explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cCVt

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.395 ↑ 1.0 100 1

Limit (cost=0.28..119.51 rows=100 width=4) (actual time=0.036..0.395 rows=100 loops=1)

  • Buffers: shared hit=104
2. 0.379 0.379 ↑ 477.8 100 1

Index Scan using index_ci_pipelines_on_project_id_and_id_and_ref on public.ci_pipelines (cost=0.28..56,970.99 rows=47,780 width=4) (actual time=0.035..0.379 rows=100 loops=1)

  • Index Cond: ((ci_pipelines.project_id = 278,964) AND ((ci_pipelines.ref)::text = 'master'::text))
  • Filter: (NOT ci_pipelines.tag)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=104