| event_time_microseconds | DateTime64(6) | 7.42 MiB | 15.35 MiB | 2.07 | 2.01 million | 8 | | Event time with microseconds resolution. |
| event_time | DateTime | 5.11 MiB | 7.67 MiB | 1.5 | 2.01 million | 4 | | Event time. |
| ProfileEvent_ReadBufferFromFileDescriptorReadBytes | UInt64 | 4.00 MiB | 15.35 MiB | 3.84 | 2.01 million | 8 | | Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size. |
| ProfileEvent_DiskReadElapsedMicroseconds | UInt64 | 3.37 MiB | 15.35 MiB | 4.55 | 2.01 million | 8 | | Total time spent waiting for read syscall. This include reads from page cache. |
| ProfileEvent_PartsLockHoldMicroseconds | UInt64 | 3.21 MiB | 15.35 MiB | 4.79 | 2.01 million | 8 | | Total time spent holding data parts lock in MergeTree tables |
| CurrentMetric_MemoryTracking | Int64 | 3.05 MiB | 15.35 MiB | 5.04 | 2.01 million | 8 | | Total amount of memory (bytes) allocated by the server. |
| ProfileEvent_MemoryWorkerRunElapsedMicroseconds | UInt64 | 2.93 MiB | 15.35 MiB | 5.24 | 2.01 million | 8 | | Total time spent by MemoryWorker for background work |
| ProfileEvent_PartsLockWaitMicroseconds | UInt64 | 2.81 MiB | 15.35 MiB | 5.46 | 2.01 million | 8 | | Total time spent waiting for data parts lock in MergeTree tables |
| ProfileEvent_WriteBufferFromFileDescriptorWriteBytes | UInt64 | 2.59 MiB | 15.35 MiB | 5.92 | 2.01 million | 8 | | Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size. |
| ProfileEvent_IOBufferAllocBytes | UInt64 | 2.19 MiB | 15.35 MiB | 7 | 2.01 million | 8 | | Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer). |
| ProfileEvent_CompressedReadBufferBytes | UInt64 | 1.90 MiB | 15.35 MiB | 8.1 | 2.01 million | 8 | | Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network). |
| ProfileEvent_MergeTreeDataWriterCompressedBytes | UInt64 | 1.88 MiB | 15.35 MiB | 8.18 | 2.01 million | 8 | | Bytes written to filesystem for data INSERTed to MergeTree tables. |
| ProfileEvent_ContextLockWaitMicroseconds | UInt64 | 1.87 MiB | 15.35 MiB | 8.2 | 2.01 million | 8 | | Context lock wait time in microseconds |
| ProfileEvent_DiskWriteElapsedMicroseconds | UInt64 | 1.81 MiB | 15.35 MiB | 8.48 | 2.01 million | 8 | | Total time spent waiting for write syscall. This include writes to page cache. |
| ProfileEvent_MergedUncompressedBytes | UInt64 | 1.69 MiB | 15.35 MiB | 9.06 | 2.01 million | 8 | | Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge. |
| ProfileEvent_ReadCompressedBytes | UInt64 | 1.69 MiB | 15.35 MiB | 9.07 | 2.01 million | 8 | | Number of bytes (the number of bytes before decompression) read from compressed sources (files, network). |
| ProfileEvent_RealTimeMicroseconds | UInt64 | 1.68 MiB | 15.35 MiB | 9.16 | 2.01 million | 8 | | Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum). |
| ProfileEvent_OSCPUVirtualTimeMicroseconds | UInt64 | 1.67 MiB | 15.35 MiB | 9.21 | 2.01 million | 8 | | CPU time spent seen by OS. Does not include involuntary waits due to virtualization. |
| ProfileEvent_UserTimeMicroseconds | UInt64 | 1.65 MiB | 15.35 MiB | 9.32 | 2.01 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. |
| CurrentMetric_PartsWide | Int64 | 1.57 MiB | 15.35 MiB | 9.79 | 2.01 million | 8 | | Wide parts. |
| ProfileEvent_ContextLock | UInt64 | 1.55 MiB | 15.35 MiB | 9.89 | 2.01 million | 8 | | Number of times the lock of Context was acquired or tried to acquire. This is global lock. |
| ProfileEvent_RWLockAcquiredReadLocks | UInt64 | 1.41 MiB | 15.35 MiB | 10.86 | 2.01 million | 8 | | Number of times a read lock was acquired (in a heavy RWLock). |
| ProfileEvent_MergedRows | UInt64 | 1.40 MiB | 15.35 MiB | 10.96 | 2.01 million | 8 | | Rows read for background merges. This is the number of rows before merge. |
| ProfileEvent_SystemTimeMicroseconds | UInt64 | 1.40 MiB | 15.35 MiB | 10.98 | 2.01 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. |
| ProfileEvent_SelectedBytes | UInt64 | 1.30 MiB | 15.35 MiB | 11.76 | 2.01 million | 8 | | Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables. |
| ProfileEvent_SoftPageFaults | UInt64 | 1.25 MiB | 15.35 MiB | 12.26 | 2.01 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_MergeTreeDataWriterSortingBlocksMicroseconds | UInt64 | 1.19 MiB | 15.35 MiB | 12.85 | 2.01 million | 8 | | Time spent sorting blocks |
| ProfileEvent_IOBufferAllocs | UInt64 | 1.18 MiB | 15.35 MiB | 13 | 2.01 million | 8 | | Number of allocations of IO buffers (for ReadBuffer/WriteBuffer). |
| ProfileEvent_SelectedRows | UInt64 | 1.12 MiB | 15.35 MiB | 13.65 | 2.01 million | 8 | | Number of rows SELECTed from all tables. |
| ProfileEvent_LogTrace | UInt64 | 1.09 MiB | 15.35 MiB | 14.05 | 2.01 million | 8 | | Number of log messages with level Trace |
| ProfileEvent_MergeTreeDataWriterUncompressedBytes | UInt64 | 1.09 MiB | 15.35 MiB | 14.08 | 2.01 million | 8 | | Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables. |
| ProfileEvent_OSReadChars | UInt64 | 1.07 MiB | 15.35 MiB | 14.37 | 2.01 million | 8 | | Number of bytes read from filesystem, including page cache. |
| ProfileEvent_FileOpen | UInt64 | 1.06 MiB | 15.35 MiB | 14.49 | 2.01 million | 8 | | Number of files opened. |
| ProfileEvent_InsertedBytes | UInt64 | 1.06 MiB | 15.35 MiB | 14.52 | 2.01 million | 8 | | Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables. |
| ProfileEvent_FunctionExecute | UInt64 | 1.01 MiB | 15.35 MiB | 15.19 | 2.01 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_CompressedReadBufferBlocks | UInt64 | 1018.63 KiB | 15.35 MiB | 15.43 | 2.01 million | 8 | | Number of compressed blocks (the blocks of data that are compressed independent of each other) read from compressed sources (files, network). |
| ProfileEvent_OSWriteChars | UInt64 | 1015.67 KiB | 15.35 MiB | 15.47 | 2.01 million | 8 | | Number of bytes written to filesystem, including page cache. |
| ProfileEvent_WriteBufferFromFileDescriptorWrite | UInt64 | 997.80 KiB | 15.35 MiB | 15.75 | 2.01 million | 8 | | Number of writes (write/pwrite) to a file descriptor. Does not include sockets. |
| ProfileEvent_ReadBufferFromFileDescriptorRead | UInt64 | 980.54 KiB | 15.35 MiB | 16.03 | 2.01 million | 8 | | Number of reads (read/pread) from a file descriptor. Does not include sockets. |
| ProfileEvent_WaitMarksLoadMicroseconds | UInt64 | 896.08 KiB | 15.35 MiB | 17.54 | 2.01 million | 8 | | Time spent loading marks |
| ProfileEvent_OSWriteBytes | UInt64 | 891.92 KiB | 15.35 MiB | 17.62 | 2.01 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. |
| ProfileEvent_LogDebug | UInt64 | 867.47 KiB | 15.35 MiB | 18.12 | 2.01 million | 8 | | Number of log messages with level Debug |
| ProfileEvent_MergeTreeDataWriterRows | UInt64 | 856.97 KiB | 15.35 MiB | 18.34 | 2.01 million | 8 | | Number of rows INSERTed to MergeTree tables. |
| ProfileEvent_InsertedRows | UInt64 | 852.16 KiB | 15.35 MiB | 18.44 | 2.01 million | 8 | | Number of rows INSERTed to all tables. |
| CurrentMetric_PartsCompact | Int64 | 851.09 KiB | 15.35 MiB | 18.46 | 2.01 million | 8 | | Compact parts. |
| CurrentMetric_PartsOutdated | Int64 | 847.76 KiB | 15.35 MiB | 18.54 | 2.01 million | 8 | | Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes. |
| ProfileEvent_NetworkReceiveElapsedMicroseconds | UInt64 | 838.90 KiB | 15.35 MiB | 18.73 | 2.01 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. |
| ProfileEvent_MergeTotalMilliseconds | UInt64 | 802.34 KiB | 15.35 MiB | 19.59 | 2.01 million | 8 | | Total time spent for background merges |
| ProfileEvent_MergeExecuteMilliseconds | UInt64 | 801.89 KiB | 15.35 MiB | 19.6 | 2.01 million | 8 | | Total busy time spent for execution of background merges |
| ProfileEvent_MergeHorizontalStageTotalMilliseconds | UInt64 | 797.96 KiB | 15.35 MiB | 19.69 | 2.01 million | 8 | | Total time spent for horizontal stage of background merges |
| ProfileEvent_MergeHorizontalStageExecuteMilliseconds | UInt64 | 794.76 KiB | 15.35 MiB | 19.77 | 2.01 million | 8 | | Total busy time spent for execution of horizontal stage of background merges |
| ProfileEvent_Seek | UInt64 | 756.89 KiB | 15.35 MiB | 20.76 | 2.01 million | 8 | | Number of times the 'lseek' function was called. |
| ProfileEvent_MemoryWorkerRun | UInt64 | 752.44 KiB | 15.35 MiB | 20.89 | 2.01 million | 8 | | Number of runs done by MemoryWorker in background |
| CurrentMetric_Read | Int64 | 750.90 KiB | 15.35 MiB | 20.93 | 2.01 million | 8 | | Number of read (read, pread, io_getevents, etc.) syscalls in fly |
| ProfileEvent_OpenedFileCacheMicroseconds | UInt64 | 695.38 KiB | 15.35 MiB | 22.6 | 2.01 million | 8 | | Amount of time spent executing OpenedFileCache methods. |
| ProfileEvent_LoadedMarksMemoryBytes | UInt64 | 690.29 KiB | 15.35 MiB | 22.77 | 2.01 million | 8 | | Size of in-memory representations of loaded marks. |
| ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds | UInt64 | 661.97 KiB | 15.35 MiB | 23.74 | 2.01 million | 8 | | Time spent merging input blocks (for special MergeTree engines) |
| ProfileEvent_LoadedMarksCount | UInt64 | 637.22 KiB | 15.35 MiB | 24.66 | 2.01 million | 8 | | Number of marks loaded (total across columns). |
| ProfileEvent_NetworkSendElapsedMicroseconds | UInt64 | 613.09 KiB | 15.35 MiB | 25.63 | 2.01 million | 8 | | 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_ConcurrencyControlSlotsGranted | UInt64 | 607.40 KiB | 15.35 MiB | 25.87 | 2.01 million | 8 | | Number of CPU slot granted according to guarantee of 1 thread per query and for queries with setting 'use_concurrency_control' = 0 |
| ProfileEvent_ConcurrencyControlSlotsAcquired | UInt64 | 607.40 KiB | 15.35 MiB | 25.87 | 2.01 million | 8 | | Total number of CPU slot acquired |
| CurrentMetric_PartsCommitted | Int64 | 591.09 KiB | 15.35 MiB | 26.59 | 2.01 million | 8 | | Deprecated. See PartsActive. |
| CurrentMetric_PartsActive | Int64 | 591.09 KiB | 15.35 MiB | 26.59 | 2.01 million | 8 | | Active data part, used by current and upcoming SELECTs. |
| ProfileEvent_OSCPUWaitMicroseconds | UInt64 | 580.25 KiB | 15.35 MiB | 27.08 | 2.01 million | 8 | | Total time a thread was ready for execution but waiting to be scheduled by OS, from the OS point of view. |
| ProfileEvent_CreatedReadBufferOrdinary | UInt64 | 577.86 KiB | 15.35 MiB | 27.2 | 2.01 million | 8 | | Number of times ordinary read buffer was created for reading data (while choosing among other read methods). |
| ProfileEvent_OpenedFileCacheMisses | UInt64 | 566.28 KiB | 15.35 MiB | 27.75 | 2.01 million | 8 | | Number of times a file has been found in the opened file cache, so we had to open it again. |
| ProfileEvent_InsertedCompactParts | UInt64 | 530.87 KiB | 15.35 MiB | 29.6 | 2.01 million | 8 | | Number of parts inserted in Compact format. |
| ProfileEvent_MergeTreeDataWriterBlocks | UInt64 | 530.86 KiB | 15.35 MiB | 29.6 | 2.01 million | 8 | | Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero. |
| ProfileEvent_MergingSortedMilliseconds | UInt64 | 523.95 KiB | 15.35 MiB | 29.99 | 2.01 million | 8 | | Total time spent while merging sorted columns |
| ProfileEvent_CannotWriteToWriteBufferDiscard | UInt64 | 519.46 KiB | 15.35 MiB | 30.25 | 2.01 million | 8 | | Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe. |
| CurrentMetric_AsynchronousInsertThreads | Int64 | 514.83 KiB | 15.35 MiB | 30.53 | 2.01 million | 8 | | Number of threads in the AsynchronousInsert thread pool. |
| CurrentMetric_AttachedDatabase | Int64 | 511.11 KiB | 15.35 MiB | 30.75 | 2.01 million | 8 | | Active databases. |
| CurrentMetric_AttachedTable | Int64 | 509.21 KiB | 15.35 MiB | 30.86 | 2.01 million | 8 | | Active tables. |
| CurrentMetric_ThreadPoolFSReaderThreads | Int64 | 509.10 KiB | 15.35 MiB | 30.87 | 2.01 million | 8 | | Number of threads in the thread pool for local_filesystem_read_method=threadpool. |
| CurrentMetric_BackgroundSchedulePoolSize | Int64 | 506.96 KiB | 15.35 MiB | 31 | 2.01 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_MergeTreeBackgroundExecutorThreadsScheduled | Int64 | 506.26 KiB | 15.35 MiB | 31.04 | 2.01 million | 8 | | Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool. |
| CurrentMetric_MergeTreeBackgroundExecutorThreads | Int64 | 506.26 KiB | 15.35 MiB | 31.04 | 2.01 million | 8 | | Number of threads in the MergeTreeBackgroundExecutor thread pool. |
| CurrentMetric_BackgroundMergesAndMutationsPoolSize | Int64 | 506.26 KiB | 15.35 MiB | 31.04 | 2.01 million | 8 | | Limit on number of active merges and mutations in an associated background pool |
| CurrentMetric_MergeTreeBackgroundExecutorThreadsActive | Int64 | 506.26 KiB | 15.35 MiB | 31.04 | 2.01 million | 8 | | Number of threads in the MergeTreeBackgroundExecutor thread pool running a task. |
| CurrentMetric_ConcurrencyControlSoftLimit | Int64 | 506.02 KiB | 15.35 MiB | 31.06 | 2.01 million | 8 | | Value of soft limit on number of CPU slots |
| CurrentMetric_BackgroundCommonPoolSize | Int64 | 506.02 KiB | 15.35 MiB | 31.06 | 2.01 million | 8 | | Limit on number of tasks in an associated background pool |
| CurrentMetric_BackgroundMovePoolSize | Int64 | 506.02 KiB | 15.35 MiB | 31.06 | 2.01 million | 8 | | Limit on number of tasks in BackgroundProcessingPool for moves |
| CurrentMetric_BackgroundMessageBrokerSchedulePoolSize | Int64 | 506.02 KiB | 15.35 MiB | 31.06 | 2.01 million | 8 | | Limit on number of tasks in BackgroundMessageBrokerSchedulePool for message streaming |
| CurrentMetric_BackgroundBufferFlushSchedulePoolSize | Int64 | 506.02 KiB | 15.35 MiB | 31.06 | 2.01 million | 8 | | Limit on number of tasks in BackgroundBufferFlushSchedulePool |
| CurrentMetric_BackgroundFetchesPoolSize | Int64 | 506.02 KiB | 15.35 MiB | 31.06 | 2.01 million | 8 | | Limit on number of simultaneous fetches in an associated background pool |
| CurrentMetric_BackgroundDistributedSchedulePoolSize | Int64 | 506.02 KiB | 15.35 MiB | 31.06 | 2.01 million | 8 | | Limit on number of tasks in BackgroundDistributedSchedulePool |
| CurrentMetric_AddressesActive | Int64 | 505.55 KiB | 15.35 MiB | 31.09 | 2.01 million | 8 | | Total count of addresses which are used for creation connections with connection pools |
| CurrentMetric_ZooKeeperSession | Int64 | 505.35 KiB | 15.35 MiB | 31.1 | 2.01 million | 8 | | 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_AttachedView | Int64 | 505.35 KiB | 15.35 MiB | 31.1 | 2.01 million | 8 | | Active views. |
| CurrentMetric_ZooKeeperWatch | Int64 | 505.35 KiB | 15.35 MiB | 31.1 | 2.01 million | 8 | | Number of watches (event subscriptions) in ZooKeeper. |
| CurrentMetric_MMappedFiles | Int64 | 505.32 KiB | 15.35 MiB | 31.1 | 2.01 million | 8 | | Total number of mmapped files. |
| CurrentMetric_IOWriterThreads | Int64 | 505.32 KiB | 15.35 MiB | 31.1 | 2.01 million | 8 | | Number of threads in the IO writer thread pool. |
| CurrentMetric_DiskConnectionsStored | Int64 | 505.32 KiB | 15.35 MiB | 31.1 | 2.01 million | 8 | | Total count of sessions stored in the session pool for disks |
| CurrentMetric_DiskConnectionsTotal | Int64 | 505.32 KiB | 15.35 MiB | 31.1 | 2.01 million | 8 | | Total count of all sessions: stored in the pool and actively used right now for disks |
| ProfileEvent_MergedColumns | UInt64 | 493.68 KiB | 15.35 MiB | 31.83 | 2.01 million | 8 | | Number of columns merged during the horizontal stage of merges. |
| CurrentMetric_OpenFileForRead | Int64 | 452.87 KiB | 15.35 MiB | 34.7 | 2.01 million | 8 | | Number of files open for reading |
| ProfileEvent_MergeProjectionStageTotalMilliseconds | UInt64 | 406.39 KiB | 15.35 MiB | 38.67 | 2.01 million | 8 | | Total time spent for projection stage of background merges |
| ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted | UInt64 | 401.49 KiB | 15.35 MiB | 39.14 | 2.01 million | 8 | | Number of blocks INSERTed to MergeTree tables that appeared to be already sorted. |
| ProfileEvent_MergeSourceParts | UInt64 | 366.24 KiB | 15.35 MiB | 42.91 | 2.01 million | 8 | | Number of source parts scheduled for merges. |
| ProfileEvent_MergeProjectionStageExecuteMilliseconds | UInt64 | 363.99 KiB | 15.35 MiB | 43.18 | 2.01 million | 8 | | Total busy time spent for execution of projection stage of background merges |
Rows per page
