Search Postgresql Archives

Re: log_min_duration_statement oddity

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

 



Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes:
> I wonder if I understood correctly what log_min_duration_statement
> does... I set it to 2000, and the result is that all queries running
> more than 2 seconds on _local_ connections are logged, but long running
> queries on remote connections are not logged.

I can't reproduce that.  Sure you've diagnosed the problem correctly?
It seems highly unlikely that the source of the connection would have
anything to do with it.  User or database could (eg, perhaps there's
a user-specific setting of log_min_duration_statement).

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux