SELECT * from lock_monitor;
 locked_item  | waiting_duration | blocked_pid | blocked_query| blocked_mode | blocking_pid | blocking_query | blocking_mode

 
 product_calculated_info | 00:00:04.423753  |        4864 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTAL_QUANTITY_ORDER
ED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$
6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8 | ExclusiveLock |         5326 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTA
L_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5,
 CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8
                                                                                     | ExclusiveLock
 product_calculated_info | 00:00:04.308003  |        5322 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTAL_QUANTITY_ORDER
ED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$
6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8 | ExclusiveLock |         5326 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTA
L_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5,
 CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8


                                                                                        | ExclusiveLock
 product_calculated_info | 00:00:04.410511  |        2594 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTAL_QUANTITY_ORDER
ED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$
6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8 | ExclusiveLock |         4864 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTA
L_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5,
 CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8


                                                                                        | ExclusiveLock
 product_calculated_info | 00:00:04.308003  |        5322 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTAL_QUANTITY_ORDER
ED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$
6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8 | ExclusiveLock |         4864 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTA
L_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5,
 CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8

                                                                                        | ExclusiveLock
 transactionid           | 00:00:04.59874   |        5326 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTAL_QUANTITY_ORDER
ED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$
6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8 | ShareLock     |         5324 | SELECT INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_
ID, PRODUCT_ID, PARTY_ID, OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, EXPIRE_DATE, FACILITY_ID, C
ONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, AVAILABLE_TO_PROMISE_TOTAL, AC
COUNTING_QUANTITY_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVA
TION_VALID_THRU, UNIT_COST, CURRENCY_UOM_ID, FIXED_ASSET_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CRE
ATED_TX_STAMP FROM public.INVENTORY_ITEM WHERE ((FACILITY_ID = $1 AND PRODUCT_ID = $2)) | ExclusiveLock
 product_calculated_info | 00:00:04.423753  |        4864 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTAL_QUANTITY_ORDER
ED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$
6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8 | ExclusiveLock |         2594 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTA
L_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5,
 CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8


                                                                                        | ExclusiveLock
 product_calculated_info | 00:00:04.308003  |        5322 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTAL_QUANTITY_ORDER
ED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$
6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8 | ExclusiveLock |         2594 | UPDATE public.PRODUCT_CALCULATED_INFO SET TOTA
L_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2, AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4, LAST_UPDATED_TX_STAMP=$5,
 CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE PRODUCT_ID=$8