benchmarks.md

@@ -28,6 +28,75 @@
 
 ### Host=amd.local
 
+Including a tokens table conversion that was missing from the last few runs: (basically it took less than 1 additional minute for the DB conversion)
+```
+0.01user 0.03system 25:51.66elapsed 0%CPU (0avgtext+0avgdata 12256maxresident)k
+12424inputs+0outputs (106major+3070minor)pagefaults 0swaps
+
+real    25m51.662s
+user    0m0.292s
+sys     0m0.086s
+Indexing started on Thu Sep 16 08:55:00 AM PDT 2021 - ended on Thu Sep 16 10:35:01 AM PDT 2021
+0.01user 0.00system 0:00.83elapsed 2%CPU (0avgtext+0avgdata 12832maxresident)k
+8872inputs+0outputs (86major+3085minor)pagefaults 0swaps
+#####################################
+Database:
+HOST=localhost
+DB=v960b
+PORT=5432
+PG_USER=phil
+DB_USER=phil
+PSQL_OPTIONS=
+PSQL=time psql -h localhost -p 5432 -U phil v960b -a
+
+Tezos node:
+TEZOS_NODE=http://127.0.0.1:8732
+TEZOS_NODE2=http://localhost:8735
+TEZOS_NODE3=http://localhost:8736
+TEZOS_NODE4=http://localhost:8732
+TEZOS_NODE5=http://localhost:8733
+TEZOS_NODE6=http://localhost:8734
+TEZOS_NODE7=http://localhost:8735
+TEZOS_NODE8=http://localhost:8736
+TEZOS_NODE9=http://localhost:8737
+TEZOS_NODEA=http://localhost:8738
+
+Tezos-indexer:
+TI=.
+LOGS_DIR=/c/L/
+BLOCK_CACHE_DIR=/home/phil/blocks/
+INDEXER_DATAKINDS=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support
+INDEXER_RUN=--use-disk-cache --debug --verbosity=1 --verbose
+INDEXER_OTHER_OPTIONS=
+gsize=2000
+top=1680000
+PROCESSES=64
+LOGS_DIR=/c/L/
+BLOCK_CACHE_DIR=/home/phil/blocks/
+LOGS=/c/L//indexer-segment-2000-localhost-v960b
+INDEXER_OPTIONS1=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8734 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS2=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8735 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS3=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8736 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS4=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8732 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS5=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8733 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS6=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8734 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS7=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8735 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS8=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8736 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONS9=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8737 --block-cache-directory=/home/phil/blocks/
+INDEXER_OPTIONSA=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose  --db=postgresql://phil@localhost:5432/v960b --tezos-url=http://localhost:8738 --block-cache-directory=/home/phil/blocks/
+
+Durations:
+STARTED ON Thu Sep 16 08:54:36 AM PDT 2021 -- TOTAL DURATION: 2h6m17s
+- apply DB schema from Thu Sep 16 08:54:52 AM PDT 2021 -- duration: 1s
+- list contract addresses from Thu Sep 16 08:54:53 AM PDT 2021 -- duration: 0s
+- record contract addresses into DB from Thu Sep 16 08:54:53 AM PDT 2021 -- duration: 7s
+- start indexing from Thu Sep 16 08:55:00 AM PDT 2021 -- duration: 1h40m1s
+- conversion of DB from Thu Sep 16 10:35:01 AM PDT 2021 -- duration: 25m52s
+- average speed: 221 blocks / second, or 13303 blocks per minute, 10014 operations per second
+############################
+start=Thu Sep 16 08:54:36 AM PDT 2021 end=Thu Sep 16 11:00:53 AM PDT 2021
+```
+
 Exactly the same run as the previous one (with less than one minute of difference in total)
 ```
 0.03user 0.02system 25:10.30elapsed 0%CPU (0avgtext+0avgdata 12852maxresident)k