enable_explain_scheduling

enable_explain_scheduling appends query scheduling information such as worker selection to EXPLAIN output, so you can see how a query is distributed across the cluster.

Description

enable_explain_scheduling is a session-scoped boolean system variable. When it is enabled, EXPLAIN output includes additional scheduling lines that describe how the query is scheduled, including the workers selected to run it.

It is disabled by default (value 0).

Syntax

SET enable_explain_scheduling = {0 | 1}

Arguments

enable_explain_scheduling takes a single boolean value: 0 (disabled, the default) or 1 (enabled).

Examples

DROP DATABASE IF EXISTS enable_explain_scheduling_demo;
CREATE DATABASE enable_explain_scheduling_demo;
USE enable_explain_scheduling_demo;

SET enable_explain_scheduling = 1;
EXPLAIN SELECT 1;

DROP DATABASE enable_explain_scheduling_demo;