explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P8Fd

Settings
# exclusive inclusive rows x rows loops node
1. 13.514 15.536 ↑ 1.0 100 1

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

  • Buffers: shared hit=6,377 read=5 dirtied=216
  • I/O Timings: read=0.236
2. 0.123 2.022 ↑ 1.0 100 1

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

  • Buffers: shared hit=702 dirtied=88
3. 0.108 0.999 ↑ 1.0 100 1

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

  • Group Key: "ANY_subquery".id
  • Buffers: shared hit=202 dirtied=88
4. 0.056 0.891 ↑ 1.0 100 1

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

  • Buffers: shared hit=202 dirtied=88
5. 0.018 0.835 ↑ 1.0 100 1

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

  • Buffers: shared hit=202 dirtied=88
6. 0.518 0.817 ↑ 477.8 100 1

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

  • Buffers: shared hit=202 dirtied=88
7. 0.299 0.299 ↑ 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=0.034..0.299 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=102
8. 0.900 0.900 ↑ 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.009..0.009 rows=1 loops=100)

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