Skip site navigation (1) Skip section navigation (2)

Re: SQL logging (log_min_duration_statement) not working

From: Pallav Kalva <pkalva(at)deg(dot)cc>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SQL logging (log_min_duration_statement) not working
Date: 2005-05-18 15:25:16
Message-ID: 428B5E5C.2020400@deg.cc (view raw or flat)
Thread:
Lists: pgsql-admin
Tom Lane wrote:

>Pallav Kalva <pkalva(at)deg(dot)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
>
>  
>
I changed the log_min_duration_statement from 60000 to 5000 and then 
ran  --> pg_ctl  reload -D <data cluster location> and then i ran the 
queries from hibernate. These are the only things which I did on the 
postgres side.


In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-05-18 15:41:15
Subject: Re: SQL logging (log_min_duration_statement) not working properly
Previous:From: Tom LaneDate: 2005-05-18 15:18:08
Subject: Re: SQL logging (log_min_duration_statement) not working properly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group