explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KvOO

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 16.848 ↑ 1.0 1 1

Aggregate (cost=149.62..149.63 rows=1 width=8) (actual time=16.847..16.848 rows=1 loops=1)

  • Buffers: shared hit=82 read=11 dirtied=1
  • I/O Timings: read=15.438
2. 16.772 16.772 ↑ 7.6 128 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at_parser_features_al on public.ci_builds (cost=0.56..147.18 rows=976 width=4) (actual time=3.118..16.772 rows=128 loops=1)

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