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