explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zyUU : after index

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 9.800 ↑ 1.0 1 1

Aggregate (cost=5,403.84..5,403.85 rows=1 width=8) (actual time=9.800..9.800 rows=1 loops=1)

  • Buffers: shared hit=3 read=5
  • I/O Timings: read=9.648
2. 9.790 9.790 ↑ 513.6 5 1

Index Scan using index_ci_builds_on_name_for_security_reports_values on public.ci_builds (cost=0.43..5,397.42 rows=2,568 width=0) (actual time=2.975..9.790 rows=5 loops=1)

  • Index Cond: ((ci_builds.name)::text = 'license_scanning'::text)
  • Filter: ((ci_builds.type)::text = 'Ci::Build'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3 read=5
  • I/O Timings: read=9.648