Postgres Pro
Downloads
Home   >   mailing lists

Re: how to figure out how long a query takes in the pg log file... - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: how to figure out how long a query takes in the pg log file...
Date
Msg-id bf54be870903101630u28d7b5b5oce4f97f532aa648f@mail.gmail.com
Whole thread Raw
In response to how to figure out how long a query takes in the pg log file...  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
Tree view
On Wed, Mar 11, 2009 at 10:24 AM, Jessica Richard <rjessil@yahoo.com> wrote:
I need to identify the slowest queries by analyzing the postgre log file.


I will recommend using log_min_duration for that purpose from postgresql.conf file. Another good project I have used for such purpose in the past is pgFouine --> http://pgfouine.projects.postgresql.org

--
Shoaib Mir
http://shoaibmir.wordpress.com/

pgsql-admin by date:

Previous
From: Jessica Richard
Date:
Subject: how to figure out how long a query takes in the pg log file...
Next
From: "Tena Sakai"
Date:
Subject: any way to convert date via libpq?