opt: improve explain (opt,env)

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

30.13k stars 3.81k forks source link

Open justinj opened 5 years ago

justinj commented 5 years ago

Tracker issue for improvements to EXPLAIN (opt, env) / EXPLAIN ANALYZE (DEBUG):

[x] include distsql plan
[x] include tables referenced by foreign keys (or remove unimportant foreign key references)
[ ] ~~include INTERLEAVE IN parent tables~~
[x] create the tables in an order that works (topological sort)
[ ] make sure the fully qualified names are correct
[x] include histograms in the INJECT STATISTICS commands
[ ] include the node's locality information

Jira issue: CRDB-4433

rytaft commented 4 years ago

We should also add histograms

michae2 commented 3 years ago

Also missing sequences.

michae2 commented 3 years ago

Also missing CREATE DATABASE statements.