explain.depesz.com

A tool for finding a real cause for slow queries.

Result: pQg

options
# exclusive inclusive rows x rows loops node
1. 0.011 9.857 ↑ 1.0 10 1
→

Limit (cost=473.30..473.45 rows=10 width=70) (actual time=9.828..9.857 rows=10 loops=1)

  • Output: cod_abi, tipo, grup_banc, ragione_sociale
  • Buffers: shared hit=389
2. 0.020 9.846 ↑ 6.2 10 1
→

Group (cost=473.30..474.20 rows=62 width=70) (actual time=9.825..9.846 rows=10 loops=1)

  • Output: cod_abi, tipo, grup_banc, ragione_sociale
  • Buffers: shared hit=389
3. 1.357 9.826 ↑ 6.5 11 1
→

Sort (cost=473.30..473.48 rows=72 width=70) (actual time=9.821..9.826 rows=11 loops=1)

  • Output: cod_abi, tipo, grup_banc, ragione_sociale
  • Sort Key: "Bank".tipo, "Bank".ragione_sociale, "Bank".cod_abi, "Bank".grup_banc
  • Sort Method: quicksort Memory: 31kB
  • Buffers: shared hit=389
4. 8.469 8.469 ↓ 1.8 130 1
→

Seq Scan on public.tbl_ajax_ricerca "Bank" (cost=0.00..471.08 rows=72 width=70) (actual time=0.125..8.469 rows=130 loops=1)

  • Output: cod_abi, tipo, grup_banc, ragione_sociale
  • Filter: ((("Bank".regione)::text ~~* 'EMILIA - ROMAGNA'::text) AND (("Bank".tipo = '1'::text) OR ("Bank".tipo = '2'::text) OR ("Bank".tipo = '3'::text)) AND (("Bank".data_type = 1) OR ("Bank".data_type = 2) OR ("Bank".data_type = 3) OR ("Bank".data_type = 4)))
  • Buffers: shared hit=389