explain.depesz.com

A tool for finding a real cause for slow queries.

Result: xHux

options
# exclusive inclusive rows x rows loops node
1. 2.259 34.286 ↓ 1.6 79 1
→

GroupAggregate (cost=586.82..596.28 rows=50 width=34) (actual time=31.858..34.286 rows=79 loops=1)

  • Output: grup_banc, count(DISTINCT cod_abi)
  • Buffers: shared hit=389
2. 3.202 32.027 ↑ 3.4 352 1
→

Sort (cost=586.82..589.81 rows=1194 width=34) (actual time=31.782..32.027 rows=352 loops=1)

  • Output: grup_banc, cod_abi
  • Sort Key: tbl_ajax_ricerca.grup_banc
  • Sort Method: quicksort Memory: 44kB
  • Buffers: shared hit=389
3. 28.825 28.825 ↑ 3.4 352 1
→

Seq Scan on public.tbl_ajax_ricerca (cost=0.00..525.80 rows=1194 width=34) (actual time=0.032..28.825 rows=352 loops=1)

  • Output: grup_banc, cod_abi
  • Filter: (((tbl_ajax_ricerca.grup_banc)::text <> ''::text) AND ((tbl_ajax_ricerca.tipo = '1'::text) OR (tbl_ajax_ricerca.tipo = '2'::text) OR (tbl_ajax_ricerca.tipo = '3'::text)) AND ((tbl_ajax_ricerca.data_type = 1) OR (tbl_ajax_ricerca.data_type = 2) OR (tbl_ajax_ricerca.data_type = 3) OR (tbl_ajax_ricerca.data_type = 4)) AND (((tbl_ajax_ricerca.descr_comune)::text ~~* '%mi%'::text) OR ((tbl_ajax_ricerca.descr_comune_de)::text ~~* '%mi%'::text) OR ((tbl_ajax_ricerca.frazione_sp)::text ~~* '%mi%'::text) OR ((tbl_ajax_ricerca.regione)::text ~~* '%mi%'::text) OR ((tbl_ajax_ricerca.descr_prov)::text ~~* '%mi%'::text) OR ((tbl_ajax_ricerca.indirizzo_sp)::text ~~* '%mi%'::text) OR ((tbl_ajax_ricerca.indirizzo_sp_de)::text ~~* '%mi%'::text) OR ((tbl_ajax_ricerca.cap_comune)::text ~~* '%mi%'::text)))
  • Buffers: shared hit=389