explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XUph

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1.729 ↓ 0.0 0 1

GroupAggregate (cost=318.78..319.08 rows=2 width=1,586) (actual time=1.729..1.729 rows=0 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.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. 0.056 1.729 ↓ 0.0 0 1

Sort (cost=318.78..318.78 rows=2 width=1,554) (actual time=1.729..1.729 rows=0 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.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: 25kB
3. 0.000 1.673 ↓ 0.0 0 1

Subquery Scan on outer_details (cost=318.65..318.77 rows=2 width=1,554) (actual time=1.673..1.673 rows=0 loops=1)

  • Filter: (outer_details.hide_zero_beginning_balance_for_no_activities <> 1)
4. 0.002 1.673 ↓ 0.0 0 1

WindowAgg (cost=318.65..318.73 rows=3 width=1,590) (actual time=1.673..1.673 rows=0 loops=1)

5. 0.003 1.671 ↓ 0.0 0 1

Sort (cost=318.65..318.66 rows=3 width=1,546) (actual time=1.671..1.671 rows=0 loops=1)

  • Sort Key: details.property_id, details.grouping_gl_account_id
  • Sort Method: quicksort Memory: 25kB
6. 0.002 1.668 ↓ 0.0 0 1

WindowAgg (cost=318.53..318.63 rows=3 width=1,546) (actual time=1.668..1.668 rows=0 loops=1)

7. 0.002 1.666 ↓ 0.0 0 1

Sort (cost=318.53..318.54 rows=3 width=1,354) (actual time=1.666..1.666 rows=0 loops=1)

  • Sort Key: details.property_id, details.gl_account
  • Sort Method: quicksort Memory: 25kB
8. 0.001 1.664 ↓ 0.0 0 1

Subquery Scan on details (cost=12.15..318.51 rows=3 width=1,354) (actual time=1.664..1.664 rows=0 loops=1)

9. 0.000 1.663 ↓ 0.0 0 1

Append (cost=12.15..318.48 rows=3 width=1,390) (actual time=1.663..1.663 rows=0 loops=1)

10. 0.001 1.641 ↓ 0.0 0 1

Result (cost=12.15..295.33 rows=2 width=1,376) (actual time=1.641..1.641 rows=0 loops=1)

11. 0.001 1.640 ↓ 0.0 0 1

Append (cost=12.15..295.30 rows=2 width=1,348) (actual time=1.640..1.640 rows=0 loops=1)

12. 0.001 0.853 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.15..99.44 rows=1 width=1,463) (actual time=0.853..0.853 rows=0 loops=1)

13. 0.000 0.852 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.73..89.86 rows=1 width=1,431) (actual time=0.852..0.852 rows=0 loops=1)

14. 0.000 0.852 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.31..81.19 rows=1 width=1,382) (actual time=0.852..0.852 rows=0 loops=1)

15. 0.000 0.852 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.15..80.54 rows=1 width=1,354) (actual time=0.852..0.852 rows=0 loops=1)

16. 0.001 0.852 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.01..79.54 rows=1 width=1,340) (actual time=0.852..0.852 rows=0 loops=1)

  • Join Filter: (gh.cid = art1.cid)
17. 0.000 0.851 ↓ 0.0 0 1

Nested Loop Left Join (cost=10.57..71.07 rows=1 width=1,115) (actual time=0.851..0.851 rows=0 loops=1)

  • Join Filter: (gh.gl_transaction_type_id = ANY ('{7,8,9,17}'::integer[]))
18. 0.000 0.851 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.72..58.18 rows=1 width=1,103) (actual time=0.851..0.851 rows=0 loops=1)

  • Join Filter: (gh.gl_transaction_type_id = ANY ('{13,14,18,23,24}'::integer[]))
19. 0.001 0.851 ↓ 0.0 0 1

Nested Loop (cost=1.29..49.71 rows=1 width=1,095) (actual time=0.851..0.851 rows=0 loops=1)

  • Join Filter: (gtty.id = gh.gl_transaction_type_id)
20. 0.000 0.850 ↓ 0.0 0 1

Nested Loop (cost=0.85..41.23 rows=1 width=999) (actual time=0.850..0.850 rows=0 loops=1)

21. 0.000 0.850 ↓ 0.0 0 1

Nested Loop (cost=0.85..35.69 rows=1 width=975) (actual time=0.850..0.850 rows=0 loops=1)

22. 0.001 0.850 ↓ 0.0 0 1

Nested Loop (cost=0.71..25.92 rows=1 width=689) (actual time=0.850..0.850 rows=0 loops=1)

23. 0.849 0.849 ↓ 0.0 0 1

