ClickHouse MonitoringMonitoring

Table: system.metric_log_0


event_time_microseconds	`DateTime64(6)`	1.50 MiB	1.97 MiB	1.31	267.16 thousand	7.73	Event time with microseconds resolution.
ProfileEvent_DiskReadElapsedMicroseconds	`UInt64`	1.00 MiB	1.97 MiB	1.97	267.16 thousand	7.73	Total time spent waiting for read syscall. This include reads from page cache.
event_time	`DateTime`	1012.53 KiB	1008.17 KiB	1	267.16 thousand	3.86	Event time.
CurrentMetric_MemoryTracking	`Int64`	834.96 KiB	1.97 MiB	2.41	267.16 thousand	7.73	Total amount of memory (bytes) allocated by the server.
ProfileEvent_ReadBufferFromFileDescriptorReadBytes	`UInt64`	815.98 KiB	1.97 MiB	2.47	267.16 thousand	7.73	Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size.
ProfileEvent_PartsLockHoldMicroseconds	`UInt64`	795.97 KiB	1.97 MiB	2.53	267.16 thousand	7.73	Total time spent holding data parts lock in MergeTree tables
ProfileEvent_ContextLock	`UInt64`	708.70 KiB	1.97 MiB	2.85	267.16 thousand	7.73	Number of times the lock of Context was acquired or tried to acquire. This is global lock.
ProfileEvent_RWLockAcquiredReadLocks	`UInt64`	643.88 KiB	1.97 MiB	3.13	267.16 thousand	7.73	Number of times a read lock was acquired (in a heavy RWLock).
ProfileEvent_WriteBufferFromFileDescriptorWriteBytes	`UInt64`	537.46 KiB	1.97 MiB	3.75	267.16 thousand	7.73	Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size.
ProfileEvent_LogTrace	`UInt64`	537.33 KiB	1.97 MiB	3.75	267.16 thousand	7.73	Number of log messages with level Trace
ProfileEvent_IOBufferAllocBytes	`UInt64`	490.51 KiB	1.97 MiB	4.11	267.16 thousand	7.73	Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer).
CurrentMetric_PartsCompact	`Int64`	467.72 KiB	1.97 MiB	4.31	267.16 thousand	7.73	Compact parts.
ProfileEvent_DiskWriteElapsedMicroseconds	`UInt64`	457.16 KiB	1.97 MiB	4.41	267.16 thousand	7.73	Total time spent waiting for write syscall. This include writes to page cache.
ProfileEvent_MergeTreeDataWriterCompressedBytes	`UInt64`	444.72 KiB	1.97 MiB	4.53	267.16 thousand	7.73	Bytes written to filesystem for data INSERTed to MergeTree tables.
ProfileEvent_IOBufferAllocs	`UInt64`	392.69 KiB	1.97 MiB	5.13	267.16 thousand	7.73	Number of allocations of IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_LogDebug	`UInt64`	389.02 KiB	1.97 MiB	5.18	267.16 thousand	7.73	Number of log messages with level Debug
ProfileEvent_SelectedBytes	`UInt64`	382.17 KiB	1.97 MiB	5.28	267.16 thousand	7.73	Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables.
ProfileEvent_MergeTreeDataWriterUncompressedBytes	`UInt64`	382.02 KiB	1.97 MiB	5.28	267.16 thousand	7.73	Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables.
ProfileEvent_InsertedBytes	`UInt64`	381.37 KiB	1.97 MiB	5.29	267.16 thousand	7.73	Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables.
ProfileEvent_CompressedReadBufferBytes	`UInt64`	380.26 KiB	1.97 MiB	5.3	267.16 thousand	7.73	Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network).
ProfileEvent_MergedUncompressedBytes	`UInt64`	377.63 KiB	1.97 MiB	5.34	267.16 thousand	7.73	Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge.
ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds	`UInt64`	371.64 KiB	1.97 MiB	5.43	267.16 thousand	7.73	Time spent sorting blocks
ProfileEvent_MergeTreeDataWriterRows	`UInt64`	369.79 KiB	1.97 MiB	5.45	267.16 thousand	7.73	Number of rows INSERTed to MergeTree tables.
ProfileEvent_SelectedRows	`UInt64`	369.74 KiB	1.97 MiB	5.45	267.16 thousand	7.73	Number of rows SELECTed from all tables.
ProfileEvent_InsertedRows	`UInt64`	369.01 KiB	1.97 MiB	5.46	267.16 thousand	7.73	Number of rows INSERTed to all tables.
CurrentMetric_PartsOutdated	`Int64`	361.48 KiB	1.97 MiB	5.58	267.16 thousand	7.73	Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes.
ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds	`UInt64`	360.43 KiB	1.97 MiB	5.59	267.16 thousand	7.73	Time spent merging input blocks (for special MergeTree engines)
ProfileEvent_FileOpen	`UInt64`	355.68 KiB	1.97 MiB	5.67	267.16 thousand	7.73	Number of files opened.
ProfileEvent_ReadCompressedBytes	`UInt64`	352.91 KiB	1.97 MiB	5.71	267.16 thousand	7.73	Number of bytes (the number of bytes before decompression) read from compressed sources (files, network).
ProfileEvent_OSCPUVirtualTimeMicroseconds	`UInt64`	344.21 KiB	1.97 MiB	5.86	267.16 thousand	7.73	CPU time spent seen by OS. Does not include involuntary waits due to virtualization.
ProfileEvent_RealTimeMicroseconds	`UInt64`	344.21 KiB	1.97 MiB	5.86	267.16 thousand	7.73	Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum).
ProfileEvent_InsertedCompactParts	`UInt64`	343.45 KiB	1.97 MiB	5.87	267.16 thousand	7.73	Number of parts inserted in Compact format.
ProfileEvent_MergeTreeDataWriterBlocks	`UInt64`	343.34 KiB	1.97 MiB	5.87	267.16 thousand	7.73	Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero.
ProfileEvent_UserTimeMicroseconds	`UInt64`	342.97 KiB	1.97 MiB	5.88	267.16 thousand	7.73	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_WriteBufferFromFileDescriptorWrite	`UInt64`	339.22 KiB	1.97 MiB	5.94	267.16 thousand	7.73	Number of writes (write/pwrite) to a file descriptor. Does not include sockets.
ProfileEvent_ReadBufferFromFileDescriptorRead	`UInt64`	338.13 KiB	1.97 MiB	5.96	267.16 thousand	7.73	Number of reads (read/pread) from a file descriptor. Does not include sockets.
ProfileEvent_MergedRows	`UInt64`	337.12 KiB	1.97 MiB	5.98	267.16 thousand	7.73	Rows read for background merges. This is the number of rows before merge.
CurrentMetric_PartsCommitted	`Int64`	330.75 KiB	1.97 MiB	6.1	267.16 thousand	7.73	Deprecated. See PartsActive.
CurrentMetric_PartsActive	`Int64`	330.75 KiB	1.97 MiB	6.1	267.16 thousand	7.73	Active data part, used by current and upcoming SELECTs.
ProfileEvent_SystemTimeMicroseconds	`UInt64`	322.93 KiB	1.97 MiB	6.24	267.16 thousand	7.73	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_SoftPageFaults	`UInt64`	311.72 KiB	1.97 MiB	6.47	267.16 thousand	7.73	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_FunctionExecute	`UInt64`	283.72 KiB	1.97 MiB	7.11	267.16 thousand	7.73	Number of SQL ordinary function calls (SQL functions are called on per-block basis, so this number represents the number of blocks).
CurrentMetric_PartsWide	`Int64`	270.91 KiB	1.97 MiB	7.44	267.16 thousand	7.73	Wide parts.
ProfileEvent_OSReadChars	`UInt64`	268.57 KiB	1.97 MiB	7.51	267.16 thousand	7.73	Number of bytes read from filesystem, including page cache.
ProfileEvent_OSWriteChars	`UInt64`	267.55 KiB	1.97 MiB	7.54	267.16 thousand	7.73	Number of bytes written to filesystem, including page cache.
ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted	`UInt64`	254.57 KiB	1.97 MiB	7.92	267.16 thousand	7.73	Number of blocks INSERTed to MergeTree tables that appeared to be already sorted.
ProfileEvent_CompressedReadBufferBlocks	`UInt64`	253.96 KiB	1.97 MiB	7.94	267.16 thousand	7.73	Number of compressed blocks (the blocks of data that are compressed independent of each other) read from compressed sources (files, network).
ProfileEvent_MergesTimeMilliseconds	`UInt64`	253.06 KiB	1.97 MiB	7.97	267.16 thousand	7.73	Total time spent for background merges.
ProfileEvent_Merge	`UInt64`	251.00 KiB	1.97 MiB	8.03	267.16 thousand	7.73	Number of launched background merges.
ProfileEvent_OSWriteBytes	`UInt64`	241.19 KiB	1.97 MiB	8.36	267.16 thousand	7.73	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_WaitMarksLoadMicroseconds	`UInt64`	238.92 KiB	1.97 MiB	8.44	267.16 thousand	7.73	Time spent loading marks
ProfileEvent_OpenedFileCacheMicroseconds	`UInt64`	225.34 KiB	1.97 MiB	8.95	267.16 thousand	7.73	Amount of time spent executing OpenedFileCache methods.
ProfileEvent_LoadedMarksMemoryBytes	`UInt64`	182.54 KiB	1.97 MiB	11.05	267.16 thousand	7.73	Size of in-memory representations of loaded marks.
ProfileEvent_CreatedReadBufferOrdinary	`UInt64`	181.06 KiB	1.97 MiB	11.14	267.16 thousand	7.73	Number of times ordinary read buffer was created for reading data (while choosing among other read methods).
ProfileEvent_OpenedFileCacheMisses	`UInt64`	181.05 KiB	1.97 MiB	11.14	267.16 thousand	7.73	Number of times a file has been found in the opened file cache, so we had to open it again.
ProfileEvent_LoadedMarksCount	`UInt64`	180.76 KiB	1.97 MiB	11.15	267.16 thousand	7.73	Number of marks loaded (total across columns).
ProfileEvent_ContextLockWaitMicroseconds	`UInt64`	132.98 KiB	1.97 MiB	15.16	267.16 thousand	7.73	Context lock wait time in microseconds
ProfileEvent_OSCPUWaitMicroseconds	`UInt64`	117.53 KiB	1.97 MiB	17.16	267.16 thousand	7.73	Total time a thread was ready for execution but waiting to be scheduled by OS, from the OS point of view.
ProfileEvent_MergedIntoWideParts	`UInt64`	84.05 KiB	1.97 MiB	23.99	267.16 thousand	7.73	Number of parts merged into Wide format.
CurrentMetric_MergesMutationsMemoryTracking	`Int64`	53.11 KiB	96.74 KiB	1.82	267.16 thousand	0.37	Total amount of memory (bytes) allocated by background tasks (merges and mutations).
ProfileEvent_PartsLockWaitMicroseconds	`UInt64`	53.10 KiB	235.96 KiB	4.44	267.16 thousand	0.9	Total time spent waiting for data parts lock in MergeTree tables
CurrentMetric_DiskSpaceReservedForMerge	`Int64`	49.84 KiB	101.68 KiB	2.04	267.16 thousand	0.39	Disk space reserved for currently running background merges. It is slightly more than the total size of currently merging parts.
ProfileEvent_QueryProfilerRuns	`UInt64`	29.17 KiB	209.70 KiB	7.19	267.16 thousand	0.8	Number of times QueryProfiler had been run.
CurrentMetric_OpenFileForRead	`Int64`	20.61 KiB	1.97 MiB	97.84	267.16 thousand	7.73	Number of files open for reading
ProfileEvent_MergedIntoCompactParts	`UInt64`	16.87 KiB	212.83 KiB	12.61	267.16 thousand	0.82	Number of parts merged into Compact format.
CurrentMetric_OpenFileForWrite	`Int64`	13.55 KiB	196.09 KiB	14.47	267.16 thousand	0.75	Number of files open for writing
ProfileEvent_Seek	`UInt64`	13.13 KiB	1.97 MiB	153.53	267.16 thousand	7.73	Number of times the 'lseek' function was called.
CurrentMetric_RWLockActiveReaders	`Int64`	10.71 KiB	206.77 KiB	19.3	267.16 thousand	0.79	Number of threads holding read lock in a table RWLock.
CurrentMetric_CreatedTimersInQueryProfiler	`Int64`	9.82 KiB	1.97 MiB	205.34	267.16 thousand	7.73	Number of Created thread local timers in QueryProfiler
CurrentMetric_GlobalThreadScheduled	`Int64`	9.47 KiB	1.97 MiB	212.81	267.16 thousand	7.73	Number of queued or active jobs in global thread pool.
CurrentMetric_Read	`Int64`	9.46 KiB	1.97 MiB	213.17	267.16 thousand	7.73	Number of read (read, pread, io_getevents, etc.) syscalls in fly
CurrentMetric_GlobalThreadActive	`Int64`	9.46 KiB	1.97 MiB	213.23	267.16 thousand	7.73	Number of threads in global thread pool running a task.
CurrentMetric_GlobalThread	`Int64`	9.23 KiB	1.97 MiB	218.49	267.16 thousand	7.73	Number of threads in global thread pool.
CurrentMetric_AttachedTable	`Int64`	9.20 KiB	1.97 MiB	219.26	267.16 thousand	7.73	Active table, used by current and upcoming SELECTs.
CurrentMetric_MMappedFileBytes	`Int64`	9.19 KiB	1.97 MiB	219.47	267.16 thousand	7.73	Sum size of mmapped file regions.
CurrentMetric_VersionInteger	`Int64`	9.19 KiB	1.97 MiB	219.47	267.16 thousand	7.73	Version of the server in a single integer number in base-1000. For example, version 11.22.33 is translated to 11022033.
CurrentMetric_AttachedDatabase	`Int64`	9.16 KiB	1.97 MiB	220.21	267.16 thousand	7.73	Active database, used by current and upcoming SELECTs.
CurrentMetric_AttachedView	`Int64`	9.14 KiB	1.97 MiB	220.5	267.16 thousand	7.73	Active view, used by current and upcoming SELECTs.
CurrentMetric_Revision	`Int64`	9.13 KiB	1.97 MiB	220.92	267.16 thousand	7.73	Revision of the server. It is a number incremented for every release or release candidate except patch releases.
CurrentMetric_BackgroundSchedulePoolSize	`Int64`	9.13 KiB	1.97 MiB	220.92	267.16 thousand	7.73	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_BackgroundMovePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundProcessingPool for moves
CurrentMetric_BackgroundFetchesPoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of simultaneous fetches in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_BackgroundCommonPoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreads	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Number of threads in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_BackgroundMergesAndMutationsPoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of active merges and mutations in an associated background pool
CurrentMetric_BackgroundDistributedSchedulePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundDistributedSchedulePool
CurrentMetric_MergeTreeBackgroundExecutorThreadsActive	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Number of threads in the MergeTreeBackgroundExecutor thread pool running a task.
CurrentMetric_BackgroundMessageBrokerSchedulePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundProcessingPool for message streaming
CurrentMetric_BackgroundBufferFlushSchedulePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundBufferFlushSchedulePool
CurrentMetric_MMappedFiles	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Total number of mmapped files.
CurrentMetric_ActiveTimersInQueryProfiler	`Int64`	7.45 KiB	193.20 KiB	25.94	267.16 thousand	0.74	Number of Active thread local timers in QueryProfiler
CurrentMetric_PartsTemporary	`Int64`	7.09 KiB	198.56 KiB	28.01	267.16 thousand	0.76	The part is generating now, it is not in data_parts list.
ProfileEvent_NetworkReceiveElapsedMicroseconds	`UInt64`	7.02 KiB	104.71 KiB	14.91	267.16 thousand	0.4	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_BackgroundMergesAndMutationsPoolTask	`Int64`	5.67 KiB	97.93 KiB	17.26	267.16 thousand	0.38	Number of active merges and mutations in an associated background pool
CurrentMetric_Merge	`Int64`	5.65 KiB	97.88 KiB	17.32	267.16 thousand	0.38	Number of executing background merges
ProfileEvent_NetworkSendElapsedMicroseconds	`UInt64`	5.30 KiB	104.70 KiB	19.77	267.16 thousand	0.4	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_NetworkSendBytes	`UInt64`	3.80 KiB	104.70 KiB	27.56	267.16 thousand	0.4	Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_RWLockReadersWaitMilliseconds	`UInt64`	2.74 KiB	12.51 KiB	4.57	267.16 thousand	0.05	Total time spent waiting for a read lock to be acquired (in a heavy RWLock).
ProfileEvent_QueryTimeMicroseconds	`UInt64`	2.38 KiB	4.64 KiB	1.95	267.16 thousand	0.02	Total time of all queries.

