explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lz1F

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

Limit (cost=1.12..1,257.48 rows=100 width=187) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.12..20,793.80 rows=1,655 width=187) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan Backward using feed_view4_compoite on feed_view4 fv (cost=0.56..6,653.62 rows=1,655 width=136) (actual rows= loops=)

  • Index Cond: ((user_id = 'cbdf9b9f-3278-42ef-b2fa-4531a04dc62b'::uuid) AND (id < 14982021))
4. 0.000 0.000 ↓ 0.0

Index Scan using feed_user_action5_pkey on feed_user_action5 fu (cost=0.56..8.54 rows=1 width=51) (actual rows= loops=)

  • Index Cond: ((user_id = fv.user_id) AND (user_id = 'cbdf9b9f-3278-42ef-b2fa-4531a04dc62b'::uuid) AND (fv.id = feed_view_id) AND (feed_view_id < 14982021))