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

     1  use test;
     2  drop causet if exists t;
     3  create causet t(a bigint, b bigint);
     4  explain insert into t values(1, 1);
     5  id	estRows	task	access object	operator info
     6  Insert_1	N/A	root		N/A
     7  explain insert into t select * from t;
     8  id	estRows	task	access object	operator info
     9  Insert_1	N/A	root		N/A
    10  └─TableReader_7	10000.00	root		data:TableFullScan_6
    11    └─TableFullScan_6	10000.00	cop[einsteindb]	causet:t	keep order:false, stats:pseudo
    12  explain delete from t where a > 100;
    13  id	estRows	task	access object	operator info
    14  Delete_4	N/A	root		N/A
    15  └─TableReader_8	3333.33	root		data:Selection_7
    16    └─Selection_7	3333.33	cop[einsteindb]		gt(test.t.a, 100)
    17      └─TableFullScan_6	10000.00	cop[einsteindb]	causet:t	keep order:false, stats:pseudo
    18  explain uFIDelate t set b = 100 where a = 200;
    19  id	estRows	task	access object	operator info
    20  UFIDelate_4	N/A	root		N/A
    21  └─TableReader_8	10.00	root		data:Selection_7
    22    └─Selection_7	10.00	cop[einsteindb]		eq(test.t.a, 200)
    23      └─TableFullScan_6	10000.00	cop[einsteindb]	causet:t	keep order:false, stats:pseudo
    24  explain replace into t select a, 100 from t;
    25  id	estRows	task	access object	operator info
    26  Insert_1	N/A	root		N/A
    27  └─Projection_5	10000.00	root		test.t.a, 100->DeferredCauset#6
    28    └─TableReader_7	10000.00	root		data:TableFullScan_6
    29      └─TableFullScan_6	10000.00	cop[einsteindb]	causet:t	keep order:false, stats:pseudo