explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wdll

Settings
# exclusive inclusive rows x rows loops node
1. 1,061.192 1,822.748 ↑ 1.0 1,058,835 1

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

  • Hash Cond: (events.id = events_venues.events_id)
2. 270.092 270.092 ↑ 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.006..270.092 rows=1,058,835 loops=1)

3. 276.012 491.464 ↑ 1.0 1,059,210 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 3620kB
4. 215.452 215.452 ↑ 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.008..215.452 rows=1,059,210 loops=1)