Important gp_% tables and views
Post date: Sep 03, 2014 12:31:33 AM
All these views are owned by gp_toolkit schema.
"gp_pgdatabase"
"gp_distributed_xacts"
"gp_transaction_log"
"gp_distributed_log"
"gp_log_system"
"gp_log_database"
"gp_log_master_concise"
"gp_log_command_timings"
"gp_param_settings_seg_value_diffs"
"gp_pgdatabase_invalid"
"gp_skew_coefficients"
"gp_skew_idle_fractions"
"gp_stats_missing"
"gp_bloat_expected_pages"
"gp_bloat_diag"
"gp_resq_activity"
"gp_resq_activity_by_queue"
"gp_resq_priority_backend"
"gp_resq_priority_statement"
"gp_resq_role"
"gp_locks_on_resqueue"
"gp_locks_on_relation"
"gp_roles_assigned"
"gp_size_of_index"
"gp_size_of_table_disk"
"gp_size_of_table_uncompressed"
"gp_table_indexes"
"gp_size_of_all_table_indexes"
"gp_size_of_table_and_indexes_disk"
"gp_size_of_table_and_indexes_licensing"
"gp_size_of_partition_and_indexes_disk"
"gp_size_of_schema_disk"
"gp_size_of_database"
"gp_resqueue_status"
"gp_disk_free" - Table
All these tables are owned by pg_catalog schema.
"gp_verification_history"
"gp_master_mirroring"
"gp_fastsequence"
"gp_global_sequence"
"gp_persistent_relation_node"
"gp_relation_node"
"gp_persistent_database_node"
"gp_persistent_tablespace_node"
"gp_persistent_filespace_node"
"gp_configuration"
"gp_configuration_history"
"gp_db_interfaces"
"gp_interfaces"
"gp_id"
"gp_distribution_policy"
"gp_version_at_initdb"
"gp_segment_configuration"
"gp_fault_strategy"
"gp_san_configuration"