> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information for workloads residing on the local server.

# system.workloads

<h2 id="description">
  Description
</h2>

Contains information for [workloads](/concepts/features/configuration/server-config/workload-scheduling#workload_entity_storage) residing on the local server. The table contains a row for every workload.

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types/index)) — The name of the workload.
* `parent` ([String](/reference/data-types/index)) — The name of the parent workload.
* `create_query` ([String](/reference/data-types/index)) — CREATE query of the workload.

<h2 id="example">
  Example
</h2>

```sql theme={null}
SELECT *
FROM system.workloads
FORMAT Vertical
```

```text theme={null}
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`
```