Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgwk7-0005gB-Mw for pgsql-performance@arkaria.postgresql.org; Thu, 23 Feb 2017 16:59:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cgwk7-0008M4-9Z for pgsql-performance@arkaria.postgresql.org; Thu, 23 Feb 2017 16:59:47 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cgwiQ-0005dF-CS for pgsql-performance@postgresql.org; Thu, 23 Feb 2017 16:58:02 +0000 Received: from mestre-yoda.datacoper.com.br ([177.204.154.21]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgwiN-0002wo-3P for pgsql-performance@postgresql.org; Thu, 23 Feb 2017 16:58:01 +0000 Received: from localhost (localhost [127.0.0.1]) by mestre-yoda.datacoper.com.br (Postfix) with ESMTP id E460B190EFE; Thu, 23 Feb 2017 13:59:07 -0300 (BRT) X-Virus-Scanned: amavisd-new at datacoper.com.br Received: from mestre-yoda.datacoper.com.br ([127.0.0.1]) by localhost (mestre-yoda.datacoper.com.br [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nIMab3JQ3b93; Thu, 23 Feb 2017 13:59:07 -0300 (BRT) Received: from mestre-yoda.datacoper.com.br (mestre-yoda.datacoper.com.br [10.150.51.27]) by mestre-yoda.datacoper.com.br (Postfix) with ESMTP id F2B12190EFC; Thu, 23 Feb 2017 13:59:06 -0300 (BRT) Date: Thu, 23 Feb 2017 13:59:06 -0300 (BRT) From: Luis Fernando Simone To: Dinesh Chandra 12108 Cc: ProPAAS DBA , pgsql-performance@postgresql.org Message-ID: <968111785.363345.1487869146964.JavaMail.root@datacoper.com.br> In-Reply-To: <1545425403.112547.1487868383328.JavaMail.root@shaakti.datacoper.com.br> Subject: Re: How to log quires which are taking time in PostgreSQL 9.1. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_363344_1046008761.1487869146963" X-Originating-IP: [192.168.0.100] X-Mailer: Zimbra 7.2.1_GA_2790 (ZimbraWebClient - FF3.0 (Win)/7.2.1_GA_2790) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ------=_Part_363344_1046008761.1487869146963 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable The parameter "log_directory" on postgresql.conf, you can define where it'l= l be created.=20 The name of the log file is defined on "log_filename".=20 ----- Mensagem original ----- De: "Dinesh Chandra 12108" =20 Para: "ProPAAS DBA" , pgsql-performance@postgresql.org=20 Cc: "Dinesh Chandra 12108" =20 Enviadas: Quinta-feira, 23 de Fevereiro de 2017 13:44:05=20 Assunto: Re: [PERFORM] How to log quires which are taking time in PostgreSQ= L 9.1.=20 Thanks for reply.=20 May I know where it will create log??=20 In pg_log directory or somewhere else.=20 Regards,=20 Dinesh Chandra=20 |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.=20 ------------------------------------------------------------------=20 Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com=20 Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.=20 From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owne= r@postgresql.org] On Behalf Of ProPAAS DBA=20 Sent: 23 February, 2017 10:01 PM=20 To: pgsql-performance@postgresql.org=20 Subject: Re: [PERFORM] How to log quires which are taking time in PostgreSQ= L 9.1.=20 set log_min_duration_statement =3D 300,000=20 (300,000 ms =3D 5min)=20