Resolve "Backfill vulnearbility risk score table"
What does this MR do and why?
-
Backfills the
vulnerability_finding_risk_scorestable for allvulnerability_occurrencesby computing their risk score based on the logic fromee/lib/vulnerabilities/risk_score.rb. -
This backfill also includes a batching optimization for
cve_enrichmentassociated with a finding, to avoid N+1 lookups.
Database
Background Migration: BackfillVulnerabilityFindingRiskScores
Sampled 13 batches. Estimated Time to complete: 5 days, 21 hours, 10 minutes, and 58 seconds
- Interval: 120s
- Max batch size: 0
- Estimated seconds to complete: 508258s
- Average batch time: 141.38s
- Batch size: 50000
- N. of batches sampled: 13
- N. of failed batches: 0
Time estimation is conservative and based on sampling production data in a test environment. It represents the max time that migration could take. The actual time may differ from this estimation.
Consider changing max_batch_size and interval if this estimate is unacceptable.
| Calls | Total Time | Max Time | Mean Time | Rows | Collapsed | Query |
|---|---|---|---|---|---|---|
| 1201 | 212421.0 ms | 859.9 ms | 176.9 ms | 600001 | Yes | SELECT vulnerability_occurrences.* |
| 1201 | 53703.1 ms | 577.2 ms | 44.7 ms | 360277 | Yes | SELECT vulnerability_occurrence_identifiers.id AS t0_r0, vulnerability_occurrence_identifiers.created_at AS t0_r1, vulnerability_occurrence_identifiers.updated_at AS t0_r2, vulnerability_occurrence_identifiers.occurrence_id AS t0_r3, vulnerability_occurrence_identifiers.identifier_id AS t0_r4, vulnerability_occurrence_identifiers.project_id AS t0_r5, vulnerability_identifiers.id AS t1_r0, vulnerability_identifiers.created_at AS t1_r1, vulnerability_identifiers.updated_at AS t1_r2, vulnerability_identifiers.project_id AS t1_r3, vulnerability_identifiers.fingerprint AS t1_r4, vulnerability_identifiers.external_type AS t1_r5, vulnerability_identifiers.external_id AS t1_r6, vulnerability_identifiers.name AS t1_r7, vulnerability_identifiers.url AS t1_r8 |
| 1201 | 11745.7 ms | 23.3 ms | 9.8 ms | 600001 | No | INSERT INTO vulnerability_finding_risk_scores (finding_id, project_id, risk_score, updated_at, created_at) VALUES ($1, $2, $3, $4, current_timestamp), ($5, $6, $7, $8, current_timestamp), ($9, $10, $11, $12, current_timestamp), ($13, $14, $15, $16, current_timestamp), ($17, $18, $19, $20, current_timestamp), ($21, $22, $23, $24, current_timestamp), ($25, $26, $27, $28, current_timestamp), ($29, $30, $31, $32, current_timestamp), ($33, $34, $35, $36, current_timestamp), ($37, $38, $39, $40, current_timestamp), ($41, $42, $43, $44, current_timestamp), ($45, $46, $47, $48, current_timestamp), ($49, $50, $51, $52, current_timestamp), ($53, $54, $55, $56, current_timestamp), ($57, $58, $59, $60, current_timestamp), ($61, $62, $63, $64, current_timestamp), ($65, $66, $67, $68, current_timestamp), ($69, $70, $71, $72, current_timestamp), ($73, $74, $75, $76, current_timestamp), ($77, $78, $79, $80, current_timestamp), ($81, $82, $83, $84, current_timestamp), ($85, $86, $87, $88, current_timestamp), ($89, $90, $91, $92, current_timestamp), ($93, $94, $95, $96, current_timestamp), ($97, $98, $99, $100, current_timestamp), ($101, $102, $103, $104, current_timestamp), ($105, $106, $107, $108, current_timestamp), ($109, $110, $111, $112, current_timestamp), ($113, $114, $115, $116, current_timestamp), ($117, $118, $119, $120, current_timestamp), ($121, $122, $123, $124, current_timestamp), ($125, $126, $127, $128, current_timestamp), ($129, $130, $131, $132, current_timestamp), ($133, $134, $135, $136, current_timestamp), ($137, $138, $139, $140, current_timestamp), ($141, $142, $143, $144, current_timestamp), ($145, $146, $147, $148, current_timestamp), ($149, $150, $151, $152, current_timestamp), ($153, $154, $155, $156, current_timestamp), ($157, $158, $159, $160, current_timestamp), ($161, $162, $163, $164, current_timestamp), ($165, $166, $167, $168, current_timestamp), ($169, $170, $171, $172, current_timestamp), ($173, $174, $175, $176, current_timestamp), ($177, $178, $179, $180, current_timestamp), ($181, $182, $183, $184, current_timestamp), ($185, $186, $187, $188, current_timestamp), ($189, $190, $191, $192, current_timestamp), ($193, $194, $195, $196, current_timestamp), ($197, $198, $199, $200, current_timestamp), ($201, $202, $203, $204, current_timestamp), ($205, $206, $207, $208, current_timestamp), ($209, $210, $211, $212, current_timestamp), ($213, $214, $215, $216, current_timestamp), ($217, $218, $219, $220, current_timestamp), ($221, $222, $223, $224, current_timestamp), ($225, $226, $227, $228, current_timestamp), ($229, $230, $231, $232, current_timestamp), ($233, $234, $235, $236, current_timestamp), ($237, $238, $239, $240, current_timestamp), ($241, $242, $243, $244, current_timestamp), ($245, $246, $247, $248, current_timestamp), ($249, $250, $251, $252, current_timestamp), ($253, $254, $255, $256, current_timestamp), ($257, $258, $259, $260, current_timestamp), ($261, $262, $263, $264, current_timestamp), ($265, $266, $267, $268, current_timestamp), ($269, $270, $271, $272, current_timestamp), ($273, $274, $275, $276, current_timestamp), ($277, $278, $279, $280, current_timestamp), ($281, $282, $283, $284, current_timestamp), ($285, $286, $287, $288, current_timestamp), ($289, $290, $291, $292, current_timestamp), ($293, $294, $295, $296, current_timestamp), ($297, $298, $299, $300, current_timestamp), ($301, $302, $303, $304, current_timestamp), ($305, $306, $307, $308, current_timestamp), ($309, $310, $311, $312, current_timestamp), ($313, $314, $315, $316, current_timestamp), ($317, $318, $319, $320, current_timestamp), ($321, $322, $323, $324, current_timestamp), ($325, $326, $327, $328, current_timestamp), ($329, $330, $331, $332, current_timestamp), ($333, $334, $335, $336, current_timestamp), ($337, $338, $339, $340, current_timestamp), ($341, $342, $343, $344, current_timestamp), ($345, $346, $347, $348, current_timestamp), ($349, $350, $351, $352, current_timestamp), ($353, $354, $355, $356, current_timestamp), ($357, $358, $359, $360, current_timestamp), ($361, $362, $363, $364, current_timestamp), ($365, $366, $367, $368, current_timestamp), ($369, $370, $371, $372, current_timestamp), ($373, $374, $375, $376, current_timestamp), ($377, $378, $379, $380, current_timestamp), ($381, $382, $383, $384, current_timestamp), ($385, $386, $387, $388, current_timestamp), ($389, $390, $391, $392, current_timestamp), ($393, $394, $395, $396, current_timestamp), ($397, $398, $399, $400, current_timestamp), ($401, $402, $403, $404, current_timestamp), ($405, $406, $407, $408, current_timestamp), ($409, $410, $411, $412, current_timestamp), ($413, $414, $415, $416, current_timestamp), ($417, $418, $419, $420, current_timestamp), ($421, $422, $423, $424, current_timestamp), ($425, $426, $427, $428, current_timestamp), ($429, $430, $431, $432, current_timestamp), ($433, $434, $435, $436, current_timestamp), ($437, $438, $439, $440, current_timestamp), ($441, $442, $443, $444, current_timestamp), ($445, $446, $447, $448, current_timestamp), ($449, $450, $451, $452, current_timestamp), ($453, $454, $455, $456, current_timestamp), ($457, $458, $459, $460, current_timestamp), ($461, $462, $463, $464, current_timestamp), ($465, $466, $467, $468, current_timestamp), ($469, $470, $471, $472, current_timestamp), ($473, $474, $475, $476, current_timestamp), ($477, $478, $479, $480, current_timestamp), ($481, $482, $483, $484, current_timestamp), ($485, $486, $487, $488, current_timestamp), ($489, $490, $491, $492, current_timestamp), ($493, $494, $495, $496, current_timestamp), ($497, $498, $499, $500, current_timestamp), ($501, $502, $503, $504, current_timestamp), ($505, $506, $507, $508, current_timestamp), ($509, $510, $511, $512, current_timestamp), ($513, $514, $515, $516, current_timestamp), ($517, $518, $519, $520, current_timestamp), ($521, $522, $523, $524, current_timestamp), ($525, $526, $527, $528, current_timestamp), ($529, $530, $531, $532, current_timestamp), ($533, $534, $535, $536, current_timestamp), ($537, $538, $539, $540, current_timestamp), ($541, $542, $543, $544, current_timestamp), ($545, $546, $547, $548, current_timestamp), ($549, $550, $551, $552, current_timestamp), ($553, $554, $555, $556, current_timestamp), ($557, $558, $559, $560, current_timestamp), ($561, $562, $563, $564, current_timestamp), ($565, $566, $567, $568, current_timestamp), ($569, $570, $571, $572, current_timestamp), ($573, $574, $575, $576, current_timestamp), ($577, $578, $579, $580, current_timestamp), ($581, $582, $583, $584, current_timestamp), ($585, $586, $587, $588, current_timestamp), ($589, $590, $591, $592, current_timestamp), ($593, $594, $595, $596, current_timestamp), ($597, $598, $599, $600, current_timestamp), ($601, $602, $603, $604, current_timestamp), ($605, $606, $607, $608, current_timestamp), ($609, $610, $611, $612, current_timestamp), ($613, $614, $615, $616, current_timestamp), ($617, $618, $619, $620, current_timestamp), ($621, $622, $623, $624, current_timestamp), ($625, $626, $627, $628, current_timestamp), ($629, $630, $631, $632, current_timestamp), ($633, $634, $635, $636, current_timestamp), ($637, $638, $639, $640, current_timestamp), ($641, $642, $643, $644, current_timestamp), ($645, $646, $647, $648, current_timestamp), ($649, $650, $651, $652, current_timestamp), ($653, $654, $655, $656, current_timestamp), ($657, $658, $659, $660, current_timestamp), ($661, $662, $663, $664, current_timestamp), ($665, $666, $667, $668, current_timestamp), ($669, $670, $671, $672, current_timestamp), ($673, $674, $675, $676, current_timestamp), ($677, $678, $679, $680, current_timestamp), ($681, $682, $683, $684, current_timestamp), ($685, $686, $687, $688, current_timestamp), ($689, $690, $691, $692, current_timestamp), ($693, $694, $695, $696, current_timestamp), ($697, $698, $699, $700, current_timestamp), ($701, $702, $703, $704, current_timestamp), ($705, $706, $707, $708, current_timestamp), ($709, $710, $711, $712, current_timestamp), ($713, $714, $715, $716, current_timestamp), ($717, $718, $719, $720, current_timestamp), ($721, $722, $723, $724, current_timestamp), ($725, $726, $727, $728, current_timestamp), ($729, $730, $731, $732, current_timestamp), ($733, $734, $735, $736, current_timestamp), ($737, $738, $739, $740, current_timestamp), ($741, $742, $743, $744, current_timestamp), ($745, $746, $747, $748, current_timestamp), ($749, $750, $751, $752, current_timestamp), ($753, $754, $755, $756, current_timestamp), ($757, $758, $759, $760, current_timestamp), ($761, $762, $763, $764, current_timestamp), ($765, $766, $767, $768, current_timestamp), ($769, $770, $771, $772, current_timestamp), ($773, $774, $775, $776, current_timestamp), ($777, $778, $779, $780, current_timestamp), ($781, $782, $783, $784, current_timestamp), ($785, $786, $787, $788, current_timestamp), ($789, $790, $791, $792, current_timestamp), ($793, $794, $795, $796, current_timestamp), ($797, $798, $799, $800, current_timestamp), ($801, $802, $803, $804, current_timestamp), ($805, $806, $807, $808, current_timestamp), ($809, $810, $811, $812, current_timestamp), ($813, $814, $815, $816, current_timestamp), ($817, $818, $819, $820, current_timestamp), ($821, $822, $823, $824, current_timestamp), ($825, $826, $827, $828, current_timestamp), ($829, $830, $831, $832, current_timestamp), ($833, $834, $835, $836, current_timestamp), ($837, $838, $839, $840, current_timestamp), ($841, $842, $843, $844, current_timestamp), ($845, $846, $847, $848, current_timestamp), ($849, $850, $851, $852, current_timestamp), ($853, $854, $855, $856, current_timestamp), ($857, $858, $859, $860, current_timestamp), ($861, $862, $863, $864, current_timestamp), ($865, $866, $867, $868, current_timestamp), ($869, $870, $871, $872, current_timestamp), ($873, $874, $875, $876, current_timestamp), ($877, $878, $879, $880, current_timestamp), ($881, $882, $883, $884, current_timestamp), ($885, $886, $887, $888, current_timestamp), ($889, $890, $891, $892, current_timestamp), ($893, $894, $895, $896, current_timestamp), ($897, $898, $899, $900, current_timestamp), ($901, $902, $903, $904, current_timestamp), ($905, $906, $907, $908, current_timestamp), ($909, $910, $911, $912, current_timestamp), ($913, $914, $915, $916, current_timestamp), ($917, $918, $919, $920, current_timestamp), ($921, $922, $923, $924, current_timestamp), ($925, $926, $927, $928, current_timestamp), ($929, $930, $931, $932, current_timestamp), ($933, $934, $935, $936, current_timestamp), ($937, $938, $939, $940, current_timestamp), ($941, $942, $943, $944, current_timestamp), ($945, $946, $947, $948, current_timestamp), ($949, $950, $951, $952, current_timestamp), ($953, $954, $955, $956, current_timestamp), ($957, $958, $959, $960, current_timestamp), ($961, $962, $963, $964, current_timestamp), ($965, $966, $967, $968, current_timestamp), ($969, $970, $971, $972, current_timestamp), ($973, $974, $975, $976, current_timestamp), ($977, $978, $979, $980, current_timestamp), ($981, $982, $983, $984, current_timestamp), ($985, $986, $987, $988, current_timestamp), ($989, $990, $991, $992, current_timestamp), ($993, $994, $995, $996, current_timestamp), ($997, $998, $999, $1000, current_timestamp), ($1001, $1002, $1003, $1004, current_timestamp), ($1005, $1006, $1007, $1008, current_timestamp), ($1009, $1010, $1011, $1012, current_timestamp), ($1013, $1014, $1015, $1016, current_timestamp), ($1017, $1018, $1019, $1020, current_timestamp), ($1021, $1022, $1023, $1024, current_timestamp), ($1025, $1026, $1027, $1028, current_timestamp), ($1029, $1030, $1031, $1032, current_timestamp), ($1033, $1034, $1035, $1036, current_timestamp), ($1037, $1038, $1039, $1040, current_timestamp), ($1041, $1042, $1043, $1044, current_timestamp), ($1045, $1046, $1047, $1048, current_timestamp), ($1049, $1050, $1051, $1052, current_timestamp), ($1053, $1054, $1055, $1056, current_timestamp), ($1057, $1058, $1059, $1060, current_timestamp), ($1061, $1062, $1063, $1064, current_timestamp), ($1065, $1066, $1067, $1068, current_timestamp), ($1069, $1070, $1071, $1072, current_timestamp), ($1073, $1074, $1075, $1076, current_timestamp), ($1077, $1078, $1079, $1080, current_timestamp), ($1081, $1082, $1083, $1084, current_timestamp), ($1085, $1086, $1087, $1088, current_timestamp), ($1089, $1090, $1091, $1092, current_timestamp), ($1093, $1094, $1095, $1096, current_timestamp), ($1097, $1098, $1099, $1100, current_timestamp), ($1101, $1102, $1103, $1104, current_timestamp), ($1105, $1106, $1107, $1108, current_timestamp), ($1109, $1110, $1111, $1112, current_timestamp), ($1113, $1114, $1115, $1116, current_timestamp), ($1117, $1118, $1119, $1120, current_timestamp), ($1121, $1122, $1123, $1124, current_timestamp), ($1125, $1126, $1127, $1128, current_timestamp), ($1129, $1130, $1131, $1132, current_timestamp), ($1133, $1134, $1135, $1136, current_timestamp), ($1137, $1138, $1139, $1140, current_timestamp), ($1141, $1142, $1143, $1144, current_timestamp), ($1145, $1146, $1147, $1148, current_timestamp), ($1149, $1150, $1151, $1152, current_timestamp), ($1153, $1154, $1155, $1156, current_timestamp), ($1157, $1158, $1159, $1160, current_timestamp), ($1161, $1162, $1163, $1164, current_timestamp), ($1165, $1166, $1167, $1168, current_timestamp), ($1169, $1170, $1171, $1172, current_timestamp), ($1173, $1174, $1175, $1176, current_timestamp), ($1177, $1178, $1179, $1180, current_timestamp), ($1181, $1182, $1183, $1184, current_timestamp), ($1185, $1186, $1187, $1188, current_timestamp), ($1189, $1190, $1191, $1192, current_timestamp), ($1193, $1194, $1195, $1196, current_timestamp), ($1197, $1198, $1199, $1200, current_timestamp), ($1201, $1202, $1203, $1204, current_timestamp), ($1205, $1206, $1207, $1208, current_timestamp), ($1209, $1210, $1211, $1212, current_timestamp), ($1213, $1214, $1215, $1216, current_timestamp), ($1217, $1218, $1219, $1220, current_timestamp), ($1221, $1222, $1223, $1224, current_timestamp), ($1225, $1226, $1227, $1228, current_timestamp), ($1229, $1230, $1231, $1232, current_timestamp), ($1233, $1234, $1235, $1236, current_timestamp), ($1237, $1238, $1239, $1240, current_timestamp), ($1241, $1242, $1243, $1244, current_timestamp), ($1245, $1246, $1247, $1248, current_timestamp), ($1249, $1250, $1251, $1252, current_timestamp), ($1253, $1254, $1255, $1256, current_timestamp), ($1257, $1258, $1259, $1260, current_timestamp), ($1261, $1262, $1263, $1264, current_timestamp), ($1265, $1266, $1267, $1268, current_timestamp), ($1269, $1270, $1271, $1272, current_timestamp), ($1273, $1274, $1275, $1276, current_timestamp), ($1277, $1278, $1279, $1280, current_timestamp), ($1281, $1282, $1283, $1284, current_timestamp), ($1285, $1286, $1287, $1288, current_timestamp), ($1289, $1290, $1291, $1292, current_timestamp), ($1293, $1294, $1295, $1296, current_timestamp), ($1297, $1298, $1299, $1300, current_timestamp), ($1301, $1302, $1303, $1304, current_timestamp), ($1305, $1306, $1307, $1308, current_timestamp), ($1309, $1310, $1311, $1312, current_timestamp), ($1313, $1314, $1315, $1316, current_timestamp), ($1317, $1318, $1319, $1320, current_timestamp), ($1321, $1322, $1323, $1324, current_timestamp), ($1325, $1326, $1327, $1328, current_timestamp), ($1329, $1330, $1331, $1332, current_timestamp), ($1333, $1334, $1335, $1336, current_timestamp), ($1337, $1338, $1339, $1340, current_timestamp), ($1341, $1342, $1343, $1344, current_timestamp), ($1345, $1346, $1347, $1348, current_timestamp), ($1349, $1350, $1351, $1352, current_timestamp), ($1353, $1354, $1355, $1356, current_timestamp), ($1357, $1358, $1359, $1360, current_timestamp), ($1361, $1362, $1363, $1364, current_timestamp), ($1365, $1366, $1367, $1368, current_timestamp), ($1369, $1370, $1371, $1372, current_timestamp), ($1373, $1374, $1375, $1376, current_timestamp), ($1377, $1378, $1379, $1380, current_timestamp), ($1381, $1382, $1383, $1384, current_timestamp), ($1385, $1386, $1387, $1388, current_timestamp), ($1389, $1390, $1391, $1392, current_timestamp), ($1393, $1394, $1395, $1396, current_timestamp), ($1397, $1398, $1399, $1400, current_timestamp), ($1401, $1402, $1403, $1404, current_timestamp), ($1405, $1406, $1407, $1408, current_timestamp), ($1409, $1410, $1411, $1412, current_timestamp), ($1413, $1414, $1415, $1416, current_timestamp), ($1417, $1418, $1419, $1420, current_timestamp), ($1421, $1422, $1423, $1424, current_timestamp), ($1425, $1426, $1427, $1428, current_timestamp), ($1429, $1430, $1431, $1432, current_timestamp), ($1433, $1434, $1435, $1436, current_timestamp), ($1437, $1438, $1439, $1440, current_timestamp), ($1441, $1442, $1443, $1444, current_timestamp), ($1445, $1446, $1447, $1448, current_timestamp), ($1449, $1450, $1451, $1452, current_timestamp), ($1453, $1454, $1455, $1456, current_timestamp), ($1457, $1458, $1459, $1460, current_timestamp), ($1461, $1462, $1463, $1464, current_timestamp), ($1465, $1466, $1467, $1468, current_timestamp), ($1469, $1470, $1471, $1472, current_timestamp), ($1473, $1474, $1475, $1476, current_timestamp), ($1477, $1478, $1479, $1480, current_timestamp), ($1481, $1482, $1483, $1484, current_timestamp), ($1485, $1486, $1487, $1488, current_timestamp), ($1489, $1490, $1491, $1492, current_timestamp), ($1493, $1494, $1495, $1496, current_timestamp), ($1497, $1498, $1499, $1500, current_timestamp), ($1501, $1502, $1503, $1504, current_timestamp), ($1505, $1506, $1507, $1508, current_timestamp), ($1509, $1510, $1511, $1512, current_timestamp), ($1513, $1514, $1515, $1516, current_timestamp), ($1517, $1518, $1519, $1520, current_timestamp), ($1521, $1522, $1523, $1524, current_timestamp), ($1525, $1526, $1527, $1528, current_timestamp), ($1529, $1530, $1531, $1532, current_timestamp), ($1533, $1534, $1535, $1536, current_timestamp), ($1537, $1538, $1539, $1540, current_timestamp), ($1541, $1542, $1543, $1544, current_timestamp), ($1545, $1546, $1547, $1548, current_timestamp), ($1549, $1550, $1551, $1552, current_timestamp), ($1553, $1554, $1555, $1556, current_timestamp), ($1557, $1558, $1559, $1560, current_timestamp), ($1561, $1562, $1563, $1564, current_timestamp), ($1565, $1566, $1567, $1568, current_timestamp), ($1569, $1570, $1571, $1572, current_timestamp), ($1573, $1574, $1575, $1576, current_timestamp), ($1577, $1578, $1579, $1580, current_timestamp), ($1581, $1582, $1583, $1584, current_timestamp), ($1585, $1586, $1587, $1588, current_timestamp), ($1589, $1590, $1591, $1592, current_timestamp), ($1593, $1594, $1595, $1596, current_timestamp), ($1597, $1598, $1599, $1600, current_timestamp), ($1601, $1602, $1603, $1604, current_timestamp), ($1605, $1606, $1607, $1608, current_timestamp), ($1609, $1610, $1611, $1612, current_timestamp), ($1613, $1614, $1615, $1616, current_timestamp), ($1617, $1618, $1619, $1620, current_timestamp), ($1621, $1622, $1623, $1624, current_timestamp), ($1625, $1626, $1627, $1628, current_timestamp), ($1629, $1630, $1631, $1632, current_timestamp), ($1633, $1634, $1635, $1636, current_timestamp), ($1637, $1638, $1639, $1640, current_timestamp), ($1641, $1642, $1643, $1644, current_timestamp), ($1645, $1646, $1647, $1648, current_timestamp), ($1649, $1650, $1651, $1652, current_timestamp), ($1653, $1654, $1655, $1656, current_timestamp), ($1657, $1658, $1659, $1660, current_timestamp), ($1661, $1662, $1663, $1664, current_timestamp), ($1665, $1666, $1667, $1668, current_timestamp), ($1669, $1670, $1671, $1672, current_timestamp), ($1673, $1674, $1675, $1676, current_timestamp), ($1677, $1678, $1679, $1680, current_timestamp), ($1681, $1682, $1683, $1684, current_timestamp), ($1685, $1686, $1687, $1688, current_timestamp), ($1689, $1690, $1691, $1692, current_timestamp), ($1693, $1694, $1695, $1696, current_timestamp), ($1697, $1698, $1699, $1700, current_timestamp), ($1701, $1702, $1703, $1704, current_timestamp), ($1705, $1706, $1707, $1708, current_timestamp), ($1709, $1710, $1711, $1712, current_timestamp), ($1713, $1714, $1715, $1716, current_timestamp), ($1717, $1718, $1719, $1720, current_timestamp), ($1721, $1722, $1723, $1724, current_timestamp), ($1725, $1726, $1727, $1728, current_timestamp), ($1729, $1730, $1731, $1732, current_timestamp), ($1733, $1734, $1735, $1736, current_timestamp), ($1737, $1738, $1739, $1740, current_timestamp), ($1741, $1742, $1743, $1744, current_timestamp), ($1745, $1746, $1747, $1748, current_timestamp), ($1749, $1750, $1751, $1752, current_timestamp), ($1753, $1754, $1755, $1756, current_timestamp), ($1757, $1758, $1759, $1760, current_timestamp), ($1761, $1762, $1763, $1764, current_timestamp), ($1765, $1766, $1767, $1768, current_timestamp), ($1769, $1770, $1771, $1772, current_timestamp), ($1773, $1774, $1775, $1776, current_timestamp), ($1777, $1778, $1779, $1780, current_timestamp), ($1781, $1782, $1783, $1784, current_timestamp), ($1785, $1786, $1787, $1788, current_timestamp), ($1789, $1790, $1791, $1792, current_timestamp), ($1793, $1794, $1795, $1796, current_timestamp), ($1797, $1798, $1799, $1800, current_timestamp), ($1801, $1802, $1803, $1804, current_timestamp), ($1805, $1806, $1807, $1808, current_timestamp), ($1809, $1810, $1811, $1812, current_timestamp), ($1813, $1814, $1815, $1816, current_timestamp), ($1817, $1818, $1819, $1820, current_timestamp), ($1821, $1822, $1823, $1824, current_timestamp), ($1825, $1826, $1827, $1828, current_timestamp), ($1829, $1830, $1831, $1832, current_timestamp), ($1833, $1834, $1835, $1836, current_timestamp), ($1837, $1838, $1839, $1840, current_timestamp), ($1841, $1842, $1843, $1844, current_timestamp), ($1845, $1846, $1847, $1848, current_timestamp), ($1849, $1850, $1851, $1852, current_timestamp), ($1853, $1854, $1855, $1856, current_timestamp), ($1857, $1858, $1859, $1860, current_timestamp), ($1861, $1862, $1863, $1864, current_timestamp), ($1865, $1866, $1867, $1868, current_timestamp), ($1869, $1870, $1871, $1872, current_timestamp), ($1873, $1874, $1875, $1876, current_timestamp), ($1877, $1878, $1879, $1880, current_timestamp), ($1881, $1882, $1883, $1884, current_timestamp), ($1885, $1886, $1887, $1888, current_timestamp), ($1889, $1890, $1891, $1892, current_timestamp), ($1893, $1894, $1895, $1896, current_timestamp), ($1897, $1898, $1899, $1900, current_timestamp), ($1901, $1902, $1903, $1904, current_timestamp), ($1905, $1906, $1907, $1908, current_timestamp), ($1909, $1910, $1911, $1912, current_timestamp), ($1913, $1914, $1915, $1916, current_timestamp), ($1917, $1918, $1919, $1920, current_timestamp), ($1921, $1922, $1923, $1924, current_timestamp), ($1925, $1926, $1927, $1928, current_timestamp), ($1929, $1930, $1931, $1932, current_timestamp), ($1933, $1934, $1935, $1936, current_timestamp), ($1937, $1938, $1939, $1940, current_timestamp), ($1941, $1942, $1943, $1944, current_timestamp), ($1945, $1946, $1947, $1948, current_timestamp), ($1949, $1950, $1951, $1952, current_timestamp), ($1953, $1954, $1955, $1956, current_timestamp), ($1957, $1958, $1959, $1960, current_timestamp), ($1961, $1962, $1963, $1964, current_timestamp), ($1965, $1966, $1967, $1968, current_timestamp), ($1969, $1970, $1971, $1972, current_timestamp), ($1973, $1974, $1975, $1976, current_timestamp), ($1977, $1978, $1979, $1980, current_timestamp), ($1981, $1982, $1983, $1984, current_timestamp), ($1985, $1986, $1987, $1988, current_timestamp), ($1989, $1990, $1991, $1992, current_timestamp), ($1993, $1994, $1995, $1996, current_timestamp), ($1997, $1998, $1999, $2000, current_timestamp) ON CONFLICT (finding_id) DO |
| 26 | 13.8 ms | 9.0 ms | 0.5 ms | 26 | No | INSERT INTO batched_background_migration_job_transition_logs (batched_background_migration_job_id, created_at, updated_at, previous_status, next_status) VALUES ($1, $2, $3, $4, $5) RETURNING id |
| 1200 | 568.8 ms | 4.7 ms | 0.5 ms | 1188 | No | SELECT vulnerability_occurrences.id |
| 13 | 9.2 ms | 3.7 ms | 0.7 ms | 13 | No | UPDATE batched_background_migration_jobs |
| 13 | 10.3 ms | 2.0 ms | 0.8 ms | 13 | No | UPDATE batched_background_migration_jobs |
| 1188 | 529.3 ms | 1.2 ms | 0.4 ms | 594000 | No | SELECT vulnerability_occurrences.id |
| 13 | 7.0 ms | 1.0 ms | 0.5 ms | 13 | No | SELECT sum(batched_background_migration_jobs.batch_size) |
| 12 | 5.0 ms | 0.6 ms | 0.4 ms | 6000 | No | SELECT vulnerability_occurrences.id |
| 26 | 4.6 ms | 0.4 ms | 0.2 ms | 26 | No | SELECT batched_background_migration_jobs.* |
| 12 | 2.5 ms | 0.2 ms | 0.2 ms | 12 | No | SELECT vulnerability_occurrences.id |
| 1 | 0.2 ms | 0.2 ms | 0.2 ms | 0 | No | SELECT vulnerability_occurrences.id |
| 1 | 0.2 ms | 0.2 ms | 0.2 ms | 1 | No | SELECT vulnerability_occurrences.id |
| 1 | 0.2 ms | 0.2 ms | 0.2 ms | 1 | No | SELECT vulnerability_occurrences.id |
Histogram of batch runtimes for BackfillVulnerabilityFindingRiskScores
| Batch Runtime | Count |
|---|---|
| 0 seconds - 10 seconds | 1 |
| 10 seconds - 1 minute | 0 |
| 1 minute - 2 minutes | 1 |
| 2 minutes - 3 minutes | 11 |
| 3 minutes - 5 minutes | 0 |
| 5 minutes + | 0 |
Histogram across all sampled batches of BackfillVulnerabilityFindingRiskScores
| Query Runtime | Count |
|---|---|
| 0 seconds - 0.1 seconds | 25 |
| 0.1 seconds - 0.5 seconds | 6956 |
| 0.5 seconds - 1 second | 80 |
| 1 second - 2 seconds | 4 |
| 2 seconds - 5 seconds | 0 |
| 5 seconds + | 0 |
Output of the post-deployment migration
bundle exec rake db:migrate:up:main VERSION=20251013084000
main: == [advisory_lock_connection] object_id: 129620, pg_backend_pid: 58948
main: == 20251013084000 QueueBackfillVulnerabilityFindingRiskScores: migrating ======
main: == 20251013084000 QueueBackfillVulnerabilityFindingRiskScores: migrated (0.1411s)
main: == [advisory_lock_connection] object_id: 129620, pg_backend_pid: 58948bundle exec rake db:migrate:down:main VERSION=20251013084000
main: == [advisory_lock_connection] object_id: 129620, pg_backend_pid: 58503
main: == 20251013084000 QueueBackfillVulnerabilityFindingRiskScores: reverting ======
main: == 20251013084000 QueueBackfillVulnerabilityFindingRiskScores: reverted (0.1173s)
main: == [advisory_lock_connection] object_id: 129620, pg_backend_pid: 58503Select query used in background migration
SELECT "vulnerability_occurrences"."id" FROM "vulnerability_occurrences" WHERE "vulnerability_occurrences"."id" BETWEEN 1 AND 10809 AND "vulnerability_occurrences"."id" >= 9585 ORDER BY "vulnerability_occurrences"."id" ASC LIMIT 1 OFFSET 500`backfill_risk_scores` method queries
/* Finding.where(id: sub_batch.select(:id)) */
SELECT "vulnerability_occurrences".* FROM "vulnerability_occurrences" WHERE "vulnerability_occurrences"."id" IN (SELECT "vulnerability_occurrences"."id" FROM "vulnerability_occurrences" WHERE "vulnerability_occurrences"."id" BETWEEN 1 AND 10809 AND "vulnerability_occurrences"."id" >= 1 AND "vulnerability_occurrences"."id" < 501)
/* Finding.where(id: sub_batch.select(:id)).includes(:cve_identifiers).load */
SELECT "vulnerability_occurrence_identifiers"."id" AS t0_r0, "vulnerability_occurrence_identifiers"."created_at" AS t0_r1, "vulnerability_occurrence_identifiers"."updated_at" AS t0_r2, "vulnerability_occurrence_identifiers"."occurrence_id" AS t0_r3, "vulnerability_occurrence_identifiers"."identifier_id" AS t0_r4, "vulnerability_occurrence_identifiers"."project_id" AS t0_r5, "vulnerability_identifiers"."id" AS t1_r0, "vulnerability_identifiers"."created_at" AS t1_r1, "vulnerability_identifiers"."updated_at" AS t1_r2, "vulnerability_identifiers"."project_id" AS t1_r3, "vulnerability_identifiers"."fingerprint" AS t1_r4, "vulnerability_identifiers"."external_type" AS t1_r5, "vulnerability_identifiers"."external_id" AS t1_r6, "vulnerability_identifiers"."name" AS t1_r7, "vulnerability_identifiers"."url" AS t1_r8 FROM "vulnerability_occurrence_identifiers" LEFT OUTER JOIN "vulnerability_identifiers" ON "vulnerability_identifiers"."id" = "vulnerability_occurrence_identifiers"."identifier_id" WHERE (LOWER(external_type) = 'cve') AND "vulnerability_occurrence_identifiers"."occurrence_id" IN (4493, 4494, 4495, 4496, 4497, 4498, 4499, 4500, 4501, 4502, 4503, 4567, 4568, 4569, 4570, 4571, 4572, 4573, 4574, 4575, 4576, 4577, 4578, 4579, 4580, 4581, 4582, 4583, 4584, 4585, 4586, 4587, 9054, 9055, 9056, 9057, 9058, 9059, 9060, 9061, 9062, 9063, 9064, 9065, 9066, 9067, 9068, 9069, 9070, 9071, 9072, 9073, 9074, 9075, 9076, 9119, 9120, 9121, 9122, 9123, 9124, 9125, 9126, 9127, 9128, 9129, 9130, 9131, 9132, 9154, 9155, 9156, 9157, 9158, 9159, 9160, 9161, 9162, 9163, 9164, 9165, 9166, 9167, 9168, 9169, 9170, 9171, 9172, 9173, 9174, 9175, 9176, 9177, 9178, 9179, 9180, 9181, 9182, 9183, 9184, 9185, 9186, 9187, 9188, 9189, 9190, 9191, 9192, 9193, 9194, 9195, 9196, 9197, 9198, 9199, 9200, 9201, 9202, 9203, 9204, 9205, 9206, 9207, 9208, 9209, 9210, 9211, 9212, 9213, 9214, 9215, 9216, 9217, 9218, 9219, 9220, 9221, 9222, 9223, 9224, 9225, 9226, 9227, 9228, 9229, 9230, 9231, 9232, 9233, 9234, 9235, 9236, 9237, 9238, 9239, 9240, 9241, 9242, 9243, 9244, 9245, 9246, 9247, 9248, 9249, 9250, 9251, 9252, 9253, 9254, 9255, 9256, 9257, 9258, 9259, 9260, 9261, 9262, 9263, 9264, 9265, 9266, 9267, 9268, 9269, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9278, 9279, 9280, 9281, 9282, 9283, 9284, 9285, 9286, 9287, 9288, 9289, 9290, 9291, 9292, 9293, 9294, 9295, 9296, 9297, 9298, 9299, 9300, 9301, 9302, 9303, 9304, 9305, 9306, 9307, 9308, 9309, 9310, 9311, 9312, 9313, 9314, 9315, 9316, 9317, 9318, 9319, 9320, 9321, 9322, 9323, 9324, 9325, 9326, 9327, 9328, 9329, 9330, 9331, 9332, 9333, 9334, 9335, 9336, 9337, 9338, 9339, 9340, 9341, 9342, 9343, 9344, 9345, 9346, 9347, 9348, 9349, 9350, 9351, 9352, 9353, 9354, 9355, 9356, 9357, 9358, 9359, 9360, 9361, 9362, 9363, 9364, 9365, 9366, 9367, 9368, 9369, 9370, 9371, 9372, 9373, 9374, 9375, 9376, 9377, 9378, 9379, 9380, 9381, 9382, 9383, 9384, 9385, 9386, 9387, 9388, 9389, 9390, 9391, 9392, 9393, 9394, 9395, 9396, 9397, 9398, 9399, 9400, 9401, 9402, 9403, 9404, 9405, 9406, 9407, 9408, 9409, 9410, 9411, 9412, 9413, 9414, 9415, 9416, 9417, 9418, 9419, 9420, 9421, 9422, 9423, 9424, 9425, 9426, 9427, 9428, 9429, 9430, 9431, 9432, 9433, 9434, 9435, 9436, 9437, 9438, 9439, 9440, 9441, 9442, 9443, 9444, 9445, 9446, 9447, 9448, 9449, 9450, 9451, 9452, 9453, 9454, 9455, 9456, 9457, 9458, 9459, 9460, 9461, 9462, 9463, 9464, 9465, 9466, 9467, 9468, 9469, 9470, 9471, 9472, 9473, 9474, 9475, 9476, 9477, 9478, 9479, 9480, 9481, 9482, 9483, 9484, 9485, 9486, 9487, 9488, 9489, 9490, 9491, 9492, 9493, 9494, 9495, 9496, 9497, 9498, 9499, 9500, 9501, 9502, 9503, 9504, 9505, 9506, 9507, 9508, 9509, 9510, 9511, 9512, 9513, 9514, 9515, 9516, 9517, 9518, 9519, 9520, 9521, 9522, 9523, 9524, 9525, 9526, 9527, 9528, 9529, 9530, 9531, 9532, 9533, 9534, 9535, 9536, 9537, 9538, 9539, 9540, 9541, 9542, 9543, 9544, 9545, 9546, 9547, 9548, 9549, 9550, 9551, 9552, 9553, 9554, 9555, 9556, 9557, 9558, 9559, 9560, 9561, 9562, 9563, 9564, 9565, 9566, 9567, 9568, 9569, 9570, 9571, 9572, 9573, 9574, 9575, 9576, 9577, 9578, 9579, 9580, 9581, 9582, 9583, 9584)
/* CveEnrichment.where(cve: cve_names).index_by(&:cve) */
SELECT "pm_cve_enrichment".* FROM "pm_cve_enrichment" WHERE "pm_cve_enrichment"."cve" IN ('CVE-2019-10086', 'CVE-2024-56326', 'CVE-2024-12797', 'CVE-2024-22195', 'CVE-2024-34064', 'CVE-2024-56201', 'CVE-2025-27516', 'CVE-2024-21272', 'CVE-2019-18874', 'CVE-2024-21506', 'CVE-2024-5629', 'CVE-2024-35195', 'CVE-2025-47273', 'CVE-2025-47287', 'CVE-2023-11147', 'CVE-2020-60933', 'CVE-2022-25613', 'CVE-2021-38572', 'CVE-2023-94279', 'CVE-2017-43844', 'CVE-2017-12595', 'CVE-2023-85099', 'CVE-2017-67275', 'CVE-2019-39492', 'CVE-2019-55129', 'CVE-2023-97411', 'CVE-2023-65911', 'CVE-2018-79836', 'CVE-2018-97257', 'CVE-2023-19806', 'CVE-2022-31209', 'CVE-2017-74194', 'CVE-2018-32136', 'CVE-2021-40396', 'CVE-2021-90899', 'CVE-2018-63274', 'CVE-2022-64139', 'CVE-2020-85463', 'CVE-2023-78642', 'CVE-2018-38262', 'CVE-2023-11795', 'CVE-2019-98598', 'CVE-2020-14924', 'CVE-2021-30597', 'CVE-2017-41990', 'CVE-2023-36466', 'CVE-2018-90135', 'CVE-2021-49719', 'CVE-2021-21019', 'CVE-2017-28539', 'CVE-2021-37609', 'CVE-2020-63683', 'CVE-2022-85567', 'CVE-2023-86840', 'CVE-2022-79805', 'CVE-2021-68410', 'CVE-2017-30300', 'CVE-2021-87191', 'CVE-2018-43468', 'CVE-2017-75526', 'CVE-2023-60072', 'CVE-2019-78825', 'CVE-2019-61072', 'CVE-2018-39075', 'CVE-2021-25331', 'CVE-2022-40553', 'CVE-2022-69966', 'CVE-2020-90343', 'CVE-2019-47175', 'CVE-2022-29232', 'CVE-2023-87183', 'CVE-2019-96459', 'CVE-2018-36723', 'CVE-2020-66767', 'CVE-2019-44899', 'CVE-2019-44304', 'CVE-2019-74802', 'CVE-2019-93505', 'CVE-2019-82959', 'CVE-2018-13228', 'CVE-2019-70965', 'CVE-2017-84203', 'CVE-2018-91987', 'CVE-2021-52453', 'CVE-2017-42832', 'CVE-2021-16539', 'CVE-2021-24811', 'CVE-2021-24745', 'CVE-2021-70212', 'CVE-2019-64231', 'CVE-2020-95025', 'CVE-2019-69321', 'CVE-2019-39710', 'CVE-2017-21763', 'CVE-2022-20493', 'CVE-2021-70547', 'CVE-2020-91496', 'CVE-2017-24349', 'CVE-2018-60233', 'CVE-2021-87142', 'CVE-2017-45814', 'CVE-2020-48458', 'CVE-2019-87263', 'CVE-2022-85238', 'CVE-2021-24980', 'CVE-2019-16687', 'CVE-2018-19858', 'CVE-2017-77011', 'CVE-2020-39769', 'CVE-2020-77767', 'CVE-2022-69533', 'CVE-2017-63191', 'CVE-2018-36353', 'CVE-2022-80178', 'CVE-2019-68265', 'CVE-2017-38776', 'CVE-2022-89983', 'CVE-2020-13976', 'CVE-2023-77151', 'CVE-2022-17795', 'CVE-2023-85125', 'CVE-2023-54239', 'CVE-2023-26180', 'CVE-2021-59777', 'CVE-2019-29156', 'CVE-2020-57955', 'CVE-2023-85582', 'CVE-2021-83508', 'CVE-2018-52546', 'CVE-2019-33755', 'CVE-2017-74071', 'CVE-2022-87599', 'CVE-2019-31817', 'CVE-2023-47969', 'CVE-2023-83569', 'CVE-2018-71112', 'CVE-2020-17052', 'CVE-2017-86960', 'CVE-2018-24174', 'CVE-2022-43205', 'CVE-2017-29838', 'CVE-2020-20434', 'CVE-2019-70504', 'CVE-2022-17719', 'CVE-2021-65976', 'CVE-2020-35790', 'CVE-2023-59349', 'CVE-2022-66422', 'CVE-2023-39688', 'CVE-2021-38884', 'CVE-2018-24020', 'CVE-2017-36951', 'CVE-2022-87811', 'CVE-2018-17893', 'CVE-2020-30923', 'CVE-2017-71849', 'CVE-2023-73436', 'CVE-2023-26613', 'CVE-2017-22390', 'CVE-2021-96670', 'CVE-2017-70574', 'CVE-2021-56668', 'CVE-2023-15929', 'CVE-2023-83747', 'CVE-2022-15168', 'CVE-2017-20328', 'CVE-2021-50529', 'CVE-2020-92270', 'CVE-2022-54895', 'CVE-2021-55553', 'CVE-2018-34853', 'CVE-2017-45212', 'CVE-2021-98644', 'CVE-2020-17508', 'CVE-2021-63595', 'CVE-2022-83773', 'CVE-2017-94882', 'CVE-2022-76122', 'CVE-2018-41767', 'CVE-2021-70251', 'CVE-2023-36363', 'CVE-2020-51106', 'CVE-2022-96032', 'CVE-2019-53294', 'CVE-2019-29259', 'CVE-2022-49615', 'CVE-2018-32234', 'CVE-2018-47530', 'CVE-2018-98890', 'CVE-2021-90485', 'CVE-2020-93804', 'CVE-2017-75725', 'CVE-2019-33990', 'CVE-2018-54635', 'CVE-2020-78683', 'CVE-2018-94958', 'CVE-2021-59530', 'CVE-2023-46127', 'CVE-2020-75071', 'CVE-2018-15296', 'CVE-2023-28082', 'CVE-2021-65768', 'CVE-2018-61719', 'CVE-2023-33590', 'CVE-2018-75325', 'CVE-2017-93743', 'CVE-2019-99717', 'CVE-2017-77592', 'CVE-2021-24837', 'CVE-2023-86739', 'CVE-2019-54222', 'CVE-2020-45483', 'CVE-2017-25661', 'CVE-2022-98778', 'CVE-2022-55027', 'CVE-2023-15087', 'CVE-2019-76433', 'CVE-2023-77692', 'CVE-2017-56605', 'CVE-2021-64686', 'CVE-2022-19357', 'CVE-2019-87189', 'CVE-2018-71836', 'CVE-2018-68149', 'CVE-2020-95938', 'CVE-2018-60750', 'CVE-2022-98271', 'CVE-2023-25232', 'CVE-2022-28047', 'CVE-2019-27235', 'CVE-2020-46248', 'CVE-2019-90022', 'CVE-2023-25672', 'CVE-2019-70588', 'CVE-2023-59261', 'CVE-2019-24349', 'CVE-2022-66263', 'CVE-2018-69020', 'CVE-2017-87328', 'CVE-2018-21508', 'CVE-2018-65611', 'CVE-2020-82647', 'CVE-2019-72880', 'CVE-2018-78795', 'CVE-2017-30401', 'CVE-2023-70931', 'CVE-2017-26259', 'CVE-2021-68232', 'CVE-2018-42262', 'CVE-2022-78187', 'CVE-2023-95504', 'CVE-2021-44946', 'CVE-2017-75547', 'CVE-2021-99735', 'CVE-2018-98885', 'CVE-2022-69176', 'CVE-2017-68295', 'CVE-2020-12358', 'CVE-2017-87715', 'CVE-2022-91015', 'CVE-2017-65879', 'CVE-2020-62894', 'CVE-2018-41746', 'CVE-2023-45195', 'CVE-2021-74969', 'CVE-2023-24662', 'CVE-2020-25870', 'CVE-2018-18461', 'CVE-2021-14001', 'CVE-2018-54076', 'CVE-2018-65937', 'CVE-2023-62109', 'CVE-2022-14494', 'CVE-2017-94933', 'CVE-2020-67725', 'CVE-2020-14542', 'CVE-2018-76862', 'CVE-2018-80545', 'CVE-2022-32590', 'CVE-2019-34838', 'CVE-2021-33755', 'CVE-2019-70316', 'CVE-2019-77185', 'CVE-2021-69269', 'CVE-2019-25915', 'CVE-2020-13297', 'CVE-2019-90769', 'CVE-2023-56529', 'CVE-2017-59925', 'CVE-2022-22953', 'CVE-2018-36329', 'CVE-2017-36894', 'CVE-2020-57002', 'CVE-2021-55521', 'CVE-2020-56043', 'CVE-2023-52780', 'CVE-2021-66905', 'CVE-2020-77226', 'CVE-2022-12752', 'CVE-2021-47700', 'CVE-2022-13112', 'CVE-2019-51966', 'CVE-2023-75670', 'CVE-2023-72152', 'CVE-2018-30479', 'CVE-2019-97116', 'CVE-2023-83828', 'CVE-2023-14057', 'CVE-2018-61145', 'CVE-2018-87349', 'CVE-2022-87215', 'CVE-2020-27672', 'CVE-2023-97206', 'CVE-2022-41261', 'CVE-2019-50765', 'CVE-2023-31715', 'CVE-2023-15920', 'CVE-2018-48176', 'CVE-2023-13242', 'CVE-2022-12353', 'CVE-2023-64787', 'CVE-2023-12731', 'CVE-2020-18574', 'CVE-2020-28374', 'CVE-2020-11352', 'CVE-2017-69942', 'CVE-2021-73154', 'CVE-2023-46728', 'CVE-2018-57238', 'CVE-2018-98123', 'CVE-2020-83654', 'CVE-2018-48973', 'CVE-2017-70417', 'CVE-2017-10124', 'CVE-2021-36118', 'CVE-2019-88377', 'CVE-2023-10221', 'CVE-2022-81071', 'CVE-2018-44867', 'CVE-2018-21807', 'CVE-2018-30152', 'CVE-2018-40724', 'CVE-2020-89473', 'CVE-2019-27952', 'CVE-2018-65026', 'CVE-2018-32007', 'CVE-2019-98953', 'CVE-2017-23476', 'CVE-2022-10501', 'CVE-2023-48775', 'CVE-2023-40449', 'CVE-2017-50237', 'CVE-2022-22879', 'CVE-2021-77010', 'CVE-2018-93587', 'CVE-2018-74370', 'CVE-2018-80321', 'CVE-2020-50521', 'CVE-2018-36301', 'CVE-2022-54495', 'CVE-2019-97024', 'CVE-2022-66485', 'CVE-2022-86526', 'CVE-2022-60005', 'CVE-2021-11086', 'CVE-2020-38484', 'CVE-2020-18125', 'CVE-2023-55627', 'CVE-2021-50283', 'CVE-2022-89570', 'CVE-2023-34892', 'CVE-2023-24907', 'CVE-2021-25686', 'CVE-2020-20499', 'CVE-2020-43919', 'CVE-2017-48934', 'CVE-2022-16207', 'CVE-2021-51002', 'CVE-2022-44103', 'CVE-2023-38805', 'CVE-2020-75364', 'CVE-2018-31345', 'CVE-2023-15233', 'CVE-2020-31075', 'CVE-2018-96553', 'CVE-2021-77417', 'CVE-2018-32626', 'CVE-2019-20421', 'CVE-2017-47220', 'CVE-2023-86362', 'CVE-2022-35981', 'CVE-2018-55184', 'CVE-2023-85818', 'CVE-2022-85128', 'CVE-2022-22694', 'CVE-2023-10804', 'CVE-2023-52956', 'CVE-2020-43942', 'CVE-2019-38507', 'CVE-2023-63390', 'CVE-2023-47756', 'CVE-2019-51957', 'CVE-2018-94714', 'CVE-2018-68701', 'CVE-2023-30756', 'CVE-2018-93184', 'CVE-2023-80823', 'CVE-2022-55819', 'CVE-2020-78963', 'CVE-2018-99835', 'CVE-2019-71583', 'CVE-2020-33289', 'CVE-2022-79101', 'CVE-2020-49158', 'CVE-2023-47167', 'CVE-2021-42300', 'CVE-2017-94556', 'CVE-2020-65071', 'CVE-2018-70077', 'CVE-2019-53885', 'CVE-2023-95570', 'CVE-2017-64201', 'CVE-2018-15273', 'CVE-2023-57646')Upsert query used in each sub-batch
INSERT INTO
"vulnerability_finding_risk_scores" (
"finding_id",
"project_id",
"risk_score",
"updated_at",
"created_at"
)
VALUES
(
4493,
56,
0.05,
'2025-10-27 12:52:26.747312',
CURRENT_TIMESTAMP
),
(
4494,
56,
0.05,
'2025-10-27 12:52:26.747328',
CURRENT_TIMESTAMP
),
(
4495,
56,
0.05,
'2025-10-27 12:52:26.747331',
CURRENT_TIMESTAMP
),
(
4496,
56,
0.05,
'2025-10-27 12:52:26.747335',
CURRENT_TIMESTAMP
),
(
4497,
56,
0.05,
'2025-10-27 12:52:26.747338',
CURRENT_TIMESTAMP
),
(
4498,
56,
0.05,
'2025-10-27 12:52:26.747341',
CURRENT_TIMESTAMP
),
(
4499,
56,
0.05,
'2025-10-27 12:52:26.747344',
CURRENT_TIMESTAMP
),
(
4500,
56,
0.05,
'2025-10-27 12:52:26.747347',
CURRENT_TIMESTAMP
),
(
4501,
56,
0.05,
'2025-10-27 12:52:26.747350',
CURRENT_TIMESTAMP
),
(
4502,
56,
0.05,
'2025-10-27 12:52:26.747354',
CURRENT_TIMESTAMP
),
(
4503,
56,
0.05,
'2025-10-27 12:52:26.747356',
CURRENT_TIMESTAMP
),
(
4567,
55,
0.05,
'2025-10-27 12:52:26.747360',
CURRENT_TIMESTAMP
),
(
4568,
55,
0.05,
'2025-10-27 12:52:26.747363',
CURRENT_TIMESTAMP
),
(
4569,
55,
0.05,
'2025-10-27 12:52:26.747366',
CURRENT_TIMESTAMP
),
(
4570,
55,
0.05,
'2025-10-27 12:52:26.747369',
CURRENT_TIMESTAMP
),
(
4571,
55,
0.05,
'2025-10-27 12:52:26.747372',
CURRENT_TIMESTAMP
),
(
4572,
55,
0.05,
'2025-10-27 12:52:26.747375',
CURRENT_TIMESTAMP
),
(
4573,
55,
0.05,
'2025-10-27 12:52:26.747378',
CURRENT_TIMESTAMP
),
(
4574,
55,
0.05,
'2025-10-27 12:52:26.747381',
CURRENT_TIMESTAMP
),
(
4575,
55,
0.05,
'2025-10-27 12:52:26.747384',
CURRENT_TIMESTAMP
),
(
4576,
55,
0.05,
'2025-10-27 12:52:26.747387',
CURRENT_TIMESTAMP
),
(
4577,
55,
0.05,
'2025-10-27 12:52:26.747391',
CURRENT_TIMESTAMP
),
(
4578,
55,
0.05,
'2025-10-27 12:52:26.747394',
CURRENT_TIMESTAMP
),
(
4579,
55,
0.05,
'2025-10-27 12:52:26.747397',
CURRENT_TIMESTAMP
),
(
4580,
55,
0.05,
'2025-10-27 12:52:26.747409',
CURRENT_TIMESTAMP
),
(
4581,
55,
0.05,
'2025-10-27 12:52:26.747412',
CURRENT_TIMESTAMP
),
(
4582,
55,
0.6,
'2025-10-27 12:52:26.747415',
CURRENT_TIMESTAMP
),
(
4583,
55,
0.05,
'2025-10-27 12:52:26.747419',
CURRENT_TIMESTAMP
),
(
4584,
55,
0.05,
'2025-10-27 12:52:26.747421',
CURRENT_TIMESTAMP
),
(
4585,
55,
0.05,
'2025-10-27 12:52:26.747424',
CURRENT_TIMESTAMP
),
(
4586,
55,
0.05,
'2025-10-27 12:52:26.747427',
CURRENT_TIMESTAMP
),
(
4587,
55,
0.05,
'2025-10-27 12:52:26.747430',
CURRENT_TIMESTAMP
),
(
9054,
70,
0.6,
'2025-10-27 12:52:26.747432',
CURRENT_TIMESTAMP
),
(
9055,
70,
0.05,
'2025-10-27 12:52:26.747435',
CURRENT_TIMESTAMP
),
(
9056,
71,
0.05,
'2025-10-27 12:52:26.747438',
CURRENT_TIMESTAMP
),
(
9057,
71,
0.05,
'2025-10-27 12:52:26.747441',
CURRENT_TIMESTAMP
),
(
9058,
71,
0.05,
'2025-10-27 12:52:26.747444',
CURRENT_TIMESTAMP
),
(
9059,
71,
0.6,
'2025-10-27 12:52:26.747446',
CURRENT_TIMESTAMP
),
(
9060,
71,
0.05,
'2025-10-27 12:52:26.747450',
CURRENT_TIMESTAMP
),
(
9061,
71,
0.05,
'2025-10-27 12:52:26.747452',
CURRENT_TIMESTAMP
),
(
9062,
71,
0.05,
'2025-10-27 12:52:26.747456',
CURRENT_TIMESTAMP
),
(
9063,
71,
0.05,
'2025-10-27 12:52:26.747459',
CURRENT_TIMESTAMP
),
(
9064,
71,
0.05,
'2025-10-27 12:52:26.747461',
CURRENT_TIMESTAMP
),
(
9065,
71,
0.05,
'2025-10-27 12:52:26.747464',
CURRENT_TIMESTAMP
),
(
9066,
71,
0.05,
'2025-10-27 12:52:26.747468',
CURRENT_TIMESTAMP
),
(
9067,
71,
0.05,
'2025-10-27 12:52:26.747471',
CURRENT_TIMESTAMP
),
(
9068,
71,
0.05,
'2025-10-27 12:52:26.747474',
CURRENT_TIMESTAMP
),
(
9069,
71,
0.05,
'2025-10-27 12:52:26.747477',
CURRENT_TIMESTAMP
),
(
9070,
71,
0.05,
'2025-10-27 12:52:26.747480',
CURRENT_TIMESTAMP
),
(
9071,
71,
0.05,
'2025-10-27 12:52:26.747483',
CURRENT_TIMESTAMP
),
(
9072,
71,
0.05,
'2025-10-27 12:52:26.747486',
CURRENT_TIMESTAMP
),
(
9073,
71,
0.05,
'2025-10-27 12:52:26.747488',
CURRENT_TIMESTAMP
),
(
9074,
71,
0.05,
'2025-10-27 12:52:26.747491',
CURRENT_TIMESTAMP
),
(
9075,
71,
0.05,
'2025-10-27 12:52:26.747494',
CURRENT_TIMESTAMP
),
(
9076,
71,
0.05,
'2025-10-27 12:52:26.747497',
CURRENT_TIMESTAMP
),
(
9119,
73,
0.4,
'2025-10-27 12:52:26.747502',
CURRENT_TIMESTAMP
),
(
9120,
73,
0.2,
'2025-10-27 12:52:26.747507',
CURRENT_TIMESTAMP
),
(
9121,
73,
0.2,
'2025-10-27 12:52:26.747512',
CURRENT_TIMESTAMP
),
(
9122,
73,
0.2,
'2025-10-27 12:52:26.747517',
CURRENT_TIMESTAMP
),
(
9123,
73,
0.4,
'2025-10-27 12:52:26.747521',
CURRENT_TIMESTAMP
),
(
9124,
73,
0.2,
'2025-10-27 12:52:26.747526',
CURRENT_TIMESTAMP
),
(
9125,
73,
0.4,
'2025-10-27 12:52:26.747531',
CURRENT_TIMESTAMP
),
(
9126,
73,
0.4,
'2025-10-27 12:52:26.747535',
CURRENT_TIMESTAMP
),
(
9127,
73,
0.2,
'2025-10-27 12:52:26.747539',
CURRENT_TIMESTAMP
),
(
9128,
73,
0.2,
'2025-10-27 12:52:26.747543',
CURRENT_TIMESTAMP
),
(
9129,
73,
0.4,
'2025-10-27 12:52:26.747547',
CURRENT_TIMESTAMP
),
(
9130,
73,
0.2,
'2025-10-27 12:52:26.747552',
CURRENT_TIMESTAMP
),
(
9131,
73,
0.2,
'2025-10-27 12:52:26.747556',
CURRENT_TIMESTAMP
),
(
9132,
73,
0.4,
'2025-10-27 12:52:26.747560',
CURRENT_TIMESTAMP
),
(
9154,
74,
0.05,
'2025-10-27 12:52:26.747564',
CURRENT_TIMESTAMP
),
(
9155,
74,
0.05,
'2025-10-27 12:52:26.747567',
CURRENT_TIMESTAMP
),
(
9156,
74,
0.05,
'2025-10-27 12:52:26.747569',
CURRENT_TIMESTAMP
),
(
9157,
74,
0.05,
'2025-10-27 12:52:26.747572',
CURRENT_TIMESTAMP
),
(
9158,
74,
0.05,
'2025-10-27 12:52:26.747576',
CURRENT_TIMESTAMP
),
(
9159,
74,
0.05,
'2025-10-27 12:52:26.747579',
CURRENT_TIMESTAMP
),
(
9160,
74,
0.05,
'2025-10-27 12:52:26.747582',
CURRENT_TIMESTAMP
),
(
9161,
74,
0.05,
'2025-10-27 12:52:26.747585',
CURRENT_TIMESTAMP
),
(
9162,
74,
0.05,
'2025-10-27 12:52:26.747588',
CURRENT_TIMESTAMP
),
(
9163,
74,
0.05,
'2025-10-27 12:52:26.747590',
CURRENT_TIMESTAMP
),
(
9164,
74,
0.05,
'2025-10-27 12:52:26.747593',
CURRENT_TIMESTAMP
),
(
9165,
74,
0.05,
'2025-10-27 12:52:26.747596',
CURRENT_TIMESTAMP
),
(
9166,
74,
0.05,
'2025-10-27 12:52:26.747598',
CURRENT_TIMESTAMP
),
(
9167,
74,
0.6,
'2025-10-27 12:52:26.747601',
CURRENT_TIMESTAMP
),
(
9168,
74,
0.05,
'2025-10-27 12:52:26.747604',
CURRENT_TIMESTAMP
),
(
9169,
74,
0.05,
'2025-10-27 12:52:26.747607',
CURRENT_TIMESTAMP
),
(
9170,
74,
0.05,
'2025-10-27 12:52:26.747609',
CURRENT_TIMESTAMP
),
(
9171,
74,
0.05,
'2025-10-27 12:52:26.747612',
CURRENT_TIMESTAMP
),
(
9172,
74,
0.05,
'2025-10-27 12:52:26.747615',
CURRENT_TIMESTAMP
),
(
9173,
74,
0.05,
'2025-10-27 12:52:26.747618',
CURRENT_TIMESTAMP
),
(
9174,
74,
0.05,
'2025-10-27 12:52:26.747621',
CURRENT_TIMESTAMP
),
(
9175,
76,
0.05,
'2025-10-27 12:52:26.747624',
CURRENT_TIMESTAMP
),
(
9176,
76,
0.05,
'2025-10-27 12:52:26.747627',
CURRENT_TIMESTAMP
),
(
9177,
76,
0.05,
'2025-10-27 12:52:26.747632',
CURRENT_TIMESTAMP
),
(
9178,
76,
0.05,
'2025-10-27 12:52:26.747636',
CURRENT_TIMESTAMP
),
(
9179,
76,
0.05,
'2025-10-27 12:52:26.747640',
CURRENT_TIMESTAMP
),
(
9180,
76,
0.05,
'2025-10-27 12:52:26.747643',
CURRENT_TIMESTAMP
),
(
9181,
76,
0.053000000000000005,
'2025-10-27 12:52:26.747648',
CURRENT_TIMESTAMP
),
(
9182,
76,
0.05,
'2025-10-27 12:52:26.747651',
CURRENT_TIMESTAMP
),
(
9183,
76,
0.05,
'2025-10-27 12:52:26.747654',
CURRENT_TIMESTAMP
),
(
9184,
76,
0.05,
'2025-10-27 12:52:26.747657',
CURRENT_TIMESTAMP
),
(
9185,
76,
0.05,
'2025-10-27 12:52:26.747660',
CURRENT_TIMESTAMP
),
(
9186,
76,
0.6,
'2025-10-27 12:52:26.747664',
CURRENT_TIMESTAMP
),
(
9187,
76,
0.05,
'2025-10-27 12:52:26.747667',
CURRENT_TIMESTAMP
),
(
9188,
76,
0.05,
'2025-10-27 12:52:26.747670',
CURRENT_TIMESTAMP
),
(
9189,
76,
0.6,
'2025-10-27 12:52:26.747673',
CURRENT_TIMESTAMP
),
(
9190,
76,
0.05,
'2025-10-27 12:52:26.747676',
CURRENT_TIMESTAMP
),
(
9191,
76,
0.053000000000000005,
'2025-10-27 12:52:26.747681',
CURRENT_TIMESTAMP
),
(
9192,
76,
0.6,
'2025-10-27 12:52:26.747684',
CURRENT_TIMESTAMP
),
(
9193,
76,
0.05,
'2025-10-27 12:52:26.747687',
CURRENT_TIMESTAMP
),
(
9194,
76,
0.05,
'2025-10-27 12:52:26.747692',
CURRENT_TIMESTAMP
),
(
9195,
76,
0.05,
'2025-10-27 12:52:26.747695',
CURRENT_TIMESTAMP
),
(
9196,
76,
0.05,
'2025-10-27 12:52:26.747699',
CURRENT_TIMESTAMP
),
(
9197,
76,
0.05,
'2025-10-27 12:52:26.747702',
CURRENT_TIMESTAMP
),
(
9198,
76,
0.05,
'2025-10-27 12:52:26.747705',
CURRENT_TIMESTAMP
),
(
9199,
76,
0.05,
'2025-10-27 12:52:26.747708',
CURRENT_TIMESTAMP
),
(
9200,
76,
0.05,
'2025-10-27 12:52:26.747711',
CURRENT_TIMESTAMP
),
(
9201,
76,
0.05,
'2025-10-27 12:52:26.747714',
CURRENT_TIMESTAMP
),
(
9202,
76,
0.05,
'2025-10-27 12:52:26.747718',
CURRENT_TIMESTAMP
),
(
9203,
76,
0.6,
'2025-10-27 12:52:26.747721',
CURRENT_TIMESTAMP
),
(
9204,
76,
0.05,
'2025-10-27 12:52:26.747725',
CURRENT_TIMESTAMP
),
(
9205,
76,
0.05,
'2025-10-27 12:52:26.747728',
CURRENT_TIMESTAMP
),
(
9206,
76,
0.05,
'2025-10-27 12:52:26.747733',
CURRENT_TIMESTAMP
),
(
9207,
76,
0.05,
'2025-10-27 12:52:26.747736',
CURRENT_TIMESTAMP
),
(
9208,
76,
0.05,
'2025-10-27 12:52:26.747739',
CURRENT_TIMESTAMP
),
(
9209,
76,
0.059000000000000004,
'2025-10-27 12:52:26.747744',
CURRENT_TIMESTAMP
),
(
9210,
76,
0.05,
'2025-10-27 12:52:26.747747',
CURRENT_TIMESTAMP
),
(
9211,
76,
0.05,
'2025-10-27 12:52:26.747751',
CURRENT_TIMESTAMP
),
(
9212,
76,
0.05,
'2025-10-27 12:52:26.747754',
CURRENT_TIMESTAMP
),
(
9213,
76,
0.05,
'2025-10-27 12:52:26.747758',
CURRENT_TIMESTAMP
),
(
9214,
76,
0.05,
'2025-10-27 12:52:26.747765',
CURRENT_TIMESTAMP
),
(
9215,
76,
0.05,
'2025-10-27 12:52:26.747769',
CURRENT_TIMESTAMP
),
(
9216,
76,
0.05,
'2025-10-27 12:52:26.747772',
CURRENT_TIMESTAMP
),
(
9217,
76,
0.05,
'2025-10-27 12:52:26.747776',
CURRENT_TIMESTAMP
),
(
9218,
76,
0.05,
'2025-10-27 12:52:26.747779',
CURRENT_TIMESTAMP
),
(
9219,
76,
0.05,
'2025-10-27 12:52:26.747782',
CURRENT_TIMESTAMP
),
(
9220,
76,
0.05,
'2025-10-27 12:52:26.747785',
CURRENT_TIMESTAMP
),
(
9221,
76,
0.05,
'2025-10-27 12:52:26.747789',
CURRENT_TIMESTAMP
),
(
9222,
76,
0.05,
'2025-10-27 12:52:26.747792',
CURRENT_TIMESTAMP
),
(
9223,
76,
0.05,
'2025-10-27 12:52:26.747795',
CURRENT_TIMESTAMP
),
(
9224,
76,
0.05,
'2025-10-27 12:52:26.747798',
CURRENT_TIMESTAMP
),
(
9225,
76,
0.05,
'2025-10-27 12:52:26.747803',
CURRENT_TIMESTAMP
),
(
9226,
76,
0.6,
'2025-10-27 12:52:26.747807',
CURRENT_TIMESTAMP
),
(
9227,
76,
0.05,
'2025-10-27 12:52:26.747811',
CURRENT_TIMESTAMP
),
(
9228,
76,
0.05,
'2025-10-27 12:52:26.747815',
CURRENT_TIMESTAMP
),
(
9229,
76,
0.05,
'2025-10-27 12:52:26.747819',
CURRENT_TIMESTAMP
),
(
9230,
76,
0.05,
'2025-10-27 12:52:26.747823',
CURRENT_TIMESTAMP
),
(
9231,
76,
0.05,
'2025-10-27 12:52:26.747826',
CURRENT_TIMESTAMP
),
(
9232,
76,
0.05,
'2025-10-27 12:52:26.747829',
CURRENT_TIMESTAMP
),
(
9233,
76,
0.05,
'2025-10-27 12:52:26.747833',
CURRENT_TIMESTAMP
),
(
9234,
76,
0.05,
'2025-10-27 12:52:26.747836',
CURRENT_TIMESTAMP
),
(
9235,
76,
0.05,
'2025-10-27 12:52:26.747840',
CURRENT_TIMESTAMP
),
(
9236,
76,
0.6,
'2025-10-27 12:52:26.747843',
CURRENT_TIMESTAMP
),
(
9237,
76,
0.05,
'2025-10-27 12:52:26.747847',
CURRENT_TIMESTAMP
),
(
9238,
76,
0.05,
'2025-10-27 12:52:26.747850',
CURRENT_TIMESTAMP
),
(
9239,
76,
0.05,
'2025-10-27 12:52:26.747854',
CURRENT_TIMESTAMP
),
(
9240,
76,
0.6,
'2025-10-27 12:52:26.747859',
CURRENT_TIMESTAMP
),
(
9241,
76,
0.05,
'2025-10-27 12:52:26.747863',
CURRENT_TIMESTAMP
),
(
9242,
76,
0.05,
'2025-10-27 12:52:26.747867',
CURRENT_TIMESTAMP
),
(
9243,
76,
0.05,
'2025-10-27 12:52:26.747871',
CURRENT_TIMESTAMP
),
(
9244,
76,
0.05,
'2025-10-27 12:52:26.747874',
CURRENT_TIMESTAMP
),
(
9245,
76,
0.05,
'2025-10-27 12:52:26.747877',
CURRENT_TIMESTAMP
),
(
9246,
76,
0.05,
'2025-10-27 12:52:26.747881',
CURRENT_TIMESTAMP
),
(
9247,
76,
0.05,
'2025-10-27 12:52:26.747885',
CURRENT_TIMESTAMP
),
(
9248,
76,
0.05,
'2025-10-27 12:52:26.747890',
CURRENT_TIMESTAMP
),
(
9249,
76,
0.6,
'2025-10-27 12:52:26.747894',
CURRENT_TIMESTAMP
),
(
9250,
76,
0.05,
'2025-10-27 12:52:26.747897',
CURRENT_TIMESTAMP
),
(
9251,
76,
0.05,
'2025-10-27 12:52:26.747900',
CURRENT_TIMESTAMP
),
(
9252,
76,
0.05,
'2025-10-27 12:52:26.747903',
CURRENT_TIMESTAMP
),
(
9253,
76,
0.05,
'2025-10-27 12:52:26.747907',
CURRENT_TIMESTAMP
),
(
9254,
76,
0.05,
'2025-10-27 12:52:26.747910',
CURRENT_TIMESTAMP
),
(
9255,
76,
0.05,
'2025-10-27 12:52:26.747914',
CURRENT_TIMESTAMP
),
(
9256,
76,
0.05,
'2025-10-27 12:52:26.747918',
CURRENT_TIMESTAMP
),
(
9257,
76,
0.05,
'2025-10-27 12:52:26.747921',
CURRENT_TIMESTAMP
),
(
9258,
76,
0.6,
'2025-10-27 12:52:26.747925',
CURRENT_TIMESTAMP
),
(
9259,
76,
0.05,
'2025-10-27 12:52:26.747928',
CURRENT_TIMESTAMP
),
(
9260,
76,
0.05,
'2025-10-27 12:52:26.747931',
CURRENT_TIMESTAMP
),
(
9261,
76,
0.05,
'2025-10-27 12:52:26.747934',
CURRENT_TIMESTAMP
),
(
9262,
76,
0.05,
'2025-10-27 12:52:26.747937',
CURRENT_TIMESTAMP
),
(
9263,
76,
0.05,
'2025-10-27 12:52:26.747940',
CURRENT_TIMESTAMP
),
(
9264,
76,
0.05,
'2025-10-27 12:52:26.747944',
CURRENT_TIMESTAMP
),
(
9265,
76,
0.05,
'2025-10-27 12:52:26.747948',
CURRENT_TIMESTAMP
),
(
9266,
76,
0.05,
'2025-10-27 12:52:26.747953',
CURRENT_TIMESTAMP
),
(
9267,
76,
0.6,
'2025-10-27 12:52:26.747958',
CURRENT_TIMESTAMP
),
(
9268,
76,
0.05,
'2025-10-27 12:52:26.747961',
CURRENT_TIMESTAMP
),
(
9269,
76,
0.05,
'2025-10-27 12:52:26.747964',
CURRENT_TIMESTAMP
),
(
9270,
76,
0.05,
'2025-10-27 12:52:26.747968',
CURRENT_TIMESTAMP
),
(
9271,
76,
0.05,
'2025-10-27 12:52:26.747971',
CURRENT_TIMESTAMP
),
(
9272,
76,
0.05,
'2025-10-27 12:52:26.747974',
CURRENT_TIMESTAMP
),
(
9273,
76,
0.05,
'2025-10-27 12:52:26.747977',
CURRENT_TIMESTAMP
),
(
9274,
76,
0.05,
'2025-10-27 12:52:26.747982',
CURRENT_TIMESTAMP
),
(
9275,
76,
0.05,
'2025-10-27 12:52:26.747986',
CURRENT_TIMESTAMP
),
(
9276,
76,
0.05,
'2025-10-27 12:52:26.747990',
CURRENT_TIMESTAMP
),
(
9277,
76,
0.05,
'2025-10-27 12:52:26.747994',
CURRENT_TIMESTAMP
),
(
9278,
76,
0.053000000000000005,
'2025-10-27 12:52:26.747999',
CURRENT_TIMESTAMP
),
(
9279,
76,
0.05,
'2025-10-27 12:52:26.748003',
CURRENT_TIMESTAMP
),
(
9280,
76,
0.05,
'2025-10-27 12:52:26.748006',
CURRENT_TIMESTAMP
),
(
9281,
76,
0.05,
'2025-10-27 12:52:26.748010',
CURRENT_TIMESTAMP
),
(
9282,
76,
0.05,
'2025-10-27 12:52:26.748013',
CURRENT_TIMESTAMP
),
(
9283,
76,
0.05,
'2025-10-27 12:52:26.748017',
CURRENT_TIMESTAMP
),
(
9284,
76,
0.05,
'2025-10-27 12:52:26.748020',
CURRENT_TIMESTAMP
),
(
9285,
76,
0.05,
'2025-10-27 12:52:26.748023',
CURRENT_TIMESTAMP
),
(
9286,
76,
0.05,
'2025-10-27 12:52:26.748026',
CURRENT_TIMESTAMP
),
(
9287,
76,
0.05,
'2025-10-27 12:52:26.748029',
CURRENT_TIMESTAMP
),
(
9288,
76,
0.05,
'2025-10-27 12:52:26.748032',
CURRENT_TIMESTAMP
),
(
9289,
76,
0.05,
'2025-10-27 12:52:26.748035',
CURRENT_TIMESTAMP
),
(
9290,
76,
0.05,
'2025-10-27 12:52:26.748039',
CURRENT_TIMESTAMP
),
(
9291,
76,
0.05,
'2025-10-27 12:52:26.748042',
CURRENT_TIMESTAMP
),
(
9292,
76,
0.05,
'2025-10-27 12:52:26.748045',
CURRENT_TIMESTAMP
),
(
9293,
76,
0.6,
'2025-10-27 12:52:26.748048',
CURRENT_TIMESTAMP
),
(
9294,
76,
0.05,
'2025-10-27 12:52:26.748051',
CURRENT_TIMESTAMP
),
(
9295,
76,
0.05,
'2025-10-27 12:52:26.748055',
CURRENT_TIMESTAMP
),
(
9296,
76,
0.05,
'2025-10-27 12:52:26.748058',
CURRENT_TIMESTAMP
),
(
9297,
76,
0.068,
'2025-10-27 12:52:26.748062',
CURRENT_TIMESTAMP
),
(
9298,
76,
0.05,
'2025-10-27 12:52:26.748066',
CURRENT_TIMESTAMP
),
(
9299,
76,
0.05,
'2025-10-27 12:52:26.748069',
CURRENT_TIMESTAMP
),
(
9300,
76,
0.05,
'2025-10-27 12:52:26.748072',
CURRENT_TIMESTAMP
),
(
9301,
76,
0.05,
'2025-10-27 12:52:26.748075',
CURRENT_TIMESTAMP
),
(
9302,
76,
0.05,
'2025-10-27 12:52:26.748078',
CURRENT_TIMESTAMP
),
(
9303,
76,
0.05,
'2025-10-27 12:52:26.748081',
CURRENT_TIMESTAMP
),
(
9304,
76,
0.05,
'2025-10-27 12:52:26.748085',
CURRENT_TIMESTAMP
),
(
9305,
76,
0.05,
'2025-10-27 12:52:26.748088',
CURRENT_TIMESTAMP
),
(
9306,
76,
0.05,
'2025-10-27 12:52:26.748092',
CURRENT_TIMESTAMP
),
(
9307,
76,
0.05,
'2025-10-27 12:52:26.748095',
CURRENT_TIMESTAMP
),
(
9308,
76,
0.05,
'2025-10-27 12:52:26.748099',
CURRENT_TIMESTAMP
),
(
9309,
76,
0.05,
'2025-10-27 12:52:26.748102',
CURRENT_TIMESTAMP
),
(
9310,
76,
0.05,
'2025-10-27 12:52:26.748105',
CURRENT_TIMESTAMP
),
(
9311,
76,
0.05,
'2025-10-27 12:52:26.748108',
CURRENT_TIMESTAMP
),
(
9312,
76,
0.05,
'2025-10-27 12:52:26.748111',
CURRENT_TIMESTAMP
),
(
9313,
76,
0.05,
'2025-10-27 12:52:26.748115',
CURRENT_TIMESTAMP
),
(
9314,
76,
0.07100000000000001,
'2025-10-27 12:52:26.748119',
CURRENT_TIMESTAMP
),
(
9315,
76,
0.05,
'2025-10-27 12:52:26.748123',
CURRENT_TIMESTAMP
),
(
9316,
76,
0.05,
'2025-10-27 12:52:26.748126',
CURRENT_TIMESTAMP
),
(
9317,
76,
0.05,
'2025-10-27 12:52:26.748129',
CURRENT_TIMESTAMP
),
(
9318,
76,
0.463,
'2025-10-27 12:52:26.748134',
CURRENT_TIMESTAMP
),
(
9319,
76,
0.05,
'2025-10-27 12:52:26.748137',
CURRENT_TIMESTAMP
),
(
9320,
76,
0.05,
'2025-10-27 12:52:26.748141',
CURRENT_TIMESTAMP
),
(
9321,
76,
0.05,
'2025-10-27 12:52:26.748144',
CURRENT_TIMESTAMP
),
(
9322,
76,
0.05,
'2025-10-27 12:52:26.748148',
CURRENT_TIMESTAMP
),
(
9323,
76,
0.05,
'2025-10-27 12:52:26.748151',
CURRENT_TIMESTAMP
),
(
9324,
76,
0.05,
'2025-10-27 12:52:26.748155',
CURRENT_TIMESTAMP
),
(
9325,
76,
0.05,
'2025-10-27 12:52:26.748158',
CURRENT_TIMESTAMP
),
(
9326,
76,
0.05,
'2025-10-27 12:52:26.748161',
CURRENT_TIMESTAMP
),
(
9327,
76,
0.05,
'2025-10-27 12:52:26.748164',
CURRENT_TIMESTAMP
),
(
9328,
76,
0.05,
'2025-10-27 12:52:26.748168',
CURRENT_TIMESTAMP
),
(
9329,
76,
0.6,
'2025-10-27 12:52:26.748171',
CURRENT_TIMESTAMP
),
(
9330,
76,
0.05,
'2025-10-27 12:52:26.748174',
CURRENT_TIMESTAMP
),
(
9331,
76,
0.05,
'2025-10-27 12:52:26.748177',
CURRENT_TIMESTAMP
),
(
9332,
76,
0.05,
'2025-10-27 12:52:26.748180',
CURRENT_TIMESTAMP
),
(
9333,
76,
0.05,
'2025-10-27 12:52:26.748183',
CURRENT_TIMESTAMP
),
(
9334,
76,
0.059000000000000004,
'2025-10-27 12:52:26.748188',
CURRENT_TIMESTAMP
),
(
9335,
76,
0.05,
'2025-10-27 12:52:26.748191',
CURRENT_TIMESTAMP
),
(
9336,
76,
0.05,
'2025-10-27 12:52:26.748194',
CURRENT_TIMESTAMP
),
(
9337,
76,
0.6,
'2025-10-27 12:52:26.748198',
CURRENT_TIMESTAMP
),
(
9338,
76,
0.05,
'2025-10-27 12:52:26.748201',
CURRENT_TIMESTAMP
),
(
9339,
76,
0.05,
'2025-10-27 12:52:26.748204',
CURRENT_TIMESTAMP
),
(
9340,
76,
0.05,
'2025-10-27 12:52:26.748207',
CURRENT_TIMESTAMP
),
(
9341,
76,
0.05,
'2025-10-27 12:52:26.748212',
CURRENT_TIMESTAMP
),
(
9342,
76,
0.05,
'2025-10-27 12:52:26.748215',
CURRENT_TIMESTAMP
),
(
9343,
76,
0.05,
'2025-10-27 12:52:26.748218',
CURRENT_TIMESTAMP
),
(
9344,
76,
0.05,
'2025-10-27 12:52:26.748222',
CURRENT_TIMESTAMP
),
(
9345,
76,
0.05,
'2025-10-27 12:52:26.748225',
CURRENT_TIMESTAMP
),
(
9346,
76,
0.05,
'2025-10-27 12:52:26.748229',
CURRENT_TIMESTAMP
),
(
9347,
76,
0.05,
'2025-10-27 12:52:26.748233',
CURRENT_TIMESTAMP
),
(
9348,
76,
0.05,
'2025-10-27 12:52:26.748236',
CURRENT_TIMESTAMP
),
(
9349,
76,
0.05,
'2025-10-27 12:52:26.748239',
CURRENT_TIMESTAMP
),
(
9350,
76,
0.05,
'2025-10-27 12:52:26.748242',
CURRENT_TIMESTAMP
),
(
9351,
76,
0.05,
'2025-10-27 12:52:26.748246',
CURRENT_TIMESTAMP
),
(
9352,
76,
0.05,
'2025-10-27 12:52:26.748249',
CURRENT_TIMESTAMP
),
(
9353,
76,
0.05,
'2025-10-27 12:52:26.748252',
CURRENT_TIMESTAMP
),
(
9354,
76,
0.05,
'2025-10-27 12:52:26.748256',
CURRENT_TIMESTAMP
),
(
9355,
76,
0.05,
'2025-10-27 12:52:26.748259',
CURRENT_TIMESTAMP
),
(
9356,
76,
0.05,
'2025-10-27 12:52:26.748262',
CURRENT_TIMESTAMP
),
(
9357,
76,
0.05,
'2025-10-27 12:52:26.748265',
CURRENT_TIMESTAMP
),
(
9358,
76,
0.222,
'2025-10-27 12:52:26.748270',
CURRENT_TIMESTAMP
),
(
9359,
76,
0.05,
'2025-10-27 12:52:26.748274',
CURRENT_TIMESTAMP
),
(
9360,
76,
0.05,
'2025-10-27 12:52:26.748277',
CURRENT_TIMESTAMP
),
(
9361,
76,
0.05,
'2025-10-27 12:52:26.748280',
CURRENT_TIMESTAMP
),
(
9362,
76,
0.05,
'2025-10-27 12:52:26.748284',
CURRENT_TIMESTAMP
),
(
9363,
76,
0.05,
'2025-10-27 12:52:26.748287',
CURRENT_TIMESTAMP
),
(
9364,
76,
0.05,
'2025-10-27 12:52:26.748290',
CURRENT_TIMESTAMP
),
(
9365,
76,
0.05,
'2025-10-27 12:52:26.748293',
CURRENT_TIMESTAMP
),
(
9366,
76,
0.6,
'2025-10-27 12:52:26.748296',
CURRENT_TIMESTAMP
),
(
9367,
76,
0.05,
'2025-10-27 12:52:26.748299',
CURRENT_TIMESTAMP
),
(
9368,
76,
0.05,
'2025-10-27 12:52:26.748302',
CURRENT_TIMESTAMP
),
(
9369,
76,
0.05,
'2025-10-27 12:52:26.748306',
CURRENT_TIMESTAMP
),
(
9370,
76,
0.05,
'2025-10-27 12:52:26.748310',
CURRENT_TIMESTAMP
),
(
9371,
76,
0.05,
'2025-10-27 12:52:26.748313',
CURRENT_TIMESTAMP
),
(
9372,
76,
0.05,
'2025-10-27 12:52:26.748316',
CURRENT_TIMESTAMP
),
(
9373,
76,
0.6,
'2025-10-27 12:52:26.748319',
CURRENT_TIMESTAMP
),
(
9374,
76,
0.05,
'2025-10-27 12:52:26.748323',
CURRENT_TIMESTAMP
),
(
9375,
76,
0.05,
'2025-10-27 12:52:26.748326',
CURRENT_TIMESTAMP
),
(
9376,
76,
0.05,
'2025-10-27 12:52:26.748330',
CURRENT_TIMESTAMP
),
(
9377,
76,
0.6,
'2025-10-27 12:52:26.748333',
CURRENT_TIMESTAMP
),
(
9378,
76,
0.6,
'2025-10-27 12:52:26.748336',
CURRENT_TIMESTAMP
),
(
9379,
76,
0.05,
'2025-10-27 12:52:26.748339',
CURRENT_TIMESTAMP
),
(
9380,
76,
0.05,
'2025-10-27 12:52:26.748342',
CURRENT_TIMESTAMP
),
(
9381,
76,
0.05,
'2025-10-27 12:52:26.748345',
CURRENT_TIMESTAMP
),
(
9382,
76,
0.05,
'2025-10-27 12:52:26.748349',
CURRENT_TIMESTAMP
),
(
9383,
76,
0.05,
'2025-10-27 12:52:26.748352',
CURRENT_TIMESTAMP
),
(
9384,
76,
0.05,
'2025-10-27 12:52:26.748355',
CURRENT_TIMESTAMP
),
(
9385,
76,
0.05,
'2025-10-27 12:52:26.748358',
CURRENT_TIMESTAMP
),
(
9386,
76,
0.05,
'2025-10-27 12:52:26.748361',
CURRENT_TIMESTAMP
),
(
9387,
76,
0.05,
'2025-10-27 12:52:26.748365',
CURRENT_TIMESTAMP
),
(
9388,
76,
0.05,
'2025-10-27 12:52:26.748368',
CURRENT_TIMESTAMP
),
(
9389,
76,
0.05,
'2025-10-27 12:52:26.748371',
CURRENT_TIMESTAMP
),
(
9390,
76,
0.05,
'2025-10-27 12:52:26.748374',
CURRENT_TIMESTAMP
),
(
9391,
76,
0.05,
'2025-10-27 12:52:26.748377',
CURRENT_TIMESTAMP
),
(
9392,
76,
0.05,
'2025-10-27 12:52:26.748380',
CURRENT_TIMESTAMP
),
(
9393,
76,
0.05,
'2025-10-27 12:52:26.748385',
CURRENT_TIMESTAMP
),
(
9394,
76,
0.05,
'2025-10-27 12:52:26.748388',
CURRENT_TIMESTAMP
),
(
9395,
76,
0.05,
'2025-10-27 12:52:26.748391',
CURRENT_TIMESTAMP
),
(
9396,
76,
0.05,
'2025-10-27 12:52:26.748394',
CURRENT_TIMESTAMP
),
(
9397,
76,
0.05,
'2025-10-27 12:52:26.748398',
CURRENT_TIMESTAMP
),
(
9398,
76,
0.05,
'2025-10-27 12:52:26.748401',
CURRENT_TIMESTAMP
),
(
9399,
76,
0.05,
'2025-10-27 12:52:26.748404',
CURRENT_TIMESTAMP
),
(
9400,
76,
0.05,
'2025-10-27 12:52:26.748407',
CURRENT_TIMESTAMP
),
(
9401,
76,
0.05,
'2025-10-27 12:52:26.748410',
CURRENT_TIMESTAMP
),
(
9402,
76,
0.05,
'2025-10-27 12:52:26.748413',
CURRENT_TIMESTAMP
),
(
9403,
76,
0.05,
'2025-10-27 12:52:26.748417',
CURRENT_TIMESTAMP
),
(
9404,
76,
0.05,
'2025-10-27 12:52:26.748420',
CURRENT_TIMESTAMP
),
(
9405,
76,
0.05,
'2025-10-27 12:52:26.748423',
CURRENT_TIMESTAMP
),
(
9406,
76,
0.05,
'2025-10-27 12:52:26.748427',
CURRENT_TIMESTAMP
),
(
9407,
76,
0.05,
'2025-10-27 12:52:26.748430',
CURRENT_TIMESTAMP
),
(
9408,
76,
0.05,
'2025-10-27 12:52:26.748433',
CURRENT_TIMESTAMP
),
(
9409,
76,
0.05,
'2025-10-27 12:52:26.748436',
CURRENT_TIMESTAMP
),
(
9410,
76,
0.05,
'2025-10-27 12:52:26.748439',
CURRENT_TIMESTAMP
),
(
9411,
76,
0.05,
'2025-10-27 12:52:26.748442',
CURRENT_TIMESTAMP
),
(
9412,
76,
0.6,
'2025-10-27 12:52:26.748445',
CURRENT_TIMESTAMP
),
(
9413,
76,
0.05,
'2025-10-27 12:52:26.748449',
CURRENT_TIMESTAMP
),
(
9414,
76,
0.05,
'2025-10-27 12:52:26.748452',
CURRENT_TIMESTAMP
),
(
9415,
76,
0.05,
'2025-10-27 12:52:26.748455',
CURRENT_TIMESTAMP
),
(
9416,
76,
0.05,
'2025-10-27 12:52:26.748458',
CURRENT_TIMESTAMP
),
(
9417,
76,
0.05,
'2025-10-27 12:52:26.748461',
CURRENT_TIMESTAMP
),
(
9418,
76,
0.05,
'2025-10-27 12:52:26.748466',
CURRENT_TIMESTAMP
),
(
9419,
76,
0.05,
'2025-10-27 12:52:26.748469',
CURRENT_TIMESTAMP
),
(
9420,
76,
0.05,
'2025-10-27 12:52:26.748472',
CURRENT_TIMESTAMP
),
(
9421,
76,
0.05,
'2025-10-27 12:52:26.748615',
CURRENT_TIMESTAMP
),
(
9422,
76,
0.05,
'2025-10-27 12:52:26.748620',
CURRENT_TIMESTAMP
),
(
9423,
76,
0.05,
'2025-10-27 12:52:26.748623',
CURRENT_TIMESTAMP
),
(
9424,
76,
0.05,
'2025-10-27 12:52:26.748628',
CURRENT_TIMESTAMP
),
(
9425,
76,
0.05,
'2025-10-27 12:52:26.748632',
CURRENT_TIMESTAMP
),
(
9426,
76,
0.05,
'2025-10-27 12:52:26.748635',
CURRENT_TIMESTAMP
),
(
9427,
76,
0.05,
'2025-10-27 12:52:26.748638',
CURRENT_TIMESTAMP
),
(
9428,
76,
0.183,
'2025-10-27 12:52:26.748646',
CURRENT_TIMESTAMP
),
(
9429,
76,
0.05,
'2025-10-27 12:52:26.748649',
CURRENT_TIMESTAMP
),
(
9430,
76,
0.05,
'2025-10-27 12:52:26.748652',
CURRENT_TIMESTAMP
),
(
9431,
76,
0.05,
'2025-10-27 12:52:26.748655',
CURRENT_TIMESTAMP
),
(
9432,
76,
0.05,
'2025-10-27 12:52:26.748658',
CURRENT_TIMESTAMP
),
(
9433,
76,
0.05,
'2025-10-27 12:52:26.748661',
CURRENT_TIMESTAMP
),
(
9434,
76,
0.05,
'2025-10-27 12:52:26.748664',
CURRENT_TIMESTAMP
),
(
9435,
76,
0.05,
'2025-10-27 12:52:26.748667',
CURRENT_TIMESTAMP
),
(
9436,
76,
0.05,
'2025-10-27 12:52:26.748672',
CURRENT_TIMESTAMP
),
(
9437,
76,
0.05,
'2025-10-27 12:52:26.748675',
CURRENT_TIMESTAMP
),
(
9438,
76,
0.05,
'2025-10-27 12:52:26.748679',
CURRENT_TIMESTAMP
),
(
9439,
76,
0.05,
'2025-10-27 12:52:26.748683',
CURRENT_TIMESTAMP
),
(
9440,
76,
0.05,
'2025-10-27 12:52:26.748687',
CURRENT_TIMESTAMP
),
(
9441,
76,
0.053000000000000005,
'2025-10-27 12:52:26.748691',
CURRENT_TIMESTAMP
),
(
9442,
76,
0.05,
'2025-10-27 12:52:26.748695',
CURRENT_TIMESTAMP
),
(
9443,
76,
0.05,
'2025-10-27 12:52:26.748698',
CURRENT_TIMESTAMP
),
(
9444,
76,
0.05,
'2025-10-27 12:52:26.748701',
CURRENT_TIMESTAMP
),
(
9445,
76,
0.05,
'2025-10-27 12:52:26.748705',
CURRENT_TIMESTAMP
),
(
9446,
76,
0.05,
'2025-10-27 12:52:26.748709',
CURRENT_TIMESTAMP
),
(
9447,
76,
0.05,
'2025-10-27 12:52:26.748713',
CURRENT_TIMESTAMP
),
(
9448,
76,
0.05,
'2025-10-27 12:52:26.748716',
CURRENT_TIMESTAMP
),
(
9449,
76,
0.05,
'2025-10-27 12:52:26.748719',
CURRENT_TIMESTAMP
),
(
9450,
76,
0.05,
'2025-10-27 12:52:26.748723',
CURRENT_TIMESTAMP
),
(
9451,
76,
0.05,
'2025-10-27 12:52:26.748727',
CURRENT_TIMESTAMP
),
(
9452,
76,
0.05,
'2025-10-27 12:52:26.748730',
CURRENT_TIMESTAMP
),
(
9453,
76,
0.05,
'2025-10-27 12:52:26.748733',
CURRENT_TIMESTAMP
),
(
9454,
76,
0.6,
'2025-10-27 12:52:26.748736',
CURRENT_TIMESTAMP
),
(
9455,
76,
0.05,
'2025-10-27 12:52:26.748739',
CURRENT_TIMESTAMP
),
(
9456,
76,
0.05,
'2025-10-27 12:52:26.748744',
CURRENT_TIMESTAMP
),
(
9457,
76,
0.05,
'2025-10-27 12:52:26.748747',
CURRENT_TIMESTAMP
),
(
9458,
76,
0.05,
'2025-10-27 12:52:26.748750',
CURRENT_TIMESTAMP
),
(
9459,
76,
0.05,
'2025-10-27 12:52:26.748754',
CURRENT_TIMESTAMP
),
(
9460,
76,
0.6,
'2025-10-27 12:52:26.748757',
CURRENT_TIMESTAMP
),
(
9461,
76,
0.05,
'2025-10-27 12:52:26.748760',
CURRENT_TIMESTAMP
),
(
9462,
76,
0.05,
'2025-10-27 12:52:26.748762',
CURRENT_TIMESTAMP
),
(
9463,
76,
0.05,
'2025-10-27 12:52:26.748766',
CURRENT_TIMESTAMP
),
(
9464,
76,
0.05,
'2025-10-27 12:52:26.748769',
CURRENT_TIMESTAMP
),
(
9465,
76,
0.05,
'2025-10-27 12:52:26.748772',
CURRENT_TIMESTAMP
),
(
9466,
76,
0.05,
'2025-10-27 12:52:26.748775',
CURRENT_TIMESTAMP
),
(
9467,
76,
0.05,
'2025-10-27 12:52:26.748778',
CURRENT_TIMESTAMP
),
(
9468,
76,
0.05,
'2025-10-27 12:52:26.748781',
CURRENT_TIMESTAMP
),
(
9469,
76,
0.05,
'2025-10-27 12:52:26.748784',
CURRENT_TIMESTAMP
),
(
9470,
76,
0.05,
'2025-10-27 12:52:26.748787',
CURRENT_TIMESTAMP
),
(
9471,
76,
0.05,
'2025-10-27 12:52:26.748791',
CURRENT_TIMESTAMP
),
(
9472,
76,
0.05,
'2025-10-27 12:52:26.748795',
CURRENT_TIMESTAMP
),
(
9473,
76,
0.05,
'2025-10-27 12:52:26.748798',
CURRENT_TIMESTAMP
),
(
9474,
76,
0.05,
'2025-10-27 12:52:26.748803',
CURRENT_TIMESTAMP
),
(
9475,
76,
0.6,
'2025-10-27 12:52:26.748806',
CURRENT_TIMESTAMP
),
(
9476,
76,
0.05,
'2025-10-27 12:52:26.748809',
CURRENT_TIMESTAMP
),
(
9477,
76,
0.05,
'2025-10-27 12:52:26.748812',
CURRENT_TIMESTAMP
),
(
9478,
76,
0.05,
'2025-10-27 12:52:26.748815',
CURRENT_TIMESTAMP
),
(
9479,
76,
0.05,
'2025-10-27 12:52:26.748819',
CURRENT_TIMESTAMP
),
(
9480,
76,
0.05,
'2025-10-27 12:52:26.748822',
CURRENT_TIMESTAMP
),
(
9481,
76,
0.05,
'2025-10-27 12:52:26.748825',
CURRENT_TIMESTAMP
),
(
9482,
76,
0.05,
'2025-10-27 12:52:26.748828',
CURRENT_TIMESTAMP
),
(
9483,
76,
0.05,
'2025-10-27 12:52:26.748831',
CURRENT_TIMESTAMP
),
(
9484,
76,
0.05,
'2025-10-27 12:52:26.748835',
CURRENT_TIMESTAMP
),
(
9485,
76,
0.05,
'2025-10-27 12:52:26.748840',
CURRENT_TIMESTAMP
),
(
9486,
76,
0.05,
'2025-10-27 12:52:26.748843',
CURRENT_TIMESTAMP
),
(
9487,
76,
0.05,
'2025-10-27 12:52:26.748847',
CURRENT_TIMESTAMP
),
(
9488,
76,
0.053000000000000005,
'2025-10-27 12:52:26.748852',
CURRENT_TIMESTAMP
),
(
9489,
76,
0.05,
'2025-10-27 12:52:26.748855',
CURRENT_TIMESTAMP
),
(
9490,
76,
0.05,
'2025-10-27 12:52:26.748858',
CURRENT_TIMESTAMP
),
(
9491,
76,
0.05,
'2025-10-27 12:52:26.748861',
CURRENT_TIMESTAMP
),
(
9492,
76,
0.05,
'2025-10-27 12:52:26.748865',
CURRENT_TIMESTAMP
),
(
9493,
76,
0.05,
'2025-10-27 12:52:26.748868',
CURRENT_TIMESTAMP
),
(
9494,
76,
0.05,
'2025-10-27 12:52:26.748871',
CURRENT_TIMESTAMP
),
(
9495,
76,
0.05,
'2025-10-27 12:52:26.748874',
CURRENT_TIMESTAMP
),
(
9496,
76,
0.05,
'2025-10-27 12:52:26.748877',
CURRENT_TIMESTAMP
),
(
9497,
76,
0.05,
'2025-10-27 12:52:26.748880',
CURRENT_TIMESTAMP
),
(
9498,
76,
0.05,
'2025-10-27 12:52:26.748883',
CURRENT_TIMESTAMP
),
(
9499,
76,
0.05,
'2025-10-27 12:52:26.748886',
CURRENT_TIMESTAMP
),
(
9500,
76,
0.05,
'2025-10-27 12:52:26.748889',
CURRENT_TIMESTAMP
),
(
9501,
76,
0.05,
'2025-10-27 12:52:26.748892',
CURRENT_TIMESTAMP
),
(
9502,
76,
0.05,
'2025-10-27 12:52:26.748895',
CURRENT_TIMESTAMP
),
(
9503,
76,
0.05,
'2025-10-27 12:52:26.748899',
CURRENT_TIMESTAMP
),
(
9504,
76,
0.05,
'2025-10-27 12:52:26.748902',
CURRENT_TIMESTAMP
),
(
9505,
76,
0.05,
'2025-10-27 12:52:26.748905',
CURRENT_TIMESTAMP
),
(
9506,
76,
0.05,
'2025-10-27 12:52:26.748908',
CURRENT_TIMESTAMP
),
(
9507,
76,
0.05,
'2025-10-27 12:52:26.748911',
CURRENT_TIMESTAMP
),
(
9508,
76,
0.6,
'2025-10-27 12:52:26.748914',
CURRENT_TIMESTAMP
),
(
9509,
76,
0.05,
'2025-10-27 12:52:26.748917',
CURRENT_TIMESTAMP
),
(
9510,
76,
0.05,
'2025-10-27 12:52:26.748922',
CURRENT_TIMESTAMP
),
(
9511,
76,
0.05,
'2025-10-27 12:52:26.748927',
CURRENT_TIMESTAMP
),
(
9512,
76,
0.05,
'2025-10-27 12:52:26.748930',
CURRENT_TIMESTAMP
),
(
9513,
76,
0.05,
'2025-10-27 12:52:26.748933',
CURRENT_TIMESTAMP
),
(
9514,
76,
0.05,
'2025-10-27 12:52:26.748936',
CURRENT_TIMESTAMP
),
(
9515,
76,
0.05,
'2025-10-27 12:52:26.748940',
CURRENT_TIMESTAMP
),
(
9516,
76,
0.05,
'2025-10-27 12:52:26.748943',
CURRENT_TIMESTAMP
),
(
9517,
76,
0.05,
'2025-10-27 12:52:26.748946',
CURRENT_TIMESTAMP
),
(
9518,
76,
0.05,
'2025-10-27 12:52:26.748949',
CURRENT_TIMESTAMP
),
(
9519,
76,
0.05,
'2025-10-27 12:52:26.748952',
CURRENT_TIMESTAMP
),
(
9520,
76,
0.05,
'2025-10-27 12:52:26.748955',
CURRENT_TIMESTAMP
),
(
9521,
76,
0.05,
'2025-10-27 12:52:26.748958',
CURRENT_TIMESTAMP
),
(
9522,
76,
0.05,
'2025-10-27 12:52:26.748963',
CURRENT_TIMESTAMP
),
(
9523,
76,
0.05,
'2025-10-27 12:52:26.748966',
CURRENT_TIMESTAMP
),
(
9524,
76,
0.05,
'2025-10-27 12:52:26.748969',
CURRENT_TIMESTAMP
),
(
9525,
76,
0.05,
'2025-10-27 12:52:26.748972',
CURRENT_TIMESTAMP
),
(
9526,
76,
0.05,
'2025-10-27 12:52:26.748975',
CURRENT_TIMESTAMP
),
(
9527,
76,
0.05,
'2025-10-27 12:52:26.748980',
CURRENT_TIMESTAMP
),
(
9528,
76,
0.05,
'2025-10-27 12:52:26.748983',
CURRENT_TIMESTAMP
),
(
9529,
76,
0.6,
'2025-10-27 12:52:26.748986',
CURRENT_TIMESTAMP
),
(
9530,
76,
0.05,
'2025-10-27 12:52:26.748990',
CURRENT_TIMESTAMP
),
(
9531,
76,
0.6,
'2025-10-27 12:52:26.748993',
CURRENT_TIMESTAMP
),
(
9532,
76,
0.059000000000000004,
'2025-10-27 12:52:26.748998',
CURRENT_TIMESTAMP
),
(
9533,
76,
0.05,
'2025-10-27 12:52:26.749001',
CURRENT_TIMESTAMP
),
(
9534,
76,
0.05,
'2025-10-27 12:52:26.749004',
CURRENT_TIMESTAMP
),
(
9535,
76,
0.05,
'2025-10-27 12:52:26.749007',
CURRENT_TIMESTAMP
),
(
9536,
76,
0.05,
'2025-10-27 12:52:26.749010',
CURRENT_TIMESTAMP
),
(
9537,
76,
0.05,
'2025-10-27 12:52:26.749014',
CURRENT_TIMESTAMP
),
(
9538,
76,
0.05,
'2025-10-27 12:52:26.749017',
CURRENT_TIMESTAMP
),
(
9539,
76,
0.05,
'2025-10-27 12:52:26.749020',
CURRENT_TIMESTAMP
),
(
9540,
76,
0.05,
'2025-10-27 12:52:26.749024',
CURRENT_TIMESTAMP
),
(
9541,
76,
0.05,
'2025-10-27 12:52:26.749027',
CURRENT_TIMESTAMP
),
(
9542,
76,
0.05,
'2025-10-27 12:52:26.749030',
CURRENT_TIMESTAMP
),
(
9543,
76,
0.05,
'2025-10-27 12:52:26.749033',
CURRENT_TIMESTAMP
),
(
9544,
76,
0.05,
'2025-10-27 12:52:26.749036',
CURRENT_TIMESTAMP
),
(
9545,
76,
0.05,
'2025-10-27 12:52:26.749039',
CURRENT_TIMESTAMP
),
(
9546,
76,
0.05,
'2025-10-27 12:52:26.749042',
CURRENT_TIMESTAMP
),
(
9547,
76,
0.05,
'2025-10-27 12:52:26.749045',
CURRENT_TIMESTAMP
),
(
9548,
76,
0.056,
'2025-10-27 12:52:26.749050',
CURRENT_TIMESTAMP
),
(
9549,
76,
0.05,
'2025-10-27 12:52:26.749054',
CURRENT_TIMESTAMP
),
(
9550,
76,
0.05,
'2025-10-27 12:52:26.749057',
CURRENT_TIMESTAMP
),
(
9551,
76,
0.05,
'2025-10-27 12:52:26.749061',
CURRENT_TIMESTAMP
),
(
9552,
76,
0.05,
'2025-10-27 12:52:26.749065',
CURRENT_TIMESTAMP
),
(
9553,
76,
0.05,
'2025-10-27 12:52:26.749068',
CURRENT_TIMESTAMP
),
(
9554,
76,
0.05,
'2025-10-27 12:52:26.749071',
CURRENT_TIMESTAMP
),
(
9555,
76,
0.05,
'2025-10-27 12:52:26.749074',
CURRENT_TIMESTAMP
),
(
9556,
76,
0.05,
'2025-10-27 12:52:26.749078',
CURRENT_TIMESTAMP
),
(
9557,
76,
0.05,
'2025-10-27 12:52:26.749081',
CURRENT_TIMESTAMP
),
(
9558,
76,
0.05,
'2025-10-27 12:52:26.749084',
CURRENT_TIMESTAMP
),
(
9559,
76,
0.05,
'2025-10-27 12:52:26.749087',
CURRENT_TIMESTAMP
),
(
9560,
76,
0.05,
'2025-10-27 12:52:26.749090',
CURRENT_TIMESTAMP
),
(
9561,
76,
0.05,
'2025-10-27 12:52:26.749094',
CURRENT_TIMESTAMP
),
(
9562,
76,
0.05,
'2025-10-27 12:52:26.749098',
CURRENT_TIMESTAMP
),
(
9563,
76,
0.05,
'2025-10-27 12:52:26.749101',
CURRENT_TIMESTAMP
),
(
9564,
76,
0.05,
'2025-10-27 12:52:26.749104',
CURRENT_TIMESTAMP
),
(
9565,
76,
0.05,
'2025-10-27 12:52:26.749109',
CURRENT_TIMESTAMP
),
(
9566,
76,
0.05,
'2025-10-27 12:52:26.749112',
CURRENT_TIMESTAMP
),
(
9567,
76,
0.6,
'2025-10-27 12:52:26.749116',
CURRENT_TIMESTAMP
),
(
9568,
76,
0.05,
'2025-10-27 12:52:26.749119',
CURRENT_TIMESTAMP
),
(
9569,
76,
0.05,
'2025-10-27 12:52:26.749122',
CURRENT_TIMESTAMP
),
(
9570,
76,
0.05,
'2025-10-27 12:52:26.749125',
CURRENT_TIMESTAMP
),
(
9571,
76,
0.05,
'2025-10-27 12:52:26.749128',
CURRENT_TIMESTAMP
),
(
9572,
76,
0.05,
'2025-10-27 12:52:26.749132',
CURRENT_TIMESTAMP
),
(
9573,
76,
0.05,
'2025-10-27 12:52:26.749135',
CURRENT_TIMESTAMP
),
(
9574,
76,
0.05,
'2025-10-27 12:52:26.749138',
CURRENT_TIMESTAMP
),
(
9575,
76,
0.05,
'2025-10-27 12:52:26.749142',
CURRENT_TIMESTAMP
),
(
9576,
76,
0.05,
'2025-10-27 12:52:26.749147',
CURRENT_TIMESTAMP
),
(
9577,
76,
0.05,
'2025-10-27 12:52:26.749150',
CURRENT_TIMESTAMP
),
(
9578,
76,
0.05,
'2025-10-27 12:52:26.749153',
CURRENT_TIMESTAMP
),
(
9579,
76,
0.05,
'2025-10-27 12:52:26.749157',
CURRENT_TIMESTAMP
),
(
9580,
76,
0.05,
'2025-10-27 12:52:26.749160',
CURRENT_TIMESTAMP
),
(
9581,
76,
0.05,
'2025-10-27 12:52:26.749163',
CURRENT_TIMESTAMP
),
(
9582,
76,
0.05,
'2025-10-27 12:52:26.749167',
CURRENT_TIMESTAMP
),
(
9583,
76,
0.6,
'2025-10-27 12:52:26.749170',
CURRENT_TIMESTAMP
),
(
9584,
76,
0.05,
'2025-10-27 12:52:26.749173',
CURRENT_TIMESTAMP
) ON CONFLICT ("finding_id")
DO
UPDATE
SET
"project_id" = excluded."project_id",
"risk_score" = excluded."risk_score",
"updated_at" = excluded."updated_at"
RETURNING
"finding_id"How to set up and validate locally
- Run the script in rails console
job = Gitlab::BackgroundMigration::BackfillVulnerabilityFindingRiskScores.new(
start_id: Vulnerabilities::Finding.minimum(:id),
end_id: Vulnerabilities::Finding.maximum(:id),
batch_table: :vulnerability_occurrences,
batch_column: :id,
sub_batch_size: 500,
pause_ms: 0,
connection: Vulnerabilities::Finding.connection
)
job.perform- Then verify that the migrated records are having correct values using the verification script.
Script
# Rails console snippet to verify migration results (run AFTER migration)
# Simple version - just shows mismatches
# 1. Define manual calculation function (mirrors migration logic)
def manually_calculate_risk_score(finding)
severity = finding.severity
# Get CVE enrichment data
cve_identifiers = finding.identifiers.where('LOWER(external_type) = ?', 'cve')
cve_enrichment = nil
cve_identifiers.each do |identifier|
enrichment = PackageMetadata::CveEnrichment.find_by(cve: identifier.name)
if enrichment
cve_enrichment = enrichment
break
end
end
epss_score = cve_enrichment&.epss_score || 0
is_known_exploit = !!cve_enrichment&.is_known_exploit
# Calculate base score
base_score = case severity
when 'critical' then 0.6
when 'high' then 0.4
when 'medium', 'unknown' then 0.2
when 'low' then 0.05
else 0
end
# Calculate EPSS modifiers
epss_base_modifier = epss_score * 0.3
epss_bonus = if epss_score >= 0.5
0.2
elsif epss_score >= 0.1
0.1
else
0
end
# KEV modifier
kev_modifier = is_known_exploit ? 0.3 : 0
# Total score (capped at 1.0)
total_score = base_score + epss_base_modifier + epss_bonus + kev_modifier
{
severity: severity,
base_score: base_score,
epss_score: epss_score,
epss_base_modifier: epss_base_modifier,
epss_bonus: epss_bonus,
is_known_exploit: is_known_exploit,
kev_modifier: kev_modifier,
total_before_cap: total_score,
final_score: [1.0, total_score].min,
cve_name: cve_enrichment&.cve
}
end
# 2. Process all findings
puts "Verifying all findings..."
mismatched_ids = []
matches = 0
processed = 0
Vulnerabilities::Finding.includes(:identifiers).find_in_batches(batch_size: 500) do |batch|
batch.each do |finding|
processed += 1
expected_score = manually_calculate_risk_score(finding)[:final_score]
actual_record = Vulnerabilities::FindingRiskScore.find_by(finding_id: finding.id)
next unless actual_record
if actual_record.risk_score == expected_score
matches += 1
else
mismatched_ids << finding.id
end
end
print "." if processed % 500 == 0
end
# 3. Results
puts "\n\nProcessed: #{processed}"
puts "Matches: #{matches}"
puts "Mismatches: #{mismatched_ids.count}"
if mismatched_ids.any?
puts "\nMismatched Finding IDs:"
puts mismatched_ids.join(", ")
else
puts "\n✅ No mismatches found!"
endMR acceptance checklist
Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Related to #569091
Edited by Bala Kumar