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
How 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 MoreTaming Prepared Statement Re‑Planning with plan_cache_mode in YugabyteDB
Have you ever noticed a prepared statement in PostgreSQL (or YugabyteDB YSQL) that runs quickly at first but then, after a handful […]
Read MoreUse EXPLAIN (SETTINGS) to See Which GUCs Shaped Your Query Plan
As of YugabyteDB 2025.1, you can now use the PostgreSQL feature EXPLAIN (SETTINGS) to see which planner-related GUCs (configuration settings) were non-default […]
Read More