| event_time_microseconds | DateTime64(6) | 10.65 MiB | 22.19 MiB | 2.08 | 2.91 million | 8 | | Event time with microseconds resolution. |
| event_time | DateTime | 7.38 MiB | 11.09 MiB | 1.5 | 2.91 million | 4 | | Event time. |
| ProfileEvent_ReadBufferFromFileDescriptorReadBytes | UInt64 | 6.58 MiB | 22.19 MiB | 3.37 | 2.91 million | 8 | | Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size. |
| ProfileEvent_DiskReadElapsedMicroseconds | UInt64 | 4.85 MiB | 22.19 MiB | 4.57 | 2.91 million | 8 | | Total time spent waiting for read syscall. This include reads from page cache. |
| ProfileEvent_PartsLockHoldMicroseconds | UInt64 | 4.50 MiB | 22.19 MiB | 4.93 | 2.91 million | 8 | | Total time spent holding data parts lock in MergeTree tables |
| CurrentMetric_MemoryTracking | Int64 | 4.34 MiB | 22.19 MiB | 5.11 | 2.91 million | 8 | | Total amount of memory (bytes) allocated by the server. |
| ProfileEvent_MemoryWorkerRunElapsedMicroseconds | UInt64 | 4.23 MiB | 22.19 MiB | 5.25 | 2.91 million | 8 | | Total time spent by MemoryWorker for background work |
| ProfileEvent_PartsLockWaitMicroseconds | UInt64 | 3.93 MiB | 22.19 MiB | 5.65 | 2.91 million | 8 | | Total time spent waiting for data parts lock in MergeTree tables |
| ProfileEvent_WriteBufferFromFileDescriptorWriteBytes | UInt64 | 3.70 MiB | 22.19 MiB | 6 | 2.91 million | 8 | | Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size. |
| ProfileEvent_IOBufferAllocBytes | UInt64 | 3.04 MiB | 22.19 MiB | 7.29 | 2.91 million | 8 | | Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer). |
| ProfileEvent_CompressedReadBufferBytes | UInt64 | 2.76 MiB | 22.19 MiB | 8.02 | 2.91 million | 8 | | Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network). |
| ProfileEvent_ContextLockWaitMicroseconds | UInt64 | 2.70 MiB | 22.19 MiB | 8.2 | 2.91 million | 8 | | Context lock wait time in microseconds |
| ProfileEvent_MergeTreeDataWriterCompressedBytes | UInt64 | 2.61 MiB | 22.19 MiB | 8.5 | 2.91 million | 8 | | Bytes written to filesystem for data INSERTed to MergeTree tables. |
| ProfileEvent_ContextLock | UInt64 | 2.56 MiB | 22.19 MiB | 8.66 | 2.91 million | 8 | | Number of times the lock of Context was acquired or tried to acquire. This is global lock. |
| ProfileEvent_DiskWriteElapsedMicroseconds | UInt64 | 2.54 MiB | 22.19 MiB | 8.72 | 2.91 million | 8 | | Total time spent waiting for write syscall. This include writes to page cache. |
| ProfileEvent_MergedUncompressedBytes | UInt64 | 2.50 MiB | 22.19 MiB | 8.89 | 2.91 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 | 2.45 MiB | 22.19 MiB | 9.04 | 2.91 million | 8 | | Number of bytes (the number of bytes before decompression) read from compressed sources (files, network). |
| ProfileEvent_RealTimeMicroseconds | UInt64 | 2.41 MiB | 22.19 MiB | 9.19 | 2.91 million | 8 | | Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum). |
| ProfileEvent_OSCPUVirtualTimeMicroseconds | UInt64 | 2.39 MiB | 22.19 MiB | 9.29 | 2.91 million | 8 | | CPU time spent seen by OS. Does not include involuntary waits due to virtualization. |
| ProfileEvent_UserTimeMicroseconds | UInt64 | 2.37 MiB | 22.19 MiB | 9.35 | 2.91 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 | 2.29 MiB | 22.19 MiB | 9.68 | 2.91 million | 8 | | Wide parts. |
| ProfileEvent_GWPAsanFree | UInt64 | 2.16 MiB | 22.19 MiB | 10.26 | 2.91 million | 8 | | Number of free operations done by GWPAsan |
| ProfileEvent_GWPAsanAllocateSuccess | UInt64 | 2.13 MiB | 22.19 MiB | 10.43 | 2.91 million | 8 | | Number of successful allocations done by GWPAsan |
| ProfileEvent_MergedRows | UInt64 | 2.03 MiB | 22.19 MiB | 10.91 | 2.91 million | 8 | | Rows read for background merges. This is the number of rows before merge. |
| ProfileEvent_RWLockAcquiredReadLocks | UInt64 | 2.03 MiB | 22.19 MiB | 10.94 | 2.91 million | 8 | | Number of times a read lock was acquired (in a heavy RWLock). |
| ProfileEvent_SystemTimeMicroseconds | UInt64 | 2.01 MiB | 22.19 MiB | 11.04 | 2.91 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_SoftPageFaults | UInt64 | 1.82 MiB | 22.19 MiB | 12.17 | 2.91 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.66 MiB | 22.19 MiB | 13.38 | 2.91 million | 8 | | Time spent sorting blocks |
| ProfileEvent_IOBufferAllocs | UInt64 | 1.65 MiB | 22.19 MiB | 13.48 | 2.91 million | 8 | | Number of allocations of IO buffers (for ReadBuffer/WriteBuffer). |
| ProfileEvent_LogTrace | UInt64 | 1.55 MiB | 22.19 MiB | 14.28 | 2.91 million | 8 | | Number of log messages with level Trace |
| ProfileEvent_OSReadChars | UInt64 | 1.51 MiB | 22.19 MiB | 14.69 | 2.91 million | 8 | | Number of bytes read from filesystem, including page cache. |
| ProfileEvent_ReadBufferFromFileDescriptorRead | UInt64 | 1.49 MiB | 22.19 MiB | 14.89 | 2.91 million | 8 | | Number of reads (read/pread) from a file descriptor. Does not include sockets. |
| ProfileEvent_SelectedBytes | UInt64 | 1.48 MiB | 22.19 MiB | 14.94 | 2.91 million | 8 | | Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables. |
| ProfileEvent_FileOpen | UInt64 | 1.48 MiB | 22.19 MiB | 14.96 | 2.91 million | 8 | | Number of files opened. |
| ProfileEvent_SelectedRows | UInt64 | 1.46 MiB | 22.19 MiB | 15.23 | 2.91 million | 8 | | Number of rows SELECTed from all tables. |
| ProfileEvent_CompressedReadBufferBlocks | UInt64 | 1.44 MiB | 22.19 MiB | 15.38 | 2.91 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 | 1.40 MiB | 22.19 MiB | 15.82 | 2.91 million | 8 | | Number of bytes written to filesystem, including page cache. |
| ProfileEvent_WriteBufferFromFileDescriptorWrite | UInt64 | 1.39 MiB | 22.19 MiB | 16.01 | 2.91 million | 8 | | Number of writes (write/pwrite) to a file descriptor. Does not include sockets. |
| ProfileEvent_FunctionExecute | UInt64 | 1.34 MiB | 22.19 MiB | 16.57 | 2.91 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_LogDebug | UInt64 | 1.28 MiB | 22.19 MiB | 17.38 | 2.91 million | 8 | | Number of log messages with level Debug |
| ProfileEvent_OSWriteBytes | UInt64 | 1.23 MiB | 22.19 MiB | 17.98 | 2.91 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_PartsOutdated | Int64 | 1.22 MiB | 22.19 MiB | 18.18 | 2.91 million | 8 | | Not active data part, but could be used by only current SELECTs, could be deleted after SELECTs finishes. |
| ProfileEvent_WaitMarksLoadMicroseconds | UInt64 | 1.21 MiB | 22.19 MiB | 18.29 | 2.91 million | 8 | | Time spent loading marks |
| CurrentMetric_PartsCompact | Int64 | 1.19 MiB | 22.19 MiB | 18.64 | 2.91 million | 8 | | Compact parts. |
| ProfileEvent_MergeTreeDataWriterUncompressedBytes | UInt64 | 1.16 MiB | 22.19 MiB | 19.12 | 2.91 million | 8 | | Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables. |
| ProfileEvent_InsertedBytes | UInt64 | 1.16 MiB | 22.19 MiB | 19.2 | 2.91 million | 8 | | Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables. |
| ProfileEvent_MergeExecuteMilliseconds | UInt64 | 1.14 MiB | 22.19 MiB | 19.42 | 2.91 million | 8 | | Total busy time spent for execution of background merges |
| ProfileEvent_MergeTotalMilliseconds | UInt64 | 1.14 MiB | 22.19 MiB | 19.45 | 2.91 million | 8 | | Total time spent for background merges |
| ProfileEvent_MergeHorizontalStageExecuteMilliseconds | UInt64 | 1.13 MiB | 22.19 MiB | 19.59 | 2.91 million | 8 | | Total busy time spent for execution of horizontal stage of background merges |
| ProfileEvent_MergeHorizontalStageTotalMilliseconds | UInt64 | 1.13 MiB | 22.19 MiB | 19.59 | 2.91 million | 8 | | Total time spent for horizontal stage of background merges |
| ProfileEvent_NetworkReceiveElapsedMicroseconds | UInt64 | 1.09 MiB | 22.19 MiB | 20.39 | 2.91 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_MergeTreeDataWriterRows | UInt64 | 1.08 MiB | 22.19 MiB | 20.57 | 2.91 million | 8 | | Number of rows INSERTed to MergeTree tables. |
| ProfileEvent_InsertedRows | UInt64 | 1.08 MiB | 22.19 MiB | 20.59 | 2.91 million | 8 | | Number of rows INSERTed to all tables. |
| ProfileEvent_Seek | UInt64 | 1.06 MiB | 22.19 MiB | 20.84 | 2.91 million | 8 | | Number of times the 'lseek' function was called. |
| ProfileEvent_MemoryWorkerRun | UInt64 | 1.06 MiB | 22.19 MiB | 20.91 | 2.91 million | 8 | | Number of runs done by MemoryWorker in background |
| CurrentMetric_Read | Int64 | 1.06 MiB | 22.19 MiB | 20.96 | 2.91 million | 8 | | Number of read (read, pread, io_getevents, etc.) syscalls in fly |
| ProfileEvent_LoadedMarksMemoryBytes | UInt64 | 940.68 KiB | 22.19 MiB | 24.15 | 2.91 million | 8 | | Size of in-memory representations of loaded marks. |
| ProfileEvent_OpenedFileCacheMicroseconds | UInt64 | 938.08 KiB | 22.19 MiB | 24.22 | 2.91 million | 8 | | Amount of time spent executing OpenedFileCache methods. |
| ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds | UInt64 | 919.06 KiB | 22.19 MiB | 24.72 | 2.91 million | 8 | | Time spent merging input blocks (for special MergeTree engines) |
| ProfileEvent_LoadedMarksCount | UInt64 | 881.75 KiB | 22.19 MiB | 25.76 | 2.91 million | 8 | | Number of marks loaded (total across columns). |
| CurrentMetric_PartsActive | Int64 | 820.67 KiB | 22.19 MiB | 27.68 | 2.91 million | 8 | | Active data part, used by current and upcoming SELECTs. |
| CurrentMetric_PartsCommitted | Int64 | 820.67 KiB | 22.19 MiB | 27.68 | 2.91 million | 8 | | Deprecated. See PartsActive. |
| ProfileEvent_NetworkSendElapsedMicroseconds | UInt64 | 804.37 KiB | 22.19 MiB | 28.24 | 2.91 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_OSCPUWaitMicroseconds | UInt64 | 801.72 KiB | 22.19 MiB | 28.34 | 2.91 million | 8 | | Total time a thread was ready for execution but waiting to be scheduled by OS, from the OS point of view. |
| ProfileEvent_MergingSortedMilliseconds | UInt64 | 777.75 KiB | 22.19 MiB | 29.21 | 2.91 million | 8 | | Total time spent while merging sorted columns |
| ProfileEvent_CreatedReadBufferOrdinary | UInt64 | 765.26 KiB | 22.19 MiB | 29.69 | 2.91 million | 8 | | Number of times ordinary read buffer was created for reading data (while choosing among other read methods). |
| ProfileEvent_OpenedFileCacheMisses | UInt64 | 758.37 KiB | 22.19 MiB | 29.96 | 2.91 million | 8 | | Number of times a file has been found in the opened file cache, so we had to open it again. |
| ProfileEvent_MergeTreeDataWriterBlocks | UInt64 | 748.28 KiB | 22.19 MiB | 30.36 | 2.91 million | 8 | | Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero. |
| ProfileEvent_InsertedCompactParts | UInt64 | 748.26 KiB | 22.19 MiB | 30.36 | 2.91 million | 8 | | Number of parts inserted in Compact format. |
| CurrentMetric_ThreadPoolFSReaderThreads | Int64 | 744.74 KiB | 22.19 MiB | 30.5 | 2.91 million | 8 | | Number of threads in the thread pool for local_filesystem_read_method=threadpool. |
| CurrentMetric_AsynchronousInsertThreads | Int64 | 737.70 KiB | 22.19 MiB | 30.8 | 2.91 million | 8 | | Number of threads in the AsynchronousInsert thread pool. |
| CurrentMetric_AttachedDatabase | Int64 | 737.46 KiB | 22.19 MiB | 30.81 | 2.91 million | 8 | | Active databases. |
| CurrentMetric_BackgroundSchedulePoolSize | Int64 | 731.22 KiB | 22.19 MiB | 31.07 | 2.91 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_AttachedTable | Int64 | 731.10 KiB | 22.19 MiB | 31.07 | 2.91 million | 8 | | Active tables. |
| CurrentMetric_BackgroundMergesAndMutationsPoolSize | Int64 | 730.27 KiB | 22.19 MiB | 31.11 | 2.91 million | 8 | | Limit on number of active merges and mutations in an associated background pool |
| CurrentMetric_MergeTreeBackgroundExecutorThreads | Int64 | 730.27 KiB | 22.19 MiB | 31.11 | 2.91 million | 8 | | Number of threads in the MergeTreeBackgroundExecutor thread pool. |
| CurrentMetric_MergeTreeBackgroundExecutorThreadsActive | Int64 | 730.27 KiB | 22.19 MiB | 31.11 | 2.91 million | 8 | | Number of threads in the MergeTreeBackgroundExecutor thread pool running a task. |
| CurrentMetric_MergeTreeBackgroundExecutorThreadsScheduled | Int64 | 730.27 KiB | 22.19 MiB | 31.11 | 2.91 million | 8 | | Number of queued or active jobs in the MergeTreeBackgroundExecutor thread pool. |
| CurrentMetric_BackgroundMessageBrokerSchedulePoolSize | Int64 | 729.95 KiB | 22.19 MiB | 31.12 | 2.91 million | 8 | | Limit on number of tasks in BackgroundProcessingPool for message streaming |
| CurrentMetric_BackgroundBufferFlushSchedulePoolSize | Int64 | 729.95 KiB | 22.19 MiB | 31.12 | 2.91 million | 8 | | Limit on number of tasks in BackgroundBufferFlushSchedulePool |
| CurrentMetric_BackgroundDistributedSchedulePoolSize | Int64 | 729.95 KiB | 22.19 MiB | 31.12 | 2.91 million | 8 | | Limit on number of tasks in BackgroundDistributedSchedulePool |
| CurrentMetric_BackgroundFetchesPoolSize | Int64 | 729.95 KiB | 22.19 MiB | 31.12 | 2.91 million | 8 | | Limit on number of simultaneous fetches in an associated background pool |
| CurrentMetric_BackgroundCommonPoolSize | Int64 | 729.95 KiB | 22.19 MiB | 31.12 | 2.91 million | 8 | | Limit on number of tasks in an associated background pool |
| CurrentMetric_BackgroundMovePoolSize | Int64 | 729.95 KiB | 22.19 MiB | 31.12 | 2.91 million | 8 | | Limit on number of tasks in BackgroundProcessingPool for moves |
| ProfileEvent_CannotWriteToWriteBufferDiscard | UInt64 | 729.92 KiB | 22.19 MiB | 31.12 | 2.91 million | 8 | | Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe. |
| CurrentMetric_AddressesActive | Int64 | 729.31 KiB | 22.19 MiB | 31.15 | 2.91 million | 8 | | Total count of addresses which are used for creation connections with connection pools |
| CurrentMetric_AttachedView | Int64 | 729.04 KiB | 22.19 MiB | 31.16 | 2.91 million | 8 | | Active views. |
| CurrentMetric_ZooKeeperWatch | Int64 | 729.04 KiB | 22.19 MiB | 31.16 | 2.91 million | 8 | | Number of watches (event subscriptions) in ZooKeeper. |
| CurrentMetric_ZooKeeperSession | Int64 | 729.04 KiB | 22.19 MiB | 31.16 | 2.91 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_DiskConnectionsTotal | Int64 | 728.99 KiB | 22.19 MiB | 31.16 | 2.91 million | 8 | | Total count of all sessions: stored in the pool and actively used right now for disks |
| CurrentMetric_DiskConnectionsStored | Int64 | 728.99 KiB | 22.19 MiB | 31.16 | 2.91 million | 8 | | Total count of sessions stored in the session pool for disks |
| CurrentMetric_MMappedFiles | Int64 | 728.99 KiB | 22.19 MiB | 31.16 | 2.91 million | 8 | | Total number of mmapped files. |
| CurrentMetric_IOWriterThreads | Int64 | 728.99 KiB | 22.19 MiB | 31.16 | 2.91 million | 8 | | Number of threads in the IO writer thread pool. |
| ProfileEvent_MergedColumns | UInt64 | 715.59 KiB | 22.19 MiB | 31.75 | 2.91 million | 8 | | Number of columns merged during the horizontal stage of merges. |
| CurrentMetric_OpenFileForRead | Int64 | 631.46 KiB | 22.19 MiB | 35.98 | 2.91 million | 8 | | Number of files open for reading |
| ProfileEvent_GWPAsanAllocateFailed | UInt64 | 615.25 KiB | 22.19 MiB | 36.92 | 2.91 million | 8 | | Number of failed allocations done by GWPAsan (i.e. filled pool) |
| ProfileEvent_MergeProjectionStageTotalMilliseconds | UInt64 | 584.37 KiB | 22.19 MiB | 38.88 | 2.91 million | 8 | | Total time spent for projection stage of background merges |
| ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted | UInt64 | 560.74 KiB | 22.19 MiB | 40.51 | 2.91 million | 8 | | Number of blocks INSERTed to MergeTree tables that appeared to be already sorted. |
| ProfileEvent_MergeProjectionStageExecuteMilliseconds | UInt64 | 523.83 KiB | 22.19 MiB | 43.37 | 2.91 million | 8 | | Total busy time spent for execution of projection stage of background merges |
| CurrentMetric_MergesMutationsMemoryTracking | Int64 | 520.29 KiB | 21.49 MiB | 42.29 | 2.91 million | 7.75 | | Total amount of memory (bytes) allocated by background tasks (merges and mutations). |
Rows per page
