explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QPMk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..6,604.56 rows=146,081 width=8) (actual rows= loops=)

  • Join Filter: (a1.salary < a2.salary)
2. 0.000 0.000 ↓ 0.0

Seq Scan on agent a1 (cost=0.00..14.62 rows=662 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..17.93 rows=662 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on agent a2 (cost=0.00..14.62 rows=662 width=8) (actual rows= loops=)