explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JHYZ : witn new index usage_activity_by_stage.secure.user_dependency_scanning_jobs alternative batch

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 7.980 ↑ 1.0 1 1

Aggregate (cost=169.23..169.24 rows=1 width=8) (actual time=7.980..7.980 rows=1 loops=1)

  • Buffers: shared hit=135 read=2 dirtied=1
  • I/O Timings: read=6.820
2. 7.900 7.900 ↑ 7.2 216 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at_parser_features_al on public.ci_builds (cost=0.56..165.35 rows=1,551 width=4) (actual time=0.048..7.900 rows=216 loops=1)

  • Index Cond: ((ci_builds.user_id >= 4,916,048) AND (ci_builds.user_id <= 4,926,048) AND (ci_builds.name = 'dependency_scanning'::text))
  • Heap Fetches: 2
  • Buffers: shared hit=135 read=2 dirtied=1
  • I/O Timings: read=6.820