explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J8mA

Settings
# exclusive inclusive rows x rows loops node
1. 8.366 66.534 ↓ 7.6 3,257 1

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

  • Sort Key: actstream_action."timestamp
  • Sort Method: quicksort Memory: 571kB
  • Buffers: shared hit=14106
2. 19.150 58.168 ↓ 7.6 3,257 1

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

  • Buffers: shared hit=14106
3. 6.448 6.448 ↓ 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=0.024..6.448 rows=3,257 loops=1)

  • Index Cond: (user_id = 2219)
  • Buffers: shared hit=1067
4. 32.570 32.570 ↑ 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=0.010..0.010 rows=1 loops=3,257)

  • Index Cond: (id = tracking_useractionlog.action_id)
  • Buffers: shared hit=13039