> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_by_thread_by_event_name-table.md).

# Performance Schema events\_statements\_summary\_by\_thread\_by\_event\_name Table

The [Performance Schema](/docs/server/reference/system-tables/performance-schema.md) `events_statements_summary_by_thread_by_event_name` table contains statement events summarized by thread and event name. It contains the following columns:

| Column                          | Description                                                                              |
| ------------------------------- | ---------------------------------------------------------------------------------------- |
| THREAD\_ID                      | Thread associated with the event. Together with EVENT\_NAME uniquely identifies the row. |
| EVENT\_NAME                     | Event name. Used together with THREAD\_ID for grouping events.                           |
| COUNT\_STAR                     | Number of summarized events                                                              |
| SUM\_TIMER\_WAIT                | Total wait time of the summarized events that are timed.                                 |
| MIN\_TIMER\_WAIT                | Minimum wait time of the summarized events that are timed.                               |
| AVG\_TIMER\_WAIT                | Average wait time of the summarized events that are timed.                               |
| MAX\_TIMER\_WAIT                | Maximum wait time of the summarized events that are timed.                               |
| SUM\_LOCK\_TIME                 | Sum of the LOCK\_TIME column in the events\_statements\_current table.                   |
| SUM\_ERRORS                     | Sum of the ERRORS column in the events\_statements\_current table.                       |
| SUM\_WARNINGS                   | Sum of the WARNINGS column in the events\_statements\_current table.                     |
| SUM\_ROWS\_AFFECTED             | Sum of the ROWS\_AFFECTED column in the events\_statements\_current table.               |
| SUM\_ROWS\_SENT                 | Sum of the ROWS\_SENT column in the events\_statements\_current table.                   |
| SUM\_ROWS\_EXAMINED             | Sum of the ROWS\_EXAMINED column in the events\_statements\_current table.               |
| SUM\_CREATED\_TMP\_DISK\_TABLES | Sum of the CREATED\_TMP\_DISK\_TABLES column in the events\_statements\_current table.   |
| SUM\_CREATED\_TMP\_TABLES       | Sum of the CREATED\_TMP\_TABLES column in the events\_statements\_current table.         |
| SUM\_SELECT\_FULL\_JOIN         | Sum of the SELECT\_FULL\_JOIN column in the events\_statements\_current table.           |
| SUM\_SELECT\_FULL\_RANGE\_JOIN  | Sum of the SELECT\_FULL\_RANGE\_JOIN column in the events\_statements\_current table.    |
| SUM\_SELECT\_RANGE              | Sum of the SELECT\_RANGE column in the events\_statements\_current table.                |
| SUM\_SELECT\_RANGE\_CHECK       | Sum of the SELECT\_RANGE\_CHECK column in the events\_statements\_current table.         |
| SUM\_SELECT\_SCAN               | Sum of the SELECT\_SCAN column in the events\_statements\_current table.                 |
| SUM\_SORT\_MERGE\_PASSES        | Sum of the SORT\_MERGE\_PASSES column in the events\_statements\_current table.          |
| SUM\_SORT\_RANGE                | Sum of the SORT\_RANGE column in the events\_statements\_current table.                  |
| SUM\_SORT\_ROWS                 | Sum of the SORT\_ROWS column in the events\_statements\_current table.                   |
| SUM\_SORT\_SCAN                 | Sum of the SORT\_SCAN column in the events\_statements\_current table.                   |
| SUM\_NO\_INDEX\_USED            | Sum of the NO\_INDEX\_USED column in the events\_statements\_current table.              |
| SUM\_NO\_GOOD\_INDEX\_USED      | Sum of the NO\_GOOD\_INDEX\_USED column in the events\_statements\_current table.        |

The `*_TIMER_WAIT` columns only calculate results for timed events, as non-timed events have a `NULL` wait time.

## Example

```sql
SELECT * FROM events_statements_summary_by_thread_by_event_name\G
...
*************************** 3653. row ***************************
                  THREAD_ID: 64
                 EVENT_NAME: statement/com/Error
                 COUNT_STAR: 0
             SUM_TIMER_WAIT: 0
             MIN_TIMER_WAIT: 0
             AVG_TIMER_WAIT: 0
             MAX_TIMER_WAIT: 0
              SUM_LOCK_TIME: 0
                 SUM_ERRORS: 0
               SUM_WARNINGS: 0
          SUM_ROWS_AFFECTED: 0
              SUM_ROWS_SENT: 0
          SUM_ROWS_EXAMINED: 0
SUM_CREATED_TMP_DISK_TABLES: 0
     SUM_CREATED_TMP_TABLES: 0
       SUM_SELECT_FULL_JOIN: 0
 SUM_SELECT_FULL_RANGE_JOIN: 0
           SUM_SELECT_RANGE: 0
     SUM_SELECT_RANGE_CHECK: 0
            SUM_SELECT_SCAN: 0
      SUM_SORT_MERGE_PASSES: 0
             SUM_SORT_RANGE: 0
              SUM_SORT_ROWS: 0
              SUM_SORT_SCAN: 0
          SUM_NO_INDEX_USED: 0
     SUM_NO_GOOD_INDEX_USED: 0
*************************** 3654. row ***************************
                  THREAD_ID: 64
                 EVENT_NAME: statement/com/
                 COUNT_STAR: 0
             SUM_TIMER_WAIT: 0
             MIN_TIMER_WAIT: 0
             AVG_TIMER_WAIT: 0
             MAX_TIMER_WAIT: 0
              SUM_LOCK_TIME: 0
                 SUM_ERRORS: 0
               SUM_WARNINGS: 0
          SUM_ROWS_AFFECTED: 0
              SUM_ROWS_SENT: 0
          SUM_ROWS_EXAMINED: 0
SUM_CREATED_TMP_DISK_TABLES: 0
     SUM_CREATED_TMP_TABLES: 0
       SUM_SELECT_FULL_JOIN: 0
 SUM_SELECT_FULL_RANGE_JOIN: 0
           SUM_SELECT_RANGE: 0
     SUM_SELECT_RANGE_CHECK: 0
            SUM_SELECT_SCAN: 0
      SUM_SORT_MERGE_PASSES: 0
             SUM_SORT_RANGE: 0
              SUM_SORT_ROWS: 0
              SUM_SORT_SCAN: 0
          SUM_NO_INDEX_USED: 0
     SUM_NO_GOOD_INDEX_USED: 0
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}