Re: postgres seems to ignore log_min_duration_statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 







On Tue, Oct 14, 2008 at 1:23 PM, Martin A. Brooks <martin@xxxxxxxxxxxxxx> wrote:
Hi

I want to have postgres log sql statements that take longer than 5 seconds to execute.  In postgresql.conf I have set log_min_duration_statement as follows:

root@martin-desktop:/etc/postgresql/8.3/main# grep log_min_duration postgresql.conf
log_min_duration_statement = 5000       # -1 is disabled, 0 logs all statements


May be you have log_min_messages = debug?
Please, show full logging section.


--
Vladimir Rusinov
http://greenmice.info/

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux