COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;

[ Date: 2025-10-29 22:02:52 - Database: perf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_restore ]

SELECT /*+ LEADING(gor_0_4 gor_0_3 gor_0_2 gor_0_1 gor_0_0 ) CURSOR_SHARING_EXACT*/ '/260-35/160-37/753-36/547-24/615-24/364' as idPath, gor_0_0.container_num_id as obj_0, 35 as rel_0, gor_0_0.content_num_id as obj_1, 37 as rel_1, gor_0_1.content_num_id as obj_2, 36 as rel_2, gor_0_2.content_num_id as obj_3, 24 as rel_3, gor_0_3.container_num_id as obj_4, 24 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = AND gor_0_2.rel_template_num_id = AND gor_0_2.container_num_id = gor_0_1.content_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.rel_template_num_id = AND gor_0_3.content_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.rel_template_num_id = AND gor_0_4.container_num_id = gor_0_3.container_num_id) INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.content_num_id in (994313, 939017, 1069079, 964614, 979974, 1069083, 980997, 991235, 992259, 990211, 979970, 966683, 1074187, 998417, 967697, 994347, 1106996, 1102904, 977958, 999462, 990245, 981029, 982076, 991292, 971832, 1073190, 967737, 965685, 981043, 991282, 965681, 987212, 965709, 987208, 991300, 965697, 978014, 1073216, 967775, 1109058, 978008, 989272, 965721, 989268, 1071216, 967782, 994407, 982116, 1071226, 998501, 965729, 1074277, 977017, 966775, 1069201, 981126, 1001631, 999583, 975004, 989340, 986265, 1069193, 1071281, 967846, 981158, 1071289, 966820, 1069242, 1069246, 966846, 966842, 997562, 1108134, 972983, 975031, 967883, 994505, 978118, 1001671, 971970, 1001667, 967872, 978112, 1071327, 1071297, 973021, 1102020, 1001683, 975059, 987345, 974063, 1108210, 1069298, 1105144, 998629, 966881, 1067263, 941310, 966911, 1071331, 939258, 967926, 975093, 967922, 975089, 966922, 967944, 1067291, 967966, 978206, 1103104, 988446, 994590, 965915, 1071367, 974105, 941334, 967958, 995604, 978194, 986387, 1000722, 966958, 979246, 988459, 967978, 979242, 969000, 1070390, 979238, 1069375, 978236, 986429, 989498, 967992, 979250, 1067311, 979278, 992591, 989518, 966988, 979274, 979270, 978242, 979266, 968000, 979294, 995679, 1103169, 990557, 1070404, 1071429, 967000, 978262, 979286, 966996, 968020, 998740, 1057100, 941392, 978286, 979310, 979298, 1071485, 978302, 990591, 1057125, 986488, 978294, 974197, 1071467, 978318, 998796, 978314, 1075605, 1098137, 1075611, 979330, 939395, 1098141, 975261, 979354, 994715, 1067399, 1072520, 990613, 979346, 986515, 1075599, 979374, 1072560, 990637, 1000875, 1071542, 973222, 968102, 978342, 1071546, 990627, 968098, 967102, 1072544, 968122, 979386, 986554, 968118, 978358, 979378, 1072556, 983472, 986544, 967116, 1069523, 979402, 940486, 978374, 982469, 968158, 941535, 989660, 970202, 1069511, 986584, 968150, 978388, 1071562, 1069515, 989648, 999888, 968174, 990703, 978412, 1067506, 975339, 996841, 1071606, 968162, 1071612, 940515, 996862, 1071586, 992764, 999930, 975353, 979446, 999926, 979442, 995827, 986610, 979470, 1067536, 969230, 993800, 1075735, 978438, 975367, 1075739, 1095195, 978434, 994819, 996866, 992770, 1101343, 999964, 976413, 1070595, 1071620, 994839, 978454, 978478, 1067570, 1075763, 1101364, 979498, 990763, 992809, 1103416, 1075771, 1095227, 979490, 999999, 978490, 979514, 978506, 979530, 1069653, 1069657, 1075803, 1095259, 970305, 1067586, 986712, 1067598, 1095247, 986704, 1095283, 968298, 979562, 986730, 978536, 1075831, 991843, 979582, 1095267, 994939, 1075813, 1066598, 991863, 969333, 986738, 963185, 1095279, 979598, 986766, 1066641, 994957, 1065618, 1095315, 993931, 1066645, 986760, 1069697, 1075843, 1095299, 969370, 1000091, 979606, 991893, 1072778, 979602, 992914, 994961, 1075855, 1075889, 979626, 1065653, 971432, 1072824, 1073850, 979618, 1074877, 1075901, 991905, 940705, 1101475, 979642, 1075877, 1100456, 1065640, 1095339, 985777, 979662, 989900, 1069779, 1075925, 1108695, 1069783, 1095391, 1000159, 1001182, 1001174, 1095375, 990959, 989934, 1106676, 990955, 988904, 1069815, 995047, 999143, 1000167, 979682, 963298, 1068797, 1068771, 1000187, 1057508, 989946, 1068775, 1000183, 939791, 1000205, 1069843, 986890, 988938, 1069847, 997126, 979714, 983811, 1069853, 983837, 986906, 1001242, 1069831, 986902, 1001238, 990997, 1072906, 1069835, 991020, 1067828, 994090, 992039, 1068858, 983845, 979746, 992035, 1001250, 991009, 1069857, 1095459, 971579, 1001274, 1095463, 1067816, 1066796, 1001266, 1095505, 992075, 980808, 970568, 1066838, 991046, 1095513, 980804, 1100635, 1068893, 980800, 971614, 980828, 1000279, 980820, 992083, 1095501, 993105, 982894, 940911, 986990, 980836, 979810, 966498, 979838, 989054, 987004, 989050, 998265, 999288, 994164, 990068, 980848, 990094, 1067924, 987014, 979842, 984962, 976799, 1000348, 979866, 966553, 979862, 980887, 1000340, 982929, 1000336, 979882, 1108918, 980905, 986023, 1074082, 979898, 980923, 1068965, 987064, 990159, 1065942, 980959, 987096, 1106887, 1103816, 994287, 1068019, 991211, 990185, 1069047, 1068023, 970726, 989159, 1103866, 994275, 1000418, 990203, 1108964, 989177, 966647, 967668, 990197, 1068011, 1000434, 1068015) AND gob_0_0.OBJ_STATE IS NULL UNION ALL SELECT /*+ LEADING(gor_0_4 gor_0_3 gor_0_2 gor_0_1 gor_0_0 ) CURSOR_SHARING_EXACT*/ '/260-35/160-37/753-18/452-13/615-24/364' as idPath, gor_0_0.container_num_id as obj_0, 35 as rel_0, gor_0_0.content_num_id as obj_1, 37 as rel_1, gor_0_1.content_num_id as obj_2, 18 as rel_2, gor_0_2.content_num_id as obj_3, 13 as rel_3, gor_0_3.content_num_id as obj_4, 24 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = AND gor_0_2.rel_template_num_id = AND gor_0_2.container_num_id = gor_0_1.content_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.CONTENT_TEMPLATE_NUM_ID = AND gor_0_3.rel_template_num_id = AND gor_0_3.container_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.rel_template_num_id = AND gor_0_4.container_num_id = gor_0_3.content_num_id) INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.content_num_id in (994313, 939017, 1069079, 964614, 979974, 1069083, 980997, 991235, 992259, 990211, 979970, 966683, 1074187, 998417, 967697, 994347, 1106996, 1102904, 977958, 999462, 990245, 981029, 982076, 991292, 971832, 1073190, 967737, 965685, 981043, 991282, 965681, 987212, 965709, 987208, 991300, 965697, 978014, 1073216, 967775, 1109058, 978008, 989272, 965721, 989268, 1071216, 967782, 994407, 982116, 1071226, 998501, 965729, 1074277, 977017, 966775, 1069201, 981126, 1001631, 999583, 975004, 989340, 986265, 1069193, 1071281, 967846, 981158, 1071289, 966820, 1069242, 1069246, 966846, 966842, 997562, 1108134, 972983, 975031, 967883, 994505, 978118, 1001671, 971970, 1001667, 967872, 978112, 1071327, 1071297, 973021, 1102020, 1001683, 975059, 987345, 974063, 1108210, 1069298, 1105144, 998629, 966881, 1067263, 941310, 966911, 1071331, 939258, 967926, 975093, 967922, 975089, 966922, 967944, 1067291, 967966, 978206, 1103104, 988446, 994590, 965915, 1071367, 974105, 941334, 967958, 995604, 978194, 986387, 1000722, 966958, 979246, 988459, 967978, 979242, 969000, 1070390, 979238, 1069375, 978236, 986429, 989498, 967992, 979250, 1067311, 979278, 992591, 989518, 966988, 979274, 979270, 978242, 979266, 968000, 979294, 995679, 1103169, 990557, 1070404, 1071429, 967000, 978262, 979286, 966996, 968020, 998740, 1057100, 941392, 978286, 979310, 979298, 1071485, 978302, 990591, 1057125, 986488, 978294, 974197, 1071467, 978318, 998796, 978314, 1075605, 1098137, 1075611, 979330, 939395, 1098141, 975261, 979354, 994715, 1067399, 1072520, 990613, 979346, 986515, 1075599, 979374, 1072560, 990637, 1000875, 1071542, 973222, 968102, 978342, 1071546, 990627, 968098, 967102, 1072544, 968122, 979386, 986554, 968118, 978358, 979378, 1072556, 983472, 986544, 967116, 1069523, 979402, 940486, 978374, 982469, 968158, 941535, 989660, 970202, 1069511, 986584, 968150, 978388, 1071562, 1069515, 989648, 999888, 968174, 990703, 978412, 1067506, 975339, 996841, 1071606, 968162, 1071612, 940515, 996862, 1071586, 992764, 999930, 975353, 979446, 999926, 979442, 995827, 986610, 979470, 1067536, 969230, 993800, 1075735, 978438, 975367, 1075739, 1095195, 978434, 994819, 996866, 992770, 1101343, 999964, 976413, 1070595, 1071620, 994839, 978454, 978478, 1067570, 1075763, 1101364, 979498, 990763, 992809, 1103416, 1075771, 1095227, 979490, 999999, 978490, 979514, 978506, 979530, 1069653, 1069657, 1075803, 1095259, 970305, 1067586, 986712, 1067598, 1095247, 986704, 1095283, 968298, 979562, 986730, 978536, 1075831, 991843, 979582, 1095267, 994939, 1075813, 1066598, 991863, 969333, 986738, 963185, 1095279, 979598, 986766, 1066641, 994957, 1065618, 1095315, 993931, 1066645, 986760, 1069697, 1075843, 1095299, 969370, 1000091, 979606, 991893, 1072778, 979602, 992914, 994961, 1075855, 1075889, 979626, 1065653, 971432, 1072824, 1073850, 979618, 1074877, 1075901, 991905, 940705, 1101475, 979642, 1075877, 1100456, 1065640, 1095339, 985777, 979662, 989900, 1069779, 1075925, 1108695, 1069783, 1095391, 1000159, 1001182, 1001174, 1095375, 990959, 989934, 1106676, 990955, 988904, 1069815, 995047, 999143, 1000167, 979682, 963298, 1068797, 1068771, 1000187, 1057508, 989946, 1068775, 1000183, 939791, 1000205, 1069843, 986890, 988938, 1069847, 997126, 979714, 983811, 1069853, 983837, 986906, 1001242, 1069831, 986902, 1001238, 990997, 1072906, 1069835, 991020, 1067828, 994090, 992039, 1068858, 983845, 979746, 992035, 1001250, 991009, 1069857, 1095459, 971579, 1001274, 1095463, 1067816, 1066796, 1001266, 1095505, 992075, 980808, 970568, 1066838, 991046, 1095513, 980804, 1100635, 1068893, 980800, 971614, 980828, 1000279, 980820, 992083, 1095501, 993105, 982894, 940911, 986990, 980836, 979810, 966498, 979838, 989054, 987004, 989050, 998265, 999288, 994164, 990068, 980848, 990094, 1067924, 987014, 979842, 984962, 976799, 1000348, 979866, 966553, 979862, 980887, 1000340, 982929, 1000336, 979882, 1108918, 980905, 986023, 1074082, 979898, 980923, 1068965, 987064, 990159, 1065942, 980959, 987096, 1106887, 1103816, 994287, 1068019, 991211, 990185, 1069047, 1068023, 970726, 989159, 1103866, 994275, 1000418, 990203, 1108964, 989177, 966647, 967668, 990197, 1068011, 1000434, 1068015) AND gob_0_0.OBJ_STATE IS NULL;

