repair metrics weekly status tracking

[jbiseda]

9/20:

• 9/15 at 01:40 UTC until 03:30 UTC and 9/19 at 20:00 UTC until 21:50 UTC there were spikes in repair as a % of total packets from a steady stake of about 0.8% to 2.5% on the 15th and 2% on the 20th
• Also at 9/19 at 20:00 The number of repair packets and the number of shreds decoupled (they were previously the same value). num shreds is around 10,100 and num packets is now about 10,550.
• There was a spike in repair total packet count (sending side) on 9/19 at 14:24 from a steady state of about 7,500 to 11,000.

Repair as a % of total packets:

SELECT sum("num_repairs") / sum(num_packets) * 100 FROM "mainnet-beta"."autogen"."recv-window-insert-shreds" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND ("host_id"='EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4' OR "host_id"='ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n' OR "host_id"='krakeNd6ednDPEXxHAmoBs1qKVM8kLg79PvWF2mhXV1' OR "host_id"='Awes4Tr6TX8JDzEhCZY2QVNimT6iD1zWHzf1vNyGvpLM' OR "host_id"='XkCriyrNwS3G4rzAXtG5B1nnvb5Ka1JtCku93VqeKAr' OR "host_id"='Certusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24' OR "host_id"='Cs23cJMRuahuKh5oNhVmLhM2UrtaZLULLF3HqrxfTnHc' OR "host_id"='DRpbCBMxVnDK7maPM5tGv6MvB3v1sRMC86PZ8okm21hy' OR "host_id"='Dokia75SVtetShgapUBoVFfYjL99fQyr1twxKKyTZKa3' OR "host_id"='Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk' OR "host_id"='Ninja1spj6n9t5hVYgF3PdnYz2PLnkt7rvaw3firmjs' OR "host_id"='Bx7SNaHfyeLZDeja9HPsn61XYjeForHtrTxLCb6cu62o' OR "host_id"='DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP' OR "host_id"='BpyjeG4SY9r3TNnc3rP22DP3wpsStFA1FaZWywNPy6dr' OR "host_id"='6TkKqq15wXjqEjNg9zqTKADwuVATR9dW3rkNnsYme1ea' OR "host_id"='DDnAqxJVFo2GVTujibHt5cjevHMSE9bo8HJaydHoshdp' OR "host_id"='2qprVNLV2BP3yApsiFgXoArtsX2oqX3hi7XsKo1vSDVP' OR "host_id"='VymDdiepH77edNcNcKBKtRUb3gbQPtPyGh5NLcWaynj' OR "host_id"='hz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe' OR "host_id"='7cVfgArCheMR6Cs4t6vz5rfnqd56vZq4ndaBrY5xkxXy' OR "host_id"='kkSzRKB5bkrtUF2MkkPUFqFmbuPppm8dkwH9SWMULJn' OR "host_id"='38mTPbpSCC3iPrdM5KKy2kXAjdSdw6GyNndMKvgHDoNv' OR "host_id"='EgxVyTgh2Msg781wt9EsqYx4fW8wSvfFAHGLaJQjghiL' OR "host_id"='7sFeozTSUYomDExsQTq59W58s4Fyj4xGmh8KLGxmEjzb' OR "host_id"='8UQ45XfTAHb8n6kMhix3MAsinKggHTGja4LE6nnQsJPf' OR "host_id"='4oSR2zEN1rXyo84x2CuMf9vRo6pdiQEALAAwpmToCHgJ' OR "host_id"='6UFbAZu536R6H9n2EtVEdB8dbZKLBax5eoPxDWgQZvRd' OR "host_id"='CKUox1FamkkPhzahNjaBytS5FCB7cJggCvcNLDLZCaDY' OR "host_id"='7brZvwqepBtCLe5NhqcENFS8jPJagny2f9eVqZoRYhMz' OR "host_id"='91yWMWM2wtsftTtgE1HA1bseRhLAg7yCuHg5GKFHn9r3' OR "host_id"='F9EcdNAwmvV7RtD4N9ncoPgMe3coVx2YNkJFWQM5yXgV' OR "host_id"='6dN61K6Y9mQpjQde4ToSjUqK6CfE1XQt8EwLeBNx6Rqm' OR "host_id"='AefX1EZnJ2KALA7e9BE1ktZWrzYiBvYgatB5Rv4vr2mt' OR "host_id"='3CvpuaRmrj2qFHQmPHiNpnHs3EosGSdbAHMbC2mqN9wB' OR "host_id"='85kaUrHo3Lb4AcbVhfzceFUxEkCNBV69Uxi2HRYE5VDh' OR "host_id"='et1UAfLg4ZNL3j9qXDs64hC55KizrDmCZz1oPtbnAKP' OR "host_id"='74theNPM1xGD5Pk54vV8hyBKF8Fqs1BgzTceGmcYVxiW' OR "host_id"='AZhAEf79gCXexHTasaByZQS8fks73aCUkDW8rRVLiiXT' OR "host_id"='EaRH6eMWnXKXhw1tqve6eUXnsoWYUFKeSbXUyBEqyPYJ' OR "host_id"='7iZsWtW2dGtLowEYT88hvtDL3AWA3cwiyqcaVPwA5hUX' OR "host_id"='2mMGsb5uy1Q4Dvezr8HK2E8SJoChcb2X7b61tJPaVHHd' OR "host_id"='G28BTgvAEGH1QtPWhQkak7yHj5ucgno6dPRq4FyDsApU' OR "host_id"='cCvd3F8D9ddpdyYNb911sGsMGDm6SEYVm2Dnqhw3Qjx' OR "host_id"='RBFiUqjYuy4mupzZaU96ctXJBy23sRBRsL3KivDAsFM' OR "host_id"='G2TBEh2ahNGS9tGnuBNyDduNjyfUtGhMcssgRb8b6KfH' OR "host_id"='A5EGLkDcDFtMcB3Mtdn6cYgeAq1gDvx9Yop7y8eyt9MN' OR "host_id"='LunaowJnt875WWoqDkhHhE93SNYHa6tfFNVn1rqc57c' OR "host_id"='7PdKhpKz7T39vZHFL1UfcYNDsLvay6hp4KPQq1aUckFf' OR "host_id"='2dfgsiSaZ51QYPsECMYMG247PXxyKdwkV9wTHoQb8YEC' OR "host_id"='MCFmmmXdzTKjBEoMggi8JGFJmd856uYSowuH2sCU5kx' OR "host_id"='2nDgb2py4cjHy8dxWGPUUR5641SSHCBEjnGGcuyqCKCh' OR "host_id"='32G1W4XLPcPBw9goEg5WyYoq5LS9kK63uRVMeRsPFjDf' OR "host_id"='fishfishrD9BwrQQiAcG6YeYZVUYVJf3tb9QGQPMJqF' OR "host_id"='2iGccofYbsAwg9GnxJA45iRNoGQfR4oYNjnptSzNx217' OR "host_id"='2av6anjHUwvpzhbCa9vAUEEybEHs9MSU6qw3pB3o6cC7' OR "host_id"='4o27cX8MsYmyzbYq9V5a2aMTW6eC4wxonVfkik6xGYHD' OR "host_id"='GZNnph4EvmyjjL5uzF9xNNTHyV46RzbkW4w4HYU8BQCW' OR "host_id"='FR9mh1vpduVxEUySvZmj19wYZqFaPtjRyLjQ5PvyPpgB' OR "host_id"='5ZwufMjECbyqtafDZR7wiB1GTWmAKR3EWqf5TeUpADnx' OR "host_id"='3ab2iWqdSjyaVVrPTJXRR9e9orqK4AMCrnc5EMEHGu2e' OR "host_id"='HzrEstnLfzsijhaD6z5frkSE2vWZEH5EUfn3bU9swo1f' OR "host_id"='Hr7bZkosETza1xtSRgmTr8DBSMMif9RPE4U49H7LXSNu' OR "host_id"='ATPHtHvsQuZm3gBgm7r9fhuXWgTPB9pr6ZLD6UbDYLTP' OR "host_id"='3RXKQBRv7xKTQeNdLSPhCiD4QcUfxEQ12rtgUkMf5LnS' OR "host_id"='BeaCHioStqCEFDFxKwAEzyrUPYxqnBPhJ98gDKeEiTPb' OR "host_id"='3B2mGaZoFwzAnWCoZ4EAKdps4FbYbDKQ48jo8u1XWynU' OR "host_id"='FzPoMxzQJRH87NVy1YJF8BqjrygzLLHz8MYjEZPhQHnL' OR "host_id"='7wohoM4oWam7mRKEYCxU3xKoFf6Q7ft1wHqkfFrmaz7K' OR "host_id"='Dq3piY2ZcBvNN84j2EhDLtTzRAw95za7Eau89pNcmSd5' OR "host_id"='23SUe5fzmLws1M58AnGnvnUBRUKJmzCpnFQwv4M4b9Er' OR "host_id"='8WjzRz9HM2bWBopD6UPbi3swyRE5kk9aJojhn6fBKTJk' OR "host_id"='1aine15iEqZxYySNwcHtQFt4Sgc75cbEi9wks8YgNCa' OR "host_id"='2fFev6gBMMzfUzbSdVnnSzNXG9W9iZ9UNZuWpPKJKKjC' OR "host_id"='CAo1dCGYrB6NhHh5xb1cGjUiu86iyCfMTENxgHumSve4' OR "host_id"='FfM4oeeszBdHJys9yPFV6hkcZB3ea5GuMYj81aVLURVK' OR "host_id"='GmCxjmjKZoaKN1DKunbYq8RCYib94Nm3sHyncFfofaF5' OR "host_id"='9U4WqNGVywKt3gG9HSt9tGVXBDXJvgid6BVweRysaJmg' OR "host_id"='5dgjNR6Ru9VbmhJBSeWmQm17VSEYcstgQini429ePEyG' OR "host_id"='Frog1Fks1AVN8ywFH3HTFeYojq6LQqoEPzgQFx2Kz5Ch' OR "host_id"='8uJiHDJ1b7UDQ4KFsQGJXK9nUCkokdKRJymg1Wy9nxvM' OR "host_id"='58KprHKFNHgH1Cvo4QwxWkDeJNaSQVteCoAAFUWjtESn' OR "host_id"='8xWsmbZdGLXNsrNjrVWQX8WsrDoX1dohtM2ncK9vtUvb' OR "host_id"='CwyVpfmfSiMeCexi3JgUNvaiDfYN14cLDjzT99zcBuD2' OR "host_id"='FWwwP9tNttSy9dJFxwf6ebXWfc6VJXqFNMTccrMiLFTH' OR "host_id"='2R6i8D4ZWd3TrMMvvnaJbyDYD955JZtCk8NvKyCgzL6K' OR "host_id"='CjmXSapt1ouz3CZzgkRJckBEwMSo5fVdVrizLeRscwYD' OR "host_id"='HaLanfo94ezLc3JZ55qqxr7W3qbe1PprJyv2uEtriEqN' OR "host_id"='9Ukj3PkyD3igEDJGt1QTj9ThzjK6hMiadQfa3gm7kjf1' OR "host_id"='forb5u56XgvzxiKfRt4FVNFQKJrd2LWAfNCsCqL6P7q' OR "host_id"='EUcJwf7jXskRE6NZBtFPVH2EedNvNYko8LL2WT62XctB' OR "host_id"='5XKJwdKB2Hs7pkEXzifAysjSk6q7Rt6k5KfHwmAMPtoQ' OR "host_id"='AoUwfPuiEek2thVRDhMP7HbQb9rguyab4rDiz2NAfwwA' OR "host_id"='Fxsn579uS4xAWHWNR9v4A3m2upUnACYcDuhKmL2fbRmu' OR "host_id"='CVRr5oHCAAooVbYze7CvXtRp4FUtkMCSqBZU7MVu8v8e' OR "host_id"='EopWTKUSWRnC1WPbqSpyN9RYEBAvG2nTGcoAjP7wHbkV' OR "host_id"='9bkyxgYxRrysC1ijd6iByp9idn112CnYTw243fdH2Uvr' OR "host_id"='ateamuvZX4iy2xYrNrMyGgwtTpWFiurNzHpmJMZwjar' OR "host_id"='HNq5uwktQcNFuuFYKoN1hYKVDuBZ6p8VZdfBjG1AVMso' OR "host_id"='9hQqNe3DQTiwhspatewA8EXhz12e6sq5UJVJ2qNRwnTf' OR "host_id"='AicQr2zCWBLiBwt2r6o7iTemmtyE7q5pTKyuuupbXEQA') GROUP BY time(:interval:) FILL(null)

