explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WISc

Settings
# exclusive inclusive rows x rows loops node
1. 10.597 84,288.028 ↓ 7.6 3,257 1

Sort (cost=4,817.85..4,818.92 rows=427 width=139) (actual time=84,286.657..84,288.028 rows=3,257 loops=1)

  • Sort Key: actstream_action."timestamp
  • Sort Method: quicksort Memory: 571kB
  • Buffers: shared hit=11268 read=2841
2. 13.909 84,277.431 ↓ 7.6 3,257 1

Nested Loop (cost=0.85..4,799.20 rows=427 width=139) (actual time=125.425..84,277.431 rows=3,257 loops=1)

  • Buffers: shared hit=11265 read=2841
3. 27,197.625 27,197.625 ↓ 7.6 3,257 1

Index Scan using tracking_useractionlog_e8701ad4 on tracking_useractionlog (cost=0.43..1,255.84 rows=427 width=4) (actual time=85.373..27,197.625 rows=3,257 loops=1)

  • Index Cond: (user_id = 2219)
  • Buffers: shared hit=128 read=939
4. 57,065.897 57,065.897 ↑ 1.0 1 3,257

Index Scan using actstream_action_pkey on actstream_action (cost=0.43..8.29 rows=1 width=139) (actual time=17.515..17.521 rows=1 loops=3,257)

  • Index Cond: (id = tracking_useractionlog.action_id)
  • Buffers: shared hit=11137 read=1902