This document contains release information about Tanzu Greenplum Command Center 6.7 releases. Greenplum Command Center 6.7 provides management and monitoring functionality for Tanzu Greenplum Database 6.
This topic contains release notes for Greenplum Command Center 6.7.
Greenplum Command Center 6.7 is compatible with the following platforms.
See Tanzu Greenplum Command Center Supported Platforms for the most current compatibility information.
Release Date: 2022-05-18
VMware Tanzu Greenplum Command Center 6.7.1 is a maintenance release that resolves several issues and introduces a new feature.
Command Center introduces a new server configuration parameter --
gpcc.enable_send_lock_info -- that helps reduce memory consumption; when disabled, Command Center stops collecting lock information for queries. For more information, see the Server Configuration Parameters topic.
 Resolved an issue where users creating GPSS jobs could not upload
.yaml files using Safari and Firefox.
 Resolved an issue where Command Center was continuing to collect lock information when
gpcc.enable_send_instrument was disabled, which could cause memory usage to bloat. To resolve this, users can set the new
gpcc.enable_send_lock_info server configuration parameter to off.
Release Date: 2022-4-29
VMware Tanzu Greenplum Command Center 6.7.0 is a minor release that includes feature changes and resolves several issues.
Command Center is now supported on Red Hat Enterprise Linux 8.x.
A user can now create Workload Management rules based on CPU skew. For more information, see the Workload Management documentation page.
The realtime Query Details page now displays information about the queries being executed inside a function that a running query has called. For more information, see the Query Details documentation page.
The realtime Query Details page now displays a query's Process ID. For more information, see the Query Details documentation page.
The Query History details page now displays a query's peak memory. For more information, see the Query History Details documentation page.
A user can now search query history by query ID, using the Advanced Search tool in the History dashboard. For more information, see the History documentation page.
A user can now create and manage from within Command Center GPSS client jobs for loading data from Amazon S3 into Greenplum Database. For more information, see the Data Loading documentation page.
The Recommendations page now:
includes an "Age Rank" report, which contains recommendations and information related to performing
VACUUM FREEZE and
VACUUM FULL on tables
offers recommendations on which tables should have
VACUUM FREEZE performed on them to reduce their age
highlights which tables have had
VACUUM FREEZE or
VACUUM FULL performed on them
allows users to export "Age Rank" from the Recommendations report page to identify which tables should have
VACUUM FREEZE performed on them
For more information, see the Recommendations documentation page.
The gpmetrics configuration file (
gpcc.conf) contains new sections and properties governing various aspects of Command Center behavior:
A user can now specify the age a table must reach to prompt Command Center to issue a
VACUUM FREEZE recommendation. This is configured with the new
age_ratio parameter in the
gpcc.conf configuration file.
In a new section called
pprof a user can configure various properties that govern how Command Center gathers performance data captured in the
In a new section called
gpss, a user can configure various properties that govern how Command Center connects with Greenplum Streaming Server (GPSS) in order to load data.
For more information, see the gpmetrics Configuration File Reference.
You can now turn off table statistics collection by setting the
stats_check_interval configuration property to
-1. For more information, see the gpmetrics Configuration File Reference.
Command Center now captures -- in
$GPCC_HOME/logs/*.prof files -- backend performance data for use when troubleshooting heap- or CPU-related performance issues with VMware Support. For more information, see Administering Log Files, Work Files, and Performance Data.
gpmetrics schema has a number of changes:
gpmetrics.gpcc_table_info_history tables now contain two new columns:
age_percent column, which tracks information for calculating when a table should have
VACUUM FREEZE run on it and
last_vacuum_freeze, which records the last time that one of VACUUM FULL, VACUUM FREEZE and VACUUM FULL FREEZE was performed on the table. In addition, the
last_vacuum_full column has been updated to record the last time
VACUUM FULL FREEZE was performed on the table.
gpmetrics schema contains three new user-defined functions:
gpcc_queries_top_10_cpu_per_resgroup -- for retrieving by resource group the top ten queries utilitizing the most memory and CPU, respectively and
gpcc_recommendations -- which returns a list of tables in need of a vacuum-related action such as
gpmetrics.gpcc_wlm_rule table has two new columns:
cpuskew_duration_sec. If the CPU skew percent of a query is equal to or higher than
cpuskew_duration_sec seconds, Command Center executes this rule.
gpmetrics schema includes two new tables --
gpmetrics.gpcc_gpss_job -- which stores information about data loading jobs -- and
gpmetrics.gpcc_gpss_log -- which contains logging-related information for data loading jobs. Both are related to the new data loading feature, which allows users to create and manage Greenplum Database Streaming Server jobs directly from Command Center.
For more information, see the gpmetrics Schema Reference.
There are three new server configuration parameters:
gpcc.enable_save_full_query_text - When turned on, Command Center saves the full query text for queries whose text is longer than 100KB
gpcc.enable_send_inner_query - When turned on, users can see the statements within functions that the query is calling when they click the Inner Queries tab in the query monitor's Query Detail view.
gpcc.enable_send_instrument - When turned off, Command Center does not display some query details -- such as the visual query plan tree -- and some statistics. This reduces Command Center's memory consumption.
For more information, see the Server Configuration Parameters.
 Resolved a memory issue caused by long query texts.
 Resolved a crash issue caused by inner queries.
The following are known issues in the current Greenplum Command Center release.
 If a user creates a data loading job with the same data source and target table as an existing job, the existing job will be updated even if it was created by a different user.
 Users cannot use the cursor to edit the S3 file location they've entered when creating a data loading job.
 Command Center does not monitor FETCH queries.
 Submitting a large query string with
psql -c or libraries causes Command Center performance issues.
 When the "Query is blocked for xxx minutes" alert is triggered, the query ID shown on the notification feed may be incorrect.
[178295227"] Resource group assignment by a query tags rule has no effect if the query tags are defined by
PGOPTIONS with single quotes.
 When Daylight Saving Time occurs, Command Center requires a restart to repopulate certain data metrics.
 When using the
gppersistentrebuild utility, the Last Accessed column in the Table Browser view might be refreshed, although no queries accessed the tables.
 When you define a workload management rule that uses the Planner Cost condition, the input field transforms your entry to a double datatype value. This can limit the ability to accurately define large planner costs that may be necessary for the GPORCA optimizer. For example, if you enter the GPORCA maximum cost value as 1457494496834852608, the actual value is converted to 1457494496834852600 for the rule. The value shown in the completed rule definition is the value that the rule enforces, and it may not be the exact value that you entered. Increase the cost value as necessary to cover the cost you want to set as the maximum.
 If you recreate the
gp_wlm extension from outside of Command Center after you have already created workload management rules using the Command Center interface, the rules engine may not run for a period of roughly 1 hour. This behavior occurs because Command Center checks for the availability of the extension every hour. Any changes you make outside of Command Center in this situation will not be visible until Command Center checks for the extension, or until you login to Command Center and access the Workload> Workload Mgmt page.
 If you upgrade your Command Center installation using the
gpccinstall -u option and you also specify an SSH binary using the
-ssh-path <path> option, the customized SSH path will not be used during the installation and the
ssh_path parameter will not be set in the
When viewing the Table Browser view, the calculated size for a partitioned table is incorrect if some child partitions are in different schemas than the root table.
If there are a large number of tables in a schema in a database, sorting the partition table list by size can take a long time to display.