explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AyQS

Settings
# exclusive inclusive rows x rows loops node
1. 3.218 77.992 ↓ 7.4 909 1

GroupAggregate (cost=3,246.80..3,265.86 rows=123 width=1,650) (actual time=74.717..77.992 rows=909 loops=1)

  • Group Key: outer_details.property_name, outer_details.account_number, outer_details.is_beginning_balance, outer_details.transaction_date, outer_details.post_month, outer_details.post_date, outer_details.gl_detail_id, outer_details.property_id, outer_details.lookup_code, outer_details.grouping_gl_account_id, outer_details.gl_account, outer_details.account_name, outer_details.gl_transaction_type_id, outer_details.transaction_type, outer_details.transaction_type_id, outer_details.gh_header_id, outer_details.header_number, outer_details.reference_id, outer_details.reference, outer_details.transaction_id, outer_details.memo, outer_details.details, outer_details.ar_code_type_id, outer_details.ar_trigger_id, outer_details.ar_code_id, outer_details.ar_transaction_payment_id, outer_details.job, outer_details.job_cost_code, outer_details.ap_payment_id, outer_details.ar_payment_id, outer_details.art_id, outer_details.vendor_id, outer_details.resident, outer_details.bldg_unit, outer_details.display_number, outer_details.lease_id, outer_details.occupancy_type_id, outer_details.customer_id, outer_details.beginning_balance, outer_details.hide_zero_beginning_balance_for_no_activities, outer_details.min_debit, outer_details.min_credit, outer_details.min_beginning_balance, outer_details.max_debit, outer_details.max_credit, outer_details.max_beginning_balance
2. 6.857 74.774 ↓ 7.4 915 1

Sort (cost=3,246.80..3,247.10 rows=123 width=1,618) (actual time=74.685..74.774 rows=915 loops=1)

  • Sort Key: outer_details.property_name, outer_details.account_number, outer_details.is_beginning_balance DESC, outer_details.transaction_date, outer_details.post_month, outer_details.post_date, outer_details.gl_detail_id, outer_details.property_id, outer_details.lookup_code, outer_details.grouping_gl_account_id, outer_details.gl_account, outer_details.account_name, outer_details.gl_transaction_type_id, outer_details.transaction_type, outer_details.transaction_type_id, outer_details.gh_header_id, outer_details.header_number, outer_details.reference_id, outer_details.reference, outer_details.transaction_id, outer_details.memo, outer_details.details, outer_details.ar_code_type_id, outer_details.ar_trigger_id, outer_details.ar_code_id, outer_details.ar_transaction_payment_id, outer_details.job, outer_details.job_cost_code, outer_details.ap_payment_id, outer_details.ar_payment_id, outer_details.art_id, outer_details.vendor_id, outer_details.resident, outer_details.bldg_unit, outer_details.display_number, outer_details.lease_id, outer_details.occupancy_type_id, outer_details.customer_id, outer_details.beginning_balance, outer_details.hide_zero_beginning_balance_for_no_activities, outer_details.min_debit, outer_details.min_credit, outer_details.min_beginning_balance, outer_details.max_debit, outer_details.max_credit, outer_details.max_beginning_balance
  • Sort Method: quicksort Memory: 746kB
3. 0.285 67.917 ↓ 7.4 915 1

Subquery Scan on outer_details (cost=3,237.88..3,242.53 rows=123 width=1,618) (actual time=66.445..67.917 rows=915 loops=1)

  • Filter: (outer_details.hide_zero_beginning_balance_for_no_activities <> 1)
  • Rows Removed by Filter: 43
4. 1.125 67.632 ↓ 7.7 958 1

WindowAgg (cost=3,237.88..3,240.98 rows=124 width=1,654) (actual time=66.441..67.632 rows=958 loops=1)

5. 1.376 66.507 ↓ 7.7 958 1

Sort (cost=3,237.88..3,238.19 rows=124 width=1,610) (actual time=66.425..66.507 rows=958 loops=1)

  • Sort Key: details.property_id, details.grouping_gl_account_id
  • Sort Method: quicksort Memory: 757kB
6. 1.849 65.131 ↓ 7.7 958 1

WindowAgg (cost=3,229.53..3,233.56 rows=124 width=1,610) (actual time=63.272..65.131 rows=958 loops=1)

7. 1.568 63.282 ↓ 7.7 958 1

Sort (cost=3,229.53..3,229.84 rows=124 width=1,418) (actual time=63.155..63.282 rows=958 loops=1)

  • Sort Key: details.property_id, details.gl_account
  • Sort Method: quicksort Memory: 662kB
8. 0.322 61.714 ↓ 7.7 958 1

Subquery Scan on details (cost=293.51..3,225.22 rows=124 width=1,418) (actual time=10.620..61.714 rows=958 loops=1)

9. 0.110 61.392 ↓ 7.7 958 1

Append (cost=293.51..3,223.98 rows=124 width=1,454) (actual time=10.619..61.392 rows=958 loops=1)

10. 0.364 59.296 ↓ 383.0 766 1

Result (cost=293.51..3,182.76 rows=2 width=1,440) (actual time=10.618..59.296 rows=766 loops=1)

11. 0.109 58.932 ↓ 383.0 766 1

Append (cost=293.51..3,182.74 rows=2 width=1,412) (actual time=10.614..58.932 rows=766 loops=1)

12. 10.785 54.824 ↓ 728.0 728 1

Nested Loop Left Join (cost=293.51..2,701.68 rows=1 width=1,225) (actual time=10.613..54.824 rows=728 loops=1)

13. 1.002 42.583 ↓ 728.0 728 1

Nested Loop Left Join (cost=293.09..2,700.00 rows=1 width=1,113) (actual time=8.803..42.583 rows=728 loops=1)

14. 0.715 39.397 ↓ 728.0 728 1

Nested Loop Left Join (cost=292.67..2,691.83 rows=1 width=1,064) (actual time=8.786..39.397 rows=728 loops=1)

15. 0.554 23.394 ↓ 728.0 728 1

Nested Loop Left Join (cost=292.52..2,688.71 rows=1 width=1,052) (actual time=8.756..23.394 rows=728 loops=1)

16. 0.413 22.112 ↓ 728.0 728 1

Nested Loop Left Join (cost=292.38..2,688.55 rows=1 width=1,038) (actual time=8.741..22.112 rows=728 loops=1)

  • Join Filter: (gh.cid = art1.cid)
17. 1.085 19.515 ↓ 728.0 728 1

Nested Loop Left Join (cost=291.94..2,685.87 rows=1 width=813) (actual time=8.731..19.515 rows=728 loops=1)

  • Join Filter: (gh.gl_transaction_type_id = ANY ('{7,8,9,17}'::integer[]))
  • Rows Removed by Join Filter: 252
18. 0.238 14.790 ↓ 728.0 728 1

