Database Locks , Performance Issues and How to Resolve?

Hi Experts,

In our TEST database - PostgreSQL 10 - We are facing issue while executing SELECT queries from application concurrently.

Select statements taking long some time (almost ½ hr) and it goes into lock mode even after we have COMMIT in the updates.

In PGADMIN dashboard, database applied exclusive lock on table cfs.next_nm_tabl.

This issue is major for us, and huge performance issue for applications.

Attached the spreadsheet with all details of LOCKS.

Please suggest how to handle this in PostgreSQL , as this never is an issue when we simulate the same in Oracle?

Query from application:
2019-12-28 20:00:17.185 DEBUG 25032 --- [pool-2-thread-1] org.hibernate.SQL :
update
cfs.next_nm_tabl
set
next_nm=?
where
nm_typ_ind=?

DB Locks details from PGADMIN:

[cid:image006(dot)jpg(at)01D5BEF7(dot)21BCD280]