explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5aum

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.146 ↓ 1.2 17 1

Bitmap Heap Scan on billing_account (cost=70.19..120.96 rows=14 width=8) (actual time=0.140..0.146 rows=17 loops=1)

  • Recheck Cond: ((customer_id = 1) AND (account_group = 'CUSTOMER_PREPAID_FUNDS'::accountgroupenum))
  • Heap Blocks: exact=7
2. 0.009 0.133 ↓ 0.0 0 1

BitmapAnd (cost=70.19..70.19 rows=14 width=0) (actual time=0.132..0.133 rows=0 loops=1)

3. 0.019 0.019 ↓ 1.1 220 1

Bitmap Index Scan on billing_account_customer_id_idx (cost=0.00..5.86 rows=209 width=0) (actual time=0.019..0.019 rows=220 loops=1)

  • Index Cond: (customer_id = 1)
4. 0.105 0.105 ↑ 1.0 3,128 1

Bitmap Index Scan on billing_account_account_group_idx (cost=0.00..64.07 rows=3,171 width=0) (actual time=0.105..0.105 rows=3,128 loops=1)

  • Index Cond: (account_group = 'CUSTOMER_PREPAID_FUNDS'::accountgroupenum)
Planning time : 0.064 ms
Execution time : 0.172 ms