explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ETv

options
# exclusive inclusive rows x rows loops node
1. 0.030 0.311 ↑ 1.0 30 1
→

Limit (cost=0.00..66.30 rows=30 width=34) (actual time=0.045..0.311 rows=30 loops=1)

  • Output: ragione_sociale
  • Buffers: shared hit=39
2. 0.061 0.281 ↑ 10.8 30 1
→

Unique (cost=0.00..715.99 rows=324 width=34) (actual time=0.043..0.281 rows=30 loops=1)

  • Output: ragione_sociale
  • Buffers: shared hit=39
3. 0.220 0.220 ↑ 10.8 30 1
→

Index Scan using idx_tblajaxchi_ragsoc on public.tbl_ajax_chi (cost=0.00..715.18 rows=324 width=34) (actual time=0.039..0.220 rows=30 loops=1)

  • Output: ragione_sociale
  • Filter: ((tbl_ajax_chi.data_type = ANY ('{1,2,3,4}'::integer[])) AND (((tbl_ajax_chi.cod_abi_ricerca)::text ~~* 'a%'::text) OR ((tbl_ajax_chi.ragione_sociale_low)::text ~~ 'a%'::text) OR ((tbl_ajax_chi.nome_abbreviato_low)::text ~~ 'a%'::text) OR ((tbl_ajax_chi.cod_abi_ricerca)::text ~~* '% a%'::text) OR ((tbl_ajax_chi.ragione_sociale_low)::text ~~ '% a%'::text) OR ((tbl_ajax_chi.nome_abbreviato_low)::text ~~ '% a%'::text)))
  • Buffers: shared hit=39