How to configure profiler with zend-db Pdo_Pgsql driver? about bjyprofiler HOT 4 CLOSED

    'service_manager' => [
        'factories' => [
            \Zend\Db\Adapter\Adapter::class => function ($sm) {
                $adapter = new BjyProfiler\Db\Adapter\ProfilingAdapter(array(
                    'driver'    => 'Zend\Db\Adapter\Driver\Pgsql\Pgsql',
                    'dsn'       => 'pgsql:dbname=' . QP_MAIN_DB_BASE_NAME . ';host='.QP_MAIN_DB_HOST,
                    'database'  => QP_MAIN_DB_BASE_NAME,
                    'username'  => QP_MAIN_DB_USER_NAME,
                    'password'  => QP_MAIN_DB_PASSWORD,
                    'hostname'  => QP_MAIN_DB_HOST,
                ));
                if (php_sapi_name() == 'cli') {
                    $logger = new Zend\Log\Logger();
                    // write queries profiling info to stdout in CLI mode
                    $writer = new Zend\Log\Writer\Stream('php://output');
                    $logger->addWriter($writer, Zend\Log\Logger::DEBUG);
                    $adapter->setProfiler(new BjyProfiler\Db\Profiler\LoggingProfiler($logger));
                } else {
                    $adapter->setProfiler(new BjyProfiler\Db\Profiler\Profiler());
                }
                if (isset($dbParams['options']) && is_array($dbParams['options'])) {
                    $options = $dbParams['options'];
                } else {
                    $options = array();
                }
                $adapter->injectProfilingStatementPrototype($options);
                return $adapter;
            },
        ],

 'service_manager' => [
        'factories' => [
            \Zend\Db\Adapter\AdapterInterface::class => function ($sm) {