explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c0e9

Settings
# exclusive inclusive rows x rows loops node
1. 2.462 9,363.008 ↑ 255.5 3,341 1

Append (cost=725,962.87..1,090,927.19 rows=853,656 width=882) (actual time=8,074.094..9,363.008 rows=3,341 loops=1)

2. 2.426 9,034.508 ↑ 292.4 2,917 1

Subquery Scan on "*SELECT* 1" (cost=725,962.87..1,075,645.31 rows=852,884 width=882) (actual time=8,074.093..9,034.508 rows=2,917 loops=1)

3. 690.619 9,032.082 ↑ 292.4 2,917 1

GroupAggregate (cost=725,962.87..1,062,852.05 rows=852,884 width=874) (actual time=8,074.090..9,032.082 rows=2,917 loops=1)

  • Group Key: taet.cid, taet.property_name, taet.property_id, taet.lookup_code, ce.id, (COALESCE(func_format_customer_name(ce.name_first, ce.name_last, NULL::character varying), 'Not Assigned'::character varying))
4. 1,533.492 8,341.463 ↑ 1.4 620,214 1

Sort (cost=725,962.87..728,095.08 rows=852,884 width=705) (actual time=8,074.070..8,341.463 rows=620,214 loops=1)

  • Sort Key: taet.cid, taet.property_name, taet.property_id, taet.lookup_code, ce.id, (COALESCE(func_format_customer_name(ce.name_first, ce.name_last, NULL::character varying), 'Not Assigned'::character varying))
  • Sort Method: quicksort Memory: 115324kB
5. 2,036.298 6,807.971 ↑ 1.4 620,214 1

Nested Loop Left Join (cost=257.90..373,750.81 rows=852,884 width=705) (actual time=6.076..6,807.971 rows=620,214 loops=1)

6. 2,294.161 2,454.932 ↓ 2.1 330,963 1

