SELECT bl.pid                 AS blocked_pid,
       a.usename              AS blocked_user,
       ka.query               AS blocking_statement,
       now() - ka.query_start AS blocking_duration,
       kl.pid                 AS blocking_pid,
       ka.usename             AS blocking_user,
       a.query                AS blocked_statement,
       now() - a.query_start  AS blocked_duration
  FROM pg_catalog.pg_locks         bl
  JOIN pg_catalog.pg_stat_activity a  ON a.pid = bl.pid
  JOIN pg_catalog.pg_locks         kl ON kl.transactionid = bl.transactionid AND kl.pid != bl.pid
  JOIN pg_catalog.pg_stat_activity ka ON ka.pid = kl.pid
 WHERE NOT bl.granted;

blocked_pid | blocked_user |                                        blocking_statement                                         | blocking_duration | blocking_pid | blocking_user |                                         blocked_statement                                         | blocked_duration
-------------+--------------+---------------------------------------------------------------------------------------------------+-------------------+--------------+---------------+---------------------------------------------------------------------------------------------------+------------------
        5549 | example      | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:37:04.217044   |        17009 | example       | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:18:16.18061
       18016 | example      | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:37:04.217044   |        17009 | example       | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:35:57.814924
       14582 | example      | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:37:04.217044   |        17009 | example       | DELETE FROM session WHERE session_lifetime + session_time < $1                                    | 00:39:28.512274
       26589 | example      | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:37:04.217044   |        17009 | example       | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:28:41.270193
        5549 | example      | DELETE FROM session WHERE session_lifetime + session_time < $1                                    | 00:39:28.512274   |        14582 | example       | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:18:16.18061
       18016 | example      | DELETE FROM session WHERE session_lifetime + session_time < $1                                    | 00:39:28.512274   |        14582 | example       | SELECT session_data, session_lifetime, session_time FROM session WHERE session_id = $1 FOR UPDATE | 00:35:57.814924

pdo:
    class: PDO
    arguments:
        dsn: 'pgsql:dbname=%database_name%;host=%database_host%'
        user: '%database_user%'
        password: '%database_password%'
    calls:
        - [setAttribute, [3, 2]] # PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION
example.session_storage:
    class: ExamplePlatformBundleSecurityExampleSessionStorage
    arguments: [ '%session.storage.options%', '@session.handler', '@session.storage.metadata_bag', '@request_stack' ]
session.handler.pdo:
    class: SymfonyComponentHttpFoundationSessionStorageHandlerPdoSessionHandler
    arguments: [ '@pdo', '%pdo.db_options%' ]