Skip to main content
Skip to main content
Edit this page

histogram_metrics

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 for further details.

This table contains histogram metrics that can be calculated instantly and exported in the Prometheus format. It is always up to date. Replaces the deprecated system.latency_log.

Columns:

Example

You can use a query like this to export all the histogram metrics in the Prometheus format.

SELECT
  metric AS name,
  toFloat64(value) AS value,
  description AS help,
  labels,
  'histogram' AS type
FROM system.histogram_metrics
FORMAT Prometheus

Metric descriptions​

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes​

Size of batch sent to Raft in bytes.

keeper_batch_size_bytes_sum​

Size of batch sent to Raft in bytes.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements​

Size of batch sent to Raft in elements.

keeper_batch_size_elements_sum​

Size of batch sent to Raft in elements.

keeper_client_queue_duration_milliseconds​

Time requests spend waiting to be enqueued and waiting in the queue before processed

keeper_client_queue_duration_milliseconds​

Time requests spend waiting to be enqueued and waiting in the queue before processed

keeper_client_queue_duration_milliseconds​

Time requests spend waiting to be enqueued and waiting in the queue before processed

keeper_client_queue_duration_milliseconds​

Time requests spend waiting to be enqueued and waiting in the queue before processed

keeper_client_queue_duration_milliseconds​

Time requests spend waiting to be enqueued and waiting in the queue before processed

keeper_client_queue_duration_milliseconds_sum​

Time requests spend waiting to be enqueued and waiting in the queue before processed

keeper_dispatcher_requests_queue_time_milliseconds​

Time request spends in dispatcher requests queue

keeper_dispatcher_requests_queue_time_milliseconds​

Time request spends in dispatcher requests queue

keeper_dispatcher_requests_queue_time_milliseconds​

Time request spends in dispatcher requests queue

keeper_dispatcher_requests_queue_time_milliseconds​

Time request spends in dispatcher requests queue

keeper_dispatcher_requests_queue_time_milliseconds​

Time request spends in dispatcher requests queue

keeper_dispatcher_requests_queue_time_milliseconds_sum​

Time request spends in dispatcher requests queue

keeper_dispatcher_responses_queue_time_milliseconds​

Time response spends in dispatcher responses queue

keeper_dispatcher_responses_queue_time_milliseconds​

Time response spends in dispatcher responses queue

keeper_dispatcher_responses_queue_time_milliseconds​

Time response spends in dispatcher responses queue

keeper_dispatcher_responses_queue_time_milliseconds​

Time response spends in dispatcher responses queue

keeper_dispatcher_responses_queue_time_milliseconds​

Time response spends in dispatcher responses queue

keeper_dispatcher_responses_queue_time_milliseconds_sum​

Time response spends in dispatcher responses queue

keeper_read_process_time_milliseconds​

Time to process read request

keeper_read_process_time_milliseconds​

Time to process read request

keeper_read_process_time_milliseconds​

Time to process read request

keeper_read_process_time_milliseconds​

Time to process read request

keeper_read_process_time_milliseconds​

Time to process read request

keeper_read_process_time_milliseconds_sum​

Time to process read request

keeper_read_wait_for_write_time_milliseconds​

Time read request waits for the write request it depends on to complete

keeper_read_wait_for_write_time_milliseconds​

Time read request waits for the write request it depends on to complete

keeper_read_wait_for_write_time_milliseconds​

Time read request waits for the write request it depends on to complete

keeper_read_wait_for_write_time_milliseconds​

Time read request waits for the write request it depends on to complete

keeper_read_wait_for_write_time_milliseconds​

Time read request waits for the write request it depends on to complete

keeper_read_wait_for_write_time_milliseconds_sum​

Time read request waits for the write request it depends on to complete

keeper_receive_request_time_milliseconds​

Time to receive and parse request from client in TCP handler

keeper_receive_request_time_milliseconds​

Time to receive and parse request from client in TCP handler

keeper_receive_request_time_milliseconds​

Time to receive and parse request from client in TCP handler

keeper_receive_request_time_milliseconds​

Time to receive and parse request from client in TCP handler

keeper_receive_request_time_milliseconds​

Time to receive and parse request from client in TCP handler

keeper_receive_request_time_milliseconds_sum​

Time to receive and parse request from client in TCP handler

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms​

The response time of Keeper, in milliseconds

keeper_response_time_ms_sum​

The response time of Keeper, in milliseconds

keeper_response_time_ms_sum​

The response time of Keeper, in milliseconds

keeper_response_time_ms_sum​

The response time of Keeper, in milliseconds

keeper_send_response_time_milliseconds​

Time to send response to client in TCP handler (includes queueing and writing to socket)

keeper_send_response_time_milliseconds​

Time to send response to client in TCP handler (includes queueing and writing to socket)

keeper_send_response_time_milliseconds​

Time to send response to client in TCP handler (includes queueing and writing to socket)

keeper_send_response_time_milliseconds​

Time to send response to client in TCP handler (includes queueing and writing to socket)

keeper_send_response_time_milliseconds​

Time to send response to client in TCP handler (includes queueing and writing to socket)

keeper_send_response_time_milliseconds_sum​

Time to send response to client in TCP handler (includes queueing and writing to socket)

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds​

Time to process write request after Raft commit

keeper_write_commit_time_milliseconds_sum​

Time to process write request after Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds​

Time to preprocess write request before Raft commit

keeper_write_pre_commit_time_milliseconds_sum​

Time to preprocess write request before Raft commit

See Also