MIME-Version: 1.0
References: <CAA23SdsOB8RSGAXHH-f1pZ76EaWNuSy2FUvmaBqVSaPJqzi1FQ@mail.gmail.com>
In-Reply-To: <CAA23SdsOB8RSGAXHH-f1pZ76EaWNuSy2FUvmaBqVSaPJqzi1FQ@mail.gmail.com>
From: Julien Rouhaud <rjuju123@gmail.com>
Date: Sat, 18 May 2024 07:05:51 +0800
Message-ID: <CAOBaU_aLzruwWTXmc43jrvquuhL10paUZKzQnMSjXOZi1wNRQg@mail.gmail.com>
Subject: Re: Execution history of a single query
To: arun chirappurath <arunsnmimt@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004f38020618ae65c1"
Archived-At: <https://www.postgresql.org/message-id/CAOBaU_aLzruwWTXmc43jrvquuhL10paUZKzQnMSjXOZi1wNRQg%40mail.gmail.com>
Precedence: bulk

--0000000000004f38020618ae65c1
Content-Type: text/plain; charset="UTF-8"

On Sat, 18 May 2024, 00:42 arun chirappurath, <arunsnmimt@gmail.com> wrote:

> Hi All,
>
> From pg_stat_statements we can get the overall execution details of
> queries.
>
> Can we get the execution details of a single queryid ?
>
> Like today it took 6 seconds,yesterday 5 and so on..just for one query.
>

you can use PoWA for that: https://powa.readthedocs.io/en/latest/

>

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

<div dir=3D"auto"><div class=3D"gmail_quote" dir=3D"auto"><div dir=3D"ltr" =
class=3D"gmail_attr">On Sat, 18 May 2024, 00:42 arun chirappurath, &lt;<a h=
ref=3D"mailto:arunsnmimt@gmail.com">arunsnmimt@gmail.com</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-l=
eft:1px #ccc solid;padding-left:1ex"><div dir=3D"auto">Hi All,<div dir=3D"a=
uto"><br></div><div dir=3D"auto">From pg_stat_statements we can get the ove=
rall execution details of queries.</div><div dir=3D"auto"><br></div><div di=
r=3D"auto">Can we get the execution details of a single queryid ?</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">Like today it took 6 seconds,yest=
erday 5 and so on..just for one query.</div></div></blockquote></div><div d=
ir=3D"auto"><br></div><div dir=3D"auto">you can use PoWA for that:=C2=A0<a =
href=3D"https://powa.readthedocs.io/en/latest/">https://powa.readthedocs.io=
/en/latest/</a></div><div class=3D"gmail_quote" dir=3D"auto"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-left:1ex">
</blockquote></div></div>

--0000000000004f38020618ae65c1--