Re: Explain and filter over subplans

2024-01-19 Thread Chantal Keller
Thank you very much for your quick answer and patch! I tested and this is exactly what I was looking for :-) Best Chantal Le 18/01/2024 à 18:55, Tom Lane a écrit : Chantal Keller writes: I would like "explain" to output formulas for filtering over subplans. Is i

Explain and filter over subplans

2024-01-18 Thread Chantal Keller
Hi I would like "explain" to output formulas for filtering over subplans. Is it possible? Here is a minimal example. Consider the queries: create table t(a int); explain (format xml, verbose true) select * from t where a >= all (select * from t); I put the result of the second query at the