Skip to main content

​
Table description

Extrinsics (aka “transactions”) normally contain a signature, some data to describe if the extrinsic has passed some validity checks and a reference to the pallet and call that it is intended for. Extrinsics may be signed or unsigned. Some extrinsics have a complex structure, e.g. when using proxy or utility pallets, resulting in the top-level call initiating other calls involving other pallets. Common queries on the extrinsics table (e.g. polkadot.extrinsics) will typically filter on block_time, section and method and extract JSON encoded information in data or decoded_data. In many cases, an initial query on the extrinsics table is best developed on the calls table instead to properly capture how users often use proxy and utility constructs to interact with the Substrate chain.

​
Table Schema

ColumnTypeDescription
yearINTEGERCalendar year of the block (partition column)
monthINTEGERCalendar month of the block (partition column)
sectionVARCHARThe pallet (module) of the top-level call (e.g. Balances, Staking)
methodVARCHARThe method name within the pallet (e.g. transferKeepAlive, nominate)
block_timeTIMESTAMPThe timestamp of the block containing this extrinsic
block_numberBIGINTThe sequential number of the block containing this extrinsic
extrinsic_idVARCHARUnique identifier for this extrinsic (format: blockNumber-extrinsicIndex)
hashVARBINARYHash of this extrinsic
block_hashVARBINARYHash of the block containing this extrinsic
lifetimeVARCHARValidity period of the extrinsic (mortal/immortal era)
paramsVARCHARJSON-encoded parameters of the top-level call
feeDOUBLETransaction fee paid for this extrinsic
weightBIGINTExecution weight consumed by this extrinsic
signedBOOLEANWhether this extrinsic includes a cryptographic signature
signer_ss58VARCHARSS58-encoded address of the signer
signer_pub_keyVARBINARYPublic key of the signer
statusBOOLEANWhether the extrinsic executed successfully (true) or failed (false)
updated_atTIMESTAMPWhen this record was last updated in the database
ingested_atTIMESTAMPWhen this record was first ingested into the database

​
Table Sample