explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zUf8

Settings
# exclusive inclusive rows x rows loops node
1. 2.141 32,274.752 ↑ 1.0 1 1

Aggregate (cost=16,471.24..16,471.25 rows=1 width=8) (actual time=32,274.752..32,274.752 rows=1 loops=1)

  • Buffers: shared hit=59 read=11,712 dirtied=41
  • I/O Timings: read=32,126.584
2. 32,272.611 32,272.611 ↑ 2.1 1,031 1

Index Scan using index_secure_ci_builds_on_user_id_created_at_parser_features on public.ci_builds (cost=0.43..16,465.94 rows=2,123 width=4) (actual time=1,010.397..32,272.611 rows=1,031 loops=1)

  • Index Cond: ((ci_builds.user_id >= 3,916,048) AND (ci_builds.user_id <= 3,926,048))
  • Filter: ((ci_builds.name)::text = 'container_scanning'::text)
  • Rows Removed by Filter: 10,828
  • Buffers: shared hit=59 read=11,712 dirtied=41
  • I/O Timings: read=32,126.584