Start a new topic
Discussions xDM xDM - Platform Configuration & Administration
Answered

PostgreSQL Explain Analyze Query Plan

When Should I Use Postgres Explain Analyze Query Plan?

Best Answer

You should use the Postgres Explain plan when experiencing performance issues. This is great tool to explain what steps in the database are costing the most resources. The explain analyze query provides more insightful stats and details because it evaluates the query at run-time. You can reference our knowledge base article PostgreSQL Explain Plan  on how to generate the explain plan query in your Postgres environment.

1 Comment
Answer

You should use the Postgres Explain plan when experiencing performance issues. This is great tool to explain what steps in the database are costing the most resources. The explain analyze query provides more insightful stats and details because it evaluates the query at run-time. You can reference our knowledge base article PostgreSQL Explain Plan  on how to generate the explain plan query in your Postgres environment.

Login to post a comment
More topics in xDM - Platform Configuration & Administration
See all 64 topics
Help Desk Software by Freshdesk