On Sat, Mar 23, 2024 at 6:51 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote: > > On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt@xxxxxxxxx> 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 retain those statistics. You can use PoWA for that (https://powa.readthedocs.io/en/latest/)
