Query editor
WITH ASSUMPTION AS (SELECT220000 AS base_verify_cost, -- using roughly experienced 22000027 AS eth_gas_price,200 AS matic_gas_price,5 AS op_gas_price),ETH_PRICE AS (SELECT2000 AS eth_usd),MATIC_PRICE AS (SELECT1 AS matic_usd),/* ZKSync *//* how we calculate the gas cost *//* gas limit before entering the verifier.sol: 7537188 *//* gas limit after: 6989391 *//* total spending: 547797 *//* source: https://etherscan.io/tx/0x2e7b8d87a0c682e5d498348b1c16ced198ceab818458c16e821e7790da191488/advanced#internal */ZKSYNC_ERAAS (SELECT'ZKSYNC_ERA' AS name,COUNT(*) AS verify_call,ROUND(TRY_CAST(COUNT(*) * 547797 * eth_gas_price * eth_usd AS DECIMAL(38, 10)) / 1000000000.0,4) AS costFROM zksync_v2_ethereum.ValidatorTimelock_call_proveBlocksCROSS JOIN ASSUMPTIONCROSS JOIN ETH_PRICECROSS JOIN MATIC_PRICEGROUP BYeth_gas_price,eth_usd),/* gas limit before entering the verifier.sol: 231182 *//* gas limit after: 32160 *//* total spending: 199076 *//* source: https://etherscan.io/tx/0xa51e3791aac8082ea69c4756388116add0a715103a4b8b14ca18578174a516e8/advanced#internal */POLYGON_ZKEVM AS (SELECT'POLYGON_ZKEVM' AS name,COUNT(*) AS verify_call,ROUND(TRY_CAST(COUNT(*) * base_verify_cost * eth_gas_price * eth_usd AS DECIMAL(38, 10)) / 1000000000.0,4) AS costFROM polygon_zkevm_ethereum.Bridge_call_verifyBatchesTrustedAggregatorCROSS JOIN ASSUMPTIONCROSS JOIN ETH_PRICECROSS JOIN MATIC_PRICEGROUP BYeth_gas_price,base_verify_cost,eth_usd),/* gas limit before entering the verifier.sol: 11,662,192 */