explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y777

Settings
# exclusive inclusive rows x rows loops node
1. 0.650 5,931.815 ↑ 1.0 1 1

Aggregate (cost=23,257.67..23,257.68 rows=1 width=8) (actual time=5,931.815..5,931.815 rows=1 loops=1)

2. 26.968 5,931.165 ↑ 104.9 1,385 1

Unique (cost=0.57..21,442.08 rows=145,247 width=4) (actual time=2.725..5,931.165 rows=1,385 loops=1)

3. 5,904.197 5,904.197 ↓ 1.1 338,975 1

Index Only Scan using index_notes_on_author_id on notes (cost=0.57..20,663.58 rows=311,400 width=4) (actual time=2.723..5,904.197 rows=338,975 loops=1)

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