Index Scan using idx_gl_details_cid_property_id_post_month_cash_gl_account_id on gl_details gd (cost=0.56..17.75 rows=1 width=73) (actual time=0.849..0.849 rows=0 loops=1)

  • Index Cond: ((cid = 15,647) AND (property_id = ANY ('{1029235,639731,639730}'::integer[])) AND (post_month >= '2020-09-01'::date) AND (post_month <= '2020-09-01'::date))
  • Filter: (gl_transaction_type_id = ANY ('{13,14,18,23,24,7,8,9,17}'::integer[]))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_load_prop_property_id on load_prop (cost=0.14..8.16 rows=1 width=620) (never executed)

  • Index Cond: (property_id = gd.property_id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_temp_gat_gl_account_id on gat_temp gat (cost=0.14..9.76 rows=1 width=298) (never executed)

  • Index Cond: (gl_account_id = gd.accrual_gl_account_id)
  • Filter: ((cid = 15,647) AND (grouping_gl_account_id = ANY ('{249085,247842,247843,247844,247845,247846,249052,247847,247848,247849,247850,247533,247851,247852,249040,247544,247853,249041,247854,247855,247856,247857,247858,247859,247860,249033,247861,247862,247863,247864,247865,247866,247867,247868,247869,247870,247871,247872,247873,247874,249053,249051,247875,247876,247556,247877,247878,247879,247880,247881,247882,247883,247884,247885,247886,247887,247555,247888,247889,247890,247891,247892,247893,247894,247895,247896,247897,247898,247899,247900,247901,247902,247903,247904,247905,247906,247907,247908,247909,247910,247911,247912,247913,247914,247915,247916,247917,247918,247919,247920,247921,247922,247923,247924,247925,247926,247927,247928,247929,247930,247931,247932,247933,247934,247935,247936,247937,247938,247939,247940,247941,247942,247943,247944,247945,247946,247947,247948,247949,247950,247951,247952,247953,247954,247955,247956,247957,247958,247959,247960,247961,247962,247963,247964,247965,247966,247967,247968,247969,247970,247971,247972,247973,247974,247975,247976,247977,247978,247979,247980,247981,247982,247983,247984,247985,247986,247987,247988,247989,247990,247991,247992,247993,247994,247995,247996,247997,247998,247999,248000,248001,248002,248003,248004,248005,248006,248007,248008,248009,248010,248011,248012,248013,248014,248015,248016,248017,248018,248019,248020,248021,248022,248023,248024,248025,248026,248027,248028,248029,248030,248031,248032,248033,248034,248035,248036,248037,248038,248039,248040,248041,248042,248043,248044,248045,248046,248047,248048,248049,248050,248051,248052,248053,248054,248055,248056,248057,248058,248059,248060,248061,248062,248063,248064,248065,248066,248067,248068,248069,248070,248071,248072,248073,248074,248075,248076,248077,248078,248079,248080,248081,248082,248083,248084,248085,248086,248087,248088,248089,248090,248091,248092,248093,248094,248095,248096,248097,248098,248099,248100,248101,248102,248103,248104,248105,248106,247561,248107,248108,248109,248110,248111,248112,248113,248114,248115,248116,248117,248118,248119,248120,248121,248122,248123,248124,248125,248126,248127,248128,248129,248130,248131,248132,248133,248134,248135,248136,248137,248138,248139,248140,248141,248142,248143,248144,248145,248146,248147,248148,248149,248150,248151,248152,248153,248154,248155,249038,248156,248157,248158,249081,249082,249086,248159,248160,248161,248162,248163,248164,248165,248166,248167,248168,248169,248170,248171,248172,248173,249083,249084,248174,248175,248176,248177,248178,248179,248180,248181,248182,248183,248184,248185,248186,248187,248188,248189,248190,248191,248192,248193,248194,248195,248196,248197,248198,248199,248200,248201,248202,248203,248204,248205,248206,248207,248208,249039,248209,248210,248211,248212,248213,248214,248215,248216,248217,248218,248219,248220,248221,248222,248223,248224,248225,248226,248227,248228,248229,248230,247553,247560,247554,247551,248231,247548,248232,248233,248234,248235,248236,248237,248238,248239,248240,248241,248242,248243,247543,247558,249054,248244,247557,248246,248248,248249,248250,248251,248252,248253,248254,248255,248256,248257,248258,248259,248260,248261,248262,248263,248264,248265,248266,248267,248268,248269,247527,248270,248271,248272,248273,248274,248275,248276,248277,248278,249065,248279,248280,248281,248282,248283,248284,249057,249058,249059,249060,248285,249055,249056,248286,248287,248288,248289,248290,248291,248292,248293,248294,248295,248296,248297,248298,247559,247529,247528,248299,248300,247540,248301,249042,248302,248303,248304,247550,249049,248305,248306,248307,248308,248309,248310,248311,248312,248313,248314,248315,248316,248317,248318,248319,248320,247549,249050,248321,248322,248323,248324,248325,248326,248327,248328,248329,248330,248331,248332,248333,248334,248335,248336,248337,248338,248339,248340,248341,248342,248343,248344,248345,248346,248347,248348,248349,248350,248351,248352,248353,248354,248355,248356,248357,247541,248358,248359,248360,248361,248362,248363,248364,248365,248366,248367,247547,248368,248369,248370,247545,248371,248372,248373,248374,248375,248376,248377,248378,248379,248380,248381,248382,248383,249067,247531,248384,248385,248386,247535,249032,248387,248388,248389,248390,248391,248392,248393,249062,247536,247542,248394,248395,248396,248397,249063,247534,248398,247539,247537,248399,248400,248401,248402,248403,248404,248405,248406,248407,248408,248409,248410,248411,248412,248413,248414,248415,248416,249034,249035,249036,249037,248421,248422,248423,248424,248425,248426,248427,248428,248429,248430,248431,248432,248433,248434,248435,248436,248437,248438,248439,248440,248441,248442,248443,248444,248445,248446,248447,248448,248449,248450,248451,248452,248453,248454,248455,248456,248457,248458,248459,248460,248461,248462,248463,248464,248465,248466,248467,248468,248469,248470,248471,248472,248473,248474,248475,248476,248477,248478,248479,248480,248481,248482,248483,248484,248485,248486,248487,248488,248489,248490,248491,248492,248493,248494,248495,248496,248497,248498,248499,248500,248501,248502,248503,248504,248505,248506,248507,248508,248509,248510,248511,248512,248513,248514,248515,248516,248517,248518,248519,248520,248521,247562,248522,248523,248524,248525,248526,248527,248528,248529,248530,248531,248532,248533,248534,248535,248536,248537,248538,248539,248540,248541,248542,248543,248544,248545,248546,248547,248548,248549,248550,248551,248552,248553,248554,248555,248556,248557,248558,248559,248560,248561,248562,248563,248564,248565,248566,248567,248568,248569,248570,248571,248572,248573,248574,248575,248576,248577,248578,248579,248580,248581,248582,248583,248584,248585,248586,248587,248588,248589,248590,248591,248592,248593,248594,248595,248596,248597,248598,248599,248600,248601,248602,248603,248604,248605,248606,249048,249061,248607,248608,248609,248610,248611,248612,248613,248614,248615,248616,248617,248618,248619,248620,248621,248622,248623,248624,248625,248626,248627,248628,248629,248630,248631,248632,248633,248634,248635,248636,248637,248638,248639,248640,248641,248642,248643,248644,247530,247546,247552,248645,248646,248647,248648,248649,248650,248651,248652,248653,248654,248655,248656,248657,248658,248659,248660,248661,248662,248663,248664,248665,248666,248667,248668,248669,248670,248671,249068,248672,248673,248674,248675,248676,248677,248678,248679,248680,248681,248682,248683,248684,248685,248686,248687,248688,248689,248690,248691,248692,248693,248694,248695,248696,248697,248698,248699,248700,248701,249069,248702,248703,248704,248705,248706,248707,248708,248709,248710,248711,248712,248713,248714,248715,248716,248717,248718,248719,248720,248721,248722,248723,248724,248725,248726,248727,248728,248729,249070,248730,248731,248732,248733,248734,248735,248736,249066,248737,248738,248739,248740,248741,248742,248743,248744,248745,248746,248747,249071,248748,248749,248750,248751,248752,248753,248754,248755,248756,248757,248758,248759,248760,248761,248762,248763,248764,248765,248766,248767,248768,248769,248770,248771,248772,248773,248774,248775,248776,247538,248777,248778,248779,248780,248781,248782,248783,248784,248785,248786,248787,248788,248789,249046,249047,248790,248791,248792,248793,248794,248795,248796,248797,249076,248798,248799,248800,249072,248801,248802,248803,248804,248805,248806,248807,248808,248809,248810,248811,248812,248813,248814,248815,248816,248817,248818,248819,248820,248821,248822,248823,248824,248825,248826,248827,248828,248829,248830,248831,248832,248833,248834,248835,248836,248837,248838,248839,248840,248841,248842,248843,248844,248845,249073,248846,248847,248848,248849,248850,248851,248852,248853,248854,248855,248856,249074,249075,248857,248858,248859,248860,248861,248862,248863,248864,248865,248866,248867,248868,248869,248870,248871,248872,248873,248874,248875,248876,248877,248878,248879,248880,248881,248882,248883,248884,248885,248886,248887,248888,248889,248890,248891,248892,248893,248894,248895,248896,248897,248898,248899,248900,248901,248902,248903,248904,248905,248906,248907,248908,249078,248909,248910,249044,249045,248911,249043,248912,248913,248914,248915,248916,248917,248918,248919,248920,248921,248922,248923,248924,248925,248926,248927,248928,248929,248930,248931,248932,248933,248934,248935,248936,248937,248938,248939,248940,248941,248942,248943,248944,248945,249077,249079,249080,248946,248947,248948,248949,248950,248951,248952,248953,248954,248955,248956,248957,248958,248959,248960,248961,248962,248963,248964,248965,248966,248967,248968,248969,248970,248971,248972,248973,248974,248975,248976,248977,248978,248979,248980,248981,248982,248983,248984,248985,248986,248987,248988,248989,248990,247532,248991,248992,248993,248994,248995,248996,248997,248998,248999,249000,249001,249002,249003,249004,249005,249006,249007,249008,249009,249010,249064,249011,249012,249013,249014,249015,249016,249017,249018,249019,249020,249021,249022,249023,249024,249025,249026,249027,249028,249029,249030}'::integer[])))
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on gl_transaction_types gtty (cost=0.00..5.27 rows=27 width=24) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_gl_headers on gl_headers gh (cost=0.43..8.47 rows=1 width=104) (never executed)

  • Index Cond: ((cid = 15,647) AND (id = gd.gl_header_id))
  • Filter: ((NOT is_template) AND (gl_book_id = 96) 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 ↓ 0.0 0

Index Scan using pk_ar_allocations on ar_allocations ara (cost=0.43..8.45 rows=1 width=16) (never executed)

  • Index Cond: ((cid = gh.cid) AND (cid = 15,647) AND (id = gh.reference_id))
29. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ar_transactions art (cost=8.86..12.88 rows=1 width=20) (never executed)

  • Recheck Cond: (((cid = 15,647) AND (id = gh.reference_id)) OR ((cid = 15,647) AND (id = ara.credit_ar_transaction_id)))
  • Filter: (gh.cid = cid)
30. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=8.86..8.86 rows=1 width=0) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_ar_transactions (cost=0.00..4.44 rows=1 width=0) (never executed)

  • Index Cond: ((cid = 15,647) AND (id = gh.reference_id))
32. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_ar_transactions (cost=0.00..4.35 rows=1 width=0) (never executed)

  • Index Cond: ((cid = 15,647) AND (id = ara.credit_ar_transaction_id))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ar_transactions on ar_transactions art1 (cost=0.43..8.46 rows=1 width=233) (never executed)

  • Index Cond: ((cid = 15,647) AND (id = COALESCE(ara.charge_ar_transaction_id, art.id)))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ar_triggers on ar_triggers att (cost=0.14..0.99 rows=1 width=18) (never executed)

  • Index Cond: (id = art1.ar_trigger_id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_temp_cid on ar_codes_temp ac (cost=0.15..0.64 rows=1 width=40) (never executed)

  • Index Cond: ((cid = art1.cid) AND (cid = 15,647))
  • Filter: (id = art1.ar_code_id)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_cached_leases on cached_leases cl (cost=0.42..8.44 rows=1 width=61) (never executed)

  • Index Cond: ((cid = gd.cid) AND (cid = 15,647) AND (id = gd.lease_id))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ar_deposits on ar_deposits ad (cost=0.42..8.69 rows=1 width=40) (never executed)

  • Index Cond: ((cid = 15,647) AND (id = gh.reference_id))
  • Filter: (gh.gl_transaction_type_id = gl_transaction_type_id)
38. 0.001 0.786 ↓ 0.0 0 1

Subquery Scan on "*SELECT* 2" (cost=56.92..195.84 rows=1 width=1,335) (actual time=0.786..0.786 rows=0 loops=1)

39. 0.001 0.785 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.92..195.83 rows=1 width=1,335) (actual time=0.785..0.785 rows=0 loops=1)

40. 0.000 0.784 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.50..186.43 rows=1 width=1,335) (actual time=0.784..0.784 rows=0 loops=1)

