Re: Execution history of a single query

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: arun chirappurath <arunsnmimt(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Execution history of a single query
Date: 2024-05-17 17:23:09
Message-ID: CAKAnmmLUNqcdt=koFQD9PBRRX5Q=8VCFXpV47oNN1fJdfkYzKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2024-05-17 23:05:51 Re: Execution history of a single query
Previous Message arun chirappurath 2024-05-17 16:42:14 Execution history of a single query