This table summarizes stage events aggregated by the client host and the event name, allowing performance analysis per host.
The table lists stage events, summarized by thread and event name.
It contains the following columns:
EVENT_NAME
Event name.
COUNT_STAR
Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT
Total wait time of the timed summarized events.
This page is licensed: CC BY-SA / Gnu FDL
MIN_TIMER_WAIT
Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT
Average wait time of the timed summarized events.
MAX_TIMER_WAIT
Maximum wait time of the timed summarized events.
SELECT * FROM events_stages_summary_global_by_event_name\G
...
*************************** 106. row ***************************
EVENT_NAME: stage/sql/Waiting for trigger metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 107. row ***************************
EVENT_NAME: stage/sql/Waiting for event metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 108. row ***************************
EVENT_NAME: stage/sql/Waiting for commit lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 109. row ***************************
EVENT_NAME: stage/aria/Waiting for a resource
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0