explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a4jL

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

Limit (cost=15.55..15.56 rows=1 width=299) (actual time=0.107..0.107 rows=0 loops=1)

2. 0.003 0.107 ↓ 0.0 0 1

Sort (cost=15.55..15.56 rows=1 width=299) (actual time=0.107..0.107 rows=0 loops=1)

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

Nested Loop (cost=12.51..15.54 rows=1 width=299) (actual time=0.104..0.104 rows=0 loops=1)

4. 0.001 0.104 ↓ 0.0 0 1

HashAggregate (cost=11.94..11.95 rows=1 width=4) (actual time=0.104..0.104 rows=0 loops=1)

  • Group Key: max(ci_pipelines_1.id)
5. 0.000 0.103 ↓ 0.0 0 1

GroupAggregate (cost=11.91..11.93 rows=1 width=17) (actual time=0.103..0.103 rows=0 loops=1)

  • Group Key: ci_pipelines_1.ref
6. 0.002 0.103 ↓ 0.0 0 1

Sort (cost=11.91..11.91 rows=1 width=17) (actual time=0.103..0.103 rows=0 loops=1)

  • Sort Key: ci_pipelines_1.ref
  • Sort Method: quicksort Memory: 25kB
7. 0.101 0.101 ↓ 0.0 0 1

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

  • Index Cond: ((project_id = 14074169) AND (ref = ANY ('{branch_1,branch_2,branch_3,branch_4,branch_5}'::text[])))
  • Heap Fetches: 0
8. 0.000 0.000 ↓ 0.0 0

Index Scan using ci_pipelines_pkey on ci_pipelines (cost=0.57..3.58 rows=1 width=299) (never executed)

  • Index Cond: (id = (max(ci_pipelines_1.id)))
Planning time : 0.825 ms
Execution time : 0.171 ms