Re: Statistics information.

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/)