explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mX21

Settings
# exclusive inclusive rows x rows loops node
1. 28.331 34.778 ↑ 1.0 100 1

ModifyTable on public.ci_pipelines (cost=122.33..481.51 rows=100 width=354) (actual time=4.854..34.778 rows=100 loops=1)

  • Buffers: shared hit=6,541 read=75 dirtied=330
  • I/O Timings: read=6.292
2. 0.192 6.447 ↑ 1.0 100 1

Nested Loop (cost=122.33..481.51 rows=100 width=354) (actual time=4.191..6.447 rows=100 loops=1)

  • Buffers: shared hit=805 dirtied=57
3. 0.141 4.255 ↑ 1.0 100 1

HashAggregate (cost=121.76..122.76 rows=100 width=32) (actual time=4.167..4.255 rows=100 loops=1)

  • Group Key: "ANY_subquery".id
  • Buffers: shared hit=305 dirtied=57
4. 0.055 4.114 ↑ 1.0 100 1

Subquery Scan on ANY_subquery (cost=0.28..121.51 rows=100 width=32) (actual time=2.043..4.114 rows=100 loops=1)

  • Buffers: shared hit=305 dirtied=57
5. 0.020 4.059 ↑ 1.0 100 1

Limit (cost=0.28..120.51 rows=100 width=10) (actual time=2.034..4.059 rows=100 loops=1)

  • Buffers: shared hit=305 dirtied=57
6. 0.949 4.039 ↑ 477.8 100 1

LockRows (cost=0.28..57,448.79 rows=47,780 width=10) (actual time=2.033..4.039 rows=100 loops=1)

  • Buffers: shared hit=305 dirtied=57
7. 3.090 3.090 ↑ 477.8 100 1

Index Scan using index_ci_pipelines_on_project_id_and_id_and_ref on public.ci_pipelines ci_pipelines_1 (cost=0.28..56,970.99 rows=47,780 width=10) (actual time=1.953..3.090 rows=100 loops=1)

  • Index Cond: ((ci_pipelines_1.project_id = 278,964) AND ((ci_pipelines_1.ref)::text = 'master'::text))
  • Filter: ((NOT ci_pipelines_1.tag) AND ci_pipelines_1.artifacts_locked)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=205 dirtied=55
8. 2.000 2.000 ↑ 1.0 1 100

Index Scan using ci_pipelines_pkey on public.ci_pipelines (cost=0.57..3.59 rows=1 width=317) (actual time=0.020..0.020 rows=1 loops=100)

  • Index Cond: (ci_pipelines.id = "ANY_subquery".id)
  • Buffers: shared hit=500