Re: Logging seq scans

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Logging seq scans
Date: 2006-03-07 11:11:28
Message-ID: 20060307111128.GA24025@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ===

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-03-07 11:13:59 Re: REPOST: How to determine the table a query or a views columns come from?
Previous Message chris smith 2006-03-07 11:09:17 Re: Question about index usage