305 lines
9.3 KiB
Plaintext
305 lines
9.3 KiB
Plaintext
2026-05-15 11:38:13.174193: [INFO] Loaded 234 seeds.
|
|
2026-05-15 11:38:13.174216: [INFO] Running 10000 iterations with 16 workers...
|
|
2026-05-15 11:38:13.174390: [INFO] All existing .gcda files have been deleted.
|
|
2026-05-15 11:38:13.460086: [INFO] Executed 100 queries...
|
|
2026-05-15 11:38:13.808368: [INFO] Executed 200 queries...
|
|
2026-05-15 11:38:14.163345: [INFO] Executed 300 queries...
|
|
2026-05-15 11:38:14.502856: [INFO] Executed 400 queries...
|
|
2026-05-15 11:38:14.757061: [INFO] Executed 500 queries...
|
|
2026-05-15 11:38:15.053901: [INFO] Executed 600 queries...
|
|
2026-05-15 11:38:15.317319: [INFO] Executed 700 queries...
|
|
2026-05-15 11:38:15.662947: [INFO] Executed 800 queries...
|
|
2026-05-15 11:38:16.094506: [INFO] Executed 900 queries...
|
|
2026-05-15 11:38:16.559696: [INFO] Executed 1000 queries...
|
|
2026-05-15 11:38:17.048435: [INFO] Executed 1100 queries...
|
|
2026-05-15 11:38:17.454410: [INFO] Executed 1200 queries...
|
|
2026-05-15 11:38:17.901636: [INFO] Executed 1300 queries...
|
|
2026-05-15 11:38:18.449883: [INFO] Executed 1400 queries...
|
|
2026-05-15 11:38:19.482493: [INFO] Executed 1500 queries...
|
|
2026-05-15 11:38:20.090383: [INFO] Executed 1600 queries...
|
|
2026-05-15 11:38:20.659234: [INFO] Executed 1700 queries...
|
|
2026-05-15 11:38:21.250497: [INFO] Executed 1800 queries...
|
|
2026-05-15 11:38:21.666267: [INFO] Executed 1900 queries...
|
|
2026-05-15 11:38:22.271932: [INFO] Executed 2000 queries...
|
|
2026-05-15 11:38:22.892772: [INFO] Executed 2100 queries...
|
|
2026-05-15 11:38:23.547211: [INFO] Executed 2200 queries...
|
|
2026-05-15 11:38:24.496295: [INFO] Executed 2300 queries...
|
|
2026-05-15 11:38:25.323501: [INFO] Executed 2400 queries...
|
|
2026-05-15 11:38:26.725144: [INFO] Executed 2500 queries...
|
|
2026-05-15 11:38:27.638036: [INFO] Executed 2600 queries...
|
|
2026-05-15 11:38:28.111866: [INFO] Executed 2700 queries...
|
|
2026-05-15 11:38:28.625315: [INFO] Executed 2800 queries...
|
|
2026-05-15 11:38:29.513280: [INFO] Executed 2900 queries...
|
|
2026-05-15 11:38:32.737259: [INFO] Executed 3000 queries...
|
|
2026-05-15 11:38:33.690376: [INFO] Executed 3100 queries...
|
|
2026-05-15 11:38:34.801831: [INFO] Executed 3200 queries...
|
|
2026-05-15 11:38:35.846142: [INFO] Executed 3300 queries...
|
|
2026-05-15 11:38:36.504262: [INFO] Executed 3400 queries...
|
|
2026-05-15 11:38:37.137460: [INFO] Executed 3500 queries...
|
|
2026-05-15 11:38:37.801244: [INFO] Executed 3600 queries...
|
|
2026-05-15 11:38:38.548752: [INFO] Executed 3700 queries...
|
|
2026-05-15 11:38:39.486025: [INFO] Executed 3800 queries...
|
|
2026-05-15 11:38:40.734225: [INFO] Executed 3900 queries...
|
|
2026-05-15 11:38:41.907248: [INFO] Executed 4000 queries...
|
|
2026-05-15 11:38:43.755949: [INFO] Executed 4100 queries...
|
|
2026-05-15 11:38:44.878211: [INFO] Executed 4200 queries...
|
|
2026-05-15 11:38:46.851789: [INFO] Executed 4300 queries...
|
|
2026-05-15 11:38:47.894671: [INFO] Executed 4400 queries...
|
|
2026-05-15 11:38:49.110791: [INFO] Executed 4500 queries...
|
|
2026-05-15 11:38:50.161142: [INFO] Executed 4600 queries...
|
|
2026-05-15 11:38:53.653243: [INFO] Executed 4700 queries...
|
|
2026-05-15 11:38:55.123991: [INFO] Executed 4800 queries...
|
|
2026-05-15 11:38:56.743559: [INFO] Executed 4900 queries...
|
|
2026-05-15 11:38:58.294430: [INFO] Executed 5000 queries...
|
|
2026-05-15 11:38:59.386357: [INFO] Executed 5100 queries...
|
|
2026-05-15 11:39:00.923512: [INFO] Executed 5200 queries...
|
|
2026-05-15 11:39:02.074209: [INFO] Executed 5300 queries...
|
|
2026-05-15 11:39:03.121231: [INFO] Executed 5400 queries...
|
|
2026-05-15 11:39:04.611905: [INFO] Executed 5500 queries...
|
|
2026-05-15 11:39:06.342604: [INFO] Executed 5600 queries...
|
|
2026-05-15 11:39:08.379923: [INFO] Executed 5700 queries...
|
|
2026-05-15 11:39:11.463772: [INFO] Executed 5800 queries...
|
|
2026-05-15 11:39:13.847211: [INFO] Executed 5900 queries...
|
|
2026-05-15 11:39:15.826240: [INFO] Executed 6000 queries...
|
|
2026-05-15 11:39:17.626759: [INFO] Executed 6100 queries...
|
|
2026-05-15 11:39:21.576607: [INFO] Executed 6200 queries...
|
|
2026-05-15 11:39:23.529212: [INFO] Executed 6300 queries...
|
|
2026-05-15 11:39:27.493969: [INFO] Executed 6400 queries...
|
|
2026-05-15 11:39:29.572597: [INFO] Executed 6500 queries...
|
|
2026-05-15 11:39:33.332596: [INFO] Executed 6600 queries...
|
|
2026-05-15 11:39:35.261579: [INFO] Executed 6700 queries...
|
|
2026-05-15 11:39:37.360007: [INFO] Executed 6800 queries...
|
|
2026-05-15 11:39:40.344645: [INFO] Executed 6900 queries...
|
|
2026-05-15 11:39:42.839439: [INFO] Executed 7000 queries...
|
|
2026-05-15 11:39:48.298975: [INFO] Executed 7100 queries...
|
|
2026-05-15 11:39:53.107088: [INFO] Executed 7200 queries...
|
|
2026-05-15 11:39:54.680113: [INFO] Executed 7300 queries...
|
|
2026-05-15 11:39:56.084816: [INFO] Executed 7400 queries...
|
|
2026-05-15 11:40:00.034377: [INFO] Executed 7500 queries...
|
|
2026-05-15 11:40:03.940163: [INFO] Executed 7600 queries...
|
|
2026-05-15 11:40:07.044752: [INFO] Executed 7700 queries...
|
|
2026-05-15 11:40:11.904632: [INFO] Executed 7800 queries...
|
|
2026-05-15 11:40:13.514119: [INFO] Executed 7900 queries...
|
|
2026-05-15 11:40:18.984175: [INFO] Executed 8000 queries...
|
|
2026-05-15 11:40:22.707829: [INFO] Executed 8100 queries...
|
|
2026-05-15 11:40:25.006341: [INFO] Executed 8200 queries...
|
|
2026-05-15 11:40:27.211763: [INFO] Executed 8300 queries...
|
|
2026-05-15 11:40:32.221623: [INFO] Executed 8400 queries...
|
|
2026-05-15 11:40:37.534388: [INFO] Executed 8500 queries...
|
|
2026-05-15 11:40:42.432448: [INFO] Executed 8600 queries...
|
|
2026-05-15 11:40:46.804130: [INFO] Executed 8700 queries...
|
|
2026-05-15 11:40:50.582365: [INFO] Executed 8800 queries...
|
|
2026-05-15 11:40:53.550471: [INFO] Executed 8900 queries...
|
|
2026-05-15 11:40:56.796130: [INFO] Executed 9000 queries...
|
|
2026-05-15 11:41:01.291508: [INFO] Executed 9100 queries...
|
|
2026-05-15 11:41:04.455380: [INFO] Executed 9200 queries...
|
|
2026-05-15 11:41:10.216792: [INFO] Executed 9300 queries...
|
|
2026-05-15 11:41:15.594857: [INFO] Executed 9400 queries...
|
|
2026-05-15 11:41:21.106006: [INFO] Executed 9500 queries...
|
|
2026-05-15 11:41:24.984477: [INFO] Executed 9600 queries...
|
|
2026-05-15 11:41:26.835251: [INFO] Executed 9700 queries...
|
|
2026-05-15 11:41:30.973286: [INFO] Executed 9800 queries...
|
|
2026-05-15 11:41:36.450017: [INFO] Executed 9900 queries...
|
|
2026-05-15 11:41:43.741186: [INFO] Executed 10000 queries...
|
|
|
|
Wall clock: 210.63s for 10000 iterations
|
|
Generation-only time: 117.20s (≈ 11.72 ms/query)
|
|
Throughput (generated): 5119.6 queries/min
|
|
Throughput (generated + executed): 2848.6 queries/min
|
|
|
|
----------------------------------------------------------------------------------------
|
|
|
|
- Valid queries: 2481
|
|
- Invalid queries: 7519
|
|
- Line coverage: 65.26%
|
|
- Branch coverage: 50.59%
|
|
- Function coverage: 71.95%
|
|
|
|
----------------------------------------------------------------------------------------
|
|
|
|
Part 1a. Number of unique queries that each keyword appears in:
|
|
|
|
IN: 9978
|
|
TABLE: 9954
|
|
CREATE: 9866
|
|
SELECT: 9782
|
|
TO: 9774
|
|
FROM: 9737
|
|
INSERT: 9690
|
|
VALUES: 9676
|
|
INTO: 9669
|
|
AS: 9297
|
|
ON: 9206
|
|
WHERE: 8995
|
|
NO: 8617
|
|
OR: 8537
|
|
IS: 8456
|
|
NULL: 8323
|
|
PRAGMA: 8261
|
|
NOT: 8258
|
|
BY: 7972
|
|
EXISTS: 7559
|
|
IF: 7375
|
|
ALTER: 7005
|
|
ORDER: 6849
|
|
INDEX: 6546
|
|
COLUMN: 6387
|
|
AND: 6319
|
|
UPDATE: 6213
|
|
BEGIN: 6068
|
|
WITH: 6029
|
|
DROP: 5982
|
|
|
|
----------------------------------------------------------------------------------------
|
|
|
|
Part 1b. Mean number of occurrences of each keyword per query:
|
|
|
|
SELECT: 55.958
|
|
FROM: 55.319
|
|
IN: 48.156
|
|
AS: 36.046
|
|
WHERE: 33.661
|
|
INTO: 32.128
|
|
TO: 31.935
|
|
VALUES: 29.903
|
|
TABLE: 23.427
|
|
INSERT: 22.209
|
|
NULL: 20.864
|
|
ON: 20.721
|
|
FILTER: 16.605
|
|
NOT: 16.137
|
|
IS: 15.968
|
|
BY: 11.981
|
|
OR: 11.79
|
|
EXISTS: 9.296
|
|
CREATE: 9.153
|
|
IF: 8.659
|
|
PRAGMA: 8.529
|
|
ORDER: 7.566
|
|
AND: 6.645
|
|
COLUMN: 6.422
|
|
INDEX: 5.946
|
|
DATABASE: 5.341
|
|
JOIN: 4.8
|
|
UPDATE: 4.585
|
|
DROP: 4.466
|
|
DEFAULT: 4.35
|
|
ROW: 4.252
|
|
KEY: 4.151
|
|
BEGIN: 3.998
|
|
PRIMARY: 3.978
|
|
SET: 3.853
|
|
GROUP: 3.747
|
|
RENAME: 3.512
|
|
TRIGGER: 3.126
|
|
VIEW: 3.094
|
|
NO: 3.031
|
|
OVER: 2.875
|
|
UNION: 2.632
|
|
UNIQUE: 2.602
|
|
ALL: 2.494
|
|
BETWEEN: 2.313
|
|
ADD: 2.291
|
|
SAVEPOINT: 2.171
|
|
DELETE: 1.903
|
|
FOR: 1.903
|
|
RETURNING: 1.867
|
|
RECURSIVE: 1.817
|
|
ALTER: 1.777
|
|
CURRENT: 1.707
|
|
UNBOUNDED: 1.562
|
|
DO: 1.556
|
|
COLLATE: 1.536
|
|
PRECEDING: 1.373
|
|
AFTER: 1.349
|
|
PARTITION: 1.337
|
|
END: 1.226
|
|
ROWS: 1.223
|
|
FOLLOWING: 1.205
|
|
TRANSACTION: 1.165
|
|
WITH: 1.117
|
|
OF: 1.108
|
|
BEFORE: 1.103
|
|
VIRTUAL: 1.046
|
|
EXCLUDE: 1.001
|
|
ROLLBACK: 0.978
|
|
EACH: 0.969
|
|
TEMPORARY: 0.945
|
|
USING: 0.939
|
|
ATTACH: 0.936
|
|
MATERIALIZED: 0.923
|
|
OUTER: 0.913
|
|
RIGHT: 0.91
|
|
TEMP: 0.902
|
|
LIMIT: 0.84
|
|
FAIL: 0.79
|
|
HAVING: 0.776
|
|
EXCEPT: 0.773
|
|
LEFT: 0.73
|
|
REPLACE: 0.73
|
|
DESC: 0.655
|
|
FULL: 0.652
|
|
INNER: 0.62
|
|
WHEN: 0.595
|
|
THEN: 0.594
|
|
REFERENCES: 0.565
|
|
ELSE: 0.551
|
|
ABORT: 0.541
|
|
CROSS: 0.535
|
|
FOREIGN: 0.44
|
|
WITHOUT: 0.436
|
|
DISTINCT: 0.412
|
|
INTERSECT: 0.4
|
|
RANGE: 0.383
|
|
NATURAL: 0.326
|
|
DEFERRED: 0.298
|
|
IGNORE: 0.288
|
|
GLOB: 0.281
|
|
IMMEDIATE: 0.274
|
|
CASE: 0.246
|
|
CURRENT_TIMESTAMP: 0.242
|
|
GROUPS: 0.232
|
|
OTHERS: 0.212
|
|
TIES: 0.199
|
|
EXCLUSIVE: 0.195
|
|
MATCH: 0.148
|
|
LIKE: 0.118
|
|
VACUUM: 0.096
|
|
ANALYZE: 0.086
|
|
OFFSET: 0.073
|
|
DETACH: 0.06
|
|
COMMIT: 0.056
|
|
REINDEX: 0.041
|
|
RELEASE: 0.039
|
|
ALWAYS: 0.037
|
|
GENERATED: 0.037
|
|
CHECK: 0.032
|
|
CONSTRAINT: 0.031
|
|
AUTOINCREMENT: 0.013
|
|
CAST: 0.006
|
|
WINDOW: 0.006
|
|
ASC: 0.004
|
|
ACTION: 0.0
|
|
CASCADE: 0.0
|
|
CONFLICT: 0.0
|
|
CURRENT_DATE: 0.0
|
|
CURRENT_TIME: 0.0
|
|
DEFERRABLE: 0.0
|
|
ESCAPE: 0.0
|
|
EXPLAIN: 0.0
|
|
FIRST: 0.0
|
|
INDEXED: 0.0
|
|
INITIALLY: 0.0
|
|
INSTEAD: 0.0
|
|
ISNULL: 0.0
|
|
LAST: 0.0
|
|
NOTHING: 0.0
|
|
NOTNULL: 0.0
|
|
NULLS: 0.0
|
|
PLAN: 0.0
|
|
QUERY: 0.0
|
|
RAISE: 0.0
|
|
REGEXP: 0.0
|
|
RESTRICT: 0.0
|
|
|