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

> System table containing information about pending asynchronous inserts in queue.

# system.asynchronous_inserts

<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>

Contains information about pending asynchronous inserts in queue.

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

* `query` ([String](/reference/data-types/index)) — Query text.
* `database` ([String](/reference/data-types/index)) — Database name.
* `table` ([String](/reference/data-types/index)) — Table name.
* `format` ([String](/reference/data-types/index)) — Format name.
* `first_update` ([DateTime64(6)](/reference/data-types/index)) — First insert time with microseconds resolution.
* `total_bytes` ([UInt64](/reference/data-types/index)) — Total number of bytes waiting in the queue.
* `entries.query_id` ([Array(String)](/reference/data-types/index)) — Array of query ids of the inserts waiting in the queue.
* `entries.bytes` ([Array(UInt64)](/reference/data-types/index)) — Array of bytes of each insert query waiting in the queue.

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

```sql title="Query" theme={null}
SELECT * FROM system.asynchronous_inserts LIMIT 1 \G;
```

```text title="Response" theme={null}
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]
```

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

* [system.query\_log](/reference/system-tables/query_log) — Description of the `query_log` system table which contains common information about queries execution.
* [system.asynchronous\_insert\_log](/reference/system-tables/asynchronous_insert_log) — This table contains information about async inserts performed.