Query editor
WITH ev AS (SELECT chain, evt_tx_hash, evt_tx_from FROM relay_multichain.relayrouter_evt_solvercallexecuted WHERE evt_block_date >= current_date - interval '90' dayUNION ALLSELECT chain, evt_tx_hash, evt_tx_from FROM relay_multichain.relayrouter_evt_solvernativetransfer WHERE evt_block_date >= current_date - interval '90' dayUNION ALLSELECT chain, evt_tx_hash, evt_tx_from FROM relay_multichain.relayrouterv3_evt_solvercallexecuted WHERE evt_block_date >= current_date - interval '90' dayUNION ALLSELECT chain, evt_tx_hash, evt_tx_from FROM relay_multichain.relayrouterv3_evt_solvernativetransfer WHERE evt_block_date >= current_date - interval '90' day),tx AS (SELECT DISTINCT chain, evt_tx_hash, evt_tx_from AS filler FROM ev),by_f AS (SELECT filler, count(*) AS n_tx, count(DISTINCT chain) AS n_chains FROM tx GROUP BY 1),tot AS (SELECT sum(n_tx) AS t, count(*) AS n_fillers FROM by_f)SELECT filler, n_tx, n_chains,round(100.0*n_tx/(SELECT t FROM tot), 2) AS pct_of_fill_txs,round(100.0*sum(n_tx) OVER (ORDER BY n_tx DESC ROWS UNBOUNDED PRECEDING)/(SELECT t FROM tot), 2) AS cum_pct,(SELECT n_fillers FROM tot) AS total_fillers,(SELECT t FROM tot) AS total_fill_txsFROM by_fORDER BY n_tx DESCLIMIT 25