pgBadger-
Global information
- Generated on Mon Sep 29 09:33:45 2025
- Log file: ././A3D-RND-REF/y=2025/m=09/d=27/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=09/d=27/h=23/m=00/PT1H.log
- Parsed 763,871 log entries in 2m49s
- Log start from 2025-09-24 09:34:29 to 2025-09-26 18:20:56
-
Overview
Global Stats
- 4,516 Number of unique normalized queries
- 22,841 Number of queries
- 18m2s Total query duration
- 2025-09-24 09:34:29 First query
- 2025-09-26 18:20:56 Last query
- 217 queries/s at 2025-09-24 18:28:10 Query peak
- 18m2s Total query duration
- 222ms Prepare/parse total duration
- 180ms Bind total duration
- 18m2s 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
- 301 Total number of sessions
- 8 sessions at 2025-09-24 09:58:01 Session peak
- 2h36m22s Total duration of sessions
- 31s171ms Average duration of sessions
- 75 Average queries per session
- 3s596ms Average queries duration per session
- 27s575ms Average idle time per session
- 301 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
- 203 queries/s Query Peak
- 2025-09-26 18:14:29 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 207 queries/s Query Peak
- 2025-09-24 09:51:36 Date
Queries duration
Key values
- 18m2s 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 Sep 25 09 8 0ms 25ms 8ms 65ms 65ms 65ms 18 1,072 0ms 22s532ms 70ms 22s533ms 51s149ms 51s149ms Sep 26 08 24 0ms 21ms 5ms 72ms 72ms 72ms 12 8 0ms 13ms 4ms 34ms 34ms 34ms 14 32 0ms 13ms 4ms 70ms 70ms 70ms 18 1,072 0ms 21s19ms 65ms 548ms 1m9s 1m9s 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 Sep 25 09 8 0 8ms 65ms 65ms 65ms 18 430 242 111ms 883ms 22s532ms 51s128ms Sep 26 08 24 0 5ms 72ms 72ms 72ms 12 8 0 4ms 34ms 34ms 34ms 14 32 0 4ms 70ms 70ms 70ms 18 430 242 104ms 0ms 514ms 1m9s 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 Sep 25 09 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Sep 26 08 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 14 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% Sep 25 09 8 8 1.00 100.00% 18 3 116 38.67 0.44% Sep 26 08 24 24 1.00 100.00% 12 8 8 1.00 100.00% 14 32 32 1.00 100.00% 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 Sep 25 09 1 0.00/s 18 3 0.00/s Sep 26 08 3 0.00/s 12 1 0.00/s 14 4 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 Sep 25 09 1 356ms 290ms 18 3 11m59s 11m34s Sep 26 08 3 358ms 316ms 12 1 283ms 248ms 14 4 271ms 237ms 18 3 11m30s 11m7s -
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
- 301 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 301 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2025-09-24 09:58:01 Date
Histogram of session times
Key values
- 252 0-500ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 301 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 301 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 301 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 Sep 25 09 0 0 0 18 0 0 0 Sep 26 08 0 0 0 12 0 0 0 14 0 0 0 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.gtp_view 1 autotest_feat_batch.public.uml_relation 1 autotest_feat_batch.public.gtp_node_tree_type 1 autotest_feat_batch.public.gtp_obj_composition 1 autotest_feat_batch.public.gtp_history_param_obj 1 autotest_feat_batch.public.gtp_history_att_template 1 autotest_feat_batch.public.gtp_history_rel_template 1 autotest_feat_batch.public.business_mail_template 1 autotest_feat_batch.public.gtp_att_template_enum_value 1 autotest_feat_batch.public.ged_node 1 autotest_feat_batch.public.gtp_history_obj_template 1 autotest_feat_batch.public.functionality_association 1 autotest_feat_batch.public.ged_history_project 1 autotest_feat_batch.public.gtp_obj_template_rel_cat 1 autotest_feat_batch.public.pe_consumption_monthly 1 autotest_feat_batch.public.gtp_etat_v2_data 1 autotest_feat_batch.public.gtp_att_template_enum 1 autotest_feat_batch.public.pe_asset_consolidation_monthly 1 autotest_feat_batch.public.bdc_concerned_element 1 autotest_feat_batch.public.pe_asset_usage_consolidation_daily 1 autotest_feat_batch.public.gtp_history_obj_action 1 autotest_feat_batch.public.register_cost_monthly 1 autotest_feat_batch.public.gtp_monthly_history 1 autotest_feat_batch.public.gtp_setting_boolean 1 autotest_feat_batch.public.uml_mapping_class 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule 1 autotest_feat_batch.public.gtp_dependence 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_request 1 autotest_feat_batch.public.gtp_log_jvm 1 autotest_feat_batch.public.gtp_obj 1 autotest_feat_batch.public.currency 1 autotest_feat_batch.public.gtp_obj_template_calcul_rule_cascade_error 1 autotest_feat_batch.public.gtp_history_att_template_category 1 autotest_feat_batch.public.gtp_log 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_mapping_alias 1 autotest_feat_batch.public.ged_node_tree_type 1 autotest_feat_batch.public.gtp_log_connection 1 autotest_feat_batch.public.gtp_att_template_category 1 autotest_feat_batch.public.uml_attribute 1 autotest_feat_batch.public.pe_asset_consolidation_annual 1 autotest_feat_batch.public.a3d_company_activity 1 autotest_feat_batch.public.gtp_obj_template 1 autotest_feat_batch.public.gtp_contenu_rel_template 1 autotest_feat_batch.public.pe_consumption_annual 1 autotest_feat_batch.public.gtp_etat_contient_requete 1 autotest_feat_batch.public.gtp_att_template_rel_tab 1 autotest_feat_batch.public.gtp_att_template_rel_cat 1 autotest_feat_batch.public.ged_right_user 1 autotest_feat_batch.public.gtp_setting 1 autotest_feat_batch.public.register_cost_annual 1 autotest_feat_batch.public.gtp_log_session 1 autotest_feat_batch.pg_catalog.pg_sequence 1 autotest_feat_batch.public.mail_template 1 autotest_feat_batch.public.gtp_att_template 1 autotest_feat_batch.public.l_notification_user 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_options 1 autotest_feat_batch.public.gtp_history_doc_deleted 1 autotest_feat_batch.public.gtp_history_view_template 1 autotest_feat_batch.public.gtp_setting_text 1 autotest_feat_batch.public.a3d_log 1 autotest_feat_batch.public.notification 1 autotest_feat_batch.public.eng_mapping 1 autotest_feat_batch.public.gtp_history_obj_concerned 1 autotest_feat_batch.public.log_profile_rel 1 autotest_feat_batch.public.gtp_setting_number 1 autotest_feat_batch.public.gtp_history_obj_old_qsp 1 autotest_feat_batch.public.gtp_dependence_rel_template 1 autotest_feat_batch.public.pe_consumption_daily 1 autotest_feat_batch.public.pe_asset_consolidation_daily 1 autotest_feat_batch.public.gtp_obj_compo_sequence 1 autotest_feat_batch.public.uml_class 1 autotest_feat_batch.public.gtp_file 1 autotest_feat_batch.public.gtp_obj_template_influence 1 autotest_feat_batch.public.gtp_dependence_obj_template 1 autotest_feat_batch.public.gtp_background_task 1 autotest_feat_batch.public.gtp_obj_template_calcul_rule_cascade_info 1 autotest_feat_batch.pg_catalog.pg_type 1 autotest_feat_batch.public.gtp_att_unit 1 autotest_feat_batch.public.eng_data 1 autotest_feat_batch.public.gtp_obj_template_composition 1 autotest_feat_batch.public.pe_dju 1 autotest_feat_batch.public.gtp_view_template 1 autotest_feat_batch.public.gtp_requete_v2 1 autotest_feat_batch.public.gtp_obj_template_rel_cat_att 1 autotest_feat_batch.public.notification_param 1 autotest_feat_batch.public.eng_gtp_datalink 1 autotest_feat_batch.public.gtp_obj_template_calculation_rule_attribute 1 autotest_feat_batch.public.uml_mapping_att 1 autotest_feat_batch.public.gtp_rel_group_template 1 autotest_feat_batch.public.gtp_history_obj_template_category 1 autotest_feat_batch.public.gtp_dependence_obj_tmplt_compo 1 autotest_feat_batch.public.bdc_right 1 autotest_feat_batch.public.gtp_log_thread 1 autotest_feat_batch.public.gtp_history_att_unit 1 autotest_feat_batch.public.pe_consumption_10min 1 autotest_feat_batch.public.gtp_obj_version 1 autotest_feat_batch.public.pe_consumption_hourly 1 autotest_feat_batch.public.functionality 1 autotest_feat_batch.public.ged_subscription 1 autotest_feat_batch.public.mapping 1 autotest_feat_batch.public.gtp_obj_rel_vt 1 autotest_feat_batch.public.bdc_history_right_action 1 autotest_feat_batch.public.gtp_cw_eng_history 1 autotest_feat_batch.pg_catalog.pg_trigger 1 autotest_feat_batch.public.gtp_history_obj_link_unlink 1 autotest_feat_batch.public.gtp_history_obj_compo 1 autotest_feat_batch.public.gtp_history_obj_deleted 1 autotest_feat_batch.public.gtp_relation 1 autotest_feat_batch.public.pe_asset_usage_consolidation_monthly 1 autotest_feat_batch.pg_catalog.pg_attrdef 1 autotest_feat_batch.public.gtp_rel_template 1 autotest_feat_batch.public.gtp_log_ehcache 1 autotest_feat_batch.public.gtp_obj_favorite 1 autotest_feat_batch.public.ged_history_project_type 1 autotest_feat_batch.public.gtp_cw_eng_alert 1 autotest_feat_batch.public.gtp_setting_clob 1 autotest_feat_batch.public.bdc_obj_template_enum_value_action 1 autotest_feat_batch.public.gtp_a3d_version 1 autotest_feat_batch.public.gtp_log_metric 1 autotest_feat_batch.public.a3d_user 1 autotest_feat_batch.public.pe_asset_usage_consolidation_annual 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 Sep 25 09 0 0 18 0 0 Sep 26 08 0 0 12 0 0 14 0 0 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
- 1,927 Total read queries
- 18,490 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 22,841 Requests
- 18m2s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 22,841 Requests
User Request type Count Duration a3dsupervisor Total 22,841 18m2s copy from 3,048 3m32s copy to 968 4m41s cte 4 12ms ddl 3,081 7m33s insert 11,377 3s222ms others 2,424 2m7s select 1,927 3s679ms tcl 12 0ms Duration by user
Key values
- 18m2s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 22,841 18m2s copy from 3,048 3m32s copy to 968 4m41s cte 4 12ms ddl 3,081 7m33s insert 11,377 3s222ms others 2,424 2m7s select 1,927 3s679ms tcl 12 0ms Queries by host
Key values
- 10.3.0.4 Main host
- 22,833 Requests
- 18m1s (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:32:32 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 15,300 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 22s532ms 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-25 18:22:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 21s19ms 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-26 18:20:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 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 ]
10 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 ]
11 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 ]
12 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 ]
13 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 ]
14 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 ]
15 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 ]
16 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 ]
17 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 ]
18 12s524ms 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-26 18:20:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 12s462ms 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-25 18:23:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 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 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1m25s 4 20s709ms 22s532ms 21s269ms 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 #1
Day Hour Count Duration Avg duration Sep 24 12 1 20s814ms 20s814ms 20 1 20s709ms 20s709ms Sep 25 20 1 22s532ms 22s532ms Sep 26 20 1 21s19ms 21s19ms [ User: a3dsupervisor - Total duration: 1m25s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m25s - Times executed: 4 ]
-
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-25 18:22:48 Duration: 22s532ms 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-26 18:20:04 Duration: 21s19ms 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 10:23:55 Duration: 20s814ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 1m5s 1 1m5s 1m5s 1m5s vacuum analyze;Times Reported Time consuming queries #2
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
3 1m 1 1m 1m 1m vacuum analyse;Times Reported Time consuming queries #3
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
4 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 #4
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
5 50s49ms 4 12s462ms 12s536ms 12s512ms 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 #5
Day Hour Count Duration Avg duration Sep 24 12 1 12s525ms 12s525ms 20 1 12s536ms 12s536ms Sep 25 20 1 12s462ms 12s462ms Sep 26 20 1 12s524ms 12s524ms [ User: a3dsupervisor - Total duration: 50s49ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s49ms - Times executed: 4 ]
-
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
-
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-26 18:20:16 Duration: 12s524ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 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 #6
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
7 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 #7
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
8 34s651ms 4 8s626ms 8s695ms 8s662ms 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 #8
Day Hour Count Duration Avg duration Sep 24 12 1 8s695ms 8s695ms 20 1 8s668ms 8s668ms Sep 25 20 1 8s626ms 8s626ms Sep 26 20 1 8s660ms 8s660ms [ User: a3dsupervisor - Total duration: 34s651ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 34s651ms - Times executed: 4 ]
-
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
-
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-26 18:20:25 Duration: 8s660ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 34s73ms 4 8s214ms 8s653ms 8s518ms 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 #9
Day Hour Count Duration Avg duration Sep 24 12 1 8s653ms 8s653ms 20 1 8s634ms 8s634ms Sep 25 20 1 8s214ms 8s214ms Sep 26 20 1 8s571ms 8s571ms [ User: a3dsupervisor - Total duration: 34s73ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 34s73ms - Times executed: 4 ]
-
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
-
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-26 18:20:33 Duration: 8s571ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 32s235ms 1 32s235ms 32s235ms 32s235ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #10
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
11 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 #11
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
12 25s946ms 4 5s956ms 7s84ms 6s486ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 12 1 6s195ms 6s195ms 20 1 6s710ms 6s710ms Sep 25 20 1 7s84ms 7s84ms Sep 26 20 1 5s956ms 5s956ms [ User: a3dsupervisor - Total duration: 25s946ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 25s946ms - Times executed: 4 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-25 18:23:25 Duration: 7s84ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-24 18:34:30 Duration: 6s710ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-24 10:24:31 Duration: 6s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 25s473ms 1 25s473ms 25s473ms 25s473ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #13
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
14 23s402ms 1 23s402ms 23s402ms 23s402ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #14
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
15 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 #15
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
16 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 #16
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
17 19s79ms 4 4s648ms 5s99ms 4s769ms copy public.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) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 12 1 4s648ms 4s648ms 20 1 4s678ms 4s678ms Sep 25 20 1 5s99ms 5s99ms Sep 26 20 1 4s652ms 4s652ms [ User: a3dsupervisor - Total duration: 19s79ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 19s79ms - Times executed: 4 ]
-
COPY public.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) TO stdout;
Date: 2025-09-25 18:23:30 Duration: 5s99ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.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) TO stdout;
Date: 2025-09-24 18:34:35 Duration: 4s678ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.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) TO stdout;
Date: 2025-09-26 18:20:44 Duration: 4s652ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 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 #18
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
19 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 #19
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
20 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 #20
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
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 656 120ms 0ms 12ms 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 Sep 25 20 164 39ms 0ms Sep 26 20 164 28ms 0ms [ User: a3dsupervisor - Total duration: 120ms - Times executed: 656 ]
[ Application: pg_dump - Total duration: 120ms - Times executed: 656 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;
Date: 2025-09-25 18:17:00 Duration: 12ms 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 = '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 = '2800421'::oid;
Date: 2025-09-26 18:14:28 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 436 92ms 0ms 10ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 12 109 19ms 0ms 20 109 21ms 0ms Sep 25 20 109 31ms 0ms Sep 26 20 109 20ms 0ms [ User: a3dsupervisor - Total duration: 92ms - Times executed: 436 ]
[ Application: pg_dump - Total duration: 92ms - Times executed: 436 ]
-
EXECUTE dumpFunc ('2818912');
Date: 2025-09-25 18:16:59 Duration: 10ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818867');
Date: 2025-09-25 18:16:59 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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
6 271 90ms 0ms 0ms 0ms set client_encoding to ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 11 258 86ms 0ms 12 7 1ms 0ms 20 2 1ms 0ms Sep 25 20 2 0ms 0ms Sep 26 20 2 0ms 0ms [ User: a3dsupervisor - Total duration: 90ms - Times executed: 271 ]
[ Application: psql - Total duration: 88ms - Times executed: 263 ]
[ Application: pg_dump - Total duration: 2ms - Times executed: 8 ]
-
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
7 254 15ms 0ms 0ms 0ms set synchronous_commit to off;Times Reported Time consuming queries #7
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
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 76 7ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 12 19 1ms 0ms 20 19 1ms 0ms Sep 25 20 19 1ms 0ms Sep 26 20 19 1ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 76 ]
[ Application: pg_dump - Total duration: 7ms - Times executed: 76 ]
-
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('1700'::pg_catalog.oid, NULL);
Date: 2025-09-26 18:14:28 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
14 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 #14
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
15 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 #15
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
16 56 6ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 12 14 1ms 0ms 20 14 1ms 0ms Sep 25 20 14 1ms 0ms Sep 26 20 14 1ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 56 ]
[ Application: pg_dump - Total duration: 6ms - Times executed: 56 ]
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819014'::pg_catalog.oid);
Date: 2025-09-24 18:28:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819023'::pg_catalog.oid);
Date: 2025-09-24 18:28:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819023'::pg_catalog.oid);
Date: 2025-09-26 18:14:30 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 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 #17
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
18 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 #18
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
19 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 #19
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
20 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 #20
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
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 20s709ms 22s532ms 21s269ms 4 1m25s 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 #7
Day Hour Count Duration Avg duration Sep 24 12 1 20s814ms 20s814ms 20 1 20s709ms 20s709ms Sep 25 20 1 22s532ms 22s532ms Sep 26 20 1 21s19ms 21s19ms [ User: a3dsupervisor - Total duration: 1m25s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m25s - Times executed: 4 ]
-
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-25 18:22:48 Duration: 22s532ms 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-26 18:20:04 Duration: 21s19ms 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 10:23:55 Duration: 20s814ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 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 #8
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
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 12s462ms 12s536ms 12s512ms 4 50s49ms 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 Sep 25 20 1 12s462ms 12s462ms Sep 26 20 1 12s524ms 12s524ms [ User: a3dsupervisor - Total duration: 50s49ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s49ms - Times executed: 4 ]
-
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
-
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-26 18:20:16 Duration: 12s524ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 8s626ms 8s695ms 8s662ms 4 34s651ms 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 #11
Day Hour Count Duration Avg duration Sep 24 12 1 8s695ms 8s695ms 20 1 8s668ms 8s668ms Sep 25 20 1 8s626ms 8s626ms Sep 26 20 1 8s660ms 8s660ms [ User: a3dsupervisor - Total duration: 34s651ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 34s651ms - Times executed: 4 ]
-
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
-
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-26 18:20:25 Duration: 8s660ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 8s214ms 8s653ms 8s518ms 4 34s73ms 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 #12
Day Hour Count Duration Avg duration Sep 24 12 1 8s653ms 8s653ms 20 1 8s634ms 8s634ms Sep 25 20 1 8s214ms 8s214ms Sep 26 20 1 8s571ms 8s571ms [ User: a3dsupervisor - Total duration: 34s73ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 34s73ms - Times executed: 4 ]
-
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
-
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-26 18:20:33 Duration: 8s571ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 5s956ms 7s84ms 6s486ms 4 25s946ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 12 1 6s195ms 6s195ms 20 1 6s710ms 6s710ms Sep 25 20 1 7s84ms 7s84ms Sep 26 20 1 5s956ms 5s956ms [ User: a3dsupervisor - Total duration: 25s946ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 25s946ms - Times executed: 4 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-25 18:23:25 Duration: 7s84ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-24 18:34:30 Duration: 6s710ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-24 10:24:31 Duration: 6s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 4s648ms 5s99ms 4s769ms 4 19s79ms copy public.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) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 12 1 4s648ms 4s648ms 20 1 4s678ms 4s678ms Sep 25 20 1 5s99ms 5s99ms Sep 26 20 1 4s652ms 4s652ms [ User: a3dsupervisor - Total duration: 19s79ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 19s79ms - Times executed: 4 ]
-
COPY public.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) TO stdout;
Date: 2025-09-25 18:23:30 Duration: 5s99ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.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) TO stdout;
Date: 2025-09-24 18:34:35 Duration: 4s678ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.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) TO stdout;
Date: 2025-09-26 18:20:44 Duration: 4s652ms 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 89ms 10 1ms 44ms 8ms 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 26 12 1 6ms 6ms Sep 26 11 1 44ms 44ms Sep 26 10 3 30ms 10ms 14 1 1ms 1ms 16 4 6ms 1ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 10 ]
-
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-25 09:12:45 Duration: 44ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 08:51:44 Duration: 27ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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 36ms 10 0ms 13ms 3ms 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 09 1 13ms 13ms 08 3 12ms 4ms 12 1 0ms 0ms 14 4 3ms 0ms [ User: a3dsupervisor - Total duration: 115ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 115ms - Times executed: 10 ]
-
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-25 09:12:45 Duration: 13ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 08:51:44 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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 33ms 10 0ms 20ms 3ms 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 #3
Day Hour Count Duration Avg duration 10 1 0ms 0ms 09 1 20ms 20ms 08 3 9ms 3ms 12 1 0ms 0ms 14 4 2ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 10 ]
-
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-25 09:12:45 Duration: 20ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 08:51:44 Duration: 8ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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 31ms 10 0ms 12ms 3ms 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 09 1 12ms 12ms 08 3 13ms 4ms 12 1 0ms 0ms 14 4 2ms 0ms [ User: a3dsupervisor - Total duration: 74ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 74ms - Times executed: 10 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-25 09:12:45 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-26 08:51:44 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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 11ms 10 0ms 5ms 1ms 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 #5
Day Hour Count Duration Avg duration 10 1 0ms 0ms 09 1 4ms 4ms 08 3 5ms 1ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 62ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 62ms - Times executed: 10 ]
-
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-26 08:51:44 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-25 09:12:45 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 14:47:20 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 10ms 10 0ms 3ms 1ms 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 #6
Day Hour Count Duration Avg duration 10 1 2ms 2ms 09 1 2ms 2ms 08 3 3ms 1ms 12 1 0ms 0ms 14 4 1ms 0ms [ User: a3dsupervisor - Total duration: 152ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 152ms - Times executed: 10 ]
-
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-26 08:51:44 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-25 09:12:45 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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]
7 9ms 10 0ms 2ms 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 #7
Day Hour Count Duration Avg duration 10 1 0ms 0ms 09 1 2ms 2ms 08 3 3ms 1ms 12 1 0ms 0ms 14 4 3ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 10 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-25 09:12:45 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-26 08:51:44 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-26 14:41:23 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 1ms 10 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 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 10 ]
-
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-26 14:41:18 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-26 08:52:18 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-26 08:51:44 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 55ms 10 0ms 32ms 5ms 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 #1
Day Hour Count Duration Avg duration Sep 26 12 1 1ms 1ms Sep 26 11 1 32ms 32ms Sep 26 10 3 16ms 5ms 14 1 1ms 1ms 16 4 3ms 0ms [ User: a3dsupervisor - Total duration: 115ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 115ms - Times executed: 10 ]
-
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-25 09:12:45 Duration: 32ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 08:51:44 Duration: 14ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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]
2 40ms 10 0ms 19ms 4ms 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 #2
Day Hour Count Duration Avg duration 10 1 1ms 1ms 09 1 19ms 19ms 08 3 15ms 5ms 12 1 1ms 1ms 14 4 4ms 1ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 10 ]
-
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-25 09:12:45 Duration: 19ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 08:51:44 Duration: 13ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-26 12:25:49 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 37ms 10 0ms 22ms 3ms 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 #3
Day Hour Count Duration Avg duration 10 1 0ms 0ms 09 1 22ms 22ms 08 3 11ms 3ms 12 1 0ms 0ms 14 4 1ms 0ms [ User: a3dsupervisor - Total duration: 152ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 152ms - Times executed: 10 ]
-
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-25 09:12:45 Duration: 22ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 08:51:44 Duration: 10ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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]
4 35ms 10 0ms 23ms 3ms 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 #4
Day Hour Count Duration Avg duration 10 1 0ms 0ms 09 1 23ms 23ms 08 3 8ms 2ms 12 1 0ms 0ms 14 4 2ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 10 ]
-
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-25 09:12:45 Duration: 23ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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-26 08:51:44 Duration: 7ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-26 08:52:18 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 4ms 10 0ms 1ms 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 #5
Day Hour Count Duration Avg duration 10 1 0ms 0ms 09 1 1ms 1ms 08 3 1ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 10 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-25 09:12:45 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-26 08:51:44 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-26 12:25:49 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 3ms 10 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 #6
Day Hour Count Duration Avg duration 10 1 0ms 0ms 09 1 0ms 0ms 08 3 1ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 62ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 62ms - Times executed: 10 ]
-
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-26 08:51:44 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-25 09:12:45 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
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]
7 1ms 10 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 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 74ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 74ms - Times executed: 10 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-26 12:25:49 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-26 14:41:23 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-26 14:47:14 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 1ms 10 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 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 10 ]
-
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-26 08:52:18 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-26 14:47:14 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
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-26 08:51:44 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
Events
Log levels
Key values
- 740,932 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