explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5cw

Settings
# exclusive inclusive rows x rows loops node
1. 10.135 2,720.420 ↑ 1.0 1 1

Aggregate (cost=99,897.10..99,897.11 rows=1 width=8) (actual time=2,720.420..2,720.420 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=1127627, temp read=2947 written=2956
2.          

CTE preadvsmy

3. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=19,869.66..19,869.70 rows=1 width=74) (never executed)

  • Output: sum(COALESCE(malmst_2.wgt, '0'::numeric)), malmst_2.cmpcod, trt.fltcaridr, trt.fltnum, trt.fltseqnum, max(trt.fltdat), count(malmst_2.malseqnum), csgdtl.uldnum
  • Group Key: malmst_2.cmpcod, trt.fltcaridr, trt.fltnum, trt.fltseqnum, csgdtl.uldnum
4. 0.000 0.000 ↓ 0.0 0

Sort (cost=19,869.66..19,869.67 rows=1 width=45) (never executed)

  • Output: malmst_2.cmpcod, trt.fltcaridr, trt.fltnum, trt.fltseqnum, csgdtl.uldnum, malmst_2.wgt, trt.fltdat, malmst_2.malseqnum
  • Sort Key: trt.fltnum, trt.fltseqnum, csgdtl.uldnum
5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2,765.92..19,869.65 rows=1 width=45) (never executed)

  • Output: malmst_2.cmpcod, trt.fltcaridr, trt.fltnum, trt.fltseqnum, csgdtl.uldnum, malmst_2.wgt, trt.fltdat, malmst_2.malseqnum
  • Inner Unique: true
6. 0.000 0.000 ↓ 0.0 0

Gather (cost=2,765.64..19,869.35 rows=1 width=52) (never executed)

  • Output: csgdtl.uldnum, malmst_2.wgt, malmst_2.cmpcod, malmst_2.malseqnum, malmst_2.orgexgofc, trt.fltcaridr, trt.fltnum, trt.fltseqnum, trt.fltdat
  • Workers Planned: 2
  • Workers Launched: 0
7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,765.64..18,869.25 rows=1 width=52) (never executed)

  • Output: csgdtl.uldnum, malmst_2.wgt, malmst_2.cmpcod, malmst_2.malseqnum, malmst_2.orgexgofc, trt.fltcaridr, trt.fltnum, trt.fltseqnum, trt.fltdat
  • Join Filter: (((csgmst.csgdocnum)::text = (csgdtl.csgdocnum)::text) AND (csgmst.csgseqnum = csgdtl.csgseqnum) AND ((csgmst.poacod)::text = (csgdtl.poacod)::text))
8. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,765.22..18,868.76 rows=1 width=121) (never executed)

  • Output: csgmst.cmpcod, csgmst.csgdocnum, csgmst.csgseqnum, csgmst.poacod, malmst_2.wgt, malmst_2.cmpcod, malmst_2.malseqnum, malmst_2.csgseqnum, malmst_2.csgdocnum, malmst_2.poacod, malmst_2.orgexgofc, trt.fltcaridr, trt.fltnum, trt.fltseqnum, trt.fltdat, trt.csgdocnum, trt.csgseqnum, trt.poacod
  • Hash Cond: (((malmst_2.csgdocnum)::text = (csgmst.csgdocnum)::text) AND (malmst_2.csgseqnum = csgmst.csgseqnum) AND ((malmst_2.poacod)::text = (csgmst.poacod)::text))
9. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on icopgmapp.malmst malmst_2 (cost=0.00..15,484.23 rows=143,938 width=45) (never executed)

  • Output: malmst_2.wgt, malmst_2.cmpcod, malmst_2.malseqnum, malmst_2.csgseqnum, malmst_2.csgdocnum, malmst_2.poacod, malmst_2.orgexgofc
  • Filter: ((malmst_2.cmpcod)::text = 'AA'::text)
10. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,765.17..1,765.17 rows=3 width=76) (never executed)

  • Output: csgmst.cmpcod, csgmst.csgdocnum, csgmst.csgseqnum, csgmst.poacod, trt.fltcaridr, trt.fltnum, trt.fltseqnum, trt.fltdat, trt.csgdocnum, trt.csgseqnum, trt.poacod
11. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=785.63..1,765.17 rows=3 width=76) (never executed)

  • Output: csgmst.cmpcod, csgmst.csgdocnum, csgmst.csgseqnum, csgmst.poacod, trt.fltcaridr, trt.fltnum, trt.fltseqnum, trt.fltdat, trt.csgdocnum, trt.csgseqnum, trt.poacod
  • Hash Cond: (((trt.csgdocnum)::text = (csgmst.csgdocnum)::text) AND (trt.csgseqnum = csgmst.csgseqnum) AND ((trt.poacod)::text = (csgmst.poacod)::text))
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on icopgmapp.malcsgrtg trt (cost=0.00..978.22 rows=86 width=50) (never executed)

  • Output: trt.cmpcod, trt.poacod, trt.csgdocnum, trt.csgseqnum, trt.rtgsernum, trt.fltcarcod, trt.fltcaridr, trt.fltseqnum, trt.fltnum, trt.fltdat, trt.pou, trt.pol, trt.rmk, trt.tagidx
  • Filter: (((trt.cmpcod)::text = 'AA'::text) AND (trt.fltcaridr = '1001'::numeric) AND ((date_trunc('day'::text, trt.fltdat))::date >= '2019-02-01'::date) AND ((date_trunc('day'::text, trt.fltdat))::date <= '2020-02-01'::date))
13. 0.000 0.000 ↓ 0.0 0

Hash (cost=549.01..549.01 rows=13,521 width=29) (never executed)

  • Output: csgmst.cmpcod, csgmst.csgdocnum, csgmst.csgseqnum, csgmst.poacod
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on icopgmapp.malcsgmst csgmst (cost=0.00..549.01 rows=13,521 width=29) (never executed)

  • Output: csgmst.cmpcod, csgmst.csgdocnum, csgmst.csgseqnum, csgmst.poacod
  • Filter: ((csgmst.cmpcod)::text = 'AA'::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using malcsgdtl_ind2 on icopgmapp.malcsgdtl csgdtl (cost=0.42..0.47 rows=1 width=44) (never executed)

  • Output: csgdtl.cmpcod, csgdtl.poacod, csgdtl.csgdocnum, csgdtl.csgseqnum, csgdtl.malseqnum, csgdtl.uldnum, csgdtl.dclval, csgdtl.curcod, csgdtl.bagcnt, csgdtl.tagidx
  • Index Cond: (((csgdtl.cmpcod)::text = 'AA'::text) AND (csgdtl.malseqnum = malmst_2.malseqnum))
  • Filter: (((malmst_2.csgdocnum)::text = (csgdtl.csgdocnum)::text) AND (malmst_2.csgseqnum = csgdtl.csgseqnum) AND ((malmst_2.poacod)::text = (csgdtl.poacod)::text))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using malexgofcmst_pk on icopgmapp.malexgofcmst ofc (cost=0.28..0.30 rows=1 width=10) (never executed)

  • Output: ofc.cmpcod, ofc.exgofccod, ofc.actflg, ofc.ctycod, ofc.exgcoddes, ofc.cntcod, ofc.ofccod, ofc.poacod, ofc.lstupdtim, ofc.lstupdusr, ofc.arpcod, ofc.malboxidr, ofc.tagidx
  • Index Cond: (((ofc.cmpcod)::text = 'AA'::text) AND ((ofc.exgofccod)::text = (malmst_2.orgexgofc)::text))
  • Filter: ((ofc.actflg)::text = 'A'::text)
17. 140.432 2,710.285 ↓ 766.1 153,226 1

GroupAggregate (cost=80,009.60..80,024.90 rows=200 width=834) (actual time=2,372.523..2,710.285 rows=153,226 loops=1)

  • Output: v_sub1.cmpcod, v_sub1.arpcod, v_sub1.fltcaridr, v_sub1.fltnum, v_sub1.fltseqnum, v_sub1.fltdat, v_sub1.legsernum, v_sub1.fltrou, v_sub1.fltorg, v_sub1.fltdst, v_sub1.flttyp, v_sub1.fltsta, v_sub1.acrtyp, v_sub1.legorg, v_sub1.expclsflg, v_sub1.depgte, v_sub1.fltdatprefix, v_sub1.deptim, v_sub1.arvgte, NULL::text, NULL::text, NULL::text, NULL::text, NULL::numeric, NULL::bigint, NULL::text, NULL::text
  • Group Key: v_sub1.cmpcod, v_sub1.arpcod, v_sub1.fltcaridr, v_sub1.fltnum, v_sub1.fltseqnum, v_sub1.fltdat, v_sub1.legsernum, v_sub1.fltrou, v_sub1.fltorg, v_sub1.fltdst, v_sub1.flttyp, v_sub1.fltsta, v_sub1.acrtyp, v_sub1.legorg, v_sub1.fltdatprefix, v_sub1.expclsflg, v_sub1.depgte, v_sub1.deptim, v_sub1.arvgte
  • Buffers: shared hit=1127627, temp read=2947 written=2956
18. 1,585.540 2,569.853 ↓ 853.7 227,092 1

Sort (cost=80,009.60..80,010.26 rows=266 width=602) (actual time=2,372.507..2,569.853 rows=227,092 loops=1)

  • Output: v_sub1.cmpcod, v_sub1.arpcod, v_sub1.fltcaridr, v_sub1.fltnum, v_sub1.fltseqnum, v_sub1.fltdat, v_sub1.legsernum, v_sub1.fltrou, v_sub1.fltorg, v_sub1.fltdst, v_sub1.flttyp, v_sub1.fltsta, v_sub1.acrtyp, v_sub1.legorg, v_sub1.expclsflg, v_sub1.depgte, v_sub1.fltdatprefix, v_sub1.deptim, v_sub1.arvgte
  • Sort Key: v_sub1.cmpcod, v_sub1.arpcod, v_sub1.fltcaridr, v_sub1.fltnum, v_sub1.fltseqnum, v_sub1.fltdat, v_sub1.legsernum, v_sub1.fltrou, v_sub1.fltorg, v_sub1.fltdst, v_sub1.flttyp, v_sub1.fltsta, v_sub1.acrtyp, v_sub1.legorg, v_sub1.fltdatprefix, v_sub1.expclsflg, v_sub1.depgte, v_sub1.deptim, v_sub1.arvgte
  • Sort Method: external merge Disk: 23576kB
  • Buffers: shared hit=1127627, temp read=2947 written=2956
19. 39.762 984.313 ↓ 853.7 227,092 1

Subquery Scan on v_sub1 (cost=9,888.20..79,998.88 rows=266 width=602) (actual time=69.231..984.313 rows=227,092 loops=1)

  • Output: v_sub1.cmpcod, v_sub1.arpcod, v_sub1.fltcaridr, v_sub1.fltnum, v_sub1.fltseqnum, v_sub1.fltdat, v_sub1.legsernum, v_sub1.fltrou, v_sub1.fltorg, v_sub1.fltdst, v_sub1.flttyp, v_sub1.fltsta, v_sub1.acrtyp, v_sub1.legorg, v_sub1.expclsflg, v_sub1.depgte, v_sub1.fltdatprefix, v_sub1.deptim, v_sub1.arvgte
  • Buffers: shared hit=1127618
20. 23.305 944.551 ↓ 853.7 227,092 1

Append (cost=9,888.20..79,996.22 rows=266 width=834) (actual time=69.229..944.551 rows=227,092 loops=1)

  • Buffers: shared hit=1127618
21. 0.001 18.208 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=9,888.20..9,889.46 rows=14 width=374) (actual time=18.208..18.208 rows=0 loops=1)

  • Output: "*SELECT* 1".cmpcod, "*SELECT* 1".arpcod, "*SELECT* 1".fltcaridr, "*SELECT* 1".fltnum, "*SELECT* 1".fltseqnum, "*SELECT* 1".fltdat, "*SELECT* 1".legsernum, "*SELECT* 1".fltrou, "*SELECT* 1".fltorg, "*SELECT* 1".fltdst, "*SELECT* 1".flttyp, "*SELECT* 1".fltsta, "*SELECT* 1".acrtyp, "*SELECT* 1".legorg, "*SELECT* 1".expclsflg, "*SELECT* 1".depgte, "*SELECT* 1".fltdatprefix, "*SELECT* 1".deptim, "*SELECT* 1".arvgte, "*SELECT* 1".concnt, "*SELECT* 1".connam, "*SELECT* 1".wgt, "*SELECT* 1".malcnt, "*SELECT* 1".rcpwgt, "*SELECT* 1".rcpidrcnt, "*SELECT* 1".dcssta, "*SELECT* 1".dcsrejrsn
  • Buffers: shared hit=4391
