explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1CDL

Settings
# exclusive inclusive rows x rows loops node
1. 0.760 3,148.349 ↓ 1.0 348 1

Sort (cost=2,387,633.28..2,387,634.15 rows=346 width=488) (actual time=3,148.332..3,148.349 rows=348 loops=1)

  • Sort Key: (CASE WHEN ((l.leasing_agent)::text = 'Not Assigned'::text) THEN 2 ELSE 1 END), l.leasing_agent
  • Sort Method: quicksort Memory: 77kB
2. 1.727 3,147.589 ↓ 1.0 348 1

GroupAggregate (cost=2,387,440.32..2,387,618.69 rows=346 width=488) (actual time=3,145.851..3,147.589 rows=348 loops=1)

  • Group Key: l.leasing_agent, l.leasing_agent_id
3. 0.466 3,145.862 ↑ 7.4 467 1

Sort (cost=2,387,440.32..2,387,448.98 rows=3,464 width=424) (actual time=3,145.832..3,145.862 rows=467 loops=1)

  • Sort Key: l.leasing_agent, l.leasing_agent_id
  • Sort Method: quicksort Memory: 90kB
4. 0.070 3,145.396 ↑ 7.4 467 1

Subquery Scan on l (cost=2,384,413.23..2,387,236.67 rows=3,464 width=424) (actual time=3,143.337..3,145.396 rows=467 loops=1)

5. 1.934 3,145.326 ↑ 7.4 467 1

GroupAggregate (cost=2,384,413.23..2,387,132.75 rows=3,464 width=578) (actual time=3,143.336..3,145.326 rows=467 loops=1)

  • Group Key: sub.cid, sub.property_id, sub.property_name, sub.leasing_agent, sub.leasing_agent_id
  • Filter: ((sum(sub.new_leads) <> '0'::numeric) OR (sum(sub.first_visit_tour) <> '0'::numeric) OR (sum(sub.applications_completed) <> '0'::numeric) OR (sum(sub.applications_approved) <> '0'::numeric) OR (sum(sub.lease_completed) <> '0'::numeric) OR (sum(sub.lease_approved) <> '0'::numeric) OR (sum(sub.applications_completed_cancelled) <> '0'::numeric) OR (sum(sub.applications_denied_cancelled) <> '0'::numeric) OR (sum(sub.applications_approved_cancelled) <> '0'::numeric) OR (sum(sub.lease_completed_cancelled) <> '0'::numeric))
  • Rows Removed by Filter: 469
6. 1.729 3,143.392 ↑ 25.1 1,378 1

Sort (cost=2,384,413.23..2,384,499.84 rows=34,644 width=258) (actual time=3,143.313..3,143.392 rows=1,378 loops=1)

  • Sort Key: sub.cid, sub.property_id, sub.property_name, sub.leasing_agent, sub.leasing_agent_id
  • Sort Method: quicksort Memory: 415kB
7. 0.307 3,141.663 ↑ 25.1 1,378 1

Subquery Scan on sub (cost=1,217,626.83..2,381,801.02 rows=34,644 width=258) (actual time=2,033.063..3,141.663 rows=1,378 loops=1)

8. 0.168 3,141.356 ↑ 25.1 1,378 1

Append (cost=1,217,626.83..2,380,761.70 rows=34,644 width=258) (actual time=2,033.062..3,141.356 rows=1,378 loops=1)

9. 0.228 2,843.009 ↑ 35.3 936 1

Subquery Scan on *SELECT* 1 (cost=1,217,626.83..1,271,778.19 rows=33,002 width=258) (actual time=2,033.061..2,843.009 rows=936 loops=1)

10. 675.580 2,842.781 ↑ 35.3 936 1

GroupAggregate (cost=1,217,626.83..1,270,705.62 rows=33,002 width=286) (actual time=2,033.060..2,842.781 rows=936 loops=1)

  • Group Key: l_1.cid, l_1.property_id, l_1.property_name, l_1.leasing_agent, l_1.leasing_agent_id
11. 704.014 2,167.201 ↓ 3.1 485,344 1

Sort (cost=1,217,626.83..1,218,019.95 rows=157,249 width=266) (actual time=2,033.008..2,167.201 rows=485,344 loops=1)

  • Sort Key: l_1.property_id, l_1.property_name, l_1.leasing_agent, l_1.leasing_agent_id
  • Sort Method: external merge Disk: 64984kB
12. 177.046 1,463.187 ↓ 3.1 485,344 1

Hash Left Join (cost=25,095.78..1,204,054.13 rows=157,249 width=266) (actual time=127.129..1,463.187 rows=485,344 loops=1)

  • Hash Cond: ((l_1.cid = cal_prior.cid) AND (l_1.application_id = cal_prior.application_id))
  • Join Filter: (cal_prior.id <> l_1.id)
13. 243.258 1,159.613 ↓ 3.1 485,344 1

Hash Left Join (cost=16.19..1,172,684.58 rows=157,249 width=258) (actual time=0.093..1,159.613 rows=485,344 loops=1)

  • Hash Cond: ((l_1.cid = ls.cid) AND (COALESCE(l_1.converting_lead_source_id, l_1.originating_lead_source_id) = ls.id))
  • Filter: ((ls.id = ANY ('{0,64848,64451,64267,64481,64233,64183,64181,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,64499,64291,64440,64410,64486,64232,64474,64248,64249,64452,64403,64250,64841,64251,64252,64185,64253,64401,64255,64439,64501,64487,64254,64462,64488,64500,64234,64480,64453,64464,64177,64441,64258,64259,64842,64463,64260,64843,64445,64465,64261,64475,64180,64262,64885,64404,64477,64263,64264,64910,64405,64409,64444,64265,64460,64237,64406,64466,64266,64268,64883,64270,64454,64489,64490,64186,64491,64272,64184,64178,64246,64238,64470,64247,64907,64273,64450,64274,64473,64846,64479,64176,64906,64903,64241,64276,64275,64239,64277,64845,64243,64492,64459,64449,64467,64407,64468,64447,64245,64443,64278,64279,64476,64280,64884,64478,64493,64482,64448,64471,64909,64494,64495,64285,64455,64286,64287,64849,64288,64844,64408,64483,64446,64442,64175,64496,64289,64497,64458,64290,64244,64461,64457,64847,64472,64882,64469}'::integer[])) OR (ls.id IS NULL))
