explain analyze select * from bar where a ~ '^MARIA DAS.*GRACAS' LIMIT 10;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..22.86 rows=1 width=62) (actual time=115.751..468760.019
rows=10 loops=1)
-> Index Scan using bari on bar (cost=0.00..22.86 rows=1 width=62)
(actual time=115.739..468759.911 rows=10 loops=1)
Index Cond: (((a)::text ~>=~ 'MARIA DAS'::character varying) AND
((a)::text ~<~ 'MARIA DAT'::character varying))
Filter: ((a)::text ~ '^MARIA DAS.*GRACAS'::text)
Total runtime: 468760.159 ms
(5 rows)
Euler Taveira de Oliveira-2 wrote:
>
> mateusgra escreveu:
>> Se tiver 70 mil variações de Euler Taveira demora bastante para lista
>> os
>> 10 primeiros.
>>
> Qual o EXPLAIN ANALYZE da consulta?
>
>
> --
> Euler Taveira de Oliveira
> http://www.timbira.com/
> _______________________________________________
> pgbr-geral mailing list
> pgbr-geral@listas.postgresql.org.br
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
>
--
View this message in context:
http://www.nabble.com/TSearch-palavar-Inicial-tp24035502p24074455.html
Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
