explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Hjk

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

Sort (cost=3,534.97..3,535.13 rows=65 width=6) (actual rows= loops=)

  • Sort Key: r.serranking DESC
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=47.85..3,533.01 rows=65 width=6) (actual rows= loops=)

  • Hash Cond: ((r.sereventid = l.seleventid) AND (r.sersiteid = l.selsiteid))
3. 0.000 0.000 ↓ 0.0

Index Scan using ix_seventranking_sercustomerid on seventranking r (cost=0.57..3,409.03 rows=2,990 width=10) (actual rows= loops=)

  • Index Cond: (sercustomerid = 10,848,976)
4. 0.000 0.000 ↓ 0.0

Hash (cost=29.36..29.36 rows=512 width=8)" -> Seq Scan on sliveevent l (cost=0.00..29.36 rows=512 width=8) (actual rows= loops=)