system.asynchronous_inserts - Clickhouse

import SystemTableCloud from '@site/docs/_snippets/_system_table_cloud.md';

Contains information about pending asynchronous inserts in queue.

Columns:

Example

Query:

sql

SELECT * FROM system.asynchronous_inserts LIMIT 1 \G;

Result:

text

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

system.query_log — Description of the query_log system table which contains common information about queries execution.
system.asynchronous_insert_log — This table contains information about async inserts performed.