Stats
Every panel below is a single round-trip to shard-db. The badge next to each title is its actual server-side latency, measured by the SvelteKit loader. Click show shard-db query to see the JSON we sent.
6,334,553
stories
[ 19.4 ms ] 43,343,004
comments
[ 18.7 ms ] 1,632,117
users
[ 13.5 ms ] 51,309,674
total records
across 3 objectsTop story authors
[ 0.03 ms ]show shard-db query
{
"mode": "aggregate",
"dir": "hn",
"object": "stories",
"group_by": [
"by"
],
"aggregates": [
{
"fn": "count",
"alias": "stories"
}
],
"criteria": [
{
"field": "type",
"op": "eq",
"value": "story"
}
],
"order_by": "stories",
"order": "desc",
"limit": 20,
"timeout_ms": 60000
}- 1 rbanffy
- 2 tosh
- 3 Tomte
- 4 mooreds
- 5 bookofjoe
- 6 pseudolus
- 7 PaulHoule
- 8 todsacerdoti
- 9 ingve
- 10 thunderbong
- 11 jonbaer
- 12 Brajeshwar
- 13 doener
- 14 rntn
- 15 LinuxBender
- 16 paulpauper
- 17 JumpCrisscross
- 18 evo_9
- 19 gmays
- 20 jseliger
Top commenters
[ 0.03 ms ]show shard-db query
{
"mode": "aggregate",
"dir": "hn",
"object": "comments",
"group_by": [
"by"
],
"aggregates": [
{
"fn": "count",
"alias": "comments"
}
],
"order_by": "comments",
"order": "desc",
"limit": 20,
"timeout_ms": 120000
}- 1 dang
- 2 tptacek
- 3 pjmlp
- 4 dragonwriter
- 5 coldtea
- 6 TeMPOraL
- 7 toomuchtodo
- 8 rayiner
- 9 jacquesm
- 10 JumpCrisscross
- 11 amelius
- 12 dredmorbius
- 13 pjc50
- 14 ghaff
- 15 Retric
- 16 WalterBright
- 17 eru
- 18 saagarjha
- 19 ceejayoz
- 20 rbanffy
Top users by karma
[ 13.4 ms ]show shard-db query
{
"mode": "find",
"dir": "hn",
"object": "users",
"criteria": [],
"order_by": "karma",
"order": "desc",
"limit": 20,
"fields": [
"karma",
"created",
"submitted_count"
],
"format": "dict"
}- 1 DepressionApp
- 2 pg
- 3 prostoalex
- 4 jseliger
- 5 mikeash
- 6 lelf
- 7 PragmaticPulp
- 8 tokenadult
- 9 llambda
- 10 LinuxBender
- 11 DanBC
- 12 smacktoward
- 13 protomyth
- 14 icebraining
- 15 ssclafani
- 16 cwan
- 17 raganwald
- 18 untog
- 19 yummyfajitas
- 20 okket
stories
[ 227 ms ]show shard-db query
{
"mode": "describe-object",
"dir": "hn",
"object": "stories"
}6,334,581 records · 64 shards · 10 indexes
| field | type | bytes | indexed |
|---|---|---|---|
by | varchar | 34 | ● |
time | timestamp | 8 | ● |
score | int | 4 | ● |
url | varchar | 514 | — |
title | varchar | 130 | — |
text | varchar | 4098 | — |
descendants | int | 4 | — |
type | enum | 1 | — |
deleted | bool | 1 | — |
dead | bool | 1 | — |
composite indexes:
by+timetype+timetype+scorecomments
[ 790 ms ]show shard-db query
{
"mode": "describe-object",
"dir": "hn",
"object": "comments"
}43,343,312 records · 256 shards · 8 indexes
| field | type | bytes | indexed |
|---|---|---|---|
by | varchar | 34 | ● |
time | timestamp | 8 | ● |
parent | int | 4 | ● |
story_root | int | 4 | ● |
text | varchar | 4098 | — |
deleted | bool | 1 | — |
dead | bool | 1 | — |
composite indexes:
by+timestory_root+timeusers
[ 138 ms ]show shard-db query
{
"mode": "describe-object",
"dir": "hn",
"object": "users"
}1,632,125 records · 32 shards · 2 indexes
| field | type | bytes | indexed |
|---|---|---|---|
karma | int | 4 | ● |
created | timestamp | 8 | ● |
about | varchar | 1026 | — |
submitted_count | int | 4 | — |
Server-side timings only — no client render cost, no network RTT to your browser. Sum of all nine queries on this page: 1221.1 ms; wall-clock was 790.4 ms because they run in parallel.