select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49802;

Date: 2025-10-24 09:03:56
Duration: 311ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver

select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49802;

Date: 2025-10-24 09:09:02
Duration: 59ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver

select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49802;

Date: 2025-10-24 09:05:56
Duration: 58ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: a3dsupervisor - Total duration: 691ms - Times executed: 4 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 691ms - Times executed: 4 ]

x Hide

select this_.REQUETE_V2_NUM_ID as requete_1_141_0_, this_.REQUETE_V2_DATE_CREATION as requete_2_141_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp3_141_0_, this_.REQUETE_V2_A3D_NUM_ID as requete_4_141_0_, this_.REQUETE_V2_COMMENT as requete_5_141_0_, this_.REQUETE_V2_GROUP_NUM_ID as requete_6_141_0_, this_.REQUETE_V2_HAVE_USER_CONDITION as requete_7_141_0_, this_.REQUETE_V2_NOM as requete_8_141_0_, this_.REQUETE_V2_VALUE as requete_9_141_0_, this_.UNIQUE_CODE as unique_10_141_0_, this_.REQUETE_V2_LAST_MODIF as requete11_141_0_, this_.USER_NUM_ID as user_nu12_141_0_, this_.USER_NUM_ID_MODIFIER as user_nu13_141_0_, this_.WORKSPACE_NUM_ID as workspa14_141_0_ from GTP_REQUETE_V2 this_;

Date: 2025-10-24 09:09:00
Duration: 307ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.REQUETE_V2_NUM_ID as requete_1_141_0_, this_.REQUETE_V2_DATE_CREATION as requete_2_141_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp3_141_0_, this_.REQUETE_V2_A3D_NUM_ID as requete_4_141_0_, this_.REQUETE_V2_COMMENT as requete_5_141_0_, this_.REQUETE_V2_GROUP_NUM_ID as requete_6_141_0_, this_.REQUETE_V2_HAVE_USER_CONDITION as requete_7_141_0_, this_.REQUETE_V2_NOM as requete_8_141_0_, this_.REQUETE_V2_VALUE as requete_9_141_0_, this_.UNIQUE_CODE as unique_10_141_0_, this_.REQUETE_V2_LAST_MODIF as requete11_141_0_, this_.USER_NUM_ID as user_nu12_141_0_, this_.USER_NUM_ID_MODIFIER as user_nu13_141_0_, this_.WORKSPACE_NUM_ID as workspa14_141_0_ from GTP_REQUETE_V2 this_;

Date: 2025-10-24 09:03:53
Duration: 173ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.REQUETE_V2_NUM_ID as requete_1_141_0_, this_.REQUETE_V2_DATE_CREATION as requete_2_141_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp3_141_0_, this_.REQUETE_V2_A3D_NUM_ID as requete_4_141_0_, this_.REQUETE_V2_COMMENT as requete_5_141_0_, this_.REQUETE_V2_GROUP_NUM_ID as requete_6_141_0_, this_.REQUETE_V2_HAVE_USER_CONDITION as requete_7_141_0_, this_.REQUETE_V2_NOM as requete_8_141_0_, this_.REQUETE_V2_VALUE as requete_9_141_0_, this_.UNIQUE_CODE as unique_10_141_0_, this_.REQUETE_V2_LAST_MODIF as requete11_141_0_, this_.USER_NUM_ID as user_nu12_141_0_, this_.USER_NUM_ID_MODIFIER as user_nu13_141_0_, this_.WORKSPACE_NUM_ID as workspa14_141_0_ from GTP_REQUETE_V2 this_;

Date: 2025-10-24 09:05:54
Duration: 111ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: a3dsupervisor - Total duration: 582ms - Times executed: 200 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 582ms - Times executed: 200 ]

x Hide

select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49802;

Date: 2025-10-24 09:03:56
Duration: 311ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49802;

Date: 2025-10-24 09:09:02
Duration: 59ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49802;

Date: 2025-10-24 09:05:56
Duration: 58ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: a3dsupervisor - Total duration: 463ms - Times executed: 33 ]

x Hide

[ Application: [unknown] - Total duration: 463ms - Times executed: 33 ]

x Hide

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-10-24 06:42:12
Duration: 22ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-10-24 07:22:55
Duration: 18ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-10-24 15:10:34
Duration: 17ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: a3dsupervisor - Total duration: 317ms - Times executed: 33 ]

x Hide

[ Application: [unknown] - Total duration: 317ms - Times executed: 33 ]

x Hide

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-10-24 07:22:55
Duration: 26ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-10-24 06:42:11
Duration: 25ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-10-24 15:06:56
Duration: 18ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: a3dsupervisor - Total duration: 249ms - Times executed: 33 ]

x Hide

[ Application: [unknown] - Total duration: 249ms - Times executed: 33 ]

x Hide

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-10-24 06:42:11
Duration: 16ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-10-24 06:23:20
Duration: 15ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-10-24 06:30:18
Duration: 15ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: azuresu - Total duration: 217ms - Times executed: 48 ]

x Hide

[ Application: [unknown] - Total duration: 217ms - Times executed: 48 ]

x Hide

SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;

Date: 2025-10-24 06:36:32
Duration: 8ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;

Date: 2025-10-24 07:06:34
Duration: 6ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;

Date: 2025-10-24 18:37:15
Duration: 6ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: a3dsupervisor - Total duration: 216ms - Times executed: 33 ]

x Hide

[ Application: [unknown] - Total duration: 216ms - Times executed: 33 ]

x Hide

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-10-24 12:02:33
Duration: 9ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-10-24 05:19:16
Duration: 9ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-10-24 06:31:05
Duration: 7ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: a3dsupervisor - Total duration: 201ms - Times executed: 4 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 201ms - Times executed: 4 ]

x Hide

select this_.ELEMENT_NUM_ID as element_1_5_0_, this_.RIGHT_NUM_ID as right_nu2_5_0_, this_.RIGHT_MODE as right_mo3_5_0_, this_.UPDATE_DATE as update_d4_5_0_, this_.UPDATE_USER_NUM_ID as update_u5_5_0_ from BDC_CONCERNED_ELEMENT this_ where this_.RIGHT_NUM_ID in (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,);

Date: 2025-10-24 09:09:13
Duration: 85ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.ELEMENT_NUM_ID as element_1_5_0_, this_.RIGHT_NUM_ID as right_nu2_5_0_, this_.RIGHT_MODE as right_mo3_5_0_, this_.UPDATE_DATE as update_d4_5_0_, this_.UPDATE_USER_NUM_ID as update_u5_5_0_ from BDC_CONCERNED_ELEMENT this_ where this_.RIGHT_NUM_ID in (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,);

Date: 2025-10-24 09:09:13
Duration: 80ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.ELEMENT_NUM_ID as element_1_5_0_, this_.RIGHT_NUM_ID as right_nu2_5_0_, this_.RIGHT_MODE as right_mo3_5_0_, this_.UPDATE_DATE as update_d4_5_0_, this_.UPDATE_USER_NUM_ID as update_u5_5_0_ from BDC_CONCERNED_ELEMENT this_ where this_.RIGHT_NUM_ID in (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,);

Date: 2025-10-24 09:09:13
Duration: 28ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: a3dsupervisor - Total duration: 122ms - Times executed: 4 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 122ms - Times executed: 4 ]

x Hide

select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in (,,,,,,,,,) and gob.obj_status = 1 LIMIT 50000;

Date: 2025-10-24 09:03:56
Duration: 119ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in (,,,,,,,,,) and gob.obj_status = 1 LIMIT 50000;

Date: 2025-10-24 09:09:02
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in (,,,,,,,,,) and gob.obj_status = 1 LIMIT 50000;

Date: 2025-10-24 09:05:06
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

[ User: a3dsupervisor - Total duration: 68ms - Times executed: 60 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 68ms - Times executed: 60 ]

x Hide

select this_.ATT_TEMPLATE_CATEGORY_NUM_ID as att_temp1_130_0_, this_.ATT_TEMPLATE_NUM_ID as att_temp2_130_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp3_130_0_, this_.ATT_TEMPLATE_REFERENCE as att_temp4_130_0_, this_.IMPORT_TYPE as import_t5_130_0_, this_.MONTHLY_HISTORIZED as monthly_6_130_0_, this_.OBJ_TEMP_COMPO_A3D_NUM_ID as obj_temp7_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_ORDER as obj_temp8_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_VALID as obj_temp9_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_VISIB as obj_tem10_130_0_, this_.ROW_HEIGHT as row_hei11_130_0_, this_.SENSITIVE_DATA as sensiti12_130_0_, this_.TOOLTIP as tooltip13_130_0_, this_.TOOLTIP_ICON_ID as tooltip14_130_0_ from GTP_OBJ_TEMPLATE_COMPOSITION this_;

