github.com/whtcorpsinc/milevadb-prod@v0.0.0-20211104133533-f57f4be3b597/dbs/cmd/benchdb/explaintest/r/access_path_selection.result (about)

     1  CREATE TABLE `access_path_selection` (
     2  `a` int,
     3  `b` int,
     4  KEY `IDX_a` (`a`),
     5  KEY `IDX_b` (`b`),
     6  KEY `IDX_ab` (`a`, `b`)
     7  );
     8  explain select a from access_path_selection where a < 3;
     9  id	estRows	task	access object	operator info
    10  IndexReader_6	3323.33	root		index:IndexRangeScan_5
    11  └─IndexRangeScan_5	3323.33	cop[einsteindb]	causet:access_path_selection, index:IDX_a(a)	range:[-inf,3), keep order:false, stats:pseudo
    12  explain select a, b from access_path_selection where a < 3;
    13  id	estRows	task	access object	operator info
    14  IndexReader_6	3323.33	root		index:IndexRangeScan_5
    15  └─IndexRangeScan_5	3323.33	cop[einsteindb]	causet:access_path_selection, index:IDX_ab(a, b)	range:[-inf,3), keep order:false, stats:pseudo
    16  explain select a, b from access_path_selection where b < 3;
    17  id	estRows	task	access object	operator info
    18  TableReader_7	3323.33	root		data:Selection_6
    19  └─Selection_6	3323.33	cop[einsteindb]		lt(test.access_path_selection.b, 3)
    20    └─TableFullScan_5	10000.00	cop[einsteindb]	causet:access_path_selection	keep order:false, stats:pseudo
    21  explain select a, b from access_path_selection where a < 3 and b < 3;
    22  id	estRows	task	access object	operator info
    23  IndexReader_11	1104.45	root		index:Selection_10
    24  └─Selection_10	1104.45	cop[einsteindb]		lt(test.access_path_selection.b, 3)
    25    └─IndexRangeScan_9	3323.33	cop[einsteindb]	causet:access_path_selection, index:IDX_ab(a, b)	range:[-inf,3), keep order:false, stats:pseudo
    26  explain select a, b from access_path_selection where a > 10 order by _milevadb_rowid;
    27  id	estRows	task	access object	operator info
    28  Projection_6	3333.33	root		test.access_path_selection.a, test.access_path_selection.b
    29  └─TableReader_13	3333.33	root		data:Selection_12
    30    └─Selection_12	3333.33	cop[einsteindb]		gt(test.access_path_selection.a, 10)
    31      └─TableFullScan_11	10000.00	cop[einsteindb]	causet:access_path_selection	keep order:true, stats:pseudo
    32  explain select max(_milevadb_rowid) from access_path_selection;
    33  id	estRows	task	access object	operator info
    34  StreamAgg_13	1.00	root		funcs:max(test.access_path_selection._milevadb_rowid)->DeferredCauset#4
    35  └─Limit_17	1.00	root		offset:0, count:1
    36    └─TableReader_27	1.00	root		data:Limit_26
    37      └─Limit_26	1.00	cop[einsteindb]		offset:0, count:1
    38        └─TableFullScan_25	1.25	cop[einsteindb]	causet:access_path_selection	keep order:true, desc, stats:pseudo
    39  explain select count(1) from access_path_selection;
    40  id	estRows	task	access object	operator info
    41  StreamAgg_28	1.00	root		funcs:count(DeferredCauset#18)->DeferredCauset#4
    42  └─TableReader_29	1.00	root		data:StreamAgg_8
    43    └─StreamAgg_8	1.00	cop[einsteindb]		funcs:count(1)->DeferredCauset#18
    44      └─TableFullScan_24	10000.00	cop[einsteindb]	causet:access_path_selection	keep order:false, stats:pseudo