explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n71i

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.518 ↑ 1.0 1 1

Aggregate (cost=1,792.27..1,792.28 rows=1 width=8) (actual time=0.518..0.518 rows=1 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=0.468
2. 0.002 0.515 ↓ 0.0 0 1

Bitmap Heap Scan on public.ci_builds (cost=1,790.25..1,792.27 rows=1 width=4) (actual time=0.515..0.515 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=0.468
3. 0.001 0.513 ↓ 0.0 0 1

BitmapAnd (cost=1,790.25..1,790.25 rows=1 width=0) (actual time=0.513..0.513 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=0.468
4. 0.512 0.512 ↓ 0.0 0 1

Bitmap Index Scan using aa_index_ci_builds_b2 (cost=0.00..45.89 rows=2,843 width=0) (actual time=0.512..0.512 rows=0 loops=1)

  • Index Cond: ((ci_builds.name)::text = 'container_scanning_jobs'::text)
  • Buffers: shared read=4
  • I/O Timings: read=0.468
5. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan using ci_builds_pkey (cost=0.00..1,744.10 rows=94,353 width=0) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: ((ci_builds.id >= 0) AND (ci_builds.id <= 99999))