Table: t_block_summaries

Table Documentation: `t_block_summaries`

Summary:
The t_block_summaries table provides a summary of each block processed by the Beacon Chain, including information about attestations for the block, duplicate attestations, votes for the block, and the distance from its parent block.

Description:
This table is crucial for analyzing the efficiency and security of block proposals on the Beacon Chain. It includes metrics that can help identify the level of validator participation for each block and any inconsistencies in attestation inclusion.

Schema Overview

Column Name	Data Type	Nullable	Description
`f_slot`	INT64	YES	The slot number of the block.
`f_attestations_for_block`	INT64	YES	The number of attestations included in the block.
`f_duplicate_attestations_for_block`	INT64	YES	The number of duplicate attestations for the block.
`f_votes_for_block`	INT64	YES	The total number of votes (in terms of validator count) for the block.
`f_parent_distance`	INT64	YES	The number of slots since the parent block (usually 1 in a healthy network).

Example SQL Query

SELECT *
FROM raw_beacon_chain.t_block_summaries
LIMIT 3;

Sample Query Result

f_slot	f_attestations_for_block	f_duplicate_attestations_for_block	f_votes_for_block	f_parent_distance
7420864	256	0	44990	1
7421706	256	0	52795	1
7422277	257	0	51560	1

This sample result set shows a summary of the first three blocks, including the number of attestations for each block, any duplicate attestations, the total number of votes for the block, and the parent distance. These metrics are instrumental in understanding block propagation and validation dynamics within the network.

Updated 26 days ago