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.

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