Guillaume Lelarge wrote:
Martin A. Brooks a écrit :
I _want_ the stats, however I _only_ want the stats for queries taking
over 5 seconds.
Well, AFAIK, you can't.
Then that would seem to entirely negate the point of having the
log_min_duration_statement option, from what
itten,
buffer hit rate = 100.00%
! Local blocks: 0 read, 0 written,
buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Am I missing something obvious?
Regards
--
Martin A. Brooks | http://www.antibodymx.net/ | Anti-spam &
Guillaume Lelarge wrote:
Martin A. Brooks a écrit :
However, in the log files, I'm seeing entries for all SQL executed, not
just that taking 5000ms or more. For example:
2008-10-14 10:15:50 BST PID:20349 DB:vhdb LOG: statement: select * from
vendors;
2008-10-14 10:15:50 BST PID:
Vladimir Rusinov wrote:
May be you have log_min_messages = debug?
Please, show full logging section.
I don't explicitly set that parameter in my config. The full config
file can be found at http://www.antibodymx.net/postgresql.conf
Thanks
--
Martin A. Brooks | http://www.antibodym
