explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HDEv : Secret Detection

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 924.574 ↑ 1.0 1 1

Aggregate (cost=66,318.59..66,318.60 rows=1 width=8) (actual time=924.574..924.574 rows=1 loops=1)

  • Buffers: shared hit=16990 read=38176 written=343
  • I/O Timings: read=774.151 write=12.693
2. 924.569 924.569 ↓ 0.0 0 1

Index Scan using ci_builds_pkey on public.ci_builds (cost=0.57..66,318.58 rows=1 width=4) (actual time=924.569..924.569 rows=0 loops=1)

  • Index Cond: ((ci_builds.id >= 0) AND (ci_builds.id <= 99999))
  • Filter: (((ci_builds.type)::text = 'Ci::Build'::text) AND ((ci_builds.name)::text = 'secret_detection'::text))
  • Rows Removed by Filter: 73332
  • Buffers: shared hit=16990 read=38176 written=343
  • I/O Timings: read=774.151 write=12.693