Observatory DB — 2026-06-22

Observatory DB Merge Report

Date: 2026-06-22 13:41:17.864289

Output: observatory.db (245,198,848)

Sources

Source	Status	Size	Tables	Total Rows
feed.db	merged	86,220,800	packages, package_versions, reverse_dependencies, package_version_history (4)	601,092
metadata.db	merged	117,882,880	check_status_history, cran_check_results, cran_check_details, cran_check_issues, authors, packages_enrichment, removal_reasons, package_news (8)	485,166
downloads-summary.db	merged	1,671,168	downloads_summary (1)	24,741
queue.db	merged	36,921,344	queue_snapshots, queue_history_daily, queue_stats (3)	275,619

Combined Tables

• authors: 61,440 rows
• check_status_history: 59,500 rows
• cran_check_details: 28,085 rows
• cran_check_issues: 428 rows
• cran_check_results: 311,611 rows
• downloads_summary: 24,741 rows
• package_news: 95 rows
• package_version_history: 162,338 rows
• package_versions: 187,027 rows
• packages: 23,993 rows
• packages_enrichment: 24,006 rows
• packages_fts: 23,993 rows
• packages_fts_config: 1 rows
• packages_fts_data: 2,055 rows
• packages_fts_docsize: 23,993 rows
• packages_fts_idx: 1,871 rows
• queue_history_daily: 10,645 rows
• queue_snapshots: 264,934 rows
• queue_stats: 40 rows
• removal_reasons: 1 rows
• reverse_dependencies: 227,734 rows

Total DB size: 245,198,848 bytes