In my opinion, Datadog is the best Postgres monitor available, but it doesn't have a feature that has been discussed. However, you can use auto_explain to analyze long-running queries by setting a limit. I recently enabled it in GCP Cloud SQL, but I haven't seen any results in the logs yet. I need to figure out which parameters to enable to get it working.
On Fri, Apr 7, 2023 at 10:57 AM kunwar singh <krishsingh....@gmail.com> wrote: > Hi Listers, > Anyone here use such a tool for Postgres? Any recommendations? > > Say I have 150 queries in Postgres 11 and I want to upgrade to Postgres > 15. I want to run explain analyze for 150 in both versions for comparative > analysis. > > I am looking for the easiest way to do it with a tool :) > > -- > Cheers, > Kunwar >
