HiveSQL
Search…
Witnesses
The Witnesses table is a non-transactional table that contains a list of all witnesses and related information. The table content is updated every witness round (i.e. every 63 seconds as there are 21 witnesses producing a block every 3 seconds in each round)

Columns

Name
Description
name
Account name of the witness
votes_count
Number of votes the witness received
url
The URL of the witness presentation post
votes
Total amount of VEST from voters
total_missed
Number of blocks missed
last_aslot
This value indicates when the witness was last scheduled for block production
last_confirmed_block_num
Block number of the last block signed by the witness
signing_key
Current signing key use by the Witness. A value of STM1111111111111111111111111111111114T1Anm means the witness has been deactivated and will no more be scheduled for block production
account_creation_fee
Proposed cost for the creation of a new account
account_creation_fee_symbol
STEEM
maximum_block_size
Proposed maximum block size. The greater, the more information and transactions the blockchain can store in each block
sbd_interest_rate
Proposed interest rate to rewards users holding SBD
sbd_exchange_rate_base
Proposed cost in SBD to buy 1 STEEM
sbd_exchange_rate_base_symbol
SBD
sbd_exchange_rate_quote
Proposed value for the ratio between SBD and STEEM for rewards
sbd_exchange_rate_quote_symbol
STEEM
last_sbd_exchange_update
Last time the witness updated its price feed
running_version
Current version of the witness node
hardfork_version_vote
Current version of the hardfork supported by the witness
hardfork_time_vote
Time of vote from the witness for the latest supported hardfork
Last modified 4mo ago
Copy link