22. 0.000 18.207 ↓ 0.0 0 1

GroupAggregate (cost=9,888.20..9,889.28 rows=14 width=359) (actual time=18.207..18.207 rows=0 loops=1)

  • Output: fltmst.cmpcod, malflt.arpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, fltmst.fltdat, malflt.legsernum, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, fltleg.acrtyp, fltleg.legorg, (COALESCE(malflt.expclsflg, 'N'::character varying)), fltleg.depgte, (CASE WHEN (fltleg.atd IS NOT NULL) THEN 'A'::text ELSE CASE WHEN (fltleg.etd IS NOT NULL) THEN 'E'::text ELSE CASE WHEN (fltleg.std IS NOT NULL) THEN 'S'::text ELSE ''::text END END END), (COALESCE(fltleg.atd, fltleg.etd, fltleg.std)), fltleg.arvgte, (count(DISTINCT fltcon.connum))::character varying, ((substr((fltcon.connum)::text, 1, 3))::character varying), sum(COALESCE(malmst.wgt, '0'::numeric)), count(malmst.malseqnum), max(COALESCE(preadv.rcpwgt, '0'::numeric)), max(COALESCE(preadv.rcpidrcnt, '0'::bigint)), max((dwsmst.dcssta)::text), max((dwsmst.dcsrejrsn)::text), fltcon.connum
  • Group Key: fltmst.cmpcod, malflt.arpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, malflt.legsernum, fltleg.acrtyp, fltleg.legorg, (COALESCE(malflt.expclsflg, 'N'::character varying)), fltleg.depgte, fltleg.arvgte, fltcon.connum, ((substr((fltcon.connum)::text, 1, 3))::character varying), (COALESCE(fltleg.atd, fltleg.etd, fltleg.std)), (CASE WHEN (fltleg.atd IS NOT NULL) THEN 'A'::text ELSE CASE WHEN (fltleg.etd IS NOT NULL) THEN 'E'::text ELSE CASE WHEN (fltleg.std IS NOT NULL) THEN 'S'::text ELSE ''::text END END END)
  • Buffers: shared hit=4391
23. 0.017 18.207 ↓ 0.0 0 1

Sort (cost=9,888.20..9,888.23 rows=14 width=798) (actual time=18.206..18.207 rows=0 loops=1)

  • Output: fltmst.cmpcod, malflt.arpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, malflt.legsernum, fltleg.acrtyp, fltleg.legorg, (COALESCE(malflt.expclsflg, 'N'::character varying)), fltleg.depgte, (CASE WHEN (fltleg.atd IS NOT NULL) THEN 'A'::text ELSE CASE WHEN (fltleg.etd IS NOT NULL) THEN 'E'::text ELSE CASE WHEN (fltleg.std IS NOT NULL) THEN 'S'::text ELSE ''::text END END END), (COALESCE(fltleg.atd, fltleg.etd, fltleg.std)), fltleg.arvgte, ((substr((fltcon.connum)::text, 1, 3))::character varying), fltcon.connum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, malmst.wgt, malmst.malseqnum, preadv.rcpwgt, preadv.rcpidrcnt, dwsmst.dcssta, dwsmst.dcsrejrsn
  • Sort Key: fltmst.fltnum, fltmst.fltseqnum, malflt.legsernum, fltleg.acrtyp, (COALESCE(malflt.expclsflg, 'N'::character varying)), fltleg.depgte, fltleg.arvgte, fltcon.connum, ((substr((fltcon.connum)::text, 1, 3))::character varying), (COALESCE(fltleg.atd, fltleg.etd, fltleg.std)), (CASE WHEN (fltleg.atd IS NOT NULL) THEN 'A'::text ELSE CASE WHEN (fltleg.etd IS NOT NULL) THEN 'E'::text ELSE CASE WHEN (fltleg.std IS NOT NULL) THEN 'S'::text ELSE ''::text END END END)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4391
24. 0.000 18.190 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,856.37..9,887.93 rows=14 width=798) (actual time=18.190..18.190 rows=0 loops=1)

  • Output: fltmst.cmpcod, malflt.arpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, malflt.legsernum, fltleg.acrtyp, fltleg.legorg, COALESCE(malflt.expclsflg, 'N'::character varying), fltleg.depgte, CASE WHEN (fltleg.atd IS NOT NULL) THEN 'A'::text ELSE CASE WHEN (fltleg.etd IS NOT NULL) THEN 'E'::text ELSE CASE WHEN (fltleg.std IS NOT NULL) THEN 'S'::text ELSE ''::text END END END, COALESCE(fltleg.atd, fltleg.etd, fltleg.std), fltleg.arvgte, (substr((fltcon.connum)::text, 1, 3))::character varying, fltcon.connum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, malmst.wgt, malmst.malseqnum, preadv.rcpwgt, preadv.rcpidrcnt, dwsmst.dcssta, dwsmst.dcsrejrsn
  • Buffers: shared hit=4391
25. 0.002 18.190 ↓ 0.0 0 1

Hash Left Join (cost=1,855.94..9,880.61 rows=14 width=720) (actual time=18.189..18.190 rows=0 loops=1)

  • Output: fltmst.cmpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, fltleg.acrtyp, fltleg.legorg, fltleg.depgte, fltleg.atd, fltleg.etd, fltleg.std, fltleg.arvgte, dwsmst.dcssta, dwsmst.dcsrejrsn, malflt.arpcod, malflt.legsernum, malflt.expclsflg, fltcon.connum, malmst.wgt, malmst.malseqnum, preadv.rcpwgt, preadv.rcpidrcnt
  • Hash Cond: (((segdtl.cmpcod)::text = (preadv.cmpcod)::text) AND (segdtl.fltcaridr = preadv.fltcaridr) AND ((segdtl.fltnum)::text = (preadv.fltnum)::text) AND (segdtl.fltseqnum = preadv.fltseqnum))
  • Buffers: shared hit=4391
26. 0.000 18.188 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,855.89..9,880.35 rows=14 width=698) (actual time=18.188..18.188 rows=0 loops=1)

  • Output: fltmst.cmpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, fltleg.acrtyp, fltleg.legorg, fltleg.depgte, fltleg.atd, fltleg.etd, fltleg.std, fltleg.arvgte, dwsmst.dcssta, dwsmst.dcsrejrsn, malflt.arpcod, malflt.legsernum, malflt.expclsflg, fltcon.connum, segdtl.cmpcod, segdtl.fltcaridr, segdtl.fltnum, segdtl.fltseqnum, malmst.wgt, malmst.malseqnum
  • Buffers: shared hit=4391
27. 0.000 18.188 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,855.05..2,104.25 rows=1 width=702) (actual time=18.188..18.188 rows=0 loops=1)

  • Output: fltmst.cmpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, fltleg.acrtyp, fltleg.legorg, fltleg.depgte, fltleg.atd, fltleg.etd, fltleg.std, fltleg.arvgte, dwsmst.dcssta, dwsmst.dcsrejrsn, malflt.arpcod, malflt.legsernum, malflt.expclsflg, fltcon.connum, uldseg.cmpcod, uldseg.fltcaridr, uldseg.fltnum, uldseg.fltseqnum, uldseg.segsernum, uldseg.uldnum
  • Inner Unique: true
  • Buffers: shared hit=4391
