Nikolay Samokhvalov <samokhvalov@gmail.com> writes: > 1) EXPLAIN ANALYZE Is sometimes very confusing (because there is ANALYZE). > Let's rename it to EXPLAIN EXECUTE?
This has got far too many years of history to be renamed now.
This is a really, really strange argument. Postgres keeps receiving new audiences at larger and larger scale. And they are confused.
It's better late than never. I didn't believe we would have "quit" working in psql.
> 2) VERBOSE doesn't include BUFFERS, and doesn't include SETTINGS; it might > be also confusing sometimes. Let's include them so VERBOSE would be really > verbose?
This is not likely to fly for compatibility reasons.
Can you elaborate?
> 3) small thing about grammar: allow omitting parentheses, so EXPLAIN > EXECUTE VERBOSE would work.
The reason for the parens is that the other way would require reserving all these options as keywords.
turns out, EXPLAIN ANALYZE VERBOSE already working (it's just not as verbose as one might expect_:
test=# explain analyze verbose select; QUERY PLAN ------------------------------------------ Result (cost=0.00..0.01 rows=1 width=0)
