Determining Prolific Authors

You can identify prolific authors of your textual data without using any of the Pulse functions. For example, using the same dataset as the examples in Determining Popular Topics, you can easily determine how many tweets were made by authors:

select "user.name", count(*) as post_count from tweets group by 
"user.name" order by count(*) DESC limit 10;
      user.name       | post_count
----------------------+------------
 Nick Cicero          |        182
 Networked Society    |        171
 AllThingsD           |        137
 Stephanie~           |        117
 Jennifer Ives        |        105
 Claudia-ElasticMinds |        101
 Needful Things       |         96
 Poptart Tech         |         85
 Patrick Bertrand     |         84
 Alessandro Piol      |         81
(10 rows)