Observatory DB — 2026-06-27
Observatory DB Merge Report
Date: 2026-06-27 10:16:26.171549
Output: observatory.db (246,837,248)
Sources
| Source | Status | Size | Tables | Total Rows |
|---|---|---|---|---|
| feed.db | merged | 86,560,768 | packages, package_versions, reverse_dependencies, package_version_history (4) | 602,582 |
| metadata.db | merged | 118,120,448 | check_status_history, cran_check_results, cran_check_details, cran_check_issues, authors, packages_enrichment, removal_reasons, package_news (8) | 486,888 |
| downloads-summary.db | merged | 1,679,360 | downloads_summary (1) | 24,825 |
| queue.db | merged | 38,019,072 | queue_snapshots, queue_history_daily, queue_stats (3) | 283,556 |
Combined Tables
- authors: 61,736 rows
- check_status_history: 60,002 rows
- cran_check_details: 27,702 rows
- cran_check_issues: 423 rows
- cran_check_results: 312,826 rows
- downloads_summary: 24,825 rows
- package_news: 95 rows
- package_version_history: 162,338 rows
- package_versions: 187,328 rows
- packages: 24,090 rows
- packages_enrichment: 24,104 rows
- packages_fts: 24,090 rows
- packages_fts_config: 1 rows
- packages_fts_data: 2,066 rows
- packages_fts_docsize: 24,090 rows
- packages_fts_idx: 1,885 rows
- queue_history_daily: 10,645 rows
- queue_snapshots: 272,871 rows
- queue_stats: 40 rows
- removal_reasons: 0 rows
- reverse_dependencies: 228,826 rows
Total DB size: 246,837,248 bytes