blob: 959f8628145fda7ff19896b4b7330711bcbe370b (
plain)
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
|
DESC sys.schema_index_statistics;
Field Type Null Key Default Extra
table_schema varchar(64) YES NULL
table_name varchar(64) YES NULL
index_name varchar(64) YES NULL
rows_selected bigint(20) unsigned NO NULL
select_latency varchar(12) YES NULL
rows_inserted bigint(20) unsigned NO NULL
insert_latency varchar(12) YES NULL
rows_updated bigint(20) unsigned NO NULL
update_latency varchar(12) YES NULL
rows_deleted bigint(20) unsigned NO NULL
delete_latency varchar(12) YES NULL
SELECT * FROM sys.schema_index_statistics;
DESC sys.x$schema_index_statistics;
Field Type Null Key Default Extra
table_schema varchar(64) YES NULL
table_name varchar(64) YES NULL
index_name varchar(64) YES NULL
rows_selected bigint(20) unsigned NO NULL
select_latency bigint(20) unsigned NO NULL
rows_inserted bigint(20) unsigned NO NULL
insert_latency bigint(20) unsigned NO NULL
rows_updated bigint(20) unsigned NO NULL
update_latency bigint(20) unsigned NO NULL
rows_deleted bigint(20) unsigned NO NULL
delete_latency bigint(20) unsigned NO NULL
SELECT * FROM sys.x$schema_index_statistics;
|
