%%{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
    PgSelect8[["PgSelect[8∈0] ➊<br />ᐸforumsᐳ"]]:::plan
    Object11{{"Object[11∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ"}}:::plan
    Lambda12[["Lambda[12∈0] ➊<br />ᐸincludeArchivedConditionᐳ"]]:::unbatchedplan
    Object11 & Lambda12 --> PgSelect8
    Access9{{"Access[9∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access10{{"Access[10∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access9 & Access10 --> Object11
    Connection23{{"Connection[23∈0] ➊<br />ᐸ19ᐳ"}}:::plan
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access9
    __Value2 --> Access10
    Constant43{{"Constant[43∈0] ➊<br />ᐸ'EXCLUSIVELY'ᐳ"}}:::plan
    Constant43 --> Lambda12
    PgSelectRows13[["PgSelectRows[13∈0] ➊"]]:::plan
    PgSelect8 --> PgSelectRows13
    Lambda25[["Lambda[25∈0] ➊<br />ᐸincludeArchivedConditionᐳ"]]:::unbatchedplan
    Constant44{{"Constant[44∈0] ➊<br />ᐸ'INHERIT'ᐳ"}}:::plan
    Constant44 --> Lambda25
    __Value4["__Value[4∈0] ➊<br />ᐸrootValueᐳ"]:::plan
    Constant26{{"Constant[26∈0] ➊<br />ᐸ[HIDDEN]ᐳ"}}:::plan
    Constant27{{"Constant[27∈0] ➊<br />ᐸtrueᐳ"}}:::plan
    __Item14[/"__Item[14∈1]<br />ᐸ13ᐳ"\]:::itemplan
    PgSelectRows13 ==> __Item14
    PgSelectSingle15{{"PgSelectSingle[15∈1]<br />ᐸforumsᐳ"}}:::plan
    __Item14 --> PgSelectSingle15
    PgClassExpression16{{"PgClassExpression[16∈2]<br />ᐸ__forums__.”name”ᐳ"}}:::plan
    PgSelectSingle15 --> PgClassExpression16
    PgSelect28[["PgSelect[28∈3@s]<br />ᐸmessagesᐳ"]]:::plan
    PgClassExpression18{{"PgClassExpression[18∈3]<br />ᐸ__forums__.”id”ᐳ"}}:::plan
    PgClassExpression24{{"PgClassExpression[24∈3]<br />ᐸ__forums__...chived_at”ᐳ"}}:::plan
    Object11 & PgClassExpression18 & PgClassExpression24 & Lambda25 & Connection23 --> PgSelect28
    PgSelectSingle15 --> PgClassExpression18
    PgSelectSingle15 --> PgClassExpression24
    PgSelectRows29[["PgSelectRows[29∈3@s]"]]:::plan
    PgSelect28 --> PgSelectRows29
    __Item30[/"__Item[30∈4]<br />ᐸ29ᐳ"\]:::itemplan
    PgSelectRows29 ==> __Item30
    PgSelectSingle31{{"PgSelectSingle[31∈4]<br />ᐸmessagesᐳ"}}:::plan
    __Item30 --> PgSelectSingle31
    PgSelect34[["PgSelect[34∈5]<br />ᐸusersᐳ"]]:::plan
    PgClassExpression33{{"PgClassExpression[33∈5]<br />ᐸ__messages...author_id”ᐳ"}}:::plan
    Object11 & PgClassExpression33 --> PgSelect34
    PgClassExpression32{{"PgClassExpression[32∈5]<br />ᐸ__messages__.”body”ᐳ"}}:::plan
    PgSelectSingle31 --> PgClassExpression32
    PgSelectSingle31 --> PgClassExpression33
    First38{{"First[38∈5]"}}:::plan
    PgSelectRows39[["PgSelectRows[39∈5]"]]:::plan
    PgSelectRows39 --> First38
    PgSelect34 --> PgSelectRows39
    PgSelectSingle40{{"PgSelectSingle[40∈5]<br />ᐸusersᐳ"}}:::plan
    First38 --> PgSelectSingle40
    PgClassExpression41{{"PgClassExpression[41∈6]<br />ᐸ__users__.”username”ᐳ"}}:::plan
    PgSelectSingle40 --> PgClassExpression41
    PgClassExpression42{{"PgClassExpression[42∈6]<br />ᐸ__users__....vatar_url”ᐳ"}}:::plan
    PgSelectSingle40 --> PgClassExpression42

    %% define steps

    subgraph "Buckets for queries/conditions/archived-forum-inherited-messages.stream-1"
    Bucket0("Bucket 0 (root)<br /><br />1: <br />ᐳ: 6, 9, 10, 26, 27, 43, 44, 11, 23<br />2: Lambda[12], Lambda[25]<br />3: PgSelect[8]<br />4: PgSelectRows[13]"):::bucket
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,__Value4,PgSelect8,Access9,Access10,Object11,Lambda12,PgSelectRows13,Connection23,Lambda25,Constant26,Constant27,Constant43,Constant44 bucket0
    Bucket1("Bucket 1 (listItem)<br />Deps: 11, 25, 23, 6, 26, 27<br /><br />ROOT __Item{1}ᐸ13ᐳ[14]"):::bucket
    classDef bucket1 stroke:#00bfff
    class Bucket1,__Item14,PgSelectSingle15 bucket1
    Bucket2("Bucket 2 (nullableBoundary)<br />Deps: 15, 11, 25, 23, 6, 26, 27<br /><br />ROOT PgSelectSingle{1}ᐸforumsᐳ[15]"):::bucket
    classDef bucket2 stroke:#7f007f
    class Bucket2,PgClassExpression16 bucket2
    Bucket3("Bucket 3 (nullableBoundary)<br />Deps: 15, 11, 25, 23, 6, 26, 27<br /><br />ROOT Connectionᐸ19ᐳ[23]<br />1: <br />ᐳ: 18, 24<br />2: PgSelect[28]<br />3: PgSelectRows[29]"):::bucket
    classDef bucket3 stroke:#ffa500
    class Bucket3,PgClassExpression18,PgClassExpression24,PgSelect28,PgSelectRows29 bucket3
    Bucket4("Bucket 4 (listItem)<br />Deps: 11<br /><br />ROOT __Item{4}ᐸ29ᐳ[30]"):::bucket
    classDef bucket4 stroke:#0000ff
    class Bucket4,__Item30,PgSelectSingle31 bucket4
    Bucket5("Bucket 5 (nullableBoundary)<br />Deps: 31, 11<br /><br />ROOT PgSelectSingle{4}ᐸmessagesᐳ[31]<br />1: <br />ᐳ: 32, 33<br />2: PgSelect[34]<br />3: PgSelectRows[39]<br />ᐳ: First[38], PgSelectSingle[40]"):::bucket
    classDef bucket5 stroke:#7fff00
    class Bucket5,PgClassExpression32,PgClassExpression33,PgSelect34,First38,PgSelectRows39,PgSelectSingle40 bucket5
    Bucket6("Bucket 6 (nullableBoundary)<br />Deps: 40<br /><br />ROOT PgSelectSingle{5}ᐸusersᐳ[40]"):::bucket
    classDef bucket6 stroke:#ff1493
    class Bucket6,PgClassExpression41,PgClassExpression42 bucket6
    Bucket0 --> Bucket1
    Bucket1 --> Bucket2
    Bucket2 --> Bucket3
    Bucket3 --> Bucket4
    Bucket4 --> Bucket5
    Bucket5 --> Bucket6
    end
