Expanding and collapsing query paths

The EXPLAIN window initially displays the full query plan as generated by the EXPLAIN command.

The EXPLAIN window initially displays the full query plan as generated by the EXPLAIN command. Query plans can be lengthy, so you might want to modify the display so you can focus only on areas of interest:

  • Collapse All collapses all query paths, and displays only a summary of each path.

  • Expand All expands all query paths.

  • Click the first line of a path to display details for that path. To collapse that path, click its first line again.

For details about EXPLAIN command output, see EXPLAIN-Generated query plans.