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
Use VmHWM to Catch “Memory-Heavy” YSQL Backends (and Help Prevent OOMs)
TL;DR A previous YugabyteDB tip, Measure Total Postgres Backend Usage, showed how to measure total current backend memory usage using PSS (Proportional […]
Read MoreUsing new DocDB metrics in pg_stat_statements to tune YSQL workloads
YugabyteDB 2025.2 introduces a powerful set of DocDB-aware columns in pg_stat_statements. These metrics finally let you answer a long-standing question: “What is […]
Read MoreForce YugabyteDB to Honor Your SQL Join Order
Modern SQL optimizers are incredibly smart. Most of the time, they’re far better at choosing an efficient execution plan than any human. […]
Read More