[ Date: 2025-10-29 02:19:21 - Database: perf_minarm - User: a3d - Remote: 10.7.173.67 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

SELECT /*+ LEADING(gor_0_4 gor_0_3 gor_0_2 gor_0_1 gor_0_0 ) CURSOR_SHARING_EXACT*/ '/260-35/160-37/753-36/547-24/615-24/364' as idPath, gor_0_0.container_num_id as obj_0, 35 as rel_0, gor_0_0.content_num_id as obj_1, 37 as rel_1, gor_0_1.content_num_id as obj_2, 36 as rel_2, gor_0_2.content_num_id as obj_3, 24 as rel_3, gor_0_3.container_num_id as obj_4, 24 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = AND gor_0_2.rel_template_num_id = AND gor_0_2.container_num_id = gor_0_1.content_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.rel_template_num_id = AND gor_0_3.content_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.rel_template_num_id = AND gor_0_4.container_num_id = gor_0_3.container_num_id) INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.content_num_id in (998413, 977930, 978950, 1068061, 1069087, 1073153, 981021, 1102851, 991258, 1069063, 967701, 981013, 958482, 983059, 994351, 970796, 965677, 1099828, 954408, 952360, 965673, 994343, 967717, 991266, 968739, 981025, 967713, 987196, 959546, 996410, 987192, 1069099, 979022, 979018, 949321, 977986, 1073244, 979008, 987200, 951388, 989276, 991318, 967765, 999507, 987216, 965713, 951404, 987243, 943210, 965737, 979046, 941157, 967807, 997500, 985211, 950393, 959600, 994417, 965745, 952462, 939150, 970892, 979078, 951426, 962690, 978051, 974976, 978078, 943260, 969884, 951450, 979098, 979090, 1069234, 943274, 999591, 954535, 939172, 998564, 976035, 1106111, 962748, 1069219, 978106, 967865, 1069223, 991412, 1066158, 986317, 1001675, 979142, 951494, 979138, 944347, 939242, 1071351, 969954, 986339, 981216, 979194, 979190, 965879, 962804, 966897, 968968, 1103130, 966915, 971036, 978202, 1074445, 966928, 951590, 975140, 946469, 998714, 978232, 1071399, 979254, 951606, 982326, 966962, 976176, 978254, 1057104, 981326, 965963, 968008, 1071447, 965959, 989510, 984389, 979290, 968024, 999769, 964953, 974167, 981332, 997712, 950638, 1072496, 1071477, 990569, 977257, 978278, 979302, 1072504, 1071481, 951650, 1072508, 970108, 1071459, 967034, 951674, 958841, 1107306, 978290, 979314, 981363, 980339, 974193, 993676, 940425, 986504, 978310, 967046, 980357, 958853, 1069471, 967070, 965020, 998812, 951706, 1102213, 1069445, 973206, 1069449, 965012, 967060, 1072524, 994705, 1067407, 986540, 1075639, 979366, 1072568, 979362, 951714, 968126, 986558, 981436, 1072548, 981432, 990649, 1075623, 1069479, 951734, 977333, 1067435, 951730, 944562, 1000881, 968142, 1057232, 956874, 965062, 956868, 1000900, 979394, 967106, 988610, 982465, 983488, 951774, 981470, 949724, 1069507, 1075653, 1071558, 945621, 965077, 967122, 968146, 1067468, 968170, 979434, 981482, 978408, 968166, 996837, 981474, 979450, 994811, 970235, 964091, 1072613, 985593, 990713, 992760, 943602, 1069551, 1068563, 994827, 967178, 940550, 968196, 979458, 990723, 988675, 1075743, 1104386, 994843, 979482, 943638, 967190, 979478, 994835, 978450, 979474, 967214, 968233, 1095223, 999974, 1065531, 990753, 978494, 954938, 949819, 994869, 979506, 941617, 1095215, 977487, 1072721, 949837, 3103339, 1075799, 3103335, 1074782, 971329, 982622, 979546, 3103351, 1067594, 1075787, 1095243, 1075791, 994927, 979566, 1069683, 1069687, 1074807, 1095287, 970342, 979558, 1095291, 962144, 1072766, 986720, 1067618, 970364, 960125, 979578, 1095271, 979574, 988790, 978548, 1067626, 1095275, 954994, 979570, 985714, 953968, 966256, 957071, 979594, 1001096, 1095319, 979586, 1069727, 982687, 985757, 991901, 991889, 965264, 1095311, 1075893, 3103367, 1095355, 972478, 979638, 972470, 962228, 1069739, 992947, 986802, 969392, 1065647, 1068759, 979654, 979650, 941763, 1075933, 988894, 1075905, 979674, 989914, 1072838, 1069767, 979670, 952021, 1069775, 979694, 971498, 973546, 993003, 959208, 979686, 978661, 1095419, 999139, 1001186, 967395, 1069823, 979706, 1001208, 1069799, 979702, 1001204, 1068779, 1069803, 1000179, 981744, 1069807, 952078, 1001230, 993037, 979722, 1095447, 979718, 986886, 952066, 970498, 957187, 971520, 969473, 1000223, 1068801, 1001246, 1073924, 979734, 988950, 941844, 1095435, 992017, 978704, 1000209, 979758, 979754, 979750, 1001254, 979774, 995133, 957245, 962365, 978744, 979790, 979786, 962377, 969539, 957249, 979802, 980824, 991065, 1001304, 978772, 967508, 978768, 980816, 978796, 967532, 980844, 970601, 979814, 999266, 980832, 969598, 958333, 967542, 982902, 1000309, 967538, 1067920, 1103761, 975756, 979846, 951175, 958343, 971651, 995201, 990106, 1000344, 950164, 978836, 959378, 992147, 987024, 967598, 1108912, 1099701, 1106871, 991140, 947107, 943009, 987070, 974781, 959418, 962490, 966587, 978872, 977849, 990133, 945073, 952270, 1106897, 945101, 980941, 975816, 953289, 987078, 992198, 1103834, 959426, 981955, 958403, 1103838, 979934, 960479, 995292, 951256, 949205, 1071052, 991215, 966637, 951270, 975842, 1096700, 967676, 979962, 966651, 951288, 974840, 967672, 978934, 978930, 946162, 1095660, 991219, 979954, 1099757) AND gob_0_0.OBJ_STATE IS NULL UNION ALL SELECT /*+ LEADING(gor_0_4 gor_0_3 gor_0_2 gor_0_1 gor_0_0 ) CURSOR_SHARING_EXACT*/ '/260-35/160-37/753-18/452-13/615-24/364' as idPath, gor_0_0.container_num_id as obj_0, 35 as rel_0, gor_0_0.content_num_id as obj_1, 37 as rel_1, gor_0_1.content_num_id as obj_2, 18 as rel_2, gor_0_2.content_num_id as obj_3, 13 as rel_3, gor_0_3.content_num_id as obj_4, 24 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = AND gor_0_2.rel_template_num_id = AND gor_0_2.container_num_id = gor_0_1.content_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.CONTENT_TEMPLATE_NUM_ID = AND gor_0_3.rel_template_num_id = AND gor_0_3.container_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.rel_template_num_id = AND gor_0_4.container_num_id = gor_0_3.content_num_id) INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.content_num_id in (998413, 977930, 978950, 1068061, 1069087, 1073153, 981021, 1102851, 991258, 1069063, 967701, 981013, 958482, 983059, 994351, 970796, 965677, 1099828, 954408, 952360, 965673, 994343, 967717, 991266, 968739, 981025, 967713, 987196, 959546, 996410, 987192, 1069099, 979022, 979018, 949321, 977986, 1073244, 979008, 987200, 951388, 989276, 991318, 967765, 999507, 987216, 965713, 951404, 987243, 943210, 965737, 979046, 941157, 967807, 997500, 985211, 950393, 959600, 994417, 965745, 952462, 939150, 970892, 979078, 951426, 962690, 978051, 974976, 978078, 943260, 969884, 951450, 979098, 979090, 1069234, 943274, 999591, 954535, 939172, 998564, 976035, 1106111, 962748, 1069219, 978106, 967865, 1069223, 991412, 1066158, 986317, 1001675, 979142, 951494, 979138, 944347, 939242, 1071351, 969954, 986339, 981216, 979194, 979190, 965879, 962804, 966897, 968968, 1103130, 966915, 971036, 978202, 1074445, 966928, 951590, 975140, 946469, 998714, 978232, 1071399, 979254, 951606, 982326, 966962, 976176, 978254, 1057104, 981326, 965963, 968008, 1071447, 965959, 989510, 984389, 979290, 968024, 999769, 964953, 974167, 981332, 997712, 950638, 1072496, 1071477, 990569, 977257, 978278, 979302, 1072504, 1071481, 951650, 1072508, 970108, 1071459, 967034, 951674, 958841, 1107306, 978290, 979314, 981363, 980339, 974193, 993676, 940425, 986504, 978310, 967046, 980357, 958853, 1069471, 967070, 965020, 998812, 951706, 1102213, 1069445, 973206, 1069449, 965012, 967060, 1072524, 994705, 1067407, 986540, 1075639, 979366, 1072568, 979362, 951714, 968126, 986558, 981436, 1072548, 981432, 990649, 1075623, 1069479, 951734, 977333, 1067435, 951730, 944562, 1000881, 968142, 1057232, 956874, 965062, 956868, 1000900, 979394, 967106, 988610, 982465, 983488, 951774, 981470, 949724, 1069507, 1075653, 1071558, 945621, 965077, 967122, 968146, 1067468, 968170, 979434, 981482, 978408, 968166, 996837, 981474, 979450, 994811, 970235, 964091, 1072613, 985593, 990713, 992760, 943602, 1069551, 1068563, 994827, 967178, 940550, 968196, 979458, 990723, 988675, 1075743, 1104386, 994843, 979482, 943638, 967190, 979478, 994835, 978450, 979474, 967214, 968233, 1095223, 999974, 1065531, 990753, 978494, 954938, 949819, 994869, 979506, 941617, 1095215, 977487, 1072721, 949837, 3103339, 1075799, 3103335, 1074782, 971329, 982622, 979546, 3103351, 1067594, 1075787, 1095243, 1075791, 994927, 979566, 1069683, 1069687, 1074807, 1095287, 970342, 979558, 1095291, 962144, 1072766, 986720, 1067618, 970364, 960125, 979578, 1095271, 979574, 988790, 978548, 1067626, 1095275, 954994, 979570, 985714, 953968, 966256, 957071, 979594, 1001096, 1095319, 979586, 1069727, 982687, 985757, 991901, 991889, 965264, 1095311, 1075893, 3103367, 1095355, 972478, 979638, 972470, 962228, 1069739, 992947, 986802, 969392, 1065647, 1068759, 979654, 979650, 941763, 1075933, 988894, 1075905, 979674, 989914, 1072838, 1069767, 979670, 952021, 1069775, 979694, 971498, 973546, 993003, 959208, 979686, 978661, 1095419, 999139, 1001186, 967395, 1069823, 979706, 1001208, 1069799, 979702, 1001204, 1068779, 1069803, 1000179, 981744, 1069807, 952078, 1001230, 993037, 979722, 1095447, 979718, 986886, 952066, 970498, 957187, 971520, 969473, 1000223, 1068801, 1001246, 1073924, 979734, 988950, 941844, 1095435, 992017, 978704, 1000209, 979758, 979754, 979750, 1001254, 979774, 995133, 957245, 962365, 978744, 979790, 979786, 962377, 969539, 957249, 979802, 980824, 991065, 1001304, 978772, 967508, 978768, 980816, 978796, 967532, 980844, 970601, 979814, 999266, 980832, 969598, 958333, 967542, 982902, 1000309, 967538, 1067920, 1103761, 975756, 979846, 951175, 958343, 971651, 995201, 990106, 1000344, 950164, 978836, 959378, 992147, 987024, 967598, 1108912, 1099701, 1106871, 991140, 947107, 943009, 987070, 974781, 959418, 962490, 966587, 978872, 977849, 990133, 945073, 952270, 1106897, 945101, 980941, 975816, 953289, 987078, 992198, 1103834, 959426, 981955, 958403, 1103838, 979934, 960479, 995292, 951256, 949205, 1071052, 991215, 966637, 951270, 975842, 1096700, 967676, 979962, 966651, 951288, 974840, 967672, 978934, 978930, 946162, 1095660, 991219, 979954, 1099757) AND gob_0_0.OBJ_STATE IS NULL;

