Skip to main content
Skip table of contents

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:

ValueDescription
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');
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.