pg-batch-bench

Benchmark batch queries. Need to upgrade to multiple trials for good statistics

1. npm i
2. setup .env PGHOST, PGDATABASE, PGUSER, PGPASSWORD, PGPORT.
3. npm run dev or build and run

example output

The 'actual' time is awaiting the query execution. The time underneath includes preparing the query string and values

Actual insert time: 2.878941999999995
Inserted 1 users in 4.9889320000000055 milliseconds
Actual batch insert time: 2.1960090000000037
Batch inserted 1 users in 3.0242520000000184 milliseconds

------------------------------------

Actual insert time: 2.412203000000005
Inserted 10 users in 2.6843299999999886 milliseconds
Actual batch insert time: 3.2105689999999925
Batch inserted 10 users in 3.5196650000000034 milliseconds

------------------------------------

Actual insert time: 7.259129999999999
Inserted 100 users in 7.748450999999989 milliseconds
Actual batch insert time: 12.405274999999989
Batch inserted 100 users in 12.695435000000003 milliseconds

------------------------------------

Actual insert time: 32.499311000000006
Inserted 1000 users in 33.7929 milliseconds
Actual batch insert time: 40.68247100000002
Batch inserted 1000 users in 41.200166000000024 milliseconds

------------------------------------

Actual insert time: 164.45973700000002
Inserted 10000 users in 182.40847699999995 milliseconds
Actual batch insert time: 308.913774
Batch inserted 10000 users in 310.96220900000003 milliseconds

------------------------------------

Actual update time: 1.6015630000001693 ms
Updated 1 users in 2.0707270000000335 milliseconds
Actual batch update time: 1.3007930000001124 ms
Batch updated 1 users in 1.615438999999924 milliseconds

------------------------------------

Actual update time: 2.1258499999999003 ms
Updated 10 users in 2.3400790000000598 milliseconds
Actual batch update time: 2.4612439999998514 ms
Batch updated 10 users in 2.6522299999999177 milliseconds

------------------------------------

Actual update time: 5.40587800000003 ms
Updated 100 users in 5.779023000000052 milliseconds
Actual batch update time: 11.205621000000065 ms
Batch updated 100 users in 11.367602000000034 milliseconds

------------------------------------

Actual update time: 26.25981999999999 ms
Updated 1000 users in 28.04937300000006 milliseconds
Actual batch update time: 56.99672900000019 ms
Batch updated 1000 users in 57.30980199999999 milliseconds

------------------------------------

Actual update time: 197.93505299999993 ms
Updated 10000 users in 223.87634000000003 milliseconds
Actual batch update time: 470.48040999999967 ms
Batch updated 10000 users in 471.65700100000004 milliseconds

------------------------------------