explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BeeB

Settings
# exclusive inclusive rows x rows loops node
1. 6.560 58.964 ↑ 1.0 1 1

Aggregate (cost=1,567.79..1,567.80 rows=1 width=8) (actual time=58.963..58.964 rows=1 loops=1)

  • Buffers: shared hit=12,180 read=109
  • I/O Timings: read=29.195
2. 52.404 52.404 ↑ 1.2 28,676 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at on public.ci_builds (cost=0.43..1,483.79 rows=33,599 width=4) (actual time=0.060..52.404 rows=28,676 loops=1)

  • Index Cond: ((ci_builds.user_id >= 0) AND (ci_builds.user_id <= 9,999))
  • Heap Fetches: 119
  • Buffers: shared hit=12,177 read=109
  • I/O Timings: read=29.195