explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lmly

Settings
# exclusive inclusive rows x rows loops node
1. 1,037,319.565 1,037,319.565 ↓ 1.1 1,186,919 1

Index Scan using index_ci_builds_on_name_for_security_products_values on public.ci_builds (cost=0.43..2,318,111.57 rows=1,113,626 width=1,540) (actual time=0.217..1,037,319.565 rows=1,186,919 loops=1)

  • Index Cond: ((ci_builds.name)::text = 'sast'::text)
  • Filter: ((ci_builds.type)::text = 'Ci::Build'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=18883 read=1150493 dirtied=1860
  • I/O Timings: read=1024411.363