GPCC not displaying Query plan
search cancel

GPCC not displaying Query plan

book

Article ID: 388402

calendar_today

Updated On:

Products

VMware Tanzu Greenplum VMware Tanzu Data Services VMware Tanzu Data Suite

Issue/Introduction

After a new Greenplum Install, GPCC query monitor page was not displaying stats on new queries run or the visual query plan. There were no errors in the GPCC logs or GPDB logs. Everything else seemed to be working in GPCC. 

The following warnings were displayed on the query monitor page

Warning: some query details cannot be displayed. 

 

and under plan and progress tab

Warning: The visual plan is unavailable

 

Cause

The cluster was not set up correctly with NTP and the time was off on one of the servers. 

 

gpssh -f ~/hostfile_all date
[mdw] Sat Feb 15 15:18:23 +04 2025
[sdw1] Sat Feb 15 15:18:23 +04 2025
[sdw2] Sat Feb 15 16:29:51 +04 2025 <<<<<<<<<<<<<<<
[sdw3] Sat Feb 15 16:19:04 +04 2025

Resolution

Make sure when installing Greenplum that NTP is installed and synced on all the cluster members as described in the install Documents.

 

After setting the time correctly on all hosts GPCC functioned as designed.