Skip to main content

Documentation Index

Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

Querying in ClickHouse CloudThe 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 for further details.

​
Description

Contains information about pending asynchronous inserts in queue.

​
Columns

  • query (String) — Query text.
  • database (String) — Database name.
  • table (String) — Table name.
  • format (String) — Format name.
  • first_update (DateTime64(6)) — First insert time with microseconds resolution.
  • total_bytes (UInt64) — Total number of bytes waiting in the queue.
  • entries.query_id (Array(String)) — Array of query ids of the inserts waiting in the queue.
  • entries.bytes (Array(UInt64)) — Array of bytes of each insert query waiting in the queue.

​
Example

Query
SELECT * FROM system.asynchronous_inserts LIMIT 1 \G;
Response
Row 1:
──────
query:            INSERT INTO public.data_guess (user_id, datasource_id, timestamp, path, type, num, str) FORMAT CSV
database:         public
table:            data_guess
format:           CSV
first_update:     2023-06-08 10:08:54.199606
total_bytes:      133223
entries.query_id: ['b46cd4c4-0269-4d0b-99f5-d27668c6102e']
entries.bytes:    [133223]

​
See also