#	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

                                                                                      QUERY PLAN                                                                                      
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop Anti Join  (cost=1.71..21631.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
   ->  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
   ->  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
         ->  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
         ->  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
(21 rows)

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	31.354 ms	8.1 %
Index Scan	2	356.053 ms	91.6 %
Nested Loop	1	1.382 ms	0.4 %
Nested Loop Anti Join	1	0.070 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
ci_builds	1	355.179 ms	91.3 %
Index Scan	1	355.179 ms	100.0 %
ci_builds_metadata	1	31.354 ms	8.1 %
Index Only Scan	1	31.354 ms	100.0 %
ci_pipelines	1	0.874 ms	0.2 %
Index Scan	1	0.874 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eslc

Color mode:

Visible columns:

Per node type stats

Per table stats