explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T1a8

Settings
# exclusive inclusive rows x rows loops node
1. 24.568 9,302.098 ↑ 1.0 1 1

Aggregate (cost=10,428.01..10,428.02 rows=1 width=8) (actual time=9,302.098..9,302.098 rows=1 loops=1)

  • Buffers: shared hit=42,196 read=4,582 dirtied=1,419
  • I/O Timings: read=9,169.890
2. 9,277.530 9,277.530 ↑ 1.2 102,233 1

Index Only Scan using new_index_on_diff_notes on public.notes (cost=0.56..10,109.95 rows=127,225 width=4) (actual time=6.643..9,277.530 rows=102,233 loops=1)

  • Index Cond: ((notes.author_id >= 1) AND (notes.author_id <= 10,000))
  • Heap Fetches: 4,324
  • Buffers: shared hit=42,187 read=4,582 dirtied=1,419
  • I/O Timings: read=9,169.890