explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MUi1

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 3,076.874 ↑ 1.0 1 1

Aggregate (cost=2,843.12..2,843.13 rows=1 width=8) (actual time=3,076.873..3,076.874 rows=1 loops=1)

  • Buffers: shared hit=4 read=999 dirtied=7
  • I/O Timings: read=3,061.404
2. 3,076.851 3,076.851 ↓ 0.0 0 1

Index Scan using ci_builds_user_id_created_at_idx on public.ci_builds (cost=0.43..2,842.44 rows=271 width=4) (actual time=3,076.851..3,076.851 rows=0 loops=1)

  • Index Cond: ((ci_builds.user_id >= 10,002) AND (ci_builds.user_id <= 20,001) AND (ci_builds.created_at >= '2020-05-26 05:25:26.510804'::timestamp without time zone) AND (ci_builds.created_at <= '2020-06-23 05:25:26.510907'::timestamp without time zone))
  • Filter: ((ci_builds.name)::text = 'container_scanning'::text)
  • Rows Removed by Filter: 903
  • Buffers: shared hit=4 read=999 dirtied=7
  • I/O Timings: read=3,061.404