system


asynchronous_metric_log	MergeTree	2.65 GiB	113.38 GiB	42.71	7.33 billion	77.66 MiB	35	2	0.00 B	Contains the historical values for system.asynchronous_metrics, once per time interval (one second by default).
query_log	MergeTree	706.33 MiB	9.74 GiB	14.12	10.88 million	28.25 MiB	25	0		Contains information about executed queries, for example, start time, duration of processing, error messages.
processors_profile_log	MergeTree	587.74 MiB	8.69 GiB	15.14	39.54 million	48.98 MiB	12	0		Contains profiling information on processors level (building blocks for a pipeline for query execution.
metric_log	MergeTree	409.79 MiB	5.50 GiB	13.74	5.66 million	27.32 MiB	15	2	0.00 B	Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.
metric_log_3	MergeTree	208.69 MiB	3.31 GiB	16.27	3.97 million	26.09 MiB	8	0		Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.
metric_log_4	MergeTree	171.39 MiB	2.51 GiB	14.98	2.91 million	28.57 MiB	6	0		Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.
processors_profile_log_1	MergeTree	145.14 MiB	1.79 GiB	12.6	10.06 million	18.14 MiB	8	0		Contains profiling information on processors level (building blocks for a pipeline for query execution.
metric_log_1	MergeTree	142.92 MiB	2.14 GiB	15.37	2.82 million	23.82 MiB	6	0		Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.
processors_profile_log_0	MergeTree	120.22 MiB	1.53 GiB	13.01	9.15 million	13.36 MiB	9	0		Contains profiling information on processors level (building blocks for a pipeline for query execution.
metric_log_5	MergeTree	119.99 MiB	1.76 GiB	15.06	2.01 million	24.00 MiB	5	0		Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.
trace_log_1	MergeTree	46.04 MiB	827.92 MiB	17.98	2.95 million	11.51 MiB	4	0		Contains stack traces collected by the sampling query profiler.
part_log	MergeTree	39.61 MiB	423.13 MiB	10.68	1.27 million	3.05 MiB	13	0		This table contains information about events that occurred with data parts in the MergeTree family tables, such as adding or merging data.
trace_log	MergeTree	37.63 MiB	1.27 GiB	34.54	4.70 million	12.54 MiB	3	0		Contains stack traces collected by the sampling query profiler.
metric_log_0	MergeTree	25.11 MiB	175.64 MiB	7	267.16 thousand	6.28 MiB	4	0		Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.
part_log_0	MergeTree	19.94 MiB	364.19 MiB	18.27	571.96 thousand	2.49 MiB	8	0		This table contains information about events that occurred with data parts in the MergeTree family tables, such as adding or merging data.
query_log_0	MergeTree	1.37 MiB	9.85 MiB	7.21	10.60 thousand	699.62 KiB	2	0		Contains information about executed queries, for example, start time, duration of processing, error messages.
metric_log_2	MergeTree	974.31 KiB	8.94 MiB	9.39	12.08 thousand	487.16 KiB	2	0		Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.
monitoring_events	ReplacingMergeTree	863.56 KiB	10.21 MiB	12.11	32.52 thousand	3.32 KiB	260	0
asynchronous_insert_log	MergeTree	462.08 KiB	1.88 MiB	4.16	8.51 thousand	57.76 KiB	8	0		Contains a history for all asynchronous inserts executed on current server.
error_log	MergeTree	430.31 KiB	9.01 MiB	21.43	471.14 thousand	39.12 KiB	11	0		Contains history of error values from table system.errors, periodically flushed to disk.
trace_log_0	MergeTree	292.82 KiB	4.12 MiB	14.41	15.09 thousand	146.41 KiB	2	0		Contains stack traces collected by the sampling query profiler.
backup_log	MergeTree	7.74 KiB	17.51 KiB	2.26	10.00	3.87 KiB	2	0		Contains logging entries with the information about BACKUP and RESTORE operations.
clickhouse_monitoring_custom_dashboard	ReplacingMergeTree	599.00 B	869.00 B	1.45	3.00	599.00 B	1	0
clickhouse_monitoring_custom_dashboard_settings	ReplacingMergeTree	159.00 B	57.00 B	0.36	1.00	159.00 B	1	0
aggregate_function_combinators	SystemAggregateFunctionCombinators			0			0	0		Contains a list of all available aggregate function combinators, which could be applied to aggregate functions and change the way they work.
dropped_tables_parts	SystemDroppedTablesParts			0			0	0		Contains parts of system.dropped_tables tables
dictionaries	SystemDictionaries			0			0	0		Contains information about dictionaries.
disks	SystemDisks			0			0	0		Contains information about disks defined in the server configuration.
distributed_ddl_queue	SystemDDLWorkerQueue			0			0	0		Contains information about distributed DDL queries (ON CLUSTER clause) that were executed on a cluster.
distribution_queue	SystemDistributionQueue			0			0	0		Contains information about local files that are in the queue to be sent to the shards. These local files contain new parts that are created by inserting new data into the Distributed table in asynchronous mode.
dns_cache	SystemDNSCache			0			0	0		Contains information about cached DNS records.
dropped_tables	SystemMarkedDroppedTables			0			0	0		Contains a list of tables which were dropped from Atomic databases but not completely removed yet.
detached_parts	SystemDetachedParts			0			0	0		Contains a list of all parts which are being found in /detached directory along with a reason why it was detached. ClickHouse server doesn't use such parts anyhow.
enabled_roles	SystemEnabledRoles			0			0	0		Contains all active roles at the moment, including current role of the current user and granted roles for current role.
databases	SystemDatabases			0			0	0		Lists all databases of the current server.
errors	SystemErrors			0			0	0		Contains a list of all errors which have ever happened including the error code, last time and message with unsymbolized stacktrace.
events	SystemEvents			0			0	0		Contains profiling events and their current value.
filesystem_cache	SystemFilesystemCache			0			0	0		Contains information about all entries inside filesystem cache for remote objects.
filesystem_cache_settings	SystemFilesystemCacheSettings			0			0	0		Contains information about all filesystem cache settings
formats	SystemFormats			0			0	0		Contains a list of all the formats along with flags whether a format is suitable for input/output or whether it supports parallelization.
functions	SystemFunctions			0			0	0		Contains a list of all available ordinary and aggregate functions with their descriptions.
grants	SystemGrants			0			0	0		Contains the information about privileges granted to ClickHouse user accounts.
graphite_retentions	SystemGraphite			0			0	0		Contains information about parameters graphite_rollup which are used in tables with *GraphiteMergeTree engines.
jemalloc_bins	SystemJemallocBins			0			0	0		Contains information about memory allocations done via jemalloc allocator in different size classes (bins) aggregated from all arenas. These statistics might not be absolutely accurate because of thread local caching in jemalloc.
kafka_consumers	SystemKafkaConsumers			0			0	0		Contains information about Kafka consumers. Applicable for Kafka table engine (native ClickHouse integration).
keywords	SystemKeywords			0			0	0		Contains a list of all keywords used in ClickHouse parser.
licenses	SystemLicenses			0			0	0		Contains licenses of third-party libraries that are located in the contrib directory of ClickHouse sources.
macros	SystemMacros			0			0	0		Contains a list of all macros defined in server configuration.
merge_tree_settings	SystemMergeTreeSettings			0			0	0		Contains a list of all MergeTree engine specific settings, their current and default values along with descriptions. You may change any of them in SETTINGS section in CREATE query.
merges	SystemMerges			0			0	0		Contains a list of merges currently executing merges of MergeTree tables and their progress. Each merge operation is represented by a single row.
database_engines	SystemDatabaseEngines			0			0	0		Contains a list of all available database engines
data_type_families	SystemTableDataTypeFamilies			0			0	0		Contains a list of all available native data types along with all the aliases used for compatibility with other DBMS.
data_skipping_indices	SystemDataSkippingIndices			0			0	0		Contains all the information about all the data skipping indices in tables, similar to system.columns.
dashboards	SystemDashboards			0			0	0		Contains queries used by /dashboard page accessible though HTTP interface. This table can be useful for monitoring and troubleshooting. The table contains a row for every chart in a dashboard.
current_roles	SystemCurrentRoles			0			0	0		Contains active roles of a current user. SET ROLE changes the contents of this table.
contributors	SystemContributors			0			0	0		Contains a list of all ClickHouse contributors <3
columns	SystemColumns			0			0	0		Lists all columns from all tables of the current server.
metrics	SystemMetrics			0			0	0		Contains metrics which can be calculated instantly, or have a current value. For example, the number of simultaneously processed queries or the current replica delay. This table is always up to date.
models	SystemModels			0			0	0		Contains a list of CatBoost models loaded into a LibraryBridge's memory along with time when it was loaded.
collations	SystemTableCollations			0			0	0		Contains a list of all available collations for alphabetical comparison of strings.
moves	SystemMoves			0			0	0		Contains information about in-progress data part moves of MergeTree tables. Each data part movement is represented by a single row.
mutations	SystemMutations			0			0	0		Contains a list of mutations and their progress. Each mutation command is represented by a single row.
mysql_binlogs	MySQLBinlogs			0			0	0		Shows a list of active binlogs for MaterializedMySQL.
named_collections	SystemNamedCollections			0			0	0		Contains a list of all named collections which were created via SQL query or parsed from configuration file.
numbers	SystemNumbers			0			0	0		Generates all natural numbers, starting from 0 (to 2^64 - 1, and then again) in sorted order.
numbers_mt	SystemNumbers			0			0	0		Multithreaded version of `system.numbers`. Numbers order is not guaranteed.
one	SystemOne			0			0	0		This table contains a single row with a single dummy UInt8 column containing the value 0. Used when the table is not specified explicitly, for example in queries like `SELECT 1`.
clusters	SystemClusters			0			0	0		Contains information about clusters defined in the configuration file or generated by a Replicated database.
certificates	SystemCertificates			0			0	0		Contains information about available certificates and their sources.
part_moves_between_shards	SystemShardMoves			0			0	0		Contains information about parts which are currently in a process of moving between shards and their progress.
parts	SystemParts			0			0	0		Contains a list of currently existing (both active and inactive) parts of all *-MergeTree tables. Each part is represented by a single row.
parts_columns	SystemPartsColumns			0			0	0		Contains a list of columns of all currently existing parts of all MergeTree tables. Each column is represented by a single row.
privileges	SystemPrivileges			0			0	0		Contains a list of all available privileges that could be granted to a user or role.
processes	SystemProcesses			0			0	0		Contains a list of currently executing processes (queries) with their progress.
build_options	SystemBuildOptions			0			0	0		Contains a list of all build flags, compiler options and commit hash for used build.
blob_storage_log	MergeTree			0			0	0		Contains logging entries with information about various blob storage operations such as uploads and deletes.
backups	SystemBackups			0			0	0		Contains a list of all BACKUP or RESTORE operations with their current states and other propertis. Note, that table is not persistent and it shows only operations executed after the last server restart.
projection_parts	SystemProjectionParts			0			0	0		Contains a list of currently existing projection parts (a copy of some part containing aggregated data or just sorted in different order) created for all the projections for all tables within a cluster.
projection_parts_columns	SystemProjectionPartsColumns			0			0	0		Contains a list of columns of all currently existing projection parts of all MergeTree tables. Each column is represented by a single row.
projections	StorageSystemProjections			0			0	0		Contains all the information about all the projections in tables, similar to system.data_skipping_indices.
query_cache	SystemQueryCache			0			0	0		Contains information about all entries inside query cache in server's memory.
azure_queue_settings	SystemAzureQueueSettings			0			0	0		Contains a list of settings of AzureQueue tables.
asynchronous_metrics	SystemAsynchronousMetrics			0			0	0		Contains metrics that are calculated periodically in the background. For example, the amount of RAM in use.
quota_limits	SystemQuotaLimits			0			0	0		Contains information about maximums for all intervals of all quotas. Any number of rows or zero can correspond to specific quota.
quota_usage	SystemQuotaUsage			0			0	0		Contains quota usage by the current user: how much is used and how much is left.
quotas	SystemQuotas			0			0	0		Contains information about quotas.
quotas_usage	SystemQuotasUsage			0			0	0		Contains quota usage by all users.
remote_data_paths	SystemRemoteDataPaths			0			0	0		Contains a mapping from a filename on local filesystem to a blob name inside object storage.
replicas	SystemReplicas			0			0	0		Contains information and status of all table replicas on current server. Each replica is represented by a single row.
replicated_fetches	SystemReplicatedFetches			0			0	0		Contains information about currently running background fetches.
replicated_merge_tree_settings	SystemReplicatedMergeTreeSettings			0			0	0		Contains a list of all ReplicatedMergeTree engine specific settings, their current and default values along with descriptions. You may change any of them in SETTINGS section in CREATE query.
replication_queue	SystemReplicationQueue			0			0	0		Contains information about tasks from replication queues stored in ClickHouse Keeper, or ZooKeeper, for each table replica.
resources	SystemResources			0			0	0		Contains a list of all currently existing resources.
rocksdb	SystemRocksDB			0			0	0		Contains a list of metrics exposed from embedded RocksDB.
role_grants	SystemRoleGrants			0			0	0		Contains the role grants for users and roles. To add entries to this table, use `GRANT role TO user`. Using this table you may find out which roles are assigned to which users or which roles a user has.
zookeeper_connection	SystemZooKeeperConnection			0			0	0		Shows the information about current connections to [Zoo]Keeper (including auxiliary [ZooKeepers)
row_policies	SystemRowPolicies			0			0	0		Contains filters for one particular table, as well as a list of roles and/or users which should use this row policy.
s3_queue_settings	SystemS3QueueSettings			0			0	0		Contains a list of settings of S3Queue tables.
s3queue	SystemS3Queue			0			0	0		Contains in-memory state of S3Queue metadata and currently processed rows per file.
scheduler	SystemScheduler			0			0	0		Contains information and status for scheduling nodes residing on the local server.

0 of 126 row(s) selected.

Rows per page

Page 1 of 2

ClickHouse MonitoringMonitoring

system