explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2KD5

Settings
# exclusive inclusive rows x rows loops node
1. 10,988.841 41,520.318 ↑ 1.0 1 1

Aggregate (cost=109,654.08..109,654.09 rows=1 width=6) (actual time=41,520.317..41,520.318 rows=1 loops=1)

2. 18,634.241 30,531.477 ↓ 15.0 41,920,080 1

Nested Loop (cost=9.81..102,667.57 rows=2,794,603 width=6) (actual time=0.081..30,531.477 rows=41,920,080 loops=1)

3. 0.131 0.166 ↓ 15.0 15 1

Bitmap Heap Scan on cust_acct_pymnt_hstr custacctpy0_ (cost=9.38..13.40 rows=1 width=0) (actual time=0.066..0.166 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
4. 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)

5. 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)
6. 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)
7. 11,897.070 11,897.070 ↓ 1.0 2,794,672 15

Index Only Scan using cust_acct_pymnt_hstr_pk on cust_acct_pymnt_hstr custacctpy1_ (cost=0.43..74,708.14 rows=2,794,603 width=6) (actual time=0.008..793.138 rows=2,794,672 loops=15)

  • Heap Fetches: 90,494
Planning time : 0.190 ms
Execution time : 41,520.358 ms