pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Mar 2 09:02:28 2026
Log file: ./2026-02-27_PT1D.log
Parsed 2,142 log entries in 55s
Log start from 55-- :: to 55-- ::

Global Stats

1 Number of unique normalized queries
1 Number of queries
4s908ms Total query duration
2026-02-27 15:45:09 First query
2026-02-27 15:45:09 Last query
1 queries/s at 2026-02-27 15:45:09 Query peak

4s908ms Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
4s908ms Execute total duration

0 Number of events
0 Number of unique normalized events
0 Max number of times the same event was reported
0 Number of cancellation

0 Total number of automatic vacuums
771 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

537 Total number of sessions
21 sessions at 2026-02-27 16:09:27 Session peak
27d1h14m6s Total duration of sessions
1h12m32s Average duration of sessions
0 Average queries per session
9ms Average queries duration per session
1h12m32s Average idle time per session

541 Total number of connections
5 connections/s at 2026-02-27 09:52:52 Connection peak
1 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-02-27 15:45:09 Date

Queries per second (5 minutes average)

SELECT Traffic

Key values

1 queries/s Query Peak
2026-02-27 15:45:09 Date

SELECT queries (5 minutes period)

INSERT/UPDATE/DELETE Traffic

Key values

0 queries/s Query Peak
Date

Write queries (5 minutes period)

Queries duration

Key values

4s908ms Total query duration

Average queries duration (5 minutes average)

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

Bind versus prepare statements (5 minutes average)

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 27	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	0	0ms	0ms	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms	0ms	0ms
	10	0	0ms	0ms	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms	0ms	0ms
	13	0	0ms	0ms	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms	0ms	0ms
	15	1	0ms	4s908ms	4s908ms	0ms	4s908ms	4s908ms
	16	0	0ms	0ms	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms	0ms	0ms
	22	0	0ms	0ms	0ms	0ms	0ms	0ms
	23	0	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 27	00	0	0ms	0ms	0ms	0ms
	01	0	0ms	0ms	0ms	0ms
	02	0	0ms	0ms	0ms	0ms
	03	0	0ms	0ms	0ms	0ms
	04	0	0ms	0ms	0ms	0ms
	05	0	0ms	0ms	0ms	0ms
	06	0	0ms	0ms	0ms	0ms
	07	0	0ms	0ms	0ms	0ms
	08	0	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms
	10	0	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms
	13	0	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms
	15	1	4s908ms	0ms	0ms	4s908ms
	16	0	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms
	22	0	0ms	0ms	0ms	0ms
	23	0	0ms	0ms	0ms	0ms

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 27	00	0ms	0ms	0ms	0ms
	01	0ms	0ms	0ms	0ms
	02	0ms	0ms	0ms	0ms
	03	0ms	0ms	0ms	0ms
	04	0ms	0ms	0ms	0ms
	05	0ms	0ms	0ms	0ms
	06	0ms	0ms	0ms	0ms
	07	0ms	0ms	0ms	0ms
	08	0ms	0ms	0ms	0ms
	09	0ms	0ms	0ms	0ms
	10	0ms	0ms	0ms	0ms
	11	0ms	0ms	0ms	0ms
	12	0ms	0ms	0ms	0ms
	13	0ms	0ms	0ms	0ms
	14	0ms	0ms	0ms	0ms
	15	0ms	0ms	0ms	0ms
	16	0ms	0ms	0ms	0ms
	17	0ms	0ms	0ms	0ms
	18	0ms	0ms	0ms	0ms
	19	0ms	0ms	0ms	0ms
	20	0ms	0ms	0ms	0ms
	21	0ms	0ms	0ms	0ms
	22	0ms	0ms	0ms	0ms
	23	0ms	0ms	0ms	0ms

Day	Hour	Percentage of prepare
Feb 27	00	0.00%
	01	0.00%
	02	0.00%
	03	0.00%
	04	0.00%
	05	0.00%
	06	0.00%
	07	0.00%
	08	0.00%
	09	0.00%
	10	0.00%
	11	0.00%
	12	0.00%
	13	0.00%
	14	0.00%
	15	0.00%
	16	0.00%
	17	0.00%
	18	0.00%
	19	0.00%
	20	0.00%
	21	0.00%
	22	0.00%
	23	0.00%

Day	Hour	Count	Average / Second
Feb 27	00	11	0.00/s
	01	16	0.00/s
	02	19	0.01/s
	03	17	0.00/s
	04	30	0.01/s
	05	22	0.01/s
	06	17	0.00/s
	07	13	0.00/s
	08	13	0.00/s
	09	26	0.01/s
	10	28	0.01/s
	11	21	0.01/s
	12	13	0.00/s
	13	9	0.00/s
	14	4	0.00/s
	15	17	0.00/s
	16	30	0.01/s
	17	34	0.01/s
	18	35	0.01/s
	19	36	0.01/s
	20	30	0.01/s
	21	33	0.01/s
	22	36	0.01/s
	23	31	0.01/s

Day	Hour	Count	Average Duration	Average idle time
Feb 27	00	11	1m20s	1m20s
	01	16	1m20s	1m20s
	02	19	1m25s	1m25s
	03	17	1m22s	1m22s
	04	30	1m20s	1m20s
	05	22	1m18s	1m18s
	06	17	1m21s	1m21s
	07	13	1m21s	1m21s
	08	12	1m16s	1m16s
	09	27	1m30s	1m30s
	10	28	1m20s	1m20s
	11	21	1m14s	1m14s
	12	13	1m20s	1m20s
	13	12	2d5h4m58s	2d5h4m58s
	14	4	285ms	285ms
	15	12	4m	3m59s
	16	29	1m29s	1m29s
	17	37	1m13s	1m13s
	18	31	1m21s	1m21s
	19	37	1m18s	1m18s
	20	33	1m19s	1m19s
	21	33	1m22s	1m22s
	22	34	1m19s	1m19s
	23	29	1m21s	1m21s

↑ Back to the top of the General Activity table

Established Connections

Key values

5 connections Connection Peak
2026-02-27 09:52:52 Date

Connections per second (5 minutes average)

Connections per database

Key values

cnrs Main Database
541 connections Total

Chart
Table

Database	User	Count
cnrs		541
	a3d	541

Connections per user

Key values

a3d Main User
541 connections Total

Chart
Table

User	Count
a3d	541

Connections per host

Key values

10.7.160.147 Main host with 522 connections
541 Total connections

Chart
Table

Host	Count
10.6.201.196	19
10.7.160.147	522

Simultaneous sessions

Key values

21 sessions Session Peak
2026-02-27 16:09:27 Date

Number of sessions/second (5 minutes average)

Histogram of session times

Key values

512 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	18	3.35%
500ms-1s	1	0.19%
1s-30s	0	0.00%
30s-1m	0	0.00%
1m-10m	512	95.34%
10m-30m	3	0.56%
30m-1h	0	0.00%
1h-8h	0	0.00%
> 8h	3	0.56%

Sessions per database

Key values

cnrs Main Database
537 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
cnrs	537	27d1h14m6s	1h12m32s

Sessions per user

Key values

a3d Main User
537 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
a3d	537	27d1h14m6s	1h12m32s

Sessions per host

Key values

10.7.160.147 Main Host
537 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.6.201.196	19	3s579ms	188ms
10.7.160.147	518	27d1h14m3s	1h15m12s

Sessions per application

Key values

PostgreSQL JDBC Driver Main Application
537 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	518	27d1h14m3s	1h15m12s
[unknown]	19	3s579ms	188ms

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Feb 27	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
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

public.applicative_lock (672) Main table analyzed (database cnrs)
771 analyzes Total

Chart
Table

Table	Number of analyzes
cnrs.public.applicative_lock	672
cnrs.public.gtp_cache_host	51
cnrs.public.gtp_background_task	48
Total	771

Vacuums per table

Key values

unknown (0) Main table vacuumed on database
0 vacuums Total

Chart
Table

Vacuums per tables

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
NO DATASET

Tuples removed per table

Key values

unknown (0) Main table with removed tuples on database
0 tuples Total removed

Chart
Table

Tuples removed per tables

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
NO DATASET

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
NO DATASET

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	ANALYZEs
Feb 27	00	34
	01	35
	02	34
	03	34
	04	36
	05	34
	06	34
	07	35
	08	34
	09	35
	10	35
	11	35
	12	35
	13	33
	14	0
	15	8
	16	34
	17	35
	18	34
	19	35
	20	35
	21	36
	22	35
	23	36

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

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 by type

Key values

1 Total read queries
0 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1	100.00%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

cnrs Main database
1 Requests
4s908ms (cnrs)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
cnrs	Total	1	4s908ms
	select	1	4s908ms

Queries by user

Key values

a3d Main user
1 Requests

Queries Chart
Table

User	Request type	Count	Duration
a3d	Total	1	4s908ms
	select	1	4s908ms

Duration by user

Key values

4s908ms (a3d) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
a3d	Total	1	4s908ms
	select	1	4s908ms

Queries by host

Key values

10.7.160.147 Main host
1 Requests
4s908ms (10.7.160.147)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.7.160.147	Total	1	4s908ms
	select	1	4s908ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
