Materialize/test/sqllogictest/mz_catalog_server_index_accounting.slt

# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.

# The purpose of these tests is to dectect additions or changes of indexes
# on the mz_catalog_server cluster, including changes to underlying
# objects that are indexed.
# Rewrite this file automatically via --rewrite-results when it fails.

mode cockroach

statement ok
SET CLUSTER TO mz_catalog_server

# Record all indexes on the mz_catalog_server cluster and their definition.
# That way we can detect new or modified indexes.
query TT
SELECT DISTINCT name, create_sql
FROM mz_indexes
WHERE cluster_id =
  (SELECT id FROM mz_clusters WHERE name = 'mz_catalog_server')
ORDER BY 1, 2
----
mz_active_peeks_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_active_peeks_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_active_peeks_per_worker"␠("id",␠"worker_id")
mz_arrangement_batcher_allocations_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_batcher_allocations_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_batcher_allocations_raw"␠("operator_id",␠"worker_id")
mz_arrangement_batcher_capacity_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_batcher_capacity_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_batcher_capacity_raw"␠("operator_id",␠"worker_id")
mz_arrangement_batcher_records_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_batcher_records_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_batcher_records_raw"␠("operator_id",␠"worker_id")
mz_arrangement_batcher_size_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_batcher_size_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_batcher_size_raw"␠("operator_id",␠"worker_id")
mz_arrangement_batches_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_batches_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_batches_raw"␠("operator_id",␠"worker_id")
mz_arrangement_heap_allocations_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_heap_allocations_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_heap_allocations_raw"␠("operator_id",␠"worker_id")
mz_arrangement_heap_capacity_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_heap_capacity_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_heap_capacity_raw"␠("operator_id",␠"worker_id")
mz_arrangement_heap_size_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_heap_size_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_heap_size_raw"␠("operator_id",␠"worker_id")
mz_arrangement_records_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_records_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_records_raw"␠("operator_id",␠"worker_id")
mz_arrangement_sharing_raw_s2_primary_idx  CREATE␠INDEX␠"mz_arrangement_sharing_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_arrangement_sharing_raw"␠("operator_id",␠"worker_id")
mz_cluster_deployment_lineage_ind  CREATE␠INDEX␠"mz_cluster_deployment_lineage_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s728␠AS␠"mz_internal"."mz_cluster_deployment_lineage"]␠("cluster_id")
mz_cluster_replica_frontiers_ind  CREATE␠INDEX␠"mz_cluster_replica_frontiers_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s723␠AS␠"mz_catalog"."mz_cluster_replica_frontiers"]␠("object_id")
mz_cluster_replica_history_ind  CREATE␠INDEX␠"mz_cluster_replica_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s587␠AS␠"mz_internal"."mz_cluster_replica_history"]␠("dropped_at")
mz_cluster_replica_metrics_history_ind  CREATE␠INDEX␠"mz_cluster_replica_metrics_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s497␠AS␠"mz_internal"."mz_cluster_replica_metrics_history"]␠("replica_id")
mz_cluster_replica_metrics_ind  CREATE␠INDEX␠"mz_cluster_replica_metrics_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s498␠AS␠"mz_internal"."mz_cluster_replica_metrics"]␠("replica_id")
mz_cluster_replica_name_history_ind  CREATE␠INDEX␠"mz_cluster_replica_name_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s588␠AS␠"mz_internal"."mz_cluster_replica_name_history"]␠("id")
mz_cluster_replica_sizes_ind  CREATE␠INDEX␠"mz_cluster_replica_sizes_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s499␠AS␠"mz_catalog"."mz_cluster_replica_sizes"]␠("size")
mz_cluster_replica_status_history_ind  CREATE␠INDEX␠"mz_cluster_replica_status_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s500␠AS␠"mz_internal"."mz_cluster_replica_status_history"]␠("replica_id")
mz_cluster_replica_statuses_ind  CREATE␠INDEX␠"mz_cluster_replica_statuses_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s501␠AS␠"mz_internal"."mz_cluster_replica_statuses"]␠("replica_id")
mz_cluster_replicas_ind  CREATE␠INDEX␠"mz_cluster_replicas_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s496␠AS␠"mz_catalog"."mz_cluster_replicas"]␠("id")
mz_clusters_ind  CREATE␠INDEX␠"mz_clusters_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s490␠AS␠"mz_catalog"."mz_clusters"]␠("id")
mz_columns_ind  CREATE␠INDEX␠"mz_columns_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s462␠AS␠"mz_catalog"."mz_columns"]␠("name")
mz_comments_ind  CREATE␠INDEX␠"mz_comments_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s513␠AS␠"mz_internal"."mz_comments"]␠("id")
mz_compute_dataflow_global_ids_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_compute_dataflow_global_ids_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_dataflow_global_ids_per_worker"␠("id",␠"worker_id")
mz_compute_dependencies_ind  CREATE␠INDEX␠"mz_compute_dependencies_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s711␠AS␠"mz_internal"."mz_compute_dependencies"]␠("dependency_id")
mz_compute_error_counts_raw_s2_primary_idx  CREATE␠INDEX␠"mz_compute_error_counts_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_error_counts_raw"␠("export_id",␠"worker_id")
mz_compute_exports_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_compute_exports_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_exports_per_worker"␠("export_id",␠"worker_id")
mz_compute_frontiers_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_compute_frontiers_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_frontiers_per_worker"␠("export_id",␠"worker_id")
mz_compute_hydration_times_ind  CREATE␠INDEX␠"mz_compute_hydration_times_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s719␠AS␠"mz_internal"."mz_compute_hydration_times"]␠("replica_id")
mz_compute_hydration_times_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_compute_hydration_times_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_hydration_times_per_worker"␠("export_id",␠"worker_id")
mz_compute_import_frontiers_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_compute_import_frontiers_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_import_frontiers_per_worker"␠("export_id",␠"import_id",␠"worker_id")
mz_compute_lir_mapping_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_compute_lir_mapping_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_lir_mapping_per_worker"␠("global_id",␠"lir_id",␠"worker_id")
mz_compute_operator_durations_histogram_raw_s2_primary_idx  CREATE␠INDEX␠"mz_compute_operator_durations_histogram_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_compute_operator_durations_histogram_raw"␠("id",␠"worker_id",␠"duration_ns")
mz_connections_ind  CREATE␠INDEX␠"mz_connections_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s494␠AS␠"mz_catalog"."mz_connections"]␠("schema_id")
mz_console_cluster_utilization_overview_ind  CREATE␠INDEX␠"mz_console_cluster_utilization_overview_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s715␠AS␠"mz_internal"."mz_console_cluster_utilization_overview"]␠("cluster_id")
mz_continual_tasks_ind  CREATE␠INDEX␠"mz_continual_tasks_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s516␠AS␠"mz_internal"."mz_continual_tasks"]␠("id")
mz_databases_ind  CREATE␠INDEX␠"mz_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s460␠AS␠"mz_catalog"."mz_databases"]␠("name")
mz_dataflow_addresses_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_dataflow_addresses_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_dataflow_addresses_per_worker"␠("id",␠"worker_id")
mz_dataflow_channels_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_dataflow_channels_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_dataflow_channels_per_worker"␠("id",␠"worker_id")
mz_dataflow_operator_reachability_raw_s2_primary_idx  CREATE␠INDEX␠"mz_dataflow_operator_reachability_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_dataflow_operator_reachability_raw"␠("id",␠"worker_id",␠"source",␠"port",␠"update_type",␠"time")
mz_dataflow_operators_per_worker_s2_primary_idx  CREATE␠INDEX␠"mz_dataflow_operators_per_worker_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_dataflow_operators_per_worker"␠("id",␠"worker_id")
mz_dataflow_shutdown_durations_histogram_raw_s2_primary_idx  CREATE␠INDEX␠"mz_dataflow_shutdown_durations_histogram_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_dataflow_shutdown_durations_histogram_raw"␠("worker_id",␠"duration_ns")
mz_frontiers_ind  CREATE␠INDEX␠"mz_frontiers_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s702␠AS␠"mz_internal"."mz_frontiers"]␠("object_id")
mz_indexes_ind  CREATE␠INDEX␠"mz_indexes_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s463␠AS␠"mz_catalog"."mz_indexes"]␠("id")
mz_kafka_sources_ind  CREATE␠INDEX␠"mz_kafka_sources_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s458␠AS␠"mz_catalog"."mz_kafka_sources"]␠("id")
mz_materialized_views_ind  CREATE␠INDEX␠"mz_materialized_views_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s475␠AS␠"mz_catalog"."mz_materialized_views"]␠("id")
mz_message_batch_counts_received_raw_s2_primary_idx  CREATE␠INDEX␠"mz_message_batch_counts_received_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_message_batch_counts_received_raw"␠("channel_id",␠"from_worker_id",␠"to_worker_id")
mz_message_batch_counts_sent_raw_s2_primary_idx  CREATE␠INDEX␠"mz_message_batch_counts_sent_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_message_batch_counts_sent_raw"␠("channel_id",␠"from_worker_id",␠"to_worker_id")
mz_message_counts_received_raw_s2_primary_idx  CREATE␠INDEX␠"mz_message_counts_received_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_message_counts_received_raw"␠("channel_id",␠"from_worker_id",␠"to_worker_id")
mz_message_counts_sent_raw_s2_primary_idx  CREATE␠INDEX␠"mz_message_counts_sent_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_message_counts_sent_raw"␠("channel_id",␠"from_worker_id",␠"to_worker_id")
mz_notices_ind  CREATE␠INDEX␠"mz_notices_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s792␠AS␠"mz_internal"."mz_notices"]␠("id")
mz_object_dependencies_ind  CREATE␠INDEX␠"mz_object_dependencies_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s459␠AS␠"mz_internal"."mz_object_dependencies"]␠("object_id")
mz_object_history_ind  CREATE␠INDEX␠"mz_object_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s525␠AS␠"mz_internal"."mz_object_history"]␠("id")
mz_object_lifetimes_ind  CREATE␠INDEX␠"mz_object_lifetimes_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s526␠AS␠"mz_internal"."mz_object_lifetimes"]␠("id")
mz_object_transitive_dependencies_ind  CREATE␠INDEX␠"mz_object_transitive_dependencies_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s540␠AS␠"mz_internal"."mz_object_transitive_dependencies"]␠("object_id")
mz_objects_ind  CREATE␠INDEX␠"mz_objects_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s522␠AS␠"mz_catalog"."mz_objects"]␠("schema_id")
mz_peek_durations_histogram_raw_s2_primary_idx  CREATE␠INDEX␠"mz_peek_durations_histogram_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_peek_durations_histogram_raw"␠("worker_id",␠"type",␠"duration_ns")
mz_recent_activity_log_thinned_ind  CREATE␠INDEX␠"mz_recent_activity_log_thinned_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s686␠AS␠"mz_internal"."mz_recent_activity_log_thinned"]␠("sql_hash")
mz_recent_sql_text_ind  CREATE␠INDEX␠"mz_recent_sql_text_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s682␠AS␠"mz_internal"."mz_recent_sql_text"]␠("sql_hash")
mz_recent_storage_usage_ind  CREATE␠INDEX␠"mz_recent_storage_usage_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s787␠AS␠"mz_catalog"."mz_recent_storage_usage"]␠("object_id")
mz_roles_ind  CREATE␠INDEX␠"mz_roles_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s483␠AS␠"mz_catalog"."mz_roles"]␠("id")
mz_scheduling_elapsed_raw_s2_primary_idx  CREATE␠INDEX␠"mz_scheduling_elapsed_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_scheduling_elapsed_raw"␠("id",␠"worker_id")
mz_scheduling_parks_histogram_raw_s2_primary_idx  CREATE␠INDEX␠"mz_scheduling_parks_histogram_raw_s2_primary_idx"␠IN␠CLUSTER␠[s2]␠ON␠"mz_introspection"."mz_scheduling_parks_histogram_raw"␠("worker_id",␠"slept_for_ns",␠"requested_ns")
mz_schemas_ind  CREATE␠INDEX␠"mz_schemas_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s461␠AS␠"mz_catalog"."mz_schemas"]␠("database_id")
mz_secrets_ind  CREATE␠INDEX␠"mz_secrets_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s493␠AS␠"mz_catalog"."mz_secrets"]␠("name")
mz_show_all_objects_ind  CREATE␠INDEX␠"mz_show_all_objects_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s571␠AS␠"mz_internal"."mz_show_all_objects"]␠("schema_id")
mz_show_cluster_replicas_ind  CREATE␠INDEX␠"mz_show_cluster_replicas_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s726␠AS␠"mz_internal"."mz_show_cluster_replicas"]␠("cluster")
mz_show_clusters_ind  CREATE␠INDEX␠"mz_show_clusters_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s573␠AS␠"mz_internal"."mz_show_clusters"]␠("name")
mz_show_columns_ind  CREATE␠INDEX␠"mz_show_columns_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s572␠AS␠"mz_internal"."mz_show_columns"]␠("id")
mz_show_connections_ind  CREATE␠INDEX␠"mz_show_connections_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s581␠AS␠"mz_internal"."mz_show_connections"]␠("schema_id")
mz_show_databases_ind  CREATE␠INDEX␠"mz_show_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s575␠AS␠"mz_internal"."mz_show_databases"]␠("name")
mz_show_indexes_ind  CREATE␠INDEX␠"mz_show_indexes_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s585␠AS␠"mz_internal"."mz_show_indexes"]␠("schema_id")
mz_show_materialized_views_ind  CREATE␠INDEX␠"mz_show_materialized_views_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s584␠AS␠"mz_internal"."mz_show_materialized_views"]␠("schema_id")
mz_show_roles_ind  CREATE␠INDEX␠"mz_show_roles_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s580␠AS␠"mz_internal"."mz_show_roles"]␠("name")
mz_show_schemas_ind  CREATE␠INDEX␠"mz_show_schemas_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s576␠AS␠"mz_internal"."mz_show_schemas"]␠("database_id")
mz_show_secrets_ind  CREATE␠INDEX␠"mz_show_secrets_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s574␠AS␠"mz_internal"."mz_show_secrets"]␠("schema_id")
mz_show_sinks_ind  CREATE␠INDEX␠"mz_show_sinks_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s583␠AS␠"mz_internal"."mz_show_sinks"]␠("schema_id")
mz_show_sources_ind  CREATE␠INDEX␠"mz_show_sources_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s582␠AS␠"mz_internal"."mz_show_sources"]␠("schema_id")
mz_show_tables_ind  CREATE␠INDEX␠"mz_show_tables_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s577␠AS␠"mz_internal"."mz_show_tables"]␠("schema_id")
mz_show_types_ind  CREATE␠INDEX␠"mz_show_types_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s579␠AS␠"mz_internal"."mz_show_types"]␠("schema_id")
mz_show_views_ind  CREATE␠INDEX␠"mz_show_views_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s578␠AS␠"mz_internal"."mz_show_views"]␠("schema_id")
mz_sink_statistics_ind  CREATE␠INDEX␠"mz_sink_statistics_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s699␠AS␠"mz_internal"."mz_sink_statistics"]␠("id",␠"replica_id")
mz_sink_status_history_ind  CREATE␠INDEX␠"mz_sink_status_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s671␠AS␠"mz_internal"."mz_sink_status_history"]␠("sink_id")
mz_sink_statuses_ind  CREATE␠INDEX␠"mz_sink_statuses_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s672␠AS␠"mz_internal"."mz_sink_statuses"]␠("id")
mz_sinks_ind  CREATE␠INDEX␠"mz_sinks_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s473␠AS␠"mz_catalog"."mz_sinks"]␠("id")
mz_source_statistics_ind  CREATE␠INDEX␠"mz_source_statistics_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s697␠AS␠"mz_internal"."mz_source_statistics"]␠("id",␠"replica_id")
mz_source_statistics_with_history_ind  CREATE␠INDEX␠"mz_source_statistics_with_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s695␠AS␠"mz_internal"."mz_source_statistics_with_history"]␠("id",␠"replica_id")
mz_source_status_history_ind  CREATE␠INDEX␠"mz_source_status_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s673␠AS␠"mz_internal"."mz_source_status_history"]␠("source_id")
mz_source_statuses_ind  CREATE␠INDEX␠"mz_source_statuses_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s690␠AS␠"mz_internal"."mz_source_statuses"]␠("id")
mz_sources_ind  CREATE␠INDEX␠"mz_sources_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s466␠AS␠"mz_catalog"."mz_sources"]␠("id")
mz_tables_ind  CREATE␠INDEX␠"mz_tables_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s465␠AS␠"mz_catalog"."mz_tables"]␠("schema_id")
mz_types_ind  CREATE␠INDEX␠"mz_types_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s477␠AS␠"mz_catalog"."mz_types"]␠("schema_id")
mz_views_ind  CREATE␠INDEX␠"mz_views_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s474␠AS␠"mz_catalog"."mz_views"]␠("schema_id")
mz_wallclock_global_lag_recent_history_ind  CREATE␠INDEX␠"mz_wallclock_global_lag_recent_history_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s706␠AS␠"mz_internal"."mz_wallclock_global_lag_recent_history"]␠("object_id")
mz_webhook_sources_ind  CREATE␠INDEX␠"mz_webhook_sources_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s514␠AS␠"mz_internal"."mz_webhook_sources"]␠("id")
pg_attrdef_all_databases_ind  CREATE␠INDEX␠"pg_attrdef_all_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s613␠AS␠"mz_internal"."pg_attrdef_all_databases"]␠("oid",␠"adrelid",␠"adnum",␠"adbin",␠"adsrc")
pg_attribute_all_databases_ind  CREATE␠INDEX␠"pg_attribute_all_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s606␠AS␠"mz_internal"."pg_attribute_all_databases"]␠("attrelid",␠"attname",␠"atttypid",␠"attlen",␠"attnum",␠"atttypmod",␠"attnotnull",␠"atthasdef",␠"attidentity",␠"attgenerated",␠"attisdropped",␠"attcollation",␠"database_name",␠"pg_type_database_name")
pg_class_all_databases_ind  CREATE␠INDEX␠"pg_class_all_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s594␠AS␠"mz_internal"."pg_class_all_databases"]␠("relname")
pg_description_all_databases_ind  CREATE␠INDEX␠"pg_description_all_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s603␠AS␠"mz_internal"."pg_description_all_databases"]␠("objoid",␠"classoid",␠"objsubid",␠"description",␠"oid_database_name",␠"class_database_name")
pg_namespace_all_databases_ind  CREATE␠INDEX␠"pg_namespace_all_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s591␠AS␠"mz_internal"."pg_namespace_all_databases"]␠("nspname")
pg_type_all_databases_ind  CREATE␠INDEX␠"pg_type_all_databases_ind"␠IN␠CLUSTER␠[s2]␠ON␠[s600␠AS␠"mz_internal"."pg_type_all_databases"]␠("oid")

