distribution: local
vectorized: true

• update
│ table: t
│ set: v
│ auto commit
│
└── • render
    │
    └── • hash join (semi)
        │ estimated row count: 1,000
        │ equality: (grp) = (id)
        │ right cols are key
        │
        ├── • scan
        │     estimated row count: 1,000 (100% of the table; stats collected 40 seconds ago)
        │     table: t@t_pkey
        │     spans: FULL SCAN
        │
        └── • filter
            │ estimated row count: 10
            │ filter: flag
            │
            └── • scan
                  estimated row count: 100 (100% of the table; stats collected 40 seconds ago)
                  table: s@s_pkey
                  spans: FULL SCAN

index recommendations: 1
1. type: index creation
   SQL command: CREATE INDEX ON capture.public.t (grp) STORING (c, d, v);
