explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cHYW

Settings
# exclusive inclusive rows x rows loops node
1. 43.026 7,984.490 ↑ 274.5 105 1

GroupAggregate (cost=3,637,093.32..3,642,856.92 rows=28,818 width=1,164) (actual time=7,933.258..7,984.490 rows=105 loops=1)

  • Group Key: l.property_name, load_prop.property_id, load_prop.property_name, load_prop.lookup_code, l.property_id
2. 51.690 7,941.464 ↑ 1.3 21,386 1

Sort (cost=3,637,093.32..3,637,165.36 rows=28,818 width=414) (actual time=7,932.878..7,941.464 rows=21,386 loops=1)

  • Sort Key: l.property_name, l.property_id, load_prop.property_name, load_prop.lookup_code
  • Sort Method: quicksort Memory: 11529kB
3. 26.473 7,889.774 ↑ 1.3 21,386 1

Hash Join (cost=1,841,198.72..3,634,958.67 rows=28,818 width=414) (actual time=5,764.425..7,889.774 rows=21,386 loops=1)

  • Hash Cond: (l.property_id = load_prop.property_id)
4. 33.636 7,863.131 ↑ 1.7 21,386 1

Subquery Scan on l (cost=1,841,193.09..3,634,530.62 rows=35,799 width=386) (actual time=5,764.247..7,863.131 rows=21,386 loops=1)

  • Filter: ((l.new_leads <> 0) OR (l.first_visit_tour <> 0) OR (l.applications_completed <> 0) OR (l.applications_approved <> 0) OR (l.lease_completed <> 0) OR (l.lease_approved <> 0) OR (l.prospect_cancelled <> 0) OR (l.applications_completed_cancelled <> 0) OR (l.applications_approved_cancelled <> 0) OR (l.lease_completed_cancelled <> 0))
  • Rows Removed by Filter: 22943
5. 33.148 7,829.495 ↓ 1.2 44,329 1

Append (cost=1,841,193.09..3,633,277.66 rows=35,799 width=414) (actual time=5,685.121..7,829.495 rows=44,329 loops=1)

6. 34.731 7,349.090 ↑ 1.0 34,518 1

Subquery Scan on "*SELECT* 1" (cost=1,841,193.09..2,332,903.04 rows=35,791 width=414) (actual time=5,685.119..7,349.090 rows=34,518 loops=1)

7. 1,508.231 7,314.359 ↑ 1.0 34,518 1

GroupAggregate (cost=1,841,193.09..2,331,829.31 rows=35,791 width=382) (actual time=5,685.117..7,314.359 rows=34,518 loops=1)

  • Group Key: l_1.cid, l_1.lead_source_id, l_1.property_id, l_1.property_name, l_1.ps_product_id, l_1.traffic_type_id, l_1.company_employee_id, l_1.unit_type_id, l_1.first_event
8. 1,020.889 5,806.128 ↑ 3.6 264,771 1

Sort (cost=1,841,193.09..1,843,607.38 rows=965,713 width=294) (actual time=5,685.036..5,806.128 rows=264,771 loops=1)

  • Sort Key: l_1.lead_source_id, l_1.property_id, l_1.property_name, l_1.ps_product_id, l_1.traffic_type_id, l_1.company_employee_id, l_1.unit_type_id, l_1.first_event
  • Sort Method: quicksort Memory: 81957kB
9. 524.890 4,785.239 ↑ 3.6 264,771 1

Merge Left Join (cost=1,725,273.96..1,745,195.26 rows=965,713 width=294) (actual time=3,949.645..4,785.239 rows=264,771 loops=1)

  • Merge Cond: (l_1.application_id = cal_inner.application_id)
  • Join Filter: ((cal_inner.id <> l_1.id) AND (cal_inner.cid = l_1.cid))
10. 462.537 2,499.002 ↓ 2.2 264,771 1

Sort (cost=105,503.47..105,806.99 rows=121,407 width=278) (actual time=2,394.397..2,499.002 rows=264,771 loops=1)

  • Sort Key: l_1.application_id
  • Sort Method: quicksort Memory: 78505kB
11. 254.084 2,036.465 ↓ 2.2 264,771 1

Hash Left Join (cost=35,925.98..95,250.96 rows=121,407 width=278) (actual time=513.035..2,036.465 rows=264,771 loops=1)

  • Hash Cond: ((l_1.cid = events_before_start_date.cid) AND (l_1.lease_interval_id = events_before_start_date.lease_interval_id))
12. 269.625 1,714.270 ↓ 2.2 264,771 1

Hash Left Join (cost=33,709.75..91,892.88 rows=121,407 width=278) (actual time=444.390..1,714.270 rows=264,771 loops=1)

  • Hash Cond: ((l_1.cid = cll.cid) AND (l_1.property_id = cll.property_id) AND (l_1.lease_id = cll.lease_id))
13. 622.178 1,303.717 ↓ 2.2 264,771 1

Hash Right Join (cost=30,903.44..87,720.66 rows=121,407 width=266) (actual time=303.445..1,303.717 rows=264,771 loops=1)

  • Hash Cond: ((a.cid = l_1.cid) AND (a.lease_interval_id = l_1.lease_interval_id))
  • Join Filter: ((a.event_datetime <= l_1.lease_approved_on) OR (l_1.lease_approved_on IS NULL))
  • Rows Removed by Join Filter: 234237
14. 378.587 378.587 ↑ 1.0 641,689 1

