Query editor
WITHdate_range AS (SELECTDATE_TRUNC('day',NOW()- interval '97 days') AS start_time,DATE_TRUNC('day',NOW()- interval '90 days') AS chart_start), gs AS (SELECT generate_series((SELECT start_time FROM date_range),DATE_TRUNC('day',NOW()), interval '1 day') dd),batches AS (SELECT evt_block_time, "_batchIndex", "_batchSize", gas_used, total_calldata,CASE WHEN batch_type = 'Tx Batch' THEN (gas_used - total_calldata)WHEN batch_type = 'State Batch' THEN gas_used ENDAS overhead --tx batch submits call data, State Batch submits are constant,CASE WHEN batch_type = 'Tx Batch' THEN (gas_used - total_calldata)::decimal/NULLIF("_batchSize",0)::decimalWHEN batch_type = 'State Batch' THEN gas_used::decimal/NULLIF("_batchSize",0)::decimal ENDAS overhead_per_tx --tx batch submits call data, State Batch submits are constant,CASE WHEN batch_type = 'Tx Batch' THEN total_calldata::decimal/NULLIF("_batchSize",0)::decimalWHEN batch_type = 'State Batch' THEN NULL::decimal ENDAS calldata_per_tx --tx batch submits call data, State Batch submits are constant,batch_type,versionFROM (SELECT *,CAST( (4*"numZeroBytes"+16*"numNonZeroBytes") AS int) AS total_calldataFROM (SELECT a.*, octet_length(t.data) AS byte_length, t.gas_used,COALESCE( (char_length( encode(data,'escape') ) - char_length(REPLACE(encode(data,'escape'),'\000','')) ) /4 ,0)::int AS "numZeroBytes",COALESCE(octet_length(t.data) - ((char_length( encode(data,'escape') ) - char_length(REPLACE(encode(data,'escape'),'\000','')) ) /4),0)::int AS "numNonZeroBytes"FROM (SELECT evt_block_time, evt_tx_hash, evt_block_number, "_batchIndex", "_batchSize", 'OVM 1.0' AS version, 'Tx Batch' AS batch_type FROMoptimism."OVM_CanonicalTransactionChain_evt_TransactionBatchAppended"WHERE evt_block_time >= (SELECT start_time FROM date_range)