Back to VisualizerSQL Explain Example
postgresql

PostgreSQL Parallel Scan

Parallel sequential scan leveraging multiple CPU cores.

SELECT COUNT(*) FROM huge_table;

PostgreSQL can carry out parallel queries to leverage multiple CPU cores. A "Gather" node collects results from worker processes executing the lower part of the plan.

Interactive Execution Plan

EXPLAIN Output
Run: EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT TEXT) your_query;
Enter SQL EXPLAIN output to visualizeSupports PostgreSQL EXPLAIN ANALYZE, MySQL EXPLAIN, and SQLite EXPLAIN QUERY PLAN formats