explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UmJG : c.sql

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.012 ↑ 1.0 1 1

Aggregate (cost=11.47..11.48 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1)

2. 0.000 0.011 ↓ 0.0 0 1

Limit (cost=5.37..11.37 rows=8 width=4) (actual time=0.011..0.011 rows=0 loops=1)

3. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=5.37..11.37 rows=8 width=4) (actual time=0.011..0.011 rows=0 loops=1)

4. 0.001 0.011 ↓ 0.0 0 1

Nested Loop (cost=5.10..8.38 rows=8 width=8) (actual time=0.011..0.011 rows=0 loops=1)

5. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=4.82..6.86 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

6. 0.000 0.010 ↓ 0.0 0 1

HashAggregate (cost=4.68..4.69 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: max(ci_pipelines_1.id)
7. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=4.65..4.67 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: ci_pipelines_1.project_id
8. 0.006 0.010 ↓ 0.0 0 1

Sort (cost=4.65..4.65 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: ci_pipelines_1.project_id
  • Sort Method: quicksort Memory: 25kB
9. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Semi Join (cost=3.75..4.64 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

10. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=3.48..3.71 rows=3 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Join Filter: (ci_pipelines_1.project_id = rs.source_id)
11. 0.000 0.004 ↓ 0.0 0 1

HashAggregate (cost=3.34..3.35 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Group Key: projects.id
12. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.28..3.33 rows=1 width=8) (actual time=0.004..0.005 rows=0 loops=1)

13. 0.004 0.004 ↓ 0.0 0 1

Index Scan using index_routes_on_path_text_pattern_ops on routes rs (cost=0.14..2.17 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((path)::text ~>=~ 'gitlab-com/'::text) AND ((path)::text ~<~ 'gitlab-com0'::text))
  • Filter: (((path)::text ~~ 'gitlab-com/%'::text) AND ((source_type)::text = 'Project'::text))
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on projects (cost=0.14..1.16 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.14..0.32 rows=3 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.28..1.18 rows=41 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.14..2.16 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.28..1.11 rows=41 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.28..0.36 rows=1 width=8) (never executed)

  • Index Cond: (id = vulnerability_occurrence_pipelines.occurrence_id)
  • Heap Fetches: 0