./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 = 499049.630 ms initial connection time = 0.732 ms tps = 0.002004 (without initial connection time) statement latencies in milliseconds: 0.091 BEGIN; 22.849 CREATE UNIQUE INDEX uidx ON index_test USING btree (transaction); 63756.013 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk; 9357.520 REINDEX INDEX uidx; 0.173 DROP INDEX uidx; 4.506 TRUNCATE index_test; 1.699 CREATE INDEX ccl ON index_test USING btree (county, city, locality); 71118.264 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk; 39849.243 REINDEX INDEX ccl; 0.145 DROP INDEX ccl; 305.330 TRUNCATE index_test; 5.833 CREATE INDEX ccl_collated ON index_test USING btree (county COLLATE "en_US", city, locality); 83673.213 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk; 40427.121 REINDEX INDEX ccl_collated; 0.169 DROP INDEX ccl_collated; 339.383 TRUNCATE index_test; 10.314 CREATE INDEX accl ON index_test USING btree (always_null, county, city, locality); 75521.468 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk; 44901.042 REINDEX INDEX accl; 0.159 DROP INDEX accl; 338.667 TRUNCATE index_test; 13.447 CREATE INDEX tnt ON index_test USING btree (transfer_date, newly_built, transaction); 50472.199 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk; 17867.951 REINDEX INDEX tnt; 0.145 DROP INDEX tnt; 351.942 TRUNCATE index_test; 710.720 COMMIT;