Date: 2025-10-24 09:03:48
Duration: 7ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.ATT_TEMPLATE_CATEGORY_NUM_ID as att_temp1_130_0_, this_.ATT_TEMPLATE_NUM_ID as att_temp2_130_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp3_130_0_, this_.ATT_TEMPLATE_REFERENCE as att_temp4_130_0_, this_.IMPORT_TYPE as import_t5_130_0_, this_.MONTHLY_HISTORIZED as monthly_6_130_0_, this_.OBJ_TEMP_COMPO_A3D_NUM_ID as obj_temp7_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_ORDER as obj_temp8_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_VALID as obj_temp9_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_VISIB as obj_tem10_130_0_, this_.ROW_HEIGHT as row_hei11_130_0_, this_.SENSITIVE_DATA as sensiti12_130_0_, this_.TOOLTIP as tooltip13_130_0_, this_.TOOLTIP_ICON_ID as tooltip14_130_0_ from GTP_OBJ_TEMPLATE_COMPOSITION this_;

Date: 2025-10-24 09:08:56
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.ATT_TEMPLATE_CATEGORY_NUM_ID as att_temp1_130_0_, this_.ATT_TEMPLATE_NUM_ID as att_temp2_130_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp3_130_0_, this_.ATT_TEMPLATE_REFERENCE as att_temp4_130_0_, this_.IMPORT_TYPE as import_t5_130_0_, this_.MONTHLY_HISTORIZED as monthly_6_130_0_, this_.OBJ_TEMP_COMPO_A3D_NUM_ID as obj_temp7_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_ORDER as obj_temp8_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_VALID as obj_temp9_130_0_, this_.OBJ_TEMPLATE_COMPOSITION_VISIB as obj_tem10_130_0_, this_.ROW_HEIGHT as row_hei11_130_0_, this_.SENSITIVE_DATA as sensiti12_130_0_, this_.TOOLTIP as tooltip13_130_0_, this_.TOOLTIP_ICON_ID as tooltip14_130_0_ from GTP_OBJ_TEMPLATE_COMPOSITION this_;

Date: 2025-10-24 09:05:49
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #11

x Hide

[ User: a3dsupervisor - Total duration: 52ms - Times executed: 16 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 52ms - Times executed: 16 ]

x Hide

select this_.ATT_TEMPLATE_ENUM_VALUE_NUM_ID as att_temp1_46_0_, this_.ATT_TEMPLATE_ENUM_LIST_ORDER as att_temp2_46_0_, this_.ATT_TEMPLATE_ENUM_NUM_ID as att_temp3_46_0_, this_.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID as att_temp4_46_0_, this_.ICON_FILE_NUM_ID as icon_fil5_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_IS_DEF as att_temp6_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_PARENT as att_temp7_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_STATUS as att_temp8_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_VALUE as att_temp9_46_0_, this_.EXT_CODE as ext_cod10_46_0_, this_.UNIQUE_CODE as unique_11_46_0_ from GTP_ATT_TEMPLATE_ENUM_VALUE this_;

Date: 2025-10-24 09:03:45
Duration: 16ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.ATT_TEMPLATE_ENUM_VALUE_NUM_ID as att_temp1_46_0_, this_.ATT_TEMPLATE_ENUM_LIST_ORDER as att_temp2_46_0_, this_.ATT_TEMPLATE_ENUM_NUM_ID as att_temp3_46_0_, this_.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID as att_temp4_46_0_, this_.ICON_FILE_NUM_ID as icon_fil5_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_IS_DEF as att_temp6_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_PARENT as att_temp7_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_STATUS as att_temp8_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_VALUE as att_temp9_46_0_, this_.EXT_CODE as ext_cod10_46_0_, this_.UNIQUE_CODE as unique_11_46_0_ from GTP_ATT_TEMPLATE_ENUM_VALUE this_;

Date: 2025-10-24 09:08:51
Duration: 8ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.ATT_TEMPLATE_ENUM_VALUE_NUM_ID as att_temp1_46_0_, this_.ATT_TEMPLATE_ENUM_LIST_ORDER as att_temp2_46_0_, this_.ATT_TEMPLATE_ENUM_NUM_ID as att_temp3_46_0_, this_.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID as att_temp4_46_0_, this_.ICON_FILE_NUM_ID as icon_fil5_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_IS_DEF as att_temp6_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_PARENT as att_temp7_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_STATUS as att_temp8_46_0_, this_.ATT_TEMPLATE_ENUM_VALUE_VALUE as att_temp9_46_0_, this_.EXT_CODE as ext_cod10_46_0_, this_.UNIQUE_CODE as unique_11_46_0_ from GTP_ATT_TEMPLATE_ENUM_VALUE this_;

