Products > Database > DatabaseDocumentation > DatabaseSchema > Statistics

Database Schema: Statistics

See the Database Schema page for an overview of the MusicBrainz Database and links to pages which describe each parts of the schema in more detail (like this page).

• Every night certain measurements are taken and stored in the statistics tables. These statistics are used to generate the database statistics page. Originally there was just the stats table - it tracked (for each day) a count of how many artists, releases, tracks, disc IDs, TRMs, edits, votes and editors were stored in the database.

• These days however the stats table is not used anymore - it has been superseded by the currentstat and historicalstat tables. Each night various measurements are taken, and those counts are stored in both tables - currentstat just stores the most up-to-date value of each measurement, and historicalstat stores all the point-in-time measurements for historical and analytic purposes. Each stat has a textual "key" (e.g. "count.album.has_discid" is how many releases there are with at least one DiscID attributed to). See Statistic.pm for more details on what stats we keep, and which keys they are stored under.

CategoryWikiDocsPage CategoryDevelopment