1 Requests
4s908ms (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	1	4s908ms
	select	1	4s908ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-02-27 01:00:22 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Slowest individual queries

Rank	Duration	Query
1	4s908ms	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 = '67585', $3 = '14337', $4 = '14338', $5 = '14339', $6 = '14342', $7 = '14343', $8 = '14344', $9 = '14345', $10 = '14346', $11 = '92171', $12 = '14347', $13 = '14349', $14 = '161807', $15 = '14350', $16 = '14351', $17 = '14352', $18 = '14353', $19 = '2066', $20 = '14354', $21 = '161808', $22 = '14355', $23 = '14356', $24 = '14357', $25 = '14358', $26 = '14359', $27 = '14361', $28 = '14363', $29 = '127002', $30 = '14364', $31 = '14365', $32 = '14366', $33 = '14367', $34 = '14368', $35 = '14369', $36 = '14370', $37 = '1286193', $38 = '14371', $39 = '14375', $40 = '14381', $41 = '14384', $42 = '14385', $43 = '14386', $44 = '92210', $45 = '143409', $46 = '147510', $47 = '2103', $48 = '14393', $49 = '14394', $50 = '14396', $51 = '14397', $52 = '14398', $53 = '14399', $54 = '14400', $55 = '14401', $56 = '14402', $57 = '14403', $58 = '14404', $59 = '14405', $60 = '14406', $61 = '14407', $62 = '14408', $63 = '14409', $64 = '108619', $65 = '14410', $66 = '14411', $67 = '14412', $68 = '14413', $69 = '14414', $70 = '122959', $71 = '14416', $72 = '14417', $73 = '14418', $74 = '14419', $75 = '83', $76 = '14420', $77 = '14421', $78 = '14422', $79 = '14423', $80 = '14424', $81 = '82011', $82 = '14428', $83 = '14431', $84 = '127070', $85 = '14432', $86 = '14433', $87 = '14434', $88 = '14436', $89 = '14437', $90 = '14438', $91 = '14439', $92 = '14440', $93 = '14441', $94 = '14442', $95 = '14443', $96 = '14444', $97 = '14445', $98 = '14446', $99 = '14447', $100 = '14448', $101 = '14449', $102 = '14450', $103 = '108659', $104 = '14451', $105 = '14452', $106 = '14453', $107 = '14454', $108 = '14455', $109 = '14456', $110 = '14457', $111 = '14458', $112 = '14459', $113 = '14460', $114 = '14461', $115 = '14462', $116 = '14463', $117 = '14464', $118 = '14465', $119 = '14466', $120 = '14467', $121 = '14471', $122 = '14472', $123 = '14473', $124 = '14474', $125 = '14475', $126 = '14476', $127 = '14477', $128 = '14478', $129 = '14479', $130 = '14480', $131 = '92305', $132 = '14482', $133 = '14483', $134 = '14488', $135 = '2201', $136 = '14489', $137 = '14490', $138 = '14491', $139 = '14492', $140 = '14493', $141 = '14494', $142 = '14495', $143 = '14496', $144 = '14497', $145 = '14498', $146 = '92323', $147 = '14499', $148 = '14500', $149 = '14501', $150 = '14502', $151 = '14503', $152 = '14504', $153 = '14505', $154 = '14506', $155 = '14507', $156 = '14508', $157 = '14509', $158 = '92332', $159 = '14511', $160 = '14512', $161 = '14513', $162 = '178', $163 = '14514', $164 = '14515', $165 = '14516', $166 = '14517', $167 = '14518', $168 = '14519', $169 = '14520', $170 = '14521', $171 = '14522', $172 = '14523', $173 = '14524', $174 = '14525', $175 = '14526', $176 = '14527', $177 = '14528', $178 = '14529', $179 = '14530', $180 = '14531', $181 = '14532', $182 = '14533', $183 = '14534', $184 = '14535', $185 = '14536', $186 = '123081', $187 = '14537', $188 = '14538', $189 = '14539', $190 = '14540', $191 = '14542', $192 = '14543', $193 = '14544', $194 = '14545', $195 = '143571', $196 = '14546', $197 = '1280193', $198 = '14547', $199 = '14548', $200 = '14549', $201 = '14550', $202 = '162004', $203 = '14551', $204 = '14552', $205 = '14553', $206 = '14554', $207 = '14555', $208 = '14556', $209 = '14557', $210 = '14558', $211 = '14559', $212 = '71902', $213 = '14560', $214 = '14561', $215 = '14562', $216 = '14563', $217 = '14564', $218 = '155878', $219 = '14565', $220 = '155879', $221 = '14566', $222 = '14567', $223 = '14568', $224 = '14569', $225 = '14570', $226 = '14571', $227 = '14572', $228 = '14573', $229 = '14574', $230 = '14575', $231 = '90350', $232 = '127214', $233 = '14576', $234 = '14577', $235 = '14578', $236 = '14579', $237 = '14580', $238 = '14581', $239 = '14582', $240 = '14583', $241 = '14584', $242 = '14585', $243 = '14586', $244 = '14587', $245 = '14588', $246 = '14589', $247 = '14590', $248 = '14591', $249 = '71934', $250 = '14592', $251 = '14593', $252 = '14594', $253 = '14595', $254 = '14596', $255 = '14597', $256 = '14598', $257 = '14599', $258 = '14600', $259 = '4361', $260 = '14602', $261 = '14603', $262 = '14604', $263 = '14605', $264 = '96524', $265 = '14606', $266 = '14607', $267 = '14608', $268 = '14609', $269 = '96531', $270 = '141584', $271 = '14611', $272 = '14612', $273 = '14613', $274 = '14615', $275 = '14616', $276 = '2328', $277 = '14617', $278 = '14618', $279 = '14619', $280 = '14620', $281 = '14621', $282 = '14622', $283 = '160028', $284 = '14623', $285 = '14624', $286 = '14625', $287 = '14626', $288 = '14627', $289 = '14628', $290 = '14629', $291 = '14630', $292 = '14631', $293 = '14632', $294 = '14633', $295 = '14634', $296 = '14635', $297 = '14636', $298 = '14637', $299 = '14638', $300 = '14639', $301 = '14640', $302 = '78129', $303 = '14641', $304 = '141619', $305 = '14642', $306 = '14643', $307 = '14644', $308 = '14645', $309 = '14646', $310 = '14647', $311 = '14648', $312 = '14649', $313 = '14650', $314 = '14651', $315 = '35131', $316 = '14652', $317 = '14653', $318 = '14654', $319 = '14655', $320 = '133442', $321 = '14656', $322 = '133443', $323 = '14657', $324 = '14658', $325 = '14659', $326 = '14660', $327 = '14661', $328 = '14662', $329 = '14663', $330 = '14664', $331 = '145738', $332 = '14665', $333 = '14666', $334 = '14667', $335 = '14668', $336 = '14669', $337 = '92492', $338 = '14670', $339 = '14671', $340 = '14672', $341 = '92497', $342 = '14673', $343 = '14674', $344 = '14675', $345 = '162129', $346 = '14676', $347 = '14677', $348 = '14678', $349 = '92503', $350 = '14679', $351 = '14680', $352 = '14681', $353 = '1265993', $354 = '14682', $355 = '92507', $356 = '14683', $357 = '14684', $358 = '14685', $359 = '14686', $360 = '14687', $361 = '92510', $362 = '14688', $363 = '92513', $364 = '14689', $365 = '92512', $366 = '14690', $367 = '14691', $368 = '14692', $369 = '14693', $370 = '14694', $371 = '14695', $372 = '14696', $373 = '172394', $374 = '14697', $375 = '172395', $376 = '14698', $377 = '164200', $378 = '14699', $379 = '164201', $380 = '14700', $381 = '14701', $382 = '14702', $383 = '172396', $384 = '14703', $385 = '92526', $386 = '172397', $387 = '14704', $388 = '14705', $389 = '14706', $390 = '14707', $391 = '14708', $392 = '14709', $393 = '14711', $394 = '14716', $395 = '14717', $396 = '14722', $397 = '76163', $398 = '14723', $399 = '14724', $400 = '14725', $401 = '14726', $402 = '14727', $403 = '4488', $404 = '14729', $405 = '14730', $406 = '14732', $407 = '14734', $408 = '14735', $409 = '14736', $410 = '14737', $411 = '14738', $412 = '14742', $413 = '14743', $414 = '14744', $415 = '14745', $416 = '14746', $417 = '14747', $418 = '133534', $419 = '14748', $420 = '14749', $421 = '133535', $422 = '14750', $423 = '14751', $424 = '14752', $425 = '14753', $426 = '14754', $427 = '160161', $428 = '14755', $429 = '14756', $430 = '139686', $431 = '14757', $432 = '14758', $433 = '14759', $434 = '14760', $435 = '14761', $436 = '14762', $437 = '76203', $438 = '14763', $439 = '141737', $440 = '14764', $441 = '14765', $442 = '14766', $443 = '14767', $444 = '14768', $445 = '14769', $446 = '14770', $447 = '141744', $448 = '14771', $449 = '14772', $450 = '14773', $451 = '14774', $452 = '92599', $453 = '14775', $454 = '14776', $455 = '14777', $456 = '14778', $457 = '14779', $458 = '43451', $459 = '121274', $460 = '14780', $461 = '14781', $462 = '14782', $463 = '14783', $464 = '14784', $465 = '14785', $466 = '14786', $467 = '14787', $468 = '14788', $469 = '14789', $470 = '14790', $471 = '14791', $472 = '14792', $473 = '14793', $474 = '14794', $475 = '14795', $476 = '14796', $477 = '14797', $478 = '14798', $479 = '14799', $480 = '14800', $481 = '14801', $482 = '14802', $483 = '14803', $484 = '14804', $485 = '14805', $486 = '14806', $487 = '14807', $488 = '14808', $489 = '14809', $490 = '14810', $491 = '14811', $492 = '14812', $493 = '14813', $494 = '14814', $495 = '14815', $496 = '4577', $497 = '14817', $498 = '14818', $499 = '14819', $500 = '14820', $501 = '14821', $502 = '14822', $503 = '14823', $504 = '14824', $505 = '14825', $506 = '129512', $507 = '14827', $508 = '14828', $509 = '14829', $510 = '14830', $511 = '14831', $512 = '14832', $513 = '14833', $514 = '14834', $515 = '14835', $516 = '14836', $517 = '14837', $518 = '14838', $519 = '14839', $520 = '14840', $521 = '14841', $522 = '14842', $523 = '14843', $524 = '14844', $525 = '14845', $526 = '14846', $527 = '14847', $528 = '14848', $529 = '14849', $530 = '76288', $531 = '14850', $532 = '14851', $533 = '14852', $534 = '14853', $535 = '14854', $536 = '14855', $537 = '14856', $538 = '14857', $539 = '14858', $540 = '14859', $541 = '14860', $542 = '14861', $543 = '14862', $544 = '14863', $545 = '14864', $546 = '2586', $547 = '141854', $548 = '207390', $549 = '141853', $550 = '1268273', $551 = '559', $552 = '129587', $553 = '129588', $554 = '2624', $555 = '141899', $556 = '299602', $557 = '76395', $558 = '162415', $559 = '82547', $560 = '2682', $561 = '4742', $562 = '657', $563 = '119447', $564 = '164512', $565 = '70325', $566 = '129724', $567 = '99007', $568 = '99008', $569 = '162515', $570 = '162519', $571 = '162516', $572 = '162520', $573 = '142054', $574 = '86761', $575 = '275191', $576 = '275193', $577 = '275194', $578 = '275195', $579 = '1215255', $580 = '105222', $581 = '782', $582 = '4879', $583 = '162594', $584 = '162595', $585 = '162592', $586 = '162593', $587 = '162598', $588 = '142134', $589 = '142167', $590 = '93022', $591 = '90985', $592 = '90998', $593 = '4988', $594 = '338810', $595 = '70545', $596 = '168849', $597 = '119701', $598 = '941', $599 = '5038', $600 = '5040', $601 = '258995', $602 = '258993', $603 = '5043', $604 = '5044', $605 = '1098660', $606 = '5045', $607 = '5046', $608 = '258997', $609 = '5048', $610 = '5050', $611 = '5052', $612 = '5053', $613 = '5054', $614 = '82879', $615 = '76734', $616 = '5056', $617 = '5058', $618 = '5060', $619 = '5061', $620 = '5062', $621 = '5063', $622 = '5064', $623 = '5066', $624 = '5068', $625 = '5069', $626 = '5070', $627 = '5071', $628 = '84942', $629 = '5072', $630 = '5076', $631 = '5077', $632 = '82900', $633 = '5078', $634 = '5080', $635 = '185306', $636 = '5081', $637 = '185307', $638 = '5082', $639 = '5083', $640 = '5084', $641 = '185310', $642 = '5085', $643 = '185311', $644 = '5086', $645 = '185308', $646 = '5087', $647 = '185309', $648 = '185314', $649 = '5089', $650 = '5090', $651 = '140256', $652 = '185312', $653 = '185313', $654 = '5092', $655 = '5093', $656 = '5094', $657 = '5095', $658 = '5096', $659 = '5097', $660 = '5098', $661 = '1002', $662 = '5099', $663 = '5100', $664 = '93165', $665 = '5101', $666 = '93164', $667 = '5102', $668 = '119791', $669 = '5103', $670 = '76782', $671 = '93166', $672 = '5104', $673 = '5105', $674 = '119792', $675 = '5107', $676 = '5109', $677 = '5110', $678 = '140276', $679 = '5111', $680 = '5112', $681 = '5113', $682 = '5115', $683 = '5116', $684 = '5117', $685 = '5118', $686 = '5119', $687 = '5120', $688 = '125953', $689 = '5121', $690 = '125952', $691 = '5122', $692 = '142336', $693 = '5124', $694 = '3076', $695 = '140295', $696 = '5126', $697 = '5127', $698 = '5128', $699 = '5129', $700 = '203790', $701 = '130085', $702 = '80932', $703 = '132138', $704 = '132139', $705 = '132142', $706 = '132141', $707 = '103473', $708 = '76883', $709 = '128082', $710 = '132182', $711 = '341085', $712 = '341084', $713 = '341087', $714 = '341086', $715 = '341080', $716 = '341083', $717 = '1119', $718 = '130145', $719 = '160866', $720 = '341092', $721 = '146534', $722 = '341089', $723 = '146535', $724 = '1125', $725 = '341088', $726 = '341091', $727 = '146533', $728 = '341090', $729 = '146536', $730 = '146537', $731 = '142446', $732 = '175246', $733 = '175244', $734 = '187542', $735 = '187540', $736 = '187546', $737 = '1227914', $738 = '1227915', $739 = '187545', $740 = '1227913', $741 = '162993', $742 = '128182', $743 = '130236', $744 = '3263', $745 = '136387', $746 = '136384', $747 = '136392', $748 = '136399', $749 = '136396', $750 = '87272', $751 = '341227', $752 = '3325', $753 = '77063', $754 = '3337', $755 = '77064', $756 = '77069', $757 = '1293', $758 = '140563', $759 = '175386', $760 = '175415', $761 = '23862', $762 = '1260842', $763 = '85318', $764 = '3405', $765 = '335191', $766 = '335190', $767 = '181591', $768 = '77145', $769 = '181593', $770 = '335193', $771 = '335192', $772 = '130404', $773 = '93545', $774 = '93546', $775 = '111997', $776 = '112021', $777 = '142743', $778 = '112022', $779 = '112026', $780 = '112037', $781 = '112038', $782 = '112041', $783 = '112042', $784 = '77229', $785 = '112047', $786 = '150956', $787 = '112048', $788 = '187830', $789 = '187831', $790 = '187829', $791 = '187834', $792 = '187835', $793 = '187832', $794 = '187833', $795 = '112061', $796 = '112063', $797 = '112065', $798 = '351684', $799 = '112064', $800 = '351687', $801 = '112068', $802 = '112070', $803 = '351689', $804 = '3535', $805 = '363984', $806 = '153044', $807 = '153045', $808 = '112092', $809 = '3571', $810 = '112114', $811 = '126460', $812 = '112126', $813 = '151040', $814 = '151041', $815 = '85513', $816 = '3596', $817 = '3610', $818 = '73243', $819 = '134690', $820 = '116263', $821 = '1244734', $822 = '46638', $823 = '48694', $824 = '83512', $825 = '128568', $826 = '110136', $827 = '3642', $828 = '142904', $829 = '142905', $830 = '128575', $831 = '333396', $832 = '345687', $833 = '345686', $834 = '345693', $835 = '345692', $836 = '345694', $837 = '345689', $838 = '345688', $839 = '345691', $840 = '163442', $841 = '163441', $842 = '1662', $843 = '263803', $844 = '93825', $845 = '140941', $846 = '356008', $847 = '1124009', $848 = '296642', $849 = '132817', $850 = '345808', $851 = '345810', $852 = '3804', $853 = '159452', $854 = '3808', $855 = '67301', $856 = '141029', $857 = '132847', $858 = '106223', $859 = '106225', $860 = '132848', $861 = '106226', $862 = '132849', $863 = '175871', $864 = '85760', $865 = '175872', $866 = '91911', $867 = '106250', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '333597', $872 = '333599', $873 = '333598', $874 = '190236', $875 = '1224498', $876 = '141088', $877 = '1224502', $878 = '333600', $879 = '124711', $880 = '333602', $881 = '91959', $882 = '1240906', $883 = '1242954', $884 = '1242955', $885 = '75611', $886 = '356190', $887 = '75612', $888 = '1242956', $889 = '1261388', $890 = '92007', $891 = '141162', $892 = '124791', $893 = '51063', $894 = '14205', $895 = '112515', $896 = '141184', $897 = '14225', $898 = '77717', $899 = '14228', $900 = '14229', $901 = '14231', $902 = '14232', $903 = '14234', $904 = '83867', $905 = '145304', $906 = '14235', $907 = '83868', $908 = '96156', $909 = '14238', $910 = '75679', $911 = '14239', $912 = '96158', $913 = '14241', $914 = '14242', $915 = '14243', $916 = '151457', $917 = '276391', $918 = '14244', $919 = '14245', $920 = '14246', $921 = '14247', $922 = '14248', $923 = '14249', $924 = '14250', $925 = '14251', $926 = '14252', $927 = '102316', $928 = '724927', $929 = '102324', $930 = '124852', $931 = '128951', $932 = '14264', $933 = '128953', $934 = '14265', $935 = '14266', $936 = '14267', $937 = '128954', $938 = '133049', $939 = '14269', $940 = '14270', $941 = '14272', $942 = '14273', $943 = '14274', $944 = '14275', $945 = '14276', $946 = '14277', $947 = '491457', $948 = '14278', $949 = '14279', $950 = '14280', $951 = '14281', $952 = '14282', $953 = '14283', $954 = '14284', $955 = '14285', $956 = '14286', $957 = '14287', $958 = '14288', $959 = '14289', $960 = '14291', $961 = '14292', $962 = '14293', $963 = '100308', $964 = '14294', $965 = '14295', $966 = '14296', $967 = '14298', $968 = '14299', $969 = '14300', $970 = '14301', $971 = '14302', $972 = '14303', $973 = '14304', $974 = '14305', $975 = '14306', $976 = '14307', $977 = '14308', $978 = '14309', $979 = '2021', $980 = '14311', $981 = '14312', $982 = '14313', $983 = '14315', $984 = '14316', $985 = '14317', $986 = '14320', $987 = '14322', $988 = '14323', $989 = '14324', $990 = '14325', $991 = '14326', $992 = '14327', $993 = '14328', $994 = '14329', $995 = '2041', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335'; [ Date: 2026-02-27 15:45:09 - Database: cnrs - User: a3d - Remote: 10.7.160.147 - Application: PostgreSQL JDBC Driver ] Explain plan Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5184.05..108311.20 rows=124195 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5150.50 rows=124195 width=0) Index Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,14330,14331,92157,14333,14335}'::bigint[]))

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4s908ms

