uuid filtering benchmark

gistfile1.txt

const _ = require('underscore');
const { Client } = require('pg');

const all_query = `SELECT id FROM "filter-test"."filter-test";`;
const some_query = `SELECT id, blob FROM "filter-test"."filter-test" WHERE id IN ('$(WHERE_IN_FILTER)');`;

async function query(q) {
    const client = new Client({
        user: 'postgres',
        database: 'postgres'
    });
    client.connect();

    try {
        return await client.query(q);
    } finally {
        client.end();
    }
}

async function main() {
    console.time("query_all");
    let result = await query(all_query);
    console.timeEnd("query_all");
    console.log(result.rows.length);
    let rows = result.rows.map((e) => e["id"])

    benchSize = [1, 10, 100, 1000, 10000, 20000, 50000, 80000];
    benchSize.forEach(async n => {
        let sample = _.sample(rows, n);
        let q = some_query.replace("$(WHERE_IN_FILTER)", sample.join(`','`));
        console.time("query_some_" + n);
        let rx = await query(q);
        console.timeEnd("query_some_" + n);
        console.log(rx.rows.length + " results with query size: " + q.length);
    });
}

main()