14. 209.975 916.289 ↓ 3.0 485,344 1

Merge Left Join (cost=0.85..1,171,624.38 rows=159,869 width=266) (actual time=0.019..916.289 rows=485,344 loops=1)

  • Merge Cond: (l_1.lease_interval_id = a.lease_interval_id)
  • Join Filter: (CASE WHEN (a.event_datetime <= l_1.lease_approved_on) THEN true WHEN (l_1.lease_approved_on IS NULL) THEN true ELSE NULL::boolean END AND (a.cid = l_1.cid))
  • Rows Removed by Join Filter: 257393
15. 518.239 518.239 ↑ 1.6 68,062 1

Index Scan using idx_temp_leads_data_lease_interval_id on leads_data l_1 (cost=0.42..1,108,048.42 rows=111,946 width=226) (actual time=0.010..518.239 rows=68,062 loops=1)

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

Index Scan using idx_temp_activities_lease_interval_id on activities_temp a (cost=0.42..49,707.21 rows=959,221 width=52) (actual time=0.008..188.075 rows=959,202 loops=1)

  • Filter: (cid = 15077)
17. 0.025 0.066 ↑ 1.0 182 1

Hash (cost=8.97..8.97 rows=182 width=8) (actual time=0.066..0.066 rows=182 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
18. 0.041 0.041 ↑ 1.0 182 1

Index Only Scan using pk_lead_sources on lead_sources ls (cost=0.14..8.97 rows=182 width=8) (actual time=0.025..0.041 rows=182 loops=1)

  • Index Cond: (cid = 15077)
  • Heap Fetches: 0
19. 66.223 126.528 ↑ 1.0 339,505 1

Hash (cost=13,196.91..13,196.91 rows=339,505 width=24) (actual time=126.528..126.528 rows=339,505 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 22663kB
20. 60.305 60.305 ↑ 1.0 339,505 1

Seq Scan on cal_prior (cost=0.00..13,196.91 rows=339,505 width=24) (actual time=0.008..60.305 rows=339,505 loops=1)

  • Filter: (cid = 15077)
21. 0.094 298.179 ↑ 3.7 442 1

Subquery Scan on *SELECT* 2 (cost=1,108,794.43..1,108,983.51 rows=1,642 width=258) (actual time=283.169..298.179 rows=442 loops=1)

22. 13.153 298.085 ↑ 3.7 442 1

GroupAggregate (cost=1,108,794.43..1,108,889.10 rows=1,642 width=246) (actual time=283.168..298.085 rows=442 loops=1)

  • Group Key: l_2.cid, l_2.property_id, l_2.property_name, l_2.leasing_agent, l_2.leasing_agent_id
23. 16.428 284.932 ↓ 13.2 21,775 1

Sort (cost=1,108,794.43..1,108,798.56 rows=1,651 width=174) (actual time=283.136..284.932 rows=21,775 loops=1)

  • Sort Key: l_2.property_id, l_2.property_name, l_2.leasing_agent, l_2.leasing_agent_id
  • Sort Method: quicksort Memory: 3733kB
24. 9.581 268.504 ↓ 13.2 21,775 1

Nested Loop Left Join (cost=0.14..1,108,706.19 rows=1,651 width=174) (actual time=29.289..268.504 rows=21,775 loops=1)

  • Filter: ((ls_1.id = ANY ('{0,64848,64451,64267,64481,64233,64183,64181,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,64499,64291,64440,64410,64486,64232,64474,64248,64249,64452,64403,64250,64841,64251,64252,64185,64253,64401,64255,64439,64501,64487,64254,64462,64488,64500,64234,64480,64453,64464,64177,64441,64258,64259,64842,64463,64260,64843,64445,64465,64261,64475,64180,64262,64885,64404,64477,64263,64264,64910,64405,64409,64444,64265,64460,64237,64406,64466,64266,64268,64883,64270,64454,64489,64490,64186,64491,64272,64184,64178,64246,64238,64470,64247,64907,64273,64450,64274,64473,64846,64479,64176,64906,64903,64241,64276,64275,64239,64277,64845,64243,64492,64459,64449,64467,64407,64468,64447,64245,64443,64278,64279,64476,64280,64884,64478,64493,64482,64448,64471,64909,64494,64495,64285,64455,64286,64287,64849,64288,64844,64408,64483,64446,64442,64175,64496,64289,64497,64458,64290,64244,64461,64457,64847,64472,64882,64469}'::integer[])) OR (ls_1.id IS NULL))
25. 237.148 237.148 ↓ 13.0 21,775 1

Seq Scan on leads_data l_2 (cost=0.00..1,107,963.60 rows=1,679 width=182) (actual time=29.268..237.148 rows=21,775 loops=1)

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

Index Only Scan using pk_lead_sources on lead_sources ls_1 (cost=0.14..0.19 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=21,775)

  • Index Cond: ((cid = l_2.cid) AND (cid = 15077) AND (id = COALESCE(l_2.converting_lead_source_id, l_2.originating_lead_source_id)))