Re: Measuring time of select query

Mariusz Wiktorczyk wrote:
> Hello!
> I have to measure the time of select query via the jdbc driver. I cannot
> do this using only java.sql interfaces :( Is there any possibility to do
> it using yours jdbc driver? Where can I find api docs to postgresql jdbc?
> Best regards
> Mariusz Wiktorczyk

I have a few solutions for you. First, in 7.3, there is the
postgresql.conf variable 'log_duration' which will return the duration
of your query:

test=> SET log_duration TO 'on';
SET
test=> SET client_min_messages TO 'log';
LOG: duration: 0.000682 sec
SET
test=> SELECT * FROM pg_language;
LOG: duration: 0.003959 sec
lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator |
lanacl
----------+---------+--------------+---------------+--------------+--------

sql | f | t | 0 | 2248 | {=U}
internal | f | f | 0 | 2246 | {=}
c | f | f | 0 | 2247 | {=}
(3 rows)

Also in 7.3, psql has \timing. I don't know of any good way to do this
in < 7.3, nor in jdbc.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073