Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.
Read OriginalThe article details a recent PostgreSQL 18 commit that modifies the EXPLAIN command to display fractional row counts with two decimal digits. This change addresses precision issues when estimating total rows from averaged values, especially in plans with multiple loops (nloops > 1). It discusses the rationale, the problem of unstable regression tests with variable loop counts, and the decision to always show two fractional digits for consistency and clarity in query execution plans.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser