在 ClickHouse Cloud 中查询此系统表中的数据分别保存在 ClickHouse Cloud 各节点的本地。因此,如需查看所有数据的完整情况,需要使用
clusterAllReplicas 函数。更多详情请参见此处。描述
列
示例
ASTFuzzerAccumulatedFragments
ActiveTimersInQueryProfiler
AddressesActive
AddressesBanned
AggregatorThreads
AggregatorThreadsActive
AggregatorThreadsScheduled
AsyncInsertCacheSize
AsynchronousInsertQueueBytes
AsynchronousInsertQueueSize
AsynchronousInsertThreads
AsynchronousInsertThreadsActive
AsynchronousInsertThreadsScheduled
AsynchronousReadWait
AttachedDatabase
AttachedDictionary
已附加的复制表
AttachedTable
AttachedView
AvroSchemaCacheBytes
AvroSchemaCacheCells
AvroSchemaRegistryCacheBytes
AvroSchemaRegistryCacheCells
AzureRequests
BackgroundBufferFlushSchedulePoolSize
BackgroundBufferFlushSchedulePoolTask
BackgroundCommonPoolSize
BackgroundCommonPoolTask
BackgroundDistributedSchedulePoolSize
BackgroundDistributedSchedulePoolTask
BackgroundFetchesPoolSize
BackgroundFetchesPoolTask
BackgroundMergesAndMutationsPoolSize
BackgroundMergesAndMutationsPoolTask
BackgroundMessageBrokerSchedulePoolSize
BackgroundMessageBrokerSchedulePoolTask
BackgroundMovePoolSize
BackgroundMovePoolTask
BackgroundSchedulePoolSize
BackgroundSchedulePoolTask
BackupsIOThreads
BackupsIOThreadsActive
BackupsIOThreadsScheduled
BackupsThreads
BackupsThreadsActive
BackupsThreadsScheduled
BcryptCacheBytes
BcryptCacheSize
BlobCopierThreads
BlobCopierThreadsActive
BlobCopierThreadsScheduled
BlobKillerThreads
BlobKillerThreadsActive
BlobKillerThreadsScheduled
BrokenDisks
BrokenDistributedBytesToInsert
BrokenDistributedFilesToInsert
BuildVectorSimilarityIndexThreads
BuildVectorSimilarityIndexThreadsActive
BuildVectorSimilarityIndexThreadsScheduled
已分离的缓存 File 段
CacheDictionaryThreads
CacheDictionaryThreadsActive
CacheDictionaryThreadsScheduled
CacheDictionaryUpdateQueueBatches
CacheDictionaryUpdateQueueKeys
CacheFileSegments
CacheWarmerBytesInProgress
ColumnsDescriptionsCacheSize
CompiledExpressionCacheBytes
CompiledExpressionCacheCount
压缩
CompressionThread
CompressionThreadActive
CompressionThreadScheduled
ConcurrencyControlAcquired
ConcurrencyControlAcquiredNonCompeting
ConcurrencyControlPreempted
ConcurrencyControlScheduled
ConcurrencyControlSoftLimit
ConcurrentHashJoinPoolThreads
ConcurrentHashJoinPoolThreadsActive
ConcurrentHashJoinPoolThreadsScheduled
ConcurrentQueryAcquired
ConcurrentQueryScheduled
ContextLockWait
CoordinatedMergesCoordinatorAssignedMerges
CoordinatedMergesCoordinatorRunningMerges
CoordinatedMergesWorkerAssignedMerges
CreatedTimersInQueryProfiler
DDLWorkerThreads
DDLWorkerThreadsActive
DDLWorkerThreadsScheduled
DNSAddressesCacheBytes
DNSAddressesCacheSize
DNSHostsCacheBytes
DNSHostsCacheSize
DatabaseBackupThreads
DatabaseBackupThreadsActive
DatabaseBackupThreadsScheduled
DatabaseCatalogThreads
DatabaseCatalogThreadsActive
DatabaseCatalogThreadsScheduled
DatabaseOnDiskThreads
DatabaseOnDiskThreadsActive
DatabaseOnDiskThreadsScheduled
DatabaseReplicatedCreateTablesThreads
DatabaseReplicatedCreateTablesThreadsActive
DatabaseReplicatedCreateTablesThreadsScheduled
解压
DelayedInserts
DeltaLakeSnapshotCacheSizeElements
DestroyAggregatesThreads
DestroyAggregatesThreadsActive
DestroyAggregatesThreadsScheduled
DictCacheRequests
DiskConnectionsStored
DiskConnectionsTotal
DiskObjectStorageAsyncThreads
DiskObjectStorageAsyncThreadsActive
DiskPlainRewritableAzureDirectoryMapSize
plain_rewritable 内存中 Map 里,本地到远程路径条目的数量。
DiskPlainRewritableAzureFileCount
plain_rewritable 内存映射中的文件条目数量。
DiskPlainRewritableLocalDirectoryMapSize
plain_rewritable 内存映射中本地到远程路径条目数量。
DiskPlainRewritableLocalFileCount
plain_rewritable 内存映射里的文件条目数。
DiskPlainRewritableS3DirectoryMapSize
plain_rewritable 内存 Map 里本地到远程路径条目的数量。
DiskPlainRewritableS3FileCount
DiskS3NoSuchKeyErrors
NoSuchKey 错误数。
DiskSpaceReservedForMerge
DistrCacheAllocatedConnections
DistrCacheBorrowedConnections
DistrCacheOpenedConnections
DistrCacheReadBuffers
DistrCacheReadRequests
DistrCacheRegisteredServers
DistrCacheRegisteredServersCurrentAZ
DistrCacheServerConnections
DistrCacheServerRegistryConnections
DistrCacheServerS3CachedClients
DistrCacheUsedConnections
DistrCacheWriteBuffers
DistrCacheWriteRequests
DistributedBytesToInsert
DistributedFilesToInsert
DistributedIndexAnalysisThreads
DistributedIndexAnalysisThreadsActive
DistributedIndexAnalysisThreadsScheduled
DistributedInsertThreads
DistributedInsertThreadsActive
DistributedInsertThreadsScheduled
DistributedSend
DropDistributedCacheThreads
DropDistributedCacheThreadsActive
DropDistributedCacheThreadsScheduled
EphemeralNode
FilesystemCacheDelayedCleanupElements
FilesystemCacheDownloadQueueElements
FilesystemCacheElements
FilesystemCacheHoldFileSegments
FilesystemCacheKeys
FilesystemCacheReadBuffers
FilesystemCacheReserveThreads
FilesystemCacheSize
FilesystemCacheSizeLimit
使用主键过滤标记范围
按二级键过滤标记范围
FormatParsingThreads
FormatParsingThreadsActive
FormatParsingThreadsScheduled
FreezePartThreads
FreezePartThreadsActive
FreezePartThreadsScheduled
GlobalThread
GlobalThreadActive
GlobalThreadScheduled
HTTPConnection
HTTPConnectionsStored
HTTPConnectionsTotal
HashedDictionaryThreads
HashedDictionaryThreadsActive
HashedDictionaryThreadsScheduled
HiveFilesCacheBytes
HiveFilesCacheFiles
HiveMetadataFilesCacheBytes
HiveMetadataFilesCacheFiles
IDiskCopierThreads
IDiskCopierThreadsActive
IDiskCopierThreadsScheduled
IOPrefetchThreads
IOPrefetchThreadsActive
IOPrefetchThreadsScheduled
IOThreads
IOThreadsActive
IOThreadsScheduled
IOUringInFlightEvents
IOUringPendingEvents
IOWriterThreads
IOWriterThreadsActive
IOWriterThreadsScheduled
IcebergCatalogThreads
IcebergCatalogThreadsActive
IcebergCatalogThreadsScheduled
IcebergCompactionSnapshots
IcebergCompactionThreads
IcebergCompactionThreadsActive
IcebergCompactionThreadsScheduled
IcebergMetadataFilesCacheBytes
IcebergMetadataFilesCacheFiles
IcebergSchedulePoolSize
IcebergSchedulePoolTask
IndexMarkCacheBytes
IndexMarkCacheFiles
IndexUncompressedCacheBytes
IndexUncompressedCacheCells
InterserverConnection
IsServerShuttingDown
KafkaAssignedPartitions
KafkaBackgroundReads
KafkaConsumers
KafkaConsumersInUse
KafkaConsumersWithAssignment
KafkaLibrdkafkaThreads
KafkaProducers
KafkaWrites
KeeperAliveConnections
KeeperOutstandingRequests
KeeperReadThreads
KeeperReadThreadsActive
KeeperReadThreadsScheduled
LicenseRemainingSeconds
LocalThread
LocalThreadActive
LocalThreadScheduled
MMapCacheCells
mmap 打开的文件数量 (即映射到内存中的文件) 。这项指标用于将设置 local_filesystem_read_method 设为 mmap 的查询。使用 mmap 打开的文件会保留在缓存中,以避免代价高昂的 TLB flush 操作。
MMappedFileBytes
MMappedFiles
MarkCacheBytes
MarkCacheFiles
MarksLoaderThreads
MarksLoaderThreadsActive
MarksLoaderThreadsScheduled
MaxAllocatedEphemeralLockSequentialNumber
MaxDDLEntryID
MaxPushedDDLEntryID
MemoryTracking
MemoryTrackingUncorrected
Merge
MergeJoinBlocksCacheBytes
MergeJoinBlocksCacheCount
MergeParts
MergeTreeAllRangesAnnouncementsSent
MergeTreeBackgroundExecutorThreads
MergeTreeBackgroundExecutorThreadsActive
MergeTreeBackgroundExecutorThreadsScheduled
MergeTreeDataSelectExecutorThreads
MergeTreeDataSelectExecutorThreadsActive
MergeTreeDataSelectExecutorThreadsScheduled
MergeTreeFetchPartitionThreads
MergeTreeFetchPartitionThreadsActive
MergeTreeFetchPartitionThreadsScheduled
MergeTreeOutdatedPartsLoaderThreads
MergeTreeOutdatedPartsLoaderThreadsActive
MergeTreeOutdatedPartsLoaderThreadsScheduled
MergeTreePartsCleanerThreads
MergeTreePartsCleanerThreadsActive
MergeTreePartsCleanerThreadsScheduled
MergeTreePartsLoaderThreads
MergeTreePartsLoaderThreadsActive
MergeTreePartsLoaderThreadsScheduled
MergeTreeReadTaskRequestsSent
MergeTreeSnapshotCommitThreads
MergeTreeSnapshotCommitThreadsActive
MergeTreeSnapshotCommitThreadsScheduled
MergeTreeSubcolumnsReaderThreads
MergeTreeSubcolumnsReaderThreadsActive
MergeTreeSubcolumnsReaderThreadsScheduled
MergeTreeUnexpectedPartsLoaderThreads
MergeTreeUnexpectedPartsLoaderThreadsActive
MergeTreeUnexpectedPartsLoaderThreadsScheduled
MergesMutationsMemoryTracking
MetadataFromKeeperCacheObjects
移动
MySQLConnection
NamedCollection
NetworkReceive
NetworkSend
ObjectStorageAzureThreads
ObjectStorageAzureThreadsActive
ObjectStorageAzureThreadsScheduled
ObjectStorageQueueMetadataCacheSizeBytes
ObjectStorageQueueMetadataCacheSizeElements
ObjectStorageQueueRegisteredServers
ObjectStorageQueueShutdownThreads
ObjectStorageQueueShutdownThreadsActive
ObjectStorageQueueShutdownThreadsScheduled
ObjectStorageS3Threads
ObjectStorageS3ThreadsActive
ObjectStorageS3ThreadsScheduled
OpenFileForRead
OpenFileForWrite
OutdatedPartsLoadingThreads
OutdatedPartsLoadingThreadsActive
OutdatedPartsLoadingThreadsScheduled
PageCacheBytes
PageCacheCells
ParallelCompressedWriteBufferThreads
ParallelCompressedWriteBufferWait
ParallelFormattingOutputFormatThreads
ParallelFormattingOutputFormatThreadsActive
ParallelFormattingOutputFormatThreadsScheduled
ParallelWithQueryActiveThreads
ParallelWithQueryScheduledThreads
ParallelWithQueryThreads
ParquetEncoderThreads
ParquetEncoderThreadsActive
ParquetEncoderThreadsScheduled
ParquetMetadataCacheBytes
ParquetMetadataCacheFiles
PartMutation
PartsActive
PartsCommitted
PartsCompact
PartsDeleteOnDestroy
PartsDeleting
PartsOutdated
PartsPreActive
PartsPreCommitted
PartsTemporary
PartsWide
PendingAsyncInsert
PolygonDictionaryThreads
PolygonDictionaryThreadsActive
PolygonDictionaryThreadsScheduled
PostgreSQLConnection
主索引缓存的总大小,以字节计。保存了在
primary_key_lazy_load=1 且 use_primary_key_cache=1 时按需加载的主键索引。这些内存分配位于专用的缓存 jemalloc Arena (jemalloc.cache_arena.*) 中。它绝不会与 system.parts.primary_key_bytes_in_memory[_allocated] 重叠——一个 part 的索引要么位于此缓存中 (计入这里) ,要么位于 part 自身中 (计入那里) ;绝不会同时计入两者。若要获取所有 parts 的主索引总内存,请将这两项相加。
PrimaryIndexCacheFiles
查询
QueryCacheBytes
QueryCacheEntries
QueryConditionCacheBytes
QueryConditionCacheEntries
QueryNonInternal
QueryPipelineExecutorThreads
QueryPipelineExecutorThreadsActive
QueryPipelineExecutorThreadsScheduled
QueryPreempted
priority 设置而被暂停并处于等待状态的运行中任务数量。
QueryThread
RWLockActiveReaders
RWLockActiveWriters
RWLockWaitingReaders
RWLockWaitingWriters
读取
ReadTaskRequestsSent
ReadonlyDisks
ReadonlyReplica
可刷新视图
刷新中的视图
RemoteRead
ReplicaReady
ReplicatedChecks
ReplicatedFetch
ReplicatedSend
RestartReplicaThreads
RestartReplicaThreadsActive
RestartReplicaThreadsScheduled
RestoreThreads
RestoreThreadsActive
RestoreThreadsScheduled
修订号
S3CachedCredentialsProviders
S3Requests
SchedulerIOReadScheduled
SchedulerIOWriteScheduled
SendExternalTables
SendScalars
SerializationCacheBytesInMemory
SerializationCacheBytesInMemoryAllocated
SerializationCacheCount
启动脚本执行状态
StartupSystemTablesThreads
StartupSystemTablesThreadsActive
StartupSystemTablesThreadsScheduled
StatelessWorkerThreads
StatelessWorkerThreadsActive
StatelessWorkerThreadsScheduled
StorageBufferBytes
StorageBufferFlushThreads
StorageBufferFlushThreadsActive
StorageBufferFlushThreadsScheduled
StorageBufferRows
StorageConnectionsStored
StorageConnectionsTotal
StorageDistributedThreads
StorageDistributedThreadsActive
StorageDistributedThreadsScheduled
StorageHiveThreads
StorageHiveThreadsActive
StorageHiveThreadsScheduled
StorageObjectStorageThreads
StorageObjectStorageThreadsActive
StorageObjectStorageThreadsScheduled
StorageS3Threads
StorageS3ThreadsActive
StorageS3ThreadsScheduled
SystemDatabaseReplicasThreads
SystemDatabaseReplicasThreadsActive
SystemDatabaseReplicasThreadsScheduled
SystemReplicasThreads
SystemReplicasThreadsActive
SystemReplicasThreadsScheduled
system.replicas 线程池中已排队或正在运行的作业数量。
TCPConnection
TablesLoaderBackgroundThreads
TablesLoaderBackgroundThreadsActive
TablesLoaderBackgroundThreadsScheduled
TablesLoaderForegroundThreads
TablesLoaderForegroundThreadsActive
TablesLoaderForegroundThreadsScheduled
TablesToDropQueueSize
TaskTrackerThreads
TaskTrackerThreadsActive
TaskTrackerThreadsScheduled
外部聚合产生的临时 File 数量
TemporaryFilesForJoin
TemporaryFilesForMerge
TemporaryFilesForSort
TemporaryFilesUnknown
TextIndexHeaderCacheBytes
TextIndexHeaderCacheCells
TextIndexPostingsCacheBytes
TextIndexPostingsCacheCells
TextIndexTokensCacheBytes
TextIndexTokensCacheCells
ThreadPoolFSReaderThreads
ThreadPoolFSReaderThreadsActive
local_filesystem_read_method=threadpool 线程池中正在执行任务的线程数。
ThreadPoolFSReaderThreadsScheduled
local_filesystem_read_method=threadpool 的线程池中,处于排队中或正在执行的作业数量。
ThreadPoolRemoteFSReaderThreads
ThreadPoolRemoteFSReaderThreadsActive
remote_filesystem_read_method=threadpool 的线程池中,正在执行任务的线程数。