postgresql/contrib/auto_explain
Alvaro Herrera 5de890e361
Add EXPLAIN (MEMORY) to report planner memory consumption
This adds a new "Memory:" line under the "Planning:" group (which
currently only has "Buffers:") when the MEMORY option is specified.

In order to make the reporting reasonably accurate, we create a separate
memory context for planner activities, to be used only when this option
is given.  The total amount of memory allocated by that context is
reported as "allocated"; we subtract memory in the context's freelists
from that and report that result as "used".  We use
MemoryContextStatsInternal() to obtain the quantities.

The code structure to show buffer usage during planning was not in
amazing shape, so I (Álvaro) modified the patch a bit to clean that up
in passing.

Author: Ashutosh Bapat
Reviewed-by: David Rowley, Andrey Lepikhov, Jian He, Andy Fan
Discussion: https://www.postgresql.org/message-id/CAExHW5sZA=5LJ_ZPpRO-w09ck8z9p7eaYAqq3Ks9GDfhrxeWBw@mail.gmail.com
2024-01-29 17:53:03 +01:00
..
t Update copyright for 2024 2024-01-03 20:49:05 -05:00
.gitignore Add a simple test for contrib/auto_explain. 2021-01-24 14:59:33 -05:00
Makefile Add a simple test for contrib/auto_explain. 2021-01-24 14:59:33 -05:00
auto_explain.c Add EXPLAIN (MEMORY) to report planner memory consumption 2024-01-29 17:53:03 +01:00
meson.build Update copyright for 2024 2024-01-03 20:49:05 -05:00