Re: Logging seq scans

[Richard Huxton <dev@xxxxxxxxxxxx>]

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