explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5A4o

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 25.603 ↓ 0.0 0 1

Limit (cost=31,234.57..31,234.57 rows=1 width=4) (actual time=25.603..25.603 rows=0 loops=1)

  • Buffers: shared hit=19,593 read=18
  • I/O Timings: read=0.200
2. 0.011 25.602 ↓ 0.0 0 1

Sort (cost=31,234.57..31,234.57 rows=2 width=4) (actual time=25.602..25.602 rows=0 loops=1)

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=19,593 read=18
  • I/O Timings: read=0.200
3. 0.031 25.591 ↓ 0.0 0 1

Nested Loop Semi Join (cost=7.43..31,234.56 rows=2 width=4) (actual time=25.591..25.591 rows=0 loops=1)

  • Buffers: shared hit=19,593 read=18
  • I/O Timings: read=0.200
4. 0.063 1.860 ↑ 1.0 100 1

Nested Loop (cost=6.16..216.84 rows=100 width=8) (actual time=0.305..1.860 rows=100 loops=1)

  • Buffers: shared hit=560 read=18
  • I/O Timings: read=0.200
5. 0.056 0.297 ↑ 1.0 100 1

HashAggregate (cost=5.59..6.59 rows=100 width=4) (actual time=0.265..0.297 rows=100 loops=1)

  • Group Key: ci_pipelines_1.id
  • Buffers: shared hit=90
6. 0.241 0.241 ↑ 1.0 100 1

Limit (cost=0.57..4.34 rows=100 width=4) (actual time=0.044..0.241 rows=100 loops=1)

  • Buffers: shared hit=90
  • -> Index Only Scan Backward using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines ci_pipelines_1 (cost=0.57..2829.41 rows=75,071 width=4) (actual time
  • Index Cond: ((project_id = 7,764) AND (ref = 'master'::text) AND (status = 'success'::text))
  • Heap Fetches: 102
  • Buffers: shared hit=90
7. 1.500 1.500 ↑ 1.0 1 100

Index Only Scan using ci_pipelines_pkey on ci_pipelines (cost=0.57..2.10 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=100)

  • Index Cond: (id = ci_pipelines_1.id)
  • Heap Fetches: 69
  • Buffers: shared hit=470 read=18
  • I/O Timings: read=0.200
8. 0.335 23.700 ↓ 0.0 0 100

Nested Loop Semi Join (cost=1.27..310.17 rows=1 width=4) (actual time=0.237..0.237 rows=0 loops=100)

  • Buffers: shared hit=19,033
9. 13.100 13.100 ↑ 5.7 21 100

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.70..71.59 rows=119 width=8) (actual time=0.025..0.131 rows=21 loops=100)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((type)::text = 'Ci::Build'::text))
  • Filter: ((retried IS FALSE) OR (retried IS NULL))
  • Buffers: shared hit=8,094
10. 10.265 10.265 ↓ 0.0 0 2,053

Index Only Scan using index_ci_job_artifacts_on_job_id_and_file_type on ci_job_artifacts (cost=0.57..2.00 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=2,053)

  • Index Cond: (job_id = ci_builds.id)
  • Filter: (file_type = ANY ('{5,6,7,8,21,23}'::integer[]))
  • Rows Removed by Filter: 2
  • Heap Fetches: 5,532
  • Buffers: shared hit=10,939
Planning time : 3.508 ms
Execution time : 25.730 ms