pgBadger-
Global information
- Generated on Thu Sep 25 09:04:26 2025
- Log file: ././A3D-RND-REF/y=2025/m=09/d=24/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=09/d=24/h=23/m=00/PT1H.log
- Parsed 413,012 log entries in 3m10s
- Log start from 2025-09-24 09:34:29 to 2025-09-24 18:34:48
-
Overview
Global Stats
- 4,516 Number of unique normalized queries
- 20,625 Number of queries
- 15m36s Total query duration
- 2025-09-24 09:34:29 First query
- 2025-09-24 18:34:48 Last query
- 217 queries/s at 2025-09-24 18:28:10 Query peak
- 15m36s Total query duration
- 17ms Prepare/parse total duration
- 3ms Bind total duration
- 15m36s Execute total duration
- 18 Number of events
- 3 Number of unique normalized events
- 16 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 159 Total number of automatic analyzes
- 285 Number temporary file
- 2.79 GiB Max size of temporary file
- 15.66 MiB Average size of temporary file
- 286 Total number of sessions
- 8 sessions at 2025-09-24 09:57:26 Session peak
- 1h25m49s Total duration of sessions
- 18s4ms Average duration of sessions
- 72 Average queries per session
- 3s274ms Average queries duration per session
- 14s729ms Average idle time per session
- 286 Total number of connections
- 9 connections/s at 2025-09-24 09:55:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 217 queries/s Query Peak
- 2025-09-24 18:28:10 Date
SELECT Traffic
Key values
- 201 queries/s Query Peak
- 2025-09-24 10:18:07 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 207 queries/s Query Peak
- 2025-09-24 09:51:36 Date
Queries duration
Key values
- 15m36s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 09 16,097 0ms 25s473ms 27ms 1m1s 1m3s 1m3s 10 3,456 0ms 1m5s 121ms 1m5s 1m23s 1m23s 18 1,072 0ms 20s709ms 65ms 20s709ms 49s92ms 49s92ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 09 0 0 0ms 0ms 0ms 0ms 10 565 242 86ms 326ms 20s814ms 47s994ms 18 430 242 104ms 586ms 20s709ms 49s71ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 09 11,377 0 0 3,048 14ms 718ms 42s714ms 58s501ms 10 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 24 09 0 0 0.00 0.00% 10 11 124 11.27 0.36% 18 3 116 38.67 0.44% Day Hour Count Average / Second Sep 24 09 268 0.07/s 10 15 0.00/s 18 3 0.00/s Day Hour Count Average Duration Average idle time Sep 24 09 267 1s463ms 0ms 10 16 2m46s 2m19s 18 3 11m39s 11m16s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2025-09-24 09:55:20 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 286 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 286 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2025-09-24 09:57:26 Date
Histogram of session times
Key values
- 243 0-500ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 286 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 286 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 286 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 387.05 MiB Temp Files size Peak
- 2025-09-24 10:03:10 Date
Number of temporary files
Key values
- 12 per second Temp Files Peak
- 2025-09-24 10:03:30 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 24 09 148 2.79 GiB 19.30 MiB 10 137 1.57 GiB 11.73 MiB 18 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- pg_catalog.pg_largeobject_metadata (7) Main table analyzed (database autotest_feat_batch)
- 159 analyzes Total
Table Number of analyzes autotest_feat_batch.pg_catalog.pg_largeobject_metadata 7 autotest_feat_batch.pg_catalog.pg_largeobject 6 autotest_feat_batch.pg_catalog.pg_class 5 autotest_feat_batch.pg_catalog.pg_index 5 autotest_feat_batch.pg_catalog.pg_depend 4 autotest_feat_batch.public.ged_document 3 autotest_feat_batch.public.ged_history_node 2 autotest_feat_batch.public.eng_file 2 autotest_feat_batch.pg_catalog.pg_attribute 2 autotest_feat_batch.pg_catalog.pg_constraint 2 autotest_feat_batch.public.pe_asset_consolidation_daily 1 autotest_feat_batch.public.gtp_att_template 1 autotest_feat_batch.public.gtp_cw_eng_alert 1 autotest_feat_batch.public.gtp_setting 1 autotest_feat_batch.public.gtp_history_param_obj 1 autotest_feat_batch.public.gtp_dependence_obj_template 1 autotest_feat_batch.public.functionality 1 autotest_feat_batch.public.uml_attribute 1 autotest_feat_batch.public.gtp_obj_template_influence 1 autotest_feat_batch.pg_catalog.pg_trigger 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule 1 autotest_feat_batch.public.mail_template 1 autotest_feat_batch.public.gtp_log_thread 1 autotest_feat_batch.public.ged_history_project 1 autotest_feat_batch.public.a3d_company_activity 1 autotest_feat_batch.public.gtp_requete_v2 1 autotest_feat_batch.public.gtp_obj_favorite 1 autotest_feat_batch.public.gtp_history_obj_old_qsp 1 autotest_feat_batch.public.gtp_setting_boolean 1 autotest_feat_batch.public.gtp_obj_template_rel_cat 1 autotest_feat_batch.public.gtp_att_unit 1 autotest_feat_batch.public.pe_consumption_daily 1 autotest_feat_batch.public.gtp_history_doc_deleted 1 autotest_feat_batch.public.gtp_obj_template_calcul_rule_cascade_info 1 autotest_feat_batch.public.pe_asset_consolidation_annual 1 autotest_feat_batch.public.gtp_history_att_template_category 1 autotest_feat_batch.public.gtp_history_obj_compo 1 autotest_feat_batch.public.gtp_a3d_version 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_options 1 autotest_feat_batch.public.uml_relation 1 autotest_feat_batch.public.gtp_log_jvm 1 autotest_feat_batch.public.gtp_obj_template_rel_cat_att 1 autotest_feat_batch.public.gtp_obj 1 autotest_feat_batch.public.eng_gtp_datalink 1 autotest_feat_batch.public.ged_subscription 1 autotest_feat_batch.public.gtp_att_template_category 1 autotest_feat_batch.public.gtp_rel_template 1 autotest_feat_batch.public.l_notification_user 1 autotest_feat_batch.public.gtp_setting_text 1 autotest_feat_batch.public.bdc_history_right_action 1 autotest_feat_batch.public.a3d_user 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_attribute 1 autotest_feat_batch.public.gtp_obj_template 1 autotest_feat_batch.public.gtp_history_obj_template 1 autotest_feat_batch.public.gtp_obj_compo_sequence 1 autotest_feat_batch.public.gtp_view_template 1 autotest_feat_batch.public.pe_dju 1 autotest_feat_batch.public.uml_mapping_class 1 autotest_feat_batch.public.gtp_log_connection 1 autotest_feat_batch.public.gtp_history_obj_concerned 1 autotest_feat_batch.public.gtp_log_session 1 autotest_feat_batch.public.gtp_obj_version 1 autotest_feat_batch.public.pe_asset_consolidation_monthly 1 autotest_feat_batch.public.mapping 1 autotest_feat_batch.public.gtp_history_obj_action 1 autotest_feat_batch.public.a3d_log 1 autotest_feat_batch.public.gtp_setting_clob 1 autotest_feat_batch.public.gtp_history_att_template 1 autotest_feat_batch.public.gtp_relation 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_mapping_alias 1 autotest_feat_batch.public.gtp_etat_v2_data 1 autotest_feat_batch.public.pe_consumption_monthly 1 autotest_feat_batch.public.ged_node 1 autotest_feat_batch.public.gtp_rel_group_template 1 autotest_feat_batch.public.gtp_history_obj_deleted 1 autotest_feat_batch.public.business_mail_template 1 autotest_feat_batch.public.ged_node_tree_type 1 autotest_feat_batch.public.gtp_contenu_rel_template 1 autotest_feat_batch.public.bdc_obj_template_enum_value_action 1 autotest_feat_batch.public.eng_data 1 autotest_feat_batch.public.currency 1 autotest_feat_batch.public.gtp_att_template_rel_cat 1 autotest_feat_batch.public.notification 1 autotest_feat_batch.public.gtp_setting_number 1 autotest_feat_batch.public.pe_asset_usage_consolidation_monthly 1 autotest_feat_batch.public.gtp_att_template_enum 1 autotest_feat_batch.public.gtp_obj_composition 1 autotest_feat_batch.public.pe_consumption_hourly 1 autotest_feat_batch.public.gtp_att_template_enum_value 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_request 1 autotest_feat_batch.public.gtp_att_template_rel_tab 1 autotest_feat_batch.public.gtp_history_view_template 1 autotest_feat_batch.public.uml_mapping_att 1 autotest_feat_batch.public.uml_class 1 autotest_feat_batch.public.ged_history_project_type 1 autotest_feat_batch.public.gtp_monthly_history 1 autotest_feat_batch.public.gtp_view 1 autotest_feat_batch.pg_catalog.pg_sequence 1 autotest_feat_batch.public.gtp_history_obj_template_category 1 autotest_feat_batch.pg_catalog.pg_attrdef 1 autotest_feat_batch.public.gtp_background_task 1 autotest_feat_batch.public.gtp_dependence_obj_tmplt_compo 1 autotest_feat_batch.public.bdc_concerned_element 1 autotest_feat_batch.public.gtp_history_att_unit 1 autotest_feat_batch.public.gtp_obj_template_composition 1 autotest_feat_batch.public.bdc_right 1 autotest_feat_batch.public.functionality_association 1 autotest_feat_batch.public.ged_right_user 1 autotest_feat_batch.public.gtp_obj_rel_vt 1 autotest_feat_batch.public.pe_consumption_annual 1 autotest_feat_batch.public.pe_consumption_10min 1 autotest_feat_batch.public.gtp_log_metric 1 autotest_feat_batch.public.pe_asset_usage_consolidation_annual 1 autotest_feat_batch.pg_catalog.pg_type 1 autotest_feat_batch.public.notification_param 1 autotest_feat_batch.public.pe_asset_usage_consolidation_daily 1 autotest_feat_batch.public.register_cost_annual 1 autotest_feat_batch.public.eng_mapping 1 autotest_feat_batch.public.gtp_cw_eng_history 1 autotest_feat_batch.public.log_profile_rel 1 autotest_feat_batch.public.gtp_history_rel_template 1 autotest_feat_batch.public.gtp_dependence 1 autotest_feat_batch.public.gtp_etat_contient_requete 1 autotest_feat_batch.public.register_cost_monthly 1 autotest_feat_batch.public.gtp_dependence_rel_template 1 autotest_feat_batch.public.gtp_node_tree_type 1 autotest_feat_batch.public.gtp_history_obj_link_unlink 1 autotest_feat_batch.public.gtp_log_ehcache 1 autotest_feat_batch.public.gtp_file 1 autotest_feat_batch.public.gtp_log 1 autotest_feat_batch.public.gtp_obj_template_calcul_rule_cascade_error 1 Total 159 Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 24 09 0 149 10 0 10 18 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 995 Total read queries
- 17,998 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 20,625 Requests
- 15m36s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 20,625 Requests
User Request type Count Duration a3dsupervisor Total 20,625 15m36s copy from 3,048 3m32s copy to 484 2m18s cte 2 6ms ddl 3,081 7m33s insert 11,377 3s222ms others 1,632 2m7s select 995 1s410ms tcl 6 0ms Duration by user
Key values
- 15m36s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 20,625 15m36s copy from 3,048 3m32s copy to 484 2m18s cte 2 6ms ddl 3,081 7m33s insert 11,377 3s222ms others 1,632 2m7s select 995 1s410ms tcl 6 0ms Queries by host
Key values
- 10.3.0.4 Main host
- 20,625 Requests
- 15m36s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 18,473 Requests
- 13m16s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-24 18:39:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 13,685 0-1ms duration
Slowest individual queries
Rank Duration Query 1 1m5s VACUUM ANALYZE;[ Date: 2025-09-24 10:05:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m VACUUM ANALYSE;[ Date: 2025-09-24 10:06:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 45s225ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 10:03:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 32s235ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2025-09-24 10:00:29 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 25s473ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-09-24 09:59:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 23s402ms CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);[ Date: 2025-09-24 10:00:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 20s814ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-09-24 10:23:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 20s778ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-24 10:01:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 20s709ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-09-24 18:33:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 14s762ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-09-24 09:56:28 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 14s444ms CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);[ Date: 2025-09-24 09:57:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 14s273ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-24 10:02:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 13s261ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-24 10:01:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 12s536ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-24 18:34:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 12s525ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-24 10:24:07 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 11s728ms ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-24 10:01:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 11s199ms CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);[ Date: 2025-09-24 09:59:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 10s826ms CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);[ Date: 2025-09-24 09:58:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 10s574ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);[ Date: 2025-09-24 09:56:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 9s580ms CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);[ Date: 2025-09-24 09:57:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1m5s 1 1m5s 1m5s 1m5s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 12 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: psql - Total duration: 1m5s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 10:05:02 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m 1 1m 1m 1m vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 12 1 1m 1m [ User: a3dsupervisor - Total duration: 1m - Times executed: 1 ]
[ Application: psql - Total duration: 1m - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 10:06:55 Duration: 1m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 56s604ms 65 219ms 1s304ms 870ms copy gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 11 65 56s604ms 870ms [ User: a3dsupervisor - Total duration: 56s604ms - Times executed: 65 ]
[ Application: psql - Total duration: 56s604ms - Times executed: 65 ]
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:52:43 Duration: 1s304ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:53:29 Duration: 1s280ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:52:59 Duration: 1s243ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 45s225ms 1 45s225ms 45s225ms 45s225ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 12 1 45s225ms 45s225ms [ User: a3dsupervisor - Total duration: 45s225ms - Times executed: 1 ]
[ Application: psql - Total duration: 45s225ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:03:10 Duration: 45s225ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 41s524ms 2 20s709ms 20s814ms 20s762ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 12 1 20s814ms 20s814ms 20 1 20s709ms 20s709ms [ User: a3dsupervisor - Total duration: 41s524ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 41s524ms - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-09-24 10:23:55 Duration: 20s814ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-09-24 18:33:53 Duration: 20s709ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 37s185ms 79 15ms 995ms 470ms copy gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 11 79 37s185ms 470ms [ User: a3dsupervisor - Total duration: 37s185ms - Times executed: 79 ]
[ Application: psql - Total duration: 37s185ms - Times executed: 79 ]
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:46 Duration: 995ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:37 Duration: 933ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:53 Duration: 826ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 32s235ms 1 32s235ms 32s235ms 32s235ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 12 1 32s235ms 32s235ms [ User: a3dsupervisor - Total duration: 32s235ms - Times executed: 1 ]
[ Application: psql - Total duration: 32s235ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-24 10:00:29 Duration: 32s235ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 26s710ms 19 513ms 3s31ms 1s405ms copy pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 11 19 26s710ms 1s405ms [ User: a3dsupervisor - Total duration: 26s710ms - Times executed: 19 ]
[ Application: psql - Total duration: 26s710ms - Times executed: 19 ]
-
COPY pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM STDIN;
Date: 2025-09-24 09:55:44 Duration: 3s31ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM STDIN;
Date: 2025-09-24 09:55:41 Duration: 2s649ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM STDIN;
Date: 2025-09-24 09:55:31 Duration: 2s450ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 25s473ms 1 25s473ms 25s473ms 25s473ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 11 1 25s473ms 25s473ms [ User: a3dsupervisor - Total duration: 25s473ms - Times executed: 1 ]
[ Application: psql - Total duration: 25s473ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 09:59:57 Duration: 25s473ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 25s62ms 2 12s525ms 12s536ms 12s531ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 12 1 12s525ms 12s525ms 20 1 12s536ms 12s536ms [ User: a3dsupervisor - Total duration: 25s62ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 25s62ms - Times executed: 2 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 18:34:06 Duration: 12s536ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 10:24:07 Duration: 12s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 23s402ms 1 23s402ms 23s402ms 23s402ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 12 1 23s402ms 23s402ms [ User: a3dsupervisor - Total duration: 23s402ms - Times executed: 1 ]
[ Application: psql - Total duration: 23s402ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-24 10:00:53 Duration: 23s402ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 21s934ms 36 243ms 1s175ms 609ms copy gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 11 36 21s934ms 609ms [ User: a3dsupervisor - Total duration: 21s934ms - Times executed: 36 ]
[ Application: psql - Total duration: 21s934ms - Times executed: 36 ]
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:54 Duration: 1s175ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:43 Duration: 1s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:51 Duration: 963ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 20s778ms 1 20s778ms 20s778ms 20s778ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 12 1 20s778ms 20s778ms [ User: a3dsupervisor - Total duration: 20s778ms - Times executed: 1 ]
[ Application: psql - Total duration: 20s778ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 10:01:40 Duration: 20s778ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 18s824ms 49 119ms 1s300ms 384ms copy gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 11 49 18s824ms 384ms [ User: a3dsupervisor - Total duration: 18s824ms - Times executed: 49 ]
[ Application: psql - Total duration: 18s824ms - Times executed: 49 ]
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:20 Duration: 1s300ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:24 Duration: 1s32ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:31 Duration: 981ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 17s364ms 2 8s668ms 8s695ms 8s682ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 12 1 8s695ms 8s695ms 20 1 8s668ms 8s668ms [ User: a3dsupervisor - Total duration: 17s364ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 17s364ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-24 10:24:16 Duration: 8s695ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-24 18:34:15 Duration: 8s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 17s288ms 2 8s634ms 8s653ms 8s644ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 12 1 8s653ms 8s653ms 20 1 8s634ms 8s634ms [ User: a3dsupervisor - Total duration: 17s288ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 17s288ms - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-24 10:24:25 Duration: 8s653ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-24 18:34:23 Duration: 8s634ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 16s834ms 27 240ms 1s249ms 623ms copy gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 11 27 16s834ms 623ms [ User: a3dsupervisor - Total duration: 16s834ms - Times executed: 27 ]
[ Application: psql - Total duration: 16s834ms - Times executed: 27 ]
-
COPY gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:54:18 Duration: 1s249ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:54:04 Duration: 923ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:54:12 Duration: 888ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 14s762ms 1 14s762ms 14s762ms 14s762ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 11 1 14s762ms 14s762ms [ User: a3dsupervisor - Total duration: 14s762ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s762ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-24 09:56:28 Duration: 14s762ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 14s444ms 1 14s444ms 14s444ms 14s444ms create index i_fk_month_histo_att on gtp_monthly_history (att_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 11 1 14s444ms 14s444ms [ User: a3dsupervisor - Total duration: 14s444ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s444ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-09-24 09:57:22 Duration: 14s444ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 14s273ms 1 14s273ms 14s273ms 14s273ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 12 1 14s273ms 14s273ms [ User: a3dsupervisor - Total duration: 14s273ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s273ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-24 10:02:08 Duration: 14s273ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 11,018 3s120ms 0ms 4ms 0ms insert into ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) values (?, ?, ?, ?, e ?, ?, null, e ?, e ?, ?, e ?, null, null, lo_from_bytea(?, decode(e ?, ?)), ?, ?, ?, ?, null, null, null, null);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 11 11,018 3s120ms 0ms [ User: a3dsupervisor - Total duration: 3s120ms - Times executed: 11018 ]
[ Application: psql - Total duration: 3s120ms - Times executed: 11018 ]
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (11030, 54, 75722, 54, E'log', 26, NULL, E'blanchi - Copie (33) - Copie.log', E'blanchi - Copie (33) - Copie', '2023-06-01 16:23:40', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b03041400080808009682c15600000000000000000000000020000000626c616e636869202d20436f7069652028333329202d20436f7069652e6c6f67538876494d4b2ccd2971c9cf4dccccb352008158d78800ffa010c7104f7f3f0517575fc7a02057572b0523237d03137d230343630543732b13232b03435e2e5e2e05824684b806f97afa6137c218640400504b07080f120f245100000086000000504b010214001400080808009682c1560f120f245100000086000000200000000000000000000000000000000000626c616e636869202d20436f7069652028333329202d20436f7069652e6c6f67504b050600000000010001004e0000009f0000000000', 'hex')), 134, 1, 1, '2023-06-01 16:12:59', NULL, NULL, NULL, NULL);
Date: 2025-09-24 09:51:16 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (6892, 54, 71473, 54, E'log', 26, NULL, E'blanchi - Copie (19).log', E'blanchi - Copie (19)', '2023-06-01 16:18:23', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b03041400080808004b82c15600000000000000000000000018000000626c616e636869202d20436f70696520283139292e6c6f67538876494d4b2ccd2971c9cf4dccccb352008158d78800ffa010c7104f7f3f0517575fc7a02057572b0523237d03137d230343630543732b13232b03435e2e5e2e05824684b806f97afa6137c218640400504b07080f120f245100000086000000504b010214001400080808004b82c1560f120f245100000086000000180000000000000000000000000000000000626c616e636869202d20436f70696520283139292e6c6f67504b0506000000000100010046000000970000000000', 'hex')), 134, 1, 1, '2023-06-01 16:12:59', NULL, NULL, NULL, NULL);
Date: 2025-09-24 09:50:53 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (10112, 54, 74781, 54, E'log', 26, NULL, E'blanchi - Copie (2).log', E'blanchi - Copie (2)', '2023-06-01 16:23:40', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b03041400080808009682c15600000000000000000000000017000000626c616e636869202d20436f706965202832292e6c6f67538876494d4b2ccd2971c9cf4dccccb352008158d78800ffa010c7104f7f3f0517575fc7a02057572b0523237d03137d230343630543732b13232b03435e2e5e2e05824684b806f97afa6137c218640400504b07080f120f245100000086000000504b010214001400080808009682c1560f120f245100000086000000170000000000000000000000000000000000626c616e636869202d20436f706965202832292e6c6f67504b0506000000000100010045000000960000000000', 'hex')), 134, 1, 1, '2023-06-01 16:12:59', NULL, NULL, NULL, NULL);
Date: 2025-09-24 09:50:57 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1,178 5s652ms 3ms 21ms 4ms copy ged_history_node (history_node_num_id, node_num_id, project_num_id, old_value, new_value, application, transaction_type, process_type, version, element_type, node_comment, modification_date, modifier_num_id, node_path) from stdin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 11 1,178 5s652ms 4ms [ User: a3dsupervisor - Total duration: 5s652ms - Times executed: 1178 ]
[ Application: psql - Total duration: 5s652ms - Times executed: 1178 ]
-
COPY ged_history_node (history_node_num_id, node_num_id, project_num_id, old_value, new_value, application, transaction_type, process_type, version, element_type, node_comment, modification_date, modifier_num_id, node_path) FROM STDIN;
Date: 2025-09-24 09:51:54 Duration: 21ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY ged_history_node (history_node_num_id, node_num_id, project_num_id, old_value, new_value, application, transaction_type, process_type, version, element_type, node_comment, modification_date, modifier_num_id, node_path) FROM STDIN;
Date: 2025-09-24 09:51:50 Duration: 12ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY ged_history_node (history_node_num_id, node_num_id, project_num_id, old_value, new_value, application, transaction_type, process_type, version, element_type, node_comment, modification_date, modifier_num_id, node_path) FROM STDIN;
Date: 2025-09-24 09:51:52 Duration: 10ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 750 4s346ms 4ms 122ms 5ms copy gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) from stdin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 11 750 4s346ms 5ms [ User: a3dsupervisor - Total duration: 4s346ms - Times executed: 750 ]
[ Application: psql - Total duration: 4s346ms - Times executed: 750 ]
-
COPY gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) FROM STDIN;
Date: 2025-09-24 09:55:05 Duration: 122ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) FROM STDIN;
Date: 2025-09-24 09:55:04 Duration: 113ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) FROM STDIN;
Date: 2025-09-24 09:55:03 Duration: 70ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 328 52ms 0ms 3ms 0ms select format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle from pg_catalog.pg_sequence where seqrelid = ?::oid;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 12 164 25ms 0ms 20 164 26ms 0ms [ User: a3dsupervisor - Total duration: 52ms - Times executed: 328 ]
[ Application: pg_dump - Total duration: 52ms - Times executed: 328 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;
Date: 2025-09-24 18:28:10 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800478'::oid;
Date: 2025-09-24 10:18:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800512'::oid;
Date: 2025-09-24 10:18:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 267 89ms 0ms 0ms 0ms set client_encoding to ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 11 258 86ms 0ms 12 7 1ms 0ms 20 2 1ms 0ms [ User: a3dsupervisor - Total duration: 89ms - Times executed: 267 ]
[ Application: psql - Total duration: 88ms - Times executed: 263 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 4 ]
-
SET client_encoding TO 'UTF8';
Date: 2025-09-24 09:55:19 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
SET client_encoding TO 'UTF8';
Date: 2025-09-24 09:56:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
set client_encoding to 'UTF8';
Date: 2025-09-24 18:28:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 254 15ms 0ms 0ms 0ms set synchronous_commit to off;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 11 254 15ms 0ms [ User: a3dsupervisor - Total duration: 15ms - Times executed: 254 ]
[ Application: psql - Total duration: 15ms - Times executed: 254 ]
-
SET synchronous_commit TO off;
Date: 2025-09-24 09:55:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
SET synchronous_commit TO off;
Date: 2025-09-24 09:53:36 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
SET synchronous_commit TO off;
Date: 2025-09-24 09:38:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 218 40ms 0ms 2ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 12 109 19ms 0ms 20 109 21ms 0ms [ User: a3dsupervisor - Total duration: 40ms - Times executed: 218 ]
[ Application: pg_dump - Total duration: 40ms - Times executed: 218 ]
-
EXECUTE dumpFunc ('2818849');
Date: 2025-09-24 18:28:09 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818912');
Date: 2025-09-24 10:18:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818867');
Date: 2025-09-24 18:28:09 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 177 52ms 0ms 5ms 0ms insert into ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) values (?, ?, ?, ?, e ?, ?, null, e ?, e ?, ?, e ?, null, null, lo_from_bytea(?, decode(e ?, ?)), ?, ?, ?, null, null, null, null, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 11 177 52ms 0ms [ User: a3dsupervisor - Total duration: 52ms - Times executed: 177 ]
[ Application: psql - Total duration: 52ms - Times executed: 177 ]
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (844, 6, 423, 6, E'XML', 1, NULL, E'EXTINCTEUR.xml', E'EXTINCTEUR.xml', '2015-04-07 14:25:58', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b03041400080808003b7387460000000000000000000000000e000000455854494e43544555522e786d6ce598dd729a4014c7afdb99bec3d6db8e414c8c3a43cc105895a84096251f570cd19d9419058b68f34ab9ef1bf862dde543c58f4033855ef4c681ff3967777fe79c5d04e1fa7536052be22f1ccfbdaaf067b50a20eed89b38eecb55c5c4dd6aab72ddf9f25990b491ae190a563495de7e127a508548c41ab2ee213298ca9ff102772833e70705f72d45ee5087e492c95d0519d8d26e6e2d0c47fa50c4d052cd11b3366b0d813b6d66c1080e2d032353c226824c0925315920bd3d39f08921a3110e2cad465be08e19b621b282a014ce3cf17eba91f7568bfc8694c5d0d424b8d114b83d2964e07621a2915294027c9476d6d261314a4fd510b4a8849fac7b71684296e9236a38c32e7dbcb6afd52a8077a6a2c3115431902130a06422054350ad7e3c9bb266a91ab614da3908b325a585c829e279d0d0c0e84318abb46512c152c511ecc047aca8128626a22d9436c501487bb0a80b0a11d8646921f63255e5ce84748996a40d3ba2c0a585032f3a48e762d78b09b1d748d47545ed5922c65648111ba27c4ade840024cb9b0c529d796e5225d19f9e869e929cd5e99adf75383a4a6cbb6c37f6a2f78262dc2d649831c6b625a29d64c4db34ba8841b913a40277ac78e98e78bfe736557dbfcfd86639dd665d11f7214a0aba73973287b4dfaef88dc7863bf1c04f3add385b87f03ef288eb1f1b0eba27ad9f08d92ee0a8e9dfef869bff6b37dcfce5dd909582a1f34ca6d3f55b3929e09b17d929903252f06156d90e08982cc184f8ae437c30f6dcc05fff9a9292ea7fb11f7d045e2e0a5edac06a03c081815612742b47c56151d0aa377bf6cb2a6fab964dda2daebcb3197103dbf1c9a21cde7a3b47657b45f1423770027a6cbd9045405f125c065ed636cec1dd2f8a5b9ccf6d3f7068a981bd0473cf0fcaa16ef239ba5b29ece45efaeb377a7613b0720808beafdf3cdff9b12ca9e24d3ec7c17d5bec538b8099b320f42d182c88bf72c6f9d10f16ff479bbc51cf461f948d4e9b61e52c58479492843c7f5a8685e68075ff741ae6c227b3f9d41e1376da97837fc19f67f38f8ae2efd9f4c1163681edb801716db7acde3faf5f6673ab4571df2dedf811570e6c2d47936b45c1eabef31a357939b4ed6c56fda3ac79bf3f247e3b1a9b72fb41f337504b07084d6a14a23c03000006150000504b010214001400080808003b7387464d6a14a23c030000061500000e0000000000000000000000000000000000455854494e43544555522e786d6c504b050600000000010001003c000000780300000000', 'hex')), 5382, 1, 1, NULL, NULL, NULL, NULL, 1);
Date: 2025-09-24 09:49:55 Duration: 5ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (1104, 1, 553, 1, E'XML', 1, NULL, E'RESEAU TELECOM.xml', E'RESEAU TELECOM.xml', '2015-04-14 10:57:41', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b030414000808080030578e46000000000000000000000000120000005245534541552054454c45434f4d2e786d6ce598dd729a4014c7afdb99bec3d6ab763a8690981867881982ab92209865499a2b86e8b66506c122daf491bcef1bf862dde543c48f403385e94c6f1c39e7ec727ee7fc0f2b0a57cf13072c883fb33df7b2c61f1dd7007147ded876bf5ed60cdcad5fd4aedaefde0a9236186aba8c654da5976f841e542112b186cc7b887466e58f7881db35b3e00719f74db9d3a601c95766eeca48c7a6767d636238182a2286a66a0c98f7fcf442e00ebbd962041553c7c890b08120b384263149905e1edcf8c096d10e3b9e66b32170fb1ce9928e8ca014de79ecfd70a3e8d416c5299445d7d4349196c06dd942086e9322da2a8329c0cfd246326db646eea91a822635e147f35e540cc84abdc71ade61133f4eee7dbd0e10d4a168800f9237f72d37005f2cfbc9211f41bdfefa7a763453d5b02953ed20cc72ca1aa2a008e84143b77a1fc2d84a4593184c551cc0769c1e860aa45aa442cabae345487b306555427000d5f08659431c65a8f29d01699aa6a4296d51e0b2869d28ba49bbb119c50c71d4401c0e65b5678a189b2149ec888a2a79630250a7b3ae22b5b3c875b924fad1d3d06352b7139af38b017b7749bad13adb5abdb528c64d21c38a31b69488ca498f8735fa1283720748056e5f03b3aa2822bcb8b3797a6bbda4b7ae88fb10255dddb8cab843e44f97fc3a620d9f44e0c7211da13420bc8e226211c48e1d0965ed0796a409ec75fd1b6371fd7f8dc5f55f1e8bbc1228f613719cd5b29a12f0ec10cb2b8194538257b376ac8080f11c8c89efdac40723cf0dfcd52f8754d4ffc6f6ea3df09db2e0f1cf298527c05f2d67c49a8360b5a46d1f79936ae09be705e06159f09237991037b06c9fccaae13d6915507ab72c5ee806366d30f84a6601fd45ed32f0aa445e80bb5716b7389d5a7e60d356032af1a9e70715a99b3fcea7ee97f65c9bd3a10e877b6113107c5b2d3ddffe3eafa8e34dbec064cbe53ed30998d833425f19c18cf80b7b541c7d27f93f1af2b3937cf49baad1a91816f68c29a292221439d26f4bad0153bfe344a71b994c1d6b44d8d3be1afc067f9acfaf94c5dfb3e8c1168ac0b2dd80b8965b95f64f4fcef3b9076571dfcdadf888ab06f6b880c8d5b26087befd1c89bc1ada563eabf65ad6a2afe949dc868ddd32fdf7ef37504b0708d485a4553c03000033140000504b0102140014000808080030578e46d485a4553c030000331400001200000000000000000000000000000000005245534541552054454c45434f4d2e786d6c504b05060000000001000100400000007c0300000000', 'hex')), 5171, 1, 1, NULL, NULL, NULL, NULL, 1);
Date: 2025-09-24 09:49:56 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (1020, 6, 511, 6, E'XML', 1, NULL, E'AVANT BEC.xml', E'AVANT BEC.xml', '2015-04-10 11:47:19', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b0304140008080800e85d8a460000000000000000000000000d0000004156414e54204245432e786d6ce598dd729a4014c7afdb99bec3d6db8e41d4c43a43cc20ae4aa240962569ae76a8eeb4cc2858449b57ca7ddfc017eb2e1f2a7e049a29f4a2370efccfd98fdfd9ff1151ba799ecfc09afa4bc773af2be245ad02a83bf1a68efbedba62e17ef573e5a6f3e1bda4e863433755acea1abb7d270da006918c75441e2032b92a5e8892702cf3e447150f89daebb084e492cb7d159998e8dd5b82e1d818c91812cd1af3e865bd2509e7c37c30822362626429d842902ba124271b64b767273e336534c351e4aac1869c0aec86f454049570e5a9f7d38db2775a9437622ca6ae6d67adb525e1400b21847d8a68aa14a604bf287b9be9f031ea40d311244cc24fe4411e599097fa841aaeb08f1f6fee63b50a4ccb6047962c05aad5b797b1a7134dc744659641986f252d444911c7a38eeecc2184b1cabc92084493c7b0233fc81a065da830eba423713ed21f89aa29088ea116ae9516e22c4b53ef2dc87648147dd49125212d1c65b1493acdfd2c2ec45963d930546d40648c49081107a2322ade9402d4eb6d0bc8749eb9ad94c23e063a7a4a4a56677b7e35e1e42c898dda9707a30f06c5b83bc8b0629c6d47c40c64c6ed195dc4a0c21952493875766943bc6ab5eda1beeeb2b047cebbac2fe32144c981eedda5c221eda76b719bb1e54e32f093c1fa659710de4719f1f9c78123f7a4f53343761b3819fae7cdd0fdbf9aa1fb979b21ab0423e72b9dcd362fe594406c35b34ba06494e0cdac30b083928ebad1cee6ec15c5d9b3030aa62b30a5beeb501f4c3c37f037bf66b424f8e6e1e813f0b02878c59bcfa91bd88e4f97e5f0d6db394cdd2fccd46ee004ac7fbfd165c07e24bb1cbcac73cec13d288a5b5e2c6c3f70d851037b05169e5f526bb7c45a36f5b0b0d65ef99b17d6dc14ac1d0a82ef9b17cf777eac4a3af19698a3b3d562bfd628983b4bcade02c192fa6b67921ffd68f37fd4e497f56cf4dbb2d19919d6ce923ba29422e4797adf155a03eefed92cac854fe78b993da1fcdbbe1cfca6d8c8e61f15c53fb0d9832d3481edb801756db72cef37ea57d9dce3a2b8ef5776fc882b07b696c3e45a51b086ef3c47262f8736c7cf54fdadac79dfc393bc3d8d2fb9fb43ef37504b070820ad4ab42003000006140000504b01021400140008080800e85d8a4620ad4ab420030000061400000d00000000000000000000000000000000004156414e54204245432e786d6c504b050600000000010001003b0000005b0300000000', 'hex')), 5126, 1, 1, NULL, NULL, NULL, NULL, 1);
Date: 2025-09-24 09:49:55 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 161 826ms 3ms 9ms 5ms copy gtp_history_att_template (history_att_template_id, att_template_num_id, workspace_num_id, history_att_unit_num_id, att_template_domain_code, att_template_name_fr, att_template_default_value, att_template_min, att_template_max, att_template_scale, att_template_size, att_template_obligatoire, att_template_date_format, att_template_a3d_num_id, att_template_unique_value, unique_code, att_template_tooltip, action_type, att_template_extra, modification_date, modifier_num_id, att_template_line_wrap, att_activated_unit, att_template_bim_activated, history_transaction_type) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 11 161 826ms 5ms [ User: a3dsupervisor - Total duration: 826ms - Times executed: 161 ]
[ Application: psql - Total duration: 826ms - Times executed: 161 ]
-
COPY gtp_history_att_template (history_att_template_id, att_template_num_id, workspace_num_id, history_att_unit_num_id, att_template_domain_code, att_template_name_fr, att_template_default_value, att_template_min, att_template_max, att_template_scale, att_template_size, att_template_obligatoire, att_template_date_format, att_template_a3d_num_id, att_template_unique_value, unique_code, att_template_tooltip, action_type, att_template_extra, modification_date, modifier_num_id, att_template_line_wrap, att_activated_unit, att_template_bim_activated, history_transaction_type) FROM STDIN;
Date: 2025-09-24 09:52:11 Duration: 9ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_att_template (history_att_template_id, att_template_num_id, workspace_num_id, history_att_unit_num_id, att_template_domain_code, att_template_name_fr, att_template_default_value, att_template_min, att_template_max, att_template_scale, att_template_size, att_template_obligatoire, att_template_date_format, att_template_a3d_num_id, att_template_unique_value, unique_code, att_template_tooltip, action_type, att_template_extra, modification_date, modifier_num_id, att_template_line_wrap, att_activated_unit, att_template_bim_activated, history_transaction_type) FROM STDIN;
Date: 2025-09-24 09:52:11 Duration: 8ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_att_template (history_att_template_id, att_template_num_id, workspace_num_id, history_att_unit_num_id, att_template_domain_code, att_template_name_fr, att_template_default_value, att_template_min, att_template_max, att_template_scale, att_template_size, att_template_obligatoire, att_template_date_format, att_template_a3d_num_id, att_template_unique_value, unique_code, att_template_tooltip, action_type, att_template_extra, modification_date, modifier_num_id, att_template_line_wrap, att_activated_unit, att_template_bim_activated, history_transaction_type) FROM STDIN;
Date: 2025-09-24 09:52:11 Duration: 8ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 147 1s70ms 4ms 125ms 7ms copy gtp_history_obj_template (history_obj_template_id, obj_template_num_id, obj_template_name_fr, unique_code, composition_modified, table_line_number_modified, monthly_history_modified, sensitive_data_modified, visible_att_modified, constraint_modified, request_modified, state_modified, sequence_modified, validation_rule_modified, display_influence_modified, advanced_settings_modified, action_type, obj_template_extra, modification_date, modifier_num_id, history_transaction_type) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 11 147 1s70ms 7ms [ User: a3dsupervisor - Total duration: 1s70ms - Times executed: 147 ]
[ Application: psql - Total duration: 1s70ms - Times executed: 147 ]
-
COPY gtp_history_obj_template (history_obj_template_id, obj_template_num_id, obj_template_name_fr, unique_code, composition_modified, table_line_number_modified, monthly_history_modified, sensitive_data_modified, visible_att_modified, constraint_modified, request_modified, state_modified, sequence_modified, validation_rule_modified, display_influence_modified, advanced_settings_modified, action_type, obj_template_extra, modification_date, modifier_num_id, history_transaction_type) FROM STDIN;
Date: 2025-09-24 09:52:36 Duration: 125ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_template (history_obj_template_id, obj_template_num_id, obj_template_name_fr, unique_code, composition_modified, table_line_number_modified, monthly_history_modified, sensitive_data_modified, visible_att_modified, constraint_modified, request_modified, state_modified, sequence_modified, validation_rule_modified, display_influence_modified, advanced_settings_modified, action_type, obj_template_extra, modification_date, modifier_num_id, history_transaction_type) FROM STDIN;
Date: 2025-09-24 09:52:36 Duration: 102ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_template (history_obj_template_id, obj_template_num_id, obj_template_name_fr, unique_code, composition_modified, table_line_number_modified, monthly_history_modified, sensitive_data_modified, visible_att_modified, constraint_modified, request_modified, state_modified, sequence_modified, validation_rule_modified, display_influence_modified, advanced_settings_modified, action_type, obj_template_extra, modification_date, modifier_num_id, history_transaction_type) FROM STDIN;
Date: 2025-09-24 09:52:38 Duration: 11ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 123 602ms 3ms 19ms 4ms copy gtp_obj_template_calcul_rule_cascade_info (id, rule_id, trigger_ot_num_id, trigger_cat_num_id, trigger_att_num_id, is_contextual, path_long, path) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 11 123 602ms 4ms [ User: a3dsupervisor - Total duration: 602ms - Times executed: 123 ]
[ Application: psql - Total duration: 602ms - Times executed: 123 ]
-
COPY gtp_obj_template_calcul_rule_cascade_info (id, rule_id, trigger_ot_num_id, trigger_cat_num_id, trigger_att_num_id, is_contextual, path_long, path) FROM STDIN;
Date: 2025-09-24 09:55:07 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_template_calcul_rule_cascade_info (id, rule_id, trigger_ot_num_id, trigger_cat_num_id, trigger_att_num_id, is_contextual, path_long, path) FROM STDIN;
Date: 2025-09-24 09:55:07 Duration: 9ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_template_calcul_rule_cascade_info (id, rule_id, trigger_ot_num_id, trigger_cat_num_id, trigger_att_num_id, is_contextual, path_long, path) FROM STDIN;
Date: 2025-09-24 09:55:07 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 79 37s185ms 15ms 995ms 470ms copy gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 11 79 37s185ms 470ms [ User: a3dsupervisor - Total duration: 37s185ms - Times executed: 79 ]
[ Application: psql - Total duration: 37s185ms - Times executed: 79 ]
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:46 Duration: 995ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:37 Duration: 933ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:53 Duration: 826ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 65 56s604ms 219ms 1s304ms 870ms copy gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 11 65 56s604ms 870ms [ User: a3dsupervisor - Total duration: 56s604ms - Times executed: 65 ]
[ Application: psql - Total duration: 56s604ms - Times executed: 65 ]
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:52:43 Duration: 1s304ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:53:29 Duration: 1s280ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:52:59 Duration: 1s243ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 64 12ms 0ms 0ms 0ms insert into ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) values (?, ?, ?, ?, e ?, ?, null, e ?, e ?, ?, e ?, null, null, null, ?, ?, ?, ?, null, null, null, null);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 11 64 12ms 0ms [ User: a3dsupervisor - Total duration: 12ms - Times executed: 64 ]
[ Application: psql - Total duration: 12ms - Times executed: 64 ]
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (2215, 6, 12873, 6, E'jpg', 9, NULL, E'8 k 34 (4).jpg', E'8 k 34 (4)', '2018-10-16 14:19:27', E'1', NULL, NULL, NULL, 0, 1, 1, '2016-10-19 22:31:56', NULL, NULL, NULL, NULL);
Date: 2025-09-24 09:50:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (2080, 6, 11622, 6, E'png', 3, NULL, E'arrow_left_16.png', E'arrow_left_16', '2018-09-12 15:12:13', E'1', NULL, NULL, NULL, 0, 1, 1, '2016-11-02 09:17:00', NULL, NULL, NULL, NULL);
Date: 2025-09-24 09:50:12 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (2100, 6, 12628, 6, E'png', 9, NULL, E'breadcrumb_sep_arrow_16.png', E'breadcrumb_sep_arrow_16', '2018-10-11 14:04:05', E'1', NULL, NULL, NULL, 0, 1, 1, '2017-10-18 08:44:22', NULL, NULL, NULL, NULL);
Date: 2025-09-24 09:50:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 55 390ms 4ms 17ms 7ms copy gtp_requete_v2 (requete_v2_num_id, user_num_id, workspace_num_id, requete_v2_nom, requete_v2_value, requete_v2_have_user_condition, requete_v2_last_modif, requete_v2_date_creation, obj_template_num_id, requete_v2_comment, requete_v2_a3d_num_id, unique_code, user_num_id_modifier, requete_v2_group_num_id) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 11 55 390ms 7ms [ User: a3dsupervisor - Total duration: 390ms - Times executed: 55 ]
[ Application: psql - Total duration: 390ms - Times executed: 55 ]
-
COPY gtp_requete_v2 (requete_v2_num_id, user_num_id, workspace_num_id, requete_v2_nom, requete_v2_value, requete_v2_have_user_condition, requete_v2_last_modif, requete_v2_date_creation, obj_template_num_id, requete_v2_comment, requete_v2_a3d_num_id, unique_code, user_num_id_modifier, requete_v2_group_num_id) FROM STDIN;
Date: 2025-09-24 09:55:17 Duration: 17ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_requete_v2 (requete_v2_num_id, user_num_id, workspace_num_id, requete_v2_nom, requete_v2_value, requete_v2_have_user_condition, requete_v2_last_modif, requete_v2_date_creation, obj_template_num_id, requete_v2_comment, requete_v2_a3d_num_id, unique_code, user_num_id_modifier, requete_v2_group_num_id) FROM STDIN;
Date: 2025-09-24 09:55:17 Duration: 16ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_requete_v2 (requete_v2_num_id, user_num_id, workspace_num_id, requete_v2_nom, requete_v2_value, requete_v2_have_user_condition, requete_v2_last_modif, requete_v2_date_creation, obj_template_num_id, requete_v2_comment, requete_v2_a3d_num_id, unique_code, user_num_id_modifier, requete_v2_group_num_id) FROM STDIN;
Date: 2025-09-24 09:55:17 Duration: 16ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 49 18s824ms 119ms 1s300ms 384ms copy gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 11 49 18s824ms 384ms [ User: a3dsupervisor - Total duration: 18s824ms - Times executed: 49 ]
[ Application: psql - Total duration: 18s824ms - Times executed: 49 ]
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:20 Duration: 1s300ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:24 Duration: 1s32ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:31 Duration: 981ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 45 15ms 0ms 0ms 0ms insert into ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) values (?, ?, ?, ?, e ?, ?, null, e ?, e ?, ?, e ?, null, null, lo_from_bytea(?, decode(e ?, ?)), ?, ?, ?, ?, null, ?, null, null);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 11 45 15ms 0ms [ User: a3dsupervisor - Total duration: 15ms - Times executed: 45 ]
[ Application: psql - Total duration: 15ms - Times executed: 45 ]
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (18393, 6, 92382, 6, E'xlsx', 185, NULL, E'B.xlsx', E'B', '2024-04-30 16:21:05', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b0304140008080800a1829e5800000000000000000000000006000000422e786c7378ed7a65545b6bb775702f50dca5d0e2ae85508a138a17b722a158b1a4b8b4418b147777a7b886a2850628147742811697e272808f9ef7bdf7f4f4f6fdfddd31ee991979b2b3f7582b19c99c4b9eb53554d0d0490198006c0000c00428c2dff2b441010008300000120036aa91ac932314ec08357beae90c8698f078bc7060cc454765cb06a002fec1ff6994c70f3876f111c99f265c10c634ea58ace79672a0864b25726b6d60359d04ea9fb10e4b7fd9dba22c2ee5c0609aee014942863ff588e62166532d3088ebdd856974d1745fc599da8abe9be9db2e803fc788750651ee655bd3488b509999455aa701f4f31d4384eddf74a1adb11955a17232741464f42a72b22df48a13caf0f4d09eed3c73ee2b70477f0bda149af638428fd4a7e6c89cdaf83ea98c1e50ee314fee569efa8628221116abfdde7593b0609eb8743cc5be6a02c52996a0d71b6761e8e69509d2885a751c37ac24f488c3a1a6732ad8ffbce9ecc84f938e7cc365234d4145c394e745aa7410134c631a355a58c79493b36eee52aa63f8c3c743017855ccee55cd3e3143fc7bd17d1f205226511c556e96b243250a184e7faf9119e655941cebe282d65e4f78aeb4664deddb119f8d5da46ece1053d98aaf8ccd6c7b86a38c34bf642a3cca00baad1f544867f427aab0380df73a81bd96246f067b91b7bff1cd0d1a40e36f0225317d0f46bd1528f2567f78b7023573053b4078797eacff08f31ffc4079acaa0a1a3f51f01eec8669b04d628e8379d481577e5dd5ea0a853fe5ea99684a747ecbd5a9c263684e03bd57fa3bf74ccf9463eb9a3c8f3c226fb7bb89f238b074ebb156dd2e95aba6262ce2385785c86da5aed7cc0ea55b65c782911c5f73a68fa5c2ca97730379586f5e51be54d4fd0003361bdb8ae927b8521a1e81084b598d13bed20523a9353e097d1852c29680a0e54a9dc1cfe122a2aaef6c07bc9c1005f738a30be586a20dcea26764360f857375730a583aabfcfa3742fb2f992dd1e81f185e65adefd98f686929b006a5a2657c3bdf16c3a883e7cb4348fce753147cd6f8e0028445fa8ebc88dc53fe6aa0e590deb0e8dda1c59a0bc0ef2493e5857287050d00c0c50200086fcf7838f0ba3bb9da5b3839d9ffc867e53a0b8e697ca4efb3eadcab7cd43ba5af356c1302a1e1e3ba23a915a24a31686adf7193670a95758e5fbbb58b4e87ef50825a45444d24e2a793d1b2da2143ee6f09a3dce5df3a263f358e67ba8f7547a1fc895cff401991bf49a6be6c447c211804d1ac21420a04454549f989cde37ab6912f53a34897c8a4db9a603454c446903da50b0d4b7836836da041a0e2092e0309a49646f09bac366c89f9b666c37bb86518cd0298446832ab94585e768216604a89da04473abd9c13396408fb255c8e775bfd20394d949ed43563a448362599325f3b4750fe16edfc620cfdacf2d9f117755aca79c7077c3b2f74f6e57059452e00d93b894799373dd5389ee4b0053f7cd390d5b9d805e7b86e45dd9a1b05dd2bc5f26b124a97c5480569c3485d54ec459a11afa879631f68d317f1cb4910c548e9c3a220c4d3b79a6a099905c6b5423d68fa61dcde5e0053444beab8245699843310b693a728cecbc2c578ba622c68a0f5a930779cb11e6b732f412700f8093d94d2d7fc911d0fd5f81d25ecf9d731f7514cca3026a84ac1f4cbb644590b7eb1b9954fe156cac1bda6d0e883bddc083a77b26a0e8af4145068526df85779b8185dd6bbc19d4d073ffaac714f3fc4a48b1e8f5d7da058f1d91897a17cbbbf6ebbbf6dbc003a5982cbfd957674d5d3b23506165512124d9adc69afd9c5f6083631ae00b5063c6ee2f9e13c6da5058cb6d77230e3d1908759b285a18d1c2454d1130b1fc3ffe81ccfd2efd99248f4174837c853166a90f45ff22679beda24bb479f1e73c5485c373913a0800f0df525eac9dc88d87d88e7024b2d5217da4d0f1910380ccfa95da0095115fda37746175882e01ad98d4d2a990e9e66be031d9b5b1b7861095f2d19927e9b3987e6db302c25e8978062b97c8259485a609f1c744695570c86a22681839f476cb7b309fb52140b0b72a41936f3b5254b07884248ac8a233bb699d66cb5c9dd4e0d640ead98625252292e77433d7aed1bc68a40a282368968c0658995d78207dccfbf1d73f98bb956e4ec354f8e47cd1b38f1855bc76522a2c445613723c0b4519c163444d560f1b88a729cbd58effbaa4f811c444fb788f631806ee53bbb65798f7e2ba8d752f14987b7472db7a9861a808d722ba87fa5a19f65f55f2909e53625a1fcff0c87ff1b50aea5aad2c347d486771dc2e79ee646463c03e565ded6d922c446d4b1cfdd6712f43b42d270b498e84faaf0a239057bee7dea733b15beb38c4672dcc9591c7617dd8bc4614f02c3e9d3e127346c8b9d0a7a982206c9ddedcdadb21dbc3ba9109266a9d88f5c99a462dfced858a942f20a99e58e9a478385ec86f85e0ad8413ed3f5ab1a2c0ed4adbeba08d4deae80d5353632a6b25b7fbd69969d3bc1cc8279328c1c52e1284b12780246d6c79938cf3ae54fb00fe07f58ab7a0ed977e65de07fa52d53a12f1506fa044319433e2a32f8b3c742bee6a6b4eaec7d81ca5cf6b3b7cf1d700d1ced59af22fa267e5fb6ecd1f339e6ddd2a50b1d00a004fc770c86d880c15008ef9f2ffc3f58931ea7e2d4c587dfb7177742973b6f6b68ca49064e15515d11d9f154d34e5258d564357f55e87bda0cee60e109e550356cbd9eb9e9c95874ac63365b82d7dd2f5226d5465598d64a95574322e9bdd959a59cb55dc104ab50bcccc5a1ca7785f65b89ef31b1d1717ad7eaeee420280f73313ff95ad1f0ad97948f492e9519f121c596c014f9645b7ddf936d7908168805dcef74eb2690ee3ffb000ac0910845fb8036b9673f7306540d8738a7b67e2dddc029a39123d54254ed64c7dbc47ca2e87d68ca36dea61c6c1c1dd93dd2e75da53e36a32e60cb9e7edc804b1c3b53f94dfb9c44c4dc9856a9e862b88b45f6db924a039687dc312f273b159dfed53d076726079f57f5735f6b12b8201774372640e338b7b0a8b1c553d9e7635acb388da5a1011c45ee38e05adb294986bb93d748411cb807060633e0be129bad776d95db8c9f98a2f67c704ddc745fa568161d7b538877991498ca0e7de99186cc073d0eda48dbf8c2953496362aba745eb72b74574d2c7c2a05d9f8e913255d47860e3c07b5411a02be43de3fffc33f971af62125556e17652ee5ba5af67e5e3db61a1d81a75a6c3c4a839c9835e5afb67165e37aaccae24149e3cbabe3f0bb46ac68404b568934ab682dc56c498d7cca8fbcb5825523bcb5b523ea9816d9cad277cd85fe72fe34ea31ee8f16e29d809cb3ad85bc9c6a6dd56864cb58bd9cc48bb01724b1d9265e584eebcae5ec64f3837f9c627d1b76be8727a964141f19800b6120113120aa02e760eed4e3eca677c87bbfdb7a4dda8fbf93648dee5a710578baef9788a9ed9c016e0b6ca8d41dfac8d9dba30fb5d953ead19fb46e7bd41851bd23de0125a5160715d82ba372c92eb0b287e712b010c3b378c59a7751d6453cc3c12bafc7cc12978e6e702f3e9f7c23cda560f82db15f4aa5d8c661020011d43f1ae63f890db501bf00ff6bfd93d3db0646e1730aa47ebc478fb0db24de2bd7b4f5d038cca8cd6edf67daca5f757188aa40bc1552105c8cc4791d2b795ca0a1a46286ebbb25cb4e20f4f973d2757250a0c815315030b622e5582c6da0b08ed55e3f7fc47dc8073234224a610287f2160e11ab899b2bcf55981637dd51eb75908935986b13a68d4fadecc600dd0fad416f5c60fdb65bb010f5a825d44d2ed072fb956f97bbc65c6460f25efc800ffea750b36790f48e5a76154b9625918c8407ec0f31dbf9b9a73812b269efc536a9c12c9cbd7d1fb25a6ee317a8b8bb7f85ab7f1121361689b0f56234b1ec96317f10a2f36649857e745c5ca66e47e611899b64cf69e096460f86a44d2bd9f15aa23b6fe2889aa3dc0772a34f8ed9d7aeadf3cf5cf5b57d0b6b475ab4870fdbb26b4fde019e3a2c5f44fa7d269cbc260544f6f18d4684ef8eed35b4001ff5d9656f8f2eb74ead4f94619a1e9a2197e6bf7f1deee0d4f8869ceb20c464921bb93d0e3ee5e6b71d97f9713a9850643f1254b4268c0f47958f6709a1590f6318ef9eb0998a66cfd32bdf4fdc23a0ae9ff77c0db3d3d74bdab6e8bf5b5d3169014d2a40032831cac358deea0f7d278dcc09939543b0b10ed1a7c86b7840e2f9ee7c4a30046b9474fb9f1f8e278461cf762ad526c25fe1206d627d68a5d410c6750bea9d65658f331f79bb1dec6f20bacdd4e9810f3dcf208b8daee06993c788278ddee7dd7afeb721eb708d17d9eef3c7cbc9635bc9a9efbc7e17cb1f9cdadbfb81114dd81f0e9d32e11e17abe78d66d7df572cc34fd5c2141efa28590c66d89f4d37232c28b3831ed1173859f34710f17369a0bfe7aebc6416783595183aeb6ce210bcef86cb6189666a3a2fdc442fb72143a432ac97370dd8155468e5aac75c2add5609df778e19dcce28c2a37327c9b96784640245a09f5240a2f52c20540ad3d99e01b972d9546a55ceab826ea1d560a83b36ff728b7a2ffb8a0347ba44cf06b30501223a22428623a2329af2a0a68e38f0294df54cfb0e94aa3eb22524ea090b9c3cd4f02321bf70970715377ad80b9e10b642af8ed3e8500716c2c40dfdbee3e6574f86f9c06afe30f1c619637573b8e1e83b58d7f4d87bf5a4ea374f30c4ebcee76523363ed24be0df231dae4857bebb31ad7ec614cfe6eac8671eb027784810731a8d15efa07afa021609cde2466f94367e09927ffdf141f878ecc04072cade4aac1ab12e07daac9392d79358c1e3abf89acb9b889a39e10b5aa185dd33937178dcdd2d89975fe3839dbaafb0125a43c81104f8bc03df068f1f373dc26ebc6ca7d87db177703ef032e733e3e20743938af9950abc53f69c23692ef6c515bb9d2173d354fc6ccd171ce343ae6d31698ace294e24f8f35cf2fdbdca296711a1eb8c3210fd25bd0911682f644a7077902ae465bb9d2e8d854f7fe32c906bd95704715236513a9f66bddc19c336cb79dd427742cd2c8b156941d8e0f6cead5eb05ecf9438bac14946666b9045b331daa69c9a09ef1d738e821b0f972139b9ea865f42a90ef9540ec06eabbca30bf1faabeedc71db362da0e169e8f29b416d3796aafeca2743cdd65e467c25a6285561fa3ad2311b89ab2d2f3d5ca106256d0a8504770d9b5358ea04223ea3af4d9430a4a73faf349207117809909635e6648fd8bc8f325621162f20101a4980dd1f729923d8944a8f8c1c81efa899230993bed3da850c60f0e60a8a49d2840b797f412a187c63a700f6e4712d81a002c2a16f3a4a6495e7ddbeee4f4d489314308519d563c2f6dfb14ea11a9c37c604e4a729f78eb1d3e301770cc323a06e78b859b641c72502fede557556784aa78f85c4dd14a0318b721a167e791c68624cb46ffd4b0d841ea00f094ec9e88e234bdeb027995c496b4e684cbe5d9794398fc80df7c4d4636e29ccdb9de4ffbc7bc02f2b2d2a2b968ac039c978be505b644725ae2a142e3ea641266e3ffbe1e84af580bacce2aeb03e78b4a28100feb96512b495ad5151db4355bb6bff049bba3e573020d50acedead557ba81b372bce835da7846eb4dc9079af3cc6632e85615b4daf229d51770ba473b6d91d727dcbbe5d98c7d112a9c7630cbd92405e427698bc99dbdb7404269cf954eebd4220e7f398d806eff6657778d5b79002d0d85e12bc458f5df84aad6dfcfb9557fd9e1e679be30eca132ee6b032bf931130004b139ae2efa5b9439365b63c613017c41f3ef0c4d7949d7379f350a5bee1ea305c561aba8b55ffb86c7113b340b74d90cdb3cdb1761c37c0b184223072319be2e2d3e4d2eb2d5af6aaa99210d3cf4e89303bca447836f386a85141b05ed94bb842d1cce943c203307e84645c94243991e907fb53a7dfe630cf9c570ef9b7c599d66d1e23f8570e83403d1dc0901fd92b5fe785fd1c1fd1b5d4b43fd1c56ebfdb0a174ec3c0e8b8c67a6f36dd7699c5c09b62d30896e743bdd7976a6ea6b40f1b46fcdea8ad8d418617205aa3696ab87596bdae1502b4264194fc3a9b6165aac1ed52649df8f7b68a4b8b3f87813d86b9de2390ed2a157378274de041a6571a22dd466ba9184c0df302ca3b098ec930de7a91d887d3a904d591e67535d7d1a42c77bad963e2392519b9acce1f31c6a6ae35e080b86936cf52f1764f80e40a35c6f34ef12250ee577614aa366f5a6cec2cc6532c63172f99a3560b4674a776719ddf54da9bd62441d7acd46c3c155057a798e4717056c267250e41f938fc0e7d6d3e62eaf615e9f2058e0968fcaf8b9d3a970d36f64af7b3e090d07eed4bb49d62807aa07266a2a14d00ad1256c616300c242237afd539157c59950ae239099038796bba239bbefad97b8f25b3cfbcda3914cfc582cc1b75e9a376f4307f1eee7476c0559d13631b4c99e6d94593bf9c13fe82a28bc043e98b40cf96c9421842ea7465bd5fbbd30e4b8e00e970b509456bb7dfa12dce2a222ba2a928de2fc0677c80d6cf9e4214e577d13e41316d12f994136f63b70cbf1b78a02a96aaf1b193763f38b28f218f60da2958dec4f70d61e8bd598a7cf58d982989eeacab97647ce258d8758ecdcec657aff99ee92e3463e4e8759c974d89aec5633cd4ac4e6de8026648599f39f85b9039817dc22ebadc678f89a8a4e6084d4b6c36215543407d4a5e7d4d7b8f60ff45ee47837aeef2b4835d5fb9928d6b59921f0ce8443f714c2ad3e1275cd93f995a47f1e83ede4396490685d757a1d2e340d84e3496576692be8c58672387d93ed343b2fac6f62def063d76a153e8b4023def74f0ca4097bffba16cc3ca33891411ea7dd0ff9c99455348522cd3a7c6d958a07342b32c4fc69237147dae9df4f15b50f461d6e36b9adfd179815123a1f5f668f2f649fa6f3adb98bb82adb4a1aeb68ecfff64b5d05b7e35347e2279effc797321dfe52054f98f5bdc4a4ba8ab8044a015f7ccca07c1f0ae1736e28a3ce445d93e175e5e48b5a4d82f69a9f9fdf7a47631d197352c970f438ba21a77e81f8f438e9a0522cf6461717392fac441bb351162653cbcbd4ac9251e3313414dbc59f564efe8e6663e8e7e544c7953677528843f5c78d6839d5359de165ee57a61b8719c9591b05ade224b60cfa42b668a0a6eba96815f73eb143f3ee28a06c21908278b6bbf39265f0f2cfc56bb2bbd1a8edab7fdb5cbad7e896f7b712b274b0d57276708afa5932bf8dfe39a7f5af05bf8c46aaa77f191062155ff2054412ace11440bcd61c3d603a849f8a891a927a8e146ad753a4bc8b917af048918e620bb5310c7d4087730b14f4075b32e7b2e1086aa2133605ca17dd4921e728f54bf2f613548373a17a82f74db57ded5e4cf2180539abc76119fee888b07e782467a9bc3cc1d3e60821cbd1773e04da385ab430c9fa8f58c7d0e849742a399783a5d10747dc27ce56a725069908b8cae59a10d40eb195b36fa57ae4260987fdb9d27b6bc7784407d06df1ccdced5429a4c1a482b3c5cf71cfc041c1be716451c2dcefe206d7f04e4492d35afdc34c1913660c620c16c1abb9f26f5843c1c717568c237765f2f7ae9ad3e6fcdd224f03ce39d6b74e325de35246a4df4e5aca234a614a3fd166d42a3c743a3214d72e287d8083e9600563a7eaf6ee6034dc53341332c47de7ed968ff379a8f585c941455a86b93abaeab6425516bd0b37c63b7b17ec744584a42dbdb5b9a51a10100443f33d1dcd9f91f22fe85f4d84ec7393efce03db4933bc1bb91e9956cc1d2bafcf99c5eeb550065ef35ab87e4f755603d94884cbfbac842b5d6314716ffcdb507a0cddde9e6dcbef817fb09fa3c20cd6cd19c063fb3376b0bdd137a9a56a8660178f49c2e5d5cbb476bea7671323d72e4904e7229bd5cd6304ef65adbea00f8b399dad1c0711497d41301a148610f86c11c59f583162e27567a1cdfc8631d499a3084cbc4d84dea6427becf39d83d0cbf7ca291324358da47e5aa3b95d4d5a6f8cc4f683d3e3d3c6ca3c1e60e6254390934a45d2fbce4fca9b705254913d108f392a34c6c4049abd105567809916ac5ec3098ced5b3f93dee4529ba0b64c1cba4b4b7498be577e3d71e25f4a81afa6e6acfe5912dcec72caab64c39343c68e99d97648986951419d089ded3c5ba397497f072c68171e4d1c724c8418cf972a6730337b3aae09acfca84e7a8c4decb75e63312bcb575c405f25c7cb70b48f4bef2b8a6b8819ba5fc9c75c8fe11c5f83d27a1e64eab0518d2f26af6509352aa73e068ecf8c04dd38ffddcf7b9302bf2baee1aef771c76039cb276df3274ee5fe3ef9fa2e94b08d4e9c53f34fe0b75f12ae173b7f1f434e81a2bafad37966bce5549e08929df6776d9b88ddc344615bd374c891105f974a01bef84f732b80b4d569ecdcbeb1249dd54487f5b42048e17524ce2f1d1db6cf472d796ea561caf99f22ae93784a3769ecee4f7d7c9245bb2defb0afaed9a60f9da743cd0ecbac0990df91c393a5e06ac1b457ea88fa459b9d00d163b691da71a63d3177be9d0191c4fac95bfb91e60ef72aa78e76a9c26a34b4379673c65c87f1eee46ecfef09af53a355944c80bf69ee7e0dc22268eb6162cdc17ff99aab2a6b4478ea8cbdae17d297d225263348341305e7f46614b7dab6f6d47c2a0dbdc683295ba5fdc3ae869320454c5d7d2cba25780a98081dd606268c020dd77a36e0e5d97bafcac2eeb1fe8e295d2b7e1d470933f18ac55c9c465f58a13a440d9c7d2fdd4c146a4ff63284596a3cca710ad478fa75bb7c62afdf3eba644513e85c0de478d34b7ec6cca1e2c7fbd134b6fc1985dfde57ec78725492114fa77bc9c769a206d3b2e5c538b4a9d374122b46b85c52cf7e2275ffa91907cd52021e4e891ba9c53c0292f6f7a3b5fda319f8caf275f50cd93ac99120cc37323a1a9960911fe383f4314ee3a1908093731bc774961ed65fb75c31df05fdc4741e506fca79b3f7ec56f6e05f9d5c1df87d33f23e73629fc34aafed5f0d711dd5f18c7fc1f03bb5f8dff3e8ef819acb87f1aff87e1c4af7e7edda3fe0bfaf8ff79c7fa572fbf6e08fe057ec2df6e0ffeeae0d76eec2f1c93fdd29bfd6afa6be5fb177a287f5f07ffeae1efe5e4cfa8a60200fe4771f9abf9df6b809f2141fb93f9bf2b825fadff1e7d7fc60dfdcf1ffedfb158430503f3c765bcdb47e7ed37be64faf1eeff01504b0708abe3ca74d8190000d2240000504b01021400140008080800a1829e58abe3ca74d8190000d2240000060000000000000000000000000000000000422e786c7378504b05060000000001000100340000000c1a00000000', 'hex')), 9426, 1, 1, '2024-03-18 14:30:46', NULL, 0, NULL, NULL);
Date: 2025-09-24 09:51:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (18220, 54, 89417, 54, E'xlsx', 1, NULL, E'OI50533_test_reception_intervention_A3D467448_2023_12_12.xlsx', E'OI50533_test_reception_intervention_A3D467448_2023_12_12', '2023-12-12 14:43:29', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b03041400080808006e758c570000000000000000000000003d0000004f4935303533335f746573745f726563657074696f6e5f696e74657276656e74696f6e5f4133443436373434385f323032335f31325f31322e786c73789d997554945dd7ffe92e291164101089911ea44452622801914e416a84a1bb5bba1b94ee6e181a86ee4e0909e912e91ff8fcd67ad5f7bdef3f9e6bd635d79ab5aeef5e73f63e9f73f6d9fb8d34320a310206060682b96db00ac26f17d1ddad216a616e63686ea3f3d6116a68adc5e2f0113210dd67dec646f0da9deea8fa13eec9977cb0ee08bcfc35d335c2542a0176b3010596fb92a5c76bc6985c02c577a19cf67b0200b5e267661941243eb9c9453de1789288ef78f2761a9f5155c41da512b35b02ebec484df52913820b66ba449f974e742556329ea377a51bb71e48a6a007c574a1b61399b7273bb290bae0414064f3eccb10a4a4de6881ee5a272f3f565b2640cd6d85ad6ced993a666af8a7a2c2976cccf67e208f3d5099f22bed2f1ec443663633a9680511a544847814c780cb45288bb0d4cf878966e474427c65a06911ea067078163e038e546ba875afa8d33734dc479f725443708ab678672ecb301e7ecd6c79fe1278f8b57204fd2b4735428f31b90640a829c7236e8bbb43bd82ca0bdb2a33e415872fceb0320b2fa266de722f40fad64aef706b7ec5ea9cf7cbe50db009283ec9dc9e0a0d766ab35c200a4d4a85ceeff1aa9e5d853523be9146c70094c694ca222220bc44434078f38fd1c0bebb75ac0c21d6ac2cf7df4591ada6ed6c387e3a9d9b8b3cbbbac10a35711c9b1f83f710411a5232fa7dd3b3b1b0eb7e160d692c8a1d86a7aeb7e8a37682fe52300596d40c4fdb31af74e399f3690a875702857b4224ad9bd01549349a76b71ad774cc2cf3e8d69c74261a52646fc9faa9fa694fa4583fa2ced92d1ef468f5756dfa4ada1f99dc1f9d0b8ee5d1923927461e754bd4a0d9b6cd4791c5d35f0f3abae801923e1585848935637e2b3e8ec583e820bf56eb6e8a4780ed949fdb5942a838a76465b69a0d8d493f85ce334da0f4aee46972d6abb195276f5980a7c2d29131f988afd2b531b62aa8a65d91ee7d9313ec045bbd1bb914d2bff986e0ee36b078ffc6ca026acdaa0785de4f53d9d056acbb692ab6eff6ba1bb6f05d586c34da0b23754758f049e6dc8b61884839587029797cb59f2d2ca77ea0642584b141a8687e2a8458f24570e8fabb575453df9ff2c39444b11e10f1f7a73f66a8b1d20b35f2803c3c793665985d2e43edd84e97fda80dc41b14a7ab03085c1e0649b48444883f2ef8890a2eba205331c27d88be20a114ae5fbb447c7586e58677817c3f9c6517fbe988bb3f5b83f06fc379f0fb70de5b5819de8fe763f802b8838d405c276bad2925133bc8af3a8801db6bc58ba4b3213cf863d93975a09dabf358fdbb37fb912e46785125b394a7f1b00c7c6f2e2e3d54ba47e42613baf5892f2b2faf820da8b1323a8c71273b54cbcd98b66a2b01f88b7c27962de17421989af58927ec7c78040661ea3e340f9ef9b24e9a3d189bb0ffeae342422922b5450a12ff2246cc866d5d43de2395b7966f63e1a68902460acd1de94028d43d68173fe1bbe22f7d0a74c46907cb8ebd9549f295a66077a887d5e9c40ea173ba6bd198e447254a87d1a4f7467ac0f1e3c8cfe500dc712abba9203a66934163edf25873de8ce454419503333752b794220b16456a810ffe0ddb091a69c09f4ad6c798f72e947e0e6047b9a3a514f1df5c487c773b4058ad8df5ac0c0d946cac4ccc8dacefbd18f2b6cf7c8e8da0f10c88a1ed626a2ced96154e82f22988dcb8a805ca0243c1a92a5393948ecd0c3e09fbbe7f101653fee0c967832f12833b2c464671327b8bf9918f5b54f3a0c212dca260045fa6a77ba4272697a7c7c98b59698466940ff2c56b3e8fc547927fdb272fc726906738541e66d95ce4bdf66507fe7863e99c01fa6ca41d93577b2c51f1fe1dc557df05e4da7c8311288f21499ce458472fc8d2c41c0b3993ac70d8931781af04a8c722abdaaea3ffeeb577c318fb530e6584f334ac39c1597f84bcda491774c4013e73e798c794964f7e6c4cb67be1cf57954a58f361f98e1eb1603e3ac3dd898e80c2bec30b821237c774ac63b5f0c6fb58a145c538820717cc3ecd7d0f19faaa35f69f9d6c6b16a7b9f94cbb3cb6f515303a6fe7783a8975bdae5b81ac45cbbff17a04621712efdfb16e5339a05b42375ffd61d5fe816b1a3840dd19d840b49a4bb72c70c84145fd652cf95915dd11fb12e4329b31e95b4793de87fc7c9797716890eeebfe29e6b4e309039ec05502c080444d0641e35013337711d6a22a62fd0ce22d4be90f7e64946bcf29b9d30e52e499e3d1aeb11987ab56c0ba7be409d57db0bb3e1e5914dc05da0ee5df828dfbff836de30831fc15e55d75058b243602b7a592d2ab262493c4d7445f46990c6745cf46e5660b909f9599420c9299b64a9666b23dc57bc0eaf5221200fd4babb3737eeb0de4e403ab284b1b79e5d6ccf8e5affdf0804faacf649e1bfd9cdabd3a26d6114f6b13b1e085a929e43f200bd0f75351dfd01128095001d17626f4e779e828e671a4ebe5c66a4700c1916d6486f314e7371d7d18443c589d7c4946f542659ad8b8157b62dd5c828404725d64bcb5c084e1477284fb17b3736de8ce0a9b31640af16005e190522231bd438f3d4cf4c7ab44641d91d2bef1929b7e4857e3dd283db963f534c9ccc49c6dd106c116290e0628939d8aacef4598f89b933a5da93a66e84ba1a245939568ba14aba8ab8dea04db6892e96cf4ea4a74eb6c4286b77649ed56188ce0c70567c17622e30bf6afab0798b17ad4acf2f972994b52594eba8bbfa87042b07a66acb22c48be2593ecd250d1f1bb7196b34abc02bfe0710796335337bf72e88ae26e00c0233e2233d6853379861cb233b21e643060f1ca72c50339312bd5d79fb5664d7278cbb5752b62b50da084912a9b45872fc8eb71aab6ba3948e2129cd992ab939b5e8277d3d54a74045fcf78fa862e332d90152d6d4525964a999db6704f08edd443037b8bbd2d91bd7524aca7b9a68fb782a023cf1664a1fd7cb98543db93abbde4112f37e6ea4032104aa897c5bbb3c06e1403c600915c46e908852f2360a61f08ebd9e11d4f3e6325ad14a96946c5bf9ecebc7e9208cc33295c5e47b67cb494d02f83c9bac92817ccbfd951dccb7db2bc0273ddc41d7941f36154985e2e249e757f57d422a0fa01fb181edf0883fe55d7a541e7be077e910fe46bf319d30f7f130a610a14ca9395f1cfe704350c54e9a63fec692da0ef6fd3d2f1032785e92f928c45796c87036ffc94d2ec275f65e09bcc0bd3fb8100c3149fe336b2dddd2fceceda3736f834de70d5c08be0efd7ebe0bc252e7300df9e6ca78d1bd4b9434fda2406cd9db43e4d148921c39bce049f6fbce194dd7806e8e5a185e77e940305374844d7bfb287a61a80cce6ddeef882f6df10c1ff0f22f6165666fa161666bf96c2c80539247602df7dd74fb3e10e745a6ea86d2cc2ad064486982cda0ea2bd76a4e4d3b195242e7469ed0f2bb0d3bfd17724bd88e2dd48e2949d4b0983044e7e06c5b5c1b3d2fd1f048871b07c78058087d5e0ce6316cf52e4912a313eeceef5fd71381faf1c4490d24f9d51cfa0f204421fc394d1156b2a7e02463474c2d32da76374d64e3188c66ea4ad1c7727e3907544124868347ad28f97ae2b15825bb0e19265799004c925c84003cb967c5f8d66e1d225ac3c1e04fa87dc10add3a5072e9b056c8dc3b58b6943a1498eeeb4c29c079699f1481de6227a42451fc99210682756fae14c0624c1d5df8763b392379cfcbf6f7346789939ade5f3151f9515686cc95e781f5abb8f87b41bb33962e9e8c335ac1bcf6ddedbd7c8f73e42b6247c425e3759ffbe0860b6942ebc34b2c83b3b9bc06e70ab8aa3c8e281fb7cadf46279bd40867c82036f90d94e6b93d494d91934d771a88d240b48d7bea5d9bdf111c7538abc8ec368fa1525230f4a4593bb850c1df9dfa244fe9f28fd27cdfb3d56bf523ed8789f5c3b1b01eab04ed907f9e44c7c82fc395c91efa4bde8aa874f4313a7638d1c4ef6d99f7f8e300d7cdd636a10e2b2af36f0e18c1d6f0597f6749131f713214a7d57d2a22d96365e18b7fd93802a4ea7033c121efc86dd754cf4812df49957e1920f428955d7a1ac745ca412b2bef89ba3d9a796e3c9a96551c2dc120b5f0afbac98571dd164383b1719029c953c7936a7a9814f0a68138d42a5c45f63c91528b5348f5f54ef52b81c0c6c0784b256f649f174f7c55fe0b4e7209694fc941b986075db5e727d19f97a8dd5917ca28a4e1095b79f232ccf085e7814dfb9136f0ba848a6b44e8217de90d0d23fd4bffcb5dba3d873141cdc79c5e85f3700b2ff99ddd6c6868636d6acbf1eecf7ae4b79d767b5ca40bc30a4f26607ee0494ebb552d12e9652ae7f36d1635352e6fad1cc4b08b75b6e7d7b038930a2a12a1ec00aa94db6de43ae7538dc2a5a5ec3004f29be052574467b4c777f64fe4172bd6d787a99eca67e53cd23759a8f8fe0f7447bf31320d8a4245dd2026f984d208a194373466a82cd5ba92acca6c0e32365deb20239dc70bc547df89bbe06f79342d1745d9591ed3553e551e33ae8740957f289b14ce176557489dd51691183b8f1f4c5231e08ced7f95cbc37958648dd97d67d664a23fdeb5f7039df8ca444de7a084542a8f48ccc3dad4f1294da5e64bf6a233a62aa8fedeaee2a6e104aaec52d4d510d1181ac1e121cf7c67c958a60de51850f3c74bc40fe7e8d9801c6c2c1467d116976269b384b9a12e907ab5be232ae28c7accdecce1edb3cd38071f9b7660ef0c30308fbf7d776b75c62d70d5d12b48861b571b2ce3327c86a83eb6acb1e4aa31b83704535d61857493ddfb1e7b7b6798d71bddee38fbdeb936ff1f3d2e398bcdef206f57184f59da864f56ae7e3284a716c9b5da445d334e7eca1ccb3b7c762d3c98bcdc8bee6b68386cc059d3d6b25a791cf38afed271d19b172ee1e205e43efdf45c9e6f19f97ed59db88bfc49471c4537394b45b7ed2267c44039334328c2451738a303af4dfc038c695caa1de1a370b6eec188b7efe86438251227acd9fc3d1a719ccb21cb12c438c9f00b37784cc792e752db3fcd06a6fe8a7bcb55ae348092dc7886e9b620558b3e448193e89416644210f910ba678c56822b23f429e44555d9b6465ebffb60170d18286a25435ee2d5c7c2b9e0aa0322f2b2a22586da27fb4b325e67e2650535b2fa77f353d6da7c387d7d15833adfa621a4005eaadfa1c1f41c6e5b24f96637059bddd601164aefc71f17ab99ab9791522b54543ded54a160689385bddeb1533f8f95c97a489437b95b5d8a43c22856db1e75c912adf93fb1843df026f15ca6b7c6da5bb226fbb8f4cc531e8dae590ff68e3c8a63dc181f2133a58ea744703981a39f98c3169b271bc2bd13c8b0d6b8905797aa227c272731c216f3383f8128fb9da771c972512183937ba12da33068bb909162e13f01910bdf436e6b736c7b7958e8da5328df3f1b5793b420c74d48e4bc3997d15e4fcb37fbca9cbebc208e70cfa616e566e454ac9ce6f6ac343de361eeab2f9f813e1378b208af75a4ec5024dcb54ad473af798d684628bebdd2d6d6218ff05a61cf7987e7ba7a034c7867397b21d9cbb664a8d8d9e26422b5b42f8a76b43cae02926e393ed659c1a267acd6e56a36ba3c5f017a13587421fa56e4ea46289e5e500d69d93ba2920bee5658530ce61eb282998cccfb8b9a01a5ab7c8a60448b02b1488606050a2d5a612d0c98331ef825a0795c846904df42dab139a9d35fc8a854d5380f78d29c009a6178e9de7c8d7638037cb6f404a8a2918d255118fbe95590e8b2ab54ce13a2ede0f713c48ea7bbe2c20c2e083f6e3a4ee0d21d1e2592625968f0f6be139662227a893e439140d1ce11dcfc92e51e747c11777e0ec6d6c5552d2e885a44898b4e2f1c238d0660ab735886991a28f4335407199bec211dfaa8ee6ddb287f183967906956ba3ba9347ebcf1f864dec0bf0341e207e66f6ac70dceade574958ce7fc0eba2d8c1f0721da2d4776923baac4b865b3dcc655c891a72836a33ee453871a34b802f016f28bd6686dceae82e55952ab8109b537bf3612b0f0ea27cb2d11ff0531b8abf3aef64b4cc29c7dacaef0ea23de41348453173b733e3b8aee8d9518bf248ae4ebd2cda7073fd30cccb397becd2f27467b7ce6df1039c7be4988ef0cce5db641da4371bfca1fd7931b53f65b7bd733f5ebccf32a042f4c508a0e2b335f7c4511739e4b28df7bbc877d8d6c14a704b6313ec8cd7582fcb32a465de3dc77aa03a9f3e450affe9db0556c976df3a2ae56379f45593e90c41aa9315a53c8f6525615f50ce24cc0645c583c49801efa70256a7da8fda83f71ee4b94f6adead442d6512093a83e91407e9852bcc7d61a1cf73afdf2a3b7acc50610ca1adce04614868b58d14100e6eceeef9449e48f3c1d7b3c755e37e169b4a932c3f281162b59cc82a68a99b8b19a6da759475a1383479f9eaf4815297afe2074e651141500dee24f965dd9e6bfe6a1bbac91192059dd348bf7125e8f481b15879d59b37b35d4f9755c459a5237fb2d35a2b96b307b99ae675f4afcf8bea103196f954cf4abae50511da7ffbb8d8369e6661fdb0fa536ed44800475d529c4acf18a858fafcb62f2a126f0ed4bf522f7cc381cb1af6f5aa3d6edb2283e7bbf821c59280e7b1853f9d267643f438c3694dea22b1c4498a3eb628edd005e5c0118980f66c48fa9490616742d1864d553642b5d13577b12b6d5633c23d7d138087193c77f4bdc3fc2fe8e3bca72f265ad622838dc06fff12f87ce9a137320ad36753e5d70bede00953c1413c9ed68f2ddd769137579449ba869e7dda2def171db5c304b21dae76e436db6248cb592d897dc80e9b624336c3e86e4eadcfb8dac326e2569826fccd79b9314e602c9666fd074201c51a8bec94dd9e6707df9e28c3717cbe4b9e7ce631d354b4a701e1288db28face61b8bc19dcd028805a37f323a390cb2e761e55c33ff545e0a89a85a943ed7f3b6900d1405d261ef0eaa35338e1f20f3a7f5e33bba7e5b9926cf65c2d45464969f1550a0879491d9ee8cc1ce34935210f2148c42155c27c5eddcc5decf9a7ce74303e1a54392e68d69fd17794e0479469e7557ab01b2c7cbba6b412addd89c854cd18d348653e257f16d9313760728725014e241ac42908c4ebeb1527810ea0268c82cb1c30c834dc061b535899db15efe93916e0935a74c70c4c22e4fa52c28f6558a47812b47a004028cfb0b27514942d25340144f8fe0691667ef27838626d43c78765f32d44f2bc2607bba086e1ec77b8ed3103d0ca54c728454f7077e9826c1d482af039258add7afab68028d54ada686cc7f66672e579571bbebaab70f98efd8ed697b1836cbc7894d351a81250564bbaff9d764a94f3a5a42aff8952446cc2ae3d0d47127095b3ac5d03101bde2c3b9cc579e2ed015f4d5b7647965cc0bd3ddcbb166ce03b79bf9cdf7f3e6a0058df2e82e29a540fd2fe60de8d7415b45d67a8c8d00760c04d513b977d8cdc940b2a5368713386c3eb7a8857007e63e7f2425a7ee2600745f4e94f98243eff798d0e4f4c7ee18589df158e5ccf789f3b01f306154774509c9aac88aa586f1dac1faf028baa957bb1f1fbc9440e9411710f72c8bdfac2f6123e1140febc3b37c94405a8a2cec0f650535a98c5ca58d764c3e0f2fdc564882a51307acb53d6c1003fd64c143ed334cd9da2f4acad2781ef77f96d5dcd4c8dad3dce090cf0bc3a18b1202bc8af69a8b964b317e9fe01b6d5e7981164958d00b9c9ea6c3f044a4014fcf1e096866e8802d62aaf2a1abb66f093cbc73b35f727c3f15f1db95fbfa5a60c94cd66aba143c7df6fd00eda79d7fbe17992175ab3aa6927b9457038e9262e9e5c51969300c4a545a8f049e8c69ad4d7334b74fe99946f7fcd4e61329fa3e6d050bd592b08bd95694bc3a73d95a52de2dfc228a478ac65d86ffa349ced017815d93a167633f8d8a14a4c905fc4f0ae97123a58681a7896b93d265fab186d64578620d62ba62533cf0e8afe6b8965864f0cf8e69be87f373fc1ba4153f71fb8fb8d90a72d801a6dba872ce9e635d8ce43c29a127d7e4e52f9130c5bfa7fabc24f427a8f1a65da22cfca05cafa5c52a4d2f604ab68ab83a2379f140323eb892aa15e5fd21dc412eb420ccd9d572351a27a50b49a3bf0781f354e2eeb945c0493aad3fe8170f7d3a4c0119af772c8ad9350b6357dd2a6d628e0c2289ac3bbc212b14e61888d9c2f9fe03fbc276e1c2a127999fe65962a2419907d171154b6990433586cb556d3f64510529c095e150b3a8eca53679265098b3000a38a8d2f78abc725b05339b2710b69b9a536976f6ae1737a97819460fc28a1728ae3d07cc56c6254e02ca7530b4bb2abe516186fa79b53733f1c00d2f3b50e03a8f390d8a98b6f03029f1ab1499e7e780e11a0d14bd24bafd03a13df617b6b48d29878e207e7bce2e334fcc2f78d8ad6b5a35b39fab46a9121503fccb6ca2debe36b1a8b5cdce8a7cb73a608a58425d6e84c4b420ace894b5562d125450dfd822cc411b21cd6cce6eebb09bbb94ce50edeb56f3e55a3136c615b27f4c6a30d83ca4358cefe31dec17df03773c073aaa8b0dbcbb49cbc939ae0c4e243a119497df3021197877eb922a8eb6ba38a4e1d07712fb9eda6cb1e167716af257ba6a05073a93a9f695e6767497a5073f698a15a237d7d9dfd4b0b3169538879fde1295efdf03ab6e5ff9d9ec6ea157c7f92f80e5fa05ecbbdf81ed1a96d9918b1afec269b859893a68da282566d82369357ab4ad365366299b5d29232f631d90b530313636669ab575a845dd4d5ab90cce06919d477b68e627f7d9829b35d39a5ce5c32ab8c752466b3e20eb627649478d86547deb38eeb74246e5a455f6121b026f79a9ed7caf3202e33e2f412769c376153cc4eaa21bc8e66515aac70cf45306cbb7f5d0dc015bf4bed96a3a413ba936cf22bade36a5e265d62b9a6819a4ba6626d41ac690c726f7c016575e60de036bad3ac38be149d4115d9af54da3b6c59211a63099df76bead268cc01721ebd8b26d2b76b11bfbd504b6882d6ba55a069e96aebac4708109bf6b2533a16e51c454ba8df2e2f765649cd6ba8621be975f402a2cf6883434842e5abcac499a34d88109892b88f5149749d48ab6f260c29d37d140f3de7e438821eede171996911d37042f66dbc5873c29ed4b25328cafe8a71cf0c905d1415b42de06c4363230f1792720697f39247f22d4981e6570939c9e21d012d8112d99277cfc027b491e5644d118962040fde1c627be73951d60b58d214ed99afb88f8040df7fc5ac0c0edc953b25267d01a22ef3c795c6bd93edebb0ae0c7775373a38a61141da5fe0ea0cf776fc8a0cde377a0881ef9431771a79d612f73931eaacfec195378fba2f4c19ff36a3d893fb657ab46e901a96473e526edf314ef4ece00adf73ce28d431b3b2f24fbc3eadd06baa2d4beae0e6156d417a21038ebe8cfb2945d243ff2f90524e541c63d90e6df981e0162087326e6171bbcc265b5ce0b51fa18529c3e36705e08244df52ba57920f7df8838bc4aedbf0d848ed23f6e62587e5cb30b247adcbcc96990c7b465158ea7e59c4fbab7c3db5db570b285c5b6eed4be6674fd85ba49e750ea25af25b06bcd4824774186cd716eef8571d189b29209db94748da472f48f440da344a00997b62669696f1433d19bad174fb336c0c5c0cadaf42e6c9b48ccc094ca787dd3b3566177114508ae56f5976b993b1e8df76db039b89bc658361febc98f10c4b8e4f6056d828292deba4d6c59a6ac5b5a7b69db3a69e6bc7ea97675c6878bd325203f7510b8c50517997c497f38c3e7e47fea9675001e2df69f3a445b826b497cf5ae084d17e3b6ffb820aef5e3fd82738eb39fd17ff22eed607d15a93b1cebb0ef7144442246f81f207f6fea1121fc7dfd1f6dd5bf0dfcdef9c2fe431c8af84727f06fe1ef3d26823f84f948ffbb4df6b7faf7f6ca833fd48ec8ff4757ea6ff9ef057be23fe48d28ff7747e66f0bbfd73371ffb09087f65799ff6fe9ef4536fc3fa4fd98ffabfcf9b7f8f74a13f91f622bec7fabcafd6de7f7a330d99feec7f9e72ad5df567e4fe9ffb4a240f0cf87e8bfadfc9ee0fd696588e89f0f037f5bf97dd7f9d30a3ae93fa7867f5bf91d963fadd43efae7fdea8d342adafd3bb8771f953bb504e5fdafff07504b07081902cb16611c0000b4200000504b010214001400080808006e758c571902cb16611c0000b42000003d00000000000000000000000000000000004f4935303533335f746573745f726563657074696f6e5f696e74657276656e74696f6e5f4133443436373434385f323032335f31325f31322e786c7378504b050600000000010001006b000000cc1c00000000', 'hex')), 8372, 1, 1, '2023-12-12 14:43:29', NULL, 0, NULL, NULL);
Date: 2025-09-24 09:51:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
INSERT INTO ged_document (document_num_id, user_num_id, node_num_id, user_num_id_uploader, extension_code, project_num_id, document_num_id_version, document_name, document_tittle, document_date_creation, document_num_version, document_comment_version, document_comment_upload, document_content, document_size, document_b_valid, document_compression, file_last_modification_date, del_action_num_id, document_statut, document_content_to_remove, document_param) VALUES (18267, 82, 91822, 82, E'xlsx', 40, NULL, E'Fichier_GED2.xlsx', E'Fichier_GED2', '2024-03-11 14:16:56', E'1', NULL, NULL, lo_from_bytea(0, decode(E'504b03041400080808001b726b5800000000000000000000000011000000466963686965725f474544322e786c7378ed5a65505ccbba1ddc1d82bb4bb004770d0341820577b70166707749080e6170273804d7e0ee04081a2cb884e0121e39574e4e6eeeeff7aade5953b567cf4c7ddd53bdd7eaf5f5d7ada200078f0f4004200300006a4021fa9e87150c0080810000e001906175a5400e10730788a1ba87a339589fddddde8e2a071e96290b000bf81bffaf519a30e4d0c9892d7391788d155baf61b29d53cc02fb4a34e9b1ea0e52c379b0d625fd98f8ead11e5151310b02f55cb7bc30786ca49b2f77601e6a828053ebc643aa09a7e91f6f60cd57f1a96f3fbfc51221ce519ee828cb82549c97d8d030ca2215a095e710c6631bd109b7c5a45b09cb4af9213fbdf7192bd352af0096247b37d9e58191635fbe1bfc1bf9dda773eea7f0515a242c19b33b5f6780f041a5ee8b8f5c4ba111d8af9302e3d4da9c77b1f217718aa7536c2b3fc280e2307abd509646effdf557744914a75123df859fb2d85577cc86fa5d355c9efabe207fb4e3b4932aaba062c06e0f150fa10e5499838de1d1306065ad59b811fd30d6d3ff8dbba532f6f0aefa188732a18defd85b6445324900567a9ee88342b4c82b0ada7a9a40cfc2b7714e4e70edb55857725b16243e1f12b2900b958d2963cb9bd181c834d69728c015e31bea82d37411d7ed9332f1f4c124053ad0582fc8dcf3b3f0fd70efcac318dfdfc30154fe22503c833673d80781ae3ce80fed41a086cee676600ef61fd7bf85f9377ea0344e51018e0b3bf428f09e7ab85568818566d28e43665bd1ec0e862be5ce882f2526afe9ee425602925d47e19956e196e1917266519deb9e8bede58a9b248312986631d5acd9a970d7d0808413ef2c1bb52fd719406357bc5772f6248a65337bee4c34b2742d27989dfede9fc8e599664fa048a39e35bf56a23391cea93c5631bd5ee22679e80a89cac8d39e51396421305c8ee865cb550b2f9f6285f5902768209f9635a6407a3446fb32e693e4ee379e1ccdec7cba8e4adfc19df0c11b1a53380a469dbbcced23db09555559fa10285cfa97ab7d7e849a963c19309edf628aacf716670b3756a19603c740ce05579588e9e8cb313edcd1e5ea6bc0ef24534c414b93080700c0a30000580fdfb8db71b8819c6d4d4020db1f7e56aaa10fcae5c7f731b4be875b4b0f44c1165794f5b661adcd6589b777cb64214c3322e0b44d65d0e0b9f7a9a0ce3b30ab1d74ad93bff3f0f13e6cdd820e71dc14cc64a01026d4a291eb6b35c9ce0726d62cb19faecc36aeee41631a1e3b8de8548f1b868fb7b3f9dd6d3af75d4ed19a2a93006a4cb25faaba665b47e6d0603c222ca57dbc6f4704aa0c665e81e6acc327e7d048f3d65aeb2659f2beadbb0ec73e0173ce5948a1c555e780e4589f612bd9b005b415593132d414f0239577dcbe3b7a1dc8432e2e3c091d4c86519f85d2b4ccd7bd5eef23595ca67db900bef4388e66b3dadf6198136c2cce46b00cb4df40104fa5ddc1bb8f35a739a586bf99224a0bdb789b26ac96d845cb7ae81397e8d67db2fc21e66cca0a398fc78a3ef8b30fee8888f3fbb3cdcdd0990d8784f2d0e6435607f5021bfd92aa186d203d33e1355981dd3351b6e3b6575e3a5de522f5fbe27cc9cf04569ccbe84817679d3124333e67730b7354ea9ba37486db00dd5fd103b55825c290da7d35c170aeaa5c2a0d75347e6709784c6ce38497a88fd9256f991caa4a6b32664de1435804a8a4aa265af4c251c1935cf36f9af6a8784b7b6ab5b995744f54d4b5905b42628dc8c388de81b1e4b3d52422dc72ddae7b0b7b4e29f1dfa011f0e2adf15ef3bef17b4dddd0df05eca98fb3e56c93af08d8e4bb45f740384b08ab6e0fecbec2aab0c645a8c21b8b1a96b7ebaa5aea3fbe63e3ac7e5a19cff4d54e2caa2d8870110d2dd44b9bbc268793b009ae93ff5353c78d3592b6b1f250fd8d61595766f63525d4faa8f944bd35d22d61bf3bb5785a7d6165aace4c083bfde8eaf3e8d053be188ca9a54a2f6505ed00a091405fed0af292a63871639b4ef0c98be947d72562df9e106e66185f595bf003859face1378626e7f97e66985894d8111ff0eeb376f70f5818b73d50792a10e02c7e3c59d2a71d42d82bacee765c828bb193fa86a0813d4b4e9d8f08715b45c28ca32244cf4012eb3a4f1c4b40f3693d6c5f65758a2dbfaf1169db93f751ddc083e1744beb47cd2c12bb70b8df29c7b65518564fcd55d9b2a936a0eb6b286d96acd5115500e6284c98b10b33d3d9e832621588730229262a1bed1b913ec729ef2fa32fa0660edf65351bdbaf3668bfa47659079a632194db78bd0d2b1ec12ae9eb196970ec9f0a2b467bf96e7078f5b49dd817eec8d6b9c0c9d7adc0f8e4ccc2075c70e052e7db3036c6f3c661eda9e08aa84e598ed8ec27ca29822f6288d364b8e5f312055fe8e2377f6f7a01a209c9df1eee9a1ebc8d04800cf3a0e07ff8decf3afe9707c23c7820ccffe6fcfb7f01a5aa8a0add9cd8ad68dfc338dd525d09703e413868f635f6b090076a981718a89ff89eae90b234e96bcd2870c081423d8e46fa5c2f7830d7e0f0ce3a588b2271e13df1ec8e84104023df46e0904d0eca28029f21e0e1eeefee951ca06142c1788da271fd6c19f8fc5f2e99e889c3720b68a44f1b27439fda8c72ba70db80c7c90715b597876a36fcaf83d5f6cb026beaeba9a0cc169bf78d520be78899811e9413df885180c2181e8089ed696ad6cb0e9973e493965b0b458f51db8edc6bf44db212058a621e11ef50085558ff334a3fe638f0664e4ab3c6d12a44f26690b97de1846de8f4c86263a0efe3ef29031e506e9d7ca00bf3c3428608f0ef491f6c656e0e0173fcf1c6f5833569f10aaf1638f1432e42be23e5b63e6ee71e20129262a086b8e64ff5e9245598e288e8013d5e5caf781dc4e4c52812554ab4c5b581a3217a6d6489e8e746e99c4d3440fc78c053bea8f1d4c8dbcb364c4b3ac78c9d50606e360da3e386f9f72b350f4ed73d4100259544732464f90221ff8d5bd6db57cfb1482c754c09be5d5af34d9f3dd27ae2a01a57e0742b4d80074d4309f109369ed774d4226e53cbba233691e08ebe6b563a3d9454bbc54933716dde9372508f0ed7915b55a64d808f240491dab395d05f8b3208ac774cacc5afa5ea9bf55ea7c7e12e3e7440499d92e1d5567fff3c9379fde564eb7d182750e9f17e8f63009ffa755552dc4062e2b2d1272463e597738e7a75731105347e33d6274d83274022cb29fe61cbf774698f93886a762075830c155734baf7f4dfaa71dcbb824a3e48eac6caa8b2a94a6e6dbecdcc84c53c6c77faac7d8789db80342d27c7d9fd9ed74288cdbb4bf5b5341f3b51f86bafaa307ab90823c8ae6f268f2c8ca7c6dbe4faaf32f62288d72518365f8cac3738262e31e9bff65967990bedb4a7741162a78e9af2443bd7889a155a29b13a9249bd1a912616bc42faf194ff78d4d5cca3728a8f9d806cc09af7cc831c2f99aa35b8d55599d8e5865911ab4bfdf751a5e2bbcd4a12e493a7d736a65b7075e9e1444ce98552cd62549f6509abe411f573bc7f5239c1f1fefd8432a24916d071fdb51c2766d12387346aa8d33572322ce0df3da9474ba0fe58e254704b3b5a9bc8482bbeaf9c8c6a9aaa9516b28fb4c78bcbd2f744026d034b990916876f2f90be8c39d2a209cbe9264405a18229f178b5b12bcdb3110f6a510ed33ec87855ec05e00fa21f245bc03b97dd01d48f7d9310d51cd3cd5b83ebca3547fb597bbbb520564772dd5a3316ad62f5afab0e043e40f04904e4f36d81b06c524bf4ccaf7230e8705a3239f81b0f61b6793d5e99af074c19267d3ebd47bd1e3fff829f4348f95b1de437a1306a3d8c5d1fd58f05fd1f3a805899db9bffe3fa8704f6b5755f91f2e1fb729c8aa17f3bbce45d1fc265bc84da5737a36833d247ebe89e339510130397a35002e284cff255e4140c517d6cb3131049acb61528afd56051ecaf693df388bdf26ad3f60af2cc672bdd378ec8c8d3c1a73bc31357afdc4c76c98dd99115747caff4062e1cb94d4ce39eeb7e8f5acd1a3f16a17ec12d9b40dfb0c95179cc61707999fbcd4a4196bf97a29fd104adf6566ef0936615932ce7eb6e01de2e945b5e6361595c8aab1afe2fdb44a7bd355acc89363d44b1dd17b8f841f3c6a77d5859fbbb6692b273ed95d3cb859c32342124442fda2a20ebcfbb3fbcc11a42a57e94a3d0e8166c351416d1bbef1e7e24b7922b277799bd997c9a69d8e2d8165ec74dcdc2d74fe20c77973c600ebbde159911af8ca5198f2841343dcf7a4722be29586e78347b5d9b288a219e8b53fab4b66746bb0212846eeb3f5981b9d4ea59a153771cfa7d173a72a0e2c3d682987f1dc4736b348ec0a1e38e21ff75954474ffa990886e3b62fee53c499b81cd456053be61108d7c5c170f84b954a379e86339159e6c7dfab10511fa6ee2738f3781765ae6c950934edc46e6591348ea5718007e0c0d105799ddc23d5036a6575f7a00867119334536c6fd4902274c57bebcb54a71a7df19ca291ff98b9a9058eab27d5885eef998ea3e3c5a258bea4d43c4b236188ff38d81a99be8cce5fbb39d2024e5a3fbb491320d6de705a614a83347dbfdc91148ecdbf7ebcd6642ac76f942d1084286ef57ca9962f70717c9efc208b6caddcfcf72b7a229456ebebc12f3f3de1e5ffeb2fd21180bf83aa43e2cba758f2d144170bf0fe976842e148726093e52bc5ecac550f6912328a0086db6a30e0de46c444c783c795b67bee7dbbd15c76fd186dbf3c831996bde7871c79fd586bdababcb83db4579748be15050f2597963335315ec62e698bf418482395f6752ca2c933c1d740d5e41f9ae1793cbb5f4f0117592a1db40f8930e86c96699164c1aa564f4818044b9c671de086a76b4e4006c9b21be66be56ccdc728d8be3d8a860fb80a2ae4bea8224528eec46e92a854dec9e69c825665cec50ff1d02654a435b0cf60e73c1f05e7415367b4a09d98c2dfc1d2ae76ba1fd6608ce821cfb40b6c216a6c9b0f4f99c319fe4d761eb27401abc9b08fe607c99651e06fd637d8b23ec337427f1815ec715ba39d48b9288cf883125d6aa1954bbc9020fe934aec5b9afde384a277b92f5b73993595ec6d1fdede1424d9b23a3e7135c24a6fb4b97ddc61261236c995bb2866ffc35eaaa58abd869855e7e0407229c43f4df2bc50a496b31374717da058934bfc2eb7e2f0e7c7dc930e285edc2eab29a0056ddd110147c1ae005bf2bd64f58a8568e3a6e4ce7e6173f638b533dca7ec6b678d5f459f3d6c032baa3ade5aee006d7ec98740850d55e070a0dd7c1db407922ad62d4b0fd48baf4788b6657efa309b870b17bb9c683288bb37a37fd2d5d059baf5282c86abbda7903da5b3526f7c5c895fce94fd2cc0b8ca8698a0df746da5352df364842e3cdd2df8f1643df17f7deafbce4493d3fd17e0cd61c4afbc85d5e5f71a13ab4b189a6ceeb91fcecc27b2dea71264a36c4909d6919a7698ff6739485b0bfc4d29b4991010d34c7471db3a51d66ab0564d6c4d14fae9863277c832dc64958f62cb6d4cd8a0b3b53b960c869454abdde5d063b2cb941fb9aedd25c0587cc3f7e7caecf1433dca7b06a43d6a4ce2d33bbeb71e1906f702155d834d4f4547ca02d02a7d7ac0e47230ce76c934a7ad55c763b313d9240318c0023df97b8d81cff6539604af345c04b072c83695d5fa23c7233ab5e090f514d27f9d481a1ede2cf6936797c02f1506200fd3937dc891c5f62196972a16672c1bcadf43c77a71cdf02322d06ad3bce68f5945d63a64569aa87dce36f09ac49cdd47cb9cbee94559a74ce81a45626dc088a2deb498625a18e65dc92ef93c402de70794759c60849b6ba500b867825c76eec84fa915aa438517bc949bfebe2d9c9b3c3c68b687c065c3cf978f2f29338de08f57c9d3302f26a104f394acd49363192447dd06b463ce1388bb9289ccd9d531c22d14dd4ad0a9ddb830ef9b811eac59b89cb39a12cb02fb94464c859b5f3e7b7c80dfc4c85cb64780d28ba38da197e8c9805af5d474a98d2a576f873de239b334602bf30ebc56f0f92ddd59c047c4d2823266b3aec0c7a2768b47235ed73f6a24cd832c6c2d742a7344749912fa5ad5d6ab992454cfa7189eaeeccd134cd56d397b83daa17e985ddac4a4bb3fcd8e85327036c53093d7b4f4bf985486b15857a023f1c4bdb07ad685a064fe181bc4e8216074a3590baabcba7232a8e864774ed5d1d49fb73912ec2c02c2198f48bda607819434fb8944944bb5821ee129cd554beadbccd95c7210759ba28cd21aab4fb8481362a2c4f3b5d6bc731bb6c1a2993145a953629c8d8b823878c3d0dc5fc59d19bfa1d0ece2ee7477c5a5af205f84c9c627758af7278f55616935967467c3c318e303e8eb41ce150a537d70e6669dbbbda8458d48a30c1b72ae58eefcf08861894e91e61782e554e902d7e6ba5c5c09cffe8a0b2c7875aeb5caf8b6c436fee9bab5d8494282f54544f7a97e5c3c16a6ab4c9ec63d606b8b06966bf85fb9d117b64fbdbe53de416aa880000c63f8c180cf1b03307ffb0e03c0d7bdb054eecefa2737ed8d78783aeeb6c28754393d32adbbd59e4fb252643114506afe92c477bbfdf28b91a9009d64df846286d4d81c796c0aa93a94aa835a6bdce65dc64fa21445c1abb91258aa1eda2041de8b47b45c545e391e6ee636c6d032bed0a650b68e70de6c3d4fe2abc5dba5b5004eaba456ee041a2c3db408e5ade38c13928465594714df5f7187c3acc2ee6d80456612a36b32b31aa38e8561d8afc63d2dd4b28dae1b9c823d96abd4550022fe4b1bf0da1a2554493958dc9748a69dcf20d4df446fe84e6ec21aa6344b9ad41753264cb4cc9ca43167663965a060565fdd5bcd037f93c142ebbbe566f7e65dbb234997c874438ae802250c79af6ce51f171660b387c50ed06eea008a01c0ccc48d2b10a2293434adf138994e7955e54ed980dbda984cab39f07099dbf3138904adb18f73aa2cbe833ae720c47733221f082fddcaf1633c6958b3a9715745703a26a0d04921a5d37f84983d0979e39710b8a5f077b34cd14040e885eac6f0faa75d8204963acd8dded42e0da6d0fc88a320b090a49cb8a8ef3d1a918e1069953b0a37dafdb3f12cee947a9b3a2ed1c96a077899c28f24355fa3bc88e43a3fa287331e640a132fa3e1158e1b4f38479ca3bb1b3425d99772e049c0248c8350e8d8e7a77019c469a4b8d08d92f3f5c95ccf26d252008bea882d6758aa48b5a5cdaf9991080ccbd23af3bdde6cfb0894517b00cde59ed822b4745b48838b45ed8ba87fa2d3f161b7ee9264336dcb9c9f656ef3ddd5bc6218d98e70ec9251a5c58ebc7e7b3db30ee5d67472b25c221af6a2b612950c04ce72a6beb9f9257272cb256c698c629c0997d53c7a6b821124ee4b21d66f2961d769ee9f032b83d253b661ec9f803e15e27839634742f9e0af36778573bea71777c7c51922b69ca110ebfd08e2ff1463ee65ba6c477d2dfd179bbc8d962e1e18ef061a98dff4f3a5b193b9b9ba9419cad1d2cff60b5b4b282521727f612ad53d8c4fe3b294264ea05fd9a047234754ca3356b536662a431f809daaa230c672ebd2c49cfc996c28bd8de72d1300ad122b9c1fd63d7092aec7a0106517eef257bd0218e345cdfb82543d8335cbdab3d56d61c9566364ca18f5f3b88ac854802d94ee4f4d27dd8a5c659863afab598a477c221db23d5d687c3d8b8b4351e262e0dd26ff95b956bdaac40f41e25be17b7b07bc33a5fd494b119c7d7b5403db73ca38c22533e36cdd20826460119f081364050fca0b20e3b8cedb42e78f96e69f9fb590605df7dd2bbe82bd06f936cd0382d09f061209c1ef48d034086310399aa38831cc11ca62067f37fee99fd5d967840429ca17227277ecf8ae22da6c24afd2116897e1d0efc04121783d1d3369e030492fa3aeb922010a8be232d809072017c58b1b5f894f4a878f206d1be015f203210db83aac84ccfcef9b4097ac3d7ff240959569e99ea9917a7959e9e81997abeba8dfb846a401dd9eb2db9ce3cf54d2bdb32792e5e081a0157001899b13cbf3cdce5596b47e4b872350c59d82a4ff9075c59b60e8cf1972238e431afcfe5cef2871e7d600ac565c19ef9cc147e5c311b583efc294093989fd5e162d045b09bbc9af8a07bb9f5490bdf8c0bf93490b46b33faf866cdfa93e659a395ab0c0c01712ef347f1d2e99e53a76a3d258a8ca3d694693df1502493f7fd7144cd8e42866023b79b27dfd5a2d7eb5d9a9ef97bb01bcd7f1460010d40eaa0b93498ebb194bdbe09a5392f3c090a80b713d2974f56e00fd98ba562eeb19fd5c3ade1a8985d6ec4e38b017ec7bfe3848cd5840772d13f380ff6cffc337674fc9b7e7f222d4e11b4c0891e7a04774e89be442ab0a4821e509a23f7f2b4d21826ed7c741042f33c093e822beeee7ae2c11017949abf2a7050c6aa5ff48d128814d80555743bbf88846d45893a6b966fb1cb74680ba7c1bb44d43bd68ac0b370aa10f35549c5a761a87e8b9674dc88eb95d310c79d2ae21a4398769e662db5eb3fa728443c3f43e28dfe653c9bd14337c90d373ab8ade30b83017c4f5ec3ee8e9f4caa1162db6d93880ce2cc2eb5ac2506f6bdaa5f3d4308990e4b1b058620fd16b007c20395aa864ce6c7815f7e44242bd7d6aaffcccd7245a13286dc35ce6ba436535ca8111d2ac9527dd763da4cd0436a46e6c8322155fd39a22ab47a80d89ef009fd5d30d21ed9586d472029148ed67935816ce42ab5d15e6c6f53eb43afcb2a15278cd31a898b6d44ea9d155fcc36e5c690c0553fa7d398566106b8edebdee20ed681cb36cd657cb9d47395e9606124fab1176723d79957f40e5db4d819cfbcc9d5cf2870795b128750d961ce86a7141db0b58f3a8e2a05666fd38930d75c9a3c5b5b741332e597cfd80a366e7cf67e5fb61b1ef9b0d6f5c0d3857f9c3ff8692675014340f67f93f94fd424fc5cb9ec8d63d37696e37e6ec039ce2c15bf93934aa5301b419d14959f472e7fef95d82689bad460e6d1b8b62d94dc45bce2678d3980e26958ef10b84d2e81c23f353f7fc0b06dfebe13955ed4caf22cdb8553a2e2f3c4dde941ea57f08aeb781889372e7d5a66960ff2129362eb27a9dc3b7dbde68677f36d13d46feed8ed4b8a792bad46aa60085565e532a0b958f641cd62cedb85cbdbf8a1f2f333693bb77d23b6844e85eb866b15c08fc1f34ae3b3216f391e05220f27f590a9495a36f4a34644d0048fcc796b08b3b567e709895930393545cc64ce448f2db8350577692625692680879ded39b7128c343ee1e219e721c81230d5e90bea537ce8bd5736866c8bde8c2b4bf9053b79a6f4ed80eaeef3864355cba9d920feacf2b2447dc1c6507b264a14eeb5d329c5a22b955d46e49bf3eb9a3d4ae6830345f11e95f10b2ec197f5fa3e72062dcb129352e8f0d3ec8bf0fc946961821fd6cfcc35dee595e7f5b06ce1826de934ebd6b4d43db289b36bd87a149ff76733503c0ff7394f8e52d5ed4143998bd133627f12a55006cf9bc32d38e6ac1db9cfc06b1282691be3b127c936a84d3efad8d53acacfa4205933c317e95fdc87817d0cf86fa76f7ec56fcee2fcdac05f4f07fc8cec076bf8e9acc0af81bfee91fe8969c4ffd831fd35f8afdb333f2309f58fe0ffb259f36b3bbfd6ecffc400fa7fafe0ffdacaaf15cf3f3181f5dbfae7af0dfcba52fb133a84bfacdb7e0dfd352bfe13cc24bfcf917f6de1afa9e4cfe07dc8c3ff23b1fc35fcaf99c0cfa823ff29fc9f79c1afd17f9d7d7f863fd5cf9dff7b2e56514040fcf133dac3abe3e11f7bd3fef8f43f504b0708f259b039581b000053260000504b010214001400080808001b726b58f259b039581b000053260000110000000000000000000000000000000000466963686965725f474544322e786c7378504b050600000000010001003f000000971b00000000', 'hex')), 9811, 1, 1, '2024-02-13 15:50:49', NULL, 0, NULL, NULL);
Date: 2025-09-24 09:51:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 38 3ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 12 19 1ms 0ms 20 19 1ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 38 ]
[ Application: pg_dump - Total duration: 3ms - Times executed: 38 ]
-
SELECT pg_catalog.format_type('1700'::pg_catalog.oid, NULL);
Date: 2025-09-24 18:28:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('16'::pg_catalog.oid, NULL);
Date: 2025-09-24 18:28:09 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('1015'::pg_catalog.oid, NULL);
Date: 2025-09-24 18:28:09 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 36 21s934ms 243ms 1s175ms 609ms copy gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 11 36 21s934ms 609ms [ User: a3dsupervisor - Total duration: 21s934ms - Times executed: 36 ]
[ Application: psql - Total duration: 21s934ms - Times executed: 36 ]
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:54 Duration: 1s175ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:43 Duration: 1s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:51 Duration: 963ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 28 177ms 4ms 16ms 6ms copy gtp_setting_clob (setting_num_id, setting_value) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 11 28 177ms 6ms [ User: a3dsupervisor - Total duration: 177ms - Times executed: 28 ]
[ Application: psql - Total duration: 177ms - Times executed: 28 ]
-
COPY gtp_setting_clob (setting_num_id, setting_value) FROM STDIN;
Date: 2025-09-24 09:55:18 Duration: 16ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_setting_clob (setting_num_id, setting_value) FROM STDIN;
Date: 2025-09-24 09:55:18 Duration: 8ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_setting_clob (setting_num_id, setting_value) FROM STDIN;
Date: 2025-09-24 09:55:18 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m5s 1m5s 1m5s 1 1m5s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 12 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: psql - Total duration: 1m5s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 10:05:02 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m 1m 1m 1 1m vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 12 1 1m 1m [ User: a3dsupervisor - Total duration: 1m - Times executed: 1 ]
[ Application: psql - Total duration: 1m - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 10:06:55 Duration: 1m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 45s225ms 45s225ms 45s225ms 1 45s225ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 12 1 45s225ms 45s225ms [ User: a3dsupervisor - Total duration: 45s225ms - Times executed: 1 ]
[ Application: psql - Total duration: 45s225ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:03:10 Duration: 45s225ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 32s235ms 32s235ms 32s235ms 1 32s235ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 12 1 32s235ms 32s235ms [ User: a3dsupervisor - Total duration: 32s235ms - Times executed: 1 ]
[ Application: psql - Total duration: 32s235ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-24 10:00:29 Duration: 32s235ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 25s473ms 25s473ms 25s473ms 1 25s473ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 11 1 25s473ms 25s473ms [ User: a3dsupervisor - Total duration: 25s473ms - Times executed: 1 ]
[ Application: psql - Total duration: 25s473ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 09:59:57 Duration: 25s473ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 23s402ms 23s402ms 23s402ms 1 23s402ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 12 1 23s402ms 23s402ms [ User: a3dsupervisor - Total duration: 23s402ms - Times executed: 1 ]
[ Application: psql - Total duration: 23s402ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-24 10:00:53 Duration: 23s402ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 20s778ms 20s778ms 20s778ms 1 20s778ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 12 1 20s778ms 20s778ms [ User: a3dsupervisor - Total duration: 20s778ms - Times executed: 1 ]
[ Application: psql - Total duration: 20s778ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 10:01:40 Duration: 20s778ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 20s709ms 20s814ms 20s762ms 2 41s524ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 12 1 20s814ms 20s814ms 20 1 20s709ms 20s709ms [ User: a3dsupervisor - Total duration: 41s524ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 41s524ms - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-09-24 10:23:55 Duration: 20s814ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-09-24 18:33:53 Duration: 20s709ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 14s762ms 14s762ms 14s762ms 1 14s762ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 11 1 14s762ms 14s762ms [ User: a3dsupervisor - Total duration: 14s762ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s762ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-24 09:56:28 Duration: 14s762ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 14s444ms 14s444ms 14s444ms 1 14s444ms create index i_fk_month_histo_att on gtp_monthly_history (att_template_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 11 1 14s444ms 14s444ms [ User: a3dsupervisor - Total duration: 14s444ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s444ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-09-24 09:57:22 Duration: 14s444ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 14s273ms 14s273ms 14s273ms 1 14s273ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 12 1 14s273ms 14s273ms [ User: a3dsupervisor - Total duration: 14s273ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s273ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-24 10:02:08 Duration: 14s273ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 12s525ms 12s536ms 12s531ms 2 25s62ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 12 1 12s525ms 12s525ms 20 1 12s536ms 12s536ms [ User: a3dsupervisor - Total duration: 25s62ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 25s62ms - Times executed: 2 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 18:34:06 Duration: 12s536ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 10:24:07 Duration: 12s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 8s668ms 8s695ms 8s682ms 2 17s364ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 12 1 8s695ms 8s695ms 20 1 8s668ms 8s668ms [ User: a3dsupervisor - Total duration: 17s364ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 17s364ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-24 10:24:16 Duration: 8s695ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-24 18:34:15 Duration: 8s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 8s634ms 8s653ms 8s644ms 2 17s288ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 12 1 8s653ms 8s653ms 20 1 8s634ms 8s634ms [ User: a3dsupervisor - Total duration: 17s288ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 17s288ms - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-24 10:24:25 Duration: 8s653ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-24 18:34:23 Duration: 8s634ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 513ms 3s31ms 1s405ms 19 26s710ms copy pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 11 19 26s710ms 1s405ms [ User: a3dsupervisor - Total duration: 26s710ms - Times executed: 19 ]
[ Application: psql - Total duration: 26s710ms - Times executed: 19 ]
-
COPY pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM STDIN;
Date: 2025-09-24 09:55:44 Duration: 3s31ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM STDIN;
Date: 2025-09-24 09:55:41 Duration: 2s649ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM STDIN;
Date: 2025-09-24 09:55:31 Duration: 2s450ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 219ms 1s304ms 870ms 65 56s604ms copy gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 11 65 56s604ms 870ms [ User: a3dsupervisor - Total duration: 56s604ms - Times executed: 65 ]
[ Application: psql - Total duration: 56s604ms - Times executed: 65 ]
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:52:43 Duration: 1s304ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:53:29 Duration: 1s280ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM STDIN;
Date: 2025-09-24 09:52:59 Duration: 1s243ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 240ms 1s249ms 623ms 27 16s834ms copy gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 11 27 16s834ms 623ms [ User: a3dsupervisor - Total duration: 16s834ms - Times executed: 27 ]
[ Application: psql - Total duration: 16s834ms - Times executed: 27 ]
-
COPY gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:54:18 Duration: 1s249ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:54:04 Duration: 923ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:54:12 Duration: 888ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 243ms 1s175ms 609ms 36 21s934ms copy gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 11 36 21s934ms 609ms [ User: a3dsupervisor - Total duration: 21s934ms - Times executed: 36 ]
[ Application: psql - Total duration: 21s934ms - Times executed: 36 ]
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:54 Duration: 1s175ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:43 Duration: 1s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM STDIN;
Date: 2025-09-24 09:53:51 Duration: 963ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 15ms 995ms 470ms 79 37s185ms copy gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 11 79 37s185ms 470ms [ User: a3dsupervisor - Total duration: 37s185ms - Times executed: 79 ]
[ Application: psql - Total duration: 37s185ms - Times executed: 79 ]
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:46 Duration: 995ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:37 Duration: 933ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM STDIN;
Date: 2025-09-24 09:54:53 Duration: 826ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 119ms 1s300ms 384ms 49 18s824ms copy gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 11 49 18s824ms 384ms [ User: a3dsupervisor - Total duration: 18s824ms - Times executed: 49 ]
[ Application: psql - Total duration: 18s824ms - Times executed: 49 ]
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:20 Duration: 1s300ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:24 Duration: 1s32ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
COPY gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM STDIN;
Date: 2025-09-24 09:52:31 Duration: 981ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6ms 1 6ms 6ms 6ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 24 12 1 6ms 6ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-24 10:11:39 Duration: 6ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 4ms 1 4ms 4ms 4ms 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';Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 10 1 4ms 4ms [ User: a3dsupervisor - Total duration: 21ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 21ms - Times executed: 1 ]
-
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';
Date: 2025-09-24 10:11:39 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 2ms 1 2ms 2ms 2ms 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;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 10 1 2ms 2ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 1 ]
-
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;
Date: 2025-09-24 10:11:39 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 2ms 1 2ms 2ms 2ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 10 1 2ms 2ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 9ms - Times executed: 1 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-24 10:11:39 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 0ms 1 0ms 0ms 0ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 0ms 1 0ms 0ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 0ms 1 0ms 0ms 0ms 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';Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 1 ]
-
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-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 0ms 1 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1ms 1 1ms 1ms 1ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 24 12 1 1ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-24 10:11:39 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 1ms 1 1ms 1ms 1ms 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';Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 10 1 1ms 1ms [ User: a3dsupervisor - Total duration: 21ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 21ms - Times executed: 1 ]
-
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';
Date: 2025-09-24 10:11:39 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 0ms 1 0ms 0ms 0ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 0ms 1 0ms 0ms 0ms 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;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 1 ]
-
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;
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 0ms 1 0ms 0ms 0ms 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';Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 1 ]
-
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-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 0ms 1 0ms 0ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 0ms 1 0ms 0ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 9ms - Times executed: 1 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 0ms 1 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 10 1 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:11:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
Events
Log levels
Key values
- 392,361 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 2 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 16 Max number of times the same event was reported
- 18 Total events found
Rank Times reported Error 1 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 24 11 16 2 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 24 11 1 3 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON gtp_obj_composition (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 24 11 1