| 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 |
