Tom, I did not follow the thread very close, so I need to look what the ambiguity is there, however I would love to see window rescans in explain analyze.
I have great experience in tuning Oracle queries. There are features in PostgreSQL's explain analyze that I miss badly in Oracle: 'rows removed by filter' is my favourite one. Improving explain analyze is great for performance analysis. I would say target audience for 'explain analyze' is not all the users, but someone closer to 'performance engineers'. Those beings are used to triple-check results and build/validate hypothesis since all the counters tend to lie, so 'a bit misleading counter' is not a showstopper. I did not think of 'non-being-able-to-use-negative-transition-since-floats-do-not-commute' before. Thanks to this discussion I see what kind of dragons live here. I would vote (if I had any vote at all) for the inclusion of performance statistics to explain analyze (e.g. number of rescans and number of rows fed to aggregate) provided performance impact is tolerable in both regular and explain analyze mode. I wonder how Oracle handles negative transition (does it?), however that is a different discussion. Regards, Vladimir Sitnikov
