explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EPtY : with new index usage_activity_by_stage.secure.user_container_scanning_jobs

Settings
# exclusive inclusive rows x rows loops node
1. 0.493 119.063 ↑ 1.0 1 1

Aggregate (cost=326.29..326.30 rows=1 width=8) (actual time=119.062..119.063 rows=1 loops=1)

  • Buffers: shared hit=633 read=74
  • I/O Timings: read=106.413
2. 118.570 118.570 ↑ 2.1 1,031 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at_parser_features_al on public.ci_builds (cost=0.56..320.98 rows=2,124 width=4) (actual time=7.833..118.570 rows=1,031 loops=1)

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