Different execution time from psql and JDBC

From: Andreas Hartmann <andreas(at)apache(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Different execution time from psql and JDBC
Date: 2005-02-21 13:52:22
Message-ID: cvcos8$tb0$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear postgresql community,

I have a quite complex statement. When I execute it directly via
psql, the execution time is approx. 2000 ms.

When I execute it via JDBC (Apache Cocoon), the execution time
is either 600..1000 ms or approx. 10.000 ms, based on a certain
value in a table.

An interesting point is that the value has a big impact on the
JDBC execution time, but the psql execution time is not affected
at all.

Is there a way to output the query plan (like EXPLAIN ANALYZE)
in the log files? How can I trace down the problem?

Of course I can attach the query if this helps.

Thanks a lot in advance!

-- Andreas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2005-02-21 14:02:11 Re: Scalability with large numbers of tables
Previous Message Christopher Browne 2005-02-21 12:55:27 Re: Scalability with large numbers of tables