Nested Loop Left Join (cost=1.85..2,391.74 rows=1 width=801) (actual time=8.703..14.790 rows=728 loops=1)

  • Join Filter: (gh.gl_transaction_type_id = ANY ('{13,14,18,23,24}'::integer[]))
19. 3.059 12.368 ↓ 728.0 728 1

Nested Loop (cost=1.41..2,387.97 rows=1 width=793) (actual time=8.686..12.368 rows=728 loops=1)

  • Join Filter: (gh.gl_transaction_type_id = gtty.id)
  • Rows Removed by Join Filter: 18,928
20. 0.048 0.048 ↑ 1.0 27 1

Index Scan using pk_gl_transaction_types on gl_transaction_types gtty (cost=0.14..26.65 rows=27 width=24) (actual time=0.006..0.048 rows=27 loops=1)

21. 2.191 9.261 ↓ 728.0 728 27

Materialize (cost=1.28..2,360.92 rows=1 width=773) (actual time=0.002..0.343 rows=728 loops=27)

22. 0.767 7.070 ↓ 728.0 728 1

Nested Loop (cost=1.28..2,360.91 rows=1 width=773) (actual time=0.061..7.070 rows=728 loops=1)

23. 0.178 6.303 ↓ 728.0 728 1

Nested Loop (cost=1.28..2,359.89 rows=1 width=242) (actual time=0.054..6.303 rows=728 loops=1)

24. 0.763 3.941 ↓ 5.9 728 1

Nested Loop (cost=0.84..1,318.54 rows=123 width=142) (actual time=0.038..3.941 rows=728 loops=1)

25. 0.964 0.964 ↓ 3.7 738 1

Index Scan using idx_gl_details_cid_property_id_post_month_lease_id_reference_id on gl_details gd (cost=0.56..850.04 rows=200 width=73) (actual time=0.024..0.964 rows=738 loops=1)

  • Index Cond: ((cid = 224) AND (property_id = 2,458) AND (post_month >= '2020-09-01'::date) AND (post_month <= '2020-09-01'::date) AND (gl_transaction_type_id = ANY ('{13,14,18,23,24,7,8,9,17}'::integer[])))
26. 2.214 2.214 ↑ 1.0 1 738