41. 0.001 0.784 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.21..178.12 rows=1 width=1,324) (actual time=0.784..0.784 rows=0 loops=1)

42. 0.001 0.783 ↓ 0.0 0 1

Nested Loop Left Join (cost=55.79..168.79 rows=1 width=1,318) (actual time=0.783..0.783 rows=0 loops=1)

43. 0.001 0.782 ↓ 0.0 0 1

Nested Loop Left Join (cost=55.37..159.45 rows=1 width=1,308) (actual time=0.782..0.782 rows=0 loops=1)

44. 0.000 0.781 ↓ 0.0 0 1

Nested Loop Left Join (cost=54.95..158.71 rows=1 width=1,280) (actual time=0.781..0.781 rows=0 loops=1)

45. 0.001 0.781 ↓ 0.0 0 1

Nested Loop Left Join (cost=54.52..150.27 rows=1 width=1,272) (actual time=0.781..0.781 rows=0 loops=1)

46. 0.001 0.780 ↓ 0.0 0 1

Nested Loop Left Join (cost=54.10..149.75 rows=1 width=1,276) (actual time=0.780..0.780 rows=0 loops=1)

  • Join Filter: ((ah1.cid = aa.cid) AND (ah1.id = aa.lump_ap_header_id))
47. 0.001 0.779 ↓ 0.0 0 1

