explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZVWO

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.254 ↑ 2.9 29 1

Unique (cost=0.43..97.28 rows=85 width=6) (actual time=0.031..0.254 rows=29 loops=1)

2. 0.233 0.233 ↓ 3.2 274 1

Index Only Scan using four on papa (cost=0.43..97.06 rows=86 width=6) (actual time=0.031..0.233 rows=274 loops=1)

  • Index Cond: (mike = 9,732)
  • Heap Fetches: 274
Planning time : 0.076 ms
Execution time : 0.271 ms