Index Scan using idx_temp_gat_gl_account_id on gat_temp gat (cost=0.28..2.33 rows=1 width=81) (actual time=0.003..0.003 rows=1 loops=738)

  • Index Cond: (gl_account_id = gd.accrual_gl_account_id)
  • Filter: ((cid = 224) AND (grouping_gl_account_id = ANY ('{85277,85280,85433,85281,305438,305002,304963,305035,305036,305015,305014,305012,305003,305001,305038,305011,160491,160486,160709,160706,302422,302423,302424,85279,160690,160708,160299,160705,160702,160487,160711,160703,160713,160710,160300,160707,160488,160704,160712,160301,160689,160492,304892,160688,300317,85282,160490,160302,161786,160749,161787,160303,161788,161397,161789,160304,302192,302425,302426,160538,302609,307666,160539,302615,302614,160540,302429,160541,304453,307624,162297,302412,302413,302414,302415,302416,302610,302611,302612,302417,302620,305360,302418,302419,302420,302427,302613,302598,302599,324066,302596,302597,302616,302617,302595,302594,302608,302602,302603,302604,302605,302600,302601,160306,302428,302606,302618,302619,302607,304882,304883,306808,160493,162224,85278,85283,163001,160307,162999,238064,160308,160309,160542,160310,160311,85256,160312,160313,160314,161392,85275,238178,300318,160315,300319,160316,300365,160317,160318,160543,160319,160544,160320,160545,160321,160714,162295,160494,160546,300320,160780,160781,160495,160496,160497,160322,160323,160324,160325,160326,85255,300321,160328,160330,160332,160333,161393,85342,160335,160782,160336,160750,161394,85341,160751,160752,160337,300322,160338,160498,160772,301891,238082,302200,300323,160339,160340,85258,160341,238181,238182,160499,160547,160342,160343,160548,160344,160345,160346,85257,160349,161395,160352,160353,160719,160354,160773,160355,160356,160357,160358,160359,160360,160362,160363,85276,85286,85246,85268,85247,85259,160365,160367,160368,300324,302198,301942,301943,160369,160549,160753,160370,160500,160501,302202,302203,85343,85344,162996,163003,163004,161934,238747,85270,85271,85269,160371,302199,302201,161403,160372,160373,160374,160375,160376,160378,160379,160783,160380,160381,160720,160382,302430,301944,160383,162298,160774,162070,162071,162072,162296,160775,160776,160777,160778,160755,160756,162299,160757,160758,160759,160760,301945,160384,160385,300366,300316,161510,160386,160387,160550,162176,85272,160388,300195,85260,85273,163000,85274,85284,160784,85334,85248,85335,85249,85250,85251,85312,85336,85337,85338,85339,85340,85252,85290,85345,160691,85253,302204,160692,162029,324826,238112,162048,301899,160508,160551,162243,162178,162251,307848,307861,307829,300059,307852,307818,307862,307830,300060,307853,307819,307863,307831,300061,307820,307864,307832,307821,300325,160693,162030,324827,238113,162049,301900,160509,160552,162244,162179,162252,307833,300326,160694,162031,324828,238114,162050,301901,160510,160553,162245,162180,307834,162253,324789,162254,162255,162256,300327,160744,162032,324829,238115,162051,301902,160511,160554,162246,162181,162257,307835,300328,160745,162033,324830,238116,162052,301903,160512,160555,162182,162258,307836,304548,300329,160746,162034,324831,238117,162053,301904,160513,160556,162183,162259,307837,302195,160747,162035,324832,238118,162054,301905,160514,300062,162184,162260,307838,302196,160748,162036,324833,238119,301906,160515,300063,162185,162261,307839,301887,302197,302205,160785,162037,324834,238120,162055,301907,160786,300064,162186,162262,307840,302206,160389,162038,324835,238121,301908,162064,300065,162263,307841,162187,162189,162190,162191,162192,162193,302207,160390,162039,238122,301909,162065,307057,307058,307059,307060,162188,162264,307842,302208,160391,162225,238123,301910,162066,162194,162265,307843,302209,160392,162040,238124,301911,160727,162195,162266,307844,160393,162041,238125,301912,160728,162196,162267,307845,237661,237662,160502,162042,238126,301913,160729,162197,307846,160503,162043,238127,301914,162198,162268,307847,160504,162044,238128,301915,162269,160505,162045,238129,301916,162199,162270,160506,162046,238130,301917,162200,162271,160507,162047,238131,324808,162272,307865,238132,307854,238133,307855,307856,307857,307858,162997,302431,302210,307492,160516,324816,238134,162056,301918,304261,304273,162330,162273,302512,302517,238607,304262,304274,302518,238608,304263,304275,302513,302519,238609,304264,302514,300330,303273,302520,160517,324817,238135,162057,301919,304265,304276,162331,162274,300331,304266,300332,300333,300334,303274,302522,160518,324818,238136,162058,301920,304267,304277,162332,304268,162275,324788,162276,162277,162278,300335,303275,302524,160519,324819,238137,162059,301921,304269,304278,162333,162279,304270,300336,303276,302523,160520,324820,238138,162060,301922,304271,162334,162280,304547,300337,302525,160521,324821,238139,162061,301923,304272,162335,162281,302526,160522,324822,238140,162062,301924,162336,162282,302211,302527,160523,324823,238141,301925,162337,162283,301888,302212,302528,160524,324824,238142,162063,301926,162338,162284,302213,302529,160525,324825,238143,301927,162339,162285,302214,302530,160526,324815,238144,301928,162340,162286,302215,302531,160527,238145,301929,162341,162287,160528,302532,160529,238146,301930,162342,162288,302533,160530,238147,301931,162343,162289,237663,237664,307860,302534,160531,238148,301932,162344,302535,160532,238149,301933,162345,162290,302521,160533,238150,301934,162346,162291,302536,160534,238151,301935,162347,162292,302537,238152,301936,162348,162293,238153,162349,162294,238154,162350,162750,238155,162351,162751,162352,162752,324807,162753,302488,238156,304527,302489,302538,302490,302491,238157,302539,304528,302492,238158,302540,304529,302493,238159,302541,304530,302494,238160,302542,304531,302495,238161,302543,304532,302496,238162,302544,304533,302497,238163,304534,302498,238164,302545,304535,302499,238165,304536,302500,238166,304537,302501,238167,304538,302502,238168,304539,302503,238169,304540,302504,238170,304541,302505,238171,304542,302506,238172,304543,302507,238173,304544,238174,304545,160787,238175,304546,238077,300018,300019,300020,160394,238176,160730,162237,162247,162201,161794,238074,300066,300075,238090,238075,300067,300074,238091,238076,300068,300073,238092,160395,238177,160731,162238,162248,162202,161795,160396,160732,162239,162203,161796,160721,162226,162240,162249,162204,161797,160722,162241,162250,162205,160723,162227,162242,162206,161798,160724,162301,300069,162207,161799,160725,162228,300070,162208,160726,162229,300071,162209,161800,161396,162230,300072,161801,162210,162211,162212,162213,162214,162215,160733,162231,307053,307054,307055,307056,162216,161802,160734,162232,162217,161803,160735,162233,162218,161804,160736,162234,162219,161805,160737,162235,162220,161806,160738,162236,162221,162745,160739,162746,304837,304838,160740,162222,162747,160741,162223,162748,160788,324809,162749,160789,162998,160397,85254,157005,85261,85262,150974,85263,163002,85264,85288,300376,300377,300378,300379,300380,300381,300382,85289,85291,85292,85293,85294,157006,85295,85296,155346,85297,150976,85298,85299,302410,302411,85285,238035,161398,160347,160348,85300,163239,301473,85301,300308,300309,300310,160350,160398,85303,161935,160351,160364,85305,160366,160754,160465,85308,85309,85310,85311,85313,85314,85315,85316,85319,85320,85321,85322,85323,85324,85265,85266,85317,85325,85326,85327,85328,85329,160402,300311,85287,160403,160404,160405,160406,160407,303272,160408,160409,160410,160411,160412,160413,161933,160414,160415,161401,85330,85331,160334,160331,160327,160329,160472,85304,160361,302432,85306,85307,160416,160417,299099,302433,160418,160419,160420,160421,271839,160422,301938,160423,160424,160425,160426,160427,302182,302183,300312,160790,160428,302181,160429,160535,160430,160431,160438,271841,160439,160440,160441,160442,160443,160444,160445,271840,160446,160447,238598,160448,271838,160449,238547,238584,238546,160450,160451,160452,160453,160454,160455,160456,238695,238697,238698,238699,238700,238701,238702,238703,238704,238705,238706,238707,238708,238709,238710,238711,238712,238713,238714,238715,238716,238717,238718,238719,238720,238721,238722,238723,238724,238725,160457,85318,160458,160459,162754,160460,301849,305437,301845,305093,301846,301847,301848,302621,307067,307583,301596,301597,302434,300313,302258,302259,301598,301599,160461,162303,160462,160463,160464,160466,85332,300370,300371,300372,300373,300374,300375,160537,162353,301889,160467,160468,160469,85302,160470,160471,160536,160473,160557,160474,160475,160476,160477,160478,160479,160480,160743,160761,162067,162068,162069,160762,160763,160764,160765,160766,160767,160768,160769,160770,160771,160695,161790,161791,161792,161793,160481,160482,300364,160742,160791,160483,160484,160558,160485,160696,160432,300314,160433,160434,301890,160779,85333,160435,160436,300315,85267,160437}'::integer[])))
27. 2.184 2.184 ↑ 1.0 1 728

Index Scan using pk_gl_headers on gl_headers gh (cost=0.43..8.47 rows=1 width=104) (actual time=0.003..0.003 rows=1 loops=728)

  • Index Cond: ((cid = 224) AND (id = gd.gl_header_id))
  • Filter: ((NOT is_template) AND (gl_book_id = 132) AND ((gl_header_status_type_id <> ALL ('{4,5,6}'::integer[])) OR ((gl_transaction_type_id = 1) AND (gl_header_status_type_id = 2))))
28. 0.000 0.000 ↑ 1.0 1 728

Seq Scan on load_prop (cost=0.00..1.01 rows=1 width=535) (actual time=0.000..0.000 rows=1 loops=728)

  • Filter: (property_id = 2,458)
29. 2.184 2.184 ↓ 0.0 0 728

Index Scan using pk_ar_allocations on ar_allocations ara (cost=0.43..3.75 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=728)

  • Index Cond: ((cid = gh.cid) AND (cid = 224) AND (id = gh.reference_id))
30. 0.728 3.640 ↑ 1.0 1 728

Bitmap Heap Scan on ar_transactions art (cost=290.10..294.12 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=728)

  • Recheck Cond: (((cid = 224) AND (id = gh.reference_id)) OR ((cid = 224) AND (id = ara.credit_ar_transaction_id)))
  • Filter: (gh.cid = cid)
  • Heap Blocks: exact=728
31. 0.728 2.912 ↓ 0.0 0 728

BitmapOr (cost=290.10..290.10 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=728)

32. 1.456 1.456 ↑ 1.0 1 728

Bitmap Index Scan on pk_ar_transactions (cost=0.00..1.16 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=728)

  • Index Cond: ((cid = 224) AND (id = gh.reference_id))
