From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Alec Swan <alecswan(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Log duration and statement for slow queries + limiting the number of log files generated |
Date: | 2011-09-16 17:21:26 |
Message-ID: | 1316193687.2139.2.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2011-09-16 at 11:16 -0600, Alec Swan wrote:
> Hello,
>
> I am trying to get postgres 8.4.4 to log the duration and statement of
> queries that take longer than 200 ms. I played with the log settings
> in postgresql.conf but I still see logs of durations of very fast
> statements. Here is my current configuration:
>
> log_min_duration_statement = 200
> log_duration = on
> log_line_prefix = '<%t> '
> log_statement = 'all'
>
> With this configuration I am still getting these in the log files:
>
> <2011-09-02 14:47:19 EDT> LOG: duration: 0.017 ms
> <2011-09-02 14:47:19 EDT> LOG: execute <unnamed>: SET SESSION
> CHARACTERISTICS AS TRANSACTION READ WRITE
> <2011-09-02 14:47:19 EDT> LOG: duration: 0.004 ms
> <2011-09-02 14:47:19 EDT> LOG: duration: 0.014 ms
> <2011-09-02 14:47:19 EDT> LOG: duration: 0.017 ms
> <2011-09-02 14:47:19 EDT> LOG: execute <unnamed>: SET SESSION
> CHARACTERISTICS AS TRANSACTION READ ONLY
>
>
> How do I filter these out?
>
You should set log_duration to off, and log_statement to none.
log_min_duration_statement will take care of logging duration and
statement if the query duration is longer than 200 ms.
> Also, how do I restrict the maximum number of log files generated to 2
> with the assumption that they will roll over when filled?
>
You can't do that with PostgreSQL configuration. You need another tool,
such as logrotate.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2011-09-16 17:22:34 | Re: Log duration and statement for slow queries + limiting the number of log files generated |
Previous Message | Tom Lane | 2011-09-16 17:16:44 | Re: Log message " last_statrequest ... is later than collector's time" - what does it mean? |