Message-ID: <7bc1cc1bcc3289e9354ebb00ac1c8440c01b736c.camel@dalibo.com>
Subject: Re: RFC: Logging plan of the running query
From: =?ISO-8859-1?Q?=C9tienne?= BERSAC <etienne.bersac@dalibo.com>
To: torikoshia <torikoshia@oss.nttdata.com>
Cc: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Andres Freund
	 <andres@anarazel.de>, jtc331@gmail.com, pgsql-hackers@lists.postgresql.org
Date: Fri, 27 Oct 2023 09:06:31 +0200
In-Reply-To: <66d29d2c10ca9181c7e183eeeb4525f8@oss.nttdata.com>
References: <af8b4c4752dcee3ca7284e7c15922d5d@oss.nttdata.com>
	 <CAAaqYe9TPyWe9yoOm5Jz_39gSnhCAYXozc698jkyegM1x74Qjg@mail.gmail.com>
	 <CAAaqYe9Mse7JC78DgT97sXoB6U+E5OL3zJAYRSsgy-TPP9PXmw@mail.gmail.com>
	 <4e1e4e5d022964953e84468fe4e511b0@oss.nttdata.com>
	 <CAAaqYe_5p_MkBCgSYX=S7G3ZKi=2=_6bZQFzTgVYyv=1NRikpw@mail.gmail.com>
	 <4af7712833d4ce989cf5e658106e42da@oss.nttdata.com>
	 <CAAaqYe_hyWLs-ObFQfu54yA-ZOjNCd-L_Z=1TnYjYNqrLuGiXQ@mail.gmail.com>
	 <cbe6eb783affb3e9b5068f5cf019ee62@oss.nttdata.com>
	 <CAAaqYe_p-849MtsVgN9_y-YL-uFzLFMpGw38T3Omb11gw-=K1w@mail.gmail.com>
	 <7ab57ab0ba3416e2dbf54927752bc310@oss.nttdata.com>
	 <20231006155850.kjjb2vwbkawj7moq@alap3.anarazel.de>
	 <0e0e7ca08dff077a625c27a5e0c2ef0a@oss.nttdata.com>
	 <CAExHW5ujL=mzbjxf6xtyU-Ft6LMBMEmt8H4ZSDiiZre0Fef0jg@mail.gmail.com>
	 <2d6d7846b6b794c0e727c431852a113c@oss.nttdata.com>
	 <CAExHW5s+T0Ds-h85y92MsryLqup8fuAT8bovgGGaNnLt=OrQOg@mail.gmail.com>
	 <0eb66e8c72f23695957466db5c76c69c@oss.nttdata.com>
	 <9c36599db62ef7466a297843fe812fc60e827cd2.camel@dalibo.com>
	 <66d29d2c10ca9181c7e183eeeb4525f8@oss.nttdata.com>
Organization: DALIBO
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.46.4-2 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/7bc1cc1bcc3289e9354ebb00ac1c8440c01b736c.camel%40dalibo.com>
Precedence: bulk


Hi Torikoshia,

> If so, we once tried to implement such function for getting memory=20
> contexts.
> However, this attempt didn't succeed because it could lead dead lock=20
> situation[1].

Thanks for the pointer. Why not use client log message to allow client
to get plan without locking backend memory context and without access
to server log ? I missed the rationnal for not sending the plan to
client.

Regards,
=C3=89tienne