Skip to content

Add SETTINGS to EXPLAIN and visualize it

PG12+ supports SETTINGS https://www.postgresql.org/docs/current/sql-explain.html:

Include information on configuration parameters. Specifically, include options affecting query planning with value different from the built-in default value. This parameter defaults to FALSE.

We need to:

  • add it to the EXPLAIN commands
  • show in chatbot sessions
  • show in History