MIME-Version: 1.0
References: 
 <CAJSrDUpaJC5+ZsTN1D4OUa8S7d0XBQD413XnZM2JVGjr_Z4xuA@mail.gmail.com>
In-Reply-To: 
 <CAJSrDUpaJC5+ZsTN1D4OUa8S7d0XBQD413XnZM2JVGjr_Z4xuA@mail.gmail.com>
From: kyle Hailey <kylelf@gmail.com>
Date: Fri, 7 Apr 2023 11:40:47 -0700
Message-ID: 
 <CADsdiQg-9d-eB16BadUtbTjuWFBEKecfunP90ce8vSccpsK2-g@mail.gmail.com>
Subject: Re: Is there any tool which will help me run and explain analyze
 about 150 queries?
To: kunwar singh <krishsingh.111@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003a2fa705f8c35f19"
Archived-At: 
 <https://www.postgresql.org/message-id/CADsdiQg-9d-eB16BadUtbTjuWFBEKecfunP90ce8vSccpsK2-g%40mail.gmail.com>
Precedence: bulk

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

In my opinion, Datadog is the best Postgres monitor available, but it
doesn't have a feature that has been discussed. However, you can use
auto_explain to analyze long-running queries by setting a limit. I recently
enabled it in GCP Cloud SQL, but I haven't seen any results in the logs
yet. I need to figure out which parameters to enable to get it working.


On Fri, Apr 7, 2023 at 10:57=E2=80=AFAM kunwar singh <krishsingh.111@gmail.=
com>
wrote:

> Hi Listers,
> Anyone here use such a tool for Postgres? Any recommendations?
>
> Say I have 150 queries in Postgres 11 and I want to upgrade to Postgres
> 15. I want to run explain analyze for 150 in both versions for comparativ=
e
> analysis.
>
> I am looking for the easiest way to do it with a tool :)
>
> --
> Cheers,
> Kunwar
>

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

<div dir=3D"ltr"><div><br></div><span style=3D"color:rgb(55,65,81);font-fam=
ily:S=C3=B6hne,ui-sans-serif,system-ui,-apple-system,&quot;Segoe UI&quot;,R=
oboto,Ubuntu,Cantarell,&quot;Noto Sans&quot;,sans-serif,&quot;Helvetica Neu=
e&quot;,Arial,&quot;Apple Color Emoji&quot;,&quot;Segoe UI Emoji&quot;,&quo=
t;Segoe UI Symbol&quot;,&quot;Noto Color Emoji&quot;;font-size:16px;white-s=
pace:pre-wrap;background-color:rgb(247,247,248)">In my opinion, Datadog is =
the best Postgres monitor available, but it doesn&#39;t have a feature that=
 has been discussed. However, you can use auto_explain to analyze long-runn=
ing queries by setting a limit. I recently enabled it in GCP Cloud SQL, but=
 I haven&#39;t seen any results in the logs yet. I need to figure out which=
 parameters to enable to get it working.</span><br><div><br></div><div><br>=
<div><br></div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Fri, Apr 7, 2023 at 10:57=E2=80=AFAM kunwar singh &=
lt;<a href=3D"mailto:krishsingh.111@gmail.com">krishsingh.111@gmail.com</a>=
&gt; wrote:<br></div><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">Hi Listers,<div>Anyone here use such a tool for Postgres?=C2=
=A0Any recommendations?</div><div><br></div><div>Say I have 150 queries in =
Postgres 11 and I want to upgrade to Postgres 15. I want to run explain ana=
lyze for 150 in both versions for comparative analysis.=C2=A0</div><div><br=
></div><div>I am looking for the easiest way to do it with a tool :)=C2=A0<=
font color=3D"#888888"><br></font></div><div><br></div><span>-- </span><br>=
<div dir=3D"ltr">Cheers,<br>Kunwar</div></div>
</blockquote></div>

--0000000000003a2fa705f8c35f19--