Re: how to figure out how long a query takes in the pg log file...

[Shoaib Mir <shoaibmir@xxxxxxxxx>]

On Wed, Mar 11, 2009 at 10:24 AM, Jessica Richard <rjessil@xxxxxxxxx> 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/