Re: Execution history of a single query

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: arun chirappurath <arunsnmimt(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Execution history of a single query
Date: 2024-05-17 23:05:51
Message-ID: CAOBaU_aLzruwWTXmc43jrvquuhL10paUZKzQnMSjXOZi1wNRQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 18 May 2024, 00:42 arun chirappurath, <arunsnmimt(at)gmail(dot)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/

>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-05-18 12:52:34 Left join syntax error
Previous Message Greg Sabino Mullane 2024-05-17 17:23:09 Re: Execution history of a single query