# Record all transitive dependencies (tables, sources, views, mvs) of indexes on
# the mz_catalog_server cluster.
# Include each column of each dependent object, so we can detect changes to
# object definitions that may impact the memory utilization of the index.
query TT
SELECT DISTINCT o.name dependent_object_name, co.name column_name
FROM mz_indexes i
LEFT JOIN mz_internal.mz_object_transitive_dependencies d ON i.id = d.object_id
LEFT JOIN mz_objects o ON o.id = d.referenced_object_id
JOIN mz_columns co on co.id = o.id
WHERE i.cluster_id =
  (SELECT id FROM mz_clusters WHERE name = 'mz_catalog_server')
ORDER BY 1, 2
----
mz_active_peeks_per_worker  id
mz_active_peeks_per_worker  object_id
mz_active_peeks_per_worker  time
mz_active_peeks_per_worker  type
mz_active_peeks_per_worker  worker_id
mz_activity_log_thinned  application_name
mz_activity_log_thinned  authenticated_user
mz_activity_log_thinned  began_at
mz_activity_log_thinned  cluster_id
mz_activity_log_thinned  cluster_name
mz_activity_log_thinned  database_name
mz_activity_log_thinned  error_message
mz_activity_log_thinned  execution_id
mz_activity_log_thinned  execution_strategy
mz_activity_log_thinned  execution_timestamp
mz_activity_log_thinned  finished_at
mz_activity_log_thinned  finished_status
mz_activity_log_thinned  initial_application_name
mz_activity_log_thinned  mz_version
mz_activity_log_thinned  params
mz_activity_log_thinned  prepared_at
mz_activity_log_thinned  prepared_statement_id
mz_activity_log_thinned  prepared_statement_name
mz_activity_log_thinned  result_size
mz_activity_log_thinned  rows_returned
mz_activity_log_thinned  sample_rate
mz_activity_log_thinned  search_path
mz_activity_log_thinned  session_id
mz_activity_log_thinned  sql_hash
mz_activity_log_thinned  statement_type
mz_activity_log_thinned  throttled_count
mz_activity_log_thinned  transaction_id
mz_activity_log_thinned  transaction_isolation
mz_activity_log_thinned  transient_index_id
mz_arrangement_batcher_allocations_raw  operator_id
mz_arrangement_batcher_allocations_raw  worker_id
mz_arrangement_batcher_capacity_raw  operator_id
mz_arrangement_batcher_capacity_raw  worker_id
mz_arrangement_batcher_records_raw  operator_id
mz_arrangement_batcher_records_raw  worker_id
mz_arrangement_batcher_size_raw  operator_id
mz_arrangement_batcher_size_raw  worker_id
mz_arrangement_batches_raw  operator_id
mz_arrangement_batches_raw  worker_id
mz_arrangement_heap_allocations_raw  operator_id
mz_arrangement_heap_allocations_raw  worker_id
mz_arrangement_heap_capacity_raw  operator_id
mz_arrangement_heap_capacity_raw  worker_id
mz_arrangement_heap_size_raw  operator_id
mz_arrangement_heap_size_raw  worker_id
mz_arrangement_records_raw  operator_id
mz_arrangement_records_raw  worker_id
mz_arrangement_sharing_raw  operator_id
mz_arrangement_sharing_raw  worker_id
mz_array_types  element_id
mz_array_types  id
mz_audit_events  details
mz_audit_events  event_type
mz_audit_events  id
mz_audit_events  object_type
mz_audit_events  occurred_at
mz_audit_events  user
mz_base_types  id
mz_cluster_deployment_lineage  cluster_id
mz_cluster_deployment_lineage  cluster_name
mz_cluster_deployment_lineage  current_deployment_cluster_id
mz_cluster_replica_frontiers  object_id
mz_cluster_replica_frontiers  replica_id
mz_cluster_replica_frontiers  write_frontier
mz_cluster_replica_history  cluster_id
mz_cluster_replica_history  cluster_name
mz_cluster_replica_history  created_at
mz_cluster_replica_history  credits_per_hour
mz_cluster_replica_history  dropped_at
mz_cluster_replica_history  replica_id
mz_cluster_replica_history  replica_name
mz_cluster_replica_history  size
mz_cluster_replica_metrics  cpu_nano_cores
mz_cluster_replica_metrics  disk_bytes
mz_cluster_replica_metrics  memory_bytes
mz_cluster_replica_metrics  process_id
mz_cluster_replica_metrics  replica_id
mz_cluster_replica_metrics_history  cpu_nano_cores
mz_cluster_replica_metrics_history  disk_bytes
mz_cluster_replica_metrics_history  memory_bytes
mz_cluster_replica_metrics_history  occurred_at
mz_cluster_replica_metrics_history  process_id
mz_cluster_replica_metrics_history  replica_id
mz_cluster_replica_name_history  id
mz_cluster_replica_name_history  new_name
mz_cluster_replica_name_history  occurred_at
mz_cluster_replica_name_history  previous_name
mz_cluster_replica_sizes  cpu_nano_cores
mz_cluster_replica_sizes  credits_per_hour
mz_cluster_replica_sizes  disk_bytes
mz_cluster_replica_sizes  memory_bytes
mz_cluster_replica_sizes  processes
mz_cluster_replica_sizes  size
mz_cluster_replica_sizes  workers
mz_cluster_replica_status_history  occurred_at
mz_cluster_replica_status_history  process_id
mz_cluster_replica_status_history  reason
mz_cluster_replica_status_history  replica_id
mz_cluster_replica_status_history  status
mz_cluster_replica_statuses  process_id
mz_cluster_replica_statuses  reason
mz_cluster_replica_statuses  replica_id
mz_cluster_replica_statuses  status
mz_cluster_replica_statuses  updated_at
mz_cluster_replicas  availability_zone
mz_cluster_replicas  cluster_id
mz_cluster_replicas  disk
mz_cluster_replicas  id
mz_cluster_replicas  name
mz_cluster_replicas  owner_id
mz_cluster_replicas  size
mz_clusters  availability_zones
mz_clusters  disk
mz_clusters  id
mz_clusters  introspection_debugging
mz_clusters  introspection_interval
mz_clusters  managed
mz_clusters  name
mz_clusters  owner_id
mz_clusters  privileges
mz_clusters  replication_factor
mz_clusters  size
mz_columns  default
mz_columns  id
mz_columns  name
mz_columns  nullable
mz_columns  position
mz_columns  type
mz_columns  type_mod
mz_columns  type_oid
mz_comments  comment
mz_comments  id
mz_comments  object_sub_id
mz_comments  object_type
mz_compute_dataflow_global_ids_per_worker  global_id
mz_compute_dataflow_global_ids_per_worker  id
mz_compute_dataflow_global_ids_per_worker  worker_id
mz_compute_dependencies  dependency_id
mz_compute_dependencies  object_id
mz_compute_error_counts_raw  count
mz_compute_error_counts_raw  export_id
mz_compute_error_counts_raw  worker_id
mz_compute_exports_per_worker  dataflow_id
mz_compute_exports_per_worker  export_id
mz_compute_exports_per_worker  worker_id
mz_compute_frontiers_per_worker  export_id
mz_compute_frontiers_per_worker  time
mz_compute_frontiers_per_worker  worker_id
mz_compute_hydration_statuses  hydrated
mz_compute_hydration_statuses  hydration_time
mz_compute_hydration_statuses  object_id
mz_compute_hydration_statuses  replica_id
mz_compute_hydration_times  object_id
mz_compute_hydration_times  replica_id
mz_compute_hydration_times  time_ns
mz_compute_hydration_times_per_worker  export_id
mz_compute_hydration_times_per_worker  time_ns
mz_compute_hydration_times_per_worker  worker_id
mz_compute_import_frontiers_per_worker  export_id
mz_compute_import_frontiers_per_worker  import_id
mz_compute_import_frontiers_per_worker  time
mz_compute_import_frontiers_per_worker  worker_id
mz_compute_lir_mapping_per_worker  global_id
mz_compute_lir_mapping_per_worker  lir_id
mz_compute_lir_mapping_per_worker  nesting
mz_compute_lir_mapping_per_worker  operator
mz_compute_lir_mapping_per_worker  operator_id_end
mz_compute_lir_mapping_per_worker  operator_id_start
mz_compute_lir_mapping_per_worker  parent_lir_id
mz_compute_lir_mapping_per_worker  worker_id
mz_compute_operator_durations_histogram_raw  duration_ns
mz_compute_operator_durations_histogram_raw  id
mz_compute_operator_durations_histogram_raw  worker_id
mz_connections  create_sql
mz_connections  id
mz_connections  name
mz_connections  oid
mz_connections  owner_id
mz_connections  privileges
mz_connections  redacted_create_sql
mz_connections  schema_id
mz_connections  type
mz_console_cluster_utilization_overview  bucket_end
mz_console_cluster_utilization_overview  bucket_start
mz_console_cluster_utilization_overview  cluster_id
mz_console_cluster_utilization_overview  disk_percent
mz_console_cluster_utilization_overview  max_cpu_at
mz_console_cluster_utilization_overview  max_cpu_percent
mz_console_cluster_utilization_overview  max_disk_at
mz_console_cluster_utilization_overview  max_memory_and_disk_at
mz_console_cluster_utilization_overview  max_memory_and_disk_disk_percent
mz_console_cluster_utilization_overview  max_memory_and_disk_memory_percent
mz_console_cluster_utilization_overview  max_memory_at
mz_console_cluster_utilization_overview  memory_and_disk_percent
mz_console_cluster_utilization_overview  memory_percent
mz_console_cluster_utilization_overview  name
mz_console_cluster_utilization_overview  offline_events
mz_console_cluster_utilization_overview  replica_id
mz_console_cluster_utilization_overview  size
mz_continual_tasks  cluster_id
mz_continual_tasks  create_sql
mz_continual_tasks  definition
mz_continual_tasks  id
mz_continual_tasks  name
mz_continual_tasks  oid
mz_continual_tasks  owner_id
mz_continual_tasks  privileges
mz_continual_tasks  redacted_create_sql
mz_continual_tasks  schema_id
mz_databases  id
mz_databases  name
mz_databases  oid
mz_databases  owner_id
mz_databases  privileges
mz_dataflow_addresses_per_worker  address
mz_dataflow_addresses_per_worker  id
mz_dataflow_addresses_per_worker  worker_id
mz_dataflow_channels_per_worker  from_index
mz_dataflow_channels_per_worker  from_port
mz_dataflow_channels_per_worker  id
mz_dataflow_channels_per_worker  to_index
mz_dataflow_channels_per_worker  to_port
mz_dataflow_channels_per_worker  worker_id
mz_dataflow_operator_reachability_raw  id
mz_dataflow_operator_reachability_raw  port
mz_dataflow_operator_reachability_raw  source
mz_dataflow_operator_reachability_raw  time
mz_dataflow_operator_reachability_raw  update_type
mz_dataflow_operator_reachability_raw  worker_id
mz_dataflow_operators_per_worker  id
mz_dataflow_operators_per_worker  name
mz_dataflow_operators_per_worker  worker_id
mz_dataflow_shutdown_durations_histogram_raw  duration_ns
mz_dataflow_shutdown_durations_histogram_raw  worker_id
mz_frontiers  object_id
mz_frontiers  read_frontier
mz_frontiers  write_frontier
mz_functions  argument_type_ids
mz_functions  id
mz_functions  name
mz_functions  oid
mz_functions  owner_id
mz_functions  return_type_id
mz_functions  returns_set
mz_functions  schema_id
mz_functions  variadic_argument_type_id
mz_hydration_statuses  hydrated
mz_hydration_statuses  object_id
mz_hydration_statuses  replica_id
mz_index_columns  index_id
mz_index_columns  index_position
mz_index_columns  nullable
mz_index_columns  on_expression
mz_index_columns  on_position
mz_indexes  cluster_id
mz_indexes  create_sql
mz_indexes  id
mz_indexes  name
mz_indexes  oid
mz_indexes  on_id
mz_indexes  owner_id
mz_indexes  redacted_create_sql
mz_kafka_sources  group_id_prefix
mz_kafka_sources  id
mz_kafka_sources  topic
mz_list_types  element_id
mz_list_types  element_modifiers
mz_list_types  id
mz_map_types  id
mz_map_types  key_id
mz_map_types  key_modifiers
mz_map_types  value_id
mz_map_types  value_modifiers
mz_materialized_views  cluster_id
mz_materialized_views  create_sql
mz_materialized_views  definition
mz_materialized_views  id
mz_materialized_views  name
mz_materialized_views  oid
mz_materialized_views  owner_id
mz_materialized_views  privileges
mz_materialized_views  redacted_create_sql
mz_materialized_views  schema_id
mz_message_batch_counts_received_raw  channel_id
mz_message_batch_counts_received_raw  from_worker_id
mz_message_batch_counts_received_raw  to_worker_id
mz_message_batch_counts_sent_raw  channel_id
mz_message_batch_counts_sent_raw  from_worker_id
mz_message_batch_counts_sent_raw  to_worker_id
mz_message_counts_received_raw  channel_id
mz_message_counts_received_raw  from_worker_id
mz_message_counts_received_raw  to_worker_id
mz_message_counts_sent_raw  channel_id
mz_message_counts_sent_raw  from_worker_id
mz_message_counts_sent_raw  to_worker_id
mz_notices  action
mz_notices  action_type
mz_notices  created_at
mz_notices  hint
mz_notices  id
mz_notices  message
mz_notices  notice_type
mz_notices  object_id
mz_notices  redacted_action
mz_notices  redacted_hint
mz_notices  redacted_message
mz_object_dependencies  object_id
mz_object_dependencies  referenced_object_id
mz_object_history  cluster_id
mz_object_history  created_at
mz_object_history  dropped_at
mz_object_history  id
mz_object_history  object_type
mz_object_lifetimes  event_type
mz_object_lifetimes  id
mz_object_lifetimes  object_type
mz_object_lifetimes  occurred_at
mz_object_lifetimes  previous_id
mz_object_transitive_dependencies  object_id
mz_object_transitive_dependencies  referenced_object_id
mz_objects  cluster_id
mz_objects  id
mz_objects  name
mz_objects  oid
mz_objects  owner_id
mz_objects  privileges
mz_objects  schema_id
mz_objects  type
mz_objects_id_namespace_types  object_type
mz_optimizer_notices  action
mz_optimizer_notices  action_type
mz_optimizer_notices  created_at
mz_optimizer_notices  dependency_ids
mz_optimizer_notices  hint
mz_optimizer_notices  id
mz_optimizer_notices  message
mz_optimizer_notices  notice_type
mz_optimizer_notices  object_id
mz_optimizer_notices  redacted_action
mz_optimizer_notices  redacted_hint
mz_optimizer_notices  redacted_message
mz_peek_durations_histogram_raw  duration_ns
mz_peek_durations_histogram_raw  type
mz_peek_durations_histogram_raw  worker_id
mz_prepared_statement_history  id
mz_prepared_statement_history  name
mz_prepared_statement_history  prepared_at
mz_prepared_statement_history  session_id
mz_prepared_statement_history  sql_hash
mz_prepared_statement_history  statement_type
mz_prepared_statement_history  throttled_count
mz_pseudo_types  id
mz_recent_activity_log_thinned  application_name
mz_recent_activity_log_thinned  authenticated_user
mz_recent_activity_log_thinned  began_at
mz_recent_activity_log_thinned  cluster_id
mz_recent_activity_log_thinned  cluster_name
mz_recent_activity_log_thinned  database_name
mz_recent_activity_log_thinned  error_message
mz_recent_activity_log_thinned  execution_id
mz_recent_activity_log_thinned  execution_strategy
mz_recent_activity_log_thinned  execution_timestamp
mz_recent_activity_log_thinned  finished_at
mz_recent_activity_log_thinned  finished_status
mz_recent_activity_log_thinned  initial_application_name
mz_recent_activity_log_thinned  mz_version
mz_recent_activity_log_thinned  params
mz_recent_activity_log_thinned  prepared_at
mz_recent_activity_log_thinned  prepared_statement_id
mz_recent_activity_log_thinned  prepared_statement_name
mz_recent_activity_log_thinned  result_size
mz_recent_activity_log_thinned  rows_returned
mz_recent_activity_log_thinned  sample_rate
mz_recent_activity_log_thinned  search_path
mz_recent_activity_log_thinned  session_id
mz_recent_activity_log_thinned  sql_hash
mz_recent_activity_log_thinned  statement_type
mz_recent_activity_log_thinned  throttled_count
mz_recent_activity_log_thinned  transaction_id
mz_recent_activity_log_thinned  transaction_isolation
mz_recent_activity_log_thinned  transient_index_id
mz_recent_sql_text  redacted_sql
mz_recent_sql_text  sql
mz_recent_sql_text  sql_hash
mz_recent_storage_usage  object_id
mz_recent_storage_usage  size_bytes
mz_relations  cluster_id
mz_relations  id
mz_relations  name
mz_relations  oid
mz_relations  owner_id
mz_relations  privileges
mz_relations  schema_id
mz_relations  type
mz_roles  id
mz_roles  inherit
mz_roles  name
mz_roles  oid
mz_scheduling_elapsed_raw  id
mz_scheduling_elapsed_raw  worker_id
mz_scheduling_parks_histogram_raw  requested_ns
mz_scheduling_parks_histogram_raw  slept_for_ns
mz_scheduling_parks_histogram_raw  worker_id
mz_schemas  database_id
mz_schemas  id
mz_schemas  name
mz_schemas  oid
mz_schemas  owner_id
mz_schemas  privileges
mz_secrets  id
mz_secrets  name
mz_secrets  oid
mz_secrets  owner_id
mz_secrets  privileges
mz_secrets  schema_id
mz_session_history  authenticated_user
mz_session_history  connected_at
mz_session_history  initial_application_name
mz_session_history  session_id
mz_show_all_objects  comment
mz_show_all_objects  name
mz_show_all_objects  schema_id
mz_show_all_objects  type
mz_show_cluster_replicas  cluster
mz_show_cluster_replicas  comment
mz_show_cluster_replicas  ready
mz_show_cluster_replicas  replica
mz_show_cluster_replicas  replica_id
mz_show_cluster_replicas  size
mz_show_clusters  comment
mz_show_clusters  name
mz_show_clusters  replicas
mz_show_columns  comment
mz_show_columns  id
mz_show_columns  name
mz_show_columns  nullable
mz_show_columns  position
mz_show_columns  type
mz_show_connections  comment
mz_show_connections  name
mz_show_connections  schema_id
mz_show_connections  type
mz_show_databases  comment
mz_show_databases  name
mz_show_indexes  cluster
mz_show_indexes  cluster_id
mz_show_indexes  comment
mz_show_indexes  id
mz_show_indexes  key
mz_show_indexes  name
mz_show_indexes  on
mz_show_indexes  on_id
mz_show_indexes  schema_id
mz_show_materialized_views  cluster
mz_show_materialized_views  cluster_id
mz_show_materialized_views  comment
mz_show_materialized_views  id
mz_show_materialized_views  name
mz_show_materialized_views  schema_id
mz_show_roles  comment
mz_show_roles  name
mz_show_schemas  comment
mz_show_schemas  database_id
mz_show_schemas  name
mz_show_secrets  comment
mz_show_secrets  name
mz_show_secrets  schema_id
mz_show_sinks  cluster
mz_show_sinks  cluster_id
mz_show_sinks  comment
mz_show_sinks  id
mz_show_sinks  name
mz_show_sinks  schema_id
mz_show_sinks  type
mz_show_sources  cluster
mz_show_sources  cluster_id
mz_show_sources  comment
mz_show_sources  id
mz_show_sources  name
mz_show_sources  schema_id
mz_show_sources  type
mz_show_tables  comment
mz_show_tables  name
mz_show_tables  schema_id
mz_show_tables  source_id
mz_show_types  comment
mz_show_types  name
mz_show_types  schema_id
mz_show_views  comment
mz_show_views  name
mz_show_views  schema_id
mz_sink_statistics  bytes_committed
mz_sink_statistics  bytes_staged
mz_sink_statistics  id
mz_sink_statistics  messages_committed
mz_sink_statistics  messages_staged
mz_sink_statistics  replica_id
mz_sink_statistics_raw  bytes_committed
mz_sink_statistics_raw  bytes_staged
mz_sink_statistics_raw  id
mz_sink_statistics_raw  messages_committed
mz_sink_statistics_raw  messages_staged
mz_sink_statistics_raw  replica_id
mz_sink_status_history  details
mz_sink_status_history  error
mz_sink_status_history  occurred_at
mz_sink_status_history  replica_id
mz_sink_status_history  sink_id
mz_sink_status_history  status
mz_sink_statuses  details
mz_sink_statuses  error
mz_sink_statuses  id
mz_sink_statuses  last_status_change_at
mz_sink_statuses  name
mz_sink_statuses  status
mz_sink_statuses  type
mz_sinks  cluster_id
mz_sinks  connection_id
mz_sinks  create_sql
mz_sinks  envelope_type
mz_sinks  format
mz_sinks  id
mz_sinks  key_format
mz_sinks  name
mz_sinks  oid
mz_sinks  owner_id
mz_sinks  redacted_create_sql
mz_sinks  schema_id
mz_sinks  size
mz_sinks  type
mz_sinks  value_format
mz_source_statistics  bytes_indexed
mz_source_statistics  bytes_received
mz_source_statistics  id
mz_source_statistics  messages_received
mz_source_statistics  offset_committed
mz_source_statistics  offset_known
mz_source_statistics  records_indexed
mz_source_statistics  rehydration_latency
mz_source_statistics  replica_id
mz_source_statistics  snapshot_committed
mz_source_statistics  snapshot_records_known
mz_source_statistics  snapshot_records_staged
mz_source_statistics  updates_committed
mz_source_statistics  updates_staged
mz_source_statistics_raw  bytes_indexed
mz_source_statistics_raw  bytes_received
mz_source_statistics_raw  id
mz_source_statistics_raw  messages_received
mz_source_statistics_raw  offset_committed
mz_source_statistics_raw  offset_known
mz_source_statistics_raw  records_indexed
mz_source_statistics_raw  rehydration_latency
mz_source_statistics_raw  replica_id
mz_source_statistics_raw  snapshot_committed
mz_source_statistics_raw  snapshot_records_known
mz_source_statistics_raw  snapshot_records_staged
mz_source_statistics_raw  updates_committed
mz_source_statistics_raw  updates_staged
mz_source_statistics_with_history  bytes_indexed
mz_source_statistics_with_history  bytes_received
mz_source_statistics_with_history  id
mz_source_statistics_with_history  messages_received
mz_source_statistics_with_history  offset_committed
mz_source_statistics_with_history  offset_known
mz_source_statistics_with_history  records_indexed
mz_source_statistics_with_history  rehydration_latency
mz_source_statistics_with_history  replica_id
mz_source_statistics_with_history  snapshot_committed
mz_source_statistics_with_history  snapshot_records_known
mz_source_statistics_with_history  snapshot_records_staged
mz_source_statistics_with_history  updates_committed
mz_source_statistics_with_history  updates_staged
mz_source_status_history  details
mz_source_status_history  error
mz_source_status_history  occurred_at
mz_source_status_history  replica_id
mz_source_status_history  source_id
mz_source_status_history  status
mz_source_statuses  details
mz_source_statuses  error
mz_source_statuses  id
mz_source_statuses  last_status_change_at
mz_source_statuses  name
mz_source_statuses  status
mz_source_statuses  type
mz_sources  cluster_id
mz_sources  connection_id
mz_sources  create_sql
mz_sources  envelope_type
mz_sources  id
mz_sources  key_format
mz_sources  name
mz_sources  oid
mz_sources  owner_id
mz_sources  privileges
mz_sources  redacted_create_sql
mz_sources  schema_id
mz_sources  size
mz_sources  type
mz_sources  value_format
mz_sql_text  prepared_day
mz_sql_text  redacted_sql
mz_sql_text  sql
mz_sql_text  sql_hash
mz_statement_execution_history  application_name
mz_statement_execution_history  began_at
mz_statement_execution_history  cluster_id
mz_statement_execution_history  cluster_name
mz_statement_execution_history  database_name
mz_statement_execution_history  error_message
mz_statement_execution_history  execution_strategy
mz_statement_execution_history  execution_timestamp
mz_statement_execution_history  finished_at
mz_statement_execution_history  finished_status
mz_statement_execution_history  id
mz_statement_execution_history  mz_version
mz_statement_execution_history  params
mz_statement_execution_history  prepared_statement_id
mz_statement_execution_history  result_size
mz_statement_execution_history  rows_returned
mz_statement_execution_history  sample_rate
mz_statement_execution_history  search_path
mz_statement_execution_history  transaction_id
mz_statement_execution_history  transaction_isolation
mz_statement_execution_history  transient_index_id
mz_storage_shards  object_id
mz_storage_shards  shard_id
mz_storage_usage_by_shard  collection_timestamp
mz_storage_usage_by_shard  id
mz_storage_usage_by_shard  shard_id
mz_storage_usage_by_shard  size_bytes
mz_tables  create_sql
mz_tables  id
mz_tables  name
mz_tables  oid
mz_tables  owner_id
mz_tables  privileges
mz_tables  redacted_create_sql
mz_tables  schema_id
mz_tables  source_id
mz_type_pg_metadata  id
mz_type_pg_metadata  typinput
mz_type_pg_metadata  typreceive
mz_types  category
mz_types  create_sql
mz_types  id
mz_types  name
mz_types  oid
mz_types  owner_id
mz_types  privileges
mz_types  redacted_create_sql
mz_types  schema_id
mz_views  create_sql
mz_views  definition
mz_views  id
mz_views  name
mz_views  oid
mz_views  owner_id
mz_views  privileges
mz_views  redacted_create_sql
mz_views  schema_id
mz_wallclock_global_lag_history  lag
mz_wallclock_global_lag_history  object_id
mz_wallclock_global_lag_history  occurred_at
mz_wallclock_global_lag_recent_history  lag
mz_wallclock_global_lag_recent_history  object_id
mz_wallclock_global_lag_recent_history  occurred_at
mz_wallclock_lag_history  lag
mz_wallclock_lag_history  object_id
mz_wallclock_lag_history  occurred_at
mz_wallclock_lag_history  replica_id
mz_webhook_sources  id
mz_webhook_sources  name
mz_webhook_sources  url
pg_attrdef_all_databases  adbin
pg_attrdef_all_databases  adnum
pg_attrdef_all_databases  adrelid
pg_attrdef_all_databases  adsrc
pg_attrdef_all_databases  oid
pg_attribute_all_databases  attcollation
pg_attribute_all_databases  attgenerated
pg_attribute_all_databases  atthasdef
pg_attribute_all_databases  attidentity
pg_attribute_all_databases  attisdropped
pg_attribute_all_databases  attlen
pg_attribute_all_databases  attname
pg_attribute_all_databases  attnotnull
pg_attribute_all_databases  attnum
pg_attribute_all_databases  attrelid
pg_attribute_all_databases  atttypid
pg_attribute_all_databases  atttypmod
pg_attribute_all_databases  database_name
pg_attribute_all_databases  pg_type_database_name
pg_class_all_databases  database_name
pg_class_all_databases  oid
pg_class_all_databases  relam
pg_class_all_databases  relchecks
pg_class_all_databases  relforcerowsecurity
pg_class_all_databases  relhasindex
pg_class_all_databases  relhasoids
pg_class_all_databases  relhasrules
pg_class_all_databases  relhassubclass
pg_class_all_databases  relhastriggers
pg_class_all_databases  relispartition
pg_class_all_databases  relkind
pg_class_all_databases  relname
pg_class_all_databases  relnamespace
pg_class_all_databases  reloftype
pg_class_all_databases  reloptions
pg_class_all_databases  relowner
pg_class_all_databases  relpersistence
pg_class_all_databases  relreplident
pg_class_all_databases  relrowsecurity
pg_class_all_databases  reltablespace
pg_class_all_databases  reltoastrelid
pg_class_all_databases  reltuples
pg_description_all_databases  class_database_name
pg_description_all_databases  classoid
pg_description_all_databases  description
pg_description_all_databases  objoid
pg_description_all_databases  objsubid
pg_description_all_databases  oid_database_name
pg_namespace_all_databases  database_name
pg_namespace_all_databases  nspacl
pg_namespace_all_databases  nspname
pg_namespace_all_databases  nspowner
pg_namespace_all_databases  oid
pg_type_all_databases  database_name
pg_type_all_databases  oid
pg_type_all_databases  typarray
pg_type_all_databases  typbasetype
pg_type_all_databases  typcategory
pg_type_all_databases  typcollation
pg_type_all_databases  typdefault
pg_type_all_databases  typdelim
pg_type_all_databases  typelem
pg_type_all_databases  typinput
pg_type_all_databases  typlen
pg_type_all_databases  typname
pg_type_all_databases  typnamespace
pg_type_all_databases  typnotnull
pg_type_all_databases  typowner
pg_type_all_databases  typreceive
pg_type_all_databases  typrelid
pg_type_all_databases  typtype
pg_type_all_databases  typtypmod