explain.depesz.com

A tool for finding a real cause for slow queries.

Result: xWs

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.109 1.337 ↓ 5.0 15 1

HashAggregate (cost=82.56..82.59 rows=3 width=29) (actual time=1.329..1.337 rows=15 loops=1)

  • Output: grup_banc
  • Buffers: shared hit=36
2. 1.228 1.228 ↓ 1.4 65 1

Seq Scan on public.tbl_ajax_gruppo (cost=0.00..82.44 rows=47 width=29) (actual time=0.057..1.228 rows=65 loops=1)

  • Output: grup_banc
  • Filter: ((((tbl_ajax_gruppo.grup_banc_low)::text ~~ 'ca%'::text) OR ((tbl_ajax_gruppo.grup_banc_low)::text ~~ '% ca%'::text)) AND (tbl_ajax_gruppo.data_type = ANY ('{1,2,3,4}'::integer[])))
  • Buffers: shared hit=36