explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gZMq

Settings
# exclusive inclusive rows x rows loops node
1. 386.347 293,939.433 ↓ 61.0 61 1

GroupAggregate (cost=4,795.33..4,796.68 rows=1 width=1,444) (actual time=293,766.356..293,939.433 rows=61 loops=1)

  • Group Key: ah.cid, ah.id, ap.company_name, gat.cid, gat.id, ad.cid, ad.id, gd.name, cd.name, cd.details, art.name, ap.ap_payee_status_type_id, pb.building_name, pb.details, pu.unit_number, pu.details, apt.name, apl.vendor_code, ba.account_name
  • Filter: (CASE WHEN (ad.transaction_amount >= '0'::numeric) THEN (ad.transaction_amount + sum(COALESCE(aa.allocation_amount, '0'::numeric))) ELSE (ad.transaction_amount - sum(COALESCE(aa.allocation_amount, '0'::numeric))) END <> '0'::numeric)
  • Rows Removed by Filter: 170854
2. 799.059 293,553.086 ↓ 176,340.0 176,340 1

Sort (cost=4,795.33..4,795.33 rows=1 width=1,472) (actual time=293,501.351..293,553.086 rows=176,340 loops=1)

  • Sort Key: ah.id, ap.company_name, gat.id, ad.id, gd.name, cd.name, cd.details, art.name, ap.ap_payee_status_type_id, pb.building_name, pb.details, pu.unit_number, pu.details, apt.name, apl.vendor_code, ba.account_name
  • Sort Method: quicksort Memory: 63194kB
3. 258.968 292,754.027 ↓ 176,340.0 176,340 1

Nested Loop Left Join (cost=34.14..4,795.32 rows=1 width=1,472) (actual time=29.607..292,754.027 rows=176,340 loops=1)

4. 233.241 292,495.059 ↓ 176,340.0 176,340 1

Nested Loop Left Join (cost=34.00..4,795.13 rows=1 width=1,461) (actual time=29.603..292,495.059 rows=176,340 loops=1)

5. 278.795 292,261.818 ↓ 176,340.0 176,340 1

Nested Loop Left Join (cost=33.72..4,794.82 rows=1 width=831) (actual time=29.600..292,261.818 rows=176,340 loops=1)

6. 224.410 291,983.023 ↓ 176,340.0 176,340 1

Nested Loop Left Join (cost=33.58..4,794.63 rows=1 width=827) (actual time=29.596..291,983.023 rows=176,340 loops=1)

  • Join Filter: (ap.id = apl.ap_payee_id)
7. 230.627 291,053.253 ↓ 176,340.0 176,340 1

Nested Loop Left Join (cost=33.29..4,794.28 rows=1 width=827) (actual time=29.561..291,053.253 rows=176,340 loops=1)

8. 247.622 290,117.266 ↓ 176,340.0 176,340 1

Nested Loop (cost=33.00..4,793.93 rows=1 width=800) (actual time=29.525..290,117.266 rows=176,340 loops=1)

9. 75,651.758 289,164.284 ↓ 176,340.0 176,340 1

