explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uKCG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.043 ↓ 0.0 0 1

Limit (cost=11.95..11.96 rows=1 width=303) (actual time=0.043..0.043 rows=0 loops=1)

2. 0.003 0.043 ↓ 0.0 0 1

Sort (cost=11.95..11.96 rows=1 width=303) (actual time=0.043..0.043 rows=0 loops=1)

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.040 ↓ 0.0 0 1

Subquery Scan on ci_pipelines (cost=11.91..11.94 rows=1 width=303) (actual time=0.040..0.040 rows=0 loops=1)

  • Filter: (ci_pipelines.id = ci_pipelines.latest_id)
4. 0.003 0.040 ↓ 0.0 0 1

WindowAgg (cost=11.91..11.93 rows=1 width=303) (actual time=0.039..0.040 rows=0 loops=1)

5. 0.003 0.037 ↓ 0.0 0 1

Sort (cost=11.91..11.91 rows=1 width=299) (actual time=0.037..0.037 rows=0 loops=1)

  • Sort Key: ci_pipelines_1.ref, ci_pipelines_1.id DESC
  • Sort Method: quicksort Memory: 25kB
6. 0.034 0.034 ↓ 0.0 0 1

Index Scan using index_ci_pipelines_on_project_idandrefandiddesc on ci_pipelines ci_pipelines_1 (cost=0.57..11.90 rows=1 width=299) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: ((project_id = 14,074,169) AND ((ref)::text = ANY ('{branch_1,branch_2,branch_3,branch_4,branch_5}'::text[])))
Planning time : 0.782 ms
Execution time : 0.109 ms