Thanks Kyle. I am also trying to get it working :). @Archilleas ,Thanks for your inputs. Appreciate it. I am further interested in learning if we can automate the generation/creation of foo.sql by including queries with bind variables defined and bind values populated ( speaking in Oracle linguistics , pardon my Postgres ignorance, a newbie here)
On Fri, Apr 7, 2023 at 2:41 PM kyle Hailey <kyl...@gmail.com> wrote: > > 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 >> > -- Cheers, Kunwar