Nested Loop Left Join (cost=32.73..4,793.63 rows=1 width=783) (actual time=29.504..289,164.284 rows=176,340 loops=1)

  • Join Filter: ((unnest(('{12154,"" 12155"","" 332835"","" 12157"","" 13044"","" 12158"","" 190506"","" 348083"","" 21259"","" 503928"","" 507641"","" 507642"","" 12159"","" 12160"","" 12161"","" 12162"","" 353765"","" 191945"","" 12163"","" 12164"","" 348460"","" 12165"","" 12166"","" 189960"","" 191534"","" 71631"","" 12167"","" 12168"","" 348020"","" 12172"","" 190255"","" 12174"","" 347357"","" 12176"","" 12177"","" 12195"","" 21249"","" 14138"","" 190730"","" 503812"","" 12178"","" 12179"","" 12186"","" 12182"","" 12181"","" 12185"","" 12180"","" 12184"","" 12183"","" 12188"","" 12189"","" 190305"","" 14186"","" 12191"","" 12190"","" 14172"","" 12193"","" 12194"","" 12187"","" 12196"","" 351206"","" 503147"","" 12198"","" 12199"","" 354626"","" 12200"","" 14065"","" 12726"","" 12201"","" 192058"","" 349944"","" 191512"","" 12202"","" 190263"","" 71186"","" 12203"","" 12169"","" 351050"","" 12204"","" 352736"","" 354649"","" 12205"","" 12170"","" 190759"","" 501167"","" 12206"","" 351645"","" 12401"","" 12207"","" 12208"","" 12209"","" 506795"","" 71625"","" 71691"","" 347821"","" 351005"","" 14018"","" 352194"","" 12210"","" 12396"","" 192030"","" 12211"","" 501791"","" 12212"","" 14136"","" 191870"","" 351634"","" 352200"","" 12213"","" 191088"","" 12214"","" 12215"","" 12216"","" 14063"","" 13935"","" 21363"","" 501094"","" 14158"","" 21423"","" 354864"","" 14135"","" 71183"","" 189506"","" 71647"","" 191987"","" 352098"","" 21334"","" 12220"","" 12221"","" 502346"","" 12217"","" 12218"","" 351117"","" 12219"","" 190514"","" 12223"","" 12222"","" 12224"","" 12225"","" 191059"","" 501404"","" 13987"","" 21312"","" 12226"","" 12227"","" 662661"","" 21427"","" 14123"","" 190985"","" 189497"","" 191525"","" 191906"","" 341803"","" 361188"","" 506763"","" 502249"","" 341307"","" 191025"","" 348323"","" 501717"","" 502996"","" 354780"","" 13814"","" 14176"","" 12236"","" 12228"","" 339346"","" 21273"","" 129757"","" 13160"","" 501024"","" 354643"","" 14015"","" 502339"","" 350946"","" 502818"","" 12175"","" 12173"","" 191981"","" 14066"","" 503020"","" 14034"","" 12229"","" 502769"","" 661858"","" 12231"","" 352416"","" 349947"","" 71676"","" 19323"","" 128290"","" 12242"","" 12243"","" 12232"","" 12233"","" 12234"","" 13781"","" 191212"","" 12235"","" 190226"","" 13799"","" 14027"","" 14050"","" 14029"","" 191099"","" 190653"","" 12237"","" 503759"","" 12244"","" 12245"","" 21368"","" 350033"","" 350032"","" 12246"","" 12247"","" 12248"","" 12249"","" 12250"","" 12251"","" 12252"","" 12253"","" 12254"","" 12255"","" 12256"","" 12257"","" 12258"","" 12259"","" 12260"","" 12261"","" 12262"","" 12263"","" 12264"","" 12265"","" 12266"","" 12267"","" 12268"","" 12269"","" 12270"","" 12171"","" 12271"","" 12238"","" 12240"","" 12241"","" 12239"","" 354179"","" 12272"","" 349586"","" 12273"","" 21421"","" 352429"","" 12275"","" 14060"","" 12276"","" 12305"","" 354654"","" 12277"","" 191173"","" 351212"","" 507393"","" 189692"","" 189691"","" 350025"","" 350024"","" 350026"","" 350027"","" 189694"","" 191127"","" 189693"","" 191126"","" 354542"","" 13988"","" 13982"","" 504142"","" 12278"","" 12281"","" 12282"","" 12283"","" 12285"","" 12284"","" 12286"","" 12300"","" 12287"","" 501454"","" 190489"","" 501776"","" 501455"","" 352180"","" 507395"","" 352400"","" 12288"","" 501702"","" 12290"","" 12291"","" 12293"","" 12294"","" 12292"","" 12295"","" 351052"","" 12296"","" 13951"","" 192033"","" 351652"","" 351012"","" 12960"","" 354503"","" 502464"","" 12299"","" 14160"","" 503166"","" 354883"","" 12279"","" 189499"","" 350724"","" 350723"","" 352500"","" 501005"","" 501004"","" 352195"","" 662935"","" 12990"","" 507639"","" 12301"","" 350347"","" 21272"","" 12302"","" 12280"","" 12304"","" 12303"","" 71627"","" 663876"","" 502433"","" 663277"","" 71662"","" 12306"","" 348599"","" 352414"","" 352418"","" 14025"","" 13875"","" 14173"","" 361007"","" 21369"","" 12309"","" 71692"","" 21268"","" 503257"","" 12310"","" 663024"","" 350386"","" 503741"","" 506697"","" 12311"","" 12312"","" 502078"","" 502206"","" 507329"","" 360992"","" 21336"","" 12313"","" 351648"","" 12314"","" 191529"","" 348273"","" 352412"","" 348016"","" 71179"","" 14068"","" 190641"","" 502081"","" 128972"","" 21365"","" 12297"","" 13938"","" 12316"","" 190642"","" 12317"","" 12318"","" 14075"","" 14072"","" 14053"","" 506997"","" 348739"","" 348738"","" 350954"","" 12711"","" 13010"","" 12892"","" 12319"","" 506921"","" 12320"","" 354476"","" 190797"","" 504167"","" 21241"","" 663042"","" 349225"","" 662944"","" 71668"","" 351125"","" 12321"","" 12322"","" 12323"","" 12324"","" 71630"","" 351094"","" 661920"","" 12325"","" 503120"","" 12329"","" 351386"","" 14071"","" 12326"","" 12327"","" 12444"","" 12457"","" 352028"","" 338460"","" 361020"","" 12927"","" 14032"","" 354872"","" 352189"","" 348580"","" 14174"","" 14059"","" 12445"","" 191863"","" 350732"","" 21345"","" 12574"","" 12624"","" 353969"","" 21313"","" 189688"","" 352027"","" 351949"","" 14028"","" 12331"","" 349609"","" 12479"","" 352415"","" 14020"","" 339931"","" 14189"","" 663738"","" 189749"","" 501684"","" 663010"","" 12333"","" 353971"","" 12334"","" 12335"","" 12336"","" 12337"","" 12338"","" 12339"","" 328311"","" 192001"","" 352426"","" 12340"","" 12341"","" 12342"","" 12343"","" 12344"","" 12347"","" 12348"","" 12349"","" 12350"","" 12351"","" 12346"","" 12345"","" 12354"","" 12352"","" 12353"","" 12374"","" 12368"","" 12371"","" 12367"","" 12369"","" 12381"","" 12370"","" 12382"","" 12373"","" 12383"","" 12372"","" 12358"","" 12156"","" 12355"","" 12390"","" 12375"","" 12765"","" 12764"","" 12364"","" 12359"","" 12366"","" 12356"","" 12363"","" 12362"","" 333067"","" 12376"","" 12377"","" 12384"","" 14126"","" 12442"","" 12361"","" 354013"","" 12378"","" 12365"","" 12379"","" 353817"","" 502166"","" 507325"","" 663306"","" 12385"","" 12387"","" 501246"","" 12992"","" 12360"","" 21321"","" 663014"","" 351375"","" 353970"","" 12386"","" 12388"","" 12357"","" 12389"","" 350191"","" 663371"","" 12391"","" 350116"","" 128994"","" 2"","" 361184"","" 506819"","" 19322"","" 12392"","" 128449"","" 12408"","" 12409"","" 503397"","" 501957"","" 352439"","" 14047"","" 191081"","" 360959"","" 12410"","" 14044"","" 12411"","" 14024"","" 189865"","" 12579"","" 12412"","" 12413"","" 342618"","" 361038"","" 12654"","" 14157"","" 12414"","" 12415"","" 12416"","" 12417"","" 507157"","" 351127"","" 12328"","" 14011"","" 12420"","" 350930"","" 12441"","" 12419"","" 12421"","" 506966"","" 12422"","" 355018"","" 663241"","" 12423"","" 12424"","" 12425"","" 12426"","" 191924"","" 21413"","" 12427"","" 128968"","" 71669"","" 189635"","" 348071"","" 12428"","" 661852"","" 12429"","" 351097"","" 12430"","" 14130"","" 12431"","" 663238"","" 347759"","" 12433"","" 12434"","" 501451"","" 342605"","" 12437"","" 500908"","" 662929"","" 354087"","" 12439"","" 12438"","" 13917"","" 352737"","" 12443"","" 191879"","" 190995"","" 12447"","" 12448"","" 348459"","" 71616"","" 12449"","" 12450"","" 348439"","" 349633"","" 662023"","" 21409"","" 191172"","" 191873"","" 663660"","" 351673"","" 350817"","" 21348"","" 502205"","" 501693"","" 348803"","" 501052"","" 503969"","" 12451"","" 21564"","" 351007"","" 502300"","" 502204"","" 190315"","" 354955"","" 503527"","" 192031"","" 12399"","" 21292"","" 12453"","" 13823"","" 190633"","" 503986"","" 663207"","" 3"","" 190636"","" 21314"","" 501058"","" 352235"","" 501938"","" 663231"","" 12455"","" 12435"","" 502344"","" 14177"","" 14049"","" 353900"","" 12456"","" 13920"","" 349943"","" 507297"","" 354499"","" 190969"","" 12458"","" 661957"","" 12459"","" 13804"","" 501575"","" 350156"","" 352399"","" 12461"","" 354391"","" 12463"","" 21337"","" 14184"","" 12469"","" 12462"","" 12468"","" 12460"","" 12446"","" 21253"","" 12464"","" 12465"","" 14041"","" 12466"","" 352499"","" 21356"","" 13884"","" 191138"","" 12400"","" 12470"","" 503167"","" 507158"","" 354789"","" 352408"","" 507447"","" 12315"","" 354967"","" 340203"","" 12471"","" 12472"","" 12473"","" 14048"","" 503817"","" 662081"","" 350753"","" 12476"","" 347731"","" 352201"","" 12475"","" 12509"","" 352202"","" 12721"","" 12478"","" 12477"","" 12480"","" 14164"","" 12483"","" 12484"","" 12485"","" 12486"","" 12487"","" 12488"","" 12489"","" 12490"","" 12491"","" 12492"","" 12493"","" 12494"","" 12495"","" 12496"","" 351169"","" 12497"","" 12498"","" 189711"","" 19358"","" 12482"","" 128526"","" 352611"","" 192036"","" 13940"","" 12499"","" 21245"","" 12500"","" 503198"","" 501706"","" 71663"","" 13925"","" 12501"","" 352422"","" 13991"","" 13948"","" 12502"","" 352181"","" 502738"","" 12504"","" 354920"","" 14179"","" 21352"","" 190650"","" 12506"","" 501054"","" 14171"","" 21424"","" 189494"","" 354549"","" 506809"","" 12508"","" 501953"","" 352402"","" 12510"","" 500925"","" 503243"","" 503164"","" 502345"","" 349861"","" 349384"","" 351139"","" 191064"","" 190982"","" 12511"","" 12512"","" 12513"","" 12947"","" 350057"","" 12515"","" 12516"","" 13778"","" 12518"","" 352203"","" 352204"","" 12519"","" 12520"","" 12522"","" 14193"","" 351629"","" 13990"","" 352153"","" 502047"","" 12523"","" 352043"","" 12524"","" 21565"","" 71678"","" 361139"","" 12525"","" 361164"","" 21339"","" 21338"","" 503289"","" 128990"","" 12481"","" 354827"","" 13919"","" 12527"","" 12526"","" 21381"","" 361190"","" 12528"","" 12529"","" 12530"","" 14195"","" 12531"","" 13783"","" 12532"","" 12533"","" 12534"","" 12536"","" 12537"","" 506979"","" 12538"","" 360963"","" 361054"","" 13776"","" 12541"","" 351148"","" 12542"","" 12543"","" 190229"","" 12545"","" 12535"","" 12546"","" 507778"","" 12547"","" 12548"","" 12549"","" 12550"","" 355080"","" 13832"","" 12551"","" 12552"","" 342141"","" 12553"","" 507274"","" 14064"","" 13779"","" 12555"","" 351388"","" 12576"","" 12559"","" 12558"","" 12560"","" 351221"","" 12563"","" 12564"","" 12562"","" 12561"","" 12565"","" 12566"","" 354417"","" 21407"","" 12567"","" 14181"","" 12568"","" 352502"","" 12569"","" 12571"","" 12572"","" 12573"","" 12575"","" 12578"","" 502076"","" 338454"","" 13914"","" 12580"","" 350962"","" 12582"","" 352398"","" 12583"","" 351936"","" 13038"","" 192029"","" 12397"","" 502212"","" 14026"","" 501025"","" 21372"","" 189611"","" 352308"","" 12584"","" 12585"","" 71654"","" 71656"","" 661873"","" 13937"","" 662990"","" 189716"","" 351218"","" 12586"","" 350019"","" 350018"","" 12587"","" 12577"","" 12588"","" 21414"","" 361158"","" 13983"","" 12590"","" 352160"","" 12591"","" 12592"","" 12395"","" 349289"","" 13954"","" 20474"","" 12664"","" 19862"","" 127624"","" 350017"","" 350016"","" 127840"","" 21110"","" 12594"","" 12595"","" 12596"","" 12593"","" 12380"","" 13790"","" 12615"","" 351392"","" 13994"","" 12598"","" 84603"","" 12600"","" 12603"","" 12608"","" 12599"","" 12601"","" 12602"","" 354992"","" 12604"","" 21280"","" 338826"","" 12607"","" 12606"","" 502460"","" 12605"","" 502336"","" 504212"","" 13936"","" 12611"","" 12609"","" 12610"","" 12612"","" 12613"","" 351403"","" 12614"","" 662916"","" 71657"","" 12703"","" 12616"","" 12617"","" 12581"","" 13812"","" 352161"","" 12618"","" 12619"","" 504065"","" 661913"","" 12620"","" 12621"","" 12622"","" 349932"","" 13985"","" 71652"","" 12623"","" 14062"","" 12657"","" 12440"","" 13984"","" 12626"","" 12627"","" 503837"","" 12628"","" 12630"","" 12631"","" 12632"","" 128966"","" 360979"","" 12629"","" 12644"","" 663083"","" 190264"","" 12634"","" 12635"","" 663601"","" 12633"","" 13950"","" 192027"","" 71661"","" 506738"","" 12636"","" 12637"","" 12638"","" 12639"","" 507779"","" 12640"","" 502183"","" 350171"","" 351404"","" 12641"","" 12643"","" 351090"","" 13824"","" 12646"","" 12647"","" 13808"","" 503565"","" 352410"","" 12653"","" 501341"","" 12649"","" 12650"","" 12648"","" 12652"","" 12651"","" 12645"","" 191871"","" 189840"","" 12394"","" 352191"","" 12544"","" 12797"","" 12655"","" 12656"","" 12658"","" 350069"","" 12659"","" 12662"","" 351917"","" 12660"","" 12661"","" 350117"","" 13986"","" 21429"","" 12663"","" 12740"","" 354281"","" 13805"","" 12665"","" 507133"","" 351934"","" 12666"","" 13942"","" 192032"","" 12667"","" 501824"","" 352726"","" 12671"","" 12670"","" 13886"","" 339304"","" 351278"","" 14156"","" 12672"","" 663735"","" 350949"","" 352110"","" 507169"","" 352404"","" 14162"","" 192057"","" 662034"","" 507693"","" 71622"","" 14169"","" 12673"","" 12674"","" 12676"","" 128989"","" 191210"","" 13816"","" 21248"","" 14023"","" 12677"","" 13820"","" 12678"","" 71633"","" 12679"","" 12503"","" 12521"","" 21360"","" 12680"","" 354116"","" 503031"","" 12675"","" 501056"","" 12704"","" 354147"","" 14119"","" 349668"","" 503876"","" 502209"","" 501372"","" 128973"","" 190496"","" 507394"","" 354507"","" 507295"","" 14168"","" 351123"","" 84604"","" 14180"","" 12682"","" 7"","" 13911"","" 352367"","" 12685"","" 12683"","" 12684"","" 12467"","" 12668"","" 507683"","" 507727"","" 129750"","" 12686"","" 503131"","" 13181"","" 189924"","" 21347"","" 71670"","" 347368"","" 507749"","" 350887"","" 354073"","" 504133"","" 12687"","" 71680"","" 21570"","" 189634"","" 502438"","" 506431"","" 661856"","" 507373"","" 71649"","" 71651"","" 352234"","" 503979"","" 13813"","" 14148"","" 352205"","" 502366"","" 190273"","" 12669"","" 12688"","" 12690"","" 12689"","" 351631"","" 354152"","" 190401"","" 12691"","" 71638"","" 14190"","" 21240"","" 12692"","" 12693"","" 14045"","" 352206"","" 71675"","" 501754"","" 191639"","" 352405"","" 191974"","" 501991"","" 352326"","" 354814"","" 662820"","" 13821"","" 129756"","" 14159"","" 12298"","" 12642"","" 349856"","" 341379"","" 14131"","" 503510"","" 12694"","" 661992"","" 21275"","" 351929"","" 352192"","" 12695"","" 191647"","" 21242"","" 12696"","" 663789"","" 12697"","" 663433"","" 71660"","" 663829"","" 14056"","" 501751"","" 507857"","" 349458"","" 14134"","" 21294"","" 502202"","" 501083"","" 21569"","" 663137"","" 352444"","" 12681"","" 12698"","" 349863"","" 354103"","" 12699"","" 191788"","" 12700"","" 354663"","" 12701"","" 348740"","" 348741"","" 12702"","" 662846"","" 12705"","" 192052"","" 361008"","" 663652"","" 347958"","" 12706"","" 350239"","" 348468"","" 12748"","" 14122"","" 189505"","" 191586"","" 191026"","" 14125"","" 129012"","" 663745"","" 349365"","" 14170"","" 190959"","" 21566"","" 352413"","" 507731"","" 354950"","" 351996"","" 663606"","" 12708"","" 192002"","" 353821"","" 12709"","" 352154"","" 351630"","" 189806"","" 351663"","" 21252"","" 354970"","" 12197"","" 12710"","" 14188"","" 12713"","" 12714"","" 12712"","" 12715"","" 352448"","" 351649"","" 352421"","" 12716"","" 349808"","" 12717"","" 14010"","" 21235"","" 190361"","" 352417"","" 354117"","" 351657"","" 12718"","" 338508"","" 503991"","" 12719"","" 12720"","" 12722"","" 12707"","" 12723"","" 349473"","" 12724"","" 12725"","" 352159"","" 361204"","" 191856"","" 13941"","" 351927"","" 663651"","" 12728"","" 12729"","" 191209"","" 347744"","" 347363"","" 354971"","" 191869"","" 354475"","" 501736"","" 350036"","" 350037"","" 12741"","" 189695"","" 14139"","" 191808"","" 663106"","" 12730"","" 12731"","" 662848"","" 71688"","" 501057"","" 12732"","" 352183"","" 502037"","" 21411"","" 21233"","" 12881"","" 12308"","" 12454"","" 190738"","" 191098"","" 12734"","" 12735"","" 12589"","" 352423"","" 13039"","" 12737"","" 12738"","" 354505"","" 361017"","" 12739"","" 14022"","" 502385"","" 14052"","" 349973"","" 190643"","" 663432"","" 12742"","" 351561"","" 351890"","" 71683"","" 14069"","" 13887"","" 21428"","" 663082"","" 501031"","" 507682"","" 12745"","" 12744"","" 351092"","" 21374"","" 14070"","" 12777"","" 351977"","" 12746"","" 12747"","" 13918"","" 12750"","" 71650"","" 13810"","" 14146"","" 352162"","" 352155"","" 12751"","" 21276"","" 12752"","" 12754"","" 12753"","" 12756"","" 352297"","" 12757"","" 191644"","" 14124"","" 12758"","" 354445"","" 354178"","" 507069"","" 12763"","" 12794"","" 12761"","" 21287"","" 21274"","" 663630"","" 663653"","" 21568"","" 354055"","" 19360"","" 128294"","" 12402"","" 191864"","" 350035"","" 350034"","" 71644"","" 349926"","" 349927"","" 12766"","" 12783"","" 502203"","" 12767"","" 127811"","" 21048"","" 350011"","" 350012"","" 354877"","" 350869"","" 13923"","" 501559"","" 12768"","" 12769"","" 128967"","" 12771"","" 328474"","" 662060"","" 501830"","" 501565"","" 341843"","" 190917"","" 352307"","" 13926"","" 501940"","" 12772"","" 12773"","" 129726"","" 191903"","" 349917"","" 13822"","" 507385"","" 507392"","" 191019"","" 352163"","" 352207"","" 12774"","" 12775"","" 354433"","" 502353"","" 191766"","" 71639"","" 13927"","" 501051"","" 12776"","" 354584"","" 129011"","" 341641"","" 352397"","" 12778"","" 14017"","" 12779"","" 354141"","" 21290"","" 13815"","" 13879"","" 71667"","" 14140"","" 662936"","" 12780"","" 12781"","" 14150"","" 12782"","" 502290"","" 12785"","" 12786"","" 12790"","" 12791"","" 12792"","" 12793"","" 501574"","" 349364"","" 663604"","" 663086"","" 349404"","" 502177"","" 502213"","" 21247"","" 12821"","" 12153"","" 349918"","" 13876"","" 349937"","" 12798"","" 12799"","" 190640"","" 506962"","" 12805"","" 12804"","" 21371"","" 352396"","" 501355"","" 352164"","" 13807"","" 128998"","" 14165"","" 501171"","" 14067"","" 12755"","" 12789"","" 12405"","" 71665"","" 14021"","" 14037"","" 14175"","" 12289"","" 21238"","" 189969"","" 352208"","" 191523"","" 21373"","" 12810"","" 12505"","" 12796"","" 12808"","" 12800"","" 12820"","" 12806"","" 12811"","" 12849"","" 12819"","" 12812"","" 14058"","" 12762"","" 12788"","" 14161"","" 12814"","" 12813"","" 351173"","" 12801"","" 12803"","" 13826"","" 12938"","" 12937"","" 14128"","" 14073"","" 342140"","" 12815"","" 13912"","" 12869"","" 12816"","" 12784"","" 12872"","" 12817"","" 328277"","" 500929"","" 348282"","" 352296"","" 14019"","" 71635"","" 328310"","" 507721"","" 352677"","" 12818"","" 13809"","" 350823"","" 189936"","" 190495"","" 21262"","" 21271"","" 21263"","" 190739"","" 191975"","" 12760"","" 663577"","" 12822"","" 12823"","" 21260"","" 12824"","" 14152"","" 14163"","" 14043"","" 14057"","" 662967"","" 189592"","" 191967"","" 13811"","" 351399"","" 12826"","" 190492"","" 503030"","" 12827"","" 12432"","" 352184"","" 12828"","" 12829"","" 12830"","" 12831"","" 12832"","" 12833"","" 12834"","" 12835"","" 12836"","" 12837"","" 12838"","" 12840"","" 12841"","" 12842"","" 12839"","" 12843"","" 12844"","" 12845"","" 12846"","" 12847"","" 12848"","" 12850"","" 12851"","" 12852"","" 12853"","" 12854"","" 12855"","" 12856"","" 12858"","" 350029"","" 21358"","" 350028"","" 12860"","" 12861"","" 12862"","" 12863"","" 12864"","" 12865"","" 12866"","" 12867"","" 12868"","" 12759"","" 12859"","" 349881"","" 13780"","" 1"","" 71686"","" 335613"","" 12871"","" 354863"","" 12517"","" 338621"","" 12802"","" 12857"","" 128497"","" 19361"","" 13827"","" 502208"","" 342090"","" 351211"","" 13993"","" 507458"","" 71640"","" 662401"","" 21364"","" 71653"","" 71655"","" 84607"","" 354519"","" 506683"","" 12875"","" 12880"","" 348954"","" 350241"","" 71184"","" 507690"","" 353728"","" 12873"","" 361069"","" 13995"","" 190490"","" 502641"","" 12874"","" 12876"","" 12877"","" 352041"","" 190423"","" 12878"","" 21375"","" 351915"","" 12879"","" 507215"","" 663741"","" 502054"","" 14035"","" 14054"","" 71648"","" 190927"","" 354963"","" 190651"","" 12192"","" 190228"","" 504210"","" 504211"","" 502179"","" 21359"","" 13792"","" 12882"","" 12883"","" 14051"","" 12885"","" 342943"","" 663222"","" 12898"","" 19359"","" 12899"","" 128470"","" 350003"","" 350004"","" 361187"","" 350006"","" 350005"","" 354425"","" 350008"","" 350007"","" 350832"","" 350840"","" 350916"","" 350009"","" 361056"","" 350010"","" 350842"","" 14013"","" 12884"","" 503852"","" 12887"","" 12888"","" 351324"","" 12886"","" 12554"","" 501453"","" 190508"","" 12889"","" 12890"","" 12893"","" 12894"","" 12895"","" 12891"","" 12896"","" 351972"","" 663560"","" 21279"","" 191531"","" 12897"","" 12900"","" 12901"","" 12902"","" 12903"","" 12904"","" 12905"","" 12906"","" 12907"","" 12908"","" 12909"","" 12910"","" 12911"","" 12912"","" 12913"","" 12914"","" 12915"","" 12916"","" 12917"","" 12918"","" 12919"","" 12920"","" 189573"","" 354764"","" 14147"","" 12921"","" 354713"","" 190936"","" 190746"","" 129006"","" 71623"","" 663208"","" 502778"","" 190872"","" 351627"","" 352156"","" 503473"","" 12332"","" 12923"","" 12924"","" 12925"","" 12926"","" 352406"","" 21573"","" 349802"","" 351096"","" 14061"","" 13800"","" 502987"","" 14132"","" 12928"","" 12929"","" 12507"","" 12930"","" 14141"","" 12931"","" 12749"","" 12403"","" 12404"","" 351051"","" 507282"","" 12932"","" 663311"","" 12933"","" 12934"","" 360974"","" 21244"","" 12936"","" 12939"","" 12940"","" 21383"","" 13777"","" 12941"","" 12942"","" 12943"","" 190316"","" 354958"","" 351387"","" 12945"","" 12944"","" 190899"","" 662934"","" 189984"","" 84606"","" 129004"","" 14040"","" 12922"","" 13947"","" 21572"","" 342019"","" 12946"","" 349425"","" 71687"","" 191761"","" 12935"","" 13955"","" 190823"","" 12948"","" 12949"","" 12950"","" 12951"","" 12952"","" 129758"","" 662472"","" 12953"","" 14192"","" 12956"","" 12957"","" 350382"","" 13819"","" 352185"","" 663257"","" 353775"","" 354430"","" 663216"","" 21560"","" 13885"","" 14121"","" 12958"","" 341844"","" 21362"","" 341717"","" 502980"","" 351150"","" 354873"","" 129753"","" 14149"","" 21258"","" 12959"","" 21250"","" 191146"","" 12993"","" 128389"","" 19223"","" 14012"","" 14129"","" 192054"","" 21366"","" 13032"","" 12418"","" 12961"","" 12962"","" 14030"","" 355091"","" 12963"","" 12964"","" 12965"","" 12966"","" 12967"","" 12968"","" 12969"","" 12970"","" 12971"","" 12972"","" 12973"","" 12974"","" 12975"","" 12976"","" 12977"","" 12978"","" 12979"","" 12980"","" 12981"","" 12870"","" 352165"","" 191061"","" 191188"","" 351095"","" 12985"","" 191519"","" 129731"","" 190326"","" 351301"","" 191201"","" 12982"","" 504088"","" 351126"","" 12983"","" 19250"","" 128809"","" 14133"","" 12984"","" 507189"","" 14016"","" 21322"","" 662470"","" 12986"","" 352001"","" 360975"","" 342857"","" 71659"","" 339345"","" 192026"","" 13949"","" 14194"","" 21234"","" 12736"","" 129709"","" 21256"","" 663209"","" 353818"","" 354581"","" 352407"","" 501163"","" 507653"","" 191066"","" 501840"","" 14185"","" 351013"","" 354341"","" 663367"","" 502033"","" 662995"","" 12727"","" 12987"","" 352420"","" 12988"","" 12989"","" 502754"","" 13924"","" 12991"","" 190785"","" 348743"","" 348742"","" 129734"","" 352657"","" 12995"","" 12996"","" 12997"","" 12998"","" 12999"","" 13000"","" 13001"","" 13002"","" 13003"","" 13004"","" 13005"","" 13006"","" 13007"","" 13008"","" 13009"","" 350020"","" 21357"","" 350021"","" 13011"","" 13012"","" 13013"","" 13014"","" 13015"","" 13016"","" 13017"","" 13018"","" 13019"","" 13020"","" 13021"","" 13022"","" 13023"","" 13024"","" 13025"","" 13026"","" 13027"","" 13028"","" 13029"","" 13030"","" 13031"","" 12994"","" 12954"","" 12955"","" 13033"","" 191015"","" 501701"","" 503455"","" 13034"","" 507343"","" 14127"","" 13818"","" 14036"","" 662849"","" 501759"","" 13035"","" 352182"","" 352193"","" 19363"","" 13080"","" 127747"","" 13081"","" 191524"","" 504131"","" 190898"","" 507858"","" 71182"","" 13036"","" 13803"","" 21408"","" 328261"","" 12570"","" 361186"","" 13048"","" 13040"","" 21382"","" 191200"","" 21563"","" 190610"","" 190733"","" 191016"","" 13042"","" 13043"","" 348615"","" 502038"","" 501279"","" 13045"","" 13046"","" 663019"","" 507694"","" 13047"","" 14042"","" 13952"","" 192034"","" 71637"","" 14014"","" 507640"","" 14055"","" 71181"","" 190918"","" 21323"","" 190281"","" 352403"","" 13049"","" 190280"","" 340198"","" 662920"","" 192025"","" 351398"","" 354546"","" 12407"","" 12406"","" 12393"","" 71634"","" 192035"","" 190803"","" 21293"","" 501252"","" 354567"","" 501531"","" 13056"","" 190227"","" 71641"","" 71645"","" 13057"","" 13058"","" 663085"","" 507168"","" 354308"","" 13059"","" 13060"","" 13061"","" 339946"","" 121396"","" 13063"","" 13062"","" 13922"","" 502888"","" 13064"","" 661959"","" 13065"","" 13066"","" 13067"","" 13068"","" 663529"","" 129762"","" 13069"","" 506524"","" 13070"","" 339935"","" 13072"","" 339980"","" 21425"","" 13041"","" 13075"","" 349880"","" 352342"","" 506699"","" 352124"","" 507170"","" 13076"","" 13077"","" 13078"","" 13079"","" 13082"","" 21367"","" 350030"","" 350031"","" 13084"","" 12230"","" 12733"","" 13085"","" 351149"","" 13086"","" 13087"","" 351055"","" 13037"","" 12330"","" 12807"","" 12809"","" 12795"","" 13916"","" 13073"","" 14008"","" 13088"","" 13071"","" 13074"","" 502527"","" 190897"","" 13946"","" 21342"","" 662889"","" 191022"","" 14007"","" 13817"","" 13921"","" 13989"","" 192037"","" 501038"","" 351124"","" 14039"","" 71658"","" 341714"","" 502694"","" 354177"","" 504245"","" 342093"","" 192028"","" 12398"","" 352428"","" 350063"","" 501050"","" 352424"","" 351147"","" 13089"","" 13090"","" 354778"","" 13083"","" 352186"","" 12539"","" 501572"","" 13091"","" 21297"","" 503434"","" 13092"","" 351859"","" 13093"","" 21270"","" 13094"","" 352376"","" 13095"","" 13096"","" 501934"","" 13997"","" 13913"","" 13097"","" 13098"","" 13099"","" 349936"","" 348973"","" 343338"","" 13102"","" 14074"","" 354633"","" 21284"","" 361055"","" 13103"","" 21232"","" 507859"","" 13104"","" 13105"","" 351280"","" 13106"","" 13883"","" 351628"","" 352157"","" 14183"","" 13107"","" 5"","" 333045"","" 191144"","" 352409"","" 14167"","" 71620"","" 13108"","" 12452"","" 361058"","" 355033"","" 12556"","" 12557"","" 12625"","" 13187"","" 12743"","" 352427"","" 71646"","" 14033"","" 350722"","" 350721"","" 351119"","" 351121"","" 13109"","" 13945"","" 503521"","" 14151"","" 13055"","" 13054"","" 13052"","" 13051"","" 13110"","" 13053"","" 13050"","" 351322"","" 13111"","" 503849"","" 21291"","" 361135"","" 502285"","" 12274"","" 13112"","" 663087"","" 350815"","" 13113"","" 663656"","" 354562"","" 361152"","" 352419"","" 21384"","" 351937"","" 351888"","" 13939"","" 501055"","" 501935"","" 13114"","" 192038"","" 14046"","" 354703"","" 6"","" 351091"","" 13101"","" 13115"","" 13116"","" 349945"","" 13996"","" 12474"","" 14038"","" 21315"","" 352438"","" 351283"","" 13117"","" 503456"","" 13118"","" 349067"","" 351367"","" 71628"","" 501930"","" 13119"","" 13120"","" 13121"","" 351323"","" 13122"","" 13100"","" 351093"","" 190639"","" 13123"","" 663235"","" 662026"","" 361226"","" 190491"","" 350064"","" 349897"","" 21285"","" 71185"","" 13124"","" 13125"","" 14187"","" 662606"","" 13127"","" 13126"","" 13128"","" 14137"","" 502308"","" 501503"","" 13129"","" 351385"","" 342950"","" 347413"","" 353744"","" 12436"","" 14191"","" 13130"","" 342088"","" 13131"","" 13132"","" 13133"","" 503155"","" 13134"","" 354429"","" 12825"","" 191849"","" 13135"","" 13944"","" 501135"","" 71664"","" 129008"","" 13943"","" 21236"","" 501639"","" 13136"","" 128954"","" 19122"","" 14166"","" 71682"","" 354547"","" 503262"","" 13806"","" 21264"","" 350822"","" 191082"","" 21370"","" 350022"","" 350023"","" 13138"","" 13139"","" 13140"","" 13141"","" 13142"","" 13143"","" 13144"","" 13145"","" 13146"","" 13147"","" 13148"","" 13149"","" 13150"","" 13151"","" 13152"","" 13153"","" 13154"","" 13155"","" 13156"","" 13157"","" 13158"","" 13137"","" 354989"","" 361030"","" 13159"","" 14120"","" 352606"","" 12514"","" 13161"","" 351155"","" 13162"","" 350002"","" 13163"","" 13164"","" 13165"","" 13166"","" 13167"","" 13168"","" 13169"","" 13171"","" 13172"","" 13173"","" 13170"","" 13174"","" 13176"","" 13177"","" 502390"","" 13178"","" 13179"","" 21376"","" 13175"","" 13189"","" 13190"","" 13180"","" 506958"","" 12770"","" 502386"","" 353778"","" 13182"","" 13183"","" 13184"","" 13185"","" 349887"","" 13186"","" 14009"","" 13188"","" 12787"","" 13191"","" 507004"","" 13192"","" 13193"","" 21243"","" 13194"","" 13195"","" 13196"","" 12307"","" 12597"","" 13197"","" 127570"","" 19251"","" 13198"","" 127599"","" 19362"","" 14182"","" 13199"","" 190709"","" 354533"","" 12540"","" 354960"","" 13201"","" 13202"","" 13203"","" 13200"","" 13204"","" 350100"","" 664825"","" 664824"","" 13205"","" 663759"","" 507765"","" 190895"","" 502417"","" 663769"","" 13206"","" 13207"","" 662948"","" 662949"","" 354135""}'::text[])::integer[])) = ah.ap_payee_id)
  • Rows Removed by Join Filter: 437500529
  • Filter: (((unnest(('{12154,"" 12155"","" 332835"","" 12157"","" 13044"","" 12158"","" 190506"","" 348083"","" 21259"","" 503928"","" 507641"","" 507642"","" 12159"","" 12160"","" 12161"","" 12162"","" 353765"","" 191945"","" 12163"","" 12164"","" 348460"","" 12165"","" 12166"","" 189960"","" 191534"","" 71631"","" 12167"","" 12168"","" 348020"","" 12172"","" 190255"","" 12174"","" 347357"","" 12176"","" 12177"","" 12195"","" 21249"","" 14138"","" 190730"","" 503812"","" 12178"","" 12179"","" 12186"","" 12182"","" 12181"","" 12185"","" 12180"","" 12184"","" 12183"","" 12188"","" 12189"","" 190305"","" 14186"","" 12191"","" 12190"","" 14172"","" 12193"","" 12194"","" 12187"","" 12196"","" 351206"","" 503147"","" 12198"","" 12199"","" 354626"","" 12200"","" 14065"","" 12726"","" 12201"","" 192058"","" 349944"","" 191512"","" 12202"","" 190263"","" 71186"","" 12203"","" 12169"","" 351050"","" 12204"","" 352736"","" 354649"","" 12205"","" 12170"","" 190759"","" 501167"","" 12206"","" 351645"","" 12401"","" 12207"","" 12208"","" 12209"","" 506795"","" 71625"","" 71691"","" 347821"","" 351005"","" 14018"","" 352194"","" 12210"","" 12396"","" 192030"","" 12211"","" 501791"","" 12212"","" 14136"","" 191870"","" 351634"","" 352200"","" 12213"","" 191088"","" 12214"","" 12215"","" 12216"","" 14063"","" 13935"","" 21363"","" 501094"","" 14158"","" 21423"","" 354864"","" 14135"","" 71183"","" 189506"","" 71647"","" 191987"","" 352098"","" 21334"","" 12220"","" 12221"","" 502346"","" 12217"","" 12218"","" 351117"","" 12219"","" 190514"","" 12223"","" 12222"","" 12224"","" 12225"","" 191059"","" 501404"","" 13987"","" 21312"","" 12226"","" 12227"","" 662661"","" 21427"","" 14123"","" 190985"","" 189497"","" 191525"","" 191906"","" 341803"","" 361188"","" 506763"","" 502249"","" 341307"","" 191025"","" 348323"","" 501717"","" 502996"","" 354780"","" 13814"","" 14176"","" 12236"","" 12228"","" 339346"","" 21273"","" 129757"","" 13160"","" 501024"","" 354643"","" 14015"","" 502339"","" 350946"","" 502818"","" 12175"","" 12173"","" 191981"","" 14066"","" 503020"","" 14034"","" 12229"","" 502769"","" 661858"","" 12231"","" 352416"","" 349947"","" 71676"","" 19323"","" 128290"","" 12242"","" 12243"","" 12232"","" 12233"","" 12234"","" 13781"","" 191212"","" 12235"","" 190226"","" 13799"","" 14027"","" 14050"","" 14029"","" 191099"","" 190653"","" 12237"","" 503759"","" 12244"","" 12245"","" 21368"","" 350033"","" 350032"","" 12246"","" 12247"","" 12248"","" 12249"","" 12250"","" 12251"","" 12252"","" 12253"","" 12254"","" 12255"","" 12256"","" 12257"","" 12258"","" 12259"","" 12260"","" 12261"","" 12262"","" 12263"","" 12264"","" 12265"","" 12266"","" 12267"","" 12268"","" 12269"","" 12270"","" 12171"","" 12271"","" 12238"","" 12240"","" 12241"","" 12239"","" 354179"","" 12272"","" 349586"","" 12273"","" 21421"","" 352429"","" 12275"","" 14060"","" 12276"","" 12305"","" 354654"","" 12277"","" 191173"","" 351212"","" 507393"","" 189692"","" 189691"","" 350025"","" 350024"","" 350026"","" 350027"","" 189694"","" 191127"","" 189693"","" 191126"","" 354542"","" 13988"","" 13982"","" 504142"","" 12278"","" 12281"","" 12282"","" 12283"","" 12285"","" 12284"","" 12286"","" 12300"","" 12287"","" 501454"","" 190489"","" 501776"","" 501455"","" 352180"","" 507395"","" 352400"","" 12288"","" 501702"","" 12290"","" 12291"","" 12293"","" 12294"","" 12292"","" 12295"","" 351052"","" 12296"","" 13951"","" 192033"","" 351652"","" 351012"","" 12960"","" 354503"","" 502464"","" 12299"","" 14160"","" 503166"","" 354883"","" 12279"","" 189499"","" 350724"","" 350723"","" 352500"","" 501005"","" 501004"","" 352195"","" 662935"","" 12990"","" 507639"","" 12301"","" 350347"","" 21272"","" 12302"","" 12280"","" 12304"","" 12303"","" 71627"","" 663876"","" 502433"","" 663277"","" 71662"","" 12306"","" 348599"","" 352414"","" 352418"","" 14025"","" 13875"","" 14173"","" 361007"","" 21369"","" 12309"","" 71692"","" 21268"","" 503257"","" 12310"","" 663024"","" 350386"","" 503741"","" 506697"","" 12311"","" 12312"","" 502078"","" 502206"","" 507329"","" 360992"","" 21336"","" 12313"","" 351648"","" 12314"","" 191529"","" 348273"","" 352412"","" 348016"","" 71179"","" 14068"","" 190641"","" 502081"","" 128972"","" 21365"","" 12297"","" 13938"","" 12316"","" 190642"","" 12317"","" 12318"","" 14075"","" 14072"","" 14053"","" 506997"","" 348739"","" 348738"","" 350954"","" 12711"","" 13010"","" 12892"","" 12319"","" 506921"","" 12320"","" 354476"","" 190797"","" 504167"","" 21241"","" 663042"","" 349225"","" 662944"","" 71668"","" 351125"","" 12321"","" 12322"","" 12323"","" 12324"","" 71630"","" 351094"","" 661920"","" 12325"","" 503120"","" 12329"","" 351386"","" 14071"","" 12326"","" 12327"","" 12444"","" 12457"","" 352028"","" 338460"","" 361020"","" 12927"","" 14032"","" 354872"","" 352189"","" 348580"","" 14174"","" 14059"","" 12445"","" 191863"","" 350732"","" 21345"","" 12574"","" 12624"","" 353969"","" 21313"","" 189688"","" 352027"","" 351949"","" 14028"","" 12331"","" 349609"","" 12479"","" 352415"","" 14020"","" 339931"","" 14189"","" 663738"","" 189749"","" 501684"","" 663010"","" 12333"","" 353971"","" 12334"","" 12335"","" 12336"","" 12337"","" 12338"","" 12339"","" 328311"","" 192001"","" 352426"","" 12340"","" 12341"","" 12342"","" 12343"","" 12344"","" 12347"","" 12348"","" 12349"","" 12350"","" 12351"","" 12346"","" 12345"","" 12354"","" 12352"","" 12353"","" 12374"","" 12368"","" 12371"","" 12367"","" 12369"","" 12381"","" 12370"","" 12382"","" 12373"","" 12383"","" 12372"","" 12358"","" 12156"","" 12355"","" 12390"","" 12375"","" 12765"","" 12764"","" 12364"","" 12359"","" 12366"","" 12356"","" 12363"","" 12362"","" 333067"","" 12376"","" 12377"","" 12384"","" 14126"","" 12442"","" 12361"","" 354013"","" 12378"","" 12365"","" 12379"","" 353817"","" 502166"","" 507325"","" 663306"","" 12385"","" 12387"","" 501246"","" 12992"","" 12360"","" 21321"","" 663014"","" 351375"","" 353970"","" 12386"","" 12388"","" 12357"","" 12389"","" 350191"","" 663371"","" 12391"","" 350116"","" 128994"","" 2"","" 361184"","" 506819"","" 19322"","" 12392"","" 128449"","" 12408"","" 12409"","" 503397"","" 501957"","" 352439"","" 14047"","" 191081"","" 360959"","" 12410"","" 14044"","" 12411"","" 14024"","" 189865"","" 12579"","" 12412"","" 12413"","" 342618"","" 361038"","" 12654"","" 14157"","" 12414"","" 12415"","" 12416"","" 12417"","" 507157"","" 351127"","" 12328"","" 14011"","" 12420"","" 350930"","" 12441"","" 12419"","" 12421"","" 506966"","" 12422"","" 355018"","" 663241"","" 12423"","" 12424"","" 12425"","" 12426"","" 191924"","" 21413"","" 12427"","" 128968"","" 71669"","" 189635"","" 348071"","" 12428"","" 661852"","" 12429"","" 351097"","" 12430"","" 14130"","" 12431"","" 663238"","" 347759"","" 12433"","" 12434"","" 501451"","" 342605"","" 12437"","" 500908"","" 662929"","" 354087"","" 12439"","" 12438"","" 13917"","" 352737"","" 12443"","" 191879"","" 190995"","" 12447"","" 12448"","" 348459"","" 71616"","" 12449"","" 12450"","" 348439"","" 349633"","" 662023"","" 21409"","" 191172"","" 191873"","" 663660"","" 351673"","" 350817"","" 21348"","" 502205"","" 501693"","" 348803"","" 501052"","" 503969"","" 12451"","" 21564"","" 351007"","" 502300"","" 502204"","" 190315"","" 354955"","" 503527"","" 192031"","" 12399"","" 21292"","" 12453"","" 13823"","" 190633"","" 503986"","" 663207"","" 3"","" 190636"","" 21314"","" 501058"","" 352235"","" 501938"","" 663231"","" 12455"","" 12435"","" 502344"","" 14177"","" 14049"","" 353900"","" 12456"","" 13920"","" 349943"","" 507297"","" 354499"","" 190969"","" 12458"","" 661957"","" 12459"","" 13804"","" 501575"","" 350156"","" 352399"","" 12461"","" 354391"","" 12463"","" 21337"","" 14184"","" 12469"","" 12462"","" 12468"","" 12460"","" 12446"","" 21253"","" 12464"","" 12465"","" 14041"","" 12466"","" 352499"","" 21356"","" 13884"","" 191138"","" 12400"","" 12470"","" 503167"","" 507158"","" 354789"","" 352408"","" 507447"","" 12315"","" 354967"","" 340203"","" 12471"","" 12472"","" 12473"","" 14048"","" 503817"","" 662081"","" 350753"","" 12476"","" 347731"","" 352201"","" 12475"","" 12509"","" 352202"","" 12721"","" 12478"","" 12477"","" 12480"","" 14164"","" 12483"","" 12484"","" 12485"","" 12486"","" 12487"","" 12488"","" 12489"","" 12490"","" 12491"","" 12492"","" 12493"","" 12494"","" 12495"","" 12496"","" 351169"","" 12497"","" 12498"","" 189711"","" 19358"","" 12482"","" 128526"","" 352611"","" 192036"","" 13940"","" 12499"","" 21245"","" 12500"","" 503198"","" 501706"","" 71663"","" 13925"","" 12501"","" 352422"","" 13991"","" 13948"","" 12502"","" 352181"","" 502738"","" 12504"","" 354920"","" 14179"","" 21352"","" 190650"","" 12506"","" 501054"","" 14171"","" 21424"","" 189494"","" 354549"","" 506809"","" 12508"","" 501953"","" 352402"","" 12510"","" 500925"","" 503243"","" 503164"","" 502345"","" 349861"","" 349384"","" 351139"","" 191064"","" 190982"","" 12511"","" 12512"","" 12513"","" 12947"","" 350057"","" 12515"","" 12516"","" 13778"","" 12518"","" 352203"","" 352204"","" 12519"","" 12520"","" 12522"","" 14193"","" 351629"","" 13990"","" 352153"","" 502047"","" 12523"","" 352043"","" 12524"","" 21565"","" 71678"","" 361139"","" 12525"","" 361164"","" 21339"","" 21338"","" 503289"","" 128990"","" 12481"","" 354827"","" 13919"","" 12527"","" 12526"","" 21381"","" 361190"","" 12528"","" 12529"","" 12530"","" 14195"","" 12531"","" 13783"","" 12532"","" 12533"","" 12534"","" 12536"","" 12537"","" 506979"","" 12538"","" 360963"","" 361054"","" 13776"","" 12541"","" 351148"","" 12542"","" 12543"","" 190229"","" 12545"","" 12535"","" 12546"","" 507778"","" 12547"","" 12548"","" 12549"","" 12550"","" 355080"","" 13832"","" 12551"","" 12552"","" 342141"","" 12553"","" 507274"","" 14064"","" 13779"","" 12555"","" 351388"","" 12576"","" 12559"","" 12558"","" 12560"","" 351221"","" 12563"","" 12564"","" 12562"","" 12561"","" 12565"","" 12566"","" 354417"","" 21407"","" 12567"","" 14181"","" 12568"","" 352502"","" 12569"","" 12571"","" 12572"","" 12573"","" 12575"","" 12578"","" 502076"","" 338454"","" 13914"","" 12580"","" 350962"","" 12582"","" 352398"","" 12583"","" 351936"","" 13038"","" 192029"","" 12397"","" 502212"","" 14026"","" 501025"","" 21372"","" 189611"","" 352308"","" 12584"","" 12585"","" 71654"","" 71656"","" 661873"","" 13937"","" 662990"","" 189716"","" 351218"","" 12586"","" 350019"","" 350018"","" 12587"","" 12577"","" 12588"","" 21414"","" 361158"","" 13983"","" 12590"","" 352160"","" 12591"","" 12592"","" 12395"","" 349289"","" 13954"","" 20474"","" 12664"","" 19862"","" 127624"","" 350017"","" 350016"","" 127840"","" 21110"","" 12594"","" 12595"","" 12596"","" 12593"","" 12380"","" 13790"","" 12615"","" 351392"","" 13994"","" 12598"","" 84603"","" 12600"","" 12603"","" 12608"","" 12599"","" 12601"","" 12602"","" 354992"","" 12604"","" 21280"","" 338826"","" 12607"","" 12606"","" 502460"","" 12605"","" 502336"","" 504212"","" 13936"","" 12611"","" 12609"","" 12610"","" 12612"","" 12613"","" 351403"","" 12614"","" 662916"","" 71657"","" 12703"","" 12616"","" 12617"","" 12581"","" 13812"","" 352161"","" 12618"","" 12619"","" 504065"","" 661913"","" 12620"","" 12621"","" 12622"","" 349932"","" 13985"","" 71652"","" 12623"","" 14062"","" 12657"","" 12440"","" 13984"","" 12626"","" 12627"","" 503837"","" 12628"","" 12630"","" 12631"","" 12632"","" 128966"","" 360979"","" 12629"","" 12644"","" 663083"","" 190264"","" 12634"","" 12635"","" 663601"","" 12633"","" 13950"","" 192027"","" 71661"","" 506738"","" 12636"","" 12637"","" 12638"","" 12639"","" 507779"","" 12640"","" 502183"","" 350171"","" 351404"","" 12641"","" 12643"","" 351090"","" 13824"","" 12646"","" 12647"","" 13808"","" 503565"","" 352410"","" 12653"","" 501341"","" 12649"","" 12650"","" 12648"","" 12652"","" 12651"","" 12645"","" 191871"","" 189840"","" 12394"","" 352191"","" 12544"","" 12797"","" 12655"","" 12656"","" 12658"","" 350069"","" 12659"","" 12662"","" 351917"","" 12660"","" 12661"","" 350117"","" 13986"","" 21429"","" 12663"","" 12740"","" 354281"","" 13805"","" 12665"","" 507133"","" 351934"","" 12666"","" 13942"","" 192032"","" 12667"","" 501824"","" 352726"","" 12671"","" 12670"","" 13886"","" 339304"","" 351278"","" 14156"","" 12672"","" 663735"","" 350949"","" 352110"","" 507169"","" 352404"","" 14162"","" 192057"","" 662034"","" 507693"","" 71622"","" 14169"","" 12673"","" 12674"","" 12676"","" 128989"","" 191210"","" 13816"","" 21248"","" 14023"","" 12677"","" 13820"","" 12678"","" 71633"","" 12679"","" 12503"","" 12521"","" 21360"","" 12680"","" 354116"","" 503031"","" 12675"","" 501056"","" 12704"","" 354147"","" 14119"","" 349668"","" 503876"","" 502209"","" 501372"","" 128973"","" 190496"","" 507394"","" 354507"","" 507295"","" 14168"","" 351123"","" 84604"","" 14180"","" 12682"","" 7"","" 13911"","" 352367"","" 12685"","" 12683"","" 12684"","" 12467"","" 12668"","" 507683"","" 507727"","" 129750"","" 12686"","" 503131"","" 13181"","" 189924"","" 21347"","" 71670"","" 347368"","" 507749"","" 350887"","" 354073"","" 504133"","" 12687"","" 71680"","" 21570"","" 189634"","" 502438"","" 506431"","" 661856"","" 507373"","" 71649"","" 71651"","" 352234"","" 503979"","" 13813"","" 14148"","" 352205"","" 502366"","" 190273"","" 12669"","" 12688"","" 12690"","" 12689"","" 351631"","" 354152"","" 190401"","" 12691"","" 71638"","" 14190"","" 21240"","" 12692"","" 12693"","" 14045"","" 352206"","" 71675"","" 501754"","" 191639"","" 352405"","" 191974"","" 501991"","" 352326"","" 354814"","" 662820"","" 13821"","" 129756"","" 14159"","" 12298"","" 12642"","" 349856"","" 341379"","" 14131"","" 503510"","" 12694"","" 661992"","" 21275"","" 351929"","" 352192"","" 12695"","" 191647"","" 21242"","" 12696"","" 663789"","" 12697"","" 663433"","" 71660"","" 663829"","" 14056"","" 501751"","" 507857"","" 349458"","" 14134"","" 21294"","" 502202"","" 501083"","" 21569"","" 663137"","" 352444"","" 12681"","" 12698"","" 349863"","" 354103"","" 12699"","" 191788"","" 12700"","" 354663"","" 12701"","" 348740"","" 348741"","" 12702"","" 662846"","" 12705"","" 192052"","" 361008"","" 663652"","" 347958"","" 12706"","" 350239"","" 348468"","" 12748"","" 14122"","" 189505"","" 191586"","" 191026"","" 14125"","" 129012"","" 663745"","" 349365"","" 14170"","" 190959"","" 21566"","" 352413"","" 507731"","" 354950"","" 351996"","" 663606"","" 12708"","" 192002"","" 353821"","" 12709"","" 352154"","" 351630"","" 189806"","" 351663"","" 21252"","" 354970"","" 12197"","" 12710"","" 14188"","" 12713"","" 12714"","" 12712"","" 12715"","" 352448"","" 351649"","" 352421"","" 12716"","" 349808"","" 12717"","" 14010"","" 21235"","" 190361"","" 352417"","" 354117"","" 351657"","" 12718"","" 338508"","" 503991"","" 12719"","" 12720"","" 12722"","" 12707"","" 12723"","" 349473"","" 12724"","" 12725"","" 352159"","" 361204"","" 191856"","" 13941"","" 351927"","" 663651"","" 12728"","" 12729"","" 191209"","" 347744"","" 347363"","" 354971"","" 191869"","" 354475"","" 501736"","" 350036"","" 350037"","" 12741"","" 189695"","" 14139"","" 191808"","" 663106"","" 12730"","" 12731"","" 662848"","" 71688"","" 501057"","" 12732"","" 352183"","" 502037"","" 21411"","" 21233"","" 12881"","" 12308"","" 12454"","" 190738"","" 191098"","" 12734"","" 12735"","" 12589"","" 352423"","" 13039"","" 12737"","" 12738"","" 354505"","" 361017"","" 12739"","" 14022"","" 502385"","" 14052"","" 349973"","" 190643"","" 663432"","" 12742"","" 351561"","" 351890"","" 71683"","" 14069"","" 13887"","" 21428"","" 663082"","" 501031"","" 507682"","" 12745"","" 12744"","" 351092"","" 21374"","" 14070"","" 12777"","" 351977"","" 12746"","" 12747"","" 13918"","" 12750"","" 71650"","" 13810"","" 14146"","" 352162"","" 352155"","" 12751"","" 21276"","" 12752"","" 12754"","" 12753"","" 12756"","" 352297"","" 12757"","" 191644"","" 14124"","" 12758"","" 354445"","" 354178"","" 507069"","" 12763"","" 12794"","" 12761"","" 21287"","" 21274"","" 663630"","" 663653"","" 21568"","" 354055"","" 19360"","" 128294"","" 12402"","" 191864"","" 350035"","" 350034"","" 71644"","" 349926"","" 349927"","" 12766"","" 12783"","" 502203"","" 12767"","" 127811"","" 21048"","" 350011"","" 350012"","" 354877"","" 350869"","" 13923"","" 501559"","" 12768"","" 12769"","" 128967"","" 12771"","" 328474"","" 662060"","" 501830"","" 501565"","" 341843"","" 190917"","" 352307"","" 13926"","" 501940"","" 12772"","" 12773"","" 129726"","" 191903"","" 349917"","" 13822"","" 507385"","" 507392"","" 191019"","" 352163"","" 352207"","" 12774"","" 12775"","" 354433"","" 502353"","" 191766"","" 71639"","" 13927"","" 501051"","" 12776"","" 354584"","" 129011"","" 341641"","" 352397"","" 12778"","" 14017"","" 12779"","" 354141"","" 21290"","" 13815"","" 13879"","" 71667"","" 14140"","" 662936"","" 12780"","" 12781"","" 14150"","" 12782"","" 502290"","" 12785"","" 12786"","" 12790"","" 12791"","" 12792"","" 12793"","" 501574"","" 349364"","" 663604"","" 663086"","" 349404"","" 502177"","" 502213"","" 21247"","" 12821"","" 12153"","" 349918"","" 13876"","" 349937"","" 12798"","" 12799"","" 190640"","" 506962"","" 12805"","" 12804"","" 21371"","" 352396"","" 501355"","" 352164"","" 13807"","" 128998"","" 14165"","" 501171"","" 14067"","" 12755"","" 12789"","" 12405"","" 71665"","" 14021"","" 14037"","" 14175"","" 12289"","" 21238"","" 189969"","" 352208"","" 191523"","" 21373"","" 12810"","" 12505"","" 12796"","" 12808"","" 12800"","" 12820"","" 12806"","" 12811"","" 12849"","" 12819"","" 12812"","" 14058"","" 12762"","" 12788"","" 14161"","" 12814"","" 12813"","" 351173"","" 12801"","" 12803"","" 13826"","" 12938"","" 12937"","" 14128"","" 14073"","" 342140"","" 12815"","" 13912"","" 12869"","" 12816"","" 12784"","" 12872"","" 12817"","" 328277"","" 500929"","" 348282"","" 352296"","" 14019"","" 71635"","" 328310"","" 507721"","" 352677"","" 12818"","" 13809"","" 350823"","" 189936"","" 190495"","" 21262"","" 21271"","" 21263"","" 190739"","" 191975"","" 12760"","" 663577"","" 12822"","" 12823"","" 21260"","" 12824"","" 14152"","" 14163"","" 14043"","" 14057"","" 662967"","" 189592"","" 191967"","" 13811"","" 351399"","" 12826"","" 190492"","" 503030"","" 12827"","" 12432"","" 352184"","" 12828"","" 12829"","" 12830"","" 12831"","" 12832"","" 12833"","" 12834"","" 12835"","" 12836"","" 12837"","" 12838"","" 12840"","" 12841"","" 12842"","" 12839"","" 12843"","" 12844"","" 12845"","" 12846"","" 12847"","" 12848"","" 12850"","" 12851"","" 12852"","" 12853"","" 12854"","" 12855"","" 12856"","" 12858"","" 350029"","" 21358"","" 350028"","" 12860"","" 12861"","" 12862"","" 12863"","" 12864"","" 12865"","" 12866"","" 12867"","" 12868"","" 12759"","" 12859"","" 349881"","" 13780"","" 1"","" 71686"","" 335613"","" 12871"","" 354863"","" 12517"","" 338621"","" 12802"","" 12857"","" 128497"","" 19361"","" 13827"","" 502208"","" 342090"","" 351211"","" 13993"","" 507458"","" 71640"","" 662401"","" 21364"","" 71653"","" 71655"","" 84607"","" 354519"","" 506683"","" 12875"","" 12880"","" 348954"","" 350241"","" 71184"","" 507690"","" 353728"","" 12873"","" 361069"","" 13995"","" 190490"","" 502641"","" 12874"","" 12876"","" 12877"","" 352041"","" 190423"","" 12878"","" 21375"","" 351915"","" 12879"","" 507215"","" 663741"","" 502054"","" 14035"","" 14054"","" 71648"","" 190927"","" 354963"","" 190651"","" 12192"","" 190228"","" 504210"","" 504211"","" 502179"","" 21359"","" 13792"","" 12882"","" 12883"","" 14051"","" 12885"","" 342943"","" 663222"","" 12898"","" 19359"","" 12899"","" 128470"","" 350003"","" 350004"","" 361187"","" 350006"","" 350005"","" 354425"","" 350008"","" 350007"","" 350832"","" 350840"","" 350916"","" 350009"","" 361056"","" 350010"","" 350842"","" 14013"","" 12884"","" 503852"","" 12887"","" 12888"","" 351324"","" 12886"","" 12554"","" 501453"","" 190508"","" 12889"","" 12890"","" 12893"","" 12894"","" 12895"","" 12891"","" 12896"","" 351972"","" 663560"","" 21279"","" 191531"","" 12897"","" 12900"","" 12901"","" 12902"","" 12903"","" 12904"","" 12905"","" 12906"","" 12907"","" 12908"","" 12909"","" 12910"","" 12911"","" 12912"","" 12913"","" 12914"","" 12915"","" 12916"","" 12917"","" 12918"","" 12919"","" 12920"","" 189573"","" 354764"","" 14147"","" 12921"","" 354713"","" 190936"","" 190746"","" 129006"","" 71623"","" 663208"","" 502778"","" 190872"","" 351627"","" 352156"","" 503473"","" 12332"","" 12923"","" 12924"","" 12925"","" 12926"","" 352406"","" 21573"","" 349802"","" 351096"","" 14061"","" 13800"","" 502987"","" 14132"","" 12928"","" 12929"","" 12507"","" 12930"","" 14141"","" 12931"","" 12749"","" 12403"","" 12404"","" 351051"","" 507282"","" 12932"","" 663311"","" 12933"","" 12934"","" 360974"","" 21244"","" 12936"","" 12939"","" 12940"","" 21383"","" 13777"","" 12941"","" 12942"","" 12943"","" 190316"","" 354958"","" 351387"","" 12945"","" 12944"","" 190899"","" 662934"","" 189984"","" 84606"","" 129004"","" 14040"","" 12922"","" 13947"","" 21572"","" 342019"","" 12946"","" 349425"","" 71687"","" 191761"","" 12935"","" 13955"","" 190823"","" 12948"","" 12949"","" 12950"","" 12951"","" 12952"","" 129758"","" 662472"","" 12953"","" 14192"","" 12956"","" 12957"","" 350382"","" 13819"","" 352185"","" 663257"","" 353775"","" 354430"","" 663216"","" 21560"","" 13885"","" 14121"","" 12958"","" 341844"","" 21362"","" 341717"","" 502980"","" 351150"","" 354873"","" 129753"","" 14149"","" 21258"","" 12959"","" 21250"","" 191146"","" 12993"","" 128389"","" 19223"","" 14012"","" 14129"","" 192054"","" 21366"","" 13032"","" 12418"","" 12961"","" 12962"","" 14030"","" 355091"","" 12963"","" 12964"","" 12965"","" 12966"","" 12967"","" 12968"","" 12969"","" 12970"","" 12971"","" 12972"","" 12973"","" 12974"","" 12975"","" 12976"","" 12977"","" 12978"","" 12979"","" 12980"","" 12981"","" 12870"","" 352165"","" 191061"","" 191188"","" 351095"","" 12985"","" 191519"","" 129731"","" 190326"","" 351301"","" 191201"","" 12982"","" 504088"","" 351126"","" 12983"","" 19250"","" 128809"","" 14133"","" 12984"","" 507189"","" 14016"","" 21322"","" 662470"","" 12986"","" 352001"","" 360975"","" 342857"","" 71659"","" 339345"","" 192026"","" 13949"","" 14194"","" 21234"","" 12736"","" 129709"","" 21256"","" 663209"","" 353818"","" 354581"","" 352407"","" 501163"","" 507653"","" 191066"","" 501840"","" 14185"","" 351013"","" 354341"","" 663367"","" 502033"","" 662995"","" 12727"","" 12987"","" 352420"","" 12988"","" 12989"","" 502754"","" 13924"","" 12991"","" 190785"","" 348743"","" 348742"","" 129734"","" 352657"","" 12995"","" 12996"","" 12997"","" 12998"","" 12999"","" 13000"","" 13001"","" 13002"","" 13003"","" 13004"","" 13005"","" 13006"","" 13007"","" 13008"","" 13009"","" 350020"","" 21357"","" 350021"","" 13011"","" 13012"","" 13013"","" 13014"","" 13015"","" 13016"","" 13017"","" 13018"","" 13019"","" 13020"","" 13021"","" 13022"","" 13023"","" 13024"","" 13025"","" 13026"","" 13027"","" 13028"","" 13029"","" 13030"","" 13031"","" 12994"","" 12954"","" 12955"","" 13033"","" 191015"","" 501701"","" 503455"","" 13034"","" 507343"","" 14127"","" 13818"","" 14036"","" 662849"","" 501759"","" 13035"","" 352182"","" 352193"","" 19363"","" 13080"","" 127747"","" 13081"","" 191524"","" 504131"","" 190898"","" 507858"","" 71182"","" 13036"","" 13803"","" 21408"","" 328261"","" 12570"","" 361186"","" 13048"","" 13040"","" 21382"","" 191200"","" 21563"","" 190610"","" 190733"","" 191016"","" 13042"","" 13043"","" 348615"","" 502038"","" 501279"","" 13045"","" 13046"","" 663019"","" 507694"","" 13047"","" 14042"","" 13952"","" 192034"","" 71637"","" 14014"","" 507640"","" 14055"","" 71181"","" 190918"","" 21323"","" 190281"","" 352403"","" 13049"","" 190280"","" 340198"","" 662920"","" 192025"","" 351398"","" 354546"","" 12407"","" 12406"","" 12393"","" 71634"","" 192035"","" 190803"","" 21293"","" 501252"","" 354567"","" 501531"","" 13056"","" 190227"","" 71641"","" 71645"","" 13057"","" 13058"","" 663085"","" 507168"","" 354308"","" 13059"","" 13060"","" 13061"","" 339946"","" 121396"","" 13063"","" 13062"","" 13922"","" 502888"","" 13064"","" 661959"","" 13065"","" 13066"","" 13067"","" 13068"","" 663529"","" 129762"","" 13069"","" 506524"","" 13070"","" 339935"","" 13072"","" 339980"","" 21425"","" 13041"","" 13075"","" 349880"","" 352342"","" 506699"","" 352124"","" 507170"","" 13076"","" 13077"","" 13078"","" 13079"","" 13082"","" 21367"","" 350030"","" 350031"","" 13084"","" 12230"","" 12733"","" 13085"","" 351149"","" 13086"","" 13087"","" 351055"","" 13037"","" 12330"","" 12807"","" 12809"","" 12795"","" 13916"","" 13073"","" 14008"","" 13088"","" 13071"","" 13074"","" 502527"","" 190897"","" 13946"","" 21342"","" 662889"","" 191022"","" 14007"","" 13817"","" 13921"","" 13989"","" 192037"","" 501038"","" 351124"","" 14039"","" 71658"","" 341714"","" 502694"","" 354177"","" 504245"","" 342093"","" 192028"","" 12398"","" 352428"","" 350063"","" 501050"","" 352424"","" 351147"","" 13089"","" 13090"","" 354778"","" 13083"","" 352186"","" 12539"","" 501572"","" 13091"","" 21297"","" 503434"","" 13092"","" 351859"","" 13093"","" 21270"","" 13094"","" 352376"","" 13095"","" 13096"","" 501934"","" 13997"","" 13913"","" 13097"","" 13098"","" 13099"","" 349936"","" 348973"","" 343338"","" 13102"","" 14074"","" 354633"","" 21284"","" 361055"","" 13103"","" 21232"","" 507859"","" 13104"","" 13105"","" 351280"","" 13106"","" 13883"","" 351628"","" 352157"","" 14183"","" 13107"","" 5"","" 333045"","" 191144"","" 352409"","" 14167"","" 71620"","" 13108"","" 12452"","" 361058"","" 355033"","" 12556"","" 12557"","" 12625"","" 13187"","" 12743"","" 352427"","" 71646"","" 14033"","" 350722"","" 350721"","" 351119"","" 351121"","" 13109"","" 13945"","" 503521"","" 14151"","" 13055"","" 13054"","" 13052"","" 13051"","" 13110"","" 13053"","" 13050"","" 351322"","" 13111"","" 503849"","" 21291"","" 361135"","" 502285"","" 12274"","" 13112"","" 663087"","" 350815"","" 13113"","" 663656"","" 354562"","" 361152"","" 352419"","" 21384"","" 351937"","" 351888"","" 13939"","" 501055"","" 501935"","" 13114"","" 192038"","" 14046"","" 354703"","" 6"","" 351091"","" 13101"","" 13115"","" 13116"","" 349945"","" 13996"","" 12474"","" 14038"","" 21315"","" 352438"","" 351283"","" 13117"","" 503456"","" 13118"","" 349067"","" 351367"","" 71628"","" 501930"","" 13119"","" 13120"","" 13121"","" 351323"","" 13122"","" 13100"","" 351093"","" 190639"","" 13123"","" 663235"","" 662026"","" 361226"","" 190491"","" 350064"","" 349897"","" 21285"","" 71185"","" 13124"","" 13125"","" 14187"","" 662606"","" 13127"","" 13126"","" 13128"","" 14137"","" 502308"","" 501503"","" 13129"","" 351385"","" 342950"","" 347413"","" 353744"","" 12436"","" 14191"","" 13130"","" 342088"","" 13131"","" 13132"","" 13133"","" 503155"","" 13134"","" 354429"","" 12825"","" 191849"","" 13135"","" 13944"","" 501135"","" 71664"","" 129008"","" 13943"","" 21236"","" 501639"","" 13136"","" 128954"","" 19122"","" 14166"","" 71682"","" 354547"","" 503262"","" 13806"","" 21264"","" 350822"","" 191082"","" 21370"","" 350022"","" 350023"","" 13138"","" 13139"","" 13140"","" 13141"","" 13142"","" 13143"","" 13144"","" 13145"","" 13146"","" 13147"","" 13148"","" 13149"","" 13150"","" 13151"","" 13152"","" 13153"","" 13154"","" 13155"","" 13156"","" 13157"","" 13158"","" 13137"","" 354989"","" 361030"","" 13159"","" 14120"","" 352606"","" 12514"","" 13161"","" 351155"","" 13162"","" 350002"","" 13163"","" 13164"","" 13165"","" 13166"","" 13167"","" 13168"","" 13169"","" 13171"","" 13172"","" 13173"","" 13170"","" 13174"","" 13176"","" 13177"","" 502390"","" 13178"","" 13179"","" 21376"","" 13175"","" 13189"","" 13190"","" 13180"","" 506958"","" 12770"","" 502386"","" 353778"","" 13182"","" 13183"","" 13184"","" 13185"","" 349887"","" 13186"","" 14009"","" 13188"","" 12787"","" 13191"","" 507004"","" 13192"","" 13193"","" 21243"","" 13194"","" 13195"","" 13196"","" 12307"","" 12597"","" 13197"","" 127570"","" 19251"","" 13198"","" 127599"","" 19362"","" 14182"","" 13199"","" 190709"","" 354533"","" 12540"","" 354960"","" 13201"","" 13202"","" 13203"","" 13200"","" 13204"","" 350100"","" 664825"","" 664824"","" 13205"","" 663759"","" 507765"","" 190895"","" 502417"","" 663769"","" 13206"","" 13207"","" 662948"","" 662949"","" 354135""}'::text[])::integer[])) IS NOT NULL) OR (ah.lease_customer_id IS NOT NULL))
