explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NH4s

Settings
# exclusive inclusive rows x rows loops node
1. 0.201 32,956.426 ↑ 1.0 1 1

Nested Loop (cost=10.46..31,029.72 rows=1 width=128) (actual time=32,482.702..32,956.426 rows=1 loops=1)

  • Join Filter: ((cal.application_stage_id = ass.application_stage_id) AND (cal.application_status_id = ass.application_status_id))
  • Rows Removed by Join Filter: 17
2. 1.242 32,956.202 ↑ 1.0 1 1

Nested Loop (cost=10.46..31,027.47 rows=1 width=759) (actual time=32,482.483..32,956.202 rows=1 loops=1)

3. 36.845 36.845 ↓ 395.0 395 1

Function Scan on load_properties lp (cost=0.25..1.00 rows=1 width=4) (actual time=36.203..36.845 rows=395 loops=1)

  • Filter: ((is_disabled = 0) AND (is_test = 0))
  • Rows Removed by Filter: 253
4. 32,918.040 32,918.115 ↓ 0.0 0 395

Index Scan using idx_cached_application_logs_property_id_reporting_daterange on cached_application_logs cal (cost=10.21..31,026.46 rows=1 width=759) (actual time=83.337..83.337 rows=0 loops=395)

  • Index Cond: ((property_id = lp.property_id) AND ('2019-09-08'::date >= reporting_post_date) AND ('2019-09-08'::date <= apply_through_post_date))
  • Filter: (CASE WHEN (cancellation_list_item_id IS NULL) THEN true WHEN (hashed SubPlan 1) THEN false ELSE true END AND (effective_date >= '2019-09-02'::date) AND (occupancy_type_id <> 4) AND (lease_interval_type_id = 1) AND (cid = 3395) AND ((COALESCE(converting_lead_source_id, originating_lead_source_id) = ANY ('{57898,57901,57899,57900,57910,56807,58036,58183,58279,57363,58282,58038,57295,40541,58238,50298,40539,58268,58198,58267,58269,57296,57886,58259,40537,58067,58068,58000,58223,58275,58331,58247,57888,57887,57354,58192,57284,50500,57903,57744,57890,58231,58255,58249,58092,57983,57957,58293,58264,58077,58080,58175,58205,57894,57893,58029,57986,58239,57996,58102,58030,58177,50531,50463,58262,57916,57351,58270,40533,57289,58207,58290,57949,58037,58032,58291,58250,57897,57285,58261,54101,58248,58277,58169,40536,58167,58073,50297,57202,57912,58237,58252,58203,58246,50528,58287,58288,58286,57299,57352,58221,58083,52252,57365,58298,58204,57283,58271,57300,56962,57960,58296,56141,56865,52758,58074,58254,50305,58334,57952,57953,57951,57954,57955,57891,57264,58166,58093,57278,58104,58105,57999,57292,58263,58280,58089,50495,58193,58176,58276,58091,57219,40542,57914,40540,40534,58210,57889,57362,57288,57357,57967,58170,57958,58224,58189,53000,58253,58188,58222,58289,58225,57904,58227,58256,58190,58086,57987,58195,58171,58272,58260,56160,55672,58001,58265,40532,58278,57956,57892,58184,57964,57378,57364,58103,50304,58243,58244,58242,50530,50504,58099,58098,58097,57915,58273,58240,57168,58233,58031,50491,58069,58070,58229,58085,40538,57353,58071,57355,58230,57913,57965,58072,58295,40535,58174,58209,58168,58182,50300,58180,57238,58033,58087,58257,58234,58197,58179,55047,58208,57950,57902,57968,57906,57742,58332,58172,57905,58194,58035,53601,58185,58187,58186,58079,57988,58299,58206,58078,58181,58090,56951,58333,57290,58330,58178,57998,57907,50483,57291,58281,57743,58251,57895,57361,57360,57359,58226,58245,58088,58075,58258,50517,57745,58294,58228,58101,58241,40531,57981,58274,57911,57995,50501,50350,52234,57356,58173,58096,58095,55865,50520,56442,58094,57277,52248,52245,52247,50302,50479,50478,50371,50512,50525,58199,58266,50513,58235,52232,50421,50499,52217,58003,53457,58236,50451,52999,50336,58076,53496,50459,50466,52249,50335,52214,50313,50460,58100,50506,50372,53001,54121,49606,50322,52235,50378,50521,58292,50414,50406,50373,50441,52223,50482,58285,58297,50316,52229,50320,50471,52241,50524,50496,50422,50412,50505,50323,50361,50494,50472,52239,52757,58004,50508,53607,50485,50449,50450,53002,50311,50301,50308,53602,52246,50502,50484,55046,53042,57896,52216,50503,50526,50523,50529,50527,57997,58211,52238,52231,57263,58191,58284,58283,50338,50303,52225,53603}'::integer[])) OR (COALESCE(converting_lead_source_id, originating_lead_source_id) IS NULL)) AND ((leasing_agent_id = ANY ('{215822,228666,222625,219368,218422,216508,218047,220480,217346,229507,228133,221092,228257,228750,226656,222179,210035,214497,227896,227754,228575,213504,227584,222309,220456,226907,217815,204975,215855,222143,219855,226936,221827,219025,215574,217588,226438,220457,227857,227395,216841,218588,218480,227467,228811,227936,219915,218830,218297,215174,218499,228423,222463,222572,216248,217886,214866,216106,228626,226938,212787,222098,221942,219538,216053,226572,217118,213499,217426,218201,221476,227756,222007,219052,215606,229277,204967,221018,226831,222560,226680,226503,227681,228203,213502,219440,227076,220268,221355,227891,228949,222819,222045,216719,229282,222655,228135,215300,229084,214329,228694,228693,220757,229136,205736,227211,228225,228999,216798,218364,227365,226662,227301,219889,226582,228953,217484,228218,218239,218056,218487,216401,222096,228059,216386,220200,212665,215165,221986,226849,227309,211425,219970,228921,221791,216912,216689,212808,222504,213506,216642,215592,222203,216558,222811,221144,227942,227781,226358,202675,222151,218470,226466,227372,222464,220833,220292,228909,221988,226387,219569,218807,229228,219513,217021,221786,229404,200092,217604,227697,219331,217495,212803,219948,228960,226409,215332,228760,222755,217105,205801,227976,218773,228522,229355,218298,216570,217483,219673,222071,216587,213143,222142,228459,203214,217557,227323,217979,217597,219829,216398,227865,222044,209836,221264,227612,221333,214463,214862,216534,221041,228174,221202,222233,222630,217867,216286,222846,228540,218340,226912,221117,220174,216783,220936,222475,221461,211010,221433,227017,211399,228743,227742,218931,217114,222597,227397,229495,229466,226507,222192,221661,212972,221366,222894,218596,228680,221171,217659,222209,216289,215462,228930,227671,227004,226679,219457,222747,213672,217025,226947,226624,227240,229435,214254,228931,228281,221245,216283,221981,217187,216331,220472,215291,218317,229373,216554,214854,219789,215307,229329,222497,229225,229304,222765,222317,219734,218767,221314,221467,222697,222853,221173,221556,226538,228701,227725,220487,227984,218220,217352,221985,226744,222989,228275,215947,227239,211517,218257,228845,222224,219466,228843,214050,228082,228703,221089,218265,218418,228262,217244,216712,222065,221910,216294,227680,216670,226334,226794,221384,210828,220852,228773,222060,211336,220228,220326,226545,228112,220303,220390,213141,216211,213976,227593,228836,215662,211581,228805,217384,214870,222323,220197,228673,217383,228556,221489,222241,222634,216281,217965,217581,229349,217541,226989,220341,227097,228414,217367,227785,228514,226535,217875,227701,228883,221715,221740,218441,216402,222662,221555,220110,226571,221605,217572,210855,226343,220082,220820,221213,228198,220867,216387,228409,229406,219699,200252,217698,199291,217961,227962,217518,227077,226366,219959,218344,216175,221762,221983,228401,221869,220130,228618,228255,217065,227384,227546,216807,229191,221321,221177,228665,217522,221175,229009,227904,222402,213501,227649,222857,224432,226641,220074,221996,221469,220249,218164,228292,222364,226444,217514,228007,222921,222703,218311,222231,217601,217697,220772,216261,228670,221865,217523,228329,219566,215182,222890,226521,215469,219809,226686,228627,222009,218668,214176,215203,221914,216023,216102,227499,220959,220016,216814,228511,211390,228580,225640,221014,229120,228265,229358,226553,218821,229464,228186,216336,209837,221946,221809,228269,220846,222573,227954,213705,220889,222966,217690,214229,227014,226846,217460,218723,218696,200236,220727,227317,227556,226952,221234,215912,219377,221711,226513,217226,228523,208701,218189,226188,227646,228073,218822,226839,220466,213148,218118,228331,222833,228129,226351,228820,222796,227382,216725,222239,226644,221812,221729,198791,228825,221168,218063,229433,220119,198808,214692,207251,209143,219046,229506,228037,222792,218633,227433,221329,215494,225637,228408,226364,218390,218153,209794,218498,221468,219356,222169,222226,215832,228248,227624,228139,213162,221017,228797,220461,228266,218308,216839,218522,228534,218231,220218,222106,226919,227806,222806,219137,227210,203213,228521,229207,228903,220215,216929,220423,229085,222025,216701,227830,229386,200095,229326,216210,227968,215455,216931,219728,218395,228092,211736,228546,220250,218169,220178,228204,205267,227983,226896,229233,222046,216978,227689,227490,219607,217687,222789,222675,226851,226642,229429,228882,212805,222177,227448,219421,227676,228720,217893,217479,217861,216468,226426,221024,219877,204072,229101,228447,224476,221050,219051,217570,228549,229452,220043,227007,219905,229243,218495,217243,215326,226352,228925,214121,228091,220999,228640,226570,218716,218254,217865,222127,226961,217942,221169,209838,209878,228310,229274,183729,229265,221716,229375,217459,221979,228552,222368,227639,228441,227089,216385,220122,222741,228244,214349,228197,213281,226567,220964,218373,229393,229455,222735,221463,217194,219351,217090,226750,215267,218154,229474,227964,220061,215235,228671,227501,220241,228756,229521,222594,217680,215548,218270,217386,219143,214219,216028,226843,227619,220834,221004,219641,213780,219239,215959,228405,228954,218283,216141,217107,226602,222363,221444,222144,228351,215428,229351,222101,228579,226367,228060,229417,229353,226344,210085,218179,227423,220861,227401,227625,227129,228400,205737,222609,222171,220211,229297,227870,226957,203331,221020,226976,222519,222100,222459,228757,215437,222550,216410,217100,216132,220348,217652,217121,228017,228531,212761,213147,221138,213259,219381,227640,213998,221280,222869,227835,217456,221492,222727,222940,219310,228141,227817,217974,212860,228019,228686,213641,228487,199293,220759,216770,207818,228585,228729,218010,221545,228352,228157,227635,220072,222972,228471,227298,222666,221678,214694,217990,220728,215704,220837,228623,219664,218614,227638,221236,226878,216071,227144,220059,220217,222878,203637,221621,214592,228336,228922,227093,227019,216295,220012,220374,222261,226721,225617,221377,229426,222158,226362,226654,229064,213906,217335,214667,221304,213149,218466,222232,220995,218748,226353,218007,227768,219828,221055,221611,216031,218247,220089,217088,216789,226565,228824,216368,228647,217962,221060,222714,215463,220134,222711,218826,228472,228706,218685,221575,227911,227585,222129,217140,226792,228070,226610,219565,217995,227440,221941,221043,217155,222099,218519,221748,228143,212234,221685,216933,226463,202829,221569,218715,228509,228258,219857,228020,215869,220439,210036,215911,228566,216163,220904,221322,221324,222167,226573,222611,222731,216403,216736,227191,227271,222839,218171,221309,222466,221587,227977,219053,205356,215683,217825,221005,228184,227522,210037,215371,222761,226539,222029,225609,228910,217538,218679,220817,219179,228285,227180,228938,214352,228293,217650,227554,229416,228897,221826,226829,211011,221709,222271,226534,222701,217540,214647,217586,217749,228212,214746,222163,209239,216042,218430,218494,211012,220270,228108,227400,228436,215316,219590,222828,221927,227199,226720,228086,222875,206150,200267,218102,228771,227485,222115,222605,218312,218044,216266,221156,222312,219987,207894,218699,219546,228510,228500,209839,222734,227767,229266,229291,222307,222314,226371,217877,218510,228353,228435,221176,228553,219884,227469,221540,219082,228638,227059,227669,217577,212534,228917,221031,228813,227656,228538,228808,220416,219736,228233,228376,226887,222657,218315,222493,222781,199250,227774,227164,226492,222315,199423,222814,227784,221513,222022,218431,222399,220027,218520,220998,228584,228372,215388,218597,217128,215292,215570,216202,222178,217542,228591,218749,218677,212785,228952,216391,217578,215321,214301,227780,211501,227978,213909,221401,218224,218128,216617,227878,221649,216641,227972,222855,219840,228518,220921,218823,218174,200097,221965,226696,217920,227647,217761,213586,214483,218098,228981,229107,226563,228965,227370,217399,228614,220316,227030,218798,219963,227496,221210,228625,217358,222862,217797,221503,219441,217576,219545,222804,218789,222803,220192,217509,227966,220040,215564,226847,222977,217487,218497,218108,222565,216899,228238,219982,226852,227578,216498,226752,222265,229325,217771,221818,220152,227916,227018,220895,200101,228935,215325,229296,227109,220062,221392,221180,220313,218721,228464,215293,228195,222313,216718,218695,227031,218314,227479,227080,228263,221900,228758,216320,222508,222118,216174,209840,212292,222234,227808,227378,214267,227500,217605,227386,226599,216638,227886,220047,218199,221394,220325,222889,217410,226998,228815,218032,229102,226653,217916,227167,222300,229402,218680,227668,228807,227657,215775,226864,207231,217922,222991,219024,227707,217006,219813,216571,212539,218671,228678,222278,220167,220206,214377,217642,226633,229498,216127,228253,228205,213179,226700,229182,229497,220981,229146,226190,226676,226980,222383,227071,221214,206397,221828,227057,218255,221759,227820,211473,228600,225631,220771,227218,217202,219524,222826,219830,220961,220930,218200,228014,217752,214051,229328,222097,229522,228460,217157,224459,214908,220830,203898,221159,216875,222436,228735,211285,229401,221151,222578,228006,216982,217828,209874,228943,221622,222834,217351,229018,211286,227237,209841,214308,219681,221728,227087,222102,228814,228382,220927,220128,219999,226416,226502,226703,219282,226722,221830,228305,219950,226328,203925,215845,221814,227207,228621,217485,217579,228368,217873,228763,229103,211717,219705,218132,209842,229178,227124,221673,205366,224466,221504,227434,217693,215239,227517,228396,221662,222704,219439,216072,227800,220310,229470,221949,215318,226814,217395,217380,218292,226701,220020,212237,219515,218022,217180,226597,229011,227267,228325,221198,227078,227286,228915,221763,222235,218592,219727,216212,221491,227843,228637,229514,217741,227185,217841,217713,218593,222430,217800,221873,218379,226977,221916,226761,227859,218009,217153,222809,229459,215833,218037,221016,220803,213905,227194,212650,228536,227665,216120,214317,220910,216247,227910,228005,227729,226705,224412,221579,200170,222737,204966,218350,221161,222039,221496,215578,217382,221111,229261,217554,226646,227154,219635,221903,226598,222931,219675,222871,222949,220854,228333,218349,229305,228733,217809,219508,229236,212288,222953,209875,228778,227230,219313,228075,216777,221239,219135,221970,229327,215846,221944,226418,221832,229061,217181,217641,216049,215755,218307,214616,227979,217773,220764,226544,203927,221650,228563,209244,218602,216362,228187,222907,214220,219693,216025,221822,218261,229448,228603,211000,220302,215950,221947,221420,217050,211897,218167,221028,215951,219612,222104,221248,217188,228470,220238,216541,215590,217098,226615,222427,227587,220411,204998,228532,222928,228615,220878,219953,220014,226511,210040,228994,209243,227804,214249,216397,219920,229176,218473,214687,224460,227166,227346,228832,229121,217307,220912,219446,221931,220758,217952,229004,228873,218453,227427,228194,229110,219602,226467,226363,227155,222378,227959,222881,217220,228765,228379,228734,226883,222924,227694,218066,215849,214202,199430,226487,221995,210041,229067,226368,222968,216358,220987,217030,222274,226671,221959,219168,221600,215408,213397,218750,211160,218582,220231,216850,224446,222537,226780,211004,206154,227641,226457,215450,226898,215937,219035,228924,228276,226928,228870,218398,216449,221802,220332,227741,219856,215949,222038,226997,221618,221659,222577,228051,226812,227251,228846,220001,211008,220923,227314,221145,221146,222964,226827,228590,210042,228468,222695,221240,216488,202828,219901,229309,216742,218697,227841,217528,221495,221010,227535,228976,220933,218276,218275,216392,216296,227557,228812,218463,227567,206390,227626,217705,213997,226378,211037,227514,220872,215476,221216,218795,227887,216417,227383,211288,222961,222031,217341,228565,228973,216333,217472,222896,222113,218232,222946,221610,227477,217968,218756,212806,227692,210589,228490,227482,222269,220434,228516,220378,227574,226189,228692,211495,219126,222805,221426,216576,218204,228507,222488,222724,229071,228712,224427,211035,220304,213142,228228,226665,222411,226639,215871,213127,214748,220754,210044,225648,211433,227727,216372,216022,214247,221275,216404,222739,227456,219314,229294,228148,229371,228978,227858,228755,221288,219312,219437,222951,221493,225606,220843,216540,222591,227036,228767,220291,220380,222575,219280,214226,227454,228307,222002,217559,218803,222905,222214,220811,222263,227739,217573,227377,222981,221030,218591,222824,218517,215605,228208,220135,227553,221725,226782,226619,222558,215328,222157,228892,219367,228245,229193,227366,218339,216260,226569,209844,215198,214114,217721,216800,222687,228597,220467,217786,226735,227973,228900,222034,222678,221323,219860,217950,211387,226583,227212,216131,216809,200029,228223,227539,218369,222451,218245,214138,222161,209845,222424,227353,210034,220821,222027,222107,217932,222069,226890,213587,227634,219595,224457,215546,215188,228964,229074,217567,228171,228508,220831,203333,217318,215091,221194,225615,221800,226712,222750,221514,218002,229292,222970,215097,221932,219065,215220,211388,216461,221515,211504,227704,218687,211432,227337,227187,226993,218617,219968,219668,228526,221971,219700,226746,227616,227997,216349,228381,222496,226841,221719,227339,221516,221093,215464,218251,222641,217378,222619,216062,218386,221671,228128,229059,224452,210045,219540,222387,212235,226433,217574,218442,226415,222075,220911,228596,218156,228491,218029,216703,222590,228211,228602,216538,220812,221118,219946,228412,227543,219908,216079,228685,220323,220469,211593,214650,227948,228572,227272,220920,228779,222832,218221,228230,216878,227489,219919,221215,216224,215735,215638,228920,210925,210924,222649,215708,219346,221982,222152,219512,228629,224440,218724,217556,220343,226813,221930,218620,217340,216717,227571,228704,218013,215729,217503,222728,215593,218180,215452,228646,226490,218445,214614,219372,229219,215572,214703,222547,228894,217490,222250,226472,217989,227115,226462,214258,222754,216604,227922,216048,214379,228911,217215,222193,226370,216724,221351,228651,228375,222877,218198,215223,218670,222729,227055,228445,221892,213139,221968,228280,222262,228069,226588,216677,229321,227244,222974,216969,217987,228969,222525,217015,204976,228503,217317,218012,227838,228125,218829,222085,218888,217959,229489,218332,213674,227677,222412,228001,222495,229113,209846,226604,227409,221984,216737,227675,219876,216026,227131,228271,226586,221568,228656,228817,215055,228330,218018,222441,218107,211976,217977,221127,226854,222015,216781,229210,229069,226486,219896,217305,222721,222447,222763,217644,226674,228370,228683,226374,216472,218139,221966,229407,221276,216310,226473,219573,221893,218246,217748,229384,228000,215858,218619,227462,216707,214002,227302,220041,228340,214131,226726,229366,220248,226891,229372,200224,222361,229382,226951,218704,229414,217034,227116,221084,219934,221141,217956,229189,220767,216373,219079,229203,228455,228715,229405,215248,228369,215202,215825,204972,218626,220747,227792,228079,228963,228533,215724,217414,218120,220256,227985,216484,222650,218053,221608,227598,214668,213781,215549,226756,224463,215961,216113,200099,217946,229100,218023,227607,215170,226369,226769,219358,228777,217759,228113,219794,221517,222195,215630,202632,217398,204973,226751,227006,228645,200102,216323,217618,222054,211401,228904,217133,228859,221953,210048,222900,215390,219536,229058,215515,215315,228528,222738,218042,228649,229238,227757,221801,218046,222709,221642,217857,228380,216110,222066,221686,226692,222125,227747,226984,221308,227255,219081,218634,221648,219132,219622,227231,229395,217359,226755,220982,210088,221307,222410,220792,227327,227113,229348,221655,222873,219483,226809,217958,211533,227236,213188,222443,226824,228359,218226,224417,217816,222417,221940,220246,214664,215487,222283,221328,226372,219350,227847,226800,218632,220123,209847,220829,226772,215438,216150,229132,222601,228838,228578,227753,220783,215731,222384,227391,221948,228080,218054,229169,215409,217063,228130,216492,216469,216088,228422,227020,228291,229179,228789,228672,226455,222780,222868,220459,219819,217419,228427,227159,226355,215505,219685,226616,226893,218705,227812,220800,219713,218616,222726,228341,228277,220944,209848,222807,219407,227907,221580,224474,218374,228229,217146,218825,221460,221723,222273,219648,226850,222576,227846,220379,226484,226517,227426,229186,228564,222554,218765,216930,228178,217783,219883,214387,219409,227229,216845,227120,226990,217033,221969,227805,228134,217023,221098,228013,226753,218725,221294,227591,229299,217760,228012,221792,205351,224454,217007,228747,220406,217716,211287,216539,218166,226661,222596,221237,229330,213393,220884,216350,227882,222011,220473,229015,227990,221232,229264,218586,219460,217682,215611,229130,203897,227527,227062,222712,221352,219537,219608,229445,221238,221557,217488,228687,220170,227939,220002,216536,229392,215906,222172,222372,215955,221291,228798,218248,222794,229125,227101,214496,221458,228033,229129,214595,216918,211159,221085,227134,221974,217840,217544,229519,229070,218075,228304,214381,218316,227564,229079,219447,226754,221641,220327,213987,222247,216692,219496,222864,220085,226509,217319,217200,229390,222021,215903,211276,228545,228644,203926,222883,219978,217530,229450,221126,226894,205357,221356,216784,220193,217211,216065,211760,224421,218457,222779,212236,219724,226762,228984,218271,215468,222926,222166,215506,219621,215238,222392,217984,221452,221395,214863,222073,213503,226781,228328,222457,220396,226458,217532,218651,217504,227450,220266,226643,226536,221952,222975,221551,212002,219169,229161,216126,215402,227548,221123,219241,217631,214468,226603,221412,216428,226640,215851,218644,222822,216434,220213,227311,227946,217548,215952,228415,229286,228485,227851,215294,220196,219144,219036,219683,217489,225619,215314,217858,222433,219345,226647,228146,221186,221078,226460,218505,218264,226790,221687,229172,220914,222164,227825,221604,228444,210521,216758,220419,220003,228335,228896,229124,227775,219050,219824,221518,221875,215581,215642,215582,219825,220395,224420,228410,214475,217565,216569,227898,229109,226347,211400,217139,226421,217366,215232,228002,222289,216454,227621,228161,221009,226655,221174,221505,218425,229254,211238,222797,217482,227723,217481,221743,213395,218223,222016,228628,222715,212961,227542,218273,218376,215489,216228,229447,218331,228744,222644,229517,218256,228142,228383,228384,222431,224434,228090,218427,216030,219617,219511,228749,227402,227580,228453,227600,227398,221637,226537,228031,217392,228835,216416,222639,214259,216596,227342,227326,218629,227169,227861,229461,220195,220868,222134,227096,228360,216585,222453,227731,225636,215407,226461,212104,222245,226345,221432,217639,221465,228891,227950,205302,213725,227328,218112,218594,228783,227881,222170,227728,221155,222652,218436,219076,221836,219497,227528,218393,205656,218477,222128,228371,219330,226638,228224,216407,219667,217714,221102,228707,228076,227829,221651,215679,229167,214241,229441,227596,226970,222917,218797,228074,228946,227143,217361,221578,226186,222502,221924,218205,221929,227174,228541,228893,213405,226913,217069,218635,227845,228561,227242,228631,217648,218094,220223,208675,213724,218621,228513,227930,218004,226940,226776,210086,224484,228120,227192,229174,210852,227744,217423,228392,219530,221152,217744,215412,228389,226527,216714,210049,227417,218319,227895,222874,228168,226666,220804,222490,227883,226873,229253,227862,228323,227288,221413,227945,213977,219206,221074,222145,226969,219415,220199,219479,216700,228586,228570,229126,217707,222188,199294,226562,220744,209850,227416,229449,225614,218688,229422,217855,229156,219708,229368,228982,215677,218380,218451,216282,221519,217891,221447,228251,226962,227108,220000,219997,227445,227161,227254,215204,222419,227336,218877,209851,219283,228790,225647,222499,228270,216615,228861,221150,207243,227287,222979,227471,222643,213505,226406,226338,218076,219074,228220,229139,218438,218698,215467,226187,227268,226941,226995,221427,228110,219791,218024,211335,215522,222992,221404,215459,227050,221464,216465,221775,226514,221773,200169,211003,203212,222730,221071,222771,216833,222236,226996,228702,212103,228660,211557,229398,221609,221284,229083,228294,216522,220931,226621,229192,229487,227280,229524,222080,222324,221937,221919,227733,222484,219303,226359,226556,221265,221273,222770,227863,212290,221520,222168,215394,215401,228127,226983,222653,209832,205354,215571,228243,208961,228215,217988,221993,220066,217681,229208,227362,222978,226706,228539,218479,227852,221790,227769,217943,222604,228196,226340,227905,226858,228313,218683,221015,210518,221197,216301,219042,228840,227415,228530,219907,200098,216466,216240,221861,222993,222036,209696,228737,227855,218460,229293,228544,213783,217372,222013,211016,221069,221803,227957,221506,220876,219480,226391,206132,204097,220986,222539,202817,229301,218693,220028,208969,228941,227541,229145,226632,228027,216663,217058,215395,222831,219954,227569,221122,221293,217461,217701,199412,199288,221370,211427,213138,227200,222629,227687,222813,217539,221829,228501,221672,222205,226902,222627,227992,203210,225601,228766,219976,218446,213703,211510,222886,217431,229237,216063,216334,228356,229087,228116,216222,227538,221185,220853,229259,226881,216721,215637,216960,222308,216497,227090,211391,221500,217608,226465,221306,226863,217054,227867,228716,200263,229397,228081,228869,222037,219918,221742,227186,220919,216559,221263,216954,222165,220088,219993,227734,219914,228730,226342,227085,229437,229098,226711,227135,222371,229117,227389,218233,219656,228559,220468,219315,222888,217575,217616,218323,227952,209853,205692,222973,228684,219069,228826,221813,228164,221223,214065,222920,229213,220272,229134,228844,221470,219400,229194,228782,220245,217778,217775,219863,221973,216223,211027,222654,222971,226554,226584,229099,219897,227459,225650,222244,227925,226657,228555,228604,205799,222083,227315,220957,227667,228213,227530,217198,227875,228605,218909,211977,229269,221441,218306,228848,218072,228299,222751,227483,215796,227811,213189,216953,204096,221789,211944,209876,228042,222740,217466,222622,217036,211908,228505,228535,217689,222251,226828,227879,199426,227381,229205,217720,217890,218525,226779,227572,228268,228202,211031,221189,219468,228582,220381,226669,210851,227899,227726,210520,226937,216773,215534,227446,211002,228961,226825,227060,219594,229357,217117,214228,227558,227408,219412,226451,216702,222551,220271,222259,226677,214665,228643,226945,228927,218324,219442,228674,216144,219410,219575,217955,198620,229415,222426,227000,216740,220855,228437,217983,228589,213190,221466,217804,217014,219969,211500,220368,221183,217787,227052,221967,221381,220972,219174,228775,218472,228759,221103,227392,228983,228852,217094,224478,218294,219347,227367,226434,220009,217116,229204,227201,205365,221372,218433,219361,218454,229359,216981,216971,227132,221165,228034,199249,217240,222574,217312,221793,219958,217700,221824,216819,227149,229081,228260,228247,227053,209854,229310,228947,228956,227776,217976,218650,228364,217563,219916,227388,221061,217931,212034,221936,227148,217027,222944,228537,221770,217793,220454,226331,229140,219444,221571,220053,222626,228078,221856,220329,228367,228479,219583,229155,228524,221565,217923,221878,207708,228641,227518,221963,221589,227801,219378,219395,216651,216441,217622,226885,211028,221776,222114,227190,227505,215830,205303,219974,216869,216865,228283,220100,221032,202630,228661,222916,229137,219657,199427,222986,218812,220894,220095,215302,222865,229340,219589,219445,228988,227029,228818,217237,218191,216837,228650,218907,218225,228945,219888,227562,217599,221859,222936,217186,228122,213191,218645,220024,220067,220068,214200,222242,221035,216831,221471,229115,228104,222084,229063,211539,218329,218666,215904,217868,219881,221279,228929,218266,225602,219311,217960,211014,228700,200265,228690,226958,222902,228497,222854,217350,219208,227807,226830,228827,212990,219834,228819,216970,227320,216611,224450,219492,216808,211744,227856,229231,229209,226897,229076,211474,215218,219576,227376,197767,213394,227610,222438,228619,218718,227243,218674,219176,219679,200273,216306,218296,221542,214465,216051,227506,227691,219960,228030,202631,221247,228726,217533,215162,221000,210853,228322,218450,227424,229188,228221,219067,216501,217696,218151,218518,228879,228011,220956,214406,216586,229516,218338,220888,220198,215440,222255,220403,229092,218764,216668,226682,228998,226600,222422,228587,218435,219810,227011,214864,228576,219333,216797,229158,227385,220191,220363,219605,218416,199417,226589,218507,228874,227991,229275,221357,221926,216167,221769,228236,222555,228344,222505,226555,216636,216616,228902,221767,217661,219419,218161,224483,217138,229187,222067,219795,228529,227358,221521,217304,228350,216314,219352,200270,227177,226524,221920,222954,227613,220968,226786,228881,222976,218021,227755,228252,221212,226678,221550,227637,222141,221977,222301,222391,226778,221681,222043,220164,228085,227015,203290,229334,212294,228183,206401,218170,226684,219382,220926,226690,217227,222764,228633,220398,226464,222120,220205,228314,221815,219156,222670,219618,228393,221872,206393,216043,229229,226730,228105,229465,217769,227444,222592,218523,228461,229218,216446,211609,228433,228642,215465,220394,226934,219740,227273,222823,227009,226815,226494,226499,221270,227480,228709,220879,209699,218678,226547,220481,221821,222243,218041,226383,222841,218776,228594,217944,228525,216118,215051,228342,221765,229166,220938,220435,222694,219408,227510,229336,220992,222686,227223,217817,216805,220045,228004,216730,227228,216101,227940,217658,217099,222185,217777,202513,227010,216505,221073,228416,228077,226376,222103,219793,218381,220474,227666,217195,226595,219516,213868,217230,211024,229284,222162,216046,218334,217986,216961,228980,218008,227357,221266,222388,215250,227188,215355,211009,228974,218175,218347,228327,229314,221490,198795,215373,215405,227965,216279,219663,217035,217120,216396,227967,229302,225613,227330,219977,220235,219592,221121,216732,228214,215656,228216,229262,220347,217970,221064,229501,227117,219944,227110,226510,219386,221405,221676,211426,227421,227599,219909,213442,222628,216413,222001,227137,217026,217818,229454,220042,226710,221408,227609,228029,228349,229311,229160,229440,211403,214234,217164,219684,227318,220774,228506,228093,218740,227679,222252,229247,227642,217332,222418,227565,217326,215804,229400,222389,218503,213782,220967,213996,218511,222937,218065,228842,221296,209695,209855,227688,228024,220254,199290,212807,221777,227823,228315,217776,220190,221425,228337,226921,222458,228878,216311,222699,217468,227876,219127,227072,218272,222817,227511,220032,215629,222935,209697,228979,226982,217189,226424,226869,221163,218758,222892,220251,200425,228517,218814,222450,216959,229080,212233,227521,227463,221053,216064,227955,215451,220385,228728,221899,227913,227864,226361,229363,220765,217235,217585,222645,218293,229148,229016,222790,216384,228326,221507,222047,220048,218440,226549,222943,229226,219666,228426,214845,229104,228823,216584,218084,219332,216799,221217,227460,226594,221390,220184,215914,218501,227410,222122,220376,228657,227783,227025,213749,228868,222376,214809,227740,220084,218481,226959,208403,218365,229162,219870,227265,216450,228567,219643,217883,228554,218346,227931,216672,217476,220950,216140,216906,213398,217607,229369,222032,211005,226645,227141,217405,227214,227720,226802,220109,217124,226763,216182,228160,227550,215573,226903,227453,228346,220030,219940,217688,221994,228934,229128,227529,219026,222292,219507,222479,211475,222390,221938,213572,227428,228492,216881,229276,217921,227332,218929,226388,215941,227579,217745,229075,218184,227814,217715,218728,219658,216483,228303,220988,228794,216957,228908,229252,228784,225624,214451,227216,218020,214177,209873,217527,216883,228913,221508,218817,219470,221067,214174,227128,220230,217438,218878,221871,229364,217149,219989,217376,217452,217665,226857,228021,228015,228365,203896,222651,218700,210927,216882,220098,224477,226757,219947,226770,222637,227999,220996,217308,227222,227988,228995,221353,229151,215458,218781,222187,220127,228722,228951,211430,221539,228450,215324,205347,215545,222375,222186,214617,215641,226729,216337,226412,218640,228348,222257,227996,218001,216697,216711,227073,228235,217037,226971,218625,218229,226719,228009,214173,220791,220947,210051,215221,221295,220312,229378,219531,222366,222562,217325,228592,217829,228023,226649,227083,220816,218930,229171,226330,226691,221559,218618,218432,219582,219615,214250,218490,216464,228906,210951,213625,227387,204965,217901,224422,217295,229152,222691,221478,218771,219038,227074,229306,216832,217702,220293,217475,219839,229347,222845,222659,227379,214157,222382,221668,218214,226411,227245,229118,217571,216024,216178,221524,229485,219056,219864,222280,227284,217097,224405,229133,217303,215859,217374,217774,222040,220440,217119,226931,219638,216910,221509,222048,222842,218681,222856,217439,219498,226516,221682,216763,219402,214745,216047,217142,227570,221438,221243,227724,220285,227771,218079,218763,222423,218524,226911,221473,228806,219131,222321,226593,219019,217497,216075,229082,228107,222969,226683,218040,225603,222580,217442,217834,217656,210017,218673,220781,227982,224442,225623,217863,217451,211283,216448,227926,216176,217531,228850,220094,220073,221688,228094,219647,217584,227713,217788,226895,227981,219788,228745,221142,227130,218647,216952,215498,222303,222633,217980,219157,219355,216976,229017,226749,218828,227715,222618,216515,220928,226608,218663,217330,217223,222758,227322,226872,201071,226485,229379,220449,218832,227331,229289,226738,214179,227396,217436,227951,214686,227442,228885,227204,220875,222595,227024,228179,222480,220391,227995,227796,228613,227718,219360,221297,222988,213779,218036,227563,217589,213399,200269,220493,228425,211862,217758,214175,228624,228502,217343,219852,219639,221879,222180,222901,211386,199422,210032,220725,220036,203884,217512,227119,217902,216107,227491,228504,216820,215445,209692,220993,227079,221862,215207,217803,216661,217782,216482,220201,219329,219604,217756,218905,229320,222434,216241,217084,220893,219784,228957,215963,213684,221741,227716,217521,219557,229060,219365,221894,218051,227497,198806,222909,215608,222501,227919,217457,226373,218133,221679,221617,220491,227608,221906,217895,198621,221860,217819,219371,213692,227289,228914,218876,222642,221399,226560,221972,217730,228723,220924,227455,227472,211534,215122,219603,227595,218727,221128,222264,227001,222213,220785,217156,217480,219464,227690,218506,222923,222146,218469,228239,228664,228748,220726,220724,209788,219787,228306,217328,229471,228126,228169,227418,219981,224458,229106,219514,228746,214388,220305,221187,221915,220350,217889,226810,229381,229394,224415,221880,226837,221992,221360,218437,216751,219384,226605,220328,215758,220118,221488,215779,214244,217660,225642,227122,226672,218833,229196,228593,219438,221227,226475,221561,219917,219952,219777,222486,228837,216528,227533,216523,219710,207112,228358,218321,227889,222514,218258,217789,220257,221081,220798,214082,229335,221538,221935,226522,218722,227969,218121,218100,211714,214232,210052,222204,228950,220107,221689,217951,217031,229230,218496,222485,216514,221002,228919,213128,216544,219413,229525,216487,226627,216513,220902,228519,228373,228308,216077,219962,217177,226747,227156,225608,221958,227961,220844,228249,220019,221120,218069,226564,218080,228742,228939,227545,215317,228858,227975,218396,227555,216851,221079,228434,215391,215555,215632,222636,217949,216972,221989,221267,228781,229258,226339,220836,228402,228708,221477,215848,221554,227560,216553,229185,218796,217253,221403,215919,226685,216455,229003,219484,227232,213145,227368,228944,221335,228648,217821,219821,221868,229439,216232,227075,216263,228787,227611,220913,217691,229220,216650,227795,221008,219951,228562,217416,226393,217070,221454,216648,213396,219073,200028,219391,222787,215706,221417,229223,215960,216406,219404,222078,228438,228309,217736,203215,218059,209877,220471,228905,222063,226986,227711,218068,229418,217832,218761,229190,228606,219128,228199,221400,220353,211863,228816,219319,222922,219366,228588,219341,215366,216566,226880,228250,222802,218792,227877,228219,226650,227897,218733,227623,227935,211509,219731,222793,220335,226806,218039,218906,217402,222275,221100,226337,210856,216659,211020,227549,227989,216705,209864,227374,222632,222681,221858,228289,218413,199411,214666,228754,222373,215705,227986,228439,221663,215870,226910,229157,216370,228739,213079,221526,229227,222994,218337,217734,221475,217657,219519,229388,221402,220369,220263,222960,220966,228098,228776,226992,229472,220029,215701,227880,222291,214147,218238,216500,228736,216608,222606,218439,224485,219853,219726,215685,219720,217609,219450,219278,228240,227049,216254,222906,216411,226922,219416,219994,219522,220925,217549,227827,220237,227770,220863,220315,218003,224447,220769,226731,229360,225630,218904,226606,220375,228770,224413,228176,217450,209833,221511,217254,214227,198810,229024,227303,218612,221068,218805,216253,228207,217610,227850,198792,228926,210631,219039,215400,215942,222111,220827,217052,219696,222448,228855,226836,217013,221184,221991,222852,226557,227540,227892,228691,221720,221819,217982,209865,229108,214464,216818,227021,226664,222237,217860,228347,219238,229180,221764,222760,226575,221011,226437,220006,220194,227275,211284,226625,219499,227566,221334,227590,221072,228267,229467,222398,227849,216975,200424,229181,227217,229097,221739,221049,210818,227758,224467,227102,217757,227762,219353,226401,221119,212971,215655,218736,211786,227037,203636,227594,221620,228417,221040,222742,222230,227924,218701,220980,226889,220850,213986,229303,217649,221057,220284,228476,222088,199429,229235,217887,214904,227658,219985,217820,226865,220142,228617,227842,220835,219975,209866,227349,217412,211907,199252,229376,218447,227840,218375,217339,211497,218692,221780,198789,221837,227759,209240,219033,226724,226551,220915,227371,229062,222119,226392,227603,227661,215957,196259,227532,227509,218019,227027,226963,221195,216579,227737,226453,220046,227092,227958,216405,228966,216138,229385,229073,226634,218038,222867,222421,229005,228741,219957,217377,211409,229184,221361,222676,228185,222318,217606,228200,219878,215523,227258,228324,215958,227834,218140,199428,227175,227233,219452,228295,215367,229096,227573,222407,221211,227413,214652,217646,215929,221531,217492,217491,228923,216418,227291,216055,219510,215128,222393,227944,218581,199204,216612,228038,222769,226985,218467,211498,226784,220216,217309,219973,218392,228822,226741,227095,222782,226550,229391,228688,221233,221125,229515,228424,222778,215265,227443,224465,215372,222685,229413,217762,219201,227885,216112,228397,221375,217493,212238,216749,215553,229463,226916,222719,217418,221670,226341,217239,228152,218313,217679,218786,227351,220949,203216,218802,217726,217779,221218,217425,228718,228131,220797,222660,228668,228206,227487,227523,229119,228550,217524,218648,217508,217587,227884,226862,220746,229434,220269,219385,216452,221208,229362,228912,222174,211428,228022,215045,227738,221527,217310,227971,228866,227227,221277,228158,216270,221287,218078,216575,226420,215125,203928,222561,219588,222722,221755,228932,222202,222710,228390,228793,217232,220737,227266,228655,222903,227760,228681,218584,217624,220871,206181,227196,228667,215953,222008,229319,227193,228865,215295,217937,228970,228796,209868,200274,214739,216458,209700,229212,219078,228089,226725,227833,216255,213870,226860,226408,217430,217389,217623,218813,228399,227263,215511,212536,222010,227203,229354,218210,217729,228676,222041,211007,229127,222748,222062,228136,222885,222863,216089,221094,211036,219988,220788,229217,221778,217217,227091,218244,222507,222108,228654,229068,219063,215956,221788,229013,214618,222051,227839,219598,222791,217683,217975,221987,216032,216630,227430,227012,218206,228418,222518,222511,217236,219129,226874,222290,226808,216256,222272,217209,217640,227307,215123,227114,222153,221472,221537,222844,222297,222059,222189,216252,204931,224445,226601,217029,216609,222671,220409,229263,221528,226956,227335,227219,222200,227821,219316,218182,218419,222293,226578,221359,217255,221816,226428,220922,218880,227763,218045,221344,221044,228458,227081,228993,220810,229105,228719,216595,221315,228867,222403,220355,221143,222194,228312,228632,227622,227938,226335,228288,226834,203131,226715,228095,228318,214523,221707,216817,204964,215838,222698,226637,216974,227153,221027,220077,219525,220485,217471,219281,227290,220370,227828,226512,229288,222984,221950,229232,215320,216830,219807,218478,214408,218103,228828,219900,218382,227618,221281,220279,213988,227488,222420,228398,217635,219642,219518,222014,227329,214235,222401,227028,217859,221124,229272,202511,219597,218336,220035,217908,218611,218284,222513,217630,221196,213590,217813,226663,228475,217632,200103,227941,222679,222600,226888,229216,221109,216601,215854,216955,216944,229423,219057,222150,228940,215675,226543,218791,218908,214224,216631,229443,220940,215159,222254,228732,200275,222884,221450,216066,229420,216322,222904,220227,226923,226379,217154,226968,229460,221003,218142,221228,211302,216312,215769,215780,219862,226580,222848,220102,219304,227918,222982,228180,222452,228332,227871,227678,217645,214132,217934,215396,216788,228989,216128,216257,226354,227324,226899,228466,227308,229287,215938,221957,228829,227705,219458,227980,226525,221955,226568,227431,219535,228724,222816,227614,218706,228114,228997,222696,229202,222454,199298,222159,216489,226613,222705,218757,221956,219723,215219,221221,226668,229159,229019,228990,221738,221416,221726,221226,219984,227544,222240,228853,227157,221766,215905,222617,200172,226508,220362,228888,218420,221795,227547,221806,213497,221964,220432,219843,222249,218203,221834,214264,228731,226733,222020,219781,220753,200087,224425,219200,221502,221564,218052,221428,226804,214448,217963,228542,220210,221746,220377,215820,227221,217710,214139,226832,200245,226400,217204,227127,220156,228099,227088,217238,219523,229491,203821,217543,219532,228334,217991,219596,228705,217550,228484,221623,228751,226185,227789,228875,220426,220748,213865,221462,222462,222623,222690,228636,229436,220994,222542,220973,220935,219044,229377,228209,214231,229066,215860,220214,226623,228088,227597,222446,227112,199420,229283,227524,228583,222941,228761,227575,226924,227937,217313,211026,216293,209870,221907,222749,222736,227551,220775,228762,216495,222094,228419,221070,220155,215771,218521,210516,217903,227507,227111,229065,221895,228300,221882,222220,221863,216146,226436,217663,222018,220477,215654,228792,225604,220083,229138,214815,227145,222238,217545,186183,226987,220939,216915,228987,218209,221854,221251,227943,219488,219188,215558,216099,220952,217647,227066,227636,216562,226380,220937,226742,216741,222689,222849,222638,222668,226697,221289,215516,217463,204977,217614,220136,221244,227147,216905,221090,227589,227960,218228,228232,227481,227912,214245,215470,222786,220492,228942,228856,219955,216342,205353,216250,217413,218735,218397,216412,221453,217694,218738,227065,205355,229496,217580,222752,229114,228689,216195,220891,220903,221677,221172,222437,221911,226716,215948,219715,226471,227970,218690,205586,221656,227655,228833,219048,220731,222028,217546,221757,204971,217905,219629,217473,227234,228788,216445,217429,218162,216985,227260,221201,226540,222967,204979,222396,217333,227354,215926,205346,227470,228446,221342,221908,229021,218742,228474,200268,220450,222827,215717,218804,227399,217569,229214,220892,215454,222506,228967,221219,228338,219205,219823,228996,221252,228163,218726,222109,215327,227703,214311,218083,221033,227160,221320,217404,217381,228527,228102,220883,227670,221855,227269,216375,218818,217551,220851,220722,205282,228872,229518,216542,221532,226689,217898,226826,204974,221160,218222,214615,229295,221874,222270,215908,229500,229175,198809,222915,214335,206428,226618,214222,214266,221162,211713,216984,222135,218780,226389,228290,217948,216768,211389,216662,220736,221225,217424,215589,228473,220044,216791,216388,221912,218219,222733,227732,228972,215217,221498,220087,216640,229255,227252,217969,222743,222042,229469,227345,218241,217486,217590,221229,214153,228124,222588,228512,222222,221116,227712,226333,222938,211999,222227,218649,199414,219548,228884,228862,229446,211013,226791,229020,217808,221411,227561,222266,216429,221529,227928,228302,219172,215814,219712,218259,227321,219601,227987,228630,228769,220296,216170,224424,221779,222079,215205,217262,219776,228831,209601,214423,229014,229245,219924,224441,222136,217022,215588,220943,229361,221867,226882,218227,216447,221563,212291,217390,214759,221220,216172,218325,228226,228975,216667,215940,228569,228764,219061,222774,217137,227933,227390,220281,203332,221075,227631,221097,214221,229307,215253,228494,228663,218383,228785,227452,220260,216129,226759,227663,210522,227359,216298,220954,218165,216073,219922,214651,215778,221443,222569,217163,211025,226796,199413,219599,222798,217711,218509,220203,226405,200426,227818,217692,228413,226840,218421,213743,228404,226816,218636,220081,216693,216928,229094,217500,228918,221512,228901,226518,229072,227719,211038,216018,222603,228151,215212,221157,218652,217016,222700,217888,210055,222087,226620,222568,215126,228851,210547,227179,221393,212762,228366,221674,219203,215413,215585,222665,227998,226798,222218,217132,228839,222374,217082,227334,211508,226607,220975,226459,220780,211019,218356,215226,221497,228181,215461,221758,228432,221737,217699,229149,227348,228601,221990,226743,215251,226771,222310,227107,214053,216548,220339,199297,216713,226454,216530,222557,227363,227046,221343,219125,219064,217695,216516,228354,217600,215197,221544,227441,226950,227189,229177,218785,216537,221833,227508,225625,222481,226842,215674,214704,214705,226991,226960,220755,222248,222509,217411,228986,229242,229281,226777,216704,227343,221317,227890,219730,226349,226698,225621,217625,219207,214753,217144,216427,229163,226422,215544,220055,227457,219851,228887,205352,226734,217881,216164,227121,229173,228849,221781,221301,217973,226953,217092,209241,217507,222223,220038,220264,222068,219328,214265,222091,219034,212000,227629,200266,215628,216258,228635,228182,228948,222933,221104,228659,221048,219680,229316,219871,229183,227262,228343,222851,226377,220905,222783,219869,217365,215301,211281,220969,216027,218729,226871,209872,212001,226927,229234,227178,222942,221231,229244,200089,226946,221597,227815,227778,227648,215510,227292,228991,228028,226442,211015,226576,228201,220090,221722,214240,221690,228713,215894,213500,218141,222563,222160,229091,216184,227312,227422,217427,216433,220823,219644,228469,222246,218516,222658,217706,226844,227394,227352,226805,209242,220319,227695,228217,221054,221913,213642,219469,228156,227702,222117,226748,222541,226541,227373,229150,213704,213072,227226,219487,222683,220739,217147,221684,228282,222435,215652,217018,222154,218809,222131,217534,228357,222325,211162,227094,217814,221059,218903,217651,218099,211906,229427,219820,199295,218181,221798,228463,214620,218095,229023,227208,229260,228227,222556,219859,226675,215806,216734,216688,198805,221302,220010,229387,220749,227310,229022,222498,214385,226787,220448,210854,221268,228876,221290,211978,210999,229090,221298,214052,220086,215457,216040,228717,228177,229224,227344,219448,227949,224433,229257,217150,220801,217437,213187,220031,210928,219454,221613,217409,222624,216197,217583,218163,213137,217306,222267,222996,227176,217703,228573,218622,217746,227123,228658,227253,221182,221877,217422,229508,219151,226704,229248,214906,210857,217827,218412,218366,222688,226845,215279,228854,218782,211023,212809,228032,227202,215913,222635,226920,213153,215916,203275,219389,218064,219417,227994,221997,217072,208894,211161,226973,229008,219380,219374,216687,222732,226974,218513,221082,215954,217709,222380,227953,200094,215433,222487,222070,226833,221066,216694,218280,227627,220299,227082,221980,229399,216919,228321,217633,217498,228442,225605,228316,221810,227934,222184,228477,227213,219872,221976,226652,217941,227735,220298,217904,221590,216914,217917,218743,217151,200171,219949,220862,215519,227486,228301,226452,221628,227038,227581,214378,214306,214236,227816,227278,227552,229367,215797,218751,227084,228634,199410,217662,227645,220857,226978,217458,229249,226773,220735,227586,219191,217051,215319,226614,228481,222377,217535,226546,227765,220948,226579,228727,218762,217704,216335,229251,228916,204095,222260,214403,222149,227350,215524,216512,227249,228061,203883,229451,221354,228488,227026,219695,214519,228886,220273,227054,220723,229012,227484,222320,219071,217536,220942,217513,216681,228847,228311,227039,218160,224439,222282,228498,228962,226591,228096,220138,228985,217753,219485,229078,221774,216491,220070,216426,221457,216532,220425,218702,217401,221434,198811,217388,228864,226402,227516,228937,219718,222207,226900,219990,229250,226868,221866,219390,221105,215299,218512,226648,200264,221386,229444,229170,218145,226559,227963,211289,217743,228449,217039,228279,217152,227419,218299,228560,227449,222810,217717,218005,229086,229494,220430,229425,198794,228132,220283,222409,220864,217091,218630,221619,228699,218202,217558,216517,215917,220383,229268,214556,221745,220845,222950,218669,228150,217185,228616,217231,227468,221975,217780,216121,217843,229324,220054,221727,221606,220951,221065,218514,220140,227136,204978,225620,221178,228039,229396,219835,228753,227495,227915,220076,227582,212963,226590,227432,219482,211979,227411,221831,216898,215329,220478,229468,214398,227848,220258,218811,216973,229246,221046,229492,219845,216381,222673,227300,217408,219674,220052,220490,227819,215841,228696,217166,228261,226906,216130,222206,221369,226566,219138,228159,222985,219991,228955,228992,218800,219123,222664,226838,227914,222808,221499,227906,211905,222026,222564,222669,229383,227974,218628,217767,221246,219885,222268,213993,219578,228175,216383,217998,228928,228768,220106,221042,228515,226879,221614,222725,227746,215554,216669,217823,220743,216399,215356,227779,227436,216462,214004,216044,200247,228363,228443,216346,221530}'::integer[])) OR (leasing_agent_id IS NULL)))
  • Rows Removed by Filter: 4514
5.          

SubPlan (forIndex Scan)

6. 0.075 0.075 ↑ 1.3 3 1

Seq Scan on list_items li (cost=0.00..9.63 rows=4 width=4) (actual time=0.030..0.075 rows=3 loops=1)

  • Filter: ((default_list_item_id = ANY ('{66,65}'::integer[])) AND (cid = 3395))
  • Rows Removed by Filter: 306
7. 0.023 0.023 ↑ 1.0 18 1

Seq Scan on application_stage_statuses ass (cost=0.00..1.73 rows=18 width=16) (actual time=0.012..0.023 rows=18 loops=1)

  • Filter: (lease_interval_type_id = 1)
  • Rows Removed by Filter: 40
Planning time : 26.353 ms