Skip to content

Observatory DB — 2026-06-20

Choose a tag to compare

View all tags
@github-actions github-actions released this 20 Jun 10:37
v2026-06-20
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-20 10:37:42.696269

Output: observatory.db (244,461,568)

Sources

Source Status Size Tables Total Rows
feed.db merged 86,220,800 packages, package_versions, reverse_dependencies, package_version_history (4) 600,809
metadata.db merged 117,575,680 check_status_history, cran_check_results, cran_check_details, cran_check_issues, authors, packages_enrichment, removal_reasons, package_news (8) 484,540
downloads-summary.db merged 1,671,168 downloads_summary (1) 24,694
queue.db merged 36,417,536 queue_snapshots, queue_history_daily, queue_stats (3) 271,893

Combined Tables

  • authors: 61,392 rows
  • check_status_history: 59,319 rows
  • cran_check_details: 28,039 rows
  • cran_check_issues: 423 rows
  • cran_check_results: 311,281 rows
  • downloads_summary: 24,694 rows
  • package_news: 95 rows
  • package_version_history: 162,338 rows
  • package_versions: 186,949 rows
  • packages: 23,977 rows
  • packages_enrichment: 23,991 rows
  • packages_fts: 23,977 rows
  • packages_fts_config: 1 rows
  • packages_fts_data: 2,053 rows
  • packages_fts_docsize: 23,977 rows
  • packages_fts_idx: 1,867 rows
  • queue_history_daily: 10,645 rows
  • queue_snapshots: 261,208 rows
  • queue_stats: 40 rows
  • removal_reasons: 0 rows
  • reverse_dependencies: 227,545 rows

Total DB size: 244,461,568 bytes

Assets 3
Loading