tencent cloud

Feedback

ClickHouse Monitoring Metrics

Last updated: 2023-12-27 14:50:56

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

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

    Technical Support

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

    7x24 Phone Support