explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K0fE

Settings
# exclusive inclusive rows x rows loops node
1. 29.240 7,134.048 ↑ 1.0 1 1

Aggregate (cost=11,347.24..11,347.25 rows=1 width=8) (actual time=7,134.047..7,134.048 rows=1 loops=1)

  • Buffers: shared hit=42,914 read=4,461
  • I/O Timings: read=6,968.633
2. 7,104.808 7,104.808 ↑ 1.2 102,261 1

Index Only Scan using new_index_on_diff_notes on public.notes (cost=0.56..11,028.96 rows=127,311 width=4) (actual time=0.465..7,104.808 rows=102,261 loops=1)

  • Index Cond: ((notes.author_id >= 0) AND (notes.author_id <= 9,999))
  • Heap Fetches: 5,147
  • Buffers: shared hit=42,905 read=4,461
  • I/O Timings: read=6,968.633