Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Sabino Mullane
Subject Re: Execution history of a single query
Date
Msg-id CAKAnmmLUNqcdt=koFQD9PBRRX5Q=8VCFXpV47oNN1fJdfkYzKQ@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
Not directly through pg_stat_statements, no. But you can:

* Use log_min_duration_statement to spy on individual runs
* Periodically copy pg_stat_statements to another table, reset the stats, and then you have some time-based buckets to play with.

Cheers,
Greg

pgsql-general by date:

Previous
From: arun chirappurath
Date:
Subject: Execution history of a single query
Next
From: Julien Rouhaud
Date:
Subject: Re: Execution history of a single query