CodeQL Demo Database (Firefox)

1. Overview

This page hosts a large-scale CodeQL demo database (Firefox). Purpose: to demonstrate the real performance and scale of CodeQL. Smaller repos are misleading; this one is a hammer.

2. Download

  • Download Firefox CodeQL DB (≈780 MB) ./firefox-db.tar.zst
  • Supports resumable downloads:

    curl -O -C - https://hohnlab.org/codeql/firefox-db.tar.zst
    

3. Database Facts

  • Repository: Firefox (x86_64)
  • Interim DB size: ~27 GB
  • Final DB size: ~5.5 GB
  • Build time (no CodeQL): ~10 minutes
  • Build time (with CodeQL trace): ~57 minutes
  • Database finalize: ~50 minutes
  • Directory breakdown:
    • contents during finalization
      • ~61% TRAP (16.5 GB)
      • ~26% db-cpp (7 GB, relational store + indexes)
      • ~10% logs (2.8 GB)
      • ~2% src snapshot (561 MB)
    • contents after finalization
      • ~53% logs (2.9 GB)
        • extractor logs: 940 MB
      • ~46% db-cpp (2.5 GB, relational store + indexes)
        • main store: db-cpp/default
      • ~<1% diagnostic (32 KB)
      • Final size: 5.5 GB

disk-sizes-during-finalize.png

Figure 1: Treemap of database contents during finalization; green = TRAP facts, gray = relational store.

disk-sizes-after-finalize.png

Figure 2: Treemap of database contents after finalization

4. Relevance

Large-scale CodeQL is drastically different from small scale.

Phase Directory Size Notes
During finalize trap/ 16.5G TRAP facts
  db-cpp/ 7.0G Relational store
  log/ 2.8G Build + extractor logs
  src/ 561M Source snapshot
After finalize db-cpp/ 2.5G Relational store
  log/ 2.9G Logs
  diagnostic/ 32K Scratch
Final DB size firefox-db/ 5.5G  
Distribution file tar.zst 757M Compressed archive