explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kO3q

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.049 ↓ 0.0 0 1

Hash Join (cost=8.45..12.14 rows=1 width=278) (actual time=0.049..0.049 rows=0 loops=1)

  • Hash Cond: (f.f_id = u.uf_feature_id)
2. 0.011 0.011 ↑ 54.0 1 1

Seq Scan on feature f (cost=0.00..3.54 rows=54 width=229) (actual time=0.011..0.011 rows=1 loops=1)

3. 0.001 0.023 ↓ 0.0 0 1

Hash (cost=8.44..8.44 rows=1 width=49) (actual time=0.023..0.023 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.022 0.022 ↓ 0.0 0 1

Index Scan using user_feature_uf_user_id_uf_feature_id_key on user_feature u (cost=0.42..8.44 rows=1 width=49) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (uf_user_id = '07b6b1a6-6cf0-11ea-bc55-0242ac130003'::uuid)
  • Filter: uf_enabled