pgsql: Add the option to report WAL usage in EXPLAIN and auto_explain.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема pgsql: Add the option to report WAL usage in EXPLAIN and auto_explain.
Дата
Msg-id E1jLHiC-0002v9-6J@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Add the option to report WAL usage in EXPLAIN and auto_explain.

This commit adds a new option WAL similar to existing option BUFFERS in the
EXPLAIN command.  This option allows to include information on WAL record
generation added by commit df3b181499 in EXPLAIN output.

This also allows the WAL usage information to be displayed via
the auto_explain module.  A new parameter auto_explain.log_wal controls
whether WAL usage statistics are printed when an execution plan is logged.
This parameter has no effect unless auto_explain.log_analyze is enabled.

Author: Julien Rouhaud
Reviewed-by: Dilip Kumar and Amit Kapila
Discussion: https://postgr.es/m/CAB-hujrP8ZfUkvL5OYETipQwA=e3n7oqHFU=4ZLxWS_Cza3kQQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/33e05f89c53e5a1533d624046bb6fb0da7bb7141

Modified Files
--------------
contrib/auto_explain/auto_explain.c | 15 ++++++++
doc/src/sgml/auto-explain.sgml      | 20 ++++++++++
doc/src/sgml/ref/explain.sgml       | 14 +++++++
src/backend/commands/explain.c      | 74 +++++++++++++++++++++++++++++++++++--
src/bin/psql/tab-complete.c         |  4 +-
src/include/commands/explain.h      |  3 ++
6 files changed, 124 insertions(+), 6 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: pgsql: Preserve clustered index after rewrites with ALTER TABLE
Следующее
От: Michael Paquier
Дата:
Сообщение: pgsql: Refactor cluster.c to use new routine get_index_isclustered()