28. 0.001 18.188 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,854.77..2,103.49 rows=1 width=691) (actual time=18.188..18.188 rows=0 loops=1)

  • Output: fltmst.cmpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, fltleg.acrtyp, fltleg.legorg, fltleg.depgte, fltleg.atd, fltleg.etd, fltleg.std, fltleg.arvgte, dwsmst.dcssta, dwsmst.dcsrejrsn, malflt.arpcod, malflt.legsernum, malflt.expclsflg, fltcon.connum, fltcon.cmpcod, fltcon.fltcaridr, fltcon.fltnum, fltcon.fltseqnum, fltcon.segsernum
  • Join Filter: (((fltleg.cmpcod)::text = (dwsmst.cmpcod)::text) AND (fltleg.fltcaridr = dwsmst.fltcaridr) AND ((fltleg.legorg)::text = (dwsmst.arpcod)::text) AND ((fltleg.fltnum)::text = (dwsmst.fltnum)::text) AND (fltleg.fltseqnum = dwsmst.fltseqnum) AND (fltleg.legsernum = dwsmst.legsernum))
  • Buffers: shared hit=4391
29. 0.264 18.187 ↓ 0.0 0 1

Nested Loop (cost=1,854.77..2,092.94 rows=1 width=150) (actual time=18.187..18.187 rows=0 loops=1)

  • Output: fltmst.cmpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, fltleg.acrtyp, fltleg.legorg, fltleg.depgte, fltleg.atd, fltleg.etd, fltleg.std, fltleg.arvgte, fltleg.cmpcod, fltleg.fltnum, fltleg.fltcaridr, fltleg.fltseqnum, fltleg.legsernum, malflt.arpcod, malflt.legsernum, malflt.expclsflg, fltcon.connum, fltcon.cmpcod, fltcon.fltcaridr, fltcon.fltnum, fltcon.fltseqnum, fltcon.segsernum
  • Inner Unique: true
  • Join Filter: (malflt.legsernum = fltleg.legsernum)
  • Buffers: shared hit=4391
30. 0.528 14.435 ↓ 436.0 436 1

Nested Loop (cost=1,854.35..2,092.23 rows=1 width=112) (actual time=9.806..14.435 rows=436 loops=1)

  • Output: fltmst.cmpcod, fltmst.fltcaridr, fltmst.fltnum, fltmst.fltseqnum, fltmst.fltdat, fltmst.fltrou, fltmst.fltorg, fltmst.fltdst, fltmst.flttyp, fltmst.fltsta, malflt.arpcod, malflt.legsernum, malflt.expclsflg, malflt.cmpcod, malflt.fltnum, malflt.fltcaridr, malflt.fltseqnum, fltcon.connum, fltcon.cmpcod, fltcon.fltcaridr, fltcon.fltnum, fltcon.fltseqnum, fltcon.legsernum, fltcon.segsernum
  • Inner Unique: true
  • Buffers: shared hit=2645
31. 0.286 11.279 ↓ 438.0 438 1

Hash Join (cost=1,853.92..2,083.87 rows=1 width=64) (actual time=9.766..11.279 rows=438 loops=1)

  • Output: malflt.arpcod, malflt.legsernum, malflt.expclsflg, malflt.cmpcod, malflt.fltnum, malflt.fltcaridr, malflt.fltseqnum, fltcon.connum, fltcon.cmpcod, fltcon.fltcaridr, fltcon.fltnum, fltcon.fltseqnum, fltcon.legsernum, fltcon.segsernum
  • Hash Cond: (((fltcon.fltnum)::text = (malflt.fltnum)::text) AND (fltcon.fltseqnum = malflt.fltseqnum) AND (fltcon.legsernum = malflt.legsernum))
  • Buffers: shared hit=895
32. 1.275 1.275 ↓ 1.9 444 1

Seq Scan on icopgmapp.malfltcon fltcon (cost=0.00..191.33 rows=234 width=40) (actual time=0.025..1.275 rows=444 loops=1)

  • Output: fltcon.cmpcod, fltcon.asgprt, fltcon.fltcaridr, fltcon.fltnum, fltcon.fltseqnum, fltcon.legsernum, fltcon.connum, fltcon.contyp, fltcon.pou, fltcon.dstcod, fltcon.rmk, fltcon.poaflg, fltcon.usrcod, fltcon.asgdat, fltcon.lstupdtim, fltcon.lstupdusr, fltcon.segsernum, fltcon.acpflg, fltcon.fltcarcod, fltcon.oflflg, fltcon.arrsta, fltcon.traflg, fltcon.poaopn, fltcon.dlvflg, fltcon.intflg, fltcon.txncod, fltcon.conjrnidr, fltcon.poacod, fltcon.trnflg, fltcon.asgdatutc, fltcon.actuldwgt, fltcon.tagidx, fltcon.cntidr, fltcon.actuldwgtdsp, fltcon.actuldwgtdspunt
  • Filter: (((fltcon.cmpcod)::text = 'AA'::text) AND (fltcon.fltcaridr = '1001'::numeric) AND ((fltcon.asgprt)::text = 'DFW'::text) AND ((fltcon.contyp)::text = 'U'::text) AND ((fltcon.acpflg)::text = 'Y'::text))
  • Rows Removed by Filter: 3793
  • Buffers: shared hit=96
33. 0.134 9.718 ↓ 1.0 411 1

Hash (cost=1,846.76..1,846.76 rows=409 width=28) (actual time=9.718..9.718 rows=411 loops=1)

  • Output: malflt.arpcod, malflt.legsernum, malflt.expclsflg, malflt.cmpcod, malflt.fltnum, malflt.fltcaridr, malflt.fltseqnum
  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
  • Buffers: shared hit=799
34. 9.584 9.584 ↓ 1.0 411 1

Seq Scan on icopgmapp.malflt (cost=0.00..1,846.76 rows=409 width=28) (actual time=0.004..9.584 rows=411 loops=1)

  • Output: malflt.arpcod, malflt.legsernum, malflt.expclsflg, malflt.cmpcod, malflt.fltnum, malflt.fltcaridr, malflt.fltseqnum
  • Filter: (((malflt.cmpcod)::text = 'AA'::text) AND (malflt.fltcaridr = '1001'::numeric) AND ((malflt.arpcod)::text = 'DFW'::text))
  • Rows Removed by Filter: 59461
  • Buffers: shared hit=799
35. 2.628 2.628 ↑ 1.0 1 438

Index Scan using fltoprmst_pk on icopgmapp.fltoprmst fltmst (cost=0.43..8.36 rows=1 width=48) (actual time=0.006..0.006 rows=1 loops=438)

  • Output: fltmst.fltseqnum, fltmst.fltnum, fltmst.fltcaridr, fltmst.cmpcod, fltmst.fltrou, fltmst.schtyp, fltmst.flttyp, fltmst.fltown, fltmst.crtusr, fltmst.crttim, fltmst.fltsta, fltmst.domfltflg, fltmst.fltmod, fltmst.fltrmk, fltmst.dayopr, fltmst.fltorg, fltmst.fltdst, fltmst.fltrstidr, fltmst.lstupdusr, fltmst.lstupdtim, fltmst.locstn, fltmst.fltdat, fltmst.ovrsegcap, fltmst.crtstn, fltmst.ffrwgtlmt, fltmst.mincontim, fltmst.hasfrsrst, fltmst.isstbd, fltmst.natlty, fltmst.ncsfltcaridr, fltmst.ncsfltnum, fltmst.ncsfltdat, fltmst.blgarl, fltmst.oinfltflg, fltmst.atbfltflg, fltmst.dmyarlflg, fltmst.ncscarcod, fltmst.extncscarcod, fltmst.extncsfltcaridr, fltmst.extncsfltnum, fltmst.extncsfltdat, fltmst.fltcatgry, fltmst.prgclsdat, fltmst.isfctlmod, fltmst.isschtmod, fltmst.acrchgflg, fltmst.fltsrc, fltmst.eqpchgflg, fltmst.legcnlrmk, fltmst.ofrdspind, fltmst.ofrdsptyp, fltmst.usrofrdsp, fltmst.ctroff, fltmst.tagidx, fltmst.agrtyp, fltmst.trktyp, fltmst.trkvndcod
  • Index Cond: (((fltmst.fltnum)::text = (malflt.fltnum)::text) AND (fltmst.fltcaridr = '1001'::numeric) AND (fltmst.fltseqnum = malflt.fltseqnum) AND ((fltmst.cmpcod)::text = 'AA'::text))
  • Filter: ((fltmst.fltsta)::text <> 'CAN'::text)
  • Buffers: shared hit=1750
36. 3.488 3.488 ↓ 0.0 0 436

Index Scan using fltoprleg_ind5 on icopgmapp.fltoprleg fltleg (cost=0.43..0.70 rows=1 width=61) (actual time=0.008..0.008 rows=0 loops=436)

  • Output: fltleg.legsernum, fltleg.fltseqnum, fltleg.fltnum, fltleg.fltcaridr, fltleg.cmpcod, fltleg.legorg, fltleg.legdst, fltleg.sta, fltleg.eta, fltleg.ata, fltleg.std, fltleg.etd, fltleg.atd, fltleg.stautc, fltleg.stdutc, fltleg.legsta, fltleg.acrtyp, fltleg.talnum, fltleg.fulwgt, fltleg.capidr, fltleg.mvtsta, fltleg.delflg, fltleg.cnlflg, fltleg.divflg, fltleg.tchflg, fltleg.ovrflg, fltleg.lstataupdusr, fltleg.lstatdupdusr, fltleg.mvtarrflg, fltleg.mvtdepflg, fltleg.prvtalnum, fltleg.dlycod, fltleg.legrmk, fltleg.atdutc, fltleg.atautc, fltleg.sptnum, fltleg.oprsta, fltleg.depgte, fltleg.arvgte, fltleg.deppos, fltleg.arvpos, fltleg.extdlycod, fltleg.subdlycod, fltleg.nxtinftim, fltleg.cstseanum, fltleg.capcfgnam, fltleg.trfrstnot, fltleg.atadsprqdflg, fltleg.timmod, fltleg.expcapsta, fltleg.sertyp, fltleg.prvacrtyp, fltleg.airbrntim, fltleg.tchdwntim, fltleg.oprfltcarcod, fltleg.tagidx, fltleg.depter, fltleg.arvter, fltleg.acrowr
  • Index Cond: ((fltleg.fltcaridr = '1001'::numeric) AND ((fltleg.fltnum)::text = (fltmst.fltnum)::text) AND (fltleg.fltseqnum = fltmst.fltseqnum) AND ((fltleg.legorg)::text = 'DFW'::text))
  • Filter: (((fltleg.cmpcod)::text = 'AA'::text) AND ((date_trunc('day'::text, fltleg.std))::date >= '2019-02-01'::date) AND ((date_trunc('day'::text, fltleg.std))::date <= '2020-02-01'::date))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1746
