From: Shoaib Mir <shoaibmir@gmail.com>
To: pgsql-admin@postgresql.org
Cc: Jessica Richard <rjessil@yahoo.com>
Subject: Re: how to figure out how long a query takes in the pg log file...
Date: Wed, 11 Mar 2009 10:30:50 +1100
Message-ID: <bf54be870903101630u28d7b5b5oce4f97f532aa648f@mail.gmail.com> (raw)
In-Reply-To: <798506.30088.qm@web111308.mail.gq1.yahoo.com>
References: <798506.30088.qm@web111308.mail.gq1.yahoo.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: shoaibmir@gmail.com, rjessil@yahoo.com
Subject: Re: how to figure out how long a query takes in the pg log file...
In-Reply-To: <bf54be870903101630u28d7b5b5oce4f97f532aa648f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox