explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3t5f

Settings
# exclusive inclusive rows x rows loops node
1. 382.302 205,126.214 ↓ 2.3 7,188 1

GroupAggregate (cost=7,776.40..9,889.50 rows=3,120 width=150) (actual time=1,332.279..205,126.214 rows=7,188 loops=1)

  • Group Key: hdr.t8071_cai_ivo_id, dtl.gl_acn_id, dtl.t063_lct_nbr, hdr.ivo_dt, hdr.t616_vbu_nbr, hdr.t617_fnc_typ_cd, hdr.t8080_cai_shp_typ_cd, hdr.t8071_a
2. 770.782 1,316.324 ↓ 49.1 153,106 1

Sort (cost=7,776.40..7,784.20 rows=3,120 width=134) (actual time=1,281.321..1,316.324 rows=153,106 loops=1)

  • Sort Key: hdr.t8071_cai_ivo_id, dtl.gl_acn_id, dtl.t063_lct_nbr, hdr.ivo_dt, hdr.t8071_add_dm, hdr.upd_id, hdr.ivo_tot_amt, hdr.tot_pnr_adj_amt
  • Sort Method: quicksort Memory: 44,655kB
3. 127.635 545.542 ↓ 49.1 153,106 1

Nested Loop (cost=18.76..7,595.32 rows=3,120 width=134) (actual time=0.790..545.542 rows=153,106 loops=1)

4. 3.976 4.582 ↓ 5.6 2,505 1

Bitmap Heap Scan on t8071_cai_ivo_hdr hdr (cost=18.07..1,004.87 rows=444 width=65) (actual time=0.656..4.582 rows=2,505 loops=1)

  • Recheck Cond: ((t616_vbu_nbr = 35,357) AND (t617_fnc_typ_cd = 10) AND (ivo_sts_cd = 5) AND (t8080_cai_shp_typ_cd = 2) AND (ivo_dt >= '08/
  • Filter: ((t8097_mas_edi_acn_id)::text = '00000443FM'::text)
  • Heap Blocks: exact=157
5. 0.606 0.606 ↓ 4.3 2,505 1

Bitmap Index Scan on t063_key (cost=0.00..17.96 rows=577 width=0) (actual time=0.606..0.606 rows=2,505 loops=1)

  • Index Cond: ((t616_vbu_nbr = 35,357) AND (t617_fnc_typ_cd = 10) AND (ivo_sts_cd = 5) AND (t8080_cai_shp_typ_cd = 2) AND (ivo_dt >=
6. 413.325 413.325 ↓ 10.2 61 2,505

Index Scan using t8072i0 on t8072_cai_ivo_dtl dtl (cost=0.69..14.78 rows=6 width=106) (actual time=0.049..0.165 rows=61 loops=2,505)

  • Index Cond: ((t616_vbu_nbr = 35,357) AND (t617_fnc_typ_cd = 10) AND (t8071_cai_ivo_id = hdr.t8071_cai_ivo_id) AND (t8071_add_dm = hdr.t80
7.          

SubPlan (for GroupAggregate)

8. 21.564 203,427.588 ↑ 1.0 1 7,188

Limit (cost=0.01..0.62 rows=1 width=4) (actual time=28.299..28.301 rows=1 loops=7,188)

9. 50.316 203,406.024 ↑ 103,651.0 1 7,188

Result (cost=0.01..63,981.21 rows=103,651 width=4) (actual time=28.298..28.298 rows=1 loops=7,188)

  • One-Time Filter: ((hdr.ivo_dt >= '08/15/2020'::date) AND (hdr.ivo_dt <= '08/22/2020'::date))
10. 203,355.708 203,355.708 ↑ 103,651.0 1 7,188

Seq Scan on t8242_pak_pay_jrn_ent_dtl (cost=0.01..63,981.21 rows=103,651 width=4) (actual time=28.291..28.291 rows=1 loops=7,188)

  • Filter: (jrn_lin_dt = hdr.ivo_dt)
  • Rows Removed by Filter: 55,287
Planning time : 4.086 ms
Execution time : 205,145.004 ms