explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qMKg : explain_sonam

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=3,263,278.78..3,280,192.23 rows=49 width=1,046) (actual rows= loops=)

  • a.pay_rit_idc, a.tot_cai_adj_amt, a.tot_pnr_adj_amt, a.add_use_id, a.upd_dm, a.upd_id
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3,262,933.61..3,280,192.23 rows=50 width=1,046) (actual rows= loops=)

  • Group Key: a.t616_vbu_nbr, a.t617_fnc_typ_cd, a.t8071_cai_ivo_id, a.t8071_add_dm, a.ivo_dt, a.t8080_cai_shp_typ_cd, a.t8097_mas_edi_acn_id, a.lws_ivo_id, a.ivo_tot_amt, a.ivo_acl_amt, a.ivo_sts_cd, a.t3799_cur_cd, a.pay_rit_idc, a.tot_cai_adj_amt, a.tot_pnr_adj_amt, a.add_use_id, a.upd_dm, a.upd_id
3. 0.000 0.000 ↓ 0.0

Sort (cost=3,262,933.61..3,262,933.73 rows=50 width=124) (actual rows= loops=)

  • Sort Key: a.t616_vbu_nbr, a.t617_fnc_typ_cd, a.t8071_cai_ivo_id, a.t8071_add_dm, a.ivo_dt, a.t8080_cai_shp_typ_cd, a.lws_ivo_id, a.ivo_tot_amt, a.ivo_acl_amt, a.t3799_cur_cd,
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=440.00..3,262,932.20 rows=50 width=124) (actual rows= loops=)

  • Hash Cond: ((a.t617_fnc_typ_cd = subquery.t617_fnc_typ_cd) AND (a.t8071_cai_ivo_id = subquery.t8071_cai_ivo_id) AND (a.t8071_add_dm = subquery.t8071_add_dm))
  • Filter: (((subquery.t8130_apv_job_lvl_cd = ANY ('{0,1,2,3}'::smallint[])) OR (subquery.t8130_apv_job_lvl_cd IS NULL)) AND ((subquery.t8118_apv_sts_cd IS NULL) OR ((subquery.t8118_apv_sts_cd = 2) AND (subquery.t8119_apv_seq_nbr = (SubPlan 7)))))
5. 0.000 0.000 ↓ 0.0

Seq Scan on t8071_cai_ivo_hdr a (cost=0.00..357.19 rows=10,052 width=118) (actual rows= loops=)

  • Filter: ((ivo_sts_cd = '1'::smallint) AND ((t8097_mas_edi_acn_id)::text = '120182102'::text))
6. 0.000 0.000 ↓ 0.0

Hash (cost=268.18..268.18 rows=9,818 width=39) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on t8119_cai_ivo_apv_wfl subquery (cost=0.00..268.18 rows=9,818 width=39) (actual rows= loops=)

8.          

SubPlan (for Hash Left Join)

9. 0.000 0.000 ↓ 0.0

Aggregate (cost=341.82..341.83 rows=1 width=2) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on t8119_cai_ivo_apv_wfl p (cost=0.00..341.82 rows=1 width=2) (actual rows= loops=)

  • Filter: ((t617_fnc_typ_cd = subquery.t617_fnc_typ_cd) AND (t8071_cai_ivo_id = subquery.t8071_cai_ivo_id) AND (t8071_add_dm = subquery.t8071_add_dm))
11.          

SubPlan (for GroupAggregate)

12. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Aggregate (cost=341.85..341.88 rows=1 width=218) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on t8119_cai_ivo_apv_wfl com (cost=0.00..341.82 rows=1 width=23) (actual rows= loops=)

  • Filter: ((a.t617_fnc_typ_cd = t617_fnc_typ_cd) AND (a.t8071_cai_ivo_id = t8071_cai_ivo_id) AND (a.t8071_add_dm = t8071_add_dm))
15.          

SubPlan (for Aggregate)

16. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on t8070_cai_ivo_sts_typ b (cost=0.00..1.14 rows=1 width=41) (actual rows= loops=)

  • Filter: (a.ivo_sts_cd = t8070_ivo_sts_cd)
18. 0.000 0.000 ↓ 0.0

Seq Scan on t8080_cai_shp_typ c (cost=0.00..1.02 rows=1 width=41) (actual rows= loops=)

  • Filter: (a.t8080_cai_shp_typ_cd = t8080_cai_shp_typ_cd)
19. 0.000 0.000 ↓ 0.0

Seq Scan on t8107_cai_ctc d (cost=0.00..1.01 rows=1 width=41) (actual rows= loops=)

  • Filter: (((a.t8097_mas_edi_acn_id)::text = (t8097_mas_edi_acn_id)::text) AND (a.t8080_cai_shp_typ_cd = t8080_cai_shp_typ_cd))