System Catalogs
- System Views
- gp_stat_progress_create_index
gp_stat_progress_create_index_summarygp_stat_activitygp_stat_all_indexesgp_stat_all_indexes_summarygp_stat_all_tablesgp_stat_all_tables_summarygp_stat_archivergp_stat_archiver_summarygp_stat_bgwritergp_stat_bgwriter_summarygp_stat_databasegp_stat_database_summarygp_stat_gssapigp_stat_operationsgp_stat_progress_analyzegp_stat_progress_analyze_summarygp_stat_progress_basebackupgp_stat_progress_clustergp_stat_progress_cluster_summarygp_stat_progress_copygp_stat_progress_vacuum_summarygp_stat_slru_summarygp_stat_sys_indexes_summarygp_stat_sys_tables_summarygp_stat_user_functions_summarygp_stat_user_indexesgp_stat_user_indexes_summarygp_stat_wal_summarygp_stat_xact_all_tablesgp_stat_xact_all_tables_summarygp_stat_xact_sys_tables_summarygp_stat_xact_user_functions_summarygp_stat_xact_user_tables_summarygp_statio_all_indexesgp_statio_all_indexes_summarygp_statio_all_sequencesgp_statio_all_sequences_summarygp_statio_all_tables_summarygp_statio_sys_indexes_summarygp_statio_sys_sequences_summarygp_statio_sys_tables_summarygp_statio_user_indexes_summarygp_statio_user_sequences_summarygp_statio_user_tablesgp_stat_user_tables_summary
- 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