add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
EXPLAIN
-> Update example_table (immediate)
    -> Nested loop antijoin
        -> Filter: (example_table.textfield = 'Y') (cost=0.35 rows=1)
            -> Table scan on example_table (cost=0.35 rows=1)
        -> Index lookup on t using <auto_key0> (pk=example_table.pk)
            -> Materialize
                -> Filter: (example_table.do_not_touch = 1) (cost=0.35 rows=1)
                    -> Table scan on example_table (cost=0.35 rows=1)
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 UPDATE example_table null index null PRIMARY 4 null 1 100.00 Using where