system


processors_profile_log	MergeTree	2.49 GiB	21.62 GiB	8.68	130.30 million	231.88 MiB	11	Contains profiling information on processors level (building blocks for a pipeline for query execution.
query_log	MergeTree	1.63 GiB	11.36 GiB	6.98	7.12 million	166.56 MiB	10	Contains information about executed queries, for example, start time, duration of processing, error messages.
query_views_log	MergeTree	56.69 MiB	453.72 MiB	8	410.33 thousand	5.67 MiB	10	Contains information about the dependent views executed when running a query, for example, the view type or the execution time.
query_views_log_0	MergeTree	218.94 KiB	1.74 MiB	8.13	1.98 thousand	218.94 KiB	1
monitoring_events	ReplacingMergeTree	35.64 KiB	190.56 KiB	5.35	805.00	688.58 B	53
aggregate_function_combinators	SystemAggregateFunctionCombinators			0			0	Contains a list of all available aggregate function combinators, which could be applied to aggregate functions and change the way they work.
row_policies	SystemRowPolicies			0			0	Contains filters for one particular table, as well as a list of roles and/or users which should use this row policy.
clusters	SystemClusters			0			0	Contains information about clusters defined in the configuration file or generated by a Replicated database.
collations	SystemTableCollations			0			0	Contains a list of all available collations for alphabetical comparison of strings.
columns	SystemColumns			0			0	Lists all columns from all tables of the current server.
contributors	SystemContributors			0			0	Contains a list of all ClickHouse contributors <3
current_roles	SystemCurrentRoles			0			0	Contains active roles of a current user. SET ROLE changes the contents of this table.
dashboards	SystemDashboards			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.
data_skipping_indices	SystemDataSkippingIndices			0			0	Contains all the information about all the data skipping indices in tables, similar to system.columns.
data_type_families	SystemTableDataTypeFamilies			0			0	Contains a list of all available native data types along with all the aliases used for compatibility with other DBMS.
database_engines	SystemDatabaseEngines			0			0	Contains a list of all available database engines
databases	SystemDatabases			0			0	Lists all databases of the current server.
detached_parts	SystemDetachedParts			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.
dictionaries	SystemDictionaries			0			0	Contains information about dictionaries.
disks	SystemDisks			0			0	Contains information about disks defined in the server configuration.
distributed_ddl_queue	SystemDDLWorkerQueue			0			0	Contains information about distributed DDL queries (ON CLUSTER clause) that were executed on a cluster.
distribution_queue	SystemDistributionQueue			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	Contains information about cached DNS records.
dropped_tables	SystemMarkedDroppedTables			0			0	Contains a list of tables which were dropped from Atomic databases but not completely removed yet.
dropped_tables_parts	SystemDroppedTablesParts			0			0	Contains parts of system.dropped_tables tables
asynchronous_inserts	SystemAsynchronousInserts			0			0	Contains information about pending asynchronous inserts in queue in server's memory.
errors	SystemErrors			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	Contains profiling events and their current value.
filesystem_cache	SystemFilesystemCache			0			0	Contains information about all entries inside filesystem cache for remote objects.
certificates	SystemCertificates			0			0	Contains information about available certificates and their sources.
functions	SystemFunctions			0			0	Contains a list of all available ordinary and aggregate functions with their descriptions.
generateSeries	SystemNumbers			0			0	Generates arithmetic progression of natural numbers in sorted order in a given segment with a given step
generate_series	SystemNumbers			0			0	Generates arithmetic progression of natural numbers in sorted order in a given segment with a given step
grants	SystemGrants			0			0	Contains the information about privileges granted to ClickHouse user accounts.
graphite_retentions	SystemGraphite			0			0	Contains information about parameters graphite_rollup which are used in tables with *GraphiteMergeTree engines.
jemalloc_bins	SystemJemallocBins			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	Contains information about Kafka consumers. Applicable for Kafka table engine (native ClickHouse integration).
keywords	SystemKeywords			0			0	Contains a list of all keywords used in ClickHouse parser.
licenses	SystemLicenses			0			0	Contains licenses of third-party libraries that are located in the contrib directory of ClickHouse sources.
macros	SystemMacros			0			0	Contains a list of all macros defined in server configuration.
merge_tree_settings	SystemMergeTreeSettings			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	Contains a list of merges currently executing merges of MergeTree tables and their progress. Each merge operation is represented by a single row.
metrics	SystemMetrics			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	Contains a list of CatBoost models loaded into a LibraryBridge's memory along with time when it was loaded.
build_options	SystemBuildOptions			0			0	Contains a list of all build flags, compiler options and commit hash for used build.
moves	SystemMoves			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	Contains a list of mutations and their progress. Each mutation command is represented by a single row.
mysql_binlogs	MySQLBinlogs			0			0	Shows a list of active binlogs for MaterializedMySQL.
named_collections	SystemNamedCollections			0			0	Contains a list of all named collections which were created via SQL query or parsed from configuration file.
numbers	SystemNumbers			0			0	Generates all natural numbers, starting from 0 (to 2^64 - 1, and then again) in sorted order.
numbers_mt	SystemNumbers			0			0	Multithreaded version of `system.numbers`. Numbers order is not guaranteed.
one	SystemOne			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`.
part_moves_between_shards	SystemShardMoves			0			0	Contains information about parts which are currently in a process of moving between shards and their progress.
parts	SystemParts			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	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	Contains a list of all available privileges that could be granted to a user or role.
processes	SystemProcesses			0			0	Contains a list of currently executing processes (queries) with their progress.
backups	SystemBackups			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	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	Contains a list of columns of all currently existing projection parts of all MergeTree tables. Each column is represented by a single row.
query_cache	SystemQueryCache			0			0	Contains information about all entries inside query cache in server's memory.
asynchronous_metrics	SystemAsynchronousMetrics			0			0	Contains metrics that are calculated periodically in the background. For example, the amount of RAM in use.
asynchronous_loader	SystemAsyncLoader			0			0	Contains information and status for recent asynchronous jobs (e.g. for tables loading). The table contains a row for every job.
roles	SystemRoles			0			0	Contains a list of all roles created at the server.
quota_limits	SystemQuotaLimits			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	Contains quota usage by the current user: how much is used and how much is left.
quotas	SystemQuotas			0			0	Contains information about quotas.
quotas_usage	SystemQuotasUsage			0			0	Contains quota usage by all users.
remote_data_paths	SystemRemoteDataPaths			0			0	Contains a mapping from a filename on local filesystem to a blob name inside object storage.
replicas	SystemReplicas			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	Contains information about currently running background fetches.
replicated_merge_tree_settings	SystemReplicatedMergeTreeSettings			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	Contains information about tasks from replication queues stored in ClickHouse Keeper, or ZooKeeper, for each table replica.
rocksdb	SystemRocksDB			0			0	Contains a list of metrics exposed from embedded RocksDB.
role_grants	SystemRoleGrants			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.
zeros_mt	SystemZeros			0			0	Multithreaded version of system.zeros.
enabled_roles	SystemEnabledRoles			0			0	Contains all active roles at the moment, including current role of the current user and granted roles for current role.
s3queue	SystemS3Queue			0			0	Contains in-memory state of S3Queue metadata and currently processed rows per file.
scheduler	SystemScheduler			0			0	Contains information and status for scheduling nodes residing on the local server.
schema_inference_cache	SystemSettingsChanges			0			0	Contains information about all cached file schemas.
server_settings	SystemServerSettings			0			0	Contains a list of all server-wide settings (which are effective only on server startup and usually cannot be modified at runtime), their current and default values along with descriptions.
settings	SystemSettings			0			0	Contains a list of all user-level settings (which can be modified in a scope of query or session), their current and default values along with descriptions.
settings_changes	SystemSettingsChanges			0			0	Contains the information about the settings changes through different ClickHouse versions. You may make ClickHouse behave like a particular previous version by changing the `compatibility` user-level settings.
settings_profile_elements	SystemSettingsProfileElements			0			0	Describes the content of each settings profile configured on the server. Including settings constraints, roles and users for which the settings are applied, and parent settings profiles.
settings_profiles	SystemSettingsProfiles			0			0	Contains properties of configured setting profiles.
stack_trace	SystemStackTrace			0			0	Allows to obtain an unsymbolized stacktrace from all the threads of the server process.
storage_policies	SystemStoragePolicies			0			0	Contains information about storage policies and volumes defined in the server configuration.
symbols	SystemSymbols			0			0	Contains information for introspection of ClickHouse binary. This table is only useful for C++ experts and ClickHouse engineers.
table_engines	SystemTableEngines			0			0	Contains a list of all available table engines along with information whether a particular table engine supports some specific features (e.g. settings, skipping indices, projections, replication, TTL, deduplication, parallel insert, etc.)
table_functions	SystemTableFunctions			0			0	Contains a list of all available table functions with their descriptions.
tables	SystemTables			0			0	Lists all tables of the current server.
time_zones	SystemTimeZones			0			0	Contains a list of time zones that are supported by the ClickHouse server. This list of timezones might vary depending on the version of ClickHouse.
user_directories	SystemUserDirectories			0			0	Contains the information about configured user directories - directories on the file system from which ClickHouse server is allowed to read user provided data.
user_processes	SystemUserProcesses			0			0	This system table can be used to get overview of memory usage and ProfileEvents of users.
users	SystemUsers			0			0	Contains a list of all users profiles either configured at the server through a configuration file or created via SQL.
view_refreshes	SystemViewRefreshes			0			0	Lists all Refreshable Materialized Views of current server.
warnings	SystemWarnings			0			0	Contains warnings about server configuration to be displayed by clickhouse-client right after it connects to the server.
zeros	SystemZeros			0			0	Produces unlimited number of non-materialized zeros.
formats	SystemFormats			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.

0 of 99 row(s) selected.

ClickHouse MonitoringMonitoring

View Full Query Details

View Full Query Details

system