Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg query exec time, reports

pg query exec time, reports

From
"Johnny Edge"
Date:

Hello folks,
 
I wish to log query execution time on all queries.
 
Could you please advise re the same?
 
Could you also suggest report generation tools? I.e. what queries take longest time to exec, duration of session, etc.
 
Thanks,
 
-JE

Re: pg query exec time, reports

From
Bill Moran
Date:
In response to "Johnny Edge" <jedge@visafirst.com>:
>
> I wish to log query execution time on all queries.

http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html
Specifically the log_*_statement directives.

> Could you also suggest report generation tools? I.e. what queries take longest time to exec, duration of session,
etc.

pgFouine

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/