Re: pg query exec time, reports

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/