explain.depesz.com

A tool for finding a real cause for slow queries.

Result: S9G

options
# exclusive inclusive rows x rows loops node
1. 1.451 6.050 ↓ 2.8 79 1
→

GroupAggregate (cost=474.79..480.04 rows=28 width=34) (actual time=4.475..6.050 rows=79 loops=1)

  • Output: grup_banc, count(DISTINCT cod_abi)
  • Buffers: shared hit=389
2. 2.095 4.599 ↑ 1.9 352 1
→

Sort (cost=474.79..476.45 rows=663 width=34) (actual time=4.433..4.599 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. 2.504 2.504 ↑ 1.9 352 1
→

Seq Scan on public.tbl_ajax_ricerca (cost=0.00..443.72 rows=663 width=34) (actual time=0.020..2.504 rows=352 loops=1)

  • Output: grup_banc, cod_abi
  • Filter: (((tbl_ajax_ricerca.grup_banc)::text <> ''::text) AND (tbl_ajax_ricerca.ricerca_testuale ~~ '%mi%'::text) AND (tbl_ajax_ricerca.data_type = ANY ('{1,2,3,4}'::integer[])))
  • Buffers: shared hit=389