Backfill non-instance admins into the organization users table
What does this MR do and why?
Backfill non-instance admins into the organization users table
- for default organization backfill, all users should be in this table. Admins were handled in !142979 (merged)
- We can now do this as we have the user creation/update code in place here
Changelog: changed
DB analysis
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.
Related to #418879 (closed)
Edited by Doug Stull
Merge request reports
Activity
changed milestone to %16.10
assigned to @dstull
- A deleted user
added databasereview pending label
2 Warnings 
New migrations added but db/structure.sql wasn't updated Usually, when adding new migrations, db/structure.sql should be
updated too (unless the migration isn't changing the DB schema
and isn't the most recent one).featureaddition and featureenhancement merge requests normally have a documentation change. Consider adding a documentation update or confirming the documentation plan with the Technical Writer counterpart.
For more information, see:
- The Handbook page on merge request types.
- The definition of done documentation.
Reviewer roulette
Category Reviewer Maintainer backend @mkhalifa3
(UTC+1, 6 hours ahead of author)
@.luke (UTC+13, 18 hours ahead of author)
database @minac (UTC+1, 6 hours ahead of author)
@Quintasan (UTC+1, 6 hours ahead of author)
Please check reviewer's status!
-
Reviewer is available!
-
Reviewer is unavailable!
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-reviewjob that generated this comment.Generated by
Edited by Ghost UserE2E Test Result Summary
allure-report-publishergenerated test report!e2e-test-on-gdk:
expand test summary
+------------------------------------------------------------------+ | suites summary | +-------------+--------+--------+---------+-------+-------+--------+ | | passed | failed | skipped | flaky | total | result | +-------------+--------+--------+---------+-------+-------+--------+ | Govern | 65 | 0 | 1 | 0 | 66 | ✅ | | Data Stores | 31 | 0 | 1 | 0 | 32 | ✅ | | Create | 57 | 0 | 12 | 0 | 69 | ✅ | | Verify | 31 | 0 | 0 | 0 | 31 | ✅ | | Package | 24 | 0 | 2 | 0 | 26 | ✅ | | Plan | 53 | 0 | 0 | 0 | 53 | ✅ | | Monitor | 7 | 0 | 0 | 0 | 7 | ✅ | | Release | 5 | 0 | 0 | 0 | 5 | ✅ | | Analytics | 2 | 0 | 0 | 0 | 2 | ✅ | | Manage | 0 | 0 | 1 | 0 | 1 | ➖ | +-------------+--------+--------+---------+-------+-------+--------+ | Total | 275 | 0 | 17 | 0 | 292 | ✅ | +-------------+--------+--------+---------+-------+-------+--------+e2e-package-and-test:
expand test summary
+---------------------------------------------------------------------+ | suites summary | +----------------+--------+--------+---------+-------+-------+--------+ | | passed | failed | skipped | flaky | total | result | +----------------+--------+--------+---------+-------+-------+--------+ | Create | 548 | 0 | 93 | 18 | 641 | ✅ | | Manage | 39 | 0 | 11 | 3 | 50 | ✅ | | Plan | 246 | 0 | 13 | 0 | 259 | ✅ | | Govern | 271 | 0 | 22 | 0 | 293 | ✅ | | Package | 226 | 0 | 17 | 18 | 243 | ✅ | | Analytics | 7 | 0 | 0 | 0 | 7 | ✅ | | Systems | 8 | 0 | 0 | 0 | 8 | ✅ | | Growth | 0 | 0 | 6 | 0 | 6 | ➖ | | Configure | 1 | 0 | 9 | 0 | 10 | ✅ | | Verify | 138 | 0 | 27 | 6 | 165 | ✅ | | Data Stores | 116 | 0 | 31 | 1 | 147 | ✅ | | Monitor | 36 | 0 | 13 | 0 | 49 | ✅ | | GitLab Metrics | 2 | 0 | 1 | 0 | 3 | ✅ | | Fulfillment | 8 | 0 | 75 | 4 | 83 | ✅ | | Release | 15 | 0 | 3 | 0 | 18 | ✅ | | Secure | 6 | 0 | 3 | 0 | 9 | ✅ | | ModelOps | 0 | 0 | 3 | 0 | 3 | ➖ | +----------------+--------+--------+---------+-------+-------+--------+ | Total | 1667 | 0 | 327 | 50 | 1994 | ✅ | +----------------+--------+--------+---------+-------+-------+--------+Edited by Ghost Useradded 1 commit
- a6825bdd - Backfill non-instance admins into the organization users table
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 20240213210124 - QueueBackfillDefaultOrganizationUsers Post deploy 3.3 s +0.00 B Runtime Histogram for all migrations
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 6 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: 20240213210124 - QueueBackfillDefaultOrganizationUsers
- Type: Post deploy
- Duration: 3.3 s
- Database size change: +0.00 B
Calls Total Time Max Time Mean Time Rows Query 1 9.4 ms 9.4 ms 9.4 ms 1 SELECT MAX("id")
FROM "users"1 7.8 ms 7.8 ms 7.8 ms 1 INSERT INTO "batched_background_migrations" ("created_at", "updated_at", "max_value", "batch_size", "sub_batch_size", "interval", "status", "job_class_name", "table_name", "column_name", "total_tuple_count", "max_batch_size", "started_at", "gitlab_schema", "queued_migration_version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING "id"1 1.9 ms 1.9 ms 1.9 ms 0 SELECT $1 AS one
FROM "batched_background_migrations" WHERE "batched_background_migrations"."job_class_name" = $2 AND "batched_background_migrations"."table_name" = $3 AND "batched_background_migrations"."column_name" = $4 AND (job_arguments = $5) AND "batched_background_migrations"."gitlab_schema" = $6
LIMIT $71 1.7 ms 1.7 ms 1.7 ms 0 SELECT $1 AS one
FROM "batched_background_migrations" WHERE "batched_background_migrations"."job_arguments" = $2 AND "batched_background_migrations"."job_class_name" = $3 AND "batched_background_migrations"."table_name" = $4 AND "batched_background_migrations"."column_name" = $5
LIMIT $61 1.6 ms 1.6 ms 1.6 ms 1 SELECT "feature_gates"."key", "feature_gates"."value" FROM "feature_gates" WHERE "feature_gates"."feature_key" = $1
2 0.0 ms 0.0 ms 0.0 ms 2 SELECT pg_backend_pid()
Histogram for QueueBackfillDefaultOrganizationUsers
Query Runtime Count 0 seconds - 0.01 seconds 0 0.01 seconds - 0.1 seconds 6 0.1 seconds - 1 second 1 1 second - 5 seconds 0 5 seconds - 15 seconds 0 15 seconds - 5 minutes 0 5 minutes + 0 Background Migration: BackfillDefaultOrganizationUsers
Sampled 213 batches. Estimated Time to complete: 1 week, 4 hours, and 26 minutes
- Interval: 120s
- Total tuple count: 15519160
- Max batch size: 10000
- Estimated seconds to complete: 620760s
- Estimated number of batches: 5173
- Average batch time: 4.23s
- Batch size: 3000
- N. of batches sampled: 213
- 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 2556 21768.5 ms 283.8 ms 8.5 ms 638888 INSERT INTO organization_users (user_id, organization_id, access_level, created_at, updated_at) VALUES ($1, $2, $3, current_timestamp, current_timestamp), ($4, $5, $6, current_timestamp, current_timestamp), ($7, $8, $9, current_timestamp, current_timestamp), ($10, $11, $12, current_timestamp, current_timestamp), ($13, $14, $15, current_timestamp, current_timestamp), ($16, $17, $18, current_timestamp, current_timestamp), ($19, $20, $21, current_timestamp, current_timestamp), ($22, $23, $24, current_timestamp, current_timestamp), ($25, $26, $27, current_timestamp, current_timestamp), ($28, $29, $30, current_timestamp, current_timestamp), ($31, $32, $33, current_timestamp, current_timestamp), ($34, $35, $36, current_timestamp, current_timestamp), ($37, $38, $39, current_timestamp, current_timestamp), ($40, $41, $42, current_timestamp, current_timestamp), ($43, $44, $45, current_timestamp, current_timestamp), ($46, $47, $48, current_timestamp, current_timestamp), ($49, $50, $51, current_timestamp, current_timestamp), ($52, $53, $54, current_timestamp, current_timestamp), ($55, $56, $57, current_timestamp, current_timestamp), ($58, $59, $60, current_timestamp, current_timestamp), ($61, $62, $63, current_timestamp, current_timestamp), ($64, $65, $66, current_timestamp, current_timestamp), ($67, $68, $69, current_timestamp, current_timestamp), ($70, $71, $72, current_timestamp, current_timestamp), ($73, $74, $75, current_timestamp, current_timestamp), ($76, $77, $78, current_timestamp, current_timestamp), ($79, $80, $81, current_timestamp, current_timestamp), ($82, $83, $84, current_timestamp, current_timestamp), ($85, $86, $87, current_timestamp, current_timestamp), ($88, $89, $90, current_timestamp, current_timestamp), ($91, $92, $93, current_timestamp, current_timestamp), ($94, $95, $96, current_timestamp, current_timestamp), ($97, $98, $99, current_timestamp, current_timestamp), ($100, $101, $102, current_timestamp, current_timestamp), ($103, $104, $105, current_timestamp, current_timestamp), ($106, $107, $108, current_timestamp, current_timestamp), ($109, $110, $111, current_timestamp, current_timestamp), ($112, $113, $114, current_timestamp, current_timestamp), ($115, $116, $117, current_timestamp, current_timestamp), ($118, $119, $120, current_timestamp, current_timestamp), ($121, $122, $123, current_timestamp, current_timestamp), ($124, $125, $126, current_timestamp, current_timestamp), ($127, $128, $129, current_timestamp, current_timestamp), ($130, $131, $132, current_timestamp, current_timestamp), ($133, $134, $135, current_timestamp, current_timestamp), ($136, $137, $138, current_timestamp, current_timestamp), ($139, $140, $141, current_timestamp, current_timestamp), ($142, $143, $144, current_timestamp, current_timestamp), ($145, $146, $147, current_timestamp, current_timestamp), ($148, $149, $150, current_timestamp, current_timestamp), ($151, $152, $153, current_timestamp, current_timestamp), ($154, $155, $156, current_timestamp, current_timestamp), ($157, $158, $159, current_timestamp, current_timestamp), ($160, $161, $162, current_timestamp, current_timestamp), ($163, $164, $165, current_timestamp, current_timestamp), ($166, $167, $168, current_timestamp, current_timestamp), ($169, $170, $171, current_timestamp, current_timestamp), ($172, $173, $174, current_timestamp, current_timestamp), ($175, $176, $177, current_timestamp, current_timestamp), ($178, $179, $180, current_timestamp, current_timestamp), ($181, $182, $183, current_timestamp, current_timestamp), ($184, $185, $186, current_timestamp, current_timestamp), ($187, $188, $189, current_timestamp, current_timestamp), ($190, $191, $192, current_timestamp, current_timestamp), ($193, $194, $195, current_timestamp, current_timestamp), ($196, $197, $198, current_timestamp, current_timestamp), ($199, $200, $201, current_timestamp, current_timestamp), ($202, $203, $204, current_timestamp, current_timestamp), ($205, $206, $207, current_timestamp, current_timestamp), ($208, $209, $210, current_timestamp, current_timestamp), ($211, $212, $213, current_timestamp, current_timestamp), ($214, $215, $216, current_timestamp, current_timestamp), ($217, $218, $219, current_timestamp, current_timestamp), ($220, $221, $222, current_timestamp, current_timestamp), ($223, $224, $225, current_timestamp, current_timestamp), ($226, $227, $228, current_timestamp, current_timestamp), ($229, $230, $231, current_timestamp, current_timestamp), ($232, $233, $234, current_timestamp, current_timestamp), ($235, $236, $237, current_timestamp, current_timestamp), ($238, $239, $240, current_timestamp, current_timestamp), ($241, $242, $243, current_timestamp, current_timestamp), ($244, $245, $246, current_timestamp, current_timestamp), ($247, $248, $249, current_timestamp, current_timestamp), ($250, $251, $252, current_timestamp, current_timestamp), ($253, $254, $255, current_timestamp, current_timestamp), ($256, $257, $258, current_timestamp, current_timestamp), ($259, $260, $261, current_timestamp, current_timestamp), ($262, $263, $264, current_timestamp, current_timestamp), ($265, $266, $267, current_timestamp, current_timestamp), ($268, $269, $270, current_timestamp, current_timestamp), ($271, $272, $273, current_timestamp, current_timestamp), ($274, $275, $276, current_timestamp, current_timestamp), ($277, $278, $279, current_timestamp, current_timestamp), ($280, $281, $282, current_timestamp, current_timestamp), ($283, $284, $285, current_timestamp, current_timestamp), ($286, $287, $288, current_timestamp, current_timestamp), ($289, $290, $291, current_timestamp, current_timestamp), ($292, $293, $294, current_timestamp, current_timestamp), ($295, $296, $297, current_timestamp, current_timestamp), ($298, $299, $300, current_timestamp, current_timestamp), ($301, $302, $303, current_timestamp, current_timestamp), ($304, $305, $306, current_timestamp, current_timestamp), ($307, $308, $309, current_timestamp, current_timestamp), ($310, $311, $312, current_timestamp, current_timestamp), ($313, $314, $315, current_timestamp, current_timestamp), ($316, $317, $318, current_timestamp, current_timestamp), ($319, $320, $321, current_timestamp, current_timestamp), ($322, $323, $324, current_timestamp, current_timestamp), ($325, $326, $327, current_timestamp, current_timestamp), ($328, $329, $330, current_timestamp, current_timestamp), ($331, $332, $333, current_timestamp, current_timestamp), ($334, $335, $336, current_timestamp, current_timestamp), ($337, $338, $339, current_timestamp, current_timestamp), ($340, $341, $342, current_timestamp, current_timestamp), ($343, $344, $345, current_timestamp, current_timestamp), ($346, $347, $348, current_timestamp, current_timestamp), ($349, $350, $351, current_timestamp, current_timestamp), ($352, $353, $354, current_timestamp, current_timestamp), ($355, $356, $357, current_timestamp, current_timestamp), ($358, $359, $360, current_timestamp, current_timestamp), ($361, $362, $363, current_timestamp, current_timestamp), ($364, $365, $366, current_timestamp, current_timestamp), ($367, $368, $369, current_timestamp, current_timestamp), ($370, $371, $372, current_timestamp, current_timestamp), ($373, $374, $375, current_timestamp, current_timestamp), ($376, $377, $378, current_timestamp, current_timestamp), ($379, $380, $381, current_timestamp, current_timestamp), ($382, $383, $384, current_timestamp, current_timestamp), ($385, $386, $387, current_timestamp, current_timestamp), ($388, $389, $390, current_timestamp, current_timestamp), ($391, $392, $393, current_timestamp, current_timestamp), ($394, $395, $396, current_timestamp, current_timestamp), ($397, $398, $399, current_timestamp, current_timestamp), ($400, $401, $402, current_timestamp, current_timestamp), ($403, $404, $405, current_timestamp, current_timestamp), ($406, $407, $408, current_timestamp, current_timestamp), ($409, $410, $411, current_timestamp, current_timestamp), ($412, $413, $414, current_timestamp, current_timestamp), ($415, $416, $417, current_timestamp, current_timestamp), ($418, $419, $420, current_timestamp, current_timestamp), ($421, $422, $423, current_timestamp, current_timestamp), ($424, $425, $426, current_timestamp, current_timestamp), ($427, $428, $429, current_timestamp, current_timestamp), ($430, $431, $432, current_timestamp, current_timestamp), ($433, $434, $435, current_timestamp, current_timestamp), ($436, $437, $438, current_timestamp, current_timestamp), ($439, $440, $441, current_timestamp, current_timestamp), ($442, $443, $444, current_timestamp, current_timestamp), ($445, $446, $447, current_timestamp, current_timestamp), ($448, $449, $450, current_timestamp, current_timestamp), ($451, $452, $453, current_timestamp, current_timestamp), ($454, $455, $456, current_timestamp, current_timestamp), ($457, $458, $459, current_timestamp, current_timestamp), ($460, $461, $462, current_timestamp, current_timestamp), ($463, $464, $465, current_timestamp, current_timestamp), ($466, $467, $468, current_timestamp, current_timestamp), ($469, $470, $471, current_timestamp, current_timestamp), ($472, $473, $474, current_timestamp, current_timestamp), ($475, $476, $477, current_timestamp, current_timestamp), ($478, $479, $480, current_timestamp, current_timestamp), ($481, $482, $483, current_timestamp, current_timestamp), ($484, $485, $486, current_timestamp, current_timestamp), ($487, $488, $489, current_timestamp, current_timestamp), ($490, $491, $492, current_timestamp, current_timestamp), ($493, $494, $495, current_timestamp, current_timestamp), ($496, $497, $498, current_timestamp, current_timestamp), ($499, $500, $501, current_timestamp, current_timestamp), ($502, $503, $504, current_timestamp, current_timestamp), ($505, $506, $507, current_timestamp, current_timestamp), ($508, $509, $510, current_timestamp, current_timestamp), ($511, $512, $513, current_timestamp, current_timestamp), ($514, $515, $516, current_timestamp, current_timestamp), ($517, $518, $519, current_timestamp, current_timestamp), ($520, $521, $522, current_timestamp, current_timestamp), ($523, $524, $525, current_timestamp, current_timestamp), ($526, $527, $528, current_timestamp, current_timestamp), ($529, $530, $531, current_timestamp, current_timestamp), ($532, $533, $534, current_timestamp, current_timestamp), ($535, $536, $537, current_timestamp, current_timestamp), ($538, $539, $540, current_timestamp, current_timestamp), ($541, $542, $543, current_timestamp, current_timestamp), ($544, $545, $546, current_timestamp, current_timestamp), ($547, $548, $549, current_timestamp, current_timestamp), ($550, $551, $552, current_timestamp, current_timestamp), ($553, $554, $555, current_timestamp, current_timestamp), ($556, $557, $558, current_timestamp, current_timestamp), ($559, $560, $561, current_timestamp, current_timestamp), ($562, $563, $564, current_timestamp, current_timestamp), ($565, $566, $567, current_timestamp, current_timestamp), ($568, $569, $570, current_timestamp, current_timestamp), ($571, $572, $573, current_timestamp, current_timestamp), ($574, $575, $576, current_timestamp, current_timestamp), ($577, $578, $579, current_timestamp, current_timestamp), ($580, $581, $582, current_timestamp, current_timestamp), ($583, $584, $585, current_timestamp, current_timestamp), ($586, $587, $588, current_timestamp, current_timestamp), ($589, $590, $591, current_timestamp, current_timestamp), ($592, $593, $594, current_timestamp, current_timestamp), ($595, $596, $597, current_timestamp, current_timestamp), ($598, $599, $600, current_timestamp, current_timestamp), ($601, $602, $603, current_timestamp, current_timestamp), ($604, $605, $606, current_timestamp, current_timestamp), ($607, $608, $609, current_timestamp, current_timestamp), ($610, $611, $612, current_timestamp, current_timestamp), ($613, $614, $615, current_timestamp, current_timestamp), ($616, $617, $618, current_timestamp, current_timestamp), ($619, $620, $621, current_timestamp, current_timestamp), ($622, $623, $624, current_timestamp, current_timestamp), ($625, $626, $627, current_timestamp, current_timestamp), ($628, $629, $630, current_timestamp, current_timestamp), ($631, $632, $633, current_timestamp, current_timestamp), ($634, $635, $636, current_timestamp, current_timestamp), ($637, $638, $639, current_timestamp, current_timestamp), ($640, $641, $642, current_timestamp, current_timestamp), ($643, $644, $645, current_timestamp, current_timestamp), ($646, $647, $648, current_timestamp, current_timestamp), ($649, $650, $651, current_timestamp, current_timestamp), ($652, $653, $654, current_timestamp, current_timestamp), ($655, $656, $657, current_timestamp, current_timestamp), ($658, $659, $660, current_timestamp, current_timestamp), ($661, $662, $663, current_timestamp, current_timestamp), ($664, $665, $666, current_timestamp, current_timestamp), ($667, $668, $669, current_timestamp, current_timestamp), ($670, $671, $672, current_timestamp, current_timestamp), ($673, $674, $675, current_timestamp, current_timestamp), ($676, $677, $678, current_timestamp, current_timestamp), ($679, $680, $681, current_timestamp, current_timestamp), ($682, $683, $684, current_timestamp, current_timestamp), ($685, $686, $687, current_timestamp, current_timestamp), ($688, $689, $690, current_timestamp, current_timestamp), ($691, $692, $693, current_timestamp, current_timestamp), ($694, $695, $696, current_timestamp, current_timestamp), ($697, $698, $699, current_timestamp, current_timestamp), ($700, $701, $702, current_timestamp, current_timestamp), ($703, $704, $705, current_timestamp, current_timestamp), ($706, $707, $708, current_timestamp, current_timestamp), ($709, $710, $711, current_timestamp, current_timestamp), ($712, $713, $714, current_timestamp, current_timestamp), ($715, $716, $717, current_timestamp, current_timestamp), ($718, $719, $720, current_timestamp, current_timestamp), ($721, $722, $723, current_timestamp, current_timestamp), ($724, $725, $726, current_timestamp, current_timestamp), ($727, $728, $729, current_timestamp, current_timestamp), ($730, $731, $732, current_timestamp, current_timestamp), ($733, $734, $735, current_timestamp, current_timestamp), ($736, $737, $738, current_timestamp, current_timestamp), ($739, $740, $741, current_timestamp, current_timestamp), ($742, $743, $744, current_timestamp, current_timestamp), ($745, $746, $747, current_timestamp, current_timestamp), ($748, $749, $750, current_timestamp, current_timestamp) ON CONFLICT (organization_id, user_id) DO
UPDATE
SET updated_at =
CASE WHEN organization_users.access_level IS NOT DISTINCT
FROM excluded.access_level THEN organization_users.updated_at ELSE current_timestamp END, access_level = excluded.access_level213 264.6 ms 176.2 ms 1.2 ms 213 UPDATE batched_background_migration_jobs
SET updated_at = $1, finished_at = $2, status = $3, metrics = $4
WHERE batched_background_migration_jobs.id = $5426 132.0 ms 45.8 ms 0.3 ms 426 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
213 78.0 ms 26.8 ms 0.4 ms 213 UPDATE batched_background_migration_jobs
SET updated_at = $1, started_at = $2, status = $3, attempts = $4
WHERE batched_background_migration_jobs.id = $52556 1557.9 ms 18.3 ms 0.6 ms 2343 SELECT users.id
FROM users
WHERE users.id BETWEEN $1 AND $2 AND users.admin = $3 AND users.id >= $4
ORDER BY users.id ASC
LIMIT $5
OFFSET $62343 1501.9 ms 15.8 ms 0.6 ms 585750 SELECT users.id
FROM users
WHERE users.id BETWEEN $1 AND $2 AND users.admin = $3 AND users.id >= $4 AND users.id < $5213 142.5 ms 6.1 ms 0.7 ms 53138 SELECT users.id
FROM users
WHERE users.id BETWEEN $1 AND $2 AND users.admin = $3 AND users.id >= $4426 32.2 ms 3.1 ms 0.1 ms 426 SELECT batched_background_migration_jobs.*
FROM batched_background_migration_jobs
WHERE batched_background_migration_jobs.id = $1
LIMIT $2213 30.5 ms 0.6 ms 0.1 ms 213 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)213 10.1 ms 0.2 ms 0.0 ms 213 SELECT users.id
FROM users
WHERE users.id BETWEEN $1 AND $2 AND users.admin = $3
ORDER BY users.id ASC
LIMIT $4213 10.2 ms 0.1 ms 0.0 ms 213 SELECT batched_background_migrations.*
FROM batched_background_migrations
WHERE batched_background_migrations.id = $1
LIMIT $2Histogram of batch runtimes for BackfillDefaultOrganizationUsers
Batch Runtime Count 0 seconds - 10 seconds 213 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 BackfillDefaultOrganizationUsers
Query Runtime Count 0 seconds - 0.1 seconds 9137 0.1 seconds - 0.5 seconds 448 0.5 seconds - 1 second 0 1 second - 2 seconds 0 2 seconds - 5 seconds 0 5 seconds + 0 Other information
No other migrations pending on GitLab.com
Clone details
Clone ID Clone Created At Clone Data Timestamp Expected Removal Time database-testing-2871694-12862711-main2024-02-15T21:30:26Z 2024-02-15T09:19:09Z 2024-02-16 10:06:59 +0000 database-testing-2871694-12862711-ci2024-02-15T21:30:26Z 2024-02-15T20:46:56Z 2024-02-16 10:06:59 +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 20240213210124 - QueueBackfillDefaultOrganizationUsers Post deploy 2.7 s +0.00 B Runtime Histogram for all migrations
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 0 5 minutes + 0 Migration: 20240213210124 - QueueBackfillDefaultOrganizationUsers
- Type: Post deploy
- Duration: 2.7 s
- Database size change: +0.00 B
Calls Total Time Max Time Mean Time Rows Query 2 0.0 ms 0.0 ms 0.0 ms 2 SELECT pg_backend_pid()
Histogram for QueueBackfillDefaultOrganizationUsers
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 0 5 minutes + 0 Other information
No other migrations pending on GitLab.com
Clone details
Clone ID Clone Created At Clone Data Timestamp Expected Removal Time database-testing-2871694-12862711-main2024-02-15T21:30:26Z 2024-02-15T09:19:09Z 2024-02-16 10:06:59 +0000 database-testing-2871694-12862711-ci2024-02-15T21:30:26Z 2024-02-15T20:46:56Z 2024-02-16 10:06:59 +0000
Brought to you by gitlab-org/database-team/gitlab-com-database-testing. Epic
Edited by Ghost User- A deleted user
added database-testing-automation label
Please register or sign in to reply