#	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

"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"
"  ->  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"
"Total runtime: 1.432 ms"

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	0.109 ms	8.2 %
Seq Scan	1	1.228 ms	91.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.tbl_ajax_gruppo	1	1.228 ms	91.8 %
Seq Scan	1	1.228 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: xWs

Colorize:

Columns visibility:

Per node type stats

Per table stats