explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BSyD : Secret Detection

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.277 ↑ 1.0 1 1

Result (cost=0.49..0.50 rows=1 width=4) (actual time=0.277..0.277 rows=1 loops=1)

  • Buffers: shared read=3
  • I/O Timings: read=0.250
2.          

Initplan (for Result)

3. 0.001 0.275 ↓ 0.0 0 1

Limit (cost=0.43..0.49 rows=1 width=4) (actual time=0.275..0.275 rows=0 loops=1)

  • Buffers: shared read=3
  • I/O Timings: read=0.250
4. 0.274 0.274 ↓ 0.0 0 1

Index Only Scan using index_ci_builds_on_name_and_security_type_eq_ci_build_2 on public.ci_builds (cost=0.43..166.11 rows=3,084 width=4) (actual time=0.274..0.274 rows=0 loops=1)

  • Index Cond: ((ci_builds.name = 'secret_detection'::text) AND (ci_builds.id IS NOT NULL))
  • Heap Fetches: 0
  • Buffers: shared read=3
  • I/O Timings: read=0.250