Re: pg query exec time, reports

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: "Johnny Edge" <jedge(at)visafirst(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg query exec time, reports
Date: 2009-05-08 19:22:41
Message-ID: 20090508152241.758040d1.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2009-05-08 19:52:45 Re: prepared statements and DBD::Pg
Previous Message Johnny Edge 2009-05-08 19:05:28 pg query exec time, reports