Debian Codegraph @

mysql-test/suite/sysschema/r/v_statement_analysis.result

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