| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Statistics information. |
| Date: | 2024-03-23 10:51:30 |
| Message-ID: | CANzqJaAP-Y0wc3zVBdeKMKemHMBCU+pc+awuYmo_OggW3iAtSA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | veem v | 2024-03-23 17:11:38 | Re: Not able to purge partition |
| Previous Message | Matthias Apitz | 2024-03-23 09:40:54 | Re: soft lockup - CPU#16 stuck for 3124s! [postmaster:2273] |