# 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