Queries for the ADXIngestionBatching table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Ingestion batching size

Track ingestion batch size timechart

ADXIngestionBatching
| where TimeGenerated > ago(1d)
| summarize sum(BatchSizeBytes) by Database, Table, bin(TimeGenerated, 10m)
| render timechart

Ingestion batching summary

Ingestion batching summary (by database, table and type).

ADXIngestionBatching
| where TimeGenerated > ago(1d)
| summarize count() by Database, Table, BatchingType, bin(TimeGenerated, 10m)

Ingestion batching duration timechart

Track ingestion batching duration timechart.

ADXIngestionBatching
| where TimeGenerated > ago(1d)
| summarize sum(BatchTimeSeconds) by Database, Table, bin(TimeGenerated, 10m)
| render timechart