System Monitoring and Maintenance
Best practices for regular maintenance that will ensure Apache Cloudberry high availability and optimal performance.
Monitor the system
Apache Cloudberry includes utilities that are useful for monitoring the system.
The gp_toolkit schema contains several views that can be accessed using SQL commands to query system catalogs, log files, and operating environment for system status information.
The gp_stats_missing view shows tables that do not have statistics and require ANALYZE to be run.
gpstate
The gpstate utility program displays the status of the Cloudberry system, including which segments are down, coordinator and segment configuration information (hosts, data directories, etc.), the ports used by the system, and mapping of primary segments to their corresponding mirror segments.
Run gpstate -Q to get a list of segments that are marked "down" in the coordinator system catalog.
To get detailed status information for the Cloudberry system, run gpstate -s.