summaryrefslogtreecommitdiff
path: root/mysql-test/main/rowid_filter_innodb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/rowid_filter_innodb.result')
-rw-r--r--mysql-test/main/rowid_filter_innodb.result78
1 files changed, 52 insertions, 26 deletions
diff --git a/mysql-test/main/rowid_filter_innodb.result b/mysql-test/main/rowid_filter_innodb.result
index 390c7834a0a..c2b3b194c37 100644
--- a/mysql-test/main/rowid_filter_innodb.result
+++ b/mysql-test/main/rowid_filter_innodb.result
@@ -125,7 +125,8 @@ ANALYZE
"r_loops": 1,
"rows": 510,
"r_rows": 60,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 10.075,
"r_filtered": 100,
"index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'",
@@ -247,7 +248,8 @@ ANALYZE
"r_loops": 1,
"rows": 510,
"r_rows": 510,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 10.075,
"r_filtered": 11.765,
"index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'",
@@ -397,7 +399,8 @@ ANALYZE
"r_loops": 1,
"rows": 98,
"r_rows": 98,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 100,
"r_filtered": 100,
"attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-01-31'",
@@ -414,7 +417,8 @@ ANALYZE
"r_loops": 98,
"rows": 1,
"r_rows": 1,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 4.7333,
"r_filtered": 11.224,
"attached_condition": "orders.o_totalprice between 200000 and 230000"
@@ -515,7 +519,8 @@ ANALYZE
"r_loops": 1,
"rows": 98,
"r_rows": 98,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 100,
"r_filtered": 100,
"attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-01-31'",
@@ -532,7 +537,8 @@ ANALYZE
"r_loops": 98,
"rows": 1,
"r_rows": 1,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 4.7333,
"r_filtered": 11.224,
"attached_condition": "orders.o_totalprice between 200000 and 230000"
@@ -633,7 +639,8 @@ ANALYZE
"r_loops": 1,
"rows": 144,
"r_rows": 144,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 100,
"r_filtered": 100,
"attached_condition": "orders.o_totalprice between 180000 and 230000",
@@ -656,7 +663,8 @@ ANALYZE
"r_loops": 144,
"rows": 4,
"r_rows": 6.625,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 0.8557,
"r_filtered": 1.6771,
"attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30' and lineitem.l_quantity > 45"
@@ -763,7 +771,8 @@ ANALYZE
"r_loops": 1,
"rows": 144,
"r_rows": 144,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 100,
"r_filtered": 100,
"attached_condition": "orders.o_totalprice between 180000 and 230000",
@@ -786,7 +795,8 @@ ANALYZE
"r_loops": 144,
"rows": 4,
"r_rows": 6.625,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 0.8557,
"r_filtered": 1.6771,
"attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30' and lineitem.l_quantity > 45"
@@ -888,7 +898,8 @@ ANALYZE
"r_loops": 1,
"rows": 71,
"r_rows": 71,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 100,
"r_filtered": 100,
"attached_condition": "orders.o_totalprice between 200000 and 230000",
@@ -910,7 +921,8 @@ ANALYZE
"r_loops": 71,
"rows": 4,
"r_rows": 6.7042,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 8.4929,
"r_filtered": 7.7731,
"attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'"
@@ -1032,7 +1044,8 @@ ANALYZE
"r_loops": 1,
"rows": 71,
"r_rows": 71,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 100,
"r_filtered": 100,
"attached_condition": "orders.o_totalprice between 200000 and 230000",
@@ -1054,7 +1067,8 @@ ANALYZE
"r_loops": 71,
"rows": 4,
"r_rows": 6.7042,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 8.4929,
"r_filtered": 7.7731,
"attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'"
@@ -1198,7 +1212,8 @@ ANALYZE
"r_loops": 1,
"rows": 18,
"r_rows": 18,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 0.5662,
"r_filtered": 38.889,
"index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'",
@@ -1215,7 +1230,8 @@ ANALYZE
"r_loops": 7,
"rows": 1,
"r_rows": 1,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 5.6667,
"r_filtered": 14.286,
"attached_condition": "orders.o_totalprice between 200000 and 250000"
@@ -1318,7 +1334,8 @@ ANALYZE
"r_loops": 1,
"rows": 18,
"r_rows": 18,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 0.5662,
"r_filtered": 38.889,
"index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'",
@@ -1335,7 +1352,8 @@ ANALYZE
"r_loops": 7,
"rows": 1,
"r_rows": 1,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 5.6667,
"r_filtered": 14.286,
"attached_condition": "orders.o_totalprice between 200000 and 250000"
@@ -1438,7 +1456,8 @@ ANALYZE
"r_loops": 1,
"rows": 41,
"r_rows": 41,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 3.3333,
"r_filtered": 2.439,
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
@@ -1460,7 +1479,8 @@ ANALYZE
"r_loops": 1,
"rows": 4,
"r_rows": 6,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 3.0475,
"r_filtered": 66.667,
"attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'"
@@ -1559,7 +1579,8 @@ ANALYZE
"r_loops": 1,
"rows": 41,
"r_rows": 41,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 3.3333,
"r_filtered": 2.439,
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
@@ -1581,7 +1602,8 @@ ANALYZE
"r_loops": 1,
"rows": 4,
"r_rows": 6,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 3.0475,
"r_filtered": 66.667,
"attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'"
@@ -1693,7 +1715,8 @@ ANALYZE
"r_loops": 1,
"rows": 41,
"r_rows": 41,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 2.0711,
"r_filtered": 2.439,
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
@@ -1715,7 +1738,8 @@ ANALYZE
"r_loops": 1,
"rows": 4,
"r_rows": 6,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 3.0475,
"r_filtered": 66.667,
"attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'"
@@ -1824,7 +1848,8 @@ ANALYZE
"r_loops": 1,
"rows": 41,
"r_rows": 41,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 2.0711,
"r_filtered": 2.439,
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
@@ -1846,7 +1871,8 @@ ANALYZE
"r_loops": 1,
"rows": 4,
"r_rows": 6,
- "r_total_time_ms": "REPLACED",
+ "r_table_time_ms": "REPLACED",
+ "r_other_time_ms": "REPLACED",
"filtered": 3.0475,
"r_filtered": 66.667,
"attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'"
View Lorry Controller Status