From: Scott Whitney <scott@journyx.com>
To: Nik Tek <niktek2005@gmail.com>
To: Matheus de Oliveira <matioli.matheus@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: log_statement vs Statistics Collector (pg_stat_database,, etc)
Date: Tue, 29 Dec 2015 04:01:02 +0000
Message-ID: <b0v8bp22049ykj7xql697jud.1451361647658@email.android.com> (raw)
In-Reply-To: <CAHySzWWVrcZXNc5z6umEy5YBxo5ew4r9wOoAAyq+=NpwqeE2vw@mail.gmail.com>
References: <CAHySzWUsa2DMp8jgACMAF+J_6o6fycQx3BEf=yBbZMiQE-S-uw@mail.gmail.com>
<CAJghg4J6+d7VU4tcSK8o_LEcEFkh3LH6zSOY6Az_ghbojEOdGw@mail.gmail.com>
<CAHySzWWVrcZXNc5z6umEy5YBxo5ew4r9wOoAAyq+=NpwqeE2vw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
I am sorry. I am late to this thread. Please do not think there is zero impact.
-------- Original message --------
From: Nik Tek <niktek2005@gmail.com>
Date: 12/28/2015 6:05 PM (GMT-06:00)
To: Matheus de Oliveira <matioli.matheus@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] log_statement vs Statistics Collector (pg_stat_database,, etc)
Thank you Matheus!
Based on the study, there's very little performance impact when enabling log_min_duration_statement, right?
Thank you
Nik
On Sun, Dec 27, 2015 at 5:35 AM, Matheus de Oliveira <matioli.matheus@gmail.com<mailto:matioli.matheus@gmail.com>> wrote:
On Thu, Dec 24, 2015 at 7:32 PM, Nik Tek <niktek2005@gmail.com<mailto:niktek2005@gmail.com>> wrote:
I wanted to capture all the DML statements executed in the database information (execution time, ).
Question:
Can anyone point me pros and cons on either of the approaches.
In my testing, I haven't found any performance degrade on application operations when enabled the additional logging (below logging).
Besides log_min_duration_statement, you can use tools like pg_stat_statements [1] and POWA [2]. POWA authors even did a comparison of performance impact of having log_min_duration_statement (to latter process with pgBadger), using POWA extension and nothing, see [3].
[1] http://www.postgresql.org/docs/current/static/pgstatstatements.html
[2] http://dalibo.github.io/powa/
[3] https://github.com/dalibo/powa/wiki/POWA-vs-pgBadger
--
Matheus de Oliveira
--
Thank you
NikTeki
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
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-admin@postgresql.org
Cc: scott@journyx.com, niktek2005@gmail.com, matioli.matheus@gmail.com
Subject: Re: log_statement vs Statistics Collector (pg_stat_database,, etc)
In-Reply-To: <b0v8bp22049ykj7xql697jud.1451361647658@email.android.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