explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TQ9V

Settings
# exclusive inclusive rows x rows loops node
1. 0.277 0.672 ↓ 7.0 7 1

HashAggregate (cost=39.53..39.53 rows=1 width=8) (actual time=0.661..0.672 rows=7 loops=1)

2. 0.395 0.395 ↑ 13.2 99 1

Index Scan using test_pkey on test (cost=0.00..32.97 rows=1,311 width=8) (actual time=0.050..0.395 rows=99 loops=1)

  • Index Cond: ((id > $1) AND (id < $2))