GitHub Actions run
CPU Simulation
9 hours ago 1fd54a1 penberg:pragma-column-names pull_requestThis run is associated to a commit that was force-pushed
It will not be associated with its branch history. Be careful when comparing its performance to other runs.Compare
Base
Search a run
Head
Comparecore: Implement PRAGMA full_column_names and short_column_names
#6200
penberg:pragma-column-names
9 hours ago
CPU Simulation
416 total
limbo_execute_select_1
core/benches/benchmark.rs::benches::bench_execute_select_1::Execute `SELECT 1`11 µs
limbo_schema[]
core/benches/benchmark.rs::benches::bench_open::Open/Connect54.9 ms
sqlite_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes11.2 ms
limbo_parse_query[SELECT * FROM users LIMIT 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT * FROM users LIMIT 1`109.2 µs
limbo_parse_query[SELECT 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT 1`59.9 µs
sqlite_parse_query[SELECT * FROM users LIMIT 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT * FROM users LIMIT 1`53.5 µs
sqlite_schema[]
core/benches/benchmark.rs::benches::bench_open::Open/Connect52.1 ms
sqlite_parse_query[SELECT 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT 1`23.5 µs
limbo_mvcc_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes102.6 ms
limbo_wal_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes39.5 ms
sqlite[a_cooccurrence]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `a_cooccurrence`332.5 ms
sqlite_execute_select_1
core/benches/benchmark.rs::benches::bench_execute_select_1::Execute `SELECT 1`4.1 µs
limbo_execute_select_count
core/benches/benchmark.rs::benches::bench_execute_select_count::Execute `SELECT count() FROM users`131.3 µs
limbo_parse_query[SELECT first_name, count(1) FROM users GROUP BY fi]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT first_name, count(1) FROM users GROUP BY first_name HAVING count(1) > 1 ORDER BY count(1) LIMIT 1`169.7 µs
sqlite_execute_select_count
core/benches/benchmark.rs::benches::bench_execute_select_count::Execute `SELECT count() FROM users`19.8 µs
sqlite[b_or_join]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `b_or_join`1.1 ms
sqlite_analyzed[a_cooccurrence]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `a_cooccurrence`56.1 ms
limbo[b_or_join]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `b_or_join`4.3 ms
limbo_analyzed[3_aggregate_or_in]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `3_aggregate_or_in`8.4 ms
sqlite_parse_query[SELECT first_name, count(1) FROM users GROUP BY fi]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT first_name, count(1) FROM users GROUP BY first_name HAVING count(1) > 1 ORDER BY count(1) LIMIT 1`69 µs
sqlite_parse_query[SELECT first_name, last_name, state, city, age + 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT first_name, last_name, state, city, age + 10, LENGTH(email), UPPER(first_name), LOWER(last_name), SUBSTR(phone_number, 1, 3), zipcode || '-' || state, AVG(age) + 5, MAX(age) - MIN(age), ROUND(AVG(age), 1), SUM(age) / COUNT(*), COUNT(*), COUNT(email), SUM(age), AVG(age), MIN(age), MAX(age), SUM(CASE WHEN age >= 18 THEN 1 ELSE 0 END), SUM(CASE WHEN age < 18 THEN 1 ELSE 0 END), AVG(CASE WHEN age >= 18 THEN age ELSE NULL END), MAX(CASE WHEN age >= 18 THEN age ELSE NULL END) FROM users GROUP BY state, city`166.6 µs
limbo_execute_select_rows[100]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`234.5 µs
sqlite_execute_select_rows[100]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`90.6 µs
sqlite_analyzed[3_aggregate_or_in]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `3_aggregate_or_in`204.8 µs
limbo_analyzed[b_or_join]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `b_or_join`4.3 ms