All queries have a LIMIT 500 (?) by default; you can change that by either
- Downloading the results raises the limit to either 10K or 100K records, I forget which
- manually running the query via the HTTP API, and increase the
limitparameter to what it needs to be.
As @Mittineague said, be careful: the
posts table includes private messages, for example. You may want to exclude those from analysis. The schema browser on the right side of the editor flags some especially sensitive columns, such as