explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U3op

Settings
# exclusive inclusive rows x rows loops node
1. 10,438.072 39,474.762 ↑ 1.0 1 1

Aggregate (cost=109,654.08..109,654.09 rows=1 width=6) (actual time=39,474.761..39,474.762 rows=1 loops=1)

2. 17,655.255 29,036.690 ↓ 15.0 41,919,960 1

Nested Loop (cost=9.81..102,667.57 rows=2,794,603 width=6) (actual time=0.168..29,036.690 rows=41,919,960 loops=1)

3. 0.140 0.230 ↓ 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.127..0.230 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.005 0.090 ↓ 0.0 0 1

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

5. 0.051 0.051 ↓ 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.051..0.051 rows=28 loops=1)

  • Index Cond: (bill_acct_id = '76097561'::numeric)
6. 0.034 0.034 ↓ 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.034..0.034 rows=30 loops=1)

  • Index Cond: (cust_id = '22535762'::numeric)
7. 11,381.205 11,381.205 ↓ 1.0 2,794,664 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.009..758.747 rows=2,794,664 loops=15)

  • Heap Fetches: 85,980
Planning time : 0.777 ms
Execution time : 39,474.814 ms