system.query_metric_log

Querying in ClickHouse Cloud

The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the clusterAllReplicas function. See here for further details.

Description

Contains a history of memory and metric values from table system.events for individual queries, periodically flushed to disk.

Once a query starts, data is collected at periodic intervals of query_metric_log_interval milliseconds (which is set to 1000 by default). The data is also collected when the query finishes if the query takes longer than query_metric_log_interval.

Columns

query_id (String) — Query ID.
hostname (LowCardinality(String)) — Hostname of the server executing the query.
event_date (Date) — Event date.
event_time (DateTime) — Event time.
event_time_microseconds (DateTime64(6)) — Event time with microseconds resolution.
memory_usage (UInt64) — Amount of RAM the query uses. It might not include some types of dedicated memory.
peak_memory_usage (UInt64) — Maximum amount of RAM the query used.
ProfileEvent_Query (UInt64) — Number of queries to be interpreted and potentially executed. Does not include queries that failed to parse or were rejected due to AST size limits, quota limits or limits on the number of simultaneously running queries. May include internal queries initiated by ClickHouse itself. Does not count subqueries.
ProfileEvent_SelectQuery (UInt64) — Same as Query, but only for SELECT queries.
ProfileEvent_InsertQuery (UInt64) — Same as Query, but only for INSERT queries.
ProfileEvent_InitialQuery (UInt64) — Same as Query, but only counts initial queries (see is_initial_query).
ProfileEvent_InitialSelectQuery (UInt64) — Same as InitialQuery, but only for SELECT queries.
ProfileEvent_QueriesWithSubqueries (UInt64) — Count queries with all subqueries
ProfileEvent_SelectQueriesWithSubqueries (UInt64) — Count SELECT queries with all subqueries
ProfileEvent_InsertQueriesWithSubqueries (UInt64) — Count INSERT queries with all subqueries
ProfileEvent_SelectQueriesWithPrimaryKeyUsage (UInt64) — Count SELECT queries which use the primary key to evaluate the WHERE condition
ProfileEvent_AsyncInsertQuery (UInt64) — Same as InsertQuery, but only for asynchronous INSERT queries.
ProfileEvent_AsyncInsertBytes (UInt64) — Data size in bytes of asynchronous INSERT queries.
ProfileEvent_AsyncInsertRows (UInt64) — Number of rows inserted by asynchronous INSERT queries.
ProfileEvent_AsyncInsertCacheHits (UInt64) — Number of times a duplicate hash id has been found in asynchronous INSERT hash id cache.
ProfileEvent_FailedInternalQuery (UInt64) — Number of failed internal queries.
ProfileEvent_FailedInternalSelectQuery (UInt64) — Same as FailedInternalQuery, but only for SELECT queries.
ProfileEvent_FailedInternalInsertQuery (UInt64) — Same as FailedInternalQuery, but only for INSERT queries.
ProfileEvent_FailedInitialQuery (UInt64) — Number of failed initial queries.
ProfileEvent_FailedInitialSelectQuery (UInt64) — Same as FailedInitialQuery, but only for SELECT queries.
ProfileEvent_FailedQuery (UInt64) — Number of total failed queries, both internal and user queries.
ProfileEvent_FailedSelectQuery (UInt64) — Same as FailedQuery, but only for SELECT queries.
ProfileEvent_FailedInsertQuery (UInt64) — Same as FailedQuery, but only for INSERT queries.
ProfileEvent_FailedAsyncInsertQuery (UInt64) — Number of failed ASYNC INSERT queries.
ProfileEvent_ASTFuzzerQueries (UInt64) — Number of fuzzed queries attempted by the server-side AST fuzzer.
ProfileEvent_QueryTimeMicroseconds (UInt64) — Total time of all queries.
ProfileEvent_SelectQueryTimeMicroseconds (UInt64) — Total time of SELECT queries.
ProfileEvent_InsertQueryTimeMicroseconds (UInt64) — Total time of INSERT queries.
ProfileEvent_OtherQueryTimeMicroseconds (UInt64) — Total time of queries that are not SELECT or INSERT.
ProfileEvent_FileOpen (UInt64) — Number of files opened.
ProfileEvent_Seek (UInt64) — Number of times the 'lseek' function was called.
ProfileEvent_ReadBufferFromFileDescriptorRead (UInt64) — Number of reads (read/pread) from a file descriptor. Does not include sockets.
ProfileEvent_ReadBufferFromFileDescriptorReadFailed (UInt64) — Number of times the read (read/pread) from a file descriptor have failed.
ProfileEvent_ReadBufferFromFileDescriptorReadBytes (UInt64) — Number of bytes read from file descriptors. If the file is compressed, this will show the compressed data size.
ProfileEvent_WriteBufferFromFileDescriptorWrite (UInt64) — Number of writes (write/pwrite) to a file descriptor. Does not include sockets.
ProfileEvent_WriteBufferFromFileDescriptorWriteFailed (UInt64) — Number of times the write (write/pwrite) to a file descriptor have failed.
ProfileEvent_WriteBufferFromFileDescriptorWriteBytes (UInt64) — Number of bytes written to file descriptors. If the file is compressed, this will show compressed data size.
ProfileEvent_FileSync (UInt64) — Number of times the F_FULLFSYNC/fsync/fdatasync function was called for files.
ProfileEvent_DirectorySync (UInt64) — Number of times the F_FULLFSYNC/fsync/fdatasync function was called for directories.
ProfileEvent_FileSyncElapsedMicroseconds (UInt64) — Total time spent waiting for F_FULLFSYNC/fsync/fdatasync syscall for files.
ProfileEvent_DirectorySyncElapsedMicroseconds (UInt64) — Total time spent waiting for F_FULLFSYNC/fsync/fdatasync syscall for directories.
ProfileEvent_ReadCompressedBytes (UInt64) — Number of bytes (the number of bytes before decompression) read from compressed sources (files, network).
ProfileEvent_CompressedReadBufferBlocks (UInt64) — Number of compressed blocks (the blocks of data that are compressed independent of each other) read from compressed sources (files, network).
ProfileEvent_CompressedReadBufferBytes (UInt64) — Number of uncompressed bytes (the number of bytes after decompression) read from compressed sources (files, network).
ProfileEvent_CompressedReadBufferChecksumDoesntMatch (UInt64) — Number of times the compressed block checksum did not match.
ProfileEvent_CompressedReadBufferChecksumDoesntMatchSingleBitMismatch (UInt64) — Number of times a compressed block checksum mismatch was caused by a single-bit difference.
ProfileEvent_CompressedReadBufferChecksumDoesntMatchMicroseconds (UInt64) — Total time spent detecting bit-flips due to compressed block checksum mismatches.
ProfileEvent_UncompressedCacheHits (UInt64) — Number of times a block of data has been found in the uncompressed cache (and decompression was avoided).
ProfileEvent_UncompressedCacheMisses (UInt64) — Number of times a block of data has not been found in the uncompressed cache (and required decompression).
ProfileEvent_UncompressedCacheWeightLost (UInt64) — Number of bytes evicted from the uncompressed cache.
ProfileEvent_PageCacheHits (UInt64) — Number of times a block of data has been found in the userspace page cache.
ProfileEvent_PageCacheMisses (UInt64) — Number of times a block of data has not been found in the userspace page cache.
ProfileEvent_PageCacheWeightLost (UInt64) — Number of bytes evicted from the userspace page cache
ProfileEvent_PageCacheResized (UInt64) — Number of times the userspace page cache was auto-resized (typically happens a few times per second, controlled by memory_worker_period_ms).
ProfileEvent_PageCacheOvercommitResize (UInt64) — Number of times the userspace page cache was auto-resized to free memory during a memory allocation.
ProfileEvent_PageCacheReadBytes (UInt64) — Number of bytes read from userspace page cache.
ProfileEvent_MMappedFileCacheHits (UInt64) — Number of times a file has been found in the MMap cache (for the 'mmap' read_method), so we didn't have to mmap it again.
ProfileEvent_MMappedFileCacheMisses (UInt64) — Number of times a file has not been found in the MMap cache (for the 'mmap' read_method), so we had to mmap it again.
ProfileEvent_OpenedFileCacheHits (UInt64) — Number of times a file has been found in the opened file cache, so we didn't have to open it again.
ProfileEvent_OpenedFileCacheMisses (UInt64) — Number of times a file has been found in the opened file cache, so we had to open it again.
ProfileEvent_OpenedFileCacheMicroseconds (UInt64) — Amount of time spent executing OpenedFileCache methods.
ProfileEvent_AIOWrite (UInt64) — Number of writes with Linux or FreeBSD AIO interface
ProfileEvent_AIOWriteBytes (UInt64) — Number of bytes written with Linux or FreeBSD AIO interface
ProfileEvent_AIORead (UInt64) — Number of reads with Linux or FreeBSD AIO interface
ProfileEvent_AIOReadBytes (UInt64) — Number of bytes read with Linux or FreeBSD AIO interface
ProfileEvent_IOBufferAllocs (UInt64) — Number of allocations of IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_IOBufferAllocBytes (UInt64) — Number of bytes allocated for IO buffers (for ReadBuffer/WriteBuffer).
ProfileEvent_ArenaAllocChunks (UInt64) — Number of chunks allocated for memory Arena (used for GROUP BY and similar operations)
ProfileEvent_ArenaAllocBytes (UInt64) — Number of bytes allocated for memory Arena (used for GROUP BY and similar operations)
ProfileEvent_FunctionExecute (UInt64) — Number of SQL ordinary function calls (SQL functions are called on per-block basis, so this number represents the number of blocks).
ProfileEvent_TableFunctionExecute (UInt64) — Number of table function calls.
ProfileEvent_DefaultImplementationForNullsRows (UInt64) — Number of rows processed by default implementation for nulls in function execution
ProfileEvent_DefaultImplementationForNullsRowsWithNulls (UInt64) — Number of rows which contain null values processed by default implementation for nulls in function execution
ProfileEvent_MarkCacheHits (UInt64) — Number of times an entry has been found in the mark cache, so we didn't have to load a mark file.
ProfileEvent_MarkCacheMisses (UInt64) — Number of times an entry has not been found in the mark cache, so we had to load a mark file in memory, which is a costly operation, adding to query latency.
ProfileEvent_PrimaryIndexCacheHits (UInt64) — Number of times an entry has been found in the primary index cache, so we didn't have to load a index file.
ProfileEvent_PrimaryIndexCacheMisses (UInt64) — Number of times an entry has not been found in the primary index cache, so we had to load a index file in memory, which is a costly operation, adding to query latency.
ProfileEvent_IcebergMetadataFilesCacheHits (UInt64) — Number of times iceberg metadata files have been found in the cache.
ProfileEvent_IcebergMetadataFilesCacheMisses (UInt64) — Number of times iceberg metadata files have not been found in the iceberg metadata cache and had to be read from (remote) disk.
ProfileEvent_IcebergMetadataFilesCacheStaleMisses (UInt64) — Number of times iceberg metadata files have been found in the cache, but were considered stale and had to be read from (remote) disk.
ProfileEvent_IcebergMetadataFilesCacheWeightLost (UInt64) — Approximate number of bytes evicted from the iceberg metadata cache.
ProfileEvent_IcebergMetadataReadWaitTimeMicroseconds (UInt64) — Total time data readers spend waiting for iceberg metadata files to be read and parsed, summed across all reader threads.
ProfileEvent_ParquetMetadataCacheHits (UInt64) — Number of times parquet metadata has been found in the cache.
ProfileEvent_ParquetMetadataCacheMisses (UInt64) — Number of times parquet metadata has not been found in the cache and had to be read from disk.
ProfileEvent_ParquetMetadataCacheWeightLost (UInt64) — Approximate number of bytes evicted from the parquet metadata cache.
ProfileEvent_IcebergIteratorInitializationMicroseconds (UInt64) — Total time spent on synchronous initialization of iceberg data iterators.
ProfileEvent_IcebergMetadataUpdateMicroseconds (UInt64) — Total time spent on synchronous initialization of iceberg data iterators.
ProfileEvent_IcebergMetadataReturnedObjectInfos (UInt64) — Total number of returned object infos from iceberg iterator.
ProfileEvent_IcebergMinMaxNonPrunedDeleteFiles (UInt64) — Total number of accepted data files-position delete file pairs by minmax analysis from pairs suitable by partitioning and sequence number.
ProfileEvent_IcebergMinMaxPrunedDeleteFiles (UInt64) — Total number of accepted data files-position delete file pairs by minmax analysis from pairs suitable by partitioning and sequence number.
ProfileEvent_VectorSimilarityIndexCacheHits (UInt64) — Number of times an index granule has been found in the vector index cache.
ProfileEvent_VectorSimilarityIndexCacheMisses (UInt64) — Number of times an index granule has not been found in the vector index cache and had to be read from disk.
ProfileEvent_VectorSimilarityIndexCacheWeightLost (UInt64) — Approximate number of bytes evicted from the vector index cache.
ProfileEvent_TextIndexReadDictionaryBlocks (UInt64) — Number of times a text index dictionary block has been read from disk.
ProfileEvent_TextIndexTokensCacheHits (UInt64) — Number of times a text index token info has been found in the cache.
ProfileEvent_TextIndexTokensCacheMisses (UInt64) — Number of times a text index token info has not been found in the cache.
ProfileEvent_TextIndexHeaderCacheHits (UInt64) — Number of times a header has been found in the cache.
ProfileEvent_TextIndexHeaderCacheMisses (UInt64) — Number of times a header has not been found in the cache.
ProfileEvent_TextIndexPostingsCacheHits (UInt64) — Number of times a text index posting list has been found in the cache.
ProfileEvent_TextIndexPostingsCacheMisses (UInt64) — Number of times a a text index posting list has not been found in the cache.
ProfileEvent_TextIndexReadSparseIndexBlocks (UInt64) — Number of times a sparse index block has been read from the text index.
ProfileEvent_TextIndexReaderTotalMicroseconds (UInt64) — Total time spent reading the text index.
ProfileEvent_TextIndexReadGranulesMicroseconds (UInt64) — Total time spent reading and analyzing granules of the text index.
ProfileEvent_TextIndexReadPostings (UInt64) — Number of times a posting list has been read from the text index.
ProfileEvent_TextIndexUsedEmbeddedPostings (UInt64) — Number of times a posting list embedded in the dictionary has been used.
ProfileEvent_TextIndexUseHint (UInt64) — Number of index granules where a direct reading from the text index was added as hint and was used.
ProfileEvent_TextIndexDiscardHint (UInt64) — Number of index granules where a direct reading from the text index was added as hint and was discarded due to low selectivity.
ProfileEvent_TextIndexDiscardPatternScan (UInt64) — Number of times pattern-based dictionary scan in a text index was discarded because the number of posting lists to read exceeded the threshold.
ProfileEvent_QueryConditionCacheHits (UInt64) — Number of times an entry has been found in the query condition cache (and reading of marks can be skipped). Only updated for SELECT queries with SETTING use_query_condition_cache = 1.
ProfileEvent_QueryConditionCacheMisses (UInt64) — Number of times an entry has not been found in the query condition cache (and reading of mark cannot be skipped). Only updated for SELECT queries with SETTING use_query_condition_cache = 1.
ProfileEvent_QueryCacheHits (UInt64) — Number of times a query result has been found in the query cache (and query computation was avoided). Only updated for SELECT queries with SETTING use_query_cache = 1.
ProfileEvent_QueryCacheMisses (UInt64) — Number of times a query result has not been found in the query cache (and required query computation). Only updated for SELECT queries with SETTING use_query_cache = 1.
ProfileEvent_QueryCacheAgeSeconds (UInt64) — The sum of ages of found query cache entries in seconds. The value is set both for hits and misses.
ProfileEvent_QueryCacheReadRows (UInt64) — The number of rows read from the query cache.
ProfileEvent_QueryCacheReadBytes (UInt64) — The number of (uncompressed) bytes read from the query cache.
ProfileEvent_QueryCacheWrittenRows (UInt64) — The number of rows saved into the query cache.
ProfileEvent_QueryCacheWrittenBytes (UInt64) — The number of (uncompressed) bytes saved into the query cache
ProfileEvent_CreatedReadBufferOrdinary (UInt64) — Number of times ordinary read buffer was created for reading data (while choosing among other read methods).
ProfileEvent_CreatedReadBufferDirectIO (UInt64) — Number of times a read buffer with O_DIRECT was created for reading data (while choosing among other read methods).
ProfileEvent_CreatedReadBufferDirectIOFailed (UInt64) — Number of times a read buffer with O_DIRECT was attempted to be created for reading data (while choosing among other read methods), but the OS did not allow it (due to lack of filesystem support or other reasons) and we fallen back to the ordinary reading method.
ProfileEvent_CreatedReadBufferMMap (UInt64) — Number of times a read buffer using 'mmap' was created for reading data (while choosing among other read methods).
ProfileEvent_CreatedReadBufferMMapFailed (UInt64) — Number of times a read buffer with 'mmap' was attempted to be created for reading data (while choosing among other read methods), but the OS did not allow it (due to lack of filesystem support or other reasons) and we fallen back to the ordinary reading method.
ProfileEvent_DiskReadElapsedMicroseconds (UInt64) — Total time spent waiting for read syscall. This include reads from page cache.
ProfileEvent_DiskWriteElapsedMicroseconds (UInt64) — Total time spent waiting for write syscall. This include writes to page cache.
ProfileEvent_NetworkReceiveElapsedMicroseconds (UInt64) — 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_NetworkSendElapsedMicroseconds (UInt64) — 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_NetworkReceiveBytes (UInt64) — Total number of bytes received from network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_NetworkSendBytes (UInt64) — Total number of bytes send to network. Only ClickHouse-related network interaction is included, not by 3rd party libraries.
ProfileEvent_FilterPartsByVirtualColumnsMicroseconds (UInt64) — Total time spent in filterPartsByVirtualColumns function.
ProfileEvent_GlobalThreadPoolExpansions (UInt64) — Counts the total number of times new threads have been added to the global thread pool. This metric indicates the frequency of expansions in the global thread pool to accommodate increased processing demands.
ProfileEvent_GlobalThreadPoolShrinks (UInt64) — Counts the total number of times the global thread pool has shrunk by removing threads. This occurs when the number of idle threads exceeds max_thread_pool_free_size, indicating adjustments in the global thread pool size in response to decreased thread utilization.
ProfileEvent_GlobalThreadPoolThreadCreationMicroseconds (UInt64) — Total time spent waiting for new threads to start.
ProfileEvent_GlobalThreadPoolLockWaitMicroseconds (UInt64) — Total time threads have spent waiting for locks in the global thread pool.
ProfileEvent_GlobalThreadPoolJobs (UInt64) — Counts the number of jobs that have been pushed to the global thread pool.
ProfileEvent_GlobalThreadPoolJobWaitTimeMicroseconds (UInt64) — Measures the elapsed time from when a job is scheduled in the thread pool to when it is picked up for execution by a worker thread. This metric helps identify delays in job processing, indicating the responsiveness of the thread pool to new tasks.
ProfileEvent_LocalThreadPoolExpansions (UInt64) — Counts the total number of times threads have been borrowed from the global thread pool to expand local thread pools.
ProfileEvent_LocalThreadPoolShrinks (UInt64) — Counts the total number of times threads have been returned to the global thread pool from local thread pools.
ProfileEvent_LocalThreadPoolThreadCreationMicroseconds (UInt64) — Total time local thread pools have spent waiting to borrow a thread from the global pool.
ProfileEvent_LocalThreadPoolLockWaitMicroseconds (UInt64) — Total time threads have spent waiting for locks in the local thread pools.
ProfileEvent_LocalThreadPoolJobs (UInt64) — Counts the number of jobs that have been pushed to the local thread pools.
ProfileEvent_LocalThreadPoolBusyMicroseconds (UInt64) — Total time threads have spent executing the actual work.
ProfileEvent_LocalThreadPoolJobWaitTimeMicroseconds (UInt64) — Measures the elapsed time from when a job is scheduled in the thread pool to when it is picked up for execution by a worker thread. This metric helps identify delays in job processing, indicating the responsiveness of the thread pool to new tasks.
ProfileEvent_DiskS3GetRequestThrottlerCount (UInt64) — Number of DiskS3 GET and SELECT requests passed through throttler: blocked and not blocked.
ProfileEvent_DiskS3GetRequestThrottlerBlocked (UInt64) — Number of DiskS3 GET and SELECT requests blocked by throttler.
ProfileEvent_DiskS3GetRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform DiskS3 GET and SELECT request throttling.
ProfileEvent_DiskS3PutRequestThrottlerCount (UInt64) — Number of DiskS3 PUT, COPY, POST and LIST requests passed through throttler: blocked and not blocked.
ProfileEvent_DiskS3PutRequestThrottlerBlocked (UInt64) — Number of DiskS3 PUT, COPY, POST and LIST requests blocked by throttler.
ProfileEvent_DiskS3PutRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform DiskS3 PUT, COPY, POST and LIST request throttling.
ProfileEvent_S3GetRequestThrottlerCount (UInt64) — Number of S3 GET and SELECT requests passed through throttler: blocked and not blocked.
ProfileEvent_S3GetRequestThrottlerBlocked (UInt64) — Number of S3 GET and SELECT requests blocked by throttler.
ProfileEvent_S3GetRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform S3 GET and SELECT request throttling.
ProfileEvent_S3PutRequestThrottlerCount (UInt64) — Number of S3 PUT, COPY, POST and LIST requests passed through throttler: blocked and not blocked.
ProfileEvent_S3PutRequestThrottlerBlocked (UInt64) — Number of S3 PUT, COPY, POST and LIST requests blocked by throttler.
ProfileEvent_S3PutRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform S3 PUT, COPY, POST and LIST request throttling.
ProfileEvent_ACMEAPIRequests (UInt64) — Number of ACME API requests issued.
ProfileEvent_ACMECertificateOrders (UInt64) — Number of ACME certificate orders issued.
ProfileEvent_DiskAzureReadMicroseconds (UInt64) — Total time spent waiting for Azure disk read requests.
ProfileEvent_DiskAzureReadRequestsCount (UInt64) — Number of Azure disk read requests.
ProfileEvent_DiskAzureReadRequestsErrors (UInt64) — Number of Azure disk read request errors.
ProfileEvent_DiskAzureReadRequestsThrottling (UInt64) — Number of Azure disk read requests throttled.
ProfileEvent_DiskAzureReadRequestsRedirects (UInt64) — Number of Azure disk read request redirects.
ProfileEvent_DiskAzureWriteMicroseconds (UInt64) — Total time spent waiting for Azure disk write requests.
ProfileEvent_DiskAzureWriteRequestsCount (UInt64) — Number of Azure disk write requests.
ProfileEvent_DiskAzureWriteRequestsErrors (UInt64) — Number of Azure disk write request errors.
ProfileEvent_DiskAzureWriteRequestsThrottling (UInt64) — Number of Azure disk write requests throttled.
ProfileEvent_DiskAzureWriteRequestsRedirects (UInt64) — Number of Azure disk write request redirects.
ProfileEvent_AzureReadMicroseconds (UInt64) — Total time spent waiting for Azure read requests.
ProfileEvent_AzureReadRequestsCount (UInt64) — Number of Azure read requests.
ProfileEvent_AzureReadRequestsErrors (UInt64) — Number of Azure read request errors.
ProfileEvent_AzureReadRequestsThrottling (UInt64) — Number of Azure read requests throttled.
ProfileEvent_AzureReadRequestsRedirects (UInt64) — Number of Azure read request redirects.
ProfileEvent_AzureWriteMicroseconds (UInt64) — Total time spent waiting for Azure write requests.
ProfileEvent_AzureWriteRequestsCount (UInt64) — Number of Azure write requests.
ProfileEvent_AzureWriteRequestsErrors (UInt64) — Number of Azure write request errors.
ProfileEvent_AzureWriteRequestsThrottling (UInt64) — Number of Azure write requests throttled.
ProfileEvent_AzureWriteRequestsRedirects (UInt64) — Number of Azure write request redirects.
ProfileEvent_AzureGetRequestThrottlerCount (UInt64) — Number of Azure GET requests passed through throttler: blocked and not blocked.
ProfileEvent_AzureGetRequestThrottlerBlocked (UInt64) — Number of Azure GET requests blocked by throttler.
ProfileEvent_AzureGetRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform Azure GET request throttling.
ProfileEvent_DiskAzureGetRequestThrottlerCount (UInt64) — Number of Azure disk GET requests passed through throttler: blocked and not blocked.
ProfileEvent_DiskAzureGetRequestThrottlerBlocked (UInt64) — Number of Azure disk GET requests blocked by throttler.
ProfileEvent_DiskAzureGetRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform Azure disk GET request throttling.
ProfileEvent_AzurePutRequestThrottlerCount (UInt64) — Number of Azure PUT requests passed through throttler: blocked and not blocked.
ProfileEvent_AzurePutRequestThrottlerBlocked (UInt64) — Number of Azure PUT requests blocked by throttler.
ProfileEvent_AzurePutRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform Azure PUT request throttling.
ProfileEvent_DiskAzurePutRequestThrottlerCount (UInt64) — Number of Azure disk PUT requests passed through throttler: blocked and not blocked.
ProfileEvent_DiskAzurePutRequestThrottlerBlocked (UInt64) — Number of Azure disk PUT requests blocked by throttler.
ProfileEvent_DiskAzurePutRequestThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform Azure disk PUT request throttling.
ProfileEvent_RemoteReadThrottlerBytes (UInt64) — Bytes passed through 'max_remote_read_network_bandwidth_for_server'/'max_remote_read_network_bandwidth' throttler.
ProfileEvent_RemoteReadThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_remote_read_network_bandwidth_for_server'/'max_remote_read_network_bandwidth' throttling.
ProfileEvent_RemoteWriteThrottlerBytes (UInt64) — Bytes passed through 'max_remote_write_network_bandwidth_for_server'/'max_remote_write_network_bandwidth' throttler.
ProfileEvent_RemoteWriteThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_remote_write_network_bandwidth_for_server'/'max_remote_write_network_bandwidth' throttling.
ProfileEvent_LocalReadThrottlerBytes (UInt64) — Bytes passed through 'max_local_read_bandwidth_for_server'/'max_local_read_bandwidth' throttler.
ProfileEvent_LocalReadThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_local_read_bandwidth_for_server'/'max_local_read_bandwidth' throttling.
ProfileEvent_LocalWriteThrottlerBytes (UInt64) — Bytes passed through 'max_local_write_bandwidth_for_server'/'max_local_write_bandwidth' throttler.
ProfileEvent_LocalWriteThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_local_write_bandwidth_for_server'/'max_local_write_bandwidth' throttling.
ProfileEvent_BackupThrottlerBytes (UInt64) — Bytes passed through 'max_backup_bandwidth_for_server' throttler.
ProfileEvent_BackupThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_backup_bandwidth_for_server' throttling.
ProfileEvent_MergesThrottlerBytes (UInt64) — Bytes passed through 'max_merges_bandwidth_for_server' throttler.
ProfileEvent_MergesThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_merges_bandwidth_for_server' throttling.
ProfileEvent_MutationsThrottlerBytes (UInt64) — Bytes passed through 'max_mutations_bandwidth_for_server' throttler.
ProfileEvent_MutationsThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_mutations_bandwidth_for_server' throttling.
ProfileEvent_UserThrottlerBytes (UInt64) — Bytes passed through 'max_network_bandwidth_for_user' throttler.
ProfileEvent_UserThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_network_bandwidth_for_user' throttling.
ProfileEvent_AllUsersThrottlerBytes (UInt64) — Bytes passed through 'max_network_bandwidth_for_all_users' throttler.
ProfileEvent_AllUsersThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_network_bandwidth_for_all_users' throttling.
ProfileEvent_QueryRemoteReadThrottlerBytes (UInt64) — Bytes passed through 'max_remote_read_network_bandwidth' throttler.
ProfileEvent_QueryRemoteReadThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_remote_read_network_bandwidth' throttling.
ProfileEvent_QueryRemoteWriteThrottlerBytes (UInt64) — Bytes passed through 'max_remote_write_network_bandwidth' throttler.
ProfileEvent_QueryRemoteWriteThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_remote_write_network_bandwidth' throttling.
ProfileEvent_QueryLocalReadThrottlerBytes (UInt64) — Bytes passed through 'max_local_read_bandwidth' throttler.
ProfileEvent_QueryLocalReadThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_local_read_bandwidth' throttling.
ProfileEvent_QueryLocalWriteThrottlerBytes (UInt64) — Bytes passed through 'max_local_write_bandwidth' throttler.
ProfileEvent_QueryLocalWriteThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_local_write_bandwidth' throttling.
ProfileEvent_QueryBackupThrottlerBytes (UInt64) — Bytes passed through 'max_backup_bandwidth' throttler.
ProfileEvent_QueryBackupThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_backup_bandwidth' throttling.
ProfileEvent_DistrCacheReadThrottlerBytes (UInt64) — Bytes passed through 'max_distributed_cache_read_bandwidth_for_server' throttler.
ProfileEvent_DistrCacheReadThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_distributed_cache_read_bandwidth_for_server' throttling.
ProfileEvent_DistrCacheWriteThrottlerBytes (UInt64) — Bytes passed through 'max_distributed_cache_write_bandwidth_for_server' throttler.
ProfileEvent_DistrCacheWriteThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform 'max_distributed_cache_write_bandwidth_for_server' throttling.
ProfileEvent_ThrottlerSleepMicroseconds (UInt64) — Total time a query was sleeping to conform all throttling settings.
ProfileEvent_ReadTasksWithAppliedPatches (UInt64) — Total number of read tasks for which there was any patch part applied
ProfileEvent_PatchesAppliedInAllReadTasks (UInt64) — Total number of applied patch parts among all read tasks
ProfileEvent_PatchesMergeAppliedInAllReadTasks (UInt64) — Total number of applied patch parts with Merge mode among all read tasks
ProfileEvent_PatchesJoinAppliedInAllReadTasks (UInt64) — Total number of applied patch parts with Join mode among all read tasks
ProfileEvent_PatchesReadRows (UInt64) — Total number of rows read from patch parts
ProfileEvent_PatchesReadUncompressedBytes (UInt64) — Total number of uncompressed bytes read from patch parts
ProfileEvent_PatchesJoinRowsAddedToHashTable (UInt64) — Total number of rows added to hash tables when applying patch parts with Join mode
ProfileEvent_ApplyPatchesMicroseconds (UInt64) — Total time spent applying patch parts to blocks
ProfileEvent_ReadPatchesMicroseconds (UInt64) — Total time spent reading patch parts
ProfileEvent_BuildPatchesMergeMicroseconds (UInt64) — Total time spent building indexes for applying patch parts with Merge mode
ProfileEvent_BuildPatchesJoinMicroseconds (UInt64) — Total time spent building indexes and hash tables for applying patch parts with Join mode
ProfileEvent_AnalyzePatchRangesMicroseconds (UInt64) — Total time spent analyzing index of patch parts
ProfileEvent_ReadTasksWithAppliedMutationsOnFly (UInt64) — Total number of read tasks for which there was any mutation applied on fly
ProfileEvent_MutationsAppliedOnFlyInAllReadTasks (UInt64) — Total number of applied mutations on-fly among all read tasks
ProfileEvent_PatchesAcquireLockTries (UInt64) — Total number of tries to acquire lock for executing lightweight updates
ProfileEvent_PatchesAcquireLockMicroseconds (UInt64) — Total number of microseconds spent to acquire lock for executing lightweight updates
ProfileEvent_DiskObjectStorageWaitBlobRemovalMicroseconds (UInt64) — Time spent waiting for pending blob removal after committing metadata transaction
ProfileEvent_SchedulerIOReadRequests (UInt64) — Resource requests passed through scheduler for IO reads.
ProfileEvent_SchedulerIOReadBytes (UInt64) — Bytes passed through scheduler for IO reads.
ProfileEvent_SchedulerIOReadWaitMicroseconds (UInt64) — Total time a query was waiting on resource requests for IO reads.
ProfileEvent_SchedulerIOWriteRequests (UInt64) — Resource requests passed through scheduler for IO writes.
ProfileEvent_SchedulerIOWriteBytes (UInt64) — Bytes passed through scheduler for IO writes.
ProfileEvent_SchedulerIOWriteWaitMicroseconds (UInt64) — Total time a query was waiting on resource requests for IO writes.
ProfileEvent_QueryMaskingRulesMatch (UInt64) — Number of times query masking rules was successfully matched.
ProfileEvent_ReplicatedPartFetches (UInt64) — Number of times a data part was downloaded from replica of a ReplicatedMergeTree table.
ProfileEvent_ReplicatedPartFailedFetches (UInt64) — Number of times a data part was failed to download from replica of a ReplicatedMergeTree table.
ProfileEvent_ObsoleteReplicatedParts (UInt64) — Number of times a data part was covered by another data part that has been fetched from a replica (so, we have marked a covered data part as obsolete and no longer needed).
ProfileEvent_ReplicatedPartMerges (UInt64) — Number of times data parts of ReplicatedMergeTree tables were successfully merged.
ProfileEvent_ReplicatedPartFetchesOfMerged (UInt64) — Number of times we prefer to download already merged part from replica of ReplicatedMergeTree table instead of performing a merge ourself (usually we prefer doing a merge ourself to save network traffic). This happens when we have not all source parts to perform a merge or when the data part is old enough.
ProfileEvent_ReplicatedPartMutations (UInt64) — Number of times data parts of ReplicatedMergeTree tables were successfully mutated.
ProfileEvent_ReplicatedPartChecks (UInt64) — Number of times we had to perform advanced search for a data part on replicas or to clarify the need of an existing data part.
ProfileEvent_ReplicatedPartChecksFailed (UInt64) — Number of times the advanced search for a data part on replicas did not give result or when unexpected part has been found and moved away.
ProfileEvent_ReplicatedDataLoss (UInt64) — Number of times a data part that we wanted doesn't exist on any replica (even on replicas that are offline right now). That data parts are definitely lost. This is normal due to asynchronous replication (if quorum inserts were not enabled), when the replica on which the data part was written was failed and when it became online after fail it doesn't contain that data part.
ProfileEvent_ReplicatedCoveredPartsInZooKeeperOnStart (UInt64) — For debugging purposes. Number of parts in ZooKeeper that have a covering part, but doesn't exist on disk. Checked on server start.
ProfileEvent_QuorumParts (UInt64) — Number of data parts written with quorum. It counts as one part for sync insert and maybe up to async inserts count for insert which flushes async inserts.
ProfileEvent_QuorumWaitMicroseconds (UInt64) — Total time spent waiting for quorum during inserts.
ProfileEvent_QuorumFailedInserts (UInt64) — Number of inserts failed due to quorum not reaching.
ProfileEvent_InsertedRows (UInt64) — Number of rows INSERTed to all tables.
ProfileEvent_InsertedBytes (UInt64) — Number of bytes (uncompressed; for columns as they stored in memory) INSERTed to all tables.
ProfileEvent_DelayedInserts (UInt64) — Number of times the INSERT of a block to a MergeTree table was throttled due to high number of active data parts for partition.
ProfileEvent_RejectedInserts (UInt64) — Number of times the INSERT of a block to a MergeTree table was rejected with 'Too many parts' exception due to high number of active data parts for partition.
ProfileEvent_DelayedInsertsMilliseconds (UInt64) — Total number of milliseconds spent while the INSERT of a block to a MergeTree table was throttled due to high number of active data parts for partition.
ProfileEvent_DelayedMutations (UInt64) — Number of times the mutation of a MergeTree table was throttled due to high number of unfinished mutations for table.
ProfileEvent_RejectedMutations (UInt64) — Number of times the mutation of a MergeTree table was rejected with 'Too many mutations' exception due to high number of unfinished mutations for table.
ProfileEvent_DelayedMutationsMilliseconds (UInt64) — Total number of milliseconds spent while the mutation of a MergeTree table was throttled due to high number of unfinished mutations for table.
ProfileEvent_RejectedLightweightUpdates (UInt64) — Number of time the lightweight update was rejected due to too many uncompressed bytes in patches.
ProfileEvent_DistributedDelayedInserts (UInt64) — Number of times the INSERT of a block to a Distributed table was throttled due to high number of pending bytes.
ProfileEvent_DistributedRejectedInserts (UInt64) — Number of times the INSERT of a block to a Distributed table was rejected with 'Too many bytes' exception due to high number of pending bytes.
ProfileEvent_DistributedDelayedInsertsMilliseconds (UInt64) — Total number of milliseconds spent while the INSERT of a block to a Distributed table was throttled due to high number of pending bytes.
ProfileEvent_DuplicatedInsertedBlocks (UInt64) — Number of the synchronous inserts to a *MergeTree table was deduplicated.
ProfileEvent_SelfDuplicatedAsyncInserts (UInt64) — Number of async inserts in the INSERTed block to a ReplicatedMergeTree table was self deduplicated.
ProfileEvent_DuplicatedAsyncInserts (UInt64) — Number of async inserts in the INSERTed block to a ReplicatedMergeTree table was deduplicated.
ProfileEvent_DuplicationElapsedMicroseconds (UInt64) — Total time spent checking for duplication of INSERTed blocks to *MergeTree tables.
ProfileEvent_ZooKeeperInit (UInt64) — Number of times connection with ZooKeeper has been established.
ProfileEvent_ZooKeeperTransactions (UInt64) — Number of ZooKeeper operations, which include both read and write operations as well as multi-transactions.
ProfileEvent_ZooKeeperList (UInt64) — Number of 'list' (getChildren) requests to ZooKeeper.
ProfileEvent_ZooKeeperListRecursive (UInt64) — Number of 'listRecursive' requests to ZooKeeper.
ProfileEvent_ZooKeeperCreate (UInt64) — Number of 'create' requests to ZooKeeper.
ProfileEvent_ZooKeeperRemove (UInt64) — Number of 'remove' requests to ZooKeeper.
ProfileEvent_ZooKeeperExists (UInt64) — Number of 'exists' requests to ZooKeeper.
ProfileEvent_ZooKeeperGet (UInt64) — Number of 'get' requests to ZooKeeper.
ProfileEvent_ZooKeeperSet (UInt64) — Number of 'set' requests to ZooKeeper.
ProfileEvent_ZooKeeperMulti (UInt64) — Number of 'multi' requests to ZooKeeper (compound transactions).
ProfileEvent_ZooKeeperMultiRead (UInt64) — Number of read 'multi' requests to ZooKeeper (compound transactions).
ProfileEvent_ZooKeeperMultiWrite (UInt64) — Number of write 'multi' requests to ZooKeeper (compound transactions).
ProfileEvent_ZooKeeperCheck (UInt64) — Number of 'check' requests to ZooKeeper. Usually they don't make sense in isolation, only as part of a complex transaction.
ProfileEvent_ZooKeeperSync (UInt64) — Number of 'sync' requests to ZooKeeper. These requests are rarely needed or usable.
ProfileEvent_ZooKeeperReconfig (UInt64) — Number of 'reconfig' requests to ZooKeeper.
ProfileEvent_ZooKeeperClose (UInt64) — Number of times connection with ZooKeeper has been closed voluntary.
ProfileEvent_ZooKeeperGetACL (UInt64) — Number of 'getACL' requests to ZooKeeper.
ProfileEvent_ZooKeeperWatchResponse (UInt64) — Number of times watch notification has been received from ZooKeeper.
ProfileEvent_ZooKeeperUserExceptions (UInt64) — Number of exceptions while working with ZooKeeper related to the data (no node, bad version or similar).
ProfileEvent_ZooKeeperHardwareExceptions (UInt64) — Number of exceptions while working with ZooKeeper related to network (connection loss or similar).
ProfileEvent_ZooKeeperOtherExceptions (UInt64) — Number of exceptions while working with ZooKeeper other than ZooKeeperUserExceptions and ZooKeeperHardwareExceptions.
ProfileEvent_ZooKeeperWaitMicroseconds (UInt64) — Number of microseconds spent waiting for responses from ZooKeeper after creating a request, summed across all the requesting threads.
ProfileEvent_ZooKeeperBytesSent (UInt64) — Number of bytes send over network while communicating with ZooKeeper.
ProfileEvent_ZooKeeperBytesReceived (UInt64) — Number of bytes received over network while communicating with ZooKeeper.
ProfileEvent_DistributedConnectionTries (UInt64) — Total count of distributed connection attempts.
ProfileEvent_DistributedConnectionUsable (UInt64) — Total count of successful distributed connections to a usable server (with required table, but maybe stale).
ProfileEvent_DistributedConnectionFailTry (UInt64) — Total count when distributed connection fails with retry.
ProfileEvent_DistributedConnectionMissingTable (UInt64) — Number of times we rejected a replica from a distributed query, because it did not contain a table needed for the query.
ProfileEvent_DistributedConnectionStaleReplica (UInt64) — Number of times we rejected a replica from a distributed query, because some table needed for a query had replication lag higher than the configured threshold.
ProfileEvent_DistributedConnectionSkipReadOnlyReplica (UInt64) — Number of replicas skipped during INSERT into Distributed table due to replicas being read-only
ProfileEvent_DistributedConnectionFailAtAll (UInt64) — Total count when distributed connection fails after all retries finished.
ProfileEvent_Shards (UInt64) — The number of shards involved in a query, summed across all distributed tables and table functions. A single host is counted multiple times if it appears in multiple tables. The number counts the total expected number of shards, which includes skipped shards with the skip_unavailable_shards setting.
ProfileEvent_HedgedRequestsChangeReplica (UInt64) — Total count when timeout for changing replica expired in hedged requests.
ProfileEvent_SuspendSendingQueryToShard (UInt64) — Total count when sending query to shard was suspended when async_query_sending_for_remote is enabled.
ProfileEvent_CompileFunction (UInt64) — Number of times a compilation of generated LLVM code (to create fused function for complex expressions) was initiated.
ProfileEvent_CompiledFunctionExecute (UInt64) — Number of times a compiled function was executed.
ProfileEvent_CompileExpressionsMicroseconds (UInt64) — Total time spent for compilation of expressions to LLVM code.
ProfileEvent_CompileExpressionsBytes (UInt64) — Number of bytes used for expressions compilation.
ProfileEvent_ExecuteShellCommand (UInt64) — Number of shell command executions.
ProfileEvent_ExternalProcessingCompressedBytesTotal (UInt64) — Number of compressed bytes written by external processing (sorting/aggregating/joining)
ProfileEvent_ExternalProcessingUncompressedBytesTotal (UInt64) — Amount of data (uncompressed, before compression) written by external processing (sorting/aggregating/joining)
ProfileEvent_ExternalProcessingFilesTotal (UInt64) — Number of files used by external processing (sorting/aggregating/joining)
ProfileEvent_ExternalSortWritePart (UInt64) — Number of times a temporary file was written to disk for sorting in external memory.
ProfileEvent_ExternalSortMerge (UInt64) — Number of times temporary files were merged for sorting in external memory.
ProfileEvent_ExternalSortCompressedBytes (UInt64) — Number of compressed bytes written for sorting in external memory.
ProfileEvent_ExternalSortUncompressedBytes (UInt64) — Amount of data (uncompressed, before compression) written for sorting in external memory.
ProfileEvent_ExternalAggregationWritePart (UInt64) — Number of times a temporary file was written to disk for aggregation in external memory.
ProfileEvent_ExternalAggregationMerge (UInt64) — Number of times temporary files were merged for aggregation in external memory.
ProfileEvent_ExternalAggregationCompressedBytes (UInt64) — Number of bytes written to disk for aggregation in external memory.
ProfileEvent_ExternalAggregationUncompressedBytes (UInt64) — Amount of data (uncompressed, before compression) written to disk for aggregation in external memory.
ProfileEvent_ExternalJoinWritePart (UInt64) — Number of times a temporary file was written to disk for JOIN in external memory.
ProfileEvent_ExternalJoinMerge (UInt64) — Number of times temporary files were merged for JOIN in external memory.
ProfileEvent_ExternalJoinCompressedBytes (UInt64) — Number of compressed bytes written for JOIN in external memory.
ProfileEvent_ExternalJoinUncompressedBytes (UInt64) — Amount of data (uncompressed, before compression) written for JOIN in external memory.
ProfileEvent_IcebergPartitionPrunedFiles (UInt64) — Number of skipped files during Iceberg partition pruning
ProfileEvent_IcebergTrivialCountOptimizationApplied (UInt64) — Trivial count optimization applied while reading from Iceberg
ProfileEvent_IcebergVersionHintUsed (UInt64) — Number of times version-hint.text has been used.
ProfileEvent_IcebergMinMaxIndexPrunedFiles (UInt64) — Number of skipped files by using MinMax index in Iceberg
ProfileEvent_JoinBuildTableRowCount (UInt64) — Total number of rows in the build table for a JOIN operation.
ProfileEvent_JoinProbeTableRowCount (UInt64) — Total number of rows in the probe table for a JOIN operation.
ProfileEvent_JoinResultRowCount (UInt64) — Total number of rows in the result of a JOIN operation.
ProfileEvent_JoinNonJoinedTransformBlockCount (UInt64) — Number of blocks emitted by NonJoinedBlocksTransform.
ProfileEvent_JoinNonJoinedTransformRowCount (UInt64) — Number of non-joined rows emitted by NonJoinedBlocksTransform.
ProfileEvent_JoinDelayedJoinedTransformBlockCount (UInt64) — Number of blocks emitted by DelayedJoinedBlocksWorkerTransform.
ProfileEvent_JoinDelayedJoinedTransformRowCount (UInt64) — Number of rows emitted by DelayedJoinedBlocksWorkerTransform.
ProfileEvent_JoinSpillingHashJoinSwitchedToGraceJoin (UInt64) — Number of times a (Concurrent)HashJoin was switched to GraceHashJoin due to memory limit in SpillingHashJoin.
ProfileEvent_JoinReorderMicroseconds (UInt64) — Total time spent executing JOIN reordering algorithm.
ProfileEvent_JoinOptimizeMicroseconds (UInt64) — Total time spent executing JOIN plan optimizations.
ProfileEvent_QueryPlanOptimizeMicroseconds (UInt64) — Total time spent executing query plan optimizations.
ProfileEvent_DeltaLakePartitionPrunedFiles (UInt64) — Number of skipped files during DeltaLake partition pruning
ProfileEvent_DeltaLakeSnapshotInitializations (UInt64) — Number of times a DeltaLake table snapshot was initialized (loaded from object storage)
ProfileEvent_DeltaLakeScannedFiles (UInt64) — Number of files scanned during DeltaLake scan callbacks
ProfileEvent_SlowRead (UInt64) — Number of reads from a file that were slow. This indicate system overload. Thresholds are controlled by read_backoff_* settings.
ProfileEvent_ReadBackoff (UInt64) — Number of times the number of query processing threads was lowered due to slow reads.
ProfileEvent_ReplicaPartialShutdown (UInt64) — How many times Replicated table has to deinitialize its state due to session expiration in ZooKeeper. The state is reinitialized every time when ZooKeeper is available again.
ProfileEvent_IndexAnalysisRounds (UInt64) — Number of times index analysis was performed within the query.
ProfileEvent_SelectedParts (UInt64) — Number of data parts selected to read from a MergeTree table.
ProfileEvent_SelectedPartsTotal (UInt64) — Number of total data parts before selecting which ones to read from a MergeTree table.
ProfileEvent_SelectedRanges (UInt64) — Number of (non-adjacent) ranges in all data parts selected to read from a MergeTree table.
ProfileEvent_SelectedMarks (UInt64) — Number of marks (index granules) selected to read from a MergeTree table.
ProfileEvent_SelectedMarksTotal (UInt64) — Number of total marks (index granules) before selecting which ones to read from a MergeTree table.
ProfileEvent_SelectedRows (UInt64) — Number of rows SELECTed from all tables.
ProfileEvent_SelectedBytes (UInt64) — Number of bytes (uncompressed; for columns as they stored in memory) SELECTed from all tables.
ProfileEvent_RowsReadByMainReader (UInt64) — Number of rows read from MergeTree tables by the main reader (after PREWHERE step).
ProfileEvent_RowsReadByPrewhereReaders (UInt64) — Number of rows read from MergeTree tables (in total) by prewhere readers.
ProfileEvent_LoadedDataParts (UInt64) — Number of data parts loaded by MergeTree tables during initialization.
ProfileEvent_LoadedDataPartsMicroseconds (UInt64) — Microseconds spent by MergeTree tables for loading data parts during initialization.
ProfileEvent_FilteringMarksWithPrimaryKeyProcessedMarks (UInt64) — Total marks processed during PK analysis.
ProfileEvent_FilteringMarksWithPrimaryKeyMicroseconds (UInt64) — Time spent filtering parts by PK.
ProfileEvent_FilteringMarksWithSecondaryKeysMicroseconds (UInt64) — Time spent filtering parts by skip indexes.
ProfileEvent_DistributedIndexAnalysisMicroseconds (UInt64) — Total time spent during distributed index analysis
ProfileEvent_DistributedIndexAnalysisScheduledReplicas (UInt64) — Number of replicas (local replica will be accounted once) to which distributed index analysis has been scheduled
ProfileEvent_DistributedIndexAnalysisReplicaUnavailable (UInt64) — Number of times distributed index analysis failed on one of replicas without fallback (failed during connect)
ProfileEvent_DistributedIndexAnalysisReplicaFallback (UInt64) — Number of times distributed index analysis failed on one of replicas with fallback to local replica
ProfileEvent_DistributedIndexAnalysisParts (UInt64) — Number of parts send for distributed index analysis
ProfileEvent_DistributedIndexAnalysisMissingParts (UInt64) — Number of missing parts during distributed index analysis that will be resolved locally
ProfileEvent_WaitMarksLoadMicroseconds (UInt64) — Time spent loading marks
ProfileEvent_BackgroundLoadingMarksTasks (UInt64) — Number of background tasks for loading marks
ProfileEvent_MarksTasksFromCache (UInt64) — Number of times marks were loaded synchronously because they were already present in the cache.
ProfileEvent_LoadingMarksTasksCanceled (UInt64) — Number of times background tasks for loading marks were canceled
ProfileEvent_LoadedMarksFiles (UInt64) — Number of mark files loaded.
ProfileEvent_LoadedMarksCount (UInt64) — Number of marks loaded (total across columns).
ProfileEvent_LoadedMarksMemoryBytes (UInt64) — Size of in-memory representations of loaded marks.
ProfileEvent_MarkCacheEvictedBytes (UInt64) — Number of bytes evicted from the mark cache.
ProfileEvent_MarkCacheEvictedMarks (UInt64) — Number of marks evicted from the mark cache.
ProfileEvent_MarkCacheEvictedFiles (UInt64) — Number of mark files evicted from the mark cache.
ProfileEvent_LoadedPrimaryIndexFiles (UInt64) — Number of primary index files loaded.
ProfileEvent_LoadedPrimaryIndexRows (UInt64) — Number of rows of primary key loaded.
ProfileEvent_LoadedPrimaryIndexBytes (UInt64) — Number of rows of primary key loaded.
ProfileEvent_Merge (UInt64) — Number of launched background merges.
ProfileEvent_MergeSourceParts (UInt64) — Number of source parts scheduled for merges.
ProfileEvent_MergedRows (UInt64) — Rows read for background merges. This is the number of rows before merge.
ProfileEvent_MergedColumns (UInt64) — Number of columns merged during the horizontal stage of merges.
ProfileEvent_GatheredColumns (UInt64) — Number of columns gathered during the vertical stage of merges.
ProfileEvent_MergedProjections (UInt64) — Number of projections merged (not rebuilt) during MergeTree merges.
ProfileEvent_RebuiltProjections (UInt64) — Number of projections rebuilt from scratch during MergeTree merges.
ProfileEvent_MergedUncompressedBytes (UInt64) — Uncompressed bytes (for columns as they stored in memory) that was read for background merges. This is the number before merge.
ProfileEvent_MergeWrittenRows (UInt64) — Number of rows written during the merge.
ProfileEvent_MergeTotalMilliseconds (UInt64) — Total time spent for background merges
ProfileEvent_MergeExecuteMilliseconds (UInt64) — Total busy time spent for execution of background merges
ProfileEvent_MergeCommitMilliseconds (UInt64) — Total time spent for committing merge results (part renaming, checksum verification, ZooKeeper updates)
ProfileEvent_MergeHorizontalStageTotalMilliseconds (UInt64) — Total time spent for horizontal stage of background merges
ProfileEvent_MergeHorizontalStageExecuteMilliseconds (UInt64) — Total busy time spent for execution of horizontal stage of background merges
ProfileEvent_MergeVerticalStageTotalMilliseconds (UInt64) — Total time spent for vertical stage of background merges
ProfileEvent_MergeVerticalStageExecuteMilliseconds (UInt64) — Total busy time spent for execution of vertical stage of background merges
ProfileEvent_MergeTextIndexStageTotalMilliseconds (UInt64) — Total time spent for text index stage of background merges
ProfileEvent_MergeTextIndexStageExecuteMilliseconds (UInt64) — Total busy time spent for execution of text index stage of background merges
ProfileEvent_MergeProjectionStageTotalMilliseconds (UInt64) — Total time spent for projection stage of background merges
ProfileEvent_MergeProjectionStageExecuteMilliseconds (UInt64) — Total busy time spent for execution of projection stage of background merges
ProfileEvent_MergePrewarmStageTotalMilliseconds (UInt64) — Total time spent for prewarm stage of background merges
ProfileEvent_MergePrewarmStageExecuteMilliseconds (UInt64) — Total busy time spent for execution of prewarm stage of background merges
ProfileEvent_MergesRejectedByMemoryLimit (UInt64) — Number of background merges rejected due to memory limit
ProfileEvent_MergingSortedMilliseconds (UInt64) — Total time spent while merging sorted columns
ProfileEvent_AggregatingSortedMilliseconds (UInt64) — Total time spent while aggregating sorted columns
ProfileEvent_CoalescingSortedMilliseconds (UInt64) — Total time spent while coalescing sorted columns
ProfileEvent_CollapsingSortedMilliseconds (UInt64) — Total time spent while collapsing sorted columns
ProfileEvent_ReplacingSortedMilliseconds (UInt64) — Total time spent while replacing sorted columns
ProfileEvent_SummingSortedMilliseconds (UInt64) — Total time spent while summing sorted columns
ProfileEvent_VersionedCollapsingSortedMilliseconds (UInt64) — Total time spent while version collapsing sorted columns
ProfileEvent_GatheringColumnMilliseconds (UInt64) — Total time spent while gathering columns for vertical merge
ProfileEvent_MutationTotalParts (UInt64) — Number of total parts for which mutations tried to be applied
ProfileEvent_MutationUntouchedParts (UInt64) — Number of total parts for which mutations tried to be applied but which was completely skipped according to predicate
ProfileEvent_MutationCreatedEmptyParts (UInt64) — Number of total parts which were replaced to empty parts instead of running mutation
ProfileEvent_MutatedRows (UInt64) — Rows read for mutations. This is the number of rows before mutation
ProfileEvent_MutatedUncompressedBytes (UInt64) — Uncompressed bytes (for columns as they stored in memory) that was read for mutations. This is the number before mutation.
ProfileEvent_MutationAffectedRowsUpperBound (UInt64) — The upper bound of number of rows that were affected by mutation (e.g. number of rows that satisfy the predicate of UPDATE or DELETE mutation). The actual number may be slightly less
ProfileEvent_MutationTotalMilliseconds (UInt64) — Total time spent for mutations.
ProfileEvent_MutationExecuteMilliseconds (UInt64) — Total busy time spent for execution of mutations.
ProfileEvent_MutationCommitMilliseconds (UInt64) — Total time spent for committing mutation results (part renaming, checksum verification, ZooKeeper updates)
ProfileEvent_MutationAllPartColumns (UInt64) — Number of times when task to mutate all columns in part was created
ProfileEvent_MutationSomePartColumns (UInt64) — Number of times when task to mutate some columns in part was created
ProfileEvent_MutateTaskProjectionsCalculationMicroseconds (UInt64) — Time spent calculating projections in mutations
ProfileEvent_MergeTreeDataWriterRows (UInt64) — Number of rows INSERTed to MergeTree tables.
ProfileEvent_MergeTreeDataWriterUncompressedBytes (UInt64) — Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables.
ProfileEvent_MergeTreeDataWriterCompressedBytes (UInt64) — Bytes written to filesystem for data INSERTed to MergeTree tables.
ProfileEvent_MergeTreeDataWriterBlocks (UInt64) — Number of blocks INSERTed to MergeTree tables. Each block forms a data part of level zero.
ProfileEvent_MergeTreeDataWriterBlocksAlreadySorted (UInt64) — Number of blocks INSERTed to MergeTree tables that appeared to be already sorted.
ProfileEvent_MergeMutateBackgroundExecutorTaskExecuteStepMicroseconds (UInt64) — Time spent in executeStep() for MergeMutate executor tasks.
ProfileEvent_MergeMutateBackgroundExecutorTaskCancelMicroseconds (UInt64) — Time spent in cancel() for MergeMutate executor tasks.
ProfileEvent_MergeMutateBackgroundExecutorTaskResetMicroseconds (UInt64) — Time spent resetting task for MergeMutate executor.
ProfileEvent_MergeMutateBackgroundExecutorWaitMicroseconds (UInt64) — Time spent waiting for completion in MergeMutate executor.
ProfileEvent_MoveBackgroundExecutorTaskExecuteStepMicroseconds (UInt64) — Time spent in executeStep() for Move executor tasks.
ProfileEvent_MoveBackgroundExecutorTaskCancelMicroseconds (UInt64) — Time spent in cancel() for Move executor tasks.
ProfileEvent_MoveBackgroundExecutorTaskResetMicroseconds (UInt64) — Time spent resetting task for Move executor.
ProfileEvent_MoveBackgroundExecutorWaitMicroseconds (UInt64) — Time spent waiting for completion in Move executor.
ProfileEvent_FetchBackgroundExecutorTaskExecuteStepMicroseconds (UInt64) — Time spent in executeStep() for Fetch executor tasks.
ProfileEvent_FetchBackgroundExecutorTaskCancelMicroseconds (UInt64) — Time spent in cancel() for Fetch executor tasks.
ProfileEvent_FetchBackgroundExecutorTaskResetMicroseconds (UInt64) — Time spent resetting task for Fetch executor.
ProfileEvent_FetchBackgroundExecutorWaitMicroseconds (UInt64) — Time spent waiting for completion in Fetch executor.
ProfileEvent_CommonBackgroundExecutorTaskExecuteStepMicroseconds (UInt64) — Time spent in executeStep() for Common executor tasks.
ProfileEvent_CommonBackgroundExecutorTaskCancelMicroseconds (UInt64) — Time spent in cancel() for Common executor tasks.
ProfileEvent_CommonBackgroundExecutorTaskResetMicroseconds (UInt64) — Time spent resetting task for Common executor.
ProfileEvent_CommonBackgroundExecutorWaitMicroseconds (UInt64) — Time spent waiting for completion in Common executor.
ProfileEvent_MergeTreeDataWriterSkipIndicesCalculationMicroseconds (UInt64) — Time spent calculating skip indices
ProfileEvent_MergeTreeDataWriterStatisticsCalculationMicroseconds (UInt64) — Time spent calculating statistics
ProfileEvent_MergeTreeDataWriterSortingBlocksMicroseconds (UInt64) — Time spent sorting blocks
ProfileEvent_MergeTreeDataWriterMergingBlocksMicroseconds (UInt64) — Time spent merging input blocks (for special MergeTree engines)
ProfileEvent_MergeTreeDataWriterProjectionsCalculationMicroseconds (UInt64) — Time spent calculating projections
ProfileEvent_MergeTreeDataProjectionWriterSortingBlocksMicroseconds (UInt64) — Time spent sorting blocks (for projection it might be a key different from table's sorting key)
ProfileEvent_MergeTreeDataProjectionWriterMergingBlocksMicroseconds (UInt64) — Time spent merging blocks
ProfileEvent_InsertedWideParts (UInt64) — Number of parts inserted in Wide format.
ProfileEvent_InsertedCompactParts (UInt64) — Number of parts inserted in Compact format.
ProfileEvent_MergedIntoWideParts (UInt64) — Number of parts merged into Wide format.
ProfileEvent_MergedIntoCompactParts (UInt64) — Number of parts merged into Compact format.
ProfileEvent_MergeTreeDataProjectionWriterRows (UInt64) — Number of rows INSERTed to MergeTree tables projection.
ProfileEvent_MergeTreeDataProjectionWriterUncompressedBytes (UInt64) — Uncompressed bytes (for columns as they stored in memory) INSERTed to MergeTree tables projection.
ProfileEvent_MergeTreeDataProjectionWriterCompressedBytes (UInt64) — Bytes written to filesystem for data INSERTed to MergeTree tables projection.
ProfileEvent_MergeTreeDataProjectionWriterBlocks (UInt64) — Number of blocks INSERTed to MergeTree tables projection. Each block forms a data part of level zero.
ProfileEvent_MergeTreeDataProjectionWriterBlocksAlreadySorted (UInt64) — Number of blocks INSERTed to MergeTree tables projection that appeared to be already sorted.
ProfileEvent_CannotRemoveEphemeralNode (UInt64) — Number of times an error happened while trying to remove ephemeral node. This is not an issue, because our implementation of ZooKeeper library guarantee that the session will expire and the node will be removed.
ProfileEvent_RegexpWithMultipleNeedlesCreated (UInt64) — Regular expressions with multiple needles (VectorScan library) compiled.
ProfileEvent_RegexpWithMultipleNeedlesGlobalCacheHit (UInt64) — Number of times we fetched compiled regular expression with multiple needles (VectorScan library) from the global cache.
ProfileEvent_RegexpWithMultipleNeedlesGlobalCacheMiss (UInt64) — Number of times we failed to fetch compiled regular expression with multiple needles (VectorScan library) from the global cache.
ProfileEvent_RegexpLocalCacheHit (UInt64) — Number of times we fetched compiled regular expression from a local cache.
ProfileEvent_RegexpLocalCacheMiss (UInt64) — Number of times we failed to fetch compiled regular expression from a local cache.
ProfileEvent_ContextLock (UInt64) — Number of times the lock of Context was acquired or tried to acquire. This is global lock.
ProfileEvent_ContextLockWaitMicroseconds (UInt64) — Context lock wait time in microseconds
ProfileEvent_StorageBufferFlush (UInt64) — Number of times a buffer in a 'Buffer' table was flushed.
ProfileEvent_StorageBufferErrorOnFlush (UInt64) — Number of times a buffer in the 'Buffer' table has not been able to flush due to error writing in the destination table.
ProfileEvent_StorageBufferPassedAllMinThresholds (UInt64) — Number of times a criteria on min thresholds has been reached to flush a buffer in a 'Buffer' table.
ProfileEvent_StorageBufferPassedTimeMaxThreshold (UInt64) — Number of times a criteria on max time threshold has been reached to flush a buffer in a 'Buffer' table.
ProfileEvent_StorageBufferPassedRowsMaxThreshold (UInt64) — Number of times a criteria on max rows threshold has been reached to flush a buffer in a 'Buffer' table.
ProfileEvent_StorageBufferPassedBytesMaxThreshold (UInt64) — Number of times a criteria on max bytes threshold has been reached to flush a buffer in a 'Buffer' table.
ProfileEvent_StorageBufferPassedTimeFlushThreshold (UInt64) — Number of times background-only flush threshold on time has been reached to flush a buffer in a 'Buffer' table. This is expert-only metric. If you read this and you are not an expert, stop reading.
ProfileEvent_StorageBufferPassedRowsFlushThreshold (UInt64) — Number of times background-only flush threshold on rows has been reached to flush a buffer in a 'Buffer' table. This is expert-only metric. If you read this and you are not an expert, stop reading.
ProfileEvent_StorageBufferPassedBytesFlushThreshold (UInt64) — Number of times background-only flush threshold on bytes has been reached to flush a buffer in a 'Buffer' table. This is expert-only metric. If you read this and you are not an expert, stop reading.
ProfileEvent_StorageBufferLayerLockReadersWaitMilliseconds (UInt64) — Time for waiting for Buffer layer during reading.
ProfileEvent_StorageBufferLayerLockWritersWaitMilliseconds (UInt64) — Time for waiting free Buffer layer to write to (can be used to tune Buffer layers).
ProfileEvent_SystemLogErrorOnFlush (UInt64) — Number of times any of the system logs have failed to flush to the corresponding system table. Attempts to flush are repeated.
ProfileEvent_DictCacheKeysRequested (UInt64) — Number of keys requested from the data source for the dictionaries of 'cache' types.
ProfileEvent_DictCacheKeysRequestedMiss (UInt64) — Number of keys requested from the data source for dictionaries of 'cache' types but not found in the data source.
ProfileEvent_DictCacheKeysRequestedFound (UInt64) — Number of keys requested from the data source for dictionaries of 'cache' types and found in the data source.
ProfileEvent_DictCacheKeysExpired (UInt64) — Number of keys looked up in the dictionaries of 'cache' types and found in the cache but they were obsolete.
ProfileEvent_DictCacheKeysNotFound (UInt64) — Number of keys looked up in the dictionaries of 'cache' types and not found.
ProfileEvent_DictCacheKeysHit (UInt64) — Number of keys looked up in the dictionaries of 'cache' types and found in the cache.
ProfileEvent_DictCacheRequestTimeNs (UInt64) — Number of nanoseconds spend in querying the external data sources for the dictionaries of 'cache' types.
ProfileEvent_DictCacheRequests (UInt64) — Number of bulk requests to the external data sources for the dictionaries of 'cache' types.
ProfileEvent_DictCacheLockWriteNs (UInt64) — Number of nanoseconds spend in waiting for write lock to update the data for the dictionaries of 'cache' types.
ProfileEvent_DictCacheLockReadNs (UInt64) — Number of nanoseconds spend in waiting for read lock to lookup the data for the dictionaries of 'cache' types.
ProfileEvent_DistributedSyncInsertionTimeoutExceeded (UInt64) — A timeout has exceeded while waiting for shards during synchronous insertion into a Distributed table (with 'distributed_foreground_insert' = 1)
ProfileEvent_DistributedAsyncInsertionFailures (UInt64) — Number of failures for asynchronous insertion into a Distributed table (with 'distributed_foreground_insert' = 0)
ProfileEvent_DataAfterMergeDiffersFromReplica (UInt64) — Number of times data after merge is not byte-identical to the data on another replicas. There could be several reasons:
1. Using newer version of compression library after server update.
2. Using another compression method.
3. Non-deterministic compression algorithm (highly unlikely).
4. Non-deterministic merge algorithm due to logical error in code.
5. Data corruption in memory due to bug in code.
6. Data corruption in memory due to hardware issue.
7. Manual modification of source data after server startup.
8. Manual modification of checksums stored in ZooKeeper.
9. Part format related settings like 'enable_mixed_granularity_parts' are different on different replicas. The server successfully detected this situation and will download merged part from the replica to force the byte-identical result.
ProfileEvent_DataAfterMutationDiffersFromReplica (UInt64) — Number of times data after mutation is not byte-identical to the data on other replicas. In addition to the reasons described in 'DataAfterMergeDiffersFromReplica', it is also possible due to non-deterministic mutation.
ProfileEvent_PolygonsAddedToPool (UInt64) — A polygon has been added to the cache (pool) for the 'pointInPolygon' function.
ProfileEvent_PolygonsInPoolAllocatedBytes (UInt64) — The number of bytes for polygons added to the cache (pool) for the 'pointInPolygon' function.
ProfileEvent_NaiveBayesClassifierModelsLoaded (UInt64) — Number of Naive Bayes Classifier models loaded.
ProfileEvent_NaiveBayesClassifierModelsAllocatedBytes (UInt64) — Number of bytes allocated for Naive Bayes Classifier models.
ProfileEvent_USearchAddCount (UInt64) — Number of vectors added to usearch indexes.
ProfileEvent_USearchAddVisitedMembers (UInt64) — Number of nodes visited when adding vectors to usearch indexes.
ProfileEvent_USearchAddComputedDistances (UInt64) — Number of times distance was computed when adding vectors to usearch indexes.
ProfileEvent_USearchSearchCount (UInt64) — Number of search operations performed in usearch indexes.
ProfileEvent_USearchSearchVisitedMembers (UInt64) — Number of nodes visited when searching in usearch indexes.
ProfileEvent_USearchSearchComputedDistances (UInt64) — Number of times distance was computed when searching usearch indexes.
ProfileEvent_RWLockAcquiredReadLocks (UInt64) — Number of times a read lock was acquired (in a heavy RWLock).
ProfileEvent_RWLockAcquiredWriteLocks (UInt64) — Number of times a write lock was acquired (in a heavy RWLock).
ProfileEvent_RWLockReadersWaitMilliseconds (UInt64) — Total time spent waiting for a read lock to be acquired (in a heavy RWLock).
ProfileEvent_RWLockWritersWaitMilliseconds (UInt64) — Total time spent waiting for a write lock to be acquired (in a heavy RWLock).
ProfileEvent_DNSError (UInt64) — Total count of errors in DNS resolution
ProfileEvent_PartsLockHoldMicroseconds (UInt64) — Total time spent holding data parts lock in MergeTree tables
ProfileEvent_PartsLockWaitMicroseconds (UInt64) — Total time spent waiting for data parts lock in MergeTree tables
ProfileEvent_PartsLocks (UInt64) — Number of times data parts lock has been acquired for MergeTree tables
ProfileEvent_SharedPartsLockHoldMicroseconds (UInt64) — Total time spent holding shared data parts lock in MergeTree tables
ProfileEvent_SharedPartsLockWaitMicroseconds (UInt64) — Total time spent waiting for shared data parts lock in MergeTree tables
ProfileEvent_SharedPartsLocks (UInt64) — Number of times shared data parts lock has been acquired for MergeTree tables
ProfileEvent_RealTimeMicroseconds (UInt64) — Total (wall clock) time spent in processing (queries and other tasks) threads (note that this is a sum).
ProfileEvent_UserTimeMicroseconds (UInt64) — 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_SystemTimeMicroseconds (UInt64) — 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_MemoryOvercommitWaitTimeMicroseconds (UInt64) — Total time spent in waiting for memory to be freed in OvercommitTracker.
ProfileEvent_MemoryAllocatorPurge (UInt64) — Total number of times memory allocator purge was requested
ProfileEvent_MemoryAllocatorPurgeTimeMicroseconds (UInt64) — Total time spent for memory allocator purge
ProfileEvent_SoftPageFaults (UInt64) — 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_HardPageFaults (UInt64) — The number of hard page faults in query execution threads. High values indicate either that you forgot to turn off swap on your server, or eviction of memory pages of the ClickHouse binary during very high memory pressure, or successful usage of the 'mmap' read method for the tables data.
ProfileEvent_OSIOWaitMicroseconds (UInt64) — Total time a thread spent waiting for a result of IO operation, from the OS point of view. This is real IO that doesn't include page cache.
ProfileEvent_OSCPUWaitMicroseconds (UInt64) — Total time a thread was ready for execution but waiting to be scheduled by OS, from the OS point of view.
ProfileEvent_OSCPUVirtualTimeMicroseconds (UInt64) — CPU time spent seen by OS. Does not include involuntary waits due to virtualization.
ProfileEvent_OSReadBytes (UInt64) — Number of bytes read from disks or block devices. Doesn't include bytes read from page cache. May include excessive data due to block size, readahead, etc.
ProfileEvent_OSWriteBytes (UInt64) — 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_OSReadChars (UInt64) — Number of bytes read from filesystem, including page cache, as well as network and other files.
ProfileEvent_OSWriteChars (UInt64) — Number of bytes written to filesystem, including page cache, as well as network and other files.
ProfileEvent_ParallelReplicasHandleRequestMicroseconds (UInt64) — Time spent processing requests for marks from replicas
ProfileEvent_ParallelReplicasHandleAnnouncementMicroseconds (UInt64) — Time spent processing replicas announcements
ProfileEvent_ParallelReplicasAnnouncementMicroseconds (UInt64) — Time spent to send an announcement
ProfileEvent_ParallelReplicasReadRequestMicroseconds (UInt64) — Time spent for read requests
ProfileEvent_ParallelReplicasReadAssignedMarks (UInt64) — Sum across all replicas of how many of scheduled marks were assigned by consistent hash
ProfileEvent_ParallelReplicasReadUnassignedMarks (UInt64) — Sum across all replicas of how many unassigned marks were scheduled
ProfileEvent_ParallelReplicasReadAssignedForStealingMarks (UInt64) — Sum across all replicas of how many of scheduled marks were assigned for stealing by consistent hash
ProfileEvent_ParallelReplicasReadMarks (UInt64) — How many marks were read by the given replica
ProfileEvent_ParallelReplicasStealingByHashMicroseconds (UInt64) — Time spent collecting segments meant for stealing by hash
ProfileEvent_ParallelReplicasProcessingPartsMicroseconds (UInt64) — Time spent processing data parts
ProfileEvent_ParallelReplicasStealingLeftoversMicroseconds (UInt64) — Time spent collecting orphaned segments
ProfileEvent_ParallelReplicasCollectingOwnedSegmentsMicroseconds (UInt64) — Time spent collecting segments meant by hash
ProfileEvent_ParallelReplicasNumRequests (UInt64) — Number of requests to the initiator.
ProfileEvent_ParallelReplicasDeniedRequests (UInt64) — Number of completely denied requests to the initiator
ProfileEvent_CacheWarmerBytesDownloaded (UInt64) — Amount of data fetched into filesystem cache by dedicated background threads.
ProfileEvent_CacheWarmerDataPartsDownloaded (UInt64) — Number of data parts that were fully fetched by CacheWarmer.
ProfileEvent_IgnoredColdParts (UInt64) — See setting ignore_cold_parts_seconds. Number of times read queries ignored very new parts that weren't pulled into cache by CacheWarmer yet.
ProfileEvent_PreferredWarmedUnmergedParts (UInt64) — See setting prefer_warmed_unmerged_parts_seconds. Number of times read queries used outdated pre-merge parts that are in cache instead of merged part that wasn't pulled into cache by CacheWarmer yet.
ProfileEvent_PerfCPUCycles (UInt64) — Total cycles. Be wary of what happens during CPU frequency scaling.
ProfileEvent_PerfInstructions (UInt64) — Retired instructions. Be careful, these can be affected by various issues, most notably hardware interrupt counts.
ProfileEvent_PerfCacheReferences (UInt64) — Cache accesses. Usually, this indicates Last Level Cache accesses, but this may vary depending on your CPU. This may include prefetches and coherency messages; again this depends on the design of your CPU.
ProfileEvent_PerfCacheMisses (UInt64) — Cache misses. Usually this indicates Last Level Cache misses; this is intended to be used in conjunction with the PERFCOUNTHWCACHEREFERENCES event to calculate cache miss rates.
ProfileEvent_PerfBranchInstructions (UInt64) — Retired branch instructions. Prior to Linux 2.6.35, this used the wrong event on AMD processors.
ProfileEvent_PerfBranchMisses (UInt64) — Mispredicted branch instructions.
ProfileEvent_PerfBusCycles (UInt64) — Bus cycles, which can be different from total cycles.
ProfileEvent_PerfStalledCyclesFrontend (UInt64) — Stalled cycles during issue.
ProfileEvent_PerfStalledCyclesBackend (UInt64) — Stalled cycles during retirement.
ProfileEvent_PerfRefCPUCycles (UInt64) — Total cycles; not affected by CPU frequency scaling.
ProfileEvent_PerfCPUClock (UInt64) — The CPU clock, a high-resolution per-CPU timer
ProfileEvent_PerfTaskClock (UInt64) — A clock count specific to the task that is running
ProfileEvent_PerfContextSwitches (UInt64) — Number of context switches
ProfileEvent_PerfCPUMigrations (UInt64) — Number of times the process has migrated to a new CPU
ProfileEvent_PerfAlignmentFaults (UInt64) — Number of alignment faults. These happen when unaligned memory accesses happen; the kernel can handle these but it reduces performance. This happens only on some architectures (never on x86).
ProfileEvent_PerfEmulationFaults (UInt64) — Number of emulation faults. The kernel sometimes traps on unimplemented instructions and emulates them for user space. This can negatively impact performance.
ProfileEvent_PerfMinEnabledTime (UInt64) — For all events, minimum time that an event was enabled. Used to track event multiplexing influence
ProfileEvent_PerfMinEnabledRunningTime (UInt64) — Running time for event with minimum enabled time. Used to track the amount of event multiplexing
ProfileEvent_PerfDataTLBReferences (UInt64) — Data TLB references
ProfileEvent_PerfDataTLBMisses (UInt64) — Data TLB misses
ProfileEvent_PerfInstructionTLBReferences (UInt64) — Instruction TLB references
ProfileEvent_PerfInstructionTLBMisses (UInt64) — Instruction TLB misses
ProfileEvent_PerfLocalMemoryReferences (UInt64) — Local NUMA node memory reads
ProfileEvent_PerfLocalMemoryMisses (UInt64) — Local NUMA node memory read misses
ProfileEvent_CannotWriteToWriteBufferDiscard (UInt64) — Number of stack traces dropped by query profiler or signal handler because pipe is full or cannot write to pipe.
ProfileEvent_QueryProfilerSignalOverruns (UInt64) — Number of times we drop processing of a query profiler signal due to overrun plus the number of signals that OS has not delivered due to overrun.
ProfileEvent_QueryProfilerConcurrencyOverruns (UInt64) — Number of times we drop processing of a query profiler signal due to too many concurrent query profilers in other threads, which may indicate overload.
ProfileEvent_QueryProfilerRuns (UInt64) — Number of times QueryProfiler had been run.
ProfileEvent_QueryProfilerErrors (UInt64) — Invalid memory accesses during asynchronous stack unwinding.
ProfileEvent_CreatedLogEntryForMerge (UInt64) — Successfully created log entry to merge parts in ReplicatedMergeTree.
ProfileEvent_NotCreatedLogEntryForMerge (UInt64) — Log entry to merge parts in ReplicatedMergeTree is not created due to concurrent log update by another replica.
ProfileEvent_CreatedLogEntryForMutation (UInt64) — Successfully created log entry to mutate parts in ReplicatedMergeTree.
ProfileEvent_NotCreatedLogEntryForMutation (UInt64) — Log entry to mutate parts in ReplicatedMergeTree is not created due to concurrent log update by another replica.
ProfileEvent_S3ReadMicroseconds (UInt64) — Time of GET and HEAD requests to S3 storage.
ProfileEvent_S3ReadRequestsCount (UInt64) — Number of GET and HEAD requests to S3 storage.
ProfileEvent_S3ReadRequestsErrors (UInt64) — Number of non-throttling errors in GET and HEAD requests to S3 storage.
ProfileEvent_S3ReadRequestsThrottling (UInt64) — Number of 429 and 503 errors in GET and HEAD requests to S3 storage.
ProfileEvent_S3ReadRequestsRedirects (UInt64) — Number of redirects in GET and HEAD requests to S3 storage.
ProfileEvent_S3ReadRequestAttempts (UInt64) — Number of attempts for GET and HEAD requests, including the initial try and any retries, but excluding retries performed internally by the S3 retry strategy
ProfileEvent_S3ReadRequestRetryableErrors (UInt64) — Number of retryable errors for GET and HEAD requests, excluding retries performed internally by the S3 retry strategy
ProfileEvent_S3WriteMicroseconds (UInt64) — Time of POST, DELETE, PUT and PATCH requests to S3 storage.
ProfileEvent_S3WriteRequestsCount (UInt64) — Number of POST, DELETE, PUT and PATCH requests to S3 storage.
ProfileEvent_S3WriteRequestsErrors (UInt64) — Number of non-throttling errors in POST, DELETE, PUT and PATCH requests to S3 storage.
ProfileEvent_S3WriteRequestsThrottling (UInt64) — Number of 429 and 503 errors in POST, DELETE, PUT and PATCH requests to S3 storage.
ProfileEvent_S3WriteRequestsRedirects (UInt64) — Number of redirects in POST, DELETE, PUT and PATCH requests to S3 storage.
ProfileEvent_S3WriteRequestAttempts (UInt64) — Number of attempts for POST, DELETE, PUT and PATCH requests, including the initial try and any retries, but excluding retries performed internally by the retry strategy
ProfileEvent_S3WriteRequestRetryableErrors (UInt64) — Number of retryable errors for POST, DELETE, PUT and PATCH requests, excluding retries performed internally by the retry strategy
ProfileEvent_DiskS3ReadMicroseconds (UInt64) — Time of GET and HEAD requests to DiskS3 storage.
ProfileEvent_DiskS3ReadRequestsCount (UInt64) — Number of GET and HEAD requests to DiskS3 storage.
ProfileEvent_DiskS3ReadRequestsErrors (UInt64) — Number of non-throttling errors in GET and HEAD requests to DiskS3 storage.
ProfileEvent_DiskS3ReadRequestsThrottling (UInt64) — Number of 429 and 503 errors in GET and HEAD requests to DiskS3 storage.
ProfileEvent_DiskS3ReadRequestsRedirects (UInt64) — Number of redirects in GET and HEAD requests to DiskS3 storage.
ProfileEvent_DiskS3ReadRequestAttempts (UInt64) — Number of attempts for GET and HEAD requests to DiskS3 storage, including the initial try and any retries, but excluding retries performed internally by the S3 retry strategy
ProfileEvent_DiskS3ReadRequestRetryableErrors (UInt64) — Number of retryable errors for GET and HEAD requests to DiskS3 storage, excluding retries performed internally by the S3 retry strategy
ProfileEvent_DiskS3WriteMicroseconds (UInt64) — Time of POST, DELETE, PUT and PATCH requests to DiskS3 storage.
ProfileEvent_DiskS3WriteRequestsCount (UInt64) — Number of POST, DELETE, PUT and PATCH requests to DiskS3 storage.
ProfileEvent_DiskS3WriteRequestsErrors (UInt64) — Number of non-throttling errors in POST, DELETE, PUT and PATCH requests to DiskS3 storage.
ProfileEvent_DiskS3WriteRequestsThrottling (UInt64) — Number of 429 and 503 errors in POST, DELETE, PUT and PATCH requests to DiskS3 storage.
ProfileEvent_DiskS3WriteRequestsRedirects (UInt64) — Number of redirects in POST, DELETE, PUT and PATCH requests to DiskS3 storage.
ProfileEvent_DiskS3WriteRequestAttempts (UInt64) — Number of attempts for POST, DELETE, PUT and PATCH requests to DiskS3 storage, including the initial try and any retries, but excluding retries performed internally by the retry strategy
ProfileEvent_DiskS3WriteRequestRetryableErrors (UInt64) — Number of retryable errors for POST, DELETE, PUT and PATCH requests to DiskS3 storage, excluding retries performed internally by the retry strategy
ProfileEvent_S3DeleteObjects (UInt64) — Number of S3 API DeleteObject(s) calls.
ProfileEvent_S3CopyObject (UInt64) — Number of S3 API CopyObject calls.
ProfileEvent_S3ListObjects (UInt64) — Number of S3 API ListObjects calls.
ProfileEvent_S3HeadObject (UInt64) — Number of S3 API HeadObject calls.
ProfileEvent_S3GetObjectTagging (UInt64) — Number of S3 API GetObjectTagging calls.
ProfileEvent_S3CreateMultipartUpload (UInt64) — Number of S3 API CreateMultipartUpload calls.
ProfileEvent_S3UploadPartCopy (UInt64) — Number of S3 API UploadPartCopy calls.
ProfileEvent_S3UploadPart (UInt64) — Number of S3 API UploadPart calls.
ProfileEvent_S3AbortMultipartUpload (UInt64) — Number of S3 API AbortMultipartUpload calls.
ProfileEvent_S3CompleteMultipartUpload (UInt64) — Number of S3 API CompleteMultipartUpload calls.
ProfileEvent_S3PutObject (UInt64) — Number of S3 API PutObject calls.
ProfileEvent_S3GetObject (UInt64) — Number of S3 API GetObject calls.
ProfileEvent_DiskS3DeleteObjects (UInt64) — Number of DiskS3 API DeleteObject(s) calls.
ProfileEvent_DiskS3CopyObject (UInt64) — Number of DiskS3 API CopyObject calls.
ProfileEvent_DiskS3ListObjects (UInt64) — Number of DiskS3 API ListObjects calls.
ProfileEvent_DiskS3HeadObject (UInt64) — Number of DiskS3 API HeadObject calls.
ProfileEvent_DiskS3GetObjectTagging (UInt64) — Number of DiskS3 API GetObjectTagging calls.
ProfileEvent_DiskS3CreateMultipartUpload (UInt64) — Number of DiskS3 API CreateMultipartUpload calls.
ProfileEvent_DiskS3UploadPartCopy (UInt64) — Number of DiskS3 API UploadPartCopy calls.
ProfileEvent_DiskS3UploadPart (UInt64) — Number of DiskS3 API UploadPart calls.
ProfileEvent_DiskS3AbortMultipartUpload (UInt64) — Number of DiskS3 API AbortMultipartUpload calls.
ProfileEvent_DiskS3CompleteMultipartUpload (UInt64) — Number of DiskS3 API CompleteMultipartUpload calls.
ProfileEvent_DiskS3PutObject (UInt64) — Number of DiskS3 API PutObject calls.
ProfileEvent_DiskS3GetObject (UInt64) — Number of DiskS3 API GetObject calls.
ProfileEvent_DiskPlainRewritableAzureDirectoryCreated (UInt64) — Number of directories created by the 'plain_rewritable' metadata storage for AzureObjectStorage.
ProfileEvent_DiskPlainRewritableAzureDirectoryRemoved (UInt64) — Number of directories removed by the 'plain_rewritable' metadata storage for AzureObjectStorage.
ProfileEvent_DiskPlainRewritableLocalDirectoryCreated (UInt64) — Number of directories created by the 'plain_rewritable' metadata storage for LocalObjectStorage.
ProfileEvent_DiskPlainRewritableLocalDirectoryRemoved (UInt64) — Number of directories removed by the 'plain_rewritable' metadata storage for LocalObjectStorage.
ProfileEvent_DiskPlainRewritableS3DirectoryCreated (UInt64) — Number of directories created by the 'plain_rewritable' metadata storage for S3ObjectStorage.
ProfileEvent_DiskPlainRewritableS3DirectoryRemoved (UInt64) — Number of directories removed by the 'plain_rewritable' metadata storage for S3ObjectStorage.
ProfileEvent_DiskPlainRewritableLegacyLayoutDiskCount (UInt64) — Number of the 'plain_rewritable' disks with legacy layout.
ProfileEvent_S3Clients (UInt64) — Number of created S3 clients.
ProfileEvent_TinyS3Clients (UInt64) — Number of S3 clients copies which reuse an existing auth provider from another client.
ProfileEvent_EngineFileLikeReadFiles (UInt64) — Number of files read in table engines working with files (like File/S3/URL/HDFS).
ProfileEvent_ReadBufferFromS3Microseconds (UInt64) — Time spent on reading from S3.
ProfileEvent_ReadBufferFromS3InitMicroseconds (UInt64) — Time spent initializing connection to S3.
ProfileEvent_ReadBufferFromS3Bytes (UInt64) — Bytes read from S3.
ProfileEvent_ReadBufferFromS3RequestsErrors (UInt64) — Number of exceptions while reading from S3.
ProfileEvent_WriteBufferFromS3Microseconds (UInt64) — Time spent on writing to S3.
ProfileEvent_WriteBufferFromS3Bytes (UInt64) — Bytes written to S3.
ProfileEvent_WriteBufferFromS3RequestsErrors (UInt64) — Number of exceptions while writing to S3.
ProfileEvent_WriteBufferFromS3WaitInflightLimitMicroseconds (UInt64) — Time spent on waiting while some of the current requests are done when its number reached the limit defined by s3_max_inflight_parts_for_one_file.
ProfileEvent_QueryMemoryLimitExceeded (UInt64) — Number of times when memory limit exceeded for query.
ProfileEvent_MemoryAllocatedWithoutCheck (UInt64) — Number of times memory has been allocated without checking for memory constraints.
ProfileEvent_MemoryAllocatedWithoutCheckBytes (UInt64) — Amount of bytes that has been allocated without checking for memory constraints.
ProfileEvent_AzureGetObject (UInt64) — Number of Azure API GetObject calls.
ProfileEvent_AzureUpload (UInt64) — Number of Azure blob storage API Upload calls
ProfileEvent_AzureStageBlock (UInt64) — Number of Azure blob storage API StageBlock calls
ProfileEvent_AzureCommitBlockList (UInt64) — Number of Azure blob storage API CommitBlockList calls
ProfileEvent_AzureCopyObject (UInt64) — Number of Azure blob storage API CopyObject calls
ProfileEvent_AzureDeleteObjects (UInt64) — Number of Azure blob storage API DeleteObject(s) calls.
ProfileEvent_AzureListObjects (UInt64) — Number of Azure blob storage API ListObjects calls.
ProfileEvent_AzureGetProperties (UInt64) — Number of Azure blob storage API GetProperties calls.
ProfileEvent_AzureCreateContainer (UInt64) — Number of Azure blob storage API CreateContainer calls.
ProfileEvent_DiskAzureGetObject (UInt64) — Number of Disk Azure API GetObject calls.
ProfileEvent_DiskAzureUpload (UInt64) — Number of Disk Azure blob storage API Upload calls
ProfileEvent_DiskAzureStageBlock (UInt64) — Number of Disk Azure blob storage API StageBlock calls
ProfileEvent_DiskAzureCommitBlockList (UInt64) — Number of Disk Azure blob storage API CommitBlockList calls
ProfileEvent_DiskAzureCopyObject (UInt64) — Number of Disk Azure blob storage API CopyObject calls
ProfileEvent_DiskAzureListObjects (UInt64) — Number of Disk Azure blob storage API ListObjects calls.
ProfileEvent_DiskAzureDeleteObjects (UInt64) — Number of Azure blob storage API DeleteObject(s) calls.
ProfileEvent_DiskAzureGetProperties (UInt64) — Number of Disk Azure blob storage API GetProperties calls.
ProfileEvent_DiskAzureCreateContainer (UInt64) — Number of Disk Azure blob storage API CreateContainer calls.
ProfileEvent_ReadBufferFromAzureMicroseconds (UInt64) — Time spent on reading from Azure.
ProfileEvent_ReadBufferFromAzureInitMicroseconds (UInt64) — Time spent initializing connection to Azure.
ProfileEvent_ReadBufferFromAzureBytes (UInt64) — Bytes read from Azure.
ProfileEvent_ReadBufferFromAzureRequestsErrors (UInt64) — Number of exceptions while reading from Azure
ProfileEvent_CachedReadBufferReadFromCacheHits (UInt64) — Number of times the read from filesystem cache hit the cache.
ProfileEvent_CachedReadBufferReadFromCacheMisses (UInt64) — Number of times the read from filesystem cache miss the cache.
ProfileEvent_CachedReadBufferReadFromSourceMicroseconds (UInt64) — Time reading from filesystem cache source (from remote filesystem, etc)
ProfileEvent_CachedReadBufferWaitReadBufferMicroseconds (UInt64) — Time spend waiting for internal read buffer (includes cache waiting)
ProfileEvent_CachedReadBufferPredownloadedFromSourceMicroseconds (UInt64) — Time reading from filesystem cache source for predownload (from remote filesystem, etc)
ProfileEvent_CachedReadBufferReadFromCacheMicroseconds (UInt64) — Time reading from filesystem cache
ProfileEvent_CachedReadBufferReadFromSourceBytes (UInt64) — Bytes read from filesystem cache source (from remote fs, etc)
ProfileEvent_CachedReadBufferPredownloadedFromSourceBytes (UInt64) — Bytes read from filesystem cache source for predownload (from remote fs, etc)
ProfileEvent_CachedReadBufferReadFromCacheBytes (UInt64) — Bytes read from filesystem cache
ProfileEvent_CachedReadBufferPredownloadedBytes (UInt64) — Bytes read from filesystem cache source. Cache segments are read from left to right as a whole, it might be that we need to predownload some part of the segment irrelevant for the current task just to get to the needed data
ProfileEvent_CachedReadBufferCacheWriteBytes (UInt64) — Bytes written from source (remote fs, etc) to filesystem cache
ProfileEvent_CachedReadBufferCacheWriteMicroseconds (UInt64) — Time spent writing data into filesystem cache
ProfileEvent_CachedReadBufferCreateBufferMicroseconds (UInt64) — Prepare buffer time
ProfileEvent_CachedWriteBufferCacheWriteBytes (UInt64) — Bytes written from source (remote fs, etc) to filesystem cache
ProfileEvent_CachedWriteBufferCacheWriteMicroseconds (UInt64) — Time spent writing data into filesystem cache
ProfileEvent_FilesystemCacheLoadMetadataMicroseconds (UInt64) — Time spent loading filesystem cache metadata
ProfileEvent_FilesystemCacheEvictedBytes (UInt64) — Number of bytes evicted from filesystem cache
ProfileEvent_FilesystemCacheCreatedKeyDirectories (UInt64) — Number of created key directories
ProfileEvent_FilesystemCacheEvictedFileSegments (UInt64) — Number of file segments evicted from filesystem cache
ProfileEvent_FilesystemCacheEvictedFileSegmentsDuringPriorityIncrease (UInt64) — Number of file segments evicted from filesystem cache when increasing priority of file segments (Applies to SLRU cache policy)
ProfileEvent_FilesystemCacheBackgroundDownloadQueuePush (UInt64) — Number of file segments sent for background download in filesystem cache
ProfileEvent_FilesystemCacheEvictionSkippedFileSegments (UInt64) — Number of file segments skipped for eviction because of being in unreleasable state
ProfileEvent_FilesystemCacheEvictionSkippedEvictingFileSegments (UInt64) — Number of file segments skipped for eviction because of being in evicting state
ProfileEvent_FilesystemCacheEvictionSkippedMovingFileSegments (UInt64) — Number of file segments skipped for eviction because of being in moving state
ProfileEvent_FilesystemCacheEvictionTries (UInt64) — Number of filesystem cache eviction attempts
ProfileEvent_FilesystemCacheEvictionReusedIterator (UInt64) — Number of filesystem cache iterator reusing
ProfileEvent_FilesystemCacheLockKeyMicroseconds (UInt64) — Lock cache key time
ProfileEvent_FilesystemCacheLockMetadataMicroseconds (UInt64) — Lock filesystem cache metadata time
ProfileEvent_FilesystemCachePriorityWriteLockMicroseconds (UInt64) — Lock filesystem cache time for write to priority queue
ProfileEvent_FilesystemCachePriorityReadLockMicroseconds (UInt64) — Lock filesystem cache time for read in priority queue
ProfileEvent_FilesystemCacheStateLockMicroseconds (UInt64) — Lock filesystem cache time for state lock
ProfileEvent_FilesystemCacheReserveMicroseconds (UInt64) — Filesystem cache space reservation time
ProfileEvent_FilesystemCacheReserveAttempts (UInt64) — Filesystem cache space reservation attempt
ProfileEvent_FilesystemCacheEvictMicroseconds (UInt64) — Filesystem cache eviction time
ProfileEvent_FilesystemCacheGetOrSetMicroseconds (UInt64) — Filesystem cache getOrSet() time
ProfileEvent_FilesystemCacheGetMicroseconds (UInt64) — Filesystem cache get() time
ProfileEvent_FilesystemCacheBackgroundEvictedFileSegments (UInt64) — Number of file segments evicted by background thread
ProfileEvent_FilesystemCacheBackgroundEvictedBytes (UInt64) — Number of bytes evicted by background thread
ProfileEvent_FilesystemCacheCheckCorrectness (UInt64) — Number of times FileCache::assertCacheCorrectness was called
ProfileEvent_FilesystemCacheCheckCorrectnessMicroseconds (UInt64) — How much time does FileCache::assertCacheCorrectness takes
ProfileEvent_FileSegmentWaitMicroseconds (UInt64) — Wait on DOWNLOADING state
ProfileEvent_FileSegmentCompleteMicroseconds (UInt64) — Duration of FileSegment::complete() in filesystem cache
ProfileEvent_FileSegmentLockMicroseconds (UInt64) — Lock file segment time
ProfileEvent_FileSegmentWriteMicroseconds (UInt64) — File segment write() time
ProfileEvent_FileSegmentIncreasePriorityMicroseconds (UInt64) — File segment increase priority time
ProfileEvent_FileSegmentRemoveMicroseconds (UInt64) — File segment remove() time
ProfileEvent_FileSegmentHolderCompleteMicroseconds (UInt64) — File segments holder complete() time
ProfileEvent_FileSegmentFailToIncreasePriority (UInt64) — Number of times the priority was not increased due to a high contention on the cache lock
ProfileEvent_FilesystemCacheFailToReserveSpaceBecauseOfLockContention (UInt64) — Number of times space reservation was skipped due to a high contention on the cache lock
ProfileEvent_FilesystemCacheFailToReserveSpaceBecauseOfCacheResize (UInt64) — Number of times space reservation was skipped due to the cache is being resized
ProfileEvent_FilesystemCacheHoldFileSegments (UInt64) — Filesystem cache file segments count, which were hold
ProfileEvent_FilesystemCacheUnusedHoldFileSegments (UInt64) — Filesystem cache file segments count, which were hold, but not used (because of seek or LIMIT n, etc)
ProfileEvent_FilesystemCacheFreeSpaceKeepingThreadRun (UInt64) — Number of times background thread executed free space keeping job
ProfileEvent_FilesystemCacheFreeSpaceKeepingThreadWorkMilliseconds (UInt64) — Time for which background thread executed free space keeping job
ProfileEvent_FilesystemCacheFailedEvictionCandidates (UInt64) — Number of file segments which unexpectedly failed to be evicted during dynamic filesystem cache eviction
ProfileEvent_RemoteFSSeeks (UInt64) — Total number of seeks for async buffer
ProfileEvent_RemoteFSPrefetches (UInt64) — Number of prefetches made with asynchronous reading from remote filesystem
ProfileEvent_RemoteFSCancelledPrefetches (UInt64) — Number of cancelled prefecthes (because of seek)
ProfileEvent_RemoteFSUnusedPrefetches (UInt64) — Number of prefetches pending at buffer destruction
ProfileEvent_RemoteFSPrefetchedReads (UInt64) — Number of reads from prefecthed buffer
ProfileEvent_RemoteFSPrefetchedBytes (UInt64) — Number of bytes from prefecthed buffer
ProfileEvent_RemoteFSUnprefetchedReads (UInt64) — Number of reads from unprefetched buffer
ProfileEvent_RemoteFSUnprefetchedBytes (UInt64) — Number of bytes from unprefetched buffer
ProfileEvent_RemoteFSLazySeeks (UInt64) — Number of lazy seeks
ProfileEvent_RemoteFSSeeksWithReset (UInt64) — Number of seeks which lead to a new connection
ProfileEvent_RemoteFSBuffers (UInt64) — Number of buffers created for asynchronous reading from remote filesystem
ProfileEvent_MergeTreePrefetchedReadPoolInit (UInt64) — Time spent preparing tasks in MergeTreePrefetchedReadPool
ProfileEvent_WaitPrefetchTaskMicroseconds (UInt64) — Time spend waiting for prefetched reader
ProfileEvent_ThreadpoolReaderTaskMicroseconds (UInt64) — Time spent getting the data in asynchronous reading
ProfileEvent_ThreadpoolReaderPrepareMicroseconds (UInt64) — Time spent on preparation (e.g. call to reader seek() method)
ProfileEvent_ThreadpoolReaderReadBytes (UInt64) — Bytes read from a threadpool task in asynchronous reading
ProfileEvent_ThreadpoolReaderSubmit (UInt64) — Bytes read from a threadpool task in asynchronous reading
ProfileEvent_ThreadpoolReaderSubmitReadSynchronously (UInt64) — How many times we haven't scheduled a task on the thread pool and read synchronously instead
ProfileEvent_ThreadpoolReaderSubmitReadSynchronouslyBytes (UInt64) — How many bytes were read synchronously
ProfileEvent_ThreadpoolReaderSubmitReadSynchronouslyMicroseconds (UInt64) — How much time we spent reading synchronously
ProfileEvent_ThreadpoolReaderSubmitLookupInCacheMicroseconds (UInt64) — How much time we spent checking if content is cached
ProfileEvent_AsynchronousReaderIgnoredBytes (UInt64) — Number of bytes ignored during asynchronous reading
ProfileEvent_ReadBufferSeekCancelConnection (UInt64) — Number of seeks which lead to new connection (s3, http)
ProfileEvent_SleepFunctionCalls (UInt64) — Number of times a sleep function (sleep, sleepEachRow) has been called.
ProfileEvent_SleepFunctionMicroseconds (UInt64) — Time set to sleep in a sleep function (sleep, sleepEachRow).
ProfileEvent_SleepFunctionElapsedMicroseconds (UInt64) — Time spent sleeping in a sleep function (sleep, sleepEachRow).
ProfileEvent_ThreadPoolReaderPageCacheHit (UInt64) — Number of times the read inside ThreadPoolReader was done from the page cache.
ProfileEvent_ThreadPoolReaderPageCacheHitBytes (UInt64) — Number of bytes read inside ThreadPoolReader when it was done from the page cache.
ProfileEvent_ThreadPoolReaderPageCacheHitElapsedMicroseconds (UInt64) — Time spent reading data from page cache in ThreadPoolReader.
ProfileEvent_ThreadPoolReaderPageCacheMiss (UInt64) — Number of times the read inside ThreadPoolReader was not done from page cache and was hand off to thread pool.
ProfileEvent_ThreadPoolReaderPageCacheMissBytes (UInt64) — Number of bytes read inside ThreadPoolReader when read was not done from page cache and was hand off to thread pool.
ProfileEvent_ThreadPoolReaderPageCacheMissElapsedMicroseconds (UInt64) — Time spent reading data inside the asynchronous job in ThreadPoolReader - when read was not done from the page cache.
ProfileEvent_AsynchronousReadWaitMicroseconds (UInt64) — Time spent in waiting for asynchronous reads in asynchronous local read.
ProfileEvent_SynchronousReadWaitMicroseconds (UInt64) — Time spent in waiting for synchronous reads in asynchronous local read.
ProfileEvent_AsynchronousRemoteReadWaitMicroseconds (UInt64) — Time spent in waiting for asynchronous remote reads.
ProfileEvent_SynchronousRemoteReadWaitMicroseconds (UInt64) — Time spent in waiting for synchronous remote reads.
ProfileEvent_ExternalDataSourceLocalCacheReadBytes (UInt64) — Bytes read from local cache buffer in RemoteReadBufferCache
ProfileEvent_MainConfigLoads (UInt64) — Number of times the main configuration was reloaded.
ProfileEvent_AggregationPreallocatedElementsInHashTables (UInt64) — How many elements were preallocated in hash tables for aggregation.
ProfileEvent_AggregationHashTablesInitializedAsTwoLevel (UInt64) — How many hash tables were inited as two-level for aggregation.
ProfileEvent_AggregationOptimizedEqualRangesOfKeys (UInt64) — For how many blocks optimization of equal ranges of keys was applied
ProfileEvent_HashJoinPreallocatedElementsInHashTables (UInt64) — How many elements were preallocated in hash tables for hash join.
ProfileEvent_MetadataFromKeeperCacheHit (UInt64) — Number of times an object storage metadata request was answered from cache without making request to Keeper
ProfileEvent_MetadataFromKeeperCacheMiss (UInt64) — Number of times an object storage metadata request had to be answered from Keeper
ProfileEvent_MetadataFromKeeperCacheTooManyInvalidated (UInt64) — Number of times filesystem cache returned too many invalidated entries
ProfileEvent_MetadataFromKeeperCacheUpdateMicroseconds (UInt64) — Total time spent in updating the cache including waiting for responses from Keeper
ProfileEvent_MetadataFromKeeperUpdateCacheOneLevel (UInt64) — Number of times a cache update for one level of directory tree was done
ProfileEvent_MetadataFromKeeperTransactionCommit (UInt64) — Number of times metadata transaction commit was attempted
ProfileEvent_MetadataFromKeeperTransactionCommitRetry (UInt64) — Number of times metadata transaction commit was retried
ProfileEvent_MetadataFromKeeperCleanupTransactionCommit (UInt64) — Number of times metadata transaction commit for deleted objects cleanup was attempted
ProfileEvent_MetadataFromKeeperCleanupTransactionCommitRetry (UInt64) — Number of times metadata transaction commit for deleted objects cleanup was retried
ProfileEvent_MetadataFromKeeperOperations (UInt64) — Number of times a request was made to Keeper
ProfileEvent_MetadataFromKeeperIndividualOperations (UInt64) — Number of paths read or written by single or multi requests to Keeper
ProfileEvent_MetadataFromKeeperIndividualOperationsMicroseconds (UInt64) — Time spend during single or multi requests to Keeper
ProfileEvent_MetadataFromKeeperReconnects (UInt64) — Number of times a reconnect to Keeper was done
ProfileEvent_MetadataFromKeeperBackgroundCleanupObjects (UInt64) — Number of times a old deleted object clean up was performed by background task
ProfileEvent_MetadataFromKeeperBackgroundCleanupTransactions (UInt64) — Number of times old transaction idempotency token was cleaned up by background task
ProfileEvent_MetadataFromKeeperBackgroundCleanupBlobs (UInt64) — Number of times an empty blob layout part was cleaned up by background task
ProfileEvent_MetadataFromKeeperBackgroundCleanupErrors (UInt64) — Number of times an error was encountered in background cleanup task
ProfileEvent_BlobKillerThreadRuns (UInt64) — Number of BlobKiller thread executes
ProfileEvent_BlobKillerThreadLockedBlobs (UInt64) — Number of blobs returned from metadata storage
ProfileEvent_BlobKillerThreadRemoveTasks (UInt64) — Number of remove tasks created by BlobKiller
ProfileEvent_BlobKillerThreadRemovedBlobs (UInt64) — Number of blobs removed by BlobKiller
ProfileEvent_BlobKillerThreadRecordedBlobs (UInt64) — Number of blobs which removal by BlobKiller was recorded in metadata storage
ProfileEvent_BlobKillerThreadLockBlobsErrors (UInt64) — Number of blobs lock errors occurred during BlobKiller execution
ProfileEvent_BlobKillerThreadRemoveBlobsErrors (UInt64) — Number of blobs removal errors occurred during BlobKiller execution
ProfileEvent_BlobKillerThreadRecordBlobsErrors (UInt64) — Number of blobs recording errors occurred during BlobKiller execution
ProfileEvent_BlobCopierThreadRuns (UInt64) — Number of BlobCopier thread executes
ProfileEvent_BlobCopierThreadLockedBlobs (UInt64) — Number of blobs returned from metadata storage
ProfileEvent_BlobCopierThreadReplicatedBlobs (UInt64) — Number of blobs replicated by BlobCopier
ProfileEvent_BlobCopierThreadRecordedBlobs (UInt64) — Number of blobs which replication by BlobCopier was recorded in metadata storage
ProfileEvent_BlobCopierThreadLockBlobsErrors (UInt64) — Number of blobs lock errors occurred during BlobCopier execution
ProfileEvent_BlobCopierThreadReplicateBlobsErrors (UInt64) — Number of blobs replication errors occurred during BlobCopier execution
ProfileEvent_BlobCopierThreadRecordBlobsErrors (UInt64) — Number of blobs recording errors occurred during BlobCopier execution
ProfileEvent_SharedMergeTreeMetadataCacheHintLoadedFromCache (UInt64) — Number of times metadata cache hint was found without going to Keeper
ProfileEvent_KafkaRebalanceRevocations (UInt64) — Number of partition revocations (the first stage of consumer group rebalance)
ProfileEvent_KafkaRebalanceAssignments (UInt64) — Number of partition assignments (the final stage of consumer group rebalance)
ProfileEvent_KafkaRebalanceErrors (UInt64) — Number of failed consumer group rebalances
ProfileEvent_KafkaMessagesPolled (UInt64) — Number of Kafka messages polled from librdkafka to ClickHouse
ProfileEvent_KafkaMessagesRead (UInt64) — Number of Kafka messages already processed by ClickHouse
ProfileEvent_KafkaMessagesFailed (UInt64) — Number of Kafka messages ClickHouse failed to parse
ProfileEvent_KafkaRowsRead (UInt64) — Number of rows parsed from Kafka messages
ProfileEvent_KafkaRowsRejected (UInt64) — Number of parsed rows which were later rejected (due to rebalances / errors or similar reasons). Those rows will be consumed again after the rebalance.
ProfileEvent_KafkaDirectReads (UInt64) — Number of direct selects from Kafka tables since server start
ProfileEvent_KafkaBackgroundReads (UInt64) — Number of background reads populating materialized views from Kafka since server start
ProfileEvent_KafkaCommits (UInt64) — Number of successful commits of consumed offsets to Kafka (normally should be the same as KafkaBackgroundReads)
ProfileEvent_KafkaCommitFailures (UInt64) — Number of failed commits of consumed offsets to Kafka (usually is a sign of some data duplication)
ProfileEvent_KafkaConsumerErrors (UInt64) — Number of errors reported by librdkafka during polls
ProfileEvent_KafkaMVNotReady (UInt64) — Number of failed attempts to stream data to a materialized view that is not ready
ProfileEvent_KafkaWrites (UInt64) — Number of writes (inserts) to Kafka tables
ProfileEvent_KafkaRowsWritten (UInt64) — Number of rows inserted into Kafka tables
ProfileEvent_KafkaProducerFlushes (UInt64) — Number of explicit flushes to Kafka producer
ProfileEvent_KafkaMessagesProduced (UInt64) — Number of messages produced to Kafka
ProfileEvent_KafkaProducerErrors (UInt64) — Number of errors during producing the messages to Kafka
ProfileEvent_ScalarSubqueriesGlobalCacheHit (UInt64) — Number of times a read from a scalar subquery was done using the global cache
ProfileEvent_ScalarSubqueriesLocalCacheHit (UInt64) — Number of times a read from a scalar subquery was done using the local cache
ProfileEvent_ScalarSubqueriesCacheMiss (UInt64) — Number of times a read from a scalar subquery was not cached and had to be calculated completely
ProfileEvent_SchemaInferenceCacheHits (UInt64) — Number of times the requested source is found in schema cache
ProfileEvent_SchemaInferenceCacheSchemaHits (UInt64) — Number of times the schema is found in schema cache during schema inference
ProfileEvent_SchemaInferenceCacheNumRowsHits (UInt64) — Number of times the number of rows is found in schema cache during count from files
ProfileEvent_SchemaInferenceCacheMisses (UInt64) — Number of times the requested source is not in schema cache
ProfileEvent_SchemaInferenceCacheSchemaMisses (UInt64) — Number of times the requested source is in cache but the schema is not in cache during schema inference
ProfileEvent_SchemaInferenceCacheNumRowsMisses (UInt64) — Number of times the requested source is in cache but the number of rows is not in cache while count from files
ProfileEvent_SchemaInferenceCacheEvictions (UInt64) — Number of times a schema from cache was evicted due to overflow
ProfileEvent_SchemaInferenceCacheInvalidations (UInt64) — Number of times a schema in cache became invalid due to changes in data
ProfileEvent_KeeperPacketsSent (UInt64) — Packets sent by keeper server
ProfileEvent_KeeperPacketsReceived (UInt64) — Packets received by keeper server
ProfileEvent_KeeperRequestTotal (UInt64) — Total requests number on keeper server
ProfileEvent_KeeperRequestTotalWithSubrequests (UInt64) — Total requests number on keeper server, counting each subrequest within a multi request
ProfileEvent_KeeperLatency (UInt64) — Keeper latency
ProfileEvent_KeeperTotalElapsedMicroseconds (UInt64) — Keeper total latency for a single request
ProfileEvent_KeeperProcessElapsedMicroseconds (UInt64) — Keeper commit latency for a single request
ProfileEvent_KeeperPreprocessElapsedMicroseconds (UInt64) — Keeper preprocessing latency for a single request
ProfileEvent_KeeperStorageLockWaitMicroseconds (UInt64) — Time spent waiting for acquiring Keeper storage lock
ProfileEvent_KeeperStorageSharedLockWaitMicroseconds (UInt64) — Time spent waiting for acquiring Keeper storage shared lock
ProfileEvent_KeeperChangelogLockWaitMicroseconds (UInt64) — Time spent waiting for acquiring Keeper changelog lock
ProfileEvent_KeeperServerWriteLockWaitMicroseconds (UInt64) — Time spent waiting for acquiring Keeper server write lock
ProfileEvent_KeeperSessionCallbackLockWaitMicroseconds (UInt64) — Time spent waiting for acquiring Keeper session callback lock
ProfileEvent_KeeperReadRequestQueueLockWaitMicroseconds (UInt64) — Time spent waiting for acquiring Keeper read request queue lock
ProfileEvent_KeeperProcessAndResponsesLockWaitMicroseconds (UInt64) — Time spent waiting for acquiring Keeper process and responses lock
ProfileEvent_KeeperCommitWaitElapsedMicroseconds (UInt64) — Time spent waiting for certain log to be committed
ProfileEvent_KeeperBatchMaxCount (UInt64) — Number of times the size of batch was limited by the amount
ProfileEvent_KeeperBatchMaxTotalSize (UInt64) — Number of times the size of batch was limited by the total bytes size
ProfileEvent_KeeperReadBatchCount (UInt64) — Number of read request batches processed by Keeper
ProfileEvent_KeeperReadBatchTotalRequests (UInt64) — Total number of read requests processed in batches by Keeper
ProfileEvent_KeeperCommits (UInt64) — Number of successful commits
ProfileEvent_KeeperCommitsFailed (UInt64) — Number of failed commits
ProfileEvent_KeeperSnapshotCreations (UInt64) — Number of snapshots creations
ProfileEvent_KeeperSnapshotCreationsFailed (UInt64) — Number of failed snapshot creations
ProfileEvent_KeeperSnapshotApplys (UInt64) — Number of snapshot applying
ProfileEvent_KeeperSnapshotApplysFailed (UInt64) — Number of failed snapshot applying
ProfileEvent_KeeperReadSnapshot (UInt64) — Number of completed snapshot reads
ProfileEvent_KeeperReadSnapshotObject (UInt64) — Number of snapshot objects sent to followers
ProfileEvent_KeeperReadSnapshotFailed (UInt64) — Number of failed snapshot reads
ProfileEvent_KeeperSnapshotRemoteLoaderErrors (UInt64) — Number of remote read errors in RemoteSnapshotLoader while serving a snapshot to a follower
ProfileEvent_KeeperSaveSnapshotObject (UInt64) — Number of snapshot objects received from leader
ProfileEvent_KeeperSaveSnapshotFailed (UInt64) — Number of failed snapshot saves
ProfileEvent_KeeperSaveSnapshot (UInt64) — Number of snapshot save
ProfileEvent_KeeperCreateRequest (UInt64) — Number of create requests
ProfileEvent_KeeperRemoveRequest (UInt64) — Number of remove requests
ProfileEvent_KeeperSetRequest (UInt64) — Number of set requests
ProfileEvent_KeeperReconfigRequest (UInt64) — Number of reconfig requests
ProfileEvent_KeeperCheckRequest (UInt64) — Number of check requests
ProfileEvent_KeeperMultiRequest (UInt64) — Number of multi requests
ProfileEvent_KeeperMultiReadRequest (UInt64) — Number of multi read requests
ProfileEvent_KeeperGetRequest (UInt64) — Number of get requests
ProfileEvent_KeeperListRequest (UInt64) — Number of list requests
ProfileEvent_KeeperListRecursiveRequest (UInt64) — Number of get children recursive requests
ProfileEvent_KeeperExistsRequest (UInt64) — Number of exists requests
ProfileEvent_KeeperSetWatchesRequest (UInt64) — Number of set watches requests
ProfileEvent_KeeperAddWatchRequest (UInt64) — Number of add watches requests
ProfileEvent_KeeperRemoveWatchRequest (UInt64) — Number of remove watches requests
ProfileEvent_KeeperCheckWatchRequest (UInt64) — Number of remove watches requests
ProfileEvent_KeeperRequestRejectedDueToSoftMemoryLimitCount (UInt64) — Number requests that have been rejected due to soft memory limit exceeded
ProfileEvent_KeeperStaleRequestsSkipped (UInt64) — Number of Keeper requests skipped because the session is no longer live
ProfileEvent_KeeperLiveSessionsLockWaitMicroseconds (UInt64) — Time spent waiting to acquire Keeper live sessions lock
ProfileEvent_OverflowBreak (UInt64) — Number of times, data processing was cancelled by query complexity limitation with setting '*_overflow_mode' = 'break' and the result is incomplete.
ProfileEvent_OverflowThrow (UInt64) — Number of times, data processing was cancelled by query complexity limitation with setting '*_overflow_mode' = 'throw' and exception was thrown.
ProfileEvent_OverflowAny (UInt64) — Number of times approximate GROUP BY was in effect: when aggregation was performed only on top of first 'max_rows_to_group_by' unique keys and other keys were ignored due to 'group_by_overflow_mode' = 'any'.
ProfileEvent_S3QueueSetFileProcessingMicroseconds (UInt64) — Time spent to set file as processing
ProfileEvent_S3QueueSetFileProcessedMicroseconds (UInt64) — Time spent to set file as processed
ProfileEvent_S3QueueSetFileFailedMicroseconds (UInt64) — Time spent to set file as failed
ProfileEvent_ObjectStorageQueueFailedFiles (UInt64) — Number of files which failed to be processed
ProfileEvent_ObjectStorageQueueProcessedFiles (UInt64) — Number of files which were processed
ProfileEvent_ObjectStorageQueueCleanupMaxSetSizeOrTTLMicroseconds (UInt64) — Time spent to set file as failed
ProfileEvent_ObjectStorageQueuePullMicroseconds (UInt64) — Time spent to read file data
ProfileEvent_ObjectStorageQueueFailedToBatchSetProcessing (UInt64) — Number of times batched set processing request failed
ProfileEvent_ObjectStorageQueueTrySetProcessingRequests (UInt64) — The number of times we tried to make set processing request
ProfileEvent_ObjectStorageQueueTrySetProcessingSucceeded (UInt64) — The number of times we successfully set file as processing
ProfileEvent_ObjectStorageQueueTrySetProcessingFailed (UInt64) — The number of times we unsuccessfully set file as processing
ProfileEvent_ObjectStorageQueueListedFiles (UInt64) — Number of listed files in StorageS3(Azure)Queue
ProfileEvent_ObjectStorageQueueFilteredFiles (UInt64) — Number of filtered files in StorageS3(Azure)Queue
ProfileEvent_ObjectStorageQueueReadFiles (UInt64) — Number of read files (not equal to the number of actually inserted files)
ProfileEvent_ObjectStorageQueueReadRows (UInt64) — Number of read rows (not equal to the number of actually inserted rows)
ProfileEvent_ObjectStorageQueueReadBytes (UInt64) — Number of read bytes (not equal to the number of actually inserted bytes)
ProfileEvent_ObjectStorageQueueExceptionsDuringRead (UInt64) — Number of exceptions during read in S3(Azure)Queue
ProfileEvent_ObjectStorageQueueExceptionsDuringInsert (UInt64) — Number of exceptions during insert in S3(Azure)Queue
ProfileEvent_ObjectStorageQueueMovedObjects (UInt64) — Number of objects moved as part of after_processing = move
ProfileEvent_ObjectStorageQueueRemovedObjects (UInt64) — Number of objects removed as part of after_processing = delete
ProfileEvent_ObjectStorageQueueTaggedObjects (UInt64) — Number of objects tagged as part of after_processing = tag
ProfileEvent_ObjectStorageQueueInsertIterations (UInt64) — Number of insert iterations
ProfileEvent_ObjectStorageQueueCommitRequests (UInt64) — Number of keeper requests to commit files as either failed or processed
ProfileEvent_ObjectStorageQueueSuccessfulCommits (UInt64) — Number of successful keeper commits
ProfileEvent_ObjectStorageQueueUnsuccessfulCommits (UInt64) — Number of unsuccessful keeper commits
ProfileEvent_ObjectStorageQueueCancelledFiles (UInt64) — Number cancelled files in StorageS3(Azure)Queue
ProfileEvent_ObjectStorageQueueProcessedRows (UInt64) — Number of processed rows in StorageS3(Azure)Queue
ProfileEvent_ObjectStorageListedObjects (UInt64) — Total objects returned by object storage listing API before any filtering.
ProfileEvent_ObjectStorageGlobFilteredObjects (UInt64) — Objects that did not match the glob or regex pattern and were skipped during listing.
ProfileEvent_ObjectStoragePredicateFilteredObjects (UInt64) — Objects removed by virtual column predicate filtering on _path/_file.
ProfileEvent_ObjectStorageReadObjects (UInt64) — Objects actually opened for reading by the object storage source.
ProfileEvent_ServerStartupMilliseconds (UInt64) — Time elapsed from starting server to listening to sockets in milliseconds
ProfileEvent_IOUringSQEsSubmitted (UInt64) — Total number of io_uring SQEs submitted
ProfileEvent_IOUringSQEsResubmitsAsync (UInt64) — Total number of asynchronous io_uring SQE resubmits performed
ProfileEvent_IOUringSQEsResubmitsSync (UInt64) — Total number of synchronous io_uring SQE resubmits performed
ProfileEvent_IOUringCQEsCompleted (UInt64) — Total number of successfully completed io_uring CQEs
ProfileEvent_IOUringCQEsFailed (UInt64) — Total number of completed io_uring CQEs with failures
ProfileEvent_BackupsOpenedForRead (UInt64) — Number of backups opened for reading
ProfileEvent_BackupsOpenedForWrite (UInt64) — Number of backups opened for writing
ProfileEvent_BackupsOpenedForUnlock (UInt64) — Number of backups opened for unlocking
ProfileEvent_BackupReadMetadataMicroseconds (UInt64) — Time spent reading backup metadata from .backup file
ProfileEvent_BackupWriteMetadataMicroseconds (UInt64) — Time spent writing backup metadata to .backup file
ProfileEvent_BackupEntriesCollectorMicroseconds (UInt64) — Time spent making backup entries
ProfileEvent_BackupEntriesCollectorForTablesDataMicroseconds (UInt64) — Time spent making backup entries for tables data
ProfileEvent_BackupEntriesCollectorRunPostTasksMicroseconds (UInt64) — Time spent running post tasks after making backup entries
ProfileEvent_BackupPreparingFileInfosMicroseconds (UInt64) — Time spent preparing file infos for backup entries
ProfileEvent_BackupReadLocalFilesToCalculateChecksums (UInt64) — Number of files read locally to calculate checksums for backup entries
ProfileEvent_BackupReadLocalBytesToCalculateChecksums (UInt64) — Total size of files read locally to calculate checksums for backup entries
ProfileEvent_BackupReadRemoteFilesToCalculateChecksums (UInt64) — Number of files read from remote disks to calculate checksums for backup entries
ProfileEvent_BackupReadRemoteBytesToCalculateChecksums (UInt64) — Total size of files read from remote disks to calculate checksums for backup entries
ProfileEvent_BackupLockFileReads (UInt64) — How many times the '.lock' file was read while making backup
ProfileEvent_RestorePartsSkippedFiles (UInt64) — Number of files skipped while restoring parts
ProfileEvent_RestorePartsSkippedBytes (UInt64) — Total size of files skipped while restoring parts
ProfileEvent_ReadTaskRequestsReceived (UInt64) — The number of callbacks requested from the remote server back to the initiator server to choose the read task (for s3Cluster table function and similar). Measured on the initiator server side.
ProfileEvent_MergeTreeReadTaskRequestsReceived (UInt64) — The number of callbacks requested from the remote server back to the initiator server to choose the read task (for MergeTree tables). Measured on the initiator server side.
ProfileEvent_ReadTaskRequestsSent (UInt64) — The number of callbacks requested from the remote server back to the initiator server to choose the read task (for s3Cluster table function and similar). Measured on the remote server side.
ProfileEvent_MergeTreeReadTaskRequestsSent (UInt64) — The number of callbacks requested from the remote server back to the initiator server to choose the read task (for MergeTree tables). Measured on the remote server side.
ProfileEvent_MergeTreeAllRangesAnnouncementsSent (UInt64) — The number of announcements sent from the remote server to the initiator server about the set of data parts (for MergeTree tables). Measured on the remote server side.
ProfileEvent_ReadTaskRequestsSentElapsedMicroseconds (UInt64) — Time spent in callbacks requested from the remote server back to the initiator server to choose the read task (for s3Cluster table function and similar). Measured on the remote server side.
ProfileEvent_MergeTreeReadTaskRequestsSentElapsedMicroseconds (UInt64) — Time spent in callbacks requested from the remote server back to the initiator server to choose the read task (for MergeTree tables). Measured on the remote server side.
ProfileEvent_MergeTreeAllRangesAnnouncementsSentElapsedMicroseconds (UInt64) — Time spent in sending the announcement from the remote server to the initiator server about the set of data parts (for MergeTree tables). Measured on the remote server side.
ProfileEvent_MergerMutatorsGetPartsForMergeElapsedMicroseconds (UInt64) — Time spent to take data parts snapshot to build ranges from them.
ProfileEvent_MergerMutatorPrepareRangesForMergeElapsedMicroseconds (UInt64) — Time spent to prepare parts ranges which can be merged according to merge predicate.
ProfileEvent_MergerMutatorSelectPartsForMergeElapsedMicroseconds (UInt64) — Time spent to select parts from ranges which can be merged.
ProfileEvent_MergerMutatorRangesForMergeCount (UInt64) — Amount of candidate ranges for merge
ProfileEvent_MergerMutatorPartsInRangesForMergeCount (UInt64) — Amount of candidate parts for merge
ProfileEvent_MergerMutatorSelectRangePartsCount (UInt64) — Amount of parts in selected range for merge
ProfileEvent_ConnectionPoolIsFullMicroseconds (UInt64) — Total time spent waiting for a slot in connection pool.
ProfileEvent_AsyncLoaderWaitMicroseconds (UInt64) — Total time a query was waiting for async loader jobs.
ProfileEvent_DistrCacheServerSwitches (UInt64) — Distributed Cache read buffer event. Number of server switches between distributed cache servers in read/write-through cache
ProfileEvent_DistrCacheReadMicroseconds (UInt64) — Distributed Cache read buffer event. Time spent reading from distributed cache
ProfileEvent_DistrCacheFallbackReadMicroseconds (UInt64) — Distributed Cache read buffer event. Time spend reading from fallback buffer instead of distributed cache
ProfileEvent_DistrCachePrecomputeRangesMicroseconds (UInt64) — Distributed Cache read buffer event. Time spent to precompute read ranges
ProfileEvent_DistrCacheNextImplMicroseconds (UInt64) — Distributed Cache read buffer event. Time spend in ReadBufferFromDistributedCache::nextImpl
ProfileEvent_DistrCacheStartRangeMicroseconds (UInt64) — Distributed Cache read buffer event. Time spent to start a new read range with distributed cache
ProfileEvent_DistrCacheRangeChange (UInt64) — Distributed Cache read buffer event. Number of times we changed read range because of seek/last_position change
ProfileEvent_DistrCacheRangeResetBackward (UInt64) — Distributed Cache read buffer event. Number of times we reset read range because of seek/last_position change
ProfileEvent_DistrCacheRangeResetForward (UInt64) — Distributed Cache read buffer event. Number of times we reset read range because of seek/last_position change
ProfileEvent_DistrCacheReconnectsAfterTimeout (UInt64) — Distributed Cache read buffer event. The number of reconnects after timeout
ProfileEvent_DistrCacheServerUpdates (UInt64) — Distributed Cache event. The number of server switches during read or write because the hash-chosen server changed (e.g. due to server deregistration)
ProfileEvent_DistrCacheReadErrors (UInt64) — Distributed Cache read buffer event. Number of distributed cache errors during read
ProfileEvent_DistrCacheWriteErrors (UInt64) — Distributed Cache write buffer event. Number of distributed cache errors during write
ProfileEvent_DistrCacheWriteReconnectsAfterTimeout (UInt64) — Distributed Cache write buffer event. The number of reconnects after timeout
ProfileEvent_DistrCacheWriteMicroseconds (UInt64) — Distributed Cache write buffer event. Time spent in WriteBufferFromDistributedCache::writeToFileSegment
ProfileEvent_DistrCacheWriteBytes (UInt64) — Distributed Cache write buffer event. Number of bytes written to distributed cache
ProfileEvent_DistrCacheObjectStorageWriteMicroseconds (UInt64) — Distributed Cache write buffer event. Time spent writing to object storage
ProfileEvent_DistrCacheObjectStorageWriteBytes (UInt64) — Distributed Cache write buffer event. Number of bytes written to object storage
ProfileEvent_DistrCacheGetResponseMicroseconds (UInt64) — Distributed Cache client event. Time spend to wait for response from distributed cache
ProfileEvent_DistrCacheMakeRequestErrors (UInt64) — Distributed Cache client event. Number of distributed cache errors when making a request
ProfileEvent_DistrCacheReceiveResponseErrors (UInt64) — Distributed Cache client event. Number of distributed cache errors when receiving response a request
ProfileEvent_DistrCacheReceivedDataPackets (UInt64) — Distributed Cache client event. Total number of received data packets received from distributed cache
ProfileEvent_DistrCacheReceivedDataPacketsBytes (UInt64) — Distributed Cache client event. The number of bytes in Data packets received from distributed cache
ProfileEvent_DistrCacheReceivedOkPackets (UInt64) — Distributed Cache client event. Total number of received Ok packets received from distributed cache
ProfileEvent_DistrCacheReceivedErrorPackets (UInt64) — Distributed Cache client event. Total number of received Error packets received from distributed cache
ProfileEvent_DistrCacheReceivedCredentialsRefreshPackets (UInt64) — Distributed Cache client event. Total number of received RefreshCredentials packets received from distributed cache
ProfileEvent_DistrCacheReceivedStopPackets (UInt64) — Distributed Cache client event. Total number of received Stop packets received from distributed cache
ProfileEvent_DistrCacheSentDataPackets (UInt64) — Distributed Cache client event. Total number of data packets sent to distributed cache
ProfileEvent_DistrCacheSentDataPacketsBytes (UInt64) — Distributed Cache client event. The number of bytes in Data packets sent to distributed cache
ProfileEvent_DistrCacheUnusedPackets (UInt64) — Distributed Cache client event. Number of skipped unused packets from distributed cache
ProfileEvent_DistrCacheUnusedDataPacketsBytes (UInt64) — Distributed Cache client event. The number of bytes in Data packets which were ignored
ProfileEvent_DistrCacheUnusedPacketsBufferAllocations (UInt64) — Distributed Cache client event. The number of extra buffer allocations in case we could not reuse existing buffer
ProfileEvent_DistrCacheLockRegistryMicroseconds (UInt64) — Distributed Cache registry event. Time spent to take DistributedCacheRegistry lock
ProfileEvent_DistrCacheRegistryUpdateMicroseconds (UInt64) — Distributed Cache registry event. Time spent updating distributed cache registry
ProfileEvent_DistrCacheRegistryUpdates (UInt64) — Distributed Cache registry event. Number of distributed cache registry updates
ProfileEvent_DistrCacheHashRingRebuilds (UInt64) — Distributed Cache registry event. Number of distributed cache hash ring rebuilds
ProfileEvent_DistrCacheSuccessfulRegistryUpdates (UInt64) — Distributed Cache registry event. The number of successful server registry updates
ProfileEvent_DistrCacheUnsuccessfulRegistryUpdates (UInt64) — Distributed Cache registry event. The number of unsuccessful server registry updates
ProfileEvent_DistrCacheReadBytesFromFallbackBuffer (UInt64) — Distributed Cache read buffer event. Bytes read from fallback buffer
ProfileEvent_DistrCacheOpenedConnections (UInt64) — Distributed Cache connection event. The number of open connections to distributed cache
ProfileEvent_DistrCacheReusedConnections (UInt64) — Distributed Cache connection event. The number of reused connections to distributed cache
ProfileEvent_DistrCacheStaleReconnections (UInt64) — Distributed Cache connection event. The number of reconnections due to stale (peer-closed) pooled connections
ProfileEvent_DistrCacheRemoveOutdatedMicroseconds (UInt64) — Distributed Cache connection event. The time spent removing outdated connections from the pool
ProfileEvent_DistrCacheOpenedConnectionsBypassingPool (UInt64) — Distributed Cache connection event. The number of open connections to distributed cache bypassing pool
ProfileEvent_DistrCacheConnectMicroseconds (UInt64) — Distributed Cache connection event. The time spent to connect to distributed cache
ProfileEvent_DistrCacheConnectAttempts (UInt64) — Distributed Cache connection event. The number of connection attempts to distributed cache
ProfileEvent_DistrCacheSuccessfulConnectAttempts (UInt64) — Distributed Cache connection event. The number of successful connection attempts to distributed cache
ProfileEvent_DistrCacheUnsuccessfulConnectAttempts (UInt64) — Distributed Cache connection event. The number of unsuccessful connection attempts to distributed cache
ProfileEvent_DistrCacheGetClientMicroseconds (UInt64) — Distributed Cache connection event. Time spent getting client for distributed cache
ProfileEvent_DistrCacheTemporaryFilesCreated (UInt64) — Distributed Cache connection event. Number of temporary files created in distributed cache
ProfileEvent_DistrCacheTemporaryFilesBytesWritten (UInt64) — Distributed Cache connection event. Number of bytes written to temporary files created in distributed cache
ProfileEvent_DistrCacheServerProcessRequestMicroseconds (UInt64) — Distributed Cache server event. Time spent processing request on DistributedCache server side
ProfileEvent_DistrCacheServerStartRequestPackets (UInt64) — Distributed Cache server event. Number of StartRequest packets in DistributedCacheServer
ProfileEvent_DistrCacheServerContinueRequestPackets (UInt64) — Distributed Cache server event. Number of ContinueRequest packets in DistributedCacheServer
ProfileEvent_DistrCacheServerEndRequestPackets (UInt64) — Distributed Cache server event. Number of EndRequest packets in DistributedCacheServer
ProfileEvent_DistrCacheServerReceivedCredentialsRefreshPackets (UInt64) — Distributed Cache server event. Number of RefreshCredentials client packets in DistributedCacheServer
ProfileEvent_DistrCacheServerAckRequestPackets (UInt64) — Distributed Cache server event. Number of AckRequest packets in DistributedCacheServer
ProfileEvent_DistrCacheServerNewS3CachedClients (UInt64) — Distributed Cache server event. The number of new cached s3 clients
ProfileEvent_DistrCacheServerReusedS3CachedClients (UInt64) — Distributed Cache server event. The number of reused cached s3 clients
ProfileEvent_DistrCacheServerCredentialsRefresh (UInt64) — Distributed Cache server event. The number of expired credentials were refreshed
ProfileEvent_DistrCacheServerCachedReadBufferCacheHits (UInt64) — Distributed Cache server event. The number of times distributed cache hit the cache while reading from filesystem cache
ProfileEvent_DistrCacheServerCachedReadBufferCacheMisses (UInt64) — Distributed Cache server event. The number of times distributed cache missed the cache while reading from filesystem cache
ProfileEvent_DistrCacheServerCachedReadBufferCacheWrittenBytes (UInt64) — Distributed Cache server event. The number of bytes written to cache in distributed cache while reading from filesystem cache
ProfileEvent_DistrCacheServerCachedReadBufferCacheReadBytes (UInt64) — Distributed Cache server event. The number of bytes read from cache in distributed cache while reading from filesystem cache
ProfileEvent_DistrCacheServerCachedReadBufferObjectStorageReadBytes (UInt64) — Distributed Cache server event. The number of bytes read from object storage in distributed cache while reading from filesystem cache
ProfileEvent_DistrCacheServerCachedReadBufferCachePredownloadBytes (UInt64) — Distributed Cache server event. The number of bytes read from object storage for predownload in distributed cache while reading from filesystem cache
ProfileEvent_DistrCacheServerSkipped (UInt64) — Distributed Cache server event. The number of times distributed cache server was skipped because of previous failed connection attempts
ProfileEvent_LogTest (UInt64) — Number of log messages with level Test
ProfileEvent_LogTrace (UInt64) — Number of log messages with level Trace
ProfileEvent_LogDebug (UInt64) — Number of log messages with level Debug
ProfileEvent_LogInfo (UInt64) — Number of log messages with level Info
ProfileEvent_LogWarning (UInt64) — Number of log messages with level Warning
ProfileEvent_LogError (UInt64) — Number of log messages with level Error
ProfileEvent_LogFatal (UInt64) — Number of log messages with level Fatal
ProfileEvent_LoggerElapsedNanoseconds (UInt64) — Cumulative time spend in logging
ProfileEvent_InterfaceHTTPSendBytes (UInt64) — Number of bytes sent through HTTP interfaces
ProfileEvent_InterfaceHTTPReceiveBytes (UInt64) — Number of bytes received through HTTP interfaces
ProfileEvent_InterfaceNativeSendBytes (UInt64) — Number of bytes sent through native interfaces
ProfileEvent_InterfaceNativeReceiveBytes (UInt64) — Number of bytes received through native interfaces
ProfileEvent_InterfacePrometheusSendBytes (UInt64) — Number of bytes sent through Prometheus interfaces
ProfileEvent_InterfacePrometheusReceiveBytes (UInt64) — Number of bytes received through Prometheus interfaces
ProfileEvent_InterfaceInterserverSendBytes (UInt64) — Number of bytes sent through interserver interfaces
ProfileEvent_InterfaceInterserverReceiveBytes (UInt64) — Number of bytes received through interserver interfaces
ProfileEvent_InterfaceMySQLSendBytes (UInt64) — Number of bytes sent through MySQL interfaces
ProfileEvent_InterfaceMySQLReceiveBytes (UInt64) — Number of bytes received through MySQL interfaces
ProfileEvent_InterfacePostgreSQLSendBytes (UInt64) — Number of bytes sent through PostgreSQL interfaces
ProfileEvent_InterfacePostgreSQLReceiveBytes (UInt64) — Number of bytes received through PostgreSQL interfaces
ProfileEvent_ParallelReplicasUsedCount (UInt64) — Number of replicas used to execute a query with task-based parallel replicas
ProfileEvent_ParallelReplicasAvailableCount (UInt64) — Number of replicas available to execute a query with task-based parallel replicas
ProfileEvent_ParallelReplicasUnavailableCount (UInt64) — Number of replicas which was chosen, but found to be unavailable during query execution with task-based parallel replicas
ProfileEvent_SharedMergeTreeVirtualPartsUpdates (UInt64) — Virtual parts update count
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesByLeader (UInt64) — Virtual parts updates by leader
ProfileEvent_SharedMergeTreeVirtualPartsUpdateMicroseconds (UInt64) — Virtual parts update microseconds
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesFromZooKeeper (UInt64) — Virtual parts updates count from ZooKeeper
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesFromZooKeeperMicroseconds (UInt64) — Virtual parts updates from ZooKeeper microseconds
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesPeerNotFound (UInt64) — Virtual updates from peer failed because no one found
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesFromPeer (UInt64) — Virtual parts updates count from peer
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesFromPeerMicroseconds (UInt64) — Virtual parts updates from peer microseconds
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesForMergesOrStatus (UInt64) — Virtual parts updates from non-default background job
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesLeaderFailedElection (UInt64) — Virtual parts updates leader election failed
ProfileEvent_SharedMergeTreeVirtualPartsUpdatesLeaderSuccessfulElection (UInt64) — Virtual parts updates leader election successful
ProfileEvent_SharedMergeTreeMergeMutationAssignmentAttempt (UInt64) — How many times we tried to assign merge or mutation
ProfileEvent_SharedMergeTreeMergeMutationAssignmentFailedWithNothingToDo (UInt64) — How many times we tried to assign merge or mutation and failed because nothing to merge
ProfileEvent_SharedMergeTreeMergeMutationAssignmentFailedWithConflict (UInt64) — How many times we tried to assign merge or mutation and failed because of conflict in Keeper
ProfileEvent_SharedMergeTreeMergeMutationAssignmentSuccessful (UInt64) — How many times we tried to assign merge or mutation
ProfileEvent_SharedMergeTreeMergePartsMovedToOudated (UInt64) — How many parts moved to outdated directory
ProfileEvent_SharedMergeTreeMergePartsMovedToCondemned (UInt64) — How many parts moved to condemned directory
ProfileEvent_SharedMergeTreeOutdatedPartsConfirmationRequest (UInt64) — How many ZooKeeper requests were used to config outdated parts
ProfileEvent_SharedMergeTreeOutdatedPartsConfirmationInvocations (UInt64) — How many invocations were made to confirm outdated parts
ProfileEvent_SharedMergeTreeOutdatedPartsHTTPRequest (UInt64) — How many HTTP requests were send to confirm outdated parts
ProfileEvent_SharedMergeTreeOutdatedPartsHTTPResponse (UInt64) — How many HTTP responses were send to confirm outdated parts
ProfileEvent_SharedMergeTreeCondemnedPartsKillRequest (UInt64) — How many ZooKeeper requests were used to remove condemned parts
ProfileEvent_SharedMergeTreeCondemnedPartsLockConflict (UInt64) — How many times we failed to acquire lock because of conflict
ProfileEvent_SharedMergeTreeCondemnedPartsRemoved (UInt64) — How many condemned parts were removed
ProfileEvent_SharedMergeTreePartsKillerRuns (UInt64) — How many times parts killer has been running
ProfileEvent_SharedMergeTreePartsKillerMicroseconds (UInt64) — How much time does parts killer main thread takes
ProfileEvent_SharedMergeTreePartsKillerParts (UInt64) — How many parts has been scheduled by the killer
ProfileEvent_SharedMergeTreePartsKillerPartsMicroseconds (UInt64) — How many time does it take to remove parts (executed from multiple threads)
ProfileEvent_SharedMergeTreeMergeSelectingTaskMicroseconds (UInt64) — Merge selecting task microseconds for SMT
ProfileEvent_SharedMergeTreeReplicaSetUpdateTaskRuns (UInt64) — Number of times updateReplicaSetTask has run
ProfileEvent_SharedMergeTreeOptimizeAsync (UInt64) — Asynchronous OPTIMIZE queries executed
ProfileEvent_SharedMergeTreeOptimizeSync (UInt64) — Synchronous OPTIMIZE queries executed
ProfileEvent_SharedMergeTreeScheduleDataProcessingJob (UInt64) — How many times scheduleDataProcessingJob called/
ProfileEvent_SharedMergeTreeScheduleDataProcessingJobNothingToScheduled (UInt64) — How many times scheduleDataProcessingJob called but nothing to do
ProfileEvent_SharedMergeTreeScheduleDataProcessingJobMicroseconds (UInt64) — scheduleDataProcessingJob execute time
ProfileEvent_SharedMergeTreeHandleBlockingParts (UInt64) — How many blocking parts to handle in scheduleDataProcessingJob
ProfileEvent_SharedMergeTreeHandleBlockingPartsMicroseconds (UInt64) — Time of handling blocking parts in scheduleDataProcessingJob
ProfileEvent_SharedMergeTreeHandleFetchPartsMicroseconds (UInt64) — Time of handling fetched parts in scheduleDataProcessingJob
ProfileEvent_SharedMergeTreeHandleOutdatedParts (UInt64) — How many outdated parts to handle in scheduleDataProcessingJob
ProfileEvent_SharedMergeTreeHandleOutdatedPartsMicroseconds (UInt64) — Time of handling outdated parts in scheduleDataProcessingJob
ProfileEvent_SharedMergeTreeSelectPartsForRendezvousFetchMicroseconds (UInt64) — Time of selectPartsForRendezvousFetch
ProfileEvent_SharedMergeTreeSelectPartsForRendezvousFetchParts (UInt64) — Number of parts selected by selectPartsForRendezvousFetch
ProfileEvent_SharedMergeTreeSelectPartsForCoordinatedFetchMicroseconds (UInt64) — Time of selectPartsForCoordinatedFetch
ProfileEvent_SharedMergeTreeSelectPartsForCoordinatedFetchParts (UInt64) — Number of parts selected by selectPartsForCoordinatedFetch
ProfileEvent_SharedMergeTreeSelectPartsForFullFetchMicroseconds (UInt64) — Time of selectPartsForFullFetch
ProfileEvent_SharedMergeTreeSelectPartsForFullFetchParts (UInt64) — Number of parts selected by selectPartsForFullFetch
ProfileEvent_SharedMergeTreeTryUpdateDiskMetadataCacheForPartMicroseconds (UInt64) — Time of tryUpdateDiskMetadataCacheForPart in scheduleDataProcessingJob
ProfileEvent_SharedMergeTreeLoadChecksumAndIndexesMicroseconds (UInt64) — Time of loadColumnsChecksumsIndexes only for SharedMergeTree
ProfileEvent_SharedMergeTreeSnapshotPartsCleanRequest (UInt64) — How many times SnapshotCleanerThread decides to clean a part
ProfileEvent_SharedMergeTreeSnapshotPartsCleanerParts (UInt64) — How long time SnapshotCleanerThread tries to clean a part
ProfileEvent_SharedMergeTreeSnapshotPartsRemoved (UInt64) — How many times SnapshotCleanerThread successfully clean a part
ProfileEvent_SharedMergeTreeSnapshotPartsCleanerRuns (UInt64) — How many times SnapshotCleanerThread runs
ProfileEvent_SharedMergeTreeSnapshotPartsCleanerMicroseconds (UInt64) — How long time SnapshotCleanerThread has run
ProfileEvent_SharedMergeTreeSnapshotPartsCleanerPartsMicroseconds (UInt64) — How long time SnapshotCleanerThread takes to clean parts
ProfileEvent_SharedMergeTreeDataPartsFetchAttempt (UInt64) — How many times we tried to fetch data parts
ProfileEvent_SharedMergeTreeDataPartsFetchFromPeer (UInt64) — How many times we fetch data parts from peer
ProfileEvent_SharedMergeTreeDataPartsFetchFromPeerMicroseconds (UInt64) — Data parts fetch from peer microseconds
ProfileEvent_SharedMergeTreeDataPartsFetchFromS3 (UInt64) — How many times we fetch data parts from S3
ProfileEvent_SharedMergeTreeReplicaSetUpdatesFromZooKeeper (UInt64) — How many times we have update replica set from ZooKeeper
ProfileEvent_SharedMergeTreeReplicaSetUpdatesFromZooKeeperRequests (UInt64) — How many total ZooKeeper requests we made to update replica set
ProfileEvent_SharedMergeTreeReplicaSetUpdatesFromZooKeeperMicroseconds (UInt64) — How much time we spend to update replica set
ProfileEvent_KeeperLogsEntryReadFromLatestCache (UInt64) — Number of log entries in Keeper being read from latest logs cache
ProfileEvent_KeeperLogsEntryReadFromCommitCache (UInt64) — Number of log entries in Keeper being read from commit logs cache
ProfileEvent_KeeperLogsEntryReadFromFile (UInt64) — Number of log entries in Keeper being read directly from the changelog file
ProfileEvent_KeeperLogsPrefetchedEntries (UInt64) — Number of log entries in Keeper being prefetched from the changelog file
ProfileEvent_KeeperChangelogWrittenBytes (UInt64) — Number of bytes written to the changelog in Keeper
ProfileEvent_KeeperChangelogFileSyncMicroseconds (UInt64) — Time spent in fsync for Keeper changelog (uncompressed logs only)
ProfileEvent_KeeperSnapshotWrittenBytes (UInt64) — Number of bytes written to snapshot files in Keeper
ProfileEvent_KeeperSnapshotFileSyncMicroseconds (UInt64) — Time spent in fsync for Keeper snapshot files
ProfileEvent_StorageConnectionsCreated (UInt64) — Number of created connections for storages
ProfileEvent_StorageConnectionsReused (UInt64) — Number of reused connections for storages
ProfileEvent_StorageConnectionsReset (UInt64) — Number of reset connections for storages
ProfileEvent_StorageConnectionsPreserved (UInt64) — Number of preserved connections for storages
ProfileEvent_StorageConnectionsExpired (UInt64) — Number of expired connections for storages
ProfileEvent_StorageConnectionsErrors (UInt64) — Number of cases when creation of a connection for storage is failed
ProfileEvent_StorageConnectionsElapsedMicroseconds (UInt64) — Total time spend on creating connections for storages
ProfileEvent_DiskConnectionsCreated (UInt64) — Number of created connections for disk
ProfileEvent_DiskConnectionsReused (UInt64) — Number of reused connections for disk
ProfileEvent_DiskConnectionsReset (UInt64) — Number of reset connections for disk
ProfileEvent_DiskConnectionsPreserved (UInt64) — Number of preserved connections for disk
ProfileEvent_DiskConnectionsExpired (UInt64) — Number of expired connections for disk
ProfileEvent_DiskConnectionsErrors (UInt64) — Number of cases when creation of a connection for disk is failed
ProfileEvent_DiskConnectionsElapsedMicroseconds (UInt64) — Total time spend on creating connections for disk
ProfileEvent_HTTPConnectionsCreated (UInt64) — Number of created client HTTP connections
ProfileEvent_HTTPConnectionsReused (UInt64) — Number of reused client HTTP connections
ProfileEvent_HTTPConnectionsReset (UInt64) — Number of reset client HTTP connections
ProfileEvent_HTTPConnectionsPreserved (UInt64) — Number of preserved client HTTP connections
ProfileEvent_HTTPConnectionsExpired (UInt64) — Number of expired client HTTP connections
ProfileEvent_HTTPConnectionsErrors (UInt64) — Number of cases when creation of a client HTTP connection failed
ProfileEvent_HTTPConnectionsElapsedMicroseconds (UInt64) — Total time spend on creating client HTTP connections
ProfileEvent_HTTPServerConnectionsCreated (UInt64) — Number of created server HTTP connections
ProfileEvent_HTTPServerConnectionsReused (UInt64) — Number of reused server HTTP connections
ProfileEvent_HTTPServerConnectionsPreserved (UInt64) — Number of preserved server HTTP connections. Connection kept alive successfully
ProfileEvent_HTTPServerConnectionsExpired (UInt64) — Number of expired server HTTP connections.
ProfileEvent_HTTPServerConnectionsClosed (UInt64) — Number of closed server HTTP connections. Keep alive has not been negotiated
ProfileEvent_HTTPServerConnectionsReset (UInt64) — Number of reset server HTTP connections. Server closes connection
ProfileEvent_AddressesDiscovered (UInt64) — Total count of new addresses in DNS resolve results for HTTP connections
ProfileEvent_AddressesExpired (UInt64) — Total count of expired addresses which is no longer presented in DNS resolve results for HTTP connections
ProfileEvent_AddressesMarkedAsFailed (UInt64) — Total count of addresses which have been marked as faulty due to connection errors for HTTP connections
ProfileEvent_ReadWriteBufferFromHTTPRequestsSent (UInt64) — Number of HTTP requests sent by ReadWriteBufferFromHTTP
ProfileEvent_ReadWriteBufferFromHTTPBytes (UInt64) — Total size of payload bytes received and sent by ReadWriteBufferFromHTTP. Doesn't include HTTP headers.
ProfileEvent_WriteBufferFromHTTPRequestsSent (UInt64) — Number of HTTP requests sent by WriteBufferFromHTTP
ProfileEvent_WriteBufferFromHTTPBytes (UInt64) — Total size of payload bytes received and sent by WriteBufferFromHTTP. Doesn't include HTTP headers.
ProfileEvent_ConcurrencyControlSlotsGranted (UInt64) — Number of CPU slot granted according to guarantee of 1 thread per query and for queries with setting 'use_concurrency_control' = 0
ProfileEvent_ConcurrencyControlSlotsDelayed (UInt64) — Number of CPU slot not granted initially and required to wait for a free CPU slot
ProfileEvent_ConcurrencyControlSlotsAcquired (UInt64) — Total number of CPU slots acquired
ProfileEvent_ConcurrencyControlSlotsAcquiredNonCompeting (UInt64) — Total number of noncompeting CPU slot acquired
ProfileEvent_ConcurrencyControlQueriesDelayed (UInt64) — Total number of CPU slot allocations (queries) that were required to wait for slots to upscale
ProfileEvent_ConcurrencyControlWaitMicroseconds (UInt64) — Total time a query was waiting on resource requests for CPU slots.
ProfileEvent_ConcurrencyControlPreemptedMicroseconds (UInt64) — Total time a query was waiting due to preemption of CPU slots.
ProfileEvent_ConcurrencyControlPreemptions (UInt64) — Total number of CPU preemptions
ProfileEvent_ConcurrencyControlUpscales (UInt64) — Total number of CPU upscaling events
ProfileEvent_ConcurrencyControlDownscales (UInt64) — Total number of CPU downscaling events
ProfileEvent_ConcurrentQuerySlotsAcquired (UInt64) — Total number of query slots acquired
ProfileEvent_ConcurrentQueryWaitMicroseconds (UInt64) — Total time a query was waiting for a query slots
ProfileEvent_CoordinatedMergesMergeCoordinatorUpdateCount (UInt64) — Total number of merge coordinator updates
ProfileEvent_CoordinatedMergesMergeCoordinatorUpdateMicroseconds (UInt64) — Total time spend on updating merge coordinator state
ProfileEvent_CoordinatedMergesMergeCoordinatorFetchMetadataMicroseconds (UInt64) — Total time spend on fetching fresh metadata inside merge coordinator
ProfileEvent_CoordinatedMergesMergeCoordinatorFilterMicroseconds (UInt64) — Total time spend on filtering prepared merges inside merge coordinator
ProfileEvent_CoordinatedMergesMergeCoordinatorSelectMergesMicroseconds (UInt64) — Total time spend on finding merge using merge selectors inside merge coordinator
ProfileEvent_CoordinatedMergesMergeCoordinatorLockStateForShareCount (UInt64) — Total number of for share captures of coordinator state lock
ProfileEvent_CoordinatedMergesMergeCoordinatorLockStateExclusivelyCount (UInt64) — Total number of exclusive captures of coordinator state lock
ProfileEvent_CoordinatedMergesMergeCoordinatorLockStateForShareMicroseconds (UInt64) — Total time spend on locking coordinator state mutex for share
ProfileEvent_CoordinatedMergesMergeCoordinatorLockStateExclusivelyMicroseconds (UInt64) — Total time spend on locking coordinator state mutex exclusively
ProfileEvent_CoordinatedMergesMergeWorkerUpdateCount (UInt64) — Total number merge worker updates
ProfileEvent_CoordinatedMergesMergeWorkerUpdateMicroseconds (UInt64) — Total time spend on updating local state of assigned merges on worker
ProfileEvent_CoordinatedMergesMergeAssignmentRequest (UInt64) — Total number of merge assignment requests
ProfileEvent_CoordinatedMergesMergeAssignmentResponse (UInt64) — Total number of merge assignment requests
ProfileEvent_CoordinatedMergesMergeAssignmentRequestMicroseconds (UInt64) — Total time spend in merge assignment client
ProfileEvent_CoordinatedMergesMergeAssignmentResponseMicroseconds (UInt64) — Total time spend in merge assignment handler
ProfileEvent_SharedDatabaseCatalogFailedToApplyState (UInt64) — Number of failures to apply new state in SharedDatabaseCatalog
ProfileEvent_SharedDatabaseCatalogStateApplicationMicroseconds (UInt64) — Total time spend on application of new state in SharedDatabaseCatalog
ProfileEvent_MemoryWorkerRun (UInt64) — Number of runs done by MemoryWorker in background
ProfileEvent_MemoryWorkerRunElapsedMicroseconds (UInt64) — Total time spent by MemoryWorker for background work
ProfileEvent_ParquetFetchWaitTimeMicroseconds (UInt64) — Time of waiting for parquet file reads from decoding threads (not prefetching threads)
ProfileEvent_WasmSerializationMicroseconds (UInt64) — Time spent executing WebAssembly code
ProfileEvent_WasmDeserializationMicroseconds (UInt64) — Time spent executing WebAssembly code
ProfileEvent_WasmGuestExecuteMicroseconds (UInt64) — Time spent executing WebAssembly code
ProfileEvent_WasmTotalExecuteMicroseconds (UInt64) — Time spent executing WebAssembly code
ProfileEvent_WasmModuleInstatiate (UInt64) — Number of WebAssembly compartments created
ProfileEvent_WasmMemoryAllocated (UInt64) — Total memory allocated for WebAssembly compartments
ProfileEvent_ParquetReadRowGroups (UInt64) — The total number of row groups read from parquet data
ProfileEvent_ParquetPrunedRowGroups (UInt64) — The total number of row groups pruned from parquet data
ProfileEvent_ParquetDecodingTasks (UInt64) — Tasks issued by parquet reader
ProfileEvent_ParquetDecodingTaskBatches (UInt64) — Task groups sent to a thread pool by parquet reader
ProfileEvent_ParquetPrefetcherReadRandomRead (UInt64) — The total number of reads with ReadMode::RandomRead by DB::Parquet::Prefetcher
ProfileEvent_ParquetPrefetcherReadSeekAndRead (UInt64) — The total number of reads with ReadMode::SeekAndRead by DB::Parquet::Prefetcher
ProfileEvent_ParquetPrefetcherReadEntireFile (UInt64) — The total number of read with ReadMode::EntireFileIsInMemory by DB::Parquet::Prefetcher
ProfileEvent_ParquetRowsFilterExpression (UInt64) — The total number of rows that were passed through filter
ProfileEvent_ParquetColumnsFilterExpression (UInt64) — The total number of columns that were passed through filter
ProfileEvent_FilterTransformPassedRows (UInt64) — Number of rows that passed the filter in the query
ProfileEvent_FilterTransformPassedBytes (UInt64) — Number of bytes that passed the filter in the query
ProfileEvent_QueryPreempted (UInt64) — How many times tasks are paused and waiting due to 'priority' setting
ProfileEvent_IndexBinarySearchAlgorithm (UInt64) — Number of times the binary search algorithm is used over the index marks
ProfileEvent_IndexGenericExclusionSearchAlgorithm (UInt64) — Number of times the generic exclusion search algorithm is used over the index marks
ProfileEvent_ParallelReplicasQueryCount (UInt64) — Number of (sub)queries executed using parallel replicas during a query execution
ProfileEvent_DistributedConnectionReconnectCount (UInt64) — Number of reconnects to other servers done during distributed query execution. It can happen when a stale connection has been acquired from connection pool
ProfileEvent_DistributedConnectionConnectCount (UInt64) — Number of connects to other servers done during distributed query execution. Happens when new connection is established instead of using existing from pool.
ProfileEvent_RefreshableViewRefreshSuccess (UInt64) — How many times refreshable materialized views refreshed
ProfileEvent_RefreshableViewRefreshFailed (UInt64) — How many times refreshable materialized views failed to refresh
ProfileEvent_RefreshableViewSyncReplicaSuccess (UInt64) — How many times a SELECT from refreshable materialized view did an implicit SYNC REPLICA
ProfileEvent_RefreshableViewSyncReplicaRetry (UInt64) — How many times a SELECT from refreshable materialized view failed and retried an implicit SYNC REPLICA
ProfileEvent_RefreshableViewLockTableRetry (UInt64) — How many times a SELECT from refreshable materialized view had to switch to a new table because the old table was dropped
ProfileEvent_AsyncLoggingConsoleTotalMessages (UInt64) — How many messages (accepted or dropped) have been sent to the async queue for the console log
ProfileEvent_AsyncLoggingFileLogTotalMessages (UInt64) — How many messages (accepted or dropped) have been sent to the async queue for the file log
ProfileEvent_AsyncLoggingErrorFileLogTotalMessages (UInt64) — How many messages (accepted or dropped) have been sent to the async queue for the error file log
ProfileEvent_AsyncLoggingSyslogTotalMessages (UInt64) — How many messages (accepted or dropped) have been sent to the async queue for the syslog
ProfileEvent_AsyncLoggingTextLogTotalMessages (UInt64) — How many messages (accepted or dropped) have been sent to the async queue for the text_log
ProfileEvent_AsyncLoggingConsoleDroppedMessages (UInt64) — How many messages have been dropped from the console log due to the async log queue being full
ProfileEvent_AsyncLoggingFileLogDroppedMessages (UInt64) — How many messages have been dropped from the file log due to the async log queue being full
ProfileEvent_AsyncLoggingErrorFileLogDroppedMessages (UInt64) — How many messages have been dropped from error file log due to the async log queue being full
ProfileEvent_AsyncLoggingSyslogDroppedMessages (UInt64) — How many messages have been dropped from the syslog due to the async log queue being full
ProfileEvent_AsyncLoggingTextLogDroppedMessages (UInt64) — How many messages have been dropped from text_log due to the async log queue being full
ProfileEvent_JemallocFailedAllocationSampleTracking (UInt64) — Total number of times tracking of jemalloc allocation sample failed
ProfileEvent_JemallocFailedDeallocationSampleTracking (UInt64) — Total number of times tracking of jemalloc deallocation sample failed
ProfileEvent_LoadedStatisticsMicroseconds (UInt64) — Elapsed time of loading statistics from parts
ProfileEvent_RuntimeDataflowStatisticsInputBytes (UInt64) — Collected statistics on the number of bytes replicas would read if the query was executed with parallel replicas
ProfileEvent_RuntimeDataflowStatisticsOutputBytes (UInt64) — Collected statistics on the number of bytes replicas would send to the initiator if the query was executed with parallel replicas
ProfileEvent_S3CachedCredentialsProvidersReused (UInt64) — Total number of reused credentials provider from the cache
ProfileEvent_S3CachedCredentialsProvidersAdded (UInt64) — Total number of newly added credentials providers to the cache
ProfileEvent_RuntimeFiltersCreated (UInt64) — Number of distinct JOIN Runtime Filters created within a query
ProfileEvent_RuntimeFilterBlocksProcessed (UInt64) — Number of blocks processed by JOIN Runtime Filters
ProfileEvent_RuntimeFilterBlocksSkipped (UInt64) — Number of blocks skipped by JOIN Runtime Filters without processing due to filter being dynamically disabled because of poor filtering ratio
ProfileEvent_RuntimeFilterRowsChecked (UInt64) — Number of rows checked by JOIN Runtime Filters
ProfileEvent_RuntimeFilterRowsPassed (UInt64) — Number of rows that passed (not filtered out by) JOIN Runtime Filters
ProfileEvent_RuntimeFilterRowsSkipped (UInt64) — Number of rows in blocks that were skipped by JOIN Runtime Filters
ProfileEvent_JoinBuildPostProcessingMicroseconds (UInt64) — Elapsed time of post-processing steps after building the right JOIN side.
ProfileEvent_AIInputTokens (UInt64) — Total prompt tokens consumed across all AI function calls in the query.
ProfileEvent_AIOutputTokens (UInt64) — Total completion tokens consumed across all AI function calls in the query.
ProfileEvent_AIAPICalls (UInt64) — Number of HTTP requests dispatched to AI providers.
ProfileEvent_AIRowsProcessed (UInt64) — Number of rows that received an AI result.
ProfileEvent_AIRowsSkipped (UInt64) — Number of rows that received a default value due to quota or error.

Example

SELECT * FROM system.query_metric_log LIMIT 1 FORMAT Vertical;

Row 1:
──────
query_id:                                                        97c8ba04-b6d4-4bd7-b13e-6201c5c6e49d
hostname:                                                        clickhouse.eu-central1.internal
event_date:                                                      2020-09-05
event_time:                                                      2020-09-05 16:22:33
event_time_microseconds:                                         2020-09-05 16:22:33.196807
memory_usage:                                                    313434219
peak_memory_usage:                                               598951986
ProfileEvent_Query:                                              0
ProfileEvent_SelectQuery:                                        0
ProfileEvent_InsertQuery:                                        0
ProfileEvent_FailedQuery:                                        0
ProfileEvent_FailedSelectQuery:                                  0
...

Description​

Columns​

Example​

See Also​

Description

Columns

Example

See Also