explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3x5F

Settings
# exclusive inclusive rows x rows loops node
1. 0.178 138.493 ↑ 1.0 1 1

Aggregate (cost=28,929.13..28,929.14 rows=1 width=8) (actual time=138.492..138.493 rows=1 loops=1)

2. 26.997 138.315 ↑ 105.5 1,480 1

Unique (cost=0.57..26,977.56 rows=156,125 width=4) (actual time=0.041..138.315 rows=1,480 loops=1)

3. 111.318 111.318 ↓ 1.1 446,699 1

Index Only Scan using index_notes_on_author_id on notes (cost=0.57..25,996.62 rows=392,377 width=4) (actual time=0.040..111.318 rows=446,699 loops=1)

  • Index Cond: ((author_id >= 170001) AND (author_id < 175001))
  • Heap Fetches: 10906
Planning time : 0.216 ms
Execution time : 138.533 ms