BaseChain: Transactions And Average TPS

i_danBaseChain: Transactions And Average TPS

Updated 2024-11-14

-- Parts of this query are forked and inspired from https://flipsidecrypto.xyz/optimus_prime/aptos-built-for-a-billion-people-rEKoh9 By Optimus_Prime

SELECT

-- All time calculations

COUNT(*) AS total_transactions

, DATEDIFF('second'

, MIN(block_timestamp)

, MAX(block_timestamp)) AS total_seconds

, COUNT(*) / NULLIF(DATEDIFF('second'

, MIN(block_timestamp)

, MAX(block_timestamp))

, 0) AS avg_all_time_tps

-- Last 90 days calculations

, COUNT(CASE

WHEN block_timestamp >= CURRENT_DATE - INTERVAL '90 days'

THEN 1 END) AS last_90_days_transactions

, DATEDIFF('second'

, MIN(CASE

WHEN block_timestamp >= CURRENT_DATE - INTERVAL '90 days'

THEN block_timestamp END)

, MAX(block_timestamp)) AS last_90_days_seconds

, COUNT(CASE

WHEN block_timestamp >= CURRENT_DATE - INTERVAL '90 days'

THEN 1 END) / NULLIF(DATEDIFF('second'

, MIN(CASE

WHEN block_timestamp >= CURRENT_DATE - INTERVAL '90 days'

THEN block_timestamp END)

, MAX(block_timestamp))

, 0) AS avg_last_90_days_tps

-- Last 30 days calculations

, COUNT(CASE

WHEN block_timestamp >= CURRENT_DATE - INTERVAL '30 days'

THEN 1 END) AS last_30_days_transactions

, DATEDIFF('second'

Last run: about 2 months ago

	TOTAL_TRANSACTIONS	TOTAL_SECONDS	AVG_ALL_TIME_TPS	LAST_90_DAYS_TRANSACTIONS	LAST_90_DAYS_SECONDS	AVG_LAST_90_DAYS_TPS	LAST_30_DAYS_TRANSACTIONS	LAST_30_DAYS_SECONDS	AVG_LAST_30_DAYS_TPS	LAST_7_DAYS_TRANSACTIONS	LAST_7_DAYS_SECONDS	AVG_LAST_7_DAYS_TPS	TRANSACTIONS_BEFORE_SEPT_2023	TOTAL_SECONDS_BEFORE_SEPT_2023_SINCE_LAUNCH	AVG_TPS_BEFORE_SEPT_2023
1	2206456111	56867844	38.799714	761501168	7794792	97.693584	224445280	2610792	85.968273	50769905	623592	81.41526	20712729	56867844	0.364226

141B

122s