Skip to content
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

sqlplus: SET AUTOTRACE ON EXPLAIN equivalent #13

Open
legrandlegrand opened this issue Apr 22, 2019 · 0 comments
Open

sqlplus: SET AUTOTRACE ON EXPLAIN equivalent #13

legrandlegrand opened this issue Apr 22, 2019 · 0 comments
Assignees
Labels
how to Explain how to do something

Comments

@legrandlegrand
Copy link
Owner

legrandlegrand commented Apr 22, 2019

set pg_stat_sql_plans.track='all';
set pg_stat_sql_plans.track_planid=true;
set pg_stat_sql_plans.explain=true;
set log_min_error_statement=LOG;

postgres=# select id from A;
LOG: queryid: 7449492610579586729 planid: 7866381122914524383 plan:
Seq Scan on a (cost=0.00..35.50 rows=2550 width=4)
id


(0 rows)

--> to be added in doc

@legrandlegrand legrandlegrand added the how to Explain how to do something label Apr 22, 2019
@legrandlegrand legrandlegrand self-assigned this Apr 22, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
how to Explain how to do something
Projects
None yet
Development

No branches or pull requests

1 participant