37. 0.000 0.000 ↓ 0.0 0

Seq Scan on icopgmapp.oprdwsmst dwsmst (cost=0.00..10.53 rows=1 width=680) (never executed)

  • Output: dwsmst.cmpcod, dwsmst.arpcod, dwsmst.fltcaridr, dwsmst.fltnum, dwsmst.fltseqnum, dwsmst.legsernum, dwsmst.prtdat, dwsmst.estblkwgt, dwsmst.estuldwgt, dwsmst.estdtl, dwsmst.lstupdusr, dwsmst.lstupdtim, dwsmst.dwsrmk, dwsmst.estblkvol, dwsmst.dwssta, dwsmst.dcssta, dwsmst.dcsrejrsn, dwsmst.tagidx, dwsmst.dcsfrcsta, dwsmst.dcsfrcrejrsn
  • Filter: (((dwsmst.cmpcod)::text = 'AA'::text) AND (dwsmst.fltcaridr = '1001'::numeric) AND ((dwsmst.arpcod)::text = 'DFW'::text))
38. 0.000 0.000 ↓ 0.0 0

Index Only Scan using maluldseg_pk on icopgmapp.maluldseg uldseg (cost=0.28..0.76 rows=1 width=33) (never executed)

  • Output: uldseg.cmpcod, uldseg.fltcaridr, uldseg.fltnum, uldseg.fltseqnum, uldseg.segsernum, uldseg.uldnum
  • Index Cond: ((uldseg.cmpcod = (fltcon.cmpcod)::text) AND (uldseg.cmpcod = 'AA'::text) AND (uldseg.fltcaridr = fltcon.fltcaridr) AND (uldseg.fltcaridr = '1001'::numeric) AND (uldseg.fltnum = (fltcon.fltnum)::text) AND (uldseg.fltseqnum = fltcon.fltseqnum) AND (uldseg.segsernum = fltcon.segsernum) AND (uldseg.uldnum = (fltcon.connum)::text))
  • Heap Fetches: 0
39. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..7,776.09 rows=1 width=43) (never executed)

  • Output: segdtl.cmpcod, segdtl.fltcaridr, segdtl.fltnum, segdtl.fltseqnum, segdtl.segsernum, segdtl.uldnum, malmst.wgt, malmst.malseqnum
40. 0.000 0.000 ↓ 0.0 0

Index Only Scan using maluldsegdtl_pk on icopgmapp.maluldsegdtl segdtl (cost=0.42..2.25 rows=1 width=39) (never executed)

  • Output: segdtl.cmpcod, segdtl.fltcaridr, segdtl.fltnum, segdtl.fltseqnum, segdtl.segsernum, segdtl.uldnum, segdtl.malseqnum
  • Index Cond: ((segdtl.cmpcod = (uldseg.cmpcod)::text) AND (segdtl.cmpcod = 'AA'::text) AND (segdtl.fltcaridr = uldseg.fltcaridr) AND (segdtl.fltcaridr = '1001'::numeric) AND (segdtl.fltnum = (uldseg.fltnum)::text) AND (segdtl.fltseqnum = uldseg.fltseqnum) AND (segdtl.segsernum = uldseg.segsernum) AND (segdtl.uldnum = (uldseg.uldnum)::text))
  • Heap Fetches: 0
41. 0.000 0.000 ↓ 0.0 0

Index Scan using malmst_ind8 on icopgmapp.malmst (cost=0.42..7,773.83 rows=1 width=14) (never executed)

  • Output: malmst.wgt, malmst.malseqnum, malmst.cmpcod
  • Index Cond: (((segdtl.cmpcod)::text = (malmst.cmpcod)::text) AND ((malmst.cmpcod)::text = 'AA'::text))
  • Filter: (segdtl.malseqnum = malmst.malseqnum)
42. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.03..0.03 rows=1 width=120) (never executed)

  • Output: preadv.rcpwgt, preadv.rcpidrcnt, preadv.cmpcod, preadv.fltcaridr, preadv.fltnum, preadv.fltseqnum
43. 0.000 0.000 ↓ 0.0 0

CTE Scan on preadvsmy preadv (cost=0.00..0.03 rows=1 width=120) (never executed)

  • Output: preadv.rcpwgt, preadv.rcpidrcnt, preadv.cmpcod, preadv.fltcaridr, preadv.fltnum, preadv.fltseqnum
  • Filter: (((preadv.cmpcod)::text = 'AA'::text) AND (preadv.fltcaridr = '1001'::numeric))
44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fltoprseg_pk on icopgmapp.fltoprseg fltseg (cost=0.43..0.51 rows=1 width=18) (never executed)

  • Output: fltseg.fltnum, fltseg.fltcaridr, fltseg.fltseqnum, fltseg.segsernum, fltseg.cmpcod
  • Index Cond: ((fltseg.fltnum = (fltmst.fltnum)::text) AND (fltseg.fltcaridr = fltmst.fltcaridr) AND (fltseg.fltcaridr = '1001'::numeric) AND (fltseg.fltseqnum = fltmst.fltseqnum) AND (fltseg.cmpcod = (fltmst.cmpcod)::text) AND (fltseg.cmpcod = 'AA'::text))
  • Heap Fetches: 0
45. 0.001 12.734 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=284.02..9,981.06 rows=14 width=325) (actual time=12.734..12.734 rows=0 loops=1)

  • Output: "*SELECT* 2".cmpcod, "*SELECT* 2".arpcod, "*SELECT* 2".fltcaridr, "*SELECT* 2".fltnum, "*SELECT* 2".fltseqnum, "*SELECT* 2".fltdat, "*SELECT* 2".legsernum, "*SELECT* 2".fltrou, "*SELECT* 2".fltorg, "*SELECT* 2".fltdst, "*SELECT* 2".flttyp, "*SELECT* 2".fltsta, "*SELECT* 2".acrtyp, "*SELECT* 2".legorg, "*SELECT* 2".expclsflg, "*SELECT* 2".depgte, "*SELECT* 2".fltdatprefix, "*SELECT* 2".deptim, "*SELECT* 2".arvgte, "*SELECT* 2".connum, 'BULK'::character varying, "*SELECT* 2".wgt, "*SELECT* 2".malseqnum, "*SELECT* 2".rcpwgt, "*SELECT* 2".rcpidrcnt, "*SELECT* 2".dcssta, "*SELECT* 2".dcsrejrsn
  • Buffers: shared hit=1765
46. 0.000 12.733 ↓ 0.0 0 1

Nested Loop Left Join (cost=284.02..9,980.92 rows=14 width=825) (actual time=12.733..12.733 rows=0 loops=1)

  • Output: fltmst_1.cmpcod, malflt_1.arpcod, fltmst_1.fltcaridr, fltmst_1.fltnum, fltmst_1.fltseqnum, fltmst_1.fltdat, malflt_1.legsernum, fltmst_1.fltrou, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.flttyp, fltmst_1.fltsta, fltleg_1.acrtyp, fltleg_1.legorg, COALESCE(malflt_1.expclsflg, 'N'::character varying), fltleg_1.depgte, CASE WHEN (fltleg_1.atd IS NOT NULL) THEN 'A'::text ELSE CASE WHEN (fltleg_1.etd IS NOT NULL) THEN 'E'::text ELSE CASE WHEN (fltleg_1.std IS NOT NULL) THEN 'S'::text ELSE ''::text END END END, COALESCE(fltleg_1.atd, fltleg_1.etd, fltleg_1.std), fltleg_1.arvgte, fltcon_1.connum, 'BULK'::character varying, COALESCE(malmst_1.wgt, '0'::numeric), malmst_1.malseqnum, COALESCE(preadv_1.rcpwgt, '0'::numeric), COALESCE(preadv_1.rcpidrcnt, '0'::bigint), dwsmst_1.dcssta, dwsmst_1.dcsrejrsn
  • Buffers: shared hit=1765
47. 0.001 12.733 ↓ 0.0 0 1

Hash Left Join (cost=283.60..9,973.64 rows=14 width=720) (actual time=12.733..12.733 rows=0 loops=1)

  • Output: fltmst_1.cmpcod, fltmst_1.fltcaridr, fltmst_1.fltnum, fltmst_1.fltseqnum, fltmst_1.fltdat, fltmst_1.fltrou, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.flttyp, fltmst_1.fltsta, fltleg_1.acrtyp, fltleg_1.legorg, fltleg_1.depgte, fltleg_1.atd, fltleg_1.etd, fltleg_1.std, fltleg_1.arvgte, dwsmst_1.dcssta, dwsmst_1.dcsrejrsn, malflt_1.arpcod, malflt_1.legsernum, malflt_1.expclsflg, fltcon_1.connum, malmst_1.wgt, malmst_1.malseqnum, preadv_1.rcpwgt, preadv_1.rcpidrcnt
  • Hash Cond: (((segdtl_1.cmpcod)::text = (preadv_1.cmpcod)::text) AND (segdtl_1.fltcaridr = preadv_1.fltcaridr) AND ((segdtl_1.fltnum)::text = (preadv_1.fltnum)::text) AND (segdtl_1.fltseqnum = preadv_1.fltseqnum))
  • Buffers: shared hit=1765
48. 0.001 12.732 ↓ 0.0 0 1

