explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wKnE

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

Nested Loop (cost=4.34..29.18 rows=3 width=139) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on user_feature u (cost=4.19..12.66 rows=3 width=49) (actual rows= loops=)

  • Recheck Cond: (uf_user_id = '07b6b1a6-6cf0-11ea-bc55-0242ac130003'::uuid)
  • Filter: uf_enabled
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on user_feature_uf_user_id_uf_feature_id_key (cost=0.00..4.19 rows=5 width=0) (actual rows= loops=)

  • Index Cond: (uf_user_id = '07b6b1a6-6cf0-11ea-bc55-0242ac130003'::uuid)
4. 0.000 0.000 ↓ 0.0

Index Scan using feature_pkey on feature f (cost=0.15..5.50 rows=1 width=90) (actual rows= loops=)

  • Index Cond: (f_id = u.uf_feature_id)