ClickHouse MonitoringMonitoring

Table: system.metric_log


event_time_microseconds	`DateTime64(6)`	7.75 MiB	15.98 MiB	2.06	2.10 million	7.98	Event time with microseconds resolution.
event_time	`DateTime`	5.30 MiB	7.99 MiB	1.51	2.10 million	3.99	Event time.
ProfileEvent_ReadBufferFromFileDescriptorReadBytes	`UInt64`	4.47 MiB	15.98 MiB	3.57	2.10 million	7.98	Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size.
ProfileEvent_DiskReadElapsedMicroseconds	`UInt64`	3.53 MiB	15.98 MiB	4.52	2.10 million	7.98	Total time spent waiting for read syscall. This include reads from page cache.
CurrentMetric_MemoryTracking	`Int64`	3.41 MiB	15.98 MiB	4.69	2.10 million	7.98	Total amount of memory (bytes) allocated by the server.
ProfileEvent_PartsLockHoldMicroseconds	`UInt64`	3.35 MiB	15.98 MiB	4.77	2.10 million	7.98	Total time spent holding data parts lock in MergeTree tables
ProfileEvent_MergerMutatorPrepareRangesForMergeElapsedMicroseconds	`UInt64`	3.30 MiB	15.98 MiB	4.84	2.10 million	7.98	Time spent to prepare parts ranges which can be merged according to merge predicate.
ProfileEvent_MemoryWorkerRunElapsedMicroseconds	`UInt64`	3.07 MiB	15.98 MiB	5.2	2.10 million	7.98	Total time spent by MemoryWorker for background work
ProfileEvent_PartsLockWaitMicroseconds	`UInt64`	3.01 MiB	15.98 MiB	5.31	2.10 million	7.98	Total time spent waiting for data parts lock in MergeTree tables
ProfileEvent_WriteBufferFromFileDescriptorWriteBytes	`UInt64`	2.90 MiB	15.98 MiB	5.51	2.10 million	7.98	Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size.
ProfileEvent_IOBufferAllocBytes	`UInt64`	2.61 MiB	15.98 MiB	6.12	2.10 million	7.98	Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_MergerMutatorSelectPartsForMergeElapsedMicroseconds	`UInt64`	2.42 MiB	15.98 MiB	6.62	2.10 million	7.98	Time spent to select parts from ranges which can be merged.
ProfileEvent_MergerMutatorPartsInRangesForMergeCount	`UInt64`	2.35 MiB	15.98 MiB	6.81	2.10 million	7.98	Amount of candidate parts for merge
ProfileEvent_CompressedReadBufferBytes	`UInt64`	2.23 MiB	15.98 MiB	7.17	2.10 million	7.98	Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network).
ProfileEvent_MergeTreeDataWriterCompressedBytes	`UInt64`	2.11 MiB	15.98 MiB	7.56	2.10 million	7.98	Bytes written to filesystem for data INSERTed to MergeTree tables.
ProfileEvent_ReadCompressedBytes	`UInt64`	2.01 MiB	15.98 MiB	7.95	2.10 million	7.98	Number of bytes (the number of bytes before decompression) read from compressed sources (files, network).
ProfileEvent_DiskWriteElapsedMicroseconds	`UInt64`	1.99 MiB	15.98 MiB	8.02	2.10 million	7.98	Total time spent waiting for write syscall. This include writes to page cache.
ProfileEvent_RealTimeMicroseconds	`UInt64`	1.99 MiB	15.98 MiB	8.05	2.10 million	7.98	Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum).
ProfileEvent_OSCPUVirtualTimeMicroseconds	`UInt64`	1.97 MiB	15.98 MiB	8.11	2.10 million	7.98	CPU time spent seen by OS. Does not include involuntary waits due to virtualization.
ProfileEvent_UserTimeMicroseconds	`UInt64`	1.96 MiB	15.98 MiB	8.15	2.10 million	7.98	Total time spent in processing (queries and other tasks) threads executing CPU instructions in user mode. This includes time CPU pipeline was stalled due to main memory access, cache misses, branch mispredictions, hyper-threading, etc.
ProfileEvent_MergerMutatorRangesForMergeCount	`UInt64`	1.92 MiB	15.98 MiB	8.34	2.10 million	7.98	Amount of candidate ranges for merge
ProfileEvent_ContextLockWaitMicroseconds	`UInt64`	1.91 MiB	15.98 MiB	8.35	2.10 million	7.98	Context lock wait time in microseconds
ProfileEvent_MergedUncompressedBytes	`UInt64`	1.87 MiB	15.98 MiB	8.54	2.10 million	7.98	Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge.
ProfileEvent_SelectedBytes	`UInt64`	1.85 MiB	15.98 MiB	8.64	2.10 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables.
ProfileEvent_ContextLock	`UInt64`	1.80 MiB	15.98 MiB	8.9	2.10 million	7.98	Number of times the lock of Context was acquired or tried to acquire. This is global lock.
CurrentMetric_PartsWide	`Int64`	1.75 MiB	15.98 MiB	9.14	2.10 million	7.98	Wide parts.
ProfileEvent_SystemTimeMicroseconds	`UInt64`	1.68 MiB	15.98 MiB	9.52	2.10 million	7.98	Total time spent in processing (queries and other tasks) threads executing CPU instructions in OS kernel mode. This is time spent in syscalls, excluding waiting time during blocking syscalls.
ProfileEvent_MergedRows	`UInt64`	1.52 MiB	15.98 MiB	10.5	2.10 million	7.98	Rows read for background merges. This is the number of rows before merge.
ProfileEvent_SelectedRows	`UInt64`	1.52 MiB	15.98 MiB	10.53	2.10 million	7.98	Number of rows SELECTed from all tables.
ProfileEvent_SoftPageFaults	`UInt64`	1.48 MiB	15.98 MiB	10.8	2.10 million	7.98	The number of soft page faults in query execution threads. Soft page fault usually means a miss in the memory allocator cache, which requires a new memory mapping from the OS and subsequent allocation of a page of physical memory.
ProfileEvent_RWLockAcquiredReadLocks	`UInt64`	1.48 MiB	15.98 MiB	10.83	2.10 million	7.98	Number of times a read lock was acquired (in a heavy RWLock).
ProfileEvent_IOBufferAllocs	`UInt64`	1.43 MiB	15.98 MiB	11.15	2.10 million	7.98	Number of allocations of IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_MergeTreeDataWriterUncompressedBytes	`UInt64`	1.42 MiB	15.98 MiB	11.27	2.10 million	7.98	Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables.
ProfileEvent_InsertedBytes	`UInt64`	1.40 MiB	15.98 MiB	11.4	2.10 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables.
ProfileEvent_LogTrace	`UInt64`	1.39 MiB	15.98 MiB	11.48	2.10 million	7.98	Number of log messages with level Trace
ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds	`UInt64`	1.32 MiB	15.98 MiB	12.12	2.10 million	7.98	Time spent sorting blocks
ProfileEvent_OSReadChars	`UInt64`	1.31 MiB	15.98 MiB	12.21	2.10 million	7.98	Number of bytes read from filesystem, including page cache.
ProfileEvent_FileOpen	`UInt64`	1.27 MiB	15.98 MiB	12.6	2.10 million	7.98	Number of files opened.
ProfileEvent_FunctionExecute	`UInt64`	1.25 MiB	15.98 MiB	12.74	2.10 million	7.98	Number of SQL ordinary function calls (SQL functions are called on per-block basis, so this number represents the number of blocks).
ProfileEvent_CompressedReadBufferBlocks	`UInt64`	1.19 MiB	15.98 MiB	13.41	2.10 million	7.98	Number of compressed blocks (the blocks of data that are compressed independent of each other) read from compressed sources (files, network).
ProfileEvent_OSWriteChars	`UInt64`	1.19 MiB	15.98 MiB	13.43	2.10 million	7.98	Number of bytes written to filesystem, including page cache.
ProfileEvent_WriteBufferFromFileDescriptorWrite	`UInt64`	1.10 MiB	15.98 MiB	14.55	2.10 million	7.98	Number of writes (write/pwrite) to a file descriptor. Does not include sockets.
ProfileEvent_WaitMarksLoadMicroseconds	`UInt64`	1.05 MiB	15.98 MiB	15.23	2.10 million	7.98	Time spent loading marks
ProfileEvent_OSWriteBytes	`UInt64`	1.04 MiB	15.98 MiB	15.39	2.10 million	7.98	Number of bytes written to disks or block devices. Doesn't include bytes that are in page cache dirty pages. May not include data that was written by OS asynchronously.
ProfileEvent_ReadBufferFromFileDescriptorRead	`UInt64`	1.03 MiB	15.98 MiB	15.53	2.10 million	7.98	Number of reads (read/pread) from a file descriptor. Does not include sockets.
ProfileEvent_MergeTreeDataWriterRows	`UInt64`	1.02 MiB	15.98 MiB	15.6	2.10 million	7.98	Number of rows INSERTed to MergeTree tables.
ProfileEvent_InsertedRows	`UInt64`	1.02 MiB	15.98 MiB	15.63	2.10 million	7.98	Number of rows INSERTed to all tables.
ProfileEvent_NetworkReceiveElapsedMicroseconds	`UInt64`	1019.40 KiB	15.98 MiB	16.05	2.10 million	7.98	Total time spent waiting for data to receive or receiving data from network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
CurrentMetric_PartsCompact	`Int64`	1003.28 KiB	15.98 MiB	16.31	2.10 million	7.98	Compact parts.
ProfileEvent_LogDebug	`UInt64`	969.20 KiB	15.98 MiB	16.89	2.10 million	7.98	Number of log messages with level Debug
ProfileEvent_MergeExecuteMilliseconds	`UInt64`	900.63 KiB	15.98 MiB	18.17	2.10 million	7.98	Total busy time spent for execution of background merges
ProfileEvent_MergeTotalMilliseconds	`UInt64`	895.93 KiB	15.98 MiB	18.27	2.10 million	7.98	Total time spent for background merges
ProfileEvent_MergeHorizontalStageExecuteMilliseconds	`UInt64`	881.02 KiB	15.98 MiB	18.58	2.10 million	7.98	Total busy time spent for execution of horizontal stage of background merges
ProfileEvent_OpenedFileCacheMicroseconds	`UInt64`	878.22 KiB	15.98 MiB	18.64	2.10 million	7.98	Amount of time spent executing OpenedFileCache methods.
ProfileEvent_MergeHorizontalStageTotalMilliseconds	`UInt64`	877.92 KiB	15.98 MiB	18.64	2.10 million	7.98	Total time spent for horizontal stage of background merges
ProfileEvent_OSCPUWaitMicroseconds	`UInt64`	837.77 KiB	15.98 MiB	19.54	2.10 million	7.98	Total time a thread was ready for execution but waiting to be scheduled by OS, from the OS point of view.
CurrentMetric_PartsOutdated	`Int64`	831.42 KiB	15.98 MiB	19.68	2.10 million	7.98	Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes.
ProfileEvent_NetworkSendElapsedMicroseconds	`UInt64`	828.35 KiB	15.98 MiB	19.76	2.10 million	7.98	Total time spent waiting for data to send to network or sending data to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_LoadedMarksMemoryBytes	`UInt64`	816.67 KiB	15.98 MiB	20.04	2.10 million	7.98	Size of in-memory representations of loaded marks.
ProfileEvent_Seek	`UInt64`	794.36 KiB	15.98 MiB	20.6	2.10 million	7.98	Number of times the 'lseek' function was called.
ProfileEvent_MemoryWorkerRun	`UInt64`	783.46 KiB	15.98 MiB	20.89	2.10 million	7.98	Number of runs done by MemoryWorker in background
CurrentMetric_Read	`Int64`	782.24 KiB	15.98 MiB	20.92	2.10 million	7.98	Number of read (read, pread, io_getevents, etc.) syscalls in fly
ProfileEvent_LoadedMarksCount	`UInt64`	763.90 KiB	15.98 MiB	21.42	2.10 million	7.98	Number of marks loaded (total across columns).
ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds	`UInt64`	753.92 KiB	15.98 MiB	21.71	2.10 million	7.98	Time spent merging input blocks (for special MergeTree engines)
ProfileEvent_CreatedReadBufferOrdinary	`UInt64`	746.70 KiB	15.98 MiB	21.92	2.10 million	7.98	Number of times ordinary read buffer was created for reading data (while choosing among other read methods).
ProfileEvent_OpenedFileCacheMisses	`UInt64`	739.28 KiB	15.98 MiB	22.14	2.10 million	7.98	Number of times a file has been found in the opened file cache, so we had to open it again.
ProfileEvent_ConcurrencyControlSlotsAcquired	`UInt64`	691.55 KiB	15.98 MiB	23.67	2.10 million	7.98	Total number of CPU slot acquired
ProfileEvent_ConcurrencyControlSlotsGranted	`UInt64`	691.55 KiB	15.98 MiB	23.67	2.10 million	7.98	Number of CPU slot granted according to guarantee of 1 thread per query and for queries with setting 'use_concurrency_control' = 0
CurrentMetric_PartsActive	`Int64`	647.43 KiB	15.98 MiB	25.28	2.10 million	7.98	Active data part, used by current and upcoming SELECTs.
CurrentMetric_PartsCommitted	`Int64`	647.43 KiB	15.98 MiB	25.28	2.10 million	7.98	Deprecated. See PartsActive.
ProfileEvent_InsertedCompactParts	`UInt64`	576.64 KiB	15.98 MiB	28.38	2.10 million	7.98	Number of parts inserted in Compact format.
ProfileEvent_MergeTreeDataWriterBlocks	`UInt64`	576.64 KiB	15.98 MiB	28.38	2.10 million	7.98	Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero.
ProfileEvent_MergedColumns	`UInt64`	564.97 KiB	15.98 MiB	28.97	2.10 million	7.98	Number of columns merged during the horizontal stage of merges.
ProfileEvent_CannotWriteToWriteBufferDiscard	`UInt64`	541.03 KiB	15.98 MiB	30.25	2.10 million	7.98	Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe.
ProfileEvent_MergingSortedMilliseconds	`UInt64`	540.07 KiB	15.98 MiB	30.3	2.10 million	7.98	Total time spent while merging sorted columns
ProfileEvent_QueryTimeMicroseconds	`UInt64`	538.59 KiB	10.02 MiB	19.04	2.10 million	5	Total time of all queries.
ProfileEvent_NetworkSendBytes	`UInt64`	537.96 KiB	15.98 MiB	30.42	2.10 million	7.98	Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
CurrentMetric_AsynchronousInsertThreads	`Int64`	534.95 KiB	15.98 MiB	30.59	2.10 million	7.98	Number of threads in the AsynchronousInsert thread pool.
CurrentMetric_AttachedDatabase	`Int64`	530.93 KiB	15.98 MiB	30.83	2.10 million	7.98	Active databases.
CurrentMetric_ThreadPoolFSReaderThreads	`Int64`	530.10 KiB	15.98 MiB	30.87	2.10 million	7.98	Number of threads in the thread pool for local_filesystem_read_method=threadpool.
CurrentMetric_BackgroundSchedulePoolSize	`Int64`	527.87 KiB	15.98 MiB	31	2.10 million	7.98	Limit on number of tasks in BackgroundSchedulePool. This pool is used for periodic ReplicatedMergeTree tasks, like cleaning old data parts, altering data parts, replica re-initialization, etc.
CurrentMetric_AttachedTable	`Int64`	527.15 KiB	15.98 MiB	31.05	2.10 million	7.98	Active tables.
CurrentMetric_BackgroundMergesAndMutationsPoolSize	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Limit on number of active merges and mutations in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreadsActive	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool running a task.
CurrentMetric_MergeTreeBackgroundExecutorThreads	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_ConcurrencyControlSoftLimit	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Value of soft limit on number of CPU slots
CurrentMetric_BackgroundDistributedSchedulePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundDistributedSchedulePool
CurrentMetric_BackgroundBufferFlushSchedulePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundBufferFlushSchedulePool
CurrentMetric_BackgroundMessageBrokerSchedulePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundMessageBrokerSchedulePool for message streaming
CurrentMetric_BackgroundFetchesPoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of simultaneous fetches in an associated background pool
CurrentMetric_BackgroundMovePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundProcessingPool for moves
CurrentMetric_BackgroundCommonPoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in an associated background pool
CurrentMetric_AddressesActive	`Int64`	526.38 KiB	15.98 MiB	31.09	2.10 million	7.98	Total count of addresses which are used for creation connections with connection pools
CurrentMetric_ZooKeeperSession	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of sessions (connections) to ZooKeeper. Should be no more than one, because using more than one connection to ZooKeeper may lead to bugs due to lack of linearizability (stale reads) that ZooKeeper consistency model allows.
CurrentMetric_ZooKeeperWatch	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of watches (event subscriptions) in ZooKeeper.
CurrentMetric_EphemeralNode	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of ephemeral nodes hold in ZooKeeper.
CurrentMetric_AttachedView	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Active views.
CurrentMetric_DiskConnectionsStored	`Int64`	526.13 KiB	15.98 MiB	31.11	2.10 million	7.98	Total count of sessions stored in the session pool for disks
CurrentMetric_IOWriterThreads	`Int64`	526.13 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of threads in the IO writer thread pool.