1

Details

4s908ms

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
Feb 27	15	1	4s908ms	4s908ms

[ User: a3d - Total duration: 4s908ms - Times executed: 1 ]

[ Application: PostgreSQL JDBC Driver - Total duration: 4s908ms - 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 = '67585', $3 = '14337', $4 = '14338', $5 = '14339', $6 = '14342', $7 = '14343', $8 = '14344', $9 = '14345', $10 = '14346', $11 = '92171', $12 = '14347', $13 = '14349', $14 = '161807', $15 = '14350', $16 = '14351', $17 = '14352', $18 = '14353', $19 = '2066', $20 = '14354', $21 = '161808', $22 = '14355', $23 = '14356', $24 = '14357', $25 = '14358', $26 = '14359', $27 = '14361', $28 = '14363', $29 = '127002', $30 = '14364', $31 = '14365', $32 = '14366', $33 = '14367', $34 = '14368', $35 = '14369', $36 = '14370', $37 = '1286193', $38 = '14371', $39 = '14375', $40 = '14381', $41 = '14384', $42 = '14385', $43 = '14386', $44 = '92210', $45 = '143409', $46 = '147510', $47 = '2103', $48 = '14393', $49 = '14394', $50 = '14396', $51 = '14397', $52 = '14398', $53 = '14399', $54 = '14400', $55 = '14401', $56 = '14402', $57 = '14403', $58 = '14404', $59 = '14405', $60 = '14406', $61 = '14407', $62 = '14408', $63 = '14409', $64 = '108619', $65 = '14410', $66 = '14411', $67 = '14412', $68 = '14413', $69 = '14414', $70 = '122959', $71 = '14416', $72 = '14417', $73 = '14418', $74 = '14419', $75 = '83', $76 = '14420', $77 = '14421', $78 = '14422', $79 = '14423', $80 = '14424', $81 = '82011', $82 = '14428', $83 = '14431', $84 = '127070', $85 = '14432', $86 = '14433', $87 = '14434', $88 = '14436', $89 = '14437', $90 = '14438', $91 = '14439', $92 = '14440', $93 = '14441', $94 = '14442', $95 = '14443', $96 = '14444', $97 = '14445', $98 = '14446', $99 = '14447', $100 = '14448', $101 = '14449', $102 = '14450', $103 = '108659', $104 = '14451', $105 = '14452', $106 = '14453', $107 = '14454', $108 = '14455', $109 = '14456', $110 = '14457', $111 = '14458', $112 = '14459', $113 = '14460', $114 = '14461', $115 = '14462', $116 = '14463', $117 = '14464', $118 = '14465', $119 = '14466', $120 = '14467', $121 = '14471', $122 = '14472', $123 = '14473', $124 = '14474', $125 = '14475', $126 = '14476', $127 = '14477', $128 = '14478', $129 = '14479', $130 = '14480', $131 = '92305', $132 = '14482', $133 = '14483', $134 = '14488', $135 = '2201', $136 = '14489', $137 = '14490', $138 = '14491', $139 = '14492', $140 = '14493', $141 = '14494', $142 = '14495', $143 = '14496', $144 = '14497', $145 = '14498', $146 = '92323', $147 = '14499', $148 = '14500', $149 = '14501', $150 = '14502', $151 = '14503', $152 = '14504', $153 = '14505', $154 = '14506', $155 = '14507', $156 = '14508', $157 = '14509', $158 = '92332', $159 = '14511', $160 = '14512', $161 = '14513', $162 = '178', $163 = '14514', $164 = '14515', $165 = '14516', $166 = '14517', $167 = '14518', $168 = '14519', $169 = '14520', $170 = '14521', $171 = '14522', $172 = '14523', $173 = '14524', $174 = '14525', $175 = '14526', $176 = '14527', $177 = '14528', $178 = '14529', $179 = '14530', $180 = '14531', $181 = '14532', $182 = '14533', $183 = '14534', $184 = '14535', $185 = '14536', $186 = '123081', $187 = '14537', $188 = '14538', $189 = '14539', $190 = '14540', $191 = '14542', $192 = '14543', $193 = '14544', $194 = '14545', $195 = '143571', $196 = '14546', $197 = '1280193', $198 = '14547', $199 = '14548', $200 = '14549', $201 = '14550', $202 = '162004', $203 = '14551', $204 = '14552', $205 = '14553', $206 = '14554', $207 = '14555', $208 = '14556', $209 = '14557', $210 = '14558', $211 = '14559', $212 = '71902', $213 = '14560', $214 = '14561', $215 = '14562', $216 = '14563', $217 = '14564', $218 = '155878', $219 = '14565', $220 = '155879', $221 = '14566', $222 = '14567', $223 = '14568', $224 = '14569', $225 = '14570', $226 = '14571', $227 = '14572', $228 = '14573', $229 = '14574', $230 = '14575', $231 = '90350', $232 = '127214', $233 = '14576', $234 = '14577', $235 = '14578', $236 = '14579', $237 = '14580', $238 = '14581', $239 = '14582', $240 = '14583', $241 = '14584', $242 = '14585', $243 = '14586', $244 = '14587', $245 = '14588', $246 = '14589', $247 = '14590', $248 = '14591', $249 = '71934', $250 = '14592', $251 = '14593', $252 = '14594', $253 = '14595', $254 = '14596', $255 = '14597', $256 = '14598', $257 = '14599', $258 = '14600', $259 = '4361', $260 = '14602', $261 = '14603', $262 = '14604', $263 = '14605', $264 = '96524', $265 = '14606', $266 = '14607', $267 = '14608', $268 = '14609', $269 = '96531', $270 = '141584', $271 = '14611', $272 = '14612', $273 = '14613', $274 = '14615', $275 = '14616', $276 = '2328', $277 = '14617', $278 = '14618', $279 = '14619', $280 = '14620', $281 = '14621', $282 = '14622', $283 = '160028', $284 = '14623', $285 = '14624', $286 = '14625', $287 = '14626', $288 = '14627', $289 = '14628', $290 = '14629', $291 = '14630', $292 = '14631', $293 = '14632', $294 = '14633', $295 = '14634', $296 = '14635', $297 = '14636', $298 = '14637', $299 = '14638', $300 = '14639', $301 = '14640', $302 = '78129', $303 = '14641', $304 = '141619', $305 = '14642', $306 = '14643', $307 = '14644', $308 = '14645', $309 = '14646', $310 = '14647', $311 = '14648', $312 = '14649', $313 = '14650', $314 = '14651', $315 = '35131', $316 = '14652', $317 = '14653', $318 = '14654', $319 = '14655', $320 = '133442', $321 = '14656', $322 = '133443', $323 = '14657', $324 = '14658', $325 = '14659', $326 = '14660', $327 = '14661', $328 = '14662', $329 = '14663', $330 = '14664', $331 = '145738', $332 = '14665', $333 = '14666', $334 = '14667', $335 = '14668', $336 = '14669', $337 = '92492', $338 = '14670', $339 = '14671', $340 = '14672', $341 = '92497', $342 = '14673', $343 = '14674', $344 = '14675', $345 = '162129', $346 = '14676', $347 = '14677', $348 = '14678', $349 = '92503', $350 = '14679', $351 = '14680', $352 = '14681', $353 = '1265993', $354 = '14682', $355 = '92507', $356 = '14683', $357 = '14684', $358 = '14685', $359 = '14686', $360 = '14687', $361 = '92510', $362 = '14688', $363 = '92513', $364 = '14689', $365 = '92512', $366 = '14690', $367 = '14691', $368 = '14692', $369 = '14693', $370 = '14694', $371 = '14695', $372 = '14696', $373 = '172394', $374 = '14697', $375 = '172395', $376 = '14698', $377 = '164200', $378 = '14699', $379 = '164201', $380 = '14700', $381 = '14701', $382 = '14702', $383 = '172396', $384 = '14703', $385 = '92526', $386 = '172397', $387 = '14704', $388 = '14705', $389 = '14706', $390 = '14707', $391 = '14708', $392 = '14709', $393 = '14711', $394 = '14716', $395 = '14717', $396 = '14722', $397 = '76163', $398 = '14723', $399 = '14724', $400 = '14725', $401 = '14726', $402 = '14727', $403 = '4488', $404 = '14729', $405 = '14730', $406 = '14732', $407 = '14734', $408 = '14735', $409 = '14736', $410 = '14737', $411 = '14738', $412 = '14742', $413 = '14743', $414 = '14744', $415 = '14745', $416 = '14746', $417 = '14747', $418 = '133534', $419 = '14748', $420 = '14749', $421 = '133535', $422 = '14750', $423 = '14751', $424 = '14752', $425 = '14753', $426 = '14754', $427 = '160161', $428 = '14755', $429 = '14756', $430 = '139686', $431 = '14757', $432 = '14758', $433 = '14759', $434 = '14760', $435 = '14761', $436 = '14762', $437 = '76203', $438 = '14763', $439 = '141737', $440 = '14764', $441 = '14765', $442 = '14766', $443 = '14767', $444 = '14768', $445 = '14769', $446 = '14770', $447 = '141744', $448 = '14771', $449 = '14772', $450 = '14773', $451 = '14774', $452 = '92599', $453 = '14775', $454 = '14776', $455 = '14777', $456 = '14778', $457 = '14779', $458 = '43451', $459 = '121274', $460 = '14780', $461 = '14781', $462 = '14782', $463 = '14783', $464 = '14784', $465 = '14785', $466 = '14786', $467 = '14787', $468 = '14788', $469 = '14789', $470 = '14790', $471 = '14791', $472 = '14792', $473 = '14793', $474 = '14794', $475 = '14795', $476 = '14796', $477 = '14797', $478 = '14798', $479 = '14799', $480 = '14800', $481 = '14801', $482 = '14802', $483 = '14803', $484 = '14804', $485 = '14805', $486 = '14806', $487 = '14807', $488 = '14808', $489 = '14809', $490 = '14810', $491 = '14811', $492 = '14812', $493 = '14813', $494 = '14814', $495 = '14815', $496 = '4577', $497 = '14817', $498 = '14818', $499 = '14819', $500 = '14820', $501 = '14821', $502 = '14822', $503 = '14823', $504 = '14824', $505 = '14825', $506 = '129512', $507 = '14827', $508 = '14828', $509 = '14829', $510 = '14830', $511 = '14831', $512 = '14832', $513 = '14833', $514 = '14834', $515 = '14835', $516 = '14836', $517 = '14837', $518 = '14838', $519 = '14839', $520 = '14840', $521 = '14841', $522 = '14842', $523 = '14843', $524 = '14844', $525 = '14845', $526 = '14846', $527 = '14847', $528 = '14848', $529 = '14849', $530 = '76288', $531 = '14850', $532 = '14851', $533 = '14852', $534 = '14853', $535 = '14854', $536 = '14855', $537 = '14856', $538 = '14857', $539 = '14858', $540 = '14859', $541 = '14860', $542 = '14861', $543 = '14862', $544 = '14863', $545 = '14864', $546 = '2586', $547 = '141854', $548 = '207390', $549 = '141853', $550 = '1268273', $551 = '559', $552 = '129587', $553 = '129588', $554 = '2624', $555 = '141899', $556 = '299602', $557 = '76395', $558 = '162415', $559 = '82547', $560 = '2682', $561 = '4742', $562 = '657', $563 = '119447', $564 = '164512', $565 = '70325', $566 = '129724', $567 = '99007', $568 = '99008', $569 = '162515', $570 = '162519', $571 = '162516', $572 = '162520', $573 = '142054', $574 = '86761', $575 = '275191', $576 = '275193', $577 = '275194', $578 = '275195', $579 = '1215255', $580 = '105222', $581 = '782', $582 = '4879', $583 = '162594', $584 = '162595', $585 = '162592', $586 = '162593', $587 = '162598', $588 = '142134', $589 = '142167', $590 = '93022', $591 = '90985', $592 = '90998', $593 = '4988', $594 = '338810', $595 = '70545', $596 = '168849', $597 = '119701', $598 = '941', $599 = '5038', $600 = '5040', $601 = '258995', $602 = '258993', $603 = '5043', $604 = '5044', $605 = '1098660', $606 = '5045', $607 = '5046', $608 = '258997', $609 = '5048', $610 = '5050', $611 = '5052', $612 = '5053', $613 = '5054', $614 = '82879', $615 = '76734', $616 = '5056', $617 = '5058', $618 = '5060', $619 = '5061', $620 = '5062', $621 = '5063', $622 = '5064', $623 = '5066', $624 = '5068', $625 = '5069', $626 = '5070', $627 = '5071', $628 = '84942', $629 = '5072', $630 = '5076', $631 = '5077', $632 = '82900', $633 = '5078', $634 = '5080', $635 = '185306', $636 = '5081', $637 = '185307', $638 = '5082', $639 = '5083', $640 = '5084', $641 = '185310', $642 = '5085', $643 = '185311', $644 = '5086', $645 = '185308', $646 = '5087', $647 = '185309', $648 = '185314', $649 = '5089', $650 = '5090', $651 = '140256', $652 = '185312', $653 = '185313', $654 = '5092', $655 = '5093', $656 = '5094', $657 = '5095', $658 = '5096', $659 = '5097', $660 = '5098', $661 = '1002', $662 = '5099', $663 = '5100', $664 = '93165', $665 = '5101', $666 = '93164', $667 = '5102', $668 = '119791', $669 = '5103', $670 = '76782', $671 = '93166', $672 = '5104', $673 = '5105', $674 = '119792', $675 = '5107', $676 = '5109', $677 = '5110', $678 = '140276', $679 = '5111', $680 = '5112', $681 = '5113', $682 = '5115', $683 = '5116', $684 = '5117', $685 = '5118', $686 = '5119', $687 = '5120', $688 = '125953', $689 = '5121', $690 = '125952', $691 = '5122', $692 = '142336', $693 = '5124', $694 = '3076', $695 = '140295', $696 = '5126', $697 = '5127', $698 = '5128', $699 = '5129', $700 = '203790', $701 = '130085', $702 = '80932', $703 = '132138', $704 = '132139', $705 = '132142', $706 = '132141', $707 = '103473', $708 = '76883', $709 = '128082', $710 = '132182', $711 = '341085', $712 = '341084', $713 = '341087', $714 = '341086', $715 = '341080', $716 = '341083', $717 = '1119', $718 = '130145', $719 = '160866', $720 = '341092', $721 = '146534', $722 = '341089', $723 = '146535', $724 = '1125', $725 = '341088', $726 = '341091', $727 = '146533', $728 = '341090', $729 = '146536', $730 = '146537', $731 = '142446', $732 = '175246', $733 = '175244', $734 = '187542', $735 = '187540', $736 = '187546', $737 = '1227914', $738 = '1227915', $739 = '187545', $740 = '1227913', $741 = '162993', $742 = '128182', $743 = '130236', $744 = '3263', $745 = '136387', $746 = '136384', $747 = '136392', $748 = '136399', $749 = '136396', $750 = '87272', $751 = '341227', $752 = '3325', $753 = '77063', $754 = '3337', $755 = '77064', $756 = '77069', $757 = '1293', $758 = '140563', $759 = '175386', $760 = '175415', $761 = '23862', $762 = '1260842', $763 = '85318', $764 = '3405', $765 = '335191', $766 = '335190', $767 = '181591', $768 = '77145', $769 = '181593', $770 = '335193', $771 = '335192', $772 = '130404', $773 = '93545', $774 = '93546', $775 = '111997', $776 = '112021', $777 = '142743', $778 = '112022', $779 = '112026', $780 = '112037', $781 = '112038', $782 = '112041', $783 = '112042', $784 = '77229', $785 = '112047', $786 = '150956', $787 = '112048', $788 = '187830', $789 = '187831', $790 = '187829', $791 = '187834', $792 = '187835', $793 = '187832', $794 = '187833', $795 = '112061', $796 = '112063', $797 = '112065', $798 = '351684', $799 = '112064', $800 = '351687', $801 = '112068', $802 = '112070', $803 = '351689', $804 = '3535', $805 = '363984', $806 = '153044', $807 = '153045', $808 = '112092', $809 = '3571', $810 = '112114', $811 = '126460', $812 = '112126', $813 = '151040', $814 = '151041', $815 = '85513', $816 = '3596', $817 = '3610', $818 = '73243', $819 = '134690', $820 = '116263', $821 = '1244734', $822 = '46638', $823 = '48694', $824 = '83512', $825 = '128568', $826 = '110136', $827 = '3642', $828 = '142904', $829 = '142905', $830 = '128575', $831 = '333396', $832 = '345687', $833 = '345686', $834 = '345693', $835 = '345692', $836 = '345694', $837 = '345689', $838 = '345688', $839 = '345691', $840 = '163442', $841 = '163441', $842 = '1662', $843 = '263803', $844 = '93825', $845 = '140941', $846 = '356008', $847 = '1124009', $848 = '296642', $849 = '132817', $850 = '345808', $851 = '345810', $852 = '3804', $853 = '159452', $854 = '3808', $855 = '67301', $856 = '141029', $857 = '132847', $858 = '106223', $859 = '106225', $860 = '132848', $861 = '106226', $862 = '132849', $863 = '175871', $864 = '85760', $865 = '175872', $866 = '91911', $867 = '106250', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '333597', $872 = '333599', $873 = '333598', $874 = '190236', $875 = '1224498', $876 = '141088', $877 = '1224502', $878 = '333600', $879 = '124711', $880 = '333602', $881 = '91959', $882 = '1240906', $883 = '1242954', $884 = '1242955', $885 = '75611', $886 = '356190', $887 = '75612', $888 = '1242956', $889 = '1261388', $890 = '92007', $891 = '141162', $892 = '124791', $893 = '51063', $894 = '14205', $895 = '112515', $896 = '141184', $897 = '14225', $898 = '77717', $899 = '14228', $900 = '14229', $901 = '14231', $902 = '14232', $903 = '14234', $904 = '83867', $905 = '145304', $906 = '14235', $907 = '83868', $908 = '96156', $909 = '14238', $910 = '75679', $911 = '14239', $912 = '96158', $913 = '14241', $914 = '14242', $915 = '14243', $916 = '151457', $917 = '276391', $918 = '14244', $919 = '14245', $920 = '14246', $921 = '14247', $922 = '14248', $923 = '14249', $924 = '14250', $925 = '14251', $926 = '14252', $927 = '102316', $928 = '724927', $929 = '102324', $930 = '124852', $931 = '128951', $932 = '14264', $933 = '128953', $934 = '14265', $935 = '14266', $936 = '14267', $937 = '128954', $938 = '133049', $939 = '14269', $940 = '14270', $941 = '14272', $942 = '14273', $943 = '14274', $944 = '14275', $945 = '14276', $946 = '14277', $947 = '491457', $948 = '14278', $949 = '14279', $950 = '14280', $951 = '14281', $952 = '14282', $953 = '14283', $954 = '14284', $955 = '14285', $956 = '14286', $957 = '14287', $958 = '14288', $959 = '14289', $960 = '14291', $961 = '14292', $962 = '14293', $963 = '100308', $964 = '14294', $965 = '14295', $966 = '14296', $967 = '14298', $968 = '14299', $969 = '14300', $970 = '14301', $971 = '14302', $972 = '14303', $973 = '14304', $974 = '14305', $975 = '14306', $976 = '14307', $977 = '14308', $978 = '14309', $979 = '2021', $980 = '14311', $981 = '14312', $982 = '14313', $983 = '14315', $984 = '14316', $985 = '14317', $986 = '14320', $987 = '14322', $988 = '14323', $989 = '14324', $990 = '14325', $991 = '14326', $992 = '14327', $993 = '14328', $994 = '14329', $995 = '2041', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335';

Date: 2026-02-27 15:45:09 Duration: 4s908ms Database: cnrs User: a3d Remote: 10.7.160.147 Application: PostgreSQL JDBC Driver

Explain plan

Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5184.05..108311.20 rows=124195 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5150.50 rows=124195 width=0) Index Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,14330,14331,92157,14333,14335}'::bigint[]))

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

