benchmarks.md

@@ -24,6 +24,65 @@
 
 # Run times
 
+## indexer v9.7.8 unreleased - PG14
+### no cache of contract addresses
+
+```
+Database:
+HOST=localhost
+DB=v977PG14
+PORT=5433
+PG_USER=phil
+DB_USER=phil
+PSQL_OPTIONS=
+PSQL=time psql -h localhost -p 5433 -U phil v977PG14 -a
+
+Tezos node:
+TEZOS_NODE=http://127.0.0.1:8732
+TEZOS_NODE2=http://localhost:8733
+TEZOS_NODE3=http://localhost:8734
+TEZOS_NODE4=http://localhost:8735
+TEZOS_NODE5=http://localhost:8736
+TEZOS_NODE6=http://localhost:8737
+TEZOS_NODE7=http://localhost:8738
+TEZOS_NODE8=http://localhost:8733
+TEZOS_NODE9=http://localhost:8734
+TEZOS_NODEA=http://localhost:8735
+
+Tezos-indexer:
+TI=.
+LOGS_DIR=/tmp/L
+BLOCK_CACHE_DIR=/home/phil/blocks/
+INDEXER_DATAKINDS=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000
+INDEXER_RUN=--use-disk-cache --debug --verbosity=1 --verbose
+INDEXER_OTHER_OPTIONS=
+gsize=2000
+top=1810000
+PROCESSES=48
+LOGS_DIR=/tmp/L
+BLOCK_CACHE_DIR=/home/phil/blocks/
+LOGS=/tmp/L/indexer-segment-2000-localhost-v977PG14
+INDEXER_OPTIONS1=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8732 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS2=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8733 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS3=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8734 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS4=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8735 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS5=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8736 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS6=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8737 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS7=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8738 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS8=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8733 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS9=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8734 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONSA=--no-contract-balances --no-snapshot --skip-prebaby --no-watch --tokens-support --auto-recovery 100000 --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5433/v977PG14 --tezos-url=http://localhost:8735 --block-cache-directory=/home/phil/blocks/
+
+Durations:
+STARTED ON Tue Oct 26 12:40:59 PM PDT 2021 -- TOTAL DURATION: 3h7m33s
+- apply DB schema from Tue Oct 26 12:41:13 PM PDT 2021 -- duration: 0s
+- list contract addresses from Tue Oct 26 12:41:13 PM PDT 2021 -- duration: 0s
+- record contract addresses into DB from Tue Oct 26 12:41:13 PM PDT 2021 -- duration: 0s
+- start indexing from Tue Oct 26 12:41:13 PM PDT 2021 -- duration: 2h28m32s
+- conversion of DB from Tue Oct 26 03:09:45 PM PDT 2021 -- duration: 38m47s
+- average speed: 160 blocks / second, or 9650 blocks per minute, 8750 operations per second
+```
+
 ## indexer v9.7.7 - PG14
 ```
 0.03user 0.01system 30:56.49elapsed 0%CPU (0avgtext+0avgdata 12556maxresident)k