3 ms·

EXPLAIN (ANALYZE, BUFFERS) <YOUR QUERY> Take the result of this and paste it into https://explain.depesz.com/ https://explain.depesz.com/ which will make it h

EXPLAIN (ANALYZE, BUFFERS) <YOUR QUERY> Take the result of this and paste it into https://explain.depesz.com/ https://explain.depesz.com/ which will make it human readable. Understanding this is sometimes very easy, but if you want to understand what they _really_ mean, you can read depesz.com

jakebasile 5y ago
Wow, how have I never heard of this tool?! Thanks a lot for the link!
- pgaddict 5y ago
  Be careful as it actually runs the query, so if it's a DELETE/INSERT/UPDATE it'll change the data. So run it in BEGIN/ROLLBACK block.
diminish 5y ago
I use it frequently - but I wish there was a tool which went into the semantics somewhat.
- pgaddict 5y ago
  What do you mean by "went into the semantics"?
- tpetry 5y ago
  I have not tried it but PgMustard is stating that they make the query plans more explainable and hint for the problems in your query.