MIME-Version: 1.0
References: <CAB+=1TWW4DJwD0XPgud2bTJOuW0HkJ+rU11CL=mU93d4HXwfeA@mail.gmail.com>
 <CANzqJaALHY3HiyPz64g1iOaNe9aVmzUe_33KpyqZVsnHMS=P_Q@mail.gmail.com> <CAB+=1TXm-4bAQBiomkoob6RBO3R7QJo_ZzC+KiFv7rQwgtD_EQ@mail.gmail.com>
In-Reply-To: <CAB+=1TXm-4bAQBiomkoob6RBO3R7QJo_ZzC+KiFv7rQwgtD_EQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 26 Sep 2025 19:00:13 -0400
Message-ID: <CANzqJaCWEZv1VomWQh-rqYcgGobnqqF2cVEabcihBzPuXhBXFA@mail.gmail.com>
Subject: Re: Correct query for monitor
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000041bf56063fbc406b"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCWEZv1VomWQh-rqYcgGobnqqF2cVEabcihBzPuXhBXFA%40mail.gmail.com>
Precedence: bulk

--00000000000041bf56063fbc406b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Sep 26, 2025 at 4:15=E2=80=AFPM veem v <veema0000@gmail.com> wrote:

> Thank you so much for the quick response. I have a follow up question on
> this as below,
>
> If we want to identify, what exact query inside a procedure is taking a
> longer time:- Using any pg_* views, Is there an easy way to tie the
> query_id of the procedure with the query_ids of the internal sqls(those a=
re
> executed within the procedure) to quickly get the culprit sql?
>

Are there queries inside a cursor loop?


> And say , we got the sql and saw a bad plan and we want to change the pla=
n
> or attach a good plan to that query , is there a possible way to do that =
in
> postgres?
>
>>
PG does not support hints or "attaching plans to queries".

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--00000000000041bf56063fbc406b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Sep 26, 2025 at 4:15=E2=80=AFPM v=
eem v &lt;<a href=3D"mailto:veema0000@gmail.com">veema0000@gmail.com</a>&gt=
; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Thank you so much fo=
r the quick response. I have a follow up question on this as below,<div><br=
></div><div>If we want to identify, what exact query=C2=A0inside=C2=A0a pro=
cedure is taking a longer time:- Using any pg_* views, Is there an easy way=
 to tie the query_id of the procedure with the query_ids of the internal sq=
ls(those are executed within the procedure) to quickly get the culprit sql?=
</div></div></blockquote><div><br></div><div>Are there queries inside a cur=
sor loop?</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><div> And say , we got the=C2=A0sql and saw a bad p=
lan and we want to change the plan or attach a good plan to that query , is=
 there a possible way to do=C2=A0that in postgres?</div></div><div class=3D=
"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div><div><div></div></div=
></div></div></div></blockquote></div></blockquote><div>=C2=A0</div></div><=
div>PG does not support hints or &quot;attaching plans to queries&quot;.</d=
iv><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div=
 dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redact=
ed&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><d=
iv><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--00000000000041bf56063fbc406b--