explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Bzc

Settings
# exclusive inclusive rows x rows loops node
1. 2.410 2.410 ↓ 9.7 1,689 1

Index Scan using test_towar_idx on test_towar (cost=0.43..8.45 rows=175 width=33) (actual time=0.053..2.410 rows=1,689 loops=1)

  • Index Cond: (((symbol)::text ~>=~ 'A-'::text) AND ((symbol)::text ~<~ 'A.'::text))
  • Filter: ((symbol)::text ~~ 'A-%'::text)