explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3bDo

Settings
# exclusive inclusive rows x rows loops node
1. 1.254 43,938.576 ↑ 184.0 3 1

GroupAggregate (cost=5,544.74..5,582.04 rows=552 width=389) (actual time=43,937.635..43,938.576 rows=3 loops=1)

  • Group Key: subscriptionnumber, servicecode
2. 3.018 43,937.322 ↓ 3.4 1,881 1

Sort (cost=5,544.74..5,546.12 rows=553 width=93) (actual time=43,937.227..43,937.322 rows=1,881 loops=1)

  • Sort Key: servicecode
  • Sort Method: quicksort Memory: 313kB
3. 43,817.153 43,934.304 ↓ 3.4 1,881 1

Bitmap Heap Scan on ratedusage cd (cost=52.93..5,519.55 rows=553 width=93) (actual time=177.052..43,934.304 rows=1,881 loops=1)

  • Recheck Cond: (subscriptionnumber = '20062'::numeric)
  • Filter: ((usagestatus = '3'::bpchar) AND (date(usagedatetime) < CURRENT_DATE))
  • Heap Blocks: exact=1881
4. 117.151 117.151 ↓ 1.0 1,881 1

Bitmap Index Scan on xif5ratedusage (cost=0.00..52.79 rows=1,839 width=0) (actual time=117.150..117.151 rows=1,881 loops=1)

  • Index Cond: (subscriptionnumber = '20062'::numeric)