Important gp_% tables and views

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