I

Data Volume Treemap

Relative row counts — WSL dwarfs everything.

completeness · scale
621,307 backbone rows

Data Volume Treemap

Coverage isn't only whichtables exist — it's how much is in them. Here every vertical is sized by its real backbone row count. World Surf League holds 86.3% of all rows on its own; the other three combined are barely 13.7%. Areas are proportional — a rectangle twice as big holds twice the rows.

Total rows

621,307

across the backbone

Largest vertical

World

536,073 rows

WSL share

86.3%

of all rows

Biggest cell

274,159

wsl · results

Rows by vertical — area = share of all backbone rows

World Surf League

asd_wsl

536,073

86.3% of all rows

Major Arena Soccer League

asd_masl

32,147

5.17% of all rows

High Limit Racing

asd_hlr

30,428

4.90% of all rows

Supercross / Motocross

asd_smx

22,659

3.65% of all rows

WSL is a single full-height column because it alone is 86.3% of the data. The three narrow stacked blocks are SMX, MASL and HLR at true relative size — all solid, all 6/6 on the spine, just two orders of magnitude smaller.

Where the rows live — six backbone tables per sport

World Surf Leagueasd_wsl
536,073 rows
competitions 84,480
results 274,159
event_results 161,030
Major Arena Soccer Leagueasd_masl
32,147 rows
competitions 8,620
results 17,240
event_results 4,150
High Limit Racingasd_hlr
30,428 rows
results 24,526
Supercross / Motocrossasd_smx
22,659 rows
results 16,794
event_results 4,115
competitorseventscompetitionsresultsevent_resultsseasons

Biggest cells in the product

wsl.results
274,159
wsl.event_results
161,030
wsl.competitions
84,480
hlr.results
24,526
masl.results
17,240
smx.results
16,794

Five of the six largest cells are WSL. Its resultstable alone is bigger than every other sport's entire backbone combined.

What this means for query cost

Scale is a feature and a footgun. An unbounded SELECT * FROM asd_wsl.results pulls 274,159 rows back through the paged Data API — always LIMIT exploratory WSL queries.

And remember the shape trap: MASL competitors = 47 rows because those are teams, not people — real MASL players live in masl_players. Small isn't incomplete.

Pulled with AWS_PROFILE=asd against Redshift Serverless (us-west-1 / default-workgroup / dev).