Table Details
| Property | Value |
|---|---|
| Table Name | solana.raw.fees |
| Table Status | Production-Ready |
| Unique Key | block_timestamp::date, txn_index, txn_id |
solana.raw.feesprovides inforrmation on base and priority fees of solana transactions. More info about transactions fees can be found here.
Note that it only contains transactions with non-zero priority fees. For all other transactions, priority_fee=0, base_fee=tx_fee
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| set_compute_unit_limit | NUMBER(38,0) | Compute unit limit explicitly set by a SetComputeUnitLimit instruction in this transaction. Null if not set. |
| set_compute_unit_price | NUMBER(38,0) | Compute unit price (micro-lamports per compute unit) set by a SetComputeUnitPrice instruction. Determines the priority fee. |
| effective_compute_unit_limit | NUMBER(38,0) | Effective compute unit limit for this transaction — either explicitly set via ComputeBudget or the default (200,000 per instruction). |
| compute_units_consumed | NUMBER(38,0) | Actual compute units used by this transaction or instruction execution. |
| priority_fee | NUMBER(38,0) | Priority fee paid above the base transaction fee, in lamports. |
| base_fee | NUMBER(38,0) | Base fee per gas for this block, in the chain’s smallest fee denomination. |
| total_fee | NUMBER(38,0) | Total transaction fee paid in lamports (base fee + priority fee). |
| success | BOOLEAN | Boolean flag indicating whether the transaction executed successfully. True = succeeded, false = failed or reverted. |
| is_voting | BOOLEAN | True if this transaction is a validator vote transaction |
| signer | VARCHAR(16777216) | Primary signing account (fee payer) of the transaction. This is the account that authorized the transaction and paid transaction fees. |
| block_slot | NUMBER(38,0) | Solana slot number in which this transaction was confirmed. Slots are the fundamental unit of time on Solana (analogous to block numbers on EVM chains). Not every slot produces a block. |
| block_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_hash | VARCHAR(44) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| txn_id | VARCHAR(88) | Base58-encoded transaction signature on Solana. Analogous to transaction_hash on EVM chains. Uniquely identifies a transaction. |
| txn_index | NUMBER(38,0) | Zero-based position of this transaction within its slot. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |