Home Analyze stored procedures in PostgreSQL
Reply: 0

Analyze stored procedures in PostgreSQL

user814
1#
user814 Published in April 26, 2018, 1:44 pm

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?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.444085 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO