explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4mVb

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

Gather (cost=1,549,331.470..2,736,396.430 rows=1 width=8) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=1,548,331.470..2,735,396.330 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: (charlie.romeo_november = xray.romeo_november)
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on charlie (cost=0.000..931,528.690 rows=6,430,452 width=8) (actual rows= loops=)

  • Filter: (romeo_hotel < 'hotel'::timestamp without time zone)
4. 0.000 0.000 ↓ 0.0

Hash (cost=1,293,759.320..1,293,759.320 rows=15,516,732 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on xray (cost=0.000..1,293,759.320 rows=15,516,732 width=8) (actual rows= loops=)