| Attached Files |  QueryMetal [^] (24,335 bytes) 2018-09-14 13:16 [Show Content] [Hide Content]QUERY:
select financialm0_.Fact_Acct_ID as Fact1_283_, financialm0_.AD_Client_ID as AD2_283_, financialm0_.AD_Org_ID as AD3_283_, financialm0_.IsActive as IsActive283_, financialm0_.Created as Created283_, financialm0_.CreatedBy as CreatedBy283_, financialm0_.Updated as Updated283_, financialm0_.UpdatedBy as UpdatedBy283_, financialm0_.C_AcctSchema_ID as C9_283_, financialm0_.Account_ID as Account10_283_, financialm0_.DateTrx as DateTrx283_, financialm0_.DateAcct as DateAcct283_, financialm0_.C_Period_ID as C13_283_, financialm0_.AD_Table_ID as AD14_283_, financialm0_.Record_ID as Record15_283_, financialm0_.Line_ID as Line16_283_, financialm0_.GL_Category_ID as GL17_283_, financialm0_.C_Tax_ID as C18_283_, financialm0_.M_Locator_ID as M19_283_, financialm0_.PostingType as Posting20_283_, financialm0_.C_Currency_ID as C21_283_, financialm0_.AmtSourceDr as AmtSour22_283_, financialm0_.AmtSourceCr as AmtSour23_283_, financialm0_.AmtAcctDr as AmtAcctDr283_, financialm0_.AmtAcctCr as AmtAcctCr283_, financialm0_.C_UOM_ID as C26_283_, financialm0_.Qty as Qty283_, financialm0_.M_Product_ID as M28_283_, financialm0_.C_BPartner_ID as C29_283_, financialm0_.AD_OrgTrx_ID as AD30_283_, financialm0_.C_LocFrom_ID as C31_283_, financialm0_.C_LocTo_ID as C32_283_, financialm0_.C_SalesRegion_ID as C33_283_, financialm0_.C_Project_ID as C34_283_, financialm0_.C_Campaign_ID as C35_283_, financialm0_.C_Activity_ID as C36_283_, financialm0_.User1_ID as User37_283_, financialm0_.User2_ID as User38_283_, financialm0_.Description as Descrip39_283_, financialm0_.A_Asset_ID as A40_283_, financialm0_.Fact_Acct_Group_ID as Fact41_283_, financialm0_.SeqNo as SeqNo283_, financialm0_.FactAcctType as FactAcc43_283_, financialm0_.DocBaseType as DocBase44_283_, financialm0_.AcctValue as AcctValue283_, financialm0_.AcctDescription as AcctDes46_283_, financialm0_.Record_ID2 as Record47_283_, financialm0_.C_Withholding_ID as C48_283_, financialm0_.C_Doctype_ID as C49_283_, financialm0_.C_Costcenter_ID as C50_283_, financialm0_.Ismodify as Ismodify283_, financialm0_.EM_Obanaly_Accountingdate as EM52_283_, financialm0_.Datebalanced as Datebal53_283_ from Fact_Acct financialm0_ inner join C_AcctSchema financialm1_ on financialm0_.C_AcctSchema_ID=financialm1_.C_AcctSchema_ID where (financialm0_.AD_Org_ID in ('0991D9520FFA42C38564EBD0EA8B024A' , '6792C58DE9E140E6BC31AFB1E65E6849' , 'A219A22301074BBAAAE9AB8C644BB968' , 'A3CA1E38B6414BC2A84B8880E011B697' , 'CE87556545454D9C8A3CD07AA6BEA8D1' , '42A817A4371E4A338BFA8C3AE1AFB480' , 'DC6A1F6BE51D4701B89B6E474F0CD90F' , 'C14A8BDAC76A45A3829E9B9D031876CB' , '61D784C8E7B24C61864CAAC67AC3554F' , '2308192A70DD4D348A76F5EE756E7174' , 'DC1B735527F14CE19E77E5C009C5E366' , '8C3BBD20B4C2427A818C4B8470389293' , '922306674BCC473FAD20A06AAB944D88' , '3FD96D629C5143F7A60B75B7ED760638' , 'CC69EF8DA4364908A0D6425E7EB098CC' , '3614E039E40C4E31A2DFC7C0BD4B7FEA' , '2BB232DB26C04BC08B782B5DA4E3B9BE' , 'A5FAA43CBCEF45219767CAA8ECE42839' , '60B9E477D08A4713A9B6A56340A321CD' , '0' , '7456B6F6A691495DBE169C888CBB0244' , 'B3C7ADE425D74FEBB81203C8E8216B1D' , 'FE0F551746024E708616111030B08E66' , '6F4D0D374CBB44CEA8413248BBF2B33A' , 'A5D0B83599FE4523AE6E20693DDB8E47' , '90F7039C0D5841318B39577F8749E47B' , '6C01460E7CF54A06874A14A31587CAE8' , '563DAC34763E42A1B7B1EDCFFDB9B234' , '20C64AD429A74881A046E53BC02C9A5D' , '939D6FA8261F471FBB180517250CB9BC' , '3973A8F4F41F4F2F8E9193265C42E139' , '89F12C251D484AADBE87BFFF8F604914' , 'D06007F3C9C643B4B4AB8E0682D468A9' , '2A85B2F756EA492897FA0C5061D35C04' , '09490F27B4AB46B991C0EC83C1307D4E' , 'BE83983A15CB4414811FC57B6FE6F28A' , '72894B6162D142CF842D4487BB0162C7' , '03317C35E2254D78ACB9D9EC9E8104F5' , '6C8386358DD945F98C98ABEDA2AB8E7F' , '29D81519EE794098A5CDAFF15CA6098F' , '6BDD9023C50F40299E9D1A3A81FEB832' , '907A8BEEEA924C0B9B2AF9CCE05A3D0A' , 'DE264A4A83614BADA700FEDCD4EE7D5E' , '417E05FE38724189BED8C1D8C5FB2C93' , 'D9F1065A7C5048F08CA04301E67E0E5B' , '8CBDF78AE56542DE901A1E3ED194C922' , '95EE75F88FF44DD6A5D57157492F21C9' , 'DDCB61EC06FF4FAEB962CBC4D48B7909' , '56BE374725A043D7B87D9DA23E2F6DE9' , 'E9EAFA7CF88D459D9AEE55D513EDB822' , 'C40F957399FF4B3A8F6388FCF28B6454' , '44F25DA9C77E43398E5AA92CB95952AA' , 'A821508015D44F24A396C9EA02093BE3' , 'C52E1910738B440E9DBB457C072ADB6D' , '558E973E23C74BBA9A1ACE179E3EFEF5' , '42DD7668C5224C168B20C4A246B66E22' , 'B6A0813D32FB4DCB83A1D359F2820624' , '0A733B3F5292414BA2310836A3EE9B73' , 'D2710C4B3A944167B8D7BF8F65D73BB0' , '8B23357AC1C140A5B3681DE476E9E1C1' , '5A4FF223AB96497798D5362E939407EC' , '2E65C0D958C04C8384715FDF6D541AE7' , 'FBEF168D10A241878731988B448A0264' , '70C913999AB54967B7DC0BFB01E4C002' , 'BB15A59BC3E9401CA84D53C5D1A56B40' , 'B1EAF0ED1A874D16AD4E3482C921A58B' , 'D25CF3B3B85C47CD9D60E675E3933CFF' , '9F488865B7FF4341938EBA9D94204795' , 'D6BF5602516F429FB4F0EB74EDA3DAAC' , '9B219F01ED224BBEBABA20E42A31AFA2' , '33DD7E752F9E4370AAE84B7B6B1EA5AD' , '985325E1C95542EF91D2EA2CB46A2F76' , 'C8E744895CAA4777947B179C8D21A9FC' , '4838CECBBA884B67A4570606A67213B8' , 'B2FC77E916324F318AF7D7B3556CB7FF' , '3EF3718C2A4947E9A3F985D69BDEC4A5' , '0B4BE7CC6D4F4E2CA8D95EDE71A79595' , '2159F0A8F2BD429588FFC67BCACBAB4F' , 'EFEF307707644996AA9AC1A88A296911' , 'BEE95716B0944D18AF306475456462E3' , 'C7FA7097C3B4409C97D8B13EEED1B069' , '22131325E5BD4FA5AFC04E3641A9B755' , '1ECF30EE6A2443D4A206BCE16B609FA8' , '57E7013CCF4B460484B9B9200A698093' , '0FAFDDD497184B3CA0EEB03275DEE18D' , '07712865174943709ADB50F96A73999A' , 'BFCC52F39C8A4CAB848DCE603F87D92C' , '1B30D2EE13F54EEAABBFAC5E6ED30489' , '1E6D53FFAEF44E9DBCB36DBD0AC68C16' , 'AA941A639DEC47639D8AE67130C6DBEE' , 'D9FC3868FBE04D51A81D6A818D1B1D95' , '09CE37B9867B42DB8ADA553B8B5A67B4' , 'C7E037FEEE6443869FEB15649CB2C0B1' , 'CFB004560B2F4766B5CA4C4761CCDA52' , 'CF9A67BE65C34F0D83C6AD48D83C1E0D' , 'ECDCE5C7F14242D5ACF207DAF30CC88B' , '3F191018E34048B6930B6E66AC5ED4D8' , '43586046BF29433EB8D2AF01C9E1873D' , '1E70C94C51DB45B583706F1F4E29CF24' , '707EB86898AA4EFA94ADE7C100B8ACC9' , '50310F189C3C4715AC90D35B51306491' , '8FDCADB63F5A4947A802C8281B7C4438' , '428125A1CFA94E27829FF69A54D8E040' , 'AA4432DBFA9B4B31B6D2BE6DBFCFEF65' , 'ADF58EE95F0D45E398ED4EFB93DD9E92' , '28B716B99D7F4D9CADC4069129B054F1' , '6B182F61975F478FA289F0F693AFE458' , '12DC94F4334443A8B7B15323BC6350ED' , 'E02823532CBC4D8EA5F0F2EF6491D3E8' , '61B2E3DCDB6C4C6DA735BCA81FCD3E86' , '3C4DE95E065E4615AAFDAC2A68641D8D' , '9EE03C4577774E6AB578459182D8993E' , '2F8DBEFD3021470098FD7EF7C63BD3FE' , '59D693BEDC4044048AF15265274EA550' , 'C1DBB548EAB64E9FAEBAC11FD570D6F9' , '39876BCF65574B39B6305FB8A3882995' , 'E32587287FAC4B3687F89B0F9C25ACE5' , '77BBE70EB029409BBBD392BD7C2F9EAA' , '963B0C7541C643B7B04F31ED8DB80991' , 'F8B33CAD6A524A17928307E191D3590C' , '9672E37BB2CC4A7CADA1AD884DE90EAA' , '8562497BB44C418EA88F8ED19FD07C5A' , 'D458727097494E1FACBA86FC3DCC0545' , '2C9F279594CB42B49DC175E3697F5152' , '227E23479C8743D79BC5ECF86BBEB95F' , '49E28B8448664A3C9E0BE8BD808315F4' , '442CE337BA84424CB75E0840E7DC6FEA' , 'CDA79F323E3A4008942F189F81C6D5F8' , '4813E926AE9E4934B6DDB0D39184BF77' , 'DEDB67BA42F648BBA0CF63A7D6AEE861' , '94BB85E191454662B8BA35886D096D18' , '5B8139996AAB4D06B6E65A5791FD1A28' , 'A23F1B4D36564D829597135A022A45A9' , '73A080E26D2F42C4B1F488DD3EC38B82' , 'B9FC7ADC307D4D31905DAFF05D2B8E90' , '88968668C1C44980AD45594FDE0F3F20' , 'C6B1E756558F4A22A705CFFAF751AC3E' , '6E95C60751F74723803CEEEF383CEC26' , 'C1E7DFFCCB384F54A15BF528C4E2FB86' , 'D90FB41D4C8443C6A6FE6B20127BDA73' , 'F3F9BA12C87D4B8EA4B181641059E164' , '8AC658DCFB1449AC9B684302A735CA85' , '8AF2E2539A3745C0ABE0A5EB1FD12D2F' , '14480C2A728A4CF8AACDF057F1EAE262' , 'EBC004F36431451B9F739ED70019AB86' , '9771CD9DAC1A4E23A70DFF0671415760' , '439E196FECB144ED87FBF79DF5EB36EB' , '4813B23E8C644A62ACFECB2B3AC5D34D' , '6EFCCC303BA44EBA8FC377471A550A65' , '518790C0219E48CB9FEEC1D0BD7E697C' , '4F821DCD6C394454B75EDCE56734FBC5' , 'F6F2235BC12143B8B92524D00E055370' , '73F6E2A4E5C34823957AFCD756B7EF96' , '0036E1B4228E41578D4F89149DEC92EC' , 'E168567EAFF94B4793996B0AB415930B' , 'C002170F73544C6E9AAEC8DD7FBB5750' , '75C698C323A9401EBACB657B62A257B8' , '3F18481C298A4CDFA9E57669CB07114D' , '7C12BE46D17144F7ADDCA0E7C7A3FD52' , 'E21D915D816B418194476AC292E3C32E' , '24D0809B7ACB4BEEBFD742E6D3BF1004' , '90BE3361AA72408B80587E63C3C75C09' , 'CB6874561A404FF6BCD1735B597CF0E8' , 'E19C5F8E9F1D4C0BAA510681AFCA9A90' , '0BD819BF9926460C96E83F0CC608BAA7' , '726C1875F4954F96B2A61E7C5A911E9D' , '6B5C4C79B4AB425AB0DB2C20AB96EFF9' , '1AD47DB36BF74AFA80DB691D8B6E2512' , '7413EF6C99A543D8B41A09B1A016A3A8' , 'B3D3E2BE6B7749E5B152D6999C3A5B9F' , '2CCD7AB2BE564B91949B5B3AFD2F170A' , 'AFA41ACBB4814A7D88E09DB285BF7B59' , '91BDD4AAA5E04D72861F80374DA08406' , '3EE29DBB721A45DA9977D4B7BDD823B5' , '25990F5BBFAA4ADEB3CBB9DE42B5D8D9' , '911D729F29294DD9997D2083C5545614' , '664FFE8B17974ABCBE4215D77996BB16' , 'A024D7397BF5495986B8006757CC8975' , '53DCB799965E44CA9EE17153E2AA2723' , 'DB54CEA1C7EB4C18B79EB86CD1064347' , '5FA7218924DB47E9A7FC0CD320A105B5' , 'F234CEEDB08B4B2B8847A9FB1763BDB3' , '1A00200E3745429083F44BB85F7DF154' , '69FF7EBCF0154A1F92CB251BAD736E06' , '8A314FF8DEBD40C69A642B94148CC628' , '7607E70CFF5B454186A44AE75778CCC0' , '6EAB3556F5A54683BA6BE029A43B82CF' , '45A2D7039663481C8D98E568C40F6923' , 'D28B399A983448A89AEBE0B318CEB2B1' , '27FD49828F7141BA97CEA94CCC893CF3' , '646F08846D04443485383E3338CD2145' , 'A3EF2DB7E4F74EE2AA54AED92B2C2702' , '5822CDAA0B094FDB87C62786C305D006' , '8E2EB700E4F64A7FA7EEA4130567C12E' , '0FE2220CD8D74D16B9CCFD88907B44F7' , 'AA6E6D54ACC94E3DA142B1CA42C332E6')) and (financialm0_.AD_Client_ID in ('101C8C9C4A8D4C84857E3F5FBD722757' , '0')) order by financialm0_.DateAcct desc, financialm1_.Name, financialm0_.Fact_Acct_ID limit 101
QUERY PLAN:
Limit (cost=10604152.40..10604152.66 rows=101 width=1534) (actual time=661677.371..661677.396 rows=101 loops=1)
-> Sort (cost=10604152.40..10655598.05 rows=20578259 width=1534) (actual time=661677.370..661677.388 rows=101 loops=1)
Sort Key: financialm0_.dateacct DESC, financialm1_.name, financialm0_.fact_acct_id
Sort Method: top-N heapsort Memory: 127kB
-> Hash Join (cost=562186.35..9816189.11 rows=20578259 width=1534) (actual time=9380.409..642935.148 rows=28701082 loops=1)
Hash Cond: ((financialm0_.c_acctschema_id)::text = (financialm1_.c_acctschema_id)::text)
-> Bitmap Heap Scan on fact_acct financialm0_ (cost=562185.28..9533236.98 rows=20578259 width=1523) (actual time=9380.382..624852.191 rows=28701082 loops=1)
Recheck Cond: ((ad_org_id)::text = ANY ('{0991D9520FFA42C38564EBD0EA8B024A,6792C58DE9E140E6BC31AFB1E65E6849,A219A22301074BBAAAE9AB8C644BB968,A3CA1E38B6414BC2
A84B8880E011B697,CE87556545454D9C8A3CD07AA6BEA8D1,42A817A4371E4A338BFA8C3AE1AFB480,DC6A1F6BE51D4701B89B6E474F0CD90F,C14A8BDAC76A45A3829E9B9D031876CB,61D784C8E7B24C61864CAAC67AC35
54F,2308192A70DD4D348A76F5EE756E7174,DC1B735527F14CE19E77E5C009C5E366,8C3BBD20B4C2427A818C4B8470389293,922306674BCC473FAD20A06AAB944D88,3FD96D629C5143F7A60B75B7ED760638,CC69EF8DA
4364908A0D6425E7EB098CC,3614E039E40C4E31A2DFC7C0BD4B7FEA,2BB232DB26C04BC08B782B5DA4E3B9BE,A5FAA43CBCEF45219767CAA8ECE42839,60B9E477D08A4713A9B6A56340A321CD,0,7456B6F6A691495DBE16
9C888CBB0244,B3C7ADE425D74FEBB81203C8E8216B1D,FE0F551746024E708616111030B08E66,6F4D0D374CBB44CEA8413248BBF2B33A,A5D0B83599FE4523AE6E20693DDB8E47,90F7039C0D5841318B39577F8749E47B,
6C01460E7CF54A06874A14A31587CAE8,563DAC34763E42A1B7B1EDCFFDB9B234,20C64AD429A74881A046E53BC02C9A5D,939D6FA8261F471FBB180517250CB9BC,3973A8F4F41F4F2F8E9193265C42E139,89F12C251D484
AADBE87BFFF8F604914,D06007F3C9C643B4B4AB8E0682D468A9,2A85B2F756EA492897FA0C5061D35C04,09490F27B4AB46B991C0EC83C1307D4E,BE83983A15CB4414811FC57B6FE6F28A,72894B6162D142CF842D4487BB
0162C7,03317C35E2254D78ACB9D9EC9E8104F5,6C8386358DD945F98C98ABEDA2AB8E7F,29D81519EE794098A5CDAFF15CA6098F,6BDD9023C50F40299E9D1A3A81FEB832,907A8BEEEA924C0B9B2AF9CCE05A3D0A,DE264A
4A83614BADA700FEDCD4EE7D5E,417E05FE38724189BED8C1D8C5FB2C93,D9F1065A7C5048F08CA04301E67E0E5B,8CBDF78AE56542DE901A1E3ED194C922,95EE75F88FF44DD6A5D57157492F21C9,DDCB61EC06FF4FAEB96
2CBC4D48B7909,56BE374725A043D7B87D9DA23E2F6DE9,E9EAFA7CF88D459D9AEE55D513EDB822,C40F957399FF4B3A8F6388FCF28B6454,44F25DA9C77E43398E5AA92CB95952AA,A821508015D44F24A396C9EA02093BE3
,C52E1910738B440E9DBB457C072ADB6D,558E973E23C74BBA9A1ACE179E3EFEF5,42DD7668C5224C168B20C4A246B66E22,B6A0813D32FB4DCB83A1D359F2820624,0A733B3F5292414BA2310836A3EE9B73,D2710C4B3A94
4167B8D7BF8F65D73BB0,8B23357AC1C140A5B3681DE476E9E1C1,5A4FF223AB96497798D5362E939407EC,2E65C0D958C04C8384715FDF6D541AE7,FBEF168D10A241878731988B448A0264,70C913999AB54967B7DC0BFB0
1E4C002,BB15A59BC3E9401CA84D53C5D1A56B40,B1EAF0ED1A874D16AD4E3482C921A58B,D25CF3B3B85C47CD9D60E675E3933CFF,9F488865B7FF4341938EBA9D94204795,D6BF5602516F429FB4F0EB74EDA3DAAC,9B219
F01ED224BBEBABA20E42A31AFA2,33DD7E752F9E4370AAE84B7B6B1EA5AD,985325E1C95542EF91D2EA2CB46A2F76,C8E744895CAA4777947B179C8D21A9FC,4838CECBBA884B67A4570606A67213B8,B2FC77E916324F318A
F7D7B3556CB7FF,3EF3718C2A4947E9A3F985D69BDEC4A5,0B4BE7CC6D4F4E2CA8D95EDE71A79595,2159F0A8F2BD429588FFC67BCACBAB4F,EFEF307707644996AA9AC1A88A296911,BEE95716B0944D18AF306475456462E
3,C7FA7097C3B4409C97D8B13EEED1B069,22131325E5BD4FA5AFC04E3641A9B755,1ECF30EE6A2443D4A206BCE16B609FA8,57E7013CCF4B460484B9B9200A698093,0FAFDDD497184B3CA0EEB03275DEE18D,07712865174
943709ADB50F96A73999A,BFCC52F39C8A4CAB848DCE603F87D92C,1B30D2EE13F54EEAABBFAC5E6ED30489,1E6D53FFAEF44E9DBCB36DBD0AC68C16,AA941A639DEC47639D8AE67130C6DBEE,D9FC3868FBE04D51A81D6A81
8D1B1D95,09CE37B9867B42DB8ADA553B8B5A67B4,C7E037FEEE6443869FEB15649CB2C0B1,CFB004560B2F4766B5CA4C4761CCDA52,CF9A67BE65C34F0D83C6AD48D83C1E0D,ECDCE5C7F14242D5ACF207DAF30CC88B,3F19
1018E34048B6930B6E66AC5ED4D8,43586046BF29433EB8D2AF01C9E1873D,1E70C94C51DB45B583706F1F4E29CF24,707EB86898AA4EFA94ADE7C100B8ACC9,50310F189C3C4715AC90D35B51306491,8FDCADB63F5A4947A
802C8281B7C4438,428125A1CFA94E27829FF69A54D8E040,AA4432DBFA9B4B31B6D2BE6DBFCFEF65,ADF58EE95F0D45E398ED4EFB93DD9E92,28B716B99D7F4D9CADC4069129B054F1,6B182F61975F478FA289F0F693AFE4
58,12DC94F4334443A8B7B15323BC6350ED,E02823532CBC4D8EA5F0F2EF6491D3E8,61B2E3DCDB6C4C6DA735BCA81FCD3E86,3C4DE95E065E4615AAFDAC2A68641D8D,9EE03C4577774E6AB578459182D8993E,2F8DBEFD30
21470098FD7EF7C63BD3FE,59D693BEDC4044048AF15265274EA550,C1DBB548EAB64E9FAEBAC11FD570D6F9,39876BCF65574B39B6305FB8A3882995,E32587287FAC4B3687F89B0F9C25ACE5,77BBE70EB029409BBBD392B
D7C2F9EAA,963B0C7541C643B7B04F31ED8DB80991,F8B33CAD6A524A17928307E191D3590C,9672E37BB2CC4A7CADA1AD884DE90EAA,8562497BB44C418EA88F8ED19FD07C5A,D458727097494E1FACBA86FC3DCC0545,2C9
F279594CB42B49DC175E3697F5152,227E23479C8743D79BC5ECF86BBEB95F,49E28B8448664A3C9E0BE8BD808315F4,442CE337BA84424CB75E0840E7DC6FEA,CDA79F323E3A4008942F189F81C6D5F8,4813E926AE9E4934
B6DDB0D39184BF77,DEDB67BA42F648BBA0CF63A7D6AEE861,94BB85E191454662B8BA35886D096D18,5B8139996AAB4D06B6E65A5791FD1A28,A23F1B4D36564D829597135A022A45A9,73A080E26D2F42C4B1F488DD3EC38
B82,B9FC7ADC307D4D31905DAFF05D2B8E90,88968668C1C44980AD45594FDE0F3F20,C6B1E756558F4A22A705CFFAF751AC3E,6E95C60751F74723803CEEEF383CEC26,C1E7DFFCCB384F54A15BF528C4E2FB86,D90FB41D4
C8443C6A6FE6B20127BDA73,F3F9BA12C87D4B8EA4B181641059E164,8AC658DCFB1449AC9B684302A735CA85,8AF2E2539A3745C0ABE0A5EB1FD12D2F,14480C2A728A4CF8AACDF057F1EAE262,EBC004F36431451B9F739ED70019AB86,9771CD9DAC1A4E23A70DFF0671415760,439E196FECB144ED87FBF79DF5EB36EB,4813B23E8C644A62ACFECB2B3AC5D34D,6EFCCC303BA44EBA8FC377471A550A65,518790C0219E48CB9FEEC1D0BD7E697C,4F821DCD6C394454B75EDCE56734FBC5,F6F2235BC12143B8B92524D00E055370,73F6E2A4E5C34823957AFCD756B7EF96,0036E1B4228E41578D4F89149DEC92EC,E168567EAFF94B4793996B0AB415930B,C002170F73544C6E9AAEC8DD7FBB5750,75C698C323A9401EBACB657B62A257B8,3F18481C298A4CDFA9E57669CB07114D,7C12BE46D17144F7ADDCA0E7C7A3FD52,E21D915D816B418194476AC292E3C32E,24D0809B7ACB4BEEBFD742E6D3BF1004,90BE3361AA72408B80587E63C3C75C09,CB6874561A404FF6BCD1735B597CF0E8,E19C5F8E9F1D4C0BAA510681AFCA9A90,0BD819BF9926460C96E83F0CC608BAA7,726C1875F4954F96B2A61E7C5A911E9D,6B5C4C79B4AB425AB0DB2C20AB96EFF9,1AD47DB36BF74AFA80DB691D8B6E2512,7413EF6C99A543D8B41A09B1A016A3A8,B3D3E2BE6B7749E5B152D6999C3A5B9F,2CCD7AB2BE564B91949B5B3AFD2F170A,AFA41ACBB4814A7D88E09DB285BF7B59,91BDD4AAA5E04D72861F80374DA08406,3EE29DBB721A45DA9977D4B7BDD823B5,25990F5BBFAA4ADEB3CBB9DE42B5D8D9,911D729F29294DD9997D2083C5545614,664FFE8B17974ABCBE4215D77996BB16,A024D7397BF5495986B8006757CC8975,53DCB799965E44CA9EE17153E2AA2723,DB54CEA1C7EB4C18B79EB86CD1064347,5FA7218924DB47E9A7FC0CD320A105B5,F234CEEDB08B4B2B8847A9FB1763BDB3,1A00200E3745429083F44BB85F7DF154,69FF7EBCF0154A1F92CB251BAD736E06,8A314FF8DEBD40C69A642B94148CC628,7607E70CFF5B454186A44AE75778CCC0,6EAB3556F5A54683BA6BE029A43B82CF,45A2D7039663481C8D98E568C40F6923,D28B399A983448A89AEBE0B318CEB2B1,27FD49828F7141BA97CEA94CCC893CF3,646F08846D04443485383E3338CD2145,A3EF2DB7E4F74EE2AA54AED92B2C2702,5822CDAA0B094FDB87C62786C305D006,8E2EB700E4F64A7FA7EEA4130567C12E,0FE2220CD8D74D16B9CCFD88907B44F7,AA6E6D54ACC94E3DA142B1CA42C332E6}'::text[]))
Rows Removed by Index Recheck: 11
Filter: ((ad_client_id)::text = ANY ('{101C8C9C4A8D4C84857E3F5FBD722757,0}'::text[]))
Heap Blocks: exact=276438 lossy=2836687
-> Bitmap Index Scan on fact_acct_account (cost=0.00..557040.72 rows=20578259 width=0) (actual time=9284.486..9284.486 rows=30087387 loops=1)
Index Cond: ((ad_org_id)::text = ANY ('{0991D9520FFA42C38564EBD0EA8B024A,6792C58DE9E140E6BC31AFB1E65E6849,A219A22301074BBAAAE9AB8C644BB968,A3CA1E38B6414BC2A84B8880E011B697,CE87556545454D9C8A3CD07AA6BEA8D1,42A817A4371E4A338BFA8C3AE1AFB480,DC6A1F6BE51D4701B89B6E474F0CD90F,C14A8BDAC76A45A3829E9B9D031876CB,61D784C8E7B24C61864CAAC67AC3554F,2308192A70DD4D348A76F5EE756E7174,DC1B735527F14CE19E77E5C009C5E366,8C3BBD20B4C2427A818C4B8470389293,922306674BCC473FAD20A06AAB944D88,3FD96D629C5143F7A60B75B7ED760638,CC69EF8DA4364908A0D6425E7EB098CC,3614E039E40C4E31A2DFC7C0BD4B7FEA,2BB232DB26C04BC08B782B5DA4E3B9BE,A5FAA43CBCEF45219767CAA8ECE42839,60B9E477D08A4713A9B6A56340A321CD,0,7456B6F6A691495DBE169C888CBB0244,B3C7ADE425D74FEBB81203C8E8216B1D,FE0F551746024E708616111030B08E66,6F4D0D374CBB44CEA8413248BBF2B33A,A5D0B83599FE4523AE6E20693DDB8E47,90F7039C0D5841318B39577F8749E47B,6C01460E7CF54A06874A14A31587CAE8,563DAC34763E42A1B7B1EDCFFDB9B234,20C64AD429A74881A046E53BC02C9A5D,939D6FA8261F471FBB180517250CB9BC,3973A8F4F41F4F2F8E9193265C42E139,89F12C251D484AADBE87BFFF8F604914,D06007F3C9C643B4B4AB8E0682D468A9,2A85B2F756EA492897FA0C5061D35C04,09490F27B4AB46B991C0EC83C1307D4E,BE83983A15CB4414811FC57B6FE6F28A,72894B6162D142CF842D4487BB0162C7,03317C35E2254D78ACB9D9EC9E8104F5,6C8386358DD945F98C98ABEDA2AB8E7F,29D81519EE794098A5CDAFF15CA6098F,6BDD9023C50F40299E9D1A3A81FEB832,907A8BEEEA924C0B9B2AF9CCE05A3D0A,DE264A4A83614BADA700FEDCD4EE7D5E,417E05FE38724189BED8C1D8C5FB2C93,D9F1065A7C5048F08CA04301E67E0E5B,8CBDF78AE56542DE901A1E3ED194C922,95EE75F88FF44DD6A5D57157492F21C9,DDCB61EC06FF4FAEB962CBC4D48B7909,56BE374725A043D7B87D9DA23E2F6DE9,E9EAFA7CF88D459D9AEE55D513EDB822,C40F957399FF4B3A8F6388FCF28B6454,44F25DA9C77E43398E5AA92CB95952AA,A821508015D44F24A396C9EA02093BE3,C52E1910738B440E9DBB457C072ADB6D,558E973E23C74BBA9A1ACE179E3EFEF5,42DD7668C5224C168B20C4A246B66E22,B6A0813D32FB4DCB83A1D359F2820624,0A733B3F5292414BA2310836A3EE9B73,D2710C4B3A944167B8D7BF8F65D73BB0,8B23357AC1C140A5B3681DE476E9E1C1,5A4FF223AB96497798D5362E939407EC,2E65C0D958C04C8384715FDF6D541AE7,FBEF168D10A241878731988B448A0264,70C913999AB54967B7DC0BFB01E4C002,BB15A59BC3E9401CA84D53C5D1A56B40,B1EAF0ED1A874D16AD4E3482C921A58B,D25CF3B3B85C47CD9D60E675E3933CFF,9F488865B7FF4341938EBA9D94204795,D6BF5602516F429FB4F0EB74EDA3DAAC,9B219F01ED224BBEBABA20E42A31AFA2,33DD7E752F9E4370AAE84B7B6B1EA5AD,985325E1C95542EF91D2EA2CB46A2F76,C8E744895CAA4777947B179C8D21A9FC,4838CECBBA884B67A4570606A67213B8,B2FC77E916324F318AF7D7B3556CB7FF,3EF3718C2A4947E9A3F985D69BDEC4A5,0B4BE7CC6D4F4E2CA8D95EDE71A79595,2159F0A8F2BD429588FFC67BCACBAB4F,EFEF307707644996AA9AC1A88A296911,BEE95716B0944D18AF306475456462E3,C7FA7097C3B4409C97D8B13EEED1B069,22131325E5BD4FA5AFC04E3641A9B755,1ECF30EE6A2443D4A206BCE16B609FA8,57E7013CCF4B460484B9B9200A698093,0FAFDDD497184B3CA0EEB03275DEE18D,07712865174943709ADB50F96A73999A,BFCC52F39C8A4CAB848DCE603F87D92C,1B30D2EE13F54EEAABBFAC5E6ED30489,1E6D53FFAEF44E9DBCB36DBD0AC68C16,AA941A639DEC47639D8AE67130C6DBEE,D9FC3868FBE04D51A81D6A818D1B1D95,09CE37B9867B42DB8ADA553B8B5A67B4,C7E037FEEE6443869FEB15649CB2C0B1,CFB004560B2F4766B5CA4C4761CCDA52,CF9A67BE65C34F0D83C6AD48D83C1E0D,ECDCE5C7F14242D5ACF207DAF30CC88B,3F191018E34048B6930B6E66AC5ED4D8,43586046BF29433EB8D2AF01C9E1873D,1E70C94C51DB45B583706F1F4E29CF24,707EB86898AA4EFA94ADE7C100B8ACC9,50310F189C3C4715AC90D35B51306491,8FDCADB63F5A4947A802C8281B7C4438,428125A1CFA94E27829FF69A54D8E040,AA4432DBFA9B4B31B6D2BE6DBFCFEF65,ADF58EE95F0D45E398ED4EFB93DD9E92,28B716B99D7F4D9CADC4069129B054F1,6B182F61975F478FA289F0F693AFE458,12DC94F4334443A8B7B15323BC6350ED,E02823532CBC4D8EA5F0F2EF6491D3E8,61B2E3DCDB6C4C6DA735BCA81FCD3E86,3C4DE95E065E4615AAFDAC2A68641D8D,9EE03C4577774E6AB578459182D8993E,2F8DBEFD3021470098FD7EF7C63BD3FE,59D693BEDC4044048AF15265274EA550,C1DBB548EAB64E9FAEBAC11FD570D6F9,39876BCF65574B39B6305FB8A3882995,E32587287FAC4B3687F89B0F9C25ACE5,77BBE70EB029409BBBD392BD7C2F9EAA,963B0C7541C643B7B04F31ED8DB80991,F8B33CAD6A524A17928307E191D3590C,9672E37BB2CC4A7CADA1AD884DE90EAA,8562497BB44C418EA88F8ED19FD07C5A,D458727097494E1FACBA86FC3DCC0545,2C9F279594CB42B49DC175E3697F5152,227E23479C8743D79BC5ECF86BBEB95F,49E28B8448664A3C9E0BE8BD808315F4,442CE337BA84424CB75E0840E7DC6FEA,CDA79F323E3A4008942F189F81C6D5F8,4813E926AE9E4934B6DDB0D39184BF77,DEDB67BA42F648BBA0CF63A7D6AEE861,94BB85E191454662B8BA35886D096D18,5B8139996AAB4D06B6E65A5791FD1A28,A23F1B4D36564D829597135A022A45A9,73A080E26D2F42C4B1F488DD3EC38B82,B9FC7ADC307D4D31905DAFF05D2B8E90,88968668C1C44980AD45594FDE0F3F20,C6B1E756558F4A22A705CFFAF751AC3E,6E95C60751F74723803CEEEF383CEC26,C1E7DFFCCB384F54A15BF528C4E2FB86,D90FB41D4C8443C6A6FE6B20127BDA73,F3F9BA12C87D4B8EA4B181641059E164,8AC658DCFB1449AC9B684302A735CA85,8AF2E2539A3745C0ABE0A5EB1FD12D2F,14480C2A728A4CF8AACDF057F1EAE262,EBC004F36431451B9F739ED70019AB86,9771CD9DAC1A4E23A70DFF0671415760,439E196FECB144ED87FBF79DF5EB36EB,4813B23E8C644A62ACFECB2B3AC5D34D,6EFCCC303BA44EBA8FC377471A550A65,518790C0219E48CB9FEEC1D0BD7E697C,4F821DCD6C394454B75EDCE56734FBC5,F6F2235BC12143B8B92524D00E055370,73F6E2A4E5C34823957AFCD756B7EF96,0036E1B4228E41578D4F89149DEC92EC,E168567EAFF94B4793996B0AB415930B,C002170F73544C6E9AAEC8DD7FBB5750,75C698C323A9401EBACB657B62A257B8,3F18481C298A4CDFA9E57669CB07114D,7C12BE46D17144F7ADDCA0E7C7A3FD52,E21D915D816B418194476AC292E3C32E,24D0809B7ACB4BEEBFD742E6D3BF1004,90BE3361AA72408B80587E63C3C75C09,CB6874561A404FF6BCD1735B597CF0E8,E19C5F8E9F1D4C0BAA510681AFCA9A90,0BD819BF9926460C96E83F0CC608BAA7,726C1875F4954F96B2A61E7C5A911E9D,6B5C4C79B4AB425AB0DB2C20AB96EFF9,1AD47DB36BF74AFA80DB691D8B6E2512,7413EF6C99A543D8B41A09B1A016A3A8,B3D3E2BE6B7749E5B152D6999C3A5B9F,2CCD7AB2BE564B91949B5B3AFD2F170A,AFA41ACBB4814A7D88E09DB285BF7B59,91BDD4AAA5E04D72861F80374DA08406,3EE29DBB721A45DA9977D4B7BDD823B5,25990F5BBFAA4ADEB3CBB9DE42B5D8D9,911D729F29294DD9997D2083C5545614,664FFE8B17974ABCBE4215D77996BB16,A024D7397BF5495986B8006757CC8975,53DCB799965E44CA9EE17153E2AA2723,DB54CEA1C7EB4C18B79EB86CD1064347,5FA7218924DB47E9A7FC0CD320A105B5,F234CEEDB08B4B2B8847A9FB1763BDB3,1A00200E3745429083F44BB85F7DF154,69FF7EBCF0154A1F92CB251BAD736E06,8A314FF8DEBD40C69A642B94148CC628,7607E70CFF5B454186A44AE75778CCC0,6EAB3556F5A54683BA6BE029A43B82CF,45A2D7039663481C8D98E568C40F6923,D28B399A983448A89AEBE0B318CEB2B1,27FD49828F7141BA97CEA94CCC893CF3,646F08846D04443485383E3338CD2145,A3EF2DB7E4F74EE2AA54AED92B2C2702,5822CDAA0B094FDB87C62786C305D006,8E2EB700E4F64A7FA7EEA4130567C12E,0FE2220CD8D74D16B9CCFD88907B44F7,AA6E6D54ACC94E3DA142B1CA42C332E6}'::text[]))
-> Hash (cost=1.03..1.03 rows=3 width=44) (actual time=0.011..0.011 rows=3 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 9kB
-> Seq Scan on c_acctschema financialm1_ (cost=0.00..1.03 rows=3 width=44) (actual time=0.002..0.003 rows=3 loops=1)
Planning time: 2.790 ms
Execution time: 661680.116 ms
(18 rows)
|
Relationships [ Relation Graph ]
[ Dependency Graph ]
Relationships 