Skip to content

Instantly share code, notes, and snippets.

@filimonov

filimonov/diff_20.4.4.18_20.12.7.3.md

Last active March 11, 2021 07:29
Star
Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
Raw
diff_20.4.4.18_20.12.7.3.md

User-level diff between 20.4.4.18 and 20.12.7.3

  • Number of PR 2167
  • Number of commits 9179
  • Number of authors 287

Tables in system database

name groupArray(version)
current_roles ['new']
distribution_queue ['new']
enabled_roles ['new']
errors ['new']
grants ['new']
licenses ['new']
privileges ['new']
quota_limits ['new']
quotas_usage ['new']
replicated_fetches ['new']
replicated_merge_tree_settings ['new']
role_grants ['new']
roles ['new']
settings_profile_elements ['new']
settings_profiles ['new']
time_zones ['new']
user_directories ['new']
users ['new']

Table structures in system database

table name groupArray(version) groupArray(type)
columns position ['new'] ['UInt64']
current_roles role_name ['new'] ['String']
current_roles with_admin_option ['new'] ['UInt8']
current_roles is_default ['new'] ['UInt8']
databases uuid ['new'] ['UUID']
dictionaries uuid ['new'] ['UUID']
disks type ['new'] ['String']
distribution_queue database ['new'] ['String']
distribution_queue table ['new'] ['String']
distribution_queue data_path ['new'] ['String']
distribution_queue is_blocked ['new'] ['UInt8']
distribution_queue error_count ['new'] ['UInt64']
distribution_queue data_files ['new'] ['UInt64']
distribution_queue data_compressed_bytes ['new'] ['UInt64']
distribution_queue last_exception ['new'] ['String']
enabled_roles role_name ['new'] ['String']
enabled_roles with_admin_option ['new'] ['UInt8']
enabled_roles is_current ['new'] ['UInt8']
enabled_roles is_default ['new'] ['UInt8']
errors name ['new'] ['String']
errors code ['new'] ['Int32']
errors value ['new'] ['UInt64']
grants user_name ['new'] ['Nullable(String)']
grants role_name ['new'] ['Nullable(String)']
grants access_type ['new'] ['Enum8('SHOW DATABASES' = 0, 'SHOW TABLES' = 1, 'SHOW COLUMNS' = 2, 'SHOW DICTIONARIES' = 3, 'SHOW' = 4, 'SELECT' = 5, 'INSERT' = 6, 'ALTER UPDATE' = 7, 'ALTER DELETE' = 8, 'ALTER ADD COLUMN' = 9, 'ALTER MODIFY COLUMN' = 10, 'ALTER DROP COLUMN' = 11, 'ALTER COMMENT COLUMN' = 12, 'ALTER CLEAR COLUMN' = 13, 'ALTER RENAME COLUMN' = 14, 'ALTER COLUMN' = 15, 'ALTER ORDER BY' = 16, 'ALTER SAMPLE BY' = 17, 'ALTER ADD INDEX' = 18, 'ALTER DROP INDEX' = 19, 'ALTER MATERIALIZE INDEX' = 20, 'ALTER CLEAR INDEX' = 21, 'ALTER INDEX' = 22, 'ALTER ADD CONSTRAINT' = 23, 'ALTER DROP CONSTRAINT' = 24, 'ALTER CONSTRAINT' = 25, 'ALTER TTL' = 26, 'ALTER MATERIALIZE TTL' = 27, 'ALTER SETTINGS' = 28, 'ALTER MOVE PARTITION' = 29, 'ALTER FETCH PARTITION' = 30, 'ALTER FREEZE PARTITION' = 31, 'ALTER TABLE' = 32, 'ALTER VIEW REFRESH' = 33, 'ALTER VIEW MODIFY QUERY' = 34, 'ALTER VIEW' = 35, 'ALTER' = 36, 'CREATE DATABASE' = 37, 'CREATE TABLE' = 38, 'CREATE VIEW' = 39, 'CREATE DICTIONARY' = 40, 'CREATE TEMPORARY TABLE' = 41, 'CREATE' = 42, 'DROP DATABASE' = 43, 'DROP TABLE' = 44, 'DROP VIEW' = 45, 'DROP DICTIONARY' = 46, 'DROP' = 47, 'TRUNCATE' = 48, 'OPTIMIZE' = 49, 'KILL QUERY' = 50, 'CREATE USER' = 51, 'ALTER USER' = 52, 'DROP USER' = 53, 'CREATE ROLE' = 54, 'ALTER ROLE' = 55, 'DROP ROLE' = 56, 'ROLE ADMIN' = 57, 'CREATE ROW POLICY' = 58, 'ALTER ROW POLICY' = 59, 'DROP ROW POLICY' = 60, 'CREATE QUOTA' = 61, 'ALTER QUOTA' = 62, 'DROP QUOTA' = 63, 'CREATE SETTINGS PROFILE' = 64, 'ALTER SETTINGS PROFILE' = 65, 'DROP SETTINGS PROFILE' = 66, 'SHOW USERS' = 67, 'SHOW ROLES' = 68, 'SHOW ROW POLICIES' = 69, 'SHOW QUOTAS' = 70, 'SHOW SETTINGS PROFILES' = 71, 'SHOW ACCESS' = 72, 'ACCESS MANAGEMENT' = 73, 'SYSTEM SHUTDOWN' = 74, 'SYSTEM DROP DNS CACHE' = 75, 'SYSTEM DROP MARK CACHE' = 76, 'SYSTEM DROP UNCOMPRESSED CACHE' = 77, 'SYSTEM DROP COMPILED EXPRESSION CACHE' = 78, 'SYSTEM DROP CACHE' = 79, 'SYSTEM RELOAD CONFIG' = 80, 'SYSTEM RELOAD DICTIONARY' = 81, 'SYSTEM RELOAD EMBEDDED DICTIONARIES' = 82, 'SYSTEM RELOAD' = 83, 'SYSTEM MERGES' = 84, 'SYSTEM TTL MERGES' = 85, 'SYSTEM FETCHES' = 86, 'SYSTEM MOVES' = 87, 'SYSTEM DISTRIBUTED SENDS' = 88, 'SYSTEM REPLICATED SENDS' = 89, 'SYSTEM SENDS' = 90, 'SYSTEM REPLICATION QUEUES' = 91, 'SYSTEM DROP REPLICA' = 92, 'SYSTEM SYNC REPLICA' = 93, 'SYSTEM RESTART REPLICA' = 94, 'SYSTEM FLUSH DISTRIBUTED' = 95, 'SYSTEM FLUSH LOGS' = 96, 'SYSTEM FLUSH' = 97, 'SYSTEM' = 98, 'dictGet' = 99, 'addressToLine' = 100, 'addressToSymbol' = 101, 'demangle' = 102, 'INTROSPECTION' = 103, 'FILE' = 104, 'URL' = 105, 'REMOTE' = 106, 'MONGO' = 107, 'MYSQL' = 108, 'ODBC' = 109, 'JDBC' = 110, 'HDFS' = 111, 'S3' = 112, 'SOURCES' = 113, 'ALL' = 114, 'NONE' = 115)']
grants database ['new'] ['Nullable(String)']
grants table ['new'] ['Nullable(String)']
grants column ['new'] ['Nullable(String)']
grants is_partial_revoke ['new'] ['UInt8']
grants grant_option ['new'] ['UInt8']
licenses library_name ['new'] ['String']
licenses license_type ['new'] ['String']
licenses license_path ['new'] ['String']
licenses license_text ['new'] ['String']
merges merge_type ['new'] ['String']
merges merge_algorithm ['new'] ['String']
metric_log event_time_microseconds ['new'] ['DateTime64(6)']
metric_log ProfileEvent_FailedQuery ['new'] ['UInt64']
metric_log ProfileEvent_FailedSelectQuery ['new'] ['UInt64']
metric_log ProfileEvent_FailedInsertQuery ['new'] ['UInt64']
metric_log ProfileEvent_QueryTimeMicroseconds ['new'] ['UInt64']
metric_log ProfileEvent_SelectQueryTimeMicroseconds ['new'] ['UInt64']
metric_log ProfileEvent_InsertQueryTimeMicroseconds ['new'] ['UInt64']
metric_log ProfileEvent_ReplicaYieldLeadership ['old'] ['UInt64']
metric_log ProfileEvent_LeaderElectionAcquiredLeadership ['old'] ['UInt64']
metric_log ProfileEvent_SelectedRows ['new'] ['UInt64']
metric_log ProfileEvent_SelectedBytes ['new'] ['UInt64']
metric_log CurrentMetric_LeaderReplica ['old'] ['Int64']
metric_log CurrentMetric_MemoryTrackingInBackgroundProcessingPool ['old'] ['Int64']
metric_log CurrentMetric_MemoryTrackingInBackgroundMoveProcessingPool ['old'] ['Int64']
metric_log CurrentMetric_MemoryTrackingInBackgroundSchedulePool ['old'] ['Int64']
metric_log CurrentMetric_MemoryTrackingInBackgroundBufferFlushSchedulePool ['old'] ['Int64']
metric_log CurrentMetric_MemoryTrackingInBackgroundDistributedSchedulePool ['old'] ['Int64']
metric_log CurrentMetric_MemoryTrackingForMerges ['old'] ['Int64']
metric_log CurrentMetric_LeaderElection ['old'] ['Int64']
metric_log ProfileEvent_PerfCpuCycles ['new'] ['UInt64']
metric_log ProfileEvent_PerfInstructions ['new'] ['UInt64']
metric_log ProfileEvent_PerfCacheReferences ['new'] ['UInt64']
metric_log ProfileEvent_PerfCacheMisses ['new'] ['UInt64']
metric_log ProfileEvent_PerfBranchInstructions ['new'] ['UInt64']
metric_log ProfileEvent_PerfBranchMisses ['new'] ['UInt64']
metric_log ProfileEvent_PerfBusCycles ['new'] ['UInt64']
metric_log ProfileEvent_PerfStalledCyclesFrontend ['new'] ['UInt64']
metric_log ProfileEvent_PerfStalledCyclesBackend ['new'] ['UInt64']
metric_log ProfileEvent_PerfRefCpuCycles ['new'] ['UInt64']
metric_log ProfileEvent_PerfCpuClock ['new'] ['UInt64']
metric_log ProfileEvent_PerfTaskClock ['new'] ['UInt64']
metric_log ProfileEvent_PerfContextSwitches ['new'] ['UInt64']
metric_log ProfileEvent_PerfCpuMigrations ['new'] ['UInt64']
metric_log ProfileEvent_PerfAlignmentFaults ['new'] ['UInt64']
metric_log ProfileEvent_PerfEmulationFaults ['new'] ['UInt64']
metric_log ProfileEvent_PerfMinEnabledTime ['new'] ['UInt64']
metric_log ProfileEvent_PerfMinEnabledRunningTime ['new'] ['UInt64']
metric_log ProfileEvent_PerfDataTLBReferences ['new'] ['UInt64']
metric_log ProfileEvent_PerfDataTLBMisses ['new'] ['UInt64']
metric_log ProfileEvent_PerfInstructionTLBReferences ['new'] ['UInt64']
metric_log ProfileEvent_PerfInstructionTLBMisses ['new'] ['UInt64']
metric_log ProfileEvent_PerfLocalMemoryReferences ['new'] ['UInt64']
metric_log ProfileEvent_PerfLocalMemoryMisses ['new'] ['UInt64']
metric_log ProfileEvent_CreatedLogEntryForMerge ['new'] ['UInt64']
metric_log ProfileEvent_NotCreatedLogEntryForMerge ['new'] ['UInt64']
metric_log ProfileEvent_CreatedLogEntryForMutation ['new'] ['UInt64']
metric_log ProfileEvent_NotCreatedLogEntryForMutation ['new'] ['UInt64']
metric_log ProfileEvent_S3ReadMicroseconds ['new'] ['UInt64']
metric_log ProfileEvent_S3ReadBytes ['new'] ['UInt64']
metric_log ProfileEvent_S3ReadRequestsCount ['new'] ['UInt64']
metric_log ProfileEvent_S3ReadRequestsErrors ['new'] ['UInt64']
metric_log ProfileEvent_S3ReadRequestsThrottling ['new'] ['UInt64']
metric_log ProfileEvent_S3ReadRequestsRedirects ['new'] ['UInt64']
metric_log ProfileEvent_S3WriteMicroseconds ['new'] ['UInt64']
metric_log ProfileEvent_S3WriteBytes ['new'] ['UInt64']
metric_log ProfileEvent_S3WriteRequestsCount ['new'] ['UInt64']
metric_log ProfileEvent_S3WriteRequestsErrors ['new'] ['UInt64']
metric_log ProfileEvent_S3WriteRequestsThrottling ['new'] ['UInt64']
metric_log ProfileEvent_S3WriteRequestsRedirects ['new'] ['UInt64']
metric_log ProfileEvent_QueryMemoryLimitExceeded ['new'] ['UInt64']
metric_log CurrentMetric_BackgroundFetchesPoolTask ['new'] ['Int64']
metric_log CurrentMetric_BackgroundMessageBrokerSchedulePoolTask ['new'] ['Int64']
metric_log CurrentMetric_PostgreSQLConnection ['new'] ['Int64']
metric_log CurrentMetric_TablesToDropQueueSize ['new'] ['Int64']
parts uuid ['new'] ['UUID']
parts delete_ttl_info_min ['new'] ['DateTime']
parts delete_ttl_info_max ['new'] ['DateTime']
parts move_ttl_info.expression ['new'] ['Array(String)']
parts move_ttl_info.min ['new'] ['Array(DateTime)']
parts move_ttl_info.max ['new'] ['Array(DateTime)']
parts default_compression_codec ['new'] ['String']
parts recompression_ttl_info.expression ['new'] ['Array(String)']
parts recompression_ttl_info.min ['new'] ['Array(DateTime)']
parts recompression_ttl_info.max ['new'] ['Array(DateTime)']
parts_columns column_position ['new'] ['UInt64']
privileges privilege ['new'] ['Enum8('SHOW DATABASES' = 0, 'SHOW TABLES' = 1, 'SHOW COLUMNS' = 2, 'SHOW DICTIONARIES' = 3, 'SHOW' = 4, 'SELECT' = 5, 'INSERT' = 6, 'ALTER UPDATE' = 7, 'ALTER DELETE' = 8, 'ALTER ADD COLUMN' = 9, 'ALTER MODIFY COLUMN' = 10, 'ALTER DROP COLUMN' = 11, 'ALTER COMMENT COLUMN' = 12, 'ALTER CLEAR COLUMN' = 13, 'ALTER RENAME COLUMN' = 14, 'ALTER COLUMN' = 15, 'ALTER ORDER BY' = 16, 'ALTER SAMPLE BY' = 17, 'ALTER ADD INDEX' = 18, 'ALTER DROP INDEX' = 19, 'ALTER MATERIALIZE INDEX' = 20, 'ALTER CLEAR INDEX' = 21, 'ALTER INDEX' = 22, 'ALTER ADD CONSTRAINT' = 23, 'ALTER DROP CONSTRAINT' = 24, 'ALTER CONSTRAINT' = 25, 'ALTER TTL' = 26, 'ALTER MATERIALIZE TTL' = 27, 'ALTER SETTINGS' = 28, 'ALTER MOVE PARTITION' = 29, 'ALTER FETCH PARTITION' = 30, 'ALTER FREEZE PARTITION' = 31, 'ALTER TABLE' = 32, 'ALTER VIEW REFRESH' = 33, 'ALTER VIEW MODIFY QUERY' = 34, 'ALTER VIEW' = 35, 'ALTER' = 36, 'CREATE DATABASE' = 37, 'CREATE TABLE' = 38, 'CREATE VIEW' = 39, 'CREATE DICTIONARY' = 40, 'CREATE TEMPORARY TABLE' = 41, 'CREATE' = 42, 'DROP DATABASE' = 43, 'DROP TABLE' = 44, 'DROP VIEW' = 45, 'DROP DICTIONARY' = 46, 'DROP' = 47, 'TRUNCATE' = 48, 'OPTIMIZE' = 49, 'KILL QUERY' = 50, 'CREATE USER' = 51, 'ALTER USER' = 52, 'DROP USER' = 53, 'CREATE ROLE' = 54, 'ALTER ROLE' = 55, 'DROP ROLE' = 56, 'ROLE ADMIN' = 57, 'CREATE ROW POLICY' = 58, 'ALTER ROW POLICY' = 59, 'DROP ROW POLICY' = 60, 'CREATE QUOTA' = 61, 'ALTER QUOTA' = 62, 'DROP QUOTA' = 63, 'CREATE SETTINGS PROFILE' = 64, 'ALTER SETTINGS PROFILE' = 65, 'DROP SETTINGS PROFILE' = 66, 'SHOW USERS' = 67, 'SHOW ROLES' = 68, 'SHOW ROW POLICIES' = 69, 'SHOW QUOTAS' = 70, 'SHOW SETTINGS PROFILES' = 71, 'SHOW ACCESS' = 72, 'ACCESS MANAGEMENT' = 73, 'SYSTEM SHUTDOWN' = 74, 'SYSTEM DROP DNS CACHE' = 75, 'SYSTEM DROP MARK CACHE' = 76, 'SYSTEM DROP UNCOMPRESSED CACHE' = 77, 'SYSTEM DROP COMPILED EXPRESSION CACHE' = 78, 'SYSTEM DROP CACHE' = 79, 'SYSTEM RELOAD CONFIG' = 80, 'SYSTEM RELOAD DICTIONARY' = 81, 'SYSTEM RELOAD EMBEDDED DICTIONARIES' = 82, 'SYSTEM RELOAD' = 83, 'SYSTEM MERGES' = 84, 'SYSTEM TTL MERGES' = 85, 'SYSTEM FETCHES' = 86, 'SYSTEM MOVES' = 87, 'SYSTEM DISTRIBUTED SENDS' = 88, 'SYSTEM REPLICATED SENDS' = 89, 'SYSTEM SENDS' = 90, 'SYSTEM REPLICATION QUEUES' = 91, 'SYSTEM DROP REPLICA' = 92, 'SYSTEM SYNC REPLICA' = 93, 'SYSTEM RESTART REPLICA' = 94, 'SYSTEM FLUSH DISTRIBUTED' = 95, 'SYSTEM FLUSH LOGS' = 96, 'SYSTEM FLUSH' = 97, 'SYSTEM' = 98, 'dictGet' = 99, 'addressToLine' = 100, 'addressToSymbol' = 101, 'demangle' = 102, 'INTROSPECTION' = 103, 'FILE' = 104, 'URL' = 105, 'REMOTE' = 106, 'MONGO' = 107, 'MYSQL' = 108, 'ODBC' = 109, 'JDBC' = 110, 'HDFS' = 111, 'S3' = 112, 'SOURCES' = 113, 'ALL' = 114, 'NONE' = 115)']
privileges aliases ['new'] ['Array(String)']
privileges level ['new'] ['Nullable(Enum8('GLOBAL' = 0, 'DATABASE' = 1, 'TABLE' = 2, 'DICTIONARY' = 3, 'VIEW' = 4, 'COLUMN' = 5))']
privileges parent_group ['new'] ['Nullable(Enum8('SHOW DATABASES' = 0, 'SHOW TABLES' = 1, 'SHOW COLUMNS' = 2, 'SHOW DICTIONARIES' = 3, 'SHOW' = 4, 'SELECT' = 5, 'INSERT' = 6, 'ALTER UPDATE' = 7, 'ALTER DELETE' = 8, 'ALTER ADD COLUMN' = 9, 'ALTER MODIFY COLUMN' = 10, 'ALTER DROP COLUMN' = 11, 'ALTER COMMENT COLUMN' = 12, 'ALTER CLEAR COLUMN' = 13, 'ALTER RENAME COLUMN' = 14, 'ALTER COLUMN' = 15, 'ALTER ORDER BY' = 16, 'ALTER SAMPLE BY' = 17, 'ALTER ADD INDEX' = 18, 'ALTER DROP INDEX' = 19, 'ALTER MATERIALIZE INDEX' = 20, 'ALTER CLEAR INDEX' = 21, 'ALTER INDEX' = 22, 'ALTER ADD CONSTRAINT' = 23, 'ALTER DROP CONSTRAINT' = 24, 'ALTER CONSTRAINT' = 25, 'ALTER TTL' = 26, 'ALTER MATERIALIZE TTL' = 27, 'ALTER SETTINGS' = 28, 'ALTER MOVE PARTITION' = 29, 'ALTER FETCH PARTITION' = 30, 'ALTER FREEZE PARTITION' = 31, 'ALTER TABLE' = 32, 'ALTER VIEW REFRESH' = 33, 'ALTER VIEW MODIFY QUERY' = 34, 'ALTER VIEW' = 35, 'ALTER' = 36, 'CREATE DATABASE' = 37, 'CREATE TABLE' = 38, 'CREATE VIEW' = 39, 'CREATE DICTIONARY' = 40, 'CREATE TEMPORARY TABLE' = 41, 'CREATE' = 42, 'DROP DATABASE' = 43, 'DROP TABLE' = 44, 'DROP VIEW' = 45, 'DROP DICTIONARY' = 46, 'DROP' = 47, 'TRUNCATE' = 48, 'OPTIMIZE' = 49, 'KILL QUERY' = 50, 'CREATE USER' = 51, 'ALTER USER' = 52, 'DROP USER' = 53, 'CREATE ROLE' = 54, 'ALTER ROLE' = 55, 'DROP ROLE' = 56, 'ROLE ADMIN' = 57, 'CREATE ROW POLICY' = 58, 'ALTER ROW POLICY' = 59, 'DROP ROW POLICY' = 60, 'CREATE QUOTA' = 61, 'ALTER QUOTA' = 62, 'DROP QUOTA' = 63, 'CREATE SETTINGS PROFILE' = 64, 'ALTER SETTINGS PROFILE' = 65, 'DROP SETTINGS PROFILE' = 66, 'SHOW USERS' = 67, 'SHOW ROLES' = 68, 'SHOW ROW POLICIES' = 69, 'SHOW QUOTAS' = 70, 'SHOW SETTINGS PROFILES' = 71, 'SHOW ACCESS' = 72, 'ACCESS MANAGEMENT' = 73, 'SYSTEM SHUTDOWN' = 74, 'SYSTEM DROP DNS CACHE' = 75, 'SYSTEM DROP MARK CACHE' = 76, 'SYSTEM DROP UNCOMPRESSED CACHE' = 77, 'SYSTEM DROP COMPILED EXPRESSION CACHE' = 78, 'SYSTEM DROP CACHE' = 79, 'SYSTEM RELOAD CONFIG' = 80, 'SYSTEM RELOAD DICTIONARY' = 81, 'SYSTEM RELOAD EMBEDDED DICTIONARIES' = 82, 'SYSTEM RELOAD' = 83, 'SYSTEM MERGES' = 84, 'SYSTEM TTL MERGES' = 85, 'SYSTEM FETCHES' = 86, 'SYSTEM MOVES' = 87, 'SYSTEM DISTRIBUTED SENDS' = 88, 'SYSTEM REPLICATED SENDS' = 89, 'SYSTEM SENDS' = 90, 'SYSTEM REPLICATION QUEUES' = 91, 'SYSTEM DROP REPLICA' = 92, 'SYSTEM SYNC REPLICA' = 93, 'SYSTEM RESTART REPLICA' = 94, 'SYSTEM FLUSH DISTRIBUTED' = 95, 'SYSTEM FLUSH LOGS' = 96, 'SYSTEM FLUSH' = 97, 'SYSTEM' = 98, 'dictGet' = 99, 'addressToLine' = 100, 'addressToSymbol' = 101, 'demangle' = 102, 'INTROSPECTION' = 103, 'FILE' = 104, 'URL' = 105, 'REMOTE' = 106, 'MONGO' = 107, 'MYSQL' = 108, 'ODBC' = 109, 'JDBC' = 110, 'HDFS' = 111, 'S3' = 112, 'SOURCES' = 113, 'ALL' = 114, 'NONE' = 115))']
query_log event_time_microseconds ['new'] ['DateTime64(6)']
query_log query_start_time_microseconds ['new'] ['DateTime64(6)']
query_log current_database ['new'] ['String']
query_thread_log event_time_microseconds ['new'] ['DateTime64(6)']
query_thread_log query_start_time_microseconds ['new'] ['DateTime64(6)']
query_thread_log current_database ['new'] ['String']
quota_limits quota_name ['new'] ['String']
quota_limits duration ['new'] ['UInt32']
quota_limits is_randomized_interval ['new'] ['UInt8']
quota_limits max_queries ['new'] ['Nullable(UInt64)']
quota_limits max_errors ['new'] ['Nullable(UInt64)']
quota_limits max_result_rows ['new'] ['Nullable(UInt64)']
quota_limits max_result_bytes ['new'] ['Nullable(UInt64)']
quota_limits max_read_rows ['new'] ['Nullable(UInt64)']
quota_limits max_read_bytes ['new'] ['Nullable(UInt64)']
quota_limits max_execution_time ['new'] ['Nullable(Float64)']
quota_usage name ['old'] ['String']
quota_usage id ['old'] ['UUID']
quota_usage key ['old'] ['String']
quota_usage duration ['new','old'] ['Nullable(UInt32)','Nullable(UInt64)']
quota_usage end_of_interval ['old'] ['Nullable(DateTime)']
quota_usage quota_name ['new'] ['String']
quota_usage quota_key ['new'] ['String']
quota_usage start_time ['new'] ['Nullable(DateTime)']
quota_usage end_time ['new'] ['Nullable(DateTime)']
quotas source ['old'] ['String']
quotas key_type ['old'] ['Enum8('none' = 0, 'user name' = 1, 'ip address' = 2, 'client key' = 3, 'client key or user name' = 4, 'client key or ip address' = 5)']
quotas roles ['old'] ['Array(String)']
quotas intervals.duration ['old'] ['Array(UInt64)']
quotas intervals.randomize_interval ['old'] ['Array(UInt8)']
quotas intervals.max_queries ['old'] ['Array(UInt64)']
quotas intervals.max_errors ['old'] ['Array(UInt64)']
quotas intervals.max_result_rows ['old'] ['Array(UInt64)']
quotas intervals.max_result_bytes ['old'] ['Array(UInt64)']
quotas intervals.max_read_rows ['old'] ['Array(UInt64)']
quotas intervals.max_read_bytes ['old'] ['Array(UInt64)']
quotas intervals.max_execution_time ['old'] ['Array(Float64)']
quotas storage ['new'] ['String']
quotas keys ['new'] ['Array(Enum8('user_name' = 1, 'ip_address' = 2, 'client_key' = 3))']
quotas durations ['new'] ['Array(UInt32)']
quotas apply_to_all ['new'] ['UInt8']
quotas apply_to_list ['new'] ['Array(String)']
quotas apply_to_except ['new'] ['Array(String)']
quotas_usage quota_name ['new'] ['String']
quotas_usage quota_key ['new'] ['String']
quotas_usage is_current ['new'] ['UInt8']
quotas_usage start_time ['new'] ['Nullable(DateTime)']
quotas_usage end_time ['new'] ['Nullable(DateTime)']
quotas_usage duration ['new'] ['Nullable(UInt32)']
quotas_usage queries ['new'] ['Nullable(UInt64)']
quotas_usage max_queries ['new'] ['Nullable(UInt64)']
quotas_usage errors ['new'] ['Nullable(UInt64)']
quotas_usage max_errors ['new'] ['Nullable(UInt64)']
quotas_usage result_rows ['new'] ['Nullable(UInt64)']
quotas_usage max_result_rows ['new'] ['Nullable(UInt64)']
quotas_usage result_bytes ['new'] ['Nullable(UInt64)']
quotas_usage max_result_bytes ['new'] ['Nullable(UInt64)']
quotas_usage read_rows ['new'] ['Nullable(UInt64)']
quotas_usage max_read_rows ['new'] ['Nullable(UInt64)']
quotas_usage read_bytes ['new'] ['Nullable(UInt64)']
quotas_usage max_read_bytes ['new'] ['Nullable(UInt64)']
quotas_usage execution_time ['new'] ['Nullable(Float64)']
quotas_usage max_execution_time ['new'] ['Nullable(Float64)']
replicated_fetches database ['new'] ['String']
replicated_fetches table ['new'] ['String']
replicated_fetches elapsed ['new'] ['Float64']
replicated_fetches progress ['new'] ['Float64']
replicated_fetches result_part_name ['new'] ['String']
replicated_fetches result_part_path ['new'] ['String']
replicated_fetches partition_id ['new'] ['String']
replicated_fetches total_size_bytes_compressed ['new'] ['UInt64']
replicated_fetches bytes_read_compressed ['new'] ['UInt64']
replicated_fetches source_replica_path ['new'] ['String']
replicated_fetches source_replica_hostname ['new'] ['String']
replicated_fetches source_replica_port ['new'] ['UInt16']
replicated_fetches interserver_scheme ['new'] ['String']
replicated_fetches URI ['new'] ['String']
replicated_fetches to_detached ['new'] ['UInt8']
replicated_fetches thread_id ['new'] ['UInt64']
replicated_merge_tree_settings name ['new'] ['String']
replicated_merge_tree_settings value ['new'] ['String']
replicated_merge_tree_settings changed ['new'] ['UInt8']
replicated_merge_tree_settings description ['new'] ['String']
replicated_merge_tree_settings type ['new'] ['String']
replication_queue merge_type ['new'] ['String']
role_grants user_name ['new'] ['Nullable(String)']
role_grants role_name ['new'] ['Nullable(String)']
role_grants granted_role_name ['new'] ['String']
role_grants granted_role_is_default ['new'] ['UInt8']
role_grants with_admin_option ['new'] ['UInt8']
roles name ['new'] ['String']
roles id ['new'] ['UUID']
roles storage ['new'] ['String']
row_policies full_name ['old'] ['String']
row_policies source ['old'] ['String']
row_policies restrictive ['old'] ['UInt8']
row_policies select_filter ['new','old'] ['Nullable(String)','String']
row_policies insert_check ['old'] ['String']
row_policies update_filter ['old'] ['String']
row_policies update_check ['old'] ['String']
row_policies delete_filter ['old'] ['String']
row_policies short_name ['new'] ['String']
row_policies storage ['new'] ['String']
row_policies is_restrictive ['new'] ['UInt8']
row_policies apply_to_all ['new'] ['UInt8']
row_policies apply_to_list ['new'] ['Array(String)']
row_policies apply_to_except ['new'] ['Array(String)']
settings_profile_elements profile_name ['new'] ['Nullable(String)']
settings_profile_elements user_name ['new'] ['Nullable(String)']
settings_profile_elements role_name ['new'] ['Nullable(String)']
settings_profile_elements index ['new'] ['UInt64']
settings_profile_elements setting_name ['new'] ['Nullable(String)']
settings_profile_elements value ['new'] ['Nullable(String)']
settings_profile_elements min ['new'] ['Nullable(String)']
settings_profile_elements max ['new'] ['Nullable(String)']
settings_profile_elements readonly ['new'] ['Nullable(UInt8)']
settings_profile_elements inherit_profile ['new'] ['Nullable(String)']
settings_profiles name ['new'] ['String']
settings_profiles id ['new'] ['UUID']
settings_profiles storage ['new'] ['String']
settings_profiles num_elements ['new'] ['UInt64']
settings_profiles apply_to_all ['new'] ['UInt8']
settings_profiles apply_to_list ['new'] ['Array(String)']
settings_profiles apply_to_except ['new'] ['Array(String)']
storage_policies volume_type ['new'] ['String']
storage_policies prefer_not_to_merge ['new'] ['UInt8']
tables lifetime_rows ['new'] ['Nullable(UInt64)']
tables lifetime_bytes ['new'] ['Nullable(UInt64)']
time_zones time_zone ['new'] ['String']
trace_log trace_type ['new','old'] ['Enum8('Real' = 0, 'CPU' = 1, 'Memory' = 2, 'MemorySample' = 3)','Enum8('Real' = 0, 'CPU' = 1, 'Memory' = 2)']
trace_log size ['new','old'] ['Int64','UInt64']
trace_log event_time_microseconds ['new'] ['DateTime64(6)']
user_directories name ['new'] ['String']
user_directories type ['new'] ['String']
user_directories params ['new'] ['String']
user_directories precedence ['new'] ['UInt64']
users name ['new'] ['String']
users id ['new'] ['UUID']
users storage ['new'] ['String']
users auth_type ['new'] ['Enum8('no_password' = 0, 'plaintext_password' = 1, 'sha256_password' = 2, 'double_sha1_password' = 3, 'ldap_server' = 4)']
users auth_params ['new'] ['String']
users host_ip ['new'] ['Array(String)']
users host_names ['new'] ['Array(String)']
users host_names_regexp ['new'] ['Array(String)']
users host_names_like ['new'] ['Array(String)']
users default_roles_all ['new'] ['UInt8']
users default_roles_list ['new'] ['Array(String)']
users default_roles_except ['new'] ['Array(String)']

