explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eBCU

Settings
# exclusive inclusive rows x rows loops node
1. 0.084 1.629 ↓ 85.0 85 1

Sort (cost=502.02..502.02 rows=1 width=236) (actual time=1.618..1.629 rows=85 loops=1)

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: quicksort Memory: 47kB
2. 0.072 1.545 ↓ 85.0 85 1

Nested Loop (cost=141.32..502.01 rows=1 width=236) (actual time=1.063..1.545 rows=85 loops=1)

3. 0.052 1.073 ↑ 1.0 100 1

HashAggregate (cost=140.76..141.76 rows=100 width=4) (actual time=1.049..1.073 rows=100 loops=1)

  • Group Key: ci_pipelines_1.id
4. 0.011 1.021 ↑ 1.0 100 1

Limit (cost=0.56..139.51 rows=100 width=4) (actual time=0.062..1.021 rows=100 loops=1)

5. 1.010 1.010 ↑ 354.9 100 1

Index Scan using nik_tmp_ci_pipelines_ce_50763 on ci_pipelines ci_pipelines_1 (cost=0.56..49,305.13 rows=35,485 width=4) (actual time=0.060..1.010 rows=100 loops=1)

  • Index Cond: ((project_id = 13083) AND ((ref)::text = 'master'::text))
  • Filter: ((config_source = ANY ('{1,2}'::integer[])) OR (config_source IS NULL))
6. 0.400 0.400 ↑ 1.0 1 100

Index Scan using nik_tmp_ci_pipelines_ce_50763 on ci_pipelines (cost=0.56..3.59 rows=1 width=236) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: ((project_id = 13083) AND ((ref)::text = 'master'::text) AND (id = ci_pipelines_1.id))
  • Filter: (((config_source = ANY ('{1,2}'::integer[])) OR (config_source IS NULL)) AND ((status)::text = 'success'::text))
  • Rows Removed by Filter: 0