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

     1  ----------------------------------------------------------------------
     2  select * from user where email='null@void.com'
     3  
     4  1 ks_sharded/-40: select * from user where email = 'null@void.com' limit 10001
     5  1 ks_sharded/40-80: select * from user where email = 'null@void.com' limit 10001
     6  1 ks_sharded/80-c0: select * from user where email = 'null@void.com' limit 10001
     7  1 ks_sharded/c0-: select * from user where email = 'null@void.com' limit 10001
     8  
     9  ----------------------------------------------------------------------
    10  select * from user where id in (1,2,3,4,5,6,7,8)
    11  
    12  1 ks_sharded/-40: select * from user where id in (1, 2) limit 10001
    13  1 ks_sharded/40-80: select * from user where id in (3, 5) limit 10001
    14  1 ks_sharded/c0-: select * from user where id in (4, 6, 7, 8) limit 10001
    15  
    16  ----------------------------------------------------------------------
    17  insert into user (id, name) values(2, 'bob')
    18  
    19  1 ks_sharded/c0-: begin
    20  1 ks_sharded/c0-: insert into name_user_map(name, user_id) values ('bob', 2) /* _stream name_user_map (name user_id ) ('Ym9i' 2 ); */ /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */
    21  2 ks_sharded/-40: begin
    22  2 ks_sharded/-40: insert into user(id, name) values (2, 'bob') /* _stream user (id ) (2 ); */ /* vtgate:: keyspace_id:06e7ea22ce92708f */
    23  3 ks_sharded/c0-: begin
    24  3 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392389222930664', 1, 1515392389285958816)
    25  3 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392389222930664', 1, 'ks_sharded', '-40')
    26  3 ks_sharded/c0-: commit
    27  4 ks_sharded/-40: begin
    28  4 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392389222930664', 1, 1515392389297064830)
    29  4 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392389222930664', 1, 'insert into user(id, name) values (2, \'bob\') /* _stream user (id ) (2 ); */ /* vtgate:: keyspace_id:06e7ea22ce92708f */')
    30  4 ks_sharded/-40: commit
    31  5 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392389222930664' and state = 1
    32  5 ks_sharded/c0-: commit
    33  6 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392389222930664'
    34  6 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392389222930664'
    35  6 ks_sharded/-40: commit
    36  7 ks_sharded/c0-: begin
    37  7 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392389222930664'
    38  7 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392389222930664'
    39  7 ks_sharded/c0-: commit
    40  
    41  ----------------------------------------------------------------------