settings and merge_tree_settings

source name old_value new_value new_description
merge_tree_settings allow_nullable_key 0 Allow Nullable types as primary keys.
merge_tree_settings assign_part_uuids 0 Generate UUIDs for parts. Before enabling check that all replicas support new format.
merge_tree_settings detach_old_local_parts_when_cloning_replica 1 Do not remove old local parts when repairing lost replica.
merge_tree_settings enable_mixed_granularity_parts 0 1 Enable parts with adaptive and non adaptive granularity
merge_tree_settings execute_merges_on_single_replica_time_threshold 0 When greater than zero only a single replica starts the merge immediately, others wait up to that amount of time to download the result instead of doing merges locally. If the chosen replica doesn't finish the merge during that amount of time, fallback to standard behavior happens.
merge_tree_settings fsync_after_insert 0 Do fsync for every inserted part. Significantly decreases performance of inserts, not recommended to use with wide parts.
merge_tree_settings fsync_part_directory 0 Do fsync for part directory after all part operations (writes, renames, etc.).
merge_tree_settings in_memory_parts_enable_wal 1 Whether to write blocks in Native format to write-ahead-log before creation in-memory part
merge_tree_settings in_memory_parts_insert_sync 0 If true insert of part with in-memory format will wait for fsync of WAL
merge_tree_settings max_number_of_merges_with_ttl_in_pool 2 When there is more than specified number of merges with TTL entries in pool, do not assign new merge with TTL. This is to leave free threads for regular merges and avoid "Too many parts"
merge_tree_settings max_part_loading_threads auto(6) 'auto(6)' The number of threads to load data parts at startup.
merge_tree_settings max_part_removal_threads auto(6) 'auto(6)' The number of threads for concurrent removal of inactive data parts. One is usually enough, but in 'Google Compute Environment SSD Persistent Disks' file removal (unlink) operation is extraordinarily slow and you probably have to increase this number (recommended is up to 16).
merge_tree_settings max_replicated_logs_to_keep 10000 1000 How many records may be in log, if there is inactive replica. Inactive replica becomes lost when when this number exceed.
merge_tree_settings max_replicated_merges_with_ttl_in_queue 1 How many tasks of merging parts with TTL are allowed simultaneously in ReplicatedMergeTree queue.
merge_tree_settings merge_with_recompression_ttl_timeout 14400 Minimal time in seconds, when merge with recompression TTL can be repeated.
merge_tree_settings merge_with_ttl_timeout 86400 14400 Minimal time in seconds, when merge with delete TTL can be repeated.
merge_tree_settings min_bytes_for_compact_part 0 Experimental. Minimal uncompressed size in bytes to create part in compact format instead of saving it in RAM
merge_tree_settings min_bytes_for_wide_part 0 10485760 Minimal uncompressed size in bytes to create part in wide format instead of compact
merge_tree_settings min_compressed_bytes_to_fsync_after_fetch 0 Minimal number of compressed bytes to do fsync for part after fetch (0 - disabled)
merge_tree_settings min_compressed_bytes_to_fsync_after_merge 0 Minimal number of compressed bytes to do fsync for part after merge (0 - disabled)
merge_tree_settings min_index_granularity_bytes 1024 Minimum amount of bytes in single granule.
merge_tree_settings min_relative_delay_to_measure 120 Calculate relative replica delay only if absolute delay is not less that this value.
merge_tree_settings min_replicated_logs_to_keep 100 10 Keep about this number of last records in ZooKeeper log, even if they are obsolete. It doesn't affect work of tables: used only to diagnose ZooKeeper log before cleaning.
merge_tree_settings min_rows_for_compact_part 0 Experimental. Minimal number of rows to create part in compact format instead of saving it in RAM
merge_tree_settings min_rows_to_fsync_after_merge 0 Minimal number of rows to do fsync for part after merge (0 - disabled)
merge_tree_settings randomize_part_type 0 For testing purposes only. Randomizes part type between wide and compact
merge_tree_settings remove_empty_parts 1 Remove empty parts after they were pruned by TTL, mutation, or collapsing merge algorithm
merge_tree_settings try_fetch_recompressed_part_timeout 7200 Recompression works slow in most cases, so we don't start merge with recompression until this timeout and trying to fetch recompressed part from replica which assigned this merge with recompression.
merge_tree_settings write_ahead_log_bytes_to_fsync 104857600 Amount of bytes, accumulated in WAL to do fsync.
merge_tree_settings write_ahead_log_interval_ms_to_fsync 100 Interval in milliseconds after which fsync for WAL is being done.
merge_tree_settings write_ahead_log_max_bytes 1073741824 Rotate WAL, if it exceeds that amount of bytes
settings aggregate_functions_null_for_empty 0 Rewrite all aggregate functions in a query, adding -OrNull suffix to them
settings allow_experimental_bigint_types 0 Allow Int128, Int256, UInt256 and Decimal256 types
settings allow_experimental_cross_to_join_conversion 1
settings allow_experimental_data_skipping_indices 1
settings allow_experimental_database_atomic 0 1 Obsolete setting, does nothing. Will be removed after 2021-02-12
settings allow_experimental_database_materialize_mysql 0 Allow to create database with Engine=MaterializeMySQL(...).
settings allow_experimental_geo_types 0 Allow geo data types such as Point, Ring, Polygon, MultiPolygon
settings allow_experimental_low_cardinality_type 1
settings allow_experimental_multiple_joins_emulation 1
settings allow_non_metadata_alters 1 Allow to execute alters which affects not only tables metadata, but also data on disk
settings allow_nondeterministic_optimize_skip_unused_shards 0 Allow non-deterministic functions (includes dictGet) in sharding_key for optimize_skip_unused_shards
settings allow_push_predicate_when_subquery_contains_with 1 Allows push predicate when subquery contains WITH clause
settings allow_suspicious_codecs 0 If it is set to true, allow to specify meaningless compression codecs.
settings alter_partition_verbose_result 0 Output information about affected parts. Currently works only for FREEZE and ATTACH commands.
settings background_fetches_pool_size 3 Number of threads performing background fetches for replicated tables. Only has meaning at server startup.
settings background_message_broker_schedule_pool_size 16 Number of threads performing background tasks for message streaming. Only has meaning at server startup.
settings cast_keep_nullable 0 CAST operator keep Nullable for result data type
settings compile 0
settings data_type_default_nullable 0 Data types without NULL or NOT NULL will make Nullable
settings database_atomic_wait_for_drop_and_detach_synchronously 0 When executing DROP or DETACH TABLE in Atomic database, wait for table data to be finally dropped or detached.
settings date_time_output_format simple Method to write DateTime to text output. Possible values: 'simple', 'iso', 'unix_timestamp'.
settings default_database_engine Ordinary Atomic Default database engine.
settings distributed_replica_max_ignored_errors 0 Number of errors that will be ignored while choosing replicas
settings do_not_merge_across_partitions_select_final 0 Merge parts only in one partition in select final
settings enable_global_with_statement 0 Propagate WITH statements to UNION queries and all subqueries
settings force_data_skipping_indices Comma separated list of strings or literals with the name of the data skipping indices that should be used during query execution, otherwise an exception will be thrown.
settings force_optimize_skip_unused_shards_nesting 0 Same as force_optimize_skip_unused_shards, but accept nesting level until which it will work.
settings format_regexp_escaping_rule Escaped Raw Field escaping rule (for Regexp format)
settings function_implementation Choose function implementation for specific target or variant (experimental). If empty enable all of them.
settings input_format_avro_allow_missing_fields 0 For Avro/AvroConfluent format: when field is not found in schema use default value instead of error
settings input_format_csv_enum_as_number 0 Treat inserted enum values in CSV formats as enum indices \N
settings input_format_tsv_enum_as_number 0 Treat inserted enum values in TSV formats as enum indices \N
settings input_format_with_names_use_header 0 1 For TSVWithNames and CSVWithNames input formats this controls whether format parser is to assume that column data appear in the input exactly as they are specified in the header.
settings insert_in_memory_parts_timeout 600000
settings insert_quorum_parallel 0 For quorum INSERT queries - enable to make parallel inserts without linearizability
settings load_balancing_first_offset 0 Which replica to preferably send a query when FIRST_OR_RANDOM load balancing strategy is used.
settings log_queries_min_query_duration_ms 0 Minimal time for the query to run, to get to the query_log/query_thread_log.
settings mark_cache_min_lifetime 0
settings materialize_ttl_after_modify 1 Apply TTL for old data, after ALTER MODIFY TTL query
settings max_alter_threads auto(6) 'auto(6)' The maximum number of threads to execute the ALTER requests. By default, it is determined automatically.
settings max_block_size 65536 65505 Maximum block size for reading
settings max_bytes_to_read_leaf 0 Limit on read bytes (after decompression) on the leaf nodes for distributed queries. Limit is applied for local reads only excluding the final merge stage on the root node.
settings max_concurrent_queries_for_all_users 0 The maximum number of concurrent requests for all users.
settings max_final_threads 16 The maximum number of threads to read from table with FINAL.
settings max_insert_block_size 1048576 1048545 The maximum block size for insertion, if we control the creation of blocks for insertion.
settings max_joined_block_size_rows 65536 65505 Maximum block size for JOIN result (if join algorithm supports it). 0 means unlimited.
settings max_rows_to_read_leaf 0 Limit on read rows on the leaf nodes for distributed queries. Limit is applied for local reads only excluding the final merge stage on the root node.
settings max_threads auto(6) 'auto(6)' The maximum number of threads to execute the request. By default, it is determined automatically.
settings max_untracked_memory 4194304 Small allocations and deallocations are grouped in thread local variable and tracked or profiled only when amount (in absolute value) becomes larger than specified value. If the value is higher than 'memory_profiler_step' it will be effectively lowered to 'memory_profiler_step'.
settings memory_profiler_sample_probability 0 Collect random allocations and deallocations and write them into system.trace_log with 'MemorySample' trace_type. The probability is for every alloc/free regardless to the size of the allocation. Note that sampling happens only when the amount of untracked memory exceeds 'max_untracked_memory'. You may want to set 'max_untracked_memory' to 0 for extra fine grained sampling.
settings merge_tree_uniform_read_distribution 1
settings metrics_perf_events_enabled 0 If enabled, some of the perf events will be measured throughout queries' execution.
settings metrics_perf_events_list Comma separated list of perf metrics that will be measured throughout queries' execution. Empty means all events. See PerfEventInfo in sources for the available events.
settings min_chunk_bytes_for_parallel_parsing 1048576 10485760 The minimum chunk size in bytes, which each thread will parse in parallel.
settings min_count_to_compile 0
settings min_insert_block_size_bytes 268435456 268427520 Squash blocks passed to INSERT query to specified size in bytes, if blocks are not big enough.
settings min_insert_block_size_bytes_for_materialized_views 0 Like min_insert_block_size_bytes, but applied only during pushing to MATERIALIZED VIEW (default: min_insert_block_size_bytes)
settings min_insert_block_size_rows 1048576 1048545 Squash blocks passed to INSERT query to specified size in rows, if blocks are not big enough.
settings min_insert_block_size_rows_for_materialized_views 0 Like min_insert_block_size_rows, but applied only during pushing to MATERIALIZED VIEW (default: min_insert_block_size_rows)
settings multiple_joins_rewriter_version 1 0 Obsolete setting, does nothing. Will be removed after 2021-03-31
settings mysql_datatypes_support_level Which MySQL types should be converted to corresponding ClickHouse types (rather than being represented as String). Can be empty or any combination of 'decimal' or 'datetime64'. When empty MySQL's DECIMAL and DATETIME/TIMESTAMP with non-zero precision are seen as String on ClickHouse's side.
settings opentelemetry_start_trace_probability 0 Probability to start an OpenTelemetry trace for an incoming query.
settings optimize_aggregation_in_order 0 Enable GROUP BY optimization for aggregating data in corresponding order in MergeTree tables.
settings optimize_aggregators_of_group_by_keys 1 Eliminates min/max/any/anyLast aggregators of GROUP BY keys in SELECT section
settings optimize_arithmetic_operations_in_aggregate_functions 1 Move arithmetic operations out of aggregation functions
settings optimize_duplicate_order_by_and_distinct 1 Remove duplicate ORDER BY and DISTINCT if it's possible
settings optimize_group_by_function_keys 1 Eliminates functions of other keys in GROUP BY section
settings optimize_if_chain_to_miltiif 0
settings optimize_if_chain_to_multiif 0 Replace if(cond1, then1, if(cond2, ...)) chains to multiIf. Currently it's not beneficial for numeric types.
settings optimize_if_transform_strings_to_enum 0 Replaces string-type arguments in If and Transform to enum. Disabled by default cause it could make inconsistent change in distributed query that would lead to its fail.
settings optimize_injective_functions_inside_uniq 1 Delete injective functions of one argument inside uniq*() functions.
settings optimize_monotonous_functions_in_order_by 1 Replace monotonous function with its argument in ORDER BY
settings optimize_move_functions_out_of_any 0 Move functions out of aggregate functions 'any', 'anyLast'.
settings optimize_redundant_functions_in_order_by 1 Remove functions from ORDER BY if its argument is also in ORDER BY
settings optimize_skip_unused_shards_nesting 0 Same as optimize_skip_unused_shards, but accept nesting level until which it will work.
settings optimize_trivial_insert_select 1 Optimize trivial 'INSERT INTO table SELECT ... FROM TABLES' query
settings output_format_enable_streaming 0 Enable streaming in output formats that support it.
settings output_format_json_array_of_rows 0 Output a JSON array of all rows in JSONEachRow(Compact) format.
settings output_format_json_named_tuples_as_objects 0 Serialize named tuple columns as JSON objects.
settings output_format_pretty_grid_charset UTF-8 Charset for printing grid borders. Available charsets: ASCII, UTF-8 (default one).
settings output_format_pretty_max_value_width 10000 Maximum width of value to display in Pretty formats. If greater - it will be cut.
settings output_format_pretty_row_numbers 0 Add row numbers before each row for pretty output format
settings output_format_tsv_null_representation \N Custom NULL representation in TSV format
settings partial_merge_join 0
settings partial_merge_join_left_table_buffer_bytes 32000000 If not 0 group left table blocks in bigger ones for left-side table in partial merge join. It uses up to 2x of specified memory per joining thread. In current version work only with 'partial_merge_join_optimizations = 1'.
settings rabbitmq_max_wait_ms 5000 The wait time for reading from RabbitMQ before retry.
settings read_backoff_min_concurrency 1 Settings to try keeping the minimal number of threads in case of slow reads.
settings read_in_order_two_level_merge_threshold 100 Minimal number of parts to read to run preliminary merge step during multithread reading in order of primary key.
settings read_overflow_mode_leaf throw What to do when the leaf limit is exceeded.
settings send_logs_level none fatal Send server text logs with specified minimum level to client. Valid values: 'trace', 'debug', 'information', 'warning', 'error', 'fatal', 'none'
settings show_table_uuid_in_table_create_query_if_not_nil 1 0 For tables in databases with Engine=Atomic show UUID of the table in its CREATE query.
settings system_events_show_zero_values 0 Include all metrics, even with zero values
settings timeout_before_checking_execution_speed 0 10 Check that the speed is not too low after the specified time has elapsed.
settings use_compact_format_in_distributed_parts_names 0 1 Changes format of directories names for distributed table insert parts.