0 of 1118 row(s) selected.

Rows per page

Page 1 of 12

Table: system.metric_log


event_time_microseconds	`DateTime64(6)`	7.75 MiB	15.98 MiB	2.06	2.10 million	7.98	Event time with microseconds resolution.
event_time	`DateTime`	5.30 MiB	7.99 MiB	1.51	2.10 million	3.99	Event time.
ProfileEvent_ReadBufferFromFileDescriptorReadBytes	`UInt64`	4.47 MiB	15.98 MiB	3.57	2.10 million	7.98	Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size.
ProfileEvent_DiskReadElapsedMicroseconds	`UInt64`	3.53 MiB	15.98 MiB	4.52	2.10 million	7.98	Total time spent waiting for read syscall. This include reads from page cache.
CurrentMetric_MemoryTracking	`Int64`	3.41 MiB	15.98 MiB	4.69	2.10 million	7.98	Total amount of memory (bytes) allocated by the server.
ProfileEvent_PartsLockHoldMicroseconds	`UInt64`	3.35 MiB	15.98 MiB	4.77	2.10 million	7.98	Total time spent holding data parts lock in MergeTree tables
ProfileEvent_MergerMutatorPrepareRangesForMergeElapsedMicroseconds	`UInt64`	3.30 MiB	15.98 MiB	4.84	2.10 million	7.98	Time spent to prepare parts ranges which can be merged according to merge predicate.
ProfileEvent_MemoryWorkerRunElapsedMicroseconds	`UInt64`	3.07 MiB	15.98 MiB	5.2	2.10 million	7.98	Total time spent by MemoryWorker for background work
ProfileEvent_PartsLockWaitMicroseconds	`UInt64`	3.01 MiB	15.98 MiB	5.31	2.10 million	7.98	Total time spent waiting for data parts lock in MergeTree tables
ProfileEvent_WriteBufferFromFileDescriptorWriteBytes	`UInt64`	2.90 MiB	15.98 MiB	5.51	2.10 million	7.98	Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size.
ProfileEvent_IOBufferAllocBytes	`UInt64`	2.61 MiB	15.98 MiB	6.12	2.10 million	7.98	Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_MergerMutatorSelectPartsForMergeElapsedMicroseconds	`UInt64`	2.42 MiB	15.98 MiB	6.62	2.10 million	7.98	Time spent to select parts from ranges which can be merged.
ProfileEvent_MergerMutatorPartsInRangesForMergeCount	`UInt64`	2.35 MiB	15.98 MiB	6.81	2.10 million	7.98	Amount of candidate parts for merge
ProfileEvent_CompressedReadBufferBytes	`UInt64`	2.23 MiB	15.98 MiB	7.17	2.10 million	7.98	Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network).
ProfileEvent_MergeTreeDataWriterCompressedBytes	`UInt64`	2.11 MiB	15.98 MiB	7.56	2.10 million	7.98	Bytes written to filesystem for data INSERTed to MergeTree tables.
ProfileEvent_ReadCompressedBytes	`UInt64`	2.01 MiB	15.98 MiB	7.95	2.10 million	7.98	Number of bytes (the number of bytes before decompression) read from compressed sources (files, network).
ProfileEvent_DiskWriteElapsedMicroseconds	`UInt64`	1.99 MiB	15.98 MiB	8.02	2.10 million	7.98	Total time spent waiting for write syscall. This include writes to page cache.
ProfileEvent_RealTimeMicroseconds	`UInt64`	1.99 MiB	15.98 MiB	8.05	2.10 million	7.98	Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum).
ProfileEvent_OSCPUVirtualTimeMicroseconds	`UInt64`	1.97 MiB	15.98 MiB	8.11	2.10 million	7.98	CPU time spent seen by OS. Does not include involuntary waits due to virtualization.
ProfileEvent_UserTimeMicroseconds	`UInt64`	1.96 MiB	15.98 MiB	8.15	2.10 million	7.98	Total time spent in processing (queries and other tasks) threads executing CPU instructions in user mode. This includes time CPU pipeline was stalled due to main memory access, cache misses, branch mispredictions, hyper-threading, etc.
ProfileEvent_MergerMutatorRangesForMergeCount	`UInt64`	1.92 MiB	15.98 MiB	8.34	2.10 million	7.98	Amount of candidate ranges for merge
ProfileEvent_ContextLockWaitMicroseconds	`UInt64`	1.91 MiB	15.98 MiB	8.35	2.10 million	7.98	Context lock wait time in microseconds
ProfileEvent_MergedUncompressedBytes	`UInt64`	1.87 MiB	15.98 MiB	8.54	2.10 million	7.98	Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge.
ProfileEvent_SelectedBytes	`UInt64`	1.85 MiB	15.98 MiB	8.64	2.10 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables.
ProfileEvent_ContextLock	`UInt64`	1.80 MiB	15.98 MiB	8.9	2.10 million	7.98	Number of times the lock of Context was acquired or tried to acquire. This is global lock.
CurrentMetric_PartsWide	`Int64`	1.75 MiB	15.98 MiB	9.14	2.10 million	7.98	Wide parts.
ProfileEvent_SystemTimeMicroseconds	`UInt64`	1.68 MiB	15.98 MiB	9.52	2.10 million	7.98	Total time spent in processing (queries and other tasks) threads executing CPU instructions in OS kernel mode. This is time spent in syscalls, excluding waiting time during blocking syscalls.
ProfileEvent_MergedRows	`UInt64`	1.52 MiB	15.98 MiB	10.5	2.10 million	7.98	Rows read for background merges. This is the number of rows before merge.
ProfileEvent_SelectedRows	`UInt64`	1.52 MiB	15.98 MiB	10.53	2.10 million	7.98	Number of rows SELECTed from all tables.
ProfileEvent_SoftPageFaults	`UInt64`	1.48 MiB	15.98 MiB	10.8	2.10 million	7.98	The number of soft page faults in query execution threads. Soft page fault usually means a miss in the memory allocator cache, which requires a new memory mapping from the OS and subsequent allocation of a page of physical memory.
ProfileEvent_RWLockAcquiredReadLocks	`UInt64`	1.48 MiB	15.98 MiB	10.83	2.10 million	7.98	Number of times a read lock was acquired (in a heavy RWLock).
ProfileEvent_IOBufferAllocs	`UInt64`	1.43 MiB	15.98 MiB	11.15	2.10 million	7.98	Number of allocations of IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_MergeTreeDataWriterUncompressedBytes	`UInt64`	1.42 MiB	15.98 MiB	11.27	2.10 million	7.98	Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables.
ProfileEvent_InsertedBytes	`UInt64`	1.40 MiB	15.98 MiB	11.4	2.10 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables.
ProfileEvent_LogTrace	`UInt64`	1.39 MiB	15.98 MiB	11.48	2.10 million	7.98	Number of log messages with level Trace
ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds	`UInt64`	1.32 MiB	15.98 MiB	12.12	2.10 million	7.98	Time spent sorting blocks
ProfileEvent_OSReadChars	`UInt64`	1.31 MiB	15.98 MiB	12.21	2.10 million	7.98	Number of bytes read from filesystem, including page cache.
ProfileEvent_FileOpen	`UInt64`	1.27 MiB	15.98 MiB	12.6	2.10 million	7.98	Number of files opened.
ProfileEvent_FunctionExecute	`UInt64`	1.25 MiB	15.98 MiB	12.74	2.10 million	7.98	Number of SQL ordinary function calls (SQL functions are called on per-block basis, so this number represents the number of blocks).
ProfileEvent_CompressedReadBufferBlocks	`UInt64`	1.19 MiB	15.98 MiB	13.41	2.10 million	7.98	Number of compressed blocks (the blocks of data that are compressed independent of each other) read from compressed sources (files, network).
ProfileEvent_OSWriteChars	`UInt64`	1.19 MiB	15.98 MiB	13.43	2.10 million	7.98	Number of bytes written to filesystem, including page cache.
ProfileEvent_WriteBufferFromFileDescriptorWrite	`UInt64`	1.10 MiB	15.98 MiB	14.55	2.10 million	7.98	Number of writes (write/pwrite) to a file descriptor. Does not include sockets.
ProfileEvent_WaitMarksLoadMicroseconds	`UInt64`	1.05 MiB	15.98 MiB	15.23	2.10 million	7.98	Time spent loading marks
ProfileEvent_OSWriteBytes	`UInt64`	1.04 MiB	15.98 MiB	15.39	2.10 million	7.98	Number of bytes written to disks or block devices. Doesn't include bytes that are in page cache dirty pages. May not include data that was written by OS asynchronously.
ProfileEvent_ReadBufferFromFileDescriptorRead	`UInt64`	1.03 MiB	15.98 MiB	15.53	2.10 million	7.98	Number of reads (read/pread) from a file descriptor. Does not include sockets.
ProfileEvent_MergeTreeDataWriterRows	`UInt64`	1.02 MiB	15.98 MiB	15.6	2.10 million	7.98	Number of rows INSERTed to MergeTree tables.
ProfileEvent_InsertedRows	`UInt64`	1.02 MiB	15.98 MiB	15.63	2.10 million	7.98	Number of rows INSERTed to all tables.
ProfileEvent_NetworkReceiveElapsedMicroseconds	`UInt64`	1019.40 KiB	15.98 MiB	16.05	2.10 million	7.98	Total time spent waiting for data to receive or receiving data from network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
CurrentMetric_PartsCompact	`Int64`	1003.28 KiB	15.98 MiB	16.31	2.10 million	7.98	Compact parts.
ProfileEvent_LogDebug	`UInt64`	969.20 KiB	15.98 MiB	16.89	2.10 million	7.98	Number of log messages with level Debug
ProfileEvent_MergeExecuteMilliseconds	`UInt64`	900.63 KiB	15.98 MiB	18.17	2.10 million	7.98	Total busy time spent for execution of background merges
ProfileEvent_MergeTotalMilliseconds	`UInt64`	895.93 KiB	15.98 MiB	18.27	2.10 million	7.98	Total time spent for background merges
ProfileEvent_MergeHorizontalStageExecuteMilliseconds	`UInt64`	881.02 KiB	15.98 MiB	18.58	2.10 million	7.98	Total busy time spent for execution of horizontal stage of background merges
ProfileEvent_OpenedFileCacheMicroseconds	`UInt64`	878.22 KiB	15.98 MiB	18.64	2.10 million	7.98	Amount of time spent executing OpenedFileCache methods.
ProfileEvent_MergeHorizontalStageTotalMilliseconds	`UInt64`	877.92 KiB	15.98 MiB	18.64	2.10 million	7.98	Total time spent for horizontal stage of background merges
ProfileEvent_OSCPUWaitMicroseconds	`UInt64`	837.77 KiB	15.98 MiB	19.54	2.10 million	7.98	Total time a thread was ready for execution but waiting to be scheduled by OS, from the OS point of view.
CurrentMetric_PartsOutdated	`Int64`	831.42 KiB	15.98 MiB	19.68	2.10 million	7.98	Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes.
ProfileEvent_NetworkSendElapsedMicroseconds	`UInt64`	828.35 KiB	15.98 MiB	19.76	2.10 million	7.98	Total time spent waiting for data to send to network or sending data to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_LoadedMarksMemoryBytes	`UInt64`	816.67 KiB	15.98 MiB	20.04	2.10 million	7.98	Size of in-memory representations of loaded marks.
ProfileEvent_Seek	`UInt64`	794.36 KiB	15.98 MiB	20.6	2.10 million	7.98	Number of times the 'lseek' function was called.
ProfileEvent_MemoryWorkerRun	`UInt64`	783.46 KiB	15.98 MiB	20.89	2.10 million	7.98	Number of runs done by MemoryWorker in background
CurrentMetric_Read	`Int64`	782.24 KiB	15.98 MiB	20.92	2.10 million	7.98	Number of read (read, pread, io_getevents, etc.) syscalls in fly
ProfileEvent_LoadedMarksCount	`UInt64`	763.90 KiB	15.98 MiB	21.42	2.10 million	7.98	Number of marks loaded (total across columns).
ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds	`UInt64`	753.92 KiB	15.98 MiB	21.71	2.10 million	7.98	Time spent merging input blocks (for special MergeTree engines)
ProfileEvent_CreatedReadBufferOrdinary	`UInt64`	746.70 KiB	15.98 MiB	21.92	2.10 million	7.98	Number of times ordinary read buffer was created for reading data (while choosing among other read methods).
ProfileEvent_OpenedFileCacheMisses	`UInt64`	739.28 KiB	15.98 MiB	22.14	2.10 million	7.98	Number of times a file has been found in the opened file cache, so we had to open it again.
ProfileEvent_ConcurrencyControlSlotsAcquired	`UInt64`	691.55 KiB	15.98 MiB	23.67	2.10 million	7.98	Total number of CPU slot acquired
ProfileEvent_ConcurrencyControlSlotsGranted	`UInt64`	691.55 KiB	15.98 MiB	23.67	2.10 million	7.98	Number of CPU slot granted according to guarantee of 1 thread per query and for queries with setting 'use_concurrency_control' = 0
CurrentMetric_PartsActive	`Int64`	647.43 KiB	15.98 MiB	25.28	2.10 million	7.98	Active data part, used by current and upcoming SELECTs.
CurrentMetric_PartsCommitted	`Int64`	647.43 KiB	15.98 MiB	25.28	2.10 million	7.98	Deprecated. See PartsActive.
ProfileEvent_InsertedCompactParts	`UInt64`	576.64 KiB	15.98 MiB	28.38	2.10 million	7.98	Number of parts inserted in Compact format.
ProfileEvent_MergeTreeDataWriterBlocks	`UInt64`	576.64 KiB	15.98 MiB	28.38	2.10 million	7.98	Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero.
ProfileEvent_MergedColumns	`UInt64`	564.97 KiB	15.98 MiB	28.97	2.10 million	7.98	Number of columns merged during the horizontal stage of merges.
ProfileEvent_CannotWriteToWriteBufferDiscard	`UInt64`	541.03 KiB	15.98 MiB	30.25	2.10 million	7.98	Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe.
ProfileEvent_MergingSortedMilliseconds	`UInt64`	540.07 KiB	15.98 MiB	30.3	2.10 million	7.98	Total time spent while merging sorted columns
ProfileEvent_QueryTimeMicroseconds	`UInt64`	538.59 KiB	10.02 MiB	19.04	2.10 million	5	Total time of all queries.
ProfileEvent_NetworkSendBytes	`UInt64`	537.96 KiB	15.98 MiB	30.42	2.10 million	7.98	Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
CurrentMetric_AsynchronousInsertThreads	`Int64`	534.95 KiB	15.98 MiB	30.59	2.10 million	7.98	Number of threads in the AsynchronousInsert thread pool.
CurrentMetric_AttachedDatabase	`Int64`	530.93 KiB	15.98 MiB	30.83	2.10 million	7.98	Active databases.
CurrentMetric_ThreadPoolFSReaderThreads	`Int64`	530.10 KiB	15.98 MiB	30.87	2.10 million	7.98	Number of threads in the thread pool for local_filesystem_read_method=threadpool.
CurrentMetric_BackgroundSchedulePoolSize	`Int64`	527.87 KiB	15.98 MiB	31	2.10 million	7.98	Limit on number of tasks in BackgroundSchedulePool. This pool is used for periodic ReplicatedMergeTree tasks, like cleaning old data parts, altering data parts, replica re-initialization, etc.
CurrentMetric_AttachedTable	`Int64`	527.15 KiB	15.98 MiB	31.05	2.10 million	7.98	Active tables.
CurrentMetric_BackgroundMergesAndMutationsPoolSize	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Limit on number of active merges and mutations in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreadsActive	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool running a task.
CurrentMetric_MergeTreeBackgroundExecutorThreads	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled	`Int64`	527.13 KiB	15.98 MiB	31.05	2.10 million	7.98	Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_ConcurrencyControlSoftLimit	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Value of soft limit on number of CPU slots
CurrentMetric_BackgroundDistributedSchedulePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundDistributedSchedulePool
CurrentMetric_BackgroundBufferFlushSchedulePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundBufferFlushSchedulePool
CurrentMetric_BackgroundMessageBrokerSchedulePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundMessageBrokerSchedulePool for message streaming
CurrentMetric_BackgroundFetchesPoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of simultaneous fetches in an associated background pool
CurrentMetric_BackgroundMovePoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in BackgroundProcessingPool for moves
CurrentMetric_BackgroundCommonPoolSize	`Int64`	526.88 KiB	15.98 MiB	31.06	2.10 million	7.98	Limit on number of tasks in an associated background pool
CurrentMetric_AddressesActive	`Int64`	526.38 KiB	15.98 MiB	31.09	2.10 million	7.98	Total count of addresses which are used for creation connections with connection pools
CurrentMetric_ZooKeeperSession	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of sessions (connections) to ZooKeeper. Should be no more than one, because using more than one connection to ZooKeeper may lead to bugs due to lack of linearizability (stale reads) that ZooKeeper consistency model allows.
CurrentMetric_ZooKeeperWatch	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of watches (event subscriptions) in ZooKeeper.
CurrentMetric_EphemeralNode	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of ephemeral nodes hold in ZooKeeper.
CurrentMetric_AttachedView	`Int64`	526.15 KiB	15.98 MiB	31.11	2.10 million	7.98	Active views.
CurrentMetric_DiskConnectionsStored	`Int64`	526.13 KiB	15.98 MiB	31.11	2.10 million	7.98	Total count of sessions stored in the session pool for disks
CurrentMetric_IOWriterThreads	`Int64`	526.13 KiB	15.98 MiB	31.11	2.10 million	7.98	Number of threads in the IO writer thread pool.

0 of 1118 row(s) selected.

Rows per page

Page 1 of 12