Re: Is there any tool which will help me run and explain analyze about 150 queries?

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Is there any tool which will help me run and explain analyze about 150 queries?
Дата
Msg-id 4e61d244-2d2b-e67a-42ab-6bd523a2153c@cloud.gatewaynet.com
обсуждение исходный текст
Ответ на Is there any tool which will help me run and explain analyze about 150 queries?  (kunwar singh <krishsingh.111@gmail.com>)
Список pgsql-performance
Дерево обсуждения

Prepend "EXPLAIN ANALYZE " on every statement :

cat foo.sql  | awk '{print " EXPLAIN (ANALYZE, BUFFERS, TIMING, SUMMARY) " $0}' | psql testdb -f -

Στις 7/4/23 20:57, ο/η kunwar singh έγραψε:
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
-- 
Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

В списке pgsql-performance по дате отправления:

Предыдущее
От: kunwar singh
Дата:
Сообщение: Is there any tool which will help me run and explain analyze about 150 queries?
Следующее
От: kyle Hailey
Дата:
Сообщение: Re: Is there any tool which will help me run and explain analyze about 150 queries?