explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mn5h : Secret Detection

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 17.993 ↑ 1.0 1 1

Limit (cost=469.35..469.35 rows=1 width=302) (actual time=17.992..17.993 rows=1 loops=1)

  • Buffers: shared hit=735 read=351
  • I/O Timings: read=15.507
2. 0.160 17.991 ↑ 1.0 1 1

Sort (cost=469.35..469.35 rows=1 width=302) (actual time=17.991..17.991 rows=1 loops=1)

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=735 read=351
  • I/O Timings: read=15.507
3. 0.075 17.831 ↓ 55.0 55 1

Nested Loop (cost=7.05..469.34 rows=1 width=302) (actual time=6.163..17.831 rows=55 loops=1)

  • Buffers: shared hit=735 read=351
  • I/O Timings: read=15.507
4. 0.091 16.326 ↓ 7.9 55 1

Nested Loop Semi Join (cost=6.48..439.34 rows=7 width=8) (actual time=5.469..16.326 rows=55 loops=1)

  • Buffers: shared hit=472 read=338
  • I/O Timings: read=14.506
5. 0.124 11.333 ↑ 1.2 57 1

Nested Loop (cost=5.91..256.48 rows=71 width=12) (actual time=4.994..11.333 rows=57 loops=1)

  • Buffers: shared hit=315 read=222
  • I/O Timings: read=10.095
6. 0.101 4.409 ↑ 1.0 100 1

HashAggregate (cost=5.48..6.48 rows=100 width=4) (actual time=4.377..4.409 rows=100 loops=1)

  • Group Key: ci_pipelines_1.id
  • Buffers: shared hit=3 read=103
  • I/O Timings: read=3.958
7. 0.016 4.308 ↑ 1.0 100 1

Limit (cost=0.57..4.23 rows=100 width=4) (actual time=0.872..4.308 rows=100 loops=1)

  • Buffers: shared hit=3 read=103
  • I/O Timings: read=3.958
8. 4.292 4.292 ↑ 896.5 100 1

Index Only Scan using index_ci_pipelines_on_project_idandrefandiddesc on public.ci_pipelines ci_pipelines_1 (cost=0.57..3,282.85 rows=89,651 width=4) (actual time=0.872..4.292 rows=100 loops=1)

  • Index Cond: ((ci_pipelines_1.project_id = 278964) AND (ci_pipelines_1.ref = 'master'::text))
  • Heap Fetches: 96
  • Buffers: shared hit=3 read=103
  • I/O Timings: read=3.958
9. 6.800 6.800 ↑ 1.0 1 100

Index Only Scan using index_ci_builds_on_commit_id_and_artifacts_expireatandidpart2 on public.ci_builds (cost=0.43..2.49 rows=1 width=8) (actual time=0.068..0.068 rows=1 loops=100)

  • Index Cond: (ci_builds.commit_id = ci_pipelines_1.id)
  • Heap Fetches: 50
  • Filter: ((ci_builds.artifacts_expire_at IS NULL) OR (ci_builds.artifacts_expire_at > '2020-05-15 13:24:34.543026'::timestamp without time zone))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=312 read=119
  • I/O Timings: read=6.137
10. 4.902 4.902 ↑ 1.0 1 57

Index Only Scan using index_ci_job_artifacts_on_job_id_and_file_type on public.ci_job_artifacts (cost=0.57..2.57 rows=1 width=4) (actual time=0.086..0.086 rows=1 loops=57)

  • Index Cond: ((ci_job_artifacts.job_id = ci_builds.id) AND (ci_job_artifacts.file_type = 1))
  • Heap Fetches: 16
  • Buffers: shared hit=157 read=116
  • I/O Timings: read=4.411
11. 1.430 1.430 ↑ 1.0 1 55

Index Scan using index_ci_pipelines_on_project_id_and_id_desc on public.ci_pipelines (cost=0.57..4.28 rows=1 width=302) (actual time=0.025..0.026 rows=1 loops=55)

  • Index Cond: ((ci_pipelines.project_id = 278964) AND (ci_pipelines.id = ci_builds.commit_id))
  • Filter: ((ci_pipelines.ref)::text = 'master'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=263 read=13
  • I/O Timings: read=1.001