explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jzZW

Settings
# exclusive inclusive rows x rows loops node
1. 919.103 1,963.676 ↓ 1.0 1,095,459 1

Hash Join (cost=36,350.02..101,860.58 rows=1,091,201 width=8) (actual time=680.885..1,963.676 rows=1,095,459 loops=1)

  • Hash Cond: (events.id = events_venues.events_id)
2. 364.365 364.365 ↑ 1.0 1,095,459 1

Seq Scan on events (cost=0.00..37,622.58 rows=1,099,458 width=4) (actual time=0.004..364.365 rows=1,095,459 loops=1)

3. 367.598 680.208 ↓ 1.0 1,095,834 1

Hash (cost=18,447.01..18,447.01 rows=1,091,201 width=8) (actual time=680.208..680.208 rows=1,095,834 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3710kB
4. 312.610 312.610 ↓ 1.0 1,095,834 1

Seq Scan on events_venues (cost=0.00..18,447.01 rows=1,091,201 width=8) (actual time=0.003..312.610 rows=1,095,834 loops=1)