explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f38H

Settings
# exclusive inclusive rows x rows loops node
1. 1,043.265 1,788.352 ↑ 1.0 1,058,835 1

Hash Join (cost=34,622.22..96,807.56 rows=1,058,835 width=8) (actual time=488.778..1,788.352 rows=1,058,835 loops=1)

  • Hash Cond: (events.id = events_venues.events_id)
2. 256.536 256.536 ↑ 1.0 1,058,835 1

Seq Scan on events (cost=0.00..35,214.35 rows=1,058,835 width=4) (actual time=0.005..256.536 rows=1,058,835 loops=1)

3. 269.997 488.551 ↑ 1.0 1,059,210 1

Hash (cost=17,244.10..17,244.10 rows=1,059,210 width=8) (actual time=488.551..488.551 rows=1,059,210 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3620kB
4. 218.554 218.554 ↑ 1.0 1,059,210 1

Seq Scan on events_venues (cost=0.00..17,244.10 rows=1,059,210 width=8) (actual time=0.007..218.554 rows=1,059,210 loops=1)