explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xS7u

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 13,970.843 ↓ 0.0 0 1

Update on ratedusage (cost=52.73..5,488.01 rows=1 width=2,723) (actual time=13,970.842..13,970.843 rows=0 loops=1)

2. 12,657.854 13,970.841 ↓ 0.0 0 1

Bitmap Heap Scan on ratedusage (cost=52.73..5,488.01 rows=1 width=2,723) (actual time=13,970.841..13,970.841 rows=0 loops=1)

  • Recheck Cond: (subscriptionnumber = '1000'::numeric)
  • Filter: ((usagestatus = 'A'::bpchar) AND (usagedatetime < CURRENT_DATE))
  • Rows Removed by Filter: 1795
  • Heap Blocks: exact=1813
3. 1,312.987 1,312.987 ↓ 2.0 3,590 1

Bitmap Index Scan on xif5ratedusage (cost=0.00..52.73 rows=1,830 width=0) (actual time=1,312.987..1,312.987 rows=3,590 loops=1)

  • Index Cond: (subscriptionnumber = '1000'::numeric)
Planning time : 0.268 ms
Execution time : 13,971.040 ms