305 lines
9.3 KiB
Plaintext
305 lines
9.3 KiB
Plaintext
2026-05-15 11:29:33.736382: [INFO] Loaded 234 seeds.
|
|
2026-05-15 11:29:33.736404: [INFO] Running 10000 iterations with 16 workers...
|
|
2026-05-15 11:29:33.736555: [INFO] All existing .gcda files have been deleted.
|
|
2026-05-15 11:29:33.996088: [INFO] Executed 100 queries...
|
|
2026-05-15 11:29:34.288721: [INFO] Executed 200 queries...
|
|
2026-05-15 11:29:34.592463: [INFO] Executed 300 queries...
|
|
2026-05-15 11:29:34.905135: [INFO] Executed 400 queries...
|
|
2026-05-15 11:29:35.352104: [INFO] Executed 500 queries...
|
|
2026-05-15 11:29:35.949717: [INFO] Executed 600 queries...
|
|
2026-05-15 11:29:36.982752: [INFO] Executed 700 queries...
|
|
2026-05-15 11:29:37.957434: [INFO] Executed 800 queries...
|
|
2026-05-15 11:29:38.401073: [INFO] Executed 900 queries...
|
|
2026-05-15 11:29:39.042203: [INFO] Executed 1000 queries...
|
|
2026-05-15 11:29:39.593847: [INFO] Executed 1100 queries...
|
|
2026-05-15 11:29:40.247091: [INFO] Executed 1200 queries...
|
|
2026-05-15 11:29:40.668143: [INFO] Executed 1300 queries...
|
|
2026-05-15 11:29:41.282037: [INFO] Executed 1400 queries...
|
|
2026-05-15 11:29:41.701819: [INFO] Executed 1500 queries...
|
|
2026-05-15 11:29:42.289979: [INFO] Executed 1600 queries...
|
|
2026-05-15 11:29:42.982584: [INFO] Executed 1700 queries...
|
|
2026-05-15 11:29:43.604696: [INFO] Executed 1800 queries...
|
|
2026-05-15 11:29:44.297779: [INFO] Executed 1900 queries...
|
|
2026-05-15 11:29:45.248798: [INFO] Executed 2000 queries...
|
|
2026-05-15 11:29:46.138606: [INFO] Executed 2100 queries...
|
|
2026-05-15 11:29:46.982783: [INFO] Executed 2200 queries...
|
|
2026-05-15 11:29:47.828734: [INFO] Executed 2300 queries...
|
|
2026-05-15 11:29:49.175811: [INFO] Executed 2400 queries...
|
|
2026-05-15 11:29:50.009554: [INFO] Executed 2500 queries...
|
|
2026-05-15 11:29:50.875742: [INFO] Executed 2600 queries...
|
|
2026-05-15 11:29:51.512635: [INFO] Executed 2700 queries...
|
|
2026-05-15 11:29:52.598573: [INFO] Executed 2800 queries...
|
|
2026-05-15 11:29:53.303669: [INFO] Executed 2900 queries...
|
|
2026-05-15 11:29:54.299288: [INFO] Executed 3000 queries...
|
|
2026-05-15 11:29:55.944630: [INFO] Executed 3100 queries...
|
|
2026-05-15 11:29:57.194819: [INFO] Executed 3200 queries...
|
|
2026-05-15 11:29:58.778511: [INFO] Executed 3300 queries...
|
|
2026-05-15 11:30:01.012668: [INFO] Executed 3400 queries...
|
|
2026-05-15 11:30:02.551027: [INFO] Executed 3500 queries...
|
|
2026-05-15 11:30:03.951713: [INFO] Executed 3600 queries...
|
|
2026-05-15 11:30:05.830193: [INFO] Executed 3700 queries...
|
|
2026-05-15 11:30:06.915699: [INFO] Executed 3800 queries...
|
|
2026-05-15 11:30:07.860006: [INFO] Executed 3900 queries...
|
|
2026-05-15 11:30:08.877397: [INFO] Executed 4000 queries...
|
|
2026-05-15 11:30:10.303458: [INFO] Executed 4100 queries...
|
|
2026-05-15 11:30:12.274931: [INFO] Executed 4200 queries...
|
|
2026-05-15 11:30:14.238056: [INFO] Executed 4300 queries...
|
|
2026-05-15 11:30:15.227452: [INFO] Executed 4400 queries...
|
|
2026-05-15 11:30:16.494423: [INFO] Executed 4500 queries...
|
|
2026-05-15 11:30:17.549564: [INFO] Executed 4600 queries...
|
|
2026-05-15 11:30:18.976558: [INFO] Executed 4700 queries...
|
|
2026-05-15 11:30:21.044151: [INFO] Executed 4800 queries...
|
|
2026-05-15 11:30:22.775942: [INFO] Executed 4900 queries...
|
|
2026-05-15 11:30:25.102348: [INFO] Executed 5000 queries...
|
|
2026-05-15 11:30:26.776606: [INFO] Executed 5100 queries...
|
|
2026-05-15 11:30:28.008958: [INFO] Executed 5200 queries...
|
|
2026-05-15 11:30:30.059554: [INFO] Executed 5300 queries...
|
|
2026-05-15 11:30:31.348274: [INFO] Executed 5400 queries...
|
|
2026-05-15 11:30:32.812147: [INFO] Executed 5500 queries...
|
|
2026-05-15 11:30:34.208868: [INFO] Executed 5600 queries...
|
|
2026-05-15 11:30:36.904890: [INFO] Executed 5700 queries...
|
|
2026-05-15 11:30:39.080444: [INFO] Executed 5800 queries...
|
|
2026-05-15 11:30:40.396074: [INFO] Executed 5900 queries...
|
|
2026-05-15 11:30:42.160196: [INFO] Executed 6000 queries...
|
|
2026-05-15 11:30:45.506314: [INFO] Executed 6100 queries...
|
|
2026-05-15 11:30:47.930810: [INFO] Executed 6200 queries...
|
|
2026-05-15 11:30:50.349791: [INFO] Executed 6300 queries...
|
|
2026-05-15 11:30:52.299351: [INFO] Executed 6400 queries...
|
|
2026-05-15 11:30:54.861558: [INFO] Executed 6500 queries...
|
|
2026-05-15 11:30:57.039835: [INFO] Executed 6600 queries...
|
|
2026-05-15 11:30:58.954753: [INFO] Executed 6700 queries...
|
|
2026-05-15 11:31:00.738224: [INFO] Executed 6800 queries...
|
|
2026-05-15 11:31:01.828856: [INFO] Executed 6900 queries...
|
|
2026-05-15 11:31:04.157260: [INFO] Executed 7000 queries...
|
|
2026-05-15 11:31:06.055576: [INFO] Executed 7100 queries...
|
|
2026-05-15 11:31:08.089250: [INFO] Executed 7200 queries...
|
|
2026-05-15 11:31:10.310668: [INFO] Executed 7300 queries...
|
|
2026-05-15 11:31:11.886164: [INFO] Executed 7400 queries...
|
|
2026-05-15 11:31:13.648781: [INFO] Executed 7500 queries...
|
|
2026-05-15 11:31:15.968244: [INFO] Executed 7600 queries...
|
|
2026-05-15 11:31:18.023892: [INFO] Executed 7700 queries...
|
|
2026-05-15 11:31:19.720483: [INFO] Executed 7800 queries...
|
|
2026-05-15 11:31:22.774085: [INFO] Executed 7900 queries...
|
|
2026-05-15 11:31:24.721470: [INFO] Executed 8000 queries...
|
|
2026-05-15 11:31:26.341943: [INFO] Executed 8100 queries...
|
|
2026-05-15 11:31:28.895970: [INFO] Executed 8200 queries...
|
|
2026-05-15 11:31:30.842164: [INFO] Executed 8300 queries...
|
|
2026-05-15 11:31:32.977663: [INFO] Executed 8400 queries...
|
|
2026-05-15 11:31:34.238630: [INFO] Executed 8500 queries...
|
|
2026-05-15 11:31:35.755819: [INFO] Executed 8600 queries...
|
|
2026-05-15 11:31:39.284937: [INFO] Executed 8700 queries...
|
|
2026-05-15 11:31:43.987358: [INFO] Executed 8800 queries...
|
|
2026-05-15 11:31:46.539065: [INFO] Executed 8900 queries...
|
|
2026-05-15 11:31:49.631214: [INFO] Executed 9000 queries...
|
|
2026-05-15 11:31:51.220585: [INFO] Executed 9100 queries...
|
|
2026-05-15 11:31:53.364446: [INFO] Executed 9200 queries...
|
|
2026-05-15 11:31:55.995777: [INFO] Executed 9300 queries...
|
|
2026-05-15 11:31:59.056582: [INFO] Executed 9400 queries...
|
|
2026-05-15 11:32:01.633273: [INFO] Executed 9500 queries...
|
|
2026-05-15 11:32:04.249211: [INFO] Executed 9600 queries...
|
|
2026-05-15 11:32:05.708715: [INFO] Executed 9700 queries...
|
|
2026-05-15 11:32:10.530183: [INFO] Executed 9800 queries...
|
|
2026-05-15 11:32:12.834913: [INFO] Executed 9900 queries...
|
|
2026-05-15 11:32:20.496263: [INFO] Executed 10000 queries...
|
|
|
|
Wall clock: 166.79s for 10000 iterations
|
|
Generation-only time: 117.12s (≈ 11.71 ms/query)
|
|
Throughput (generated): 5123.1 queries/min
|
|
Throughput (generated + executed): 3597.3 queries/min
|
|
|
|
----------------------------------------------------------------------------------------
|
|
|
|
- Valid queries: 2351
|
|
- Invalid queries: 7649
|
|
- Line coverage: 66.58%
|
|
- Branch coverage: 51.57%
|
|
- Function coverage: 73.94%
|
|
|
|
----------------------------------------------------------------------------------------
|
|
|
|
Part 1a. Number of unique queries that each keyword appears in:
|
|
|
|
IN: 9949
|
|
TABLE: 9932
|
|
SELECT: 9819
|
|
CREATE: 9817
|
|
TO: 9771
|
|
FROM: 9744
|
|
INSERT: 9658
|
|
INTO: 9657
|
|
VALUES: 9644
|
|
AS: 9261
|
|
ON: 9043
|
|
WHERE: 8956
|
|
OR: 8561
|
|
NO: 8560
|
|
NULL: 8444
|
|
IS: 8284
|
|
PRAGMA: 8188
|
|
NOT: 8162
|
|
BY: 7965
|
|
EXISTS: 7263
|
|
IF: 7171
|
|
ALTER: 7099
|
|
ORDER: 7018
|
|
COLUMN: 6341
|
|
AND: 6221
|
|
INDEX: 6212
|
|
UPDATE: 5927
|
|
KEY: 5782
|
|
DROP: 5731
|
|
PRIMARY: 5711
|
|
|
|
----------------------------------------------------------------------------------------
|
|
|
|
Part 1b. Mean number of occurrences of each keyword per query:
|
|
|
|
IN: 59.482
|
|
SELECT: 57.694
|
|
FROM: 57.327
|
|
AS: 41.912
|
|
TO: 38.959
|
|
INTO: 37.545
|
|
VALUES: 34.78
|
|
WHERE: 32.341
|
|
TABLE: 29.628
|
|
ON: 24.9
|
|
NULL: 23.225
|
|
INSERT: 22.539
|
|
IS: 17.915
|
|
NOT: 17.315
|
|
BY: 14.315
|
|
FILTER: 14.093
|
|
OR: 12.235
|
|
EXISTS: 9.902
|
|
IF: 9.161
|
|
ORDER: 8.305
|
|
CREATE: 8.0
|
|
DATABASE: 7.518
|
|
PRAGMA: 7.464
|
|
AND: 7.369
|
|
KEY: 6.684
|
|
INDEX: 6.674
|
|
COLUMN: 6.673
|
|
NO: 6.35
|
|
PRIMARY: 6.151
|
|
ROW: 5.651
|
|
DEFAULT: 5.57
|
|
UPDATE: 5.541
|
|
JOIN: 5.5
|
|
SET: 5.022
|
|
OVER: 4.823
|
|
UNIQUE: 4.574
|
|
GROUP: 4.325
|
|
RENAME: 4.077
|
|
BEGIN: 4.07
|
|
BETWEEN: 3.805
|
|
DROP: 3.672
|
|
ADD: 3.476
|
|
VIEW: 3.254
|
|
TRIGGER: 3.165
|
|
VIRTUAL: 3.062
|
|
USING: 3.006
|
|
CURRENT: 2.834
|
|
SAVEPOINT: 2.775
|
|
DO: 2.606
|
|
UNBOUNDED: 2.598
|
|
PARTITION: 2.574
|
|
PRECEDING: 2.412
|
|
FOLLOWING: 2.385
|
|
ALTER: 2.32
|
|
WITH: 2.119
|
|
FOR: 2.005
|
|
RETURNING: 1.972
|
|
ROWS: 1.947
|
|
ALL: 1.946
|
|
UNION: 1.926
|
|
EXCLUDE: 1.82
|
|
COLLATE: 1.733
|
|
DELETE: 1.722
|
|
TEMP: 1.545
|
|
AFTER: 1.494
|
|
ROLLBACK: 1.402
|
|
LEFT: 1.383
|
|
TRANSACTION: 1.363
|
|
RECURSIVE: 1.306
|
|
DESC: 1.188
|
|
OF: 1.013
|
|
DISTINCT: 0.973
|
|
EACH: 0.934
|
|
LIMIT: 0.923
|
|
RANGE: 0.89
|
|
TEMPORARY: 0.879
|
|
BEFORE: 0.875
|
|
ATTACH: 0.86
|
|
INNER: 0.847
|
|
END: 0.843
|
|
HAVING: 0.835
|
|
MATERIALIZED: 0.834
|
|
OUTER: 0.771
|
|
REFERENCES: 0.738
|
|
FULL: 0.702
|
|
RIGHT: 0.646
|
|
INTERSECT: 0.642
|
|
FOREIGN: 0.615
|
|
FAIL: 0.605
|
|
ABORT: 0.54
|
|
REPLACE: 0.502
|
|
OTHERS: 0.47
|
|
THEN: 0.444
|
|
WHEN: 0.444
|
|
CURRENT_TIMESTAMP: 0.443
|
|
CASE: 0.435
|
|
GROUPS: 0.43
|
|
ELSE: 0.416
|
|
EXCLUSIVE: 0.412
|
|
EXCEPT: 0.411
|
|
IMMEDIATE: 0.41
|
|
CROSS: 0.395
|
|
IGNORE: 0.364
|
|
NATURAL: 0.341
|
|
TIES: 0.285
|
|
WITHOUT: 0.222
|
|
DEFERRED: 0.202
|
|
GLOB: 0.187
|
|
LIKE: 0.174
|
|
CHECK: 0.076
|
|
MATCH: 0.075
|
|
CAST: 0.073
|
|
DETACH: 0.062
|
|
ALWAYS: 0.061
|
|
ANALYZE: 0.061
|
|
GENERATED: 0.061
|
|
REINDEX: 0.054
|
|
OFFSET: 0.042
|
|
AUTOINCREMENT: 0.04
|
|
CONSTRAINT: 0.039
|
|
WINDOW: 0.038
|
|
VACUUM: 0.037
|
|
COMMIT: 0.032
|
|
RELEASE: 0.026
|
|
ASC: 0.002
|
|
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
|
|
|