folio=# explain (analyze, buffers) DELETE FROM supertenant_mod_inventory_storage.instance WHERE (jsonb->>'id') = '71bf3242-0979-4b21-ab7f-5dc7e275f00'; QUERY PLAN ----------------------------------------------------------------------------------------------------------------------- Delete on instance (cost=0.00..314636.92 rows=13807 width=6) (actual time=1108.199..1108.199 rows=0 loops=1) Buffers: shared hit=2559 read=272436 dirtied=1 -> Seq Scan on instance (cost=0.00..314636.92 rows=13807 width=6) (actual time=1108.199..1108.199 rows=0 loops=1) Filter: ((jsonb ->> 'id'::text) = '71bf3242-0979-4b21-ab7f-5dc7e275f00'::text) Rows Removed by Filter: 2761432 Buffers: shared hit=2559 read=272436 dirtied=1 Planning time: 0.620 ms Execution time: 1108.221 ms (8 rows) folio=#