クエリちょっと重かったけどだいたい日本語として検出されてたねー
> SELECT language, count(1) FROM statuses WHERE local=true AND reblog_of_id IS NULL AND created_at > now() - interval '1 month' GROUP BY language ORDER by count DESC;
language | count
----------+-------
ja | 1994
en | 36
kk | 17
zh | 11
sn | 5
bg | 4
| 3
de | 2
fy | 1
la | 1
nl | 1
sm | 1
sr | 1
cy | 1
id | 1
| 1
(16 rows)
Time: 13706.576 ms (00:13.707)