%%{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
    Object14{{"Object[14∈0]<br />ᐸ{pgSettings,withPgClient}ᐳ"}}:::plan
    Access12{{"Access[12∈0]<br />ᐸ3.pgSettingsᐳ"}}:::plan
    Access13{{"Access[13∈0]<br />ᐸ3.withPgClientᐳ"}}:::plan
    Access12 & Access13 --> Object14
    __Value3["__Value[3∈0]<br />ᐸcontextᐳ"]:::plan
    __Value3 --> Access12
    __Value3 --> Access13
    PgSelect11[["PgSelect[11∈0]<br />ᐸforumsᐳ"]]:::plan
    Object14 --> PgSelect11
    Connection28{{"Connection[28∈0]<br />ᐸ24ᐳ"}}:::plan
    Constant84{{"Constant[84∈0]<br />ᐸ5ᐳ"}}:::plan
    Constant84 --> Connection28
    __Value0["__Value[0∈0]"]:::plan
    __Value5["__Value[5∈0]<br />ᐸrootValueᐳ"]:::plan
    __Item15[/"__Item[15∈1]<br />ᐸ11ᐳ"\]:::itemplan
    PgSelect11 ==> __Item15
    PgSelectSingle16{{"PgSelectSingle[16∈1]<br />ᐸforumsᐳ"}}:::plan
    __Item15 --> PgSelectSingle16
    Constant60{{"Constant[60∈1]<br />ᐸfalseᐳ"}}:::plan
    PgClassExpression17{{"PgClassExpression[17∈2]<br />ᐸ__forums__.”name”ᐳ"}}:::plan
    PgSelectSingle16 --> PgClassExpression17
    Access81{{"Access[81∈3]<br />ᐸ15.1ᐳ"}}:::plan
    __Item15 --> Access81
    Lambda82{{"Lambda[82∈3]"}}:::plan
    Access81 --> Lambda82
    PgPageInfo57{{"PgPageInfo[57∈3]"}}:::plan
    Connection28 --> PgPageInfo57
    Lambda59{{"Lambda[59∈3]<br />ᐸlistHasMoreᐳ"}}:::plan
    Lambda82 --> Lambda59
    First62{{"First[62∈3]"}}:::plan
    Lambda82 --> First62
    PgSelectSingle63{{"PgSelectSingle[63∈3]<br />ᐸmessagesᐳ"}}:::plan
    First62 --> PgSelectSingle63
    PgClassExpression65{{"PgClassExpression[65∈3]<br />ᐸ__messages__.”id”ᐳ"}}:::plan
    PgSelectSingle63 --> PgClassExpression65
    List66{{"List[66∈3]<br />ᐸ65ᐳ"}}:::plan
    PgClassExpression65 --> List66
    PgCursor64{{"PgCursor[64∈3]"}}:::plan
    List66 --> PgCursor64
    Last68{{"Last[68∈3]"}}:::plan
    Lambda82 --> Last68
    PgSelectSingle69{{"PgSelectSingle[69∈3]<br />ᐸmessagesᐳ"}}:::plan
    Last68 --> PgSelectSingle69
    PgClassExpression71{{"PgClassExpression[71∈3]<br />ᐸ__messages__.”id”ᐳ"}}:::plan
    PgSelectSingle69 --> PgClassExpression71
    List72{{"List[72∈3]<br />ᐸ71ᐳ"}}:::plan
    PgClassExpression71 --> List72
    PgCursor70{{"PgCursor[70∈3]"}}:::plan
    List72 --> PgCursor70
    Access83{{"Access[83∈3]<br />ᐸ15.2ᐳ"}}:::plan
    __Item15 --> Access83
    First74{{"First[74∈3]"}}:::plan
    Access83 --> First74
    PgSelectSingle75{{"PgSelectSingle[75∈3]<br />ᐸmessagesᐳ"}}:::plan
    First74 --> PgSelectSingle75
    PgClassExpression76{{"PgClassExpression[76∈3]<br />ᐸcount(*)ᐳ"}}:::plan
    PgSelectSingle75 --> PgClassExpression76
    __Item30[/"__Item[30∈4]<br />ᐸ82ᐳ"\]:::itemplan
    Lambda82 ==> __Item30
    PgSelectSingle31{{"PgSelectSingle[31∈4]<br />ᐸmessagesᐳ"}}:::plan
    __Item30 --> PgSelectSingle31
    PgClassExpression45{{"PgClassExpression[45∈7]<br />ᐸ__messages__.”id”ᐳ"}}:::plan
    PgSelectSingle31 --> PgClassExpression45
    List46{{"List[46∈7]<br />ᐸ45ᐳ"}}:::plan
    PgClassExpression45 --> List46
    PgCursor44{{"PgCursor[44∈7]"}}:::plan
    List46 --> PgCursor44
    PgClassExpression47{{"PgClassExpression[47∈7]<br />ᐸ__messages__.”body”ᐳ"}}:::plan
    PgSelectSingle31 --> PgClassExpression47
    RemapKeys79{{"RemapKeys[79∈7]<br />ᐸ31:{”0”:4,”1”:5}ᐳ"}}:::plan
    PgSelectSingle31 --> RemapKeys79
    PgSelectSingle54{{"PgSelectSingle[54∈7]<br />ᐸusersᐳ"}}:::plan
    RemapKeys79 --> PgSelectSingle54
    PgClassExpression32{{"PgClassExpression[32∈5]<br />ᐸ__messages__.”body”ᐳ"}}:::plan
    PgSelectSingle31 --> PgClassExpression32
    RemapKeys77{{"RemapKeys[77∈5]<br />ᐸ31:{”0”:1,”1”:2}ᐳ"}}:::plan
    PgSelectSingle31 --> RemapKeys77
    PgSelectSingle39{{"PgSelectSingle[39∈5]<br />ᐸusersᐳ"}}:::plan
    RemapKeys77 --> PgSelectSingle39
    PgClassExpression40{{"PgClassExpression[40∈6]<br />ᐸ__users__.”username”ᐳ"}}:::plan
    PgSelectSingle39 --> PgClassExpression40
    PgClassExpression41{{"PgClassExpression[41∈6]<br />ᐸ__users__....vatar_url”ᐳ"}}:::plan
    PgSelectSingle39 --> PgClassExpression41
    PgClassExpression55{{"PgClassExpression[55∈8]<br />ᐸ__users__.”username”ᐳ"}}:::plan
    PgSelectSingle54 --> PgClassExpression55
    PgClassExpression56{{"PgClassExpression[56∈8]<br />ᐸ__users__....vatar_url”ᐳ"}}:::plan
    PgSelectSingle54 --> PgClassExpression56

    %% define steps

    subgraph "Buckets for queries/conditions/exclusively-archived-messages"
    Bucket0("Bucket 0 (root)<br />1: <br />ᐳ: 12, 13, 84, 14, 28<br />2: PgSelect[11]"):::bucket
    classDef bucket0 stroke:#696969
    class Bucket0,__Value0,__Value3,__Value5,PgSelect11,Access12,Access13,Object14,Connection28,Constant84 bucket0
    Bucket1("Bucket 1 (listItem)<br />Deps: 28<br /><br />ROOT __Item{1}ᐸ11ᐳ[15]"):::bucket
    classDef bucket1 stroke:#00bfff
    class Bucket1,__Item15,PgSelectSingle16,Constant60 bucket1
    Bucket2("Bucket 2 (nullableBoundary)<br />Deps: 16, 28, 15, 60<br /><br />ROOT PgSelectSingle{1}ᐸforumsᐳ[16]"):::bucket
    classDef bucket2 stroke:#7f007f
    class Bucket2,PgClassExpression17 bucket2
    Bucket3("Bucket 3 (nullableBoundary)<br />Deps: 28, 15, 60<br /><br />ROOT Connectionᐸ24ᐳ[28]"):::bucket
    classDef bucket3 stroke:#ffa500
    class Bucket3,PgPageInfo57,Lambda59,First62,PgSelectSingle63,PgCursor64,PgClassExpression65,List66,Last68,PgSelectSingle69,PgCursor70,PgClassExpression71,List72,First74,PgSelectSingle75,PgClassExpression76,Access81,Lambda82,Access83 bucket3
    Bucket4("Bucket 4 (listItem)<br />ROOT __Item{4}ᐸ82ᐳ[30]"):::bucket
    classDef bucket4 stroke:#0000ff
    class Bucket4,__Item30,PgSelectSingle31 bucket4
    Bucket5("Bucket 5 (nullableBoundary)<br />Deps: 31<br /><br />ROOT PgSelectSingle{4}ᐸmessagesᐳ[31]"):::bucket
    classDef bucket5 stroke:#7fff00
    class Bucket5,PgClassExpression32,PgSelectSingle39,RemapKeys77 bucket5
    Bucket6("Bucket 6 (nullableBoundary)<br />Deps: 39<br /><br />ROOT PgSelectSingle{5}ᐸusersᐳ[39]"):::bucket
    classDef bucket6 stroke:#ff1493
    class Bucket6,PgClassExpression40,PgClassExpression41 bucket6
    Bucket7("Bucket 7 (nullableBoundary)<br />Deps: 31<br /><br />ROOT PgSelectSingle{4}ᐸmessagesᐳ[31]"):::bucket
    classDef bucket7 stroke:#808000
    class Bucket7,PgCursor44,PgClassExpression45,List46,PgClassExpression47,PgSelectSingle54,RemapKeys79 bucket7
    Bucket8("Bucket 8 (nullableBoundary)<br />Deps: 54<br /><br />ROOT PgSelectSingle{7}ᐸusersᐳ[54]"):::bucket
    classDef bucket8 stroke:#dda0dd
    class Bucket8,PgClassExpression55,PgClassExpression56 bucket8
    Bucket0 --> Bucket1
    Bucket1 --> Bucket2
    Bucket2 --> Bucket3
    Bucket3 --> Bucket4
    Bucket4 --> Bucket5 & Bucket7
    Bucket5 --> Bucket6
    Bucket7 --> Bucket8
    end
