explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AMQS

Settings
# exclusive inclusive rows x rows loops node
1. 10,200.148 38,823.485 ↑ 1.0 1 1

Aggregate (cost=109,654.08..109,654.09 rows=1 width=6) (actual time=38,823.485..38,823.485 rows=1 loops=1)

2. 17,458.754 28,623.337 ↓ 15.0 41,920,035 1

Nested Loop (cost=9.81..102,667.57 rows=2,794,603 width=6) (actual time=0.080..28,623.337 rows=41,920,035 loops=1)

3. 0.138 0.173 ↓ 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.067..0.173 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,164.410 11,164.410 ↓ 1.0 2,794,669 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..744.294 rows=2,794,669 loops=15)

  • Heap Fetches: 88,969
Planning time : 0.161 ms
Execution time : 38,823.527 ms