10. 453.306 10,721.526 ↓ 176,340.0 176,340 1

Nested Loop Left Join (cost=32.73..4,790.86 rows=1 width=783) (actual time=28.479..10,721.526 rows=176,340 loops=1)

11. 274.045 8,046.325 ↓ 170,915.0 170,915 1

Nested Loop (cost=31.65..4,785.70 rows=1 width=777) (actual time=28.372..8,046.325 rows=170,915 loops=1)

  • Join Filter: (gat.gl_tree_id = gt.id)
12. 202.060 7,430.450 ↓ 170,915.0 170,915 1

Nested Loop (cost=31.50..4,777.53 rows=1 width=781) (actual time=28.343..7,430.450 rows=170,915 loops=1)

13. 287.003 5,177.410 ↓ 170,915.0 170,915 1

Nested Loop Left Join (cost=31.08..4,775.46 rows=1 width=523) (actual time=28.257..5,177.410 rows=170,915 loops=1)

14. 278.356 4,548.577 ↓ 170,915.0 170,915 1

Nested Loop Left Join (cost=30.95..4,775.30 rows=1 width=516) (actual time=28.246..4,548.577 rows=170,915 loops=1)

15. 223.975 3,586.561 ↓ 170,915.0 170,915 1

Nested Loop Anti Join (cost=30.66..4,774.96 rows=1 width=516) (actual time=28.200..3,586.561 rows=170,915 loops=1)

16. 105.883 3,362.586 ↓ 172,944.0 172,944 1

Nested Loop Left Join (cost=30.23..4,773.99 rows=1 width=520) (actual time=28.197..3,362.586 rows=172,944 loops=1)

17. 163.436 3,083.759 ↓ 172,944.0 172,944 1

Nested Loop Left Join (cost=29.95..4,773.58 rows=1 width=327) (actual time=28.193..3,083.759 rows=172,944 loops=1)

18. 243.415 2,747.379 ↓ 172,944.0 172,944 1

Nested Loop (cost=29.66..4,773.07 rows=1 width=141) (actual time=28.189..2,747.379 rows=172,944 loops=1)

19. 96.364 1,163.457 ↓ 925.1 191,501 1

Nested Loop (cost=29.24..4,457.84 rows=207 width=77) (actual time=28.130..1,163.457 rows=191,501 loops=1)

20. 19.410 19.410 ↓ 29.0 29 1

Function Scan on load_properties load_prop (cost=0.25..1.00 rows=1 width=4) (actual time=19.275..19.410 rows=29 loops=1)

  • Filter: ((is_disabled = 0) AND (is_test = 0))
21. 1,005.575 1,047.683 ↓ 31.9 6,603 29

Bitmap Heap Scan on ap_details ad (cost=28.99..4,454.77 rows=207 width=77) (actual time=2.016..36.127 rows=6,603 loops=29)

  • Recheck Cond: ((cid = 224) AND (property_id = load_prop.property_id))
  • Filter: ((deleted_by IS NULL) AND (deleted_on IS NULL) AND (post_month <= '2019-06-01'::date) AND (retention_amount = '0'::numeric) AND (bank_account_id = ANY ('{5989,4426,5984,5980,5973,5990,5974,5993,5991,6005,5975,5996,5977,5994,6001,5997,6002,5978,5986,5998,5987,5979,5999,6003,6000,6004,4018,6067,4022,4017,4019,4020,4021,4100,4098,4101,4023,4024,4007,4012,4010,4011,4013,4114,4111,2672,2673,3974,146,3975,3976,152,145,148,135,131,3986,5932,4025,4110,4115,4109,4015,4108,4097,4233,4232,4231,4234,4235}'::integer[])))
  • Rows Removed by Filter: 2562
  • Heap Blocks: exact=96850