Repair num/shreds/packets:

SELECT mean("num_packets") AS "mean_num_packets", mean("num_repairs") AS "mean_num_repairs", mean("num_shreds_received") AS "mean_num_shreds" FROM "mainnet-beta"."autogen"."recv-window-insert-shreds" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND ("host_id"='EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4' OR "host_id"='ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n' OR "host_id"='krakeNd6ednDPEXxHAmoBs1qKVM8kLg79PvWF2mhXV1' OR "host_id"='Awes4Tr6TX8JDzEhCZY2QVNimT6iD1zWHzf1vNyGvpLM' OR "host_id"='XkCriyrNwS3G4rzAXtG5B1nnvb5Ka1JtCku93VqeKAr' OR "host_id"='Certusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24' OR "host_id"='Cs23cJMRuahuKh5oNhVmLhM2UrtaZLULLF3HqrxfTnHc' OR "host_id"='DRpbCBMxVnDK7maPM5tGv6MvB3v1sRMC86PZ8okm21hy' OR "host_id"='Dokia75SVtetShgapUBoVFfYjL99fQyr1twxKKyTZKa3' OR "host_id"='Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk' OR "host_id"='Ninja1spj6n9t5hVYgF3PdnYz2PLnkt7rvaw3firmjs' OR "host_id"='Bx7SNaHfyeLZDeja9HPsn61XYjeForHtrTxLCb6cu62o' OR "host_id"='DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP' OR "host_id"='BpyjeG4SY9r3TNnc3rP22DP3wpsStFA1FaZWywNPy6dr' OR "host_id"='6TkKqq15wXjqEjNg9zqTKADwuVATR9dW3rkNnsYme1ea' OR "host_id"='DDnAqxJVFo2GVTujibHt5cjevHMSE9bo8HJaydHoshdp' OR "host_id"='2qprVNLV2BP3yApsiFgXoArtsX2oqX3hi7XsKo1vSDVP' OR "host_id"='VymDdiepH77edNcNcKBKtRUb3gbQPtPyGh5NLcWaynj' OR "host_id"='hz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe' OR "host_id"='7cVfgArCheMR6Cs4t6vz5rfnqd56vZq4ndaBrY5xkxXy' OR "host_id"='kkSzRKB5bkrtUF2MkkPUFqFmbuPppm8dkwH9SWMULJn' OR "host_id"='38mTPbpSCC3iPrdM5KKy2kXAjdSdw6GyNndMKvgHDoNv' OR "host_id"='EgxVyTgh2Msg781wt9EsqYx4fW8wSvfFAHGLaJQjghiL' OR "host_id"='7sFeozTSUYomDExsQTq59W58s4Fyj4xGmh8KLGxmEjzb' OR "host_id"='8UQ45XfTAHb8n6kMhix3MAsinKggHTGja4LE6nnQsJPf' OR "host_id"='4oSR2zEN1rXyo84x2CuMf9vRo6pdiQEALAAwpmToCHgJ' OR "host_id"='6UFbAZu536R6H9n2EtVEdB8dbZKLBax5eoPxDWgQZvRd' OR "host_id"='CKUox1FamkkPhzahNjaBytS5FCB7cJggCvcNLDLZCaDY' OR "host_id"='7brZvwqepBtCLe5NhqcENFS8jPJagny2f9eVqZoRYhMz' OR "host_id"='91yWMWM2wtsftTtgE1HA1bseRhLAg7yCuHg5GKFHn9r3' OR "host_id"='F9EcdNAwmvV7RtD4N9ncoPgMe3coVx2YNkJFWQM5yXgV' OR "host_id"='6dN61K6Y9mQpjQde4ToSjUqK6CfE1XQt8EwLeBNx6Rqm' OR "host_id"='AefX1EZnJ2KALA7e9BE1ktZWrzYiBvYgatB5Rv4vr2mt' OR "host_id"='3CvpuaRmrj2qFHQmPHiNpnHs3EosGSdbAHMbC2mqN9wB' OR "host_id"='85kaUrHo3Lb4AcbVhfzceFUxEkCNBV69Uxi2HRYE5VDh' OR "host_id"='et1UAfLg4ZNL3j9qXDs64hC55KizrDmCZz1oPtbnAKP' OR "host_id"='74theNPM1xGD5Pk54vV8hyBKF8Fqs1BgzTceGmcYVxiW' OR "host_id"='AZhAEf79gCXexHTasaByZQS8fks73aCUkDW8rRVLiiXT' OR "host_id"='EaRH6eMWnXKXhw1tqve6eUXnsoWYUFKeSbXUyBEqyPYJ' OR "host_id"='7iZsWtW2dGtLowEYT88hvtDL3AWA3cwiyqcaVPwA5hUX' OR "host_id"='2mMGsb5uy1Q4Dvezr8HK2E8SJoChcb2X7b61tJPaVHHd' OR "host_id"='G28BTgvAEGH1QtPWhQkak7yHj5ucgno6dPRq4FyDsApU' OR "host_id"='cCvd3F8D9ddpdyYNb911sGsMGDm6SEYVm2Dnqhw3Qjx' OR "host_id"='RBFiUqjYuy4mupzZaU96ctXJBy23sRBRsL3KivDAsFM' OR "host_id"='G2TBEh2ahNGS9tGnuBNyDduNjyfUtGhMcssgRb8b6KfH' OR "host_id"='A5EGLkDcDFtMcB3Mtdn6cYgeAq1gDvx9Yop7y8eyt9MN' OR "host_id"='LunaowJnt875WWoqDkhHhE93SNYHa6tfFNVn1rqc57c' OR "host_id"='7PdKhpKz7T39vZHFL1UfcYNDsLvay6hp4KPQq1aUckFf' OR "host_id"='2dfgsiSaZ51QYPsECMYMG247PXxyKdwkV9wTHoQb8YEC' OR "host_id"='MCFmmmXdzTKjBEoMggi8JGFJmd856uYSowuH2sCU5kx' OR "host_id"='2nDgb2py4cjHy8dxWGPUUR5641SSHCBEjnGGcuyqCKCh' OR "host_id"='32G1W4XLPcPBw9goEg5WyYoq5LS9kK63uRVMeRsPFjDf' OR "host_id"='fishfishrD9BwrQQiAcG6YeYZVUYVJf3tb9QGQPMJqF' OR "host_id"='2iGccofYbsAwg9GnxJA45iRNoGQfR4oYNjnptSzNx217' OR "host_id"='2av6anjHUwvpzhbCa9vAUEEybEHs9MSU6qw3pB3o6cC7' OR "host_id"='4o27cX8MsYmyzbYq9V5a2aMTW6eC4wxonVfkik6xGYHD' OR "host_id"='GZNnph4EvmyjjL5uzF9xNNTHyV46RzbkW4w4HYU8BQCW' OR "host_id"='FR9mh1vpduVxEUySvZmj19wYZqFaPtjRyLjQ5PvyPpgB' OR "host_id"='5ZwufMjECbyqtafDZR7wiB1GTWmAKR3EWqf5TeUpADnx' OR "host_id"='3ab2iWqdSjyaVVrPTJXRR9e9orqK4AMCrnc5EMEHGu2e' OR "host_id"='HzrEstnLfzsijhaD6z5frkSE2vWZEH5EUfn3bU9swo1f' OR "host_id"='Hr7bZkosETza1xtSRgmTr8DBSMMif9RPE4U49H7LXSNu' OR "host_id"='ATPHtHvsQuZm3gBgm7r9fhuXWgTPB9pr6ZLD6UbDYLTP' OR "host_id"='3RXKQBRv7xKTQeNdLSPhCiD4QcUfxEQ12rtgUkMf5LnS' OR "host_id"='BeaCHioStqCEFDFxKwAEzyrUPYxqnBPhJ98gDKeEiTPb' OR "host_id"='3B2mGaZoFwzAnWCoZ4EAKdps4FbYbDKQ48jo8u1XWynU' OR "host_id"='FzPoMxzQJRH87NVy1YJF8BqjrygzLLHz8MYjEZPhQHnL' OR "host_id"='7wohoM4oWam7mRKEYCxU3xKoFf6Q7ft1wHqkfFrmaz7K' OR "host_id"='Dq3piY2ZcBvNN84j2EhDLtTzRAw95za7Eau89pNcmSd5' OR "host_id"='23SUe5fzmLws1M58AnGnvnUBRUKJmzCpnFQwv4M4b9Er' OR "host_id"='8WjzRz9HM2bWBopD6UPbi3swyRE5kk9aJojhn6fBKTJk' OR "host_id"='1aine15iEqZxYySNwcHtQFt4Sgc75cbEi9wks8YgNCa' OR "host_id"='2fFev6gBMMzfUzbSdVnnSzNXG9W9iZ9UNZuWpPKJKKjC' OR "host_id"='CAo1dCGYrB6NhHh5xb1cGjUiu86iyCfMTENxgHumSve4' OR "host_id"='FfM4oeeszBdHJys9yPFV6hkcZB3ea5GuMYj81aVLURVK' OR "host_id"='GmCxjmjKZoaKN1DKunbYq8RCYib94Nm3sHyncFfofaF5' OR "host_id"='9U4WqNGVywKt3gG9HSt9tGVXBDXJvgid6BVweRysaJmg' OR "host_id"='5dgjNR6Ru9VbmhJBSeWmQm17VSEYcstgQini429ePEyG' OR "host_id"='Frog1Fks1AVN8ywFH3HTFeYojq6LQqoEPzgQFx2Kz5Ch' OR "host_id"='8uJiHDJ1b7UDQ4KFsQGJXK9nUCkokdKRJymg1Wy9nxvM' OR "host_id"='58KprHKFNHgH1Cvo4QwxWkDeJNaSQVteCoAAFUWjtESn' OR "host_id"='8xWsmbZdGLXNsrNjrVWQX8WsrDoX1dohtM2ncK9vtUvb' OR "host_id"='CwyVpfmfSiMeCexi3JgUNvaiDfYN14cLDjzT99zcBuD2' OR "host_id"='FWwwP9tNttSy9dJFxwf6ebXWfc6VJXqFNMTccrMiLFTH' OR "host_id"='2R6i8D4ZWd3TrMMvvnaJbyDYD955JZtCk8NvKyCgzL6K' OR "host_id"='CjmXSapt1ouz3CZzgkRJckBEwMSo5fVdVrizLeRscwYD' OR "host_id"='HaLanfo94ezLc3JZ55qqxr7W3qbe1PprJyv2uEtriEqN' OR "host_id"='9Ukj3PkyD3igEDJGt1QTj9ThzjK6hMiadQfa3gm7kjf1' OR "host_id"='forb5u56XgvzxiKfRt4FVNFQKJrd2LWAfNCsCqL6P7q' OR "host_id"='EUcJwf7jXskRE6NZBtFPVH2EedNvNYko8LL2WT62XctB' OR "host_id"='5XKJwdKB2Hs7pkEXzifAysjSk6q7Rt6k5KfHwmAMPtoQ' OR "host_id"='AoUwfPuiEek2thVRDhMP7HbQb9rguyab4rDiz2NAfwwA' OR "host_id"='Fxsn579uS4xAWHWNR9v4A3m2upUnACYcDuhKmL2fbRmu' OR "host_id"='CVRr5oHCAAooVbYze7CvXtRp4FUtkMCSqBZU7MVu8v8e' OR "host_id"='EopWTKUSWRnC1WPbqSpyN9RYEBAvG2nTGcoAjP7wHbkV' OR "host_id"='9bkyxgYxRrysC1ijd6iByp9idn112CnYTw243fdH2Uvr' OR "host_id"='ateamuvZX4iy2xYrNrMyGgwtTpWFiurNzHpmJMZwjar' OR "host_id"='HNq5uwktQcNFuuFYKoN1hYKVDuBZ6p8VZdfBjG1AVMso' OR "host_id"='9hQqNe3DQTiwhspatewA8EXhz12e6sq5UJVJ2qNRwnTf' OR "host_id"='AicQr2zCWBLiBwt2r6o7iTemmtyE7q5pTKyuuupbXEQA') GROUP BY time(:interval:) 

