Skip to content

Changes

Page history
Update benchmarks authored by Philippe Wang's avatar Philippe Wang
Show whitespace changes
Inline Side-by-side
benchmarks.md
View page @ d4e3f9e2
...@@ -25,6 +25,65 @@ ...@@ -25,6 +25,65 @@
# Run times # Run times
## indexer v9.7.8 unreleased - PG14 ## indexer v9.7.8 unreleased - PG14
### with DB hosted on **hard drive**
```
Database:
HOST=localhost
DB=v977PG14HDD
PORT=5434
PG_USER=phil
DB_USER=phil
PSQL_OPTIONS=
PSQL=time psql -h localhost -p 5434 -U phil v977PG14HDD -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-v977PG14HDD
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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --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:5434/v977PG14HDD --tezos-url=http://localhost:8735 --block-cache-directory=/home/phil/blocks/
Durations:
STARTED ON Mon Nov 1 12:23:56 PM PDT 2021 -- TOTAL DURATION: 17h40m12s
- apply DB schema from Mon Nov 1 12:23:56 PM PDT 2021 -- duration: 3s
- list contract addresses from -- duration: 0s
- record contract addresses into DB from -- duration: 454387h23m59s
- start indexing from Mon Nov 1 12:23:59 PM PDT 2021 -- duration: 11h18m46s
- conversion of DB from Mon Nov 1 11:42:45 PM PDT 2021 -- duration: 6h21m23s
- average speed: 28 blocks / second, or 1707 blocks per minute, 1547 operations per second
```
### with cache of contract addresses ### with cache of contract addresses
``` ```
... ...
......