Important gp_% tables and views

All these views are owned by gp_toolkit schema.

1. "gp_pgdatabase"

2. "gp_distributed_xacts"

3. "gp_transaction_log"

4. "gp_distributed_log"

5. "gp_log_system"

6. "gp_log_database"

7. "gp_log_master_concise"

8. "gp_log_command_timings"

9. "gp_param_settings_seg_value_diffs"

10. "gp_pgdatabase_invalid"

11. "gp_skew_coefficients"

12. "gp_skew_idle_fractions"

13. "gp_stats_missing"

14. "gp_bloat_expected_pages"

15. "gp_bloat_diag"

16. "gp_resq_activity"

17. "gp_resq_activity_by_queue"

18. "gp_resq_priority_backend"

19. "gp_resq_priority_statement"

20. "gp_resq_role"

21. "gp_locks_on_resqueue"

22. "gp_locks_on_relation"

23. "gp_roles_assigned"

24. "gp_size_of_index"

25. "gp_size_of_table_disk"

26. "gp_size_of_table_uncompressed"

27. "gp_table_indexes"

28. "gp_size_of_all_table_indexes"

29. "gp_size_of_table_and_indexes_disk"

30. "gp_size_of_table_and_indexes_licensing"

31. "gp_size_of_partition_and_indexes_disk"

32. "gp_size_of_schema_disk"

33. "gp_size_of_database"

34. "gp_resqueue_status"

35. "gp_disk_free" - Table

All these tables are owned by pg_catalog schema.

1. "gp_verification_history"

2. "gp_master_mirroring"

3. "gp_fastsequence"

4. "gp_global_sequence"

5. "gp_persistent_relation_node"

6. "gp_relation_node"

7. "gp_persistent_database_node"

8. "gp_persistent_tablespace_node"

9. "gp_persistent_filespace_node"

10. "gp_configuration"

11. "gp_configuration_history"

12. "gp_db_interfaces"

13. "gp_interfaces"

14. "gp_id"

15. "gp_distribution_policy"

16. "gp_version_at_initdb"

17. "gp_segment_configuration"

18. "gp_fault_strategy"

19. "gp_san_configuration"