Re: investigating slow queries through - Mailing list pgsql-performance

From Jacques Caron
Subject Re: investigating slow queries through
Date
Msg-id 6.2.0.14.0.20050620204307.039e9e78@pop.interactivemediafactory.net
Whole thread Raw
In response to investigating slow queries through pg_stat_activity  (Dan Harris <fbsd@drivefaster.net>)
List pgsql-performance
Hi,

At 19:55 20/06/2005, Dan Harris 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.

You can log just those queries that take "a little bit too much time". See
log_min_duration_statement in postgresql.conf. Set it really high, and
you'll only get those queries you're after.

Jacques.



pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: investigating slow queries through pg_stat_activity
Next
From: Tom Lane
Date:
Subject: Re: investigating slow queries through pg_stat_activity