Nested Loop Left Join (cost=53.67..141.70 rows=1 width=1,272) (actual time=0.779..0.779 rows=0 loops=1)

48. 0.000 0.778 ↓ 0.0 0 1

Nested Loop Left Join (cost=53.25..133.92 rows=1 width=1,239) (actual time=0.778..0.778 rows=0 loops=1)

49. 0.000 0.778 ↓ 0.0 0 1

Nested Loop Left Join (cost=53.09..128.73 rows=1 width=1,227) (actual time=0.778..0.778 rows=0 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))
50. 0.001 0.778 ↓ 0.0 0 1

Nested Loop Left Join (cost=53.09..103.62 rows=1 width=1,207) (actual time=0.778..0.778 rows=0 loops=1)

51. 0.000 0.777 ↓ 0.0 0 1

Nested Loop Left Join (cost=52.67..95.18 rows=1 width=1,169) (actual time=0.777..0.777 rows=0 loops=1)

52. 0.001 0.777 ↓ 0.0 0 1

Nested Loop Left Join (cost=52.24..86.71 rows=1 width=1,127) (actual time=0.777..0.777 rows=0 loops=1)

  • Join Filter: (gh_1.gl_transaction_type_id = ANY ('{4,5}'::integer[]))
53. 0.000 0.776 ↓ 0.0 0 1

Nested Loop (cost=51.81..78.25 rows=1 width=1,115) (actual time=0.776..0.776 rows=0 loops=1)

54. 0.001 0.776 ↓ 0.0 0 1

Nested Loop (cost=51.67..72.93 rows=1 width=829) (actual time=0.776..0.776 rows=0 loops=1)

  • Join Filter: (gh_1.gl_transaction_type_id = gtty_1.id)
55. 0.000 0.775 ↓ 0.0 0 1

Nested Loop (cost=51.67..67.32 rows=1 width=805) (actual time=0.775..0.775 rows=0 loops=1)

56. 0.001 0.775 ↓ 0.0 0 1

Nested Loop (cost=51.53..63.60 rows=1 width=189) (actual time=0.775..0.775 rows=0 loops=1)

57. 0.002 0.774 ↓ 0.0 0 1

Bitmap Heap Scan on gl_headers gh_1 (cost=50.96..54.99 rows=1 width=104) (actual time=0.774..0.774 rows=0 loops=1)

  • Recheck Cond: ((gl_book_id = 96) AND (cid = 15,647))
  • Filter: ((is_template IS FALSE) AND ((gl_header_status_type_id <> ALL ('{4,5,6}'::integer[])) OR ((gl_transaction_type_id = 1) AND (gl_header_status_type_id = 2))))
58. 0.001 0.772 ↓ 0.0 0 1

BitmapAnd (cost=50.96..50.96 rows=1 width=0) (actual time=0.772..0.772 rows=0 loops=1)

59. 0.771 0.771 ↓ 0.0 0 1

Bitmap Index Scan on idx_gl_headers_gl_book_id (cost=0.00..25.13 rows=1,160 width=0) (actual time=0.771..0.771 rows=0 loops=1)

  • Index Cond: (gl_book_id = 96)
60. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_gl_headers (cost=0.00..25.58 rows=1,219 width=0) (never executed)

  • Index Cond: (cid = 15,647)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_gl_details_cid_gl_header_id on gl_details gd_1 (cost=0.56..8.60 rows=1 width=89) (never executed)

  • Index Cond: ((cid = 15,647) AND (gl_header_id = gh_1.id))
  • Filter: ((post_month >= '2020-09-01'::date) AND (post_month <= '2020-09-01'::date) AND (gl_transaction_type_id <> ALL ('{13,14,18,23,24,7,8,9,17}'::integer[])))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_load_prop_property_id on load_prop load_prop_1 (cost=0.14..3.72 rows=1 width=620) (never executed)

  • Index Cond: (property_id = gd_1.property_id)
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on gl_transaction_types gtty_1 (cost=0.00..5.27 rows=27 width=24) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_temp_gat_gl_account_id on gat_temp gat_1 (cost=0.14..5.31 rows=1 width=298) (never executed)

  • Index Cond: (gl_account_id = gd_1.accrual_gl_account_id)
  • Filter: ((cid = 15,647) AND (grouping_gl_account_id = ANY ('{249085,247842,247843,247844,247845,247846,249052,247847,247848,247849,247850,247533,247851,247852,249040,247544,247853,249041,247854,247855,247856,247857,247858,247859,247860,249033,247861,247862,247863,247864,247865,247866,247867,247868,247869,247870,247871,247872,247873,247874,249053,249051,247875,247876,247556,247877,247878,247879,247880,247881,247882,247883,247884,247885,247886,247887,247555,247888,247889,247890,247891,247892,247893,247894,247895,247896,247897,247898,247899,247900,247901,247902,247903,247904,247905,247906,247907,247908,247909,247910,247911,247912,247913,247914,247915,247916,247917,247918,247919,247920,247921,247922,247923,247924,247925,247926,247927,247928,247929,247930,247931,247932,247933,247934,247935,247936,247937,247938,247939,247940,247941,247942,247943,247944,247945,247946,247947,247948,247949,247950,247951,247952,247953,247954,247955,247956,247957,247958,247959,247960,247961,247962,247963,247964,247965,247966,247967,247968,247969,247970,247971,247972,247973,247974,247975,247976,247977,247978,247979,247980,247981,247982,247983,247984,247985,247986,247987,247988,247989,247990,247991,247992,247993,247994,247995,247996,247997,247998,247999,248000,248001,248002,248003,248004,248005,248006,248007,248008,248009,248010,248011,248012,248013,248014,248015,248016,248017,248018,248019,248020,248021,248022,248023,248024,248025,248026,248027,248028,248029,248030,248031,248032,248033,248034,248035,248036,248037,248038,248039,248040,248041,248042,248043,248044,248045,248046,248047,248048,248049,248050,248051,248052,248053,248054,248055,248056,248057,248058,248059,248060,248061,248062,248063,248064,248065,248066,248067,248068,248069,248070,248071,248072,248073,248074,248075,248076,248077,248078,248079,248080,248081,248082,248083,248084,248085,248086,248087,248088,248089,248090,248091,248092,248093,248094,248095,248096,248097,248098,248099,248100,248101,248102,248103,248104,248105,248106,247561,248107,248108,248109,248110,248111,248112,248113,248114,248115,248116,248117,248118,248119,248120,248121,248122,248123,248124,248125,248126,248127,248128,248129,248130,248131,248132,248133,248134,248135,248136,248137,248138,248139,248140,248141,248142,248143,248144,248145,248146,248147,248148,248149,248150,248151,248152,248153,248154,248155,249038,248156,248157,248158,249081,249082,249086,248159,248160,248161,248162,248163,248164,248165,248166,248167,248168,248169,248170,248171,248172,248173,249083,249084,248174,248175,248176,248177,248178,248179,248180,248181,248182,248183,248184,248185,248186,248187,248188,248189,248190,248191,248192,248193,248194,248195,248196,248197,248198,248199,248200,248201,248202,248203,248204,248205,248206,248207,248208,249039,248209,248210,248211,248212,248213,248214,248215,248216,248217,248218,248219,248220,248221,248222,248223,248224,248225,248226,248227,248228,248229,248230,247553,247560,247554,247551,248231,247548,248232,248233,248234,248235,248236,248237,248238,248239,248240,248241,248242,248243,247543,247558,249054,248244,247557,248246,248248,248249,248250,248251,248252,248253,248254,248255,248256,248257,248258,248259,248260,248261,248262,248263,248264,248265,248266,248267,248268,248269,247527,248270,248271,248272,248273,248274,248275,248276,248277,248278,249065,248279,248280,248281,248282,248283,248284,249057,249058,249059,249060,248285,249055,249056,248286,248287,248288,248289,248290,248291,248292,248293,248294,248295,248296,248297,248298,247559,247529,247528,248299,248300,247540,248301,249042,248302,248303,248304,247550,249049,248305,248306,248307,248308,248309,248310,248311,248312,248313,248314,248315,248316,248317,248318,248319,248320,247549,249050,248321,248322,248323,248324,248325,248326,248327,248328,248329,248330,248331,248332,248333,248334,248335,248336,248337,248338,248339,248340,248341,248342,248343,248344,248345,248346,248347,248348,248349,248350,248351,248352,248353,248354,248355,248356,248357,247541,248358,248359,248360,248361,248362,248363,248364,248365,248366,248367,247547,248368,248369,248370,247545,248371,248372,248373,248374,248375,248376,248377,248378,248379,248380,248381,248382,248383,249067,247531,248384,248385,248386,247535,249032,248387,248388,248389,248390,248391,248392,248393,249062,247536,247542,248394,248395,248396,248397,249063,247534,248398,247539,247537,248399,248400,248401,248402,248403,248404,248405,248406,248407,248408,248409,248410,248411,248412,248413,248414,248415,248416,249034,249035,249036,249037,248421,248422,248423,248424,248425,248426,248427,248428,248429,248430,248431,248432,248433,248434,248435,248436,248437,248438,248439,248440,248441,248442,248443,248444,248445,248446,248447,248448,248449,248450,248451,248452,248453,248454,248455,248456,248457,248458,248459,248460,248461,248462,248463,248464,248465,248466,248467,248468,248469,248470,248471,248472,248473,248474,248475,248476,248477,248478,248479,248480,248481,248482,248483,248484,248485,248486,248487,248488,248489,248490,248491,248492,248493,248494,248495,248496,248497,248498,248499,248500,248501,248502,248503,248504,248505,248506,248507,248508,248509,248510,248511,248512,248513,248514,248515,248516,248517,248518,248519,248520,248521,247562,248522,248523,248524,248525,248526,248527,248528,248529,248530,248531,248532,248533,248534,248535,248536,248537,248538,248539,248540,248541,248542,248543,248544,248545,248546,248547,248548,248549,248550,248551,248552,248553,248554,248555,248556,248557,248558,248559,248560,248561,248562,248563,248564,248565,248566,248567,248568,248569,248570,248571,248572,248573,248574,248575,248576,248577,248578,248579,248580,248581,248582,248583,248584,248585,248586,248587,248588,248589,248590,248591,248592,248593,248594,248595,248596,248597,248598,248599,248600,248601,248602,248603,248604,248605,248606,249048,249061,248607,248608,248609,248610,248611,248612,248613,248614,248615,248616,248617,248618,248619,248620,248621,248622,248623,248624,248625,248626,248627,248628,248629,248630,248631,248632,248633,248634,248635,248636,248637,248638,248639,248640,248641,248642,248643,248644,247530,247546,247552,248645,248646,248647,248648,248649,248650,248651,248652,248653,248654,248655,248656,248657,248658,248659,248660,248661,248662,248663,248664,248665,248666,248667,248668,248669,248670,248671,249068,248672,248673,248674,248675,248676,248677,248678,248679,248680,248681,248682,248683,248684,248685,248686,248687,248688,248689,248690,248691,248692,248693,248694,248695,248696,248697,248698,248699,248700,248701,249069,248702,248703,248704,248705,248706,248707,248708,248709,248710,248711,248712,248713,248714,248715,248716,248717,248718,248719,248720,248721,248722,248723,248724,248725,248726,248727,248728,248729,249070,248730,248731,248732,248733,248734,248735,248736,249066,248737,248738,248739,248740,248741,248742,248743,248744,248745,248746,248747,249071,248748,248749,248750,248751,248752,248753,248754,248755,248756,248757,248758,248759,248760,248761,248762,248763,248764,248765,248766,248767,248768,248769,248770,248771,248772,248773,248774,248775,248776,247538,248777,248778,248779,248780,248781,248782,248783,248784,248785,248786,248787,248788,248789,249046,249047,248790,248791,248792,248793,248794,248795,248796,248797,249076,248798,248799,248800,249072,248801,248802,248803,248804,248805,248806,248807,248808,248809,248810,248811,248812,248813,248814,248815,248816,248817,248818,248819,248820,248821,248822,248823,248824,248825,248826,248827,248828,248829,248830,248831,248832,248833,248834,248835,248836,248837,248838,248839,248840,248841,248842,248843,248844,248845,249073,248846,248847,248848,248849,248850,248851,248852,248853,248854,248855,248856,249074,249075,248857,248858,248859,248860,248861,248862,248863,248864,248865,248866,248867,248868,248869,248870,248871,248872,248873,248874,248875,248876,248877,248878,248879,248880,248881,248882,248883,248884,248885,248886,248887,248888,248889,248890,248891,248892,248893,248894,248895,248896,248897,248898,248899,248900,248901,248902,248903,248904,248905,248906,248907,248908,249078,248909,248910,249044,249045,248911,249043,248912,248913,248914,248915,248916,248917,248918,248919,248920,248921,248922,248923,248924,248925,248926,248927,248928,248929,248930,248931,248932,248933,248934,248935,248936,248937,248938,248939,248940,248941,248942,248943,248944,248945,249077,249079,249080,248946,248947,248948,248949,248950,248951,248952,248953,248954,248955,248956,248957,248958,248959,248960,248961,248962,248963,248964,248965,248966,248967,248968,248969,248970,248971,248972,248973,248974,248975,248976,248977,248978,248979,248980,248981,248982,248983,248984,248985,248986,248987,248988,248989,248990,247532,248991,248992,248993,248994,248995,248996,248997,248998,248999,249000,249001,249002,249003,249004,249005,249006,249007,249008,249009,249010,249064,249011,249012,249013,249014,249015,249016,249017,249018,249019,249020,249021,249022,249023,249024,249025,249026,249027,249028,249029,249030}'::integer[])))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_allocations on ap_allocations aa (cost=0.42..8.45 rows=1 width=24) (never executed)

  • Index Cond: ((cid = gh_1.cid) AND (cid = 15,647) AND (id = gh_1.reference_id))
  • Filter: (gl_transaction_type_id = gh_1.gl_transaction_type_id)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_details on ap_details ad_1 (cost=0.43..8.40 rows=1 width=50) (never executed)

  • Index Cond: ((cid = aa.cid) AND (cid = 15,647) AND (id = aa.credit_ap_detail_id))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_details on ap_details ad1 (cost=0.43..8.45 rows=1 width=50) (never executed)

  • Index Cond: ((cid = COALESCE(gd_1.cid, aa.cid)) AND (id = COALESCE(gd_1.ap_detail_id, aa.charge_ap_detail_id)))
