explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eslc

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 388.859 ↑ 31.4 10 1

Nested Loop Anti Join (cost=1.71..21,631.59 rows=314 width=288) (actual time=0.934..388.859 rows=10 loops=1)

  • Buffers: shared hit=2455 read=560
  • I/O Timings: read=366.702
2. 0.874 0.874 ↑ 10.0 33 1

Index Scan using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines (cost=0.57..453.82 rows=331 width=288) (actual time=0.135..0.874 rows=33 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=53
3. 1.382 387.915 ↑ 31.0 1 33

Nested Loop (cost=1.14..66.66 rows=31 width=4) (actual time=11.755..11.755 rows=1 loops=33)

  • Buffers: shared hit=2402 read=560
  • I/O Timings: read=366.702
4. 355.179 355.179 ↑ 2.6 16 33

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.57..41.28 rows=42 width=8) (actual time=1.064..10.763 rows=16 loops=33)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((status)::text = ANY ('{running,success,failure}'::text[])))
  • Buffers: shared hit=373 read=516
  • I/O Timings: read=339.799
5. 31.354 31.354 ↓ 0.0 0 514

Index Only Scan using index_ci_builds_metadata_on_build_id on ci_builds_metadata (cost=0.57..0.59 rows=1 width=4) (actual time=0.061..0.061 rows=0 loops=514)

  • Index Cond: (build_id = ci_builds.id)
  • Heap Fetches: 2
  • Buffers: shared hit=2029 read=44
  • I/O Timings: read=26.903
Planning time : 8.870 ms
Execution time : 388.969 ms