[ Date: 2025-10-29 02:19:21 - Database: perf_minarm - User: a3d - Remote: 10.7.173.67 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

SELECT /*+ LEADING(gor_0_4 gor_0_3 gor_0_2 gor_0_1 gor_0_0 ) CURSOR_SHARING_EXACT*/ '/260-35/160-37/753-36/547-24/615-24/364' as idPath, gor_0_0.container_num_id as obj_0, 35 as rel_0, gor_0_0.content_num_id as obj_1, 37 as rel_1, gor_0_1.content_num_id as obj_2, 36 as rel_2, gor_0_2.content_num_id as obj_3, 24 as rel_3, gor_0_3.container_num_id as obj_4, 24 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = AND gor_0_2.rel_template_num_id = AND gor_0_2.container_num_id = gor_0_1.content_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.rel_template_num_id = AND gor_0_3.content_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.rel_template_num_id = AND gor_0_4.container_num_id = gor_0_3.container_num_id) INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.content_num_id in (1276434, 850447, 706574, 102404, 1663004, 1281556, 477709, 1665042, 1494554, 3191842, 1116675, 1023005, 820244, 1030679, 308254, 1249289, 1012757, 1480205, 3122737, 121887, 207901, 3142159, 3138062, 3185684, 16933, 1278517, 8231, 1486398, 1062969, 1357375, 1664566, 2672667, 5060216, 5551203, 307776, 1775711, 1725535, 1060950, 3145851, 614981, 81999, 1309276, 266320, 522323, 236122, 1195598, 1526901, 1333366, 1028205, 431717, 78436, 1658492, 3158101, 1059448, 877669, 27242, 212073, 1312890, 1430139, 1594999, 1022079, 1030269, 1035389, 1701482, 1665645, 985211, 1495139, 4187210, 3143255, 1197678, 1281169, 1285270, 3144873, 3123878, 1053338, 1029252, 1527963, 1669271, 1764500, 306836, 1069697, 1030814, 1354886, 1235584, 1390214, 1656961, 1652354, 398491, 403099, 2738356, 1588357, 3161233, 3195026, 323239, 704175, 637614, 1529520, 3139719, 1193661, 3147905, 5994217, 1629868, 500402, 463537, 615102, 1667747, 1447084, 1496236, 1356463, 1721511, 3184781, 3137775, 3179250, 1323735, 81095, 820939, 964806, 1590480, 788164, 1342172, 3184888, 1495775, 546498, 236232, 547012, 1038017, 1663176, 1648843, 1817801, 1359047, 821471, 2385648, 3137785, 804059, 940759, 308954, 1298675, 1724665, 2672847, 2661569, 3143876, 1025763, 1195263, 1814773, 3117248, 6384, 1287393, 261366, 264444, 1789668, 725748, 3183408, 1276690, 962312, 804614, 62732, 199950, 531718, 820483, 1573128, 1785098, 83731, 192279, 877851, 725788, 1725696, 1309961, 898326, 1285902, 961296, 1612089, 476964, 262432, 1023274, 3182359, 1301818, 3189531, 113970, 181047, 1429792, 1432354, 15160, 1482543, 1248041, 211769, 1280813, 119619, 1558869, 1278299, 123720, 846661, 802118, 119626, 3144548, 486729, 313169, 1304389, 983383, 821588, 1689920, 1038678, 1648455, 1061199, 296292, 640872, 1717118, 1770366, 4378916, 470369, 826731, 1289076, 3127112, 1804659, 403310, 961407, 1416039, 1708392, 403314, 1194854, 238458, 1396591, 3137877, 825713, 1076077, 3170638, 1309586, 3144622, 934799, 1571221, 109954, 1288087, 500097, 1669535, 3128232, 4297158, 520576, 1660311, 3137983, 1486727, 848286, 1594764, 702366, 922009, 3174823, 501151, 1030039, 899476, 1526157, 1810817, 1610630, 843666, 1615238, 1038225, 3125680, 809901, 487844, 1471923, 1689020, 1249717, 1520063, 1326526, 1492925, 112557, 1701813, 261550, 803233, 1416120, 1648567, 3187614, 266155, 3146143, 1191335, 7093, 1417122, 980405, 260030, 1725861, 822220, 54211, 7619, 168390, 3184117, 1664476, 1529296, 1325023, 2738658, 1651159, 318422, 939997, 3269604, 3143161, 983000, 1558464, 1415116, 1659840, 200671, 166879, 1558984, 1286643, 3187152, 157667, 1492469, 3126731, 5481909, 1666047, 1287673, 852966, 1023458, 3162078, 3196359, 1063400, 259578, 1433580, 7839116, 3190732, 3183567) AND gob_0_0.OBJ_STATE IS NULL UNION ALL SELECT /*+ LEADING(gor_0_4 gor_0_3 gor_0_2 gor_0_1 gor_0_0 ) CURSOR_SHARING_EXACT*/ '/260-35/160-37/753-18/452-13/615-24/364' as idPath, gor_0_0.container_num_id as obj_0, 35 as rel_0, gor_0_0.content_num_id as obj_1, 37 as rel_1, gor_0_1.content_num_id as obj_2, 18 as rel_2, gor_0_2.content_num_id as obj_3, 13 as rel_3, gor_0_3.content_num_id as obj_4, 24 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = AND gor_0_2.rel_template_num_id = AND gor_0_2.container_num_id = gor_0_1.content_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.CONTENT_TEMPLATE_NUM_ID = AND gor_0_3.rel_template_num_id = AND gor_0_3.container_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.rel_template_num_id = AND gor_0_4.container_num_id = gor_0_3.content_num_id) INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = AND gor_0_4.content_num_id in (1276434, 850447, 706574, 102404, 1663004, 1281556, 477709, 1665042, 1494554, 3191842, 1116675, 1023005, 820244, 1030679, 308254, 1249289, 1012757, 1480205, 3122737, 121887, 207901, 3142159, 3138062, 3185684, 16933, 1278517, 8231, 1486398, 1062969, 1357375, 1664566, 2672667, 5060216, 5551203, 307776, 1775711, 1725535, 1060950, 3145851, 614981, 81999, 1309276, 266320, 522323, 236122, 1195598, 1526901, 1333366, 1028205, 431717, 78436, 1658492, 3158101, 1059448, 877669, 27242, 212073, 1312890, 1430139, 1594999, 1022079, 1030269, 1035389, 1701482, 1665645, 985211, 1495139, 4187210, 3143255, 1197678, 1281169, 1285270, 3144873, 3123878, 1053338, 1029252, 1527963, 1669271, 1764500, 306836, 1069697, 1030814, 1354886, 1235584, 1390214, 1656961, 1652354, 398491, 403099, 2738356, 1588357, 3161233, 3195026, 323239, 704175, 637614, 1529520, 3139719, 1193661, 3147905, 5994217, 1629868, 500402, 463537, 615102, 1667747, 1447084, 1496236, 1356463, 1721511, 3184781, 3137775, 3179250, 1323735, 81095, 820939, 964806, 1590480, 788164, 1342172, 3184888, 1495775, 546498, 236232, 547012, 1038017, 1663176, 1648843, 1817801, 1359047, 821471, 2385648, 3137785, 804059, 940759, 308954, 1298675, 1724665, 2672847, 2661569, 3143876, 1025763, 1195263, 1814773, 3117248, 6384, 1287393, 261366, 264444, 1789668, 725748, 3183408, 1276690, 962312, 804614, 62732, 199950, 531718, 820483, 1573128, 1785098, 83731, 192279, 877851, 725788, 1725696, 1309961, 898326, 1285902, 961296, 1612089, 476964, 262432, 1023274, 3182359, 1301818, 3189531, 113970, 181047, 1429792, 1432354, 15160, 1482543, 1248041, 211769, 1280813, 119619, 1558869, 1278299, 123720, 846661, 802118, 119626, 3144548, 486729, 313169, 1304389, 983383, 821588, 1689920, 1038678, 1648455, 1061199, 296292, 640872, 1717118, 1770366, 4378916, 470369, 826731, 1289076, 3127112, 1804659, 403310, 961407, 1416039, 1708392, 403314, 1194854, 238458, 1396591, 3137877, 825713, 1076077, 3170638, 1309586, 3144622, 934799, 1571221, 109954, 1288087, 500097, 1669535, 3128232, 4297158, 520576, 1660311, 3137983, 1486727, 848286, 1594764, 702366, 922009, 3174823, 501151, 1030039, 899476, 1526157, 1810817, 1610630, 843666, 1615238, 1038225, 3125680, 809901, 487844, 1471923, 1689020, 1249717, 1520063, 1326526, 1492925, 112557, 1701813, 261550, 803233, 1416120, 1648567, 3187614, 266155, 3146143, 1191335, 7093, 1417122, 980405, 260030, 1725861, 822220, 54211, 7619, 168390, 3184117, 1664476, 1529296, 1325023, 2738658, 1651159, 318422, 939997, 3269604, 3143161, 983000, 1558464, 1415116, 1659840, 200671, 166879, 1558984, 1286643, 3187152, 157667, 1492469, 3126731, 5481909, 1666047, 1287673, 852966, 1023458, 3162078, 3196359, 1063400, 259578, 1433580, 7839116, 3190732, 3183567) AND gob_0_0.OBJ_STATE IS NULL;