33. 0.728 0.728 ↓ 0.0 0 728

Bitmap Index Scan on pk_ar_transactions (cost=0.00..0.64 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=728)

  • Index Cond: ((cid = 224) AND (id = ara.credit_ar_transaction_id))
34. 2.184 2.184 ↑ 1.0 1 728

Index Scan using pk_ar_transactions on ar_transactions art1 (cost=0.43..2.66 rows=1 width=233) (actual time=0.003..0.003 rows=1 loops=728)

  • Index Cond: ((cid = 224) AND (id = COALESCE(ara.charge_ar_transaction_id, art.id)))
35. 0.728 0.728 ↑ 1.0 1 728

Index Scan using pk_ar_triggers on ar_triggers att (cost=0.14..0.16 rows=1 width=18) (actual time=0.001..0.001 rows=1 loops=728)

  • Index Cond: (id = art1.ar_trigger_id)
36. 15.288 15.288 ↑ 1.0 1 728

Index Scan using idx_temp_cid on ar_codes_temp ac (cost=0.14..3.12 rows=1 width=24) (actual time=0.012..0.021 rows=1 loops=728)

  • Index Cond: ((cid = art1.cid) AND (cid = 224))
  • Filter: (id = art1.ar_code_id)
  • Rows Removed by Filter: 131
37. 2.184 2.184 ↑ 1.0 1 728

Index Scan using pk_cached_leases on cached_leases cl (cost=0.42..8.17 rows=1 width=61) (actual time=0.003..0.003 rows=1 loops=728)

  • Index Cond: ((cid = gd.cid) AND (cid = 224) AND (id = gd.lease_id))
38. 1.456 1.456 ↓ 0.0 0 728

Index Scan using pk_ar_deposits on ar_deposits ad (cost=0.42..0.79 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=728)

  • Index Cond: ((cid = 224) AND (id = gh.reference_id))
  • Filter: (gh.gl_transaction_type_id = gl_transaction_type_id)
39. 0.023 3.999 ↓ 38.0 38 1

Subquery Scan on "*SELECT* 2" (cost=6.51..481.04 rows=1 width=1,097) (actual time=0.898..3.999 rows=38 loops=1)

40. 0.266 3.976 ↓ 38.0 38 1

Nested Loop Left Join (cost=6.51..481.03 rows=1 width=1,097) (actual time=0.893..3.976 rows=38 loops=1)

41. 0.028 3.596 ↓ 38.0 38 1

Nested Loop Left Join (cost=6.09..479.53 rows=1 width=979) (actual time=0.809..3.596 rows=38 loops=1)

42. 0.045 3.454 ↓ 38.0 38 1

Nested Loop Left Join (cost=5.80..479.20 rows=1 width=968) (actual time=0.796..3.454 rows=38 loops=1)

43. 0.034 3.409 ↓ 38.0 38 1

Nested Loop Left Join (cost=5.38..478.48 rows=1 width=962) (actual time=0.778..3.409 rows=38 loops=1)

44. 0.039 3.299 ↓ 38.0 38 1

Nested Loop Left Join (cost=4.96..477.77 rows=1 width=952) (actual time=0.766..3.299 rows=38 loops=1)

45. 0.042 3.260 ↓ 38.0 38 1

Nested Loop Left Join (cost=4.54..477.03 rows=1 width=924) (actual time=0.756..3.260 rows=38 loops=1)

46. 0.039 3.218 ↓ 38.0 38 1

Nested Loop Left Join (cost=4.11..476.28 rows=1 width=916) (actual time=0.742..3.218 rows=38 loops=1)

47. 0.037 3.065 ↓ 38.0 38 1

Nested Loop Left Join (cost=3.69..475.77 rows=1 width=920) (actual time=0.731..3.065 rows=38 loops=1)

48. 0.039 3.028 ↓ 38.0 38 1

Nested Loop Left Join (cost=3.26..474.83 rows=1 width=916) (actual time=0.721..3.028 rows=38 loops=1)

49. 0.046 2.913 ↓ 38.0 38 1

Nested Loop Left Join (cost=2.84..474.17 rows=1 width=883) (actual time=0.712..2.913 rows=38 loops=1)

50. 0.539 2.867 ↓ 38.0 38 1

Nested Loop Left Join (cost=2.69..473.98 rows=1 width=898) (actual time=0.701..2.867 rows=38 loops=1)

  • Join Filter: ((pu.cid = gd_1.cid) AND (pu.id = CASE WHEN (gd_1.gl_transaction_type_id = 1) THEN gd_1.property_unit_id ELSE COALESCE(ad1.property_unit_id, ad_1.property_unit_id) END))
  • Rows Removed by Join Filter: 5,624
51. 0.040 1.568 ↓ 38.0 38 1

Nested Loop Left Join (cost=2.69..468.54 rows=1 width=905) (actual time=0.655..1.568 rows=38 loops=1)

52. 0.046 1.376 ↓ 38.0 38 1

Nested Loop Left Join (cost=2.27..461.85 rows=1 width=867) (actual time=0.645..1.376 rows=38 loops=1)

53. 0.053 1.254 ↓ 38.0 38 1

Nested Loop Left Join (cost=1.84..460.04 rows=1 width=825) (actual time=0.634..1.254 rows=38 loops=1)

  • Join Filter: (gh_1.gl_transaction_type_id = ANY ('{4,5}'::integer[]))
54. 0.054 1.087 ↓ 38.0 38 1

Nested Loop (cost=1.41..459.01 rows=1 width=813) (actual time=0.613..1.087 rows=38 loops=1)

55. 0.037 0.995 ↓ 38.0 38 1

Nested Loop (cost=1.28..458.85 rows=1 width=789) (actual time=0.598..0.995 rows=38 loops=1)

56. 0.047 0.806 ↓ 4.2 38 1

Nested Loop (cost=0.84..385.68 rows=9 width=689) (actual time=0.574..0.806 rows=38 loops=1)

57. 0.019 0.607 ↓ 2.5 38 1

Nested Loop (cost=0.56..357.79 rows=15 width=620) (actual time=0.554..0.607 rows=38 loops=1)

58. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on load_prop load_prop_1 (cost=0.00..1.01 rows=1 width=535) (actual time=0.006..0.007 rows=1 loops=1)

59. 0.581 0.581 ↓ 2.5 38 1

Index Scan using idx_gl_details_cid_property_id_post_month_lease_id_reference_id on gl_details gd_1 (cost=0.56..356.63 rows=15 width=89) (actual time=0.542..0.581 rows=38 loops=1)

  • Index Cond: ((cid = 224) AND (property_id = load_prop_1.property_id) AND (post_month >= '2020-09-01'::date) AND (post_month <= '2020-09-01'::date))
  • Filter: (gl_transaction_type_id <> ALL ('{13,14,18,23,24,7,8,9,17}'::integer[]))
  • Rows Removed by Filter: 738
