Different execution time from psql and JDBC

Поиск
Список
Период
Сортировка
От Andreas Hartmann
Тема Different execution time from psql and JDBC
Дата
Msg-id cvcos8$tb0$1@sea.gmane.org
обсуждение исходный текст
Ответы Re: Different execution time from psql and JDBC  (Richard Huxton <dev@archonet.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "FERREIRA William (COFRAMI)"
Дата:
Сообщение:
Следующее
От:
Дата:
Сообщение: function body error checking issues