explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CN0B

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

Parallel Seq Scan on guest g (cost=0.00..97,900.27 rows=459,327 width=38) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=138,780.76..138,780.76 rows=500,485 width=13) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=97,177.74..138,780.76 rows=500,485 width=13) (actual rows= loops=)

  • Hash Cond: (brg.booked_room_id = br.id)
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on booked_room_guest brg (cost=0.00..31,606.85 rows=500,485 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=93,099.51..93,099.51 rows=234,579 width=13) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=57,117.95..93,099.51 rows=234,579 width=13) (actual rows= loops=)

  • Hash Cond: (br.request_id = r.id)
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on booked_room br (cost=0.00..30,476.79 rows=234,579 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=47,874.31..47,874.31 rows=531,731 width=13) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on request r (cost=0.00..47,874.31 rows=531,731 width=13) (actual rows= loops=)