Geth db inspect

geth db inspect
geth db inspect --help
geth db inspect --datadir /path/to/geth/folder
(It can take up to 1 hour)

geth --sepolia db inspect --datadir /path/to/geth/folder

.../...
ERROR[10-10|09:40:43.923] Database contains unaccounted data       size=71.05MiB count=1773925

geth db inspect | grep snapshot
| Key-Value store       | Account snapshot        | 409.64 KiB |  8893 |
| Key-Value store       | Storage snapshot        | 0.00 B     |     0 |
| Key-Value store       | Clique snapshots        | 0.00 B     |     0 |

Example

INFO [10-08|12:11:22.012] Maximum peer count                       ETH=50 total=50
INFO [10-08|12:11:22.016] Set global gas cap                       cap=50,000,000
INFO [10-08|12:11:22.017] Initializing the KZG library             backend=gokzg
INFO [10-08|12:11:22.042] Using pebble as the backing database
INFO [10-08|12:11:22.042] Allocated cache and file handles         database=~/Library/Ethereum/geth/chaindata cache=512.00MiB handles=5120
INFO [10-08|12:11:22.133] Opened ancient database                  database~/Library/Ethereum/geth/chaindata/ancient/chain readonly=true
INFO [10-08|12:11:30.137] Inspecting database                      count=31,189,000 elapsed=8.000s
INFO [10-08|12:11:38.146] Inspecting database                      count=36,313,000 elapsed=16.010s
INFO [10-08|12:11:46.149] Inspecting database                      count=38,084,000 elapsed=24.012s
INFO [10-08|12:11:54.156] Inspecting database                      count=39,442,000 elapsed=32.020s
INFO [10-08|12:12:02.161] Inspecting database                      count=40,476,000 elapsed=40.024s

+-----------------------+-------------------------+------------+-------+
|       DATABASE        |        CATEGORY         |    SIZE    | ITEMS |
+-----------------------+-------------------------+------------+-------+
| Key-Value store       | Headers                 | 576.00 B   |     1 |
| Key-Value store       | Bodies                  | 44.00 B    |     1 |
| Key-Value store       | Receipt lists           | 42.00 B    |     1 |
| Key-Value store       | Difficulties            | 48.00 B    |     1 |
| Key-Value store       | Block number->hash      | 42.00 B    |     1 |
| Key-Value store       | Block hash->number      | 41.00 B    |     1 |
| Key-Value store       | Transaction index       | 0.00 B     |     0 |
| Key-Value store       | Bloombit index          | 0.00 B     |     0 |
| Key-Value store       | Contract codes          | 0.00 B     |     0 |
| Key-Value store       | Hash trie nodes         | 0.00 B     |     0 |
| Key-Value store       | Path trie state lookups | 82.00 B    |     2 |
| Key-Value store       | Path trie account nodes | 1.47 MiB   | 12356 |
| Key-Value store       | Path trie storage nodes | 0.00 B     |     0 |
| Key-Value store       | Trie preimages          | 0.00 B     |     0 |
| Key-Value store       | Account snapshot        | 409.64 KiB |  8893 |
| Key-Value store       | Storage snapshot        | 0.00 B     |     0 |
| Key-Value store       | Beacon sync headers     | 0.00 B     |     0 |
| Key-Value store       | Clique snapshots        | 0.00 B     |     0 |
| Key-Value store       | Singleton metadata      | 695.19 KiB |    12 |
| Light client          | CHT trie nodes          | 0.00 B     |     0 |
| Light client          | Bloom trie nodes        | 0.00 B     |     0 |
| Ancient store (Chain) | Diffs                   | 6.00 B     |     0 |
| Ancient store (Chain) | Headers                 | 6.00 B     |     0 |
| Ancient store (Chain) | Hashes                  | 6.00 B     |     0 |
| Ancient store (Chain) | Bodies                  | 6.00 B     |     0 |
| Ancient store (Chain) | Receipts                | 6.00 B     |     0 |
| Ancient store (State) | History.Meta            | 85.00 B    |     1 |
| Ancient store (State) | Account.Index           | 201.05 KiB |     1 |
| Ancient store (State) | Storage.Index           | 13.00 B    |     1 |
| Ancient store (State) | Account.Data            | 13.00 B    |     1 |
| Ancient store (State) | Storage.Data            | 13.00 B    |     1 |
+-----------------------+-------------------------+------------+-------+
|                                  TOTAL          |  2.75 MIB  |       |
+-----------------------+-------------------------+------------+-------+

Errors

geth db inspect
INFO [10-08|12:04:40.196] Maximum peer count                       ETH=50 total=50
Fatal: Failed to create the protocol stack: datadir already used by another process

geth db inspect ./
failed to hex-decode 'prefix': hex string without 0x prefix

geth db inspect --datadir ./
INFO [10-10|09:37:48.217] Maximum peer count                       ETH=50 total=50
INFO [10-10|09:37:48.221] Set global gas cap                       cap=50,000,000
INFO [10-10|09:37:48.221] Initializing the KZG library             backend=gokzg
INFO [10-10|09:37:48.233] Defaulting to pebble as the backing database
INFO [10-10|09:37:48.233] Allocated cache and file handles         database=~/geth/chaindata/geth/chaindata cache=512.00MiB handles=5120
Fatal: Could not open database: error opening database at "~/geth/chaindata/geth/chaindata": pebble: database 
"~/geth/chaindata/geth/chaindata" does not exist

ERROR Database contains unaccounted data

See also

• geth db [ inspect | inspect-history | check-state-content | stats | metadata | dumptrie | get | --help ] geth db --datadir, geth --db.engine