explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vwo

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.152 ↓ 1.1 17 1

Bitmap Heap Scan on billing_account (cost=77.62..135.62 rows=16 width=8) (actual time=0.146..0.152 rows=17 loops=1)

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

BitmapAnd (cost=77.62..77.62 rows=16 width=0) (actual time=0.137..0.137 rows=0 loops=1)

3. 0.020 0.020 ↑ 1.1 220 1

Bitmap Index Scan on billing_account_customer_id_idx (cost=0.00..6.08 rows=238 width=0) (actual time=0.020..0.020 rows=220 loops=1)

  • Index Cond: (customer_id = 1)
4. 0.108 0.108 ↑ 1.2 3,128 1

Bitmap Index Scan on billing_account_account_group_idx (cost=0.00..71.28 rows=3,599 width=0) (actual time=0.108..0.108 rows=3,128 loops=1)

  • Index Cond: (account_group = 'CUSTOMER_PREPAID_FUNDS'::accountgroupenum)
Planning time : 0.075 ms
Execution time : 0.182 ms