explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZjJj : with new index usage_activity_by_stage.secure.user_dast_jobs alternative batch

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 16.825 ↑ 1.0 1 1

Aggregate (cost=79.54..79.55 rows=1 width=8) (actual time=16.825..16.825 rows=1 loops=1)

  • Buffers: shared hit=36 read=11
  • I/O Timings: read=15.960
2. 16.767 16.767 ↑ 6.6 52 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at_parser_features_al on public.ci_builds (cost=0.56..78.69 rows=341 width=4) (actual time=6.157..16.767 rows=52 loops=1)

  • Index Cond: ((ci_builds.user_id >= 5,916,048) AND (ci_builds.user_id <= 5,926,048) AND (ci_builds.name = 'license_management'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=36 read=11
  • I/O Timings: read=15.960