explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i3he : c_prod.sql

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1.005 ↑ 1.0 1 1

Aggregate (cost=98,423.73..98,423.74 rows=1 width=8) (actual time=1.004..1.005 rows=1 loops=1)

  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
2. 0.001 1.002 ↓ 0.0 0 1

Limit (cost=97,801.09..98,423.67 rows=5 width=4) (actual time=1.002..1.002 rows=0 loops=1)

  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
3. 0.000 1.001 ↓ 0.0 0 1

Nested Loop (cost=97,801.09..98,423.67 rows=5 width=4) (actual time=1.001..1.001 rows=0 loops=1)

  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
4. 0.000 1.001 ↓ 0.0 0 1

Nested Loop (cost=97,800.67..98,421.41 rows=5 width=8) (actual time=1.001..1.001 rows=0 loops=1)

  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
5. 0.000 1.001 ↓ 0.0 0 1

Nested Loop (cost=97,800.23..97,908.40 rows=51 width=8) (actual time=1.001..1.001 rows=0 loops=1)

  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
6. 0.001 1.001 ↓ 0.0 0 1

HashAggregate (cost=97,799.67..97,800.18 rows=51 width=4) (actual time=1.001..1.001 rows=0 loops=1)

  • Group Key: max(ci_pipelines_1.id)
  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
7. 0.000 1.000 ↓ 0.0 0 1

GroupAggregate (cost=97,798.14..97,799.03 rows=51 width=8) (actual time=1.000..1.000 rows=0 loops=1)

  • Group Key: ci_pipelines_1.project_id
  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
8. 0.032 1.000 ↓ 0.0 0 1

Sort (cost=97,798.14..97,798.27 rows=51 width=8) (actual time=1.000..1.000 rows=0 loops=1)

  • Sort Key: ci_pipelines_1.project_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5 read=2
  • I/O Timings: read=0.777
9. 0.000 0.968 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,866.65..97,796.69 rows=51 width=8) (actual time=0.968..0.968 rows=0 loops=1)

  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.777
10. 0.000 0.968 ↓ 0.0 0 1

Nested Loop (cost=1,866.22..9,055.65 rows=197,197 width=8) (actual time=0.968..0.968 rows=0 loops=1)

  • Join Filter: (ci_pipelines_1.project_id = rs.source_id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.777
11. 0.003 0.968 ↓ 0.0 0 1

HashAggregate (cost=1,865.65..1,874.52 rows=887 width=8) (actual time=0.968..0.968 rows=0 loops=1)

  • Group Key: projects.id
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.777
12. 0.000 0.965 ↓ 0.0 0 1

Nested Loop (cost=1.00..1,863.43 rows=887 width=8) (actual time=0.965..0.965 rows=0 loops=1)

  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.777
13. 0.965 0.965 ↓ 0.0 0 1

Index Scan using index_routes_on_path_text_pattern_ops on routes rs (cost=0.56..3.59 rows=924 width=4) (actual time=0.965..0.965 rows=0 loops=1)

  • Index Cond: (((path)::text ~>=~ 'nu-group/'::text) AND ((path)::text ~<~ 'nu-group0'::text))
  • Filter: (((path)::text ~~ 'nu-group/%'::text) AND ((source_type)::text = 'Project'::text))
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.777
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projects_pkey on projects (cost=0.43..2.00 rows=1 width=4) (never executed)

  • Index Cond: (id = rs.source_id)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ci_pipelines_on_project_id_and_status_and_config_source on ci_pipelines ci_pipelines_1 (cost=0.56..5.32 rows=222 width=8) (never executed)

  • Index Cond: ((project_id = projects.id) AND ((status)::text = 'success'::text))
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using index_vulnerability_occurrence_pipelines_on_pipeline_id on vulnerability_occurrence_pipelines vulnerability_occurrence_pipelines_1 (cost=0.43..6.56 rows=350 width=4) (never executed)

  • Index Cond: (pipeline_id = ci_pipelines_1.id)
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ci_pipelines_pkey on ci_pipelines (cost=0.56..2.11 rows=1 width=4) (never executed)

  • Index Cond: (id = (max(ci_pipelines_1.id)))
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Index Scan using index_vulnerability_occurrence_pipelines_on_pipeline_id on vulnerability_occurrence_pipelines (cost=0.43..6.56 rows=350 width=12) (never executed)

  • Index Cond: (pipeline_id = ci_pipelines.id)
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using vulnerability_occurrences_pkey on vulnerability_occurrences (cost=0.42..0.44 rows=1 width=8) (never executed)

  • Index Cond: (id = vulnerability_occurrence_pipelines.occurrence_id)
  • Heap Fetches: 0
Planning time : 23.538 ms
Execution time : 1.236 ms