Conference Schedule - PGConf.EU 2012Back
Debugging complex SQL queries with writable CTEs
Date: Oct. 26, 2012
Sometimes you have a complex query using subqueries, and even using EXPLAIN output you still can't understand why the output differs from what you expected.
In this talk we show how CTE (a.k.a. WITH queries), more precisely the writable ones introduced in PostgreSQL 9.1, can provide a debugging and tracing tool.
We will provide concrete examples and try to point out pitfalls and limitations.