將檔案拖放至此處

SQL 上載 ( 0 ) x -

頁面相關設定 點選此列以回到頁面頂端
請按 Ctrl+Enter 執行查詢 請按 Enter 執行查詢
遞增
遞減
排序：
SQL 偵錯
次數
執行排序
使用時間
排序依：
群組查詢
解除群組查詢
摺疊 展開 顯示追蹤 隱藏追蹤 次數 : 使用時間 :
書籤
重新整理
新增
無書籤
新增書籤
選項
設為預設值





摺疊 展開 重新查詢 編輯 語句分析 效能分析 書籤 查詢失敗 資料庫 : 查詢時間 :
資料表結構設定 (欄位清單)。
資料表結構
說明文件 是否隱藏資料表結構操作項目。 還原預設值
說明文件 在資料表結構畫面，是否顯示欄位備註 還原預設值
預設轉換
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值
說明文件 預設轉換的選項清單值。若轉換已於資料表結構頁輸入，則此等值會被覆蓋。 還原預設值

events_statements_history_long

# 名稱 類型 編碼與排序 屬性 空值(Null) 預設值 備註 額外資訊
1 bigint(20) UNSIGNED 否 無 Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
2 bigint(20) UNSIGNED 否 無 Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
3 bigint(20) UNSIGNED 是 NULL NULL when the event starts, set to the thread's current event number at the end of the event.
4 varchar(128) utf8_general_ci 否 無 Event instrument name and a NAME from the setup_instruments table
5 varchar(64) utf8_general_ci 是 NULL Name and line number of the source file containing the instrumented code that produced the event.
6 bigint(20) UNSIGNED 是 NULL Value in picoseconds when the event timing started or NULL if timing is not collected.
7 bigint(20) UNSIGNED 是 NULL Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
8 bigint(20) UNSIGNED 是 NULL Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
9 bigint(20) UNSIGNED 否 無 Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
10 longtext utf8_general_ci 是 NULL The SQL statement, or NULL if the command is not associated with an SQL statement.
11 varchar(32) utf8_general_ci 是 NULL Statement digest.
12 longtext utf8_general_ci 是 NULL Statement digest text.
13 varchar(64) utf8_general_ci 是 NULL Statement's default database for the statement, or NULL if there was none.
14 varchar(64) utf8_general_ci 是 NULL Reserved, currently NULL
15 varchar(64) utf8_general_ci 是 NULL Reserved, currently NULL
16 varchar(64) utf8_general_ci 是 NULL Reserved, currently NULL
17 bigint(20) UNSIGNED 是 NULL Address in memory of the statement object.
18 int(11) 是 NULL Error code. See MariaDB Error Codes for a full list.
19 varchar(5) utf8_general_ci 是 NULL The SQLSTATE value.
20 varchar(128) utf8_general_ci 是 NULL Statement error message. See MariaDB Error Codes.
21 bigint(20) UNSIGNED 否 無 0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
22 bigint(20) UNSIGNED 否 無 Number of warnings from the diagnostics area.
23 bigint(20) UNSIGNED 否 無 Number of rows affected the statement affected.
24 bigint(20) UNSIGNED 否 無 Number of rows returned.
25 bigint(20) UNSIGNED 否 無 Number of rows read during the statement's execution.
26 bigint(20) UNSIGNED 否 無 Number of on-disk temp tables created by the statement.
27 bigint(20) UNSIGNED 否 無 Number of temp tables created by the statement.
28 bigint(20) UNSIGNED 否 無 Number of joins performed by the statement which did not use an index.
29 bigint(20) UNSIGNED 否 無 Number of joins performed by the statement which used a range search of the first table.
30 bigint(20) UNSIGNED 否 無 Number of joins performed by the statement which used a range of the first table.
31 bigint(20) UNSIGNED 否 無 Number of joins without keys performed by the statement that check for key usage after each row.
32 bigint(20) UNSIGNED 否 無 Number of joins performed by the statement which used a full scan of the first table.
33 bigint(20) UNSIGNED 否 無 Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the sort_buffer_size.
34 bigint(20) UNSIGNED 否 無 Number of sorts performed by the statement which used a range.
35 bigint(20) UNSIGNED 否 無 Number of rows sorted by the statement.
36 bigint(20) UNSIGNED 否 無 Number of sorts performed by the statement which used a full table scan.
37 bigint(20) UNSIGNED 否 無 0 if the statement performed a table scan with an index, 1 if without an index.
38 bigint(20) UNSIGNED 否 無 0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the EXPLAIN article.
39 bigint(20) UNSIGNED 是 NULL Reserved, currently NULL.
40 enum('STATEMENT', 'STAGE', 'WAIT') utf8_general_ci 是 NULL Reserved, currently NULL.
已選擇項目： 已選擇項目：
分區 說明文件
資訊
資料列統計資訊
格式 動態
編碼與排序 utf8_general_ci
資料列數 10,000
資料列大小 0 B
下個自動索引 0
建立時間 2026-01-22 08:53:25
最後更新時間 2026-01-22 08:53:25
最後檢查時間 2026-01-22 08:53:25