gistfile1.txt

dotcms=#  SELECT bl.pid                 AS blocked_pid,
dotcms-#          a.usename              AS blocked_user,
dotcms-#          ka.query               AS blocking_statement,
dotcms-#          now() - ka.query_start AS blocking_duration,
dotcms-#          kl.pid                 AS blocking_pid,
dotcms-#          ka.usename             AS blocking_user,
dotcms-#          a.query                AS blocked_statement,
dotcms-#          now() - a.query_start  AS blocked_duration
dotcms-#   FROM  pg_catalog.pg_locks         bl
dotcms-#    JOIN pg_catalog.pg_stat_activity a  ON a.pid = bl.pid
dotcms-#    JOIN pg_catalog.pg_locks         kl ON kl.transactionid = bl.transactionid AND kl.pid != bl.pid
dotcms-#    JOIN pg_catalog.pg_stat_activity ka ON ka.pid = kl.pid
dotcms-#   WHERE NOT bl.granted;
 blocked_pid | blocked_user |                                                                    blocking_statement                                          
                           | blocking_duration | blocking_pid | blocking_user |                                                                     blocked_s
tatement                                                                     | blocked_duration 
-------------+--------------+--------------------------------------------------------------------------------------------------------------------------------
---------------------------+-------------------+--------------+---------------+------------------------------------------------------------------------------
-----------------------------------------------------------------------------+------------------
       27827 | dotcms       | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where
 identifier=$7 and lang=$8 | 00:52:13.340922   |        17825 | dotcms        | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_typ
e=$4, syspublish_date=$5, sysexpire_date=$6 where id=$7                      | 00:51:17.906477
       27827 | dotcms       | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where
 identifier=$7 and lang=$8 | 00:27:18.463658   |        17824 | dotcms        | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_typ
e=$4, syspublish_date=$5, sysexpire_date=$6 where id=$7                      | 00:51:17.906477
       27947 | dotcms       | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where
 identifier=$7 and lang=$8 | 00:52:13.340922   |        17825 | dotcms        | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_typ
e=$4, syspublish_date=$5, sysexpire_date=$6 where id=$7                      | 00:52:14.402017
       27947 | dotcms       | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where
 identifier=$7 and lang=$8 | 00:52:14.027641   |        27995 | dotcms        | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_typ
e=$4, syspublish_date=$5, sysexpire_date=$6 where id=$7                      | 00:52:14.402017
       17825 | dotcms       | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspublish_date=$5, sysexpire_date=$6 where 
id=$7                      | 00:52:14.402017   |        27947 | dotcms        | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$
3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | 00:52:13.340922
       17825 | dotcms       | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where
 identifier=$7 and lang=$8 | 00:52:14.027641   |        27995 | dotcms        | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$
3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | 00:52:13.340922
       17824 | dotcms       | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where
 identifier=$7 and lang=$8 | 00:52:13.340922   |        17825 | dotcms        | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$
3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | 00:27:18.463658
       17824 | dotcms       | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspublish_date=$5, sysexpire_date=$6 where 
id=$7                      | 00:51:17.906477   |        27827 | dotcms        | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$
3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | 00:27:18.463658
(8 rows)