explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0WYa

Settings
# exclusive inclusive rows x rows loops node
1. 0.196 1.298 ↓ 5.0 15 1

Nested Loop (cost=5.31..269.74 rows=3 width=929) (actual time=1.051..1.298 rows=15 loops=1)

  • Join Filter: (v.namespace_id = vn.id)
  • Rows Removed by Join Filter: 510
2. 0.017 0.017 ↓ 1.0 35 1

Seq Scan on namespace vn (cost=0.00..1.34 rows=34 width=552) (actual time=0.006..0.017 rows=35 loops=1)

3. 0.192 1.085 ↓ 5.0 15 35

Materialize (cost=5.31..266.87 rows=3 width=385) (actual time=0.006..0.031 rows=15 loops=35)

4. 0.051 0.893 ↓ 5.0 15 1

Nested Loop (cost=5.31..266.86 rows=3 width=385) (actual time=0.187..0.893 rows=15 loops=1)

5. 0.131 0.486 ↓ 4.2 89 1

Nested Loop (cost=4.88..251.72 rows=21 width=22) (actual time=0.030..0.486 rows=89 loops=1)

6. 0.075 0.088 ↓ 4.2 89 1

Bitmap Heap Scan on vulnerability_affects_featureversion vafv (cost=4.46..74.37 rows=21 width=8) (actual time=0.018..0.088 rows=89 loops=1)

  • Recheck Cond: (featureversion_id = 16)
  • Heap Blocks: exact=30
7. 0.013 0.013 ↓ 4.2 89 1

Bitmap Index Scan on vulnerability_affects_feature_featureversion_id_vulnerabili_idx (cost=0.00..4.45 rows=21 width=0) (actual time=0.013..0.013 rows=89 loops=1)

  • Index Cond: (featureversion_id = 16)
8. 0.267 0.267 ↑ 1.0 1 89

Index Scan using vulnerability_fixedin_feature_pkey on vulnerability_fixedin_feature vfif (cost=0.43..8.45 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=89)

  • Index Cond: (id = vafv.fixedin_id)
9. 0.356 0.356 ↓ 0.0 0 89

Index Scan using vulnerability_pkey on vulnerability v (cost=0.43..0.72 rows=1 width=367) (actual time=0.004..0.004 rows=0 loops=89)

  • Index Cond: (id = vfif.vulnerability_id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1