This element shows the last time the statement entry was processed. For cursor operations, stmt_last_use_time shows the time of the last action on the cursor where that action could be an open, fetch, or close. At application coordination nodes, this value reflects the application requests; at non-coordinator nodes, this value reflects when requests were received from the originating node.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Locking | - | - |
Deadlocks with Details History Values 1 | event_stmt_history | timestamp |
Deadlocks with Details History 1 | event_stmt_history | timestamp |
Activities | event_activitystmt | timestamp |
Use this element in conjunction with other statement history entries to see the sequence of SQL statements that caused the deadlock.