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

From: Shoaib Mir <shoaibmir(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Jessica Richard <rjessil(at)yahoo(dot)com>
Subject: Re: how to figure out how long a query takes in the pg log file...
Date: 2009-03-10 23:30:50
Message-ID: bf54be870903101630u28d7b5b5oce4f97f532aa648f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Mar 11, 2009 at 10:24 AM, Jessica Richard <rjessil(at)yahoo(dot)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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2009-03-11 02:43:01 any way to convert date via libpq?
Previous Message Jessica Richard 2009-03-10 23:24:57 how to figure out how long a query takes in the pg log file...