explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8JiO

Settings
# exclusive inclusive rows x rows loops node
1. 992.626 68,011.728 ↑ 135,612.7 12 1

Limit (cost=2884438.00..2884438.03 rows=12 width=1341) (actual time=68011.728..68011.730 rows=12 loops=1)-> Sort (cost=2,884,438.00..2,888,506.38 rows=1,627,352 width=1,341) (actual time=68,011.727..68,011.728 rows=12 loops=1)

  • Sort Key: (engagement(social)) DESC NULLS LAST, created_at
  • Sort Method: top-N heapsort Memory: 45kB
2. 67,019.102 67,019.102 ↑ 1.2 1,360,633 1

Index Scan using idx_in_social_engagement on users (cost=0.43..2,847,131.26 rows=1,627,352 width=1,341) (actual time=0.082..67,019.102 rows=1,360,633 loops=1)

  • Index Cond: ((engagement(social) > '0.03'::double precision) AND (engagement(social) < '0.25'::double precision))
  • Filter: ((follower_count(social) < 500000) AND (peemv(social) > '0'::double precision) AND (peemv(social) < '533'::double precision))
  • Rows Removed by Filter: 85580
Planning time : 0.312 ms
Execution time : 68,011.752 ms