Sample output
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count % of total
------------------------ ------------ ---------- --------- ----------
Total Parallel Queries 0.1 0.3 19 n/a
WP Adjustments Made
Due to WP Limit 0.0 0.0 0 0.0 %
Due to No WPs 0.0 0.0 0 0.0 %
Merge Lock Requests per sec per xact count % of total
------------------------ ------------ ---------- --------- ----------
Network Buffer Merge Locks
Granted with no wait 1.1 5.0 320 21.3 %
Granted after wait 3.9 18.4 1179 78.7 %
Result Buffer Merge Locks
Granted with no wait 0.0 0.0 0 0.0 %
Granted after wait 0.0 0.0 0 0.0 %
Work Table Merge Locks
Granted with no wait 0.0 0.0 0 0.0 %
Granted after wait 0.0 0.0 0 0.0 %
------------------------ ------------ ---------- --------- ----------
Total # of Requests 5.0 23.4 1499
Sort Buffer Waits per sec per xact count % of total
------------------------ ------------ ---------- --------- ----------
Producer Waits 0.0 0.1 8 100.0 %
Consumer Waits 0.0 0.0 0 0.0 %
------------------------ ------------ ---------- --------- ----------
Total # of Waits 0.0 0.1 8