Schedule - PGConf.EU 2012

Debugging complex SQL queries with writable CTEs

Date: 2012-10-26
Time: 11:50–12:40
Room: Thames
Level: Beginner

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.


Gianni Ciolli

Platinum Sponsors

2ndQuadrant EnterpriseDB

Gold Sponsors

VMWare Cybertec Servoy

Silver Sponsors

Heroku Dalibo GoodData pgPower

Related Conferences

Postgres Open 2012