explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ot9C : current usage_activity_by_stage.secure.user_dependency_scanning_jobs query

Settings
# exclusive inclusive rows x rows loops node
1. 0.107 267.205 ↑ 1.0 1 1

Aggregate (cost=205.60..205.61 rows=1 width=8) (actual time=267.205..267.205 rows=1 loops=1)

  • Buffers: shared hit=27 read=159 dirtied=50
  • I/O Timings: read=252.478
2. 267.098 267.098 ↓ 0.0 0 1

Index Scan using index_secure_ci_builds_on_user_id_created_at_parser_features on public.ci_builds (cost=0.43..205.50 rows=42 width=4) (actual time=267.098..267.098 rows=0 loops=1)

  • Index Cond: ((ci_builds.user_id >= 6,916,048) AND (ci_builds.user_id <= 6,926,048))
  • Filter: ((ci_builds.name)::text = 'dependency_scanning'::text)
  • Rows Removed by Filter: 39
  • Buffers: shared hit=18 read=159 dirtied=50