explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 9z4

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 141.919 258.889 ↓ 199.8 164048 1

Sort (cost=8707.66..8709.71 rows=821 width=1567) (actual time=224.386..258.889 rows=164048 loops=1)

  • Sort Key: z01_numcgm
2. 116.970 116.970 ↓ 199.8 164048 1

Seq Scan on cgm (cost=0.00..8667.92 rows=821 width=1567) (actual time=6.366..116.970 rows=164048 loops=1)

  • Filter: (((substr((z01_nome)::text, 1, 1))::text >= 'A'::text) AND ((substr((z01_nome)::text, 1, 1))::text <= 'Z'::text))