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

> System table containing history of background schedule pool task executions.

# system.background_schedule_pool_log

<Info>
  **Querying in ClickHouse Cloud**

  The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the `clusterAllReplicas` function. See [here](/reference/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.
</Info>

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

The `system.background_schedule_pool_log` table is created only if the [background\_schedule\_pool\_log](/reference/settings/server-settings/settings#background_schedule_pool_log) server setting is specified.

This table contains the history of background schedule pool task executions. Background schedule pools are used for executing periodic tasks such as distributed sends, buffer flushes, and message broker operations.

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

* `hostname` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — Hostname of the server executing the query.
* `event_date` ([Date](/reference/data-types/date)) — Event date.
* `event_time` ([DateTime](/reference/data-types/datetime)) — Event time.
* `event_time_microseconds` ([DateTime64(6)](/reference/data-types/datetime64)) — Event time with microseconds precision.
* `query_id` ([String](/reference/data-types/string)) — Identifier of the query associated with the background task.
* `database` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — Name of the database.
* `table` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — Name of the table.
* `table_uuid` ([UUID](/reference/data-types/uuid)) — UUID of the table the background task belongs to.
* `log_name` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — Name of the background task.
* `duration_ms` ([UInt64](/reference/data-types/int-uint)) — Duration of the task execution in milliseconds.
* `error` ([UInt16](/reference/data-types/int-uint)) — The error code of the occurred exception.
* `exception` ([String](/reference/data-types/string)) — Text message of the occurred error.

The `system.background_schedule_pool_log` table is created after the first background task execution.

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

```sql theme={null}
SELECT * FROM system.background_schedule_pool_log LIMIT 1 FORMAT Vertical;
```

```text theme={null}
Row 1:
──────
hostname:                clickhouse.eu-central1.internal
event_date:              2025-12-18
event_time:              2025-12-18 10:30:15
event_time_microseconds: 2025-12-18 10:30:15.123456
query_id:
database:                default
table:                   data
table_uuid:              00000000-0000-0000-0000-000000000000
log_name:                default.data
duration_ms:             42
error:                   0
exception:
```

<h2 id="see-also">
  See also
</h2>

* [system.background\_schedule\_pool](/reference/system-tables/background_schedule_pool) — Contains information about currently scheduled tasks in background schedule pools.