explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hal

Settings
# exclusive inclusive rows x rows loops node
1. 10.610 139.438 ↑ 13.4 37 1

Hash Join (cost=6.50..34.96 rows=495 width=8) (actual time=48.430..139.438 rows=37 loops=1)

  • Hash Cond: (avail_d.d_order = curr_d.d_order)
2. 110.218 110.218 ↓ 2.2 1,107 1

CTE Scan on available_date avail_d (cost=0.00..9.90 rows=495 width=12) (actual time=29.789..110.218 rows=1,107 loops=1)

3. 0.350 18.610 ↑ 5.4 37 1

Hash (cost=4.00..4.00 rows=200 width=12) (actual time=18.602..18.610 rows=37 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 18.260 18.260 ↑ 5.4 37 1

CTE Scan on curr_date curr_d (cost=0.00..4.00 rows=200 width=12) (actual time=16.617..18.260 rows=37 loops=1)

Planning time : 1.687 ms