Skip to content

Instantly share code, notes, and snippets.

@bxcodec
Last active October 24, 2023 13:23
Show Gist options
  • Save bxcodec/056cb7cd59e7b9d2b4f7ee06908d31bb to your computer and use it in GitHub Desktop.
Save bxcodec/056cb7cd59e7b9d2b4f7ee06908d31bb to your computer and use it in GitHub Desktop.
Postgres Explain Analyze Example
flowchart LR

    A[GroupAggregate] --> B{Has Leaves/Branches?}
    B --> C[Nested Loop]
    C --> D{Has Leaves/Branches?}
    D --> E[Index Scan]
    E --> G{Has Leaves/Branches?}
    G --> |Execute| E
    D --> F[Seq Scan]
    F --> H{Has Leaves/Branches?}
    H --> |Execute| F
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment