pgsql: autho_explain: Add GUC to log query parameters

Started by Michael Paquieralmost 4 years ago1 messagescomitters
Jump to latest
#1Michael Paquier
michael@paquier.xyz

autho_explain: Add GUC to log query parameters

auto_explain.log_parameter_max_length is a new GUC part of the
extension, similar to the corresponding core setting, that controls the
inclusion of query parameters in the logged explain output.

More tests are added to check the behavior of this new parameter: when
parameters logged in full (the default of -1), when disabled (value of
0) and when partially truncated (value different than the two others).

Author: Dagfinn Ilmari Mannsåker
Discussion: /messages/by-id/87ee09mohb.fsf@wibble.ilmari.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d4bfe41281705c1bcb7093b3d07ce5ff1114341b

Modified Files
--------------
contrib/auto_explain/auto_explain.c | 15 ++++++++++
contrib/auto_explain/t/001_auto_explain.pl | 48 ++++++++++++++++++++++++++++++
doc/src/sgml/auto-explain.sgml | 19 ++++++++++++
src/backend/commands/explain.c | 22 ++++++++++++++
src/include/commands/explain.h | 1 +
5 files changed, 105 insertions(+)