vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/twopc-output/selectsharded-output.txt (about) 1 ---------------------------------------------------------------------- 2 select * from user /* scatter */ 3 4 1 ks_sharded/-40: select * from user limit 10001 /* scatter */ 5 1 ks_sharded/40-80: select * from user limit 10001 /* scatter */ 6 1 ks_sharded/80-c0: select * from user limit 10001 /* scatter */ 7 1 ks_sharded/c0-: select * from user limit 10001 /* scatter */ 8 9 ---------------------------------------------------------------------- 10 select * from user where id = 1 /* equal unique */ 11 12 1 ks_sharded/-40: select * from user where id = 1 limit 10001 /* equal unique */ 13 14 ---------------------------------------------------------------------- 15 select * from user where id > 100 /* scatter range */ 16 17 1 ks_sharded/-40: select * from user where id > 100 limit 10001 /* scatter range */ 18 1 ks_sharded/40-80: select * from user where id > 100 limit 10001 /* scatter range */ 19 1 ks_sharded/80-c0: select * from user where id > 100 limit 10001 /* scatter range */ 20 1 ks_sharded/c0-: select * from user where id > 100 limit 10001 /* scatter range */ 21 22 ---------------------------------------------------------------------- 23 select * from user where name = 'bob' /* vindex lookup */ 24 25 1 ks_sharded/c0-: select name, user_id from name_user_map where name in ('bob') limit 10001 /* vindex lookup */ 26 2 ks_sharded/-40: select * from user where name = 'bob' limit 10001 /* vindex lookup */ 27 28 ---------------------------------------------------------------------- 29 select * from user where name = 'bob' or nickname = 'bob' /* vindex lookup */ 30 31 1 ks_sharded/-40: select * from user where (name = 'bob' or nickname = 'bob') limit 10001 /* vindex lookup */ 32 1 ks_sharded/40-80: select * from user where (name = 'bob' or nickname = 'bob') limit 10001 /* vindex lookup */ 33 1 ks_sharded/80-c0: select * from user where (name = 'bob' or nickname = 'bob') limit 10001 /* vindex lookup */ 34 1 ks_sharded/c0-: select * from user where (name = 'bob' or nickname = 'bob') limit 10001 /* vindex lookup */ 35 36 ---------------------------------------------------------------------- 37 select u.id, u.name, u.nickname, n.info from user u join name_info n on u.name = n.name /* join on varchar */ 38 39 1 ks_sharded/-40: select u.id, u.name, u.nickname from user as u limit 10001 /* join on varchar */ 40 1 ks_sharded/40-80: select u.id, u.name, u.nickname from user as u limit 10001 /* join on varchar */ 41 1 ks_sharded/80-c0: select u.id, u.name, u.nickname from user as u limit 10001 /* join on varchar */ 42 1 ks_sharded/c0-: select u.id, u.name, u.nickname from user as u limit 10001 /* join on varchar */ 43 2 ks_sharded/40-80: select n.info from name_info as n where n.name = 'name_val_2' limit 10001 /* join on varchar */ 44 3 ks_sharded/40-80: select n.info from name_info as n where n.name = 'name_val_2' limit 10001 /* join on varchar */ 45 4 ks_sharded/40-80: select n.info from name_info as n where n.name = 'name_val_2' limit 10001 /* join on varchar */ 46 5 ks_sharded/40-80: select n.info from name_info as n where n.name = 'name_val_2' limit 10001 /* join on varchar */ 47 48 ---------------------------------------------------------------------- 49 select m.id, m.song, e.extra from music m join music_extra e on m.id = e.id where m.user_id = 100 /* join on int */ 50 51 1 ks_sharded/80-c0: select m.id, m.song from music as m where m.user_id = 100 limit 10001 /* join on int */ 52 2 ks_sharded/-40: select e.extra from music_extra as e where e.id = 1 limit 10001 /* join on int */ 53 54 ---------------------------------------------------------------------- 55 select count(*) from user where id = 1 /* point aggregate */ 56 57 1 ks_sharded/-40: select count(*) from user where id = 1 limit 10001 /* point aggregate */ 58 59 ---------------------------------------------------------------------- 60 select count(*) from user where name in ('alice','bob') /* scatter aggregate */ 61 62 1 ks_sharded/40-80: select name, user_id from name_user_map where name in ('alice', 'bob') limit 10001 /* scatter aggregate */ 63 2 ks_sharded/-40: select count(*) from user where name in ('alice', 'bob') limit 10001 /* scatter aggregate */ 64 65 ---------------------------------------------------------------------- 66 select name, count(*) from user group by name /* scatter aggregate */ 67 68 1 ks_sharded/-40: select name, count(*) from user group by name limit 10001 /* scatter aggregate */ 69 1 ks_sharded/40-80: select name, count(*) from user group by name limit 10001 /* scatter aggregate */ 70 1 ks_sharded/80-c0: select name, count(*) from user group by name limit 10001 /* scatter aggregate */ 71 1 ks_sharded/c0-: select name, count(*) from user group by name limit 10001 /* scatter aggregate */ 72 73 ---------------------------------------------------------------------- 74 select 1, "hello", 3.14 from user limit 10 /* select constant sql values */ 75 76 1 ks_sharded/-40: select 1, 'hello', 3.14 from user limit 10 /* select constant sql values */ 77 1 ks_sharded/40-80: select 1, 'hello', 3.14 from user limit 10 /* select constant sql values */ 78 1 ks_sharded/80-c0: select 1, 'hello', 3.14 from user limit 10 /* select constant sql values */ 79 1 ks_sharded/c0-: select 1, 'hello', 3.14 from user limit 10 /* select constant sql values */ 80 81 ---------------------------------------------------------------------- 82 select * from (select id from user) s /* scatter paren select */ 83 84 1 ks_sharded/-40: select * from (select id from user) as s limit 10001 /* scatter paren select */ 85 1 ks_sharded/40-80: select * from (select id from user) as s limit 10001 /* scatter paren select */ 86 1 ks_sharded/80-c0: select * from (select id from user) as s limit 10001 /* scatter paren select */ 87 1 ks_sharded/c0-: select * from (select id from user) as s limit 10001 /* scatter paren select */ 88 89 ---------------------------------------------------------------------- 90 SELECT id FROM orders WHERE id IN (1, "1", 1) 91 92 1 ks_sharded/-40: select id, keyspace_id from orders_id_lookup where id in (1, '1', 1) limit 10001 93 2 ks_sharded/40-80: select id from orders where id in (1, '1', 1) limit 10001 94 95 ----------------------------------------------------------------------