Other

source name groupArray(version)
aggregate_function_combinators Distinct ['new']
asynchronous_metrics CompiledExpressionCacheCount ['old']
asynchronous_metrics MarkCacheBytes ['old']
asynchronous_metrics MarkCacheFiles ['old']
asynchronous_metrics MaxPartCountForPartition ['old']
asynchronous_metrics MemoryCode ['old']
asynchronous_metrics MemoryDataAndStack ['old']
asynchronous_metrics MemoryResident ['old']
asynchronous_metrics MemoryShared ['old']
asynchronous_metrics MemoryVirtual ['old']
asynchronous_metrics NumberOfDatabases ['old']
asynchronous_metrics NumberOfTables ['old']
asynchronous_metrics ReplicasMaxAbsoluteDelay ['old']
asynchronous_metrics ReplicasMaxInsertsInQueue ['old']
asynchronous_metrics ReplicasMaxMergesInQueue ['old']
asynchronous_metrics ReplicasMaxQueueSize ['old']
asynchronous_metrics ReplicasMaxRelativeDelay ['old']
asynchronous_metrics ReplicasSumInsertsInQueue ['old']
asynchronous_metrics ReplicasSumMergesInQueue ['old']
asynchronous_metrics ReplicasSumQueueSize ['old']
asynchronous_metrics UncompressedCacheBytes ['old']
asynchronous_metrics UncompressedCacheCells ['old']
asynchronous_metrics Uptime ['old']
asynchronous_metrics jemalloc.active ['old']
asynchronous_metrics jemalloc.allocated ['old']
asynchronous_metrics jemalloc.background_thread.num_runs ['old']
asynchronous_metrics jemalloc.background_thread.num_threads ['old']
asynchronous_metrics jemalloc.background_thread.run_interval ['old']
asynchronous_metrics jemalloc.mapped ['old']
asynchronous_metrics jemalloc.metadata ['old']
asynchronous_metrics jemalloc.metadata_thp ['old']
asynchronous_metrics jemalloc.resident ['old']
asynchronous_metrics jemalloc.retained ['old']
data_type_families BIGINT SIGNED ['new']
data_type_families BIGINT UNSIGNED ['new']
data_type_families BINARY LARGE OBJECT ['new']
data_type_families BINARY VARYING ['new']
data_type_families BOOL ['new']
data_type_families BOOLEAN ['new']
data_type_families BYTE ['new']
data_type_families BYTEA ['new']
data_type_families CHAR LARGE OBJECT ['new']
data_type_families CHAR VARYING ['new']
data_type_families CHARACTER ['new']
data_type_families CHARACTER LARGE OBJECT ['new']
data_type_families CHARACTER VARYING ['new']
data_type_families CLOB ['new']
data_type_families DOUBLE PRECISION ['new']
data_type_families DateTime32 ['new']
data_type_families Decimal256 ['new']
data_type_families FIXED ['new']
data_type_families INET4 ['new']
data_type_families INET6 ['new']
data_type_families INT SIGNED ['new']
data_type_families INT UNSIGNED ['new']
data_type_families INT1 ['new']
data_type_families INT1 SIGNED ['new']
data_type_families INT1 UNSIGNED ['new']
data_type_families INTEGER SIGNED ['new']
data_type_families INTEGER UNSIGNED ['new']
data_type_families Int128 ['new']
data_type_families Int256 ['new']
data_type_families MEDIUMINT ['new']
data_type_families MEDIUMINT SIGNED ['new']
data_type_families MEDIUMINT UNSIGNED ['new']
data_type_families MultiPolygon ['new']
data_type_families NATIONAL CHAR ['new']
data_type_families NATIONAL CHAR VARYING ['new']
data_type_families NATIONAL CHARACTER ['new']
data_type_families NATIONAL CHARACTER LARGE OBJECT ['new']
data_type_families NATIONAL CHARACTER VARYING ['new']
data_type_families NCHAR ['new']
data_type_families NCHAR LARGE OBJECT ['new']
data_type_families NCHAR VARYING ['new']
data_type_families NUMERIC ['new']
data_type_families NVARCHAR ['new']
data_type_families Point ['new']
data_type_families Polygon ['new']
data_type_families REAL ['new']
data_type_families Ring ['new']
data_type_families SINGLE ['new']
data_type_families SMALLINT SIGNED ['new']
data_type_families SMALLINT UNSIGNED ['new']
data_type_families TINYINT SIGNED ['new']
data_type_families TINYINT UNSIGNED ['new']
data_type_families UInt256 ['new']
data_type_families VARCHAR2 ['new']
events ArenaAllocBytes ['old']
events ArenaAllocChunks ['old']
events HardPageFaults ['old']
events OSCPUVirtualTimeMicroseconds ['new']
events OSCPUWaitMicroseconds ['new']
events OSReadChars ['new']
events OSWriteBytes ['new']
events OSWriteChars ['new']
events QueryTimeMicroseconds ['new']
events RWLockReadersWaitMilliseconds ['new']
events SelectQueryTimeMicroseconds ['new']
events SelectedBytes ['new']
events SelectedRows ['new']
events TableFunctionExecute ['old']
formats Arrow ['new']
formats ArrowStream ['new']
formats JSONAsString ['new']
formats JSONCompactStrings ['new']
formats JSONCompactStringsEachRow ['new']
formats JSONCompactStringsEachRowWithNamesAndTypes ['new']
formats JSONStrings ['new']
formats JSONStringsEachRow ['new']
formats JSONStringsEachRowWithProgress ['new']
formats LineAsString ['new']
formats ODBCDriver ['old']
formats PostgreSQLWire ['new']
formats PrettyCompactMonoBlock ['new']
formats ProtobufSingle ['new']
formats RawBLOB ['new']
functions DATABASE ['new']
functions FROM_UNIXTIME ['new']
functions acosh ['new']
functions aes_decrypt_mysql ['new']
functions aes_encrypt_mysql ['new']
functions asinh ['new']
functions atan2 ['new']
functions atanh ['new']
functions bayesAB ['new']
functions buildId ['new']
functions cosh ['new']
functions countDigits ['new']
functions currentQuota ['old']
functions currentQuotaID ['old']
functions currentQuotaKey ['old']
functions currentRowPolicies ['old']
functions currentRowPolicyIDs ['old']
functions cutToFirstSignificantSubdomainWithWWW ['new']
functions dateTrunc ['new']
functions date_trunc ['new']
functions decrypt ['new']
functions defaultValueOfTypeName ['new']
functions encrypt ['new']
functions errorCodeToName ['new']
functions extractAllGroups ['new']
functions extractAllGroupsHorizontal ['new']
functions extractAllGroupsVertical ['new']
functions extractGroups ['new']
functions farmFingerprint64 ['new']
functions formatReadableQuantity ['new']
functions formatReadableTimeDelta ['new']
functions formatRow ['new']
functions formatRowNoNewline ['new']
functions fromUnixTimestamp ['new']
functions fromUnixTimestamp64Micro ['new']
functions fromUnixTimestamp64Milli ['new']
functions fromUnixTimestamp64Nano ['new']
functions fuzzBits ['new']
functions getSetting ['new']
functions globalVariable ['new']
functions hasSubstr ['new']
functions hasThreadFuzzer ['new']
functions hostname ['new']
functions hypot ['new']
functions ilike ['new']
functions initializeAggregation ['new']
functions isDecimalOverflow ['new']
functions isZeroOrNull ['new']
functions log1p ['new']
functions logTrace ['new']
functions mapAdd ['new']
functions mapPopulateSeries ['new']
functions mapSubtract ['new']
functions maxMap ['new']
functions medianExactHigh ['new']
functions medianExactLow ['new']
functions minMap ['new']
functions mod ['new']
functions netloc ['new']
functions normalizeQuery ['new']
functions normalizedQueryHash ['new']
functions notILike ['new']
functions parseDateTime32BestEffort ['new']
functions parseDateTime32BestEffortOrNull ['new']
functions parseDateTime32BestEffortOrZero ['new']
functions parseDateTimeBestEffortUS ['new']
functions port ['new']
functions quantileExactHigh ['new']
functions quantileExactLow ['new']
functions quantilesExactHigh ['new']
functions quantilesExactLow ['new']
functions rand32 ['new']
functions randomFixedString ['new']
functions randomString ['new']
functions randomStringUTF8 ['new']
functions rankCorr ['new']
functions reinterpretAsUUID ['new']
functions sinh ['new']
functions tcpPort ['new']
functions tid ['new']
functions toDateTime32 ['new']
functions toDecimal256 ['new']
functions toDecimal256OrNull ['new']
functions toDecimal256OrZero ['new']
functions toInt128 ['new']
functions toInt128OrNull ['new']
functions toInt128OrZero ['new']
functions toInt256 ['new']
functions toInt256OrNull ['new']
functions toInt256OrZero ['new']
functions toStartOfSecond ['new']
functions toUInt256 ['new']
functions toUInt256OrNull ['new']
functions toUInt256OrZero ['new']
functions toUUIDOrNull ['new']
functions toUUIDOrZero ['new']
functions toUnixTimestamp64Micro ['new']
functions toUnixTimestamp64Milli ['new']
functions toUnixTimestamp64Nano ['new']
metrics BackgroundFetchesPoolTask ['new']
metrics BackgroundMessageBrokerSchedulePoolTask ['new']
metrics LeaderElection ['old']
metrics LeaderReplica ['old']
metrics MemoryTrackingForMerges ['old']
metrics MemoryTrackingInBackgroundBufferFlushSchedulePool ['old']
metrics MemoryTrackingInBackgroundDistributedSchedulePool ['old']
metrics MemoryTrackingInBackgroundMoveProcessingPool ['old']
metrics MemoryTrackingInBackgroundProcessingPool ['old']
metrics MemoryTrackingInBackgroundSchedulePool ['old']
metrics PostgreSQLConnection ['new']
metrics TablesToDropQueueSize ['new']
table_engines COSN ['new']
table_engines EmbeddedRocksDB ['new']
table_engines MongoDB ['new']
table_engines RabbitMQ ['new']
table_functions cosn ['new']
table_functions null ['new']
table_functions view ['new']
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment