explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qlGa

Settings
# exclusive inclusive rows x rows loops node
1. 0.061 7,756.048 ↓ 8.0 8 1

Unique (cost=10,484.71..10,484.72 rows=1 width=69) (actual time=7,741.397..7,756.048 rows=8 loops=1)

2. 0.360 7,755.987 ↓ 120.0 120 1

Sort (cost=10,484.71..10,484.71 rows=1 width=69) (actual time=7,741.396..7,755.987 rows=120 loops=1)

  • Sort Key: property_meta_asset_managers.name, property_meta_clients.name, property_meta_funds.name, property_meta_jv_partners.name, property_meta_data.region
  • Sort Method: quicksort Memory: 41kB
3. 81.016 7,755.627 ↓ 120.0 120 1

Gather (cost=5,925.09..10,484.71 rows=1 width=69) (actual time=168.497..7,755.627 rows=120 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.561 7,674.611 ↓ 60.0 60 2 / 2

Nested Loop (cost=4,925.09..9,484.61 rows=1 width=69) (actual time=2,078.730..7,674.611 rows=60 loops=2)

  • Join Filter: (property_meta_asset_managers.property_meta_datum_id = property_meta_jv_partners.property_meta_datum_id)
5. 11.659 7,649.283 ↓ 750.0 750 2 / 2

Nested Loop (cost=4,925.01..9,481.75 rows=1 width=64) (actual time=79.026..7,649.283 rows=750 loops=2)

6. 6,186.946 7,620.363 ↓ 750.0 750 2 / 2

Nested Loop (cost=4,924.95..9,480.59 rows=1 width=47) (actual time=73.927..7,620.363 rows=750 loops=2)

7. 11.103 366.087 ↓ 2,426.0 4,852 2 / 2

Nested Loop (cost=4,924.87..5,138.69 rows=2 width=51) (actual time=72.652..366.087 rows=4,852 loops=2)

8. 2.404 260.859 ↓ 1,046.0 3,138 2 / 2

Nested Loop (cost=4,924.78..5,124.85 rows=3 width=51) (actual time=72.594..260.859 rows=3,138 loops=2)

9. 0.965 143.645 ↓ 111.2 890 2 / 2

Nested Loop (cost=4,924.70..5,078.98 rows=8 width=51) (actual time=72.529..143.645 rows=890 loops=2)

10. 0.892 113.092 ↓ 167.3 502 2 / 2

Nested Loop (cost=4,924.61..5,051.45 rows=3 width=55) (actual time=72.443..113.092 rows=502 loops=2)

11. 0.607 89.632 ↓ 167.3 502 2 / 2

Nested Loop (cost=4,924.53..5,046.22 rows=3 width=51) (actual time=72.391..89.632 rows=502 loops=2)

  • Join Filter: (property_meta_data.id = property_meta_asset_managers.property_meta_datum_id)
12. 2.461 75.726 ↓ 12.8 512 2 / 2

Merge Join (cost=4,924.44..4,933.57 rows=40 width=34) (actual time=72.283..75.726 rows=512 loops=2)

  • Merge Cond: (property_meta_data.id = property_meta_clients.property_meta_datum_id)
13. 5.371 27.630 ↓ 1.1 2,044 2 / 2

Sort (cost=3,597.73..3,598.69 rows=1,926 width=17) (actual time=27.235..27.630 rows=2,044 loops=2)

  • Sort Key: property_meta_data.id
  • Sort Method: quicksort Memory: 271kB
  • Worker 0: Sort Method: quicksort Memory: 74kB
14. 17.782 22.259 ↓ 1.1 2,044 2 / 2

Parallel Bitmap Heap Scan on property_meta_data (cost=33.16..3,576.71 rows=1,926 width=17) (actual time=4.618..22.259 rows=2,044 loops=2)

  • Recheck Cond: ((employer_id = 1,996) AND (deleted_at IS NULL))
  • Heap Blocks: exact=605
15. 4.478 4.478 ↓ 1.2 4,089 1 / 2

Bitmap Index Scan on index_property_meta_data_composite (cost=0.00..33.00 rows=3,274 width=0) (actual time=8.954..8.955 rows=4,089 loops=1)

  • Index Cond: (employer_id = 1,996)
16. 4.285 45.635 ↑ 1.0 6,819 2 / 2

Sort (cost=1,326.71..1,330.26 rows=7,100 width=17) (actual time=44.492..45.635 rows=6,819 loops=2)

  • Sort Key: property_meta_clients.property_meta_datum_id
  • Sort Method: quicksort Memory: 595kB
  • Worker 0: Sort Method: quicksort Memory: 595kB
17. 41.350 41.350 ↑ 1.0 6,825 2 / 2

Seq Scan on property_meta_clients (cost=0.00..1,235.88 rows=7,100 width=17) (actual time=0.029..41.350 rows=6,825 loops=2)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 78,135
18. 13.299 13.299 ↑ 1.0 1 1,023 / 2

Index Scan using index_property_meta_asset_managers_on_property_meta_datum_id on property_meta_asset_managers (cost=0.08..2.81 rows=1 width=17) (actual time=0.009..0.026 rows=1 loops=1,023)

  • Index Cond: (property_meta_datum_id = property_meta_clients.property_meta_datum_id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1
19. 22.567 22.567 ↑ 1.0 1 1,003 / 2

Index Only Scan using index_properties_on_id_no_deleted on properties (cost=0.08..1.74 rows=1 width=4) (actual time=0.045..0.045 rows=1 loops=1,003)

  • Index Cond: (id = property_meta_data.property_id)
  • Heap Fetches: 1,003
20. 29.588 29.588 ↑ 26.5 2 1,003 / 2

Index Only Scan using index_floors_on_property_id_and_id_no_deleted on floors (cost=0.08..9.02 rows=53 width=8) (actual time=0.047..0.059 rows=2 loops=1,003)

  • Index Cond: (property_id = properties.id)
  • Heap Fetches: 1,773
21. 114.810 114.810 ↑ 6.0 4 1,780 / 2

Index Only Scan using index_spaces_on_floor_id_and_id_no_deleted on spaces (cost=0.09..5.66 rows=24 width=8) (actual time=0.039..0.129 rows=4 loops=1,780)

  • Index Cond: (floor_id = floors.id)
  • Heap Fetches: 6,275
22. 94.125 94.125 ↑ 6.0 2 6,275 / 2

Index Scan using partial_index_space_lease_terms_on_space_id on space_lease_terms (cost=0.09..4.58 rows=12 width=8) (actual time=0.021..0.030 rows=2 loops=6,275)

  • Index Cond: (space_id = spaces.id)
23. 1,067.330 1,067.330 ↓ 0.0 0 9,703 / 2

Index Scan using deal_terms_pkey on deal_terms (cost=0.09..2,168.87 rows=1 width=4) (actual time=0.220..0.220 rows=0 loops=9,703)

  • Index Cond: ((id = space_lease_terms.lease_term_id) AND (id = ANY ('{5678681,5678681,5832435,5678660,5678651,5678653,5678650,5678661,5678661,6014593,6015165,6015165,6012915,6012915,6012915,6012915,6012915,6047704,6047704,6014875,6012473,6010917,6013317,6014522,6015188,6015188,6010292,6011410,6015273,6015273,6015273,6015273,6012857,6013984,6025719,6013800,6015315,6083327,6014978,6014978,6015087,6015087,6015102,6015046,6015046,6015250,6015250,6015250,6015250,6015256,6015251,6015251,6014055,6014439,6015333,6015333,6015338,6025694,6010015,6010304,6010367,6010479,6010834,6010873,6010976,6011296,6011344,6011344,6011344,6011344,6011344,6011344,6012301,6012515,6012892,6014030,6008856,6010080,6011111,6056554,6013139,6014640,6015124,6009011,6011358,6009553,6013928,6014609,6012832,6025795,6025795,6070266,6010087,6093702,6093700,6093704,6173139,6012546,6012739,6012742,6013917,6013862,6095422,6173218,6014029,6014110,6014110,6014110,6025837,6025860,6015035,6015035,6009276,6009276,6063772,6010380,6014877,6012554,6063746,6025624,6014497,6014478,6014535,6173219,6192063,6192063,6010490,6012956,6010269,6298439,6013354,6013354,6008711,6008711,6173080,6173106,6013604,6324424,6324432,6324432,6015305,6015305,6324437,6324438,6324438,6324439,6324444,6025774,6025774,6298408,6014821,6015357,6011299,6012286,6012484,6013943,6014060,6013722,6014917,6282622,6282622,6063741,6014957,6014957,6014986,6010194,6025621,6009144,6009144,6008818,6008807,6008839,6008876,6010511,6012547,6173060,6173061,6173064,6014708,6015000,6012971,6012972,6012972,6012976,6008947,6008947,6172965,6010260,6172887,6172915,6063798,6012316,6013370,6013390,6014692,6014785,6014862,6014961,6015065,6008845,6008902,6010518,6010518,6010999,6010999,6011187,6011187,6011187,6013576,6008752,6008726,6008726,6008762,6008762,6008762,6063769,6013880,6010055,6010086,6349862,6173178,6173208,6015491,6008917,6010898,6025523,6010063,6010063,6343066,6343066,6198138,6198138,6198138,6198138,6198138,6198138,6198138,6008788,6012815,6013339,6101681,6012476,6012560,6015052,6173230,6013867,6013867,6008769,6319191,6012259,6014043,6015378,6015378,6275468,6063795,6008992,6013888,6014794,6014794,6014815,6014815,6275467,6014165,6014165,6012918,6013697,6014591,6173028,6013951,6014041,6014041,6014041,6010127,6025708,6608662,6608662,6608662,6008996,6010421,6012579,6012865,6013263,6014254,6084690,6090104,6608656,6608656,6608656,6608692,6608692,6608692,6609307,6609307,6609307,6609307,6609307,6609307,6609307,6609307,6609307,6609331,6609331,6609331,6609331,6609331,6609331,6609331,6609324,6609324,6609324,6609324,6609324,6609324,6609324,6609324,6609324,6609334,6609334,6609334,6609736,6609736,6609736,6609736,6609736,6609736,6609736,6609736,6012707,6608676,6608676,6608676,6609864,6013853,6173130,6608668,6608672,6608704,6063770,6011371,6011371,6014797,6014797,6015221,6014249,6008734,6008734,6015324,6015324,6015428,6015428,6015428,6015428,6015322,6015322,6015322,6015322,6173049,6172958,6172958,6014450,6378662,6010488,6010488,6025803,6025803,6609917,6395368,6014564,6015106,6012765,6014423,6014423,6378661,6378661,6235613,6235613,6235613,6357068,6173169,6173169,6173176,6173176,6173180,6173180,6014995,6014995,6608234,6010145,6015274,6015277,6608111,6424755,6424755,6424755,6319199,6014476,6014476,6014606,6014844,6608666,6608666,6010153,6010267,6010267,6686918,6686918,6025579,6025579,6013326,6013326,6608201,6608201,6608201,6608259,6010191,6010537,6010537,6013754,6013770,6013811,6013842,6013845,6103725,6090078,6245626,6245626,6011254,6011254,6012845,6013834,6025807,6608232,6608232,6608232,6608232,6608232,6608232,6608232,6015399,6011353,6011353,6608646,6608646,6608683,6012601,6608132,6014868,6454955,6454955,6101658,6101658,6010549,6010549,6010574,6010574,6686927,6686927,6609866,6014587,6010717,6010717,6010717,6015157,6009512,6014028,6015093,6015093,6401610,6015060,6015060,6014823,6014823,6015101,6015101,6015101,6609720,6609720,6013024,6013024,6014520,6010504,6012962,6084708,6084708,6608141,6608141,6608239,6608267,6608267,6609714,6609743,6609743,6009068,6009068,6012704,6012704,6012704,6012886,6012886,6012886,6903147,6903147,6012551,6609735,6609735,6609735,6010510,6172955,6012700,6012911,6013631,6686926,6609713,6608092,6608092,6608170,6608170,6608266,6608703,6608713,6012621,6012621,6012955,6012955,6608264,6609315,6609339,6008727,6008727,6011251,6011251,6609750,6609750,6609750,6609332,6609332,6609332,6609332,6008713,6008719,6008732,6008732,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6319185,6008730,6008730,6008835,7548509,7548509,6008723,6661704,6661704,6008892,6008767,6198139,6198139,6198139,6198139,6198139,6198139,6198139,6008815,6008773,6008773,6008778,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008861,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6008994,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009061,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6009096,6532092,6008844,6008881,6008813,6532094,6008942,6008972,6008822,6008822,6008830,6194341,6194341,6008843,6008866,6008866,6008968,6008968,6688683,6571072,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008937,6008900,6008899,6008889,6008889,6008896,6661705,6008908,6008944,6008944,6008916,6008910,6008935,6008935,6008926,6008926,6008926,6008926,6008945,6223988,6008959,6008959,6172792,6401608,6401608,6623738,6009097,6009103,6009131,6635071,6635071,6205268,6009434,6049363,6049363,6049363,6049363,6049363,6049363,6009413,6009427,6009427,6009427,6009427,6009453,6009509,6009687,6009631,6009631,6009786,6009746,6009746,6607717,6009814,6009814,6009814,6009856,6009915,6009915,6009915,6009915,6685290,6685290,6685290,6009966,6009966,6009927,6009927,6009924,6009924,6009924,6010016,6009994,6010068,6010089,6010004,6010009,6010040,6010073,6010081,6010045,6025544,6025544,6319189,6319189,6319189,6025542,6010054,6010066,6010066,6010079,6010078,6010078,6454949,6454949,6010093,6010093,6010125,6010125,6010070,6010070,6010070,6010070,6010070,6226415,6010099,6010099,6010099,6010134,6010134,6010134,6010085,6010085,6010085,6010088,6010088,6010088,6010118,6010118,6010118,6192030,6192035,6192035,6258712,6258712,6595427,6083299,6083299,6083299,6083299,6485034,6010138,6343049,6343049,6010155,6010155,6010151,6010151,6433496,6343051,6343051,6010186,6010186,6343064,6343053,6343053,6343055,6343055,6343055,6010199,6010230,6010196,6010200,6343058,6343058,6010235,6010235,6010206,6010206,6010216,6172820,6172820,6010233,6010233,6010259,6010259,6343061,6343061,6010246,6343065,6010248,6010248,6010248,6010247,6010247,6010247,6343062,6010258,6343063,6343063,6010268,6343068,6101628,6101628,6101628,6411705,6101645,6101645,6319190,6101651,6298440,6298440,6298440,6101646,6101640,6101640,6101640,6101641,6101641,6101641,6101685,6101685,6101652,6101655,6010355,6010355,6360324,6360324,6902870,6025577,6025577,6025576,6025576,6010375,6010377,6010384,6010390,6010400,6010408,6010413,6010466,6010466,6010466,6010466,6010466,6010495,6010495,6010495,6010495,6694163,6694163,6025580,6025580,6010620,6010620,6010620,6010620,6010620,6010620,6010620,6328097,6481542,6010449,6010449,6010452,6010458,6010458,6010450,6010450,6010474,6010464,6010464,6010467,6010467,6010472,6010472,6010482,6010482,6010484,6010485,6010489,6010489,6010497,6010497,6010502,6010502,6010546,6010546,6010506,6010506,6010512,6010512,6010533,6010533,6485035,6010517,6010517,6010517,6010517,6010517,6010536,6010536,6010536,6010523,6010523,6010523,6010545,6010532,6010532,6010554,6010554,6697451,6697451,6010535,6010535,6010548,6010578,6010578,6010602,6010602,6025582,6025582,6025583,6172843,6172852,6172864,6172841,6172841,6172847,6172853,6172862,6172859,6172863,6172863,6172893,6172903,6172895,6172895,6172895,6172909,6172905,6172905,6172905,6188871,6172913,6172912,6172947,6172950,6172950,6010694,6010694,6010695,6010695,6010695,6010721,6010721,6010712,6010712,6010790,6010839,6532096,6010735,6010798,6245628,6245629,6245629,6010796,6010824,6010997,6011033,6011065,6010878,6010884,6245660,6245660,6245662,6245663,6245645,6011162,6011162,6010899,6010899,6010922,6010920,6103586,6103617,6010915,6010915,6010915,6664594,6664594,6010926,6010930,6010930,6010930,6010930,6010998,6010932,6010932,6378659,6011087,6011087,6011087,6011087,6011087,6011087,6011087,6011087,6011087,6011087,6011087,6011087,6011087,6103616,6103616,6103616,6010949,7030965,7030965,7030965,6010964,6010964,6010964,6010964,6010964,6103596,6103596,6011084,6011084,6011084,6011001,6011040,6011040,6011040,6011040,6011070,6011070,6011003,6011003,6011028,6011028,6319192,6319192,6011031,7319074,7319074,7319074,7319074,6011027,6011027,6011051,6011051,6011051,6011054,6011057,6349861,6349861,6011059,6011059,6011059,6011059,6011059,6011061,6011061,6011061,6011061,6011061,6011061,6011085,6011085,7362217,6011103,6011103,6011113,6011113,6011112,6011112,6206891,6206891,6011143,6011143,6011143,6059674,6059674,6172980,6172980,6172978,6011235,6011235,6011267,6011267,6173006,6173006,6343073,6328105,6328105,6173015,6173015,6173015,6173015,6173015,6173015,6173015,6011193,6011193,6011237,6011237,6172995,6282627,6282627,6063727,6063727,6063727,6063727,6063729,6063744,6063738,6063743,6063749,6063760,6063771,6063757,6063757,6063765,6063765,6063765,6625238,6625238,6625238,6625238,6480404,6658383,6063777,6406686,6426261,6433498,6063813,6063815,6063815,6063817,6063818,6063819,6063801,6063801,6370304,6063800,6063811,6063814,6252113,6252113,7548605,7548605,6011252,6011252,6011252,6011259,6011259,6025589,6025589,6025596,6025608,6173017,6025592,6025592,6025609,6025607,6011264,6011264,6025630,6025630,6026759,6026759,6011265,6011265,6011328,6011328,6011280,6011282,6011282,6011300,6011300,6011292,6011293,6011315,6011315,6011315,6011315,6011315,6011318,6011318,6011318,6025639,6025639,6025639,6263524,6263524,6011312,6011312,6011312,6011312,6011313,6011313,6011313,6011320,6011320,6011320,6011320,6011317,6011317,6011317,6011365,6011365,6011365,6011365,6011365,6181653,6181653,6181653,6181653,6181653,6631758,6631758,7362222,6011376,6011376,6011376,6011376,6011376,6244421,6244421,6244421,6244421,6244421,6541991,6633366,6633366,6226419,6226420,6226420,6011336,6011339,6011340,6011340,6011346,6011346,6011346,6011355,6011355,6011355,6324180,6324180,6324180,6387436,6387436,6324181,6324181,6324181,6753607,6753607,6025666,6025666,6025664,6025664,6401609,6011368,6011367,6011367,6011369,6011369,6411724,6686921,6631756,6631756,6631756,6025671,6025671,6025671,6011383,6011395,6011395,6535490,6101694,6101694,6688685,6541995,6541995,6011405,6011405,6011417,6011417,6011411,6011411,6011418,6011415,6011415,7413305,7413305,6011420,6011420,6011464,6011464,6012148,6012148,6205276,6012206,6012206,6012246,6012283,6012221,6012249,6012249,6198194,6198195,6012298,6012337,6012337,6012317,6012427,6012489,6013265,6013265,6013265,6013265,6013599,6013599,6013599,6013822,6013822,6015504,6015504,6015504,6015504,6012540,6012544,6012543,6012552,6012553,6012557,6012559,6012562,6012563,6012564,6615359,6012565,6012611,6012580,6012668,6012581,6012588,6012597,6012664,6012604,6012644,6679208,6679209,6012647,6012647,6192050,6012724,6012674,6012697,6615361,6173033,6012755,6012733,6051100,6012772,7387964,7387964,6482428,6173048,6012757,6012743,6679210,6012840,6012881,6012900,6012922,6012753,6012753,6067977,6067977,6012782,6012807,6012879,6070280,6012838,6623741,6012860,6012860,6012858,6012858,6024576,6012906,6244423,6244423,6244424,6343075,6343075,6535491,6012872,7388010,7388010,6012897,6012903,6012903,6012929,6038026,6038026,6038026,6038026,6038026,6012947,6012928,6012916,6606129,6173101,6173103,6173059,6173104,6173104,6173107,6173107,7362412,6012985,6012985,6012985,6012953,6012987,6012987,6012987,6012987,6012987,6012987,6012987,6013016,6013016,6013016,6535492,6535492,7525490,7525490,6454953,6454953,6012963,6012963,6476245,6476244,6476244,6476243,6012974,6012974,6012978,6012978,6377473,6013041,6882665,6882665,6882666,6882666,7319279,7319279,6013019,6013019,6013018,6013025,6013025,6013045,6013045,6478395,6013117,6013117,6013117,6623742,6013170,6013199,6013199,6013342,6013342,6013342,6013342,6013510,6013510,6013274,6201640,6013327,6013327,6103647,6013372,6615363,6995944,6245666,6103651,6083317,6083318,6348201,6348203,6013644,6013644,6013644,6013683,6013685,6013710,6013710,6103677,6103677,6013721,6348205,6013725,6245679,6245679,6245679,6013756,6013737,6013737,6013737,6083319,6013760,6013788,6013796,6013803,6480408,6480408,6013810,6013810,6013784,6013801,6013807,6013819,6013817,6457987,6013836,6013836,6013900,6013856,6013856,6013861,6013864,6013864,6013864,6013864,6013890,6013890,6013912,6013875,6013921,6013921,6173117,6173117,6013915,6013882,6013882,6513603,6534681,6534681,6013904,6013904,6013901,6014017,6014017,6013931,6013931,6395360,6013939,6013986,6013986,6013940,6013976,6013976,6173118,7181143,6615365,6093687,6103696,6103697,6103698,6566770,6014018,6226452,6226448,6226451,6617533,6617533,6617533,6013994,6013994,6192055,6014006,6014007,6635076,6534680,6534682,6333106,6665912,6014025,6014054,6492469,6014048,6014073,6014135,6014115,6617530,6617530,6251945,6598313,6598313,6014174,6014177,6014177,6014177,6014177,6014113,6093705,6103709,6103709,6635077,6014540,6014124,6224005,6103715,6103715,6014126,6089995,6014413,6378660,6095421,6014468,6014468,6014485,6014485,6014485,6014485,6014485,6014485,6688686,6688686,7319299,6014487,6014493,6014493,6995958,6995958,6014538,6014515,6014515,6014515,6070294,6014532,6014532,6014532,6014528,6014537,6014604,6014568,6014568,6014568,6014568,6014595,6014555,6014555,6014600,6014600,6688687,6995959,6014622,6014610,6491372,6014635,6014605,6014607,6014607,6014598,6014627,6014666,6014655,6014655,6606132,6014676,6014688,6014691,6014701,6198231,6014678,6103730,6014690,6014693,6014693,6103733,6205282,6205282,6205282,6205282,6173141,6173141,6173141,6173141,6631766,6631766,6014786,6014786,6014786,6201641,6201641,6201641,6201641,6201641,7250072,7250072,6378663,6378663,6378663,6378663,6324429,6014851,6014851,6014817,6014817,6014820,6014819,6014827,6014827,6014814,6014814,6014814,6014876,6014876,7227101,7227101,6014842,6014842,6014861,6014863,6014863,6173142,6173142,6014911,6014869,6282632,6014897,6014903,6014872,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6090003,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6014947,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6090031,6014916,7413513,6014900,6014900,6014904,6014904,6014899,6014899,6014899,6014899,6014901,6014901,6014922,6014922,6014905,6014905,6014905,6014905,6014908,6014907,6014907,6014907,6014909,6014909,6014988,6014912,6014912,6014913,6014919,6014919,6014918,6014918,6685300,6173144,6173144,6173145,6173156,6173156,6173156,6173159,6015009,6015027,6173187,6274163,6014944,6173166,6173166,6173166,6015040,6015040,6015040,6015040,6015040,6256000,6256000,6014969,6014969,6360328,6360328,6015031,6173179,6173179,6173179,6173179,6014967,6685303,6685303,6685304,6685304,6173183,6015063,6173173,6173188,6173203,6192060,6192060,6173190,6173190,6274164,6274164,6015072,6679211,6173212,6173212,6173196,7227111,7227111,6015064,6015064,6015064,6015064,6173211,6015089,7203855,7203855,6015091,6015091,6015099,6015099,6015099,6015099,6015099,6015099,6015092,6015092,6015098,6015098,6015094,7250088,7250088,7250088,6015100,6015100,6015110,6668437,6173216,6173216,6173217,6173217,6015122,6015128,6015128,6015127,6015138,6015138,6633264,6173221,6173223,6084698,6173227,6015153,6173224,6173224,6192061,6192062,6015298,6084701,6084701,6173231,6360329,6360329,6360329,6084724,7362448,7362448,6173236,6395376,6357069,6084719,6084722,6090079,6090079,6090079,6090079,6067978,6067978,6067978,6067978,6015252,6015194,6015217,6015223,6090081,6015203,6015203,6090116,6090089,6280517,6015235,6015235,6015237,6015237,6015237,6015237,6015237,6090119,6090120,6280518,6090106,6173240,7362449,7362449,7362449,7362449,6282633,6282634,6282634,6282634,6282634,6282634,6409529,6409529,6083329,6015268,6015268,6686928,6015291,6015291,6015291,6679212,6015307,6015307,6095433,6095433,6095439,6025693,6025693,6103735,6025695,6025696,6025696,6025696,6025721,6077792,6077793,6025769,6025736,6025736,6173245,6173246,6025761,6025761,6025761,6025761,6025753,6025744,6025744,6025780,6173248,6173248,6173248,6173248,6173249,6173249,6025759,6025759,6025759,6025797,6025797,6025763,6025772,6025772,6025798,6025798,6025798,6362360,6025778,6025793,6025793,6665913,6665913,6025808,6025808,6025808,6025809,6025809,6025861,6025861,6025888,6025888,6025823,6025822,6025822,6025822,6025825,6025825,6025825,6025880,6025872,6688688,6401612,6534685,6534685,6534685,6534685,6192072,6192072,6192072,6192072,6192072,6192071,6192071,6192071,6192076,6192076,6192076,6608079,6608079,6608079,6608080,6608080,6608103,6608103,6608081,6608081,6608081,6608100,6608100,6608100,6686932,6608083,6608083,6608083,6608085,6608088,6608112,6608131,6608131,6608091,6608091,6608091,6608093,6608093,7504645,7504645,6608096,6608133,6608094,6608095,7504646,7504646,6608097,6608135,6608098,6608098,6608099,6608099,6608101,6608107,6608107,6608109,6608134,6608120,6608120,6608113,6608146,6608119,6608144,6608144,6608147,6608147,6608128,6608166,6608129,6608156,6608156,6608167,6608150,6608150,6608152,6608152,6608165,6608155,6608161,6608161,6608161,6608161,6608161,6608161,6608160,6608160,6608174,6608175,6608176,6608176,6608176,6608177,6608177,6608179,6608180,6608181,6608189,6608191,6608191,6608191,6608204,6608204,6608204,6608193,6608193,6608193,6608221,6608221,6608221,6608221,6608195,6608227,6608194,6608215,6724497,6724497,6724497,6724497,6724497,6724497,6724497,6608197,6608197,6608197,6608219,6608219,6608219,6608199,6608199,6608199,6608235,6608235,6608235,6608202,6608202,6608228,6608228,6608203,6695880,6608206,6608206,7362472,7362472,6608209,6608257,6608210,6608253,6608214,7525552,6608248,6608279,6608220,7504648,6608283,6608226,6608226,6608226,6608245,6608245,6608245,6608233,6608233,6608233,6608233,6608229,6608229,6608229,6608229,6608231,6608231,6608230,6608230,6608236,6608236,6608252,6608252,6608260,6608260,6608265,6608268,6608298,6608281,6608281,6608645,6608645,6608645,6608645,6608645,6753852,6608658,6608658,6608659,6608659,6608659,6608659,6608674,6608705,6623747,6623747,6623747,6608655,6608655,6608655,6608680,6608680,6608652,6608693,6608657,6608684,6608661,6608661,6608664,6608664,6608664,6608695,6608695,6608695,6626438,6626438,6626438,6608663,6608687,6753853,7479503,6608670,6608694,7504651,6608671,6608708,6608677,6608700,6608728,6608686,6608689,6609115,6609115,6609122,6609122,6609116,6609116,6609116,6609116,6609116,6609116,6609118,6609118,6609119,6609120,6609120,7388098,7388098,6609253,6609257,6609257,6609281,6609281,6609258,6609258,6609293,6609260,6609329,6609259,6609291,6609264,6609303,6609267,6609267,6609270,6609302,6609273,6609299,6609276,6609276,6609276,6609305,6609305,6609285,6609285,6609314,6609314,6609289,6609289,6609289,6609290,6609290,6609290,6623750,6623750,6623750,6623750,6623750,6623750,6623750,6609295,6609325,6609297,6609327,6609301,6609301,6609304,6609304,6609317,6609317,6609306,6609306,6609306,6609333,6609333,6609333,7525554,6609316,6609320,6609321,6609321,6609340,6609340,6623749,6623749,6623749,6623749,6623749,6623749,6623749,6623749,6623749,6609323,6609323,6609323,6609328,6609330,6609330,6609330,6623751,6623751,6623751,7593809,7593809,7593809,7593809,6609335,6609335,6609335,6609708,6609744,7362475,6609710,6609716,6609716,6609716,6609716,6609715,6609715,6609715,6609715,6609718,6609718,6609718,6609729,6609729,6609729,6609729,6609719,6609719,6609717,6609723,6609723,6609722,7362476,7362476,6609724,6609724,6609724,6609724,6609721,6609721,6609721,6609721,6609752,6609752,6609725,6609725,6609727,6609727,6609727,6609726,6609726,6609731,6609730,6609730,6609733,6609733,6609734,6609734,6609734,6609734,7548860,7548860,7548860,6625262,6625262,6625262,6625262,6625262,6625262,6625262,6625262,6609738,6609738,6609738,6609737,6609737,6609740,6609740,6609739,6609739,6609739,6609739,6609741,6609741,6609741,6609741,6609741,6609741,6609741,6609741,6609741,6609741,6609742,6609742,6609742,6609742,6609742,6609742,6609742,6609742,6609742,6609742,6609751,6609751,6609751,6609751,6609751,6609751,6609751,6609751,6609751,6609751,6609747,6609747,6609747,6609747,6609747,6609747,6609747,6609747,6609747,6609747,6609748,6609748,6609748,6609748,6609748,6609748,6609748,6609748,6609748,6609748,6609749,6609749,6609749,6609749,6609749,6609749,6609749,6609749,6609749,6609749,6609753,6609753,6609753,6609753,6609753,6609753,6609753,6609753,6609753,6609753,6609757,6609757,6609757,6609757,6609757,6609757,6609757,6609757,6609757,6609757,6609754,6609754,6609811,6609844,6609809,6609809,6609809,6609812,6609812,6609813,6609813,6609813,6609813,6609813,6609813,6609813,6609813,6609814,6609852,6609816,6609816,6609825,6609825,6609825,6609819,6609824,6609820,6609820,6609820,6609857,6665970,6609867,6609867,6609867,6609867,6609867,6609870,6609871,6609871,6609877,6609877,6609879,6609879,6609879,6609879,6609879,6609879,6609879,6609879,6609879,6609879,6609879,6609879,6609879,6609911,6609911,6609898,6609898,6609881,6609881,6661712,6661712,6661719,6661719,6661719,6661719,6661713,6661713,6661713,6661713,6015334,6015334,6015381,6015350,6015350,6015356,6015356,6015430,6015386,6015375,6438886,6015458,6015458,6015458,6015458,6015393,6015393,6015393,6015423,6015423,6015423,6015385,6438887,6438888,6438889,6015389,6535495,6535495,6015422,-1}'::integer[])))
  • Filter: ((deleted_at IS NULL) AND ((type)::text = 'LeaseTerm'::text))
24. 17.261 17.261 ↑ 1.0 1 1,501 / 2

Index Scan using index_property_meta_funds_on_property_meta_datum_id on property_meta_funds (cost=0.06..1.16 rows=1 width=17) (actual time=0.022..0.023 rows=1 loops=1,501)

  • Index Cond: (property_meta_datum_id = property_meta_asset_managers.property_meta_datum_id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1
25. 24.767 24.767 ↓ 0.0 0 1,501 / 2

Index Scan using index_property_meta_jv_partners_on_property_meta_datum_id on property_meta_jv_partners (cost=0.08..2.85 rows=1 width=25) (actual time=0.032..0.033 rows=0 loops=1,501)

  • Index Cond: (property_meta_datum_id = property_meta_funds.property_meta_datum_id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 2
Planning time : 26.896 ms
Execution time : 7,756.268 ms