> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

> Contains the current number of processed, processing and failed nodes in keeper for each S3Queue metadata object and, on demand, their contents. Unlike system.s3queue_metadata_cache, which shows the in-memory cache, this table reads the state directly from keeper.

# system.s3_queue_metadata

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

Contains the current number of processed, processing and failed nodes in keeper for each S3Queue metadata object and, on demand, their contents. Unlike system.s3queue\_metadata\_cache, which shows the in-memory cache, this table reads the state directly from keeper.

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

* `zookeeper_path` ([String](/docs/reference/data-types/string)) — Path in zookeeper to metadata. For a queue on an auxiliary zookeeper this is the factory key `<zookeeper_name>:<path>`, not the raw keeper path.
* `processed_nodes_count` ([Nullable(UInt64)](/docs/reference/data-types/nullable)) — Number of nodes in the `processed` directory in keeper. Only set for `unordered` mode: in `ordered` mode there are no per-file processed nodes (see `processed_path` instead), so the value is NULL.
* `processing_nodes_count` ([UInt64](/docs/reference/data-types/int-uint)) — Number of nodes in the `processing` directory in keeper
* `failed_nodes_count` ([UInt64](/docs/reference/data-types/int-uint)) — Number of nodes in the `failed` directory in keeper
* `processed_nodes` ([Map(String, String)](/docs/reference/data-types/map)) — Contents (node name -> node data) of the `processed` directory in keeper. Only filled for `unordered` mode. Fetched only when this column is selected.
* `processing_nodes` ([Map(String, String)](/docs/reference/data-types/map)) — Contents (node name -> node data) of the `processing` directory in keeper. Fetched only when this column is selected.
* `failed_nodes` ([Map(String, String)](/docs/reference/data-types/map)) — Contents (node name -> node data) of the `failed` directory in keeper. Fetched only when this column is selected.
* `processed_path` ([Map(String, String)](/docs/reference/data-types/map)) — Last processed path per processed pointer in keeper (relative pointer path -> last processed file path). Only filled for `ordered` mode, where it covers the single, per-bucket and per-partition pointers. Fetched only when this column is selected.