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 164,048 1

Sort (cost=8,707.66..8,709.71 rows=821 width=1,567) (actual time=224.386..258.889 rows=164,048 loops=1)

  • Sort Key: z01_numcgm
2. 116.970 116.970 ↓ 199.8 164,048 1

Seq Scan on cgm (cost=0.00..8,667.92 rows=821 width=1,567) (actual time=6.366..116.970 rows=164,048 loops=1)

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