posted Apr 28, 2017, 12:17 PM by Sachchida Ojha
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"
|
|
|