After DELETE http://perf-okapi.int.aws.folio.org:9130/inventory/items/6a4fda81-a5eb-4ebd-a80d-556ecf4e73cd - if I do GET on same itemId to verify it doesn't exists(404), that GET HTTP request takes ~15 seconds. Below is the explain analyze:mod-inventory

folio=# explain (analyze, buffers) SELECT  supertenant_mod_inventory_storage.count_estimate_smart('SELECT * FROM supertenant_mod_inventory_storage.items_mt_view  WHERE lower(f_unaccent(items_mt_view.jsonb->>''id'')) LIKE lower(f_unaccent(''6a4fda81-a5eb-4ebd-a80d-556ecf4e73cd''))  ') AS count,  * FROM supertenant_mod_inventory_storage.items_mt_view  WHERE lower(f_unaccent(items_mt_view.jsonb->>'id')) LIKE lower(f_unaccent('6a4fda81-a5eb-4ebd-a80d-556ecf4e73cd')) LIMIT 1 OFFSET 0;
                                                             QUERY PLAN                                                             
------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.51..68.48 rows=1 width=542) (actual time=7515.781..7515.781 rows=0 loops=1)
   Buffers: shared hit=14485 read=188343
   ->  Nested Loop  (cost=0.51..988199.71 rows=14539 width=542) (actual time=7515.781..7515.781 rows=0 loops=1)
         Buffers: shared hit=14485 read=188343
         ->  Seq Scan on item  (cost=0.00..980292.65 rows=14539 width=465) (actual time=7515.780..7515.780 rows=0 loops=1)
               Filter: (lower(f_unaccent((jsonb ->> 'id'::text))) ~~ '6a4fda81-a5eb-4ebd-a80d-556ecf4e73cd'::text)
               Rows Removed by Filter: 2908646
               Buffers: shared hit=14485 read=188343
         ->  Index Scan using material_type_id_idx on material_type  (cost=0.51..0.53 rows=1 width=73) (never executed)
               Index Cond: (lower(f_unaccent((jsonb ->> 'id'::text))) = lower(f_unaccent((item.jsonb ->> 'materialTypeId'::text))))
 Planning time: 7467.075 ms
 Execution time: 7515.807 ms
(12 rows)