From: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
To: ProPAAS DBA <dba@propaas.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
Subject: Re: How to log quires which are taking time in PostgreSQL 9.1.
Date: Thu, 23 Feb 2017 16:44:05 +0000
Message-ID: <848350bdc9bf440e9e7469601075dc69@cyient.com> (raw)
In-Reply-To: <691c4080-ab82-599c-0da4-8e1549349572@propaas.com>
References: <f75bc56eb9784a0eadc6c8ed81bf27db@cyient.com>
<691c4080-ab82-599c-0da4-8e1549349572@propaas.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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<mailto:%7Cdinesh.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: Dinesh.Chandra@cyient.com, dba@propaas.com
Subject: Re: How to log quires which are taking time in PostgreSQL 9.1.
In-Reply-To: <848350bdc9bf440e9e7469601075dc69@cyient.com>
* 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