Re: Logging seq scans

am  07.03.2006, um 11:59:18 +0100 mailte Guido Neitzer folgendes:
> 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"?

Yes, of cource. You can define

log_min_duration_statement = 100

to log all queries taking longer 100 ms.


Btw.: visit our new PostgreSQL User Group Deutschland - Homepage:
http://pgug.de



HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===