explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5JLb

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.131 ↓ 1.1 17 1

Bitmap Heap Scan on billing_account (cost=59.68..112.89 rows=15 width=8) (actual time=0.126..0.131 rows=17 loops=1)

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

BitmapAnd (cost=59.68..59.68 rows=15 width=0) (actual time=0.118..0.118 rows=0 loops=1)

3. 0.022 0.022 ↓ 1.1 220 1

Bitmap Index Scan on billing_account_customer_id_idx (cost=0.00..5.83 rows=206 width=0) (actual time=0.022..0.022 rows=220 loops=1)

  • Index Cond: (customer_id = 1)
4. 0.089 0.089 ↑ 1.0 2,822 1

Bitmap Index Scan on billing_account_account_group_idx (cost=0.00..53.59 rows=2,840 width=0) (actual time=0.089..0.089 rows=2,822 loops=1)

  • Index Cond: (account_group = 'CUSTOMER_PREPAID_FUNDS'::accountgroupenum)
Planning time : 0.072 ms
Execution time : 0.160 ms