query: 2021-08-16 15:32:05 UTC:xx.xx.xx.xx(49272):fs00001034_mod_inventory_storage@folio:[3404]:LOG:  duration: 1199446.252 ms  statement:  WITH  headrecords AS (   SELECT jsonb, (lower(f_unaccent(jsonb->>'title')) ) AS data_column FROM fs00001034_mod_inventory_storage.instance   WHERE ((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE lower(f_unaccent(item.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Missing'))))) AND (((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='c8e127a3-1d59-42e6-9600-bbdffc13b373'))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a8f90946-aea4-4491-9de9-14d2162e96a6')))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a69b7fa9-e958-4160-bdca-94a384c7b02d')))))     AND left(lower(f_unaccent(jsonb->>'title')) ,600) <             ( SELECT left(lower(f_unaccent(jsonb->>'title')) ,600)                FROM fs00001034_mod_inventory_storage.instance               ORDER BY left(lower(f_unaccent(jsonb->>'title')) ,600)                OFFSET 10000 LIMIT 1             )   ORDER BY left(lower(f_unaccent(jsonb->>'title')) ,600)    LIMIT 100 OFFSET 0 ),  allrecords AS (   SELECT jsonb, lower(f_unaccent(jsonb->>'title'))  AS data_column FROM fs00001034_mod_inventory_storage.instance   WHERE ((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE lower(f_unaccent(item.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Missing'))))) AND (((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='c8e127a3-1d59-42e6-9600-bbdffc13b373'))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a8f90946-aea4-4491-9de9-14d2162e96a6')))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a69b7fa9-e958-4160-bdca-94a384c7b02d')))))     AND (SELECT COUNT(*) FROM headrecords) < 100 ), totalCount AS (SELECT fs00001034_mod_inventory_storage.count_estimate('  SELECT lower(f_unaccent(jsonb->>''title''))  AS data_column   FROM fs00001034_mod_inventory_storage.instance   WHERE (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE lower(f_unaccent(item.jsonb->''status''->>''name'')) LIKE lower(f_unaccent(''Missing''))))) AND (((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId=''c8e127a3-1d59-42e6-9600-bbdffc13b373''))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId=''a8f90946-aea4-4491-9de9-14d2162e96a6'')))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId=''a69b7fa9-e958-4160-bdca-94a384c7b02d''))))') AS count) SELECT jsonb, data_column, (SELECT count FROM totalCount)   FROM headrecords   WHERE (SELECT COUNT(*) FROM headrecords) >= 100 UNION (SELECT jsonb, data_column, (SELECT count FROM totalCount)   FROM allrecords   ORDER BY data_column    LIMIT 100 OFFSET 0 ) ORDER BY data_column 



2021-08-16 16:02:27 UTC:xx.xx.xx.xx(49272):fs00001034_mod_inventory_storage@folio:[3404]:LOG:  duration: 1821699.834 ms  statement: EXPLAIN ANALYZE  WITH  headrecords AS (   SELECT jsonb, (lower(f_unaccent(jsonb->>'title')) ) AS data_column FROM fs00001034_mod_inventory_storage.instance   WHERE ((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE lower(f_unaccent(item.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Missing'))))) AND (((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='c8e127a3-1d59-42e6-9600-bbdffc13b373'))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a8f90946-aea4-4491-9de9-14d2162e96a6')))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a69b7fa9-e958-4160-bdca-94a384c7b02d')))))     AND left(lower(f_unaccent(jsonb->>'title')) ,600) <             ( SELECT left(lower(f_unaccent(jsonb->>'title')) ,600)                FROM fs00001034_mod_inventory_storage.instance               ORDER BY left(lower(f_unaccent(jsonb->>'title')) ,600)                OFFSET 10000 LIMIT 1             )   ORDER BY left(lower(f_unaccent(jsonb->>'title')) ,600)    LIMIT 100 OFFSET 0 ),  allrecords AS (   SELECT jsonb, lower(f_unaccent(jsonb->>'title'))  AS data_column FROM fs00001034_mod_inventory_storage.instance   WHERE ((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE lower(f_unaccent(item.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Missing'))))) AND (((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='c8e127a3-1d59-42e6-9600-bbdffc13b373'))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a8f90946-aea4-4491-9de9-14d2162e96a6')))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId='a69b7fa9-e958-4160-bdca-94a384c7b02d')))))     AND (SELECT COUNT(*) FROM headrecords) < 100 ), totalCount AS (SELECT fs00001034_mod_inventory_storage.count_estimate('  SELECT lower(f_unaccent(jsonb->>''title''))  AS data_column   FROM fs00001034_mod_inventory_storage.instance   WHERE (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE lower(f_unaccent(item.jsonb->''status''->>''name'')) LIKE lower(f_unaccent(''Missing''))))) AND (((instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId=''c8e127a3-1d59-42e6-9600-bbdffc13b373''))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId=''a8f90946-aea4-4491-9de9-14d2162e96a6'')))) OR (instance.id IN  ( SELECT instanceId FROM holdings_record WHERE holdings_record.id IN  ( SELECT holdingsRecordId FROM item WHERE effectiveLocationId=''a69b7fa9-e958-4160-bdca-94a384c7b02d''))))') AS count) SELECT jsonb, data_column, (SELECT count FROM totalCount)   FROM headrecords   WHERE (SELECT COUNT(*) FROM headrecords) >= 100 UNION (SELECT jsonb, data_column, (SELECT count FROM totalCount)   FROM allrecords   ORDER BY data_column    LIMIT 100 OFFSET 0 ) ORDER BY data_column