@verita84eva @colonelj @i @ChristiJunior @admin Maybe try sorting by actor, there ought to be some clue on which servers take the most space.
select data->>'actor', count(data->>'actor') as count from activities group by data->>'actor' order by count desc;
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.