pgBadger-
Global information
- Generated on Mon Mar 9 09:03:17 2026
- Log file: ./2026-03-06_PT1D.log
- Parsed 2,158 log entries in 1m38s
- Log start from 2026-03-06 08:58:15 to 2026-03-06 09:12:13
-
Overview
Global Stats
- 1 Number of unique normalized queries
- 1 Number of queries
- 6s46ms Total query duration
- 2026-03-06 08:58:22 First query
- 2026-03-06 08:58:22 Last query
- 1 queries/s at 2026-03-06 08:58:22 Query peak
- 6s46ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6s46ms Execute total duration
- 818 Number of events
- 2 Number of unique normalized events
- 735 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 328 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 101 Total number of sessions
- 19 sessions at 2026-03-06 09:06:42 Session peak
- 89d17h53m46s Total duration of sessions
- 21h19m32s Average duration of sessions
- 0 Average queries per session
- 59ms Average queries duration per session
- 21h19m32s Average idle time per session
- 96 Total number of connections
- 5 connections/s at 2026-03-06 08:58:04 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-06 08:58:22 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-06 08:58:22 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 6s46ms Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 06 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 1 0ms 6s46ms 6s46ms 0ms 0ms 6s46ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 06 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 1 0 6s46ms 0ms 0ms 6s46ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 06 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 14 0 0 0.00 0.00% Day Hour Count Average / Second Mar 06 00 9 0.00/s 01 2 0.00/s 02 19 0.01/s 03 17 0.00/s 04 10 0.00/s 05 9 0.00/s 06 0 0.00/s 07 9 0.00/s 08 14 0.00/s 09 4 0.00/s 10 1 0.00/s 14 2 0.00/s Day Hour Count Average Duration Average idle time Mar 06 00 11 1m17s 1m17s 01 2 1m12s 1m12s 02 15 1m21s 1m21s 03 21 1m12s 1m12s 04 10 1m12s 1m12s 05 9 1m14s 1m14s 06 0 0ms 0ms 07 9 1m12s 1m12s 08 12 7d11h17m1s 7d11h17m1s 09 9 5m53s 5m53s 10 1 67ms 67ms 14 2 66ms 66ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-03-06 08:58:04 Date
Connections per database
Key values
- cnrs2 Main Database
- 96 connections Total
-
Sessions
Simultaneous sessions
Key values
- 19 sessions Session Peak
- 2026-03-06 09:06:42 Date
Histogram of session times
Key values
- 92 60000-600000ms duration
Sessions per database
Key values
- cnrs2 Main Database
- 101 sessions Total
Sessions per user
Key values
- a3d Main User
- 101 sessions Total
Sessions per host
Key values
- 10.7.177.87 Main Host
- 101 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 06 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 14 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- public.applicative_lock (277) Main table analyzed (database cnrs2)
- 328 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 06 00 0 36 01 0 35 02 0 35 03 0 35 04 0 36 05 0 34 06 0 35 07 0 36 08 0 40 09 0 6 10 0 0 14 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 1 Total read queries
- 0 Total write queries
Queries by database
Key values
- cnrs2 Main database
- 1 Requests
- 6s46ms (cnrs2)
- Main time consuming database
Queries by user
Key values
- a3d Main user
- 1 Requests
User Request type Count Duration a3d Total 1 6s46ms select 1 6s46ms Duration by user
Key values
- 6s46ms (a3d) Main time consuming user
User Request type Count Duration a3d Total 1 6s46ms select 1 6s46ms Queries by host
Key values
- 10.7.177.87 Main host
- 1 Requests
- 6s46ms (10.7.177.87)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1 Requests
- 6s46ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-06 09:06:18 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Slowest individual queries
Rank Duration Query 1 6s46ms select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($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) Query Parameters: $1 = '14336', $2 = '14337', $3 = '14338', $4 = '14339', $5 = '14342', $6 = '14343', $7 = '14344', $8 = '14345', $9 = '14346', $10 = '92171', $11 = '14347', $12 = '14349', $13 = '161807', $14 = '14350', $15 = '14351', $16 = '14352', $17 = '14353', $18 = '14354', $19 = '161808', $20 = '14355', $21 = '14356', $22 = '14357', $23 = '14358', $24 = '14359', $25 = '14361', $26 = '14363', $27 = '14364', $28 = '14365', $29 = '14366', $30 = '14367', $31 = '71710', $32 = '14368', $33 = '14369', $34 = '14370', $35 = '1286193', $36 = '14371', $37 = '14375', $38 = '14381', $39 = '14384', $40 = '14385', $41 = '14386', $42 = '92210', $43 = '14393', $44 = '14394', $45 = '14396', $46 = '14397', $47 = '14398', $48 = '14399', $49 = '14400', $50 = '65', $51 = '2113', $52 = '14401', $53 = '14402', $54 = '14403', $55 = '14404', $56 = '14405', $57 = '14406', $58 = '14407', $59 = '14408', $60 = '14409', $61 = '14410', $62 = '108619', $63 = '14411', $64 = '14412', $65 = '14413', $66 = '14414', $67 = '122959', $68 = '14416', $69 = '14417', $70 = '14418', $71 = '14419', $72 = '14420', $73 = '14421', $74 = '14422', $75 = '14423', $76 = '14424', $77 = '14428', $78 = '14431', $79 = '14432', $80 = '14433', $81 = '14434', $82 = '14436', $83 = '14437', $84 = '14438', $85 = '14439', $86 = '14440', $87 = '14441', $88 = '14442', $89 = '14443', $90 = '14444', $91 = '14445', $92 = '14446', $93 = '14447', $94 = '14448', $95 = '14449', $96 = '14450', $97 = '104563', $98 = '108659', $99 = '14451', $100 = '14452', $101 = '14453', $102 = '14454', $103 = '14455', $104 = '14456', $105 = '14457', $106 = '122', $107 = '14458', $108 = '14459', $109 = '14460', $110 = '14461', $111 = '14462', $112 = '14463', $113 = '14464', $114 = '104577', $115 = '14465', $116 = '14466', $117 = '14467', $118 = '14471', $119 = '14472', $120 = '14473', $121 = '14474', $122 = '14475', $123 = '14476', $124 = '14477', $125 = '14478', $126 = '14479', $127 = '14480', $128 = '92305', $129 = '14482', $130 = '14483', $131 = '32915', $132 = '14488', $133 = '14489', $134 = '14490', $135 = '67739', $136 = '14491', $137 = '14492', $138 = '14493', $139 = '14494', $140 = '14495', $141 = '14496', $142 = '14497', $143 = '14498', $144 = '92323', $145 = '14499', $146 = '14500', $147 = '14501', $148 = '14502', $149 = '14503', $150 = '14504', $151 = '14505', $152 = '14506', $153 = '14507', $154 = '14508', $155 = '14509', $156 = '92332', $157 = '14511', $158 = '14512', $159 = '14513', $160 = '14514', $161 = '14515', $162 = '14516', $163 = '14517', $164 = '14518', $165 = '14519', $166 = '14520', $167 = '14521', $168 = '14522', $169 = '14523', $170 = '14524', $171 = '14525', $172 = '14526', $173 = '14527', $174 = '14528', $175 = '14529', $176 = '14530', $177 = '14531', $178 = '14532', $179 = '14533', $180 = '14534', $181 = '14535', $182 = '92358', $183 = '14536', $184 = '14537', $185 = '14538', $186 = '14539', $187 = '14540', $188 = '14542', $189 = '14543', $190 = '14544', $191 = '14545', $192 = '14546', $193 = '1280193', $194 = '14547', $195 = '14548', $196 = '14549', $197 = '14550', $198 = '162004', $199 = '14551', $200 = '14552', $201 = '14553', $202 = '14554', $203 = '14555', $204 = '14556', $205 = '14557', $206 = '14558', $207 = '14559', $208 = '14560', $209 = '14561', $210 = '14562', $211 = '14563', $212 = '14564', $213 = '155878', $214 = '14565', $215 = '155879', $216 = '14566', $217 = '14567', $218 = '14568', $219 = '14569', $220 = '14570', $221 = '14571', $222 = '14572', $223 = '14573', $224 = '14574', $225 = '14575', $226 = '90350', $227 = '127214', $228 = '14576', $229 = '14577', $230 = '14578', $231 = '14579', $232 = '14580', $233 = '14581', $234 = '14582', $235 = '14583', $236 = '14584', $237 = '14585', $238 = '14586', $239 = '14587', $240 = '14588', $241 = '14589', $242 = '14590', $243 = '14591', $244 = '14592', $245 = '14593', $246 = '14594', $247 = '14595', $248 = '14596', $249 = '14597', $250 = '14598', $251 = '14599', $252 = '14600', $253 = '14602', $254 = '14603', $255 = '14604', $256 = '14605', $257 = '96524', $258 = '14606', $259 = '14607', $260 = '14608', $261 = '14609', $262 = '96531', $263 = '14611', $264 = '14612', $265 = '125205', $266 = '14613', $267 = '14615', $268 = '14616', $269 = '14617', $270 = '14618', $271 = '14619', $272 = '14620', $273 = '14621', $274 = '108828', $275 = '14622', $276 = '160028', $277 = '14623', $278 = '14624', $279 = '14625', $280 = '14626', $281 = '14627', $282 = '14628', $283 = '14629', $284 = '294', $285 = '14630', $286 = '14631', $287 = '14632', $288 = '14633', $289 = '14634', $290 = '14635', $291 = '14636', $292 = '14637', $293 = '14638', $294 = '14639', $295 = '14640', $296 = '78129', $297 = '14641', $298 = '14642', $299 = '14643', $300 = '14644', $301 = '14645', $302 = '14646', $303 = '14647', $304 = '14648', $305 = '37176', $306 = '14649', $307 = '133435', $308 = '14650', $309 = '14651', $310 = '14652', $311 = '14653', $312 = '14654', $313 = '14655', $314 = '14656', $315 = '133442', $316 = '14657', $317 = '133443', $318 = '14658', $319 = '14659', $320 = '14660', $321 = '14661', $322 = '14662', $323 = '72007', $324 = '14663', $325 = '14664', $326 = '145738', $327 = '14665', $328 = '14666', $329 = '14667', $330 = '14668', $331 = '14669', $332 = '14670', $333 = '14671', $334 = '14672', $335 = '14673', $336 = '14674', $337 = '92499', $338 = '14675', $339 = '162129', $340 = '14676', $341 = '14677', $342 = '14678', $343 = '14679', $344 = '14680', $345 = '14681', $346 = '14682', $347 = '1265993', $348 = '14683', $349 = '14684', $350 = '14685', $351 = '14686', $352 = '14687', $353 = '14688', $354 = '14689', $355 = '14690', $356 = '14691', $357 = '125282', $358 = '14692', $359 = '14693', $360 = '14694', $361 = '14695', $362 = '14696', $363 = '172394', $364 = '14697', $365 = '172395', $366 = '14698', $367 = '164200', $368 = '14699', $369 = '164201', $370 = '14700', $371 = '14701', $372 = '2414', $373 = '14702', $374 = '172396', $375 = '14703', $376 = '172397', $377 = '14704', $378 = '14705', $379 = '14706', $380 = '14707', $381 = '14708', $382 = '14709', $383 = '14711', $384 = '14716', $385 = '14717', $386 = '14722', $387 = '76163', $388 = '14723', $389 = '14724', $390 = '14725', $391 = '14726', $392 = '14727', $393 = '14729', $394 = '14730', $395 = '14732', $396 = '14734', $397 = '14735', $398 = '14736', $399 = '14737', $400 = '14738', $401 = '14742', $402 = '14743', $403 = '14744', $404 = '14745', $405 = '14746', $406 = '14747', $407 = '14748', $408 = '133534', $409 = '14749', $410 = '133535', $411 = '14750', $412 = '14751', $413 = '14752', $414 = '14753', $415 = '14754', $416 = '14755', $417 = '160161', $418 = '14756', $419 = '14757', $420 = '131495', $421 = '14758', $422 = '14759', $423 = '14760', $424 = '14761', $425 = '14762', $426 = '76203', $427 = '14763', $428 = '14764', $429 = '14765', $430 = '14766', $431 = '14767', $432 = '14768', $433 = '14769', $434 = '14770', $435 = '14771', $436 = '14772', $437 = '14773', $438 = '14774', $439 = '14775', $440 = '14776', $441 = '14777', $442 = '14778', $443 = '14779', $444 = '14780', $445 = '14781', $446 = '14782', $447 = '14783', $448 = '14784', $449 = '14785', $450 = '14786', $451 = '14787', $452 = '14788', $453 = '14789', $454 = '14790', $455 = '14791', $456 = '14792', $457 = '14793', $458 = '14794', $459 = '14795', $460 = '14796', $461 = '14797', $462 = '14798', $463 = '14799', $464 = '68046', $465 = '14800', $466 = '14801', $467 = '14802', $468 = '14803', $469 = '4564', $470 = '14804', $471 = '14805', $472 = '14806', $473 = '14807', $474 = '14808', $475 = '14809', $476 = '14810', $477 = '14811', $478 = '14812', $479 = '14813', $480 = '14814', $481 = '14815', $482 = '14817', $483 = '14818', $484 = '14819', $485 = '14820', $486 = '14821', $487 = '14822', $488 = '14823', $489 = '14824', $490 = '14825', $491 = '129512', $492 = '14827', $493 = '14828', $494 = '14829', $495 = '70124', $496 = '14830', $497 = '14831', $498 = '14832', $499 = '14833', $500 = '14834', $501 = '14835', $502 = '14836', $503 = '14837', $504 = '14838', $505 = '14839', $506 = '14840', $507 = '14841', $508 = '14842', $509 = '14843', $510 = '14844', $511 = '14845', $512 = '14846', $513 = '14847', $514 = '14848', $515 = '14849', $516 = '14850', $517 = '14851', $518 = '14852', $519 = '14853', $520 = '14854', $521 = '14855', $522 = '14856', $523 = '14857', $524 = '14858', $525 = '14859', $526 = '14860', $527 = '14861', $528 = '14862', $529 = '527', $530 = '14863', $531 = '14864', $532 = '207390', $533 = '1268273', $534 = '2602', $535 = '556', $536 = '141870', $537 = '129587', $538 = '129588', $539 = '100931', $540 = '66114', $541 = '299602', $542 = '162415', $543 = '82547', $544 = '92790', $545 = '92797', $546 = '164512', $547 = '96938', $548 = '2748', $549 = '96956', $550 = '99007', $551 = '99008', $552 = '162515', $553 = '162519', $554 = '162516', $555 = '162520', $556 = '94952', $557 = '275191', $558 = '6900', $559 = '275193', $560 = '275194', $561 = '275195', $562 = '1215255', $563 = '105222', $564 = '4876', $565 = '162594', $566 = '162595', $567 = '162592', $568 = '162593', $569 = '162598', $570 = '817', $571 = '4936', $572 = '90985', $573 = '142186', $574 = '90998', $575 = '4986', $576 = '338810', $577 = '168849', $578 = '119701', $579 = '70550', $580 = '142238', $581 = '926', $582 = '70558', $583 = '140193', $584 = '5038', $585 = '5040', $586 = '258995', $587 = '258993', $588 = '5043', $589 = '5044', $590 = '1098660', $591 = '5045', $592 = '5046', $593 = '258997', $594 = '5048', $595 = '93112', $596 = '5050', $597 = '5052', $598 = '5053', $599 = '5054', $600 = '82879', $601 = '76734', $602 = '5056', $603 = '961', $604 = '140227', $605 = '5058', $606 = '5060', $607 = '5061', $608 = '5062', $609 = '5063', $610 = '5064', $611 = '5066', $612 = '5068', $613 = '5069', $614 = '5070', $615 = '5071', $616 = '84942', $617 = '5072', $618 = '977', $619 = '82899', $620 = '5076', $621 = '5077', $622 = '5078', $623 = '5080', $624 = '95193', $625 = '185306', $626 = '5081', $627 = '185307', $628 = '5082', $629 = '5083', $630 = '5084', $631 = '185310', $632 = '5085', $633 = '185311', $634 = '5086', $635 = '185308', $636 = '5087', $637 = '185309', $638 = '185314', $639 = '5089', $640 = '5090', $641 = '185312', $642 = '185313', $643 = '5092', $644 = '5093', $645 = '5094', $646 = '5095', $647 = '5096', $648 = '5097', $649 = '5098', $650 = '5099', $651 = '5100', $652 = '93165', $653 = '5101', $654 = '93164', $655 = '5102', $656 = '119791', $657 = '5103', $658 = '76782', $659 = '93166', $660 = '5104', $661 = '5105', $662 = '119792', $663 = '5107', $664 = '5109', $665 = '5110', $666 = '5111', $667 = '142325', $668 = '5112', $669 = '5113', $670 = '115707', $671 = '5115', $672 = '5116', $673 = '5117', $674 = '5118', $675 = '5119', $676 = '5120', $677 = '125953', $678 = '5121', $679 = '125952', $680 = '5122', $681 = '5124', $682 = '5126', $683 = '5127', $684 = '5128', $685 = '5129', $686 = '70669', $687 = '203790', $688 = '130085', $689 = '80932', $690 = '132138', $691 = '132139', $692 = '132142', $693 = '132141', $694 = '103473', $695 = '130103', $696 = '142404', $697 = '142418', $698 = '76883', $699 = '128085', $700 = '341085', $701 = '341084', $702 = '341087', $703 = '341086', $704 = '341080', $705 = '341083', $706 = '160866', $707 = '341092', $708 = '146534', $709 = '341089', $710 = '146535', $711 = '341088', $712 = '341091', $713 = '146533', $714 = '341090', $715 = '146536', $716 = '146537', $717 = '3184', $718 = '126074', $719 = '40067', $720 = '175246', $721 = '175244', $722 = '187542', $723 = '187540', $724 = '187546', $725 = '1227914', $726 = '1177', $727 = '1227915', $728 = '187545', $729 = '1227913', $730 = '103588', $731 = '162993', $732 = '136387', $733 = '136384', $734 = '136392', $735 = '136399', $736 = '136396', $737 = '87272', $738 = '1258', $739 = '341227', $740 = '77063', $741 = '77064', $742 = '77069', $743 = '175386', $744 = '58662', $745 = '175415', $746 = '1260842', $747 = '85318', $748 = '3409', $749 = '335191', $750 = '335190', $751 = '181591', $752 = '95575', $753 = '95574', $754 = '77145', $755 = '181593', $756 = '335193', $757 = '335192', $758 = '130404', $759 = '93545', $760 = '93546', $761 = '144745', $762 = '111997', $763 = '112021', $764 = '112022', $765 = '112026', $766 = '128413', $767 = '128414', $768 = '150947', $769 = '112037', $770 = '112038', $771 = '112041', $772 = '112042', $773 = '77229', $774 = '112047', $775 = '150956', $776 = '112048', $777 = '187830', $778 = '3509', $779 = '187831', $780 = '187829', $781 = '187834', $782 = '187835', $783 = '187832', $784 = '187833', $785 = '112061', $786 = '97724', $787 = '112063', $788 = '112065', $789 = '112064', $790 = '351684', $791 = '351687', $792 = '112068', $793 = '128452', $794 = '112070', $795 = '351689', $796 = '3535', $797 = '363984', $798 = '153044', $799 = '153045', $800 = '3546', $801 = '112092', $802 = '112114', $803 = '126460', $804 = '112126', $805 = '130558', $806 = '151040', $807 = '151041', $808 = '85513', $809 = '85512', $810 = '3608', $811 = '110115', $812 = '116263', $813 = '1244734', $814 = '144949', $815 = '83512', $816 = '97848', $817 = '110136', $818 = '128568', $819 = '142904', $820 = '142905', $821 = '128575', $822 = '333396', $823 = '345687', $824 = '345686', $825 = '97879', $826 = '345693', $827 = '345692', $828 = '345694', $829 = '345689', $830 = '345688', $831 = '345691', $832 = '163442', $833 = '163441', $834 = '58996', $835 = '58997', $836 = '263803', $837 = '93825', $838 = '3715', $839 = '46729', $840 = '46733', $841 = '95889', $842 = '108186', $843 = '128669', $844 = '356008', $845 = '1124009', $846 = '296642', $847 = '3790', $848 = '345808', $849 = '345810', $850 = '159452', $851 = '3816', $852 = '3820', $853 = '132847', $854 = '106223', $855 = '42736', $856 = '106225', $857 = '42737', $858 = '42738', $859 = '132848', $860 = '106226', $861 = '132849', $862 = '175871', $863 = '85760', $864 = '141059', $865 = '175872', $866 = '91911', $867 = '42765', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '42775', $872 = '333597', $873 = '42777', $874 = '333599', $875 = '333598', $876 = '190236', $877 = '1224498', $878 = '1224502', $879 = '83748', $880 = '333600', $881 = '124711', $882 = '333602', $883 = '91959', $884 = '130883', $885 = '91973', $886 = '1240906', $887 = '1242954', $888 = '1242955', $889 = '75611', $890 = '356190', $891 = '75612', $892 = '1242956', $893 = '1261388', $894 = '124791', $895 = '92025', $896 = '14205', $897 = '141185', $898 = '141196', $899 = '57232', $900 = '14225', $901 = '14228', $902 = '77717', $903 = '14229', $904 = '96148', $905 = '14231', $906 = '96150', $907 = '14232', $908 = '96152', $909 = '14234', $910 = '83867', $911 = '14235', $912 = '100253', $913 = '83868', $914 = '14238', $915 = '75679', $916 = '14239', $917 = '14241', $918 = '14242', $919 = '14243', $920 = '276391', $921 = '14244', $922 = '14245', $923 = '14246', $924 = '14247', $925 = '14248', $926 = '14249', $927 = '14250', $928 = '14251', $929 = '14252', $930 = '724927', $931 = '124852', $932 = '128951', $933 = '14264', $934 = '128953', $935 = '14265', $936 = '14266', $937 = '14267', $938 = '128954', $939 = '133049', $940 = '14269', $941 = '14270', $942 = '14272', $943 = '14273', $944 = '14274', $945 = '14275', $946 = '14276', $947 = '1989', $948 = '14277', $949 = '14278', $950 = '491457', $951 = '14279', $952 = '14280', $953 = '14281', $954 = '14282', $955 = '14283', $956 = '14284', $957 = '14285', $958 = '14286', $959 = '14287', $960 = '14288', $961 = '14289', $962 = '14291', $963 = '14292', $964 = '14293', $965 = '14294', $966 = '14295', $967 = '14296', $968 = '14298', $969 = '14299', $970 = '14300', $971 = '14301', $972 = '14302', $973 = '14303', $974 = '14304', $975 = '67553', $976 = '14305', $977 = '14306', $978 = '14307', $979 = '14308', $980 = '14309', $981 = '14311', $982 = '14312', $983 = '14313', $984 = '14315', $985 = '14316', $986 = '14317', $987 = '14320', $988 = '14322', $989 = '14323', $990 = '14324', $991 = '14325', $992 = '14326', $993 = '14327', $994 = '14328', $995 = '14329', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335';[ Date: 2026-03-06 08:58:22 - Database: cnrs2 - User: a3d - Remote: 10.7.177.87 - Application: PostgreSQL JDBC Driver ]
Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5168.42..106913.49 rows=121690 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5135.50 rows=121690 width=0) Index Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[]))Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6s46ms 1 6s46ms 6s46ms 6s46ms select gocp1_0.obj_compo_num_id, gocp1_0.obj_compo_creator, gocp1_0.obj_compo_dcre, gocp1_0.obj_compo_dmaj, gocp1_0.obj_compo_ligne_tab_num_id, gocp1_0.obj_compo_modifier, gocp1_0.obj_compo_num_id_tab, gocp1_0.att_template_category_num_id, gocp1_0.att_template_num_id, gocp1_0.obj_compo_unit_num_id, gocp1_0.obj_compo_value, gocp1_0.obj_num_id from gtp_obj_composition gocp1_0 where gocp1_0.obj_num_id in (...) query parameters: ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 08 1 6s46ms 6s46ms [ User: a3d - Total duration: 6s46ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s46ms - Times executed: 1 ]
-
select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($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) Query Parameters: $1 = '14336', $2 = '14337', $3 = '14338', $4 = '14339', $5 = '14342', $6 = '14343', $7 = '14344', $8 = '14345', $9 = '14346', $10 = '92171', $11 = '14347', $12 = '14349', $13 = '161807', $14 = '14350', $15 = '14351', $16 = '14352', $17 = '14353', $18 = '14354', $19 = '161808', $20 = '14355', $21 = '14356', $22 = '14357', $23 = '14358', $24 = '14359', $25 = '14361', $26 = '14363', $27 = '14364', $28 = '14365', $29 = '14366', $30 = '14367', $31 = '71710', $32 = '14368', $33 = '14369', $34 = '14370', $35 = '1286193', $36 = '14371', $37 = '14375', $38 = '14381', $39 = '14384', $40 = '14385', $41 = '14386', $42 = '92210', $43 = '14393', $44 = '14394', $45 = '14396', $46 = '14397', $47 = '14398', $48 = '14399', $49 = '14400', $50 = '65', $51 = '2113', $52 = '14401', $53 = '14402', $54 = '14403', $55 = '14404', $56 = '14405', $57 = '14406', $58 = '14407', $59 = '14408', $60 = '14409', $61 = '14410', $62 = '108619', $63 = '14411', $64 = '14412', $65 = '14413', $66 = '14414', $67 = '122959', $68 = '14416', $69 = '14417', $70 = '14418', $71 = '14419', $72 = '14420', $73 = '14421', $74 = '14422', $75 = '14423', $76 = '14424', $77 = '14428', $78 = '14431', $79 = '14432', $80 = '14433', $81 = '14434', $82 = '14436', $83 = '14437', $84 = '14438', $85 = '14439', $86 = '14440', $87 = '14441', $88 = '14442', $89 = '14443', $90 = '14444', $91 = '14445', $92 = '14446', $93 = '14447', $94 = '14448', $95 = '14449', $96 = '14450', $97 = '104563', $98 = '108659', $99 = '14451', $100 = '14452', $101 = '14453', $102 = '14454', $103 = '14455', $104 = '14456', $105 = '14457', $106 = '122', $107 = '14458', $108 = '14459', $109 = '14460', $110 = '14461', $111 = '14462', $112 = '14463', $113 = '14464', $114 = '104577', $115 = '14465', $116 = '14466', $117 = '14467', $118 = '14471', $119 = '14472', $120 = '14473', $121 = '14474', $122 = '14475', $123 = '14476', $124 = '14477', $125 = '14478', $126 = '14479', $127 = '14480', $128 = '92305', $129 = '14482', $130 = '14483', $131 = '32915', $132 = '14488', $133 = '14489', $134 = '14490', $135 = '67739', $136 = '14491', $137 = '14492', $138 = '14493', $139 = '14494', $140 = '14495', $141 = '14496', $142 = '14497', $143 = '14498', $144 = '92323', $145 = '14499', $146 = '14500', $147 = '14501', $148 = '14502', $149 = '14503', $150 = '14504', $151 = '14505', $152 = '14506', $153 = '14507', $154 = '14508', $155 = '14509', $156 = '92332', $157 = '14511', $158 = '14512', $159 = '14513', $160 = '14514', $161 = '14515', $162 = '14516', $163 = '14517', $164 = '14518', $165 = '14519', $166 = '14520', $167 = '14521', $168 = '14522', $169 = '14523', $170 = '14524', $171 = '14525', $172 = '14526', $173 = '14527', $174 = '14528', $175 = '14529', $176 = '14530', $177 = '14531', $178 = '14532', $179 = '14533', $180 = '14534', $181 = '14535', $182 = '92358', $183 = '14536', $184 = '14537', $185 = '14538', $186 = '14539', $187 = '14540', $188 = '14542', $189 = '14543', $190 = '14544', $191 = '14545', $192 = '14546', $193 = '1280193', $194 = '14547', $195 = '14548', $196 = '14549', $197 = '14550', $198 = '162004', $199 = '14551', $200 = '14552', $201 = '14553', $202 = '14554', $203 = '14555', $204 = '14556', $205 = '14557', $206 = '14558', $207 = '14559', $208 = '14560', $209 = '14561', $210 = '14562', $211 = '14563', $212 = '14564', $213 = '155878', $214 = '14565', $215 = '155879', $216 = '14566', $217 = '14567', $218 = '14568', $219 = '14569', $220 = '14570', $221 = '14571', $222 = '14572', $223 = '14573', $224 = '14574', $225 = '14575', $226 = '90350', $227 = '127214', $228 = '14576', $229 = '14577', $230 = '14578', $231 = '14579', $232 = '14580', $233 = '14581', $234 = '14582', $235 = '14583', $236 = '14584', $237 = '14585', $238 = '14586', $239 = '14587', $240 = '14588', $241 = '14589', $242 = '14590', $243 = '14591', $244 = '14592', $245 = '14593', $246 = '14594', $247 = '14595', $248 = '14596', $249 = '14597', $250 = '14598', $251 = '14599', $252 = '14600', $253 = '14602', $254 = '14603', $255 = '14604', $256 = '14605', $257 = '96524', $258 = '14606', $259 = '14607', $260 = '14608', $261 = '14609', $262 = '96531', $263 = '14611', $264 = '14612', $265 = '125205', $266 = '14613', $267 = '14615', $268 = '14616', $269 = '14617', $270 = '14618', $271 = '14619', $272 = '14620', $273 = '14621', $274 = '108828', $275 = '14622', $276 = '160028', $277 = '14623', $278 = '14624', $279 = '14625', $280 = '14626', $281 = '14627', $282 = '14628', $283 = '14629', $284 = '294', $285 = '14630', $286 = '14631', $287 = '14632', $288 = '14633', $289 = '14634', $290 = '14635', $291 = '14636', $292 = '14637', $293 = '14638', $294 = '14639', $295 = '14640', $296 = '78129', $297 = '14641', $298 = '14642', $299 = '14643', $300 = '14644', $301 = '14645', $302 = '14646', $303 = '14647', $304 = '14648', $305 = '37176', $306 = '14649', $307 = '133435', $308 = '14650', $309 = '14651', $310 = '14652', $311 = '14653', $312 = '14654', $313 = '14655', $314 = '14656', $315 = '133442', $316 = '14657', $317 = '133443', $318 = '14658', $319 = '14659', $320 = '14660', $321 = '14661', $322 = '14662', $323 = '72007', $324 = '14663', $325 = '14664', $326 = '145738', $327 = '14665', $328 = '14666', $329 = '14667', $330 = '14668', $331 = '14669', $332 = '14670', $333 = '14671', $334 = '14672', $335 = '14673', $336 = '14674', $337 = '92499', $338 = '14675', $339 = '162129', $340 = '14676', $341 = '14677', $342 = '14678', $343 = '14679', $344 = '14680', $345 = '14681', $346 = '14682', $347 = '1265993', $348 = '14683', $349 = '14684', $350 = '14685', $351 = '14686', $352 = '14687', $353 = '14688', $354 = '14689', $355 = '14690', $356 = '14691', $357 = '125282', $358 = '14692', $359 = '14693', $360 = '14694', $361 = '14695', $362 = '14696', $363 = '172394', $364 = '14697', $365 = '172395', $366 = '14698', $367 = '164200', $368 = '14699', $369 = '164201', $370 = '14700', $371 = '14701', $372 = '2414', $373 = '14702', $374 = '172396', $375 = '14703', $376 = '172397', $377 = '14704', $378 = '14705', $379 = '14706', $380 = '14707', $381 = '14708', $382 = '14709', $383 = '14711', $384 = '14716', $385 = '14717', $386 = '14722', $387 = '76163', $388 = '14723', $389 = '14724', $390 = '14725', $391 = '14726', $392 = '14727', $393 = '14729', $394 = '14730', $395 = '14732', $396 = '14734', $397 = '14735', $398 = '14736', $399 = '14737', $400 = '14738', $401 = '14742', $402 = '14743', $403 = '14744', $404 = '14745', $405 = '14746', $406 = '14747', $407 = '14748', $408 = '133534', $409 = '14749', $410 = '133535', $411 = '14750', $412 = '14751', $413 = '14752', $414 = '14753', $415 = '14754', $416 = '14755', $417 = '160161', $418 = '14756', $419 = '14757', $420 = '131495', $421 = '14758', $422 = '14759', $423 = '14760', $424 = '14761', $425 = '14762', $426 = '76203', $427 = '14763', $428 = '14764', $429 = '14765', $430 = '14766', $431 = '14767', $432 = '14768', $433 = '14769', $434 = '14770', $435 = '14771', $436 = '14772', $437 = '14773', $438 = '14774', $439 = '14775', $440 = '14776', $441 = '14777', $442 = '14778', $443 = '14779', $444 = '14780', $445 = '14781', $446 = '14782', $447 = '14783', $448 = '14784', $449 = '14785', $450 = '14786', $451 = '14787', $452 = '14788', $453 = '14789', $454 = '14790', $455 = '14791', $456 = '14792', $457 = '14793', $458 = '14794', $459 = '14795', $460 = '14796', $461 = '14797', $462 = '14798', $463 = '14799', $464 = '68046', $465 = '14800', $466 = '14801', $467 = '14802', $468 = '14803', $469 = '4564', $470 = '14804', $471 = '14805', $472 = '14806', $473 = '14807', $474 = '14808', $475 = '14809', $476 = '14810', $477 = '14811', $478 = '14812', $479 = '14813', $480 = '14814', $481 = '14815', $482 = '14817', $483 = '14818', $484 = '14819', $485 = '14820', $486 = '14821', $487 = '14822', $488 = '14823', $489 = '14824', $490 = '14825', $491 = '129512', $492 = '14827', $493 = '14828', $494 = '14829', $495 = '70124', $496 = '14830', $497 = '14831', $498 = '14832', $499 = '14833', $500 = '14834', $501 = '14835', $502 = '14836', $503 = '14837', $504 = '14838', $505 = '14839', $506 = '14840', $507 = '14841', $508 = '14842', $509 = '14843', $510 = '14844', $511 = '14845', $512 = '14846', $513 = '14847', $514 = '14848', $515 = '14849', $516 = '14850', $517 = '14851', $518 = '14852', $519 = '14853', $520 = '14854', $521 = '14855', $522 = '14856', $523 = '14857', $524 = '14858', $525 = '14859', $526 = '14860', $527 = '14861', $528 = '14862', $529 = '527', $530 = '14863', $531 = '14864', $532 = '207390', $533 = '1268273', $534 = '2602', $535 = '556', $536 = '141870', $537 = '129587', $538 = '129588', $539 = '100931', $540 = '66114', $541 = '299602', $542 = '162415', $543 = '82547', $544 = '92790', $545 = '92797', $546 = '164512', $547 = '96938', $548 = '2748', $549 = '96956', $550 = '99007', $551 = '99008', $552 = '162515', $553 = '162519', $554 = '162516', $555 = '162520', $556 = '94952', $557 = '275191', $558 = '6900', $559 = '275193', $560 = '275194', $561 = '275195', $562 = '1215255', $563 = '105222', $564 = '4876', $565 = '162594', $566 = '162595', $567 = '162592', $568 = '162593', $569 = '162598', $570 = '817', $571 = '4936', $572 = '90985', $573 = '142186', $574 = '90998', $575 = '4986', $576 = '338810', $577 = '168849', $578 = '119701', $579 = '70550', $580 = '142238', $581 = '926', $582 = '70558', $583 = '140193', $584 = '5038', $585 = '5040', $586 = '258995', $587 = '258993', $588 = '5043', $589 = '5044', $590 = '1098660', $591 = '5045', $592 = '5046', $593 = '258997', $594 = '5048', $595 = '93112', $596 = '5050', $597 = '5052', $598 = '5053', $599 = '5054', $600 = '82879', $601 = '76734', $602 = '5056', $603 = '961', $604 = '140227', $605 = '5058', $606 = '5060', $607 = '5061', $608 = '5062', $609 = '5063', $610 = '5064', $611 = '5066', $612 = '5068', $613 = '5069', $614 = '5070', $615 = '5071', $616 = '84942', $617 = '5072', $618 = '977', $619 = '82899', $620 = '5076', $621 = '5077', $622 = '5078', $623 = '5080', $624 = '95193', $625 = '185306', $626 = '5081', $627 = '185307', $628 = '5082', $629 = '5083', $630 = '5084', $631 = '185310', $632 = '5085', $633 = '185311', $634 = '5086', $635 = '185308', $636 = '5087', $637 = '185309', $638 = '185314', $639 = '5089', $640 = '5090', $641 = '185312', $642 = '185313', $643 = '5092', $644 = '5093', $645 = '5094', $646 = '5095', $647 = '5096', $648 = '5097', $649 = '5098', $650 = '5099', $651 = '5100', $652 = '93165', $653 = '5101', $654 = '93164', $655 = '5102', $656 = '119791', $657 = '5103', $658 = '76782', $659 = '93166', $660 = '5104', $661 = '5105', $662 = '119792', $663 = '5107', $664 = '5109', $665 = '5110', $666 = '5111', $667 = '142325', $668 = '5112', $669 = '5113', $670 = '115707', $671 = '5115', $672 = '5116', $673 = '5117', $674 = '5118', $675 = '5119', $676 = '5120', $677 = '125953', $678 = '5121', $679 = '125952', $680 = '5122', $681 = '5124', $682 = '5126', $683 = '5127', $684 = '5128', $685 = '5129', $686 = '70669', $687 = '203790', $688 = '130085', $689 = '80932', $690 = '132138', $691 = '132139', $692 = '132142', $693 = '132141', $694 = '103473', $695 = '130103', $696 = '142404', $697 = '142418', $698 = '76883', $699 = '128085', $700 = '341085', $701 = '341084', $702 = '341087', $703 = '341086', $704 = '341080', $705 = '341083', $706 = '160866', $707 = '341092', $708 = '146534', $709 = '341089', $710 = '146535', $711 = '341088', $712 = '341091', $713 = '146533', $714 = '341090', $715 = '146536', $716 = '146537', $717 = '3184', $718 = '126074', $719 = '40067', $720 = '175246', $721 = '175244', $722 = '187542', $723 = '187540', $724 = '187546', $725 = '1227914', $726 = '1177', $727 = '1227915', $728 = '187545', $729 = '1227913', $730 = '103588', $731 = '162993', $732 = '136387', $733 = '136384', $734 = '136392', $735 = '136399', $736 = '136396', $737 = '87272', $738 = '1258', $739 = '341227', $740 = '77063', $741 = '77064', $742 = '77069', $743 = '175386', $744 = '58662', $745 = '175415', $746 = '1260842', $747 = '85318', $748 = '3409', $749 = '335191', $750 = '335190', $751 = '181591', $752 = '95575', $753 = '95574', $754 = '77145', $755 = '181593', $756 = '335193', $757 = '335192', $758 = '130404', $759 = '93545', $760 = '93546', $761 = '144745', $762 = '111997', $763 = '112021', $764 = '112022', $765 = '112026', $766 = '128413', $767 = '128414', $768 = '150947', $769 = '112037', $770 = '112038', $771 = '112041', $772 = '112042', $773 = '77229', $774 = '112047', $775 = '150956', $776 = '112048', $777 = '187830', $778 = '3509', $779 = '187831', $780 = '187829', $781 = '187834', $782 = '187835', $783 = '187832', $784 = '187833', $785 = '112061', $786 = '97724', $787 = '112063', $788 = '112065', $789 = '112064', $790 = '351684', $791 = '351687', $792 = '112068', $793 = '128452', $794 = '112070', $795 = '351689', $796 = '3535', $797 = '363984', $798 = '153044', $799 = '153045', $800 = '3546', $801 = '112092', $802 = '112114', $803 = '126460', $804 = '112126', $805 = '130558', $806 = '151040', $807 = '151041', $808 = '85513', $809 = '85512', $810 = '3608', $811 = '110115', $812 = '116263', $813 = '1244734', $814 = '144949', $815 = '83512', $816 = '97848', $817 = '110136', $818 = '128568', $819 = '142904', $820 = '142905', $821 = '128575', $822 = '333396', $823 = '345687', $824 = '345686', $825 = '97879', $826 = '345693', $827 = '345692', $828 = '345694', $829 = '345689', $830 = '345688', $831 = '345691', $832 = '163442', $833 = '163441', $834 = '58996', $835 = '58997', $836 = '263803', $837 = '93825', $838 = '3715', $839 = '46729', $840 = '46733', $841 = '95889', $842 = '108186', $843 = '128669', $844 = '356008', $845 = '1124009', $846 = '296642', $847 = '3790', $848 = '345808', $849 = '345810', $850 = '159452', $851 = '3816', $852 = '3820', $853 = '132847', $854 = '106223', $855 = '42736', $856 = '106225', $857 = '42737', $858 = '42738', $859 = '132848', $860 = '106226', $861 = '132849', $862 = '175871', $863 = '85760', $864 = '141059', $865 = '175872', $866 = '91911', $867 = '42765', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '42775', $872 = '333597', $873 = '42777', $874 = '333599', $875 = '333598', $876 = '190236', $877 = '1224498', $878 = '1224502', $879 = '83748', $880 = '333600', $881 = '124711', $882 = '333602', $883 = '91959', $884 = '130883', $885 = '91973', $886 = '1240906', $887 = '1242954', $888 = '1242955', $889 = '75611', $890 = '356190', $891 = '75612', $892 = '1242956', $893 = '1261388', $894 = '124791', $895 = '92025', $896 = '14205', $897 = '141185', $898 = '141196', $899 = '57232', $900 = '14225', $901 = '14228', $902 = '77717', $903 = '14229', $904 = '96148', $905 = '14231', $906 = '96150', $907 = '14232', $908 = '96152', $909 = '14234', $910 = '83867', $911 = '14235', $912 = '100253', $913 = '83868', $914 = '14238', $915 = '75679', $916 = '14239', $917 = '14241', $918 = '14242', $919 = '14243', $920 = '276391', $921 = '14244', $922 = '14245', $923 = '14246', $924 = '14247', $925 = '14248', $926 = '14249', $927 = '14250', $928 = '14251', $929 = '14252', $930 = '724927', $931 = '124852', $932 = '128951', $933 = '14264', $934 = '128953', $935 = '14265', $936 = '14266', $937 = '14267', $938 = '128954', $939 = '133049', $940 = '14269', $941 = '14270', $942 = '14272', $943 = '14273', $944 = '14274', $945 = '14275', $946 = '14276', $947 = '1989', $948 = '14277', $949 = '14278', $950 = '491457', $951 = '14279', $952 = '14280', $953 = '14281', $954 = '14282', $955 = '14283', $956 = '14284', $957 = '14285', $958 = '14286', $959 = '14287', $960 = '14288', $961 = '14289', $962 = '14291', $963 = '14292', $964 = '14293', $965 = '14294', $966 = '14295', $967 = '14296', $968 = '14298', $969 = '14299', $970 = '14300', $971 = '14301', $972 = '14302', $973 = '14303', $974 = '14304', $975 = '67553', $976 = '14305', $977 = '14306', $978 = '14307', $979 = '14308', $980 = '14309', $981 = '14311', $982 = '14312', $983 = '14313', $984 = '14315', $985 = '14316', $986 = '14317', $987 = '14320', $988 = '14322', $989 = '14323', $990 = '14324', $991 = '14325', $992 = '14326', $993 = '14327', $994 = '14328', $995 = '14329', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335';
Date: 2026-03-06 08:58:22 Duration: 6s46ms Database: cnrs2 User: a3d Remote: 10.7.177.87 Application: PostgreSQL JDBC Driver
Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5168.42..106913.49 rows=121690 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5135.50 rows=121690 width=0) Index Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[]))
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1 6s46ms 6s46ms 6s46ms 6s46ms select gocp1_0.obj_compo_num_id, gocp1_0.obj_compo_creator, gocp1_0.obj_compo_dcre, gocp1_0.obj_compo_dmaj, gocp1_0.obj_compo_ligne_tab_num_id, gocp1_0.obj_compo_modifier, gocp1_0.obj_compo_num_id_tab, gocp1_0.att_template_category_num_id, gocp1_0.att_template_num_id, gocp1_0.obj_compo_unit_num_id, gocp1_0.obj_compo_value, gocp1_0.obj_num_id from gtp_obj_composition gocp1_0 where gocp1_0.obj_num_id in (...) query parameters: ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 08 1 6s46ms 6s46ms [ User: a3d - Total duration: 6s46ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s46ms - Times executed: 1 ]
-
select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($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) Query Parameters: $1 = '14336', $2 = '14337', $3 = '14338', $4 = '14339', $5 = '14342', $6 = '14343', $7 = '14344', $8 = '14345', $9 = '14346', $10 = '92171', $11 = '14347', $12 = '14349', $13 = '161807', $14 = '14350', $15 = '14351', $16 = '14352', $17 = '14353', $18 = '14354', $19 = '161808', $20 = '14355', $21 = '14356', $22 = '14357', $23 = '14358', $24 = '14359', $25 = '14361', $26 = '14363', $27 = '14364', $28 = '14365', $29 = '14366', $30 = '14367', $31 = '71710', $32 = '14368', $33 = '14369', $34 = '14370', $35 = '1286193', $36 = '14371', $37 = '14375', $38 = '14381', $39 = '14384', $40 = '14385', $41 = '14386', $42 = '92210', $43 = '14393', $44 = '14394', $45 = '14396', $46 = '14397', $47 = '14398', $48 = '14399', $49 = '14400', $50 = '65', $51 = '2113', $52 = '14401', $53 = '14402', $54 = '14403', $55 = '14404', $56 = '14405', $57 = '14406', $58 = '14407', $59 = '14408', $60 = '14409', $61 = '14410', $62 = '108619', $63 = '14411', $64 = '14412', $65 = '14413', $66 = '14414', $67 = '122959', $68 = '14416', $69 = '14417', $70 = '14418', $71 = '14419', $72 = '14420', $73 = '14421', $74 = '14422', $75 = '14423', $76 = '14424', $77 = '14428', $78 = '14431', $79 = '14432', $80 = '14433', $81 = '14434', $82 = '14436', $83 = '14437', $84 = '14438', $85 = '14439', $86 = '14440', $87 = '14441', $88 = '14442', $89 = '14443', $90 = '14444', $91 = '14445', $92 = '14446', $93 = '14447', $94 = '14448', $95 = '14449', $96 = '14450', $97 = '104563', $98 = '108659', $99 = '14451', $100 = '14452', $101 = '14453', $102 = '14454', $103 = '14455', $104 = '14456', $105 = '14457', $106 = '122', $107 = '14458', $108 = '14459', $109 = '14460', $110 = '14461', $111 = '14462', $112 = '14463', $113 = '14464', $114 = '104577', $115 = '14465', $116 = '14466', $117 = '14467', $118 = '14471', $119 = '14472', $120 = '14473', $121 = '14474', $122 = '14475', $123 = '14476', $124 = '14477', $125 = '14478', $126 = '14479', $127 = '14480', $128 = '92305', $129 = '14482', $130 = '14483', $131 = '32915', $132 = '14488', $133 = '14489', $134 = '14490', $135 = '67739', $136 = '14491', $137 = '14492', $138 = '14493', $139 = '14494', $140 = '14495', $141 = '14496', $142 = '14497', $143 = '14498', $144 = '92323', $145 = '14499', $146 = '14500', $147 = '14501', $148 = '14502', $149 = '14503', $150 = '14504', $151 = '14505', $152 = '14506', $153 = '14507', $154 = '14508', $155 = '14509', $156 = '92332', $157 = '14511', $158 = '14512', $159 = '14513', $160 = '14514', $161 = '14515', $162 = '14516', $163 = '14517', $164 = '14518', $165 = '14519', $166 = '14520', $167 = '14521', $168 = '14522', $169 = '14523', $170 = '14524', $171 = '14525', $172 = '14526', $173 = '14527', $174 = '14528', $175 = '14529', $176 = '14530', $177 = '14531', $178 = '14532', $179 = '14533', $180 = '14534', $181 = '14535', $182 = '92358', $183 = '14536', $184 = '14537', $185 = '14538', $186 = '14539', $187 = '14540', $188 = '14542', $189 = '14543', $190 = '14544', $191 = '14545', $192 = '14546', $193 = '1280193', $194 = '14547', $195 = '14548', $196 = '14549', $197 = '14550', $198 = '162004', $199 = '14551', $200 = '14552', $201 = '14553', $202 = '14554', $203 = '14555', $204 = '14556', $205 = '14557', $206 = '14558', $207 = '14559', $208 = '14560', $209 = '14561', $210 = '14562', $211 = '14563', $212 = '14564', $213 = '155878', $214 = '14565', $215 = '155879', $216 = '14566', $217 = '14567', $218 = '14568', $219 = '14569', $220 = '14570', $221 = '14571', $222 = '14572', $223 = '14573', $224 = '14574', $225 = '14575', $226 = '90350', $227 = '127214', $228 = '14576', $229 = '14577', $230 = '14578', $231 = '14579', $232 = '14580', $233 = '14581', $234 = '14582', $235 = '14583', $236 = '14584', $237 = '14585', $238 = '14586', $239 = '14587', $240 = '14588', $241 = '14589', $242 = '14590', $243 = '14591', $244 = '14592', $245 = '14593', $246 = '14594', $247 = '14595', $248 = '14596', $249 = '14597', $250 = '14598', $251 = '14599', $252 = '14600', $253 = '14602', $254 = '14603', $255 = '14604', $256 = '14605', $257 = '96524', $258 = '14606', $259 = '14607', $260 = '14608', $261 = '14609', $262 = '96531', $263 = '14611', $264 = '14612', $265 = '125205', $266 = '14613', $267 = '14615', $268 = '14616', $269 = '14617', $270 = '14618', $271 = '14619', $272 = '14620', $273 = '14621', $274 = '108828', $275 = '14622', $276 = '160028', $277 = '14623', $278 = '14624', $279 = '14625', $280 = '14626', $281 = '14627', $282 = '14628', $283 = '14629', $284 = '294', $285 = '14630', $286 = '14631', $287 = '14632', $288 = '14633', $289 = '14634', $290 = '14635', $291 = '14636', $292 = '14637', $293 = '14638', $294 = '14639', $295 = '14640', $296 = '78129', $297 = '14641', $298 = '14642', $299 = '14643', $300 = '14644', $301 = '14645', $302 = '14646', $303 = '14647', $304 = '14648', $305 = '37176', $306 = '14649', $307 = '133435', $308 = '14650', $309 = '14651', $310 = '14652', $311 = '14653', $312 = '14654', $313 = '14655', $314 = '14656', $315 = '133442', $316 = '14657', $317 = '133443', $318 = '14658', $319 = '14659', $320 = '14660', $321 = '14661', $322 = '14662', $323 = '72007', $324 = '14663', $325 = '14664', $326 = '145738', $327 = '14665', $328 = '14666', $329 = '14667', $330 = '14668', $331 = '14669', $332 = '14670', $333 = '14671', $334 = '14672', $335 = '14673', $336 = '14674', $337 = '92499', $338 = '14675', $339 = '162129', $340 = '14676', $341 = '14677', $342 = '14678', $343 = '14679', $344 = '14680', $345 = '14681', $346 = '14682', $347 = '1265993', $348 = '14683', $349 = '14684', $350 = '14685', $351 = '14686', $352 = '14687', $353 = '14688', $354 = '14689', $355 = '14690', $356 = '14691', $357 = '125282', $358 = '14692', $359 = '14693', $360 = '14694', $361 = '14695', $362 = '14696', $363 = '172394', $364 = '14697', $365 = '172395', $366 = '14698', $367 = '164200', $368 = '14699', $369 = '164201', $370 = '14700', $371 = '14701', $372 = '2414', $373 = '14702', $374 = '172396', $375 = '14703', $376 = '172397', $377 = '14704', $378 = '14705', $379 = '14706', $380 = '14707', $381 = '14708', $382 = '14709', $383 = '14711', $384 = '14716', $385 = '14717', $386 = '14722', $387 = '76163', $388 = '14723', $389 = '14724', $390 = '14725', $391 = '14726', $392 = '14727', $393 = '14729', $394 = '14730', $395 = '14732', $396 = '14734', $397 = '14735', $398 = '14736', $399 = '14737', $400 = '14738', $401 = '14742', $402 = '14743', $403 = '14744', $404 = '14745', $405 = '14746', $406 = '14747', $407 = '14748', $408 = '133534', $409 = '14749', $410 = '133535', $411 = '14750', $412 = '14751', $413 = '14752', $414 = '14753', $415 = '14754', $416 = '14755', $417 = '160161', $418 = '14756', $419 = '14757', $420 = '131495', $421 = '14758', $422 = '14759', $423 = '14760', $424 = '14761', $425 = '14762', $426 = '76203', $427 = '14763', $428 = '14764', $429 = '14765', $430 = '14766', $431 = '14767', $432 = '14768', $433 = '14769', $434 = '14770', $435 = '14771', $436 = '14772', $437 = '14773', $438 = '14774', $439 = '14775', $440 = '14776', $441 = '14777', $442 = '14778', $443 = '14779', $444 = '14780', $445 = '14781', $446 = '14782', $447 = '14783', $448 = '14784', $449 = '14785', $450 = '14786', $451 = '14787', $452 = '14788', $453 = '14789', $454 = '14790', $455 = '14791', $456 = '14792', $457 = '14793', $458 = '14794', $459 = '14795', $460 = '14796', $461 = '14797', $462 = '14798', $463 = '14799', $464 = '68046', $465 = '14800', $466 = '14801', $467 = '14802', $468 = '14803', $469 = '4564', $470 = '14804', $471 = '14805', $472 = '14806', $473 = '14807', $474 = '14808', $475 = '14809', $476 = '14810', $477 = '14811', $478 = '14812', $479 = '14813', $480 = '14814', $481 = '14815', $482 = '14817', $483 = '14818', $484 = '14819', $485 = '14820', $486 = '14821', $487 = '14822', $488 = '14823', $489 = '14824', $490 = '14825', $491 = '129512', $492 = '14827', $493 = '14828', $494 = '14829', $495 = '70124', $496 = '14830', $497 = '14831', $498 = '14832', $499 = '14833', $500 = '14834', $501 = '14835', $502 = '14836', $503 = '14837', $504 = '14838', $505 = '14839', $506 = '14840', $507 = '14841', $508 = '14842', $509 = '14843', $510 = '14844', $511 = '14845', $512 = '14846', $513 = '14847', $514 = '14848', $515 = '14849', $516 = '14850', $517 = '14851', $518 = '14852', $519 = '14853', $520 = '14854', $521 = '14855', $522 = '14856', $523 = '14857', $524 = '14858', $525 = '14859', $526 = '14860', $527 = '14861', $528 = '14862', $529 = '527', $530 = '14863', $531 = '14864', $532 = '207390', $533 = '1268273', $534 = '2602', $535 = '556', $536 = '141870', $537 = '129587', $538 = '129588', $539 = '100931', $540 = '66114', $541 = '299602', $542 = '162415', $543 = '82547', $544 = '92790', $545 = '92797', $546 = '164512', $547 = '96938', $548 = '2748', $549 = '96956', $550 = '99007', $551 = '99008', $552 = '162515', $553 = '162519', $554 = '162516', $555 = '162520', $556 = '94952', $557 = '275191', $558 = '6900', $559 = '275193', $560 = '275194', $561 = '275195', $562 = '1215255', $563 = '105222', $564 = '4876', $565 = '162594', $566 = '162595', $567 = '162592', $568 = '162593', $569 = '162598', $570 = '817', $571 = '4936', $572 = '90985', $573 = '142186', $574 = '90998', $575 = '4986', $576 = '338810', $577 = '168849', $578 = '119701', $579 = '70550', $580 = '142238', $581 = '926', $582 = '70558', $583 = '140193', $584 = '5038', $585 = '5040', $586 = '258995', $587 = '258993', $588 = '5043', $589 = '5044', $590 = '1098660', $591 = '5045', $592 = '5046', $593 = '258997', $594 = '5048', $595 = '93112', $596 = '5050', $597 = '5052', $598 = '5053', $599 = '5054', $600 = '82879', $601 = '76734', $602 = '5056', $603 = '961', $604 = '140227', $605 = '5058', $606 = '5060', $607 = '5061', $608 = '5062', $609 = '5063', $610 = '5064', $611 = '5066', $612 = '5068', $613 = '5069', $614 = '5070', $615 = '5071', $616 = '84942', $617 = '5072', $618 = '977', $619 = '82899', $620 = '5076', $621 = '5077', $622 = '5078', $623 = '5080', $624 = '95193', $625 = '185306', $626 = '5081', $627 = '185307', $628 = '5082', $629 = '5083', $630 = '5084', $631 = '185310', $632 = '5085', $633 = '185311', $634 = '5086', $635 = '185308', $636 = '5087', $637 = '185309', $638 = '185314', $639 = '5089', $640 = '5090', $641 = '185312', $642 = '185313', $643 = '5092', $644 = '5093', $645 = '5094', $646 = '5095', $647 = '5096', $648 = '5097', $649 = '5098', $650 = '5099', $651 = '5100', $652 = '93165', $653 = '5101', $654 = '93164', $655 = '5102', $656 = '119791', $657 = '5103', $658 = '76782', $659 = '93166', $660 = '5104', $661 = '5105', $662 = '119792', $663 = '5107', $664 = '5109', $665 = '5110', $666 = '5111', $667 = '142325', $668 = '5112', $669 = '5113', $670 = '115707', $671 = '5115', $672 = '5116', $673 = '5117', $674 = '5118', $675 = '5119', $676 = '5120', $677 = '125953', $678 = '5121', $679 = '125952', $680 = '5122', $681 = '5124', $682 = '5126', $683 = '5127', $684 = '5128', $685 = '5129', $686 = '70669', $687 = '203790', $688 = '130085', $689 = '80932', $690 = '132138', $691 = '132139', $692 = '132142', $693 = '132141', $694 = '103473', $695 = '130103', $696 = '142404', $697 = '142418', $698 = '76883', $699 = '128085', $700 = '341085', $701 = '341084', $702 = '341087', $703 = '341086', $704 = '341080', $705 = '341083', $706 = '160866', $707 = '341092', $708 = '146534', $709 = '341089', $710 = '146535', $711 = '341088', $712 = '341091', $713 = '146533', $714 = '341090', $715 = '146536', $716 = '146537', $717 = '3184', $718 = '126074', $719 = '40067', $720 = '175246', $721 = '175244', $722 = '187542', $723 = '187540', $724 = '187546', $725 = '1227914', $726 = '1177', $727 = '1227915', $728 = '187545', $729 = '1227913', $730 = '103588', $731 = '162993', $732 = '136387', $733 = '136384', $734 = '136392', $735 = '136399', $736 = '136396', $737 = '87272', $738 = '1258', $739 = '341227', $740 = '77063', $741 = '77064', $742 = '77069', $743 = '175386', $744 = '58662', $745 = '175415', $746 = '1260842', $747 = '85318', $748 = '3409', $749 = '335191', $750 = '335190', $751 = '181591', $752 = '95575', $753 = '95574', $754 = '77145', $755 = '181593', $756 = '335193', $757 = '335192', $758 = '130404', $759 = '93545', $760 = '93546', $761 = '144745', $762 = '111997', $763 = '112021', $764 = '112022', $765 = '112026', $766 = '128413', $767 = '128414', $768 = '150947', $769 = '112037', $770 = '112038', $771 = '112041', $772 = '112042', $773 = '77229', $774 = '112047', $775 = '150956', $776 = '112048', $777 = '187830', $778 = '3509', $779 = '187831', $780 = '187829', $781 = '187834', $782 = '187835', $783 = '187832', $784 = '187833', $785 = '112061', $786 = '97724', $787 = '112063', $788 = '112065', $789 = '112064', $790 = '351684', $791 = '351687', $792 = '112068', $793 = '128452', $794 = '112070', $795 = '351689', $796 = '3535', $797 = '363984', $798 = '153044', $799 = '153045', $800 = '3546', $801 = '112092', $802 = '112114', $803 = '126460', $804 = '112126', $805 = '130558', $806 = '151040', $807 = '151041', $808 = '85513', $809 = '85512', $810 = '3608', $811 = '110115', $812 = '116263', $813 = '1244734', $814 = '144949', $815 = '83512', $816 = '97848', $817 = '110136', $818 = '128568', $819 = '142904', $820 = '142905', $821 = '128575', $822 = '333396', $823 = '345687', $824 = '345686', $825 = '97879', $826 = '345693', $827 = '345692', $828 = '345694', $829 = '345689', $830 = '345688', $831 = '345691', $832 = '163442', $833 = '163441', $834 = '58996', $835 = '58997', $836 = '263803', $837 = '93825', $838 = '3715', $839 = '46729', $840 = '46733', $841 = '95889', $842 = '108186', $843 = '128669', $844 = '356008', $845 = '1124009', $846 = '296642', $847 = '3790', $848 = '345808', $849 = '345810', $850 = '159452', $851 = '3816', $852 = '3820', $853 = '132847', $854 = '106223', $855 = '42736', $856 = '106225', $857 = '42737', $858 = '42738', $859 = '132848', $860 = '106226', $861 = '132849', $862 = '175871', $863 = '85760', $864 = '141059', $865 = '175872', $866 = '91911', $867 = '42765', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '42775', $872 = '333597', $873 = '42777', $874 = '333599', $875 = '333598', $876 = '190236', $877 = '1224498', $878 = '1224502', $879 = '83748', $880 = '333600', $881 = '124711', $882 = '333602', $883 = '91959', $884 = '130883', $885 = '91973', $886 = '1240906', $887 = '1242954', $888 = '1242955', $889 = '75611', $890 = '356190', $891 = '75612', $892 = '1242956', $893 = '1261388', $894 = '124791', $895 = '92025', $896 = '14205', $897 = '141185', $898 = '141196', $899 = '57232', $900 = '14225', $901 = '14228', $902 = '77717', $903 = '14229', $904 = '96148', $905 = '14231', $906 = '96150', $907 = '14232', $908 = '96152', $909 = '14234', $910 = '83867', $911 = '14235', $912 = '100253', $913 = '83868', $914 = '14238', $915 = '75679', $916 = '14239', $917 = '14241', $918 = '14242', $919 = '14243', $920 = '276391', $921 = '14244', $922 = '14245', $923 = '14246', $924 = '14247', $925 = '14248', $926 = '14249', $927 = '14250', $928 = '14251', $929 = '14252', $930 = '724927', $931 = '124852', $932 = '128951', $933 = '14264', $934 = '128953', $935 = '14265', $936 = '14266', $937 = '14267', $938 = '128954', $939 = '133049', $940 = '14269', $941 = '14270', $942 = '14272', $943 = '14273', $944 = '14274', $945 = '14275', $946 = '14276', $947 = '1989', $948 = '14277', $949 = '14278', $950 = '491457', $951 = '14279', $952 = '14280', $953 = '14281', $954 = '14282', $955 = '14283', $956 = '14284', $957 = '14285', $958 = '14286', $959 = '14287', $960 = '14288', $961 = '14289', $962 = '14291', $963 = '14292', $964 = '14293', $965 = '14294', $966 = '14295', $967 = '14296', $968 = '14298', $969 = '14299', $970 = '14300', $971 = '14301', $972 = '14302', $973 = '14303', $974 = '14304', $975 = '67553', $976 = '14305', $977 = '14306', $978 = '14307', $979 = '14308', $980 = '14309', $981 = '14311', $982 = '14312', $983 = '14313', $984 = '14315', $985 = '14316', $986 = '14317', $987 = '14320', $988 = '14322', $989 = '14323', $990 = '14324', $991 = '14325', $992 = '14326', $993 = '14327', $994 = '14328', $995 = '14329', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335';
Date: 2026-03-06 08:58:22 Duration: 6s46ms Database: cnrs2 User: a3d Remote: 10.7.177.87 Application: PostgreSQL JDBC Driver
Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5168.42..106913.49 rows=121690 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5135.50 rows=121690 width=0) Index Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[]))
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 6s46ms 6s46ms 6s46ms 1 6s46ms select gocp1_0.obj_compo_num_id, gocp1_0.obj_compo_creator, gocp1_0.obj_compo_dcre, gocp1_0.obj_compo_dmaj, gocp1_0.obj_compo_ligne_tab_num_id, gocp1_0.obj_compo_modifier, gocp1_0.obj_compo_num_id_tab, gocp1_0.att_template_category_num_id, gocp1_0.att_template_num_id, gocp1_0.obj_compo_unit_num_id, gocp1_0.obj_compo_value, gocp1_0.obj_num_id from gtp_obj_composition gocp1_0 where gocp1_0.obj_num_id in (...) query parameters: ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?, ? = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 08 1 6s46ms 6s46ms [ User: a3d - Total duration: 6s46ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s46ms - Times executed: 1 ]
-
select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($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) Query Parameters: $1 = '14336', $2 = '14337', $3 = '14338', $4 = '14339', $5 = '14342', $6 = '14343', $7 = '14344', $8 = '14345', $9 = '14346', $10 = '92171', $11 = '14347', $12 = '14349', $13 = '161807', $14 = '14350', $15 = '14351', $16 = '14352', $17 = '14353', $18 = '14354', $19 = '161808', $20 = '14355', $21 = '14356', $22 = '14357', $23 = '14358', $24 = '14359', $25 = '14361', $26 = '14363', $27 = '14364', $28 = '14365', $29 = '14366', $30 = '14367', $31 = '71710', $32 = '14368', $33 = '14369', $34 = '14370', $35 = '1286193', $36 = '14371', $37 = '14375', $38 = '14381', $39 = '14384', $40 = '14385', $41 = '14386', $42 = '92210', $43 = '14393', $44 = '14394', $45 = '14396', $46 = '14397', $47 = '14398', $48 = '14399', $49 = '14400', $50 = '65', $51 = '2113', $52 = '14401', $53 = '14402', $54 = '14403', $55 = '14404', $56 = '14405', $57 = '14406', $58 = '14407', $59 = '14408', $60 = '14409', $61 = '14410', $62 = '108619', $63 = '14411', $64 = '14412', $65 = '14413', $66 = '14414', $67 = '122959', $68 = '14416', $69 = '14417', $70 = '14418', $71 = '14419', $72 = '14420', $73 = '14421', $74 = '14422', $75 = '14423', $76 = '14424', $77 = '14428', $78 = '14431', $79 = '14432', $80 = '14433', $81 = '14434', $82 = '14436', $83 = '14437', $84 = '14438', $85 = '14439', $86 = '14440', $87 = '14441', $88 = '14442', $89 = '14443', $90 = '14444', $91 = '14445', $92 = '14446', $93 = '14447', $94 = '14448', $95 = '14449', $96 = '14450', $97 = '104563', $98 = '108659', $99 = '14451', $100 = '14452', $101 = '14453', $102 = '14454', $103 = '14455', $104 = '14456', $105 = '14457', $106 = '122', $107 = '14458', $108 = '14459', $109 = '14460', $110 = '14461', $111 = '14462', $112 = '14463', $113 = '14464', $114 = '104577', $115 = '14465', $116 = '14466', $117 = '14467', $118 = '14471', $119 = '14472', $120 = '14473', $121 = '14474', $122 = '14475', $123 = '14476', $124 = '14477', $125 = '14478', $126 = '14479', $127 = '14480', $128 = '92305', $129 = '14482', $130 = '14483', $131 = '32915', $132 = '14488', $133 = '14489', $134 = '14490', $135 = '67739', $136 = '14491', $137 = '14492', $138 = '14493', $139 = '14494', $140 = '14495', $141 = '14496', $142 = '14497', $143 = '14498', $144 = '92323', $145 = '14499', $146 = '14500', $147 = '14501', $148 = '14502', $149 = '14503', $150 = '14504', $151 = '14505', $152 = '14506', $153 = '14507', $154 = '14508', $155 = '14509', $156 = '92332', $157 = '14511', $158 = '14512', $159 = '14513', $160 = '14514', $161 = '14515', $162 = '14516', $163 = '14517', $164 = '14518', $165 = '14519', $166 = '14520', $167 = '14521', $168 = '14522', $169 = '14523', $170 = '14524', $171 = '14525', $172 = '14526', $173 = '14527', $174 = '14528', $175 = '14529', $176 = '14530', $177 = '14531', $178 = '14532', $179 = '14533', $180 = '14534', $181 = '14535', $182 = '92358', $183 = '14536', $184 = '14537', $185 = '14538', $186 = '14539', $187 = '14540', $188 = '14542', $189 = '14543', $190 = '14544', $191 = '14545', $192 = '14546', $193 = '1280193', $194 = '14547', $195 = '14548', $196 = '14549', $197 = '14550', $198 = '162004', $199 = '14551', $200 = '14552', $201 = '14553', $202 = '14554', $203 = '14555', $204 = '14556', $205 = '14557', $206 = '14558', $207 = '14559', $208 = '14560', $209 = '14561', $210 = '14562', $211 = '14563', $212 = '14564', $213 = '155878', $214 = '14565', $215 = '155879', $216 = '14566', $217 = '14567', $218 = '14568', $219 = '14569', $220 = '14570', $221 = '14571', $222 = '14572', $223 = '14573', $224 = '14574', $225 = '14575', $226 = '90350', $227 = '127214', $228 = '14576', $229 = '14577', $230 = '14578', $231 = '14579', $232 = '14580', $233 = '14581', $234 = '14582', $235 = '14583', $236 = '14584', $237 = '14585', $238 = '14586', $239 = '14587', $240 = '14588', $241 = '14589', $242 = '14590', $243 = '14591', $244 = '14592', $245 = '14593', $246 = '14594', $247 = '14595', $248 = '14596', $249 = '14597', $250 = '14598', $251 = '14599', $252 = '14600', $253 = '14602', $254 = '14603', $255 = '14604', $256 = '14605', $257 = '96524', $258 = '14606', $259 = '14607', $260 = '14608', $261 = '14609', $262 = '96531', $263 = '14611', $264 = '14612', $265 = '125205', $266 = '14613', $267 = '14615', $268 = '14616', $269 = '14617', $270 = '14618', $271 = '14619', $272 = '14620', $273 = '14621', $274 = '108828', $275 = '14622', $276 = '160028', $277 = '14623', $278 = '14624', $279 = '14625', $280 = '14626', $281 = '14627', $282 = '14628', $283 = '14629', $284 = '294', $285 = '14630', $286 = '14631', $287 = '14632', $288 = '14633', $289 = '14634', $290 = '14635', $291 = '14636', $292 = '14637', $293 = '14638', $294 = '14639', $295 = '14640', $296 = '78129', $297 = '14641', $298 = '14642', $299 = '14643', $300 = '14644', $301 = '14645', $302 = '14646', $303 = '14647', $304 = '14648', $305 = '37176', $306 = '14649', $307 = '133435', $308 = '14650', $309 = '14651', $310 = '14652', $311 = '14653', $312 = '14654', $313 = '14655', $314 = '14656', $315 = '133442', $316 = '14657', $317 = '133443', $318 = '14658', $319 = '14659', $320 = '14660', $321 = '14661', $322 = '14662', $323 = '72007', $324 = '14663', $325 = '14664', $326 = '145738', $327 = '14665', $328 = '14666', $329 = '14667', $330 = '14668', $331 = '14669', $332 = '14670', $333 = '14671', $334 = '14672', $335 = '14673', $336 = '14674', $337 = '92499', $338 = '14675', $339 = '162129', $340 = '14676', $341 = '14677', $342 = '14678', $343 = '14679', $344 = '14680', $345 = '14681', $346 = '14682', $347 = '1265993', $348 = '14683', $349 = '14684', $350 = '14685', $351 = '14686', $352 = '14687', $353 = '14688', $354 = '14689', $355 = '14690', $356 = '14691', $357 = '125282', $358 = '14692', $359 = '14693', $360 = '14694', $361 = '14695', $362 = '14696', $363 = '172394', $364 = '14697', $365 = '172395', $366 = '14698', $367 = '164200', $368 = '14699', $369 = '164201', $370 = '14700', $371 = '14701', $372 = '2414', $373 = '14702', $374 = '172396', $375 = '14703', $376 = '172397', $377 = '14704', $378 = '14705', $379 = '14706', $380 = '14707', $381 = '14708', $382 = '14709', $383 = '14711', $384 = '14716', $385 = '14717', $386 = '14722', $387 = '76163', $388 = '14723', $389 = '14724', $390 = '14725', $391 = '14726', $392 = '14727', $393 = '14729', $394 = '14730', $395 = '14732', $396 = '14734', $397 = '14735', $398 = '14736', $399 = '14737', $400 = '14738', $401 = '14742', $402 = '14743', $403 = '14744', $404 = '14745', $405 = '14746', $406 = '14747', $407 = '14748', $408 = '133534', $409 = '14749', $410 = '133535', $411 = '14750', $412 = '14751', $413 = '14752', $414 = '14753', $415 = '14754', $416 = '14755', $417 = '160161', $418 = '14756', $419 = '14757', $420 = '131495', $421 = '14758', $422 = '14759', $423 = '14760', $424 = '14761', $425 = '14762', $426 = '76203', $427 = '14763', $428 = '14764', $429 = '14765', $430 = '14766', $431 = '14767', $432 = '14768', $433 = '14769', $434 = '14770', $435 = '14771', $436 = '14772', $437 = '14773', $438 = '14774', $439 = '14775', $440 = '14776', $441 = '14777', $442 = '14778', $443 = '14779', $444 = '14780', $445 = '14781', $446 = '14782', $447 = '14783', $448 = '14784', $449 = '14785', $450 = '14786', $451 = '14787', $452 = '14788', $453 = '14789', $454 = '14790', $455 = '14791', $456 = '14792', $457 = '14793', $458 = '14794', $459 = '14795', $460 = '14796', $461 = '14797', $462 = '14798', $463 = '14799', $464 = '68046', $465 = '14800', $466 = '14801', $467 = '14802', $468 = '14803', $469 = '4564', $470 = '14804', $471 = '14805', $472 = '14806', $473 = '14807', $474 = '14808', $475 = '14809', $476 = '14810', $477 = '14811', $478 = '14812', $479 = '14813', $480 = '14814', $481 = '14815', $482 = '14817', $483 = '14818', $484 = '14819', $485 = '14820', $486 = '14821', $487 = '14822', $488 = '14823', $489 = '14824', $490 = '14825', $491 = '129512', $492 = '14827', $493 = '14828', $494 = '14829', $495 = '70124', $496 = '14830', $497 = '14831', $498 = '14832', $499 = '14833', $500 = '14834', $501 = '14835', $502 = '14836', $503 = '14837', $504 = '14838', $505 = '14839', $506 = '14840', $507 = '14841', $508 = '14842', $509 = '14843', $510 = '14844', $511 = '14845', $512 = '14846', $513 = '14847', $514 = '14848', $515 = '14849', $516 = '14850', $517 = '14851', $518 = '14852', $519 = '14853', $520 = '14854', $521 = '14855', $522 = '14856', $523 = '14857', $524 = '14858', $525 = '14859', $526 = '14860', $527 = '14861', $528 = '14862', $529 = '527', $530 = '14863', $531 = '14864', $532 = '207390', $533 = '1268273', $534 = '2602', $535 = '556', $536 = '141870', $537 = '129587', $538 = '129588', $539 = '100931', $540 = '66114', $541 = '299602', $542 = '162415', $543 = '82547', $544 = '92790', $545 = '92797', $546 = '164512', $547 = '96938', $548 = '2748', $549 = '96956', $550 = '99007', $551 = '99008', $552 = '162515', $553 = '162519', $554 = '162516', $555 = '162520', $556 = '94952', $557 = '275191', $558 = '6900', $559 = '275193', $560 = '275194', $561 = '275195', $562 = '1215255', $563 = '105222', $564 = '4876', $565 = '162594', $566 = '162595', $567 = '162592', $568 = '162593', $569 = '162598', $570 = '817', $571 = '4936', $572 = '90985', $573 = '142186', $574 = '90998', $575 = '4986', $576 = '338810', $577 = '168849', $578 = '119701', $579 = '70550', $580 = '142238', $581 = '926', $582 = '70558', $583 = '140193', $584 = '5038', $585 = '5040', $586 = '258995', $587 = '258993', $588 = '5043', $589 = '5044', $590 = '1098660', $591 = '5045', $592 = '5046', $593 = '258997', $594 = '5048', $595 = '93112', $596 = '5050', $597 = '5052', $598 = '5053', $599 = '5054', $600 = '82879', $601 = '76734', $602 = '5056', $603 = '961', $604 = '140227', $605 = '5058', $606 = '5060', $607 = '5061', $608 = '5062', $609 = '5063', $610 = '5064', $611 = '5066', $612 = '5068', $613 = '5069', $614 = '5070', $615 = '5071', $616 = '84942', $617 = '5072', $618 = '977', $619 = '82899', $620 = '5076', $621 = '5077', $622 = '5078', $623 = '5080', $624 = '95193', $625 = '185306', $626 = '5081', $627 = '185307', $628 = '5082', $629 = '5083', $630 = '5084', $631 = '185310', $632 = '5085', $633 = '185311', $634 = '5086', $635 = '185308', $636 = '5087', $637 = '185309', $638 = '185314', $639 = '5089', $640 = '5090', $641 = '185312', $642 = '185313', $643 = '5092', $644 = '5093', $645 = '5094', $646 = '5095', $647 = '5096', $648 = '5097', $649 = '5098', $650 = '5099', $651 = '5100', $652 = '93165', $653 = '5101', $654 = '93164', $655 = '5102', $656 = '119791', $657 = '5103', $658 = '76782', $659 = '93166', $660 = '5104', $661 = '5105', $662 = '119792', $663 = '5107', $664 = '5109', $665 = '5110', $666 = '5111', $667 = '142325', $668 = '5112', $669 = '5113', $670 = '115707', $671 = '5115', $672 = '5116', $673 = '5117', $674 = '5118', $675 = '5119', $676 = '5120', $677 = '125953', $678 = '5121', $679 = '125952', $680 = '5122', $681 = '5124', $682 = '5126', $683 = '5127', $684 = '5128', $685 = '5129', $686 = '70669', $687 = '203790', $688 = '130085', $689 = '80932', $690 = '132138', $691 = '132139', $692 = '132142', $693 = '132141', $694 = '103473', $695 = '130103', $696 = '142404', $697 = '142418', $698 = '76883', $699 = '128085', $700 = '341085', $701 = '341084', $702 = '341087', $703 = '341086', $704 = '341080', $705 = '341083', $706 = '160866', $707 = '341092', $708 = '146534', $709 = '341089', $710 = '146535', $711 = '341088', $712 = '341091', $713 = '146533', $714 = '341090', $715 = '146536', $716 = '146537', $717 = '3184', $718 = '126074', $719 = '40067', $720 = '175246', $721 = '175244', $722 = '187542', $723 = '187540', $724 = '187546', $725 = '1227914', $726 = '1177', $727 = '1227915', $728 = '187545', $729 = '1227913', $730 = '103588', $731 = '162993', $732 = '136387', $733 = '136384', $734 = '136392', $735 = '136399', $736 = '136396', $737 = '87272', $738 = '1258', $739 = '341227', $740 = '77063', $741 = '77064', $742 = '77069', $743 = '175386', $744 = '58662', $745 = '175415', $746 = '1260842', $747 = '85318', $748 = '3409', $749 = '335191', $750 = '335190', $751 = '181591', $752 = '95575', $753 = '95574', $754 = '77145', $755 = '181593', $756 = '335193', $757 = '335192', $758 = '130404', $759 = '93545', $760 = '93546', $761 = '144745', $762 = '111997', $763 = '112021', $764 = '112022', $765 = '112026', $766 = '128413', $767 = '128414', $768 = '150947', $769 = '112037', $770 = '112038', $771 = '112041', $772 = '112042', $773 = '77229', $774 = '112047', $775 = '150956', $776 = '112048', $777 = '187830', $778 = '3509', $779 = '187831', $780 = '187829', $781 = '187834', $782 = '187835', $783 = '187832', $784 = '187833', $785 = '112061', $786 = '97724', $787 = '112063', $788 = '112065', $789 = '112064', $790 = '351684', $791 = '351687', $792 = '112068', $793 = '128452', $794 = '112070', $795 = '351689', $796 = '3535', $797 = '363984', $798 = '153044', $799 = '153045', $800 = '3546', $801 = '112092', $802 = '112114', $803 = '126460', $804 = '112126', $805 = '130558', $806 = '151040', $807 = '151041', $808 = '85513', $809 = '85512', $810 = '3608', $811 = '110115', $812 = '116263', $813 = '1244734', $814 = '144949', $815 = '83512', $816 = '97848', $817 = '110136', $818 = '128568', $819 = '142904', $820 = '142905', $821 = '128575', $822 = '333396', $823 = '345687', $824 = '345686', $825 = '97879', $826 = '345693', $827 = '345692', $828 = '345694', $829 = '345689', $830 = '345688', $831 = '345691', $832 = '163442', $833 = '163441', $834 = '58996', $835 = '58997', $836 = '263803', $837 = '93825', $838 = '3715', $839 = '46729', $840 = '46733', $841 = '95889', $842 = '108186', $843 = '128669', $844 = '356008', $845 = '1124009', $846 = '296642', $847 = '3790', $848 = '345808', $849 = '345810', $850 = '159452', $851 = '3816', $852 = '3820', $853 = '132847', $854 = '106223', $855 = '42736', $856 = '106225', $857 = '42737', $858 = '42738', $859 = '132848', $860 = '106226', $861 = '132849', $862 = '175871', $863 = '85760', $864 = '141059', $865 = '175872', $866 = '91911', $867 = '42765', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '42775', $872 = '333597', $873 = '42777', $874 = '333599', $875 = '333598', $876 = '190236', $877 = '1224498', $878 = '1224502', $879 = '83748', $880 = '333600', $881 = '124711', $882 = '333602', $883 = '91959', $884 = '130883', $885 = '91973', $886 = '1240906', $887 = '1242954', $888 = '1242955', $889 = '75611', $890 = '356190', $891 = '75612', $892 = '1242956', $893 = '1261388', $894 = '124791', $895 = '92025', $896 = '14205', $897 = '141185', $898 = '141196', $899 = '57232', $900 = '14225', $901 = '14228', $902 = '77717', $903 = '14229', $904 = '96148', $905 = '14231', $906 = '96150', $907 = '14232', $908 = '96152', $909 = '14234', $910 = '83867', $911 = '14235', $912 = '100253', $913 = '83868', $914 = '14238', $915 = '75679', $916 = '14239', $917 = '14241', $918 = '14242', $919 = '14243', $920 = '276391', $921 = '14244', $922 = '14245', $923 = '14246', $924 = '14247', $925 = '14248', $926 = '14249', $927 = '14250', $928 = '14251', $929 = '14252', $930 = '724927', $931 = '124852', $932 = '128951', $933 = '14264', $934 = '128953', $935 = '14265', $936 = '14266', $937 = '14267', $938 = '128954', $939 = '133049', $940 = '14269', $941 = '14270', $942 = '14272', $943 = '14273', $944 = '14274', $945 = '14275', $946 = '14276', $947 = '1989', $948 = '14277', $949 = '14278', $950 = '491457', $951 = '14279', $952 = '14280', $953 = '14281', $954 = '14282', $955 = '14283', $956 = '14284', $957 = '14285', $958 = '14286', $959 = '14287', $960 = '14288', $961 = '14289', $962 = '14291', $963 = '14292', $964 = '14293', $965 = '14294', $966 = '14295', $967 = '14296', $968 = '14298', $969 = '14299', $970 = '14300', $971 = '14301', $972 = '14302', $973 = '14303', $974 = '14304', $975 = '67553', $976 = '14305', $977 = '14306', $978 = '14307', $979 = '14308', $980 = '14309', $981 = '14311', $982 = '14312', $983 = '14313', $984 = '14315', $985 = '14316', $986 = '14317', $987 = '14320', $988 = '14322', $989 = '14323', $990 = '14324', $991 = '14325', $992 = '14326', $993 = '14327', $994 = '14328', $995 = '14329', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335';
Date: 2026-03-06 08:58:22 Duration: 6s46ms Database: cnrs2 User: a3d Remote: 10.7.177.87 Application: PostgreSQL JDBC Driver
Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5168.42..106913.49 rows=121690 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5135.50 rows=121690 width=0) Index Cond: (obj_num_id = ANY ('{14336,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,14354,161808,14355,14356,14357,14358,14359,14361,14363,14364,14365,14366,14367,71710,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,14393,14394,14396,14397,14398,14399,14400,65,2113,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,108619,14411,14412,14413,14414,122959,14416,14417,14418,14419,14420,14421,14422,14423,14424,14428,14431,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,104563,108659,14451,14452,14453,14454,14455,14456,14457,122,14458,14459,14460,14461,14462,14463,14464,104577,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,32915,14488,14489,14490,67739,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,92358,14536,14537,14538,14539,14540,14542,14543,14544,14545,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,155878,14565,155879,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,90350,127214,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,14611,14612,125205,14613,14615,14616,14617,14618,14619,14620,14621,108828,14622,160028,14623,14624,14625,14626,14627,14628,14629,294,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,14642,14643,14644,14645,14646,14647,14648,37176,14649,133435,14650,14651,14652,14653,14654,14655,14656,133442,14657,133443,14658,14659,14660,14661,14662,72007,14663,14664,145738,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,92499,14675,162129,14676,14677,14678,14679,14680,14681,14682,1265993,14683,14684,14685,14686,14687,14688,14689,14690,14691,125282,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,2414,14702,172396,14703,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,14748,133534,14749,133535,14750,14751,14752,14753,14754,14755,160161,14756,14757,131495,14758,14759,14760,14761,14762,76203,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,68046,14800,14801,14802,14803,4564,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,70124,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,527,14863,14864,207390,1268273,2602,556,141870,129587,129588,100931,66114,299602,162415,82547,92790,92797,164512,96938,2748,96956,99007,99008,162515,162519,162516,162520,94952,275191,6900,275193,275194,275195,1215255,105222,4876,162594,162595,162592,162593,162598,817,4936,90985,142186,90998,4986,338810,168849,119701,70550,142238,926,70558,140193,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,93112,5050,5052,5053,5054,82879,76734,5056,961,140227,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,977,82899,5076,5077,5078,5080,95193,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,185312,185313,5092,5093,5094,5095,5096,5097,5098,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,5111,142325,5112,5113,115707,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,5124,5126,5127,5128,5129,70669,203790,130085,80932,132138,132139,132142,132141,103473,130103,142404,142418,76883,128085,341085,341084,341087,341086,341080,341083,160866,341092,146534,341089,146535,341088,341091,146533,341090,146536,146537,3184,126074,40067,175246,175244,187542,187540,187546,1227914,1177,1227915,187545,1227913,103588,162993,136387,136384,136392,136399,136396,87272,1258,341227,77063,77064,77069,175386,58662,175415,1260842,85318,3409,335191,335190,181591,95575,95574,77145,181593,335193,335192,130404,93545,93546,144745,111997,112021,112022,112026,128413,128414,150947,112037,112038,112041,112042,77229,112047,150956,112048,187830,3509,187831,187829,187834,187835,187832,187833,112061,97724,112063,112065,112064,351684,351687,112068,128452,112070,351689,3535,363984,153044,153045,3546,112092,112114,126460,112126,130558,151040,151041,85513,85512,3608,110115,116263,1244734,144949,83512,97848,110136,128568,142904,142905,128575,333396,345687,345686,97879,345693,345692,345694,345689,345688,345691,163442,163441,58996,58997,263803,93825,3715,46729,46733,95889,108186,128669,356008,1124009,296642,3790,345808,345810,159452,3816,3820,132847,106223,42736,106225,42737,42738,132848,106226,132849,175871,85760,141059,175872,91911,42765,124684,333591,333590,42775,333597,42777,333599,333598,190236,1224498,1224502,83748,333600,124711,333602,91959,130883,91973,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,124791,92025,14205,141185,141196,57232,14225,14228,77717,14229,96148,14231,96150,14232,96152,14234,83867,14235,100253,83868,14238,75679,14239,14241,14242,14243,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,724927,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,1989,14277,14278,491457,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,67553,14305,14306,14307,14308,14309,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,92157,14333,14335}'::bigint[]))
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
-
Events
Log levels
Key values
- 2,157 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 818 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 735 Max number of times the same event was reported
- 818 Total events found
Rank Times reported Error 1 735 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 06 08 1 09 734 - ERROR: relation "gtp_log_metric" does not exist at character 13
- ERROR: relation "gtp_log_metric" does not exist at character 173
Statement: delete from GTP_LOG_METRIC where LOG_DATE < $1
Date: 2026-03-06 08:58:15 Database: cnrs2 Application: PostgreSQL JDBC Driver User: a3d Remote: 10.7.177.87
Statement: select glmp1_0.LOG_METRIC_NUM_ID,glmp1_0.LOG_DATE,glmp1_0.METRIC_AVERAGE_VALUE,glmp1_0.METRIC_MAX_VALUE,glmp1_0.METRIC_MIN_VALUE,glmp1_0.METRIC_NAME,glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME=$3)
Date: 2026-03-06 09:00:01 Database: cnrs2 Application: PostgreSQL JDBC Driver User: a3d Remote: 10.7.177.87
2 83 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 06 08 9 09 74 - ERROR: column gbtp1_0.task_sub_type does not exist at character 552
- ERROR: column gbtp1_0.task_sub_type does not exist at character 472
Statement: select gbtp1_0.TASK_NUM_ID,gbtp1_0.CANCELING_USER_NUM_ID,gbtp1_0.EXPORT_FILE_NAME,gbtp1_0.SERVER_ID,gbtp1_0.SOURCE_FILE_NAME,gbtp1_0.SOURCE_OBJ_NUM_ID,gbtp1_0.TASK_ACTIVE_STATUS,gbtp1_0.TASK_CREATE_DATE,gbtp1_0.TASK_CURRENT_PROGRESS,gbtp1_0.TASK_CURRENT_STEP,gbtp1_0.TASK_END_DATE,gbtp1_0.TASK_ERROR_MESSAGE,gbtp1_0.TASK_LAST_UPDATE,gbtp1_0.TASK_LOG,gbtp1_0.TASK_MAX_PROGRESS,gbtp1_0.TASK_MAX_STEP,gbtp1_0.TASK_ORIGIN,gbtp1_0.TASK_PARAMETERS,gbtp1_0.TASK_REPORT,gbtp1_0.TASK_SERVICE_NAME,gbtp1_0.TASK_START_DATE,gbtp1_0.TASK_STATE,gbtp1_0.TASK_STATUS,gbtp1_0.TASK_SUB_TYPE,gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS=$1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc
Date: 2026-03-06 08:58:22 Database: cnrs2 Application: PostgreSQL JDBC Driver User: a3d Remote: 10.7.177.87
Statement: select gbtp1_0.TASK_NUM_ID,gbtp1_0.USER_NUM_ID,gbtp1_0.TASK_SERVICE_NAME,gbtp1_0.TASK_START_DATE,gbtp1_0.TASK_END_DATE,gbtp1_0.TASK_CURRENT_STEP,gbtp1_0.TASK_MAX_STEP,gbtp1_0.TASK_CURRENT_PROGRESS,gbtp1_0.TASK_MAX_PROGRESS,gbtp1_0.TASK_STATUS,gbtp1_0.TASK_STATE,gbtp1_0.TASK_ERROR_MESSAGE,gbtp1_0.TASK_ACTIVE_STATUS,gbtp1_0.TASK_PARAMETERS,gbtp1_0.TASK_CREATE_DATE,gbtp1_0.CANCELING_USER_NUM_ID,gbtp1_0.EXPORT_FILE_NAME,gbtp1_0.SOURCE_FILE_NAME,gbtp1_0.SOURCE_OBJ_NUM_ID,gbtp1_0.TASK_SUB_TYPE from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS in ($1,$2) and gbtp1_0.TASK_SERVICE_NAME=$3 order by 1 desc
Date: 2026-03-06 08:59:12 Database: cnrs2 Application: PostgreSQL JDBC Driver User: a3d Remote: 10.7.177.87