ClickHouse MonitoringMonitoring

Table: system.metric_log_1


event_time_microseconds	`DateTime64(6)`	10.77 MiB	21.44 MiB	1.99	2.82 million	7.98	Event time with microseconds resolution.
event_time	`DateTime`	7.43 MiB	10.72 MiB	1.44	2.82 million	3.99	Event time.
ProfileEvent_DiskReadElapsedMicroseconds	`UInt64`	5.33 MiB	21.44 MiB	4.02	2.82 million	7.98	Total time spent waiting for read syscall. This include reads from page cache.
ProfileEvent_ReadBufferFromFileDescriptorReadBytes	`UInt64`	5.22 MiB	21.44 MiB	4.1	2.82 million	7.98	Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size.
CurrentMetric_MemoryTracking	`Int64`	5.10 MiB	21.44 MiB	4.21	2.82 million	7.98	Total amount of memory (bytes) allocated by the server.
ProfileEvent_PartsLockHoldMicroseconds	`UInt64`	4.60 MiB	21.44 MiB	4.66	2.82 million	7.98	Total time spent holding data parts lock in MergeTree tables
ProfileEvent_PartsLockWaitMicroseconds	`UInt64`	4.03 MiB	21.44 MiB	5.32	2.82 million	7.98	Total time spent waiting for data parts lock in MergeTree tables
ProfileEvent_WriteBufferFromFileDescriptorWriteBytes	`UInt64`	3.11 MiB	21.44 MiB	6.89	2.82 million	7.98	Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size.
ProfileEvent_ContextLockWaitMicroseconds	`UInt64`	2.93 MiB	21.44 MiB	7.32	2.82 million	7.98	Context lock wait time in microseconds
ProfileEvent_ContextLock	`UInt64`	2.82 MiB	21.44 MiB	7.61	2.82 million	7.98	Number of times the lock of Context was acquired or tried to acquire. This is global lock.
ProfileEvent_IOBufferAllocBytes	`UInt64`	2.67 MiB	21.44 MiB	8.02	2.82 million	7.98	Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_DiskWriteElapsedMicroseconds	`UInt64`	2.25 MiB	21.44 MiB	9.52	2.82 million	7.98	Total time spent waiting for write syscall. This include writes to page cache.
ProfileEvent_CompressedReadBufferBytes	`UInt64`	2.12 MiB	21.44 MiB	10.11	2.82 million	7.98	Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network).
CurrentMetric_PartsOutdated	`Int64`	2.10 MiB	21.44 MiB	10.19	2.82 million	7.98	Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes.
ProfileEvent_MergeTreeDataWriterCompressedBytes	`UInt64`	2.09 MiB	21.44 MiB	10.27	2.82 million	7.98	Bytes written to filesystem for data INSERTed to MergeTree tables.
ProfileEvent_RWLockAcquiredReadLocks	`UInt64`	2.07 MiB	21.44 MiB	10.36	2.82 million	7.98	Number of times a read lock was acquired (in a heavy RWLock).
ProfileEvent_MergedUncompressedBytes	`UInt64`	2.06 MiB	21.44 MiB	10.43	2.82 million	7.98	Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge.
CurrentMetric_PartsActive	`Int64`	2.00 MiB	21.44 MiB	10.71	2.82 million	7.98	Active data part, used by current and upcoming SELECTs.
CurrentMetric_PartsCommitted	`Int64`	2.00 MiB	21.44 MiB	10.71	2.82 million	7.98	Deprecated. See PartsActive.
CurrentMetric_PartsWide	`Int64`	1.98 MiB	21.44 MiB	10.83	2.82 million	7.98	Wide parts.
ProfileEvent_RealTimeMicroseconds	`UInt64`	1.93 MiB	21.44 MiB	11.14	2.82 million	7.98	Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum).
ProfileEvent_ReadCompressedBytes	`UInt64`	1.92 MiB	21.44 MiB	11.15	2.82 million	7.98	Number of bytes (the number of bytes before decompression) read from compressed sources (files, network).
ProfileEvent_OSCPUVirtualTimeMicroseconds	`UInt64`	1.92 MiB	21.44 MiB	11.17	2.82 million	7.98	CPU time spent seen by OS. Does not include involuntary waits due to virtualization.
ProfileEvent_UserTimeMicroseconds	`UInt64`	1.91 MiB	21.44 MiB	11.25	2.82 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_LogTrace	`UInt64`	1.86 MiB	21.44 MiB	11.53	2.82 million	7.98	Number of log messages with level Trace
ProfileEvent_MergedRows	`UInt64`	1.80 MiB	21.44 MiB	11.9	2.82 million	7.98	Rows read for background merges. This is the number of rows before merge.
ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds	`UInt64`	1.67 MiB	21.44 MiB	12.83	2.82 million	7.98	Time spent sorting blocks
ProfileEvent_SystemTimeMicroseconds	`UInt64`	1.67 MiB	21.44 MiB	12.85	2.82 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_IOBufferAllocs	`UInt64`	1.57 MiB	21.44 MiB	13.63	2.82 million	7.98	Number of allocations of IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_SoftPageFaults	`UInt64`	1.57 MiB	21.44 MiB	13.65	2.82 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.
CurrentMetric_PartsCompact	`Int64`	1.38 MiB	21.44 MiB	15.54	2.82 million	7.98	Compact parts.
ProfileEvent_ReadBufferFromFileDescriptorRead	`UInt64`	1.35 MiB	21.44 MiB	15.86	2.82 million	7.98	Number of reads (read/pread) from a file descriptor. Does not include sockets.
ProfileEvent_FileOpen	`UInt64`	1.26 MiB	21.44 MiB	17.07	2.82 million	7.98	Number of files opened.
ProfileEvent_GWPAsanFree	`UInt64`	1.21 MiB	21.44 MiB	17.67	2.82 million	7.98	Number of free operations done by GWPAsan
ProfileEvent_LogDebug	`UInt64`	1.19 MiB	21.44 MiB	18.07	2.82 million	7.98	Number of log messages with level Debug
ProfileEvent_GWPAsanAllocateSuccess	`UInt64`	1.18 MiB	21.44 MiB	18.17	2.82 million	7.98	Number of successful allocations done by GWPAsan
ProfileEvent_WriteBufferFromFileDescriptorWrite	`UInt64`	1.18 MiB	21.44 MiB	18.19	2.82 million	7.98	Number of writes (write/pwrite) to a file descriptor. Does not include sockets.
ProfileEvent_OSReadChars	`UInt64`	1.15 MiB	21.44 MiB	18.61	2.82 million	7.98	Number of bytes read from filesystem, including page cache.
ProfileEvent_CompressedReadBufferBlocks	`UInt64`	1.11 MiB	21.44 MiB	19.28	2.82 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.10 MiB	21.44 MiB	19.53	2.82 million	7.98	Number of bytes written to filesystem, including page cache.
ProfileEvent_MergesTimeMilliseconds	`UInt64`	1.06 MiB	21.44 MiB	20.27	2.82 million	7.98	Total time spent for background merges.
ProfileEvent_WaitMarksLoadMicroseconds	`UInt64`	1.03 MiB	21.44 MiB	20.89	2.82 million	7.98	Time spent loading marks
ProfileEvent_Merge	`UInt64`	1015.75 KiB	21.44 MiB	21.62	2.82 million	7.98	Number of launched background merges.
ProfileEvent_OSWriteBytes	`UInt64`	998.34 KiB	21.44 MiB	21.99	2.82 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_MergeTreeDataWriterMergingBlocksMicroseconds	`UInt64`	994.26 KiB	21.44 MiB	22.08	2.82 million	7.98	Time spent merging input blocks (for special MergeTree engines)
ProfileEvent_FunctionExecute	`UInt64`	896.96 KiB	21.44 MiB	24.48	2.82 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).
CurrentMetric_Read	`Int64`	892.31 KiB	21.44 MiB	24.61	2.82 million	7.98	Number of read (read, pread, io_getevents, etc.) syscalls in fly
ProfileEvent_MergeTreeDataWriterBlocks	`UInt64`	884.82 KiB	21.44 MiB	24.82	2.82 million	7.98	Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero.
ProfileEvent_InsertedCompactParts	`UInt64`	884.72 KiB	21.44 MiB	24.82	2.82 million	7.98	Number of parts inserted in Compact format.
ProfileEvent_OpenedFileCacheMicroseconds	`UInt64`	878.32 KiB	21.44 MiB	25	2.82 million	7.98	Amount of time spent executing OpenedFileCache methods.
ProfileEvent_SelectedRows	`UInt64`	873.34 KiB	21.44 MiB	25.14	2.82 million	7.98	Number of rows SELECTed from all tables.
ProfileEvent_SelectedBytes	`UInt64`	856.98 KiB	21.44 MiB	25.62	2.82 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables.
ProfileEvent_MergeTreeDataWriterUncompressedBytes	`UInt64`	821.06 KiB	21.44 MiB	26.74	2.82 million	7.98	Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables.
ProfileEvent_MergeTreeDataWriterRows	`UInt64`	819.25 KiB	21.44 MiB	26.8	2.82 million	7.98	Number of rows INSERTed to MergeTree tables.
ProfileEvent_InsertedRows	`UInt64`	804.54 KiB	21.44 MiB	27.29	2.82 million	7.98	Number of rows INSERTed to all tables.
ProfileEvent_InsertedBytes	`UInt64`	803.44 KiB	21.44 MiB	27.33	2.82 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables.
CurrentMetric_AttachedDatabase	`Int64`	696.84 KiB	21.44 MiB	31.51	2.82 million	7.98	Active database, used by current and upcoming SELECTs.
ProfileEvent_LoadedMarksMemoryBytes	`UInt64`	690.38 KiB	21.44 MiB	31.81	2.82 million	7.98	Size of in-memory representations of loaded marks.
ProfileEvent_NetworkReceiveElapsedMicroseconds	`UInt64`	686.24 KiB	19.80 MiB	29.54	2.82 million	7.37	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_AttachedTable	`Int64`	665.72 KiB	21.44 MiB	32.98	2.82 million	7.98	Active table, used by current and upcoming SELECTs.
CurrentMetric_BackgroundSchedulePoolSize	`Int64`	659.60 KiB	21.44 MiB	33.29	2.82 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_AttachedView	`Int64`	658.67 KiB	21.44 MiB	33.34	2.82 million	7.98	Active view, used by current and upcoming SELECTs.
CurrentMetric_BackgroundMergesAndMutationsPoolSize	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Limit on number of active merges and mutations in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreads	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_MergeTreeBackgroundExecutorThreadsActive	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool running a task.
CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_BackgroundDistributedSchedulePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundDistributedSchedulePool
CurrentMetric_BackgroundCommonPoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in an associated background pool
CurrentMetric_BackgroundMessageBrokerSchedulePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundProcessingPool for message streaming
CurrentMetric_BackgroundBufferFlushSchedulePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundBufferFlushSchedulePool
CurrentMetric_BackgroundMovePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundProcessingPool for moves
CurrentMetric_BackgroundFetchesPoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of simultaneous fetches in an associated background pool
ProfileEvent_LoadedMarksCount	`UInt64`	657.77 KiB	21.44 MiB	33.38	2.82 million	7.98	Number of marks loaded (total across columns).
CurrentMetric_MMappedFiles	`Int64`	657.44 KiB	21.44 MiB	33.4	2.82 million	7.98	Total number of mmapped files.
CurrentMetric_ThreadPoolFSReaderThreads	`Int64`	654.65 KiB	21.44 MiB	33.54	2.82 million	7.98	Number of threads in the thread pool for local_filesystem_read_method=threadpool.
ProfileEvent_CreatedReadBufferOrdinary	`UInt64`	620.97 KiB	21.44 MiB	35.36	2.82 million	7.98	Number of times ordinary read buffer was created for reading data (while choosing among other read methods).
ProfileEvent_OpenedFileCacheMisses	`UInt64`	618.17 KiB	21.44 MiB	35.52	2.82 million	7.98	Number of times a file has been found in the opened file cache, so we had to open it again.
CurrentMetric_ZooKeeperSession	`Int64`	609.31 KiB	19.74 MiB	33.17	2.82 million	7.34	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`	609.29 KiB	19.74 MiB	33.17	2.82 million	7.34	Number of watches (event subscriptions) in ZooKeeper.
CurrentMetric_IOWriterThreads	`Int64`	606.79 KiB	19.74 MiB	33.3	2.82 million	7.34	Number of threads in the IO writer thread pool.
CurrentMetric_AddressesActive	`Int64`	606.21 KiB	19.84 MiB	33.51	2.82 million	7.38	Total count of addresses which are used for creation connections with connection pools
CurrentMetric_DiskConnectionsTotal	`Int64`	605.69 KiB	19.74 MiB	33.36	2.82 million	7.34	Total count of all sessions: stored in the pool and actively used right now for disks
CurrentMetric_DiskConnectionsStored	`Int64`	605.47 KiB	19.74 MiB	33.38	2.82 million	7.34	Total count of sessions stored in the session pool for disks
CurrentMetric_AsynchronousInsertThreads	`Int64`	575.76 KiB	19.74 MiB	35.1	2.82 million	7.34	Number of threads in the AsynchronousInsert thread pool.
ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted	`UInt64`	570.63 KiB	21.44 MiB	38.48	2.82 million	7.98	Number of blocks INSERTed to MergeTree tables that appeared to be already sorted.
ProfileEvent_OSCPUWaitMicroseconds	`UInt64`	551.38 KiB	21.44 MiB	39.82	2.82 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_OpenFileForRead	`Int64`	537.85 KiB	21.44 MiB	40.83	2.82 million	7.98	Number of files open for reading
ProfileEvent_NetworkSendElapsedMicroseconds	`UInt64`	487.70 KiB	19.77 MiB	41.51	2.82 million	7.36	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.
CurrentMetric_MergesMutationsMemoryTracking	`Int64`	422.66 KiB	7.00 MiB	16.95	2.82 million	2.6	Total amount of memory (bytes) allocated by background tasks (merges and mutations).
ProfileEvent_CannotWriteToWriteBufferDiscard	`UInt64`	399.30 KiB	19.74 MiB	50.61	2.82 million	7.34	Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe.
ProfileEvent_MergedIntoWideParts	`UInt64`	333.78 KiB	21.44 MiB	65.78	2.82 million	7.98	Number of parts merged into Wide format.
CurrentMetric_DiskSpaceReservedForMerge	`Int64`	326.12 KiB	1.06 MiB	3.32	2.82 million	0.39	Disk space reserved for currently running background merges. It is slightly more than the total size of currently merging parts.
ProfileEvent_NetworkReceiveBytes	`UInt64`	285.01 KiB	19.77 MiB	71.02	2.82 million	7.36	Total number of bytes received from network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_NetworkSendBytes	`UInt64`	236.22 KiB	19.77 MiB	85.7	2.82 million	7.36	Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_ZooKeeperBytesReceived	`UInt64`	230.95 KiB	19.74 MiB	87.5	2.82 million	7.34	Number of bytes received over network while communicating with ZooKeeper.
ProfileEvent_ZooKeeperBytesSent	`UInt64`	230.78 KiB	19.74 MiB	87.57	2.82 million	7.34	Number of bytes send over network while communicating with ZooKeeper.
ProfileEvent_Seek	`UInt64`	194.40 KiB	21.44 MiB	112.95	2.82 million	7.98	Number of times the 'lseek' function was called.
ProfileEvent_MergedIntoCompactParts	`UInt64`	127.86 KiB	2.28 MiB	18.22	2.82 million	0.85	Number of parts merged into Compact format.
ProfileEvent_GWPAsanAllocateFailed	`UInt64`	117.32 KiB	865.56 KiB	7.38	2.82 million	0.31	Number of failed allocations done by GWPAsan (i.e. filled pool)
CurrentMetric_RWLockActiveReaders	`Int64`	115.68 KiB	2.13 MiB	18.82	2.82 million	0.79	Number of threads holding read lock in a table RWLock.

0 of 946 row(s) selected.

Rows per page

Page 1 of 10

Table: system.metric_log_1


event_time_microseconds	`DateTime64(6)`	10.77 MiB	21.44 MiB	1.99	2.82 million	7.98	Event time with microseconds resolution.
event_time	`DateTime`	7.43 MiB	10.72 MiB	1.44	2.82 million	3.99	Event time.
ProfileEvent_DiskReadElapsedMicroseconds	`UInt64`	5.33 MiB	21.44 MiB	4.02	2.82 million	7.98	Total time spent waiting for read syscall. This include reads from page cache.
ProfileEvent_ReadBufferFromFileDescriptorReadBytes	`UInt64`	5.22 MiB	21.44 MiB	4.1	2.82 million	7.98	Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size.
CurrentMetric_MemoryTracking	`Int64`	5.10 MiB	21.44 MiB	4.21	2.82 million	7.98	Total amount of memory (bytes) allocated by the server.
ProfileEvent_PartsLockHoldMicroseconds	`UInt64`	4.60 MiB	21.44 MiB	4.66	2.82 million	7.98	Total time spent holding data parts lock in MergeTree tables
ProfileEvent_PartsLockWaitMicroseconds	`UInt64`	4.03 MiB	21.44 MiB	5.32	2.82 million	7.98	Total time spent waiting for data parts lock in MergeTree tables
ProfileEvent_WriteBufferFromFileDescriptorWriteBytes	`UInt64`	3.11 MiB	21.44 MiB	6.89	2.82 million	7.98	Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size.
ProfileEvent_ContextLockWaitMicroseconds	`UInt64`	2.93 MiB	21.44 MiB	7.32	2.82 million	7.98	Context lock wait time in microseconds
ProfileEvent_ContextLock	`UInt64`	2.82 MiB	21.44 MiB	7.61	2.82 million	7.98	Number of times the lock of Context was acquired or tried to acquire. This is global lock.
ProfileEvent_IOBufferAllocBytes	`UInt64`	2.67 MiB	21.44 MiB	8.02	2.82 million	7.98	Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_DiskWriteElapsedMicroseconds	`UInt64`	2.25 MiB	21.44 MiB	9.52	2.82 million	7.98	Total time spent waiting for write syscall. This include writes to page cache.
ProfileEvent_CompressedReadBufferBytes	`UInt64`	2.12 MiB	21.44 MiB	10.11	2.82 million	7.98	Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network).
CurrentMetric_PartsOutdated	`Int64`	2.10 MiB	21.44 MiB	10.19	2.82 million	7.98	Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes.
ProfileEvent_MergeTreeDataWriterCompressedBytes	`UInt64`	2.09 MiB	21.44 MiB	10.27	2.82 million	7.98	Bytes written to filesystem for data INSERTed to MergeTree tables.
ProfileEvent_RWLockAcquiredReadLocks	`UInt64`	2.07 MiB	21.44 MiB	10.36	2.82 million	7.98	Number of times a read lock was acquired (in a heavy RWLock).
ProfileEvent_MergedUncompressedBytes	`UInt64`	2.06 MiB	21.44 MiB	10.43	2.82 million	7.98	Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge.
CurrentMetric_PartsActive	`Int64`	2.00 MiB	21.44 MiB	10.71	2.82 million	7.98	Active data part, used by current and upcoming SELECTs.
CurrentMetric_PartsCommitted	`Int64`	2.00 MiB	21.44 MiB	10.71	2.82 million	7.98	Deprecated. See PartsActive.
CurrentMetric_PartsWide	`Int64`	1.98 MiB	21.44 MiB	10.83	2.82 million	7.98	Wide parts.
ProfileEvent_RealTimeMicroseconds	`UInt64`	1.93 MiB	21.44 MiB	11.14	2.82 million	7.98	Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum).
ProfileEvent_ReadCompressedBytes	`UInt64`	1.92 MiB	21.44 MiB	11.15	2.82 million	7.98	Number of bytes (the number of bytes before decompression) read from compressed sources (files, network).
ProfileEvent_OSCPUVirtualTimeMicroseconds	`UInt64`	1.92 MiB	21.44 MiB	11.17	2.82 million	7.98	CPU time spent seen by OS. Does not include involuntary waits due to virtualization.
ProfileEvent_UserTimeMicroseconds	`UInt64`	1.91 MiB	21.44 MiB	11.25	2.82 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_LogTrace	`UInt64`	1.86 MiB	21.44 MiB	11.53	2.82 million	7.98	Number of log messages with level Trace
ProfileEvent_MergedRows	`UInt64`	1.80 MiB	21.44 MiB	11.9	2.82 million	7.98	Rows read for background merges. This is the number of rows before merge.
ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds	`UInt64`	1.67 MiB	21.44 MiB	12.83	2.82 million	7.98	Time spent sorting blocks
ProfileEvent_SystemTimeMicroseconds	`UInt64`	1.67 MiB	21.44 MiB	12.85	2.82 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_IOBufferAllocs	`UInt64`	1.57 MiB	21.44 MiB	13.63	2.82 million	7.98	Number of allocations of IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_SoftPageFaults	`UInt64`	1.57 MiB	21.44 MiB	13.65	2.82 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.
CurrentMetric_PartsCompact	`Int64`	1.38 MiB	21.44 MiB	15.54	2.82 million	7.98	Compact parts.
ProfileEvent_ReadBufferFromFileDescriptorRead	`UInt64`	1.35 MiB	21.44 MiB	15.86	2.82 million	7.98	Number of reads (read/pread) from a file descriptor. Does not include sockets.
ProfileEvent_FileOpen	`UInt64`	1.26 MiB	21.44 MiB	17.07	2.82 million	7.98	Number of files opened.
ProfileEvent_GWPAsanFree	`UInt64`	1.21 MiB	21.44 MiB	17.67	2.82 million	7.98	Number of free operations done by GWPAsan
ProfileEvent_LogDebug	`UInt64`	1.19 MiB	21.44 MiB	18.07	2.82 million	7.98	Number of log messages with level Debug
ProfileEvent_GWPAsanAllocateSuccess	`UInt64`	1.18 MiB	21.44 MiB	18.17	2.82 million	7.98	Number of successful allocations done by GWPAsan
ProfileEvent_WriteBufferFromFileDescriptorWrite	`UInt64`	1.18 MiB	21.44 MiB	18.19	2.82 million	7.98	Number of writes (write/pwrite) to a file descriptor. Does not include sockets.
ProfileEvent_OSReadChars	`UInt64`	1.15 MiB	21.44 MiB	18.61	2.82 million	7.98	Number of bytes read from filesystem, including page cache.
ProfileEvent_CompressedReadBufferBlocks	`UInt64`	1.11 MiB	21.44 MiB	19.28	2.82 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.10 MiB	21.44 MiB	19.53	2.82 million	7.98	Number of bytes written to filesystem, including page cache.
ProfileEvent_MergesTimeMilliseconds	`UInt64`	1.06 MiB	21.44 MiB	20.27	2.82 million	7.98	Total time spent for background merges.
ProfileEvent_WaitMarksLoadMicroseconds	`UInt64`	1.03 MiB	21.44 MiB	20.89	2.82 million	7.98	Time spent loading marks
ProfileEvent_Merge	`UInt64`	1015.75 KiB	21.44 MiB	21.62	2.82 million	7.98	Number of launched background merges.
ProfileEvent_OSWriteBytes	`UInt64`	998.34 KiB	21.44 MiB	21.99	2.82 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_MergeTreeDataWriterMergingBlocksMicroseconds	`UInt64`	994.26 KiB	21.44 MiB	22.08	2.82 million	7.98	Time spent merging input blocks (for special MergeTree engines)
ProfileEvent_FunctionExecute	`UInt64`	896.96 KiB	21.44 MiB	24.48	2.82 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).
CurrentMetric_Read	`Int64`	892.31 KiB	21.44 MiB	24.61	2.82 million	7.98	Number of read (read, pread, io_getevents, etc.) syscalls in fly
ProfileEvent_MergeTreeDataWriterBlocks	`UInt64`	884.82 KiB	21.44 MiB	24.82	2.82 million	7.98	Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero.
ProfileEvent_InsertedCompactParts	`UInt64`	884.72 KiB	21.44 MiB	24.82	2.82 million	7.98	Number of parts inserted in Compact format.
ProfileEvent_OpenedFileCacheMicroseconds	`UInt64`	878.32 KiB	21.44 MiB	25	2.82 million	7.98	Amount of time spent executing OpenedFileCache methods.
ProfileEvent_SelectedRows	`UInt64`	873.34 KiB	21.44 MiB	25.14	2.82 million	7.98	Number of rows SELECTed from all tables.
ProfileEvent_SelectedBytes	`UInt64`	856.98 KiB	21.44 MiB	25.62	2.82 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables.
ProfileEvent_MergeTreeDataWriterUncompressedBytes	`UInt64`	821.06 KiB	21.44 MiB	26.74	2.82 million	7.98	Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables.
ProfileEvent_MergeTreeDataWriterRows	`UInt64`	819.25 KiB	21.44 MiB	26.8	2.82 million	7.98	Number of rows INSERTed to MergeTree tables.
ProfileEvent_InsertedRows	`UInt64`	804.54 KiB	21.44 MiB	27.29	2.82 million	7.98	Number of rows INSERTed to all tables.
ProfileEvent_InsertedBytes	`UInt64`	803.44 KiB	21.44 MiB	27.33	2.82 million	7.98	Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables.
CurrentMetric_AttachedDatabase	`Int64`	696.84 KiB	21.44 MiB	31.51	2.82 million	7.98	Active database, used by current and upcoming SELECTs.
ProfileEvent_LoadedMarksMemoryBytes	`UInt64`	690.38 KiB	21.44 MiB	31.81	2.82 million	7.98	Size of in-memory representations of loaded marks.
ProfileEvent_NetworkReceiveElapsedMicroseconds	`UInt64`	686.24 KiB	19.80 MiB	29.54	2.82 million	7.37	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_AttachedTable	`Int64`	665.72 KiB	21.44 MiB	32.98	2.82 million	7.98	Active table, used by current and upcoming SELECTs.
CurrentMetric_BackgroundSchedulePoolSize	`Int64`	659.60 KiB	21.44 MiB	33.29	2.82 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_AttachedView	`Int64`	658.67 KiB	21.44 MiB	33.34	2.82 million	7.98	Active view, used by current and upcoming SELECTs.
CurrentMetric_BackgroundMergesAndMutationsPoolSize	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Limit on number of active merges and mutations in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreads	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_MergeTreeBackgroundExecutorThreadsActive	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Number of threads in the MergeTreeBackgroundExecutor thread pool running a task.
CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled	`Int64`	658.65 KiB	21.44 MiB	33.34	2.82 million	7.98	Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_BackgroundDistributedSchedulePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundDistributedSchedulePool
CurrentMetric_BackgroundCommonPoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in an associated background pool
CurrentMetric_BackgroundMessageBrokerSchedulePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundProcessingPool for message streaming
CurrentMetric_BackgroundBufferFlushSchedulePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundBufferFlushSchedulePool
CurrentMetric_BackgroundMovePoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of tasks in BackgroundProcessingPool for moves
CurrentMetric_BackgroundFetchesPoolSize	`Int64`	658.35 KiB	21.44 MiB	33.35	2.82 million	7.98	Limit on number of simultaneous fetches in an associated background pool
ProfileEvent_LoadedMarksCount	`UInt64`	657.77 KiB	21.44 MiB	33.38	2.82 million	7.98	Number of marks loaded (total across columns).
CurrentMetric_MMappedFiles	`Int64`	657.44 KiB	21.44 MiB	33.4	2.82 million	7.98	Total number of mmapped files.
CurrentMetric_ThreadPoolFSReaderThreads	`Int64`	654.65 KiB	21.44 MiB	33.54	2.82 million	7.98	Number of threads in the thread pool for local_filesystem_read_method=threadpool.
ProfileEvent_CreatedReadBufferOrdinary	`UInt64`	620.97 KiB	21.44 MiB	35.36	2.82 million	7.98	Number of times ordinary read buffer was created for reading data (while choosing among other read methods).
ProfileEvent_OpenedFileCacheMisses	`UInt64`	618.17 KiB	21.44 MiB	35.52	2.82 million	7.98	Number of times a file has been found in the opened file cache, so we had to open it again.
CurrentMetric_ZooKeeperSession	`Int64`	609.31 KiB	19.74 MiB	33.17	2.82 million	7.34	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`	609.29 KiB	19.74 MiB	33.17	2.82 million	7.34	Number of watches (event subscriptions) in ZooKeeper.
CurrentMetric_IOWriterThreads	`Int64`	606.79 KiB	19.74 MiB	33.3	2.82 million	7.34	Number of threads in the IO writer thread pool.
CurrentMetric_AddressesActive	`Int64`	606.21 KiB	19.84 MiB	33.51	2.82 million	7.38	Total count of addresses which are used for creation connections with connection pools
CurrentMetric_DiskConnectionsTotal	`Int64`	605.69 KiB	19.74 MiB	33.36	2.82 million	7.34	Total count of all sessions: stored in the pool and actively used right now for disks
CurrentMetric_DiskConnectionsStored	`Int64`	605.47 KiB	19.74 MiB	33.38	2.82 million	7.34	Total count of sessions stored in the session pool for disks
CurrentMetric_AsynchronousInsertThreads	`Int64`	575.76 KiB	19.74 MiB	35.1	2.82 million	7.34	Number of threads in the AsynchronousInsert thread pool.
ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted	`UInt64`	570.63 KiB	21.44 MiB	38.48	2.82 million	7.98	Number of blocks INSERTed to MergeTree tables that appeared to be already sorted.
ProfileEvent_OSCPUWaitMicroseconds	`UInt64`	551.38 KiB	21.44 MiB	39.82	2.82 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_OpenFileForRead	`Int64`	537.85 KiB	21.44 MiB	40.83	2.82 million	7.98	Number of files open for reading
ProfileEvent_NetworkSendElapsedMicroseconds	`UInt64`	487.70 KiB	19.77 MiB	41.51	2.82 million	7.36	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.
CurrentMetric_MergesMutationsMemoryTracking	`Int64`	422.66 KiB	7.00 MiB	16.95	2.82 million	2.6	Total amount of memory (bytes) allocated by background tasks (merges and mutations).
ProfileEvent_CannotWriteToWriteBufferDiscard	`UInt64`	399.30 KiB	19.74 MiB	50.61	2.82 million	7.34	Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe.
ProfileEvent_MergedIntoWideParts	`UInt64`	333.78 KiB	21.44 MiB	65.78	2.82 million	7.98	Number of parts merged into Wide format.
CurrentMetric_DiskSpaceReservedForMerge	`Int64`	326.12 KiB	1.06 MiB	3.32	2.82 million	0.39	Disk space reserved for currently running background merges. It is slightly more than the total size of currently merging parts.
ProfileEvent_NetworkReceiveBytes	`UInt64`	285.01 KiB	19.77 MiB	71.02	2.82 million	7.36	Total number of bytes received from network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_NetworkSendBytes	`UInt64`	236.22 KiB	19.77 MiB	85.7	2.82 million	7.36	Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_ZooKeeperBytesReceived	`UInt64`	230.95 KiB	19.74 MiB	87.5	2.82 million	7.34	Number of bytes received over network while communicating with ZooKeeper.
ProfileEvent_ZooKeeperBytesSent	`UInt64`	230.78 KiB	19.74 MiB	87.57	2.82 million	7.34	Number of bytes send over network while communicating with ZooKeeper.
ProfileEvent_Seek	`UInt64`	194.40 KiB	21.44 MiB	112.95	2.82 million	7.98	Number of times the 'lseek' function was called.
ProfileEvent_MergedIntoCompactParts	`UInt64`	127.86 KiB	2.28 MiB	18.22	2.82 million	0.85	Number of parts merged into Compact format.
ProfileEvent_GWPAsanAllocateFailed	`UInt64`	117.32 KiB	865.56 KiB	7.38	2.82 million	0.31	Number of failed allocations done by GWPAsan (i.e. filled pool)
CurrentMetric_RWLockActiveReaders	`Int64`	115.68 KiB	2.13 MiB	18.82	2.82 million	0.79	Number of threads holding read lock in a table RWLock.

0 of 946 row(s) selected.

Rows per page

Page 1 of 10