On Sun, Aug 18, 2019 at 1:57 AM Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> wrote: > > Hey, > I upgraded my pg9.6 cluster to pg11.2. > As it seems after the upgrade the duration of the same flow in my application raised from 13 minutes to 19 minutes. > > The test I did : > 1.reset pg_stat_statements > 2.run the applicative flow > 3.collect everything from pg_stat_statements > > I did this test on the env before the upgrade and after the upgrade. I took the sum of the total_time in pg_stat_statements and sumed it up. Since you have performance data, do you see any trends? For example, is it generalized performance issues or are there specific queries that have degraded? We would need more specific detail before being able to give better advice on how to fix performance issue. merlin