68. 0.000 0.000 ↓ 0.0 0

Seq Scan on property_units_temp pu (cost=0.00..25.00 rows=6 width=40) (never executed)

  • Filter: (cid = 15,647)
69. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id on property_buildings_temp pb (cost=0.15..5.18 rows=1 width=40) (never executed)

  • 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 = 15,647) AND (cid = gd_1.cid))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_headers on ap_headers ah (cost=0.42..7.77 rows=1 width=53) (never executed)

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

Index Scan using pk_ap_headers on ap_headers ah1 (cost=0.42..8.04 rows=1 width=12) (never executed)

  • Index Cond: (cid = 15,647)
  • Filter: (ap_financial_status_type_id IS DISTINCT FROM 8)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_ap_headers_id on ap_headers ah2 (cost=0.42..0.50 rows=1 width=24) (never executed)

  • 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))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_lease_customers on lease_customers lc (cost=0.42..8.45 rows=1 width=16) (never executed)

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

Index Scan using pk_customers on customers cust (cost=0.42..0.74 rows=1 width=40) (never executed)

  • Index Cond: ((cid = lc.cid) AND (id = lc.customer_id))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_payments on ap_payments ap_ref (cost=0.42..8.44 rows=1 width=18) (never executed)

  • Index Cond: ((cid = ah.cid) AND (cid = 15,647) AND (id = ah.ap_payment_id))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_payments on ap_payments ap (cost=0.42..8.44 rows=1 width=18) (never executed)

  • Index Cond: ((cid = ah1.cid) AND (cid = 15,647) AND (id = ah1.ap_payment_id))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_payees on ap_payees app (cost=0.29..8.31 rows=1 width=31) (never executed)

  • Index Cond: ((cid = COALESCE(ah.cid, ah2.cid)) AND (id = COALESCE(ah.ap_payee_id, ah2.ap_payee_id)))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ar_deposits on ar_deposits ad_2 (cost=0.42..8.69 rows=1 width=40) (never executed)

  • Index Cond: ((cid = 15,647) AND (id = gh_1.reference_id))
  • Filter: (gh_1.gl_transaction_type_id = gl_transaction_type_id)
