| 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 | 995.15 KiB | 30.27 MiB | 31.15 | 3.97 million | 8 | | Limit on number of tasks in BackgroundProcessingPool for moves |
| CurrentMetric_AddressesActive | Int64 | 994.30 KiB | 30.27 MiB | 31.17 | 3.97 million | 8 | | Total count of addresses which are used for creation connections with connection pools |
| CurrentMetric_ZooKeeperWatch | Int64 | 994.20 KiB | 30.27 MiB | 31.18 | 3.97 million | 8 | | Number of watches (event subscriptions) in ZooKeeper. |
| CurrentMetric_ZooKeeperSession | Int64 | 994.20 KiB | 30.27 MiB | 31.18 | 3.97 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_DiskConnectionsStored | Int64 | 993.88 KiB | 30.27 MiB | 31.19 | 3.97 million | 8 | | Total count of sessions stored in the session pool for disks |
| CurrentMetric_DiskConnectionsTotal | Int64 | 993.87 KiB | 30.27 MiB | 31.19 | 3.97 million | 8 | | Total count of all sessions: stored in the pool and actively used right now for disks |
| CurrentMetric_MMappedFiles | Int64 | 993.87 KiB | 30.27 MiB | 31.19 | 3.97 million | 8 | | Total number of mmapped files. |
| CurrentMetric_IOWriterThreads | Int64 | 993.87 KiB | 30.27 MiB | 31.19 | 3.97 million | 8 | | Number of threads in the IO writer thread pool. |
| ProfileEvent_MergeTreeDataWriterBlocks | UInt64 | 954.03 KiB | 30.27 MiB | 32.49 | 3.97 million | 8 | | Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero. |
| ProfileEvent_InsertedCompactParts | UInt64 | 953.99 KiB | 30.27 MiB | 32.49 | 3.97 million | 8 | | Number of parts inserted in Compact format. |
| ProfileEvent_NetworkSendElapsedMicroseconds | UInt64 | 953.88 KiB | 30.27 MiB | 32.49 | 3.97 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_LoadedMarksCount | UInt64 | 935.81 KiB | 30.27 MiB | 33.12 | 3.97 million | 8 | | Number of marks loaded (total across columns). |
| CurrentMetric_AttachedView | Int64 | 895.98 KiB | 30.27 MiB | 34.59 | 3.97 million | 8 | | Active views. |
| ProfileEvent_OSCPUWaitMicroseconds | UInt64 | 892.61 KiB | 30.27 MiB | 34.72 | 3.97 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 | 833.94 KiB | 30.27 MiB | 37.17 | 3.97 million | 8 | | Number of times ordinary read buffer was created for reading data (while choosing among other read methods). |
| ProfileEvent_CannotWriteToWriteBufferDiscard | UInt64 | 822.97 KiB | 30.27 MiB | 37.66 | 3.97 million | 8 | | Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe. |
| CurrentMetric_OpenFileForRead | Int64 | 822.30 KiB | 30.27 MiB | 37.69 | 3.97 million | 8 | | Number of files open for reading |
| ProfileEvent_OpenedFileCacheMisses | UInt64 | 814.29 KiB | 30.27 MiB | 38.06 | 3.97 million | 8 | | Number of times a file has been found in the opened file cache, so we had to open it again. |
| ProfileEvent_GWPAsanAllocateFailed | UInt64 | 753.53 KiB | 30.27 MiB | 41.13 | 3.97 million | 8 | | Number of failed allocations done by GWPAsan (i.e. filled pool) |
| ProfileEvent_MergedColumns | UInt64 | 747.95 KiB | 30.27 MiB | 41.44 | 3.97 million | 8 | | Number of columns merged during the horizontal stage of merges. |
| ProfileEvent_MergeProjectionStageTotalMilliseconds | UInt64 | 694.87 KiB | 30.27 MiB | 44.61 | 3.97 million | 8 | | Total time spent for projection stage of background merges |
| ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted | UInt64 | 655.47 KiB | 30.27 MiB | 47.29 | 3.97 million | 8 | | Number of blocks INSERTed to MergeTree tables that appeared to be already sorted. |
| ProfileEvent_MergeProjectionStageExecuteMilliseconds | UInt64 | 615.63 KiB | 30.27 MiB | 50.35 | 3.97 million | 8 | | Total busy time spent for execution of projection stage of background merges |
| CurrentMetric_MergesMutationsMemoryTracking | Int64 | 607.04 KiB | 23.86 MiB | 40.25 | 3.97 million | 6.31 | | Total amount of memory (bytes) allocated by background tasks (merges and mutations). |
| ProfileEvent_Merge | UInt64 | 575.70 KiB | 30.27 MiB | 53.84 | 3.97 million | 8 | | Number of launched background merges. |
| ProfileEvent_NetworkSendBytes | UInt64 | 465.18 KiB | 30.27 MiB | 66.63 | 3.97 million | 8 | | Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries. |
| ProfileEvent_NetworkReceiveBytes | UInt64 | 431.45 KiB | 30.27 MiB | 71.84 | 3.97 million | 8 | | Total number of bytes received from network. Only ClickHouse-related network interaction is included, not by 3rd party libraries. |
Rows per page
