You can monitor the status of PXF from the command line.
PXF also provides additional information about the runtime status of the PXF Service by exposing HTTP endpoints that you can use to query the health, build information, and various metrics of the running process.
pxf cluster status command displays the status of the PXF Service instance on all hosts in your Greenplum Database cluster.
pxf status displays the status of the PXF Service instance on the local Greenplum host.
gpadmin user can request the status of the PXF Service.
Perform the following procedure to request the PXF status of your Greenplum Database cluster.
Log in to the Greenplum Database master host:
$ ssh gpadmin@<gpmaster>
pxf cluster status command:
gpadmin@gpmaster$ pxf cluster status
PXF exposes the following HTTP endpoints that you can use to monitor a running PXF Service on the local host:
actuator/health- Returns the status of the PXF Service.
actuator/info- Returns build information for the PXF Service.
actuator/metrics- Returns JVM, extended Tomcat, system, process, Log4j2, and PXF-specific metrics for the PXF Service.
actuator/prometheus- Returns all metrics in a format that can be scraped by a Prometheus server.
Any user can access the HTTP endpoints and view the monitoring information that PXF returns.
You can view the data associated with a specific endpoint by viewing in a browser, or
curl-ing, a URL of the following format:
For example, to view the build information for the PXF service running on
localhost, query the
To view the status of the PXF Service running on the local Greenplum Database host, query the
PXF exposes JVM, extended Tomcat, and system metrics via its integration with Spring Boot. Refer to Supported Metrics in the Spring Boot documentation for more information about these metrics.
PXF also exposes metrics that are specific to its processing, including:
|pxf.fragments.sent||The number of fragments, and the total time that it took to send all fragments to Greenplum Database.|
|pxf.records.sent||The number of records that PXF sent to Greenplum Database.|
|pxf.records.received||The number of records that PXF received from Greenplum Database.|
|pxf.bytes.sent||The number of bytes that PXF sent to Greenplum Database.|
|pxf.bytes.received||The number of bytes that PXF received from Greenplum Database.|
|http.server.requests||Standard metric augmented with PXF tags.|
The information that PXF returns when you query a metric is the aggregate data collected since the last (re)start of the PXF Service.
To view a list of all of the metrics (names) available from the PXF Service, query just the
PXF tags all metrics that it returns with an
application label; the value of this tag is always
PXF tags its specific metrics with the additional labels:
server. All of these tags are present for each PXF metric. PXF returns the tag value
unknown when the value cannot be determined.
You can use the tags to filter the information returned for PXF-specific metrics. For example, to examine the
pxf.records.received metric for the PXF server named
hadoop1 located on
segment 1 on the local host:
Certain metrics, such as
pxf.fragments.sent, include an additional tag named
outcome; you can examine its value (
error) to determine if all data for the fragment was sent. You can also use this tag to filter the aggregated data.