system.workloads - ClickHouse Documentation

Description

Contains information for workloads residing on the local server. The table contains a row for every workload.

Columns

name (String) — The name of the workload.
parent (String) — The name of the parent workload.
create_query (String) — CREATE query of the workload.

Example

SELECT *
FROM system.workloads
FORMAT Vertical

Row 1:
──────
name:         production
parent:       all
create_query: CREATE WORKLOAD production IN `all` SETTINGS weight = 9

Row 2:
──────
name:         development
parent:       all
create_query: CREATE WORKLOAD development IN `all`

Row 3:
──────
name:         all
parent:
create_query: CREATE WORKLOAD `all`

Last modified on June 23, 2026

system.zerosProduces unlimited number of non-materialized zeros.