Metrics Collector Server Configuration Parameters

The metrics collector extension in Greenplum Database defines custom server configuration parameters to configure metrics collection options. If the metrics collector extension is installed and the value of the shared_preload_libraries configuration parameter includes metrics_collector when Greenplum Database starts, these parameters can be viewed and set using the Greenplum Database gpconfig utility.

Enables collection of query metrics in Greenplum Database. When on, the metrics collector sends query metrics to the Greenplum Command Center agent.
Type: boolean
Default: on

When off the metrics collector does not collect queries executed by the gpmon user in the gpperfmon database or plan node history for queries that run in less than ten seconds (or min_query_time, if it is set and greater than 10 seconds). If enabled in a session, the metrics collector collects those queries in the session.
NOTE: Enabling this parameter in Greenplum Database 6.3.0, 6.4.0, or 6.5.0 could cause Greenplum Database to crash. The recommended workaround is to install Greenplum Command Center 6.2.0 and to upgrade the metrics collector extension using the gppkg package included with Command Center 6.2.0.
Type: boolean
Default: off

The port number to send query metrics. The metrics collector sends query metrics to the Greenplum Command Center agent process on this port.
Type: integer
Default: 9898