22. 42.108 42.108 ↓ 7.3 9,166 29

Bitmap Index Scan on idx_ap_details_cid_property_id (cost=0.00..28.94 rows=1,251 width=0) (actual time=1.452..1.452 rows=9,166 loops=29)

  • Index Cond: ((cid = 224) AND (property_id = load_prop.property_id))
23. 1,340.507 1,340.507 ↑ 1.0 1 191,501

Index Scan using idx_ap_headers on ap_headers ah (cost=0.42..1.51 rows=1 width=80) (actual time=0.007..0.007 rows=1 loops=191,501)

  • Index Cond: (id = ad.ap_header_id)
  • Filter: ((is_template IS FALSE) AND (is_posted OR (is_temporary AND (reversal_ap_header_id IS NULL))) AND (COALESCE(ap_financial_status_type_id, 0) <> 8) AND (ap_financial_status_type_id IS DISTINCT FROM 8) AND (cid = 224) AND (ap_header_type_id = 5) AND (ad.gl_transaction_type_id = gl_transaction_type_id) AND (ad.post_month = post_month))
  • Rows Removed by Filter: 0
24. 172.944 172.944 ↓ 0.0 0 172,944

Index Scan using pk_property_units on property_units pu (cost=0.29..0.50 rows=1 width=194) (actual time=0.001..0.001 rows=0 loops=172,944)

  • Index Cond: ((ad.cid = cid) AND (cid = 224) AND (ad.property_unit_id = id))
