explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nHrH : current usage_activity_by_stage.secure.user_license_management_jobs

Settings
# exclusive inclusive rows x rows loops node
1. 0.195 70.727 ↑ 1.0 1 1

Aggregate (cost=16,469.20..16,469.21 rows=1 width=8) (actual time=70.726..70.727 rows=1 loops=1)

  • Buffers: shared hit=11,749
2. 70.532 70.532 ↑ 3.3 391 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=1,305 width=4) (actual time=2.073..70.532 rows=391 loops=1)

  • Index Cond: ((ci_builds.user_id >= 3,916,048) AND (ci_builds.user_id <= 3,926,048))
  • Filter: ((ci_builds.name)::text = 'license_management'::text)
  • Rows Removed by Filter: 11,468
  • Buffers: shared hit=11,749