Details

4s908ms

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
Feb 27	15	1	4s908ms	4s908ms

[ User: a3d - Total duration: 4s908ms - Times executed: 1 ]

[ Application: PostgreSQL JDBC Driver - Total duration: 4s908ms - 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 = '67585', $3 = '14337', $4 = '14338', $5 = '14339', $6 = '14342', $7 = '14343', $8 = '14344', $9 = '14345', $10 = '14346', $11 = '92171', $12 = '14347', $13 = '14349', $14 = '161807', $15 = '14350', $16 = '14351', $17 = '14352', $18 = '14353', $19 = '2066', $20 = '14354', $21 = '161808', $22 = '14355', $23 = '14356', $24 = '14357', $25 = '14358', $26 = '14359', $27 = '14361', $28 = '14363', $29 = '127002', $30 = '14364', $31 = '14365', $32 = '14366', $33 = '14367', $34 = '14368', $35 = '14369', $36 = '14370', $37 = '1286193', $38 = '14371', $39 = '14375', $40 = '14381', $41 = '14384', $42 = '14385', $43 = '14386', $44 = '92210', $45 = '143409', $46 = '147510', $47 = '2103', $48 = '14393', $49 = '14394', $50 = '14396', $51 = '14397', $52 = '14398', $53 = '14399', $54 = '14400', $55 = '14401', $56 = '14402', $57 = '14403', $58 = '14404', $59 = '14405', $60 = '14406', $61 = '14407', $62 = '14408', $63 = '14409', $64 = '108619', $65 = '14410', $66 = '14411', $67 = '14412', $68 = '14413', $69 = '14414', $70 = '122959', $71 = '14416', $72 = '14417', $73 = '14418', $74 = '14419', $75 = '83', $76 = '14420', $77 = '14421', $78 = '14422', $79 = '14423', $80 = '14424', $81 = '82011', $82 = '14428', $83 = '14431', $84 = '127070', $85 = '14432', $86 = '14433', $87 = '14434', $88 = '14436', $89 = '14437', $90 = '14438', $91 = '14439', $92 = '14440', $93 = '14441', $94 = '14442', $95 = '14443', $96 = '14444', $97 = '14445', $98 = '14446', $99 = '14447', $100 = '14448', $101 = '14449', $102 = '14450', $103 = '108659', $104 = '14451', $105 = '14452', $106 = '14453', $107 = '14454', $108 = '14455', $109 = '14456', $110 = '14457', $111 = '14458', $112 = '14459', $113 = '14460', $114 = '14461', $115 = '14462', $116 = '14463', $117 = '14464', $118 = '14465', $119 = '14466', $120 = '14467', $121 = '14471', $122 = '14472', $123 = '14473', $124 = '14474', $125 = '14475', $126 = '14476', $127 = '14477', $128 = '14478', $129 = '14479', $130 = '14480', $131 = '92305', $132 = '14482', $133 = '14483', $134 = '14488', $135 = '2201', $136 = '14489', $137 = '14490', $138 = '14491', $139 = '14492', $140 = '14493', $141 = '14494', $142 = '14495', $143 = '14496', $144 = '14497', $145 = '14498', $146 = '92323', $147 = '14499', $148 = '14500', $149 = '14501', $150 = '14502', $151 = '14503', $152 = '14504', $153 = '14505', $154 = '14506', $155 = '14507', $156 = '14508', $157 = '14509', $158 = '92332', $159 = '14511', $160 = '14512', $161 = '14513', $162 = '178', $163 = '14514', $164 = '14515', $165 = '14516', $166 = '14517', $167 = '14518', $168 = '14519', $169 = '14520', $170 = '14521', $171 = '14522', $172 = '14523', $173 = '14524', $174 = '14525', $175 = '14526', $176 = '14527', $177 = '14528', $178 = '14529', $179 = '14530', $180 = '14531', $181 = '14532', $182 = '14533', $183 = '14534', $184 = '14535', $185 = '14536', $186 = '123081', $187 = '14537', $188 = '14538', $189 = '14539', $190 = '14540', $191 = '14542', $192 = '14543', $193 = '14544', $194 = '14545', $195 = '143571', $196 = '14546', $197 = '1280193', $198 = '14547', $199 = '14548', $200 = '14549', $201 = '14550', $202 = '162004', $203 = '14551', $204 = '14552', $205 = '14553', $206 = '14554', $207 = '14555', $208 = '14556', $209 = '14557', $210 = '14558', $211 = '14559', $212 = '71902', $213 = '14560', $214 = '14561', $215 = '14562', $216 = '14563', $217 = '14564', $218 = '155878', $219 = '14565', $220 = '155879', $221 = '14566', $222 = '14567', $223 = '14568', $224 = '14569', $225 = '14570', $226 = '14571', $227 = '14572', $228 = '14573', $229 = '14574', $230 = '14575', $231 = '90350', $232 = '127214', $233 = '14576', $234 = '14577', $235 = '14578', $236 = '14579', $237 = '14580', $238 = '14581', $239 = '14582', $240 = '14583', $241 = '14584', $242 = '14585', $243 = '14586', $244 = '14587', $245 = '14588', $246 = '14589', $247 = '14590', $248 = '14591', $249 = '71934', $250 = '14592', $251 = '14593', $252 = '14594', $253 = '14595', $254 = '14596', $255 = '14597', $256 = '14598', $257 = '14599', $258 = '14600', $259 = '4361', $260 = '14602', $261 = '14603', $262 = '14604', $263 = '14605', $264 = '96524', $265 = '14606', $266 = '14607', $267 = '14608', $268 = '14609', $269 = '96531', $270 = '141584', $271 = '14611', $272 = '14612', $273 = '14613', $274 = '14615', $275 = '14616', $276 = '2328', $277 = '14617', $278 = '14618', $279 = '14619', $280 = '14620', $281 = '14621', $282 = '14622', $283 = '160028', $284 = '14623', $285 = '14624', $286 = '14625', $287 = '14626', $288 = '14627', $289 = '14628', $290 = '14629', $291 = '14630', $292 = '14631', $293 = '14632', $294 = '14633', $295 = '14634', $296 = '14635', $297 = '14636', $298 = '14637', $299 = '14638', $300 = '14639', $301 = '14640', $302 = '78129', $303 = '14641', $304 = '141619', $305 = '14642', $306 = '14643', $307 = '14644', $308 = '14645', $309 = '14646', $310 = '14647', $311 = '14648', $312 = '14649', $313 = '14650', $314 = '14651', $315 = '35131', $316 = '14652', $317 = '14653', $318 = '14654', $319 = '14655', $320 = '133442', $321 = '14656', $322 = '133443', $323 = '14657', $324 = '14658', $325 = '14659', $326 = '14660', $327 = '14661', $328 = '14662', $329 = '14663', $330 = '14664', $331 = '145738', $332 = '14665', $333 = '14666', $334 = '14667', $335 = '14668', $336 = '14669', $337 = '92492', $338 = '14670', $339 = '14671', $340 = '14672', $341 = '92497', $342 = '14673', $343 = '14674', $344 = '14675', $345 = '162129', $346 = '14676', $347 = '14677', $348 = '14678', $349 = '92503', $350 = '14679', $351 = '14680', $352 = '14681', $353 = '1265993', $354 = '14682', $355 = '92507', $356 = '14683', $357 = '14684', $358 = '14685', $359 = '14686', $360 = '14687', $361 = '92510', $362 = '14688', $363 = '92513', $364 = '14689', $365 = '92512', $366 = '14690', $367 = '14691', $368 = '14692', $369 = '14693', $370 = '14694', $371 = '14695', $372 = '14696', $373 = '172394', $374 = '14697', $375 = '172395', $376 = '14698', $377 = '164200', $378 = '14699', $379 = '164201', $380 = '14700', $381 = '14701', $382 = '14702', $383 = '172396', $384 = '14703', $385 = '92526', $386 = '172397', $387 = '14704', $388 = '14705', $389 = '14706', $390 = '14707', $391 = '14708', $392 = '14709', $393 = '14711', $394 = '14716', $395 = '14717', $396 = '14722', $397 = '76163', $398 = '14723', $399 = '14724', $400 = '14725', $401 = '14726', $402 = '14727', $403 = '4488', $404 = '14729', $405 = '14730', $406 = '14732', $407 = '14734', $408 = '14735', $409 = '14736', $410 = '14737', $411 = '14738', $412 = '14742', $413 = '14743', $414 = '14744', $415 = '14745', $416 = '14746', $417 = '14747', $418 = '133534', $419 = '14748', $420 = '14749', $421 = '133535', $422 = '14750', $423 = '14751', $424 = '14752', $425 = '14753', $426 = '14754', $427 = '160161', $428 = '14755', $429 = '14756', $430 = '139686', $431 = '14757', $432 = '14758', $433 = '14759', $434 = '14760', $435 = '14761', $436 = '14762', $437 = '76203', $438 = '14763', $439 = '141737', $440 = '14764', $441 = '14765', $442 = '14766', $443 = '14767', $444 = '14768', $445 = '14769', $446 = '14770', $447 = '141744', $448 = '14771', $449 = '14772', $450 = '14773', $451 = '14774', $452 = '92599', $453 = '14775', $454 = '14776', $455 = '14777', $456 = '14778', $457 = '14779', $458 = '43451', $459 = '121274', $460 = '14780', $461 = '14781', $462 = '14782', $463 = '14783', $464 = '14784', $465 = '14785', $466 = '14786', $467 = '14787', $468 = '14788', $469 = '14789', $470 = '14790', $471 = '14791', $472 = '14792', $473 = '14793', $474 = '14794', $475 = '14795', $476 = '14796', $477 = '14797', $478 = '14798', $479 = '14799', $480 = '14800', $481 = '14801', $482 = '14802', $483 = '14803', $484 = '14804', $485 = '14805', $486 = '14806', $487 = '14807', $488 = '14808', $489 = '14809', $490 = '14810', $491 = '14811', $492 = '14812', $493 = '14813', $494 = '14814', $495 = '14815', $496 = '4577', $497 = '14817', $498 = '14818', $499 = '14819', $500 = '14820', $501 = '14821', $502 = '14822', $503 = '14823', $504 = '14824', $505 = '14825', $506 = '129512', $507 = '14827', $508 = '14828', $509 = '14829', $510 = '14830', $511 = '14831', $512 = '14832', $513 = '14833', $514 = '14834', $515 = '14835', $516 = '14836', $517 = '14837', $518 = '14838', $519 = '14839', $520 = '14840', $521 = '14841', $522 = '14842', $523 = '14843', $524 = '14844', $525 = '14845', $526 = '14846', $527 = '14847', $528 = '14848', $529 = '14849', $530 = '76288', $531 = '14850', $532 = '14851', $533 = '14852', $534 = '14853', $535 = '14854', $536 = '14855', $537 = '14856', $538 = '14857', $539 = '14858', $540 = '14859', $541 = '14860', $542 = '14861', $543 = '14862', $544 = '14863', $545 = '14864', $546 = '2586', $547 = '141854', $548 = '207390', $549 = '141853', $550 = '1268273', $551 = '559', $552 = '129587', $553 = '129588', $554 = '2624', $555 = '141899', $556 = '299602', $557 = '76395', $558 = '162415', $559 = '82547', $560 = '2682', $561 = '4742', $562 = '657', $563 = '119447', $564 = '164512', $565 = '70325', $566 = '129724', $567 = '99007', $568 = '99008', $569 = '162515', $570 = '162519', $571 = '162516', $572 = '162520', $573 = '142054', $574 = '86761', $575 = '275191', $576 = '275193', $577 = '275194', $578 = '275195', $579 = '1215255', $580 = '105222', $581 = '782', $582 = '4879', $583 = '162594', $584 = '162595', $585 = '162592', $586 = '162593', $587 = '162598', $588 = '142134', $589 = '142167', $590 = '93022', $591 = '90985', $592 = '90998', $593 = '4988', $594 = '338810', $595 = '70545', $596 = '168849', $597 = '119701', $598 = '941', $599 = '5038', $600 = '5040', $601 = '258995', $602 = '258993', $603 = '5043', $604 = '5044', $605 = '1098660', $606 = '5045', $607 = '5046', $608 = '258997', $609 = '5048', $610 = '5050', $611 = '5052', $612 = '5053', $613 = '5054', $614 = '82879', $615 = '76734', $616 = '5056', $617 = '5058', $618 = '5060', $619 = '5061', $620 = '5062', $621 = '5063', $622 = '5064', $623 = '5066', $624 = '5068', $625 = '5069', $626 = '5070', $627 = '5071', $628 = '84942', $629 = '5072', $630 = '5076', $631 = '5077', $632 = '82900', $633 = '5078', $634 = '5080', $635 = '185306', $636 = '5081', $637 = '185307', $638 = '5082', $639 = '5083', $640 = '5084', $641 = '185310', $642 = '5085', $643 = '185311', $644 = '5086', $645 = '185308', $646 = '5087', $647 = '185309', $648 = '185314', $649 = '5089', $650 = '5090', $651 = '140256', $652 = '185312', $653 = '185313', $654 = '5092', $655 = '5093', $656 = '5094', $657 = '5095', $658 = '5096', $659 = '5097', $660 = '5098', $661 = '1002', $662 = '5099', $663 = '5100', $664 = '93165', $665 = '5101', $666 = '93164', $667 = '5102', $668 = '119791', $669 = '5103', $670 = '76782', $671 = '93166', $672 = '5104', $673 = '5105', $674 = '119792', $675 = '5107', $676 = '5109', $677 = '5110', $678 = '140276', $679 = '5111', $680 = '5112', $681 = '5113', $682 = '5115', $683 = '5116', $684 = '5117', $685 = '5118', $686 = '5119', $687 = '5120', $688 = '125953', $689 = '5121', $690 = '125952', $691 = '5122', $692 = '142336', $693 = '5124', $694 = '3076', $695 = '140295', $696 = '5126', $697 = '5127', $698 = '5128', $699 = '5129', $700 = '203790', $701 = '130085', $702 = '80932', $703 = '132138', $704 = '132139', $705 = '132142', $706 = '132141', $707 = '103473', $708 = '76883', $709 = '128082', $710 = '132182', $711 = '341085', $712 = '341084', $713 = '341087', $714 = '341086', $715 = '341080', $716 = '341083', $717 = '1119', $718 = '130145', $719 = '160866', $720 = '341092', $721 = '146534', $722 = '341089', $723 = '146535', $724 = '1125', $725 = '341088', $726 = '341091', $727 = '146533', $728 = '341090', $729 = '146536', $730 = '146537', $731 = '142446', $732 = '175246', $733 = '175244', $734 = '187542', $735 = '187540', $736 = '187546', $737 = '1227914', $738 = '1227915', $739 = '187545', $740 = '1227913', $741 = '162993', $742 = '128182', $743 = '130236', $744 = '3263', $745 = '136387', $746 = '136384', $747 = '136392', $748 = '136399', $749 = '136396', $750 = '87272', $751 = '341227', $752 = '3325', $753 = '77063', $754 = '3337', $755 = '77064', $756 = '77069', $757 = '1293', $758 = '140563', $759 = '175386', $760 = '175415', $761 = '23862', $762 = '1260842', $763 = '85318', $764 = '3405', $765 = '335191', $766 = '335190', $767 = '181591', $768 = '77145', $769 = '181593', $770 = '335193', $771 = '335192', $772 = '130404', $773 = '93545', $774 = '93546', $775 = '111997', $776 = '112021', $777 = '142743', $778 = '112022', $779 = '112026', $780 = '112037', $781 = '112038', $782 = '112041', $783 = '112042', $784 = '77229', $785 = '112047', $786 = '150956', $787 = '112048', $788 = '187830', $789 = '187831', $790 = '187829', $791 = '187834', $792 = '187835', $793 = '187832', $794 = '187833', $795 = '112061', $796 = '112063', $797 = '112065', $798 = '351684', $799 = '112064', $800 = '351687', $801 = '112068', $802 = '112070', $803 = '351689', $804 = '3535', $805 = '363984', $806 = '153044', $807 = '153045', $808 = '112092', $809 = '3571', $810 = '112114', $811 = '126460', $812 = '112126', $813 = '151040', $814 = '151041', $815 = '85513', $816 = '3596', $817 = '3610', $818 = '73243', $819 = '134690', $820 = '116263', $821 = '1244734', $822 = '46638', $823 = '48694', $824 = '83512', $825 = '128568', $826 = '110136', $827 = '3642', $828 = '142904', $829 = '142905', $830 = '128575', $831 = '333396', $832 = '345687', $833 = '345686', $834 = '345693', $835 = '345692', $836 = '345694', $837 = '345689', $838 = '345688', $839 = '345691', $840 = '163442', $841 = '163441', $842 = '1662', $843 = '263803', $844 = '93825', $845 = '140941', $846 = '356008', $847 = '1124009', $848 = '296642', $849 = '132817', $850 = '345808', $851 = '345810', $852 = '3804', $853 = '159452', $854 = '3808', $855 = '67301', $856 = '141029', $857 = '132847', $858 = '106223', $859 = '106225', $860 = '132848', $861 = '106226', $862 = '132849', $863 = '175871', $864 = '85760', $865 = '175872', $866 = '91911', $867 = '106250', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '333597', $872 = '333599', $873 = '333598', $874 = '190236', $875 = '1224498', $876 = '141088', $877 = '1224502', $878 = '333600', $879 = '124711', $880 = '333602', $881 = '91959', $882 = '1240906', $883 = '1242954', $884 = '1242955', $885 = '75611', $886 = '356190', $887 = '75612', $888 = '1242956', $889 = '1261388', $890 = '92007', $891 = '141162', $892 = '124791', $893 = '51063', $894 = '14205', $895 = '112515', $896 = '141184', $897 = '14225', $898 = '77717', $899 = '14228', $900 = '14229', $901 = '14231', $902 = '14232', $903 = '14234', $904 = '83867', $905 = '145304', $906 = '14235', $907 = '83868', $908 = '96156', $909 = '14238', $910 = '75679', $911 = '14239', $912 = '96158', $913 = '14241', $914 = '14242', $915 = '14243', $916 = '151457', $917 = '276391', $918 = '14244', $919 = '14245', $920 = '14246', $921 = '14247', $922 = '14248', $923 = '14249', $924 = '14250', $925 = '14251', $926 = '14252', $927 = '102316', $928 = '724927', $929 = '102324', $930 = '124852', $931 = '128951', $932 = '14264', $933 = '128953', $934 = '14265', $935 = '14266', $936 = '14267', $937 = '128954', $938 = '133049', $939 = '14269', $940 = '14270', $941 = '14272', $942 = '14273', $943 = '14274', $944 = '14275', $945 = '14276', $946 = '14277', $947 = '491457', $948 = '14278', $949 = '14279', $950 = '14280', $951 = '14281', $952 = '14282', $953 = '14283', $954 = '14284', $955 = '14285', $956 = '14286', $957 = '14287', $958 = '14288', $959 = '14289', $960 = '14291', $961 = '14292', $962 = '14293', $963 = '100308', $964 = '14294', $965 = '14295', $966 = '14296', $967 = '14298', $968 = '14299', $969 = '14300', $970 = '14301', $971 = '14302', $972 = '14303', $973 = '14304', $974 = '14305', $975 = '14306', $976 = '14307', $977 = '14308', $978 = '14309', $979 = '2021', $980 = '14311', $981 = '14312', $982 = '14313', $983 = '14315', $984 = '14316', $985 = '14317', $986 = '14320', $987 = '14322', $988 = '14323', $989 = '14324', $990 = '14325', $991 = '14326', $992 = '14327', $993 = '14328', $994 = '14329', $995 = '2041', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335';

Date: 2026-02-27 15:45:09 Duration: 4s908ms Database: cnrs User: a3d Remote: 10.7.160.147 Application: PostgreSQL JDBC Driver

Explain plan

Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5184.05..108311.20 rows=124195 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5150.50 rows=124195 width=0) Index Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,14330,14331,92157,14333,14335}'::bigint[]))

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

