explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E4kW : select with index

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.083 ↑ 2.0 5 1

Limit (cost=0.43..21.45 rows=10 width=1,540) (actual time=0.060..0.083 rows=5 loops=1)

  • Buffers: shared hit=8
2. 0.080 0.080 ↑ 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=1,540) (actual time=0.059..0.080 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=8