From: David Gould <daveg@sonic.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: Kevin Bloch <kev@codingthat.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: maximum for auto_explain.log_min_duration doesn't seem to make sense
Date: Fri, 23 Feb 2018 13:36:27 -0800
Message-ID: <20180223133627.33672e01@engels> (raw)
In-Reply-To: <16575.1519413959@sss.pgh.pa.us>
References: <8ea82d7e-cb78-8e05-0629-73aa14d2a0ca@codingthat.com>
<CAKFQuwaPyFHN=cmEhOYdd2R5daZP2Wn0og9M8BEPE5k_tuQYjA@mail.gmail.com>
<16575.1519413959@sss.pgh.pa.us>
On Fri, 23 Feb 2018 14:25:59 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> INT_MAX. As to whether it's worth doing, the existing limit is equivalent
> to ~35 minutes if I did the math right. I can barely imagine that anyone
> would want to set auto_explain.log_min_duration higher than that, but
> maybe in some huge data warehouse environment it'd make sense.
> In short, seems like a valid complaint to me.
A client has several production queries that commonly run an hour or two.
Sometimes queries are modified infelicitously or the planner is lead astray
due to statistics etc and they can run much longer unexpectedly. It would be
useful to set a threshold of a few hours to catch those as reproducing them
is a slow process.
-dg
--
David Gould daveg@sonic.net
If simplicity worked, the world would be overrun with insects.
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-bugs@postgresql.org
Cc: daveg@sonic.net, tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, kev@codingthat.com, pgsql-bugs@lists.postgresql.org
Subject: Re: maximum for auto_explain.log_min_duration doesn't seem to make sense
In-Reply-To: <20180223133627.33672e01@engels>
* 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