In response to "Johnny Edge" <jedge(at)visafirst(dot)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/