The Admin> Settings view enables Command Center administrators to configure settings for Command Center features.
Turn on Enable GPCC history data collection to save query history, host metrics, and disk usage metrics to tables in the gpperfmon database gmetrics schema. This option defaults to on for a Greenplum Database 6 installation, but the Greenplum Database metrics collector extension is inactive until Command Center is started.
Enter a number of seconds to set the minimum runtime for a query to be saved in history. The default is to save all queries. Set this threshold to prevent Command Center from filling history with trivial queries.
When you enable GPCC history data collection:
Command Center saves query and metrics history in the gpmetrics schema tables in the gpperfmon database. Only queries that execute for at least the number of seconds you specify are saved. Query plan node history is only saved for queries that run for at least 10 seconds, or the number of seconds you specify, if greater than 10.
See gpmetrics Schema Reference for information about the gpmetrics history tables.
When you disable GPCC history data collection:
- Command Center query history views use history data collected by the Greenplum Database gpperfmon agents.
For best performance, set Enable GPCC history data collection to on and disable gpperfmon data collection. To disable the gpperfmon agents, set the Greenplum Database
gp_enable_gpperfmon configuration parameter to off and restart Greenplum Database:
$ gpconfig -c gp_enable_gpperfmon -v 'off' $ gpstop -ar