System Catalogs

• System Views
  • pg_stat_progress_create_index
• The gp_toolkit Administrative Schema
  • About the extension
  • Upgrade the extension
  • Check for tables that need routine maintenance
  • Check for locks
  • Check append-optimized tables
  • View server log files
  • Check server configuration files
  • Check for failed segments
  • Check resource group activity and status
  • Check resource queue activity and status
  • Check query disk spill space usage
  • View users and groups (roles)
  • Check database object sizes and disk space
  • Check for missing and orphaned data files
  • Move orphaned data files
  • Check for uneven data distribution
  • Maintain partitions