curl to greenplum exporter table_metrics endpoint can get stuck

Products

• VMware Tanzu Data
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Intelligence
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

Prometheus times out when trying to scrape the table_metrics endpoint, for example, the below curl request can get stuck:

curl -H "Authorization: Bearer xxxxx" http://<FQDN>:6162/table_metrics 

While at the same time, the endpoints for other metrics for example cluster_metrics can work fine

Environment

Greenplum Exporter work with Prometheus, here Greenplum Exporter is a comprehensive Prometheus exporter for Greenplum Database, providing detailed metrics for monitoring cluster health, performance, and resource utilization.

Cause

As advised in the documentation, table metrics come from the table gpmetrics.gpcc_table_info in gpperfmon database, we should consider whether the table is bloat or with missing statistics, which can result in notable slowness when querying it.

Resolution

Run VACUUM/VACUUM FULL + ANALYZE against gpmetrics.gpcc_table_info

Additional Information

refer to KB 431358 for more information on another possible failure scenario.