explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LTej : Secret Detection

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

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

  • Buffers: shared hit=738 read=351 dirtied=71
  • I/O Timings: read=469.534
2. 0.315 509.545 ↑ 1.0 1 1

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

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=738 read=351 dirtied=71
  • I/O Timings: read=469.534
3. 0.142 509.230 ↓ 55.0 55 1

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

  • Buffers: shared hit=738 read=351 dirtied=71
  • I/O Timings: read=469.534
4. 0.180 483.183 ↓ 7.9 55 1

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

  • Buffers: shared hit=472 read=338 dirtied=70
  • I/O Timings: read=444.587
5. 0.245 310.350 ↑ 1.2 57 1

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

  • Buffers: shared hit=315 read=222 dirtied=63
  • I/O Timings: read=282.199
6. 0.346 177.005 ↑ 1.0 100 1

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

  • Group Key: ci_pipelines_1.id
  • Buffers: shared hit=3 read=103 dirtied=63
  • I/O Timings: read=150.716
7. 0.062 176.659 ↑ 1.0 100 1

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

  • Buffers: shared hit=3 read=103 dirtied=63
  • I/O Timings: read=150.716
8. 176.597 176.597 ↑ 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=15.475..176.597 rows=100 loops=1)

  • Index Cond: ((ci_pipelines_1.project_id = 278964) AND (ci_pipelines_1.ref = 'master'::text))
  • Heap Fetches: 103
  • Buffers: shared hit=3 read=103 dirtied=63
  • I/O Timings: read=150.716
9. 133.100 133.100 ↑ 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=1.331..1.331 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=131.483
10. 172.653 172.653 ↑ 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=3.029..3.029 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 dirtied=7
  • I/O Timings: read=162.388
11. 25.905 25.905 ↑ 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.453..0.471 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=266 read=13 dirtied=1
  • I/O Timings: read=24.947