%%{init: {'themeVariables': { 'fontSize': '12px'}}}%%
graph TD
    classDef path fill:#eee,stroke:#000,color:#000
    classDef plan fill:#fff,stroke-width:1px,color:#000
    classDef itemplan fill:#fff,stroke-width:2px,color:#000
    classDef unbatchedplan fill:#dff,stroke-width:1px,color:#000
    classDef sideeffectplan fill:#fcc,stroke-width:2px,color:#000
    classDef bucket fill:#f6f6f6,color:#000,stroke-width:2px,text-align:left


    %% plan dependencies
    Connection13{{"Connection[13∈0] ➊<br />ᐸ9ᐳ"}}:::plan
    Constant6{{"Constant[6∈0] ➊<br />ᐸundefinedᐳ"}}:::plan
    Constant6 & Constant6 & Constant6 --> Connection13
    Connection46{{"Connection[46∈0] ➊<br />ᐸ42ᐳ"}}:::plan
    Constant6 & Constant6 & Constant6 --> Connection46
    Connection87{{"Connection[87∈0] ➊<br />ᐸ83ᐳ"}}:::plan
    Constant6 & Constant6 & Constant6 --> Connection87
    Connection128{{"Connection[128∈0] ➊<br />ᐸ124ᐳ"}}:::plan
    Constant6 & Constant6 & Constant6 --> Connection128
    Connection168{{"Connection[168∈0] ➊<br />ᐸ164ᐳ"}}:::plan
    Constant6 & Constant6 & Constant6 --> Connection168
    Connection205{{"Connection[205∈0] ➊<br />ᐸ201ᐳ"}}:::plan
    Constant6 & Constant6 & Constant6 --> Connection205
    Connection245{{"Connection[245∈0] ➊<br />ᐸ241ᐳ"}}:::plan
    Constant6 & Constant6 & Constant6 --> Connection245
    PgSelect258[["PgSelect[258∈0] ➊<br />ᐸhousesᐳ"]]:::plan
    Object12{{"Object[12∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ"}}:::plan
    Constant298{{"Constant[298∈0] ➊<br />ᐸ2ᐳ"}}:::plan
    Constant299{{"Constant[299∈0] ➊<br />ᐸ3ᐳ"}}:::plan
    Object12 & Constant298 & Constant299 --> PgSelect258
    PgSelect277[["PgSelect[277∈0] ➊<br />ᐸhousesᐳ"]]:::plan
    Access273{{"Access[273∈0] ➊<br />ᐸ272.1ᐳ"}}:::plan
    Access275{{"Access[275∈0] ➊<br />ᐸ272.2ᐳ"}}:::plan
    Object12 -->|rejectNull| PgSelect277
    Access273 -->|rejectNull| PgSelect277
    Access275 --> PgSelect277
    Access10{{"Access[10∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access11{{"Access[11∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access10 & Access11 --> Object12
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access10
    __Value2 --> Access11
    First260{{"First[260∈0] ➊"}}:::plan
    PgSelectRows261[["PgSelectRows[261∈0] ➊"]]:::plan
    PgSelectRows261 --> First260
    PgSelect258 --> PgSelectRows261
    PgSelectSingle262{{"PgSelectSingle[262∈0] ➊<br />ᐸhousesᐳ"}}:::plan
    First260 --> PgSelectSingle262
    Lambda272{{"Lambda[272∈0] ➊<br />ᐸspecifier_House_base64JSONᐳ"}}:::plan
    Constant300{{"Constant[300∈0] ➊<br />ᐸ'WyJob3VzZXMiLDIsM10='ᐳ"}}:::plan
    Constant300 --> Lambda272
    Lambda272 --> Access273
    Lambda272 --> Access275
    First279{{"First[279∈0] ➊"}}:::plan
    PgSelectRows280[["PgSelectRows[280∈0] ➊"]]:::plan
    PgSelectRows280 --> First279
    PgSelect277 --> PgSelectRows280
    PgSelectSingle281{{"PgSelectSingle[281∈0] ➊<br />ᐸhousesᐳ"}}:::plan
    First279 --> PgSelectSingle281
    __Value4["__Value[4∈0] ➊<br />ᐸrootValueᐳ"]:::plan
    Constant19{{"Constant[19∈0] ➊<br />ᐸ'houses'ᐳ"}}:::plan
    Constant35{{"Constant[35∈0] ➊<br />ᐸ'streets'ᐳ"}}:::plan
    Constant52{{"Constant[52∈0] ➊<br />ᐸ'buildings'ᐳ"}}:::plan
    Constant104{{"Constant[104∈0] ➊<br />ᐸ'properties'ᐳ"}}:::plan
    Constant302{{"Constant[302∈0] ➊<br />ᐸ[Function: applyInputConstant]ᐳ"}}:::plan
    Constant303{{"Constant[303∈0] ➊<br />ᐸ[Function: applyInputConstant]ᐳ"}}:::plan
    PgSelect15[["PgSelect[15∈1] ➊<br />ᐸhousesᐳ"]]:::plan
    Object12 & Constant302 & Connection13 & Constant6 & Constant6 & Constant6 --> PgSelect15
    PgSelectRows16[["PgSelectRows[16∈1] ➊"]]:::plan
    PgSelect15 --> PgSelectRows16
    __Item17[/"__Item[17∈2]<br />ᐸ16ᐳ"\]:::itemplan
    PgSelectRows16 ==> __Item17
    PgSelectSingle18{{"PgSelectSingle[18∈2]<br />ᐸhousesᐳ"}}:::plan
    __Item17 --> PgSelectSingle18
    List22{{"List[22∈3]<br />ᐸ19,20,21ᐳ"}}:::plan
    PgClassExpression20{{"PgClassExpression[20∈3]<br />ᐸ__houses__.”street_id”ᐳ"}}:::plan
    PgClassExpression21{{"PgClassExpression[21∈3]<br />ᐸ__houses__...operty_id”ᐳ"}}:::plan
    Constant19 & PgClassExpression20 & PgClassExpression21 --> List22
    PgSelect179[["PgSelect[179∈3]<br />ᐸstreet_propertyᐳ"]]:::plan
    Object12 & PgClassExpression20 & PgClassExpression21 --> PgSelect179
    PgSelect28[["PgSelect[28∈3]<br />ᐸstreetsᐳ"]]:::plan
    Object12 & PgClassExpression20 --> PgSelect28
    PgSelect57[["PgSelect[57∈3]<br />ᐸbuildingsᐳ"]]:::plan
    PgClassExpression27{{"PgClassExpression[27∈3]<br />ᐸ__houses__...ilding_id”ᐳ"}}:::plan
    Object12 & PgClassExpression27 --> PgSelect57
    PgSelect139[["PgSelect[139∈3]<br />ᐸpropertiesᐳ"]]:::plan
    Object12 & PgClassExpression21 --> PgSelect139
    PgSelectSingle18 --> PgClassExpression20
    PgSelectSingle18 --> PgClassExpression21
    Lambda23{{"Lambda[23∈3]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List22 --> Lambda23
    PgClassExpression24{{"PgClassExpression[24∈3]<br />ᐸ__houses__...ding_name”ᐳ"}}:::plan
    PgSelectSingle18 --> PgClassExpression24
    PgClassExpression25{{"PgClassExpression[25∈3]<br />ᐸ__houses__...or_number”ᐳ"}}:::plan
    PgSelectSingle18 --> PgClassExpression25
    PgClassExpression26{{"PgClassExpression[26∈3]<br />ᐸ__houses__...reet_name”ᐳ"}}:::plan
    PgSelectSingle18 --> PgClassExpression26
    PgSelectSingle18 --> PgClassExpression27
    First32{{"First[32∈3]"}}:::plan
    PgSelectRows33[["PgSelectRows[33∈3]"]]:::plan
    PgSelectRows33 --> First32
    PgSelect28 --> PgSelectRows33
    PgSelectSingle34{{"PgSelectSingle[34∈3]<br />ᐸstreetsᐳ"}}:::plan
    First32 --> PgSelectSingle34
    First59{{"First[59∈3]"}}:::plan
    PgSelectRows60[["PgSelectRows[60∈3]"]]:::plan
    PgSelectRows60 --> First59
    PgSelect57 --> PgSelectRows60
    PgSelectSingle61{{"PgSelectSingle[61∈3]<br />ᐸbuildingsᐳ"}}:::plan
    First59 --> PgSelectSingle61
    First141{{"First[141∈3]"}}:::plan
    PgSelectRows142[["PgSelectRows[142∈3]"]]:::plan
    PgSelectRows142 --> First141
    PgSelect139 --> PgSelectRows142
    PgSelectSingle143{{"PgSelectSingle[143∈3]<br />ᐸpropertiesᐳ"}}:::plan
    First141 --> PgSelectSingle143
    First181{{"First[181∈3]"}}:::plan
    PgSelectRows182[["PgSelectRows[182∈3]"]]:::plan
    PgSelectRows182 --> First181
    PgSelect179 --> PgSelectRows182
    PgSelectSingle183{{"PgSelectSingle[183∈3]<br />ᐸstreet_propertyᐳ"}}:::plan
    First181 --> PgSelectSingle183
    PgSelect48[["PgSelect[48∈4]<br />ᐸbuildingsᐳ"]]:::plan
    PgClassExpression39{{"PgClassExpression[39∈4]<br />ᐸ__streets__.”name”ᐳ"}}:::plan
    Object12 & PgClassExpression39 & Constant303 & Connection46 & Constant6 & Constant6 & Constant6 --> PgSelect48
    List37{{"List[37∈4]<br />ᐸ35,36ᐳ"}}:::plan
    PgClassExpression36{{"PgClassExpression[36∈4]<br />ᐸ__streets__.”id”ᐳ"}}:::plan
    Constant35 & PgClassExpression36 --> List37
    PgSelectSingle34 --> PgClassExpression36
    Lambda38{{"Lambda[38∈4]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List37 --> Lambda38
    PgSelectSingle34 --> PgClassExpression39
    PgSelectRows49[["PgSelectRows[49∈4]"]]:::plan
    PgSelect48 --> PgSelectRows49
    __Item50[/"__Item[50∈5]<br />ᐸ49ᐳ"\]:::itemplan
    PgSelectRows49 ==> __Item50
    PgSelectSingle51{{"PgSelectSingle[51∈5]<br />ᐸbuildingsᐳ"}}:::plan
    __Item50 --> PgSelectSingle51
    List54{{"List[54∈6]<br />ᐸ52,53ᐳ"}}:::plan
    PgClassExpression53{{"PgClassExpression[53∈6]<br />ᐸ__buildings__.”id”ᐳ"}}:::plan
    Constant52 & PgClassExpression53 --> List54
    PgSelectSingle51 --> PgClassExpression53
    Lambda55{{"Lambda[55∈6]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List54 --> Lambda55
    PgClassExpression56{{"PgClassExpression[56∈6]<br />ᐸ__buildings__.”name”ᐳ"}}:::plan
    PgSelectSingle51 --> PgClassExpression56
    List64{{"List[64∈7]<br />ᐸ52,63ᐳ"}}:::plan
    PgClassExpression63{{"PgClassExpression[63∈7]<br />ᐸ__buildings__.”id”ᐳ"}}:::plan
    Constant52 & PgClassExpression63 --> List64
    PgSelect69[["PgSelect[69∈7]<br />ᐸstreetsᐳ"]]:::plan
    PgClassExpression66{{"PgClassExpression[66∈7]<br />ᐸ__buildings__.”name”ᐳ"}}:::plan
    Object12 & PgClassExpression66 --> PgSelect69
    PgSelect99[["PgSelect[99∈7]<br />ᐸpropertiesᐳ"]]:::plan
    PgClassExpression98{{"PgClassExpression[98∈7]<br />ᐸ__building...operty_id”ᐳ"}}:::plan
    Object12 & PgClassExpression98 --> PgSelect99
    PgSelectSingle61 --> PgClassExpression63
    Lambda65{{"Lambda[65∈7]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List64 --> Lambda65
    PgSelectSingle61 --> PgClassExpression66
    PgClassExpression67{{"PgClassExpression[67∈7]<br />ᐸ__buildings__.”floors”ᐳ"}}:::plan
    PgSelectSingle61 --> PgClassExpression67
    PgClassExpression68{{"PgClassExpression[68∈7]<br />ᐸ__building...s_primary”ᐳ"}}:::plan
    PgSelectSingle61 --> PgClassExpression68
    First73{{"First[73∈7]"}}:::plan
    PgSelectRows74[["PgSelectRows[74∈7]"]]:::plan
    PgSelectRows74 --> First73
    PgSelect69 --> PgSelectRows74
    PgSelectSingle75{{"PgSelectSingle[75∈7]<br />ᐸstreetsᐳ"}}:::plan
    First73 --> PgSelectSingle75
    PgSelectSingle61 --> PgClassExpression98
    First101{{"First[101∈7]"}}:::plan
    PgSelectRows102[["PgSelectRows[102∈7]"]]:::plan
    PgSelectRows102 --> First101
    PgSelect99 --> PgSelectRows102
    PgSelectSingle103{{"PgSelectSingle[103∈7]<br />ᐸpropertiesᐳ"}}:::plan
    First101 --> PgSelectSingle103
    PgSelect89[["PgSelect[89∈8]<br />ᐸbuildingsᐳ"]]:::plan
    PgClassExpression80{{"PgClassExpression[80∈8]<br />ᐸ__streets__.”name”ᐳ"}}:::plan
    Object12 & PgClassExpression80 & Constant303 & Connection87 & Constant6 & Constant6 & Constant6 --> PgSelect89
    List78{{"List[78∈8]<br />ᐸ35,77ᐳ"}}:::plan
    PgClassExpression77{{"PgClassExpression[77∈8]<br />ᐸ__streets__.”id”ᐳ"}}:::plan
    Constant35 & PgClassExpression77 --> List78
    PgSelectSingle75 --> PgClassExpression77
    Lambda79{{"Lambda[79∈8]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List78 --> Lambda79
    PgSelectSingle75 --> PgClassExpression80
    PgSelectRows90[["PgSelectRows[90∈8]"]]:::plan
    PgSelect89 --> PgSelectRows90
    __Item91[/"__Item[91∈9]<br />ᐸ90ᐳ"\]:::itemplan
    PgSelectRows90 ==> __Item91
    PgSelectSingle92{{"PgSelectSingle[92∈9]<br />ᐸbuildingsᐳ"}}:::plan
    __Item91 --> PgSelectSingle92
    List95{{"List[95∈10]<br />ᐸ52,94ᐳ"}}:::plan
    PgClassExpression94{{"PgClassExpression[94∈10]<br />ᐸ__buildings__.”id”ᐳ"}}:::plan
    Constant52 & PgClassExpression94 --> List95
    PgSelectSingle92 --> PgClassExpression94
    Lambda96{{"Lambda[96∈10]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List95 --> Lambda96
    PgClassExpression97{{"PgClassExpression[97∈10]<br />ᐸ__buildings__.”name”ᐳ"}}:::plan
    PgSelectSingle92 --> PgClassExpression97
    List106{{"List[106∈11]<br />ᐸ104,105ᐳ"}}:::plan
    PgClassExpression105{{"PgClassExpression[105∈11]<br />ᐸ__properties__.”id”ᐳ"}}:::plan
    Constant104 & PgClassExpression105 --> List106
    PgSelect110[["PgSelect[110∈11]<br />ᐸstreetsᐳ"]]:::plan
    PgClassExpression108{{"PgClassExpression[108∈11]<br />ᐸ__properti...street_id”ᐳ"}}:::plan
    Object12 & PgClassExpression108 --> PgSelect110
    PgSelectSingle103 --> PgClassExpression105
    Lambda107{{"Lambda[107∈11]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List106 --> Lambda107
    PgSelectSingle103 --> PgClassExpression108
    PgClassExpression109{{"PgClassExpression[109∈11]<br />ᐸ__properti...or_number”ᐳ"}}:::plan
    PgSelectSingle103 --> PgClassExpression109
    First114{{"First[114∈11]"}}:::plan
    PgSelectRows115[["PgSelectRows[115∈11]"]]:::plan
    PgSelectRows115 --> First114
    PgSelect110 --> PgSelectRows115
    PgSelectSingle116{{"PgSelectSingle[116∈11]<br />ᐸstreetsᐳ"}}:::plan
    First114 --> PgSelectSingle116
    PgSelect130[["PgSelect[130∈12]<br />ᐸbuildingsᐳ"]]:::plan
    PgClassExpression121{{"PgClassExpression[121∈12]<br />ᐸ__streets__.”name”ᐳ"}}:::plan
    Object12 & PgClassExpression121 & Constant303 & Connection128 & Constant6 & Constant6 & Constant6 --> PgSelect130
    List119{{"List[119∈12]<br />ᐸ35,118ᐳ"}}:::plan
    PgClassExpression118{{"PgClassExpression[118∈12]<br />ᐸ__streets__.”id”ᐳ"}}:::plan
    Constant35 & PgClassExpression118 --> List119
    PgSelectSingle116 --> PgClassExpression118
    Lambda120{{"Lambda[120∈12]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List119 --> Lambda120
    PgSelectSingle116 --> PgClassExpression121
    PgSelectRows131[["PgSelectRows[131∈12]"]]:::plan
    PgSelect130 --> PgSelectRows131
    __Item132[/"__Item[132∈13]<br />ᐸ131ᐳ"\]:::itemplan
    PgSelectRows131 ==> __Item132
    PgSelectSingle133{{"PgSelectSingle[133∈13]<br />ᐸbuildingsᐳ"}}:::plan
    __Item132 --> PgSelectSingle133
    List136{{"List[136∈14]<br />ᐸ52,135ᐳ"}}:::plan
    PgClassExpression135{{"PgClassExpression[135∈14]<br />ᐸ__buildings__.”id”ᐳ"}}:::plan
    Constant52 & PgClassExpression135 --> List136
    PgSelectSingle133 --> PgClassExpression135
    Lambda137{{"Lambda[137∈14]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List136 --> Lambda137
    PgClassExpression138{{"PgClassExpression[138∈14]<br />ᐸ__buildings__.”name”ᐳ"}}:::plan
    PgSelectSingle133 --> PgClassExpression138
    List146{{"List[146∈15]<br />ᐸ104,145ᐳ"}}:::plan
    PgClassExpression145{{"PgClassExpression[145∈15]<br />ᐸ__properties__.”id”ᐳ"}}:::plan
    Constant104 & PgClassExpression145 --> List146
    PgSelect150[["PgSelect[150∈15]<br />ᐸstreetsᐳ"]]:::plan
    PgClassExpression148{{"PgClassExpression[148∈15]<br />ᐸ__properti...street_id”ᐳ"}}:::plan
    Object12 & PgClassExpression148 --> PgSelect150
    PgSelectSingle143 --> PgClassExpression145
    Lambda147{{"Lambda[147∈15]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List146 --> Lambda147
    PgSelectSingle143 --> PgClassExpression148
    PgClassExpression149{{"PgClassExpression[149∈15]<br />ᐸ__properti...or_number”ᐳ"}}:::plan
    PgSelectSingle143 --> PgClassExpression149
    First154{{"First[154∈15]"}}:::plan
    PgSelectRows155[["PgSelectRows[155∈15]"]]:::plan
    PgSelectRows155 --> First154
    PgSelect150 --> PgSelectRows155
    PgSelectSingle156{{"PgSelectSingle[156∈15]<br />ᐸstreetsᐳ"}}:::plan
    First154 --> PgSelectSingle156
    PgSelect170[["PgSelect[170∈16]<br />ᐸbuildingsᐳ"]]:::plan
    PgClassExpression161{{"PgClassExpression[161∈16]<br />ᐸ__streets__.”name”ᐳ"}}:::plan
    Object12 & PgClassExpression161 & Constant303 & Connection168 & Constant6 & Constant6 & Constant6 --> PgSelect170
    List159{{"List[159∈16]<br />ᐸ35,158ᐳ"}}:::plan
    PgClassExpression158{{"PgClassExpression[158∈16]<br />ᐸ__streets__.”id”ᐳ"}}:::plan
    Constant35 & PgClassExpression158 --> List159
    PgSelectSingle156 --> PgClassExpression158
    Lambda160{{"Lambda[160∈16]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List159 --> Lambda160
    PgSelectSingle156 --> PgClassExpression161
    PgSelectRows171[["PgSelectRows[171∈16]"]]:::plan
    PgSelect170 --> PgSelectRows171
    __Item172[/"__Item[172∈17]<br />ᐸ171ᐳ"\]:::itemplan
    PgSelectRows171 ==> __Item172
    PgSelectSingle173{{"PgSelectSingle[173∈17]<br />ᐸbuildingsᐳ"}}:::plan
    __Item172 --> PgSelectSingle173
    List176{{"List[176∈18]<br />ᐸ52,175ᐳ"}}:::plan
    PgClassExpression175{{"PgClassExpression[175∈18]<br />ᐸ__buildings__.”id”ᐳ"}}:::plan
    Constant52 & PgClassExpression175 --> List176
    PgSelectSingle173 --> PgClassExpression175
    Lambda177{{"Lambda[177∈18]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List176 --> Lambda177
    PgClassExpression178{{"PgClassExpression[178∈18]<br />ᐸ__buildings__.”name”ᐳ"}}:::plan
    PgSelectSingle173 --> PgClassExpression178
    PgSelect187[["PgSelect[187∈19]<br />ᐸstreetsᐳ"]]:::plan
    PgClassExpression184{{"PgClassExpression[184∈19]<br />ᐸ__street_p..._.”str_id”ᐳ"}}:::plan
    Object12 & PgClassExpression184 --> PgSelect187
    PgSelect216[["PgSelect[216∈19]<br />ᐸpropertiesᐳ"]]:::plan
    PgClassExpression185{{"PgClassExpression[185∈19]<br />ᐸ__street_p....”prop_id”ᐳ"}}:::plan
    Object12 & PgClassExpression185 --> PgSelect216
    PgSelectSingle183 --> PgClassExpression184
    PgSelectSingle183 --> PgClassExpression185
    PgClassExpression186{{"PgClassExpression[186∈19]<br />ᐸ__street_p...ent_owner”ᐳ"}}:::plan
    PgSelectSingle183 --> PgClassExpression186
    First191{{"First[191∈19]"}}:::plan
    PgSelectRows192[["PgSelectRows[192∈19]"]]:::plan
    PgSelectRows192 --> First191
    PgSelect187 --> PgSelectRows192
    PgSelectSingle193{{"PgSelectSingle[193∈19]<br />ᐸstreetsᐳ"}}:::plan
    First191 --> PgSelectSingle193
    First218{{"First[218∈19]"}}:::plan
    PgSelectRows219[["PgSelectRows[219∈19]"]]:::plan
    PgSelectRows219 --> First218
    PgSelect216 --> PgSelectRows219
    PgSelectSingle220{{"PgSelectSingle[220∈19]<br />ᐸpropertiesᐳ"}}:::plan
    First218 --> PgSelectSingle220
    PgSelect207[["PgSelect[207∈20]<br />ᐸbuildingsᐳ"]]:::plan
    PgClassExpression198{{"PgClassExpression[198∈20]<br />ᐸ__streets__.”name”ᐳ"}}:::plan
    Object12 & PgClassExpression198 & Constant303 & Connection205 & Constant6 & Constant6 & Constant6 --> PgSelect207
    List196{{"List[196∈20]<br />ᐸ35,195ᐳ"}}:::plan
    PgClassExpression195{{"PgClassExpression[195∈20]<br />ᐸ__streets__.”id”ᐳ"}}:::plan
    Constant35 & PgClassExpression195 --> List196
    PgSelectSingle193 --> PgClassExpression195
    Lambda197{{"Lambda[197∈20]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List196 --> Lambda197
    PgSelectSingle193 --> PgClassExpression198
    PgSelectRows208[["PgSelectRows[208∈20]"]]:::plan
    PgSelect207 --> PgSelectRows208
    __Item209[/"__Item[209∈21]<br />ᐸ208ᐳ"\]:::itemplan
    PgSelectRows208 ==> __Item209
    PgSelectSingle210{{"PgSelectSingle[210∈21]<br />ᐸbuildingsᐳ"}}:::plan
    __Item209 --> PgSelectSingle210
    List213{{"List[213∈22]<br />ᐸ52,212ᐳ"}}:::plan
    PgClassExpression212{{"PgClassExpression[212∈22]<br />ᐸ__buildings__.”id”ᐳ"}}:::plan
    Constant52 & PgClassExpression212 --> List213
    PgSelectSingle210 --> PgClassExpression212
    Lambda214{{"Lambda[214∈22]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List213 --> Lambda214
    PgClassExpression215{{"PgClassExpression[215∈22]<br />ᐸ__buildings__.”name”ᐳ"}}:::plan
    PgSelectSingle210 --> PgClassExpression215
    List223{{"List[223∈23]<br />ᐸ104,222ᐳ"}}:::plan
    PgClassExpression222{{"PgClassExpression[222∈23]<br />ᐸ__properties__.”id”ᐳ"}}:::plan
    Constant104 & PgClassExpression222 --> List223
    PgSelect227[["PgSelect[227∈23]<br />ᐸstreetsᐳ"]]:::plan
    PgClassExpression225{{"PgClassExpression[225∈23]<br />ᐸ__properti...street_id”ᐳ"}}:::plan
    Object12 & PgClassExpression225 --> PgSelect227
    PgSelectSingle220 --> PgClassExpression222
    Lambda224{{"Lambda[224∈23]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List223 --> Lambda224
    PgSelectSingle220 --> PgClassExpression225
    PgClassExpression226{{"PgClassExpression[226∈23]<br />ᐸ__properti...or_number”ᐳ"}}:::plan
    PgSelectSingle220 --> PgClassExpression226
    First231{{"First[231∈23]"}}:::plan
    PgSelectRows232[["PgSelectRows[232∈23]"]]:::plan
    PgSelectRows232 --> First231
    PgSelect227 --> PgSelectRows232
    PgSelectSingle233{{"PgSelectSingle[233∈23]<br />ᐸstreetsᐳ"}}:::plan
    First231 --> PgSelectSingle233
    PgSelect247[["PgSelect[247∈24]<br />ᐸbuildingsᐳ"]]:::plan
    PgClassExpression238{{"PgClassExpression[238∈24]<br />ᐸ__streets__.”name”ᐳ"}}:::plan
    Object12 & PgClassExpression238 & Constant303 & Connection245 & Constant6 & Constant6 & Constant6 --> PgSelect247
    List236{{"List[236∈24]<br />ᐸ35,235ᐳ"}}:::plan
    PgClassExpression235{{"PgClassExpression[235∈24]<br />ᐸ__streets__.”id”ᐳ"}}:::plan
    Constant35 & PgClassExpression235 --> List236
    PgSelectSingle233 --> PgClassExpression235
    Lambda237{{"Lambda[237∈24]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List236 --> Lambda237
    PgSelectSingle233 --> PgClassExpression238
    PgSelectRows248[["PgSelectRows[248∈24]"]]:::plan
    PgSelect247 --> PgSelectRows248
    __Item249[/"__Item[249∈25]<br />ᐸ248ᐳ"\]:::itemplan
    PgSelectRows248 ==> __Item249
    PgSelectSingle250{{"PgSelectSingle[250∈25]<br />ᐸbuildingsᐳ"}}:::plan
    __Item249 --> PgSelectSingle250
    List253{{"List[253∈26]<br />ᐸ52,252ᐳ"}}:::plan
    PgClassExpression252{{"PgClassExpression[252∈26]<br />ᐸ__buildings__.”id”ᐳ"}}:::plan
    Constant52 & PgClassExpression252 --> List253
    PgSelectSingle250 --> PgClassExpression252
    Lambda254{{"Lambda[254∈26]<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List253 --> Lambda254
    PgClassExpression255{{"PgClassExpression[255∈26]<br />ᐸ__buildings__.”name”ᐳ"}}:::plan
    PgSelectSingle250 --> PgClassExpression255
    List269{{"List[269∈27] ➊<br />ᐸ19,267,268ᐳ"}}:::plan
    PgClassExpression267{{"PgClassExpression[267∈27] ➊<br />ᐸ__houses__.”street_id”ᐳ"}}:::plan
    PgClassExpression268{{"PgClassExpression[268∈27] ➊<br />ᐸ__houses__...operty_id”ᐳ"}}:::plan
    Constant19 & PgClassExpression267 & PgClassExpression268 --> List269
    PgClassExpression263{{"PgClassExpression[263∈27] ➊<br />ᐸ__houses__...ding_name”ᐳ"}}:::plan
    PgSelectSingle262 --> PgClassExpression263
    PgClassExpression264{{"PgClassExpression[264∈27] ➊<br />ᐸ__houses__...or_number”ᐳ"}}:::plan
    PgSelectSingle262 --> PgClassExpression264
    PgClassExpression265{{"PgClassExpression[265∈27] ➊<br />ᐸ__houses__...reet_name”ᐳ"}}:::plan
    PgSelectSingle262 --> PgClassExpression265
    PgSelectSingle262 --> PgClassExpression267
    PgSelectSingle262 --> PgClassExpression268
    Lambda270{{"Lambda[270∈27] ➊<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List269 --> Lambda270
    List288{{"List[288∈28] ➊<br />ᐸ19,286,287ᐳ"}}:::plan
    PgClassExpression286{{"PgClassExpression[286∈28] ➊<br />ᐸ__houses__.”street_id”ᐳ"}}:::plan
    PgClassExpression287{{"PgClassExpression[287∈28] ➊<br />ᐸ__houses__...operty_id”ᐳ"}}:::plan
    Constant19 & PgClassExpression286 & PgClassExpression287 --> List288
    PgClassExpression282{{"PgClassExpression[282∈28] ➊<br />ᐸ__houses__...ding_name”ᐳ"}}:::plan
    PgSelectSingle281 --> PgClassExpression282
    PgClassExpression283{{"PgClassExpression[283∈28] ➊<br />ᐸ__houses__...or_number”ᐳ"}}:::plan
    PgSelectSingle281 --> PgClassExpression283
    PgClassExpression284{{"PgClassExpression[284∈28] ➊<br />ᐸ__houses__...reet_name”ᐳ"}}:::plan
    PgSelectSingle281 --> PgClassExpression284
    PgSelectSingle281 --> PgClassExpression286
    PgSelectSingle281 --> PgClassExpression287
    Lambda289{{"Lambda[289∈28] ➊<br />ᐸbase64JSONEncodeᐳ"}}:::plan
    List288 --> Lambda289

    %% define steps

    subgraph "Buckets for queries/v4/smart_comment_relations.houses"
    Bucket0("Bucket 0 (root)<br /><br />1: <br />ᐳ: 6, 10, 11, 19, 35, 52, 104, 298, 299, 300, 302, 303, 12, 13, 46, 87, 128, 168, 205, 245, 272, 273, 275<br />2: PgSelect[258], PgSelect[277]<br />3: PgSelectRows[261], PgSelectRows[280]<br />ᐳ: 260, 262, 279, 281"):::bucket
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,__Value4,Constant6,Access10,Access11,Object12,Connection13,Constant19,Constant35,Connection46,Constant52,Connection87,Constant104,Connection128,Connection168,Connection205,Connection245,PgSelect258,First260,PgSelectRows261,PgSelectSingle262,Lambda272,Access273,Access275,PgSelect277,First279,PgSelectRows280,PgSelectSingle281,Constant298,Constant299,Constant300,Constant302,Constant303 bucket0
    Bucket1("Bucket 1 (nullableBoundary)<br />Deps: 12, 302, 13, 6, 19, 35, 303, 46, 52, 87, 104, 128, 168, 205, 245<br /><br />ROOT Connectionᐸ9ᐳ[13]<br />1: PgSelect[15]<br />2: PgSelectRows[16]"):::bucket
    classDef bucket1 stroke:#00bfff
    class Bucket1,PgSelect15,PgSelectRows16 bucket1
    Bucket2("Bucket 2 (listItem)<br />Deps: 19, 12, 35, 303, 46, 6, 52, 87, 104, 128, 168, 205, 245<br /><br />ROOT __Item{2}ᐸ16ᐳ[17]"):::bucket
    classDef bucket2 stroke:#7f007f
    class Bucket2,__Item17,PgSelectSingle18 bucket2
    Bucket3("Bucket 3 (nullableBoundary)<br />Deps: 18, 19, 12, 35, 303, 46, 6, 52, 87, 104, 128, 168, 205, 245<br /><br />ROOT PgSelectSingle{2}ᐸhousesᐳ[18]<br />1: <br />ᐳ: 20, 21, 24, 25, 26, 27, 22, 23<br />2: 28, 57, 139, 179<br />3: 33, 60, 142, 182<br />ᐳ: 32, 34, 59, 61, 141, 143, 181, 183"):::bucket
    classDef bucket3 stroke:#ffa500
    class Bucket3,PgClassExpression20,PgClassExpression21,List22,Lambda23,PgClassExpression24,PgClassExpression25,PgClassExpression26,PgClassExpression27,PgSelect28,First32,PgSelectRows33,PgSelectSingle34,PgSelect57,First59,PgSelectRows60,PgSelectSingle61,PgSelect139,First141,PgSelectRows142,PgSelectSingle143,PgSelect179,First181,PgSelectRows182,PgSelectSingle183 bucket3
    Bucket4("Bucket 4 (nullableBoundary)<br />Deps: 34, 35, 12, 303, 46, 6, 52<br /><br />ROOT PgSelectSingle{3}ᐸstreetsᐳ[34]<br />1: <br />ᐳ: 36, 39, 37, 38<br />2: PgSelect[48]<br />3: PgSelectRows[49]"):::bucket
    classDef bucket4 stroke:#0000ff
    class Bucket4,PgClassExpression36,List37,Lambda38,PgClassExpression39,PgSelect48,PgSelectRows49 bucket4
    Bucket5("Bucket 5 (listItem)<br />Deps: 52<br /><br />ROOT __Item{5}ᐸ49ᐳ[50]"):::bucket
    classDef bucket5 stroke:#7fff00
    class Bucket5,__Item50,PgSelectSingle51 bucket5
    Bucket6("Bucket 6 (nullableBoundary)<br />Deps: 51, 52<br /><br />ROOT PgSelectSingle{5}ᐸbuildingsᐳ[51]"):::bucket
    classDef bucket6 stroke:#ff1493
    class Bucket6,PgClassExpression53,List54,Lambda55,PgClassExpression56 bucket6
    Bucket7("Bucket 7 (nullableBoundary)<br />Deps: 61, 52, 12, 35, 303, 87, 6, 104, 128<br /><br />ROOT PgSelectSingle{3}ᐸbuildingsᐳ[61]<br />1: <br />ᐳ: 63, 66, 67, 68, 98, 64, 65<br />2: PgSelect[69], PgSelect[99]<br />3: PgSelectRows[74], PgSelectRows[102]<br />ᐳ: 73, 75, 101, 103"):::bucket
    classDef bucket7 stroke:#808000
    class Bucket7,PgClassExpression63,List64,Lambda65,PgClassExpression66,PgClassExpression67,PgClassExpression68,PgSelect69,First73,PgSelectRows74,PgSelectSingle75,PgClassExpression98,PgSelect99,First101,PgSelectRows102,PgSelectSingle103 bucket7
    Bucket8("Bucket 8 (nullableBoundary)<br />Deps: 75, 35, 12, 303, 87, 6, 52<br /><br />ROOT PgSelectSingle{7}ᐸstreetsᐳ[75]<br />1: <br />ᐳ: 77, 80, 78, 79<br />2: PgSelect[89]<br />3: PgSelectRows[90]"):::bucket
    classDef bucket8 stroke:#dda0dd
    class Bucket8,PgClassExpression77,List78,Lambda79,PgClassExpression80,PgSelect89,PgSelectRows90 bucket8
    Bucket9("Bucket 9 (listItem)<br />Deps: 52<br /><br />ROOT __Item{9}ᐸ90ᐳ[91]"):::bucket
    classDef bucket9 stroke:#ff0000
    class Bucket9,__Item91,PgSelectSingle92 bucket9
    Bucket10("Bucket 10 (nullableBoundary)<br />Deps: 92, 52<br /><br />ROOT PgSelectSingle{9}ᐸbuildingsᐳ[92]"):::bucket
    classDef bucket10 stroke:#ffff00
    class Bucket10,PgClassExpression94,List95,Lambda96,PgClassExpression97 bucket10
    Bucket11("Bucket 11 (nullableBoundary)<br />Deps: 103, 104, 12, 35, 303, 128, 6, 52<br /><br />ROOT PgSelectSingle{7}ᐸpropertiesᐳ[103]<br />1: <br />ᐳ: 105, 108, 109, 106, 107<br />2: PgSelect[110]<br />3: PgSelectRows[115]<br />ᐳ: First[114], PgSelectSingle[116]"):::bucket
    classDef bucket11 stroke:#00ffff
    class Bucket11,PgClassExpression105,List106,Lambda107,PgClassExpression108,PgClassExpression109,PgSelect110,First114,PgSelectRows115,PgSelectSingle116 bucket11
    Bucket12("Bucket 12 (nullableBoundary)<br />Deps: 116, 35, 12, 303, 128, 6, 52<br /><br />ROOT PgSelectSingle{11}ᐸstreetsᐳ[116]<br />1: <br />ᐳ: 118, 121, 119, 120<br />2: PgSelect[130]<br />3: PgSelectRows[131]"):::bucket
    classDef bucket12 stroke:#4169e1
    class Bucket12,PgClassExpression118,List119,Lambda120,PgClassExpression121,PgSelect130,PgSelectRows131 bucket12
    Bucket13("Bucket 13 (listItem)<br />Deps: 52<br /><br />ROOT __Item{13}ᐸ131ᐳ[132]"):::bucket
    classDef bucket13 stroke:#3cb371
    class Bucket13,__Item132,PgSelectSingle133 bucket13
    Bucket14("Bucket 14 (nullableBoundary)<br />Deps: 133, 52<br /><br />ROOT PgSelectSingle{13}ᐸbuildingsᐳ[133]"):::bucket
    classDef bucket14 stroke:#a52a2a
    class Bucket14,PgClassExpression135,List136,Lambda137,PgClassExpression138 bucket14
    Bucket15("Bucket 15 (nullableBoundary)<br />Deps: 143, 104, 12, 35, 303, 168, 6, 52<br /><br />ROOT PgSelectSingle{3}ᐸpropertiesᐳ[143]<br />1: <br />ᐳ: 145, 148, 149, 146, 147<br />2: PgSelect[150]<br />3: PgSelectRows[155]<br />ᐳ: First[154], PgSelectSingle[156]"):::bucket
    classDef bucket15 stroke:#ff00ff
    class Bucket15,PgClassExpression145,List146,Lambda147,PgClassExpression148,PgClassExpression149,PgSelect150,First154,PgSelectRows155,PgSelectSingle156 bucket15
    Bucket16("Bucket 16 (nullableBoundary)<br />Deps: 156, 35, 12, 303, 168, 6, 52<br /><br />ROOT PgSelectSingle{15}ᐸstreetsᐳ[156]<br />1: <br />ᐳ: 158, 161, 159, 160<br />2: PgSelect[170]<br />3: PgSelectRows[171]"):::bucket
    classDef bucket16 stroke:#f5deb3
    class Bucket16,PgClassExpression158,List159,Lambda160,PgClassExpression161,PgSelect170,PgSelectRows171 bucket16
    Bucket17("Bucket 17 (listItem)<br />Deps: 52<br /><br />ROOT __Item{17}ᐸ171ᐳ[172]"):::bucket
    classDef bucket17 stroke:#696969
    class Bucket17,__Item172,PgSelectSingle173 bucket17
    Bucket18("Bucket 18 (nullableBoundary)<br />Deps: 173, 52<br /><br />ROOT PgSelectSingle{17}ᐸbuildingsᐳ[173]"):::bucket
    classDef bucket18 stroke:#00bfff
    class Bucket18,PgClassExpression175,List176,Lambda177,PgClassExpression178 bucket18
    Bucket19("Bucket 19 (nullableBoundary)<br />Deps: 183, 12, 35, 303, 205, 6, 52, 104, 245<br /><br />ROOT PgSelectSingle{3}ᐸstreet_propertyᐳ[183]<br />1: <br />ᐳ: 184, 185, 186<br />2: PgSelect[187], PgSelect[216]<br />3: PgSelectRows[192], PgSelectRows[219]<br />ᐳ: 191, 193, 218, 220"):::bucket
    classDef bucket19 stroke:#7f007f
    class Bucket19,PgClassExpression184,PgClassExpression185,PgClassExpression186,PgSelect187,First191,PgSelectRows192,PgSelectSingle193,PgSelect216,First218,PgSelectRows219,PgSelectSingle220 bucket19
    Bucket20("Bucket 20 (nullableBoundary)<br />Deps: 193, 35, 12, 303, 205, 6, 52<br /><br />ROOT PgSelectSingle{19}ᐸstreetsᐳ[193]<br />1: <br />ᐳ: 195, 198, 196, 197<br />2: PgSelect[207]<br />3: PgSelectRows[208]"):::bucket
    classDef bucket20 stroke:#ffa500
    class Bucket20,PgClassExpression195,List196,Lambda197,PgClassExpression198,PgSelect207,PgSelectRows208 bucket20
    Bucket21("Bucket 21 (listItem)<br />Deps: 52<br /><br />ROOT __Item{21}ᐸ208ᐳ[209]"):::bucket
    classDef bucket21 stroke:#0000ff
    class Bucket21,__Item209,PgSelectSingle210 bucket21
    Bucket22("Bucket 22 (nullableBoundary)<br />Deps: 210, 52<br /><br />ROOT PgSelectSingle{21}ᐸbuildingsᐳ[210]"):::bucket
    classDef bucket22 stroke:#7fff00
    class Bucket22,PgClassExpression212,List213,Lambda214,PgClassExpression215 bucket22
    Bucket23("Bucket 23 (nullableBoundary)<br />Deps: 220, 104, 12, 35, 303, 245, 6, 52<br /><br />ROOT PgSelectSingle{19}ᐸpropertiesᐳ[220]<br />1: <br />ᐳ: 222, 225, 226, 223, 224<br />2: PgSelect[227]<br />3: PgSelectRows[232]<br />ᐳ: First[231], PgSelectSingle[233]"):::bucket
    classDef bucket23 stroke:#ff1493
    class Bucket23,PgClassExpression222,List223,Lambda224,PgClassExpression225,PgClassExpression226,PgSelect227,First231,PgSelectRows232,PgSelectSingle233 bucket23
    Bucket24("Bucket 24 (nullableBoundary)<br />Deps: 233, 35, 12, 303, 245, 6, 52<br /><br />ROOT PgSelectSingle{23}ᐸstreetsᐳ[233]<br />1: <br />ᐳ: 235, 238, 236, 237<br />2: PgSelect[247]<br />3: PgSelectRows[248]"):::bucket
    classDef bucket24 stroke:#808000
    class Bucket24,PgClassExpression235,List236,Lambda237,PgClassExpression238,PgSelect247,PgSelectRows248 bucket24
    Bucket25("Bucket 25 (listItem)<br />Deps: 52<br /><br />ROOT __Item{25}ᐸ248ᐳ[249]"):::bucket
    classDef bucket25 stroke:#dda0dd
    class Bucket25,__Item249,PgSelectSingle250 bucket25
    Bucket26("Bucket 26 (nullableBoundary)<br />Deps: 250, 52<br /><br />ROOT PgSelectSingle{25}ᐸbuildingsᐳ[250]"):::bucket
    classDef bucket26 stroke:#ff0000
    class Bucket26,PgClassExpression252,List253,Lambda254,PgClassExpression255 bucket26
    Bucket27("Bucket 27 (nullableBoundary)<br />Deps: 262, 19<br /><br />ROOT PgSelectSingleᐸhousesᐳ[262]"):::bucket
    classDef bucket27 stroke:#ffff00
    class Bucket27,PgClassExpression263,PgClassExpression264,PgClassExpression265,PgClassExpression267,PgClassExpression268,List269,Lambda270 bucket27
    Bucket28("Bucket 28 (nullableBoundary)<br />Deps: 281, 19<br /><br />ROOT PgSelectSingleᐸhousesᐳ[281]"):::bucket
    classDef bucket28 stroke:#00ffff
    class Bucket28,PgClassExpression282,PgClassExpression283,PgClassExpression284,PgClassExpression286,PgClassExpression287,List288,Lambda289 bucket28
    Bucket0 --> Bucket1 & Bucket27 & Bucket28
    Bucket1 --> Bucket2
    Bucket2 --> Bucket3
    Bucket3 --> Bucket4 & Bucket7 & Bucket15 & Bucket19
    Bucket4 --> Bucket5
    Bucket5 --> Bucket6
    Bucket7 --> Bucket8 & Bucket11
    Bucket8 --> Bucket9
    Bucket9 --> Bucket10
    Bucket11 --> Bucket12
    Bucket12 --> Bucket13
    Bucket13 --> Bucket14
    Bucket15 --> Bucket16
    Bucket16 --> Bucket17
    Bucket17 --> Bucket18
    Bucket19 --> Bucket20 & Bucket23
    Bucket20 --> Bucket21
    Bucket21 --> Bucket22
    Bucket23 --> Bucket24
    Bucket24 --> Bucket25
    Bucket25 --> Bucket26
    end
