postgresql

PostgreSQL Subquery Scan

Scanning a subquery that could not be flattened.

SELECT * FROM (SELECT id FROM users LIMIT 10) AS u_lim;

A Subquery Scan node appears when the optimizer reads from a temporary result set produced by a subquery, typically when flattening/inlining is not possible (e.g., due to LIMIT).

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