On Fri, May 23, 2008 at 2:45 PM, Sebastian Rychter
<[EMAIL PROTECTED]> wrote:
> Thanks for your response. I did that in the first place and found that both
> explain reports where quite similar. I've got both reports: From pgadmin it
> took 7288 ms, and from VFP took 6446 ms (of course, that's the
0..1.10
rows=10 width=4) (actual time=0.004..0.023 rows=10 loops=1)
-> Seq Scan on "Country" "PatientEmployerCountry"
(cost=0.00..1.02 rows=2 width=4) (actual time=0.003..0.007 rows=2 loops=1)
-> Seq Scan on "Country&quo
On Fri, May 23, 2008 at 2:07 PM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> Can it be done? Or is the DB server not capable of generating explain output
> (say to a log) and also returning a resultset?
It can be done ~kind-of~.
To me EXPLAIN [ ANALYSE ] is similar to any other SELECT statement
qu
Richard Broersma wrote:
On Fri, May 23, 2008 at 9:47 AM, Sebastian Rychter
<[EMAIL PROTECTED]> wrote:
Thanks.. All logs are already off and I'm just sending one query directly
from the application (from Visual Foxpro using SQL Pass through and in
VB.net using ado.net). I've found that the "probl
On Fri, May 23, 2008 at 9:47 AM, Sebastian Rychter
<[EMAIL PROTECTED]> wrote:
> Thanks.. All logs are already off and I'm just sending one query directly
> from the application (from Visual Foxpro using SQL Pass through and in
> VB.net using ado.net). I've found that the "problem" is that I'm using
Thanks.. All logs are already off and I'm just sending one query directly
from the application (from Visual Foxpro using SQL Pass through and in
VB.net using ado.net). I've found that the "problem" is that I'm using
implicit joins, and when I change it to explicit Inner Joins the query only
takes 3
On Thu, May 22, 2008 at 11:29 AM, Sebastian Rychter
<[EMAIL PROTECTED]> wrote:
> Hi, I'm executing a query through psql ODBC which is taking around 2 minutes
> to complete. When I run it from PgAdmin it takes less than 3 seconds.
>
> Any idea ?
1) turn off all ODBC query logging from both the ODBC
Sebastian Rychter wrote:
Hi, I'm executing a query through psql ODBC which is taking around 2 minutes
to complete. When I run it from PgAdmin it takes less than 3 seconds.
The query itself has :
. 15 inner joins (from just around 10 different tables - the other inner
joins are using different a
