title: Analyze stored procedures in PostgreSQL
body: <p>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 <code>postgresql.conf</code> file with the following:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>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.</p>
  
  <p>Is there a better, more elegant way to do this? Maybe is there a UI tool for it on windows? </p>