gpmetrics Configuration File Reference

Greenplum Command Center uses the gpcc.conf configuration file to save configuration information entered in the Command Center user interface.

You should not normally edit the gpcc.conf file directly. Instead, modify configuration information in the Command Center user interface. The threshold properties for the Recommendations page reports are an exception and must be added manually. If you edit the file, you must restart Command Center for the new values to take effect.

The gpcc.conf file is created in the $MASTER_DATA_DIRECTORY/gpmetrics/ directory on the Greenplum Database master or standby host where you start Command Center. The file is an INI-format configuration file, containing properties defined as key = value entries, one property per line.

Property Description
allow_anonymous If true, Command Center users can access the Query Monitor view without logging into Command Center. You can change this setting on the Command Center Admin> Permissions page.
resource_queue_import_status Command Center uses this property to determine whether to offer to import Greenplum Database resource queues to resource groups when you access the Admin> Workload Mgmt view. The default is false.
emailFrom The email address to set on the “From:” line of alert emails. The default is noreply-gpcc-alerts@pivotal.io.

Note: Set the email and smtp properties on the Command Center Admin> Alerts page.
emailTo A comma-separated list of email addresses to send alert emails.
smtpUsername The account name to use when authenticating with the SMTP server.
smtpServer The address and port of the SMTP server to use for alert emails.
smtpPassword The password used to authenticate the SMTP user with the SMTP server, base 64-encoded.
bloat_threshold Specifies the minimum percentage of bloat (space occupied by dead tuples) required to include a table with a VACUUM recommendation in the Bloat Rank report on the Recommendations page. The default is 0.1 (10%).
bloat_vacuum_full_threshold Specifies the minimum percentage of bloat (combined dead tuples and unused space) required to include a table with a VACUUM FULL recommendation in the Bloat Rank report on the Recommendations page. The default is 0.5 (50%).
accuracy_threshold Specifies the minimum inaccuracy percentage required to include a table in the Accuracy% Rank table on the Recommendations page. The default is 0.1 (10%).
skew_threshold Specifies the minimum skew percentage required to include a table in the Skew% Rank report on the Recommendations page. The default is 0.1 (10%).
skew_tuple_per_segment Specifies a minimum number of tuples per segment to include a table in the Skew% Rank report on the Recommendations page. This parameter helps to avoid reporting tables that have high skew due to small numbers of tuples. The default is 128, which means a table with fewer tuples than 128 times the number of segments will be excluded from the report.