On 16 September 2011 18:16, Alec Swan <alecswan@xxxxxxxxx> 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 have log_statement set to 'all', and since it's mostly independent of log_min_duration_statement, it's logging everything anyway. You may wish to just set log_statement to 'none'. > Also, how do I restrict the maximum number of log files generated to 2 > with the assumption that they will roll over when filled? -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