0 of 925 row(s) selected.

Rows per page

Page 1 of 10

Table: system.metric_log_0


event_time_microseconds	`DateTime64(6)`	1.50 MiB	1.97 MiB	1.31	267.16 thousand	7.73	Event time with microseconds resolution.
ProfileEvent_DiskReadElapsedMicroseconds	`UInt64`	1.00 MiB	1.97 MiB	1.97	267.16 thousand	7.73	Total time spent waiting for read syscall. This include reads from page cache.
event_time	`DateTime`	1012.53 KiB	1008.17 KiB	1	267.16 thousand	3.86	Event time.
CurrentMetric_MemoryTracking	`Int64`	834.96 KiB	1.97 MiB	2.41	267.16 thousand	7.73	Total amount of memory (bytes) allocated by the server.
ProfileEvent_ReadBufferFromFileDescriptorReadBytes	`UInt64`	815.98 KiB	1.97 MiB	2.47	267.16 thousand	7.73	Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size.
ProfileEvent_PartsLockHoldMicroseconds	`UInt64`	795.97 KiB	1.97 MiB	2.53	267.16 thousand	7.73	Total time spent holding data parts lock in MergeTree tables
ProfileEvent_ContextLock	`UInt64`	708.70 KiB	1.97 MiB	2.85	267.16 thousand	7.73	Number of times the lock of Context was acquired or tried to acquire. This is global lock.
ProfileEvent_RWLockAcquiredReadLocks	`UInt64`	643.88 KiB	1.97 MiB	3.13	267.16 thousand	7.73	Number of times a read lock was acquired (in a heavy RWLock).
ProfileEvent_WriteBufferFromFileDescriptorWriteBytes	`UInt64`	537.46 KiB	1.97 MiB	3.75	267.16 thousand	7.73	Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size.
ProfileEvent_LogTrace	`UInt64`	537.33 KiB	1.97 MiB	3.75	267.16 thousand	7.73	Number of log messages with level Trace
ProfileEvent_IOBufferAllocBytes	`UInt64`	490.51 KiB	1.97 MiB	4.11	267.16 thousand	7.73	Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer).
CurrentMetric_PartsCompact	`Int64`	467.72 KiB	1.97 MiB	4.31	267.16 thousand	7.73	Compact parts.
ProfileEvent_DiskWriteElapsedMicroseconds	`UInt64`	457.16 KiB	1.97 MiB	4.41	267.16 thousand	7.73	Total time spent waiting for write syscall. This include writes to page cache.
ProfileEvent_MergeTreeDataWriterCompressedBytes	`UInt64`	444.72 KiB	1.97 MiB	4.53	267.16 thousand	7.73	Bytes written to filesystem for data INSERTed to MergeTree tables.
ProfileEvent_IOBufferAllocs	`UInt64`	392.69 KiB	1.97 MiB	5.13	267.16 thousand	7.73	Number of allocations of IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_LogDebug	`UInt64`	389.02 KiB	1.97 MiB	5.18	267.16 thousand	7.73	Number of log messages with level Debug
ProfileEvent_SelectedBytes	`UInt64`	382.17 KiB	1.97 MiB	5.28	267.16 thousand	7.73	Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables.
ProfileEvent_MergeTreeDataWriterUncompressedBytes	`UInt64`	382.02 KiB	1.97 MiB	5.28	267.16 thousand	7.73	Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables.
ProfileEvent_InsertedBytes	`UInt64`	381.37 KiB	1.97 MiB	5.29	267.16 thousand	7.73	Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables.
ProfileEvent_CompressedReadBufferBytes	`UInt64`	380.26 KiB	1.97 MiB	5.3	267.16 thousand	7.73	Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network).
ProfileEvent_MergedUncompressedBytes	`UInt64`	377.63 KiB	1.97 MiB	5.34	267.16 thousand	7.73	Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge.
ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds	`UInt64`	371.64 KiB	1.97 MiB	5.43	267.16 thousand	7.73	Time spent sorting blocks
ProfileEvent_MergeTreeDataWriterRows	`UInt64`	369.79 KiB	1.97 MiB	5.45	267.16 thousand	7.73	Number of rows INSERTed to MergeTree tables.
ProfileEvent_SelectedRows	`UInt64`	369.74 KiB	1.97 MiB	5.45	267.16 thousand	7.73	Number of rows SELECTed from all tables.
ProfileEvent_InsertedRows	`UInt64`	369.01 KiB	1.97 MiB	5.46	267.16 thousand	7.73	Number of rows INSERTed to all tables.
CurrentMetric_PartsOutdated	`Int64`	361.48 KiB	1.97 MiB	5.58	267.16 thousand	7.73	Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes.
ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds	`UInt64`	360.43 KiB	1.97 MiB	5.59	267.16 thousand	7.73	Time spent merging input blocks (for special MergeTree engines)
ProfileEvent_FileOpen	`UInt64`	355.68 KiB	1.97 MiB	5.67	267.16 thousand	7.73	Number of files opened.
ProfileEvent_ReadCompressedBytes	`UInt64`	352.91 KiB	1.97 MiB	5.71	267.16 thousand	7.73	Number of bytes (the number of bytes before decompression) read from compressed sources (files, network).
ProfileEvent_OSCPUVirtualTimeMicroseconds	`UInt64`	344.21 KiB	1.97 MiB	5.86	267.16 thousand	7.73	CPU time spent seen by OS. Does not include involuntary waits due to virtualization.
ProfileEvent_RealTimeMicroseconds	`UInt64`	344.21 KiB	1.97 MiB	5.86	267.16 thousand	7.73	Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum).
ProfileEvent_InsertedCompactParts	`UInt64`	343.45 KiB	1.97 MiB	5.87	267.16 thousand	7.73	Number of parts inserted in Compact format.
ProfileEvent_MergeTreeDataWriterBlocks	`UInt64`	343.34 KiB	1.97 MiB	5.87	267.16 thousand	7.73	Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero.
ProfileEvent_UserTimeMicroseconds	`UInt64`	342.97 KiB	1.97 MiB	5.88	267.16 thousand	7.73	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_WriteBufferFromFileDescriptorWrite	`UInt64`	339.22 KiB	1.97 MiB	5.94	267.16 thousand	7.73	Number of writes (write/pwrite) to a file descriptor. Does not include sockets.
ProfileEvent_ReadBufferFromFileDescriptorRead	`UInt64`	338.13 KiB	1.97 MiB	5.96	267.16 thousand	7.73	Number of reads (read/pread) from a file descriptor. Does not include sockets.
ProfileEvent_MergedRows	`UInt64`	337.12 KiB	1.97 MiB	5.98	267.16 thousand	7.73	Rows read for background merges. This is the number of rows before merge.
CurrentMetric_PartsCommitted	`Int64`	330.75 KiB	1.97 MiB	6.1	267.16 thousand	7.73	Deprecated. See PartsActive.
CurrentMetric_PartsActive	`Int64`	330.75 KiB	1.97 MiB	6.1	267.16 thousand	7.73	Active data part, used by current and upcoming SELECTs.
ProfileEvent_SystemTimeMicroseconds	`UInt64`	322.93 KiB	1.97 MiB	6.24	267.16 thousand	7.73	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_SoftPageFaults	`UInt64`	311.72 KiB	1.97 MiB	6.47	267.16 thousand	7.73	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_FunctionExecute	`UInt64`	283.72 KiB	1.97 MiB	7.11	267.16 thousand	7.73	Number of SQL ordinary function calls (SQL functions are called on per-block basis, so this number represents the number of blocks).
CurrentMetric_PartsWide	`Int64`	270.91 KiB	1.97 MiB	7.44	267.16 thousand	7.73	Wide parts.
ProfileEvent_OSReadChars	`UInt64`	268.57 KiB	1.97 MiB	7.51	267.16 thousand	7.73	Number of bytes read from filesystem, including page cache.
ProfileEvent_OSWriteChars	`UInt64`	267.55 KiB	1.97 MiB	7.54	267.16 thousand	7.73	Number of bytes written to filesystem, including page cache.
ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted	`UInt64`	254.57 KiB	1.97 MiB	7.92	267.16 thousand	7.73	Number of blocks INSERTed to MergeTree tables that appeared to be already sorted.
ProfileEvent_CompressedReadBufferBlocks	`UInt64`	253.96 KiB	1.97 MiB	7.94	267.16 thousand	7.73	Number of compressed blocks (the blocks of data that are compressed independent of each other) read from compressed sources (files, network).
ProfileEvent_MergesTimeMilliseconds	`UInt64`	253.06 KiB	1.97 MiB	7.97	267.16 thousand	7.73	Total time spent for background merges.
ProfileEvent_Merge	`UInt64`	251.00 KiB	1.97 MiB	8.03	267.16 thousand	7.73	Number of launched background merges.
ProfileEvent_OSWriteBytes	`UInt64`	241.19 KiB	1.97 MiB	8.36	267.16 thousand	7.73	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_WaitMarksLoadMicroseconds	`UInt64`	238.92 KiB	1.97 MiB	8.44	267.16 thousand	7.73	Time spent loading marks
ProfileEvent_OpenedFileCacheMicroseconds	`UInt64`	225.34 KiB	1.97 MiB	8.95	267.16 thousand	7.73	Amount of time spent executing OpenedFileCache methods.
ProfileEvent_LoadedMarksMemoryBytes	`UInt64`	182.54 KiB	1.97 MiB	11.05	267.16 thousand	7.73	Size of in-memory representations of loaded marks.
ProfileEvent_CreatedReadBufferOrdinary	`UInt64`	181.06 KiB	1.97 MiB	11.14	267.16 thousand	7.73	Number of times ordinary read buffer was created for reading data (while choosing among other read methods).
ProfileEvent_OpenedFileCacheMisses	`UInt64`	181.05 KiB	1.97 MiB	11.14	267.16 thousand	7.73	Number of times a file has been found in the opened file cache, so we had to open it again.
ProfileEvent_LoadedMarksCount	`UInt64`	180.76 KiB	1.97 MiB	11.15	267.16 thousand	7.73	Number of marks loaded (total across columns).
ProfileEvent_ContextLockWaitMicroseconds	`UInt64`	132.98 KiB	1.97 MiB	15.16	267.16 thousand	7.73	Context lock wait time in microseconds
ProfileEvent_OSCPUWaitMicroseconds	`UInt64`	117.53 KiB	1.97 MiB	17.16	267.16 thousand	7.73	Total time a thread was ready for execution but waiting to be scheduled by OS, from the OS point of view.
ProfileEvent_MergedIntoWideParts	`UInt64`	84.05 KiB	1.97 MiB	23.99	267.16 thousand	7.73	Number of parts merged into Wide format.
CurrentMetric_MergesMutationsMemoryTracking	`Int64`	53.11 KiB	96.74 KiB	1.82	267.16 thousand	0.37	Total amount of memory (bytes) allocated by background tasks (merges and mutations).
ProfileEvent_PartsLockWaitMicroseconds	`UInt64`	53.10 KiB	235.96 KiB	4.44	267.16 thousand	0.9	Total time spent waiting for data parts lock in MergeTree tables
CurrentMetric_DiskSpaceReservedForMerge	`Int64`	49.84 KiB	101.68 KiB	2.04	267.16 thousand	0.39	Disk space reserved for currently running background merges. It is slightly more than the total size of currently merging parts.
ProfileEvent_QueryProfilerRuns	`UInt64`	29.17 KiB	209.70 KiB	7.19	267.16 thousand	0.8	Number of times QueryProfiler had been run.
CurrentMetric_OpenFileForRead	`Int64`	20.61 KiB	1.97 MiB	97.84	267.16 thousand	7.73	Number of files open for reading
ProfileEvent_MergedIntoCompactParts	`UInt64`	16.87 KiB	212.83 KiB	12.61	267.16 thousand	0.82	Number of parts merged into Compact format.
CurrentMetric_OpenFileForWrite	`Int64`	13.55 KiB	196.09 KiB	14.47	267.16 thousand	0.75	Number of files open for writing
ProfileEvent_Seek	`UInt64`	13.13 KiB	1.97 MiB	153.53	267.16 thousand	7.73	Number of times the 'lseek' function was called.
CurrentMetric_RWLockActiveReaders	`Int64`	10.71 KiB	206.77 KiB	19.3	267.16 thousand	0.79	Number of threads holding read lock in a table RWLock.
CurrentMetric_CreatedTimersInQueryProfiler	`Int64`	9.82 KiB	1.97 MiB	205.34	267.16 thousand	7.73	Number of Created thread local timers in QueryProfiler
CurrentMetric_GlobalThreadScheduled	`Int64`	9.47 KiB	1.97 MiB	212.81	267.16 thousand	7.73	Number of queued or active jobs in global thread pool.
CurrentMetric_Read	`Int64`	9.46 KiB	1.97 MiB	213.17	267.16 thousand	7.73	Number of read (read, pread, io_getevents, etc.) syscalls in fly
CurrentMetric_GlobalThreadActive	`Int64`	9.46 KiB	1.97 MiB	213.23	267.16 thousand	7.73	Number of threads in global thread pool running a task.
CurrentMetric_GlobalThread	`Int64`	9.23 KiB	1.97 MiB	218.49	267.16 thousand	7.73	Number of threads in global thread pool.
CurrentMetric_AttachedTable	`Int64`	9.20 KiB	1.97 MiB	219.26	267.16 thousand	7.73	Active table, used by current and upcoming SELECTs.
CurrentMetric_MMappedFileBytes	`Int64`	9.19 KiB	1.97 MiB	219.47	267.16 thousand	7.73	Sum size of mmapped file regions.
CurrentMetric_VersionInteger	`Int64`	9.19 KiB	1.97 MiB	219.47	267.16 thousand	7.73	Version of the server in a single integer number in base-1000. For example, version 11.22.33 is translated to 11022033.
CurrentMetric_AttachedDatabase	`Int64`	9.16 KiB	1.97 MiB	220.21	267.16 thousand	7.73	Active database, used by current and upcoming SELECTs.
CurrentMetric_AttachedView	`Int64`	9.14 KiB	1.97 MiB	220.5	267.16 thousand	7.73	Active view, used by current and upcoming SELECTs.
CurrentMetric_Revision	`Int64`	9.13 KiB	1.97 MiB	220.92	267.16 thousand	7.73	Revision of the server. It is a number incremented for every release or release candidate except patch releases.
CurrentMetric_BackgroundSchedulePoolSize	`Int64`	9.13 KiB	1.97 MiB	220.92	267.16 thousand	7.73	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_BackgroundMovePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundProcessingPool for moves
CurrentMetric_BackgroundFetchesPoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of simultaneous fetches in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_BackgroundCommonPoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in an associated background pool
CurrentMetric_MergeTreeBackgroundExecutorThreads	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Number of threads in the MergeTreeBackgroundExecutor thread pool.
CurrentMetric_BackgroundMergesAndMutationsPoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of active merges and mutations in an associated background pool
CurrentMetric_BackgroundDistributedSchedulePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundDistributedSchedulePool
CurrentMetric_MergeTreeBackgroundExecutorThreadsActive	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Number of threads in the MergeTreeBackgroundExecutor thread pool running a task.
CurrentMetric_BackgroundMessageBrokerSchedulePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundProcessingPool for message streaming
CurrentMetric_BackgroundBufferFlushSchedulePoolSize	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Limit on number of tasks in BackgroundBufferFlushSchedulePool
CurrentMetric_MMappedFiles	`Int64`	9.10 KiB	1.97 MiB	221.66	267.16 thousand	7.73	Total number of mmapped files.
CurrentMetric_ActiveTimersInQueryProfiler	`Int64`	7.45 KiB	193.20 KiB	25.94	267.16 thousand	0.74	Number of Active thread local timers in QueryProfiler
CurrentMetric_PartsTemporary	`Int64`	7.09 KiB	198.56 KiB	28.01	267.16 thousand	0.76	The part is generating now, it is not in data_parts list.
ProfileEvent_NetworkReceiveElapsedMicroseconds	`UInt64`	7.02 KiB	104.71 KiB	14.91	267.16 thousand	0.4	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_BackgroundMergesAndMutationsPoolTask	`Int64`	5.67 KiB	97.93 KiB	17.26	267.16 thousand	0.38	Number of active merges and mutations in an associated background pool
CurrentMetric_Merge	`Int64`	5.65 KiB	97.88 KiB	17.32	267.16 thousand	0.38	Number of executing background merges
ProfileEvent_NetworkSendElapsedMicroseconds	`UInt64`	5.30 KiB	104.70 KiB	19.77	267.16 thousand	0.4	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_NetworkSendBytes	`UInt64`	3.80 KiB	104.70 KiB	27.56	267.16 thousand	0.4	Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_RWLockReadersWaitMilliseconds	`UInt64`	2.74 KiB	12.51 KiB	4.57	267.16 thousand	0.05	Total time spent waiting for a read lock to be acquired (in a heavy RWLock).
ProfileEvent_QueryTimeMicroseconds	`UInt64`	2.38 KiB	4.64 KiB	1.95	267.16 thousand	0.02	Total time of all queries.

0 of 925 row(s) selected.

Rows per page

Page 1 of 10