explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TJue : Secret Detection

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

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

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

Initplan (for Result)

3. 0.000 3.813 ↓ 0.0 0 1

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

  • Buffers: shared read=3
  • I/O Timings: read=3.729
4. 3.813 3.813 ↓ 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=3.813..3.813 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=3.729