brian-terraAurora Table Record Counts
Updated 2024-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
⌄
select 'Block Records: ' as label, count(*) as total_count from aurora.core.fact_blocks
UNION ALL
select 'Transaction Records: ' as label, count(*) as total_count from aurora.core.fact_transactions
UNION ALL
select 'Receipt Records: ' as label, count(*) as total_count from aurora.core.fact_receipts
UNION ALL
select 'Log Records: ' as label, count(*) as total_count from aurora.core.fact_logs
/*
aurora.core.fact_blocks - 96m
aurora.core.fact_transactions - 55m
aurora.core.fact_receipts - 10m
aurora.core.fact_logs - 24m
*/
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived