explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tYOs

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 4.471 ↑ 1.2 47 1

Sort (cost=3,527.69..3,527.83 rows=56 width=6) (actual time=4.466..4.471 rows=47 loops=1)

  • Sort Key: r.serranking DESC
  • Sort Method: quicksort Memory: 27kB
2. 0.662 4.440 ↑ 1.2 47 1

Hash Join (cost=41.17..3,526.06 rows=56 width=6) (actual time=0.346..4.440 rows=47 loops=1)

  • Hash Cond: ((r.sereventid = l.seleventid) AND (r.sersiteid = l.selsiteid))
3. 3.491 3.491 ↑ 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.033..3.491 rows=2,947 loops=1)

  • Index Cond: (sercustomerid = 10,848,976)
4. 0.136 0.287 ↑ 1.0 440 1

Hash (cost=25.20..25.20 rows=440 width=8) (actual time=0.287..0.287 rows=440 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
5. 0.151 0.151 ↑ 1.0 440 1

Seq Scan on sliveevent l (cost=0.00..25.20 rows=440 width=8) (actual time=0.030..0.151 rows=440 loops=1)