From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Use case for enabling log_duration other than benchmarking
Date: Tue, 10 Jan 2023 10:28:29 -0600
Message-ID: <d24e32ff-e020-a042-ae53-8a98d9b24e79@gmail.com> (raw)
In-Reply-To: <CAM=sWa4x+_yzXEY_g-p+rXg3LQnrrSfmiu4OTmpsx_KgL=pkGA@mail.gmail.com>
References: <CAM=sWa5kArsJrPXOMVDx9137YjJGsaUXF1c1aBt-Lqk2uXt-+Q@mail.gmail.com>
<ea71e4b5-bb1c-00ea-4376-b87e3327de58@gmail.com>
<CAM=sWa4x+_yzXEY_g-p+rXg3LQnrrSfmiu4OTmpsx_KgL=pkGA@mail.gmail.com>
On 1/10/23 09:57, Alicja Kucharczyk wrote:
> wt., 10 sty 2023 o 14:57 Ron <ronljohnsonjr@gmail.com> napisał(a):
>
> On 1/10/23 07:14, Alicja Kucharczyk wrote:
>> Do you know any use case for enabling log_duration? Like 3rd party
>> tools for instance.
>> I find this parameter pretty much useless (in opposite to
>> log_min_duration_statement) as it does not show the query text, so
>> besides having just the timing logged it is of no use in
>> troubleshooting and often causes huge overhead. Am I missing something?
>
> https://www.postgresql.org/docs/current/runtime-config-logging.html
>
>
> Note
>
> The difference between enabling|log_duration|and
> settinglog_min_duration_statement
> <https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-MIN-DURATION-STATEMENT&g...
> zero is that exceeding|log_min_duration_statement|forces the text of
> the query to be logged, but this option doesn't. Thus,
> if|log_duration|is|on|and|log_min_duration_statement|has a positive
> value, all durations are logged but the query text is included only
> for statements exceeding the threshold. *This behavior can be useful
> for gathering statistics in high-load installations.*
>
>
> thank you Ron.
> My question is a bit more practical - Does anyone really find it useful?
> What value brings the info that 20% of my query are under 1ms and 10% over
> 1 minute
If your application /*requires*/ subsecond response, and you're only getting
subsecond response some of the time, then you obviously want to know why.
Part of that is checking to see if the database and queries are doing their job.
> - If just checked once and then turned off - I can understand to have more
> visibility into the overall characteristics. But let say someone have it
> enabled on a production system all the time - what could be the reason for
> that?
--
Born in Arizona, moved to Babylonia.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ronljohnsonjr@gmail.com
Subject: Re: Use case for enabling log_duration other than benchmarking
In-Reply-To: <d24e32ff-e020-a042-ae53-8a98d9b24e79@gmail.com>
References: <CAM=sWa5kArsJrPXOMVDx9137YjJGsaUXF1c1aBt-Lqk2uXt-+Q@mail.gmail.com> <ea71e4b5-bb1c-00ea-4376-b87e3327de58@gmail.com> <CAM=sWa4x+_yzXEY_g-p+rXg3LQnrrSfmiu4OTmpsx_KgL=pkGA@mail.gmail.com> <d24e32ff-e020-a042-ae53-8a98d9b24e79@gmail.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