Home Analyze stored procedures in PostgreSQL
 So I have a complex, almost 200 lines long stored procedure in PostgreSQL and I would like to analyze it quickly, but unfortunately the PgAdmin's built in explain analyze function does not support nested loops and it does not let me look under the hood, so I updated my postgresql.conf file with the following: auto_explain.log_analyze = true auto_explain.log_timing = true auto_explain.log_verbose = true auto_explain.log_min_duration = '0ms' auto_explain.log_nested_statements = true auto_explain.log_buffers = true  So I can see the detailed logs in my pg_log folder, but it generates almost 300 lines long result log and its not easy to analyze. Is there a better, more elegant way to do this? Maybe is there a UI tool for it on windows?