Skip to main content

​
Table Description

The tron.blocks table contains information about blocks in the Tron blockchain. A block is a collection of transactions that are hashed and added to the blockchain. Each block contains a reference to the previous block, known as the parent hash, and a timestamp. The table contains information about each block, such as the block number, the block hash, the block size, the number of transactions, and the gas used.

​
Table Schema

ColumnTypeDescription
timetimestamp(3)Timestamp when this block was added to the chain
numberbigintSequential position of this block in the blockchain
gas_limitdecimal(38,0)Maximum amount of energy that can be used by all transactions in this block
gas_useddecimal(38,0)Total amount of energy actually consumed by all transactions in this block
difficultybigintMeasure of how difficult it was to produce this block
total_difficultydecimal(38,0)Total chain difficulty up to this block
sizebigintSize of this block in bytes
base_fee_per_gasbigintMinimum fee per energy unit required for transaction inclusion in this block
hashvarbinaryUnique identifier (hash) of this block
parent_hashvarbinaryHash of the previous block in the blockchain
minervarbinaryAddress of the block producer (super representative) who produced this block
noncevarbinaryBlock nonce value used in the consensus mechanism
datedateThe UTC date when this block was added to the chain

​
Table Sample

​
Examples

​
Show the most recent blocks

SELECT
  number,
  hash,
  size,
  gas_used
FROM
  tron.blocks
ORDER BY
  number DESC
LIMIT 10

​
Show the number of blocks produced each day

SELECT
  date_trunc('day', time) AS day,
  count(distinct number)
FROM
  tron.blocks
GROUP BY
  day
ORDER BY
  day DESC

​
Show the number of transactions in each block

SELECT
  number,
  count(*)
FROM
  tron.blocks
group by 1 

LIMIT 10