X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2EA7D528B4 for ; Wed, 18 May 2005 12:25:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57695-08 for ; Wed, 18 May 2005 15:25:21 +0000 (GMT) Received: from mail.deg.cc (mail.deg.cc [64.139.134.201]) by svr1.postgresql.org (Postfix) with ESMTP id 1ACB352868 for ; Wed, 18 May 2005 12:25:18 -0300 (ADT) Received: from deg.cc (unknown [205.242.255.66]) by mail.deg.cc (Postfix) with ESMTP id AB4CC55F89; Wed, 18 May 2005 11:25:14 -0400 (EDT) Message-ID: <428B5E5C.2020400@deg.cc> Date: Wed, 18 May 2005 11:25:16 -0400 From: Pallav Kalva User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: SQL logging (log_min_duration_statement) not working References: <428B4487.8010702@deg.cc> <21996.1116429488@sss.pgh.pa.us> In-Reply-To: <21996.1116429488@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.029 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/241 X-Sequence-Number: 17670 Tom Lane wrote: >Pallav Kalva 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 and then i ran the queries from hibernate. These are the only things which I did on the postgres side.