log postgres serverside pid for debugging

postgres_process_id.java

private void logServerPID(Connection connection) throws SQLException {
    if (connection.isWrapperFor(PGConnection.class)) {
        // WARNING this PGConnection will have some mem leak, but cant close it, so only use it for debugging
        PGConnection pgConnection = connection.unwrap(PGConnection.class);
        log.info("Server PID {}", pgConnection.getBackendPID());
    } else {
        log.warn("Connection instance is not of pg instance type");
    }
}


@Transactional(rollbackOn = Exception.class)
public <T> void run() {
    EntityManager entityManager = entityManagerProvider.get();
    Session session = entityManager.unwrap(Session.class);
    session.doWork(this::logServerPID);

    // ...
}