Date: 2025-10-24 09:04:55
Duration: 7ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #12

x Hide

[ User: a3dsupervisor - Total duration: 41ms - Times executed: 24 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 41ms - Times executed: 24 ]

x Hide

delete from BDC_RIGHT where RIGHT_NUM_ID =;

Date: 2025-10-24 09:09:15
Duration: 34ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

delete from BDC_RIGHT where RIGHT_NUM_ID =;

Date: 2025-10-24 09:09:15
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

delete from BDC_RIGHT where RIGHT_NUM_ID =;

Date: 2025-10-24 09:09:16
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #13

x Hide

[ User: a3dsupervisor - Total duration: 37ms - Times executed: 32 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 37ms - Times executed: 32 ]

x Hide

select this_.NODE_TREE_TYPE_NUM_ID as node_tre1_107_0_, this_.VIEW_TEMPLATE_NUM_ID as view_tem2_107_0_, this_.LNK_TEMPLATE_NUM_ID as lnk_temp3_107_0_, this_.NODE_TREE_TYPE_A3D_NUM_ID as node_tre4_107_0_, this_.NODE_TREE_TYPE_NUM_ID_P as node_tre5_107_0_, this_.NODE_TREE_TYPE_POSITION as node_tre6_107_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp7_107_0_, this_.REL_SENS as rel_sens8_107_0_, this_.REL_TEMPLATE_NUM_ID as rel_temp9_107_0_, this_.REQUETE_V2_NUM_ID as requete10_107_0_, this_.TYPE_NODE_CODE as type_no11_107_0_ from GTP_NODE_TREE_TYPE this_;

Date: 2025-10-24 09:03:46
Duration: 9ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.NODE_TREE_TYPE_NUM_ID as node_tre1_107_0_, this_.VIEW_TEMPLATE_NUM_ID as view_tem2_107_0_, this_.LNK_TEMPLATE_NUM_ID as lnk_temp3_107_0_, this_.NODE_TREE_TYPE_A3D_NUM_ID as node_tre4_107_0_, this_.NODE_TREE_TYPE_NUM_ID_P as node_tre5_107_0_, this_.NODE_TREE_TYPE_POSITION as node_tre6_107_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp7_107_0_, this_.REL_SENS as rel_sens8_107_0_, this_.REL_TEMPLATE_NUM_ID as rel_temp9_107_0_, this_.REQUETE_V2_NUM_ID as requete10_107_0_, this_.TYPE_NODE_CODE as type_no11_107_0_ from GTP_NODE_TREE_TYPE this_;

Date: 2025-10-24 09:08:53
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.NODE_TREE_TYPE_NUM_ID as node_tre1_107_0_, this_.VIEW_TEMPLATE_NUM_ID as view_tem2_107_0_, this_.LNK_TEMPLATE_NUM_ID as lnk_temp3_107_0_, this_.NODE_TREE_TYPE_A3D_NUM_ID as node_tre4_107_0_, this_.NODE_TREE_TYPE_NUM_ID_P as node_tre5_107_0_, this_.NODE_TREE_TYPE_POSITION as node_tre6_107_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp7_107_0_, this_.REL_SENS as rel_sens8_107_0_, this_.REL_TEMPLATE_NUM_ID as rel_temp9_107_0_, this_.REQUETE_V2_NUM_ID as requete10_107_0_, this_.TYPE_NODE_CODE as type_no11_107_0_ from GTP_NODE_TREE_TYPE this_;

Date: 2025-10-24 09:08:53
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #14

x Hide

[ User: a3dsupervisor - Total duration: 33ms - Times executed: 24 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 33ms - Times executed: 24 ]

x Hide

insert into BDC_HISTORY_RIGHT_ACTION (ACCEPT_FUTURE_ELEMENTS, ACTION_DATE, ACTION_TYPE, CONTEXT, ELEMENT_NUM_ID, ELEMENT_TYPE, RIGHT_MODE, TARGET_NUM_ID, TARGET_TYPE, USER_NUM_ID, HISTORY_RIGHT_NUM_ID) values (,,,,,,,,,,);

Date: 2025-10-24 09:09:15
Duration: 30ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

insert into BDC_HISTORY_RIGHT_ACTION (ACCEPT_FUTURE_ELEMENTS, ACTION_DATE, ACTION_TYPE, CONTEXT, ELEMENT_NUM_ID, ELEMENT_TYPE, RIGHT_MODE, TARGET_NUM_ID, TARGET_TYPE, USER_NUM_ID, HISTORY_RIGHT_NUM_ID) values (,,,,,,,,,,);

Date: 2025-10-24 09:09:15
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

insert into BDC_HISTORY_RIGHT_ACTION (ACCEPT_FUTURE_ELEMENTS, ACTION_DATE, ACTION_TYPE, CONTEXT, ELEMENT_NUM_ID, ELEMENT_TYPE, RIGHT_MODE, TARGET_NUM_ID, TARGET_TYPE, USER_NUM_ID, HISTORY_RIGHT_NUM_ID) values (,,,,,,,,,,);

Date: 2025-10-24 09:09:17
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide

Times Reported Time consuming queries #15

x Hide

[ User: a3dsupervisor - Total duration: 33ms - Times executed: 32 ]

x Hide

[ Application: PostgreSQL JDBC Driver - Total duration: 33ms - Times executed: 32 ]

x Hide

select this_.NODE_TREE_TYPE_NUM_ID as node_tre1_107_0_, this_.VIEW_TEMPLATE_NUM_ID as view_tem2_107_0_, this_.LNK_TEMPLATE_NUM_ID as lnk_temp3_107_0_, this_.NODE_TREE_TYPE_A3D_NUM_ID as node_tre4_107_0_, this_.NODE_TREE_TYPE_NUM_ID_P as node_tre5_107_0_, this_.NODE_TREE_TYPE_POSITION as node_tre6_107_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp7_107_0_, this_.REL_SENS as rel_sens8_107_0_, this_.REL_TEMPLATE_NUM_ID as rel_temp9_107_0_, this_.REQUETE_V2_NUM_ID as requete10_107_0_, this_.TYPE_NODE_CODE as type_no11_107_0_ from GTP_NODE_TREE_TYPE this_ where this_.VIEW_TEMPLATE_NUM_ID in (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,);

Date: 2025-10-24 09:08:54
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.NODE_TREE_TYPE_NUM_ID as node_tre1_107_0_, this_.VIEW_TEMPLATE_NUM_ID as view_tem2_107_0_, this_.LNK_TEMPLATE_NUM_ID as lnk_temp3_107_0_, this_.NODE_TREE_TYPE_A3D_NUM_ID as node_tre4_107_0_, this_.NODE_TREE_TYPE_NUM_ID_P as node_tre5_107_0_, this_.NODE_TREE_TYPE_POSITION as node_tre6_107_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp7_107_0_, this_.REL_SENS as rel_sens8_107_0_, this_.REL_TEMPLATE_NUM_ID as rel_temp9_107_0_, this_.REQUETE_V2_NUM_ID as requete10_107_0_, this_.TYPE_NODE_CODE as type_no11_107_0_ from GTP_NODE_TREE_TYPE this_ where this_.VIEW_TEMPLATE_NUM_ID in (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,);

Date: 2025-10-24 09:08:53
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

select this_.NODE_TREE_TYPE_NUM_ID as node_tre1_107_0_, this_.VIEW_TEMPLATE_NUM_ID as view_tem2_107_0_, this_.LNK_TEMPLATE_NUM_ID as lnk_temp3_107_0_, this_.NODE_TREE_TYPE_A3D_NUM_ID as node_tre4_107_0_, this_.NODE_TREE_TYPE_NUM_ID_P as node_tre5_107_0_, this_.NODE_TREE_TYPE_POSITION as node_tre6_107_0_, this_.OBJ_TEMPLATE_NUM_ID as obj_temp7_107_0_, this_.REL_SENS as rel_sens8_107_0_, this_.REL_TEMPLATE_NUM_ID as rel_temp9_107_0_, this_.REQUETE_V2_NUM_ID as requete10_107_0_, this_.TYPE_NODE_CODE as type_no11_107_0_ from GTP_NODE_TREE_TYPE this_ where this_.VIEW_TEMPLATE_NUM_ID in (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,);

Date: 2025-10-24 09:08:53
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: PostgreSQL JDBC Driver
Bind query: yes

x Hide