diff options
-rw-r--r-- | mysql-test/main/show_analyze_json.result | 1229 | ||||
-rw-r--r-- | mysql-test/main/show_analyze_json.test | 368 | ||||
-rw-r--r-- | mysql-test/main/show_explain_json.result | 14 | ||||
-rw-r--r-- | sql/handler.h | 3 | ||||
-rw-r--r-- | sql/sql_show.cc | 30 | ||||
-rw-r--r-- | sql/sql_yacc.yy | 13 |
6 files changed, 1634 insertions, 23 deletions
diff --git a/mysql-test/main/show_analyze_json.result b/mysql-test/main/show_analyze_json.result new file mode 100644 index 00000000000..b49fe8c9971 --- /dev/null +++ b/mysql-test/main/show_analyze_json.result @@ -0,0 +1,1229 @@ +drop table if exists t0, t1, t2, t3, t4; +drop view if exists v1; +SET @old_debug= @@session.debug; +set debug_sync='RESET'; +create table t0 (a int); +insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +create table t1 (a int); +alter table t1 add b int, add c int, add filler char(32); +insert into t1 select A.a, 10*B.a, 100*C.a, 'foo filler' from t0 A, t0 B, t0 C; +alter table t1 add key(a), add key(b); +analyze table t1; +Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected +test.t1 analyze status Table is already up to date +show analyze format=JSON for; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 +show analyze format=json for 1001; +ERROR HY000: Unknown thread id: 1001 +show analyze format=JSON for (select a from t0 limit 1); +ERROR HY000: You may only use constant expressions in this statement +connect con1, localhost, root,,; +connection con1; +SET @old_debug= @@session.debug; +connection default; +show analyze format = JSON for $thr2; +ERROR HY000: Target is not executing an operation with a query plan +show analyze format = json for $thr1; +ERROR HY000: Target is not executing an operation with a query plan +show analyze FORMAT=HTML for $thr1; +ERROR HY000: Unknown EXPLAIN/ANALYZE format name: 'HTML' +analyze FORMAT=XML for connection $thr1; +ERROR HY000: Unknown EXPLAIN/ANALYZE format name: 'XML' +connection con1; +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +select count(*) from t1 where c < 500; +connection default; +show analyze format=JSON for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t1", + "access_type": "ALL", + "r_loops": 1, + "rows": 1000, + "r_rows": 1000, + "filtered": 59.375, + "r_filtered": 50, + "attached_condition": "t1.c < 500" + } + } + ] + } +} +Warnings: +Note 1003 select count(*) from t1 where c < 500 +connection con1; +count(*) +500 +select max(c) from t1 where c < 10; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t1", + "access_type": "ALL", + "r_loops": 1, + "rows": 1000, + "r_rows": 1000, + "filtered": 10.15625, + "r_filtered": 10, + "attached_condition": "t1.c < 10" + } + } + ] + } +} +Warnings: +Note 1003 select max(c) from t1 where c < 10 +connection con1; +max(c) +0 +# We can catch ANALYZE too. +analyze select max(c) from t1 where a < 10; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t1", + "access_type": "ALL", + "possible_keys": ["a"], + "r_loops": 1, + "rows": 1000, + "r_rows": 1000, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 99.90000153, + "r_filtered": 100, + "attached_condition": "t1.a < 10" + } + } + ] + } +} +Warnings: +Note 1003 analyze select max(c) from t1 where a < 10 +connection con1; +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 SIMPLE t1 ALL a NULL NULL NULL 1000 1000.00 99.90 100.00 Using where +SET debug_dbug=@old_debug; +# UNION, select, first branch +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +select max(a) from t0 A where a<=5 union select max(a+1) from t0 B where a>=9; +connection default; +show analyze FORMAT= json for $thr2; +ANALYZE +{ + "query_block": { + "union_result": { + "table_name": "<union1,2>", + "access_type": "ALL", + "r_loops": 0, + "r_rows": null, + "query_specifications": [ + { + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "A", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 60, + "attached_condition": "a.a <= 5" + } + } + ] + } + }, + { + "query_block": { + "select_id": 2, + "operation": "UNION", + "nested_loop": [ + { + "table": { + "table_name": "B", + "access_type": "ALL", + "r_loops": 0, + "rows": 10, + "r_rows": null, + "filtered": 100, + "r_filtered": null, + "attached_condition": "b.a >= 9" + } + } + ] + } + } + ] + } + } +} +Warnings: +Note 1003 select max(a) from t0 A where a<=5 union select max(a+1) from t0 B where a>=9 +connection con1; +max(a) +5 +10 +# UNION, select, second branch +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +select max(a) from t0 A where a<=5 union select max(a+1) from t0 B where a>=9; +connection default; +show analyze format=JSON for $thr2; +ANALYZE +{ + "query_block": { + "union_result": { + "table_name": "<union1,2>", + "access_type": "ALL", + "r_loops": 0, + "r_rows": null, + "query_specifications": [ + { + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "A", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 60, + "attached_condition": "a.a <= 5" + } + } + ] + } + }, + { + "query_block": { + "select_id": 2, + "operation": "UNION", + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "B", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 10, + "attached_condition": "b.a >= 9" + } + } + ] + } + } + ] + } + } +} +Warnings: +Note 1003 select max(a) from t0 A where a<=5 union select max(a+1) from t0 B where a>=9 +connection con1; +max(a) +5 +10 +# UNION, analyze, first branch +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +analyze select a from t0 A where a<=5 union select a+1 from t0 B where a>=9; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "union_result": { + "table_name": "<union1,2>", + "access_type": "ALL", + "r_loops": 0, + "r_rows": null, + "query_specifications": [ + { + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "A", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 60, + "attached_condition": "a.a <= 5" + } + } + ] + } + }, + { + "query_block": { + "select_id": 2, + "operation": "UNION", + "nested_loop": [ + { + "table": { + "table_name": "B", + "access_type": "ALL", + "r_loops": 0, + "rows": 10, + "r_rows": null, + "filtered": 100, + "r_filtered": null, + "attached_condition": "b.a >= 9" + } + } + ] + } + } + ] + } + } +} +Warnings: +Note 1003 analyze select a from t0 A where a<=5 union select a+1 from t0 B where a>=9 +connection con1; +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 PRIMARY A ALL NULL NULL NULL NULL 10 10.00 100.00 60.00 Using where +2 UNION B ALL NULL NULL NULL NULL 10 10.00 100.00 10.00 Using where +NULL UNION RESULT <union1,2> ALL NULL NULL NULL NULL NULL 7.00 NULL NULL +# UNION, analyze, second branch +set @show_explain_probe_select_id=2; +analyze select a from t0 A where a<=5 union select a+1 from t0 B where a>=9; +connection default; +show analyze FORMAT=JSON for $thr2; +ANALYZE +{ + "query_block": { + "union_result": { + "table_name": "<union1,2>", + "access_type": "ALL", + "r_loops": 0, + "r_rows": null, + "query_specifications": [ + { + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "A", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 60, + "attached_condition": "a.a <= 5" + } + } + ] + } + }, + { + "query_block": { + "select_id": 2, + "operation": "UNION", + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "B", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 10, + "attached_condition": "b.a >= 9" + } + } + ] + } + } + ] + } + } +} +Warnings: +Note 1003 analyze select a from t0 A where a<=5 union select a+1 from t0 B where a>=9 +connection con1; +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 PRIMARY A ALL NULL NULL NULL NULL 10 10.00 100.00 60.00 Using where +2 UNION B ALL NULL NULL NULL NULL 10 10.00 100.00 10.00 Using where +NULL UNION RESULT <union1,2> ALL NULL NULL NULL NULL NULL 7.00 NULL NULL +SET debug_dbug=@old_debug; +# Uncorrelated subquery, select +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +select a, (select max(a) from t0 B where a>6) from t0 A where a<2; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "A", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 20, + "attached_condition": "a.a < 2" + } + } + ], + "subqueries": [ + { + "query_block": { + "select_id": 2, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "B", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 30, + "attached_condition": "b.a > 6" + } + } + ] + } + } + ] + } +} +Warnings: +Note 1003 select a, (select max(a) from t0 B where a>6) from t0 A where a<2 +connection con1; +a (select max(a) from t0 B where a>6) +0 9 +1 9 +SET debug_dbug=@old_debug; +# Uncorrelated subquery, analyze +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +analyze select a, (select max(a) from t0 B where a>6) from t0 A where a<2; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "A", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 20, + "attached_condition": "a.a < 2" + } + } + ], + "subqueries": [ + { + "query_block": { + "select_id": 2, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "B", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 30, + "attached_condition": "b.a > 6" + } + } + ] + } + } + ] + } +} +Warnings: +Note 1003 analyze select a, (select max(a) from t0 B where a>6) from t0 A where a<2 +connection con1; +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 PRIMARY A ALL NULL NULL NULL NULL 10 10.00 100.00 20.00 Using where +2 SUBQUERY B ALL NULL NULL NULL NULL 10 10.00 100.00 30.00 Using where +SET debug_dbug=@old_debug; +# correlated subquery, select, before execution start +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "nested_loop": [ + { + "table": { + "table_name": "a", + "access_type": "ALL", + "r_loops": 0, + "rows": 10, + "r_rows": null, + "filtered": 100, + "r_filtered": null, + "attached_condition": "a.a < 2" + } + } + ], + "subqueries": [ + { + "expression_cache": { + "state": "uninitialized", + "r_loops": 0, + "query_block": { + "select_id": 2, + "nested_loop": [ + { + "table": { + "table_name": "b", + "access_type": "ALL", + "r_loops": 0, + "rows": 10, + "r_rows": null, + "filtered": 100, + "r_filtered": null, + "attached_condition": "b.a + a.a < 10" + } + } + ] + } + } + } + ] + } +} +Warnings: +Note 1003 select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2 +connection con1; +a (select max(a) from t0 b where b.a+a.a<10) +0 9 +1 8 +SET debug_dbug=@old_debug; +# correlated subquery, select, after execution +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "a", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 20, + "attached_condition": "a.a < 2" + } + } + ], + "subqueries": [ + { + "expression_cache": { + "r_loops": 2, + "r_hit_ratio": 0, + "query_block": { + "select_id": 2, + "r_loops": 2, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "b", + "access_type": "ALL", + "r_loops": 2, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 95, + "attached_condition": "b.a + a.a < 10" + } + } + ] + } + } + } + ] + } +} +Warnings: +Note 1003 select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2 +connection con1; +a (select max(a) from t0 b where b.a+a.a<10) +0 9 +1 8 +SET debug_dbug=@old_debug; +# correlated subquery, analyze +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +analyze select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "a", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 20, + "attached_condition": "a.a < 2" + } + } + ], + "subqueries": [ + { + "expression_cache": { + "r_loops": 2, + "r_hit_ratio": 0, + "query_block": { + "select_id": 2, + "r_loops": 2, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "b", + "access_type": "ALL", + "r_loops": 2, + "rows": 10, + "r_rows": 10, + "r_table_time_ms": "REPLACED", + "r_other_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 95, + "attached_condition": "b.a + a.a < 10" + } + } + ] + } + } + } + ] + } +} +Warnings: +Note 1003 analyze select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2 +connection con1; +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 PRIMARY a ALL NULL NULL NULL NULL 10 10.00 100.00 20.00 Using where +2 DEPENDENT SUBQUERY b ALL NULL NULL NULL NULL 10 10.00 100.00 95.00 Using where +SET debug_dbug=@old_debug; +# Try to do SHOW ANALYZE for a query that runs a SET command: +# +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +set @foo= (select max(a) from t0 where sin(a) >0); +connection default; +show analyze format=json for $thr2; +ERROR HY000: Target is not executing an operation with a query plan +kill query $thr2; +connection con1; +ERROR 70100: Query execution was interrupted +SET debug_dbug=@old_debug; +# +# Attempt SHOW ANALYZE for an UPDATE +# +create table t2 as select a as a, a as dummy from t0 limit 2; +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +update t2 set dummy=0 where (select max(a) from t0 where t2.a + t0.a <3) >3 ; +connection default; +show analyze FORMAT=JSON for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_total_time_ms": "REPLACED", + "table": { + "update": 1, + "table_name": "t2", + "access_type": "ALL", + "rows": 2, + "r_rows": 1, + "r_filtered": 0, + "attached_condition": "(subquery#2) > 3" + }, + "subqueries": [ + { + "query_block": { + "select_id": 2, + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 0, + "rows": 10, + "r_rows": null, + "filtered": 100, + "r_filtered": null, + "attached_condition": "t2.a + t0.a < 3" + } + } + ] + } + } + ] + } +} +Warnings: +Note 1003 update t2 set dummy=0 where (select max(a) from t0 where t2.a + t0.a <3) >3 +show analyze FORMAT=JSON for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_total_time_ms": "REPLACED", + "table": { + "update": 1, + "table_name": "t2", + "access_type": "ALL", + "rows": 2, + "r_rows": 2, + "r_filtered": 0, + "attached_condition": "(subquery#2) > 3" + }, + "subqueries": [ + { + "query_block": { + "select_id": 2, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 30, + "attached_condition": "t2.a + t0.a < 3" + } + } + ] + } + } + ] + } +} +Warnings: +Note 1003 update t2 set dummy=0 where (select max(a) from t0 where t2.a + t0.a <3) >3 +connection con1; +drop table t2; +SET debug_dbug=@old_debug; +# +# Attempt SHOW ANALYZE for a DELETE +# +create table t2 as select a as a, a as dummy from t0 limit 2; +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +delete from t2 where (select max(a) from t0 where t2.a + t0.a <3) >3 ; +connection default; +show analyze FORMAT=JSON for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_total_time_ms": "REPLACED", + "table": { + "delete": 1, + "table_name": "t2", + "access_type": "ALL", + "rows": 2, + "r_rows": 1, + "r_filtered": 0, + "attached_condition": "(subquery#2) > 3" + }, + "subqueries": [ + { + "query_block": { + "select_id": 2, + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 0, + "rows": 10, + "r_rows": null, + "filtered": 100, + "r_filtered": null, + "attached_condition": "t2.a + t0.a < 3" + } + } + ] + } + } + ] + } +} +Warnings: +Note 1003 delete from t2 where (select max(a) from t0 where t2.a + t0.a <3) >3 +show analyze FORMAT=JSON for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_total_time_ms": "REPLACED", + "table": { + "delete": 1, + "table_name": "t2", + "access_type": "ALL", + "rows": 2, + "r_rows": 2, + "r_filtered": 0, + "attached_condition": "(subquery#2) > 3" + }, + "subqueries": [ + { + "query_block": { + "select_id": 2, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 30, + "attached_condition": "t2.a + t0.a < 3" + } + } + ] + } + } + ] + } +} +Warnings: +Note 1003 delete from t2 where (select max(a) from t0 where t2.a + t0.a <3) >3 +connection con1; +drop table t2; +SET debug_dbug=@old_debug; +# +# Multiple SHOW ANALYZE calls for one select +# +create table t2 as select a as a, a as dummy from t0 limit 3; +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +select t2.a, ((select max(a) from t0 where t2.a + t0.a <3) >3) as SUBQ from t2; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t2", + "access_type": "ALL", + "r_loops": 1, + "rows": 3, + "r_rows": 1, + "filtered": 100, + "r_filtered": 100 + } + } + ], + "subqueries": [ + { + "expression_cache": { + "r_loops": 1, + "r_hit_ratio": 0, + "query_block": { + "select_id": 2, + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 0, + "rows": 10, + "r_rows": null, + "filtered": 100, + "r_filtered": null, + "attached_condition": "t2.a + t0.a < 3" + } + } + ] + } + } + } + ] + } +} +Warnings: +Note 1003 select t2.a, ((select max(a) from t0 where t2.a + t0.a <3) >3) as SUBQ from t2 +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t2", + "access_type": "ALL", + "r_loops": 1, + "rows": 3, + "r_rows": 2, + "filtered": 100, + "r_filtered": 100 + } + } + ], + "subqueries": [ + { + "expression_cache": { + "r_loops": 2, + "r_hit_ratio": 0, + "query_block": { + "select_id": 2, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 30, + "attached_condition": "t2.a + t0.a < 3" + } + } + ] + } + } + } + ] + } +} +Warnings: +Note 1003 select t2.a, ((select max(a) from t0 where t2.a + t0.a <3) >3) as SUBQ from t2 +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t2", + "access_type": "ALL", + "r_loops": 1, + "rows": 3, + "r_rows": 3, + "filtered": 100, + "r_filtered": 100 + } + } + ], + "subqueries": [ + { + "expression_cache": { + "r_loops": 3, + "r_hit_ratio": 0, + "query_block": { + "select_id": 2, + "r_loops": 2, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 2, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 25, + "attached_condition": "t2.a + t0.a < 3" + } + } + ] + } + } + } + ] + } +} +Warnings: +Note 1003 select t2.a, ((select max(a) from t0 where t2.a + t0.a <3) >3) as SUBQ from t2 +connection con1; +a SUBQ +0 0 +1 0 +2 0 +SET debug_dbug=@old_debug; +drop table t2; +# +# SHOW ANALYZE for SELECT ... ORDER BY with "Using filesort" +# +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +set @show_explain_probe_select_id=1; +select * from t0 order by a; +connection default; +show analyze format=JSON for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "nested_loop": [ + { + "read_sorted_file": { + "r_rows": 10, + "filesort": { + "sort_key": "t0.a", + "r_loops": 1, + "r_used_priority_queue": false, + "r_output_rows": 10, + "r_buffer_size": "REPLACED", + "r_sort_mode": "sort_key,addon_fields", + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 100 + } + } + } + } + ] + } +} +Warnings: +Note 1003 select * from t0 order by a +connection con1; +a +0 +1 +2 +3 +4 +5 +6 +7 +8 +9 +SET debug_dbug=@old_debug; +# +# SHOW ANALYZE for SELECT ... with "Using temporary" +# +connection con1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +set @show_explain_probe_select_id=1; +select distinct a from t0; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "temporary_table": { + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 100 + } + } + ] + } + } +} +Warnings: +Note 1003 select distinct a from t0 +connection con1; +a +0 +1 +2 +3 +4 +5 +6 +7 +8 +9 +SET debug_dbug=@old_debug; +# +# SHOW ANALYZE for SELECT ... with "Using temporary; Using filesort" +# +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +set @show_explain_probe_select_id=1; +select distinct a from t0; +connection default; +show analyze format=json for $thr2; +ANALYZE +{ + "query_block": { + "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", + "temporary_table": { + "nested_loop": [ + { + "table": { + "table_name": "t0", + "access_type": "ALL", + "r_loops": 1, + "rows": 10, + "r_rows": 10, + "filtered": 100, + "r_filtered": 100 + } + } + ] + } + } +} +Warnings: +Note 1003 select distinct a from t0 +connection con1; +a +0 +1 +2 +3 +4 +5 +6 +7 +8 +9 +SET debug_dbug=@old_debug; +drop table t0,t1; +# End +connection default; +disconnect con1; +set debug_sync='RESET'; diff --git a/mysql-test/main/show_analyze_json.test b/mysql-test/main/show_analyze_json.test new file mode 100644 index 00000000000..8c483364e24 --- /dev/null +++ b/mysql-test/main/show_analyze_json.test @@ -0,0 +1,368 @@ +# +# Tests for SHOW ANALYZE FORMAT=JSON FOR functionality +# +--source include/have_debug.inc +--source include/have_debug_sync.inc +--source include/have_innodb.inc +# Using valgrind can cause 'reap' to fail. See comment below +--source include/not_valgrind.inc + +--disable_warnings +drop table if exists t0, t1, t2, t3, t4; +drop view if exists v1; +--enable_warnings +SET @old_debug= @@session.debug; + +# +# Testcases in this file do not work with embedded server. The reason for this +# is that we use the following commands for synchronization: +# +# set @show_explain_probe_select_id=1; +# SET debug_dbug='d,show_explain_probe_join_exec_start'; +# send select count(*) from t1 where a < 100000; +# +# When ran with mysqltest_embedded, this translates into: +# +# Thread1> DBUG_PUSH("d,show_explain_probe_join_exec_start"); +# Thread1> create another thread for doing "send ... reap" +# Thread2> mysql_parse("select count(*) from t1 where a < 100000"); +# +# That is, "select count(*) ..." is ran in a thread for which DBUG_PUSH(...) +# has not been called. As a result, show_explain_probe_join_exec_start does not fire, and +# "select count(*) ..." does not wait till its SHOW ANALYZE command, and the +# test fails. +# +-- source include/not_embedded.inc + +set debug_sync='RESET'; + +create table t0 (a int); +insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +create table t1 (a int); +alter table t1 add b int, add c int, add filler char(32); +insert into t1 select A.a, 10*B.a, 100*C.a, 'foo filler' from t0 A, t0 B, t0 C; +alter table t1 add key(a), add key(b); +analyze table t1; + +# +# Try to call SHOW ANALYZE with a missing thread ID +# +--error ER_PARSE_ERROR +show analyze format=JSON for; + +# +# Try SHOW ANALYZE for a non-existent thread +# +--error ER_NO_SUCH_THREAD +show analyze format=json for 1001; + +--error ER_SET_CONSTANTS_ONLY +show analyze format=JSON for (select a from t0 limit 1); + +# +# Setup two threads and their ids +# +let $thr1=`select connection_id()`; +connect (con1, localhost, root,,); +connection con1; +let $thr2=`select connection_id()`; +SET @old_debug= @@session.debug; +connection default; + +# SHOW ANALYZE FOR <idle thread> +--error ER_TARGET_NOT_EXPLAINABLE +evalp show analyze format = JSON for $thr2; + +# SHOW ANALYZE FOR <ourselves> +--error ER_TARGET_NOT_EXPLAINABLE +evalp show analyze format = json for $thr1; + +# Not supported format of output +--error ER_UNKNOWN_EXPLAIN_FORMAT +evalp show analyze FORMAT=HTML for $thr1; + +--error ER_UNKNOWN_EXPLAIN_FORMAT +evalp analyze FORMAT=XML for connection $thr1; + +let $wait_condition= select State='show_explain_trap' from information_schema.processlist where id=$thr2; + +# +# Test SHOW ANALYZE for simple queries +# +connection con1; +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send select count(*) from t1 where c < 500; + +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=JSON for $thr2; +connection con1; +reap; + + +send select max(c) from t1 where c < 10; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; + + +--echo # We can catch ANALYZE too. +send analyze select max(c) from t1 where a < 10; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # UNION, select, first branch +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send select max(a) from t0 A where a<=5 union select max(a+1) from t0 B where a>=9; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze FORMAT= json for $thr2; +connection con1; +reap; + + +--echo # UNION, select, second branch +set @show_explain_probe_select_id=2; # <--- Second branch +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send select max(a) from t0 A where a<=5 union select max(a+1) from t0 B where a>=9; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=JSON for $thr2; +connection con1; +reap; + + +--echo # UNION, analyze, first branch +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send analyze select a from t0 A where a<=5 union select a+1 from t0 B where a>=9; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; + + +--echo # UNION, analyze, second branch +set @show_explain_probe_select_id=2; +send analyze select a from t0 A where a<=5 union select a+1 from t0 B where a>=9; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze FORMAT=JSON for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # Uncorrelated subquery, select +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send select a, (select max(a) from t0 B where a>6) from t0 A where a<2; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # Uncorrelated subquery, analyze +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send analyze select a, (select max(a) from t0 B where a>6) from t0 A where a<2; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # correlated subquery, select, before execution start +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +send select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # correlated subquery, select, after execution +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # correlated subquery, analyze +set @show_explain_probe_select_id=1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +send analyze select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # Try to do SHOW ANALYZE for a query that runs a SET command: +--echo # +set @show_explain_probe_select_id=2; # <--- +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +send set @foo= (select max(a) from t0 where sin(a) >0); +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +--error ER_TARGET_NOT_EXPLAINABLE +evalp show analyze format=json for $thr2; +evalp kill query $thr2; +connection con1; +--error ER_QUERY_INTERRUPTED +reap; +SET debug_dbug=@old_debug; + + +--echo # +--echo # Attempt SHOW ANALYZE for an UPDATE +--echo # +create table t2 as select a as a, a as dummy from t0 limit 2; +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +send update t2 set dummy=0 where (select max(a) from t0 where t2.a + t0.a <3) >3 ; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze FORMAT=JSON for $thr2; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze FORMAT=JSON for $thr2; +connection con1; +reap; +drop table t2; +SET debug_dbug=@old_debug; + + +--echo # +--echo # Attempt SHOW ANALYZE for a DELETE +--echo # +create table t2 as select a as a, a as dummy from t0 limit 2; +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +send delete from t2 where (select max(a) from t0 where t2.a + t0.a <3) >3 ; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze FORMAT=JSON for $thr2; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze FORMAT=JSON for $thr2; +connection con1; +reap; +drop table t2; +SET debug_dbug=@old_debug; + + +--echo # +--echo # Multiple SHOW ANALYZE calls for one select +--echo # +create table t2 as select a as a, a as dummy from t0 limit 3; +set @show_explain_probe_select_id=2; +SET debug_dbug='+d,show_explain_probe_join_exec_start'; +send select t2.a, ((select max(a) from t0 where t2.a + t0.a <3) >3) as SUBQ from t2; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; +drop table t2; + + +--echo # +--echo # SHOW ANALYZE for SELECT ... ORDER BY with "Using filesort" +--echo # +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +set @show_explain_probe_select_id=1; +send select * from t0 order by a; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=JSON for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # +--echo # SHOW ANALYZE for SELECT ... with "Using temporary" +--echo # +connection con1; +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +set @show_explain_probe_select_id=1; +send select distinct a from t0; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +--echo # +--echo # SHOW ANALYZE for SELECT ... with "Using temporary; Using filesort" +--echo # +SET debug_dbug='+d,show_explain_probe_join_exec_end'; +set @show_explain_probe_select_id=1; +send select distinct a from t0; +connection default; +--source include/wait_condition.inc +--source include/analyze-format.inc +evalp show analyze format=json for $thr2; +connection con1; +reap; +SET debug_dbug=@old_debug; + + +drop table t0,t1; +--echo # End +connection default; +disconnect con1; +set debug_sync='RESET';
\ No newline at end of file diff --git a/mysql-test/main/show_explain_json.result b/mysql-test/main/show_explain_json.result index cfc9dd010cf..7440c9d1341 100644 --- a/mysql-test/main/show_explain_json.result +++ b/mysql-test/main/show_explain_json.result @@ -26,17 +26,17 @@ connection con1; SET @old_debug= @@session.debug; connection default; show explain format=JSON for $thr2; -ERROR HY000: Target is not running an EXPLAINable command +ERROR HY000: Target is not executing an operation with a query plan explain format=json for connection $thr2; -ERROR HY000: Target is not running an EXPLAINable command +ERROR HY000: Target is not executing an operation with a query plan show explain format=json for $thr1; -ERROR HY000: Target is not running an EXPLAINable command +ERROR HY000: Target is not executing an operation with a query plan explain FORMAT=JSON for connection $thr1; -ERROR HY000: Target is not running an EXPLAINable command +ERROR HY000: Target is not executing an operation with a query plan show explain FORMAT=HTML for $thr1; -ERROR HY000: Unknown EXPLAIN format name: 'HTML' +ERROR HY000: Unknown EXPLAIN/ANALYZE format name: 'HTML' explain FORMAT=XML for connection $thr1; -ERROR HY000: Unknown EXPLAIN format name: 'XML' +ERROR HY000: Unknown EXPLAIN/ANALYZE format name: 'XML' connection con1; set @show_explain_probe_select_id=1; SET debug_dbug='+d,show_explain_probe_join_exec_start'; @@ -523,7 +523,7 @@ SET debug_dbug='+d,show_explain_probe_join_exec_start'; set @foo= (select max(a) from t0 where sin(a) >0); connection default; show explain format=JSON for $thr2; -ERROR HY000: Target is not running an EXPLAINable command +ERROR HY000: Target is not executing an operation with a query plan kill query $thr2; connection con1; ERROR 70100: Query execution was interrupted diff --git a/sql/handler.h b/sql/handler.h index a4c54b3a260..750250a390f 100644 --- a/sql/handler.h +++ b/sql/handler.h @@ -1025,7 +1025,8 @@ enum enum_schema_tables SCH_EVENTS, SCH_EXPLAIN_TABULAR, SCH_EXPLAIN_JSON, - SCH_ANALYZE, + SCH_ANALYZE_TABULAR, + SCH_ANALYZE_JSON, SCH_FILES, SCH_GLOBAL_STATUS, SCH_GLOBAL_VARIABLES, diff --git a/sql/sql_show.cc b/sql/sql_show.cc index 7fa55913262..8746d442fe8 100644 --- a/sql/sql_show.cc +++ b/sql/sql_show.cc @@ -3242,13 +3242,14 @@ int fill_show_explain_tabular(THD *thd, TABLE_LIST *table, COND *cond) int fill_show_explain_json(THD *thd, TABLE_LIST *table, COND *cond) { return fill_show_explain_or_analyze( - thd, table, cond, TRUE /* json_format */, TRUE /* is_analyze */); + thd, table, cond, TRUE /* json_format */, FALSE /* is_analyze */); +} int fill_show_analyze_tabular(THD * thd, TABLE_LIST * table, COND * cond) { return fill_show_explain_or_analyze( - thd, table, cond, FALSE /* json_format */, TRUE /* is_analyze */); + thd, table, cond, FALSE /* json_format */, TRUE /* is_analyze */); } @@ -9676,7 +9677,7 @@ ST_FIELD_INFO show_explain_json_fields_info[]= }; -ST_FIELD_INFO show_analyze_fields_info[]= +ST_FIELD_INFO show_analyze_tabular_fields_info[]= { Column("id", SLonglong(3), NULLABLE, "id"), Column("select_type", Varchar(19), NOT_NULL, "select_type"), @@ -9699,6 +9700,11 @@ ST_FIELD_INFO show_analyze_fields_info[]= }; +ST_FIELD_INFO show_analyze_json_fields_info[]= { + Column("EXPLAIN", Longtext(MAX_FIELD_VARCHARLENGTH), NOT_NULL, "ANALYZE"), + CEnd()}; + + ST_FIELD_INFO check_constraints_fields_info[]= { Column("CONSTRAINT_CATALOG", Catalog(), NOT_NULL, OPEN_FULL_TABLE), @@ -9759,12 +9765,18 @@ ST_SCHEMA_TABLE schema_tables[]= {"EVENTS", Show::events_fields_info, 0, 0, make_old_format, 0, -1, -1, 0, 0}, #endif - {"EXPLAIN", Show::show_explain_tabular_fields_info, 0, fill_show_explain_tabular, - make_old_format, 0, -1, -1, TRUE /*hidden*/ , 0}, - {"EXPLAIN_JSON", Show::show_explain_json_fields_info, 0, fill_show_explain_json, - make_old_format, 0, -1, -1, TRUE /*hidden*/, 0}, - {"ANALYZE", Show::show_analyze_fields_info, 0, fill_show_analyze_tabular, - make_old_format, 0, -1, -1, TRUE /*hidden*/, 0}, + {"EXPLAIN", Show::show_explain_tabular_fields_info, 0, + fill_show_explain_tabular, make_old_format, 0, -1, -1, + TRUE /*hidden*/ , 0}, + {"EXPLAIN_JSON", Show::show_explain_json_fields_info, 0, + fill_show_explain_json, make_old_format, 0, -1, -1, + TRUE /*hidden*/ , 0}, + {"ANALYZE", Show::show_analyze_tabular_fields_info, 0, + fill_show_analyze_tabular, make_old_format, 0, -1, -1, + TRUE /*hidden*/, 0}, + {"ANALYZE_JSON", Show::show_analyze_json_fields_info, 0, + fill_show_analyze_json, make_old_format, 0, -1, -1, + TRUE /*hidden*/, 0}, {"FILES", Show::files_fields_info, 0, hton_fill_schema_table, 0, 0, -1, -1, 0, 0}, {"GLOBAL_STATUS", Show::variables_fields_info, 0, diff --git a/sql/sql_yacc.yy b/sql/sql_yacc.yy index b81a4ad606c..8f4f7ccefc3 100644 --- a/sql/sql_yacc.yy +++ b/sql/sql_yacc.yy @@ -13944,16 +13944,17 @@ show_param: { Lex->sql_command= SQLCOM_SHOW_EXPLAIN; if (unlikely(prepare_schema_table(thd, Lex, 0, - Lex->explain_json ? SCH_EXPLAIN_JSON : SCH_EXPLAIN_TABULAR))) + Lex->explain_json ? SCH_EXPLAIN_JSON : SCH_EXPLAIN_TABULAR))) MYSQL_YYABORT; add_value_to_list(thd, $4); } - | ANALYZE_SYM FOR_SYM expr + | ANALYZE_SYM opt_format_json FOR_SYM expr { Lex->sql_command= SQLCOM_SHOW_ANALYZE; - if (unlikely(prepare_schema_table(thd, Lex, 0, SCH_ANALYZE))) + if (unlikely(prepare_schema_table(thd, Lex, 0, + Lex->explain_json ? SCH_ANALYZE_JSON : SCH_ANALYZE_TABULAR))) MYSQL_YYABORT; - add_value_to_list(thd, $3); + add_value_to_list(thd, $4); } | IDENT_sys remember_tok_start wild_and_where { @@ -14107,8 +14108,8 @@ opt_format_json: else if (lex_string_eq(&$3, STRING_WITH_LEN("TRADITIONAL"))) DBUG_ASSERT(Lex->explain_json==false); else - my_yyabort_error((ER_UNKNOWN_EXPLAIN_FORMAT, MYF(0), "EXPLAIN", - $3.str)); + my_yyabort_error((ER_UNKNOWN_EXPLAIN_FORMAT, MYF(0), + "EXPLAIN/ANALYZE", $3.str)); } ; |