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