79. 0.001 0.022 ↓ 0.0 0 1

Subquery Scan on "*SELECT* 3" (cost=23.08..23.14 rows=1 width=800) (actual time=0.022..0.022 rows=0 loops=1)

80. 0.002 0.021 ↓ 0.0 0 1

GroupAggregate (cost=23.08..23.12 rows=1 width=716) (actual time=0.021..0.021 rows=0 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
81. 0.009 0.019 ↓ 0.0 0 1

Sort (cost=23.08..23.08 rows=1 width=348) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort 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
  • Sort Method: quicksort Memory: 25kB
82. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.72..23.07 rows=1 width=348) (actual time=0.010..0.010 rows=0 loops=1)

83. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.57..17.30 rows=1 width=70) (actual time=0.009..0.009 rows=0 loops=1)

84. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.42..16.47 rows=1 width=38) (actual time=0.009..0.009 rows=0 loops=1)

85. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pk_properties on properties p (cost=0.28..8.29 rows=1 width=34) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (cid = 15,647)
86. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_load_prop_property_id on load_prop load_prop_2 (cost=0.14..8.16 rows=1 width=4) (never executed)

  • Index Cond: (property_id = p.id)
  • Heap Fetches: 0
87. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_beg_bal_temp_pid on beg_bal_temp bbt (cost=0.15..0.82 rows=1 width=44) (never executed)

  • Index Cond: (property_id = load_prop_2.property_id)
  • Filter: (cid = 15,647)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_temp_gat_gl_account_id on gat_temp gat_2 (cost=0.14..5.76 rows=1 width=294) (never executed)

  • Index Cond: (gl_account_id = bbt.gl_account_id)
  • Filter: ((cid = 15,647) AND (grouping_gl_account_id = ANY ('{249085,247842,247843,247844,247845,247846,249052,247847,247848,247849,247850,247533,247851,247852,249040,247544,247853,249041,247854,247855,247856,247857,247858,247859,247860,249033,247861,247862,247863,247864,247865,247866,247867,247868,247869,247870,247871,247872,247873,247874,249053,249051,247875,247876,247556,247877,247878,247879,247880,247881,247882,247883,247884,247885,247886,247887,247555,247888,247889,247890,247891,247892,247893,247894,247895,247896,247897,247898,247899,247900,247901,247902,247903,247904,247905,247906,247907,247908,247909,247910,247911,247912,247913,247914,247915,247916,247917,247918,247919,247920,247921,247922,247923,247924,247925,247926,247927,247928,247929,247930,247931,247932,247933,247934,247935,247936,247937,247938,247939,247940,247941,247942,247943,247944,247945,247946,247947,247948,247949,247950,247951,247952,247953,247954,247955,247956,247957,247958,247959,247960,247961,247962,247963,247964,247965,247966,247967,247968,247969,247970,247971,247972,247973,247974,247975,247976,247977,247978,247979,247980,247981,247982,247983,247984,247985,247986,247987,247988,247989,247990,247991,247992,247993,247994,247995,247996,247997,247998,247999,248000,248001,248002,248003,248004,248005,248006,248007,248008,248009,248010,248011,248012,248013,248014,248015,248016,248017,248018,248019,248020,248021,248022,248023,248024,248025,248026,248027,248028,248029,248030,248031,248032,248033,248034,248035,248036,248037,248038,248039,248040,248041,248042,248043,248044,248045,248046,248047,248048,248049,248050,248051,248052,248053,248054,248055,248056,248057,248058,248059,248060,248061,248062,248063,248064,248065,248066,248067,248068,248069,248070,248071,248072,248073,248074,248075,248076,248077,248078,248079,248080,248081,248082,248083,248084,248085,248086,248087,248088,248089,248090,248091,248092,248093,248094,248095,248096,248097,248098,248099,248100,248101,248102,248103,248104,248105,248106,247561,248107,248108,248109,248110,248111,248112,248113,248114,248115,248116,248117,248118,248119,248120,248121,248122,248123,248124,248125,248126,248127,248128,248129,248130,248131,248132,248133,248134,248135,248136,248137,248138,248139,248140,248141,248142,248143,248144,248145,248146,248147,248148,248149,248150,248151,248152,248153,248154,248155,249038,248156,248157,248158,249081,249082,249086,248159,248160,248161,248162,248163,248164,248165,248166,248167,248168,248169,248170,248171,248172,248173,249083,249084,248174,248175,248176,248177,248178,248179,248180,248181,248182,248183,248184,248185,248186,248187,248188,248189,248190,248191,248192,248193,248194,248195,248196,248197,248198,248199,248200,248201,248202,248203,248204,248205,248206,248207,248208,249039,248209,248210,248211,248212,248213,248214,248215,248216,248217,248218,248219,248220,248221,248222,248223,248224,248225,248226,248227,248228,248229,248230,247553,247560,247554,247551,248231,247548,248232,248233,248234,248235,248236,248237,248238,248239,248240,248241,248242,248243,247543,247558,249054,248244,247557,248246,248248,248249,248250,248251,248252,248253,248254,248255,248256,248257,248258,248259,248260,248261,248262,248263,248264,248265,248266,248267,248268,248269,247527,248270,248271,248272,248273,248274,248275,248276,248277,248278,249065,248279,248280,248281,248282,248283,248284,249057,249058,249059,249060,248285,249055,249056,248286,248287,248288,248289,248290,248291,248292,248293,248294,248295,248296,248297,248298,247559,247529,247528,248299,248300,247540,248301,249042,248302,248303,248304,247550,249049,248305,248306,248307,248308,248309,248310,248311,248312,248313,248314,248315,248316,248317,248318,248319,248320,247549,249050,248321,248322,248323,248324,248325,248326,248327,248328,248329,248330,248331,248332,248333,248334,248335,248336,248337,248338,248339,248340,248341,248342,248343,248344,248345,248346,248347,248348,248349,248350,248351,248352,248353,248354,248355,248356,248357,247541,248358,248359,248360,248361,248362,248363,248364,248365,248366,248367,247547,248368,248369,248370,247545,248371,248372,248373,248374,248375,248376,248377,248378,248379,248380,248381,248382,248383,249067,247531,248384,248385,248386,247535,249032,248387,248388,248389,248390,248391,248392,248393,249062,247536,247542,248394,248395,248396,248397,249063,247534,248398,247539,247537,248399,248400,248401,248402,248403,248404,248405,248406,248407,248408,248409,248410,248411,248412,248413,248414,248415,248416,249034,249035,249036,249037,248421,248422,248423,248424,248425,248426,248427,248428,248429,248430,248431,248432,248433,248434,248435,248436,248437,248438,248439,248440,248441,248442,248443,248444,248445,248446,248447,248448,248449,248450,248451,248452,248453,248454,248455,248456,248457,248458,248459,248460,248461,248462,248463,248464,248465,248466,248467,248468,248469,248470,248471,248472,248473,248474,248475,248476,248477,248478,248479,248480,248481,248482,248483,248484,248485,248486,248487,248488,248489,248490,248491,248492,248493,248494,248495,248496,248497,248498,248499,248500,248501,248502,248503,248504,248505,248506,248507,248508,248509,248510,248511,248512,248513,248514,248515,248516,248517,248518,248519,248520,248521,247562,248522,248523,248524,248525,248526,248527,248528,248529,248530,248531,248532,248533,248534,248535,248536,248537,248538,248539,248540,248541,248542,248543,248544,248545,248546,248547,248548,248549,248550,248551,248552,248553,248554,248555,248556,248557,248558,248559,248560,248561,248562,248563,248564,248565,248566,248567,248568,248569,248570,248571,248572,248573,248574,248575,248576,248577,248578,248579,248580,248581,248582,248583,248584,248585,248586,248587,248588,248589,248590,248591,248592,248593,248594,248595,248596,248597,248598,248599,248600,248601,248602,248603,248604,248605,248606,249048,249061,248607,248608,248609,248610,248611,248612,248613,248614,248615,248616,248617,248618,248619,248620,248621,248622,248623,248624,248625,248626,248627,248628,248629,248630,248631,248632,248633,248634,248635,248636,248637,248638,248639,248640,248641,248642,248643,248644,247530,247546,247552,248645,248646,248647,248648,248649,248650,248651,248652,248653,248654,248655,248656,248657,248658,248659,248660,248661,248662,248663,248664,248665,248666,248667,248668,248669,248670,248671,249068,248672,248673,248674,248675,248676,248677,248678,248679,248680,248681,248682,248683,248684,248685,248686,248687,248688,248689,248690,248691,248692,248693,248694,248695,248696,248697,248698,248699,248700,248701,249069,248702,248703,248704,248705,248706,248707,248708,248709,248710,248711,248712,248713,248714,248715,248716,248717,248718,248719,248720,248721,248722,248723,248724,248725,248726,248727,248728,248729,249070,248730,248731,248732,248733,248734,248735,248736,249066,248737,248738,248739,248740,248741,248742,248743,248744,248745,248746,248747,249071,248748,248749,248750,248751,248752,248753,248754,248755,248756,248757,248758,248759,248760,248761,248762,248763,248764,248765,248766,248767,248768,248769,248770,248771,248772,248773,248774,248775,248776,247538,248777,248778,248779,248780,248781,248782,248783,248784,248785,248786,248787,248788,248789,249046,249047,248790,248791,248792,248793,248794,248795,248796,248797,249076,248798,248799,248800,249072,248801,248802,248803,248804,248805,248806,248807,248808,248809,248810,248811,248812,248813,248814,248815,248816,248817,248818,248819,248820,248821,248822,248823,248824,248825,248826,248827,248828,248829,248830,248831,248832,248833,248834,248835,248836,248837,248838,248839,248840,248841,248842,248843,248844,248845,249073,248846,248847,248848,248849,248850,248851,248852,248853,248854,248855,248856,249074,249075,248857,248858,248859,248860,248861,248862,248863,248864,248865,248866,248867,248868,248869,248870,248871,248872,248873,248874,248875,248876,248877,248878,248879,248880,248881,248882,248883,248884,248885,248886,248887,248888,248889,248890,248891,248892,248893,248894,248895,248896,248897,248898,248899,248900,248901,248902,248903,248904,248905,248906,248907,248908,249078,248909,248910,249044,249045,248911,249043,248912,248913,248914,248915,248916,248917,248918,248919,248920,248921,248922,248923,248924,248925,248926,248927,248928,248929,248930,248931,248932,248933,248934,248935,248936,248937,248938,248939,248940,248941,248942,248943,248944,248945,249077,249079,249080,248946,248947,248948,248949,248950,248951,248952,248953,248954,248955,248956,248957,248958,248959,248960,248961,248962,248963,248964,248965,248966,248967,248968,248969,248970,248971,248972,248973,248974,248975,248976,248977,248978,248979,248980,248981,248982,248983,248984,248985,248986,248987,248988,248989,248990,247532,248991,248992,248993,248994,248995,248996,248997,248998,248999,249000,249001,249002,249003,249004,249005,249006,249007,249008,249009,249010,249064,249011,249012,249013,249014,249015,249016,249017,249018,249019,249020,249021,249022,249023,249024,249025,249026,249027,249028,249029,249030}'::integer[])))