In a previous YugabyteDB Tip, we explored how to use cbo_stat_dump to recreate production optimizer behavior in a clean environment: 👉 Recreating […]
Read More
Recreating Production Optimizer Behavior in YugabyteDB with cbo_stat_dump
TL;DR When a query plan changes in production, teams often try to copy production data into another environment to reproduce the issue. […]
Read MoreNo More ANALYZE After CREATE INDEX in YugabyteDB 2025.2
TL;DR Starting in 2025.2.0.0 (and backported to 2025.1.3.0), YugabyteDB automatically updates pg_class.reltuples for both the base table and newly created index after […]
Read MoreAudit Table Stats & Last ANALYZE in YSQL
Ever see a query plan that suddenly flips to a seq scan, or cardinality estimates that are off by 100×? Nine times […]
Read More