Transactions

The transactions table provides indexed views of all transactions submitted for a specified chain.

Columns

Name	Description	Type
block_number	The block number the transaction was included in.	integer
timestamp	The transaction's timestamp (in ISO-8601 format).	timestamp
transaction_hash	The transaction's hash.	text
gas_limit	The maximum amount of gas that can be used in the transaction (in gas units).	numeric
gas_used	The amount of gas used in the transaction (in gas units).	numeric
gas_price	The actual price of gas used in the transaction (in Wei per gas unit).	numeric
transaction_fee	The gas fee paid by the transaction (in Wei).	numeric
nonce	The transaction sender's nonce.	integer
position	The position of the transaction in the block.	integer
from_address	The address of the transaction's sender.	text
to_address	The address of the transaction's recipient, if any.	text
value	The amount sent by the transaction (in Wei).	numeric
contract_address	The address of the contract created by the transaction, if any.	text
input	The input data for the transaction.	text
output	The output data for the transaction.	text
internal_transaction_count	The number of internal transactions produced in the transaction.	integer
log_count	The number of logs produced in the transaction.	integer
__confirmed	Flag indicating whether the transaction has been confirmed.	boolean

Indexes

The following indexes are available for this table:

(__confirmed) WHERE __confirmed = false
(block_number, position)
(timestamp, position)
(from_address, block_number, position)
(to_address, block_number, position)
(to_address, LEFT(input, 10), block_number, position)

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.