explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vn3K

Settings
# exclusive inclusive rows x rows loops node
1. 1,468.266 1,514.764 ↓ 0.0 0 1

ModifyTable on public.vulnerabilities (cost=3,631.71..9,330.49 rows=1,933 width=295) (actual time=1,514.764..1,514.764 rows=0 loops=1)

  • Buffers: shared hit=139,381 read=1,472 dirtied=1,552
  • I/O Timings: read=1,274.050
2. 46.488 46.498 ↓ 2.1 3,974 1

Index Scan using index_vulnerabilities_on_project_id on public.vulnerabilities (cost=3,631.71..9,330.49 rows=1,933 width=295) (actual time=0.065..46.498 rows=3,974 loops=1)

  • Index Cond: (vulnerabilities.project_id = 278,964)
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4,542 dirtied=78
3.          

SubPlan (for Index Scan)

4. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=1.43..3,631.28 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=4
5. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=1.00..3,192.98 rows=914 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=4
6. 0.009 0.009 ↓ 0.0 0 1

Index Scan using index_vulnerability_occurrence_pipelines_on_pipeline_id on public.vulnerability_occurrence_pipelines vop (cost=0.57..67.47 rows=914 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (vop.pipeline_id = 158)
  • Buffers: shared hit=4
7. 0.000 0.000 ↓ 0.0 0 0

Index Scan using vulnerability_occurrences_pkey on public.vulnerability_occurrences vo (cost=0.43..3.42 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (vo.id = vop.occurrence_id)
8. 0.000 0.000 ↓ 0.0 0 0

Index Scan using vulnerabilities_pkey on public.vulnerabilities vulnerabilities_1 (cost=0.43..0.48 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (vulnerabilities_1.id = vo.vulnerability_id)
  • Filter: (vulnerabilities_1.project_id = 278,964)
  • Rows Removed by Filter: 0