./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 = 507826.653 ms
initial connection time = 0.762 ms
tps = 0.001969 (without initial connection time)
statement latencies in milliseconds:
         0.093  BEGIN;
        22.484  CREATE UNIQUE INDEX uidx ON index_test USING btree (transaction);
     61833.583  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
      9374.550  REINDEX INDEX uidx;
         0.155  DROP INDEX uidx;
         4.500  TRUNCATE index_test;
         1.861  CREATE INDEX ccl ON index_test USING btree (county, city, locality);
     72790.944  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     42364.419  REINDEX INDEX ccl;
         0.155  DROP INDEX ccl;
       306.673  TRUNCATE index_test;
         5.833  CREATE INDEX ccl_collated ON index_test USING btree (county COLLATE "en_US", city, locality);
     84156.380  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     42272.279  REINDEX INDEX ccl_collated;
         0.149  DROP INDEX ccl_collated;
       332.287  TRUNCATE index_test;
        10.861  CREATE INDEX accl ON index_test USING btree (always_null, county, city, locality);
     78607.320  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     50884.837  REINDEX INDEX accl;
         0.154  DROP INDEX accl;
       337.609  TRUNCATE index_test;
        15.329  CREATE INDEX tnt ON index_test USING btree (transfer_date, newly_built, transaction);
     48327.733  INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk;
     15111.673  REINDEX INDEX tnt;
         0.150  DROP INDEX tnt;
       351.298  TRUNCATE index_test;
       713.319  COMMIT;