Postgres Pro
Downloads
Home   >   mailing lists

Re: Execution history of a single query - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: Execution history of a single query
Date
Msg-id CAOBaU_aLzruwWTXmc43jrvquuhL10paUZKzQnMSjXOZi1wNRQg@mail.gmail.com
Whole thread Raw
In response to Execution history of a single query  (arun chirappurath <arunsnmimt@gmail.com>)
List pgsql-general
Tree view
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/

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Execution history of a single query
Next
From: Rich Shepard
Date:
Subject: Left join syntax error