Common questions engineers search for: ● Why is my indexed query still scanning thousands of rows? ● Why does PostgreSQL / YugabyteDB […]
Read More
Use Query Diagnostics to Investigate Real-World Queries
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 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 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 More