On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnm...@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.
