DEBUGGING INCONSISTENT QUERY LATENCY ON A POSTGRESQL HYPERTABLE: WHAT WE LEARNED

Summary from the TLDR Data newsletter

A PostgreSQL hypertable query was fast by hand but intermittently stalled because JDBC prepared statements switched to generic plans. Without parameter values, the planner could not exclude old chunks and spent seconds planning instead of executing. Logging the bind phase exposed the fault, while disabling server-side prepared statements and reducing chunk count restored predictable latency.