explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jTv3

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

Limit (cost=24.87..43.46 rows=20 width=418) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=24.87..83.43 rows=63 width=418) (actual rows= loops=)

  • Join Filter: (e.feed_id = f.id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=24.73..82.02 rows=6 width=434) (actual rows= loops=)

  • Join Filter: (s.feed_id = e.feed_id)
4. 0.000 0.000 ↓ 0.0

Index Scan using entries_pkey on entries e (cost=0.14..20.30 rows=180 width=418) (actual rows= loops=)

  • Index Cond: (id > 1)
5. 0.000 0.000 ↓ 0.0

Materialize (cost=24.59..42.84 rows=7 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=24.59..42.80 rows=7 width=16) (actual rows= loops=)

  • Hash Cond: (s.id = ss.subscription_id)
7. 0.000 0.000 ↓ 0.0

Seq Scan on subscriptions s (cost=0.00..16.50 rows=650 width=32) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=24.50..24.50 rows=7 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on streams_subscriptions ss (cost=14.35..24.50 rows=7 width=16) (actual rows= loops=)

  • Recheck Cond: (stream_id = '0c512e88-da12-4f41-9a5d-8e773fa5e057'::uuid)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on streams_subscriptions_pkey (cost=0.00..14.35 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (stream_id = '0c512e88-da12-4f41-9a5d-8e773fa5e057'::uuid)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using feeds_pkey on feeds f (cost=0.14..0.22 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = s.feed_id)