25. 172.944 172.944 ↓ 0.0 0 172,944

Index Scan using idx_property_buildings_id on property_buildings pb (cost=0.28..0.40 rows=1 width=209) (actual time=0.001..0.001 rows=0 loops=172,944)

  • Index Cond: (id = pu.property_building_id)
  • Filter: ((cid = 224) AND (cid = pu.cid))
26. 0.000 0.000 ↓ 0.0 0 172,944

Index Scan using idx_ap_headers on ap_headers ah_reversal (cost=0.42..0.96 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=172,944)

  • Index Cond: (id = ah.reversal_ap_header_id)
  • Filter: ((is_template IS FALSE) AND (post_month <= '2019-06-01'::date) AND (cid = 224) AND (cid = ah.cid))
  • Rows Removed by Filter: 0
27. 683.660 683.660 ↑ 1.0 1 170,915

Index Scan using pk_ap_remittances on ap_remittances apr (cost=0.29..0.34 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=170,915)

  • Index Cond: ((cid = ah.cid) AND (cid = 224) AND (id = ah.ap_remittance_id))
28. 341.830 341.830 ↑ 1.0 1 170,915

Index Scan using pk_ap_payment_types on ap_payment_types apt (cost=0.14..0.16 rows=1 width=15) (actual time=0.002..0.002 rows=1 loops=170,915)

  • Index Cond: (id = apr.ap_payment_type_id)
