Re: RFC: Logging plan of the running query

From: Étienne BERSAC <etienne(dot)bersac(at)dalibo(dot)com>
To: torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, jtc331(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: RFC: Logging plan of the running query
Date: 2023-10-24 07:12:46
Message-ID: 9c36599db62ef7466a297843fe812fc60e827cd2.camel@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Hi,
>
> Yeah, and when we have a situation where we want to run
> pg_log_query_plan(), we can run it in any environment as long as it
> is bundled with the core.

Is it possible to get the plan of a backend programmatically without
access to the logs?

Something like pg_get_query_plan(pid, format) which output would be the
same as EXPLAIN.

Regards,
Étienne BERSAC
Dalibo

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2023-10-24 07:32:04 Re: Synchronizing slots from primary to standby
Previous Message Laurenz Albe 2023-10-24 06:34:42 Re: Fix output of zero privileges in psql