explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZDWq : same_family_pipeline_ids

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 0.049 ↑ 31.0 1 1

CTE Scan on base_and_descendants ci_pipelines (cost=4,399.23..4,399.85 rows=31 width=4) (actual time=0.025..0.049 rows=1 loops=1)

  • Buffers: shared hit=13
  • - planning: 1.749 ms
  • - execution: 0.238 ms
  • - I/O read: 0.000 ms
  • - I/O write: 0.000 ms
  • - hits: 13 (~104.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_descendants

3. 0.003 0.047 ↑ 31.0 1 1

Recursive Union (cost=387.47..4,399.23 rows=31 width=1,784) (actual time=0.024..0.047 rows=1 loops=1)

  • Buffers: shared hit=13
4. 0.035 0.035 ↑ 11.0 1 1

CTE Scan on base_and_ancestors ci_pipelines_3 (cost=387.47..387.69 rows=11 width=1,784) (actual time=0.021..0.035 rows=1 loops=1)

  • Buffers: shared hit=9
5.          

CTE base_and_ancestors

6. 0.005 0.033 ↑ 11.0 1 1

Recursive Union (cost=0.57..387.47 rows=11 width=314) (actual time=0.019..0.033 rows=1 loops=1)

  • Buffers: shared hit=9
7. 0.015 0.015 ↑ 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=314) (actual time=0.014..0.015 rows=1 loops=1)

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

Nested Loop (cost=1.00..38.37 rows=1 width=314) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=4
9. 0.002 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.43..34.80 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=4
10. 0.001 0.001 ↑ 10.0 1 1

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

11. 0.009 0.009 ↓ 0.0 0 1

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.009..0.009 rows=0 loops=1)

  • Index Cond: (ci_sources_pipelines.pipeline_id = base_and_ancestors.id)
  • Filter: (ci_sources_pipelines.source_project_id = ci_sources_pipelines.project_id)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4
12. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (ci_pipelines_2.id = ci_sources_pipelines.source_pipeline_id)
13. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=1.00..401.09 rows=2 width=314) (actual time=0.009..0.009 rows=0 loops=1)

  • Buffers: shared hit=4
14. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.43..393.96 rows=2 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Buffers: shared hit=4
15. 0.001 0.001 ↑ 110.0 1 1

WorkTable Scan on base_and_descendants (cost=0.00..2.20 rows=110 width=4) (actual time=0.001..0.001 rows=1 loops=1)

16. 0.008 0.008 ↓ 0.0 0 1

Index Scan using index_ci_sources_pipelines_on_source_pipeline_id on public.ci_sources_pipelines ci_sources_pipelines_1 (cost=0.43..3.55 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (ci_sources_pipelines_1.source_pipeline_id = base_and_descendants.id)
  • Filter: (ci_sources_pipelines_1.source_project_id = ci_sources_pipelines_1.project_id)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4
17. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (ci_pipelines_4.id = ci_sources_pipelines_1.pipeline_id)