Hash Join (cost=283.55..9,973.37 rows=14 width=698) (actual time=12.732..12.732 rows=0 loops=1)

  • Output: fltmst_1.cmpcod, fltmst_1.fltcaridr, fltmst_1.fltnum, fltmst_1.fltseqnum, fltmst_1.fltdat, fltmst_1.fltrou, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.flttyp, fltmst_1.fltsta, fltleg_1.acrtyp, fltleg_1.legorg, fltleg_1.depgte, fltleg_1.atd, fltleg_1.etd, fltleg_1.std, fltleg_1.arvgte, dwsmst_1.dcssta, dwsmst_1.dcsrejrsn, malflt_1.arpcod, malflt_1.legsernum, malflt_1.expclsflg, fltcon_1.connum, segdtl_1.cmpcod, segdtl_1.fltcaridr, segdtl_1.fltnum, segdtl_1.fltseqnum, malmst_1.wgt, malmst_1.malseqnum
  • Hash Cond: (((fltmst_1.fltnum)::text = (fltcon_1.fltnum)::text) AND (fltmst_1.fltseqnum = fltcon_1.fltseqnum) AND (fltleg_1.legsernum = fltcon_1.legsernum) AND (uldseg_1.segsernum = fltcon_1.segsernum))
  • Buffers: shared hit=1765
49. 0.000 12.731 ↓ 0.0 0 1

Nested Loop Left Join (cost=84.00..9,758.55 rows=14 width=745) (actual time=12.731..12.731 rows=0 loops=1)

  • Output: fltmst_1.cmpcod, fltmst_1.fltcaridr, fltmst_1.fltnum, fltmst_1.fltseqnum, fltmst_1.fltdat, fltmst_1.fltrou, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.flttyp, fltmst_1.fltsta, fltleg_1.acrtyp, fltleg_1.legorg, fltleg_1.depgte, fltleg_1.atd, fltleg_1.etd, fltleg_1.std, fltleg_1.arvgte, fltleg_1.fltnum, fltleg_1.fltseqnum, fltleg_1.legsernum, dwsmst_1.dcssta, dwsmst_1.dcsrejrsn, malflt_1.arpcod, malflt_1.legsernum, malflt_1.expclsflg, malflt_1.cmpcod, malflt_1.fltnum, malflt_1.fltcaridr, malflt_1.fltseqnum, uldseg_1.cmpcod, uldseg_1.fltcaridr, uldseg_1.fltnum, uldseg_1.fltseqnum, uldseg_1.segsernum, segdtl_1.cmpcod, segdtl_1.fltcaridr, segdtl_1.fltnum, segdtl_1.fltseqnum, malmst_1.wgt, malmst_1.malseqnum
  • Buffers: shared hit=1765
50. 0.001 12.731 ↓ 0.0 0 1

Nested Loop Left Join (cost=83.16..1,981.35 rows=1 width=726) (actual time=12.731..12.731 rows=0 loops=1)

  • Output: fltmst_1.cmpcod, fltmst_1.fltcaridr, fltmst_1.fltnum, fltmst_1.fltseqnum, fltmst_1.fltdat, fltmst_1.fltrou, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.flttyp, fltmst_1.fltsta, fltleg_1.acrtyp, fltleg_1.legorg, fltleg_1.depgte, fltleg_1.atd, fltleg_1.etd, fltleg_1.std, fltleg_1.arvgte, fltleg_1.fltnum, fltleg_1.fltseqnum, fltleg_1.legsernum, dwsmst_1.dcssta, dwsmst_1.dcsrejrsn, malflt_1.arpcod, malflt_1.legsernum, malflt_1.expclsflg, malflt_1.cmpcod, malflt_1.fltnum, malflt_1.fltcaridr, malflt_1.fltseqnum, uldseg_1.cmpcod, uldseg_1.fltcaridr, uldseg_1.fltnum, uldseg_1.fltseqnum, uldseg_1.segsernum, uldseg_1.uldnum
  • Join Filter: (((fltleg_1.cmpcod)::text = (dwsmst_1.cmpcod)::text) AND (fltleg_1.fltcaridr = dwsmst_1.fltcaridr) AND ((fltleg_1.legorg)::text = (dwsmst_1.arpcod)::text) AND ((fltleg_1.fltnum)::text = (dwsmst_1.fltnum)::text) AND (fltleg_1.fltseqnum = dwsmst_1.fltseqnum) AND (fltleg_1.legsernum = dwsmst_1.legsernum))
  • Buffers: shared hit=1765
51. 0.104 12.730 ↓ 0.0 0 1

Nested Loop (cost=83.16..1,970.80 rows=1 width=170) (actual time=12.730..12.730 rows=0 loops=1)

  • Output: fltmst_1.cmpcod, fltmst_1.fltcaridr, fltmst_1.fltnum, fltmst_1.fltseqnum, fltmst_1.fltdat, fltmst_1.fltrou, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.flttyp, fltmst_1.fltsta, fltleg_1.acrtyp, fltleg_1.legorg, fltleg_1.depgte, fltleg_1.atd, fltleg_1.etd, fltleg_1.std, fltleg_1.arvgte, fltleg_1.cmpcod, fltleg_1.fltnum, fltleg_1.fltcaridr, fltleg_1.fltseqnum, fltleg_1.legsernum, malflt_1.arpcod, malflt_1.legsernum, malflt_1.expclsflg, malflt_1.cmpcod, malflt_1.fltnum, malflt_1.fltcaridr, malflt_1.fltseqnum, uldseg_1.cmpcod, uldseg_1.fltcaridr, uldseg_1.fltnum, uldseg_1.fltseqnum, uldseg_1.segsernum, uldseg_1.uldnum
  • Inner Unique: true
  • Join Filter: (malflt_1.legsernum = fltleg_1.legsernum)
  • Buffers: shared hit=1765
52. 0.162 11.666 ↓ 120.0 120 1

Nested Loop (cost=82.73..1,970.08 rows=1 width=109) (actual time=0.690..11.666 rows=120 loops=1)

  • Output: fltmst_1.cmpcod, fltmst_1.fltcaridr, fltmst_1.fltnum, fltmst_1.fltseqnum, fltmst_1.fltdat, fltmst_1.fltrou, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.flttyp, fltmst_1.fltsta, malflt_1.arpcod, malflt_1.legsernum, malflt_1.expclsflg, malflt_1.cmpcod, malflt_1.fltnum, malflt_1.fltcaridr, malflt_1.fltseqnum, uldseg_1.cmpcod, uldseg_1.fltcaridr, uldseg_1.fltnum, uldseg_1.fltseqnum, uldseg_1.segsernum, uldseg_1.uldnum
  • Inner Unique: true
  • Join Filter: (((malflt_1.fltnum)::text = (fltmst_1.fltnum)::text) AND (malflt_1.fltseqnum = fltmst_1.fltseqnum))
  • Buffers: shared hit=1310
53. 0.169 10.664 ↓ 120.0 120 1

Hash Join (cost=82.30..1,961.80 rows=1 width=61) (actual time=0.659..10.664 rows=120 loops=1)

  • Output: malflt_1.arpcod, malflt_1.legsernum, malflt_1.expclsflg, malflt_1.cmpcod, malflt_1.fltnum, malflt_1.fltcaridr, malflt_1.fltseqnum, uldseg_1.cmpcod, uldseg_1.fltcaridr, uldseg_1.fltnum, uldseg_1.fltseqnum, uldseg_1.segsernum, uldseg_1.uldnum
  • Hash Cond: (((malflt_1.fltnum)::text = (uldseg_1.fltnum)::text) AND (malflt_1.fltseqnum = uldseg_1.fltseqnum))
  • Buffers: shared hit=830
54. 9.872 9.872 ↓ 1.0 411 1

Seq Scan on icopgmapp.malflt malflt_1 (cost=0.00..1,846.76 rows=409 width=28) (actual time=0.006..9.872 rows=411 loops=1)

  • Output: malflt_1.cmpcod, malflt_1.arpcod, malflt_1.fltcaridr, malflt_1.fltnum, malflt_1.fltseqnum, malflt_1.legsernum, malflt_1.expclsflg, malflt_1.impclsflg, malflt_1.fltdat, malflt_1.fltcarcod, malflt_1.lstupdtim, malflt_1.lstupdusr, malflt_1.flnaccsta, malflt_1.prgclsdat, malflt_1.tagidx
  • Filter: (((malflt_1.cmpcod)::text = 'AA'::text) AND (malflt_1.fltcaridr = '1001'::numeric) AND ((malflt_1.arpcod)::text = 'DFW'::text))
  • Rows Removed by Filter: 59461
  • Buffers: shared hit=799
55. 0.202 0.623 ↑ 1.0 766 1

Hash (cost=70.72..70.72 rows=772 width=33) (actual time=0.623..0.623 rows=766 loops=1)

  • Output: uldseg_1.cmpcod, uldseg_1.fltcaridr, uldseg_1.fltnum, uldseg_1.fltseqnum, uldseg_1.segsernum, uldseg_1.uldnum
  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
  • Buffers: shared hit=31
56. 0.421 0.421 ↑ 1.0 766 1

Seq Scan on icopgmapp.maluldseg uldseg_1 (cost=0.00..70.72 rows=772 width=33) (actual time=0.004..0.421 rows=766 loops=1)

  • Output: uldseg_1.cmpcod, uldseg_1.fltcaridr, uldseg_1.fltnum, uldseg_1.fltseqnum, uldseg_1.segsernum, uldseg_1.uldnum
  • Filter: (((uldseg_1.uldnum)::text ~~ '%BULK-%'::text) AND ((uldseg_1.cmpcod)::text = 'AA'::text) AND (uldseg_1.fltcaridr = '1001'::numeric))
  • Rows Removed by Filter: 1504
  • Buffers: shared hit=31
57. 0.840 0.840 ↑ 1.0 1 120

