explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FtlE : with new index usage_activity_by_stage.secure.user_dast_jobs

Settings
# exclusive inclusive rows x rows loops node
1. 1.007 16.643 ↑ 1.0 1 1

Aggregate (cost=283.46..283.47 rows=1 width=8) (actual time=16.642..16.643 rows=1 loops=1)

  • Buffers: shared hit=1,818
2. 15.636 15.636 ↓ 3.5 2,860 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at_parser_features_al on public.ci_builds (cost=0.56..281.39 rows=828 width=4) (actual time=0.169..15.636 rows=2,860 loops=1)

  • Index Cond: ((ci_builds.user_id >= 3,916,048) AND (ci_builds.user_id <= 3,926,048) AND (ci_builds.name = 'dast'::text))
  • Heap Fetches: 20
  • Buffers: shared hit=1,818