Precomputing Live demo: SQL How to run it

Answers ready before you ask

Three hours of API traffic, precomputed inside SQLite in your browser

Loading SQLite

Loading SQLite and the compiled policy.

0
requests in
–
requests a second on this device
–
raw table, every request kept
–
precomputed file
–
smaller
0
unusual requests kept whole

Storage

The same requests kept two ways. The raw table grows with traffic; the precomputed file grows with time.

Raw tablePrecomputed file

Sizes are SQLite pages in use. Times are UTC. Hover or use the arrow keys for values.

p99 latency, minute by minute

Read from the 1-minute quantile sketches, one row per endpoint.

p99OutageUnusual request kept whole

Answers kept ready

Read from the precompute views as requests arrive.

EndpointRequestsAveragep99

What happened

Newest first.

    The policy

    A short policy says what to keep. The compiler turns it into the SQL this page runs.

    
        
      

    Ask the file

    The precomputed file is plain SQLite. Pick a question or write your own, then press Run (or Ctrl+Enter, ⌘+Enter on a Mac). It reads while the run is paused or finished.