Index Scan using fltoprmst_pk on icopgmapp.fltoprmst fltmst_1 (cost=0.43..8.27 rows=1 width=48) (actual time=0.007..0.007 rows=1 loops=120)

  • Output: fltmst_1.fltseqnum, fltmst_1.fltnum, fltmst_1.fltcaridr, fltmst_1.cmpcod, fltmst_1.fltrou, fltmst_1.schtyp, fltmst_1.flttyp, fltmst_1.fltown, fltmst_1.crtusr, fltmst_1.crttim, fltmst_1.fltsta, fltmst_1.domfltflg, fltmst_1.fltmod, fltmst_1.fltrmk, fltmst_1.dayopr, fltmst_1.fltorg, fltmst_1.fltdst, fltmst_1.fltrstidr, fltmst_1.lstupdusr, fltmst_1.lstupdtim, fltmst_1.locstn, fltmst_1.fltdat, fltmst_1.ovrsegcap, fltmst_1.crtstn, fltmst_1.ffrwgtlmt, fltmst_1.mincontim, fltmst_1.hasfrsrst, fltmst_1.isstbd, fltmst_1.natlty, fltmst_1.ncsfltcaridr, fltmst_1.ncsfltnum, fltmst_1.ncsfltdat, fltmst_1.blgarl, fltmst_1.oinfltflg, fltmst_1.atbfltflg, fltmst_1.dmyarlflg, fltmst_1.ncscarcod, fltmst_1.extncscarcod, fltmst_1.extncsfltcaridr, fltmst_1.extncsfltnum, fltmst_1.extncsfltdat, fltmst_1.fltcatgry, fltmst_1.prgclsdat, fltmst_1.isfctlmod, fltmst_1.isschtmod, fltmst_1.acrchgflg, fltmst_1.fltsrc, fltmst_1.eqpchgflg, fltmst_1.legcnlrmk, fltmst_1.ofrdspind, fltmst_1.ofrdsptyp, fltmst_1.usrofrdsp, fltmst_1.ctroff, fltmst_1.tagidx, fltmst_1.agrtyp, fltmst_1.trktyp, fltmst_1.trkvndcod
  • Index Cond: (((fltmst_1.fltnum)::text = (uldseg_1.fltnum)::text) AND (fltmst_1.fltcaridr = '1001'::numeric) AND (fltmst_1.fltseqnum = uldseg_1.fltseqnum) AND ((fltmst_1.cmpcod)::text = 'AA'::text))
  • Filter: ((fltmst_1.fltsta)::text <> 'CAN'::text)
  • Buffers: shared hit=480
58. 0.960 0.960 ↓ 0.0 0 120

Index Scan using fltoprleg_ind5 on icopgmapp.fltoprleg fltleg_1 (cost=0.43..0.70 rows=1 width=61) (actual time=0.008..0.008 rows=0 loops=120)

  • Output: fltleg_1.legsernum, fltleg_1.fltseqnum, fltleg_1.fltnum, fltleg_1.fltcaridr, fltleg_1.cmpcod, fltleg_1.legorg, fltleg_1.legdst, fltleg_1.sta, fltleg_1.eta, fltleg_1.ata, fltleg_1.std, fltleg_1.etd, fltleg_1.atd, fltleg_1.stautc, fltleg_1.stdutc, fltleg_1.legsta, fltleg_1.acrtyp, fltleg_1.talnum, fltleg_1.fulwgt, fltleg_1.capidr, fltleg_1.mvtsta, fltleg_1.delflg, fltleg_1.cnlflg, fltleg_1.divflg, fltleg_1.tchflg, fltleg_1.ovrflg, fltleg_1.lstataupdusr, fltleg_1.lstatdupdusr, fltleg_1.mvtarrflg, fltleg_1.mvtdepflg, fltleg_1.prvtalnum, fltleg_1.dlycod, fltleg_1.legrmk, fltleg_1.atdutc, fltleg_1.atautc, fltleg_1.sptnum, fltleg_1.oprsta, fltleg_1.depgte, fltleg_1.arvgte, fltleg_1.deppos, fltleg_1.arvpos, fltleg_1.extdlycod, fltleg_1.subdlycod, fltleg_1.nxtinftim, fltleg_1.cstseanum, fltleg_1.capcfgnam, fltleg_1.trfrstnot, fltleg_1.atadsprqdflg, fltleg_1.timmod, fltleg_1.expcapsta, fltleg_1.sertyp, fltleg_1.prvacrtyp, fltleg_1.airbrntim, fltleg_1.tchdwntim, fltleg_1.oprfltcarcod, fltleg_1.tagidx, fltleg_1.depter, fltleg_1.arvter, fltleg_1.acrowr
  • Index Cond: ((fltleg_1.fltcaridr = '1001'::numeric) AND ((fltleg_1.fltnum)::text = (fltmst_1.fltnum)::text) AND (fltleg_1.fltseqnum = fltmst_1.fltseqnum) AND ((fltleg_1.legorg)::text = 'DFW'::text))
  • Filter: (((fltleg_1.cmpcod)::text = 'AA'::text) AND ((date_trunc('day'::text, fltleg_1.std))::date >= '2019-02-01'::date) AND ((date_trunc('day'::text, fltleg_1.std))::date <= '2020-02-01'::date))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=455
59. 0.000 0.000 ↓ 0.0 0

Seq Scan on icopgmapp.oprdwsmst dwsmst_1 (cost=0.00..10.53 rows=1 width=680) (never executed)

  • Output: dwsmst_1.cmpcod, dwsmst_1.arpcod, dwsmst_1.fltcaridr, dwsmst_1.fltnum, dwsmst_1.fltseqnum, dwsmst_1.legsernum, dwsmst_1.prtdat, dwsmst_1.estblkwgt, dwsmst_1.estuldwgt, dwsmst_1.estdtl, dwsmst_1.lstupdusr, dwsmst_1.lstupdtim, dwsmst_1.dwsrmk, dwsmst_1.estblkvol, dwsmst_1.dwssta, dwsmst_1.dcssta, dwsmst_1.dcsrejrsn, dwsmst_1.tagidx, dwsmst_1.dcsfrcsta, dwsmst_1.dcsfrcrejrsn
  • Filter: (((dwsmst_1.cmpcod)::text = 'AA'::text) AND (dwsmst_1.fltcaridr = '1001'::numeric) AND ((dwsmst_1.arpcod)::text = 'DFW'::text))
60. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..7,777.19 rows=1 width=43) (never executed)

  • Output: segdtl_1.cmpcod, segdtl_1.fltcaridr, segdtl_1.fltnum, segdtl_1.fltseqnum, segdtl_1.segsernum, segdtl_1.uldnum, malmst_1.wgt, malmst_1.malseqnum
61. 0.000 0.000 ↓ 0.0 0

Index Only Scan using maluldsegdtl_pk on icopgmapp.maluldsegdtl segdtl_1 (cost=0.42..3.35 rows=1 width=39) (never executed)

  • Output: segdtl_1.cmpcod, segdtl_1.fltcaridr, segdtl_1.fltnum, segdtl_1.fltseqnum, segdtl_1.segsernum, segdtl_1.uldnum, segdtl_1.malseqnum
  • Index Cond: ((segdtl_1.cmpcod = (uldseg_1.cmpcod)::text) AND (segdtl_1.cmpcod = 'AA'::text) AND (segdtl_1.fltcaridr = uldseg_1.fltcaridr) AND (segdtl_1.fltcaridr = '1001'::numeric) AND (segdtl_1.fltnum = (uldseg_1.fltnum)::text) AND (segdtl_1.fltseqnum = uldseg_1.fltseqnum) AND (segdtl_1.segsernum = uldseg_1.segsernum) AND (segdtl_1.uldnum = (uldseg_1.uldnum)::text))
  • Heap Fetches: 0
62. 0.000 0.000 ↓ 0.0 0

Index Scan using malmst_ind8 on icopgmapp.malmst malmst_1 (cost=0.42..7,773.83 rows=1 width=14) (never executed)

  • Output: malmst_1.wgt, malmst_1.malseqnum, malmst_1.cmpcod
  • Index Cond: (((segdtl_1.cmpcod)::text = (malmst_1.cmpcod)::text) AND ((malmst_1.cmpcod)::text = 'AA'::text))
  • Filter: (segdtl_1.malseqnum = malmst_1.malseqnum)
63. 0.000 0.000 ↓ 0.0 0

Hash (cost=191.33..191.33 rows=411 width=40) (never executed)

  • Output: fltcon_1.connum, fltcon_1.cmpcod, fltcon_1.asgprt, fltcon_1.fltcaridr, fltcon_1.fltnum, fltcon_1.fltseqnum, fltcon_1.legsernum, fltcon_1.segsernum
64. 0.000 0.000 ↓ 0.0 0

Seq Scan on icopgmapp.malfltcon fltcon_1 (cost=0.00..191.33 rows=411 width=40) (never executed)

  • Output: fltcon_1.connum, fltcon_1.cmpcod, fltcon_1.asgprt, fltcon_1.fltcaridr, fltcon_1.fltnum, fltcon_1.fltseqnum, fltcon_1.legsernum, fltcon_1.segsernum
  • Filter: (((fltcon_1.cmpcod)::text = 'AA'::text) AND (fltcon_1.fltcaridr = '1001'::numeric) AND ((fltcon_1.asgprt)::text = 'DFW'::text) AND ((fltcon_1.contyp)::text = 'B'::text) AND ((fltcon_1.acpflg)::text = 'Y'::text))
65. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.03..0.03 rows=1 width=120) (never executed)

  • Output: preadv_1.rcpwgt, preadv_1.rcpidrcnt, preadv_1.cmpcod, preadv_1.fltcaridr, preadv_1.fltnum, preadv_1.fltseqnum
66. 0.000 0.000 ↓ 0.0 0

CTE Scan on preadvsmy preadv_1 (cost=0.00..0.03 rows=1 width=120) (never executed)

  • Output: preadv_1.rcpwgt, preadv_1.rcpidrcnt, preadv_1.cmpcod, preadv_1.fltcaridr, preadv_1.fltnum, preadv_1.fltseqnum
  • Filter: (((preadv_1.cmpcod)::text = 'AA'::text) AND (preadv_1.fltcaridr = '1001'::numeric))
67. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fltoprseg_pk on icopgmapp.fltoprseg fltseg_1 (cost=0.43..0.51 rows=1 width=18) (never executed)

  • Output: fltseg_1.fltnum, fltseg_1.fltcaridr, fltseg_1.fltseqnum, fltseg_1.segsernum, fltseg_1.cmpcod
  • Index Cond: ((fltseg_1.fltnum = (fltmst_1.fltnum)::text) AND (fltseg_1.fltcaridr = fltmst_1.fltcaridr) AND (fltseg_1.fltcaridr = '1001'::numeric) AND (fltseg_1.fltseqnum = fltmst_1.fltseqnum) AND (fltseg_1.cmpcod = (fltmst_1.cmpcod)::text) AND (fltseg_1.cmpcod = 'AA'::text))
  • Heap Fetches: 0
68. 78.723 890.304 ↓ 954.2 227,092 1

Subquery Scan on *SELECT* 3 (cost=8,109.35..60,124.38 rows=238 width=375) (actual time=38.285..890.304 rows=227,092 loops=1)

  • Output: "*SELECT* 3".cmpcod, "*SELECT* 3".legorg, "*SELECT* 3".fltcaridr, "*SELECT* 3".fltnum, "*SELECT* 3".fltseqnum, "*SELECT* 3".fltdat, "*SELECT* 3".legsernum, "*SELECT* 3".fltrou, "*SELECT* 3".fltorg, "*SELECT* 3".fltdst, "*SELECT* 3".flttyp, "*SELECT* 3".fltsta, "*SELECT* 3".acrtyp, "*SELECT* 3".legorg_1, "*SELECT* 3".expclsflg, "*SELECT* 3".depgte, "*SELECT* 3".fltdatprefix, "*SELECT* 3".deptim, "*SELECT* 3".arvgte, ''::character varying, ''::character varying, 0, 0, 0, 0, "*SELECT* 3".dcssta, "*SELECT* 3".dcsrejrsn
  • Buffers: shared hit=1121462
69. 100.356 811.581 ↓ 954.2 227,092 1

Hash Left Join (cost=8,109.35..60,119.62 rows=238 width=787) (actual time=38.281..811.581 rows=227,092 loops=1)

  • Output: fltmst_2.cmpcod, fltleg_2.legorg, fltmst_2.fltcaridr, fltmst_2.fltnum, fltmst_2.fltseqnum, fltmst_2.fltdat, fltleg_2.legsernum, fltmst_2.fltrou, fltmst_2.fltorg, fltmst_2.fltdst, fltmst_2.flttyp, fltmst_2.fltsta, fltleg_2.acrtyp, fltleg_2.legorg, COALESCE(malflt_2.expclsflg, 'N'::character varying), fltleg_2.depgte, CASE WHEN (fltleg_2.atd IS NOT NULL) THEN 'A'::text ELSE CASE WHEN (fltleg_2.etd IS NOT NULL) THEN 'E'::text ELSE CASE WHEN (fltleg_2.std IS NOT NULL) THEN 'S'::text ELSE ''::text END END END, COALESCE(fltleg_2.atd, fltleg_2.etd, fltleg_2.std), fltleg_2.arvgte, ''::character varying, ''::character varying, 0, 0, 0, 0, dwsmst_2.dcssta, dwsmst_2.dcsrejrsn
  • Hash Cond: ((fltleg_2.fltcaridr = malflt_2.fltcaridr) AND ((fltleg_2.legorg)::text = (malflt_2.arpcod)::text) AND ((fltleg_2.fltnum)::text = (malflt_2.fltnum)::text) AND (fltleg_2.fltseqnum = malflt_2.fltseqnum) AND (fltleg_2.legsernum = malflt_2.legsernum))
  • Buffers: shared hit=1121462
70. 88.012 698.885 ↓ 954.2 227,092 1

Hash Anti Join (cost=6,403.06..58,347.87 rows=238 width=670) (actual time=25.904..698.885 rows=227,092 loops=1)

  • Output: fltmst_2.cmpcod, fltmst_2.fltcaridr, fltmst_2.fltnum, fltmst_2.fltseqnum, fltmst_2.fltdat, fltmst_2.fltrou, fltmst_2.fltorg, fltmst_2.fltdst, fltmst_2.flttyp, fltmst_2.fltsta, fltleg_2.legorg, fltleg_2.legsernum, fltleg_2.acrtyp, fltleg_2.depgte, fltleg_2.atd, fltleg_2.etd, fltleg_2.std, fltleg_2.arvgte, fltleg_2.fltnum, fltleg_2.fltcaridr, fltleg_2.fltseqnum, dwsmst_2.dcssta, dwsmst_2.dcsrejrsn
  • Hash Cond: (((fltleg_2.cmpcod)::text = (fltcon_2.cmpcod)::text) AND ((fltleg_2.legorg)::text = (fltcon_2.asgprt)::text) AND (fltleg_2.fltcaridr = fltcon_2.fltcaridr) AND ((fltleg_2.fltnum)::text = (fltcon_2.fltnum)::text) AND (fltleg_2.fltseqnum = fltcon_2.fltseqnum))
  • Buffers: shared hit=1120663
71. 125.423 609.264 ↓ 930.7 227,092 1

Hash Left Join (cost=6,207.81..58,138.98 rows=244 width=673) (actual time=24.273..609.264 rows=227,092 loops=1)

  • Output: fltmst_2.cmpcod, fltmst_2.fltcaridr, fltmst_2.fltnum, fltmst_2.fltseqnum, fltmst_2.fltdat, fltmst_2.fltrou, fltmst_2.fltorg, fltmst_2.fltdst, fltmst_2.flttyp, fltmst_2.fltsta, fltleg_2.legorg, fltleg_2.legsernum, fltleg_2.acrtyp, fltleg_2.depgte, fltleg_2.atd, fltleg_2.etd, fltleg_2.std, fltleg_2.arvgte, fltleg_2.cmpcod, fltleg_2.fltnum, fltleg_2.fltcaridr, fltleg_2.fltseqnum, dwsmst_2.dcssta, dwsmst_2.dcsrejrsn
  • Hash Cond: (((fltleg_2.cmpcod)::text = (dwsmst_2.cmpcod)::text) AND (fltleg_2.fltcaridr = dwsmst_2.fltcaridr) AND ((fltleg_2.legorg)::text = (dwsmst_2.arpcod)::text) AND ((fltleg_2.fltnum)::text = (dwsmst_2.fltnum)::text) AND (fltleg_2.fltseqnum = dwsmst_2.fltseqnum) AND (fltleg_2.legsernum = dwsmst_2.legsernum))
  • Buffers: shared hit=1120567
72. 0.000 483.838 ↓ 930.7 227,092 1

Gather (cost=6,197.26..58,122.93 rows=244 width=109) (actual time=24.239..483.838 rows=227,092 loops=1)

  • Output: fltmst_2.cmpcod, fltmst_2.fltcaridr, fltmst_2.fltnum, fltmst_2.fltseqnum, fltmst_2.fltdat, fltmst_2.fltrou, fltmst_2.fltorg, fltmst_2.fltdst, fltmst_2.flttyp, fltmst_2.fltsta, fltleg_2.legorg, fltleg_2.legsernum, fltleg_2.acrtyp, fltleg_2.depgte, fltleg_2.atd, fltleg_2.etd, fltleg_2.std, fltleg_2.arvgte, fltleg_2.cmpcod, fltleg_2.fltnum, fltleg_2.fltcaridr, fltleg_2.fltseqnum
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1120567
73. 49.911 807.444 ↓ 742.1 75,697 3 / 3

Nested Loop Left Join (cost=5,197.26..57,098.53 rows=102 width=109) (actual time=19.034..807.444 rows=75,697 loops=3)

  • Output: fltmst_2.cmpcod, fltmst_2.fltcaridr, fltmst_2.fltnum, fltmst_2.fltseqnum, fltmst_2.fltdat, fltmst_2.fltrou, fltmst_2.fltorg, fltmst_2.fltdst, fltmst_2.flttyp, fltmst_2.fltsta, fltleg_2.legorg, fltleg_2.legsernum, fltleg_2.acrtyp, fltleg_2.depgte, fltleg_2.atd, fltleg_2.etd, fltleg_2.std, fltleg_2.arvgte, fltleg_2.cmpcod, fltleg_2.fltnum, fltleg_2.fltcaridr, fltleg_2.fltseqnum
  • Buffers: shared hit=1120567
  • Worker 0: actual time=16.729..1000.355 rows=95309 loops=1
  • Buffers: shared hit=469158
  • Worker 1: actual time=17.352..995.632 rows=95736 loops=1
  • Buffers: shared hit=470574
74. 63.711 451.081 ↓ 500.7 51,075 3 / 3

Nested Loop (cost=5,196.83..57,045.48 rows=102 width=109) (actual time=18.989..451.081 rows=51,075 loops=3)

  • Output: fltmst_2.cmpcod, fltmst_2.fltcaridr, fltmst_2.fltnum, fltmst_2.fltseqnum, fltmst_2.fltdat, fltmst_2.fltrou, fltmst_2.fltorg, fltmst_2.fltdst, fltmst_2.flttyp, fltmst_2.fltsta, fltleg_2.legorg, fltleg_2.legsernum, fltleg_2.acrtyp, fltleg_2.depgte, fltleg_2.atd, fltleg_2.etd, fltleg_2.std, fltleg_2.arvgte, fltleg_2.cmpcod, fltleg_2.fltnum, fltleg_2.fltcaridr, fltleg_2.fltseqnum
  • Inner Unique: true
  • Buffers: shared hit=656091
  • Worker 0: actual time=16.680..553.165 rows=64293 loops=1
  • Buffers: shared hit=274235
  • Worker 1: actual time=17.300..552.009 rows=64384 loops=1
  • Buffers: shared hit=275458
75. 71.489 77.114 ↓ 177.1 51,709 3 / 3

