topo_update.update_features_java performance issue

May we need to checkout this some more

/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:55:39.565 CEST >LOG:  duration: 25687.358 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:56:36.005 CEST >LOG:  duration: 388886.668 ms  execute S_6: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:57:03.291 CEST >LOG:  duration: 68294.721 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:57:16.651 CEST >LOG:  duration: 27782.545 ms  execute S_6: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:57:27.527 CEST >LOG:  duration: 247382.610 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:57:31.440 CEST >LOG:  duration: 7421.619 ms  execute S_6: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:58:04.085 CEST >LOG:  duration: 29034.374 ms  execute S_6: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:58:08.127 CEST >LOG:  duration: 60158.431 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:58:17.476 CEST >LOG:  duration: 4746.173 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:58:45.035 CEST >LOG:  duration: 33667.203 ms  execute S_6: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:59:06.630 CEST >LOG:  duration: 44137.400 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:59:26.396 CEST >LOG:  duration: 34459.039 ms  execute S_6: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:59:27.854 CEST >LOG:  duration: 18043.367 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:59:35.618 CEST >LOG:  duration: 2088.742 ms  execute S_7: select * from topo_update.update_features_java($1,$2,$3) as result
/var/log/postgresql/postgresql-Fri.log.1:< 128.39.98.198 topo_rein_crud1, ar5ngis_utv_ws, 2021-06-11 23:59:59.209 CEST >LOG:  duration: 25787.078 ms  execute S_6: select * from topo_update.update_features_java($1,$2,$3) as result
Edited by Lars Aksel Opsahl