explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HJsY : a

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

HashAggregate (cost=39.530..39.530 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 yankee on victor (cost=0.000..32.970 rows=1,311 width=8) (actual time=0.050..0.395 rows=99 loops=1)

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