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

Achilleas Mantzios <a.mantzios@xxxxxxxxxxxxxxxxxxxx> · Fri, 7 Apr 2023 21:19:36 +0300



    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