Skip to main content

Table description

Compared to the extrinsics table, which only has a top-level call, the calls Substrate table represents internal calls, including recursive internal calls of proxy and utility (batch) pallets, and provides detailed call arguments each level of the call tree. Common queries on the calls table will typically filter on block_time, call_section and call_method and extract JSON encoded information in data or decoded_data.

Table Schema

ColumnTypeDescription
yearINTEGERCalendar year of the block (partition column)
monthINTEGERCalendar month of the block (partition column)
call_sectionVARCHARThe pallet (module) of this call (e.g. Balances, Staking)
call_methodVARCHARThe method name within the pallet (e.g. transfer, bond)
block_numberBIGINTThe sequential number of the block containing this call
block_timeTIMESTAMPThe timestamp of the block containing this call
extrinsic_idVARCHARIdentifier of the parent extrinsic (format: blockNumber-extrinsicIndex)
relay_chainVARCHARName of the relay chain (e.g. polkadot, kusama)
para_idBIGINTParachain ID, if this call is on a parachain
idVARCHARUnique identifier for this call
block_hashVARBINARYHash of the block containing this call
extrinsic_hashVARBINARYHash of the parent extrinsic
extrinsic_sectionVARCHARThe pallet of the top-level extrinsic
extrinsic_methodVARCHARThe method of the top-level extrinsic
call_idVARCHARIdentifier for this specific call within the extrinsic
call_indexVARBINARYEncoded index of the call within the pallet
call_argsVARCHARJSON-encoded arguments passed to this call
call_args_defVARCHARJSON-encoded definition/schema of the call arguments
rootBOOLEANWhether this is the root (top-level) call in the extrinsic
leafBOOLEANWhether this is a leaf call with no further nested calls
feeDOUBLETransaction fee paid for this call
weightBIGINTExecution weight consumed by this call
signedBOOLEANWhether the parent extrinsic was signed
signer_ss58VARCHARSS58-encoded address of the extrinsic signer
signer_pub_keyVARBINARYPublic key of the extrinsic signer
lifetimeVARCHARValidity period of the extrinsic (mortal/immortal era)
updated_atTIMESTAMPWhen this record was last updated in the database
ingested_atTIMESTAMPWhen this record was first ingested into the database

Table Sample