On Tue, Feb 6, 2024 at 3:51 AM Justin Pryzby <pry...@telsasoft.com> wrote: > > Up to now, the explain " " (two space) format is not mixed with "=". > > And, other places which show "Memory" do not use "=". David will > remember prior discussions. > https://www.postgresql.org/message-id/20200402054120.gc14...@telsasoft.com > https://www.postgresql.org/message-id/20200407042521.gh2...@telsasoft.com > > "Memory: used=%lld bytes > allocated=%lld bytes", > vs > "Buckets: %d (originally %d) > Batches: %d (originally %d) Memory Usage: %ldkB\n", >
I have used = to be consistent with Buffers usage in the same Planning section. Are you suggesting that "Memory: used=%lld bytes allocated=%lld bytes", should be used instead of "Memory: used=%lld bytes allocated=%lld bytes", Please notice the single vs double space. I am fine with this. > There was some discussion about "bytes" - maybe it should instead show > kB? > So EXPLAIN (memory) on a prepared statement may report memory less than 1kB in which case bytes is a better unit. Planner may consume as less as few kBs of memory, reporting which in kBs would be lossy. > (Also, I first thought that "peek" should be "peak", but eventually I > realized that's it's as intended.) > Don't understand the context. But probably it doesn't matter. -- Best Wishes, Ashutosh Bapat
