Result: Ddo

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
10.636	16.764	↓ 1.0	38180	1	→ Bitmap Heap Scan on tconaccessright2 security (cost=1617.84..6369.12 rows=37219 width=4) (actual time=6.778..16.764 rows=38180 loops=1) Recheck Cond: ((coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar) AND (coa_bread = 1)) Buffers: shared hit=4357
6.128	6.128	↓ 1.0	38180	1	→ Bitmap Index Scan on idx_coa_t1 (cost=0.00..1608.53 rows=37219 width=0) (actual time=6.128..6.128 rows=38180 loops=1) Index Cond: ((coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar) AND (coa_bread = 1)) Buffers: shared hit=316

"Bitmap Heap Scan on tconaccessright2 security  (cost=1617.84..6369.12 rows=37219 width=4) (actual time=6.778..16.764 rows=38180 loops=1)"
"  Recheck Cond: ((coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar) AND (coa_bread = 1))"
"  Buffers: shared hit=4357"
"  ->  Bitmap Index Scan on idx_coa_t1  (cost=0.00..1608.53 rows=37219 width=0) (actual time=6.128..6.128 rows=38180 loops=1)"
"        Index Cond: ((coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar) AND (coa_bread = 1))"
"        Buffers: shared hit=316"
"Total runtime: 19.113 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	10.636 ms	63.4 %
Bitmap Index Scan	1	6.128 ms	36.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tconaccessright2	1	10.636 ms	63.4 %
Bitmap Heap Scan	1	10.636 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ddo

Colorize:

Columns visibility:

Per node type stats

Per table stats