tencent cloud

All product documents
Elastic MapReduce
DocumentationElastic MapReduce EMR on CVM Operation GuideMonitoring and AlarmsMonitoring MetricsClickHouse Monitoring Metrics
ClickHouse Monitoring Metrics
Download PDF
Last updated: 2023-12-27 14:50:56
ClickHouse Monitoring Metrics
Last updated: 2023-12-27 14:50:56
Download PDF

ClickHouse - metrics

Title
Metric
Unit
Description
Network connections
tcp
-
Number of TCP server connections
http
-
Number of HTTP server connections
ZooKeeper event subscriptions
watches
-
Number of ZooKeeper event subscriptions
Ephemeral nodes held in ZooKeeper
ephemeralNode
-
Number of ephemeral nodes held in ZooKeeper
Active tasks in BackgroundPool
backgroundPoolTask
-
Number of active tasks in BackgroundProcessingPool
backgroundSchedulePoolTask
-
Number of active tasks in BackgroundSchedulePool
Threads waiting for locks in Context
contextLockWait
-
Number of threads waiting for locks in Context
Throttled INSERT queries
delayedInserts
-
Number of throttled INSERT queries
Requests in fly to data sources of dictionaries of cache type
dictCacheRequests
-
Number of requests in fly to data sources of dictionaries of cache type
Pending files to process for asynchronous insertion into distributed tables
distributedSend
-
Number of pending files to process for asynchronous insertion into distributed tables
Threads
global
-
Number of threads in the global thread pool
globalActive
-
Number of active threads in the global thread pool
local
-
Number of threads in the local thread pool
localActive
-
Number of active threads in the local thread pool
Replicas participating in leader election
leaderElection
-
Number of replicas participating in leader election
Replicated tables
leaderReplica
-
Number of replicated tables that are leaders
readonlyReplica
-
Number of replicated tables in read-only status
Total allocated memory size
memoryTracking
GB
Total memory size allocated to queries being executed
backgroundProcessingPool
GB
Total memory size allocated to the background processing pool
backgroundSchedulePool
GB
Total memory size allocated to the background scheduling pool
memoryTrackingForMerges
GB
Total memory size allocated to background merges
Merges being executed in the background
merge
-
Number of merges being executed in the background
Opened files
read
-
Number of opened readable files
write
-
Number of opened writable files
Table changes
partMutation
-
Number of table changes
Query processing threads
queryThread
-
Number of query processing threads
Stopped or waiting queries
queryPreempted
-
Number of stopped or waiting queries
System calls
read
-
Number of read system calls
write
-
Number of write system calls
Blocks
fetch
-
Number of blocks collected from replicas
send
-
Number of blocks sent to replicas
check
-
Number of blocks for consistency check
Server change
revision
-
Number of server changes
Version number
version
1
Version number
Threads waiting for read/write locks
waitingRead
-
Number of threads waiting for read/write locks to read from tables
waitingWrite
-
Number of threads waiting for read/write locks to write to tables
activeRead
-
Number of threads holding read locks on tables
activeWrite
-
Number of threads holding write locks on tables
Rows in buffer tables
storageBufferRows
-
Number of rows in buffer tables
Bytes in buffer tables
storageBufferBytes
MB
Number of bytes in buffer tables

ClickHouse - events

Title
Metric
Unit
Description
Queries
total
-
Total number of queries that may be executed
select
-
Number of SELECT queries that may be executed
insert
-
Number of INSERT queries that may be executed
Inserted rows
insertedRows
-
Number of rows inserted into all tables
Inserted bytes
insertedBytes
-
Number of bytes inserted into all tables
Total time waiting for system calls
read
μs
Total time waiting for read system calls
write
μs
Total time waiting for write system calls
Opened files
fileOpen
-
Number of opened files
Reads/Writes from/to file descriptors
read
-
Number of reads from file descriptors
write
-
Number of writes to file descriptors
Bytes read/written from/to file descriptors
read
MB
Number of bytes read from file descriptors
write
MB
Number of bytes written to file descriptors
Total time processing threads
realtime
μs
Total time processing threads
user
μs
Total time processing threads executing CPU instructions in user space
system
μs
Total time processing threads executing CPU instructions in OS kernel space
Compiled regular expressions
regexpCreated
-
Number of compiled regular expressions

ClickHouse - asynchronous metrics

Title
Metric
Unit
Description
Size of cache of marks of StorageMergeTree
markCacheBytes
MB
Size of cache of marks of StorageMergeTree
Cache files of marks of StorageMergeTree
markCacheFiles
-
Number of cache files of marks of StorageMergeTree
Maximum number of active blocks
maxPartCountForPartition
-
Number of largest active data blocks in partition
Databases
databaseCount
-
Number of databases
Data tables
tableCount
-
Number of data tables
Maximum replica latency
absolute
μs
Maximum replica queue latency
relative
μs
Maximum difference of the absolute latency from other blocks
Size of the queue for the operations to be performed
replicasMaxQueueSize
-
Size of the queue for the operations to be performed

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon