explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bM3A

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

Merge Join (cost=1,564,370.73..1,564,469.70 rows=1 width=72) (actual rows= loops=)

  • Merge Cond: (foxtrot.alpha_victor = victor.quebec_seven)
2. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=1,564,247.22..1,564,341.65 rows=362 width=40) (actual rows= loops=)

  • Group Key: foxtrot.alpha_victor
3. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,564,247.22..1,564,331.70 rows=724 width=36) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Sort (cost=1,563,247.20..1,563,248.10 rows=362 width=36) (actual rows= loops=)

  • Sort Key: foxtrot.alpha_victor
5. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=1,563,227.29..1,563,231.82 rows=362 width=36) (actual rows= loops=)

  • Group Key: foxtrot.alpha_victor
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on foxtrot (cost=0.00..1,555,563.85 rows=1,532,688 width=20) (actual rows= loops=)

  • Filter: ((november_mike >= 'seven'::date) AND (november_mike <= 'four'::date))
7. 0.000 0.000 ↓ 0.0

Sort (cost=123.51..123.51 rows=1 width=4) (actual rows= loops=)

  • Sort Key: victor.quebec_seven
8. 0.000 0.000 ↓ 0.0

Seq Scan on victor (cost=0.00..123.50 rows=1 width=4) (actual rows= loops=)

  • Filter: (((hotel)::text <> 'alpha_yankee'::text) AND (quebec_kilo >= 'four'::date) AND (quebec_seven <> november_november ('november_five'::integer[])))