| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
| Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Christofides <michael(at)pgmustard(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE |
| Date: | 2024-11-20 01:10:06 |
| Message-ID: | CAApHDvov847_KpLwV6f3PPKq5QzNrk9uFbGa9W4--Fd72G84=w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 20 Nov 2024 at 13:13, Greg Sabino Mullane <htamfids(at)gmail(dot)com> wrote:
>> It defaults to <literal>TRUE</literal> when <literal>ANALYZE</literal> is also enabled. Otherwise, it defaults to <literal>FALSE</literal>.
>
> Is that second sentence really needed? Because "BUFFERS ON" will never be needed anymore (save as a no-op to allow the same explain queries to run cross-version), and BUFFERS OFF outside of analyze is meaningless.
"BUFFERS ON" will be needed if the user wants to see the buffer usage
in the planner when ANALYZE isn't specified. You'll see the planner
access buffers when the caches are not fully populated and for
get_actual_variable_range() work.
Maybe the wording could just be based on the wording for the SUMMARY
option, i.e. "Summary information is included by default when ANALYZE
is used but otherwise is not included by default".
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2024-11-20 01:28:32 | Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation |
| Previous Message | Greg Sabino Mullane | 2024-11-20 00:47:58 | Re: [PATCH] Add support for displaying database service in psql prompt |