| event_time_microseconds | DateTime64(6) | 14.39 MiB | 30.27 MiB | 2.1 | 3.97 million | 8 | | Event time with microseconds resolution. |
| CurrentMetric_MemoryTracking | Int64 | 10.95 MiB | 30.27 MiB | 2.76 | 3.97 million | 8 | | Total amount of memory (bytes) allocated by the server. |
| event_time | DateTime | 10.08 MiB | 15.13 MiB | 1.5 | 3.97 million | 4 | | Event time. |
| ProfileEvent_ReadBufferFromFileDescriptorReadBytes | UInt64 | 8.35 MiB | 30.27 MiB | 3.62 | 3.97 million | 8 | | Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size. |
| ProfileEvent_DiskReadElapsedMicroseconds | UInt64 | 6.64 MiB | 30.27 MiB | 4.56 | 3.97 million | 8 | | Total time spent waiting for read syscall. This include reads from page cache. |
| ProfileEvent_PartsLockHoldMicroseconds | UInt64 | 6.11 MiB | 30.27 MiB | 4.95 | 3.97 million | 8 | | Total time spent holding data parts lock in MergeTree tables |
| ProfileEvent_PartsLockWaitMicroseconds | UInt64 | 4.89 MiB | 30.27 MiB | 6.19 | 3.97 million | 8 | | Total time spent waiting for data parts lock in MergeTree tables |
| ProfileEvent_WriteBufferFromFileDescriptorWriteBytes | UInt64 | 4.47 MiB | 30.27 MiB | 6.77 | 3.97 million | 8 | | Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size. |
| ProfileEvent_ContextLockWaitMicroseconds | UInt64 | 3.63 MiB | 30.27 MiB | 8.35 | 3.97 million | 8 | | Context lock wait time in microseconds |
| ProfileEvent_ContextLock | UInt64 | 3.53 MiB | 30.27 MiB | 8.57 | 3.97 million | 8 | | Number of times the lock of Context was acquired or tried to acquire. This is global lock. |
| ProfileEvent_IOBufferAllocBytes | UInt64 | 3.51 MiB | 30.27 MiB | 8.63 | 3.97 million | 8 | | Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer). |
| ProfileEvent_DiskWriteElapsedMicroseconds | UInt64 | 3.12 MiB | 30.27 MiB | 9.7 | 3.97 million | 8 | | Total time spent waiting for write syscall. This include writes to page cache. |
| CurrentMetric_PartsWide | Int64 | 3.06 MiB | 30.27 MiB | 9.9 | 3.97 million | 8 | | Wide parts. |
| ProfileEvent_MergeTreeDataWriterCompressedBytes | UInt64 | 3.02 MiB | 30.27 MiB | 10.02 | 3.97 million | 8 | | Bytes written to filesystem for data INSERTed to MergeTree tables. |
| ProfileEvent_CompressedReadBufferBytes | UInt64 | 3.02 MiB | 30.27 MiB | 10.03 | 3.97 million | 8 | | Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network). |
| ProfileEvent_MergedUncompressedBytes | UInt64 | 2.87 MiB | 30.27 MiB | 10.55 | 3.97 million | 8 | | Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge. |
| ProfileEvent_GWPAsanFree | UInt64 | 2.76 MiB | 30.27 MiB | 10.96 | 3.97 million | 8 | | Number of free operations done by GWPAsan |
| ProfileEvent_RealTimeMicroseconds | UInt64 | 2.74 MiB | 30.27 MiB | 11.06 | 3.97 million | 8 | | Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum). |
| ProfileEvent_GWPAsanAllocateSuccess | UInt64 | 2.73 MiB | 30.27 MiB | 11.09 | 3.97 million | 8 | | Number of successful allocations done by GWPAsan |
| ProfileEvent_ReadCompressedBytes | UInt64 | 2.72 MiB | 30.27 MiB | 11.11 | 3.97 million | 8 | | Number of bytes (the number of bytes before decompression) read from compressed sources (files, network). |
| ProfileEvent_OSCPUVirtualTimeMicroseconds | UInt64 | 2.71 MiB | 30.27 MiB | 11.18 | 3.97 million | 8 | | CPU time spent seen by OS. Does not include involuntary waits due to virtualization. |
| ProfileEvent_UserTimeMicroseconds | UInt64 | 2.70 MiB | 30.27 MiB | 11.2 | 3.97 million | 8 | | 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 | 2.62 MiB | 30.27 MiB | 11.57 | 3.97 million | 8 | | Number of log messages with level Trace |
| ProfileEvent_RWLockAcquiredReadLocks | UInt64 | 2.58 MiB | 30.27 MiB | 11.75 | 3.97 million | 8 | | Number of times a read lock was acquired (in a heavy RWLock). |
| ProfileEvent_MergedRows | UInt64 | 2.41 MiB | 30.27 MiB | 12.54 | 3.97 million | 8 | | Rows read for background merges. This is the number of rows before merge. |
| ProfileEvent_SystemTimeMicroseconds | UInt64 | 2.32 MiB | 30.27 MiB | 13.03 | 3.97 million | 8 | | 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. |
| CurrentMetric_PartsOutdated | Int64 | 2.26 MiB | 30.27 MiB | 13.37 | 3.97 million | 8 | | Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes. |
| ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds | UInt64 | 2.15 MiB | 30.27 MiB | 14.1 | 3.97 million | 8 | | Time spent sorting blocks |
| ProfileEvent_SoftPageFaults | UInt64 | 2.09 MiB | 30.27 MiB | 14.47 | 3.97 million | 8 | | 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_IOBufferAllocs | UInt64 | 1.87 MiB | 30.27 MiB | 16.16 | 3.97 million | 8 | | Number of allocations of IO buffers (for ReadBuffer/WriteBuffer). |
| ProfileEvent_ReadBufferFromFileDescriptorRead | UInt64 | 1.78 MiB | 30.27 MiB | 16.99 | 3.97 million | 8 | | Number of reads (read/pread) from a file descriptor. Does not include sockets. |
| ProfileEvent_FileOpen | UInt64 | 1.70 MiB | 30.27 MiB | 17.76 | 3.97 million | 8 | | Number of files opened. |
| ProfileEvent_OSReadChars | UInt64 | 1.64 MiB | 30.27 MiB | 18.5 | 3.97 million | 8 | | Number of bytes read from filesystem, including page cache. |
| ProfileEvent_WriteBufferFromFileDescriptorWrite | UInt64 | 1.62 MiB | 30.27 MiB | 18.73 | 3.97 million | 8 | | Number of writes (write/pwrite) to a file descriptor. Does not include sockets. |
| ProfileEvent_OSWriteChars | UInt64 | 1.60 MiB | 30.27 MiB | 18.88 | 3.97 million | 8 | | Number of bytes written to filesystem, including page cache. |
| CurrentMetric_PartsCompact | Int64 | 1.59 MiB | 30.27 MiB | 18.99 | 3.97 million | 8 | | Compact parts. |
| ProfileEvent_CompressedReadBufferBlocks | UInt64 | 1.56 MiB | 30.27 MiB | 19.46 | 3.97 million | 8 | | Number of compressed blocks (the blocks of data that are compressed independent of each other) read from compressed sources (files, network). |
| ProfileEvent_LogDebug | UInt64 | 1.50 MiB | 30.27 MiB | 20.14 | 3.97 million | 8 | | Number of log messages with level Debug |
| ProfileEvent_WaitMarksLoadMicroseconds | UInt64 | 1.43 MiB | 30.27 MiB | 21.15 | 3.97 million | 8 | | Time spent loading marks |
| ProfileEvent_OSWriteBytes | UInt64 | 1.41 MiB | 30.27 MiB | 21.48 | 3.97 million | 8 | | 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. |
| CurrentMetric_Read | Int64 | 1.36 MiB | 30.27 MiB | 22.22 | 3.97 million | 8 | | Number of read (read, pread, io_getevents, etc.) syscalls in fly |
| ProfileEvent_MergeExecuteMilliseconds | UInt64 | 1.34 MiB | 30.27 MiB | 22.56 | 3.97 million | 8 | | Total busy time spent for execution of background merges |
| ProfileEvent_MergeTotalMilliseconds | UInt64 | 1.34 MiB | 30.27 MiB | 22.59 | 3.97 million | 8 | | Total time spent for background merges |
| ProfileEvent_FunctionExecute | UInt64 | 1.33 MiB | 30.27 MiB | 22.77 | 3.97 million | 8 | | Number of SQL ordinary function calls (SQL functions are called on per-block basis, so this number represents the number of blocks). |
| ProfileEvent_MergeHorizontalStageExecuteMilliseconds | UInt64 | 1.33 MiB | 30.27 MiB | 22.79 | 3.97 million | 8 | | Total busy time spent for execution of horizontal stage of background merges |
| ProfileEvent_MergeHorizontalStageTotalMilliseconds | UInt64 | 1.33 MiB | 30.27 MiB | 22.81 | 3.97 million | 8 | | Total time spent for horizontal stage of background merges |
| ProfileEvent_SelectedRows | UInt64 | 1.29 MiB | 30.27 MiB | 23.44 | 3.97 million | 8 | | Number of rows SELECTed from all tables. |
| ProfileEvent_NetworkReceiveElapsedMicroseconds | UInt64 | 1.29 MiB | 30.27 MiB | 23.54 | 3.97 million | 8 | | 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_PartsActive | Int64 | 1.26 MiB | 30.27 MiB | 23.95 | 3.97 million | 8 | | Active data part, used by current and upcoming SELECTs. |
| CurrentMetric_PartsCommitted | Int64 | 1.26 MiB | 30.27 MiB | 23.95 | 3.97 million | 8 | | Deprecated. See PartsActive. |
| ProfileEvent_SelectedBytes | UInt64 | 1.25 MiB | 30.27 MiB | 24.26 | 3.97 million | 8 | | Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables. |
| ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds | UInt64 | 1.15 MiB | 30.27 MiB | 26.36 | 3.97 million | 8 | | Time spent merging input blocks (for special MergeTree engines) |
| ProfileEvent_OpenedFileCacheMicroseconds | UInt64 | 1.10 MiB | 30.27 MiB | 27.47 | 3.97 million | 8 | | Amount of time spent executing OpenedFileCache methods. |
| ProfileEvent_MergeTreeDataWriterUncompressedBytes | UInt64 | 1.10 MiB | 30.27 MiB | 27.5 | 3.97 million | 8 | | Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables. |
| ProfileEvent_InsertedBytes | UInt64 | 1.10 MiB | 30.27 MiB | 27.61 | 3.97 million | 8 | | Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables. |
| ProfileEvent_MergeTreeDataWriterRows | UInt64 | 1.10 MiB | 30.27 MiB | 27.64 | 3.97 million | 8 | | Number of rows INSERTed to MergeTree tables. |
| ProfileEvent_InsertedRows | UInt64 | 1.09 MiB | 30.27 MiB | 27.81 | 3.97 million | 8 | | Number of rows INSERTed to all tables. |
| CurrentMetric_AttachedDatabase | Int64 | 1.02 MiB | 30.27 MiB | 29.68 | 3.97 million | 8 | | Active databases. |
| ProfileEvent_MergingSortedMilliseconds | UInt64 | 1020.33 KiB | 30.27 MiB | 30.38 | 3.97 million | 8 | | Total time spent while merging sorted columns |
| ProfileEvent_LoadedMarksMemoryBytes | UInt64 | 1009.51 KiB | 30.27 MiB | 30.7 | 3.97 million | 8 | | Size of in-memory representations of loaded marks. |
| CurrentMetric_AttachedTable | Int64 | 1003.56 KiB | 30.27 MiB | 30.89 | 3.97 million | 8 | | Active tables. |
| CurrentMetric_ThreadPoolFSReaderThreads | Int64 | 1001.93 KiB | 30.27 MiB | 30.94 | 3.97 million | 8 | | Number of threads in the thread pool for local_filesystem_read_method=threadpool. |
| CurrentMetric_AsynchronousInsertThreads | Int64 | 998.82 KiB | 30.27 MiB | 31.03 | 3.97 million | 8 | | Number of threads in the AsynchronousInsert thread pool. |
| CurrentMetric_BackgroundSchedulePoolSize | Int64 | 996.85 KiB | 30.27 MiB | 31.09 | 3.97 million | 8 | | 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_MergeTreeBackgroundExecutorThreadsActive | Int64 | 995.57 KiB | 30.27 MiB | 31.13 | 3.97 million | 8 | | Number of threads in the MergeTreeBackgroundExecutor thread pool running a task. |
| CurrentMetric_BackgroundMergesAndMutationsPoolSize | Int64 | 995.57 KiB | 30.27 MiB | 31.13 | 3.97 million | 8 | | Limit on number of active merges and mutations in an associated background pool |
| CurrentMetric_MergeTreeBackgroundExecutorThreads | Int64 | 995.57 KiB | 30.27 MiB | 31.13 | 3.97 million | 8 | | Number of threads in the MergeTreeBackgroundExecutor thread pool. |
| CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled | Int64 | 995.57 KiB | 30.27 MiB | 31.13 | 3.97 million | 8 | | Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool. |
| CurrentMetric_BackgroundFetchesPoolSize | Int64 | 995.15 KiB | 30.27 MiB | 31.15 | 3.97 million | 8 | | Limit on number of simultaneous fetches in an associated background pool |
| CurrentMetric_BackgroundMessageBrokerSchedulePoolSize | Int64 | 995.15 KiB | 30.27 MiB | 31.15 | 3.97 million | 8 | | Limit on number of tasks in BackgroundProcessingPool for message streaming |
| CurrentMetric_BackgroundBufferFlushSchedulePoolSize | Int64 | 995.15 KiB | 30.27 MiB | 31.15 | 3.97 million | 8 | | Limit on number of tasks in BackgroundBufferFlushSchedulePool |
| CurrentMetric_BackgroundDistributedSchedulePoolSize | Int64 | 995.15 KiB | 30.27 MiB | 31.15 | 3.97 million | 8 | | Limit on number of tasks in BackgroundDistributedSchedulePool |
| CurrentMetric_BackgroundCommonPoolSize | Int64 | 995.15 KiB | 30.27 MiB | 31.15 | 3.97 million | 8 | | Limit on number of tasks in an associated background pool |
| CurrentMetric_BackgroundMovePoolSize | Int64 |
