Administering the gpperfmon Database

Data collected by gpmmon and gpsmon agents is stored in a dedicated database called gpperfmon. This database requires the typical database maintenance tasks, such as clean up of old historical data and periodic ANALYZE.

See the gpperfmon Database Reference section for a reference of the tables and views in the gpperfmon database.

Connecting to the gpperfmon Database

Database administrators can connect directly to the gpperfmon database using any Greenplum Database-compatible client program (such as psql). For example:

$ psql -d gpperfmon -h master_host -p 5432 -U gpadmin

Backing Up and Restoring the gpperfmon Database

The history tables of the gpperfmon database can be backed up and restored using the Greenplum Database backup and restore utilities. See the Greenplum Database Utility Guide for more information.

Maintaining the Historical Data Tables

All of the *_history tables stored in the gpperfmon database are partitioned into monthly partitions. A January 2010 partition is created at installation time as a template partition. It can be deleted once some current partitions are created. The Command Center agents automatically create new partitions in two month increments as needed. Administrators must periodically drop partitions for the months that are no longer needed in order to maintain the size of the database.

See the Greenplum Database Administrator Guide for more information on dropping partitions of a partitioned table.