Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id B80AA632465
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 10 Mar 2009 20:30:57 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 87452-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 10 Mar 2009 20:30:48 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ti-out-0910.google.com (ti-out-0910.google.com
 [209.85.142.186])
	by mail.postgresql.org (Postfix) with ESMTP id E09A563223F
	for <pgsql-admin@postgresql.org>; Tue, 10 Mar 2009 20:30:53 -0300 (ADT)
Received: by ti-out-0910.google.com with SMTP id a21so1638853tia.5
	for <pgsql-admin@postgresql.org>; Tue, 10 Mar 2009 16:30:50 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=xnNxNPGRtEm4dbGoZVrXQDObfd7BFHtyF0gbhs1inL8=;
	b=EPNS/gvf5GnTrdlr2ImhGONKQpaGg1LRvH3N7amFXAEOSk3/7E5pwoyP0UW8OS0GRZ
	hOfZ1/TYSpAoHym8i3Zm6RjzywgKSy6XOGw3LHF7uUnYhKIzwKiX6L227ZyX/Frfyroy
	roEwLPNjZg5yFIIdoTIboddImMqxjsZ/JE9AI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=IS0xP/Df/6cH61DJRSpnfvZglwmpHOaNKwZS2010XtA2v/Op9tNC6izhfXDnRuyIw6
	S1rUkvizaYB+yDJ+DHk38U1+MUuZjYz3yER5B3Px9TZioxFKAltAZ4qcsSnd19IJ9h8g
	dd2h3bWoMF6n4dh9mZZEygRmrTOxr2xpMp/yo=
MIME-Version: 1.0
Received: by 10.110.43.20 with SMTP id q20mr575059tiq.33.1236727850421; Tue,
	10 Mar 2009 16:30:50 -0700 (PDT)
In-Reply-To: <798506.30088.qm@web111308.mail.gq1.yahoo.com>
References: <798506.30088.qm@web111308.mail.gq1.yahoo.com>
Date: Wed, 11 Mar 2009 10:30:50 +1100
Message-ID: <bf54be870903101630u28d7b5b5oce4f97f532aa648f@mail.gmail.com>
Subject: Re: how to figure out how long a query takes in the pg log
	file...
From: Shoaib Mir <shoaibmir@gmail.com>
To: pgsql-admin@postgresql.org
Cc: Jessica Richard <rjessil@yahoo.com>
Content-Type: multipart/alternative; boundary=001485ec1020354e820464cc242b
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/140
X-Sequence-Number: 31640

--001485ec1020354e820464cc242b
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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/

--001485ec1020354e820464cc242b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Wed, Mar 11, 2009 at 10:24 AM, Jessica Richard <span dir=3D"ltr">&lt;<a =
href=3D"mailto:rjessil@yahoo.com">rjessil@yahoo.com</a>&gt;</span> wrote:<b=
r><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"bor=
der-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-=
left: 1ex;">
<div><div style=3D"font-family: times new roman,new york,times,serif; font-=
size: 12pt;"><div>I need to identify the slowest queries by analyzing the p=
ostgre log file.<br><br></div></div>



      </div></blockquote></div><br>I will recommend using log_min_duration =
for that purpose from postgresql.conf file. Another good project I have use=
d for such purpose in the past is pgFouine --&gt; <a href=3D"http://pgfouin=
e.projects.postgresql.org">http://pgfouine.projects.postgresql.org</a><br c=
lear=3D"all">
<br>-- <br>Shoaib Mir<br><a href=3D"http://shoaibmir.wordpress.com/">http:/=
/shoaibmir.wordpress.com/</a><br>

--001485ec1020354e820464cc242b--