explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tBs4

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=12,491.62..12,495.78 rows=1,665 width=137) (actual rows= loops=)

  • Sort Key: fv.id DESC
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=6,258.19..12,402.53 rows=1,665 width=137) (actual rows= loops=)

  • Hash Cond: ((fu.user_id = fv.user_id) AND (fu.feed_view_id = fv.id))
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feed_user_action5 fu (cost=77.46..6,213.07 rows=1,665 width=25) (actual rows= loops=)

  • Recheck Cond: (user_id = 'cbdf9b9f-3278-42ef-b2fa-4531a04dc62b'::uuid)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on feed_user_action5_pkey (cost=0.00..77.05 rows=1,665 width=0) (actual rows= loops=)

  • Index Cond: (user_id = 'cbdf9b9f-3278-42ef-b2fa-4531a04dc62b'::uuid)
5. 0.000 0.000 ↓ 0.0

Hash (cost=6,155.75..6,155.75 rows=1,665 width=136) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feed_view4 fv (cost=49.46..6,155.75 rows=1,665 width=136) (actual rows= loops=)

  • Recheck Cond: (user_id = 'cbdf9b9f-3278-42ef-b2fa-4531a04dc62b'::uuid)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on feed_view4_compoite (cost=0.00..49.05 rows=1,665 width=0) (actual rows= loops=)

  • Index Cond: (user_id = 'cbdf9b9f-3278-42ef-b2fa-4531a04dc62b'::uuid)