I am curious about the information like
- total optimization time
- the time spent on each stage of optimization
- the number of alternative plans and
- the cost of each alternative plan.
Postgresql – How to get the information of the optimizer of PostgreSQL
optimizationpostgresql
Related Question
- Sql-server – ny way to prevent the memo structure from being pruned
- Postgresql – Problem with PostgreSQL and the geqo optimizer
- SQL Server 2014 – SET Options Affecting Plan Reuse and How to Get Their Values
- Sql-server – SQL Server Query Optimizer Time Spent and Numbers
- Mysql – Optimizer choose incorrect index for query according to rows number in thesql 5.6
- MongoDB Optimization – How Does the Query Optimizer Evaluate Candidate Plans?
- SQL Server – How to See Candidate Execution Plans Generated by Query Optimizer
- Postgresql – How long does query optimisation take relative to the execution time
Best Answer
You can get some of that information by turning on the configuration parameter
log_planner_stats. Most of that information, however, doesn't really exist, because the planner does not fully compute all alternative plans and their costs. It only explores an alternative plan until it can determine that it is slower than the current best plan. So alternative plans are not fully materialized.