{"generator":"GNU social 2.0.2-beta0","title":"Conversation","totalItems":1,"items":[{"actor":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/1005-original-20200212031327.gif","rel":"avatar","type":"image\/gif","width":120,"height":120},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-48-20200212035814.gif","rel":"avatar","type":"image\/gif","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-24-20200212035814.gif","rel":"avatar","type":"image\/gif","width":24,"height":24}],"profile_info":{"local_id":"1005"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},"objectType":"person","summary":"<p>Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>","url":"https:\/\/mastodon.zunda.ninja\/users\/zundan","portablecontacts_net":{"preferredUsername":"zundan@mastodon.zunda.ninja","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","note":"<p>Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>"}},"content":"<p>SELECT wb*50 as min, count(1), sum(count(1)) OVER (ORDER BY wb) FROM (SELECT width_bucket(char_length(spoiler_text)+char_length(text), 0, 1199, 24)-1 as wb FROM statuses LIMIT 1000000) AS t GROUP BY wb;<\/p><p> min  | count  |   sum<br \/>------+--------+---------<br \/>    0 | 585255 |  585255<br \/>   50 |  87341 |  672596<br \/>  100 | 103253 |  775849<br \/>  150 |  98207 |  874056<br \/>  200 |  26304 |  900360<br \/>  250 |  27776 |  928136<br \/>  300 |  21541 |  949677<br \/>  350 |  14415 |  964092<br \/>  400 |   9088 |  973180<br \/>  450 |   6590 |  979770<br \/>  500 |   5210 |  984980<br \/>  550 |   3252 |  988232<br \/>  600 |   2997 |  991229<br \/>  650 |   1710 |  992939<br \/>  700 |   1297 |  994236<br \/>  750 |   1026 |  995262<br \/>  800 |    735 |  995997<br \/>  850 |    498 |  996495<br \/>  900 |    450 |  996945<br \/>  950 |    450 |  997395<br \/> 1000 |    310 |  997705<br \/> 1050 |    274 |  997979<br \/> 1100 |    210 |  998189<br \/> 1150 |    188 |  998377<br \/> 1200 |   1623 | 1000000<br \/>(25 rows)<\/p><p>Time: 1657.927 ms (00:01.658)<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/100881683192897279","object":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/100881683192897279","objectType":"note","content":"<p>SELECT wb*50 as min, count(1), sum(count(1)) OVER (ORDER BY wb) FROM (SELECT width_bucket(char_length(spoiler_text)+char_length(text), 0, 1199, 24)-1 as wb FROM statuses LIMIT 1000000) AS t GROUP BY wb;<\/p><p> min  | count  |   sum<br \/>------+--------+---------<br \/>    0 | 585255 |  585255<br \/>   50 |  87341 |  672596<br \/>  100 | 103253 |  775849<br \/>  150 |  98207 |  874056<br \/>  200 |  26304 |  900360<br \/>  250 |  27776 |  928136<br \/>  300 |  21541 |  949677<br \/>  350 |  14415 |  964092<br \/>  400 |   9088 |  973180<br \/>  450 |   6590 |  979770<br \/>  500 |   5210 |  984980<br \/>  550 |   3252 |  988232<br \/>  600 |   2997 |  991229<br \/>  650 |   1710 |  992939<br \/>  700 |   1297 |  994236<br \/>  750 |   1026 |  995262<br \/>  800 |    735 |  995997<br \/>  850 |    498 |  996495<br \/>  900 |    450 |  996945<br \/>  950 |    450 |  997395<br \/> 1000 |    310 |  997705<br \/> 1050 |    274 |  997979<br \/> 1100 |    210 |  998189<br \/> 1150 |    188 |  998377<br \/> 1200 |   1623 | 1000000<br \/>(25 rows)<\/p><p>Time: 1657.927 ms (00:01.658)<\/p>","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/100881683192897279","status_net":{"notice_id":null}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mastodon.zunda.ninja,2018-10-12:objectId=2192090:objectType=Conversation","notice_info":{"local_id":"999842","source":"ostatus"}},"published":"2018-10-12T08:18:44+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/100881683192897279"}],"links":[{"url":"https:\/\/social.senooken.jp\/conversation\/695749","rel":"alternate","type":"text\/html"}]}