Set pipeline expiry time
What does this MR do and why?
Set pipeline expiry time
Extracted from !171142 (diffs), it allows project owners to set a value after which the pipelines get deleted.
References
Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Screenshots or screen recordings
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
See !171142 (merged)
Related to #498969 (closed)
Merge request reports
Activity
changed milestone to %17.7
assigned to @mbobin
added pipelinetier-1 label
Database migrations (on the main database)
Migrations included in this change have been executed on gitlab.com data for testing purposes. For details, please see the migration testing pipeline (limited access).
Migration Type Total runtime Result DB size change 20241115121334 - AddDeletePipelinesInSecondsToProjectCiCdSettings Regular 4.4 s +0.00 B 20241115121337 - AddIndexOnProjectSettingsForOldPipelines Post deploy 45.3 s +8.00 KiB [note] Runtime Histogram for all migrations
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 4 0.1 seconds - 1 second 1 1 second - 5 seconds 0 5 seconds - 15 seconds 0 15 seconds - 5 minutes 1 5 minutes + 0 Migration: 20241115121334 - AddDeletePipelinesInSecondsToProjectCiCdSettings
* Duration: 4.4 s
* Database size change: +0.00 BCalls Total Time Max Time Mean Time Rows Query 1 2.4 ms 2.4 ms 2.4 ms 0 ALTER TABLE "project_ci_cd_settings" ADD "delete_pipelines_in_seconds" integer
2 0.0 ms 0.0 ms 0.0 ms 2 SELECT pg_backend_pid()
Histogram for AddDeletePipelinesInSecondsToProjectCiCdSettings
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 2 0.1 seconds - 1 second 1 1 second - 5 seconds 0 5 seconds - 15 seconds 0 15 seconds - 5 minutes 0 5 minutes + 0 Migration: 20241115121337 - AddIndexOnProjectSettingsForOldPipelines
* Duration: 45.3 s
* Database size change: +8.00 KiB [note]Calls Total Time Max Time Mean Time Rows Query 1 40374.8 ms 40374.8 ms 40374.8 ms 0 CREATE INDEX CONCURRENTLY "index_project_ci_cd_settings_on_id_partial" ON "project_ci_cd_settings" ("id")
WHERE delete_pipelines_in_seconds IS NOT NULL2 0.0 ms 0.0 ms 0.0 ms 2 SELECT pg_backend_pid()
Histogram for AddIndexOnProjectSettingsForOldPipelines
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 2 0.1 seconds - 1 second 0 1 second - 5 seconds 0 5 seconds - 15 seconds 0 15 seconds - 5 minutes 1 5 minutes + 0 Background Migration: BackfillSoftwareLicenseSpdxIdentifierForSoftwareLicensePolicies
Sampled 10 batches. Estimated Time to complete: 16 hours and 14 minutes
- Interval: 120s
- Max batch size: 0
- Estimated seconds to complete: 58440s
- Average batch time: 5.04s
- Batch size: 1000
- N. of batches sampled: 10
- 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 Query 81 177.6 ms 18.0 ms 2.2 ms 8100 UPDATE software_license_policies
SET software_license_spdx_identifier = software_licenses.spdx_identifier
FROM software_licenses
WHERE software_license_policies.software_license_id = software_licenses.id AND software_license_policies.id IN (
SELECT software_license_policies.id
FROM software_license_policies
WHERE software_license_policies.id BETWEEN $1 AND $2 AND software_license_policies.software_license_spdx_identifier IS NULL AND software_license_policies.software_license_id IS NOT NULL AND software_license_policies.id >= $3 AND software_license_policies.id < $4
)10 13.9 ms 2.4 ms 1.4 ms 902 UPDATE software_license_policies
SET software_license_spdx_identifier = software_licenses.spdx_identifier
FROM software_licenses
WHERE software_license_policies.software_license_id = software_licenses.id AND software_license_policies.id IN (
SELECT software_license_policies.id
FROM software_license_policies
WHERE software_license_policies.id BETWEEN $1 AND $2 AND software_license_policies.software_license_spdx_identifier IS NULL AND software_license_policies.software_license_id IS NOT NULL AND software_license_policies.id >= $3
)10 3.0 ms 0.8 ms 0.3 ms 10 UPDATE batched_background_migration_jobs
SET updated_at = $1, finished_at = $2, status = $3, metrics = $4
WHERE batched_background_migration_jobs.id = $591 20.1 ms 0.7 ms 0.2 ms 81 SELECT software_license_policies.id
FROM software_license_policies
WHERE software_license_policies.id BETWEEN $1 AND $2 AND software_license_policies.software_license_spdx_identifier IS NULL AND software_license_policies.software_license_id IS NOT NULL AND software_license_policies.id >= $3
ORDER BY software_license_policies.id ASC
LIMIT $4
OFFSET $510 1.5 ms 0.4 ms 0.1 ms 10 UPDATE batched_background_migration_jobs
SET updated_at = $1, started_at = $2, status = $3, attempts = $4
WHERE batched_background_migration_jobs.id = $520 2.4 ms 0.3 ms 0.1 ms 20 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
20 0.9 ms 0.2 ms 0.0 ms 20 SELECT batched_background_migration_jobs.*
FROM batched_background_migration_jobs
WHERE batched_background_migration_jobs.id = $1
LIMIT $210 0.4 ms 0.1 ms 0.0 ms 10 SELECT sum(batched_background_migration_jobs.batch_size)
FROM batched_background_migration_jobs
WHERE batched_background_migration_jobs.batched_background_migration_id = $1 AND batched_background_migration_jobs.status IN ($2)10 0.3 ms 0.0 ms 0.0 ms 10 SELECT software_license_policies.id
FROM software_license_policies
WHERE software_license_policies.id BETWEEN $1 AND $2 AND software_license_policies.software_license_spdx_identifier IS NULL AND software_license_policies.software_license_id IS NOT NULL
ORDER BY software_license_policies.id ASC
LIMIT $3Histogram of batch runtimes for BackfillSoftwareLicenseSpdxIdentifierForSoftwareLicensePolicies
Batch Runtime Count 0 seconds - 10 seconds 10 10 seconds - 1 minute 0 1 minute - 2 minutes 0 2 minutes - 3 minutes 0 3 minutes - 5 minutes 0 5 minutes + 0 Histogram across all sampled batches of BackfillSoftwareLicenseSpdxIdentifierForSoftwareLicensePolicies
Query Runtime Count 0 seconds - 0.1 seconds 0 0.1 seconds - 0.5 seconds 262 0.5 seconds - 1 second 0 1 second - 2 seconds 0 2 seconds - 5 seconds 0 5 seconds + 0 Background Migration: BackfillSeatAssignmentsTable
Sampled 36 batches. Estimated Time to complete: 6 days, 21 hours, and 14 minutes
- Interval: 120s
- Max batch size: 0
- Estimated seconds to complete: 594840s
- Average batch time: 14.66s
- Batch size: 10000
- N. of batches sampled: 36
- 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 Query 351 77143.5 ms 1185.3 ms 219.8 ms 221607 INSERT INTO subscription_seat_assignments (namespace_id, user_id, created_at, updated_at) VALUES ($1, $2, $3, $4), ($5, $6, $7, $8), ($9, $10, $11, $12), ($13, $14, $15, $16), ($17, $18, $19, $20), ($21, $22, $23, $24), ($25, $26, $27, $28), ($29, $30, $31, $32), ($33, $34, $35, $36), ($37, $38, $39, $40), ($41, $42, $43, $44), ($45, $46, $47, $48), ($49, $50, $51, $52), ($53, $54, $55, $56), ($57, $58, $59, $60), ($61, $62, $63, $64), ($65, $66, $67, $68), ($69, $70, $71, $72), ($73, $74, $75, $76), ($77, $78, $79, $80), ($81, $82, $83, $84), ($85, $86, $87, $88), ($89, $90, $91, $92), ($93, $94, $95, $96), ($97, $98, $99, $100), ($101, $102, $103, $104), ($105, $106, $107, $108), ($109, $110, $111, $112), ($113, $114, $115, $116), ($117, $118, $119, $120), ($121, $122, $123, $124), ($125, $126, $127, $128), ($129, $130, $131, $132), ($133, $134, $135, $136), ($137, $138, $139, $140), ($141, $142, $143, $144), ($145, $146, $147, $148), ($149, $150, $151, $152), ($153, $154, $155, $156), ($157, $158, $159, $160), ($161, $162, $163, $164), ($165, $166, $167, $168), ($169, $170, $171, $172), ($173, $174, $175, $176), ($177, $178, $179, $180), ($181, $182, $183, $184), ($185, $186, $187, $188), ($189, $190, $191, $192), ($193, $194, $195, $196), ($197, $198, $199, $200), ($201, $202, $203, $204), ($205, $206, $207, $208), ($209, $210, $211, $212), ($213, $214, $215, $216), ($217, $218, $219, $220), ($221, $222, $223, $224), ($225, $226, $227, $228), ($229, $230, $231, $232), ($233, $234, $235, $236), ($237, $238, $239, $240), ($241, $242, $243, $244), ($245, $246, $247, $248), ($249, $250, $251, $252), ($253, $254, $255, $256), ($257, $258, $259, $260), ($261, $262, $263, $264), ($265, $266, $267, $268), ($269, $270, $271, $272), ($273, $274, $275, $276), ($277, $278, $279, $280), ($281, $282, $283, $284), ($285, $286, $287, $288), ($289, $290, $291, $292), ($293, $294, $295, $296), ($297, $298, $299, $300), ($301, $302, $303, $304), ($305, $306, $307, $308), ($309, $310, $311, $312), ($313, $314, $315, $316), ($317, $318, $319, $320), ($321, $322, $323, $324), ($325, $326, $327, $328), ($329, $330, $331, $332), ($333, $334, $335, $336), ($337, $338, $339, $340), ($341, $342, $343, $344), ($345, $346, $347, $348), ($349, $350, $351, $352), ($353, $354, $355, $356), ($357, $358, $359, $360), ($361, $362, $363, $364), ($365, $366, $367, $368), ($369, $370, $371, $372), ($373, $374, $375, $376), ($377, $378, $379, $380), ($381, $382, $383, $384), ($385, $386, $387, $388), ($389, $390, $391, $392), ($393, $394, $395, $396), ($397, $398, $399, $400), ($401, $402, $403, $404), ($405, $406, $407, $408), ($409, $410, $411, $412), ($413, $414, $415, $416), ($417, $418, $419, $420), ($421, $422, $423, $424), ($425, $426, $427, $428), ($429, $430, $431, $432), ($433, $434, $435, $436), ($437, $438, $439, $440), ($441, $442, $443, $444), ($445, $446, $447, $448), ($449, $450, $451, $452), ($453, $454, $455, $456), ($457, $458, $459, $460), ($461, $462, $463, $464), ($465, $466, $467, $468), ($469, $470, $471, $472), ($473, $474, $475, $476), ($477, $478, $479, $480), ($481, $482, $483, $484), ($485, $486, $487, $488), ($489, $490, $491, $492), ($493, $494, $495, $496), ($497, $498, $499, $500), ($501, $502, $503, $504), ($505, $506, $507, $508), ($509, $510, $511, $512), ($513, $514, $515, $516), ($517, $518, $519, $520), ($521, $522, $523, $524), ($525, $526, $527, $528), ($529, $530, $531, $532), ($533, $534, $535, $536), ($537, $538, $539, $540), ($541, $542, $543, $544), ($545, $546, $547, $548), ($549, $550, $551, $552), ($553, $554, $555, $556), ($557, $558, $559, $560), ($561, $562, $563, $564), ($565, $566, $567, $568), ($569, $570, $571, $572), ($573, $574, $575, $576), ($577, $578, $579, $580), ($581, $582, $583, $584), ($585, $586, $587, $588), ($589, $590, $591, $592), ($593, $594, $595, $596), ($597, $598, $599, $600), ($601, $602, $603, $604), ($605, $606, $607, $608), ($609, $610, $611, $612), ($613, $614, $615, $616), ($617, $618, $619, $620), ($621, $622, $623, $624), ($625, $626, $627, $628), ($629, $630, $631, $632), ($633, $634, $635, $636), ($637, $638, $639, $640), ($641, $642, $643, $644), ($645, $646, $647, $648), ($649, $650, $651, $652), ($653, $654, $655, $656), ($657, $658, $659, $660), ($661, $662, $663, $664), ($665, $666, $667, $668), ($669, $670, $671, $672), ($673, $674, $675, $676), ($677, $678, $679, $680), ($681, $682, $683, $684), ($685, $686, $687, $688), ($689, $690, $691, $692), ($693, $694, $695, $696), ($697, $698, $699, $700), ($701, $702, $703, $704), ($705, $706, $707, $708), ($709, $710, $711, $712), ($713, $714, $715, $716), ($717, $718, $719, $720), ($721, $722, $723, $724), ($725, $726, $727, $728), ($729, $730, $731, $732), ($733, $734, $735, $736), ($737, $738, $739, $740), ($741, $742, $743, $744), ($745, $746, $747, $748), ($749, $750, $751, $752), ($753, $754, $755, $756), ($757, $758, $759, $760), ($761, $762, $763, $764), ($765, $766, $767, $768), ($769, $770, $771, $772), ($773, $774, $775, $776), ($777, $778, $779, $780), ($781, $782, $783, $784), ($785, $786, $787, $788), ($789, $790, $791, $792), ($793, $794, $795, $796), ($797, $798, $799, $800), ($801, $802, $803, $804), ($805, $806, $807, $808), ($809, $810, $811, $812), ($813, $814, $815, $816), ($817, $818, $819, $820), ($821, $822, $823, $824), ($825, $826, $827, $828), ($829, $830, $831, $832), ($833, $834, $835, $836), ($837, $838, $839, $840), ($841, $842, $843, $844), ($845, $846, $847, $848), ($849, $850, $851, $852), ($853, $854, $855, $856), ($857, $858, $859, $860), ($861, $862, $863, $864), ($865, $866, $867, $868), ($869, $870, $871, $872), ($873, $874, $875, $876), ($877, $878, $879, $880), ($881, $882, $883, $884), ($885, $886, $887, $888), ($889, $890, $891, $892), ($893, $894, $895, $896), ($897, $898, $899, $900), ($901, $902, $903, $904), ($905, $906, $907, $908), ($909, $910, $911, $912), ($913, $914, $915, $916), ($917, $918, $919, $920), ($921, $922, $923, $924), ($925, $926, $927, $928), ($929, $930, $931, $932), ($933, $934, $935, $936), ($937, $938, $939, $940), ($941, $942, $943, $944), ($945, $946, $947, $948), ($949, $950, $951, $952), ($953, $954, $955, $956), ($957, $958, $959, $960), ($961, $962, $963, $964), ($965, $966, $967, $968), ($969, $970, $971, $972), ($973, $974, $975, $976), ($977, $978, $979, $980), ($981, $982, $983, $984), ($985, $986, $987, $988), ($989, $990, $991, $992), ($993, $994, $995, $996), ($997, $998, $999, $1000), ($1001, $1002, $1003, $1004), ($1005, $1006, $1007, $1008), ($1009, $1010, $1011, $1012), ($1013, $1014, $1015, $1016), ($1017, $1018, $1019, $1020), ($1021, $1022, $1023, $1024), ($1025, $1026, $1027, $1028), ($1029, $1030, $1031, $1032), ($1033, $1034, $1035, $1036), ($1037, $1038, $1039, $1040), ($1041, $1042, $1043, $1044), ($1045, $1046, $1047, $1048), ($1049, $1050, $1051, $1052), ($1053, $1054, $1055, $1056), ($1057, $1058, $1059, $1060), ($1061, $1062, $1063, $1064), ($1065, $1066, $1067, $1068), ($1069, $1070, $1071, $1072), ($1073, $1074, $1075, $1076), ($1077, $1078, $1079, $1080), ($1081, $1082, $1083, $1084), ($1085, $1086, $1087, $1088), ($1089, $1090, $1091, $1092), ($1093, $1094, $1095, $1096), ($1097, $1098, $1099, $1100), ($1101, $1102, $1103, $1104), ($1105, $1106, $1107, $1108), ($1109, $1110, $1111, $1112), ($1113, $1114, $1115, $1116), ($1117, $1118, $1119, $1120), ($1121, $1122, $1123, $1124), ($1125, $1126, $1127, $1128), ($1129, $1130, $1131, $1132), ($1133, $1134, $1135, $1136), ($1137, $1138, $1139, $1140), ($1141, $1142, $1143, $1144), ($1145, $1146, $1147, $1148), ($1149, $1150, $1151, $1152), ($1153, $1154, $1155, $1156), ($1157, $1158, $1159, $1160), ($1161, $1162, $1163, $1164), ($1165, $1166, $1167, $1168), ($1169, $1170, $1171, $1172), ($1173, $1174, $1175, $1176), ($1177, $1178, $1179, $1180), ($1181, $1182, $1183, $1184), ($1185, $1186, $1187, $1188), ($1189, $1190, $1191, $1192), ($1193, $1194, $1195, $1196), ($1197, $1198, $1199, $1200), ($1201, $1202, $1203, $1204), ($1205, $1206, $1207, $1208), ($1209, $1210, $1211, $1212), ($1213, $1214, $1215, $1216), ($1217, $1218, $1219, $1220), ($1221, $1222, $1223, $1224), ($1225, $1226, $1227, $1228), ($1229, $1230, $1231, $1232), ($1233, $1234, $1235, $1236), ($1237, $1238, $1239, $1240), ($1241, $1242, $1243, $1244), ($1245, $1246, $1247, $1248), ($1249, $1250, $1251, $1252), ($1253, $1254, $1255, $1256), ($1257, $1258, $1259, $1260), ($1261, $1262, $1263, $1264), ($1265, $1266, $1267, $1268), ($1269, $1270, $1271, $1272), ($1273, $1274, $1275, $1276), ($1277, $1278, $1279, $1280), ($1281, $1282, $1283, $1284), ($1285, $1286, $1287, $1288), ($1289, $1290, $1291, $1292), ($1293, $1294, $1295, $1296), ($1297, $1298, $1299, $1300), ($1301, $1302, $1303, $1304), ($1305, $1306, $1307, $1308), ($1309, $1310, $1311, $1312), ($1313, $1314, $1315, $1316), ($1317, $1318, $1319, $1320), ($1321, $1322, $1323, $1324), ($1325, $1326, $1327, $1328), ($1329, $1330, $1331, $1332), ($1333, $1334, $1335, $1336), ($1337, $1338, $1339, $1340), ($1341, $1342, $1343, $1344), ($1345, $1346, $1347, $1348), ($1349, $1350, $1351, $1352), ($1353, $1354, $1355, $1356), ($1357, $1358, $1359, $1360), ($1361, $1362, $1363, $1364), ($1365, $1366, $1367, $1368), ($1369, $1370, $1371, $1372), ($1373, $1374, $1375, $1376), ($1377, $1378, $1379, $1380), ($1381, $1382, $1383, $1384), ($1385, $1386, $1387, $1388), ($1389, $1390, $1391, $1392), ($1393, $1394, $1395, $1396), ($1397, $1398, $1399, $1400), ($1401, $1402, $1403, $1404), ($1405, $1406, $1407, $1408), ($1409, $1410, $1411, $1412), ($1413, $1414, $1415, $1416), ($1417, $1418, $1419, $1420), ($1421, $1422, $1423, $1424), ($1425, $1426, $1427, $1428), ($1429, $1430, $1431, $1432), ($1433, $1434, $1435, $1436), ($1437, $1438, $1439, $1440), ($1441, $1442, $1443, $1444), ($1445, $1446, $1447, $1448), ($1449, $1450, $1451, $1452), ($1453, $1454, $1455, $1456), ($1457, $1458, $1459, $1460), ($1461, $1462, $1463, $1464), ($1465, $1466, $1467, $1468), ($1469, $1470, $1471, $1472), ($1473, $1474, $1475, $1476), ($1477, $1478, $1479, $1480), ($1481, $1482, $1483, $1484), ($1485, $1486, $1487, $1488), ($1489, $1490, $1491, $1492), ($1493, $1494, $1495, $1496), ($1497, $1498, $1499, $1500), ($1501, $1502, $1503, $1504), ($1505, $1506, $1507, $1508), ($1509, $1510, $1511, $1512), ($1513, $1514, $1515, $1516), ($1517, $1518, $1519, $1520), ($1521, $1522, $1523, $1524), ($1525, $1526, $1527, $1528), ($1529, $1530, $1531, $1532), ($1533, $1534, $1535, $1536), ($1537, $1538, $1539, $1540), ($1541, $1542, $1543, $1544), ($1545, $1546, $1547, $1548), ($1549, $1550, $1551, $1552), ($1553, $1554, $1555, $1556), ($1557, $1558, $1559, $1560), ($1561, $1562, $1563, $1564), ($1565, $1566, $1567, $1568), ($1569, $1570, $1571, $1572), ($1573, $1574, $1575, $1576), ($1577, $1578, $1579, $1580), ($1581, $1582, $1583, $1584), ($1585, $1586, $1587, $1588), ($1589, $1590, $1591, $1592), ($1593, $1594, $1595, $1596), ($1597, $1598, $1599, $1600), ($1601, $1602, $1603, $1604), ($1605, $1606, $1607, $1608), ($1609, $1610, $1611, $1612), ($1613, $1614, $1615, $1616), ($1617, $1618, $1619, $1620), ($1621, $1622, $1623, $1624), ($1625, $1626, $1627, $1628), ($1629, $1630, $1631, $1632), ($1633, $1634, $1635, $1636), ($1637, $1638, $1639, $1640), ($1641, $1642, $1643, $1644), ($1645, $1646, $1647, $1648), ($1649, $1650, $1651, $1652), ($1653, $1654, $1655, $1656), ($1657, $1658, $1659, $1660), ($1661, $1662, $1663, $1664), ($1665, $1666, $1667, $1668), ($1669, $1670, $1671, $1672), ($1673, $1674, $1675, $1676), ($1677, $1678, $1679, $1680), ($1681, $1682, $1683, $1684), ($1685, $1686, $1687, $1688), ($1689, $1690, $1691, $1692), ($1693, $1694, $1695, $1696), ($1697, $1698, $1699, $1700), ($1701, $1702, $1703, $1704), ($1705, $1706, $1707, $1708), ($1709, $1710, $1711, $1712), ($1713, $1714, $1715, $1716), ($1717, $1718, $1719, $1720), ($1721, $1722, $1723, $1724), ($1725, $1726, $1727, $1728), ($1729, $1730, $1731, $1732), ($1733, $1734, $1735, $1736), ($1737, $1738, $1739, $1740), ($1741, $1742, $1743, $1744), ($1745, $1746, $1747, $1748), ($1749, $1750, $1751, $1752), ($1753, $1754, $1755, $1756), ($1757, $1758, $1759, $1760), ($1761, $1762, $1763, $1764), ($1765, $1766, $1767, $1768), ($1769, $1770, $1771, $1772), ($1773, $1774, $1775, $1776), ($1777, $1778, $1779, $1780), ($1781, $1782, $1783, $1784), ($1785, $1786, $1787, $1788), ($1789, $1790, $1791, $1792), ($1793, $1794, $1795, $1796), ($1797, $1798, $1799, $1800), ($1801, $1802, $1803, $1804), ($1805, $1806, $1807, $1808), ($1809, $1810, $1811, $1812), ($1813, $1814, $1815, $1816), ($1817, $1818, $1819, $1820), ($1821, $1822, $1823, $1824), ($1825, $1826, $1827, $1828), ($1829, $1830, $1831, $1832), ($1833, $1834, $1835, $1836), ($1837, $1838, $1839, $1840), ($1841, $1842, $1843, $1844), ($1845, $1846, $1847, $1848), ($1849, $1850, $1851, $1852), ($1853, $1854, $1855, $1856), ($1857, $1858, $1859, $1860), ($1861, $1862, $1863, $1864), ($1865, $1866, $1867, $1868), ($1869, $1870, $1871, $1872), ($1873, $1874, $1875, $1876), ($1877, $1878, $1879, $1880), ($1881, $1882, $1883, $1884), ($1885, $1886, $1887, $1888), ($1889, $1890, $1891, $1892), ($1893, $1894, $1895, $1896), ($1897, $1898, $1899, $1900), ($1901, $1902, $1903, $1904), ($1905, $1906, $1907, $1908), ($1909, $1910, $1911, $1912), ($1913, $1914, $1915, $1916), ($1917, $1918, $1919, $1920), ($1921, $1922, $1923, $1924), ($1925, $1926, $1927, $1928), ($1929, $1930, $1931, $1932), ($1933, $1934, $1935, $1936), ($1937, $1938, $1939, $1940), ($1941, $1942, $1943, $1944), ($1945, $1946, $1947, $1948), ($1949, $1950, $1951, $1952), ($1953, $1954, $1955, $1956), ($1957, $1958, $1959, $1960), ($1961, $1962, $1963, $1964), ($1965, $1966, $1967, $1968), ($1969, $1970, $1971, $1972), ($1973, $1974, $1975, $1976), ($1977, $1978, $1979, $1980), ($1981, $1982, $1983, $1984), ($1985, $1986, $1987, $1988), ($1989, $1990, $1991, $1992), ($1993, $1994, $1995, $1996), ($1997, $1998, $1999, $2000), ($2001, $2002, $2003, $2004), ($2005, $2006, $2007, $2008), ($2009, $2010, $2011, $2012), ($2013, $2014, $2015, $2016), ($2017, $2018, $2019, $2020), ($2021, $2022, $2023, $2024), ($2025, $2026, $2027, $2028), ($2029, $2030, $2031, $2032), ($2033, $2034, $2035, $2036), ($2037, $2038, $2039, $2040), ($2041, $2042, $2043, $2044), ($2045, $2046, $2047, $2048), ($2049, $2050, $2051, $2052), ($2053, $2054, $2055, $2056), ($2057, $2058, $2059, $2060), ($2061, $2062, $2063, $2064), ($2065, $2066, $2067, $2068), ($2069, $2070, $2071, $2072), ($2073, $2074, $2075, $2076), ($2077, $2078, $2079, $2080), ($2081, $2082, $2083, $2084), ($2085, $2086, $2087, $2088), ($2089, $2090, $2091, $2092), ($2093, $2094, $2095, $2096), ($2097, $2098, $2099, $2100), ($2101, $2102, $2103, $2104), ($2105, $2106, $2107, $2108), ($2109, $2110, $2111, $2112), ($2113, $2114, $2115, $2116), ($2117, $2118, $2119, $2120), ($2121, $2122, $2123, $2124), ($2125, $2126, $2127, $2128), ($2129, $2130, $2131, $2132), ($2133, $2134, $2135, $2136), ($2137, $2138, $2139, $2140), ($2141, $2142, $2143, $2144), ($2145, $2146, $2147, $2148), ($2149, $2150, $2151, $2152), ($2153, $2154, $2155, $2156), ($2157, $2158, $2159, $2160), ($2161, $2162, $2163, $2164), ($2165, $2166, $2167, $2168), ($2169, $2170, $2171, $2172), ($2173, $2174, $2175, $2176), ($2177, $2178, $2179, $2180), ($2181, $2182, $2183, $2184), ($2185, $2186, $2187, $2188), ($2189, $2190, $2191, $2192), ($2193, $2194, $2195, $2196), ($2197, $2198, $2199, $2200), ($2201, $2202, $2203, $2204), ($2205, $2206, $2207, $2208), ($2209, $2210, $2211, $2212), ($2213, $2214, $2215, $2216), ($2217, $2218, $2219, $2220), ($2221, $2222, $2223, $2224), ($2225, $2226, $2227, $2228), ($2229, $2230, $2231, $2232), ($2233, $2234, $2235, $2236), ($2237, $2238, $2239, $2240), ($2241, $2242, $2243, $2244), ($2245, $2246, $2247, $2248), ($2249, $2250, $2251, $2252), ($2253, $2254, $2255, $2256), ($2257, $2258, $2259, $2260), ($2261, $2262, $2263, $2264), ($2265, $2266, $2267, $2268), ($2269, $2270, $2271, $2272), ($2273, $2274, $2275, $2276), ($2277, $2278, $2279, $2280), ($2281, $2282, $2283, $2284), ($2285, $2286, $2287, $2288), ($2289, $2290, $2291, $2292), ($2293, $2294, $2295, $2296), ($2297, $2298, $2299, $2300), ($2301, $2302, $2303, $2304), ($2305, $2306, $2307, $2308), ($2309, $2310, $2311, $2312), ($2313, $2314, $2315, $2316), ($2317, $2318, $2319, $2320), ($2321, $2322, $2323, $2324), ($2325, $2326, $2327, $2328), ($2329, $2330, $2331, $2332), ($2333, $2334, $2335, $2336), ($2337, $2338, $2339, $2340), ($2341, $2342, $2343, $2344), ($2345, $2346, $2347, $2348), ($2349, $2350, $2351, $2352), ($2353, $2354, $2355, $2356), ($2357, $2358, $2359, $2360), ($2361, $2362, $2363, $2364), ($2365, $2366, $2367, $2368), ($2369, $2370, $2371, $2372), ($2373, $2374, $2375, $2376), ($2377, $2378, $2379, $2380), ($2381, $2382, $2383, $2384), ($2385, $2386, $2387, $2388), ($2389, $2390, $2391, $2392), ($2393, $2394, $2395, $2396), ($2397, $2398, $2399, $2400), ($2401, $2402, $2403, $2404), ($2405, $2406, $2407, $2408), ($2409, $2410, $2411, $2412), ($2413, $2414, $2415, $2416), ($2417, $2418, $2419, $2420), ($2421, $2422, $2423, $2424), ($2425, $2426, $2427, $2428), ($2429, $2430, $2431, $2432), ($2433, $2434, $2435, $2436), ($2437, $2438, $2439, $2440), ($2441, $2442, $2443, $2444), ($2445, $2446, $2447, $2448), ($2449, $2450, $2451, $2452), ($2453, $2454, $2455, $2456), ($2457, $2458, $2459, $2460), ($2461, $2462, $2463, $2464), ($2465, $2466, $2467, $2468), ($2469, $2470, $2471, $2472), ($2473, $2474, $2475, $2476), ($2477, $2478, $2479, $2480), ($2481, $2482, $2483, $2484), ($2485, $2486, $2487, $2488), ($2489, $2490, $2491, $2492), ($2493, $2494, $2495, $2496), ($2497, $2498, $2499, $2500), ($2501, $2502, $2503, $2504), ($2505, $2506, $2507, $2508), ($2509, $2510, $2511, $2512), ($2513, $2514, $2515, $2516), ($2517, $2518, $2519, $2520), ($2521, $2522, $2523, $2524), ($2525, $2526, $2527, $2528), ($2529, $2530, $2531, $2532), ($2533, $2534, $2535, $2536), ($2537, $2538, $2539, $2540), ($2541, $2542, $2543, $2544), ($2545, $2546, $2547, $2548), ($2549, $2550, $2551, $2552), ($2553, $2554, $2555, $2556), ($2557, $2558, $2559, $2560), ($2561, $2562, $2563, $2564), ($2565, $2566, $2567, $2568), ($2569, $2570, $2571, $2572), ($2573, $2574, $2575, $2576), ($2577, $2578, $2579, $2580), ($2581, $2582, $2583, $2584), ($2585, $2586, $2587, $2588), ($2589, $2590, $2591, $2592), ($2593, $2594, $2595, $2596), ($2597, $2598, $2599, $2600), ($2601, $2602, $2603, $2604), ($2605, $2606, $2607, $2608), ($2609, $2610, $2611, $2612), ($2613, $2614, $2615, $2616), ($2617, $2618, $2619, $2620), ($2621, $2622, $2623, $2624), ($2625, $2626, $2627, $2628), ($2629, $2630, $2631, $2632), ($2633, $2634, $2635, $2636), ($2637, $2638, $2639, $2640), ($2641, $2642, $2643, $2644), ($2645, $2646, $2647, $2648), ($2649, $2650, $2651, $2652), ($2653, $2654, $2655, $2656), ($2657, $2658, $2659, $2660), ($2661, $2662, $2663, $2664), ($2665, $2666, $2667, $2668), ($2669, $2670, $2671, $2672), ($2673, $2674, $2675, $2676), ($2677, $2678, $2679, $2680), ($2681, $2682, $2683, $2684), ($2685, $2686, $2687, $2688), ($2689, $2690, $2691, $2692), ($2693, $2694, $2695, $2696), ($2697, $2698, $2699, $2700), ($2701, $2702, $2703, $2704), ($2705, $2706, $2707, $2708), ($2709, $2710, $2711, $2712), ($2713, $2714, $2715, $2716), ($2717, $2718, $2719, $2720), ($2721, $2722, $2723, $2724), ($2725, $2726, $2727, $2728), ($2729, $2730, $2731, $2732), ($2733, $2734, $2735, $2736), ($2737, $2738, $2739, $2740), ($2741, $2742, $2743, $2744), ($2745, $2746, $2747, $2748), ($2749, $2750, $2751, $2752), ($2753, $2754, $2755, $2756), ($2757, $2758, $2759, $2760), ($2761, $2762, $2763, $2764), ($2765, $2766, $2767, $2768), ($2769, $2770, $2771, $2772), ($2773, $2774, $2775, $2776), ($2777, $2778, $2779, $2780), ($2781, $2782, $2783, $2784), ($2785, $2786, $2787, $2788), ($2789, $2790, $2791, $2792), ($2793, $2794, $2795, $2796), ($2797, $2798, $2799, $2800), ($2801, $2802, $2803, $2804), ($2805, $2806, $2807, $2808), ($2809, $2810, $2811, $2812), ($2813, $2814, $2815, $2816), ($2817, $2818, $2819, $2820), ($2821, $2822, $2823, $2824), ($2825, $2826, $2827, $2828), ($2829, $2830, $2831, $2832), ($2833, $2834, $2835, $2836), ($2837, $2838, $2839, $2840), ($2841, $2842, $2843, $2844), ($2845, $2846, $2847, $2848), ($2849, $2850, $2851, $2852), ($2853, $2854, $2855, $2856), ($2857, $2858, $2859, $2860), ($2861, $2862, $2863, $2864), ($2865, $2866, $2867, $2868), ($2869, $2870, $2871, $2872), ($2873, $2874, $2875, $2876), ($2877, $2878, $2879, $2880), ($2881, $2882, $2883, $2884), ($2885, $2886, $2887, $2888), ($2889, $2890, $2891, $2892), ($2893, $2894, $2895, $2896), ($2897, $2898, $2899, $2900), ($2901, $2902, $2903, $2904), ($2905, $2906, $2907, $2908), ($2909, $2910, $2911, $2912), ($2913, $2914, $2915, $2916), ($2917, $2918, $2919, $2920), ($2921, $2922, $2923, $2924), ($2925, $2926, $2927, $2928), ($2929, $2930, $2931, $2932), ($2933, $2934, $2935, $2936), ($2937, $2938, $2939, $2940), ($2941, $2942, $2943, $2944), ($2945, $2946, $2947, $2948), ($2949, $2950, $2951, $2952), ($2953, $2954, $2955, $2956), ($2957, $2958, $2959, $2960), ($2961, $2962, $2963, $2964), ($2965, $2966, $2967, $2968), ($2969, $2970, $2971, $2972), ($2973, $2974, $2975, $2976), ($2977, $2978, $2979, $2980), ($2981, $2982, $2983, $2984), ($2985, $2986, $2987, $2988), ($2989, $2990, $2991, $2992), ($2993, $2994, $2995, $2996), ($2997, $2998, $2999, $3000), ($3001, $3002, $3003, $3004), ($3005, $3006, $3007, $3008), ($3009, $3010, $3011, $3012), ($3013, $3014, $3015, $3016), ($3017, $3018, $3019, $3020), ($3021, $3022, $3023, $3024), ($3025, $3026, $3027, $3028), ($3029, $3030, $3031, $3032), ($3033, $3034, $3035, $3036), ($3037, $3038, $3039, $3040), ($3041, $3042, $3043, $3044), ($3045, $3046, $3047, $3048), ($3049, $3050, $3051, $3052), ($3053, $3054, $3055, $3056), ($3057, $3058, $3059, $3060), ($3061, $3062, $3063, $3064), ($3065, $3066, $3067, $3068), ($3069, $3070, $3071, $3072), ($3073, $3074, $3075, $3076), ($3077, $3078, $3079, $3080), ($3081, $3082, $3083, $3084), ($3085, $3086, $3087, $3088), ($3089, $3090, $3091, $3092), ($3093, $3094, $3095, $3096), ($3097, $3098, $3099, $3100), ($3101, $3102, $3103, $3104), ($3105, $3106, $3107, $3108), ($3109, $3110, $3111, $3112), ($3113, $3114, $3115, $3116), ($3117, $3118, $3119, $3120), ($3121, $3122, $3123, $3124), ($3125, $3126, $3127, $3128), ($3129, $3130, $3131, $3132), ($3133, $3134, $3135, $3136), ($3137, $3138, $3139, $3140), ($3141, $3142, $3143, $3144) ON CONFLICT (namespace_id, user_id) DO NOTHING RETURNING id
315 42672.7 ms 553.1 ms 135.5 ms 238915 SELECT DISTINCT user_id, (
SELECT traversal_ids[$1]
FROM namespaces
WHERE id = members.member_namespace_id
) AS root_namespace_id
FROM members
WHERE id IN (
SELECT members.id
FROM members
WHERE members.id BETWEEN $2 AND $3 AND members.id >= $4 AND members.id < $5 AND members.user_id IS NOT NULL
)36 4269.9 ms 483.6 ms 118.6 ms 26792 SELECT DISTINCT user_id, (
SELECT traversal_ids[$1]
FROM namespaces
WHERE id = members.member_namespace_id
) AS root_namespace_id
FROM members
WHERE id IN (
SELECT members.id
FROM members
WHERE members.id BETWEEN $2 AND $3 AND members.id >= $4 AND members.user_id IS NOT NULL
)351 4163.2 ms 169.6 ms 11.9 ms 44100 SELECT namespace_id AS root_namespace_id, user_id
FROM subscription_seat_assignments
WHERE (namespace_id, user_id) IN (VALUES ($1, $2), ($3, $4), ($5, $6), ($7, $8), ($9, $10), ($11, $12), ($13, $14), ($15, $16), ($17, $18), ($19, $20), ($21, $22), ($23, $24), ($25, $26), ($27, $28), ($29, $30), ($31, $32), ($33, $34), ($35, $36), ($37, $38), ($39, $40), ($41, $42), ($43, $44), ($45, $46), ($47, $48), ($49, $50), ($51, $52), ($53, $54), ($55, $56), ($57, $58), ($59, $60), ($61, $62), ($63, $64), ($65, $66), ($67, $68), ($69, $70), ($71, $72), ($73, $74), ($75, $76), ($77, $78), ($79, $80), ($81, $82), ($83, $84), ($85, $86), ($87, $88), ($89, $90), ($91, $92), ($93, $94), ($95, $96), ($97, $98), ($99, $100), ($101, $102), ($103, $104), ($105, $106), ($107, $108), ($109, $110), ($111, $112), ($113, $114), ($115, $116), ($117, $118), ($119, $120), ($121, $122), ($123, $124), ($125, $126), ($127, $128), ($129, $130), ($131, $132), ($133, $134), ($135, $136), ($137, $138), ($139, $140), ($141, $142), ($143, $144), ($145, $146), ($147, $148), ($149, $150), ($151, $152), ($153, $154), ($155, $156), ($157, $158), ($159, $160), ($161, $162), ($163, $164), ($165, $166), ($167, $168), ($169, $170), ($171, $172), ($173, $174), ($175, $176), ($177, $178), ($179, $180), ($181, $182), ($183, $184), ($185, $186), ($187, $188), ($189, $190), ($191, $192), ($193, $194), ($195, $196), ($197, $198), ($199, $200), ($201, $202), ($203, $204), ($205, $206), ($207, $208), ($209, $210), ($211, $212), ($213, $214), ($215, $216), ($217, $218), ($219, $220), ($221, $222), ($223, $224), ($225, $226), ($227, $228), ($229, $230), ($231, $232), ($233, $234), ($235, $236), ($237, $238), ($239, $240), ($241, $242), ($243, $244), ($245, $246), ($247, $248), ($249, $250), ($251, $252), ($253, $254), ($255, $256), ($257, $258), ($259, $260), ($261, $262), ($263, $264), ($265, $266), ($267, $268), ($269, $270), ($271, $272), ($273, $274), ($275, $276), ($277, $278), ($279, $280), ($281, $282), ($283, $284), ($285, $286), ($287, $288), ($289, $290), ($291, $292), ($293, $294), ($295, $296), ($297, $298), ($299, $300), ($301, $302), ($303, $304), ($305, $306), ($307, $308), ($309, $310), ($311, $312), ($313, $314), ($315, $316), ($317, $318), ($319, $320), ($321, $322), ($323, $324), ($325, $326), ($327, $328), ($329, $330), ($331, $332), ($333, $334), ($335, $336), ($337, $338), ($339, $340), ($341, $342), ($343, $344), ($345, $346), ($347, $348), ($349, $350), ($351, $352), ($353, $354), ($355, $356), ($357, $358), ($359, $360), ($361, $362), ($363, $364), ($365, $366), ($367, $368), ($369, $370), ($371, $372), ($373, $374), ($375, $376), ($377, $378), ($379, $380), ($381, $382), ($383, $384), ($385, $386), ($387, $388), ($389, $390), ($391, $392), ($393, $394), ($395, $396), ($397, $398), ($399, $400), ($401, $402), ($403, $404), ($405, $406), ($407, $408), ($409, $410), ($411, $412), ($413, $414), ($415, $416), ($417, $418), ($419, $420), ($421, $422), ($423, $424), ($425, $426), ($427, $428), ($429, $430), ($431, $432), ($433, $434), ($435, $436), ($437, $438), ($439, $440), ($441, $442), ($443, $444), ($445, $446), ($447, $448), ($449, $450), ($451, $452), ($453, $454), ($455, $456), ($457, $458), ($459, $460), ($461, $462), ($463, $464), ($465, $466), ($467, $468), ($469, $470), ($471, $472), ($473, $474), ($475, $476), ($477, $478), ($479, $480), ($481, $482), ($483, $484), ($485, $486), ($487, $488), ($489, $490), ($491, $492), ($493, $494), ($495, $496), ($497, $498), ($499, $500), ($501, $502), ($503, $504), ($505, $506), ($507, $508), ($509, $510), ($511, $512), ($513, $514), ($515, $516), ($517, $518), ($519, $520), ($521, $522), ($523, $524), ($525, $526), ($527, $528), ($529, $530), ($531, $532), ($533, $534), ($535, $536), ($537, $538), ($539, $540), ($541, $542), ($543, $544), ($545, $546), ($547, $548), ($549, $550), ($551, $552), ($553, $554), ($555, $556), ($557, $558), ($559, $560), ($561, $562), ($563, $564), ($565, $566), ($567, $568), ($569, $570), ($571, $572), ($573, $574), ($575, $576), ($577, $578), ($579, $580), ($581, $582), ($583, $584), ($585, $586), ($587, $588), ($589, $590), ($591, $592), ($593, $594), ($595, $596), ($597, $598), ($599, $600), ($601, $602), ($603, $604), ($605, $606), ($607, $608), ($609, $610), ($611, $612), ($613, $614), ($615, $616), ($617, $618), ($619, $620), ($621, $622), ($623, $624), ($625, $626), ($627, $628), ($629, $630), ($631, $632), ($633, $634), ($635, $636), ($637, $638), ($639, $640), ($641, $642), ($643, $644), ($645, $646), ($647, $648), ($649, $650), ($651, $652), ($653, $654), ($655, $656), ($657, $658), ($659, $660), ($661, $662), ($663, $664), ($665, $666), ($667, $668), ($669, $670), ($671, $672), ($673, $674), ($675, $676), ($677, $678), ($679, $680), ($681, $682), ($683, $684), ($685, $686), ($687, $688), ($689, $690), ($691, $692), ($693, $694), ($695, $696), ($697, $698), ($699, $700), ($701, $702), ($703, $704), ($705, $706), ($707, $708), ($709, $710), ($711, $712), ($713, $714), ($715, $716), ($717, $718), ($719, $720), ($721, $722), ($723, $724), ($725, $726), ($727, $728), ($729, $730), ($731, $732), ($733, $734), ($735, $736), ($737, $738), ($739, $740), ($741, $742), ($743, $744), ($745, $746), ($747, $748), ($749, $750), ($751, $752), ($753, $754), ($755, $756), ($757, $758), ($759, $760), ($761, $762), ($763, $764), ($765, $766), ($767, $768), ($769, $770), ($771, $772), ($773, $774), ($775, $776), ($777, $778), ($779, $780), ($781, $782), ($783, $784), ($785, $786), ($787, $788), ($789, $790), ($791, $792), ($793, $794), ($795, $796), ($797, $798), ($799, $800), ($801, $802), ($803, $804), ($805, $806), ($807, $808), ($809, $810), ($811, $812), ($813, $814), ($815, $816), ($817, $818), ($819, $820), ($821, $822), ($823, $824), ($825, $826), ($827, $828), ($829, $830), ($831, $832), ($833, $834), ($835, $836), ($837, $838), ($839, $840), ($841, $842), ($843, $844), ($845, $846), ($847, $848), ($849, $850), ($851, $852), ($853, $854), ($855, $856), ($857, $858), ($859, $860), ($861, $862), ($863, $864), ($865, $866), ($867, $868), ($869, $870), ($871, $872), ($873, $874), ($875, $876), ($877, $878), ($879, $880), ($881, $882), ($883, $884), ($885, $886), ($887, $888), ($889, $890), ($891, $892), ($893, $894), ($895, $896), ($897, $898), ($899, $900), ($901, $902), ($903, $904), ($905, $906), ($907, $908), ($909, $910), ($911, $912), ($913, $914), ($915, $916), ($917, $918), ($919, $920), ($921, $922), ($923, $924), ($925, $926), ($927, $928), ($929, $930), ($931, $932), ($933, $934), ($935, $936), ($937, $938), ($939, $940), ($941, $942), ($943, $944), ($945, $946), ($947, $948), ($949, $950), ($951, $952), ($953, $954), ($955, $956), ($957, $958), ($959, $960), ($961, $962), ($963, $964), ($965, $966), ($967, $968), ($969, $970), ($971, $972), ($973, $974), ($975, $976), ($977, $978), ($979, $980), ($981, $982), ($983, $984), ($985, $986), ($987, $988), ($989, $990), ($991, $992), ($993, $994), ($995, $996), ($997, $998), ($999, $1000), ($1001, $1002), ($1003, $1004), ($1005, $1006), ($1007, $1008), ($1009, $1010), ($1011, $1012), ($1013, $1014), ($1015, $1016), ($1017, $1018), ($1019, $1020), ($1021, $1022), ($1023, $1024), ($1025, $1026), ($1027, $1028), ($1029, $1030), ($1031, $1032), ($1033, $1034), ($1035, $1036), ($1037, $1038), ($1039, $1040), ($1041, $1042), ($1043, $1044), ($1045, $1046), ($1047, $1048), ($1049, $1050), ($1051, $1052), ($1053, $1054), ($1055, $1056), ($1057, $1058), ($1059, $1060), ($1061, $1062), ($1063, $1064), ($1065, $1066), ($1067, $1068), ($1069, $1070), ($1071, $1072), ($1073, $1074), ($1075, $1076), ($1077, $1078), ($1079, $1080), ($1081, $1082), ($1083, $1084), ($1085, $1086), ($1087, $1088), ($1089, $1090), ($1091, $1092), ($1093, $1094), ($1095, $1096), ($1097, $1098), ($1099, $1100), ($1101, $1102), ($1103, $1104), ($1105, $1106), ($1107, $1108), ($1109, $1110), ($1111, $1112), ($1113, $1114), ($1115, $1116), ($1117, $1118), ($1119, $1120), ($1121, $1122), ($1123, $1124), ($1125, $1126), ($1127, $1128), ($1129, $1130), ($1131, $1132), ($1133, $1134), ($1135, $1136), ($1137, $1138), ($1139, $1140), ($1141, $1142), ($1143, $1144), ($1145, $1146), ($1147, $1148), ($1149, $1150), ($1151, $1152), ($1153, $1154), ($1155, $1156), ($1157, $1158), ($1159, $1160), ($1161, $1162), ($1163, $1164), ($1165, $1166), ($1167, $1168), ($1169, $1170), ($1171, $1172), ($1173, $1174), ($1175, $1176), ($1177, $1178), ($1179, $1180), ($1181, $1182), ($1183, $1184), ($1185, $1186), ($1187, $1188), ($1189, $1190), ($1191, $1192), ($1193, $1194), ($1195, $1196), ($1197, $1198), ($1199, $1200), ($1201, $1202), ($1203, $1204), ($1205, $1206), ($1207, $1208), ($1209, $1210), ($1211, $1212), ($1213, $1214), ($1215, $1216), ($1217, $1218), ($1219, $1220), ($1221, $1222), ($1223, $1224), ($1225, $1226), ($1227, $1228), ($1229, $1230), ($1231, $1232), ($1233, $1234), ($1235, $1236), ($1237, $1238), ($1239, $1240), ($1241, $1242), ($1243, $1244), ($1245, $1246), ($1247, $1248), ($1249, $1250), ($1251, $1252), ($1253, $1254), ($1255, $1256), ($1257, $1258), ($1259, $1260), ($1261, $1262), ($1263, $1264), ($1265, $1266), ($1267, $1268), ($1269, $1270), ($1271, $1272), ($1273, $1274), ($1275, $1276), ($1277, $1278), ($1279, $1280), ($1281, $1282), ($1283, $1284), ($1285, $1286), ($1287, $1288), ($1289, $1290), ($1291, $1292), ($1293, $1294), ($1295, $1296), ($1297, $1298), ($1299, $1300), ($1301, $1302), ($1303, $1304), ($1305, $1306), ($1307, $1308), ($1309, $1310), ($1311, $1312), ($1313, $1314), ($1315, $1316), ($1317, $1318), ($1319, $1320), ($1321, $1322), ($1323, $1324), ($1325, $1326), ($1327, $1328), ($1329, $1330), ($1331, $1332), ($1333, $1334), ($1335, $1336), ($1337, $1338), ($1339, $1340), ($1341, $1342), ($1343, $1344), ($1345, $1346), ($1347, $1348), ($1349, $1350), ($1351, $1352), ($1353, $1354), ($1355, $1356), ($1357, $1358), ($1359, $1360), ($1361, $1362), ($1363, $1364), ($1365, $1366), ($1367, $1368), ($1369, $1370), ($1371, $1372), ($1373, $1374), ($1375, $1376), ($1377, $1378), ($1379, $1380), ($1381, $1382), ($1383, $1384), ($1385, $1386), ($1387, $1388), ($1389, $1390), ($1391, $1392), ($1393, $1394), ($1395, $1396), ($1397, $1398), ($1399, $1400), ($1401, $1402), ($1403, $1404), ($1405, $1406), ($1407, $1408), ($1409, $1410), ($1411, $1412), ($1413, $1414), ($1415, $1416), ($1417, $1418), ($1419, $1420), ($1421, $1422), ($1423, $1424), ($1425, $1426), ($1427, $1428), ($1429, $1430), ($1431, $1432), ($1433, $1434), ($1435, $1436), ($1437, $1438), ($1439, $1440), ($1441, $1442), ($1443, $1444), ($1445, $1446), ($1447, $1448), ($1449, $1450), ($1451, $1452), ($1453, $1454), ($1455, $1456), ($1457, $1458), ($1459, $1460), ($1461, $1462), ($1463, $1464), ($1465, $1466), ($1467, $1468), ($1469, $1470), ($1471, $1472), ($1473, $1474), ($1475, $1476), ($1477, $1478), ($1479, $1480), ($1481, $1482), ($1483, $1484), ($1485, $1486), ($1487, $1488), ($1489, $1490), ($1491, $1492), ($1493, $1494), ($1495, $1496), ($1497, $1498), ($1499, $1500), ($1501, $1502), ($1503, $1504), ($1505, $1506), ($1507, $1508), ($1509, $1510), ($1511, $1512), ($1513, $1514), ($1515, $1516), ($1517, $1518), ($1519, $1520), ($1521, $1522), ($1523, $1524), ($1525, $1526), ($1527, $1528), ($1529, $1530), ($1531, $1532), ($1533, $1534), ($1535, $1536), ($1537, $1538), ($1539, $1540), ($1541, $1542), ($1543, $1544), ($1545, $1546), ($1547, $1548), ($1549, $1550), ($1551, $1552), ($1553, $1554), ($1555, $1556), ($1557, $1558), ($1559, $1560), ($1561, $1562), ($1563, $1564), ($1565, $1566), ($1567, $1568), ($1569, $1570), ($1571, $1572), ($1573, $1574), ($1575, $1576), ($1577, $1578), ($1579, $1580), ($1581, $1582), ($1583, $1584), ($1585, $1586), ($1587, $1588), ($1589, $1590), ($1591, $1592), ($1593, $1594), ($1595, $1596), ($1597, $1598), ($1599, $1600), ($1601, $1602), ($1603, $1604), ($1605, $1606), ($1607, $1608), ($1609, $1610), ($1611, $1612), ($1613, $1614), ($1615, $1616), ($1617, $1618), ($1619, $1620), ($1621, $1622), ($1623, $1624), ($1625, $1626), ($1627, $1628), ($1629, $1630), ($1631, $1632), ($1633, $1634), ($1635, $1636), ($1637, $1638), ($1639, $1640), ($1641, $1642), ($1643, $1644), ($1645, $1646), ($1647, $1648), ($1649, $1650), ($1651, $1652), ($1653, $1654), ($1655, $1656), ($1657, $1658), ($1659, $1660), ($1661, $1662), ($1663, $1664), ($1665, $1666), ($1667, $1668), ($1669, $1670), ($1671, $1672), ($1673, $1674), ($1675, $1676), ($1677, $1678), ($1679, $1680), ($1681, $1682), ($1683, $1684), ($1685, $1686), ($1687, $1688), ($1689, $1690), ($1691, $1692), ($1693, $1694), ($1695, $1696), ($1697, $1698), ($1699, $1700), ($1701, $1702), ($1703, $1704), ($1705, $1706), ($1707, $1708), ($1709, $1710), ($1711, $1712), ($1713, $1714), ($1715, $1716), ($1717, $1718), ($1719, $1720), ($1721, $1722), ($1723, $1724), ($1725, $1726), ($1727, $1728), ($1729, $1730), ($1731, $1732), ($1733, $1734), ($1735, $1736), ($1737, $1738), ($1739, $1740), ($1741, $1742), ($1743, $1744), ($1745, $1746), ($1747, $1748), ($1749, $1750), ($1751, $1752), ($1753, $1754))36 9.4 ms 2.1 ms 0.3 ms 36 UPDATE batched_background_migration_jobs
SET updated_at = $1, started_at = $2, status = $3, attempts = $4
WHERE batched_background_migration_jobs.id = $572 10.1 ms 1.0 ms 0.1 ms 72 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
72 4.4 ms 0.9 ms 0.1 ms 72 SELECT batched_background_migration_jobs.*
FROM batched_background_migration_jobs
WHERE batched_background_migration_jobs.id = $1
LIMIT $236 5.9 ms 0.6 ms 0.2 ms 36 UPDATE batched_background_migration_jobs
SET updated_at = $1, finished_at = $2, status = $3, metrics = $4
WHERE batched_background_migration_jobs.id = $5351 89.1 ms 0.5 ms 0.3 ms 315 SELECT members.id
FROM members
WHERE members.id BETWEEN $1 AND $2 AND members.id >= $3
ORDER BY members.id ASC
LIMIT $4
OFFSET $536 1.4 ms 0.2 ms 0.0 ms 36 SELECT members.id
FROM members
WHERE members.id BETWEEN $1 AND $2
ORDER BY members.id ASC
LIMIT $336 1.8 ms 0.1 ms 0.1 ms 36 SELECT sum(batched_background_migration_jobs.batch_size)
FROM batched_background_migration_jobs
WHERE batched_background_migration_jobs.batched_background_migration_id = $1 AND batched_background_migration_jobs.status IN ($2)Histogram of batch runtimes for BackfillSeatAssignmentsTable
Batch Runtime Count 0 seconds - 10 seconds 2 10 seconds - 1 minute 34 1 minute - 2 minutes 0 2 minutes - 3 minutes 0 3 minutes - 5 minutes 0 5 minutes + 0 Histogram across all sampled batches of BackfillSeatAssignmentsTable
Query Runtime Count 0 seconds - 0.1 seconds 0 0.1 seconds - 0.5 seconds 1492 0.5 seconds - 1 second 197 1 second - 2 seconds 3 2 seconds - 5 seconds 0 5 seconds + 0 Background Migration: BackfillDetectedAtFromCreatedAtColumn
Sampled 89 batches. Estimated Time to complete: 5 months, 2 weeks, 2 days, 2 hours, 40 minutes, and 30 seconds
- Interval: 120s
- Max batch size: 0
- Estimated seconds to complete: 14540760s
- Average batch time: 5.02s
- Batch size: 1000
- N. of batches sampled: 89
- 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 Query 792 15960.9 ms 245.5 ms 20.2 ms 63387 UPDATE vulnerabilities
SET detected_at = created_at
WHERE vulnerabilities.id BETWEEN $1 AND $2 AND vulnerabilities.id >= $3 AND vulnerabilities.id < $4 AND vulnerabilities.detected_at IS NULL89 1592.6 ms 102.5 ms 17.9 ms 7300 UPDATE vulnerabilities
SET detected_at = created_at
WHERE vulnerabilities.id BETWEEN $1 AND $2 AND vulnerabilities.id >= $3 AND vulnerabilities.detected_at IS NULL178 53.1 ms 25.1 ms 0.3 ms 178 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
89 35.9 ms 24.5 ms 0.4 ms 89 UPDATE batched_background_migration_jobs
SET updated_at = $1, started_at = $2, status = $3, attempts = $4
WHERE batched_background_migration_jobs.id = $5881 69.0 ms 2.1 ms 0.1 ms 792 SELECT vulnerabilities.id
FROM vulnerabilities
WHERE vulnerabilities.id BETWEEN $1 AND $2 AND vulnerabilities.id >= $3
ORDER BY vulnerabilities.id ASC
LIMIT $4
OFFSET $5178 10.6 ms 1.1 ms 0.1 ms 178 SELECT batched_background_migration_jobs.*
FROM batched_background_migration_jobs
WHERE batched_background_migration_jobs.id = $1
LIMIT $289 13.5 ms 0.9 ms 0.2 ms 89 UPDATE batched_background_migration_jobs
SET updated_at = $1, finished_at = $2, status = $3, metrics = $4
WHERE batched_background_migration_jobs.id = $589 5.8 ms 0.2 ms 0.1 ms 89 SELECT sum(batched_background_migration_jobs.batch_size)
FROM batched_background_migration_jobs
WHERE batched_background_migration_jobs.batched_background_migration_id = $1 AND batched_background_migration_jobs.status IN ($2)89 3.1 ms 0.0 ms 0.0 ms 89 SELECT vulnerabilities.id
FROM vulnerabilities
WHERE vulnerabilities.id BETWEEN $1 AND $2
ORDER BY vulnerabilities.id ASC
LIMIT $3Histogram of batch runtimes for BackfillDetectedAtFromCreatedAtColumn
Batch Runtime Count 0 seconds - 10 seconds 89 10 seconds - 1 minute 0 1 minute - 2 minutes 0 2 minutes - 3 minutes 0 3 minutes - 5 minutes 0 5 minutes + 0 Histogram across all sampled batches of BackfillDetectedAtFromCreatedAtColumn
Query Runtime Count 0 seconds - 0.1 seconds 601 0.1 seconds - 0.5 seconds 1873 0.5 seconds - 1 second 0 1 second - 2 seconds 0 2 seconds - 5 seconds 0 5 seconds + 0 Other migrations pending on GitLab.com
Migration Type Total runtime Result DB size change 20241105134416 - AddUsernamePasswordToVirtualRegistriesPackagesMavenUpstream Regular 12.8 s +16.00 KiB 20241021063020 - QueueBackfillDetectedAtFromCreatedAtColumn Post deploy 5.3 s +0.00 B 20241103232325 - FinalizeBackfillDastSiteValidationsProjectId Post deploy 4.7 s +0.00 B 20241108133603 - QueueBackfillSeatAssignmentsTable Post deploy 5.0 s +0.00 B 20241115140940 - SyncPartitionFkForPCiBuildsExecutionConfigsAndPCiPipelines Post deploy 7.2 s +0.00 B 20241115211552 - QueueBackfillSoftwareLicenseSpdxIdentifierForSoftwareLicensePolicies Post deploy 4.9 s +0.00 B 20241119085925 - RemoveNamespaceLimitsTemporaryStorageIncreaseEndsOnColumn Post deploy 4.4 s +0.00 B 20241120134610 - SetNamespacesOrganizationIdNotNull Post deploy 4.9 s +0.00 B 20241120232540 - FinalizeBackfillProjectRelationExportsProjectId Post deploy 4.7 s +0.00 B 20241121090148 - RemoveNamespacePendingDeleteColumn Post deploy 4.3 s +0.00 B 20241121115756 - PrepareNamespacesOrganizationIdNotNullValidation Post deploy 5.0 s +8.00 KiB [note] 20241125133120 - IndexGroupWikiRepositoryStatesOnGroupId Post deploy 5.3 s +8.00 KiB [note] 20241125133216 - AddGroupWikiRepositoryStatesGroupIdFk Post deploy 5.0 s +0.00 B 20241125133312 - AddGroupWikiRepositoryStatesGroupIdTrigger Post deploy 4.6 s +0.00 B 20241125133627 - QueueBackfillGroupWikiRepositoryStatesGroupId Post deploy 5.0 s +0.00 B Clone details
Clone ID Clone Created At Clone Data Timestamp Expected Removal Time database-testing-3928179-16211897-main
2024-11-27T11:17:09Z 2024-11-26T06:38:45Z 2024-11-27 23:52:40 +0000 database-testing-3928179-16211897-ci
2024-11-27T11:17:07Z 2024-11-27T08:44:33Z 2024-11-27 23:52:40 +0000 Database migrations (on the ci database)
Migrations included in this change have been executed on gitlab.com data for testing purposes. For details, please see the migration testing pipeline (limited access).
Migration Type Total runtime Result DB size change 20241115121334 - AddDeletePipelinesInSecondsToProjectCiCdSettings Regular 8.1 s +0.00 B 20241115121337 - AddIndexOnProjectSettingsForOldPipelines Post deploy 8.5 s +8.00 KiB [note] Runtime Histogram for all migrations
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 0 0.1 seconds - 1 second 6 1 second - 5 seconds 0 5 seconds - 15 seconds 0 15 seconds - 5 minutes 0 5 minutes + 0 Migration: 20241115121334 - AddDeletePipelinesInSecondsToProjectCiCdSettings
* Duration: 8.1 s
* Database size change: +0.00 BCalls Total Time Max Time Mean Time Rows Query 1 2.4 ms 2.4 ms 2.4 ms 0 ALTER TABLE "project_ci_cd_settings" ADD "delete_pipelines_in_seconds" integer
2 0.0 ms 0.0 ms 0.0 ms 2 SELECT pg_backend_pid()
Histogram for AddDeletePipelinesInSecondsToProjectCiCdSettings
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 0 0.1 seconds - 1 second 3 1 second - 5 seconds 0 5 seconds - 15 seconds 0 15 seconds - 5 minutes 0 5 minutes + 0 Migration: 20241115121337 - AddIndexOnProjectSettingsForOldPipelines
* Duration: 8.5 s
* Database size change: +8.00 KiB [note]Calls Total Time Max Time Mean Time Rows Query 1 4.9 ms 4.9 ms 4.9 ms 0 CREATE INDEX CONCURRENTLY "index_project_ci_cd_settings_on_id_partial" ON "project_ci_cd_settings" ("id")
WHERE delete_pipelines_in_seconds IS NOT NULL2 0.0 ms 0.0 ms 0.0 ms 2 SELECT pg_backend_pid()
Histogram for AddIndexOnProjectSettingsForOldPipelines
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 0 0.1 seconds - 1 second 3 1 second - 5 seconds 0 5 seconds - 15 seconds 0 15 seconds - 5 minutes 0 5 minutes + 0 Other information
Other migrations pending on GitLab.com
Migration Type Total runtime Result DB size change 20241021063020 - QueueBackfillDetectedAtFromCreatedAtColumn Post deploy 7.0 s +0.00 B 20241108133603 - QueueBackfillSeatAssignmentsTable Post deploy 7.1 s +0.00 B 20241119085925 - RemoveNamespaceLimitsTemporaryStorageIncreaseEndsOnColumn Post deploy 7.2 s +0.00 B 20241120134610 - SetNamespacesOrganizationIdNotNull Post deploy 7.9 s +0.00 B 20241121115756 - PrepareNamespacesOrganizationIdNotNullValidation Post deploy 8.1 s +8.00 KiB [note] Clone details
Clone ID Clone Created At Clone Data Timestamp Expected Removal Time database-testing-3928179-16211897-main
2024-11-27T11:17:09Z 2024-11-26T06:38:45Z 2024-11-27 23:52:40 +0000 database-testing-3928179-16211897-ci
2024-11-27T11:17:07Z 2024-11-27T08:44:33Z 2024-11-27 23:52:40 +0000
Brought to you by gitlab-org/database-team/gitlab-com-database-testing. Epic
Edited by ****- A deleted user
added databasereview pending feature flag feature flagexists frontend labels
- Resolved by Marius Bobin
1 Warning This MR changes code in ee/
, but its Changelog commit is missing theEE: true
trailer. Consider adding it to your Changelog commits.Reviewer roulette
Category Reviewer Maintainer backend @adie.po
(UTC+0, 2 hours behind author)
@j_lar
(UTC+1, 1 hour behind author)
database @morefice
(UTC+1, 1 hour behind author)
@jarka
(UTC+1, 1 hour behind author)
frontend @anastasia.khom
(UTC-5, 7 hours behind author)
@ealcantara
(UTC+1, 1 hour behind author)
~"Verify" Reviewer review is optional for ~"Verify" @drew
(UTC+0, 2 hours behind author)
Please refer to documentation page for guidance on how you can benefit from the Reviewer Roulette, or use the GitLab Review Workload Dashboard to find other available reviewers.
If needed, you can retry the
danger-review
job that generated this comment.Generated by
Danger- A deleted user
added Data WarehouseImpact Check label
added database-testing-automation label
- Resolved by Marius Bobin
@drew I've also extracted this part out of !171142 (diffs) since it's something that seems quite simple.
requested review from @drew
added pipeline:mr-approved label
added pipelinetier-2 label and removed pipelinetier-1 label
Before you set this MR to auto-merge
This merge request will progress on pipeline tiers until it reaches the last tier: pipelinetier-3. We will trigger a new pipeline for each transition to a higher tier.
Before you set this MR to auto-merge, please check the following:
- You are the last maintainer of this merge request
- The latest pipeline for this merge request is pipelinetier-3 (You can find which tier it is in the pipeline name)
- This pipeline is recent enough (created in the last 8 hours)
If all the criteria above apply, please set auto-merge for this merge request.
See pipeline tiers and merging a merge request for more details.
requested review from @l.rosa
- Resolved by Marius Bobin
Generated bygitlab_quality-test_tooling
.
Slow tests detected in this merge request. These slow tests might be related to this merge request's changes.Click to expand
Job File Name Duration Expected duration #8487447807 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 43.78 s < 27.12 s #8487448088 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 37.42 s < 27.12 s #8487448247 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 48.91 s < 27.12 s #8487447937 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 49.53 s < 27.12 s #8487449045 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 53.15 s < 27.12 s #8487449565 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 49.39 s < 27.12 s #8487449350 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 50.44 s < 27.12 s #8496197852 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 55.43 s < 27.12 s #8496196422 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 34.28 s < 27.12 s #8496196606 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 45.68 s < 27.12 s #8496196790 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 47.38 s < 27.12 s #8496196270 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 43.71 s < 27.12 s #8496197681 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 57.69 s < 27.12 s #8496197981 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 54.96 s < 27.12 s #8496198136 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 55.52 s < 27.12 s #8502702639 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 44.95 s < 27.12 s #8502703002 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 37.21 s < 27.12 s #8502703197 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 41.31 s < 27.12 s #8502701410 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 38.31 s < 27.12 s #8502701004 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 42.54 s < 27.12 s #8502702399 ee/spec/lib/ee/search/project_settings_spec.rb#L20
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 46.04 s < 27.12 s #8502701191 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 37.69 s < 27.12 s #8502701316 spec/lib/gitlab/database/decomposition/migrate_spec.rb#L103
Gitlab::Database::Decomposition::Migrate#process! when the checks pass copies main database to ci database 28.32 s < 27.12 s #8502701101 spec/lib/search/project_settings_spec.rb#L6
Search results for project settings behaves like all project settings sections exist and have correct anchor links has only valid settings sections 34.51 s < 27.12 s - A deleted user
added rspec:slow test detected label
E2E Test Result Summary
allure-report-publisher
generated test report!e2e-test-on-gdk:
test report for 4043ee2cexpand test summary
+------------------------------------------------------------------+ | suites summary | +-------------+--------+--------+---------+-------+-------+--------+ | | passed | failed | skipped | flaky | total | result | +-------------+--------+--------+---------+-------+-------+--------+ | Create | 240 | 0 | 4 | 0 | 244 | ✅ | | Plan | 148 | 0 | 0 | 0 | 148 | ✅ | | Verify | 86 | 0 | 2 | 0 | 88 | ✅ | | Data Stores | 56 | 0 | 0 | 0 | 56 | ✅ | | Govern | 134 | 0 | 6 | 0 | 140 | ✅ | | Package | 50 | 0 | 0 | 0 | 50 | ✅ | | Monitor | 16 | 0 | 0 | 0 | 16 | ✅ | | Release | 8 | 0 | 0 | 0 | 8 | ✅ | | Manage | 2 | 0 | 0 | 0 | 2 | ✅ | | Secure | 8 | 0 | 0 | 0 | 8 | ✅ | | Fulfillment | 2 | 0 | 0 | 0 | 2 | ✅ | | Analytics | 4 | 0 | 0 | 0 | 4 | ✅ | +-------------+--------+--------+---------+-------+-------+--------+ | Total | 754 | 0 | 12 | 0 | 766 | ✅ | +-------------+--------+--------+---------+-------+-------+--------+
e2e-test-on-cng:
test report for 4043ee2cexpand test summary
+------------------------------------------------------------------+ | suites summary | +-------------+--------+--------+---------+-------+-------+--------+ | | passed | failed | skipped | flaky | total | result | +-------------+--------+--------+---------+-------+-------+--------+ | Verify | 49 | 0 | 16 | 0 | 65 | ✅ | | Package | 24 | 0 | 14 | 0 | 38 | ✅ | | Create | 140 | 0 | 20 | 0 | 160 | ✅ | | Govern | 84 | 0 | 9 | 1 | 93 | ✅ | | Monitor | 8 | 0 | 12 | 0 | 20 | ✅ | | Release | 5 | 0 | 1 | 0 | 6 | ✅ | | Plan | 86 | 0 | 8 | 0 | 94 | ✅ | | Secure | 2 | 0 | 5 | 0 | 7 | ✅ | | Data Stores | 33 | 0 | 10 | 0 | 43 | ✅ | | Fulfillment | 2 | 0 | 7 | 1 | 9 | ✅ | | Manage | 1 | 0 | 9 | 0 | 10 | ✅ | | ModelOps | 0 | 0 | 1 | 0 | 1 | ➖ | | Ai-powered | 0 | 0 | 2 | 0 | 2 | ➖ | | Analytics | 2 | 0 | 0 | 1 | 2 | ✅ | | Growth | 0 | 0 | 2 | 0 | 2 | ➖ | | Configure | 0 | 0 | 3 | 0 | 3 | ➖ | +-------------+--------+--------+---------+-------+-------+--------+ | Total | 436 | 0 | 119 | 3 | 555 | ✅ | +-------------+--------+--------+---------+-------+-------+--------+
@mrincon could you do the frontend review here?
requested review from @mrincon
- Resolved by Marius Bobin
added pipelinetier-3 pipeline:run-e2e-omnibus-once labels and removed pipelinetier-2 label
requested review from @jarka
removed review request for @l.rosa
added databasereviewed label and removed databasereview pending label
added databaseapproved label and removed databasereviewed label
- Resolved by Marius Bobin
- Resolved by Marius Bobin
- Resolved by Marius Bobin
requested review from @mrincon
requested review from @jarka
started a merge train
Hello @mbobin
The database team is looking for ways to improve the database review process and we would love your help!
If you'd be open to someone on the database team reaching out to you for a chat, or if you'd like to leave some feedback asynchronously, just post a reply to this comment mentioning:
@gitlab-org/database-team
And someone will be by shortly!
Thanks for your help!
This message was generated automatically. Improve it or delete it.