29. 2,050.980 2,050.980 ↑ 1.0 1 170,915

Index Scan using idx_gl_account_trees_gl_account_id on gl_account_trees gat (cost=0.42..2.06 rows=1 width=266) (actual time=0.008..0.012 rows=1 loops=170,915)

  • Index Cond: (gl_account_id = ad.gl_account_id)
  • Filter: ((cid = 224) AND (is_default = 1))
  • Rows Removed by Filter: 6
30. 341.830 341.830 ↑ 1.0 1 170,915

Index Scan using idx_gl_trees_cid_is_system on gl_trees gt (cost=0.14..8.16 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=170,915)

  • Index Cond: (cid = 224)
31. 683.660 2,221.895 ↑ 1.0 1 170,915

Bitmap Heap Scan on ap_allocations aa (cost=1.08..5.15 rows=1 width=18) (actual time=0.012..0.013 rows=1 loops=170,915)

  • Recheck Cond: ((ad.id = charge_ap_detail_id) OR (ad.id = credit_ap_detail_id))
  • Filter: ((post_month <= '2019-06-01'::date) AND (cid = 224) AND (cid = ad.cid))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=180778
32. 170.915 1,538.235 ↓ 0.0 0 170,915

BitmapOr (cost=1.08..1.08 rows=3 width=0) (actual time=0.009..0.009 rows=0 loops=170,915)

