emojistats ops

stalled · 17,993s behind6:28:55 PM

Live ingest

Jetstream worker, all-time totals

posts/s · 1m

0.0

0/min

posts/s · 15m

0.0

0/min

freshness

17,993s

worker stalled?

posts total

2.8B

2,799,659,737

with emojis

510.4M

18.2% of posts

emoji occurrences

1.4B

1,422,667,194

distinct glyphs

4,274

Top emojis

by occurrences — divergence from posts marks spam

emoji	occurrences	posts	occ/post
🐑	491,152,727	1,806,118	271.9
😭	48,408,145	25,910,739	1.9
😂	47,331,923	28,967,102	1.6
🟩	43,312,918	4,908,445	8.8
🤣	36,311,608	18,411,390	2.0
❤️	27,645,257	18,937,866	1.5
✨	26,610,489	19,716,761	1.3
💃	22,531,715	558,958	40.3
🔥	21,245,142	12,353,013	1.7
⬜️	21,140,675	2,396,732	8.8

Languages

top 8 by emoji occurrences

lang	occurrences	posts
en	736,705,639	311,863,087
unknown	601,983,492	37,735,261
ja	169,873,394	70,931,510
pt	89,575,444	37,510,460
de	66,587,079	33,197,724
es	50,660,243	20,467,359
fr	30,920,587	14,223,014
nl	9,098,272	4,959,688

Last 24h

posts per hour (local time)

ClickHouse health

288 active parts · 57.4 GiB on disk

table	parts	on disk
posts	207	55.5 GiB
backfill_repo_events	5	1.2 GiB
emoji_hourly_by_lang	19	492.2 MiB
emoji_hourly	21	172.2 MiB
live_ingest_second	16	2.8 MiB
backfill_progress	2	2.8 MiB
emoji_total_by_lang	3	1.7 MiB
posts_hourly	10	815.9 KiB
emoji_total	2	108.7 KiB
backfill_verify_progress	1	69.4 KiB
lang_total	1	10.8 KiB
backfill_status_reason_counts	1	2.3 KiB

Backfill

full-network crawl telemetry

details →

pending 29,659fetching 0loaded 14,009,939verified 10,109,270empty 26,396,611unreachable 30,360,838tombstoned 2,305deactivated 423,822takendown 2,911,622quarantined 17,111failed 21,318,334

repos/min

posts loaded

2.6B

2,623,769,701

ETA

—

last error: did:plc:4thfetd2jdk434tqciuaxyv7: malformed car: decoded value contains remainder