vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/multi-output/gen4-output.txt (about)

     1  ----------------------------------------------------------------------
     2  select * from user_region where regionId = 4611686018427387904 and userId = 100 /* exact shard */
     3  
     4  1 ks_sharded/40-80: select * from user_region where regionId = 4611686018427387904 and userId = 100 limit 10001 /* exact shard */
     5  
     6  ----------------------------------------------------------------------
     7  select * from user_region where regionId = 4611686018427387904 /* subshard */
     8  
     9  1 ks_sharded/40-80: select * from user_region where regionId = 4611686018427387904 limit 10001 /* subshard */
    10  
    11  ----------------------------------------------------------------------
    12  select * from user_region where regionId in (4611686018427387903, 4611686018427387904) /* subshard */
    13  
    14  1 ks_sharded/-40: select * from user_region where regionId in (4611686018427387903) limit 10001 /* subshard */
    15  1 ks_sharded/40-80: select * from user_region where regionId in (4611686018427387904) limit 10001 /* subshard */
    16  
    17  ----------------------------------------------------------------------
    18  select * from user_region where userId = 100 /* scatter, needs prefix columns for subshard routing */
    19  
    20  1 ks_sharded/-40: select * from user_region where userId = 100 limit 10001 /* scatter, needs prefix columns for subshard routing */
    21  1 ks_sharded/40-80: select * from user_region where userId = 100 limit 10001 /* scatter, needs prefix columns for subshard routing */
    22  1 ks_sharded/80-c0: select * from user_region where userId = 100 limit 10001 /* scatter, needs prefix columns for subshard routing */
    23  1 ks_sharded/c0-: select * from user_region where userId = 100 limit 10001 /* scatter, needs prefix columns for subshard routing */
    24  
    25  ----------------------------------------------------------------------