explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Lq4 : with new index usage_activity_by_stage.secure.user_container_scanning_jobs alternative batch

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 1.176 ↑ 1.0 1 1

Aggregate (cost=5.68..5.69 rows=1 width=8) (actual time=1.175..1.176 rows=1 loops=1)

  • Buffers: shared hit=22 read=3
  • I/O Timings: read=0.278
2. 1.148 1.148 ↑ 1.4 19 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at_parser_features_al on public.ci_builds (cost=0.56..5.62 rows=26 width=4) (actual time=0.486..1.148 rows=19 loops=1)

  • Index Cond: ((ci_builds.user_id >= 6,916,048) AND (ci_builds.user_id <= 6,926,048) AND (ci_builds.name = 'container_scanning'::text))
  • Heap Fetches: 19
  • Buffers: shared hit=22 read=3
  • I/O Timings: read=0.278