[30956] - When exporting the queries history page to a CSV file, the Submitted field
contained the time of the query but not the date. For example, in the GPCC UI, the
Submitted field would show 2020-09-13 10:25:11 but the CSV file would only show 10:25:11.
This issue has been resolved.
[174798424] - When creating a rule condition containing more than one slice, the rule
condition was ignored, and the query ran normally. This issue has been resolved.
[174796107] - When updating the status of a workload management rule to inactive, when
the rule condition was met, the rule remained active . This issue also appeared when
deactivating multiple rules in a set, and when one rule of the set had been deleted but the
rest remained in the inactive status. This issue has been resolved.
[174795058] - On the Query History Detail page, a query's Submitted Time did not match
the one displayed on the Query List page. This issue has been resolved.
[174983144] - On the Query Monitor page, when the query list extended further than the
window size, the Workload dropdown column did not display correctly. This issue has been
resolved.
[174922355] - When a partition's root table appeared in the Accuracy % Rank list, the row
count column incorrectly showed a 0 (nil) value. This issue has been resolved.
[174767109] - When creating a rule using the Planner Cost condition, and subsequently
deleting that condition by reducing the planner cost to "0", the updated rule still showed:
"planner cost is greater than [0,0]". This issue has been resolved.
Release 4.11.0
Workload Management
The Command Center interface for managing workload assignment rules has moved to a
new page, Workload> Workload Mgmt. Resource group configuration and idle session
management controls remain on the Workload> Resource Groups page. See Workload
Management.
Workload management rules can now be assigned using any combination of resource group
name (or all resource groups, by default), database role, and query tag identifiers.
Workload management rules can include one or more conditions that must be met before
the rule action is performed. Conditions are triggered after configured maximum values for
CPU time, Planner Cost, Running time, Slices, or Total Disk I/O are exceeded by a query.
For Greenplum 6.8 or later, you can configure workload management rules to automatically
move queries to a specified resource group. These rules can be created on earlier
Greenplum versions, but are immediately placed in the Inactive state.
Command Center automatically attempts to retry applying a failed rule action 2 times, after
waiting a minimum of 15 seconds between retries. You can configure the time interval using
the new configuration parameter, wlm_query_cooldown_time. See Greenplum Command
Center Parameters.
A new configuration parameter, wlm_short_query_threshold , can be used to ensure that
Command Center only applies workload management rules after a query has run for at least