diff options
| author | Tomas Vondra | 2019-04-03 22:04:31 +0000 |
|---|---|---|
| committer | Tomas Vondra | 2019-04-03 22:04:31 +0000 |
| commit | ea569d64ac7174d3fe657e3e682d11053ecf1866 (patch) | |
| tree | fa6b135c64de45765a78c7f72b22481fd9b95bc3 /src/include/commands | |
| parent | d1f04b96b99d595e80791cdb0faa9cfdde2a5afa (diff) | |
Add SETTINGS option to EXPLAIN, to print modified settings.
Query planning is affected by a number of configuration options, and it
may be crucial to know which of those options were set to non-default
values. With this patch you can say EXPLAIN (SETTINGS ON) to include
that information in the query plan. Only options affecting planning,
with values different from the built-in default are printed.
This patch also adds auto_explain.log_settings option, providing the
same capability in auto_explain module.
Author: Tomas Vondra
Reviewed-by: Rafia Sabih, John Naylor
Discussion: https://postgr.es/m/e1791b4c-df9c-be02-edc5-7c8874944be0@2ndquadrant.com
Diffstat (limited to 'src/include/commands')
| -rw-r--r-- | src/include/commands/explain.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/include/commands/explain.h b/src/include/commands/explain.h index e8854db4599..db48f295019 100644 --- a/src/include/commands/explain.h +++ b/src/include/commands/explain.h @@ -35,6 +35,7 @@ typedef struct ExplainState bool buffers; /* print buffer usage */ bool timing; /* print detailed node timing */ bool summary; /* print total planning and execution timing */ + bool settings; /* print modified settings */ ExplainFormat format; /* output format */ /* state for output formatting --- not reset for each new plan tree */ int indent; /* current indentation level */ |