The Admin> Settings view enables Command Center administrators to configure settings for Command Center features.
Click Enable queries history data collection to save query history, host metrics, and disk usage metrics to tables in the gpperfmon database gmetrics schema.
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.
Command Center by default uses history data collected by the
gpmmon agents that are installed and enabled when you create the gpperfmon database. These agents save history data to the “legacy” history tables, in the gpperfmon database public schema. History and metrics collected by the Command Center
ccagent agent can be saved to a different set of history tables, in the gpperfmon database gpmetrics schema.
When you enable queries history data collection:
- Command Center saves query and metrics history in the gpmetrics schema tables in the gpperfmon database for completed queries that execute for at least the number of seconds you specify. Plan node history is only saved for queries that run at least 10 seconds, or the number of seconds you specify if greater than 10. See gpmetrics Schema Reference for information about the history tables.
- The Command Center History view displays saved history and metrics from the gpmetrics tables instead of from the legacy gpperfmon tables.
- The gpperfmon
gpsmonagents continue to populate the legacy gpperfmon tables.
If you disable history data collection, the Command Center History view again displays data from the legacy history tables.