In response to "Johnny Edge" <je...@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/

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to