| From: | Michael Christofides <michael(at)pgmustard(dot)com> |
|---|---|
| To: | kunwar singh <krishsingh(dot)111(at)gmail(dot)com> |
| Cc: | kyle Hailey <kylelf(at)gmail(dot)com>, Jerry Sievers <gsievers19(at)comcast(dot)net>, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Is there any tool which will help me run and explain analyze about 150 queries? |
| Date: | 2023-04-12 09:17:30 |
| Message-ID: | CAFwT4nBiiRW2iKzEiDvaczXM2twYA5GEwVU+9Hg=Jd+cEzdsaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> > 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 :)
>>>
>>
I hadn't considered using it for this, and it's not free, but our pgMustard
scoring API[1] might make your comparative analysis easier.
If you send plans to it (in JSON format), you'll get back summary info like
total time and total buffers, as well as scored tips. You can then compare
the summary info, tips, and scores to find those with the biggest
differences, and some starting points for what the issue(s) may be.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | milist ujang | 2023-04-15 10:41:16 | Re: Replication lag due to lagging restart_lsn |
| Previous Message | milist ujang | 2023-04-11 03:39:38 | Re: Replication lag due to lagging restart_lsn |