Re: SQL logging (log_min_duration_statement) not working properly - Mailing list pgsql-admin

From Tom Lane
Subject Re: SQL logging (log_min_duration_statement) not working properly
Date
Msg-id 21996.1116429488@sss.pgh.pa.us
Whole thread Raw
In response to SQL logging (log_min_duration_statement) not working properly  (Pallav Kalva <pkalva@deg.cc>)
Responses Re: SQL logging (log_min_duration_statement) not working  (Pallav Kalva <pkalva@deg.cc>)
List pgsql-admin
Pallav Kalva <pkalva@deg.cc> writes:
>     I am having problems with logging long running SQL in the log file.
> I have set log_min_duration_statement = 5000 (5secs) and it is not
> logging sql statements that took over 5 secs and this is only from
> queries generated by Hibernate .

Did you set log_min_duration_statement in a way that would actually
affect Hibernate (ie, change postgresql.conf and sighup the postmaster)?

            regards, tom lane

pgsql-admin by date:

Previous
From: Pallav Kalva
Date:
Subject: Re: SQL logging (log_min_duration_statement) not working
Next
From: Pallav Kalva
Date:
Subject: Re: SQL logging (log_min_duration_statement) not working