Postgres Pro
Downloads
Home   >   mailing lists

Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE - Mailing list pgsql-hackers

From Guillaume Lelarge
Subject Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Date
Msg-id CAECtzeUKbyZNuFRu4DTr_3p44egDXGbPpGonixqJninWXyBvnQ@mail.gmail.com
Whole thread Raw
In response to Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE  (Michael Christofides <michael@pgmustard.com>)
Responses Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
List pgsql-hackers
Tree view
Hi,

Le mer. 6 nov. 2024 à 17:57, Michael Christofides <michael@pgmustard.com> a écrit :
[...]
I agree. In the past 6 versions, 5 new parameters have been added. 
SETTINGS in v12, WAL in v13, GENERIC_PLAN in v16, SERIALIZE in 
v17, and MEMORY in v17. It feels like we should have some easier way 
to get everything. Currently, we need to specify: EXPLAIN (ANALYZE, 
VERBOSE, BUFFERS, SETTINGS, WAL, SERIALIZE, MEMORY).


Agreed. Having an "EXPLAIN (ALL)" would be a great addition. I could tell a customer to do an "EXPLAIN (ALL)", rather than first asking the PostgreSQL release installed on the server and after that, giving the correct options for EXPLAIN.


--
Guillaume.

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4
Next
From: Michel Pelletier
Date:
Subject: Re: Using Expanded Objects other than Arrays from plpgsql