YugabyteDB’s new Query Diagnostics feature, avaiable is release 2025.1.1.1, lets you capture a rich diagnostic bundle for a particular query over a […]
Read More
Clearing pg_stat_statements Across All Nodes in YugabyteDB
When working with query performance in YugabyteDB, the pg_stat_statements extension is your best friend. It collects execution statistics for all SQL statements, […]
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 MoreHow to Prevent YugabyteDB YSQL (JDBC) from Switching a Prepared Statement to an Inefficient Plan
Prepared statements are great… until they suddenly aren’t. With the YugabyteDB JDBC Smart Driver (which inherits pgJDBC behavior), a prepared statement is […]
Read More