explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DdcL

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.162 ↑ 1.0 1 1

Aggregate (cost=16.04..16.05 rows=1 width=4) (actual time=0.161..0.162 rows=1 loops=1)

  • Buffers: shared hit=7
2. 0.158 0.158 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_commit_id_and_type_and_name_and_ref on ci_builds (cost=0.28..16.03 rows=1 width=4) (actual time=0.157..0.158 rows=0 loops=1)

  • Index Cond: (((type)::text = 'Ci::Build'::text) AND ((name)::text = 'container_scanning_jobs'::text))
  • Buffers: shared hit=7