From: Luis Fernando Simone <luis.simone@datacoper.com.br>
To: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
Cc: ProPAAS DBA <dba@propaas.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to log quires which are taking time in PostgreSQL 9.1.
Date: Thu, 23 Feb 2017 13:59:06 -0300 (BRT)
Message-ID: <968111785.363345.1487869146964.JavaMail.root@datacoper.com.br> (raw)
In-Reply-To: <1545425403.112547.1487868383328.JavaMail.root@shaakti.datacoper.com.br>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
The parameter "log_directory" on postgresql.conf, you can define where it'll be created.
The name of the log file is defined on "log_filename".
----- Mensagem original -----
De: "Dinesh Chandra 12108" <Dinesh.Chandra@cyient.com>
Para: "ProPAAS DBA" <dba@propaas.com>, pgsql-performance@postgresql.org
Cc: "Dinesh Chandra 12108" <Dinesh.Chandra@cyient.com>
Enviadas: Quinta-feira, 23 de Fevereiro de 2017 13:44:05
Assunto: Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1.
Thanks for reply.
May I know where it will create log??
In pg_log directory or somewhere else.
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
------------------------------------------------------------------
Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com
Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of ProPAAS DBA
Sent: 23 February, 2017 10:01 PM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1.
set log_min_duration_statement = 300,000
(300,000 ms = 5min)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: luis.simone@datacoper.com.br, Dinesh.Chandra@cyient.com, dba@propaas.com
Subject: Re: How to log quires which are taking time in PostgreSQL 9.1.
In-Reply-To: <968111785.363345.1487869146964.JavaMail.root@datacoper.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox