Re: [GENERAL] pg query exec time, reports

2009-05-08 Thread Bill Moran
In response to "Johnny Edge" : > > 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 e

[GENERAL] pg query exec time, reports

2009-05-08 Thread Johnny Edge
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