ENABLE_EXPLAIN_LOG_OUTPUT

You are looking at an older version of the documentation. The latest version is found here.

The EXPLAIN command returns the processing plan or the plan and the full planner debug log, with the ENABLE_EXPLAIN_LOG_OUTPUT option controlling whether the full planner debug log is part of the EXPLAIN result. The option can have the following values:

Value	Description
`TRUE`	Full planner debug log is part of the `EXPLAIN` result; Full planner debug log will be printed into the server log
`FALSE`	Full planner debug log is not part of the `EXPLAIN` result; The "`DEBUG_LOG`" column in the `EXPLAIN` result will have `null` as value Default value

Example

SQL

CALL SYSADMIN.setDefaultOptionValue('ENABLE_EXPLAIN_LOG_OUTPUT', 'TRUE');