mezo.blocks

Block headers, timestamps, gas limits, base fees, and validator/miner data for Mezo.

Table description

The mezo.blocks table contains information about blocks in the mezo 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.

Column Descriptions

Column	Type	Description
time	timestamp	The time when the block was mined
number	bigint	The block number (height)
gas_limit	decimal	Maximum gas allowed in the block
gas_used	decimal	Total gas used by all transactions in the block
difficulty	bigint	Mining difficulty of the block
total_difficulty	decimal	Cumulative difficulty of the chain up to this block
size	bigint	Size of the block in bytes
base_fee_per_gas	bigint	Base fee per gas unit (EIP-1559)
hash	varbinary	Hash of the block
parent_hash	varbinary	Hash of the parent block
miner	varbinary	Address of the miner/validator
nonce	varbinary	Nonce used in mining the block
date	date	Date of the block (UTC)
blob_gas_used	bigint	Total blob gas used in the block (EIP-4844)
excess_blob_gas	bigint	Excess blob gas for fee calculation (EIP-4844)
parent_beacon_block_root	varbinary	Root of the parent beacon block

Table Sample

Examples

Show the most recent blocks

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

Show the number of blocks mined each day

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

Show the number of transactions in each block

SELECT
    number,
    count(*)
  FROM mezo.blocks
  GROUP BY 1 
  LIMIT 10