Re: Logging seq scans - Mailing list pgsql-general

From Richard Huxton
Subject Re: Logging seq scans
Date
Msg-id 440D9402.8020209@archonet.com
Whole thread Raw
In response to Logging seq scans  (Guido Neitzer <guido.neitzer@pharmaline.de>)
List pgsql-general
Guido Neitzer wrote:
> Hi.
>
> Is there a way to set up logging in a way that I can see queries which
> trigger seq scans? Or to log queries "taking longer than xx ms"?

The second is straightforward. See the "log_min_duration_statement"
setting in the "logging" section of the manuals.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Russ Brown
Date:
Subject: Re: Benchmark-Comparison PostGreSQL vs. SQL Server
Next
From: Kenneth Downs
Date:
Subject: per-statement, after, what's new?