60. 0.152 0.152 ↑ 1.0 1 38

Index Scan using idx_temp_gat_gl_account_id on gat_temp gat_1 (cost=0.28..1.85 rows=1 width=81) (actual time=0.004..0.004 rows=1 loops=38)

  • Index Cond: (gl_account_id = gd_1.accrual_gl_account_id)
  • Filter: ((cid = 224) AND (grouping_gl_account_id = ANY ('{85277,85280,85433,85281,305438,305002,304963,305035,305036,305015,305014,305012,305003,305001,305038,305011,160491,160486,160709,160706,302422,302423,302424,85279,160690,160708,160299,160705,160702,160487,160711,160703,160713,160710,160300,160707,160488,160704,160712,160301,160689,160492,304892,160688,300317,85282,160490,160302,161786,160749,161787,160303,161788,161397,161789,160304,302192,302425,302426,160538,302609,307666,160539,302615,302614,160540,302429,160541,304453,307624,162297,302412,302413,302414,302415,302416,302610,302611,302612,302417,302620,305360,302418,302419,302420,302427,302613,302598,302599,324066,302596,302597,302616,302617,302595,302594,302608,302602,302603,302604,302605,302600,302601,160306,302428,302606,302618,302619,302607,304882,304883,306808,160493,162224,85278,85283,163001,160307,162999,238064,160308,160309,160542,160310,160311,85256,160312,160313,160314,161392,85275,238178,300318,160315,300319,160316,300365,160317,160318,160543,160319,160544,160320,160545,160321,160714,162295,160494,160546,300320,160780,160781,160495,160496,160497,160322,160323,160324,160325,160326,85255,300321,160328,160330,160332,160333,161393,85342,160335,160782,160336,160750,161394,85341,160751,160752,160337,300322,160338,160498,160772,301891,238082,302200,300323,160339,160340,85258,160341,238181,238182,160499,160547,160342,160343,160548,160344,160345,160346,85257,160349,161395,160352,160353,160719,160354,160773,160355,160356,160357,160358,160359,160360,160362,160363,85276,85286,85246,85268,85247,85259,160365,160367,160368,300324,302198,301942,301943,160369,160549,160753,160370,160500,160501,302202,302203,85343,85344,162996,163003,163004,161934,238747,85270,85271,85269,160371,302199,302201,161403,160372,160373,160374,160375,160376,160378,160379,160783,160380,160381,160720,160382,302430,301944,160383,162298,160774,162070,162071,162072,162296,160775,160776,160777,160778,160755,160756,162299,160757,160758,160759,160760,301945,160384,160385,300366,300316,161510,160386,160387,160550,162176,85272,160388,300195,85260,85273,163000,85274,85284,160784,85334,85248,85335,85249,85250,85251,85312,85336,85337,85338,85339,85340,85252,85290,85345,160691,85253,302204,160692,162029,324826,238112,162048,301899,160508,160551,162243,162178,162251,307848,307861,307829,300059,307852,307818,307862,307830,300060,307853,307819,307863,307831,300061,307820,307864,307832,307821,300325,160693,162030,324827,238113,162049,301900,160509,160552,162244,162179,162252,307833,300326,160694,162031,324828,238114,162050,301901,160510,160553,162245,162180,307834,162253,324789,162254,162255,162256,300327,160744,162032,324829,238115,162051,301902,160511,160554,162246,162181,162257,307835,300328,160745,162033,324830,238116,162052,301903,160512,160555,162182,162258,307836,304548,300329,160746,162034,324831,238117,162053,301904,160513,160556,162183,162259,307837,302195,160747,162035,324832,238118,162054,301905,160514,300062,162184,162260,307838,302196,160748,162036,324833,238119,301906,160515,300063,162185,162261,307839,301887,302197,302205,160785,162037,324834,238120,162055,301907,160786,300064,162186,162262,307840,302206,160389,162038,324835,238121,301908,162064,300065,162263,307841,162187,162189,162190,162191,162192,162193,302207,160390,162039,238122,301909,162065,307057,307058,307059,307060,162188,162264,307842,302208,160391,162225,238123,301910,162066,162194,162265,307843,302209,160392,162040,238124,301911,160727,162195,162266,307844,160393,162041,238125,301912,160728,162196,162267,307845,237661,237662,160502,162042,238126,301913,160729,162197,307846,160503,162043,238127,301914,162198,162268,307847,160504,162044,238128,301915,162269,160505,162045,238129,301916,162199,162270,160506,162046,238130,301917,162200,162271,160507,162047,238131,324808,162272,307865,238132,307854,238133,307855,307856,307857,307858,162997,302431,302210,307492,160516,324816,238134,162056,301918,304261,304273,162330,162273,302512,302517,238607,304262,304274,302518,238608,304263,304275,302513,302519,238609,304264,302514,300330,303273,302520,160517,324817,238135,162057,301919,304265,304276,162331,162274,300331,304266,300332,300333,300334,303274,302522,160518,324818,238136,162058,301920,304267,304277,162332,304268,162275,324788,162276,162277,162278,300335,303275,302524,160519,324819,238137,162059,301921,304269,304278,162333,162279,304270,300336,303276,302523,160520,324820,238138,162060,301922,304271,162334,162280,304547,300337,302525,160521,324821,238139,162061,301923,304272,162335,162281,302526,160522,324822,238140,162062,301924,162336,162282,302211,302527,160523,324823,238141,301925,162337,162283,301888,302212,302528,160524,324824,238142,162063,301926,162338,162284,302213,302529,160525,324825,238143,301927,162339,162285,302214,302530,160526,324815,238144,301928,162340,162286,302215,302531,160527,238145,301929,162341,162287,160528,302532,160529,238146,301930,162342,162288,302533,160530,238147,301931,162343,162289,237663,237664,307860,302534,160531,238148,301932,162344,302535,160532,238149,301933,162345,162290,302521,160533,238150,301934,162346,162291,302536,160534,238151,301935,162347,162292,302537,238152,301936,162348,162293,238153,162349,162294,238154,162350,162750,238155,162351,162751,162352,162752,324807,162753,302488,238156,304527,302489,302538,302490,302491,238157,302539,304528,302492,238158,302540,304529,302493,238159,302541,304530,302494,238160,302542,304531,302495,238161,302543,304532,302496,238162,302544,304533,302497,238163,304534,302498,238164,302545,304535,302499,238165,304536,302500,238166,304537,302501,238167,304538,302502,238168,304539,302503,238169,304540,302504,238170,304541,302505,238171,304542,302506,238172,304543,302507,238173,304544,238174,304545,160787,238175,304546,238077,300018,300019,300020,160394,238176,160730,162237,162247,162201,161794,238074,300066,300075,238090,238075,300067,300074,238091,238076,300068,300073,238092,160395,238177,160731,162238,162248,162202,161795,160396,160732,162239,162203,161796,160721,162226,162240,162249,162204,161797,160722,162241,162250,162205,160723,162227,162242,162206,161798,160724,162301,300069,162207,161799,160725,162228,300070,162208,160726,162229,300071,162209,161800,161396,162230,300072,161801,162210,162211,162212,162213,162214,162215,160733,162231,307053,307054,307055,307056,162216,161802,160734,162232,162217,161803,160735,162233,162218,161804,160736,162234,162219,161805,160737,162235,162220,161806,160738,162236,162221,162745,160739,162746,304837,304838,160740,162222,162747,160741,162223,162748,160788,324809,162749,160789,162998,160397,85254,157005,85261,85262,150974,85263,163002,85264,85288,300376,300377,300378,300379,300380,300381,300382,85289,85291,85292,85293,85294,157006,85295,85296,155346,85297,150976,85298,85299,302410,302411,85285,238035,161398,160347,160348,85300,163239,301473,85301,300308,300309,300310,160350,160398,85303,161935,160351,160364,85305,160366,160754,160465,85308,85309,85310,85311,85313,85314,85315,85316,85319,85320,85321,85322,85323,85324,85265,85266,85317,85325,85326,85327,85328,85329,160402,300311,85287,160403,160404,160405,160406,160407,303272,160408,160409,160410,160411,160412,160413,161933,160414,160415,161401,85330,85331,160334,160331,160327,160329,160472,85304,160361,302432,85306,85307,160416,160417,299099,302433,160418,160419,160420,160421,271839,160422,301938,160423,160424,160425,160426,160427,302182,302183,300312,160790,160428,302181,160429,160535,160430,160431,160438,271841,160439,160440,160441,160442,160443,160444,160445,271840,160446,160447,238598,160448,271838,160449,238547,238584,238546,160450,160451,160452,160453,160454,160455,160456,238695,238697,238698,238699,238700,238701,238702,238703,238704,238705,238706,238707,238708,238709,238710,238711,238712,238713,238714,238715,238716,238717,238718,238719,238720,238721,238722,238723,238724,238725,160457,85318,160458,160459,162754,160460,301849,305437,301845,305093,301846,301847,301848,302621,307067,307583,301596,301597,302434,300313,302258,302259,301598,301599,160461,162303,160462,160463,160464,160466,85332,300370,300371,300372,300373,300374,300375,160537,162353,301889,160467,160468,160469,85302,160470,160471,160536,160473,160557,160474,160475,160476,160477,160478,160479,160480,160743,160761,162067,162068,162069,160762,160763,160764,160765,160766,160767,160768,160769,160770,160771,160695,161790,161791,161792,161793,160481,160482,300364,160742,160791,160483,160484,160558,160485,160696,160432,300314,160433,160434,301890,160779,85333,160435,160436,300315,85267,160437}'::integer[])))
