explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Wsy : current usage_activity_by_stage.secure.user_container_scanning_jobs alternative batch

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.239 ↑ 1.0 1 1

Aggregate (cost=205.56..205.57 rows=1 width=8) (actual time=0.238..0.239 rows=1 loops=1)

  • Buffers: shared hit=43
2. 0.219 0.219 ↑ 1.4 19 1

Index Scan using index_secure_ci_builds_on_user_id_created_at_parser_features on public.ci_builds (cost=0.43..205.50 rows=26 width=4) (actual time=0.040..0.219 rows=19 loops=1)

  • Index Cond: ((ci_builds.user_id >= 6,916,048) AND (ci_builds.user_id <= 6,926,048))
  • Filter: ((ci_builds.name)::text = 'container_scanning'::text)
  • Rows Removed by Filter: 20
  • Buffers: shared hit=43