Skip to main content

Table description

The solana.vote_transactions table contains the full set of vote transactions that are submitted by validators to vote on a block. It can be joined with the non-vote transactions table above to get a full breakdown of all transactions. It has the same schema as the main transactions table.

Table Schema

ColumnTypeDescription
block_slotBIGINTThe slot number of the block containing this vote transaction
block_heightBIGINTThe block height at which this vote transaction was processed
block_timeTIMESTAMPThe timestamp of the block this vote transaction belongs to
block_dateDATEThe date of the block this vote transaction belongs to
indexINTEGERThe index position of this vote transaction within the block
feeBIGINTThe transaction fee paid in lamports
compute_units_consumedBIGINTThe number of compute units consumed by this vote transaction
cost_unitsBIGINTThe cost units charged for this vote transaction
versionVARCHARThe transaction version (‘legacy’ or ‘0’ for versioned transactions)
required_signaturesINTEGERThe number of signatures required for this vote transaction
readonly_signed_accountsINTEGERThe number of read-only accounts that are also signers
readonly_unsigned_accountsINTEGERThe number of read-only accounts that are not signers
block_hashVARCHARThe hash of the block containing this vote transaction
idVARCHARThe unique transaction ID (same as signature)
signatureVARCHARThe first signature of the transaction, used as the transaction identifier
successBOOLEANWhether the vote transaction completed successfully
errorVARCHARThe error message if the vote transaction failed, null otherwise
recent_block_hashVARCHARThe recent blockhash used for transaction validity and replay prevention
instructionsARRAY(ROW(data VARCHAR, executing_account VARCHAR, account_arguments ARRAY(VARCHAR), inner_instructions ARRAY(ROW(data VARCHAR, executing_account VARCHAR, account_arguments ARRAY(VARCHAR), stack_height BIGINT))))The list of instructions executed in this vote transaction, including nested inner instructions
account_keysARRAY(VARCHAR)All account addresses referenced in this vote transaction
log_messagesARRAY(VARCHAR)Program log messages emitted during vote transaction execution
pre_balancesARRAY(BIGINT)SOL balances (in lamports) of all accounts before the vote transaction, ordered by account_keys index
post_balancesARRAY(BIGINT)SOL balances (in lamports) of all accounts after the vote transaction, ordered by account_keys index
pre_token_balancesARRAY(ROW(account VARCHAR, mint VARCHAR, owner VARCHAR, amount DECIMAL(38,18)))SPL token balances of accounts before the vote transaction
post_token_balancesARRAY(ROW(account VARCHAR, mint VARCHAR, owner VARCHAR, amount DECIMAL(38,18)))SPL token balances of accounts after the vote transaction
signaturesARRAY(VARCHAR)All signatures attached to this vote transaction
signerVARCHARThe primary signer (fee payer) of the vote transaction
signersARRAY(VARCHAR)All accounts that signed this vote transaction
return_data_program_idVARCHARThe program ID that produced the return data, if any
return_dataARRAY(VARCHAR)The data returned by the program after execution, if any
address_table_lookupsARRAY(ROW(accountKey VARCHAR, readonlyIndexes ARRAY(BIGINT), writableIndexes ARRAY(BIGINT)))Address lookup table references used for versioned vote transactions
loaded_addressesROW(readonly ARRAY(VARCHAR), writable ARRAY(VARCHAR))Addresses loaded from address lookup tables, split into readonly and writable sets

Table Sample