Postgres Pro
Downloads
Home   >   mailing lists

Re: pg query exec time, reports - Mailing list pgsql-general

From Bill Moran
Subject Re: pg query exec time, reports
Date
Msg-id 20090508152241.758040d1.wmoran@potentialtech.com
Whole thread Raw
In response to pg query exec time, reports  ("Johnny Edge" <jedge@visafirst.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: "Johnny Edge"
Date:
Subject: pg query exec time, reports
Next
From: "Daniel Verite"
Date:
Subject: Re: prepared statements and DBD::Pg