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,152,058
stories
[ 0.10 ms ] 42,529,399
comments
[ 0.07 ms ] 1,513,407
users
[ 0.07 ms ] 50,194,864
total records
across 3 objectsTop story authors
[ 0.01 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 Tomte
- 3 tosh
- 4 mooreds
- 5 bookofjoe
- 6 pseudolus
- 7 PaulHoule
- 8 todsacerdoti
- 9 ingve
- 10 thunderbong
- 11 jonbaer
- 12 Brajeshwar
- 13 rntn
- 14 doener
- 15 LinuxBender
- 16 paulpauper
- 17 JumpCrisscross
- 18 gmays
- 19 evo_9
- 20 jseliger
Top commenters
[ 0.01 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 jacquesm
- 8 toomuchtodo
- 9 JumpCrisscross
- 10 rayiner
- 11 amelius
- 12 dredmorbius
- 13 ghaff
- 14 pjc50
- 15 Retric
- 16 saagarjha
- 17 eru
- 18 ceejayoz
- 19 Dylan16807
- 20 Animats
Top users by karma
[ 0.06 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 rms
- 2 cookiecaper
- 3 grandalf
- 4 gnaritas
- 5 DannoHung
- 6 malvosenior
- 7 icefox
- 8 CamperBob
- 9 codex
- 10 tjogin
- 11 pilom
- 12 dmethvin
- 13 rpsubhub
- 14 mbateman
- 15 maryrosecook
- 16 skorks
- 17 igorgue
- 18 spydez
- 19 nolanbrown23
- 20 dmoney
stories
[ 2.2 ms ]show shard-db query
{
"mode": "describe-object",
"dir": "hn",
"object": "stories"
}6,152,058 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
[ 2.9 ms ]show shard-db query
{
"mode": "describe-object",
"dir": "hn",
"object": "comments"
}42,529,399 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
[ 5.5 ms ]show shard-db query
{
"mode": "describe-object",
"dir": "hn",
"object": "users"
}1,513,407 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: 10.9 ms; wall-clock was 5.5 ms because they run in parallel.