Re: Statistics information.

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt@xxxxxxxxx> wrote:

Dear All,

Apologies the way i am asking question as i am more a SQL Server person and a new postgre man..

I have used a query store in SQL server. it provides me option to load statistics data to temp table and get  below important information.

1. Last run duration

2. Average time for execution.

3. Filter statistics for a specific function(stored procedure)

4. Filter for specific texts.

5 top queries

6. query plans...

I see 1, 2, 5 & 6 via AppDynamics, after installing the pg_stat_statements extension.  Vanilla Postgresql does not retain those statistics.