select-pgsql-raw.php

<?php
/**
 * This file is part of the Makise-Co Postgres Client
 * World line: 0.571024a
 *
 * (c) Dmitry K. <coder1994@gmail.com>
 */

declare(strict_types=1);

require_once dirname(__DIR__) . '/vendor/autoload.php';
require_once 'random_data.php';

Swoole\Coroutine\run(function () {
    $handle = pg_connect(
        "host=127.0.0.1 port=5434 dbname=makise user=makise password=el-psy-congroo application_name='Makise Postgres Client Benchmark' client_encoding=utf8 options='-ctimezone=UTC -csearch_path=public'"
    );

    $start = microtime(true);

    for ($i = 0; $i < 100; $i++) {
        $result = pg_exec($handle, 'SELECT * FROM test');

        while ($row = pg_fetch_assoc($result)) {
        }
    }

    $end = microtime(true);

    $total = $end - $start;

    printf("Execution time for Pgsql (raw): %f secs\n", $total);
    printf("Peak memory usage for Pgsql (raw): %.2f kb\n", memory_get_peak_usage() / 1024);
});