Skip to main content

Monitoring:Clickhouse database monitoring

Collect and monitor the general performance Metrics of Clickhouse database.

Configuration parameter

Parameter nameParameter help description
Monitoring HostMonitored IPV4, IPV6 or domain name. Note⚠️Without protocol header (eg: https://, http://)
Monitoring nameIdentify the name of this monitoring. The name needs to be unique
PortPort provided by the database. The default is 8123
Query timeoutSet the timeout time when SQL query does not respond to data, unit: ms, default: 6000ms
Database nameDatabase instance name, optional
UsernameDatabase connection user name, optional
PasswordDatabase connection password, optional
Collection intervalInterval time of monitor periodic data collection, unit: second, and the minimum interval that can be set is 30 seconds
Bind TagsUsed to classify and manage monitoring resources
Description remarksFor more information about identifying and describing this monitoring, users can note information here

Collection Metric

Metric set:ping_available

Metric nameMetric unitMetric help description
responseTimenoneresponse time

Metric set:Data in the system.metrics table

Metric nameMetric unitMetric help description
QuerynoneNumber of executing queries
MergenoneNumber of executing background merges
PartMutationnoneNumber of mutations (ALTER DELETE/UPDATE)
ReplicatedFetchnoneNumber of data parts being fetched from replica
ReplicatedSendnoneNumber of data parts being sent to replicas
ReplicatedChecksnoneNumber of data parts checking for consistency
BackgroundMergesAndMutationsPoolTasknoneNumber of active merges and mutations in an associated background pool
BackgroundFetchesPoolTasknoneNumber of active fetches in an associated background pool
BackgroundCommonPoolTasknoneNumber of active tasks in an associated background pool
BackgroundMovePoolTasknoneNumber of active tasks in BackgroundProcessingPool for moves

Metric set:Data for the table

Metric nameMetric unitMetric help description
QuerynoneNumber of queries to be interpreted and potentially executed. Does not include queries that failed to parse or were rejected due to AST size limits, quota limits or limits on the number of simultaneously running queries. May include internal queries initiated by ClickHouse itself. Does not count subqueries.
SelectQuerynoneSame as Query, but only for SELECT queries.
FailedQuerynoneNumber of failed queries.
FailedSelectQuerynoneSame as FailedQuery, but only for SELECT queries.
QueryTimeMicrosecondsnoneTotal time of all queries.

Metric set:Data from the system.asynchronous_metrics table

Metric nameMetric unitMetric help description
AsynchronousMetricsCalculationTimeSpentnoneTime spent on asynchronous metrics calculation.
jemalloc.arenas.all.muzzy_purgednoneNumber of muzzy pages purged.
jemalloc.arenas.all.dirty_purgednoneNumber of dirty pages purged.
BlockReadBytes_ram1noneNumber of bytes read from RAM.
jemalloc.background_thread.run_intervalsnoneNumber of background thread run intervals.
BlockQueueTime_nbd13noneTime spent in block queue.
jemalloc.background_thread.num_threadsnoneNumber of background threads.
jemalloc.residentnoneResident memory size.
InterserverThreadsnoneNumber of inter-server threads.
BlockWriteMerges_nbd7noneNumber of block write merges.