Hash Left Join (cost=257.48..8,458.71 rows=156,842 width=651) (actual time=5.748..2,454.932 rows=330,963 loops=1)

  • Hash Cond: ((taet.cid = ce.cid) AND (taet.leasing_agent_id = ce.id))
  • Filter: ((ce.id IS NULL) OR (ce.id = ANY ('{0,314762,314924,314050,310742,311529,311527,311526,315607,312100,310978,310924,315427,312708,310997,315743,316091,313890,316179,316052,313933,315412,316182,316322,315526,314643,315266,313865,312853,312045,313663,313664,314003,314047,316241,315271,315499,315901,315873,315880,316058,315482,315738,312867,314763,314749,312108,316189,315011,315625,315767,313866,314964,310676,312005,310988,310979,310928,315775,316303,316014,313839,315225,315676,315311,315460,310649,314959,314656,315371,315237,315267,315215,311514,315996,314034,315452,312066,315547,316211,314970,316160,314060,314090,314792,316212,315913,310610,315465,314650,312073,314947,312125,312274,316300,315950,314822,316044,311500,311496,315468,315500,312927,311512,311007,312711,310673,315549,316252,316049,313918,315046,311073,310383,313393,313235,311458,313944,315687,315820,314368,315973,315248,314051,314052,313913,315651,315242,315679,315230,311040,311029,310984,311064,315289,315856,315521,315524,315680,315384,314755,314712,315910,316190,315050,315647,313945,313888,313881,312732,314565,313921,312690,315683,315204,314806,315940,315977,313946,314039,312044,315302,316177,313835,312857,315085,315759,313990,316166,315520,312075,314983,310987,315477,312879,315833,314744,316038,313878,310852,313840,312726,313901,314948,312840,313942,316111,315214,310637,310639,310602,310636,310623,310635,310603,310634,310638,310633,315490,314055,314732,316100,314837,313845,310651,310652,313911,315002,316251,312022,315275,315079,315517,312081,313665,313667,316099,314988,316181,315538,316010,312656,314056,313882,316198,315641,315503,315827,316222,315795,315203,315592,315900,311503,316233,313930,315318,313892,315773,310853,316240,314969,315416,315469,315735,316200,309364,314644,316208,316096,313875,314666,310627,310626,310625,310618,310599,310624,310628,312937,316293,312931,314699,314788,311999,315223,315071,315395,316120,315229,315646,313978,315824,315893,315581,316164,313943,312930,314813,315224,315670,315613,315218,312088,316047,310784,313902,315411,312103,315783,313833,315898,315287,314949,315742,315638,316042,315929,313017,316221,312517,314742,314725,312910,313638,314478,313696,313464,313241,314621,313147,314199,312150,310910,314377,314414,314333,314539,310508,313642,313612,313277,313048,314511,314381,312292,314508,310535,312992,312438,313374,312977,313096,312533,314424,313731,313555,313679,314240,313212,314487,313419,314519,313625,313390,314394,314399,314411,313676,312347,313465,312363,314095,313400,314447,313406,311592,314336,310448,312461,314188,313776,314242,314160,314202,311420,313191,313651,314230,314554,314534,313270,313494,314130,314567,314556,312444,312146,312963,313468,313558,310826,312390,311534,314605,311589,314528,312427,314479,312470,313693,313037,313259,314271,311598,313129,314476,311438,313752,312366,312367,314091,313635,313510,313429,313600,313426,313125,312505,313424,313531,314606,314316,313492,312456,312414,312490,310865,312485,311591,313726,314471,310462,314182,314588,312344,314500,313351,314049,313389,313104,313779,311531,314274,313738,314620,312312,314167,312335,314535,314521,313471,313131,314446,312951,314251,314613,314283,314168,313498,313186,313133,313732,313128,312328,313480,313228,313199,314267,313618,314618,311595,314429,313202,314631,313193,313165,312701,314139,313718,313681,313094,314383,313288,312266,313213,314132,311540,313708,314244,313617,314451,313095,313446,314264,313164,313540,314622,310542,313715,313145,314578,313714,312302,313662,312396,313484,312972,312424,312223,311599,313631,312300,310866,313018,312498,313790,311439,314154,313460,314423,313434,313686,313161,311537,313323,313496,313060,314038,313585,313527,313045,312398,314237,314109,314386,314027,313654,313215,314571,310459,311577,314171,314194,313647,313085,311600,310909,313119,313619,314144,314626,314142,313646,313559,313577,314592,313110,312422,314129,310513,312267,314101,313512,313087,314632,314596,313580,312445,313740,313298,313730,313490,314522,311612,312430,314428,313570,314367,312449,314602,313608,313174,313006,314518,313058,314531,312502,313073,314284,314480,314530,314376,314345,314308,312296,314501,311548,314059,314573,312204,313743,313572,312350,313721,314268,312377,313491,313003,313504,314577,311574,312284,314123,313430,314205,313438,313750,314485,311581,312421,312234,314213,311231,312282,313160,313713,314325,313356,312511,314600,313627,313744,312987,314494,313310,312214,313098,314178,313724,312966,314449,313275,312448,313344,314200,312369,313561,312509,313118,310512,313528,313757,314150,312308,313605,313107,313549,314490,314318,313283,312395,314143,314562,313597,312419,312356,313170,313255,314638,312392,313727,312404,313547,313380,314331,313691,313159,312340,313785,312304,312979,312406,313028,313532,314536,313000,314598,314363,314595,314431,313423,312215,313653,314408,312357,313416,312283,313514,313537,313621,314111,313178,314177,313245,314630,313162,312417,310455,314629,314419,314633,312381,314545,313615,314312,314151,312393,311556,314332,314286,314548,314037,313616,314338,314241,312389,314185,314303,314198,314204,314114,313166,313764,313124,313728,314229,313203,313519,313067,314486,312364,314502,314323,314439,314157,313437,314582,313479,312965,312362,312318,314597,314550,313709,312252,311551,313587,314311,312309,313101,312475,313010,312316,313695,311607,312331,312514,313116,313256,314448,313285,313601,312162,314161,314105,314292,313181,314560,314193,313624,313385,313707,312263,312166,311576,314272,313677,313063,313433,314210,314159,314220,310502,314310,313290,314145,313371,312492,313474,313278,313485,313078,314184,312289,313688,314517,314330,313762,312506,314370,313065,313448,313778,312385,313316,314609,313336,313425,312447,314413,314523,314481,314557,313081,312483,312962,314148,314097,314456,312512,313687,313216,311613,310550,313673,313553,313499,314276,314092,313279,314426,312453,312409,313138,312491,313462,313296,314473,312423,312960,312976,314290,312338,313251,314440,313567,311593,314155,314569,314615,314593,313355,312361,312967,314032,314300,314141,314045,313781,312371,313643,312969,312975,311601,313472,312372,313301,312387,313560,312305,314208,312400,314537,313784,313150,314610,312486,314113,310792,314190,312474,312973,312239,313508,312230,313773,313146,314028,312463,314289,312434,314106,314552,314438,313004,314389,313493,312291,313441,314441,313407,312288,314321,312341,313538,313105,313576,314314,312451,310908,314247,313141,312466,314499,314366,314137,313523,312326,313630,314355,313284,312353,314233,314201,313157,312313,314313,314238,314466,314465,314454,313581,312996,312156,313143,313478,313420,314619,313137,313783,313318,312971,311538,313306,312348,314124,311594,313660,313794,314138,314544,313729,312317,314410,314398,312978,314637,312298,313079,313211,313495,314195,312228,313632,312510,313656,312431,313533,313795,311608,313710,313694,313568,314475,314273,312411,314514,313267,314415,313670,314583,314236,313313,313036,313652,313345,314277,313399,314382,313780,314231,313789,314470,312958,312493,313038,313640,313114,312186,314218,314627,314361,314348,314125,313233,313030,310521,313172,312425,314189,312324,311544,313633,313477,313069,310559,312137,313607,312691,314445,314257,314328,313658,313766,314153,313777,312306,313130,314304,314207,312535,314568,313297,313020,314436,313153,314306,313428,314211,314180,312478,313449,312495,314099,313582,310912,314349,313246,314469,314118,311605,312354,313602,313453,312429,314179,313761,314543,311609,314358,313797,310466,314147,312952,312374,314354,314604,314625,314282,313421,312964,313436,313221,314516,313061,313311,313442,312507,314464,314269,313052,314634,313734,313702,314226,313705,313609,314555,312360,312322,314435,312293,313019,312993,313451,313071,314291,313227,313026,313452,314183,314477,313261,312460,314379,313415,313439,312441,313082,313725,314206,312464,313578,312334,314614,314347,312249,314551,312405,314254,313217,312497,312468,314166,314607,313312,314453,313340,313712,312968,314488,312953,313364,314128,313745,311586,313583,312408,312399,313410,314315,314110,314278,314197,313262,314339,312240,313733,314223,314246,313769,313219,312345,313024,314558,313689,312985,314255,314430,312388,314443,314232,313431,312503,313022,312433,313250,314061,313200,313047,312986,313257,313671,314541,313788,313466,312290,312471,314146,314294,313791,313768,312476,312982,314400,314497,314482,312442,312530,312458,313402,312959,313054,313445,314335,314512,312410,314581,313398,311530,314484,310913,313613,313266,314108,314437,314540,313180,313027,312382,311602,313088,314296,313254,312450,312997,314580,314103,312995,314507,314491,313080,313755,313754,313369,314131,312373,312303,313554,313629,314112,314559,313001,313234,313699,313009,312494,314549,313505,310533,313751,313758,313622,313565,314252,313509,314243,314575,313534,312386,312516,314572,312336,311525,313184,310867,313690,311555,313591,313112,312954,312310,313450,313331,314463,314396,313126,314088,313366,313222,312998,314350,313242,313604,312307,313050,312991,312473,312211,312346,313432,314126,313697,314288,313372,313068,314256,313680,312531,313596,313541,313413,312499,313566,311585,313332,314590,313377,313201,312989,312325,312950,313294,314603,313148,313739,313595,313154,313717,313302,312343,314215,312403,314107,314219,313584,313544,314591,311604,314035,314317,314285,310483,312379,313796,313520,313210,312457,310556,312487,313192,313418,312513,313231,312948,312462,310552,311610,312983,312311,314133,313132,311441,314505,312397,312469,313005,314460,313579,313529,314495,313368,313620,314196,314165,314616,314175,312467,311596,313333,314174,313239,314279,313722,313675,313467,314030,313767,313379,314421,313395,313035,313167,312529,313511,313457,313459,312418,312383,313611,313720,314259,313641,314149,313140,312196,312432,313672,313506,312301,310477,313032,312339,314506,313314,314472,314217,313536,314262,314033,314374,311442,313507,313787,313408,312315,314164,314416,312980,313168,313134,313243,314191,314340,311584,314307,314287,314360,313746,313260,311549,314458,313155,312955,312242,313447,312454,312412,314098,314365,313303,312446,312253,314357,312482,313444,312961,314640,313645,313543,313051,313571,313097,314589,314457,314412,313208,313386,314352,312452,314275,313742,313198,313225,313049,313455,311582,312437,313224,313142,314337,313603,311552,314393,314510,314158,313650,312443,314319,310548,313759,314048,314378,313337,314351,313070,313674,313545,312508,313149,314221,313090,313775,314525,310537,313786,314266,314248,314261,313403,314397,312489,313760,313456,314417,311590,314341,312329,314623,314635,311459,312440,313661,313636,312184,312534,314089,312323,314298,314587,313692,313307,310564,314293,313475,314031,314343,314234,313229,314225,314305,313197,312299,314579,314538,313046,313684,313473,313427,313550,313002,314611,311606,313637,313230,313716,312380,312984,313136,311597,314474,310700,314152,313012,314584,312988,312990,313183,313562,313013,314444,313091,313623,313412,313417,312297,314117,313639,314513,312287,313422,313698,313701,314612,312949,314228,312407,313798,312439,313463,313182,313205,312426,313700,313476,313454,314442,311550,313409,312368,313590,312281,313388,312359,313481,313719,313176,313404,314212,314542,314120,313185,313188,313127,313077,314104,313592,310715,312481,313539,314216,313171,313706,313563,313394,313657,312455,313384,314203,313179,313025,314498,314224,314176,314356,313497,313173,313599,313042,313011,313678,314094,313542,312480,310889,312320,314163,313226,314362,313634,314574,313093,314169,313487,312970,313557,314617,313206,313763,310569,314250,313066,313083,311545,311611,312376,313628,314119,312479,313703,313223,313109,314390,314553,314127,312477,313501,314100,314115,313513,313064,313614,313458,314334,313099,312285,311536,314570,314324,311578,312532,312355,314235,310534,313747,314170,314496,313748,313440,312202,314135,313741,314526,313102,314270,312459,313735,313292,314427,313232,314096,314295,314346,314093,313115,314239,313588,312370,313158,314297,313139,313411,312692,313575,312319,314245,313382,314527,312358,312333,312999,313551,313122,314263,311539,314173,314585,313008,314181,313756,313482,312957,314468,314265,313016,314281,312375,312420,312378,313108,311547,313774,310492,312394,314599,313092,312994,311579,313530,314586,314483,313196,313483,313594,313589,314515,313792,313753,313669,313443,314172,314601,313606,313502,313281,312337,313367,313338,314302,313015,313220,312504,313308,313357,313486,313014,313269,313683,314162,313163,313169,311440,313682,313414,314342,313396,313043,313113,314121,314102,314134,314260,314434,314566,313117,314547,313100,310539,314122,312981,314046,313723,312416,313770,314489,314520,313151,313204,312402,314187,312294,314327,312321,313023,313488,313535,313435,311587,313103,311580,314533,314493,312488,312974,313253,312465,312280,312436,313556,313648,313194,314209,313238,312500,312246,314156,314532,312435,312428,313526,314450,314249,311542,314322,314462,312472,313056,314253,313626,314353,312314,313244,313033,314459,313711,314524,312286,314503,313209,311603,312484,312351,310451,313315,312384,313401,311554,313363,313736,313144,314140,313749,312413,313072,313569,313044,314509,314116,312349,313076,313503,314214,313704,314624,312496,314492,313007,313040,313500,313765,313598,314504,312501,313320,314608,314192,314136,314036,313135,312391,313685,310911,313771,314222,310902,314594,312327,314186,314546,314227,313089,313190,311583,314299,313649,312956,313335,312415,312365,314320,313793,314529,314639,314344,313782,314258,313059,314029,312716,312715,315012,312816,315479,313889,315606,314717,315830,315260,313838,312062,312110,313907,313836,315253,315813,312843,314072,314064,316267,312841,313854,314989,310568,314814,312866,312099,312713,315474,312881,316214,315957,316060,314893,312764,315295,315622,315472,316098,315263,314668,315067,312086,315951,314824,312710,313814,314728,314834,312859,312124,312273,315550,315988,314679,316232,315627,312938,314977,310991,313924,312895,313826,314772,315789,315604,316050,314040,314686,313876,316219,310965,310967,310972,310969,310970,310977,310971,310973,310968,310914,310927,310964,310975,310974,310921,310960,310963,310957,310958,310961,310959,310966,310962,314698,311566,311569,311567,311568,311560,314724,315596,315493,311487,313906,314917,314804,313207,310608,314986,313851,314773,315470,314911,316068,311260,312043,315866,311519,314756,314972,315991,313909,316041,314680,316119,315430,310654,313841,315369,315525,314655,316028,312089,314907,312101,314058,312904,313517,315846,312932,315475,314971,312865,313884,313053,313041,315467,316280,315010,315454,310936,310937,316061,310907,316097,314910,315425,315749,312911,312854,315583,315008,315612,315481,316257,315239,313870,314044,314041,312278,312277,313853,312851,312926,315896,315202,312700,316256,312878,313156,315884,315385,315042,312063,312111,315504,315527,315769,315213,316124,315280,311976,312123,314685,315620,313929,310860,310982,310981,310980,315616,315685,315424,315750,313827,314707,315227,311515,315920,312815,315871,315192,315774,313916,313900,316016,311211,312864,315986,315236,316025,314978,315007,312087,315895,316011,311257,312873,315840,313931,314979,316248,312061,310818,310815,313812,315228,313891,314406,314405,314375,314391,314461,314392,314425,314373,314455,314371,314380,314422,314359,314364,314404,314467,314395,314402,314403,314418,314388,314385,314433,314384,314420,314401,314452,314407,314387,314372,315540,315522,312871,315246,316242,313844,316188,314369,316125,316319,312012,312929,310992,310985,315927,315914,315918,316278,314839,316165,314767,315243,315296,315014,315528,310831,312275,312276,315245,314984,313668,312528,316066,314842,315212,310642,310640,310643,310641,316163,312845,316074,314057,315912,312098,315739,316199,314894,315838,311990,312042,315764,310942,310952,310938,310949,310935,310954,310956,310953,310926,310918,310922,310919,310950,310955,310934,310943,310917,310944,310941,310940,310946,310923,310947,310916,310939,310951,310945,310920,310915,310948,310976,312872,312829,312919,311992,315047,316158,314689,314653,314739,314963,315488,316035,316325,312109,312060,315548,315194,315078,312868,312903,315293,315389,315652,312877,313802,312090,312642,312536,315779,315147,315546,316259,315877,315939,315065,315450,315892,311000,310998,310999,312839,313846,315505,314652,315968,315875,311504,311230,315560,315291,314811,315272,315489,314803,311513,312077,315205,316030,315226,315591,315196,313869,313962,311985,315284,311269,316298,312917,315771,315523,313055,312924,316247,314676,311977,315061,316145,313941,315507,315848,312102,310854,315608,316260,316204,316003,314815,311546,312056,316094,315495,315428,312894,310663,310617,310614,310662,312874,316207,316195,314664,313874,314812,315299,314928,314054,314053,313852,315637,313887,315506,315885,314966,315199,312709,316243,315290,316149,312078,313187,313214,315661,315557,312858,313218,313086,315544,310646,314740,315261,312749,310660,310846,314895,312121,312072,315463,315682,311061,314718,312519,312521,310655,310995,315648,311483,315946,314810,313935,313860,314891,310376,310619,315265,315811,315916,311517,311005,310620,315551,311021,312928,310993,313919,315792,315741,315878,312004,315867,311535,312946,312643,314801,311558,312037,316034,310385,310986,315808,310706,312003,315942,310668,315512,311018,315643,316114,313886,315585,310840,316121,315611,310875,312705,315252,315590,311983,310497,313934,314999,310686,315586,315294,315244,313896,313880,315464,310611,312947,312279,311897,312074,314994,315462,315650,314836,310444,315677,311989,313834,311478,312079,314014,315258,310930,310377,315945,315628,314835,311485,315298,312849,315978,311119,315626,311508,310606,315009,315432,314677,314779,314783,310604,312909,313965,316215,315241,313914,311510,312896,312847,310605,315301,310386,315793,313925,310925,312846,312908,312939,311516,311217,312897,314838,311095,310677,311557,315619,311511,314920,310570,310379,316282,310983,312918,310729,312076,313917,312518,313898,315264,315539,311004,313811,312848,315642,312916,310931,314797,315286,313828,314697,310989,314998,314678,310384,312902,310615,315274,311532,312080,311996,313897,311991,313926,315250,315251,310600,315632,310658,315297,310739,312778,310994,314898}'::integer[])))
