explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 78I2

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 4.356 ↑ 1.2 54 1

Sort (cost=3,557.14..3,557.31 rows=67 width=6) (actual time=4.337..4.356 rows=54 loops=1)

  • Sort Key: r.serranking DESC
  • Sort Method: quicksort Memory: 27kB
2. 0.684 4.312 ↑ 1.2 54 1

Hash Join (cost=69.89..3,555.11 rows=67 width=6) (actual time=0.347..4.312 rows=54 loops=1)

  • Hash Cond: ((r.sereventid = l.seleventid) AND (r.sersiteid = l.selsiteid))
3. 3.331 3.331 ↑ 1.0 2,947 1

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

  • Index Cond: (sercustomerid = 10,848,976)
4. 0.132 0.297 ↑ 1.0 528 1

Hash (cost=50.84..50.84 rows=528 width=8) (actual time=0.296..0.297 rows=528 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 29kB
5. 0.165 0.165 ↑ 1.0 528 1

Seq Scan on sliveevent l (cost=0.00..50.84 rows=528 width=8) (actual time=0.027..0.165 rows=528 loops=1)