Postgres Pro
Downloads
Home   >   mailing lists

Re: Statistics information. - Mailing list pgsql-general

From Ron Johnson
Subject Re: Statistics information.
Date
Msg-id CANzqJaAP-Y0wc3zVBdeKMKemHMBCU+pc+awuYmo_OggW3iAtSA@mail.gmail.com
Whole thread Raw
In response to Statistics information.  (arun chirappurath <arunsnmimt@gmail.com>)
Responses Re: Statistics information.  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general
Tree view
On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt@gmail.com> 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. 

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: soft lockup - CPU#16 stuck for 3124s! [postmaster:2273]
Next
From: veem v
Date:
Subject: Re: Not able to purge partition