7. 155.042 155.042 ↑ 1.0 330,963 1

Seq Scan on traffic_and_events_data_temp taet (cost=0.00..6,304.63 rows=330,963 width=640) (actual time=0.010..155.042 rows=330,963 loops=1)

8. 2.787 5.729 ↑ 1.0 5,459 1

Hash (cost=175.59..175.59 rows=5,459 width=19) (actual time=5.729..5.729 rows=5,459 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 352kB
9. 2.942 2.942 ↑ 1.0 5,459 1

Seq Scan on company_employees ce (cost=0.00..175.59 rows=5,459 width=19) (actual time=0.005..2.942 rows=5,459 loops=1)

10. 2,316.741 2,316.741 ↑ 5.0 1 330,963

Index Scan using idx_temp_activities_lease_interval_id on activities_temp a (cost=0.42..0.92 rows=5 width=57) (actual time=0.005..0.007 rows=1 loops=330,963)

  • Index Cond: (lease_interval_id = taet.lease_interval_id)
  • Filter: ((event_datetime <= taet.lease_approved_on) OR (taet.lease_approved_on IS NULL))
  • Rows Removed by Filter: 1
11. 0.364 326.038 ↑ 1.8 424 1

Subquery Scan on "*SELECT* 2" (cost=15,028.09..15,281.89 rows=772 width=882) (actual time=308.218..326.038 rows=424 loops=1)

12. 11.394 325.674 ↑ 1.8 424 1

GroupAggregate (cost=15,028.09..15,252.94 rows=772 width=838) (actual time=308.215..325.674 rows=424 loops=1)

  • Group Key: l.cid, l.property_name, l.property_id, l.lookup_code, ce_1.id, (COALESCE(func_format_customer_name(ce_1.name_first, ce_1.name_last, NULL::character varying), 'Not Assigned'::character varying))
13. 31.332 314.280 ↓ 20.6 15,880 1

Sort (cost=15,028.09..15,030.02 rows=772 width=672) (actual time=308.187..314.280 rows=15,880 loops=1)

  • Sort Key: l.cid, l.property_name, l.property_id, l.lookup_code, ce_1.id, (COALESCE(func_format_customer_name(ce_1.name_first, ce_1.name_last, NULL::character varying), 'Not Assigned'::character varying))
  • Sort Method: quicksort Memory: 2611kB
14. 52.938 282.948 ↓ 20.6 15,880 1

Hash Left Join (cost=268.05..14,991.06 rows=772 width=672) (actual time=6.027..282.948 rows=15,880 loops=1)

  • Hash Cond: ((l.cid = ls.cid) AND (COALESCE(l.converting_lead_source_id, l.originating_lead_source_id) = ls.id))
  • Filter: ((ls.id = ANY ('{0,64451,64267,64481,64183,64233,64181,64848,64256,64896,64257,64235,64911,64236,64269,64271,64895,64898,64893,64899,64886,64887,64888,64889,64890,64892,64897,64900,64901,64902,64904,64905,64240,64242,64485,64182,64179,64281,64282,64283,64284,64908,64498,64440,64499,64291,64410,64232,64474,64248,64249,64452,64185,64403,64439,64250,64841,64253,64501,64401,64251,64252,64255,64486,64487,64462,64488,64254,64500,64472,64234,64480,64453,64464,64177,64441,64258,64259,64842,64463,64260,64843,64445,64465,64261,64475,64180,64262,64404,64477,64885,64264,64263,64910,64405,64409,64444,64265,64406,64466,64460,64237,64266,64268,64883,64270,64454,64489,64490,64186,64491,64272,64184,64178,64246,64238,64247,64470,64907,64273,64274,64450,64473,64846,64479,64176,64906,64903,64241,64275,64276,64277,64845,64239,64243,64492,64459,64449,64245,64467,64407,64468,64447,64443,64278,64279,64280,64476,64884,64478,64493,64482,64448,64471,64909,64882,64494,64495,64285,64455,64286,64287,64849,64288,64483,64408,64446,64442,64175,64496,64289,64844,64469,64497,64458,64290,64244,64461,64457,64847}'::integer[])) OR (ls.id IS NULL))
15. 114.260 229.823 ↓ 20.3 15,880 1

Hash Left Join (cost=257.48..14,782.42 rows=784 width=659) (actual time=5.808..229.823 rows=15,880 loops=1)

  • Hash Cond: ((l.cid = ce_1.cid) AND (l.leasing_agent_id = ce_1.id))
  • Filter: ((ce_1.id IS NULL) OR (ce_1.id = ANY ('{0,314762,314924,314050,310742,311529,311527,311526,315607,312100,310978,310924,315427,312708,310997,315743,316091,313890,316179,316052,313933,315412,316182,316322,315526,314643,315266,313865,312853,312045,313663,313664,314003,314047,316241,315271,315499,315901,315873,315880,316058,315482,315738,312867,314763,314749,312108,316189,315011,315625,315767,313866,314964,310676,312005,310988,310979,310928,315775,316303,316014,313839,315225,315676,315311,315460,310649,314959,314656,315371,315237,315267,315215,311514,315996,314034,315452,312066,315547,316211,314970,316160,314060,314090,314792,316212,315913,310610,315465,314650,312073,314947,312125,312274,316300,315950,314822,316044,311500,311496,315468,315500,312927,311512,311007,312711,310673,315549,316252,316049,313918,315046,311073,310383,313393,313235,311458,313944,315687,315820,314368,315973,315248,314051,314052,313913,315651,315242,315679,315230,311040,311029,310984,311064,315289,315856,315521,315524,315680,315384,314755,314712,315910,316190,315050,315647,313945,313888,313881,312732,314565,313921,312690,315683,315204,314806,315940,315977,313946,314039,312044,315302,316177,313835,312857,315085,315759,313990,316166,315520,312075,314983,310987,315477,312879,315833,314744,316038,313878,310852,313840,312726,313901,314948,312840,313942,316111,315214,310637,310639,310602,310636,310623,310635,310603,310634,310638,310633,315490,314055,314732,316100,314837,313845,310651,310652,313911,315002,316251,312022,315275,315079,315517,312081,313665,313667,316099,314988,316181,315538,316010,312656,314056,313882,316198,315641,315503,315827,316222,315795,315203,315592,315900,311503,316233,313930,315318,313892,315773,310853,316240,314969,315416,315469,315735,316200,309364,314644,316208,316096,313875,314666,310627,310626,310625,310618,310599,310624,310628,312937,316293,312931,314699,314788,311999,315223,315071,315395,316120,315229,315646,313978,315824,315893,315581,316164,313943,312930,314813,315224,315670,315613,315218,312088,316047,310784,313902,315411,312103,315783,313833,315898,315287,314949,315742,315638,316042,315929,313017,316221,312517,314742,314725,312910,313638,314478,313696,313464,313241,314621,313147,314199,312150,310910,314377,314414,314333,314539,310508,313642,313612,313277,313048,314511,314381,312292,314508,310535,312992,312438,313374,312977,313096,312533,314424,313731,313555,313679,314240,313212,314487,313419,314519,313625,313390,314394,314399,314411,313676,312347,313465,312363,314095,313400,314447,313406,311592,314336,310448,312461,314188,313776,314242,314160,314202,311420,313191,313651,314230,314554,314534,313270,313494,314130,314567,314556,312444,312146,312963,313468,313558,310826,312390,311534,314605,311589,314528,312427,314479,312470,313693,313037,313259,314271,311598,313129,314476,311438,313752,312366,312367,314091,313635,313510,313429,313600,313426,313125,312505,313424,313531,314606,314316,313492,312456,312414,312490,310865,312485,311591,313726,314471,310462,314182,314588,312344,314500,313351,314049,313389,313104,313779,311531,314274,313738,314620,312312,314167,312335,314535,314521,313471,313131,314446,312951,314251,314613,314283,314168,313498,313186,313133,313732,313128,312328,313480,313228,313199,314267,313618,314618,311595,314429,313202,314631,313193,313165,312701,314139,313718,313681,313094,314383,313288,312266,313213,314132,311540,313708,314244,313617,314451,313095,313446,314264,313164,313540,314622,310542,313715,313145,314578,313714,312302,313662,312396,313484,312972,312424,312223,311599,313631,312300,310866,313018,312498,313790,311439,314154,313460,314423,313434,313686,313161,311537,313323,313496,313060,314038,313585,313527,313045,312398,314237,314109,314386,314027,313654,313215,314571,310459,311577,314171,314194,313647,313085,311600,310909,313119,313619,314144,314626,314142,313646,313559,313577,314592,313110,312422,314129,310513,312267,314101,313512,313087,314632,314596,313580,312445,313740,313298,313730,313490,314522,311612,312430,314428,313570,314367,312449,314602,313608,313174,313006,314518,313058,314531,312502,313073,314284,314480,314530,314376,314345,314308,312296,314501,311548,314059,314573,312204,313743,313572,312350,313721,314268,312377,313491,313003,313504,314577,311574,312284,314123,313430,314205,313438,313750,314485,311581,312421,312234,314213,311231,312282,313160,313713,314325,313356,312511,314600,313627,313744,312987,314494,313310,312214,313098,314178,313724,312966,314449,313275,312448,313344,314200,312369,313561,312509,313118,310512,313528,313757,314150,312308,313605,313107,313549,314490,314318,313283,312395,314143,314562,313597,312419,312356,313170,313255,314638,312392,313727,312404,313547,313380,314331,313691,313159,312340,313785,312304,312979,312406,313028,313532,314536,313000,314598,314363,314595,314431,313423,312215,313653,314408,312357,313416,312283,313514,313537,313621,314111,313178,314177,313245,314630,313162,312417,310455,314629,314419,314633,312381,314545,313615,314312,314151,312393,311556,314332,314286,314548,314037,313616,314338,314241,312389,314185,314303,314198,314204,314114,313166,313764,313124,313728,314229,313203,313519,313067,314486,312364,314502,314323,314439,314157,313437,314582,313479,312965,312362,312318,314597,314550,313709,312252,311551,313587,314311,312309,313101,312475,313010,312316,313695,311607,312331,312514,313116,313256,314448,313285,313601,312162,314161,314105,314292,313181,314560,314193,313624,313385,313707,312263,312166,311576,314272,313677,313063,313433,314210,314159,314220,310502,314310,313290,314145,313371,312492,313474,313278,313485,313078,314184,312289,313688,314517,314330,313762,312506,314370,313065,313448,313778,312385,313316,314609,313336,313425,312447,314413,314523,314481,314557,313081,312483,312962,314148,314097,314456,312512,313687,313216,311613,310550,313673,313553,313499,314276,314092,313279,314426,312453,312409,313138,312491,313462,313296,314473,312423,312960,312976,314290,312338,313251,314440,313567,311593,314155,314569,314615,314593,313355,312361,312967,314032,314300,314141,314045,313781,312371,313643,312969,312975,311601,313472,312372,313301,312387,313560,312305,314208,312400,314537,313784,313150,314610,312486,314113,310792,314190,312474,312973,312239,313508,312230,313773,313146,314028,312463,314289,312434,314106,314552,314438,313004,314389,313493,312291,313441,314441,313407,312288,314321,312341,313538,313105,313576,314314,312451,310908,314247,313141,312466,314499,314366,314137,313523,312326,313630,314355,313284,312353,314233,314201,313157,312313,314313,314238,314466,314465,314454,313581,312996,312156,313143,313478,313420,314619,313137,313783,313318,312971,311538,313306,312348,314124,311594,313660,313794,314138,314544,313729,312317,314410,314398,312978,314637,312298,313079,313211,313495,314195,312228,313632,312510,313656,312431,313533,313795,311608,313710,313694,313568,314475,314273,312411,314514,313267,314415,313670,314583,314236,313313,313036,313652,313345,314277,313399,314382,313780,314231,313789,314470,312958,312493,313038,313640,313114,312186,314218,314627,314361,314348,314125,313233,313030,310521,313172,312425,314189,312324,311544,313633,313477,313069,310559,312137,313607,312691,314445,314257,314328,313658,313766,314153,313777,312306,313130,314304,314207,312535,314568,313297,313020,314436,313153,314306,313428,314211,314180,312478,313449,312495,314099,313582,310912,314349,313246,314469,314118,311605,312354,313602,313453,312429,314179,313761,314543,311609,314358,313797,310466,314147,312952,312374,314354,314604,314625,314282,313421,312964,313436,313221,314516,313061,313311,313442,312507,314464,314269,313052,314634,313734,313702,314226,313705,313609,314555,312360,312322,314435,312293,313019,312993,313451,313071,314291,313227,313026,313452,314183,314477,313261,312460,314379,313415,313439,312441,313082,313725,314206,312464,313578,312334,314614,314347,312249,314551,312405,314254,313217,312497,312468,314166,314607,313312,314453,313340,313712,312968,314488,312953,313364,314128,313745,311586,313583,312408,312399,313410,314315,314110,314278,314197,313262,314339,312240,313733,314223,314246,313769,313219,312345,313024,314558,313689,312985,314255,314430,312388,314443,314232,313431,312503,313022,312433,313250,314061,313200,313047,312986,313257,313671,314541,313788,313466,312290,312471,314146,314294,313791,313768,312476,312982,314400,314497,314482,312442,312530,312458,313402,312959,313054,313445,314335,314512,312410,314581,313398,311530,314484,310913,313613,313266,314108,314437,314540,313180,313027,312382,311602,313088,314296,313254,312450,312997,314580,314103,312995,314507,314491,313080,313755,313754,313369,314131,312373,312303,313554,313629,314112,314559,313001,313234,313699,313009,312494,314549,313505,310533,313751,313758,313622,313565,314252,313509,314243,314575,313534,312386,312516,314572,312336,311525,313184,310867,313690,311555,313591,313112,312954,312310,313450,313331,314463,314396,313126,314088,313366,313222,312998,314350,313242,313604,312307,313050,312991,312473,312211,312346,313432,314126,313697,314288,313372,313068,314256,313680,312531,313596,313541,313413,312499,313566,311585,313332,314590,313377,313201,312989,312325,312950,313294,314603,313148,313739,313595,313154,313717,313302,312343,314215,312403,314107,314219,313584,313544,314591,311604,314035,314317,314285,310483,312379,313796,313520,313210,312457,310556,312487,313192,313418,312513,313231,312948,312462,310552,311610,312983,312311,314133,313132,311441,314505,312397,312469,313005,314460,313579,313529,314495,313368,313620,314196,314165,314616,314175,312467,311596,313333,314174,313239,314279,313722,313675,313467,314030,313767,313379,314421,313395,313035,313167,312529,313511,313457,313459,312418,312383,313611,313720,314259,313641,314149,313140,312196,312432,313672,313506,312301,310477,313032,312339,314506,313314,314472,314217,313536,314262,314033,314374,311442,313507,313787,313408,312315,314164,314416,312980,313168,313134,313243,314191,314340,311584,314307,314287,314360,313746,313260,311549,314458,313155,312955,312242,313447,312454,312412,314098,314365,313303,312446,312253,314357,312482,313444,312961,314640,313645,313543,313051,313571,313097,314589,314457,314412,313208,313386,314352,312452,314275,313742,313198,313225,313049,313455,311582,312437,313224,313142,314337,313603,311552,314393,314510,314158,313650,312443,314319,310548,313759,314048,314378,313337,314351,313070,313674,313545,312508,313149,314221,313090,313775,314525,310537,313786,314266,314248,314261,313403,314397,312489,313760,313456,314417,311590,314341,312329,314623,314635,311459,312440,313661,313636,312184,312534,314089,312323,314298,314587,313692,313307,310564,314293,313475,314031,314343,314234,313229,314225,314305,313197,312299,314579,314538,313046,313684,313473,313427,313550,313002,314611,311606,313637,313230,313716,312380,312984,313136,311597,314474,310700,314152,313012,314584,312988,312990,313183,313562,313013,314444,313091,313623,313412,313417,312297,314117,313639,314513,312287,313422,313698,313701,314612,312949,314228,312407,313798,312439,313463,313182,313205,312426,313700,313476,313454,314442,311550,313409,312368,313590,312281,313388,312359,313481,313719,313176,313404,314212,314542,314120,313185,313188,313127,313077,314104,313592,310715,312481,313539,314216,313171,313706,313563,313394,313657,312455,313384,314203,313179,313025,314498,314224,314176,314356,313497,313173,313599,313042,313011,313678,314094,313542,312480,310889,312320,314163,313226,314362,313634,314574,313093,314169,313487,312970,313557,314617,313206,313763,310569,314250,313066,313083,311545,311611,312376,313628,314119,312479,313703,313223,313109,314390,314553,314127,312477,313501,314100,314115,313513,313064,313614,313458,314334,313099,312285,311536,314570,314324,311578,312532,312355,314235,310534,313747,314170,314496,313748,313440,312202,314135,313741,314526,313102,314270,312459,313735,313292,314427,313232,314096,314295,314346,314093,313115,314239,313588,312370,313158,314297,313139,313411,312692,313575,312319,314245,313382,314527,312358,312333,312999,313551,313122,314263,311539,314173,314585,313008,314181,313756,313482,312957,314468,314265,313016,314281,312375,312420,312378,313108,311547,313774,310492,312394,314599,313092,312994,311579,313530,314586,314483,313196,313483,313594,313589,314515,313792,313753,313669,313443,314172,314601,313606,313502,313281,312337,313367,313338,314302,313015,313220,312504,313308,313357,313486,313014,313269,313683,314162,313163,313169,311440,313682,313414,314342,313396,313043,313113,314121,314102,314134,314260,314434,314566,313117,314547,313100,310539,314122,312981,314046,313723,312416,313770,314489,314520,313151,313204,312402,314187,312294,314327,312321,313023,313488,313535,313435,311587,313103,311580,314533,314493,312488,312974,313253,312465,312280,312436,313556,313648,313194,314209,313238,312500,312246,314156,314532,312435,312428,313526,314450,314249,311542,314322,314462,312472,313056,314253,313626,314353,312314,313244,313033,314459,313711,314524,312286,314503,313209,311603,312484,312351,310451,313315,312384,313401,311554,313363,313736,313144,314140,313749,312413,313072,313569,313044,314509,314116,312349,313076,313503,314214,313704,314624,312496,314492,313007,313040,313500,313765,313598,314504,312501,313320,314608,314192,314136,314036,313135,312391,313685,310911,313771,314222,310902,314594,312327,314186,314546,314227,313089,313190,311583,314299,313649,312956,313335,312415,312365,314320,313793,314529,314639,314344,313782,314258,313059,314029,312716,312715,315012,312816,315479,313889,315606,314717,315830,315260,313838,312062,312110,313907,313836,315253,315813,312843,314072,314064,316267,312841,313854,314989,310568,314814,312866,312099,312713,315474,312881,316214,315957,316060,314893,312764,315295,315622,315472,316098,315263,314668,315067,312086,315951,314824,312710,313814,314728,314834,312859,312124,312273,315550,315988,314679,316232,315627,312938,314977,310991,313924,312895,313826,314772,315789,315604,316050,314040,314686,313876,316219,310965,310967,310972,310969,310970,310977,310971,310973,310968,310914,310927,310964,310975,310974,310921,310960,310963,310957,310958,310961,310959,310966,310962,314698,311566,311569,311567,311568,311560,314724,315596,315493,311487,313906,314917,314804,313207,310608,314986,313851,314773,315470,314911,316068,311260,312043,315866,311519,314756,314972,315991,313909,316041,314680,316119,315430,310654,313841,315369,315525,314655,316028,312089,314907,312101,314058,312904,313517,315846,312932,315475,314971,312865,313884,313053,313041,315467,316280,315010,315454,310936,310937,316061,310907,316097,314910,315425,315749,312911,312854,315583,315008,315612,315481,316257,315239,313870,314044,314041,312278,312277,313853,312851,312926,315896,315202,312700,316256,312878,313156,315884,315385,315042,312063,312111,315504,315527,315769,315213,316124,315280,311976,312123,314685,315620,313929,310860,310982,310981,310980,315616,315685,315424,315750,313827,314707,315227,311515,315920,312815,315871,315192,315774,313916,313900,316016,311211,312864,315986,315236,316025,314978,315007,312087,315895,316011,311257,312873,315840,313931,314979,316248,312061,310818,310815,313812,315228,313891,314406,314405,314375,314391,314461,314392,314425,314373,314455,314371,314380,314422,314359,314364,314404,314467,314395,314402,314403,314418,314388,314385,314433,314384,314420,314401,314452,314407,314387,314372,315540,315522,312871,315246,316242,313844,316188,314369,316125,316319,312012,312929,310992,310985,315927,315914,315918,316278,314839,316165,314767,315243,315296,315014,315528,310831,312275,312276,315245,314984,313668,312528,316066,314842,315212,310642,310640,310643,310641,316163,312845,316074,314057,315912,312098,315739,316199,314894,315838,311990,312042,315764,310942,310952,310938,310949,310935,310954,310956,310953,310926,310918,310922,310919,310950,310955,310934,310943,310917,310944,310941,310940,310946,310923,310947,310916,310939,310951,310945,310920,310915,310948,310976,312872,312829,312919,311992,315047,316158,314689,314653,314739,314963,315488,316035,316325,312109,312060,315548,315194,315078,312868,312903,315293,315389,315652,312877,313802,312090,312642,312536,315779,315147,315546,316259,315877,315939,315065,315450,315892,311000,310998,310999,312839,313846,315505,314652,315968,315875,311504,311230,315560,315291,314811,315272,315489,314803,311513,312077,315205,316030,315226,315591,315196,313869,313962,311985,315284,311269,316298,312917,315771,315523,313055,312924,316247,314676,311977,315061,316145,313941,315507,315848,312102,310854,315608,316260,316204,316003,314815,311546,312056,316094,315495,315428,312894,310663,310617,310614,310662,312874,316207,316195,314664,313874,314812,315299,314928,314054,314053,313852,315637,313887,315506,315885,314966,315199,312709,316243,315290,316149,312078,313187,313214,315661,315557,312858,313218,313086,315544,310646,314740,315261,312749,310660,310846,314895,312121,312072,315463,315682,311061,314718,312519,312521,310655,310995,315648,311483,315946,314810,313935,313860,314891,310376,310619,315265,315811,315916,311517,311005,310620,315551,311021,312928,310993,313919,315792,315741,315878,312004,315867,311535,312946,312643,314801,311558,312037,316034,310385,310986,315808,310706,312003,315942,310668,315512,311018,315643,316114,313886,315585,310840,316121,315611,310875,312705,315252,315590,311983,310497,313934,314999,310686,315586,315294,315244,313896,313880,315464,310611,312947,312279,311897,312074,314994,315462,315650,314836,310444,315677,311989,313834,311478,312079,314014,315258,310930,310377,315945,315628,314835,311485,315298,312849,315978,311119,315626,311508,310606,315009,315432,314677,314779,314783,310604,312909,313965,316215,315241,313914,311510,312896,312847,310605,315301,310386,315793,313925,310925,312846,312908,312939,311516,311217,312897,314838,311095,310677,311557,315619,311511,314920,310570,310379,316282,310983,312918,310729,312076,313917,312518,313898,315264,315539,311004,313811,312848,315642,312916,310931,314797,315286,313828,314697,310989,314998,314678,310384,312902,310615,315274,311532,312080,311996,313897,311991,313926,315250,315251,310600,315632,310658,315297,310739,312778,310994,314898}'::integer[])))
16. 109.880 109.880 ↓ 9.6 15,880 1

Seq Scan on leads_temp l (cost=0.00..14,516.26 rows=1,655 width=648) (actual time=0.099..109.880 rows=15,880 loops=1)

  • Filter: (((application_datetime)::date >= '2020-01-01'::date) AND ((application_datetime)::date < '2020-02-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 315083
17. 2.811 5.683 ↑ 1.0 5,459 1

Hash (cost=175.59..175.59 rows=5,459 width=19) (actual time=5.683..5.683 rows=5,459 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 352kB
18. 2.872 2.872 ↑ 1.0 5,459 1

Seq Scan on company_employees ce_1 (cost=0.00..175.59 rows=5,459 width=19) (actual time=0.007..2.872 rows=5,459 loops=1)

19. 0.090 0.187 ↑ 1.0 183 1

Hash (cost=7.83..7.83 rows=183 width=8) (actual time=0.187..0.187 rows=183 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
20. 0.097 0.097 ↑ 1.0 183 1

Seq Scan on lead_sources ls (cost=0.00..7.83 rows=183 width=8) (actual time=0.007..0.097 rows=183 loops=1)