Parallel Bitmap Heap Scan on icopgmapp.fltoprleg fltleg_2 (cost=5,196.41..54,623.27 rows=292 width=61) (actual time=18.949..77.114 rows=51,709 loops=3)

  • Output: fltleg_2.legsernum, fltleg_2.fltseqnum, fltleg_2.fltnum, fltleg_2.fltcaridr, fltleg_2.cmpcod, fltleg_2.legorg, fltleg_2.legdst, fltleg_2.sta, fltleg_2.eta, fltleg_2.ata, fltleg_2.std, fltleg_2.etd, fltleg_2.atd, fltleg_2.stautc, fltleg_2.stdutc, fltleg_2.legsta, fltleg_2.acrtyp, fltleg_2.talnum, fltleg_2.fulwgt, fltleg_2.capidr, fltleg_2.mvtsta, fltleg_2.delflg, fltleg_2.cnlflg, fltleg_2.divflg, fltleg_2.tchflg, fltleg_2.ovrflg, fltleg_2.lstataupdusr, fltleg_2.lstatdupdusr, fltleg_2.mvtarrflg, fltleg_2.mvtdepflg, fltleg_2.prvtalnum, fltleg_2.dlycod, fltleg_2.legrmk, fltleg_2.atdutc, fltleg_2.atautc, fltleg_2.sptnum, fltleg_2.oprsta, fltleg_2.depgte, fltleg_2.arvgte, fltleg_2.deppos, fltleg_2.arvpos, fltleg_2.extdlycod, fltleg_2.subdlycod, fltleg_2.nxtinftim, fltleg_2.cstseanum, fltleg_2.capcfgnam, fltleg_2.trfrstnot, fltleg_2.atadsprqdflg, fltleg_2.timmod, fltleg_2.expcapsta, fltleg_2.sertyp, fltleg_2.prvacrtyp, fltleg_2.airbrntim, fltleg_2.tchdwntim, fltleg_2.oprfltcarcod, fltleg_2.tagidx, fltleg_2.depter, fltleg_2.arvter, fltleg_2.acrowr
  • Recheck Cond: ((fltleg_2.legorg)::text = 'DFW'::text)
  • Filter: (((fltleg_2.cmpcod)::text = 'AA'::text) AND (fltleg_2.fltcaridr = '1001'::numeric) AND ((date_trunc('day'::text, fltleg_2.std))::date >= '2019-02-01'::date) AND ((date_trunc('day'::text, fltleg_2.std))::date <= '2020-02-01'::date))
  • Rows Removed by Filter: 9940
  • Heap Blocks: exact=5790
  • Buffers: shared hit=34475
  • Worker 0: actual time=16.643..86.761 rows=64988 loops=1
  • Buffers: shared hit=13738
  • Worker 1: actual time=17.261..87.077 rows=65254 loops=1
  • Buffers: shared hit=14017
76. 5.625 5.625 ↓ 1.0 184,947 1 / 3

Bitmap Index Scan on fltoprleg_ind1 (cost=0.00..5,196.23 rows=182,907 width=0) (actual time=16.875..16.875 rows=184,947 loops=1)

  • Index Cond: ((fltleg_2.legorg)::text = 'DFW'::text)
  • Buffers: shared hit=930
77. 310.256 310.256 ↑ 1.0 1 155,128 / 3

Index Scan using fltoprmst_pk on icopgmapp.fltoprmst fltmst_2 (cost=0.43..8.30 rows=1 width=48) (actual time=0.006..0.006 rows=1 loops=155,128)

  • Output: fltmst_2.fltseqnum, fltmst_2.fltnum, fltmst_2.fltcaridr, fltmst_2.cmpcod, fltmst_2.fltrou, fltmst_2.schtyp, fltmst_2.flttyp, fltmst_2.fltown, fltmst_2.crtusr, fltmst_2.crttim, fltmst_2.fltsta, fltmst_2.domfltflg, fltmst_2.fltmod, fltmst_2.fltrmk, fltmst_2.dayopr, fltmst_2.fltorg, fltmst_2.fltdst, fltmst_2.fltrstidr, fltmst_2.lstupdusr, fltmst_2.lstupdtim, fltmst_2.locstn, fltmst_2.fltdat, fltmst_2.ovrsegcap, fltmst_2.crtstn, fltmst_2.ffrwgtlmt, fltmst_2.mincontim, fltmst_2.hasfrsrst, fltmst_2.isstbd, fltmst_2.natlty, fltmst_2.ncsfltcaridr, fltmst_2.ncsfltnum, fltmst_2.ncsfltdat, fltmst_2.blgarl, fltmst_2.oinfltflg, fltmst_2.atbfltflg, fltmst_2.dmyarlflg, fltmst_2.ncscarcod, fltmst_2.extncscarcod, fltmst_2.extncsfltcaridr, fltmst_2.extncsfltnum, fltmst_2.extncsfltdat, fltmst_2.fltcatgry, fltmst_2.prgclsdat, fltmst_2.isfctlmod, fltmst_2.isschtmod, fltmst_2.acrchgflg, fltmst_2.fltsrc, fltmst_2.eqpchgflg, fltmst_2.legcnlrmk, fltmst_2.ofrdspind, fltmst_2.ofrdsptyp, fltmst_2.usrofrdsp, fltmst_2.ctroff, fltmst_2.tagidx, fltmst_2.agrtyp, fltmst_2.trktyp, fltmst_2.trkvndcod
  • Index Cond: (((fltmst_2.fltnum)::text = (fltleg_2.fltnum)::text) AND (fltmst_2.fltcaridr = '1001'::numeric) AND (fltmst_2.fltseqnum = fltleg_2.fltseqnum) AND ((fltmst_2.cmpcod)::text = 'AA'::text))
  • Filter: ((fltmst_2.fltsta)::text <> 'CAN'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=621616
  • Worker 0: actual time=0.006..0.006 rows=1 loops=64988
  • Buffers: shared hit=260497
  • Worker 1: actual time=0.006..0.006 rows=1 loops=65254
  • Buffers: shared hit=261441
78. 306.452 306.452 ↑ 1.0 1 153,226 / 3

Index Only Scan using fltoprseg_pk on icopgmapp.fltoprseg fltseg_2 (cost=0.43..0.51 rows=1 width=18) (actual time=0.006..0.006 rows=1 loops=153,226)

  • Output: fltseg_2.fltnum, fltseg_2.fltcaridr, fltseg_2.fltseqnum, fltseg_2.segsernum, fltseg_2.cmpcod
  • Index Cond: ((fltseg_2.fltnum = (fltmst_2.fltnum)::text) AND (fltseg_2.fltcaridr = fltmst_2.fltcaridr) AND (fltseg_2.fltcaridr = '1001'::numeric) AND (fltseg_2.fltseqnum = fltmst_2.fltseqnum) AND (fltseg_2.cmpcod = (fltmst_2.cmpcod)::text) AND (fltseg_2.cmpcod = 'AA'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=464476
  • Worker 0: actual time=0.006..0.006 rows=1 loops=64293
  • Buffers: shared hit=194923
  • Worker 1: actual time=0.006..0.006 rows=1 loops=64384
  • Buffers: shared hit=195116
79. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=10.53..10.53 rows=1 width=680) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: dwsmst_2.dcssta, dwsmst_2.dcsrejrsn, dwsmst_2.cmpcod, dwsmst_2.fltnum, dwsmst_2.fltcaridr, dwsmst_2.fltseqnum, dwsmst_2.legsernum, dwsmst_2.arpcod
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
80. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on icopgmapp.oprdwsmst dwsmst_2 (cost=0.00..10.53 rows=1 width=680) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: dwsmst_2.dcssta, dwsmst_2.dcsrejrsn, dwsmst_2.cmpcod, dwsmst_2.fltnum, dwsmst_2.fltcaridr, dwsmst_2.fltseqnum, dwsmst_2.legsernum, dwsmst_2.arpcod
  • Filter: (((dwsmst_2.cmpcod)::text = 'AA'::text) AND (dwsmst_2.fltcaridr = '1001'::numeric) AND ((dwsmst_2.arpcod)::text = 'DFW'::text))
81. 0.278 1.609 ↓ 1.0 648 1

Hash (cost=180.74..180.74 rows=645 width=22) (actual time=1.608..1.609 rows=648 loops=1)

  • Output: fltcon_2.cmpcod, fltcon_2.asgprt, fltcon_2.fltcaridr, fltcon_2.fltnum, fltcon_2.fltseqnum
  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
  • Buffers: shared hit=96
82. 1.331 1.331 ↓ 1.0 648 1

Seq Scan on icopgmapp.malfltcon fltcon_2 (cost=0.00..180.74 rows=645 width=22) (actual time=0.006..1.331 rows=648 loops=1)

  • Output: fltcon_2.cmpcod, fltcon_2.asgprt, fltcon_2.fltcaridr, fltcon_2.fltnum, fltcon_2.fltseqnum
  • Filter: (((fltcon_2.cmpcod)::text = 'AA'::text) AND ((fltcon_2.asgprt)::text = 'DFW'::text) AND (fltcon_2.fltcaridr = '1001'::numeric) AND ((fltcon_2.acpflg)::text = 'Y'::text))
  • Rows Removed by Filter: 3589
  • Buffers: shared hit=96
83. 0.206 12.340 ↓ 1.0 411 1

Hash (cost=1,697.08..1,697.08 rows=409 width=25) (actual time=12.340..12.340 rows=411 loops=1)

  • Output: malflt_2.expclsflg, malflt_2.fltnum, malflt_2.fltcaridr, malflt_2.fltseqnum, malflt_2.arpcod, malflt_2.legsernum
  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
  • Buffers: shared hit=799
84. 12.134 12.134 ↓ 1.0 411 1

Seq Scan on icopgmapp.malflt malflt_2 (cost=0.00..1,697.08 rows=409 width=25) (actual time=0.008..12.134 rows=411 loops=1)

  • Output: malflt_2.expclsflg, malflt_2.fltnum, malflt_2.fltcaridr, malflt_2.fltseqnum, malflt_2.arpcod, malflt_2.legsernum
  • Filter: ((malflt_2.fltcaridr = '1001'::numeric) AND ((malflt_2.arpcod)::text = 'DFW'::text))
  • Rows Removed by Filter: 59461
  • Buffers: shared hit=799
Planning time : 56.345 ms
Execution time : 2,725.574 ms