X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C4DC8528CB
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 20 Jun 2005 17:30:51 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 42483-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 20 Jun 2005 20:30:47 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202])
	by svr1.postgresql.org (Postfix) with ESMTP id D487D528AA
	for <pgsql-performance@postgresql.org>;
	Mon, 20 Jun 2005 17:30:45 -0300 (ADT)
Received: by wproxy.gmail.com with SMTP id 69so893738wra
	for <pgsql-performance@postgresql.org>;
	Mon, 20 Jun 2005 13:30:47 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=tSoACs/pv6rgd0V+nEcvavJgyBrSHQP9dGD/DG6jgCVScVQ5Y5lkZC/RxqiFZ0192LhWs3Xyxq84m5c2LoHeqjuJOBj7KvinqLh/DxInr6YCezwGlfC83Y/zBrDJ25/DaUp6+Ev1mLxR2HT6QLbraiqgjCXWfKW9KQLKlYnDHt4=
Received: by 10.54.145.8 with SMTP id s8mr1175766wrd;
	Mon, 20 Jun 2005 13:30:40 -0700 (PDT)
Received: by 10.54.96.18 with HTTP; Mon, 20 Jun 2005 13:30:38 -0700 (PDT)
Message-ID: <6744b38505062013302b4f1864@mail.gmail.com>
Date: Mon, 20 Jun 2005 15:30:38 -0500
From: George Essig <george.essig@gmail.com>
Reply-To: George Essig <george.essig@gmail.com>
To: Dan Harris <fbsd@drivefaster.net>
Subject: Re: investigating slow queries through pg_stat_activity
Cc: pgsql-performance@postgresql.org
In-Reply-To: <0B5C29FA-E949-447E-AEFE-A806E238F1C2@drivefaster.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <0B5C29FA-E949-447E-AEFE-A806E238F1C2@drivefaster.net>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.072 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP
X-Spam-Level: 
X-Archive-Number: 200506/373
X-Sequence-Number: 13010

On 6/20/05, Dan Harris <fbsd@drivefaster.net> wrote:
> Also, I'm sure some people will respond with "turn on query
> logging".. I've explored that option and the formatting of the log
> file and the fact that EVERY query is logged is not what I'm after
> for this project. =20

You don't have to log every query.  You can set
log_min_duration_statement in postgresql.conf to log only the queries
that exceed a certain amount of time.