diff options
| author | Bryan Newbold <bnewbold@archive.org> | 2020-01-02 18:11:24 -0800 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@archive.org> | 2020-01-02 18:13:03 -0800 |
| commit | fdff17d2cdf4ac92a0458403bb4ca0b073a7752b (patch) | |
| tree | dfacd521b1e8b43ab3a4f54cce7d9bc3320b1255 | |
| parent | 34f8d3d32845774d7fc8690350084eabff54e44f (diff) | |
| download | sandcrawler-fdff17d2cdf4ac92a0458403bb4ca0b073a7752b.tar.gz sandcrawler-fdff17d2cdf4ac92a0458403bb4ca0b073a7752b.zip | |
sql: more cool random queries
| -rw-r--r-- | sql/random_queries.md | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/random_queries.md b/sql/random_queries.md index 6ae651a..604088a 100644 --- a/sql/random_queries.md +++ b/sql/random_queries.md @@ -53,3 +53,8 @@ Time: 189067.335 ms (03:09.067) ) r LIMIT 5; +More stats (2019-12-27): + + SELECT mimetype, COUNT(*) FROM file_meta GROUP BY mimetype ORDER BY COUNT(*) DESC LIMIT 20; + + SELECT SUM(size_bytes) FROM file_meta; |