Postgres Pro
Downloads
Home   >   mailing lists

Re: Statistics information. - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: Statistics information.
Date
Msg-id CAOBaU_YgDX9o1N6=gVFifjika3Ck+3q01+H1qNHKnCPpnt7FvQ@mail.gmail.com
Whole thread Raw
In response to Re: Statistics information.  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 
On Sat, Mar 23, 2024 at 6:51 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
> On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt@gmail.com> wrote:
>>
>> 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
retainthose statistics. 

You can use PoWA for that (https://powa.readthedocs.io/en/latest/)

pgsql-general by date:

Previous
From: veem v
Date:
Subject: Re: Not able to purge partition
Next
From: sud
Date:
Subject: Is this a buggy behavior?