explain.depesz.com

A tool for finding a real cause for slow queries.

Result: sKc

options
# exclusive inclusive rows x rows loops node
1. 1.104 26.783 ↓ 1.5 484 1
→

HashAggregate (cost=106.08..109.32 rows=324 width=34) (actual time=26.490..26.783 rows=484 loops=1)

  • Output: ragione_sociale
  • Buffers: shared hit=24
2. 25.679 25.679 ↓ 1.5 485 1
→

Seq Scan on public.tbl_ajax_chi (cost=0.00..105.27 rows=324 width=34) (actual time=0.157..25.679 rows=485 loops=1)

  • Output: ragione_sociale
  • Filter: (((tbl_ajax_chi.data_type = 1) OR (tbl_ajax_chi.data_type = 2) OR (tbl_ajax_chi.data_type = 3) OR (tbl_ajax_chi.data_type = 4)) AND (((tbl_ajax_chi.cod_abi_ricerca)::text ~~* 'a%'::text) OR ((tbl_ajax_chi.ragione_sociale)::text ~~* 'a%'::text) OR ((tbl_ajax_chi.nome_abbreviato)::text ~~* 'a%'::text) OR ((tbl_ajax_chi.cod_abi_ricerca)::text ~~* '% a%'::text) OR ((tbl_ajax_chi.ragione_sociale)::text ~~* '% a%'::text) OR ((tbl_ajax_chi.nome_abbreviato)::text ~~* '% a%'::text)))
  • Buffers: shared hit=24