explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LGWQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2,016.189 ↑ 1.0 1 1

Aggregate (cost=53,176.76..53,176.77 rows=1 width=8) (actual time=2,016.189..2,016.189 rows=1 loops=1)

  • Buffers: shared hit=45589 read=23710 written=2924
  • I/O Timings: read=1229.912 write=477.334
2. 2,016.181 2,016.181 ↓ 0.0 0 1

Index Scan using ci_builds_pkey on public.ci_builds (cost=0.57..53,176.76 rows=1 width=4) (actual time=2,016.181..2,016.181 rows=0 loops=1)

  • Index Cond: ((ci_builds.id >= 0) AND (ci_builds.id <= 99999))
  • Filter: (((ci_builds.type)::text = 'Ci::Build'::text) AND ((ci_builds.name)::text = 'container_scanning_jobs'::text))
  • Rows Removed by Filter: 73975
  • Buffers: shared hit=45589 read=23710 written=2924
  • I/O Timings: read=1229.912 write=477.334