explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cY4R

Settings
# exclusive inclusive rows x rows loops node
1. 438.748 67,858.819 ↑ 1.0 1 1

Aggregate (cost=64,921.67..64,921.68 rows=1 width=8) (actual time=67,858.818..67,858.819 rows=1 loops=1)

  • Buffers: shared hit=321,423 read=37,675 dirtied=5,697
  • I/O Timings: read=65,346.853
2. 67,420.071 67,420.071 ↓ 1.1 1,382,833 1

Index Only Scan using index_ci_builds_on_user_id_and_created_at_and_type_eq_ci_build on public.ci_builds (cost=0.57..61,679.94 rows=1,296,694 width=4) (actual time=0.038..67,420.071 rows=1,382,833 loops=1)

  • Index Cond: ((ci_builds.user_id >= 0) AND (ci_builds.user_id <= 1,250))
  • Heap Fetches: 27,812
  • Buffers: shared hit=321,420 read=37,675 dirtied=5,697
  • I/O Timings: read=65,346.853