explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HBRx : favorites.getFavoriteProjectEmailRecipientsWithoutDonations

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 64.308 ↓ 22.0 22 1

Unique (cost=28.71..28.72 rows=1 width=4) (actual time=64.301..64.308 rows=22 loops=1)

  • Buffers: shared hit=125 read=147
  • I/O Timings: read=63.736
2. 0.038 64.304 ↓ 22.0 22 1

Sort (cost=28.71..28.72 rows=1 width=4) (actual time=64.301..64.304 rows=22 loops=1)

  • Sort Key: challenge.donorid
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=125 read=147
  • I/O Timings: read=63.736
3. 0.033 64.266 ↓ 22.0 22 1

Nested Loop Left Join (cost=1.29..28.70 rows=1 width=4) (actual time=10.059..64.266 rows=22 loops=1)

  • Filter: (donorproposal.id IS NULL)
  • Rows Removed by Filter: 8
  • Buffers: shared hit=122 read=147
  • I/O Timings: read=63.736
4. 0.032 39.543 ↓ 30.0 30 1

Nested Loop (cost=0.85..25.54 rows=1 width=4) (actual time=3.945..39.543 rows=30 loops=1)

  • Buffers: shared hit=74 read=97
  • I/O Timings: read=39.209
5. 12.876 12.876 ↓ 17.5 35 1

Index Scan using challengeproposal_proposalid on challengeproposal (cost=0.43..8.62 rows=2 width=4) (actual time=1.438..12.876 rows=35 loops=1)

  • Index Cond: (proposalid = 1563383)
  • Buffers: shared hit=1 read=30
  • I/O Timings: read=12.800
6. 26.635 26.635 ↑ 1.0 1 35

Index Scan using pk_challenge on challenge (cost=0.43..8.45 rows=1 width=8) (actual time=0.761..0.761 rows=1 loops=35)

  • Index Cond: (challengeid = challengeproposal.challengeid)
  • Filter: (givingpagecampaign = 8)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=73 read=67
  • I/O Timings: read=26.409
7. 24.690 24.690 ↓ 0.0 0 30

Index Scan using uix_donorproposal on donorproposal (cost=0.43..3.15 rows=1 width=8) (actual time=0.823..0.823 rows=0 loops=30)

  • Index Cond: ((donorid = challenge.donorid) AND (proposalid = 1563383))
  • Buffers: shared hit=48 read=50
  • I/O Timings: read=24.527
Planning time : 21.377 ms
Execution time : 64.386 ms