Changes

Page history
Update benchmarks authored by Philippe Wang's avatar Philippe Wang
Show whitespace changes
Inline Side-by-side
benchmarks.md
View page @ 8564089e
......@@ -25,6 +25,64 @@
# Run times
## indexer v9.7.8 unreleased - PG14
### with 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 Wed Oct 27 10:08:46 AM PDT 2021 -- TOTAL DURATION: 3h6m29s
- apply DB schema from Wed Oct 27 10:08:46 AM PDT 2021 -- duration: 0s
- list contract addresses from Wed Oct 27 10:08:46 AM PDT 2021 -- duration: 0s
- record contract addresses into DB from Wed Oct 27 10:08:46 AM PDT 2021 -- duration: 8s
- start indexing from Wed Oct 27 10:08:54 AM PDT 2021 -- duration: 2h27m53s
- conversion of DB from Wed Oct 27 12:36:47 PM PDT 2021 -- duration: 38m28s
- average speed: 161 blocks / second, or 9705 blocks per minute, 8800 operations per second
```
### no cache of contract addresses
```
......
......