33. 683.660 683.660 ↑ 1.0 1 170,915

Bitmap Index Scan on idx_ap_allocations_charge_ap_detail_id (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=170,915)

  • Index Cond: (ad.id = charge_ap_detail_id)
34. 683.660 683.660 ↑ 1.0 1 170,915

Bitmap Index Scan on idx_ap_allocations_credit_ap_detail_id (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=170,915)

  • Index Cond: (ad.id = credit_ap_detail_id)
35. 202,791.000 202,791.000 ↓ 24.8 2,482 176,340

ProjectSet (cost=0.00..0.52 rows=100 width=4) (actual time=0.670..1.150 rows=2,482 loops=176,340)

36. 0.000 0.000 ↑ 1.0 1 176,340

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=176,340)

37. 705.360 705.360 ↑ 1.0 1 176,340

Index Scan using idx_bank_accounts on bank_accounts ba (cost=0.28..0.30 rows=1 width=29) (actual time=0.004..0.004 rows=1 loops=176,340)

  • Index Cond: (id = ad.bank_account_id)
  • Filter: (cid = 224)
  • Rows Removed by Filter: 0
38. 705.360 705.360 ↑ 1.0 1 176,340

Index Scan using idx_ap_payees_id on ap_payees ap (cost=0.29..0.34 rows=1 width=31) (actual time=0.004..0.004 rows=1 loops=176,340)

  • Index Cond: (id = ah.ap_payee_id)
  • Filter: ((cid = 224) AND (cid = ah.cid))
  • Rows Removed by Filter: 0
39. 705.360 705.360 ↑ 1.0 1 176,340

Index Scan using idx_ap_payee_locations_id on ap_payee_locations apl (cost=0.29..0.34 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=176,340)

  • Index Cond: (id = ah.ap_payee_location_id)
  • Filter: ((cid = 224) AND (cid = ah.cid))
  • Rows Removed by Filter: 0
40. 0.000 0.000 ↓ 0.0 0 176,340

Index Scan using pk_gl_dimensions on gl_dimensions gd (cost=0.14..0.17 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=176,340)

  • Index Cond: ((ad.cid = cid) AND (cid = 224) AND (ad.gl_dimension_id = id))
41. 0.000 0.000 ↓ 0.0 0 176,340

Index Scan using idx_company_departments_id on company_departments cd (cost=0.28..0.30 rows=1 width=642) (actual time=0.000..0.000 rows=0 loops=176,340)

  • Index Cond: (ad.company_department_id = id)
  • Filter: ((cid = 224) AND (ad.cid = cid))
42. 0.000 0.000 ↓ 0.0 0 176,340

Index Scan using pk_ap_routing_tags on ap_routing_tags art (cost=0.14..0.16 rows=1 width=23) (actual time=0.000..0.000 rows=0 loops=176,340)

  • Index Cond: ((ah.cid = cid) AND (cid = 224) AND (ah.ap_routing_tag_id = id))
Planning time : 38.865 ms