explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yma

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

Aggregate (cost=5,767.42..5,767.43 rows=1 width=4) (actual time=0.533..0.533 rows=1 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=0.478
2. 0.529 0.529 ↓ 0.0 0 1

Index Scan using aa_index_ci_builds_b2 on public.ci_builds (cost=0.57..5,760.32 rows=2,843 width=4) (actual time=0.529..0.529 rows=0 loops=1)

  • Index Cond: ((ci_builds.name)::text = 'container_scanning_jobs'::text)
  • Buffers: shared read=4
  • I/O Timings: read=0.478