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.

gpcc.enable_send_query_info
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

gpcc.enable_query_profiling
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: Setting this parameter to on in Greenplum Database 5.24.0, 5.24.2, or 5.25.0 may cause Greenplum Database to crash, so you should not enable this parameter in those Greenplum Database versions.
Type: boolean
Default: off

gpcc.query_metrics_port
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