Difference between revisions of "Geth db stats"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ➜ ~ geth db stats | |
| − | level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w | + | INFO [08-18|18:48:16.689] Maximum peer count ETH=50 total=50 |
| − | ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- | + | INFO [08-18|18:48:16.693] Set global gas cap cap=50,000,000 |
| − | + | INFO [08-18|18:48:16.693] Initializing the KZG library backend=gokzg | |
| − | + | INFO [08-18|18:48:16.717] Using pebble as the backing database | |
| − | 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | + | INFO [08-18|18:48:16.717] Allocated cache and file handles database=/Users/user/Library/Ethereum/geth/chaindata cache=512.00MiB handles=5120 |
| − | 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | + | INFO [08-18|18:48:16.720] Opened ancient database database=/Users/user/Library/Ethereum/geth/chaindata/ancient/chain readonly=true |
| − | + | | | | | ingested | moved | written | | amp | |
| − | + | level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w | |
| − | + | ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- | |
| − | total | 3 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | + | 0 | 1 954B 0B 0 | 0.50 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 |
| − | ------------------------------------------------------------------------------------------------------------------- | + | 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 |
| − | WAL: 1 files (0B) in: 0B written: 0B (0% overhead) | + | 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 |
| − | Flushes: 0 | + | 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 |
| − | Compactions: 0 estimated debt: 1.8MB in progress: 0 (0B) | + | 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 |
| − | + | 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | |
| − | MemTables: 1 (256KB) zombie: 0 (0B) | + | 6 | 2 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 |
| − | Zombie tables: 0 (0B) | + | total | 3 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 |
| − | Backing tables: 0 (0B) | + | ------------------------------------------------------------------------------------------------------------------- |
| − | Virtual tables: 0 (0B) | + | WAL: 1 files (0B) in: 0B written: 0B (0% overhead) |
| − | Block cache: 10 entries (11KB) hit rate: 13.3% | + | Flushes: 0 |
| − | Table cache: 3 entries (2.3KB) hit rate: 25.0% | + | Compactions: 0 estimated debt: 1.8MB in progress: 0 (0B) |
| − | Secondary cache: 0 entries (0B) hit rate: 0.0% | + | default: 0 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 |
| − | Snapshots: 0 earliest seq num: 0 | + | MemTables: 1 (256KB) zombie: 0 (0B) |
| − | Table iters: 0 | + | Zombie tables: 0 (0B) |
| − | Filter utility: 100.0% | + | Backing tables: 0 (0B) |
| − | Ingestions: 0 as flushable: 0 (0B in 0 tables) | + | Virtual tables: 0 (0B) |
| − | + | Block cache: 10 entries (11KB) hit rate: 13.3% | |
| + | Table cache: 3 entries (2.3KB) hit rate: 25.0% | ||
| + | Secondary cache: 0 entries (0B) hit rate: 0.0% | ||
| + | Snapshots: 0 earliest seq num: 0 | ||
| + | Table iters: 0 | ||
| + | Filter utility: 100.0% | ||
| + | Ingestions: 0 as flushable: 0 (0B in 0 tables) | ||
| + | |||
| + | | | | | ingested | moved | written | | amp | ||
| + | level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w | ||
| + | ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- | ||
| + | 0 | 1 954B 0B 0 | 0.50 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | 6 | 2 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | total | 3 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 | ||
| + | ------------------------------------------------------------------------------------------------------------------- | ||
| + | WAL: 1 files (0B) in: 0B written: 0B (0% overhead) | ||
| + | Flushes: 0 | ||
| + | Compactions: 0 estimated debt: 1.8MB in progress: 0 (0B) | ||
| + | default: 0 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 | ||
| + | MemTables: 1 (256KB) zombie: 0 (0B) | ||
| + | Zombie tables: 0 (0B) | ||
| + | Backing tables: 0 (0B) | ||
| + | Virtual tables: 0 (0B) | ||
| + | Block cache: 10 entries (11KB) hit rate: 13.3% | ||
| + | Table cache: 3 entries (2.3KB) hit rate: 25.0% | ||
| + | Secondary cache: 0 entries (0B) hit rate: 0.0% | ||
| + | Snapshots: 0 earliest seq num: 0 | ||
| + | Table iters: 0 | ||
| + | Filter utility: 100.0% | ||
| + | Ingestions: 0 as flushable: 0 (0B in 0 tables) | ||
Revision as of 16:50, 18 August 2024
➜ ~ geth db stats
INFO [08-18|18:48:16.689] Maximum peer count ETH=50 total=50
INFO [08-18|18:48:16.693] Set global gas cap cap=50,000,000
INFO [08-18|18:48:16.693] Initializing the KZG library backend=gokzg
INFO [08-18|18:48:16.717] Using pebble as the backing database
INFO [08-18|18:48:16.717] Allocated cache and file handles database=/Users/user/Library/Ethereum/geth/chaindata cache=512.00MiB handles=5120
INFO [08-18|18:48:16.720] Opened ancient database database=/Users/user/Library/Ethereum/geth/chaindata/ancient/chain readonly=true
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 1 954B 0B 0 | 0.50 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 2 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
total | 3 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (0B) in: 0B written: 0B (0% overhead)
Flushes: 0
Compactions: 0 estimated debt: 1.8MB in progress: 0 (0B)
default: 0 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 0 (0B)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 10 entries (11KB) hit rate: 13.3%
Table cache: 3 entries (2.3KB) hit rate: 25.0%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 100.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 1 954B 0B 0 | 0.50 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 2 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
total | 3 1.8MB 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (0B) in: 0B written: 0B (0% overhead)
Flushes: 0
Compactions: 0 estimated debt: 1.8MB in progress: 0 (0B)
default: 0 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 0 (0B)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 10 entries (11KB) hit rate: 13.3%
Table cache: 3 entries (2.3KB) hit rate: 25.0%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 100.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
Related
geth db stats INFO [08-18|18:45:59.321] Maximum peer count ETH=50 total=50 Fatal: Failed to create the protocol stack: datadir already used by another process
See also
geth db [ inspect | inspect-history | check-state-content | stats | metadata | dumptrie | get | --help ] geth db --datadir, geth --db.engine
Advertising:
