Observatory DB — 2026-06-24
Observatory DB Merge Report
Date: 2026-06-24 10:58:00.638096
Output: observatory.db (245,907,456)
Sources
| Source | Status | Size | Tables | Total Rows |
|---|---|---|---|---|
| feed.db | merged | 86,343,680 | packages, package_versions, reverse_dependencies, package_version_history (4) | 601,757 |
| metadata.db | merged | 117,968,896 | check_status_history, cran_check_results, cran_check_details, cran_check_issues, authors, packages_enrichment, removal_reasons, package_news (8) | 485,667 |
| downloads-summary.db | merged | 1,679,360 | downloads_summary (1) | 24,758 |
| queue.db | merged | 37,347,328 | queue_snapshots, queue_history_daily, queue_stats (3) | 278,631 |
Combined Tables
- authors: 61,523 rows
- check_status_history: 59,649 rows
- cran_check_details: 27,968 rows
- cran_check_issues: 424 rows
- cran_check_results: 311,955 rows
- downloads_summary: 24,758 rows
- package_news: 95 rows
- package_version_history: 162,338 rows
- package_versions: 187,166 rows
- packages: 24,033 rows
- packages_enrichment: 24,053 rows
- packages_fts: 24,033 rows
- packages_fts_config: 1 rows
- packages_fts_data: 2,058 rows
- packages_fts_docsize: 24,033 rows
- packages_fts_idx: 1,872 rows
- queue_history_daily: 10,645 rows
- queue_snapshots: 267,946 rows
- queue_stats: 40 rows
- removal_reasons: 0 rows
- reverse_dependencies: 228,220 rows
Total DB size: 245,907,456 bytes