61. 0.152 0.152 ↑ 1.0 1 38

Index Scan using pk_gl_headers on gl_headers gh_1 (cost=0.43..8.13 rows=1 width=104) (actual time=0.004..0.004 rows=1 loops=38)

  • Index Cond: ((cid = 224) AND (id = gd_1.gl_header_id))
  • Filter: ((is_template IS FALSE) AND (gl_book_id = 132) AND ((gl_header_status_type_id <> ALL ('{4,5,6}'::integer[])) OR ((gl_transaction_type_id = 1) AND (gl_header_status_type_id = 2))))
62. 0.038 0.038 ↑ 1.0 1 38

Index Scan using pk_gl_transaction_types on gl_transaction_types gtty_1 (cost=0.14..0.16 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=38)

  • Index Cond: (id = gh_1.gl_transaction_type_id)
63. 0.114 0.114 ↑ 1.0 1 38

Index Scan using pk_ap_allocations on ap_allocations aa (cost=0.42..1.02 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=38)

  • Index Cond: ((cid = gh_1.cid) AND (cid = 224) AND (id = gh_1.reference_id))
  • Filter: (gl_transaction_type_id = gh_1.gl_transaction_type_id)
64. 0.076 0.076 ↑ 1.0 1 38

Index Scan using idx_ap_details on ap_details ad_1 (cost=0.43..1.80 rows=1 width=50) (actual time=0.002..0.002 rows=1 loops=38)

  • Index Cond: (id = aa.credit_ap_detail_id)
  • Filter: ((cid = 224) AND (aa.cid = cid))
65. 0.152 0.152 ↑ 1.0 1 38

Index Scan using pk_ap_details on ap_details ad1 (cost=0.43..6.70 rows=1 width=50) (actual time=0.004..0.004 rows=1 loops=38)

  • Index Cond: ((cid = COALESCE(gd_1.cid, aa.cid)) AND (id = COALESCE(gd_1.ap_detail_id, aa.charge_ap_detail_id)))
66. 0.760 0.760 ↑ 1.0 148 38

Seq Scan on property_units_temp pu (cost=0.00..2.85 rows=148 width=13) (actual time=0.004..0.020 rows=148 loops=38)

  • Filter: (cid = 224)
67. 0.000 0.000 ↓ 0.0 0 38

Index Scan using idx_id on property_buildings_temp pb (cost=0.15..0.17 rows=1 width=13) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: (id = CASE WHEN (gd_1.gl_transaction_type_id = 1) THEN gd_1.property_building_id ELSE COALESCE(ad1.property_building_id, ad_1.property_building_id, gd_1.property_building_id) END)
  • Filter: ((cid = 224) AND (cid = gd_1.cid))
68. 0.076 0.076 ↑ 1.0 1 38

Index Scan using idx_ap_headers_id on ap_headers ah (cost=0.42..0.65 rows=1 width=53) (actual time=0.002..0.002 rows=1 loops=38)

  • Index Cond: (id = ad_1.ap_header_id)
  • Filter: ((ap_financial_status_type_id IS DISTINCT FROM 8) AND (cid = 224) AND (ad_1.cid = cid) AND (ad_1.gl_transaction_type_id = gl_transaction_type_id) AND (ad_1.post_month = post_month))
69. 0.000 0.000 ↓ 0.0 0 38

