The events_stages_current table shows the current stage event for each thread, including timer information and nesting details.
The events_stages_current table contains current stage events, with each row being a record of a thread and its most recent stage event.
The table contains the following columns:
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID
It is possible to empty this table with a TRUNCATE TABLE statement.
The related tables, and derive their values from the current events.
This page is licensed: CC BY-SA / Gnu FDL
NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
NESTING_EVENT_ID
EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE
Nesting event type. One of transaction, statement, stage or wait.