explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mPsf

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 21.906 ↓ 0.0 0 1

ModifyTable on public.ci_pipelines (cost=101,202.97..101,206.00 rows=1 width=354) (actual time=21.906..21.906 rows=0 loops=1)

  • Buffers: shared hit=18,918
2. 0.001 21.904 ↓ 0.0 0 1

Nested Loop (cost=101,202.97..101,206.00 rows=1 width=354) (actual time=21.904..21.904 rows=0 loops=1)

  • Buffers: shared hit=18,918
3. 0.002 21.903 ↓ 0.0 0 1

HashAggregate (cost=101,202.40..101,202.41 rows=1 width=32) (actual time=21.903..21.903 rows=0 loops=1)

  • Group Key: "ANY_subquery".id
  • Buffers: shared hit=18,918
4. 0.002 21.901 ↓ 0.0 0 1

Subquery Scan on ANY_subquery (cost=101,117.09..101,202.40 rows=1 width=32) (actual time=21.900..21.901 rows=0 loops=1)

  • Buffers: shared hit=18,918
5. 0.001 21.899 ↓ 0.0 0 1

Limit (cost=101,117.09..101,202.39 rows=1 width=10) (actual time=21.899..21.899 rows=0 loops=1)

  • Buffers: shared hit=18,918
6. 0.001 21.898 ↓ 0.0 0 1

LockRows (cost=101,117.09..150,929.93 rows=584 width=10) (actual time=21.898..21.898 rows=0 loops=1)

  • Buffers: shared hit=18,918
7. 21.897 21.897 ↓ 0.0 0 1

Index Scan using index_ci_pipelines_on_project_id_and_id_and_ref on public.ci_pipelines ci_pipelines_1 (cost=101,117.09..150,924.09 rows=584 width=10) (actual time=21.897..21.897 rows=0 loops=1)

  • Index Cond: ((ci_pipelines_1.project_id = 278,964) AND (ci_pipelines_1.id < 140361418) AND ((ci_pipelines_1.ref)::text = 'master'::text))
  • Filter: (ci_pipelines_1.tag AND ci_pipelines_1.artifacts_locked AND (NOT (hashed SubPlan 2)))
  • Rows Removed by Filter: 15,852
  • Buffers: shared hit=18,918
8.          

SubPlan (for Index Scan)

9. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_ci_pipelines_on_project_idandrefandiddesc on public.ci_pipelines ci_pipelines_3 (cost=7.69..101,113.90 rows=1,167 width=4) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: ((ci_pipelines_3.project_id = 278,964) AND ((ci_pipelines_3.ref)::text = 'master'::text) AND (ci_pipelines_3.id < 140361418))
  • Filter: (ci_pipelines_3.tag AND ((ci_pipelines_3.id = 140,361,418) OR (hashed SubPlan 1)))
  • Rows Removed by Filter: 0
10.          

SubPlan (for Index Scan)

11. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.00..7.12 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=0)

12. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_ci_sources_pipelines_on_source_pipeline_id on public.ci_sources_pipelines (cost=0.43..3.53 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (ci_sources_pipelines.source_pipeline_id = 140,361,418)
  • Filter: (ci_sources_pipelines.source_project_id = ci_sources_pipelines.project_id)
  • Rows Removed by Filter: 0
13. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using ci_pipelines_pkey on public.ci_pipelines ci_pipelines_2 (cost=0.57..3.59 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (ci_pipelines_2.id = ci_sources_pipelines.pipeline_id)
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (ci_pipelines.id = "ANY_subquery".id)