solana.staking.validators table contains the latest commission rate of validators.
Background
At the start of epoch, the rewards from the previous epoch are distributed to validators and stakers. Validators rewards are recorded with reward_type = ‘Voting’ together with the commission rate they charge. This table is consolidated from thecommission rate recorded during these reward distributions.
Table columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| validator_vote_account | The validator’s vote account address | varchar | DzhGmMUzpyQ5ruk5rRCfekTZMyvPXBXHtnn6aNnt94x4 |
| last_commission_rate | The latest commission rate of the validator | number | 100 |
| last_updated_block_timestamp | Timestamp of the block when commission was last updated | timestamp_ntz | 2024-12-02 17:43:22.000 |
| last_updated_block_height | Block height when commission was last updated | number | 283410986 |
| last_updated_block_hash | Block hash when commission was last updated | varchar | 9nV3sysuDYhgZHSF24yVu7rbGB75aHPPnajUHPi2KQSx |
| last_updated_block_slot | Block slot when commission was last updated | number | 304992000 |
| last_updated_epoch | Epoch when commission was last updated | number | 706 |