Backfill p_ci_pipeline_variables from ci_trigger_requests

Tianwen Chenrequested to merge
502767-backfill-variables into master

What does this MR do and why?

This is to copy the historical variables from ci_trigger_requests to p_ci_pipeline_variables.

Execution plan for bulk insert

Click to expand the insert statement 
INSERT INTO "p_ci_pipeline_variables" ("key","value","encrypted_value","encrypted_value_salt","encrypted_value_iv","variable_type","partition_id","raw","pipeline_id","project_id") VALUES ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_LUqVzTs2HR1LcyMRaMDFyA==
', 'aimkj7SwZJVurOg/dpwKlg==
', 1, 100, FALSE, 4733331, 1887345), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_YZPMlK9EVV6f7L0wGGAFKA==
', '90W4EohlE3CHuJ1Zc8fQjA==
', 1, 100, FALSE, 4733331, 1887345), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_BK8YMzjPG4EQbBriX8jdYQ==
', 'R6V/s/KrEUILRIuay7oNeQ==
', 1, 100, FALSE, 4733365, 1042641), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_lCj1nhxyp4DpJr+eVdvq8A==
', 'BNdlAKNXj6CjH7jCGJ7Jhw==
', 1, 100, FALSE, 4733365, 1042641), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_cKbBeUoNt1GqQipeu2ax2g==
', '94yvnpL32zqctewNeFyaBQ==
', 1, 100, FALSE, 4733397, 1169457), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_L0qGRXnUpPwiGB3ojjLJDw==
', '7nxznMkr/yXhgHhOj28Tuw==
', 1, 100, FALSE, 4733397, 1169457), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_0Lon2RvhaI6DvM+0TT0F6Q==
', 'bmJ/+RNuV08r0rmh7zF7YQ==
', 1, 100, FALSE, 4733402, 1535550), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_IRNRa5MUTNn7RYM8Eg6Xuw==
', '/vZUcObTMkvuekM9Hww/yg==
', 1, 100, FALSE, 4733402, 1535550), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_jdoOR90lenXpI7X4t6nWww==
', 'i1BXM/vQxgeF5Qhy5b7V9A==
', 1, 100, FALSE, 4733412, 1589468), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_BuZOCzRiyXc1MU6z6IeIXQ==
', 'ORvmkTDgI07/8U8suwJFfQ==
', 1, 100, FALSE, 4733412, 1589468), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_AgmL5QcEydwAKfz8yYXE7Q==
', 'wvtxUltZILzd1I8n/YghYg==
', 1, 100, FALSE, 4733435, 1762651), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_rmlJgUx34Ef7M5Zpfb57OQ==
', 'ZlNo7r+KhpI3CfMyiiKADA==
', 1, 100, FALSE, 4733435, 1762651), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_EHOd9+ePjAESfqsxJyOoew==
', 'F3spN15yftBSaGP1npiNRA==
', 1, 100, FALSE, 4733448, 1169457), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ZggTyEPWxCGGOjrPokkmWA==
', 'vySr40umI1opQPXPPu5XCA==
', 1, 100, FALSE, 4733448, 1169457), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Rzbz1FiLYjzzHEuOis+gmA==
', 'AuJUw5fxqVnSBzeNPNhQZA==
', 1, 100, FALSE, 4733457, 1682900), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_NdjBI6BrPydVP142GntnLQ==
', 'CkVrdTPriYaPm+krG4oqHQ==
', 1, 100, FALSE, 4733457, 1682900), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ecDZ5iRuyRTJiP+vTub92Q==
', 'br6oXiiegc1ikyS2oJ1fjg==
', 1, 100, FALSE, 4733460, 1875599), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_grO/b51A+bJoDtu1Yz+bCg==
', 'nkgf3KQQS60cNiEr95bVvA==
', 1, 100, FALSE, 4733460, 1875599), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_+3EiRY9l1iFcYztYXR9+Dg==
', 'uRY2//3B47XYx6VMQ6meZQ==
', 1, 100, FALSE, 4733462, 1893608), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_gAWPxBzEyykYehZakung1g==
', 'gDswhVamlnkea+0DGwz2zQ==
', 1, 100, FALSE, 4733462, 1893608), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_E+c+XMnfggkmZQVyfGZ+xw==
', 'ONSLAVU6RJ+ICSune+b+ZA==
', 1, 100, FALSE, 4733469, 1214866), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_HH4iFdTNtCgk4kp4fExVjA==
', 'TTEQXkKNJmqDmDOOY/seiA==
', 1, 100, FALSE, 4733469, 1214866), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_QuclCkdddHotwo+HRHzMIA==
', 'E2PPoz8CsN42R03ywwxyjg==
', 1, 100, FALSE, 4733478, 13083), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_D12mqsLUO3hgDra3S69Sww==
', 'bYxfi7zjFYEWtiA1Ddepng==
', 1, 100, FALSE, 4733478, 13083), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_tnTBHpuoqhP501CS7fbXqg==
', 's5JuIJ7/v3dt+f70qeuVoA==
', 1, 100, FALSE, 4733480, 1676763), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_8adyAzHCWHgAGrE1HKLOGA==
', 'Wh/4tIwcaNfdVdLrdHoWrQ==
', 1, 100, FALSE, 4733480, 1676763), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_zNK4cIqsqDZbr86KEfOcfg==
', 'TFeuRL8n5z2/J0MY2cmPdA==
', 1, 100, FALSE, 4733499, 1644503), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_42ZqD4LCnyc9mmw4IrLl1g==
', 'tneueQ+hkYA4YEzeWQAkEg==
', 1, 100, FALSE, 4733499, 1644503), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_pwPwO3F/4NWVhAbR1Ggh1A==
', 'uxEFkYHTQcdf1dp3qC+zpQ==
', 1, 100, FALSE, 4733498, 1853882), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_2ctamHZcjpQsL9GTA7rAnA==
', 'syxAHTD5ss2DuD25ajCcAw==
', 1, 100, FALSE, 4733498, 1853882), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_qzutLI83EGjB6ptYM00bTQ==
', 'mg2rK+pKW6H6AtLXNIv/5Q==
', 1, 100, FALSE, 4733507, 1519872), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_jOb9ZMIUE29d/qxDiTCMtQ==
', 'tGJFNs+pmmIPajXHw4UUVw==
', 1, 100, FALSE, 4733507, 1519872), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_i7GYqF6AFhtIhZtRRtZSWA==
', 'ALMHsdI/sD1nq7AP7nUEOA==
', 1, 100, FALSE, 4733508, 1594479), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_aew1GT046Tv1buqTOiztCA==
', 'rR9sGdwDtTYGba8UiZ7fvQ==
', 1, 100, FALSE, 4733508, 1594479), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_M76CVK2CygcK9h+/XtcdGw==
', 'lTmxC5UkYMw3ufoBVi5dpg==
', 1, 100, FALSE, 4733512, 1762651), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_oyyQ9mqK+f4yayLQ4o4BbA==
', 't1sQ/vbN0xaKAU5eLAR4wg==
', 1, 100, FALSE, 4733512, 1762651), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_RYwgIQz0nbbhVzaxjFTl7w==
', 'cqcRSV+xf66QmCRNu+BlQA==
', 1, 100, FALSE, 4730071, 1635327), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_HrtLbPCgpq8JR3QX3Ig0qg==
', 'hA0tLTdAkC2brANz+fCWKA==
', 1, 100, FALSE, 4730071, 1635327), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_uQqQ0U6IQoXI7R4CAnMTrw==
', 'POmXx+8pKpih/fjlb+oekQ==
', 1, 100, FALSE, 4733537, 1682900), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_qgBPmIy1UuCaF7PVqNVLzQ==
', 'xXATL+FhasCdgacz7PPVOg==
', 1, 100, FALSE, 4733537, 1682900), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_SEzYnn6rJuRKVyP5u9+Lqw==
', 'kh5jo4FWqKvj31mgTZPpWg==
', 1, 100, FALSE, 4733528, 1893445), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_dg5Z0USevoKocWQE4B9ANQ==
', 'fQsjzPQw3q1JJ9w2XS0R1A==
', 1, 100, FALSE, 4733528, 1893445), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_uLatAGM/mREqujLj2RPFnQ==
', '5xzhLPL/q9Dqe7ysPZUcGQ==
', 1, 100, FALSE, 4733549, 1214866), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_1XwDHmxAqi3t4FVbMMtABQ==
', 'mOep0J/4woBzBZRLOoZ01Q==
', 1, 100, FALSE, 4733549, 1214866), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_LQ5y24u9SEHtDVnKiLmJLA==
', 'iR3G1PS2gbJtsju5r+eNCw==
', 1, 100, FALSE, 4733551, 95278), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_yxOxJX8T8eRfa0TrCIdZqA==
', 'DaYFDEZ/b6MsHQcA17+sdQ==
', 1, 100, FALSE, 4733551, 95278), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_qrgpktxGnCgrYG73Gof8rA==
', 'Yln9FsPvmWYhPpJvsLd0sQ==
', 1, 100, FALSE, 4733544, 1892050), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_HnX5wOUAupxH369fsDX/JQ==
', '/rryU+zoMxorjkJww91jOg==
', 1, 100, FALSE, 4733544, 1892050), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_6u6HgAmkdniKm2tyXJ2ZLg==
', 'TuQG99kOQYjfF4X2ipC/kw==
', 1, 100, FALSE, 4732799, 1836963), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_+kJYqx6cikpqwphfb8ebuw==
', 'NOmO5MK5LUF+LHorO6iL1A==
', 1, 100, FALSE, 4732799, 1836963), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_GSObxf8VxXaJaN8WPbeJzQ==
', 'CvgdTLtSPB7qtTTOSBnEBQ==
', 1, 100, FALSE, 4733569, 1570676), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_YEOEgoGNvrzhrvw+hjaijg==
', '+ENITiYTLskF59pMi31Gzg==
', 1, 100, FALSE, 4733569, 1570676), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_V5LXrVKrV3Gx/lOZiPuWZQ==
', 'RQmAOqbqfN8bCcqgFd9oFw==
', 1, 100, FALSE, 4733576, 1227519), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_25A/HXAlx22bwYSi9MS7AQ==
', 'yzWoGZdX4jSuFuaJLa0kLg==
', 1, 100, FALSE, 4733576, 1227519), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_BwWSoYSLVZTmXTzQ/6oe6Q==
', 'XsyX/MVPUpSa/mw4I1mgQg==
', 1, 100, FALSE, 4733617, 1409835), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_KqbXZHNI79OKd+LJiE34qQ==
', 'yBNox3k9OaM/6rub8jklNw==
', 1, 100, FALSE, 4733617, 1409835), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_493DNv6eWdCg5cIEHqa9ZQ==
', 'p3GsDpSBEWVEZy8QIwtI8w==
', 1, 100, FALSE, 4733618, 1594479), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_SjU3/e2epu0OZ++VK9H4/A==
', 'RFN+zCITyTyiMvgJVwX4yQ==
', 1, 100, FALSE, 4733618, 1594479), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_OCEpOkfGnK5JSDgiwEJp0A==
', 'M+sbHmp8oZnznV8XpNAH0A==
', 1, 100, FALSE, 4733619, 1881538), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_iH3d09dmWHhXv4n8mJsbuQ==
', 'C1OJSKX1DanKEEg1IPcGug==
', 1, 100, FALSE, 4733619, 1881538), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_UycmS2YxxWKUN2ICOds/Zw==
', 'uiY4SKiK7p7CPg4exPwFdQ==
', 1, 100, FALSE, 4733620, 1722680), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_FN27xmELf3Gq5+aVhlXQyQ==
', 'TQxBsma3Gmetsio1tvSmYg==
', 1, 100, FALSE, 4733620, 1722680), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_GfcUmJ2slip3PwEQ2aEl1g==
', 'OllhVz/KnXZIwl0SXnKPqA==
', 1, 100, FALSE, 4733598, 1886925), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_7UItCISnLEdFTCEsZx6F7Q==
', 'dFOADX7D9/i0DC9YfYkaOQ==
', 1, 100, FALSE, 4733598, 1886925), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_gRmnui0t9GzJEV9TbK682w==
', 'IjJV3AhWDN0USaYKFG1FAA==
', 1, 100, FALSE, 4733631, 1272301), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_yfX7RDeVnhuwPL6bUl+rsA==
', 'nXQqKz6E6vaG0ALu8mCPMg==
', 1, 100, FALSE, 4733631, 1272301), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_D7x1JPzVlte+qRcSKrZUxQ==
', 'oRmXgTyEFfHFIuhfL3SoXw==
', 1, 100, FALSE, 4733634, 1578524), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ADujVKvBWQFDaHdgPDQeaQ==
', 'sDG8aGZ6rmpzwreimQuTJQ==
', 1, 100, FALSE, 4733634, 1578524), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Mmvd5ZdlLXX6KB4TCuzeJQ==
', 'nZ3C46qvHURZ8l4sGyNn9Q==
', 1, 100, FALSE, 4733644, 135653), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_6OMsMCEZZY5tx79cEhQTMw==
', 'y9ek7AQf0SxVm72dYflrCw==
', 1, 100, FALSE, 4733644, 135653), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_e+oOKfADuWjQY9U1KG6gFg==
', 'UEtjtiv5cTwYW9bhHS9hBg==
', 1, 100, FALSE, 4733643, 1854877), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ndJgVwDtTipdT2oyrw6Eeg==
', '4OsYy5NuAbdeoHxFSFJVPg==
', 1, 100, FALSE, 4733643, 1854877), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_zMhioV9GVnMHGwf5d4gNkg==
', 'k6bgO1tDmmXAQNZ1HQi16g==
', 1, 100, FALSE, 4733647, 1854877), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_k0GFYq7GzMz4lmeiLucymQ==
', 'hAlTxr/oiP5SUWoUI2TE4w==
', 1, 100, FALSE, 4733647, 1854877), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_nauyUxbY/aln112hr16uYA==
', 'BFciZTCLAEVCdYSan2wX6g==
', 1, 100, FALSE, 4733650, 1522013), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_BHc9LPti+lViwCl2kBqGag==
', 'qWwEfODMJoMuToqYeY0+IQ==
', 1, 100, FALSE, 4734125, 1715534), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ptvq32uQLaktZXV/P82KKA==
', '8Kn5wKNryitC4KtYOpOjOw==
', 1, 100, FALSE, 4734301, 842546), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_zD+3Xdv8qDS9aZPSoQ1WKw==
', 'CVqiYIQ6B82/6nsuh4xdQA==
', 1, 100, FALSE, 4734322, 1409835), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_In+B+6hRB6jljzmHgFPMbw==
', 'oUr3aazHgg+0HJbrQ0qEDg==
', 1, 100, FALSE, 4735265, 1887345), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_0O3/P/Cz93sDaCiQeMmj4g==
', 'GvT7sD78VOr/dEQff5ZQbQ==
', 1, 100, FALSE, 4735291, 1896784), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ME2QAdLXlnv3UpMoPmu2cA==
', 'eGALN/eTPbFEqk7NnZFPag==
', 1, 100, FALSE, 4735293, 1831936), ('REPO_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Eit7OqV31oGF1u0NB/gWYg==
', 'kyp5AZuEMW6Hd7f3NkjU2A==
', 1, 100, FALSE, 4735457, 115583), ('REPO_DIST', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ZsebcUyPHz8eL6UVyA7mRg==
', 'E1gCvpJzpmndqo+x4h6t5Q==
', 1, 100, FALSE, 4735457, 115583), ('PROJECT', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_sNFlUZJbVYl5DxGFanIS/A==
', 'aHc3CqrtbUugrejW08xddw==
', 1, 100, FALSE, 4735457, 115583), ('STAGE', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_SaZw379IcQ2M+5rqip62pA==
', 'JshURnqSoVe3rbngjY6Ysw==
', 1, 100, FALSE, 4735457, 115583), ('REF', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_5eGSxAme99n5z0Taj5g6kA==
', 'IucuZ4fev+YJFvULfobI/w==
', 1, 100, FALSE, 4735457, 115583), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_RjZeaSqu2cPmitEnv5s7Wg==
', 'wCCQkN1ZgI1Uq9Xj/e2gRA==
', 1, 100, FALSE, 4735469, 115583), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_QYHvXeIco/wi9Y8V+YSFzw==
', 'jyocsGWFOIxRU5Um0QbSyg==
', 1, 100, FALSE, 4735478, 115583), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_bibj4AB1Wsz2D1MyqTJEgg==
', 'CSdTAYbT5Pb1DuQgVTGJ1A==
', 1, 100, FALSE, 4735517, 115583), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_W8BgaG6hn7ySYLwQs+L21A==
', 'GoGDswDyqaV7j/U5D53FgQ==
', 1, 100, FALSE, 4735517, 115583), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_PJTgSu2H8wjVgmD0uC5Tdw==
', 'UwGSwvwbyo+nn669zyEnUA==
', 1, 100, FALSE, 4735518, 115583), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ATEZsiH006F7AB91xUROUg==
', '7F3rt7c/TFaCbMRxSictHQ==
', 1, 100, FALSE, 4735518, 115583), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_dYmo2ciV/mnqFBZxAbX2nA==
', 'UMXWPXNaRSisjzX/W9HQnA==
', 1, 100, FALSE, 4735551, 115583), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_frtxr7vXbuZQ2Bmp4UXbgg==
', 'QK3KbmDa0Kiq7ixdzYOZAg==
', 1, 100, FALSE, 4735589, 115583), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_B7fgq5/fZX2OzEc7BcKvUg==
', '/m3J/R0gGugP7vwfAlNRTQ==
', 1, 100, FALSE, 4735592, 115583), ('TAGS', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_RCnf460OhambRzM2Vpr/KA==
', 'HtzVv3+nV1C0Uem9DFEwWA==
', 1, 100, FALSE, 4735597, 115583), ('CONSUL_BUILD_KEY', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_SwfPiQEKhjPpvqCLHudy8g==
', 'ontFVp5M79E6QDGZpmqdyA==
', 1, 100, FALSE, 4735948, 13083), ('ENV', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_l+zftoGyBhWuaDtZNbecBw==
', 'F40X5cpsaUnOWOmfGCaw/A==
', 1, 100, FALSE, 4735948, 13083), ('BUILD_CACHE', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_yt06gY5tPVl7XdUIYrQV3Q==
', 'DaVjxUJha9x6mxzWJx3Kvg==
', 1, 100, FALSE, 4736799, 1867194), ('opt', NULL, '', NULL, NULL, 1, 100, FALSE, 4736799, 1867194), ('IMG', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Q7Dz9xVgsqXOnyUXEiQBcQ==
', 'LkAR7aWr8j2+RnIbMiz40Q==
', 1, 100, FALSE, 4736799, 1867194), ('BUILD_CACHE', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_D6sgFtlTymYZGeEg/OakVA==
', 'RUgYXp+UChTYcaWSYpTeIQ==
', 1, 100, FALSE, 4736856, 1075625), ('opt', NULL, '', NULL, NULL, 1, 100, FALSE, 4736856, 1075625), ('IMG', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_j7/a8jUo2bEMfRYBydVfyw==
', 'xntTXN9qkqgdgucVvmOG8w==
', 1, 100, FALSE, 4736856, 1075625), ('BUILD_CACHE', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_5IGTSLCHXvWKc8i3xrRzog==
', 'Ue60xv98AKrp6L4bCNqjSA==
', 1, 100, FALSE, 4737044, 1864232), ('opt', NULL, '', NULL, NULL, 1, 100, FALSE, 4737044, 1864232), ('IMG', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_16gfJkOgqGMejPWUmjGSdA==
', '111ZvJ+Cs6pFBiLrEyH4dQ==
', 1, 100, FALSE, 4737044, 1864232), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_c+28MP2VZ1yrIE24G/qmbQ==
', 'DcKoolVTUR08lIc/mkDYtQ==
', 1, 100, FALSE, 4737173, 1590377), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ckZdxyei47QXTETHDe/hqQ==
', 'D537THpDH5HkYUZLaURS5A==
', 1, 100, FALSE, 4737173, 1590377), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_EaVznHLfaJICDi9A2IHTig==
', '7VfBB/23OHFaPRBDJv0z8A==
', 1, 100, FALSE, 4737178, 1605178), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_KJz7sGMoKcfypfZIF3Dz1Q==
', '8FLyj4fuWFSWtxHGwcUupw==
', 1, 100, FALSE, 4737178, 1605178), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_hHfZL3B2Y2LMX/ZugFEs3w==
', 'eVEwNyrkDvqr/DRPyfpBMA==
', 1, 100, FALSE, 4737185, 13083), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_ejg3ynGjNusBTg8urIFUkQ==
', 'hf/Ytfc79IWAo6JDsFQhIw==
', 1, 100, FALSE, 4737185, 13083), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_aTsooQ+TWX2QNmL4y2WB3g==
', 'SIal9D8WXZQ78AOnp4r4Yw==
', 1, 100, FALSE, 4737186, 1006873), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_GzvEp6T8Cmsh8q7bbFtXuw==
', '+qo8g5GfJNf7UL4ThdHHbQ==
', 1, 100, FALSE, 4737186, 1006873), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_dpLitd4NdzitP+7lLWLY5w==
', 'hMexxdM7pN2Vi7PluxE/iw==
', 1, 100, FALSE, 4737194, 1596837), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_JmNUS6fRK7dSN/XrzDKOBA==
', '2qvy9cZlB0Ch2hNWZtQsSQ==
', 1, 100, FALSE, 4737194, 1596837), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_54uBSJ7G+Q4mGomI89Szrw==
', 'd9I8kVA8Rchbh6Kd8gWY2Q==
', 1, 100, FALSE, 4737197, 13083), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_0lWi6GVz4VkUruxgKiuJpw==
', 'i/ezjkr8HdIJ5EzfrJefyA==
', 1, 100, FALSE, 4737197, 13083), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_1V+Wbn5HUrK099mr2QGFLw==
', 'Oh6gGLxC+Al1lRcHIItKpg==
', 1, 100, FALSE, 4737208, 1047214), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Yquo+zz5+catzfEDMiBT3A==
', 'gXEsKtOxe4E9Q9NUKL/ViQ==
', 1, 100, FALSE, 4737208, 1047214), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_sj+n+7tA3MNAfBawNMxMlg==
', 'CNwq3zhTvmb1FTnslY3WkQ==
', 1, 100, FALSE, 4737216, 1857328), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Q3hrmH9dt/vIIBQ5DwEZaw==
', 'JeJBVWZlqrni67II4pCjAA==
', 1, 100, FALSE, 4737216, 1857328), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_1jireQ7vSQojZWpJqCQ+NQ==
', 'pAj6iCo7cOksTrVSJXNMgg==
', 1, 100, FALSE, 4737220, 13083), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Xw2o6P/lzgKWWz0kxuA9OA==
', 'ioBafd9Ml7pQoGEEWYCKew==
', 1, 100, FALSE, 4737220, 13083), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_tPyQioy2qG4Z9omDHrNy1g==
', '6tXlDa/gxx6F10SDotT5MQ==
', 1, 100, FALSE, 4737224, 1150887), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_sgFWLh8mh+2rO690HgwDfA==
', 'pG+8pBfV2DaGY0CqDsA5ig==
', 1, 100, FALSE, 4737224, 1150887), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_o2x4VEGEoHlHVHxI7CKFhQ==
', '3/BFccsWIPlNDCfqd0c19w==
', 1, 100, FALSE, 4737238, 1591562), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_WV1ELg6O2GKLtmpgT/zHwQ==
', 'BV94Slk/xigtcECDoRyV6g==
', 1, 100, FALSE, 4737238, 1591562), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_l0cCcC2ClZJrKDbgntb77g==
', 'km7nL5y/nOcbaDzMneLaeA==
', 1, 100, FALSE, 4737239, 1347754), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Wb7WFQd9S/tLlt9r/WEddQ==
', '1Z5CZhC5FVnvffvlKFUN9w==
', 1, 100, FALSE, 4737239, 1347754), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_tOKZl1Xu004/NB+Z1Sb4OQ==
', 'HOOLvpKNIgAYQD5BnGUqtw==
', 1, 100, FALSE, 4737243, 1635327), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_AhBHvgXvqI5YsYPhQ1r2fA==
', '0JsJNoUCZ3m9w/tarrs0EA==
', 1, 100, FALSE, 4737243, 1635327), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Cef0AHR7GD06/F+ARLmuxQ==
', 'z8OlewJDg6K1rlekZKU03A==
', 1, 100, FALSE, 4737248, 13083), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Usx7MOz7NPtyLRh2/ihQJQ==
', 'oruHhPrJJObzKKSx4bdOSQ==
', 1, 100, FALSE, 4737248, 13083), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_Dm9H8iJhDiEsNL/dqVXkUQ==
', 'c79PiOUgEfxluoqqEP1TeA==
', 1, 100, FALSE, 4737254, 1191787), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_kpWtNS/Gb0YFHwCMEoinvQ==
', 'tPJ5Z80ii85rJWid2TekaA==
', 1, 100, FALSE, 4737254, 1191787), ('FEED_PROVIDER_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_cBww247pI28zzN3n04TRaw==
', 'Fqv23FUjd3ZamdFfR9iB+w==
', 1, 100, FALSE, 4737276, 1165773), ('WEBSHOP_NAME', NULL, 'b3ZlcnJpZGRlbiBjcnlwdG9ncmFt
', '_yKim1bfX0SQPlUQmI4IP/g==
', 'c1Uy5sjZ7sT6iqbDYE4RqA==
', 1, 100, FALSE, 4737276, 1165773) ON CONFLICT ("pipeline_id","key","partition_id") DO UPDATE SET "value"=excluded."value","encrypted_value"=excluded."encrypted_value","encrypted_value_salt"=excluded."encrypted_value_salt","encrypted_value_iv"=excluded."encrypted_value_iv","variable_type"=excluded."variable_type","raw"=excluded."raw","project_id"=excluded."project_id"

plan:

 ModifyTable on public.p_ci_pipeline_variables  (cost=0.00..1.74 rows=0 width=0) (actual time=102.839..102.840 rows=0 loops=1)
   Buffers: shared hit=2831 read=157 dirtied=130 written=3
   WAL: records=707 fpi=125 bytes=996676
   I/O Timings: read=94.134 write=1.024
   ->  Values Scan on "*VALUES*"  (cost=0.00..1.74 rows=139 width=195) (actual time=0.005..0.386 rows=139 loops=1)
         I/O Timings: read=0.000 write=0.000
Trigger RI_ConstraintTrigger_c_31690 for constraint fk_f29c5f4380_p: time=41.064 calls=139
Trigger RI_ConstraintTrigger_c_32933 for constraint fk_rails_507416c33a_p: time=1.808 calls=139
Trigger assign_p_ci_pipeline_variables_id_trigger for constraint : time=1.911 calls=139
Settings: work_mem = '100MB', effective_cache_size = '338688MB', jit = 'off', seq_page_cost = '4', random_page_cost = '1.5'

see https://postgres.ai/console/gitlab/gitlab-production-ci/sessions/34393/commands/106054

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.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Related to #502767 (closed)

Edited by Tianwen Chen

Merge request reports