Settings

The Admin> Settings view enables Command Center administrators to configure settings for Command Center features.

Query Monitor guest access settings

Turn on Allow guests to view Query Monitor to allow users access to the Query Monitor without logging in. When enabled, the Allow guests to view Query Monitor feature allows anyone with access to the Greenplum Command Center web server to click View Query Monitor on the Command Center sign-in screen and see the Query Monitor page without logging in. These anonymous users cannot cancel queries and cannot access any other Command Center features.

When this feature is off, the View Query Monitor link does not appear on the sign-in screen and anonymous users cannot see the Query Monitor page.

Command Center users with Admin permission can toggle the feature on an off with a mouse click. Users with Operator or Operator Basic permission see a message reporting if the feature is on or off.

Guest Access

History settings

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.

Settings

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