Skip to navigation
Watch our latest webinar on demand:
Optimizing Postgres with Claude Code and the pganalyze MCP Server
.
Docs
Features
Our Key Features
Query Advisor
Detect and fix Postgres query plan problems
Index Advisor
Faster queries, less guesswork
VACUUM Advisor
Optimize bloat, freezing and VACUUM performance
Workbooks
Dedicated environment for query optimization
All features
Solutions
Fix Slow Queries
Enterprise Scale
Pricing
Blog
Resources
Webinars
eBooks
Tools
Customer Stories
Blog
Newsletter
Company
About us
Careers
Contact
Login
Free Trial
Menu
Close
Docs
Features
Query Advisor
Detect and fix Postgres query plan problems
Index Advisor
Faster queries, less guesswork
VACUUM Advisor
Optimize bloat, freezing and VACUUM performance
Workbooks
Dedicated environment for query optimization
See all features
Solutions
Fix Slow Queries
Enterprise Scale
Pricing
Blog
Resources
Webinars
eBooks
Tools
Customer Stories
Blog
Newsletter
Company
About us
Careers
Contact
Free Trial
Log in
Show table of contents
Overview
Installation Guide
pganalyze Collector
Query Performance
Query Advisor
EXPLAIN Plans
Overview
The Basics of Postgres Query Planning
EXPLAIN Grid view
Comparing EXPLAIN plans
Insights
Scan nodes
Join nodes
Other nodes
Aggregate
Append
Bitmap And
Bitmap Or
Gather Merge
Gather
Group
Hash
Limit
Lock Rows
Materialize
Merge Append
Modify Table
Project Set
Recursive Union
Result
SetOp
Sort
Unique
Window Aggregate
Workbooks
Index Advisor
Indexing Engine
VACUUM Advisor
Schema Statistics
Log Insights
Connections
Alerts & Check-Up
Account Management
MCP Server (Preview)
OpenTelemetry Integration
pganalyze Enterprise Server
pganalyze GraphQL API
Open-Source Components
❮ Documentation: EXPLAIN - Overview
EXPLAIN - Other Nodes
This section lists plan nodes other than
Scan
and
Join
nodes.
Aggregate
Append
Bitmap And
Bitmap Or
Gather Merge
Gather
Group
Hash
Limit
Lock Rows
Materialize
Merge Append
Modify Table
Project Set
Recursive Union
Result
SetOp
Sort
Unique
Window Aggregate
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →