Skip to content

Observatory DB — 2026-06-23

Choose a tag to compare

View all tags
@github-actions github-actions released this 23 Jun 11:24
v2026-06-23
4244d16
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Observatory DB Merge Report

Date: 2026-06-23 11:24:31.632812

Output: observatory.db (245,522,432)

Sources

Source Status Size Tables Total Rows
feed.db merged 86,310,912 packages, package_versions, reverse_dependencies, package_version_history (4) 601,522
metadata.db merged 117,923,840 check_status_history, cran_check_results, cran_check_details, cran_check_issues, authors, packages_enrichment, removal_reasons, package_news (8) 485,433
downloads-summary.db merged 1,675,264 downloads_summary (1) 24,752
queue.db merged 37,109,760 queue_snapshots, queue_history_daily, queue_stats (3) 276,988

Combined Tables

  • authors: 61,493 rows
  • check_status_history: 59,564 rows
  • cran_check_details: 28,018 rows
  • cran_check_issues: 430 rows
  • cran_check_results: 311,799 rows
  • downloads_summary: 24,752 rows
  • package_news: 95 rows
  • package_version_history: 162,338 rows
  • package_versions: 187,097 rows
  • packages: 24,020 rows
  • packages_enrichment: 24,034 rows
  • packages_fts: 24,020 rows
  • packages_fts_config: 1 rows
  • packages_fts_data: 2,055 rows
  • packages_fts_docsize: 24,020 rows
  • packages_fts_idx: 1,870 rows
  • queue_history_daily: 10,645 rows
  • queue_snapshots: 266,303 rows
  • queue_stats: 40 rows
  • removal_reasons: 0 rows
  • reverse_dependencies: 228,067 rows

Total DB size: 245,522,432 bytes

Assets 3
Loading