← Graph

EXPLAIN cost units meaning

question 2 connections

Audience question: EXPLAIN's cost numbers are hard to interpret — is 100 high? Answer: they're effectively 'story points'. Postgres has configurable per-operation base costs (in postgres.conf) and just sums them for each part of the plan; defaults come from various use cases but can be tuned (e.g. increase sequential-scan cost on slow disks) to change the planner's choices.

answer_summary
Costs are unitless 'story points' — configurable in postgres.conf. Planner sums per-operation base costs. Tune them if your hardware profile differs from defaults.
question EXPLAIN cost units meaning
about
Question about how to interpret EXPLAIN cost numbers.
question EXPLAIN cost units meaning
asked_at
Asked during the Q&A.

Provenance