explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ddo

options
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