explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wTJV

Settings
# exclusive inclusive rows x rows loops node
1. 85.544 9,508.148 ↑ 1.5 34,422 1

Index Scan using index_ci_pipelines_on_project_idandrefandiddesc on ci_pipelines (cost=129,635.83..258,855.96 rows=53,317 width=312) (actual time=9,423.865..9,508.148 rows=34,422 loops=1)

  • Index Cond: ((project_id = 278,964) AND ((ref)::text = 'master'::text) AND (id < 159932257))
  • Filter: ((NOT tag) AND (NOT (hashed SubPlan 2)))
  • (never executed)
2.          

SubPlan (for Index Scan)

3. 9,422.495 9,422.604 ↓ 0.0 0 1

Index Scan using index_ci_pipelines_on_project_idandrefandiddesc on ci_pipelines ci_pipelines_2 (cost=7.69..129,501.97 rows=53,317 width=4) (actual time=9,422.604..9,422.604 rows=0 loops=1)

  • Index Cond: ((project_id = 278,964) AND ((ref)::text = 'master'::text) AND (id < 159932257))
  • Filter: ((NOT tag) AND ((id = 159,932,257) OR (hashed SubPlan 1)))
  • Rows Removed by Filter: 34,422
4.          

SubPlan (for Index Scan)

5. 0.000 0.109 ↓ 0.0 0 1

Nested Loop (cost=1.00..7.11 rows=1 width=4) (actual time=0.109..0.109 rows=0 loops=1)

6. 0.109 0.109 ↓ 0.0 0 1

Index Scan using index_ci_sources_pipelines_on_source_pipeline_id on ci_sources_pipelines (cost=0.43..3.53 rows=1 width=4) (actual time=0.109..0.109 rows=0 loops=1)

  • Index Cond: (source_pipeline_id = 159,932,257)
  • Filter: (source_project_id = project_id)
  • Rows Removed by Filter: 1
7. 0.000 0.000 ↓ 0.0

Index Only Scan using ci_pipelines_pkey on ci_pipelines ci_pipelines_1 (cost=0.57..3.59 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = ci_sources_pipelines.pipeline_id)
  • Heap Fetches: 0
Planning time : 6.997 ms
Execution time : 9,510.069 ms