Skip to content

Support Postgres Explain options #1425

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
kysshsy opened this issue Sep 13, 2024 · 0 comments · Fixed by #1426
Closed

Support Postgres Explain options #1425

kysshsy opened this issue Sep 13, 2024 · 0 comments · Fixed by #1426

Comments

@kysshsy
Copy link
Contributor

kysshsy commented Sep 13, 2024

support EXPLAIN [ ( option [, ...] ) ] statement , like EXPLAIN (analyze true, option_name option_arg) select * from t1 .
Postgres doc.

in Postgres

explain (analyze true) select * from t100;
                                            QUERY PLAN
--------------------------------------------------------------------------------------------------
 Seq Scan on t100  (cost=0.00..35.50 rows=2550 width=4) (actual time=0.007..0.008 rows=0 loops=1)
 Planning Time: 0.040 ms
 Execution Time: 0.019 ms
(3 rows)

explain (aaa) select * from t100;
ERROR:  unrecognized EXPLAIN option "aaa"
LINE 1: explain (aaa) select * from t100;

I want the parser to handle options in a way similar to how the Postgres parser does. Specifically, I want it to be able to parse key-value pairs and validate them when executing the EXPLAIN command. This would allow users to define and include custom options.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant