public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrei Lepikhov <[email protected]>
To: Robert Haas <[email protected]>
Cc: torikoshia <[email protected]>
Cc: Lukas Fittl <[email protected]>
Cc: [email protected]
Cc: Atsushi Torikoshi <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: RFC: Logging plan of the running query
Date: Thu, 25 Jun 2026 12:33:14 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+TgmoZQCVNqR9JnzTPEKAr85Q91L9odhmqGEZuJ6x4V5FJ-ig@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CA+TgmoaFp8JN2=7UFhsy0L-8NJ_MJX+HVHbmq2U2++9Em9JTnw@mail.gmail.com>
<[email protected]>
<CA+TgmobrSqf-PS7sgLAkAET1c8Nv7DON8VhbxjSUEL36G1mfxg@mail.gmail.com>
<[email protected]>
<CA+TgmoYJkk9+pMZSZyBi49Tbap7LSXf0An0boVaopDdNUhdzRQ@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<CAP53Pkw8CX0RQY474McHyc1N8p331-asEBAEGu0X+bJX-VB8jg@mail.gmail.com>
<[email protected]>
<CA+TgmobUqXfn9Y40Oc0PKn7yeG62v8gwAekr=HUQjcW3OPAk5Q@mail.gmail.com>
<[email protected]>
<[email protected]>
<CA+TgmoZQCVNqR9JnzTPEKAr85Q91L9odhmqGEZuJ6x4V5FJ-ig@mail.gmail.com>
On 25/06/2026 11:43, Robert Haas wrote:
> On Wed, Jun 24, 2026 at 10:35 AM Andrei Lepikhov <[email protected]> wrote:
>> 1. pg_log_query_plan - This function just sends a signal. There are no
>> guarantees that actual action will be performed. So, the 'request' word makes
>> more sense for me.
>
> I don't agree with this particular comment. Of course nothing is
> absolutely guaranteed because the database system could crash or the
> world could end, but if the target backend is running a query, it
> should log the query plan. Therefore, I don't see the need for a word
> like "request".
>
Ok, so just mention this behaviour in the documentation - let people know that
they should potentially wait for a minute or two more to see the EXPLAIN.
Real-life with huge queries and big machines provide us with examples where a
backend might delay a response to a signal for quite a substantial time.
Sometimes nothing happens after such an async operation, and we need to identify
the problem: has the backend stalled, is the ‘logging plan’ algorithm
ineffective, or is something else happening?
--
regards, Andrei Lepikhov,
pgEdge
view thread (127+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: RFC: Logging plan of the running query
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox