add app-specific database metrics

spacemeshos / go-spacemesh

Go Implementation of the Spacemesh protocol full node. 💾⏰💪

https://spacemesh.io

MIT License

770 stars 215 forks source link

add app-specific database metrics #4113

Open countvonzero opened 1 year ago

countvonzero commented 1 year ago

Description

for example:

size of each table. i.e. number of atxs/ballots/blocks/proposals/malicious identities/accounts/block certificates
whenever make sense, the count of the last N epochs by epoch
mesh state. latest/last processed by mesh/last applied in vm
min/max ATX tickcount/height per epoch

dshulyak commented 1 year ago

size of each table. i.e. number of atxs/ballots/blocks/proposals/malicious identities/accounts/block certificates

this information is available

countvonzero commented 1 year ago

size of each table. i.e. number of atxs/ballots/blocks/proposals/malicious identities/accounts/block certificates

this information is available

apologies. i mean row counts of each table.

dshulyak commented 1 year ago

so if there will an implementation attempt it shouldn't scan whole database to get that data. if this is not available in https://www.sqlite.org/dbstat.html might be problematic to get it