Index Scan using idx_ap_headers_id on ap_headers ah1 (cost=0.42..0.93 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: (id = aa.lump_ap_header_id)
  • Filter: ((ap_financial_status_type_id IS DISTINCT FROM 8) AND (cid = 224) AND (cid = aa.cid))
70. 0.114 0.114 ↑ 1.0 1 38

Index Scan using idx_ap_headers_id on ap_headers ah2 (cost=0.42..0.50 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=38)

  • Index Cond: (id = ad1.ap_header_id)
  • Filter: ((ap_financial_status_type_id IS DISTINCT FROM 8) AND (ad1.cid = cid) AND (ad1.gl_transaction_type_id = gl_transaction_type_id) AND (ad1.post_month = post_month))
71. 0.000 0.000 ↓ 0.0 0 38

Index Scan using pk_lease_customers on lease_customers lc (cost=0.42..0.75 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: ((cid = COALESCE(ah2.cid, ah.cid)) AND (id = COALESCE(ah2.lease_customer_id, ah.lease_customer_id)))
72. 0.000 0.000 ↓ 0.0 0 38

Index Scan using pk_customers on customers cust (cost=0.42..0.74 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: ((cid = lc.cid) AND (id = lc.customer_id))
73. 0.076 0.076 ↑ 1.0 1 38

Index Scan using pk_ap_payments on ap_payments ap_ref (cost=0.42..0.71 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=38)

  • Index Cond: ((cid = ah.cid) AND (cid = 224) AND (id = ah.ap_payment_id))
74. 0.000 0.000 ↓ 0.0 0 38

Index Scan using pk_ap_payments on ap_payments ap (cost=0.42..0.71 rows=1 width=18) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: ((cid = ah1.cid) AND (cid = 224) AND (id = ah1.ap_payment_id))
75. 0.114 0.114 ↑ 1.0 1 38

Index Scan using pk_ap_payees on ap_payees app (cost=0.29..0.33 rows=1 width=31) (actual time=0.003..0.003 rows=1 loops=38)

  • Index Cond: ((cid = COALESCE(ah.cid, ah2.cid)) AND (id = COALESCE(ah.ap_payee_id, ah2.ap_payee_id)))
76. 0.114 0.114 ↓ 0.0 0 38

Index Scan using pk_ar_deposits on ar_deposits ad_2 (cost=0.42..0.79 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=38)

  • Index Cond: ((cid = 224) AND (id = gh_1.reference_id))
  • Filter: (gh_1.gl_transaction_type_id = gl_transaction_type_id)
77. 0.083 1.986 ↓ 1.6 192 1

Subquery Scan on "*SELECT* 3" (cost=36.64..40.60 rows=122 width=647) (actual time=1.810..1.986 rows=192 loops=1)

78. 0.335 1.903 ↓ 1.6 192 1

HashAggregate (cost=36.64..38.47 rows=122 width=563) (actual time=1.803..1.903 rows=192 loops=1)

  • Group Key: p.id, p.property_name, p.lookup_code, gat_2.grouping_gl_account_id, gat_2.formatted_account_number, gat_2.name, gat_2.gl_account
79. 0.040 1.568 ↓ 1.6 193 1

Nested Loop (cost=12.29..33.89 rows=122 width=105) (actual time=0.162..1.568 rows=193 loops=1)

  • Join Filter: (p.id = load_prop_2.property_id)
80. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on load_prop load_prop_2 (cost=0.00..1.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

81. 0.170 1.525 ↓ 38.6 193 1

Nested Loop (cost=12.29..32.82 rows=5 width=109) (actual time=0.154..1.525 rows=193 loops=1)

82. 0.047 0.197 ↓ 27.6 193 1

Merge Join (cost=12.02..16.29 rows=7 width=48) (actual time=0.140..0.197 rows=193 loops=1)

  • Merge Cond: (p.id = bbt.property_id)
83. 0.027 0.027 ↑ 6.7 7 1

Index Scan using pk_properties on properties p (cost=0.28..152.55 rows=47 width=34) (actual time=0.020..0.027 rows=7 loops=1)

  • Index Cond: (cid = 224)
84. 0.073 0.123 ↑ 1.0 193 1

Sort (cost=11.74..12.22 rows=193 width=18) (actual time=0.109..0.123 rows=193 loops=1)

  • Sort Key: bbt.property_id
  • Sort Method: quicksort Memory: 38kB
85. 0.050 0.050 ↑ 1.0 193 1

Seq Scan on beg_bal_temp bbt (cost=0.00..4.41 rows=193 width=18) (actual time=0.010..0.050 rows=193 loops=1)

  • Filter: (cid = 224)
86. 1.158 1.158 ↑ 1.0 1 193

Index Scan using idx_temp_gat_gl_account_id on gat_temp gat_2 (cost=0.28..2.35 rows=1 width=77) (actual time=0.006..0.006 rows=1 loops=193)

  • Index Cond: (gl_account_id = bbt.gl_account_id)
  • Filter: ((cid = 224) AND (grouping_gl_account_id = ANY ('{85277,85280,85433,85281,305438,305002,304963,305035,305036,305015,305014,305012,305003,305001,305038,305011,160491,160486,160709,160706,302422,302423,302424,85279,160690,160708,160299,160705,160702,160487,160711,160703,160713,160710,160300,160707,160488,160704,160712,160301,160689,160492,304892,160688,300317,85282,160490,160302,161786,160749,161787,160303,161788,161397,161789,160304,302192,302425,302426,160538,302609,307666,160539,302615,302614,160540,302429,160541,304453,307624,162297,302412,302413,302414,302415,302416,302610,302611,302612,302417,302620,305360,302418,302419,302420,302427,302613,302598,302599,324066,302596,302597,302616,302617,302595,302594,302608,302602,302603,302604,302605,302600,302601,160306,302428,302606,302618,302619,302607,304882,304883,306808,160493,162224,85278,85283,163001,160307,162999,238064,160308,160309,160542,160310,160311,85256,160312,160313,160314,161392,85275,238178,300318,160315,300319,160316,300365,160317,160318,160543,160319,160544,160320,160545,160321,160714,162295,160494,160546,300320,160780,160781,160495,160496,160497,160322,160323,160324,160325,160326,85255,300321,160328,160330,160332,160333,161393,85342,160335,160782,160336,160750,161394,85341,160751,160752,160337,300322,160338,160498,160772,301891,238082,302200,300323,160339,160340,85258,160341,238181,238182,160499,160547,160342,160343,160548,160344,160345,160346,85257,160349,161395,160352,160353,160719,160354,160773,160355,160356,160357,160358,160359,160360,160362,160363,85276,85286,85246,85268,85247,85259,160365,160367,160368,300324,302198,301942,301943,160369,160549,160753,160370,160500,160501,302202,302203,85343,85344,162996,163003,163004,161934,238747,85270,85271,85269,160371,302199,302201,161403,160372,160373,160374,160375,160376,160378,160379,160783,160380,160381,160720,160382,302430,301944,160383,162298,160774,162070,162071,162072,162296,160775,160776,160777,160778,160755,160756,162299,160757,160758,160759,160760,301945,160384,160385,300366,300316,161510,160386,160387,160550,162176,85272,160388,300195,85260,85273,163000,85274,85284,160784,85334,85248,85335,85249,85250,85251,85312,85336,85337,85338,85339,85340,85252,85290,85345,160691,85253,302204,160692,162029,324826,238112,162048,301899,160508,160551,162243,162178,162251,307848,307861,307829,300059,307852,307818,307862,307830,300060,307853,307819,307863,307831,300061,307820,307864,307832,307821,300325,160693,162030,324827,238113,162049,301900,160509,160552,162244,162179,162252,307833,300326,160694,162031,324828,238114,162050,301901,160510,160553,162245,162180,307834,162253,324789,162254,162255,162256,300327,160744,162032,324829,238115,162051,301902,160511,160554,162246,162181,162257,307835,300328,160745,162033,324830,238116,162052,301903,160512,160555,162182,162258,307836,304548,300329,160746,162034,324831,238117,162053,301904,160513,160556,162183,162259,307837,302195,160747,162035,324832,238118,162054,301905,160514,300062,162184,162260,307838,302196,160748,162036,324833,238119,301906,160515,300063,162185,162261,307839,301887,302197,302205,160785,162037,324834,238120,162055,301907,160786,300064,162186,162262,307840,302206,160389,162038,324835,238121,301908,162064,300065,162263,307841,162187,162189,162190,162191,162192,162193,302207,160390,162039,238122,301909,162065,307057,307058,307059,307060,162188,162264,307842,302208,160391,162225,238123,301910,162066,162194,162265,307843,302209,160392,162040,238124,301911,160727,162195,162266,307844,160393,162041,238125,301912,160728,162196,162267,307845,237661,237662,160502,162042,238126,301913,160729,162197,307846,160503,162043,238127,301914,162198,162268,307847,160504,162044,238128,301915,162269,160505,162045,238129,301916,162199,162270,160506,162046,238130,301917,162200,162271,160507,162047,238131,324808,162272,307865,238132,307854,238133,307855,307856,307857,307858,162997,302431,302210,307492,160516,324816,238134,162056,301918,304261,304273,162330,162273,302512,302517,238607,304262,304274,302518,238608,304263,304275,302513,302519,238609,304264,302514,300330,303273,302520,160517,324817,238135,162057,301919,304265,304276,162331,162274,300331,304266,300332,300333,300334,303274,302522,160518,324818,238136,162058,301920,304267,304277,162332,304268,162275,324788,162276,162277,162278,300335,303275,302524,160519,324819,238137,162059,301921,304269,304278,162333,162279,304270,300336,303276,302523,160520,324820,238138,162060,301922,304271,162334,162280,304547,300337,302525,160521,324821,238139,162061,301923,304272,162335,162281,302526,160522,324822,238140,162062,301924,162336,162282,302211,302527,160523,324823,238141,301925,162337,162283,301888,302212,302528,160524,324824,238142,162063,301926,162338,162284,302213,302529,160525,324825,238143,301927,162339,162285,302214,302530,160526,324815,238144,301928,162340,162286,302215,302531,160527,238145,301929,162341,162287,160528,302532,160529,238146,301930,162342,162288,302533,160530,238147,301931,162343,162289,237663,237664,307860,302534,160531,238148,301932,162344,302535,160532,238149,301933,162345,162290,302521,160533,238150,301934,162346,162291,302536,160534,238151,301935,162347,162292,302537,238152,301936,162348,162293,238153,162349,162294,238154,162350,162750,238155,162351,162751,162352,162752,324807,162753,302488,238156,304527,302489,302538,302490,302491,238157,302539,304528,302492,238158,302540,304529,302493,238159,302541,304530,302494,238160,302542,304531,302495,238161,302543,304532,302496,238162,302544,304533,302497,238163,304534,302498,238164,302545,304535,302499,238165,304536,302500,238166,304537,302501,238167,304538,302502,238168,304539,302503,238169,304540,302504,238170,304541,302505,238171,304542,302506,238172,304543,302507,238173,304544,238174,304545,160787,238175,304546,238077,300018,300019,300020,160394,238176,160730,162237,162247,162201,161794,238074,300066,300075,238090,238075,300067,300074,238091,238076,300068,300073,238092,160395,238177,160731,162238,162248,162202,161795,160396,160732,162239,162203,161796,160721,162226,162240,162249,162204,161797,160722,162241,162250,162205,160723,162227,162242,162206,161798,160724,162301,300069,162207,161799,160725,162228,300070,162208,160726,162229,300071,162209,161800,161396,162230,300072,161801,162210,162211,162212,162213,162214,162215,160733,162231,307053,307054,307055,307056,162216,161802,160734,162232,162217,161803,160735,162233,162218,161804,160736,162234,162219,161805,160737,162235,162220,161806,160738,162236,162221,162745,160739,162746,304837,304838,160740,162222,162747,160741,162223,162748,160788,324809,162749,160789,162998,160397,85254,157005,85261,85262,150974,85263,163002,85264,85288,300376,300377,300378,300379,300380,300381,300382,85289,85291,85292,85293,85294,157006,85295,85296,155346,85297,150976,85298,85299,302410,302411,85285,238035,161398,160347,160348,85300,163239,301473,85301,300308,300309,300310,160350,160398,85303,161935,160351,160364,85305,160366,160754,160465,85308,85309,85310,85311,85313,85314,85315,85316,85319,85320,85321,85322,85323,85324,85265,85266,85317,85325,85326,85327,85328,85329,160402,300311,85287,160403,160404,160405,160406,160407,303272,160408,160409,160410,160411,160412,160413,161933,160414,160415,161401,85330,85331,160334,160331,160327,160329,160472,85304,160361,302432,85306,85307,160416,160417,299099,302433,160418,160419,160420,160421,271839,160422,301938,160423,160424,160425,160426,160427,302182,302183,300312,160790,160428,302181,160429,160535,160430,160431,160438,271841,160439,160440,160441,160442,160443,160444,160445,271840,160446,160447,238598,160448,271838,160449,238547,238584,238546,160450,160451,160452,160453,160454,160455,160456,238695,238697,238698,238699,238700,238701,238702,238703,238704,238705,238706,238707,238708,238709,238710,238711,238712,238713,238714,238715,238716,238717,238718,238719,238720,238721,238722,238723,238724,238725,160457,85318,160458,160459,162754,160460,301849,305437,301845,305093,301846,301847,301848,302621,307067,307583,301596,301597,302434,300313,302258,302259,301598,301599,160461,162303,160462,160463,160464,160466,85332,300370,300371,300372,300373,300374,300375,160537,162353,301889,160467,160468,160469,85302,160470,160471,160536,160473,160557,160474,160475,160476,160477,160478,160479,160480,160743,160761,162067,162068,162069,160762,160763,160764,160765,160766,160767,160768,160769,160770,160771,160695,161790,161791,161792,161793,160481,160482,300364,160742,160791,160483,160484,160558,160485,160696,160432,300314,160433,160434,301890,160779,85333,160435,160436,300315,85267,160437}'::integer[])))