2021-08-18 16:01:03 UTC:xx.xx.xx.xx(48226):fs00001034_mod_orders_storage@folio:[16565]:LOG:  duration: 28092.261 ms  statement: SELECT DISTINCT ON(lower(f_unaccent(metadata->>'id'))) jsonb FROM fs00001034_mod_orders_storage.receiving_history_view WHERE ((true) AND ( (lower(f_unaccent(receiving_history_view.metadata->>'acqUnitIds')) NOT LIKE lower(f_unaccent('[]'))) IS NOT TRUE)) AND ((lower(f_unaccent(receiving_history_view.metadata->>'checkin')) LIKE lower(f_unaccent('true'))) AND (lower(f_unaccent(receiving_history_view.metadata->>'poLineId')) LIKE lower(f_unaccent('f56bdce7-a554-4ebe-a51e-af39554fe656')))) LIMIT 10 OFFSET 0

2021-08-18 16:01:30 UTC:xx.xx.xx.x(48226):fs00001034_mod_orders_storage@folio:[16565]:LOG:  duration: 26741.252 ms  statement: EXPLAIN ANALYZE SELECT DISTINCT ON(lower(f_unaccent(metadata->>'id'))) jsonb FROM fs00001034_mod_orders_storage.receiving_history_view WHERE ((true) AND ( (lower(f_unaccent(receiving_history_view.metadata->>'acqUnitIds')) NOT LIKE lower(f_unaccent('[]'))) IS NOT TRUE)) AND ((lower(f_unaccent(receiving_history_view.metadata->>'checkin')) LIKE lower(f_unaccent('true'))) AND (lower(f_unaccent(receiving_history_view.metadata->>'poLineId')) LIKE lower(f_unaccent('f56bdce7-a554-4ebe-a51e-af39554fe656')))) LIMIT 10 OFFSET 0