explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nWRq

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.101 ↑ 1.0 1 1

Aggregate (cost=13.41..13.42 rows=1 width=6) (actual time=0.101..0.101 rows=1 loops=1)

2. 0.059 0.094 ↓ 15.0 15 1

Bitmap Heap Scan on cust_acct_pymnt_hstr custacctpy0_ (cost=9.38..13.40 rows=1 width=6) (actual time=0.067..0.094 rows=15 loops=1)

  • Recheck Cond: ((bill_acct_id = '76097561'::numeric) AND (cust_id = '22535762'::numeric))
  • Filter: ((cdate >= '2020-01-01 00:00:00-05'::timestamp with time zone) AND (cdate <= '2020-12-31 23:59:59.999-05'::timestamp with time zone) AND ((store_type)::text = 'PAYMENT'::text))
  • Rows Removed by Filter: 13
  • Heap Blocks: exact=27
3. 0.003 0.035 ↓ 0.0 0 1

BitmapAnd (cost=9.38..9.38 rows=1 width=0) (actual time=0.035..0.035 rows=0 loops=1)

4. 0.018 0.018 ↓ 1.9 28 1

Bitmap Index Scan on idx_caph_bill_acct_id (cost=0.00..4.54 rows=15 width=0) (actual time=0.018..0.018 rows=28 loops=1)

  • Index Cond: (bill_acct_id = '76097561'::numeric)
5. 0.014 0.014 ↓ 1.4 30 1

Bitmap Index Scan on idx_acct_pymnt_hstr_cust_id (cost=0.00..4.59 rows=21 width=0) (actual time=0.014..0.014 rows=30 loops=1)

  • Index Cond: (cust_id = '22535762'::numeric)
Planning time : 0.159 ms
Execution time : 0.134 ms