Introducing
Query Tuning Workbooks
to safely tune Postgres queries on production with pganalyze!
Resources
Enterprise
Docs
Blog
Contact
Features
Pricing
Login
Free Trial
Show table of contents
Overview
Installation Guide
pganalyze Collector
Query Performance
Query Tuning
EXPLAIN Plans
Overview
The Basics of Postgres Query Planning
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
Index Advisor
Indexing Engine
VACUUM Advisor
Schema Statistics
Log Insights
Connections
Alerts & Check-Up
Account Management
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 →