drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aman Sinha <asi...@maprtech.com>
Subject Re: Help with optimizing a query
Date Tue, 11 Aug 2015 00:02:55 GMT
Parquet files of size 20GB seem too large... could you split it up into
smaller chunks ?   Drill's  Scan parallelism for Parquet is at the
granularity of files, so if you have several 256MB files you will get very
good parallelism as opposed to fewer large files.   The tradeoff is that
planning time would increase slightly since Drill has to read metadata from
many files.  However, overall the performance should improve.
For more detailed analysis, someone would have to look at the query
profile..

Aman

On Mon, Aug 10, 2015 at 3:53 PM, Sudheesh Katkam <skatkam@maprtech.com>
wrote:

> Hi Yousef,
>
> If possible, could you put the profile in a publicly accessible location
> (Dropbox, etc) and post the link here?
>
> Thank you,
> Sudheesh
>
> > On Aug 10, 2015, at 3:43 PM, Yousef Lasi <yousef.lasi@gmail.com> wrote:
> >
> > We're running a 4 file join on a set of parquet files, the largest of
> which is about 20 GB in size. The query plan seems to indicate that most,
> if not all the time for the query (>30 minutes) is spent on the first two
> major fragments. The physical plan looks like the output for these 2
> fragments below. I am not sure how to best interpret the results to
> optimize the query. It's pretty clear based on the plan output as well as
> the actual system resources utilized during execution that we are not CPU,
> Memory or I/O bound.  That doesn't leave a whole lot left to chase down.
> Any suggestions on where to look?
> >
> >
> >        00-00    Screen : rowType = RecordType(ANY ACTION, ANY
> ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY
> CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY
> DMT_FED_COST_SETT_LCL, ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY
> DMT_FED_COST_TOT_CLNT, ANY DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY
> TRD_FEDERAL_TAX_COST_LOCL, ANY SET_FEDERAL_TAX_COST_LOCL, ANY
> DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE,
> ANY DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL, ANY
> DMT_SET_FMKT_VAL_BASE, ANY DMT_TRD_LOT_LEVEL_COV_IND, ANY
> DMT_SET_LOT_LEVEL_COV_IND, ANY DMT_TRD_TRANSFER_CODE, ANY
> DMT_SET_TRANSFER_CODE, ANY DMT_TRD_WASH_SALE_ACQ_DATE, ANY
> DMT_SET_WASH_SALE_ACQ_DATE, ANY DMT_TRD_LOT_DISALLOWED_DAYS, ANY
> DMT_SET_LOT_DISALLOWED_DAYS, ANY DMT_TRD_LOT_FMKT_USAGE_IND, ANY
> DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY
> DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY
> DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY
> ID_ACC_ALT, ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY
> IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY
> TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI):
> rowcount = 4.0612884300000004E7, cumulative cost = {7.330557446299999E8
> rows, 1.5711522516974182E10 cpu, 0.0 io, 2.5162863282995203E13 network,
> 1.7235157009600002E10 memory}, id = 117134 00-01      Project(ACTION=[$0],
> ID_TRAN_COLL=[$1], ID_ACC=[$2], ID_IMNT_STD=[$3], CD_TYP_PSN=[$4],
> DT_ACQS=[$5], CD_TX_ACQS=[$6], DMT_FED_COST_ACQ_PSN=[$7], QY_SETT=[$8],
> DMT_FED_COST_SETT_LCL=[$9], DMT_UNIT_SETT_PSN=[$10], QY_TOT=[$11],
> DMT_FED_COST_TOT_CLNT=[$12], DMT_FED_COST_TOT_LCL=[$13],
> DMT_UNIT_TOT_PSN=[$14], TRD_FEDERAL_TAX_COST_LOCL=[$15],
> SET_FEDERAL_TAX_COST_LOCL=[$16], DMT_TRD_GIFT_DATE=[$17],
> DMT_TRD_FMKT_VAL_LOCL=[$18], DMT_TRD_FMKT_VAL_BASE=[$19],
> DMT_SET_GIFT_DATE=[$20], DMT_SET_FMKT_VAL_LOCL=[$21],
> DMT_SET_FMKT_VAL_BASE=[$22], DMT_TRD_LOT_LEVEL_COV_IND=[$23],
> DMT_SET_LOT_LEVEL_COV_IND=[$24], DMT_TRD_TRANSFER_CODE=[$25],
> DMT_SET_TRANSFER_CODE=[$26], DMT_TRD_WASH_SALE_ACQ_DATE=[$27],
> DMT_SET_WASH_SALE_ACQ_DATE=[$28], DMT_TRD_LOT_DISALLOWED_DAYS=[$29],
> DMT_SET_LOT_DISALLOWED_DAYS=[$30], DMT_TRD_LOT_FMKT_USAGE_IND=[$31],
> DMT_SET_LOT_FMKT_USAGE_IND=[$32], DMT_SET_UGL_ST=[$33],
> DMT_SET_UGL_ST_LCL=[$34], DMT_SET_UGL_LT=[$35], DMT_SET_UGL_LT_LCL=[$36],
> DMT_TRD_UGL_ST=[$37], DMT_TRD_UGL_ST_LCL=[$38], DMT_TRD_UGL_LT=[$39],
> DMT_TRD_UGL_LT_LCL=[$40], ID_ACC_ALT=[$41], CD_MTH_CSTNG=[$42],
> CD_CCY_TRD_PRIM=[$43], RT_SPOT=[$44], IMNT_CLSS_PRICE_FCTR_RT=[$45],
> ID_IMNT_CL=[$46], DMT_TOT_MV_PSN=[$47], TRD_INT_LOCL=[$48],
> DMT_INCM_EXPCTD=[$49], DMT_SETT_MV_PSN=[$50], CD_CL_OMNI=[$51]) : rowType =
> RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY
> CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY
> QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY
> DMT_FED_COST_TOT_CLNT, ANY DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY
> TRD_FEDERAL_TAX_COST_LOCL, ANY SET_FEDERAL_TAX_COST_LOCL, ANY
> DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE,
> ANY DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL, ANY
> DMT_SET_FMKT_VAL_BASE, ANY DMT_TRD_LOT_LEVEL_COV_IND, ANY
> DMT_SET_LOT_LEVEL_COV_IND, ANY DMT_TRD_TRANSFER_CODE, ANY
> DMT_SET_TRANSFER_CODE, ANY DMT_TRD_WASH_SALE_ACQ_DATE, ANY
> DMT_SET_WASH_SALE_ACQ_DATE, ANY DMT_TRD_LOT_DISALLOWED_DAYS, ANY
> DMT_SET_LOT_DISALLOWED_DAYS, ANY DMT_TRD_LOT_FMKT_USAGE_IND, ANY
> DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY
> DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY
> DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY
> ID_ACC_ALT, ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY
> IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY
> TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI):
> rowcount = 4.0612884300000004E7, cumulative cost = {7.289944561999999E8
> rows, 1.5707461228544182E10 cpu, 0.0 io, 2.5162863282995203E13 network,
> 1.7235157009600002E10 memory}, id = 117133 00-02
> SingleMergeExchange(sort0=[2 ASC], sort1=[3 ASC]) : rowType =
> RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY
> CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY
> QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY
> DMT_FED_COST_TOT_CLNT, ANY DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY
> TRD_FEDERAL_TAX_COST_LOCL, ANY SET_FEDERAL_TAX_COST_LOCL, ANY
> DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE,
> ANY DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL, ANY
> DMT_SET_FMKT_VAL_BASE, ANY DMT_TRD_LOT_LEVEL_COV_IND, ANY
> DMT_SET_LOT_LEVEL_COV_IND, ANY DMT_TRD_TRANSFER_CODE, ANY
> DMT_SET_TRANSFER_CODE, ANY DMT_TRD_WASH_SALE_ACQ_DATE, ANY
> DMT_SET_WASH_SALE_ACQ_DATE, ANY DMT_TRD_LOT_DISALLOWED_DAYS, ANY
> DMT_SET_LOT_DISALLOWED_DAYS, ANY DMT_TRD_LOT_FMKT_USAGE_IND, ANY
> DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY
> DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY
> DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY
> ID_ACC_ALT, ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY
> IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY
> TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI):
> rowcount = 4.0612884300000004E7, cumulative cost = {7.289944561999999E8
> rows, 1.5707461228544182E10 cpu, 0.0 io, 2.5162863282995203E13 network,
> 1.7235157009600002E10 memory}, id = 117132 01-01
> SelectionVectorRemover : rowType = RecordType(ANY ACTION, ANY ID_TRAN_COLL,
> ANY ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS,
> ANY DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY
> DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY DMT_FED_COST_TOT_CLNT, ANY
> DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY TRD_FEDERAL_TAX_COST_LOCL,
> ANY SET_FEDERAL_TAX_COST_LOCL, ANY DMT_TRD_GIFT_DATE, ANY
> DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY DMT_SET_GIFT_DATE,
> ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
> DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
> DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
> DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
> DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
> DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY
> DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY
> DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY
> DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG,
> ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY
> ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY
> DMT_SETT_MV_PSN, ANY CD_CL_OMNI): rowcount = 4.0612884300000004E7,
> cumulative cost = {6.883815719E8 rows, 1.5057655079744183E10 cpu, 0.0 io,
> 1.6512643830169602E13 network, 1.7235157009600002E10 memory}, id = 117131
> 01-02            Sort(sort0=[$2], sort1=[$3], dir0=[ASC], dir1=[ASC]) :
> rowType = RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY ID_ACC, ANY
> ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY
> DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY
> DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY DMT_FED_COST_TOT_CLNT, ANY
> DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY TRD_FEDERAL_TAX_COST_LOCL,
> ANY SET_FEDERAL_TAX_COST_LOCL, ANY DMT_TRD_GIFT_DATE, ANY
> DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY DMT_SET_GIFT_DATE,
> ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
> DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
> DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
> DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
> DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
> DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY
> DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY
> DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY
> DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG,
> ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY
> ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY
> DMT_SETT_MV_PSN, ANY CD_CL_OMNI): rowcount = 4.0612884300000004E7,
> cumulative cost = {6.477686876E8 rows, 1.5017042195444183E10 cpu, 0.0 io,
> 1.6512643830169602E13 network, 1.7235157009600002E10 memory}, id = 117130
> 01-03              Project(ACTION=[$0], ID_TRAN_COLL=[$1], ID_ACC=[$2],
> ID_IMNT_STD=[$3], CD_TYP_PSN=[$4], DT_ACQS=[$5], CD_TX_ACQS=[$6],
> DMT_FED_COST_ACQ_PSN=[$7], QY_SETT=[$8], DMT_FED_COST_SETT_LCL=[$9],
> DMT_UNIT_SETT_PSN=[$10], QY_TOT=[$11], DMT_FED_COST_TOT_CLNT=[$12],
> DMT_FED_COST_TOT_LCL=[$13], DMT_UNIT_TOT_PSN=[$14],
> TRD_FEDERAL_TAX_COST_LOCL=[$15], SET_FEDERAL_TAX_COST_LOCL=[$16],
> DMT_TRD_GIFT_DATE=[$17], DMT_TRD_FMKT_VAL_LOCL=[$18],
> DMT_TRD_FMKT_VAL_BASE=[$19], DMT_SET_GIFT_DATE=[$20],
> DMT_SET_FMKT_VAL_LOCL=[$21], DMT_SET_FMKT_VAL_BASE=[$22],
> DMT_TRD_LOT_LEVEL_COV_IND=[$23], DMT_SET_LOT_LEVEL_COV_IND=[$24],
> DMT_TRD_TRANSFER_CODE=[$25], DMT_SET_TRANSFER_CODE=[$26],
> DMT_TRD_WASH_SALE_ACQ_DATE=[$27], DMT_SET_WASH_SALE_ACQ_DATE=[$28],
> DMT_TRD_LOT_DISALLOWED_DAYS=[$29], DMT_SET_LOT_DISALLOWED_DAYS=[$30],
> DMT_TRD_LOT_FMKT_USAGE_IND=[$31], DMT_SET_LOT_FMKT_USAGE_IND=[$32],
> DMT_SET_UGL_ST=[$33], DMT_SET_UGL_ST_LCL=[$34], DMT_SET_UGL_LT=[$35],
> DMT_SET_UGL_LT_LCL=[$36], DMT_TRD_UGL_ST=[$37], DMT_TRD_UGL_ST_LCL=[$38],
> DMT_TRD_UGL_LT=[$39], DMT_TRD_UGL_LT_LCL=[$40], ID_ACC_ALT=[$41],
> CD_MTH_CSTNG=[$42], CD_CCY_TRD_PRIM=[$43], RT_SPOT=[$44],
> IMNT_CLSS_PRICE_FCTR_RT=[$45], ID_IMNT_CL=[$46], DMT_TOT_MV_PSN=[$47],
> TRD_INT_LOCL=[$48], DMT_INCM_EXPCTD=[$49], DMT_SETT_MV_PSN=[$50],
> CD_CL_OMNI=[$51]) : rowType = RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY
> ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY
> DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY
> DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY DMT_FED_COST_TOT_CLNT, ANY
> DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY TRD_FEDERAL_TAX_COST_LOCL,
> ANY SET_FEDERAL_TAX_COST_LOCL, ANY DMT_TRD_GIFT_DATE, ANY
> DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY DMT_SET_GIFT_DATE,
> ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
> DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
> DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
> DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
> DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
> DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY
> DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY
> DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY
> DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG,
> ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY
> ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY
> DMT_SETT_MV_PSN, ANY CD_CL_OMNI): rowcount = 4.0612884300000004E7,
> cumulative cost = {6.071558033000001E8 rows, 6.804975931900001E9 cpu, 0.0
> io, 1.6512643830169602E13 network, 3.4019714079999995E8 memory}, id =
> 117129 01-04                HashToRandomExchange(dist0=[[$2]],
> dist1=[[$3]]) : rowType = RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY
> ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY
> DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY
> DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY DMT_FED_COST_TOT_CLNT, ANY
> DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY TRD_FEDERAL_TAX_COST_LOCL,
> ANY SET_FEDERAL_TAX_COST_LOCL, ANY DMT_TRD_GIFT_DATE, ANY
> DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY DMT_SET_GIFT_DATE,
> ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
> DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
> DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
> DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
> DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
> DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY
> DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY
> DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY
> DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG,
> ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY
> ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY
> DMT_SETT_MV_PSN, ANY CD_CL_OMNI, ANY E_X_P_R_H_A_S_H_F_I_E_L_D): rowcount =
> 4.0612884300000004E7, cumulative cost = {6.071558033000001E8 rows,
> 6.804975931900001E9 cpu, 0.0 io, 1.6512643830169602E13 network,
> 3.4019714079999995E8 memory}, id = 117128
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message