# | 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)
|
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)
|
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)
|
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)
|
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)
|
Planning time | : | 8.870 ms |
---|---|---|
Execution time | : | 388.969 ms |