explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J22S

Settings
# exclusive inclusive rows x rows loops node
1. 195.749 1,653.333 ↑ 1.0 1 1

Aggregate (cost=102,751.64..102,751.65 rows=1 width=8) (actual time=1,653.333..1,653.333 rows=1 loops=1)

  • Buffers: shared hit=1623419 read=36584 dirtied=8806
  • I/O Timings: read=767.351
2. 1,457.584 1,457.584 ↓ 1.0 1,696,003 1

Index Only Scan using test_index on public.users (cost=0.43..98,558.89 rows=1,677,098 width=23) (actual time=0.200..1,457.584 rows=1,696,003 loops=1)

  • Heap Fetches: 141596
  • Buffers: shared hit=1623419 read=36584 dirtied=8806
  • I/O Timings: read=767.351