explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lXl9

Settings
# exclusive inclusive rows x rows loops node
1. 1,024.172 1,806.275 ↑ 1.0 1,058,835 1

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

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

3. 297.036 515.690 ↑ 1.0 1,059,210 1

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

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