Horton

Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE

Peter Eisentraut <peter@eisentraut.org>

View thread View on postgr.es
From: Peter Eisentraut <peter@eisentraut.org>
To: Robert Haas <robertmhaas@gmail.com>, Nikolay Samokhvalov <samokhvalov@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2024-11-07T06:55:24Z
Lists: pgsql-hackers 
On 05.11.24 19:19, Robert Haas wrote:
>> 1) EXPLAIN ANALYZE Is sometimes very confusing (because there is ANALYZE). Let's rename it to EXPLAIN EXECUTE?
> The trouble is that EXPLAIN EXECUTE already means something.
> 
> robert.haas=# explain execute foo;
> ERROR:  prepared statement "foo" does not exist
> 
> Granted, that would not make it impossible to make EXPLAIN (EXECUTE) a
> synonym for EXPLAIN (ANALYZE), but IMHO it would be pretty confusing
> if EXPLAIN EXECUTE and EXPLAIN (EXECUTE) did different things.

At some point in the past, the idea of renaming EXPLAIN ANALYZE to 
PROFILE was thrown around.  I still kind of like that idea.  You'd have 
to keep the existing syntax around, of course.

Commits

  1. Fix further fallout from EXPLAIN ANALYZE BUFFERS change

  2. Add missing BUFFERS OFF in regression tests, take 2

  3. Add missing BUFFERS OFF in select_into regression tests

  4. Enable BUFFERS with EXPLAIN ANALYZE by default