Repair Total packet count (sending side):

SELECT mean("total_requests")  FROM "mainnet-beta"."autogen"."serve_repair-requests_received" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND ("host_id"='Awes4Tr6TX8JDzEhCZY2QVNimT6iD1zWHzf1vNyGvpLM' OR 
"host_id"='XkCriyrNwS3G4rzAXtG5B1nnvb5Ka1JtCku93VqeKAr' OR 
"host_id"='DRpbCBMxVnDK7maPM5tGv6MvB3v1sRMC86PZ8okm21hy' OR 
"host_id"='DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP' OR 
"host_id"='EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4' OR 
"host_id"='Certusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24' OR 
"host_id"='Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk' OR 
"host_id"='BpyjeG4SY9r3TNnc3rP22DP3wpsStFA1FaZWywNPy6dr' OR 
"host_id"='Bx7SNaHfyeLZDeja9HPsn61XYjeForHtrTxLCb6cu62o' OR 
"host_id"='Cs23cJMRuahuKh5oNhVmLhM2UrtaZLULLF3HqrxfTnHc' OR 
"host_id"='524nvr3JESQpYq5UUD7QMkpuDMg8TyyJBGr5m47jWZfe' OR 
"host_id"='LA1NEzryoih6CQW3gwQqJQffK2mKgnXcjSQZSRpM3wc' OR 
"host_id"='Ninja1spj6n9t5hVYgF3PdnYz2PLnkt7rvaw3firmjs' OR 
"host_id"='2qprVNLV2BP3yApsiFgXoArtsX2oqX3hi7XsKo1vSDVP' OR 
"host_id"='5EhGYUyQNrxgUbuYF4vbL2SZDT6RMfhq3yjeyevvULeC' OR 
"host_id"='VymDdiepH77edNcNcKBKtRUb3gbQPtPyGh5NLcWaynj' OR 
"host_id"='EgxVyTgh2Msg781wt9EsqYx4fW8wSvfFAHGLaJQjghiL' OR 
"host_id"='G2TBEh2ahNGS9tGnuBNyDduNjyfUtGhMcssgRb8b6KfH' OR 
"host_id"='DiGifdKABxzru2KsjN3YkZZmWP9mVMYK8HWadjtPtJit' OR 
"host_id"='FzQqaDStQQHs52YKeCnDovwSqvyZBCgs2kJcmvoFZwaS' OR 
"host_id"='ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n' OR 
"host_id"='BUv44cVtsdvU9z2BfFGk6s5JZZWrmVnq5qCaii5ARyyB' OR 
"host_id"='Hz5aLvpKScNWoe9YZWxBLrQA3qzHJivBGtfciMekk8m5' OR 
"host_id"='FBKFWadXZJahGtFitAsBvbqh5968gLY7dMBBJUoUjeNi' OR 
"host_id"='A4hyMd3FyvUJSRafDUSwtLLaQcxRP4r1BRC9w2AJ1to2' OR 
"host_id"='6y7V8dL673XFzm9QyC5vvh3itWkp7wztahBd2yDqsyrK' OR 
"host_id"='3JotfSFPaod4KVK7nj7ULvcq5PjUBdZNVGracNkJNhrt' OR 
"host_id"='BtsmiEEvnSuUnKxqXj2PZRYpPJAc7C34mGz8gtJ1DAaH' OR 
"host_id"='q9XWcZ7T1wP4bW9SB4XgNNwjnFEJ982nE8aVbbNuwot' OR 
"host_id"='6TkKqq15wXjqEjNg9zqTKADwuVATR9dW3rkNnsYme1ea' OR 
"host_id"='6hPGtyetcZPrG3wVDUZJjCwn59Eum3roPzkd1nx2B3oV' OR 
"host_id"='3hkPdLyQReJwdWe7Y8JL7jRhYaBCC8GZcmWwjpiLXC9f' OR 
"host_id"='BXAxLMMMUNYfC1z166VjWHR3WjTmqzLxB837o5ghmRtH' OR 
"host_id"='E4r87mnk6kkSaeNpHw2R4fSnzUR2ksajjZJDV5kpUpH2' OR 
"host_id"='GSTampk6BJRKSDkzhaMM49R7qRx98MTPYYWvKbp83XKc' OR 
"host_id"='5ejbTALcBsKQ7Cj1iSuu2mY5jqbYHqh9gF5ERXLiYj1z' OR 
"host_id"='GQzMeEMwAR44ugoNCifTb5NdRKos1GduDUPeNh6AgV46' OR 
"host_id"='BSVckjdW2f8kcXPGcrPPtV9kUDBZ8w8PjrrGVnxgEdwq' OR 
"host_id"='76rcGHdPvgs8G1XrzCXUTWtwgT59AFDvpB4VbTS2TBBJ' OR 
"host_id"='3SkE34PVeGck2ArEffFKjihrQgURsvnoTAhitsNXNzXd' OR 
"host_id"='HpcB5Qg8Y9E73dUkot5e8HkgAJbExsYeUzniY4bCuKac' OR 
"host_id"='DUND26mEDfFeaPsVof3YvbXDRvpuQX7HMUJrLgEWzYw4' OR 
"host_id"='Aw5wEMXhbygFLR7jHtHpih8QvxVBGAMTqsQ2SjWPk1ex' OR 
"host_id"='2GUnfxZavKoPfS9s3VSEjaWDzB3vNf5RojUhprCS1rSx' OR 
"host_id"='DDnAqxJVFo2GVTujibHt5cjevHMSE9bo8HJaydHoshdp' OR 
"host_id"='FbYX2uN573G5WsgiPdHU6fS5PNUyjdXfGfpZNkYUuT4k' OR 
"host_id"='EkvdKhULbMFqjKBKotAzGi3kwMvMpYNDKJXXQQmi6C1f' OR 
"host_id"='krakeNd6ednDPEXxHAmoBs1qKVM8kLg79PvWF2mhXV1' OR 
"host_id"='AP9PtZU55e3oeDuFrfMtppD8YPotTzU8avZEnSboHNR7' OR 
"host_id"='22rU5yUmdVThrkoPieVNphqEyAtMQKmZxjwcD8v4bJDU' OR 
"host_id"='HbidP4hpQdwhkzrxder3x3VNPt6DQnE25gFG46napD2p' OR 
"host_id"='HnfPZDrbJFooiP9vvgWrjx3baXVNAZCgisT58gyMCgML' OR 
"host_id"='RBFiUqjYuy4mupzZaU96ctXJBy23sRBRsL3KivDAsFM' OR 
"host_id"='AaapDdocMdZQaMAF1gXqKX2ixd7YYSxTpKHMcsbcF318' OR 
"host_id"='Frog1Fks1AVN8ywFH3HTFeYojq6LQqoEPzgQFx2Kz5Ch' OR 
"host_id"='5pPRHniefFjkiaArbGX3Y8NUysJmQ9tMZg3FrFGwHzSm' OR 
"host_id"='A5EGLkDcDFtMcB3Mtdn6cYgeAq1gDvx9Yop7y8eyt9MN' OR 
"host_id"='CXPeim1wQMkcTvEHx9QdhgKREYYJD8bnaCCqPRwJ1to1' OR 
"host_id"='Cogent51kHgGLHr7zpkpRjGYFXM57LgjHjDdqXd4ypdA' OR 
"host_id"='7QQGNm3ptwinipDCyaCF7jY5katgmFUu1ieP2f7nwLpE' OR 
"host_id"='BUtFhK4wrFyuJx1iQFkw7fPnywvo1N7xtg29MmU9CxmT' OR 
"host_id"='Ex1AxFCipXGfSxgvXPPT3nPQUARddCduHwKR6jHiXAaT' OR 
"host_id"='3fpcsJ2WPdrmpjVVA5Lmv4m9Qx5xqND1xJhFprDSjWJ4' OR 
"host_id"='fishfishrD9BwrQQiAcG6YeYZVUYVJf3tb9QGQPMJqF' OR 
"host_id"='7PdKhpKz7T39vZHFL1UfcYNDsLvay6hp4KPQq1aUckFf' OR 
"host_id"='2Qig5xnzmQwqurLSyaUpyuRZmjuna5MDT9hn66nFZd4T' OR 
"host_id"='DgwzRqBMbhjrXszuUQ177HTaGmzz6Aq3oUm4CD6bGai2' OR 
"host_id"='EMoYzBCJgHexN2auwmj1tHbmURHJhgWbuZfGoYMernyA' OR 
"host_id"='2nDgb2py4cjHy8dxWGPUUR5641SSHCBEjnGGcuyqCKCh' OR 
"host_id"='HzrEstnLfzsijhaD6z5frkSE2vWZEH5EUfn3bU9swo1f' OR 
"host_id"='2iGccofYbsAwg9GnxJA45iRNoGQfR4oYNjnptSzNx217' OR 
"host_id"='2av6anjHUwvpzhbCa9vAUEEybEHs9MSU6qw3pB3o6cC7' OR 
"host_id"='3RXKQBRv7xKTQeNdLSPhCiD4QcUfxEQ12rtgUkMf5LnS' OR 
"host_id"='Ei8VLKR3chZAhJzWwj8PopeuedpQiths2ovVCQ2BCvK7' OR 
"host_id"='7y5VhV4fkz6r4zUmH2UiwPjLwXzPL1PcV28or5NWkWRL' OR 
"host_id"='ELVtbgZzDh6fCYsFRfarkt47tDmkqYqFX8eUNLG7fq9r' OR 
"host_id"='5Us18hLZPXJTS4QVuGSsUw137Dyd2tgBaem24Xsf5nBS' OR 
"host_id"='G7kTcjJkdf5jMaFxkTAexuCNBjrZFvt8ofp8BdFPwBaC' OR 
"host_id"='ATPHtHvsQuZm3gBgm7r9fhuXWgTPB9pr6ZLD6UbDYLTP' OR 
"host_id"='FugJZepeGfh1Ruunhep19JC4F3Hr2FL3oKUMezoK8ajp' OR 
"host_id"='STaKesuXJH6UGRizuEVSWG1tyLu5ycKgWj3i1HUdvs5' OR 
"host_id"='C1ocKDYMCm2ooWptMMnpd5VEB2Nx4UMJgRuYofysyzcA' OR 
"host_id"='Hr7bZkosETza1xtSRgmTr8DBSMMif9RPE4U49H7LXSNu' OR 
"host_id"='FzPoMxzQJRH87NVy1YJF8BqjrygzLLHz8MYjEZPhQHnL' OR 
"host_id"='AicQr2zCWBLiBwt2r6o7iTemmtyE7q5pTKyuuupbXEQA' OR 
"host_id"='7wohoM4oWam7mRKEYCxU3xKoFf6Q7ft1wHqkfFrmaz7K' OR 
"host_id"='9bkyxgYxRrysC1ijd6iByp9idn112CnYTw243fdH2Uvr' OR 
"host_id"='ARgSemSL8KuwJrVMgbrgdAhdqTAwEkG9L9fBMD7zVX1y' OR 
"host_id"='HaLanfo94ezLc3JZ55qqxr7W3qbe1PprJyv2uEtriEqN' OR 
"host_id"='7CbxuNuAeZBeTKDVfiJxz8ZJphVSNVbS8T6n7kfuiXq1' OR 
"host_id"='9MySck9qTMMPMUwFnh1rAYk6eStsBkUbKSBTnAeKmJXu' OR 
"host_id"='3ab2iWqdSjyaVVrPTJXRR9e9orqK4AMCrnc5EMEHGu2e' OR 
"host_id"='7cVfgArCheMR6Cs4t6vz5rfnqd56vZq4ndaBrY5xkxXy' OR 
"host_id"='GmCxjmjKZoaKN1DKunbYq8RCYib94Nm3sHyncFfofaF5' OR 
"host_id"='4o27cX8MsYmyzbYq9V5a2aMTW6eC4wxonVfkik6xGYHD' OR 
"host_id"='Va1idLRtYEtVFJFsvz8vtt1uCJgea4Q1zi2Rh3eraJh' OR 
"host_id"='8uJiHDJ1b7UDQ4KFsQGJXK9nUCkokdKRJymg1Wy9nxvM' OR 
"host_id"='5dgjNR6Ru9VbmhJBSeWmQm17VSEYcstgQini429ePEyG' OR 
"host_id"='AnoQ3whjumVaJsBX4r7skgGebzq2sk2XTqPtV7tqnTHf' OR 
"host_id"='MCFmmmXdzTKjBEoMggi8JGFJmd856uYSowuH2sCU5kx') GROUP BY time(:interval:) FILL(null)

[jbiseda]

For the events starting at `2023-09-19T21:00:00.0Z' (repair increase, num_shred/num_packet divergence):
There's a substantial increase in shred_version_mismatch which is leading to the packet/shred count divergence.

SELECT mean("slot_out_of_range") AS "mean_slot_out_of_range", mean("slot_bad_deserialize") AS "mean_slot_bad_deserialize", mean("shred_version_mismatch") AS "mean_shred_version_mismatch", mean("index_overrun") AS "mean_index_overrun", mean("index_out_of_bounds") AS "mean_index_out_of_bounds", mean("index_bad_deserialize") AS "mean_index_bad_deserialize", mean("bad_shred_type") AS "mean_bad_shred_type", mean("bad_parent_offset") AS "mean_bad_parent_offset" FROM "mainnet-beta"."autogen"."shred_fetch" WHERE time > '2023-09-19T12:00:00.0Z' AND time < '2023-09-20T12:00:00.0Z' AND ("host_id"='EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4' OR "host_id"='ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n' OR "host_id"='krakeNd6ednDPEXxHAmoBs1qKVM8kLg79PvWF2mhXV1' OR "host_id"='Awes4Tr6TX8JDzEhCZY2QVNimT6iD1zWHzf1vNyGvpLM' OR "host_id"='XkCriyrNwS3G4rzAXtG5B1nnvb5Ka1JtCku93VqeKAr' OR "host_id"='Certusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24' OR "host_id"='Cs23cJMRuahuKh5oNhVmLhM2UrtaZLULLF3HqrxfTnHc' OR "host_id"='DRpbCBMxVnDK7maPM5tGv6MvB3v1sRMC86PZ8okm21hy' OR "host_id"='Dokia75SVtetShgapUBoVFfYjL99fQyr1twxKKyTZKa3' OR "host_id"='Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk' OR "host_id"='Ninja1spj6n9t5hVYgF3PdnYz2PLnkt7rvaw3firmjs' OR "host_id"='Bx7SNaHfyeLZDeja9HPsn61XYjeForHtrTxLCb6cu62o' OR "host_id"='DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP' OR "host_id"='BpyjeG4SY9r3TNnc3rP22DP3wpsStFA1FaZWywNPy6dr' OR "host_id"='6TkKqq15wXjqEjNg9zqTKADwuVATR9dW3rkNnsYme1ea' OR "host_id"='DDnAqxJVFo2GVTujibHt5cjevHMSE9bo8HJaydHoshdp' OR "host_id"='2qprVNLV2BP3yApsiFgXoArtsX2oqX3hi7XsKo1vSDVP' OR "host_id"='VymDdiepH77edNcNcKBKtRUb3gbQPtPyGh5NLcWaynj' OR "host_id"='hz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe' OR "host_id"='7cVfgArCheMR6Cs4t6vz5rfnqd56vZq4ndaBrY5xkxXy' OR "host_id"='kkSzRKB5bkrtUF2MkkPUFqFmbuPppm8dkwH9SWMULJn' OR "host_id"='38mTPbpSCC3iPrdM5KKy2kXAjdSdw6GyNndMKvgHDoNv' OR "host_id"='EgxVyTgh2Msg781wt9EsqYx4fW8wSvfFAHGLaJQjghiL' OR "host_id"='7sFeozTSUYomDExsQTq59W58s4Fyj4xGmh8KLGxmEjzb' OR "host_id"='8UQ45XfTAHb8n6kMhix3MAsinKggHTGja4LE6nnQsJPf' OR "host_id"='4oSR2zEN1rXyo84x2CuMf9vRo6pdiQEALAAwpmToCHgJ' OR "host_id"='6UFbAZu536R6H9n2EtVEdB8dbZKLBax5eoPxDWgQZvRd' OR "host_id"='CKUox1FamkkPhzahNjaBytS5FCB7cJggCvcNLDLZCaDY' OR "host_id"='7brZvwqepBtCLe5NhqcENFS8jPJagny2f9eVqZoRYhMz' OR "host_id"='91yWMWM2wtsftTtgE1HA1bseRhLAg7yCuHg5GKFHn9r3' OR "host_id"='F9EcdNAwmvV7RtD4N9ncoPgMe3coVx2YNkJFWQM5yXgV' OR "host_id"='6dN61K6Y9mQpjQde4ToSjUqK6CfE1XQt8EwLeBNx6Rqm' OR "host_id"='AefX1EZnJ2KALA7e9BE1ktZWrzYiBvYgatB5Rv4vr2mt' OR "host_id"='3CvpuaRmrj2qFHQmPHiNpnHs3EosGSdbAHMbC2mqN9wB' OR "host_id"='85kaUrHo3Lb4AcbVhfzceFUxEkCNBV69Uxi2HRYE5VDh' OR "host_id"='et1UAfLg4ZNL3j9qXDs64hC55KizrDmCZz1oPtbnAKP' OR "host_id"='74theNPM1xGD5Pk54vV8hyBKF8Fqs1BgzTceGmcYVxiW' OR "host_id"='AZhAEf79gCXexHTasaByZQS8fks73aCUkDW8rRVLiiXT' OR "host_id"='EaRH6eMWnXKXhw1tqve6eUXnsoWYUFKeSbXUyBEqyPYJ' OR "host_id"='7iZsWtW2dGtLowEYT88hvtDL3AWA3cwiyqcaVPwA5hUX' OR "host_id"='2mMGsb5uy1Q4Dvezr8HK2E8SJoChcb2X7b61tJPaVHHd' OR "host_id"='G28BTgvAEGH1QtPWhQkak7yHj5ucgno6dPRq4FyDsApU' OR "host_id"='cCvd3F8D9ddpdyYNb911sGsMGDm6SEYVm2Dnqhw3Qjx' OR "host_id"='RBFiUqjYuy4mupzZaU96ctXJBy23sRBRsL3KivDAsFM' OR "host_id"='G2TBEh2ahNGS9tGnuBNyDduNjyfUtGhMcssgRb8b6KfH' OR "host_id"='A5EGLkDcDFtMcB3Mtdn6cYgeAq1gDvx9Yop7y8eyt9MN' OR "host_id"='LunaowJnt875WWoqDkhHhE93SNYHa6tfFNVn1rqc57c' OR "host_id"='7PdKhpKz7T39vZHFL1UfcYNDsLvay6hp4KPQq1aUckFf' OR "host_id"='2dfgsiSaZ51QYPsECMYMG247PXxyKdwkV9wTHoQb8YEC' OR "host_id"='MCFmmmXdzTKjBEoMggi8JGFJmd856uYSowuH2sCU5kx' OR "host_id"='2nDgb2py4cjHy8dxWGPUUR5641SSHCBEjnGGcuyqCKCh' OR "host_id"='32G1W4XLPcPBw9goEg5WyYoq5LS9kK63uRVMeRsPFjDf' OR "host_id"='fishfishrD9BwrQQiAcG6YeYZVUYVJf3tb9QGQPMJqF' OR "host_id"='2iGccofYbsAwg9GnxJA45iRNoGQfR4oYNjnptSzNx217' OR "host_id"='2av6anjHUwvpzhbCa9vAUEEybEHs9MSU6qw3pB3o6cC7' OR "host_id"='4o27cX8MsYmyzbYq9V5a2aMTW6eC4wxonVfkik6xGYHD' OR "host_id"='GZNnph4EvmyjjL5uzF9xNNTHyV46RzbkW4w4HYU8BQCW' OR "host_id"='FR9mh1vpduVxEUySvZmj19wYZqFaPtjRyLjQ5PvyPpgB' OR "host_id"='5ZwufMjECbyqtafDZR7wiB1GTWmAKR3EWqf5TeUpADnx' OR "host_id"='3ab2iWqdSjyaVVrPTJXRR9e9orqK4AMCrnc5EMEHGu2e' OR "host_id"='HzrEstnLfzsijhaD6z5frkSE2vWZEH5EUfn3bU9swo1f' OR "host_id"='Hr7bZkosETza1xtSRgmTr8DBSMMif9RPE4U49H7LXSNu' OR "host_id"='ATPHtHvsQuZm3gBgm7r9fhuXWgTPB9pr6ZLD6UbDYLTP' OR "host_id"='3RXKQBRv7xKTQeNdLSPhCiD4QcUfxEQ12rtgUkMf5LnS' OR "host_id"='BeaCHioStqCEFDFxKwAEzyrUPYxqnBPhJ98gDKeEiTPb' OR "host_id"='3B2mGaZoFwzAnWCoZ4EAKdps4FbYbDKQ48jo8u1XWynU' OR "host_id"='FzPoMxzQJRH87NVy1YJF8BqjrygzLLHz8MYjEZPhQHnL' OR "host_id"='7wohoM4oWam7mRKEYCxU3xKoFf6Q7ft1wHqkfFrmaz7K' OR "host_id"='Dq3piY2ZcBvNN84j2EhDLtTzRAw95za7Eau89pNcmSd5' OR "host_id"='23SUe5fzmLws1M58AnGnvnUBRUKJmzCpnFQwv4M4b9Er' OR "host_id"='8WjzRz9HM2bWBopD6UPbi3swyRE5kk9aJojhn6fBKTJk' OR "host_id"='1aine15iEqZxYySNwcHtQFt4Sgc75cbEi9wks8YgNCa' OR "host_id"='2fFev6gBMMzfUzbSdVnnSzNXG9W9iZ9UNZuWpPKJKKjC' OR "host_id"='CAo1dCGYrB6NhHh5xb1cGjUiu86iyCfMTENxgHumSve4' OR "host_id"='FfM4oeeszBdHJys9yPFV6hkcZB3ea5GuMYj81aVLURVK' OR "host_id"='GmCxjmjKZoaKN1DKunbYq8RCYib94Nm3sHyncFfofaF5' OR "host_id"='9U4WqNGVywKt3gG9HSt9tGVXBDXJvgid6BVweRysaJmg' OR "host_id"='5dgjNR6Ru9VbmhJBSeWmQm17VSEYcstgQini429ePEyG' OR "host_id"='Frog1Fks1AVN8ywFH3HTFeYojq6LQqoEPzgQFx2Kz5Ch' OR "host_id"='8uJiHDJ1b7UDQ4KFsQGJXK9nUCkokdKRJymg1Wy9nxvM' OR "host_id"='58KprHKFNHgH1Cvo4QwxWkDeJNaSQVteCoAAFUWjtESn' OR "host_id"='8xWsmbZdGLXNsrNjrVWQX8WsrDoX1dohtM2ncK9vtUvb' OR "host_id"='CwyVpfmfSiMeCexi3JgUNvaiDfYN14cLDjzT99zcBuD2' OR "host_id"='FWwwP9tNttSy9dJFxwf6ebXWfc6VJXqFNMTccrMiLFTH' OR "host_id"='2R6i8D4ZWd3TrMMvvnaJbyDYD955JZtCk8NvKyCgzL6K' OR "host_id"='CjmXSapt1ouz3CZzgkRJckBEwMSo5fVdVrizLeRscwYD' OR "host_id"='HaLanfo94ezLc3JZ55qqxr7W3qbe1PprJyv2uEtriEqN' OR "host_id"='9Ukj3PkyD3igEDJGt1QTj9ThzjK6hMiadQfa3gm7kjf1' OR "host_id"='forb5u56XgvzxiKfRt4FVNFQKJrd2LWAfNCsCqL6P7q' OR "host_id"='EUcJwf7jXskRE6NZBtFPVH2EedNvNYko8LL2WT62XctB' OR "host_id"='5XKJwdKB2Hs7pkEXzifAysjSk6q7Rt6k5KfHwmAMPtoQ' OR "host_id"='AoUwfPuiEek2thVRDhMP7HbQb9rguyab4rDiz2NAfwwA' OR "host_id"='Fxsn579uS4xAWHWNR9v4A3m2upUnACYcDuhKmL2fbRmu' OR "host_id"='CVRr5oHCAAooVbYze7CvXtRp4FUtkMCSqBZU7MVu8v8e' OR "host_id"='EopWTKUSWRnC1WPbqSpyN9RYEBAvG2nTGcoAjP7wHbkV' OR "host_id"='9bkyxgYxRrysC1ijd6iByp9idn112CnYTw243fdH2Uvr' OR "host_id"='ateamuvZX4iy2xYrNrMyGgwtTpWFiurNzHpmJMZwjar' OR "host_id"='HNq5uwktQcNFuuFYKoN1hYKVDuBZ6p8VZdfBjG1AVMso' OR "host_id"='9hQqNe3DQTiwhspatewA8EXhz12e6sq5UJVJ2qNRwnTf' OR "host_id"='AicQr2zCWBLiBwt2r6o7iTemmtyE7q5pTKyuuupbXEQA') GROUP BY time(:interval:) FILL(null)

If we have any data from this log line it might be useful:

solana/core/src/window_service.rs

Line 120 in 2839d51

"num addresses: {}, top packets by source: {:?}",

SELECT top("total_time_ms", 100) AS "total_time_ms", "host_id" FROM "mainnet-beta"."autogen"."shred_insert_is_full" WHERE time > '2023-09-20T17:57:00.0Z' AND time < '2023-09-20T17:57:30.0Z'

points to 3THprEXdsRkJdsBvqnMf6RAVenyqW2ax9y3SRHfg3Jj1 which I found on devnet:

target/release/solana-gossip spy --entrypoint entrypoint2.devnet.solana.com:8001 2>&1|grep 3THprEXdsRkJdsBvqnMf6RAVenyqW2ax9y3SRHfg3Jj1
    217.28.63.147     |   188 | 3THprEXdsRkJdsBvqnMf6RAVenyqW2ax9y3SRHfg3Jj1 | 1.14.28 | 8002 |  8007 | 8005 | 8006 | 8003 | 8004 | 8010 | 38642