explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dwgy

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,187.740 49,339.893 ↑ 1.0 1 1

Aggregate (cost=2,610,059.42..2,610,059.43 rows=1 width=12) (actual time=49,339.893..49,339.893 rows=1 loops=1)

  • Output: sum((debet - credit))
2. 47,757.462 48,152.153 ↓ 1.0 2,358,373 1

Bitmap Heap Scan on gl_transdetail (cost=48,548.84..2,604,181.26 rows=2,351,261 width=12) (actual time=572.054..48,152.153 rows=2,358,373 loops=1)

  • Output: gltdid, gltid, coaid, debet, credit, detailnote, modify_id, modify_time, create_id, create_time, bprid, trans_date, regpid, other_id, dccid, reff_id, subid, debet_curr, credit_curr, curr_rate, is_fast_update, cf_group_id, vol, kode_brg, kod (...)
  • Recheck Cond: (coaid = 4308)
  • Filter: (date(trans_date) <= date(now()))
3. 394.691 394.691 ↓ 1.0 2,358,373 1

Bitmap Index Scan on gl_transdetail_coaid (cost=0.00..47,961.02 rows=2,351,478 width=0) (actual time=394.691..394.691 rows=2,358,373 loops=1)

  • Index Cond: (coaid = 4308)