%%{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

    subgraph "Buckets for queries/conditions/archived-forum-inherited-messages.defer-2"
    Bucket0("Bucket 0 (root)<br /><br />1: PgSelectInlineApply[53]<br />ᐳ: 9, 10, 24, 59, 60, 11, 13, 28<br />2: PgSelect[8]<br />3: PgSelectRows[14]"):::bucket
    Bucket1("Bucket 1 (listItem)<br />Deps: 24, 11, 28, 53<br /><br />ROOT __Item{1}ᐸ14ᐳ[15]"):::bucket
    Bucket2("Bucket 2 (nullableBoundary)<br />Deps: 16, 24, 11, 28, 53<br /><br />ROOT PgSelectSingle{1}ᐸforumsᐳ[16]"):::bucket
    Bucket3("Bucket 3 (nullableBoundary)<br />Deps: 16, 24, 11, 28, 53<br /><br />ROOT Connectionᐸ20ᐳ[24]"):::bucket
    Bucket4("Bucket 4 (defer)<br />Deps: 11, 19, 25, 28, 24, 53<br /><br />1: PgSelect[29]<br />2: PgSelectRows[31]"):::bucket
    Bucket5("Bucket 5 (listItem)<br />Deps: 29<br /><br />ROOT __Item{5}ᐸ31ᐳ[32]"):::bucket
    Bucket6("Bucket 6 (nullableBoundary)<br />Deps: 33, 36, 54<br /><br />ROOT PgSelectSingle{5}ᐸmessagesᐳ[33]<br />1: <br />ᐳ: 35, 37, 55, 56<br />2: PgSelectRows[44]<br />ᐳ: First[43], PgSelectSingle[45]"):::bucket
    Bucket7("Bucket 7 (nullableBoundary)<br />Deps: 45<br /><br />ROOT PgSelectSingle{6}ᐸusersᐳ[45]"):::bucket
    end
    Bucket0 --> Bucket1
    Bucket1 --> Bucket2
    Bucket2 --> Bucket3
    Bucket3 --> Bucket4
    Bucket4 --> Bucket5
    Bucket5 --> Bucket6
    Bucket6 --> Bucket7

    %% plan dependencies
    PgSelect8[["PgSelect[8∈0] ➊<br />ᐸforumsᐳ<br />More deps:<br />- Object[11]"]]:::plan
    Lambda13{{"Lambda[13∈0] ➊<br />ᐸincludeArchivedConditionᐳ<br />More deps:<br />- Constantᐸ[ undefined, 'EXCLUSIVELY' ]ᐳ[59]"}}:::plan
    Lambda13 --> PgSelect8
    Object11{{"Object[11∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ<br />Dependents: 2"}}:::plan
    Access9{{"Access[9∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access10{{"Access[10∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access9 & Access10 --> Object11
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access9
    __Value2 --> Access10
    PgSelectRows14[["PgSelectRows[14∈0] ➊"]]:::plan
    PgSelect8 --> PgSelectRows14
    Lambda28{{"Lambda[28∈0] ➊<br />ᐸincludeArchivedConditionᐳ<br />More deps:<br />- Constantᐸ[HIDDEN]ᐳ[60]"}}:::plan
    Connection24{{"Connection[24∈0] ➊<br />ᐸ20ᐳ"}}:::plan
    PgSelectInlineApply53["PgSelectInlineApply[53∈0] ➊"]:::plan
    __Item15[/"__Item[15∈1]<br />ᐸ14ᐳ"\]:::itemplan
    PgSelectRows14 ==> __Item15
    PgSelectSingle16{{"PgSelectSingle[16∈1]<br />ᐸforumsᐳ"}}:::plan
    __Item15 --> PgSelectSingle16
    PgClassExpression17{{"PgClassExpression[17∈2]<br />ᐸ__forums__.”name”ᐳ"}}:::plan
    PgSelectSingle16 --> PgClassExpression17
    PgClassExpression19{{"PgClassExpression[19∈3]<br />ᐸ__forums__.”id”ᐳ"}}:::plan
    PgSelectSingle16 --> PgClassExpression19
    PgClassExpression25{{"PgClassExpression[25∈3]<br />ᐸ__forums__...chived_at”ᐳ"}}:::plan
    PgSelectSingle16 --> PgClassExpression25
    PgSelect29[["PgSelect[29∈4]<br />ᐸmessagesᐳ<br />More deps:<br />- Object[11]"]]:::plan
    PgClassExpression19 & PgClassExpression25 & Lambda28 & Connection24 & PgSelectInlineApply53 --> PgSelect29
    PgSelectRows31[["PgSelectRows[31∈4]"]]:::plan
    PgSelect29 --> PgSelectRows31
    __Item32[/"__Item[32∈5]<br />ᐸ31ᐳ"\]:::itemplan
    PgSelectRows31 ==> __Item32
    PgSelectSingle33{{"PgSelectSingle[33∈5]<br />ᐸmessagesᐳ"}}:::plan
    __Item32 --> PgSelectSingle33
    Access36{{"Access[36∈5]<br />ᐸ29.cursorDetailsᐳ"}}:::plan
    PgSelect29 --> Access36
    Access54{{"Access[54∈5]<br />ᐸ29.m.joinDetailsFor39ᐳ"}}:::plan
    PgSelect29 --> Access54
    PgCursor37{{"PgCursor[37∈6]"}}:::plan
    PgSelectSingle33 & Access36 --> PgCursor37
    List55{{"List[55∈6]<br />ᐸ54,33ᐳ"}}:::plan
    Access54 & PgSelectSingle33 --> List55
    PgClassExpression35{{"PgClassExpression[35∈6]<br />ᐸ__messages__.”body”ᐳ"}}:::plan
    PgSelectSingle33 --> PgClassExpression35
    First43{{"First[43∈6]"}}:::plan
    PgSelectRows44[["PgSelectRows[44∈6]"]]:::plan
    PgSelectRows44 --> First43
    Lambda56{{"Lambda[56∈6]<br />ᐸpgInlineViaJoinTransformᐳ"}}:::plan
    Lambda56 --> PgSelectRows44
    PgSelectSingle45{{"PgSelectSingle[45∈6]<br />ᐸusersᐳ"}}:::plan
    First43 --> PgSelectSingle45
    List55 --> Lambda56
    PgClassExpression46{{"PgClassExpression[46∈7]<br />ᐸ__users__.”username”ᐳ"}}:::plan
    PgSelectSingle45 --> PgClassExpression46
    PgClassExpression47{{"PgClassExpression[47∈7]<br />ᐸ__users__....vatar_url”ᐳ"}}:::plan
    PgSelectSingle45 --> PgClassExpression47

    %% define steps
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,PgSelect8,Access9,Access10,Object11,Lambda13,PgSelectRows14,Connection24,Lambda28,PgSelectInlineApply53 bucket0
    classDef bucket1 stroke:#00bfff
    class Bucket1,__Item15,PgSelectSingle16 bucket1
    classDef bucket2 stroke:#7f007f
    class Bucket2,PgClassExpression17 bucket2
    classDef bucket3 stroke:#ffa500
    class Bucket3,PgClassExpression19,PgClassExpression25 bucket3
    classDef bucket4 stroke:#0000ff
    class Bucket4,PgSelect29,PgSelectRows31 bucket4
    classDef bucket5 stroke:#7fff00
    class Bucket5,__Item32,PgSelectSingle33,Access36,Access54 bucket5
    classDef bucket6 stroke:#ff1493
    class Bucket6,PgClassExpression35,PgCursor37,First43,PgSelectRows44,PgSelectSingle45,List55,Lambda56 bucket6
    classDef bucket7 stroke:#808000
    class Bucket7,PgClassExpression46,PgClassExpression47 bucket7

