explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Drf0

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 102.063 ↑ 1.0 25 1

Limit (cost=17,695.28..17,695.34 rows=25 width=1,900) (actual time=102.047..102.063 rows=25 loops=1)

2. 8.501 102.059 ↑ 443.1 25 1

Sort (cost=17,695.28..17,722.97 rows=11,078 width=1,900) (actual time=102.045..102.059 rows=25 loops=1)

  • Sort Key: feeds_post.date_published DESC, feeds_post.orderable_id DESC
  • Sort Method: top-N heapsort Memory: 60kB
3. 17.338 93.558 ↑ 1.0 11,078 1

Nested Loop (cost=710.85..17,382.66 rows=11,078 width=1,900) (actual time=12.333..93.558 rows=11,078 loops=1)

4. 21.451 42.986 ↑ 1.0 11,078 1

Hash Join (cost=710.43..4,330.56 rows=11,078 width=8) (actual time=12.314..42.986 rows=11,078 loops=1)

  • Hash Cond: (users_status.id = users_status_timeline.status_id)
5. 15.642 15.642 ↑ 1.0 134,333 1

Seq Scan on users_status (cost=0.00..2,333.19 rows=134,419 width=24) (actual time=0.012..15.642 rows=134,333 loops=1)

6. 1.777 5.893 ↑ 1.0 11,078 1

Hash (cost=571.95..571.95 rows=11,078 width=16) (actual time=5.893..5.893 rows=11,078 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 648kB
7. 4.116 4.116 ↑ 1.0 11,078 1

Seq Scan on users_status_timeline (cost=0.00..571.95 rows=11,078 width=16) (actual time=0.014..4.116 rows=11,078 loops=1)

  • Filter: (timeline_id = '7bcdd334-1e10-4993-91ae-f438c52c1c7a'::uuid)
  • Rows Removed by Filter: 13958
8. 33.234 33.234 ↑ 1.0 1 11,078

Index Scan using feeds_post_orderab_7ba03a_idx on feeds_post (cost=0.42..1.17 rows=1 width=1,900) (actual time=0.003..0.003 rows=1 loops=11,078)

  • Index Cond: (orderable_id = users_status.post_id)
Planning time : 2.489 ms
Execution time : 102.223 ms