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.
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.
|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
|emailFrom||The email address to set on the “From:” line of alert emails. The default is
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
|bloat_vacuum_full_threshold||Specifies the minimum percentage of bloat (combined dead tuples and unused space) required to include a table with a
|accuracy_threshold||Specifies the minimum inaccuracy percentage required to include a table in the Accuracy% Rank table on the Recommendations page. The default is
|skew_threshold||Specifies the minimum skew percentage required to include a table in the Skew% Rank report on the Recommendations page. The default is
|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
|stats_check_interval||Specifies how often to refresh the statistics in the Command Center Table Browser. The default is