postgresql

PostgreSQL Window Function

Execution plan for a query using window functions (OVER clause).

SELECT id, salary, RANK() OVER (ORDER BY salary DESC) FROM employees;

Window functions often require data to be sorted according to the OVER clause. Here, a Sort node precedes the WindowAgg node.

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