explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M3SAH

Settings
# exclusive inclusive rows x rows loops node
1. 0.087 0.087 ↑ 50.5 2 1

CTE Scan on base_and_ancestors ci_pipelines (cost=585.33..587.35 rows=101 width=1,784) (actual time=0.032..0.087 rows=2 loops=1)

  • Buffers: shared hit=17
  • - planning: 1.663 ms
  • - execution: 0.239 ms
  • - I/O read: 0.000 ms
  • - I/O write: 0.000 ms
  • - hits: 17 (~136.00 KiB) from the buffer pool
  • - reads: 0 from the OS file cache, including disk I/O
  • - dirtied: 0
  • - writes: 0
2.          

CTE base_and_ancestors

3. 0.014 0.081 ↑ 50.5 2 1

Recursive Union (cost=0.57..585.33 rows=101 width=316) (actual time=0.028..0.081 rows=2 loops=1)

  • Buffers: shared hit=17
4. 0.023 0.023 ↑ 1.0 1 1

Index Scan using ci_pipelines_pkey on public.ci_pipelines ci_pipelines_1 (cost=0.57..3.59 rows=1 width=316) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: (ci_pipelines_1.id = 171,465,064)
  • Buffers: shared hit=5
5. 0.001 0.044 ↓ 0.0 0 2

Nested Loop (cost=1.00..57.97 rows=10 width=316) (actual time=0.022..0.022 rows=0 loops=2)

  • Buffers: shared hit=12
6. 0.006 0.028 ↓ 0.0 0 2

Nested Loop (cost=0.43..34.77 rows=10 width=4) (actual time=0.013..0.014 rows=0 loops=2)

  • Buffers: shared hit=7
7. 0.002 0.002 ↑ 10.0 1 2

WorkTable Scan on base_and_ancestors (cost=0.00..0.20 rows=10 width=4) (actual time=0.001..0.001 rows=1 loops=2)

8. 0.020 0.020 ↓ 0.0 0 2

Index Scan using index_ci_sources_pipelines_on_pipeline_id on public.ci_sources_pipelines (cost=0.43..3.45 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=2)

  • Index Cond: (ci_sources_pipelines.pipeline_id = base_and_ancestors.id)
  • Buffers: shared hit=7
9. 0.015 0.015 ↑ 1.0 1 1

Index Scan using ci_pipelines_pkey on public.ci_pipelines ci_pipelines_2 (cost=0.57..2.32 rows=1 width=316) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (ci_pipelines_2.id = ci_sources_pipelines.source_pipeline_id)
  • Buffers: shared hit=5