Repository navigation
Observatory DB — 2026-05-29
·
129 commits
to main
since this release
Observatory DB Merge Report
Date: 2026-05-29 11:35:49.399714
Output: observatory.db (225,320,960)
Sources
| Source | Status | Size | Tables | Total Rows |
|---|---|---|---|---|
| feed.db | merged | 85,381,120 | packages, package_versions, reverse_dependencies, package_version_history (4) | 596,448 |
| metadata.db | merged | 106,094,592 | check_status_history, cran_check_results, cran_check_details, cran_check_issues, authors, packages_enrichment, removal_reasons, package_news (8) | 464,735 |
| downloads-summary.db | merged | 1,650,688 | downloads_summary (1) | 24,368 |
| queue.db | merged | 31,207,424 | queue_snapshots, queue_history_daily, queue_stats (3) | 233,823 |
Combined Tables
- authors: 60,892 rows
- check_status_history: 42,848 rows
- cran_check_details: 28,083 rows
- cran_check_issues: 445 rows
- cran_check_results: 308,591 rows
- downloads_summary: 24,368 rows
- package_news: 94 rows
- package_version_history: 162,338 rows
- package_versions: 185,617 rows
- packages: 23,768 rows
- packages_enrichment: 23,782 rows
- packages_fts: 23,768 rows
- packages_fts_config: 1 rows
- packages_fts_data: 2,029 rows
- packages_fts_docsize: 23,768 rows
- packages_fts_idx: 1,751 rows
- queue_history_daily: 10,645 rows
- queue_snapshots: 223,148 rows
- queue_stats: 30 rows
- removal_reasons: 0 rows
- reverse_dependencies: 224,725 rows
Total DB size: 225,320,960 bytes