Tom van Tilburg <tom.van.tilburg@xxxxxxxxx> writes: > Problem is that the query is not slow, it just stalls and never finishes ( > I waited several hours for a 2 seconds query). Would it still be possible > to derive an EXPLAIN ANALYZE from it in that case? No, not really, but it'd be sufficient to compare EXPLAIN (without ANALYZE) output for the slow and fast cases. What I'm wondering about is whether the shape of the plan changes. regards, tom lane