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. Properties are organized within sections, with the exception of a handful that have no associated section.

Property	Description	Section
min_query_time	Queries shorter than number of seconds specified will not be captured in Query History.	[history]
wlm_short_query_threshold	Specifies the minimum number of seconds that a query must run before Command Center applies the action of a matching workload management rule. Use this parameter to prevent Command Center from applying rule actions to short-running queries. The default is 45 seconds.	[wlm]
wlm_query_cooldown_time	Specifies the wait time, in seconds, for retrying a failed workload management rule (canceling a query or moving a query to another resource group). Command Center makes 2 retry attempts for failed rules, after waiting the configured amount of time. The default is 15 seconds.	[wlm]
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.	N/A
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.	N/A
emailFrom	The email address to set on the "From:" line of alert emails. The default is [email protected]. Note: Set the email and smtp properties on the Command Center Admin> Alerts page.	[alert]
emailTo	A comma-delimited list of email addresses to send alert emails.	[alert]
smtpUsername	The account name to use when authenticating with the SMTP server.	[alert]
smtpServer	The address and port of the SMTP server to use for alert emails.	[alert]
smtpPassword	The password used to authenticate the SMTP user with the SMTP server, base 64-encoded.	[alert]
age_ratio	Specifies the age a table must reach to prompt Command Center to issue a VACUUM FREEZE recommendation in the Age Rank report on the Recommendations page. You must specify a value between 0 and 1. The default is 0.7. The age is calculated using two Greenplum Database GUCs: xid_warn_limit and xid_stop_limit. For example, 0.7 means a table is regarded as old enough and in need of VACUUM FREEZE when its age is above 70% * (2^31-1 - xid_warn_limit - xid_stop_limit).	[recommendations]
recommendations_visited	Indicates whether the Recommendations page has been visited.	N/A
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%).	[recommendations]
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%).	[recommendations]
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%).	[recommendations]
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%).	[recommendations]
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.	[recommendations]
stats_check_interval	Specifies how often to refresh the statistics in the Command Center Table Browser. The default is 300. New tables and changed values such as the file size and the last access time may not be seen until stats_check_interval seconds have elapsed. To disable table statistics collection, set this property to -1.	[table_browser]
gpssServer	Specifies the hostname or IP address of the GPSS server listening for client requests from Commmand Center.	[gpss]
gpssPort	Specifies the port number on which the GPSS server listens for client requests from Command Center. The default is 5000.	[gpss]
gpssUsername	Specifies the username for authenticating to the GPSS server.	[gpss]
gpssAuthentication	Specifies the authentication method for authenticating to the GPSS server. Accepted values are without-tls, tls, and tls-skip-ca-verify.	[gpss]
gpssCaFile	Specifies the file system path to the Certificate Authority file. This file should be accessible by Command Center on the host where it runs. This entry can be empty if the CA is already in the system pool on that host.	[gpss]
enable	Specifies whether Command Center automatically collects performance data and saves it in the $GPCC_HOME/logs/pprof file. The default is true.	[pprof]
interval	Specifies how long Command Center will collect data. It takes a value of datatype time duration; a time duration string is a possibly signed sequence of decimal numbers, each with optional fraction and a unit suffix, such as "30ms", "1.5h" or "2h45m". Valid time units are "s", "m", "h". The default is 1h.	[pprof]
cpu_interval	Specifies how long Command Center will conduct CPU profiling. It takes a value of datatype time duration; a time duration string is a possibly signed sequence of decimal numbers, each with optional fraction and a unit suffix, such as "30ms", "1.5h" or "2h45m". Valid time units are "s", "m", "h". The default is 10s.	[pprof]
ttl	Specifies time-to-live for profile logs. It takes a value of datatype time duration; a time duration string is a possibly signed sequence of decimal numbers, each with optional fraction and a unit suffix, such as "30ms", "1.5h" or "2h45m". Valid time units are "s", "m", "h". The default is 24h	[pprof]
profiles	Specifies a comma-delimited list of benchmarking profile names. Valid values are heap -- which means Command Center collects heap benchmark data, cpu -- which means Command Center collects CPU benchmark data, and heap,cpu -- which means Command Center collects both. The default is heap.	[pprof]