explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ASPAc

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 9.851 ↑ 10.1 30 1

Nested Loop Anti Join (cost=1.26..14,388.68 rows=302 width=285) (actual time=0.061..9.851 rows=30 loops=1)

  • Buffers: shared hit=7485
2. 0.166 0.166 ↑ 10.6 30 1

Index Scan using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines (cost=0.56..439.72 rows=319 width=285) (actual time=0.032..0.166 rows=30 loops=1)

  • Index Cond: ((project_id = 13083) AND ((ref)::text = 'master'::text) AND ((status)::text = ANY ('{created,preparing,pending,running,scheduled}'::text[])))
  • Filter: (((config_source = ANY ('{1,2}'::integer[])) OR (config_source IS NULL)) AND (id <> 152) AND ((sha)::text <> 'b83d6e391c22777fca1ed3012fce84f633d7fed0'::text))
  • Buffers: shared hit=49
3. 1.500 9.660 ↓ 0.0 0 30

Nested Loop (cost=0.70..45.54 rows=14 width=4) (actual time=0.322..0.322 rows=0 loops=30)

  • Buffers: shared hit=7436
4. 8.160 8.160 ↓ 3.1 119 30

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.57..39.53 rows=39 width=8) (actual time=0.023..0.272 rows=119 loops=30)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((status)::text = ANY ('{running,success,failure}'::text[])))
  • Buffers: shared hit=3876
5. 0.000 0.000 ↓ 0.0 0 3,560

Index Only Scan using ci_builds_metadata_build_id_idx on ci_builds_metadata (cost=0.12..0.14 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=3,560)

  • Index Cond: (build_id = ci_builds.id)
  • Heap Fetches: 0
  • Buffers: shared hit=3560
Planning time : 1.282 ms
Execution time : 9.921 ms