explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uZ5L

Settings
# exclusive inclusive rows x rows loops node
1. 0.206 258.515 ↑ 1.0 1 1

Aggregate (cost=23,265.94..23,265.95 rows=1 width=8) (actual time=258.515..258.515 rows=1 loops=1)

2. 21.696 258.309 ↑ 104.9 1,385 1

Unique (cost=0.57..21,450.34 rows=145,248 width=4) (actual time=0.112..258.309 rows=1,385 loops=1)

3. 236.613 236.613 ↓ 1.1 338,975 1

Index Only Scan using index_notes_on_author_id on notes (cost=0.57..20,671.82 rows=311,407 width=4) (actual time=0.111..236.613 rows=338,975 loops=1)

  • Index Cond: ((author_id >= 270001) AND (author_id < 275001))
  • Heap Fetches: 6877