explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5hY1

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

XN Hash Join DS_BCAST_INNER (cost=109.98..3,871,130,276.17 rows=172,456 width=132) (actual rows= loops=)

  • Hash Cond: ("outer".eventid = "inner".eventid)
2. 0.000 0.000 ↓ 0.0

XN Merge Join DS_DIST_NONE (cost=0.00..6,285.93 rows=172,456 width=97) (actual rows= loops=)

  • Merge Cond: ("outer".listid = "inner".listid)
3. 0.000 0.000 ↓ 0.0

XN Seq Scan on listing (cost=0.00..1,924.97 rows=192,497 width=44) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Seq Scan on sales (cost=0.00..1,724.56 rows=172,456 width=53) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Hash (cost=87.98..87.98 rows=8,798 width=35) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Seq Scan on event (cost=0.00..87.98 rows=8,798 width=35) (actual rows= loops=)