Observatory DB Merge Report
Date: 2026-06-28 22:08:48.797324
Output: observatory.db (249,040,896)
Sources
| Source | Status | Size | Tables | Total Rows |
|---|---|---|---|---|
| feed.db | merged | 86,560,768 | packages, package_versions, reverse_dependencies, package_version_history (4) | 602,606 |
| 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,936 |
| downloads-summary.db | merged | 1,683,456 | downloads_summary (1) | 24,852 |
| r2u-summary.db | merged | 2,310,144 | r2u_downloads_summary (1) | 28,864 |
| queue.db | merged | 38,588,416 | queue_snapshots, queue_history_daily, queue_stats (3) | 287,752 |
Combined Tables
- authors: 61,738 rows
- check_status_history: 60,013 rows
- cran_check_details: 27,702 rows
- cran_check_issues: 419 rows
- cran_check_results: 312,865 rows
- downloads_summary: 24,852 rows
- package_news: 95 rows
- package_version_history: 162,338 rows
- package_versions: 187,360 rows
- packages: 24,089 rows
- packages_enrichment: 24,104 rows
- packages_fts: 24,089 rows
- packages_fts_config: 1 rows
- packages_fts_data: 2,067 rows
- packages_fts_docsize: 24,089 rows
- packages_fts_idx: 1,883 rows
- queue_history_daily: 10,645 rows
- queue_snapshots: 277,067 rows
- queue_stats: 40 rows
- r2u_downloads_summary: 28,864 rows
- removal_reasons: 0 rows
- reverse_dependencies: 228,819 rows
Total DB size: 249,040,896 bytes