# Relayer Stats

## Osmosis

#### Total txs

sqlite> select count(*) from txs;

18347   

### Txs per relayer

select
    (select count(*) from txs where memo LIKE '%hermes%') as hermes,
    (select count(*) from txs where memo LIKE '%rly%') as rly;
    
hermes  rly 
------  ----
8454    4564

### Txs relayed by Informal

sqlite> select count(*) from txs where memo like '%Stake with Informal%';

17      

### Hermes versions on `channel-0`

sqlite> select
  (select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where txs_channel.channel_id = 'channel-0' and memo LIKE '%hermes 1.0%') as '1.0',
  (select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where txs_channel.channel_id = 'channel-0' and memo LIKE '%hermes 1.1%') as '1.1',
  (select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where txs_channel.channel_id = 'channel-0' and memo LIKE '%hermes 1.2%') as '1.2',
  (select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where txs_channel.channel_id = 'channel-0' and memo LIKE '%hermes 1.3%') as '1.3',
  (select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where txs_channel.channel_id = 'channel-0' and memo LIKE '%hermes 1.4%') as '1.4';

1.0  1.1  1.2  1.3  1.4
---  ---  ---  ---  ---
0    0    89   51   748

### Operators relaying on `channel-0`

select memo from txs join txs_channel on txs.hash = txs_channel.tx_hash where txs_channel.channel_id = 'channel-0' group by memo;

42-cresBot-2023-05-09                                                                                                   
43-cresBot-2023-05-09                                                                                                   
44-cresBot-2023-05-09                                                                                                   
45-cresBot-2023-05-09                                                                                                   
49-lunaBot-2023-05-09                                                                                                   
54-kujiBot-2023-05-09                                                                                                   
55-kujiBot-2023-05-09                                                                                                   
56-kujiBot-2023-05-09                                                                                                   
57-kujiBot-2023-05-09                                                                                                   
63-kujiBot-2023-05-09                                                                                                   
64-lunaBot-2023-05-09                                                                                                   
73-kujiBot-2023-05-09                                                                                                   
74-kujiBot-2023-05-09                                                                                                   
75-kujiBot-2023-05-09                                                                                                   
76-kujiBot-2023-05-09                                                                                                   
85-junoBot-2023-05-09                                                                                                   
94-junoBot-2023-05-09                                                                                                   
Relayed By Golden Ratio Staking. Support By Delegating Here: https://linktr.ee/GoldenRatioStaking | rly(2.2.0)          
Relayed by Architect Nodes!  | hermes 1.2.0+061f14f (https://hermes.informal.systems)                                   
Relayed by Cosmos Spaces Team ☮️💜⚛️ | hermes 1.4.1 (https://hermes.informal.systems)                                    
Relayed by IcyCRO 🧊 | hermes 1.3.0+d3ad2eb (https://hermes.informal.systems)                                            
Relayed by Notional Labs | rly(2.1.2-50-gb32126d)                                                                       
Relayed by Notional! | hermes 1.4.0+daad028 (https://hermes.informal.systems)                                           
Relayed by jabbey (wif da zoomiez) | rly(2.1.2-50-gb32126d)                                                             
Relayed with 💜 by Lavender.Five Nodes 🐝 | rly(2.3.1)                                                                    
good luck                                                                                                               
relayed by CryptoCrew Validators | hermes 1.4.1+065fc246-dirty (https://hermes.informal.systems)   

### Total txs on `channel-0`

select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where channel_id = 'channel-0';

2318

### Txs relayed by Hermes on `channel-0`

select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where channel_id = 'channel-0' and memo like '%hermes%';

888                                                                            

### Txs relayed by Rly on `channel-0`

select count(*) from txs join txs_channel on txs.hash = txs_channel.tx_hash where channel_id = 'channel-0' and memo like '%rly%';

618                                                                            

### Best relayers on `channel-0`

select memo,count(*) as count from txs join txs_channel on txs.hash = txs_channel.tx_hash where channel_id = 'channel-0' group by memo order by count desc;
memo                                                                                                                      count
------------------------------------------------------------------------------------------------------------------------  -----
                                                                                                                          790  

relayed by CryptoCrew Validators | hermes 1.4.1+065fc246-dirty (https://hermes.informal.systems)                          729  

Relayed by jabbey (wif da zoomiez) | rly(2.1.2-50-gb32126d)                                                               457  

Relayed by Architect Nodes!  | hermes 1.2.0+061f14f (https://hermes.informal.systems)                                     89   

Relayed by Notional Labs | rly(2.1.2-50-gb32126d)                                                                         75   

Relayed By Golden Ratio Staking. Support By Delegating Here: https://linktr.ee/GoldenRatioStaking | rly(2.2.0)            69   

Relayed by IcyCRO 🧊 | hermes 1.3.0+d3ad2eb (https://hermes.informal.systems)                                              51   

Relayed by Cosmos Spaces Team ☮️💜⚛️ | hermes 1.4.1 (https://hermes.informal.systems)                                      16   

Relayed with 💜 by Lavender.Five Nodes 🐝 | rly(2.3.1)                                                                      13   

OSL (Osmosis Support Lab) Relayer 🧪 | rly(2.3.1)                                                                          2    

Connect the Interchain. Stake with Informal 🐙 | hermes 1.4.1+904c057d-dirty (https://hermes.informal.systems)             2    

💙 Relayed by Stakin | https://stakin.com | Stake with us to support our love for the Cosmos and IBC ecosystem 🌌 | rly(2.  1    
3.1)                                                                                                                           

good luck                                                                                                                 1    

Relayed by Notional! | hermes 1.4.0+daad028 (https://hermes.informal.systems)                                             1    

## Stride

### Best relayers on `channel-5`

select memo,count(*) as count from txs
  join txs_channel on txs.hash = txs_channel.tx_hash
  where channel_id = 'channel-5' and memo <> ''
  group by memo order by count desc limit 10;

memo   count
--------------------------------------------------------------------------------------  -----
👾 cosmosrescue.com | Securing the Cosmos | rly(2.2.0)                                   29   
IcyCRO 🧊 | hermes 1.3.0+d3ad2eb (https://hermes.informal.systems)                       25   
CryptoCrew Validators | hermes 1.3.0+d3ad2eb2 (https://hermes.informal.systems)          19   
hermes 1.4.1+45b5c292 (https://hermes.informal.systems)                                  18   
Golden Ratio Staking. | rly(2.2.0)                                                       16                                                                
WhisperNode 🤐 | rly(2.3.0)                                                              13   
SynergyNodes.com Relayer | hermes 0.15.0+4e83aae (https://hermes.informal.systems)       12   
Cosmos Spaces Team ☮️💜⚛️ | hermes 1.4.1 (https://hermes.informal.systems)                 12   
Notional Labs | rly(2.1.2-50-gb32126d)                                                    8    
shepherd | rly(2.3.0-rc3)                                                                 7