4s908ms

1

Details

4s908ms

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
Feb 27	15	1	4s908ms	4s908ms

[ User: a3d - Total duration: 4s908ms - Times executed: 1 ]

[ Application: PostgreSQL JDBC Driver - Total duration: 4s908ms - 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 = '67585', $3 = '14337', $4 = '14338', $5 = '14339', $6 = '14342', $7 = '14343', $8 = '14344', $9 = '14345', $10 = '14346', $11 = '92171', $12 = '14347', $13 = '14349', $14 = '161807', $15 = '14350', $16 = '14351', $17 = '14352', $18 = '14353', $19 = '2066', $20 = '14354', $21 = '161808', $22 = '14355', $23 = '14356', $24 = '14357', $25 = '14358', $26 = '14359', $27 = '14361', $28 = '14363', $29 = '127002', $30 = '14364', $31 = '14365', $32 = '14366', $33 = '14367', $34 = '14368', $35 = '14369', $36 = '14370', $37 = '1286193', $38 = '14371', $39 = '14375', $40 = '14381', $41 = '14384', $42 = '14385', $43 = '14386', $44 = '92210', $45 = '143409', $46 = '147510', $47 = '2103', $48 = '14393', $49 = '14394', $50 = '14396', $51 = '14397', $52 = '14398', $53 = '14399', $54 = '14400', $55 = '14401', $56 = '14402', $57 = '14403', $58 = '14404', $59 = '14405', $60 = '14406', $61 = '14407', $62 = '14408', $63 = '14409', $64 = '108619', $65 = '14410', $66 = '14411', $67 = '14412', $68 = '14413', $69 = '14414', $70 = '122959', $71 = '14416', $72 = '14417', $73 = '14418', $74 = '14419', $75 = '83', $76 = '14420', $77 = '14421', $78 = '14422', $79 = '14423', $80 = '14424', $81 = '82011', $82 = '14428', $83 = '14431', $84 = '127070', $85 = '14432', $86 = '14433', $87 = '14434', $88 = '14436', $89 = '14437', $90 = '14438', $91 = '14439', $92 = '14440', $93 = '14441', $94 = '14442', $95 = '14443', $96 = '14444', $97 = '14445', $98 = '14446', $99 = '14447', $100 = '14448', $101 = '14449', $102 = '14450', $103 = '108659', $104 = '14451', $105 = '14452', $106 = '14453', $107 = '14454', $108 = '14455', $109 = '14456', $110 = '14457', $111 = '14458', $112 = '14459', $113 = '14460', $114 = '14461', $115 = '14462', $116 = '14463', $117 = '14464', $118 = '14465', $119 = '14466', $120 = '14467', $121 = '14471', $122 = '14472', $123 = '14473', $124 = '14474', $125 = '14475', $126 = '14476', $127 = '14477', $128 = '14478', $129 = '14479', $130 = '14480', $131 = '92305', $132 = '14482', $133 = '14483', $134 = '14488', $135 = '2201', $136 = '14489', $137 = '14490', $138 = '14491', $139 = '14492', $140 = '14493', $141 = '14494', $142 = '14495', $143 = '14496', $144 = '14497', $145 = '14498', $146 = '92323', $147 = '14499', $148 = '14500', $149 = '14501', $150 = '14502', $151 = '14503', $152 = '14504', $153 = '14505', $154 = '14506', $155 = '14507', $156 = '14508', $157 = '14509', $158 = '92332', $159 = '14511', $160 = '14512', $161 = '14513', $162 = '178', $163 = '14514', $164 = '14515', $165 = '14516', $166 = '14517', $167 = '14518', $168 = '14519', $169 = '14520', $170 = '14521', $171 = '14522', $172 = '14523', $173 = '14524', $174 = '14525', $175 = '14526', $176 = '14527', $177 = '14528', $178 = '14529', $179 = '14530', $180 = '14531', $181 = '14532', $182 = '14533', $183 = '14534', $184 = '14535', $185 = '14536', $186 = '123081', $187 = '14537', $188 = '14538', $189 = '14539', $190 = '14540', $191 = '14542', $192 = '14543', $193 = '14544', $194 = '14545', $195 = '143571', $196 = '14546', $197 = '1280193', $198 = '14547', $199 = '14548', $200 = '14549', $201 = '14550', $202 = '162004', $203 = '14551', $204 = '14552', $205 = '14553', $206 = '14554', $207 = '14555', $208 = '14556', $209 = '14557', $210 = '14558', $211 = '14559', $212 = '71902', $213 = '14560', $214 = '14561', $215 = '14562', $216 = '14563', $217 = '14564', $218 = '155878', $219 = '14565', $220 = '155879', $221 = '14566', $222 = '14567', $223 = '14568', $224 = '14569', $225 = '14570', $226 = '14571', $227 = '14572', $228 = '14573', $229 = '14574', $230 = '14575', $231 = '90350', $232 = '127214', $233 = '14576', $234 = '14577', $235 = '14578', $236 = '14579', $237 = '14580', $238 = '14581', $239 = '14582', $240 = '14583', $241 = '14584', $242 = '14585', $243 = '14586', $244 = '14587', $245 = '14588', $246 = '14589', $247 = '14590', $248 = '14591', $249 = '71934', $250 = '14592', $251 = '14593', $252 = '14594', $253 = '14595', $254 = '14596', $255 = '14597', $256 = '14598', $257 = '14599', $258 = '14600', $259 = '4361', $260 = '14602', $261 = '14603', $262 = '14604', $263 = '14605', $264 = '96524', $265 = '14606', $266 = '14607', $267 = '14608', $268 = '14609', $269 = '96531', $270 = '141584', $271 = '14611', $272 = '14612', $273 = '14613', $274 = '14615', $275 = '14616', $276 = '2328', $277 = '14617', $278 = '14618', $279 = '14619', $280 = '14620', $281 = '14621', $282 = '14622', $283 = '160028', $284 = '14623', $285 = '14624', $286 = '14625', $287 = '14626', $288 = '14627', $289 = '14628', $290 = '14629', $291 = '14630', $292 = '14631', $293 = '14632', $294 = '14633', $295 = '14634', $296 = '14635', $297 = '14636', $298 = '14637', $299 = '14638', $300 = '14639', $301 = '14640', $302 = '78129', $303 = '14641', $304 = '141619', $305 = '14642', $306 = '14643', $307 = '14644', $308 = '14645', $309 = '14646', $310 = '14647', $311 = '14648', $312 = '14649', $313 = '14650', $314 = '14651', $315 = '35131', $316 = '14652', $317 = '14653', $318 = '14654', $319 = '14655', $320 = '133442', $321 = '14656', $322 = '133443', $323 = '14657', $324 = '14658', $325 = '14659', $326 = '14660', $327 = '14661', $328 = '14662', $329 = '14663', $330 = '14664', $331 = '145738', $332 = '14665', $333 = '14666', $334 = '14667', $335 = '14668', $336 = '14669', $337 = '92492', $338 = '14670', $339 = '14671', $340 = '14672', $341 = '92497', $342 = '14673', $343 = '14674', $344 = '14675', $345 = '162129', $346 = '14676', $347 = '14677', $348 = '14678', $349 = '92503', $350 = '14679', $351 = '14680', $352 = '14681', $353 = '1265993', $354 = '14682', $355 = '92507', $356 = '14683', $357 = '14684', $358 = '14685', $359 = '14686', $360 = '14687', $361 = '92510', $362 = '14688', $363 = '92513', $364 = '14689', $365 = '92512', $366 = '14690', $367 = '14691', $368 = '14692', $369 = '14693', $370 = '14694', $371 = '14695', $372 = '14696', $373 = '172394', $374 = '14697', $375 = '172395', $376 = '14698', $377 = '164200', $378 = '14699', $379 = '164201', $380 = '14700', $381 = '14701', $382 = '14702', $383 = '172396', $384 = '14703', $385 = '92526', $386 = '172397', $387 = '14704', $388 = '14705', $389 = '14706', $390 = '14707', $391 = '14708', $392 = '14709', $393 = '14711', $394 = '14716', $395 = '14717', $396 = '14722', $397 = '76163', $398 = '14723', $399 = '14724', $400 = '14725', $401 = '14726', $402 = '14727', $403 = '4488', $404 = '14729', $405 = '14730', $406 = '14732', $407 = '14734', $408 = '14735', $409 = '14736', $410 = '14737', $411 = '14738', $412 = '14742', $413 = '14743', $414 = '14744', $415 = '14745', $416 = '14746', $417 = '14747', $418 = '133534', $419 = '14748', $420 = '14749', $421 = '133535', $422 = '14750', $423 = '14751', $424 = '14752', $425 = '14753', $426 = '14754', $427 = '160161', $428 = '14755', $429 = '14756', $430 = '139686', $431 = '14757', $432 = '14758', $433 = '14759', $434 = '14760', $435 = '14761', $436 = '14762', $437 = '76203', $438 = '14763', $439 = '141737', $440 = '14764', $441 = '14765', $442 = '14766', $443 = '14767', $444 = '14768', $445 = '14769', $446 = '14770', $447 = '141744', $448 = '14771', $449 = '14772', $450 = '14773', $451 = '14774', $452 = '92599', $453 = '14775', $454 = '14776', $455 = '14777', $456 = '14778', $457 = '14779', $458 = '43451', $459 = '121274', $460 = '14780', $461 = '14781', $462 = '14782', $463 = '14783', $464 = '14784', $465 = '14785', $466 = '14786', $467 = '14787', $468 = '14788', $469 = '14789', $470 = '14790', $471 = '14791', $472 = '14792', $473 = '14793', $474 = '14794', $475 = '14795', $476 = '14796', $477 = '14797', $478 = '14798', $479 = '14799', $480 = '14800', $481 = '14801', $482 = '14802', $483 = '14803', $484 = '14804', $485 = '14805', $486 = '14806', $487 = '14807', $488 = '14808', $489 = '14809', $490 = '14810', $491 = '14811', $492 = '14812', $493 = '14813', $494 = '14814', $495 = '14815', $496 = '4577', $497 = '14817', $498 = '14818', $499 = '14819', $500 = '14820', $501 = '14821', $502 = '14822', $503 = '14823', $504 = '14824', $505 = '14825', $506 = '129512', $507 = '14827', $508 = '14828', $509 = '14829', $510 = '14830', $511 = '14831', $512 = '14832', $513 = '14833', $514 = '14834', $515 = '14835', $516 = '14836', $517 = '14837', $518 = '14838', $519 = '14839', $520 = '14840', $521 = '14841', $522 = '14842', $523 = '14843', $524 = '14844', $525 = '14845', $526 = '14846', $527 = '14847', $528 = '14848', $529 = '14849', $530 = '76288', $531 = '14850', $532 = '14851', $533 = '14852', $534 = '14853', $535 = '14854', $536 = '14855', $537 = '14856', $538 = '14857', $539 = '14858', $540 = '14859', $541 = '14860', $542 = '14861', $543 = '14862', $544 = '14863', $545 = '14864', $546 = '2586', $547 = '141854', $548 = '207390', $549 = '141853', $550 = '1268273', $551 = '559', $552 = '129587', $553 = '129588', $554 = '2624', $555 = '141899', $556 = '299602', $557 = '76395', $558 = '162415', $559 = '82547', $560 = '2682', $561 = '4742', $562 = '657', $563 = '119447', $564 = '164512', $565 = '70325', $566 = '129724', $567 = '99007', $568 = '99008', $569 = '162515', $570 = '162519', $571 = '162516', $572 = '162520', $573 = '142054', $574 = '86761', $575 = '275191', $576 = '275193', $577 = '275194', $578 = '275195', $579 = '1215255', $580 = '105222', $581 = '782', $582 = '4879', $583 = '162594', $584 = '162595', $585 = '162592', $586 = '162593', $587 = '162598', $588 = '142134', $589 = '142167', $590 = '93022', $591 = '90985', $592 = '90998', $593 = '4988', $594 = '338810', $595 = '70545', $596 = '168849', $597 = '119701', $598 = '941', $599 = '5038', $600 = '5040', $601 = '258995', $602 = '258993', $603 = '5043', $604 = '5044', $605 = '1098660', $606 = '5045', $607 = '5046', $608 = '258997', $609 = '5048', $610 = '5050', $611 = '5052', $612 = '5053', $613 = '5054', $614 = '82879', $615 = '76734', $616 = '5056', $617 = '5058', $618 = '5060', $619 = '5061', $620 = '5062', $621 = '5063', $622 = '5064', $623 = '5066', $624 = '5068', $625 = '5069', $626 = '5070', $627 = '5071', $628 = '84942', $629 = '5072', $630 = '5076', $631 = '5077', $632 = '82900', $633 = '5078', $634 = '5080', $635 = '185306', $636 = '5081', $637 = '185307', $638 = '5082', $639 = '5083', $640 = '5084', $641 = '185310', $642 = '5085', $643 = '185311', $644 = '5086', $645 = '185308', $646 = '5087', $647 = '185309', $648 = '185314', $649 = '5089', $650 = '5090', $651 = '140256', $652 = '185312', $653 = '185313', $654 = '5092', $655 = '5093', $656 = '5094', $657 = '5095', $658 = '5096', $659 = '5097', $660 = '5098', $661 = '1002', $662 = '5099', $663 = '5100', $664 = '93165', $665 = '5101', $666 = '93164', $667 = '5102', $668 = '119791', $669 = '5103', $670 = '76782', $671 = '93166', $672 = '5104', $673 = '5105', $674 = '119792', $675 = '5107', $676 = '5109', $677 = '5110', $678 = '140276', $679 = '5111', $680 = '5112', $681 = '5113', $682 = '5115', $683 = '5116', $684 = '5117', $685 = '5118', $686 = '5119', $687 = '5120', $688 = '125953', $689 = '5121', $690 = '125952', $691 = '5122', $692 = '142336', $693 = '5124', $694 = '3076', $695 = '140295', $696 = '5126', $697 = '5127', $698 = '5128', $699 = '5129', $700 = '203790', $701 = '130085', $702 = '80932', $703 = '132138', $704 = '132139', $705 = '132142', $706 = '132141', $707 = '103473', $708 = '76883', $709 = '128082', $710 = '132182', $711 = '341085', $712 = '341084', $713 = '341087', $714 = '341086', $715 = '341080', $716 = '341083', $717 = '1119', $718 = '130145', $719 = '160866', $720 = '341092', $721 = '146534', $722 = '341089', $723 = '146535', $724 = '1125', $725 = '341088', $726 = '341091', $727 = '146533', $728 = '341090', $729 = '146536', $730 = '146537', $731 = '142446', $732 = '175246', $733 = '175244', $734 = '187542', $735 = '187540', $736 = '187546', $737 = '1227914', $738 = '1227915', $739 = '187545', $740 = '1227913', $741 = '162993', $742 = '128182', $743 = '130236', $744 = '3263', $745 = '136387', $746 = '136384', $747 = '136392', $748 = '136399', $749 = '136396', $750 = '87272', $751 = '341227', $752 = '3325', $753 = '77063', $754 = '3337', $755 = '77064', $756 = '77069', $757 = '1293', $758 = '140563', $759 = '175386', $760 = '175415', $761 = '23862', $762 = '1260842', $763 = '85318', $764 = '3405', $765 = '335191', $766 = '335190', $767 = '181591', $768 = '77145', $769 = '181593', $770 = '335193', $771 = '335192', $772 = '130404', $773 = '93545', $774 = '93546', $775 = '111997', $776 = '112021', $777 = '142743', $778 = '112022', $779 = '112026', $780 = '112037', $781 = '112038', $782 = '112041', $783 = '112042', $784 = '77229', $785 = '112047', $786 = '150956', $787 = '112048', $788 = '187830', $789 = '187831', $790 = '187829', $791 = '187834', $792 = '187835', $793 = '187832', $794 = '187833', $795 = '112061', $796 = '112063', $797 = '112065', $798 = '351684', $799 = '112064', $800 = '351687', $801 = '112068', $802 = '112070', $803 = '351689', $804 = '3535', $805 = '363984', $806 = '153044', $807 = '153045', $808 = '112092', $809 = '3571', $810 = '112114', $811 = '126460', $812 = '112126', $813 = '151040', $814 = '151041', $815 = '85513', $816 = '3596', $817 = '3610', $818 = '73243', $819 = '134690', $820 = '116263', $821 = '1244734', $822 = '46638', $823 = '48694', $824 = '83512', $825 = '128568', $826 = '110136', $827 = '3642', $828 = '142904', $829 = '142905', $830 = '128575', $831 = '333396', $832 = '345687', $833 = '345686', $834 = '345693', $835 = '345692', $836 = '345694', $837 = '345689', $838 = '345688', $839 = '345691', $840 = '163442', $841 = '163441', $842 = '1662', $843 = '263803', $844 = '93825', $845 = '140941', $846 = '356008', $847 = '1124009', $848 = '296642', $849 = '132817', $850 = '345808', $851 = '345810', $852 = '3804', $853 = '159452', $854 = '3808', $855 = '67301', $856 = '141029', $857 = '132847', $858 = '106223', $859 = '106225', $860 = '132848', $861 = '106226', $862 = '132849', $863 = '175871', $864 = '85760', $865 = '175872', $866 = '91911', $867 = '106250', $868 = '124684', $869 = '333591', $870 = '333590', $871 = '333597', $872 = '333599', $873 = '333598', $874 = '190236', $875 = '1224498', $876 = '141088', $877 = '1224502', $878 = '333600', $879 = '124711', $880 = '333602', $881 = '91959', $882 = '1240906', $883 = '1242954', $884 = '1242955', $885 = '75611', $886 = '356190', $887 = '75612', $888 = '1242956', $889 = '1261388', $890 = '92007', $891 = '141162', $892 = '124791', $893 = '51063', $894 = '14205', $895 = '112515', $896 = '141184', $897 = '14225', $898 = '77717', $899 = '14228', $900 = '14229', $901 = '14231', $902 = '14232', $903 = '14234', $904 = '83867', $905 = '145304', $906 = '14235', $907 = '83868', $908 = '96156', $909 = '14238', $910 = '75679', $911 = '14239', $912 = '96158', $913 = '14241', $914 = '14242', $915 = '14243', $916 = '151457', $917 = '276391', $918 = '14244', $919 = '14245', $920 = '14246', $921 = '14247', $922 = '14248', $923 = '14249', $924 = '14250', $925 = '14251', $926 = '14252', $927 = '102316', $928 = '724927', $929 = '102324', $930 = '124852', $931 = '128951', $932 = '14264', $933 = '128953', $934 = '14265', $935 = '14266', $936 = '14267', $937 = '128954', $938 = '133049', $939 = '14269', $940 = '14270', $941 = '14272', $942 = '14273', $943 = '14274', $944 = '14275', $945 = '14276', $946 = '14277', $947 = '491457', $948 = '14278', $949 = '14279', $950 = '14280', $951 = '14281', $952 = '14282', $953 = '14283', $954 = '14284', $955 = '14285', $956 = '14286', $957 = '14287', $958 = '14288', $959 = '14289', $960 = '14291', $961 = '14292', $962 = '14293', $963 = '100308', $964 = '14294', $965 = '14295', $966 = '14296', $967 = '14298', $968 = '14299', $969 = '14300', $970 = '14301', $971 = '14302', $972 = '14303', $973 = '14304', $974 = '14305', $975 = '14306', $976 = '14307', $977 = '14308', $978 = '14309', $979 = '2021', $980 = '14311', $981 = '14312', $982 = '14313', $983 = '14315', $984 = '14316', $985 = '14317', $986 = '14320', $987 = '14322', $988 = '14323', $989 = '14324', $990 = '14325', $991 = '14326', $992 = '14327', $993 = '14328', $994 = '14329', $995 = '2041', $996 = '14330', $997 = '14331', $998 = '92157', $999 = '14333', $1000 = '14335';

Date: 2026-02-27 15:45:09 Duration: 4s908ms Database: cnrs User: a3d Remote: 10.7.160.147 Application: PostgreSQL JDBC Driver

Explain plan

Bitmap Heap Scan on gtp_obj_composition gocp1_0 (cost=5184.05..108311.20 rows=124195 width=75) Recheck Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,14330,14331,92157,14333,14335}'::bigint[])) -> Bitmap Index Scan on i_fk_gtp_obj_compo_obj (cost=0.00..5150.50 rows=124195 width=0) Index Cond: (obj_num_id = ANY ('{14336,67585,14337,14338,14339,14342,14343,14344,14345,14346,92171,14347,14349,161807,14350,14351,14352,14353,2066,14354,161808,14355,14356,14357,14358,14359,14361,14363,127002,14364,14365,14366,14367,14368,14369,14370,1286193,14371,14375,14381,14384,14385,14386,92210,143409,147510,2103,14393,14394,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,108619,14410,14411,14412,14413,14414,122959,14416,14417,14418,14419,83,14420,14421,14422,14423,14424,82011,14428,14431,127070,14432,14433,14434,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,108659,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,92305,14482,14483,14488,2201,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,92323,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,92332,14511,14512,14513,178,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,123081,14537,14538,14539,14540,14542,14543,14544,14545,143571,14546,1280193,14547,14548,14549,14550,162004,14551,14552,14553,14554,14555,14556,14557,14558,14559,71902,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,71934,14592,14593,14594,14595,14596,14597,14598,14599,14600,4361,14602,14603,14604,14605,96524,14606,14607,14608,14609,96531,141584,14611,14612,14613,14615,14616,2328,14617,14618,14619,14620,14621,14622,160028,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,78129,14641,141619,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,35131,14652,14653,14654,14655,133442,14656,133443,14657,14658,14659,14660,14661,14662,14663,14664,145738,14665,14666,14667,14668,14669,92492,14670,14671,14672,92497,14673,14674,14675,162129,14676,14677,14678,92503,14679,14680,14681,1265993,14682,92507,14683,14684,14685,14686,14687,92510,14688,92513,14689,92512,14690,14691,14692,14693,14694,14695,14696,172394,14697,172395,14698,164200,14699,164201,14700,14701,14702,172396,14703,92526,172397,14704,14705,14706,14707,14708,14709,14711,14716,14717,14722,76163,14723,14724,14725,14726,14727,4488,14729,14730,14732,14734,14735,14736,14737,14738,14742,14743,14744,14745,14746,14747,133534,14748,14749,133535,14750,14751,14752,14753,14754,160161,14755,14756,139686,14757,14758,14759,14760,14761,14762,76203,14763,141737,14764,14765,14766,14767,14768,14769,14770,141744,14771,14772,14773,14774,92599,14775,14776,14777,14778,14779,43451,121274,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,4577,14817,14818,14819,14820,14821,14822,14823,14824,14825,129512,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,76288,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,2586,141854,207390,141853,1268273,559,129587,129588,2624,141899,299602,76395,162415,82547,2682,4742,657,119447,164512,70325,129724,99007,99008,162515,162519,162516,162520,142054,86761,275191,275193,275194,275195,1215255,105222,782,4879,162594,162595,162592,162593,162598,142134,142167,93022,90985,90998,4988,338810,70545,168849,119701,941,5038,5040,258995,258993,5043,5044,1098660,5045,5046,258997,5048,5050,5052,5053,5054,82879,76734,5056,5058,5060,5061,5062,5063,5064,5066,5068,5069,5070,5071,84942,5072,5076,5077,82900,5078,5080,185306,5081,185307,5082,5083,5084,185310,5085,185311,5086,185308,5087,185309,185314,5089,5090,140256,185312,185313,5092,5093,5094,5095,5096,5097,5098,1002,5099,5100,93165,5101,93164,5102,119791,5103,76782,93166,5104,5105,119792,5107,5109,5110,140276,5111,5112,5113,5115,5116,5117,5118,5119,5120,125953,5121,125952,5122,142336,5124,3076,140295,5126,5127,5128,5129,203790,130085,80932,132138,132139,132142,132141,103473,76883,128082,132182,341085,341084,341087,341086,341080,341083,1119,130145,160866,341092,146534,341089,146535,1125,341088,341091,146533,341090,146536,146537,142446,175246,175244,187542,187540,187546,1227914,1227915,187545,1227913,162993,128182,130236,3263,136387,136384,136392,136399,136396,87272,341227,3325,77063,3337,77064,77069,1293,140563,175386,175415,23862,1260842,85318,3405,335191,335190,181591,77145,181593,335193,335192,130404,93545,93546,111997,112021,142743,112022,112026,112037,112038,112041,112042,77229,112047,150956,112048,187830,187831,187829,187834,187835,187832,187833,112061,112063,112065,351684,112064,351687,112068,112070,351689,3535,363984,153044,153045,112092,3571,112114,126460,112126,151040,151041,85513,3596,3610,73243,134690,116263,1244734,46638,48694,83512,128568,110136,3642,142904,142905,128575,333396,345687,345686,345693,345692,345694,345689,345688,345691,163442,163441,1662,263803,93825,140941,356008,1124009,296642,132817,345808,345810,3804,159452,3808,67301,141029,132847,106223,106225,132848,106226,132849,175871,85760,175872,91911,106250,124684,333591,333590,333597,333599,333598,190236,1224498,141088,1224502,333600,124711,333602,91959,1240906,1242954,1242955,75611,356190,75612,1242956,1261388,92007,141162,124791,51063,14205,112515,141184,14225,77717,14228,14229,14231,14232,14234,83867,145304,14235,83868,96156,14238,75679,14239,96158,14241,14242,14243,151457,276391,14244,14245,14246,14247,14248,14249,14250,14251,14252,102316,724927,102324,124852,128951,14264,128953,14265,14266,14267,128954,133049,14269,14270,14272,14273,14274,14275,14276,14277,491457,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14291,14292,14293,100308,14294,14295,14296,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,2021,14311,14312,14313,14315,14316,14317,14320,14322,14323,14324,14325,14326,14327,14328,14329,2041,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

Log levels

Key values

2,141 Log entries

Chart
Table

Type	Count	Percentage
LOG	2,141	100.00%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
0 ERROR entries
0 WARNING entries

Errors per 5 minutes

Most Frequent Errors/Events

Key values

0 Max number of times the same event was reported
0 Total events found

Rank	Times reported	Error
NO DATASET

Global information

Overview

Global Stats

SQL Traffic

Key values

Queries per second (5 minutes average)

SELECT Traffic

Key values

SELECT queries (5 minutes period)

INSERT/UPDATE/DELETE Traffic

Key values

Write queries (5 minutes period)

Queries duration

Key values

Average queries duration (5 minutes average)

Prepared queries ratio

Key values

Bind versus prepare statements (5 minutes average)

General Activity

Connections

Established Connections

Key values

Connections per second (5 minutes average)

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Number of sessions/second (5 minutes average)

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database