./tmp_install/usr/local/pgsql/bin/pgbench --transactions=7 --report-latencies --no-vacuum --client=1
 --log --file=/mnt/c/Users/Matthias/AppData/Roaming/JetBrains/CLion2021.1/scratches/scratch.sql testing
pgbench (14beta1)
transaction type: /mnt/c/Users/Matthias/AppData/Roaming/JetBrains/CLion2021.1/scratches/scratch.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
number of transactions per client: 7
number of transactions actually processed: 7/7
latency average = 487476.847 ms
initial connection time = 0.718 ms
tps = 0.002051 (without initial connection time)
statement latencies in milliseconds:
         0.085  BEGIN;
       259.079  CREATE UNIQUE INDEX uidx ON index_test USING btree (transaction);
     63115.157  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
      9505.625  REINDEX INDEX uidx;
         0.177  DROP INDEX uidx;
         4.592  TRUNCATE index_test;
         1.686  CREATE INDEX ccl ON index_test USING btree (county, city, locality);
     69923.493  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     40202.434  REINDEX INDEX ccl;
         0.151  DROP INDEX ccl;
       308.214  TRUNCATE index_test;
         5.394  CREATE INDEX ccl_collated ON index_test USING btree (county COLLATE "en_US", city, locality);
     80143.752  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     39677.198  REINDEX INDEX ccl_collated;
         0.152  DROP INDEX ccl_collated;
       335.813  TRUNCATE index_test;
        15.291  CREATE INDEX accl ON index_test USING btree (always_null, county, city, locality);
     72638.613  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     43370.492  REINDEX INDEX accl;
         0.154  DROP INDEX accl;
       339.273  TRUNCATE index_test;
        13.803  CREATE INDEX tnt ON index_test USING btree (transfer_date, newly_built, transaction);
     49171.589  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     17378.554  REINDEX INDEX tnt;
         0.153  DROP INDEX tnt;
       353.809  TRUNCATE index_test;
       712.091  COMMIT;