1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
DESC sys.statement_analysis;
Field Type Null Key Default Extra
query longtext YES NULL
db varchar(64) YES NULL
full_scan varchar(1) NO
exec_count bigint unsigned NO NULL
err_count bigint unsigned NO NULL
warn_count bigint unsigned NO NULL
total_latency varchar(11) YES NULL
max_latency varchar(11) YES NULL
avg_latency varchar(11) YES NULL
lock_latency varchar(11) YES NULL
cpu_latency varchar(11) YES NULL
rows_sent bigint unsigned NO NULL
rows_sent_avg decimal(21,0) NO 0
rows_examined bigint unsigned NO NULL
rows_examined_avg decimal(21,0) NO 0
rows_affected bigint unsigned NO NULL
rows_affected_avg decimal(21,0) NO 0
tmp_tables bigint unsigned NO NULL
tmp_disk_tables bigint unsigned NO NULL
rows_sorted bigint unsigned NO NULL
sort_merge_passes bigint unsigned NO NULL
max_controlled_memory varchar(11) YES NULL
max_total_memory varchar(11) YES NULL
digest varchar(64) YES NULL
first_seen timestamp(6) NO NULL
last_seen timestamp(6) NO NULL
SELECT * FROM sys.statement_analysis;
DESC sys.x$statement_analysis;
Field Type Null Key Default Extra
query longtext YES NULL
db varchar(64) YES NULL
full_scan varchar(1) NO
exec_count bigint unsigned NO NULL
exec_secondary_count bigint unsigned NO NULL
err_count bigint unsigned NO NULL
warn_count bigint unsigned NO NULL
total_latency bigint unsigned NO NULL
max_latency bigint unsigned NO NULL
avg_latency bigint unsigned NO NULL
lock_latency bigint unsigned NO NULL
cpu_latency bigint unsigned NO NULL
rows_sent bigint unsigned NO NULL
rows_sent_avg decimal(21,0) NO 0
rows_examined bigint unsigned NO NULL
rows_examined_avg decimal(21,0) NO 0
rows_affected bigint unsigned NO NULL
rows_affected_avg decimal(21,0) NO 0
tmp_tables bigint unsigned NO NULL
tmp_disk_tables bigint unsigned NO NULL
rows_sorted bigint unsigned NO NULL
sort_merge_passes bigint unsigned NO NULL
max_controlled_memory bigint unsigned NO NULL
max_total_memory bigint unsigned NO NULL
digest varchar(64) YES NULL
first_seen timestamp(6) NO NULL
last_seen timestamp(6) NO NULL
SELECT * FROM sys.x$statement_analysis;
|