Seq Scan on activities_temp a (cost=0.00..49,328.09 rows=641,927 width=60) (actual time=0.008..378.587 rows=641,689 loops=1)

  • Filter: (cid = 15077)
15. 57.539 302.952 ↑ 1.6 74,498 1

Hash (cost=29,082.33..29,082.33 rows=121,407 width=222) (actual time=302.952..302.952 rows=74,498 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 10783kB
16. 245.413 245.413 ↑ 1.6 74,498 1

Seq Scan on leads_data l_1 (cost=0.00..29,082.33 rows=121,407 width=222) (actual time=0.010..245.413 rows=74,498 loops=1)

  • Filter: ((effective_date >= '2020-02-01'::date) AND (cid = 15077))
  • Rows Removed by Filter: 289724
17. 71.560 140.928 ↓ 199.9 134,126 1

Hash (cost=2,794.57..2,794.57 rows=671 width=28) (actual time=140.927..140.928 rows=134,126 loops=1)

  • Buckets: 262144 (originally 1024) Batches: 1 (originally 1) Memory Usage: 9907kB
18. 69.368 69.368 ↓ 199.9 134,126 1

Seq Scan on leases_data cll (cost=0.00..2,794.57 rows=671 width=28) (actual time=0.009..69.368 rows=134,126 loops=1)

  • Filter: (cid = 15077)
19. 34.448 68.111 ↑ 1.0 69,390 1

Hash (cost=1,175.38..1,175.38 rows=69,390 width=8) (actual time=68.110..68.111 rows=69,390 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3735kB
20. 33.663 33.663 ↑ 1.0 69,390 1

Seq Scan on unique_visits_leads_temp events_before_start_date (cost=0.00..1,175.38 rows=69,390 width=8) (actual time=0.013..33.663 rows=69,390 loops=1)

  • Filter: (cid = 15077)
21. 506.774 1,761.347 ↑ 1.3 551,147 1

Sort (cost=1,619,770.49..1,621,525.78 rows=702,114 width=24) (actual time=1,555.235..1,761.347 rows=551,147 loops=1)

  • Sort Key: cal_inner.application_id
  • Sort Method: quicksort Memory: 41125kB
22. 322.262 1,254.573 ↑ 1.9 369,109 1

Hash Join (cost=6.06..1,551,590.50 rows=702,114 width=24) (actual time=0.208..1,254.573 rows=369,109 loops=1)

  • Hash Cond: (cal_inner.property_id = load_prop_1.property_id)
23. 932.149 932.149 ↑ 1.9 373,444 1

Index Scan using idx_cached_application_logs_cid_aid_reporting_daterange on cached_application_logs cal_inner (cost=0.43..1,541,930.81 rows=702,114 width=28) (actual time=0.034..932.149 rows=373,444 loops=1)

  • Index Cond: ((cid = 15077) AND ('2020-01-31 00:00:00'::timestamp without time zone >= reporting_post_date) AND ('2020-01-31 00:00:00'::timestamp without time zone <= apply_through_post_date))
  • Filter: ((occupancy_type_id <> 4) AND (lease_interval_type_id = 1))
  • Rows Removed by Filter: 44287
24. 0.076 0.162 ↑ 1.0 161 1

Hash (cost=3.61..3.61 rows=161 width=4) (actual time=0.162..0.162 rows=161 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
25. 0.086 0.086 ↑ 1.0 161 1

Seq Scan on load_prop load_prop_1 (cost=0.00..3.61 rows=161 width=4) (actual time=0.013..0.086 rows=161 loops=1)

26. 11.064 447.257 ↓ 1,226.4 9,811 1

Subquery Scan on "*SELECT* 2" (cost=1,300,373.45..1,300,374.62 rows=8 width=414) (actual time=339.142..447.257 rows=9,811 loops=1)

27. 88.978 436.193 ↓ 1,226.4 9,811 1

GroupAggregate (cost=1,300,373.45..1,300,374.16 rows=8 width=290) (actual time=339.138..436.193 rows=9,811 loops=1)

  • Group Key: l_2.cid, (COALESCE(l_2.converting_lead_source_id, l_2.originating_lead_source_id, 0)), l_2.property_id, l_2.property_name, l_2.ps_product_id, l_2.first_event_medium_id, (COALESCE(l_2.leasing_agent_id, 0)), l_2.unit_type_id, l_2.first_event
28. 45.596 347.215 ↓ 2,485.0 19,880 1

Sort (cost=1,300,373.45..1,300,373.47 rows=8 width=155) (actual time=339.100..347.215 rows=19,880 loops=1)

  • Sort Key: (COALESCE(l_2.converting_lead_source_id, l_2.originating_lead_source_id, 0)), l_2.property_id, l_2.property_name, l_2.ps_product_id, l_2.first_event_medium_id, (COALESCE(l_2.leasing_agent_id, 0)), l_2.unit_type_id, l_2.first_event
  • Sort Method: quicksort Memory: 3436kB
29. 301.619 301.619 ↓ 2,485.0 19,880 1

Seq Scan on leads_temp l_2 (cost=0.00..1,300,373.33 rows=8 width=155) (actual time=142.762..301.619 rows=19,880 loops=1)

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

Hash (cost=3.61..3.61 rows=161 width=28) (actual time=0.169..0.170 rows=161 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
31. 0.084 0.084 ↑ 1.0 161 1

Seq Scan on load_prop (cost=0.00..3.61 rows=161 width=28) (actual time=0.008..0.084 rows=161 loops=1)