v.20.5New Feature

Add system.distribution_queue table

Official CH changelog text
Add system.distribution_queue table. #11394 (Azat Khuzhin).
Add system.distribution_queue table for monitoring distributed inserts.

Why it matters

The system.distribution_queue table provides detailed information about queued and processed blocks during distributed inserts. This enables users to monitor and troubleshoot data insertion in distributed tables more effectively by viewing the current state, delays, retries, and errors related to distributed queue processing.

How to use it

Query the <code>system.distribution_queue</code> table to inspect the status of blocks in the distributed queues. For example:

SELECT * FROM system.distribution_queue
WHERE table = 'your_distributed_table'
ORDER BY create_time DESC
LIMIT 10


This table is available by default in ClickHouse after upgrading to the version that includes this feature. No additional configuration is needed.

Related resources

PreviousNext