pgBadger-
Global information
- Generated on Wed Nov 19 09:07:15 2025
- Log file: ././A3D-RND-REF/y=2025/m=11/d=18/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=11/d=18/h=23/m=00/PT1H.log
- Parsed 224,108 log entries in 5m13s
- Log start from 2025-11-18 00:11:41 to 2025-11-18 10:11:33
-
Overview
Global Stats
- 630 Number of unique normalized queries
- 11,768 Number of queries
- 51s865ms Total query duration
- 2025-11-18 00:11:41 First query
- 2025-11-18 10:11:33 Last query
- 592 queries/s at 2025-11-18 10:07:47 Query peak
- 51s865ms Total query duration
- 805ms Prepare/parse total duration
- 1s688ms Bind total duration
- 49s371ms Execute total duration
- 6 Number of events
- 2 Number of unique normalized events
- 4 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 6 Total number of automatic analyzes
- 2 Number temporary file
- 4.20 MiB Max size of temporary file
- 4.20 MiB Average size of temporary file
- 81 Total number of sessions
- 3 sessions at 2025-11-18 09:13:06 Session peak
- 49m6s Total duration of sessions
- 36s382ms Average duration of sessions
- 145 Average queries per session
- 640ms Average queries duration per session
- 35s742ms Average idle time per session
- 85 Total number of connections
- 5 connections/s at 2025-11-18 10:07:37 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 592 queries/s Query Peak
- 2025-11-18 10:07:47 Date
SELECT Traffic
Key values
- 142 queries/s Query Peak
- 2025-11-18 09:06:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 226 queries/s Query Peak
- 2025-11-18 10:07:47 Date
Queries duration
Key values
- 51s865ms 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) Nov 18 00 10 0ms 4ms 1ms 5ms 5ms 5ms 01 10 0ms 4ms 1ms 6ms 6ms 6ms 02 10 0ms 4ms 1ms 5ms 5ms 5ms 03 10 0ms 4ms 1ms 6ms 6ms 6ms 04 10 0ms 4ms 1ms 6ms 6ms 6ms 05 10 0ms 4ms 1ms 6ms 6ms 6ms 06 10 0ms 4ms 0ms 5ms 5ms 5ms 07 34 0ms 19ms 5ms 63ms 63ms 63ms 08 74 0ms 16ms 4ms 109ms 109ms 109ms 09 1,018 0ms 9s344ms 44ms 87ms 115ms 43s982ms 10 10,572 0ms 669ms 0ms 1s48ms 1s84ms 1s84ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 18 00 5 0 2ms 5ms 5ms 5ms 01 5 0 2ms 6ms 6ms 6ms 02 5 0 2ms 5ms 5ms 5ms 03 5 0 2ms 6ms 6ms 6ms 04 5 0 2ms 6ms 6ms 6ms 05 5 0 2ms 6ms 6ms 6ms 06 5 0 1ms 5ms 5ms 5ms 07 29 0 6ms 63ms 63ms 63ms 08 69 0 4ms 62ms 109ms 109ms 09 615 245 52ms 71ms 104ms 43s115ms 10 3,143 0 0ms 96ms 368ms 552ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 18 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 200 8 108 0 5ms 3ms 64ms 671ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 18 00 10 10 1.00 200.00% 01 10 10 1.00 200.00% 02 10 10 1.00 200.00% 03 10 10 1.00 200.00% 04 10 10 1.00 200.00% 05 10 10 1.00 200.00% 06 10 10 1.00 200.00% 07 34 34 1.00 117.24% 08 74 74 1.00 107.25% 09 205 339 1.65 23.78% 10 741 5,394 7.28 10.13% Day Hour Count Average / Second Nov 18 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 5 0.00/s 08 10 0.00/s 09 27 0.01/s 10 29 0.01/s Day Hour Count Average Duration Average idle time Nov 18 00 2 74ms 68ms 01 2 73ms 68ms 02 2 73ms 67ms 03 2 75ms 69ms 04 2 76ms 70ms 05 2 77ms 71ms 06 2 72ms 67ms 07 5 312ms 274ms 08 10 323ms 291ms 09 27 46s91ms 44s428ms 10 25 1m7s 1m7s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2025-11-18 10:07:37 Date
Connections per database
Key values
- pentest Main Database
- 85 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 85 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2025-11-18 09:13:06 Date
Histogram of session times
Key values
- 67 0-500ms duration
Sessions per database
Key values
- pentest Main Database
- 81 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 81 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 81 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 4.20 MiB Temp Files size Peak
- 2025-11-18 10:07:50 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2025-11-18 10:07:50 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 18 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 2 8.39 MiB 4.20 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 2 8.39 MiB 4.20 MiB 4.20 MiB 4.20 MiB select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) limit ?;-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:03:06 Duration: 105ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:07:50 Duration: 70ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:03:06 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
Queries generating the largest temporary files
Rank Size Query 1 4.20 MiB select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;[ Date: 2025-11-18 10:03:06 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver ]
2 4.20 MiB select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;[ Date: 2025-11-18 10:07:50 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- public.applicative_lock (2) Main table analyzed (database pentest)
- 6 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 18 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 6 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 3,891 Total read queries
- 4,417 Total write queries
Queries by database
Key values
- pentest Main database
- 11,768 Requests
- 49s371ms (pentest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 11,668 Requests
User Request type Count Duration a3dsupervisor Total 11,668 49s252ms copy to 245 43s115ms cte 1 15ms delete 108 491ms insert 200 476ms others 170 208ms select 3,841 3s623ms tcl 3,855 531ms update 8 737ms azuresu Total 100 118ms others 50 1ms select 50 117ms Duration by user
Key values
- 49s252ms (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 11,668 49s252ms copy to 245 43s115ms cte 1 15ms delete 108 491ms insert 200 476ms others 170 208ms select 3,841 3s623ms tcl 3,855 531ms update 8 737ms azuresu Total 100 118ms others 50 1ms select 50 117ms Queries by host
Key values
- 10.3.6.4 Main host
- 10,488 Requests
- 45s720ms (10.3.0.4)
- Main time consuming host
Host Request type Count Duration 10.3.0.4 Total 1,168 45s720ms copy to 245 43s115ms cte 1 15ms others 151 41ms select 770 2s549ms tcl 1 0ms 10.3.1.6 Total 12 34ms select 12 34ms 10.3.6.4 Total 10,488 3s496ms delete 108 491ms insert 200 476ms others 19 167ms select 3,059 1s39ms tcl 3,854 530ms update 8 737ms 169.254.128.1 Total 100 118ms others 50 1ms select 50 117ms Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 10,488 Requests
- 43s982ms (pg_dump)
- Main time consuming application
Application Request type Count Duration PostgreSQL JDBC Driver Total 10,488 3s496ms delete 108 491ms insert 200 476ms others 19 167ms select 3,059 1s39ms tcl 3,854 530ms update 8 737ms [unknown] Total 464 1s891ms others 50 1ms select 414 1s890ms pg_dump Total 816 43s982ms copy to 245 43s115ms cte 1 15ms others 151 41ms select 418 810ms tcl 1 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-18 09:14:20 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 10,958 0-1ms duration
Slowest individual queries
Rank Duration Query 1 9s344ms 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-11-18 09:06:34 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 9s91ms 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-11-18 09:06:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 6s586ms 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-11-18 09:06:41 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 5s214ms 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-11-18 09:06:49 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 1s512ms 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-11-18 09:06:24 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 1s237ms COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;[ Date: 2025-11-18 09:06:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 1s209ms COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;[ Date: 2025-11-18 09:06:11 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 1s161ms COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;[ Date: 2025-11-18 09:06:09 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 828ms COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-11-18 09:06:49 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 680ms COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;[ Date: 2025-11-18 09:06:43 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 669ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');[ Date: 2025-11-18 10:04:04 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 650ms COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;[ Date: 2025-11-18 09:06:07 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 558ms 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-11-18 09:06:41 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 544ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-11-18 09:06:07 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 476ms COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;[ Date: 2025-11-18 09:06:08 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 425ms COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;[ Date: 2025-11-18 09:06:24 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 408ms COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;[ Date: 2025-11-18 09:06:34 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 307ms COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;[ Date: 2025-11-18 09:06:24 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 221ms COPY public.gtp_log_connection (log_connection_num_id, server_id, log_date, gtp_active_min, gtp_active_average, gtp_active_max, gtp_idle_average) TO stdout;[ Date: 2025-11-18 09:06:22 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 207ms COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;[ Date: 2025-11-18 09:06:43 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9s344ms 1 9s344ms 9s344ms 9s344ms 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 #1
Day Hour Count Duration Avg duration Nov 18 10 1 9s344ms 9s344ms [ User: a3dsupervisor - Total duration: 9s344ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s344ms - Times executed: 1 ]
-
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-11-18 09:06:34 Duration: 9s344ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 9s91ms 1 9s91ms 9s91ms 9s91ms 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 #2
Day Hour Count Duration Avg duration Nov 18 10 1 9s91ms 9s91ms [ User: a3dsupervisor - Total duration: 9s91ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s91ms - Times executed: 1 ]
-
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-11-18 09:06:20 Duration: 9s91ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 6s586ms 1 6s586ms 6s586ms 6s586ms 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 #3
Day Hour Count Duration Avg duration Nov 18 10 1 6s586ms 6s586ms [ User: a3dsupervisor - Total duration: 6s586ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 6s586ms - Times executed: 1 ]
-
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-11-18 09:06:41 Duration: 6s586ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 5s214ms 1 5s214ms 5s214ms 5s214ms 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 #4
Day Hour Count Duration Avg duration Nov 18 10 1 5s214ms 5s214ms [ User: a3dsupervisor - Total duration: 5s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s214ms - Times executed: 1 ]
-
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-11-18 09:06:49 Duration: 5s214ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 1s512ms 1 1s512ms 1s512ms 1s512ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 18 10 1 1s512ms 1s512ms [ User: a3dsupervisor - Total duration: 1s512ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s512ms - Times executed: 1 ]
-
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-11-18 09:06:24 Duration: 1s512ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 1s237ms 1 1s237ms 1s237ms 1s237ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 10 1 1s237ms 1s237ms [ User: a3dsupervisor - Total duration: 1s237ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s237ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-18 09:06:21 Duration: 1s237ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 1s209ms 1 1s209ms 1s209ms 1s209ms copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 18 10 1 1s209ms 1s209ms [ User: a3dsupervisor - Total duration: 1s209ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s209ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-18 09:06:11 Duration: 1s209ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1s161ms 1 1s161ms 1s161ms 1s161ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 10 1 1s161ms 1s161ms [ User: a3dsupervisor - Total duration: 1s161ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s161ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-18 09:06:09 Duration: 1s161ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 828ms 1 828ms 828ms 828ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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 #9
Day Hour Count Duration Avg duration Nov 18 10 1 828ms 828ms [ User: a3dsupervisor - Total duration: 828ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 828ms - Times executed: 1 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-11-18 09:06:49 Duration: 828ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 732ms 2 63ms 669ms 366ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 11 2 732ms 366ms [ User: a3dsupervisor - Total duration: 732ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 732ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-18 10:04:04 Duration: 669ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-18 10:08:48 Duration: 63ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 680ms 1 680ms 680ms 680ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 10 1 680ms 680ms [ User: a3dsupervisor - Total duration: 680ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 680ms - Times executed: 1 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-18 09:06:43 Duration: 680ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 650ms 1 650ms 650ms 650ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 10 1 650ms 650ms [ User: a3dsupervisor - Total duration: 650ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 650ms - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-18 09:06:07 Duration: 650ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 625ms 45 12ms 21ms 13ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 08 3 53ms 17ms 09 8 107ms 13ms 10 24 323ms 13ms 11 10 141ms 14ms [ User: a3dsupervisor - Total duration: 625ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 625ms - Times executed: 45 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 10:02:13 Duration: 21ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 07:40:36 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 07:51:56 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
14 558ms 1 558ms 558ms 558ms 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 #14
Day Hour Count Duration Avg duration Nov 18 10 1 558ms 558ms [ User: a3dsupervisor - Total duration: 558ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 558ms - Times executed: 1 ]
-
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-11-18 09:06:41 Duration: 558ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 544ms 1 544ms 544ms 544ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 10 1 544ms 544ms [ User: a3dsupervisor - Total duration: 544ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 544ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-11-18 09:06:07 Duration: 544ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 476ms 1 476ms 476ms 476ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 10 1 476ms 476ms [ User: a3dsupervisor - Total duration: 476ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 476ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-11-18 09:06:08 Duration: 476ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 463ms 1,927 0ms 14ms 0ms commit;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 18 11 1,927 463ms 0ms [ User: a3dsupervisor - Total duration: 463ms - Times executed: 1927 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 463ms - Times executed: 1927 ]
-
COMMIT;
Date: 2025-11-18 10:09:23 Duration: 14ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 10:04:04 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 10:09:33 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 445ms 119 0ms 50ms 3ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 11 119 445ms 3ms [ User: a3dsupervisor - Total duration: 445ms - Times executed: 119 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 445ms - Times executed: 119 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 50ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 14ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 13ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 425ms 1 425ms 425ms 425ms copy public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 10 1 425ms 425ms [ User: a3dsupervisor - Total duration: 425ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 425ms - Times executed: 1 ]
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-11-18 09:06:24 Duration: 425ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 408ms 1 408ms 408ms 408ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 18 10 1 408ms 408ms [ User: a3dsupervisor - Total duration: 408ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 408ms - Times executed: 1 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-18 09:06:34 Duration: 408ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,927 463ms 0ms 14ms 0ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 18 11 1,927 463ms 0ms [ User: a3dsupervisor - Total duration: 463ms - Times executed: 1927 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 463ms - Times executed: 1927 ]
-
COMMIT;
Date: 2025-11-18 10:09:23 Duration: 14ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 10:04:04 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 10:09:33 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1,585 57ms 0ms 0ms 0ms begin read only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 18 11 1,585 57ms 0ms [ User: a3dsupervisor - Total duration: 57ms - Times executed: 1585 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 57ms - Times executed: 1585 ]
-
BEGIN READ ONLY;
Date: 2025-11-18 10:08:48 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-18 10:04:59 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-18 10:07:46 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
3 886 44ms 0ms 4ms 0ms select gotrcap1_0.att_template_category_num_id, gotrcap1_0.obj_template_num_id, gotrcap1_0.obj_template_rel_cat_att_order from gtp_obj_template_rel_cat_att gotrcap1_0 where gotrcap1_0.obj_template_num_id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 18 11 886 44ms 0ms [ User: a3dsupervisor - Total duration: 44ms - Times executed: 886 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 44ms - Times executed: 886 ]
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ();
Date: 2025-11-18 10:03:08 Duration: 4ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ();
Date: 2025-11-18 10:03:08 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ();
Date: 2025-11-18 10:03:08 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 424 235ms 0ms 6ms 0ms select gatp1_0.att_template_num_id, gatp1_0.att_activated_unit, gatp1_0.att_template_a3d_num_id, gatp1_0.att_template_bim_activated, gatp1_0.att_template_creator, gatp1_0.att_template_date_format, gatp1_0.att_template_dcre, gatp1_0.att_template_default_value, gatp1_0.att_template_dmaj, gatp1_0.att_template_domain_code, gatp1_0.att_template_enum_num_id, gatp1_0.att_template_enum_parent, gatp1_0.att_template_line_wrap, gatp1_0.att_template_max, gatp1_0.att_template_min, gatp1_0.att_template_modifiable, gatp1_0.att_template_modifier, gatp1_0.att_template_name_fr, gatp1_0.att_template_obligatoire, gatp1_0.att_template_scale, gatp1_0.att_template_size, gatp1_0.att_template_tooltip, gatp1_0.att_template_unique_value, gatp1_0.att_unit_num_id, gatp1_0.unique_code, gatp1_0.workspace_num_id from gtp_att_template gatp1_0 where gatp1_0.att_template_a3d_num_id = and gatp1_0.workspace_num_id =;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 18 11 424 235ms 0ms [ User: a3dsupervisor - Total duration: 235ms - Times executed: 424 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 235ms - Times executed: 424 ]
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = and gatp1_0.WORKSPACE_NUM_ID =;
Date: 2025-11-18 10:03:00 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = and gatp1_0.WORKSPACE_NUM_ID =;
Date: 2025-11-18 10:07:46 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = and gatp1_0.WORKSPACE_NUM_ID =;
Date: 2025-11-18 10:03:03 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 343 9ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 18 10 1 0ms 0ms 11 342 9ms 0ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 343 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 342 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 1 ]
-
BEGIN;
Date: 2025-11-18 10:08:48 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-18 10:04:04 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-18 10:03:27 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
6 189 4ms 0ms 0ms 0ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 11 189 4ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 189 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-18 10:06:30 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-18 10:09:28 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-18 10:09:28 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 164 28ms 0ms 4ms 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 #7
Day Hour Count Duration Avg duration Nov 18 10 164 28ms 0ms [ User: a3dsupervisor - Total duration: 28ms - Times executed: 164 ]
[ Application: pg_dump - Total duration: 28ms - Times executed: 164 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2754432'::oid;
Date: 2025-11-18 09:06:03 Duration: 4ms Database: pentest 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 = '2596127'::oid;
Date: 2025-11-18 09:06:03 Duration: 0ms Database: pentest 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 = '2596158'::oid;
Date: 2025-11-18 09:06:03 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 152 11ms 0ms 5ms 0ms select gsbp1_0.setting_num_id, gsbp1_1.setting_code, gsbp1_1.setting_creator, gsbp1_1.setting_dcre, gsbp1_1.setting_dmaj, gsbp1_1.setting_modifier, gsbp1_1.setting_type, gsbp1_1.user_num_id, gsbp1_0.setting_value from gtp_setting_boolean gsbp1_0 join gtp_setting gsbp1_1 on gsbp1_0.setting_num_id = gsbp1_1.setting_num_id where gsbp1_1.user_num_id is null and gsbp1_1.setting_code = order by gsbp1_0.setting_num_id desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 11 152 11ms 0ms [ User: a3dsupervisor - Total duration: 11ms - Times executed: 152 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11ms - Times executed: 152 ]
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-18 10:03:04 Duration: 5ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-18 10:07:15 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-18 10:09:28 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 152 2ms 0ms 0ms 0ms select null, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 18 11 152 2ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 152 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2ms - Times executed: 152 ]
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-18 10:05:04 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-18 10:04:34 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-18 10:04:59 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 148 50ms 0ms 2ms 0ms select gotp1_0.obj_template_num_id, gotp1_0.component_num_id, gotp1_0.obj_template_b_valid, gotp1_0.obj_template_a3d_num_id, gotp1_0.obj_template_compo_version, gotp1_0.obj_template_creator, gotp1_0.obj_template_dcre, gotp1_0.obj_template_dmaj, gotp1_0.obj_template_icon_num_id, gotp1_0.obj_templ_instance_icon_num_id, gotp1_0.obj_template_modifier, gotp1_0.obj_template_name_fr, gotp1_0.obj_template_version, gotp1_0.unique_code, gotp1_0.workspace_num_id from gtp_obj_template gotp1_0 where gotp1_0.obj_template_a3d_num_id = and gotp1_0.workspace_num_id =;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 11 148 50ms 0ms [ User: a3dsupervisor - Total duration: 50ms - Times executed: 148 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 50ms - Times executed: 148 ]
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = and gotp1_0.WORKSPACE_NUM_ID =;
Date: 2025-11-18 10:03:00 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = and gotp1_0.WORKSPACE_NUM_ID =;
Date: 2025-11-18 10:07:45 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = and gotp1_0.WORKSPACE_NUM_ID =;
Date: 2025-11-18 10:07:46 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 125 23ms 0ms 1ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 10 125 23ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 125 ]
[ Application: pg_dump - Total duration: 23ms - Times executed: 125 ]
-
EXECUTE dumpFunc ('22092');
Date: 2025-11-18 09:06:02 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('22117');
Date: 2025-11-18 09:06:02 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('22132');
Date: 2025-11-18 09:06:02 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 124 8ms 0ms 3ms 0ms select nextval(?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 11 124 8ms 0ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 124 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8ms - Times executed: 124 ]
-
select nextval('S_BACKGROUND_TASK');
Date: 2025-11-18 10:04:04 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-11-18 10:05:00 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_THREAD_NUM_ID_SEQ');
Date: 2025-11-18 10:05:01 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 119 445ms 0ms 50ms 3ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 11 119 445ms 3ms [ User: a3dsupervisor - Total duration: 445ms - Times executed: 119 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 445ms - Times executed: 119 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 50ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 14ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 13ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 100 212ms 0ms 105ms 2ms select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 11 100 212ms 2ms [ User: a3dsupervisor - Total duration: 212ms - Times executed: 100 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 212ms - Times executed: 100 ]
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:03:06 Duration: 105ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:07:50 Duration: 70ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:03:06 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 100 4ms 0ms 0ms 0ms select pp1_0.property_name, pp1_0.property_comment, pp1_0.property_creator, pp1_0.property_dcre, pp1_0.property_dmaj, pp1_0.property_domain, pp1_0.property_modifier, pp1_0.property_value from property pp1_0 where pp1_0.property_name =;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 11 100 4ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 100 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 100 ]
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME =;
Date: 2025-11-18 10:09:36 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME =;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME =;
Date: 2025-11-18 10:09:36 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 78 2ms 0ms 0ms 0ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 11 78 2ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 78 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2ms - Times executed: 78 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-11-18 10:07:13 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-11-18 10:08:48 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-11-18 10:04:08 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 76 22ms 0ms 14ms 0ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 18 11 76 22ms 0ms [ User: a3dsupervisor - Total duration: 22ms - Times executed: 76 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22ms - Times executed: 76 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-18 10:04:04 Duration: 14ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-18 10:06:15 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-18 10:05:34 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 76 4ms 0ms 0ms 0ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 11 76 4ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 76 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 76 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-11-18 10:09:28 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-11-18 10:09:28 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-11-18 10:05:50 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 74 0ms 0ms 0ms 0ms select gotcrp1_0.rule_id, gotcrp1_0.att_template_category_num_id, gotcrp1_0.att_template_num_id, gotcrp1_0.else_condition, gotcrp1_0.formula, gotcrp1_0.label, gotcrp1_0.obj_template_num_id, gotcrp1_0.parent_rule_id, gotcrp1_0.rule_order from gtp_obj_template_calculation_rule gotcrp1_0 where ? = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 11 74 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 74 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 74 ]
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0 where 1 = 0;
Date: 2025-11-18 10:06:20 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0 where 1 = 0;
Date: 2025-11-18 10:09:33 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0 where 1 = 0;
Date: 2025-11-18 10:09:33 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 50 1ms 0ms 0ms 0ms set session statement_timeout to ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 18 01 5 0ms 0ms 02 5 0ms 0ms 03 5 0ms 0ms 04 5 0ms 0ms 05 5 0ms 0ms 06 5 0ms 0ms 07 5 0ms 0ms 08 5 0ms 0ms 09 5 0ms 0ms 10 5 0ms 0ms [ User: azuresu - Total duration: 1ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 1ms - Times executed: 50 ]
-
set session statement_timeout to 60000;
Date: 2025-11-18 03:11:52 Duration: 0ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 120000;
Date: 2025-11-18 01:41:47 Duration: 0ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 120000;
Date: 2025-11-18 04:41:57 Duration: 0ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 9s344ms 9s344ms 9s344ms 1 9s344ms 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 #1
Day Hour Count Duration Avg duration Nov 18 10 1 9s344ms 9s344ms [ User: a3dsupervisor - Total duration: 9s344ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s344ms - Times executed: 1 ]
-
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-11-18 09:06:34 Duration: 9s344ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 9s91ms 9s91ms 9s91ms 1 9s91ms 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 #2
Day Hour Count Duration Avg duration Nov 18 10 1 9s91ms 9s91ms [ User: a3dsupervisor - Total duration: 9s91ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s91ms - Times executed: 1 ]
-
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-11-18 09:06:20 Duration: 9s91ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 6s586ms 6s586ms 6s586ms 1 6s586ms 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 #3
Day Hour Count Duration Avg duration Nov 18 10 1 6s586ms 6s586ms [ User: a3dsupervisor - Total duration: 6s586ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 6s586ms - Times executed: 1 ]
-
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-11-18 09:06:41 Duration: 6s586ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 5s214ms 5s214ms 5s214ms 1 5s214ms 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 #4
Day Hour Count Duration Avg duration Nov 18 10 1 5s214ms 5s214ms [ User: a3dsupervisor - Total duration: 5s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s214ms - Times executed: 1 ]
-
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-11-18 09:06:49 Duration: 5s214ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 1s512ms 1s512ms 1s512ms 1 1s512ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 18 10 1 1s512ms 1s512ms [ User: a3dsupervisor - Total duration: 1s512ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s512ms - Times executed: 1 ]
-
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-11-18 09:06:24 Duration: 1s512ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 1s237ms 1s237ms 1s237ms 1 1s237ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 10 1 1s237ms 1s237ms [ User: a3dsupervisor - Total duration: 1s237ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s237ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-18 09:06:21 Duration: 1s237ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 1s209ms 1s209ms 1s209ms 1 1s209ms copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 18 10 1 1s209ms 1s209ms [ User: a3dsupervisor - Total duration: 1s209ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s209ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-18 09:06:11 Duration: 1s209ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1s161ms 1s161ms 1s161ms 1 1s161ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 10 1 1s161ms 1s161ms [ User: a3dsupervisor - Total duration: 1s161ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s161ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-18 09:06:09 Duration: 1s161ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 828ms 828ms 828ms 1 828ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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 #9
Day Hour Count Duration Avg duration Nov 18 10 1 828ms 828ms [ User: a3dsupervisor - Total duration: 828ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 828ms - Times executed: 1 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-11-18 09:06:49 Duration: 828ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 680ms 680ms 680ms 1 680ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 10 1 680ms 680ms [ User: a3dsupervisor - Total duration: 680ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 680ms - Times executed: 1 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-18 09:06:43 Duration: 680ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 650ms 650ms 650ms 1 650ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 10 1 650ms 650ms [ User: a3dsupervisor - Total duration: 650ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 650ms - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-18 09:06:07 Duration: 650ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 558ms 558ms 558ms 1 558ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 10 1 558ms 558ms [ User: a3dsupervisor - Total duration: 558ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 558ms - Times executed: 1 ]
-
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-11-18 09:06:41 Duration: 558ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 544ms 544ms 544ms 1 544ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 10 1 544ms 544ms [ User: a3dsupervisor - Total duration: 544ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 544ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-11-18 09:06:07 Duration: 544ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 476ms 476ms 476ms 1 476ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 10 1 476ms 476ms [ User: a3dsupervisor - Total duration: 476ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 476ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-11-18 09:06:08 Duration: 476ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 425ms 425ms 425ms 1 425ms copy public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 10 1 425ms 425ms [ User: a3dsupervisor - Total duration: 425ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 425ms - Times executed: 1 ]
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-11-18 09:06:24 Duration: 425ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 408ms 408ms 408ms 1 408ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 10 1 408ms 408ms [ User: a3dsupervisor - Total duration: 408ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 408ms - Times executed: 1 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-18 09:06:34 Duration: 408ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 63ms 669ms 366ms 2 732ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 18 11 2 732ms 366ms [ User: a3dsupervisor - Total duration: 732ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 732ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-18 10:04:04 Duration: 669ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-18 10:08:48 Duration: 63ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 12ms 21ms 13ms 45 625ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 08 3 53ms 17ms 09 8 107ms 13ms 10 24 323ms 13ms 11 10 141ms 14ms [ User: a3dsupervisor - Total duration: 625ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 625ms - Times executed: 45 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 10:02:13 Duration: 21ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 07:40:36 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 07:51:56 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
19 0ms 50ms 3ms 119 445ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 11 119 445ms 3ms [ User: a3dsupervisor - Total duration: 445ms - Times executed: 119 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 445ms - Times executed: 119 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 50ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 14ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-18 10:05:00 Duration: 13ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 105ms 2ms 100 212ms select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 18 11 100 212ms 2ms [ User: a3dsupervisor - Total duration: 212ms - Times executed: 100 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 212ms - Times executed: 100 ]
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:03:06 Duration: 105ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:07:50 Duration: 70ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-18 10:03:06 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 146ms 45 1ms 32ms 3ms 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 Nov 18 08 3 68ms 22ms 09 8 19ms 2ms 10 24 41ms 1ms 11 10 17ms 1ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 23ms - Times executed: 45 ]
-
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-11-18 07:51:56 Duration: 32ms Database: pentest User: pentest 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-11-18 07:40:36 Duration: 28ms Database: pentest User: pentest 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-11-18 07:43:51 Duration: 7ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 85ms 20 1ms 30ms 4ms SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 00 2 2ms 1ms 01 2 2ms 1ms 02 2 2ms 1ms 03 2 2ms 1ms 04 2 2ms 1ms 05 2 2ms 1ms 06 2 2ms 1ms 07 2 8ms 4ms 08 2 47ms 23ms 09 2 9ms 4ms [ User: azuresu - Total duration: 101ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 101ms - Times executed: 20 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-18 08:12:09 Duration: 30ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-18 08:42:11 Duration: 16ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-18 07:42:07 Duration: 6ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
3 81ms 45 0ms 13ms 1ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 07 3 32ms 10ms 08 8 17ms 2ms 09 24 21ms 0ms 10 10 10ms 1ms [ User: a3dsupervisor - Total duration: 403ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 403ms - Times executed: 45 ]
-
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-11-18 07:51:56 Duration: 13ms Database: pentest User: pentest 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-11-18 08:42:12 Duration: 11ms Database: pentest User: pentest 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-11-18 07:40:36 Duration: 10ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 58ms 45 0ms 10ms 1ms 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 #4
Day Hour Count Duration Avg duration 07 3 26ms 8ms 08 8 11ms 1ms 09 24 13ms 0ms 10 10 6ms 0ms [ User: a3dsupervisor - Total duration: 15ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 15ms - Times executed: 45 ]
-
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-11-18 07:43:51 Duration: 10ms Database: pentest User: pentest 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-11-18 07:40:36 Duration: 9ms Database: pentest User: pentest 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-11-18 08:42:12 Duration: 7ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 57ms 45 0ms 13ms 1ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 07 3 27ms 9ms 08 8 7ms 0ms 09 24 16ms 0ms 10 10 6ms 0ms [ User: a3dsupervisor - Total duration: 383ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 383ms - Times executed: 45 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-11-18 07:51:56 Duration: 13ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-11-18 07:40:36 Duration: 12ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-11-18 08:42:12 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 27ms 45 0ms 4ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 07 3 7ms 2ms 08 8 7ms 0ms 09 24 9ms 0ms 10 10 3ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 45 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 08:42:12 Duration: 4ms Database: pentest User: pentest 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-11-18 07:40:36 Duration: 2ms Database: pentest User: pentest 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-11-18 07:51:56 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 25ms 45 0ms 4ms 0ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 07 3 10ms 3ms 08 8 3ms 0ms 09 24 6ms 0ms 10 10 4ms 0ms [ User: a3dsupervisor - Total duration: 306ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 306ms - Times executed: 45 ]
-
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-11-18 07:40:36 Duration: 4ms Database: pentest User: pentest 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-11-18 07:51:56 Duration: 4ms Database: pentest User: pentest 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-11-18 10:10:55 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 20ms 45 0ms 2ms 0ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 07 3 6ms 2ms 08 8 4ms 0ms 09 24 6ms 0ms 10 10 2ms 0ms [ User: a3dsupervisor - Total duration: 625ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 625ms - Times executed: 45 ]
-
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-11-18 07:40:36 Duration: 2ms Database: pentest User: pentest 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-11-18 07:43:51 Duration: 2ms Database: pentest User: pentest 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-11-18 08:42:12 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
9 15ms 10 1ms 2ms 1ms select gop1_0.OBJ_NUM_ID, gop1_0.OBJ_CREATOR, gop1_0.OBJ_DCRE, gop1_0.OBJ_DMAJ, gop1_0.OBJ_MODIFIER, gop1_0.OBJ_NAME_FR, gop1_0.OBJ_STATE, gop1_0.OBJ_STATUS, gop1_0.OBJ_TEMPLATE_NUM_ID, gop1_0.OBJ_B_VALID, gop1_0.OBJ_VERSION from GTP_OBJ gop1_0 where gop1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 10 10 15ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 10 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 10 ]
-
select gop1_0.OBJ_NUM_ID, gop1_0.OBJ_CREATOR, gop1_0.OBJ_DCRE, gop1_0.OBJ_DMAJ, gop1_0.OBJ_MODIFIER, gop1_0.OBJ_NAME_FR, gop1_0.OBJ_STATE, gop1_0.OBJ_STATUS, gop1_0.OBJ_TEMPLATE_NUM_ID, gop1_0.OBJ_B_VALID, gop1_0.OBJ_VERSION from GTP_OBJ gop1_0 where gop1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);
Date: 2025-11-18 10:07:59 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gop1_0.OBJ_NUM_ID, gop1_0.OBJ_CREATOR, gop1_0.OBJ_DCRE, gop1_0.OBJ_DMAJ, gop1_0.OBJ_MODIFIER, gop1_0.OBJ_NAME_FR, gop1_0.OBJ_STATE, gop1_0.OBJ_STATUS, gop1_0.OBJ_TEMPLATE_NUM_ID, gop1_0.OBJ_B_VALID, gop1_0.OBJ_VERSION from GTP_OBJ gop1_0 where gop1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);
Date: 2025-11-18 10:07:50 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gop1_0.OBJ_NUM_ID, gop1_0.OBJ_CREATOR, gop1_0.OBJ_DCRE, gop1_0.OBJ_DMAJ, gop1_0.OBJ_MODIFIER, gop1_0.OBJ_NAME_FR, gop1_0.OBJ_STATE, gop1_0.OBJ_STATUS, gop1_0.OBJ_TEMPLATE_NUM_ID, gop1_0.OBJ_B_VALID, gop1_0.OBJ_VERSION from GTP_OBJ gop1_0 where gop1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);
Date: 2025-11-18 10:08:00 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
10 13ms 8 1ms 2ms 1ms select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 10 8 13ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 8 ]
-
select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);
Date: 2025-11-18 10:03:17 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);
Date: 2025-11-18 10:07:52 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gocp1_0.OBJ_COMPO_NUM_ID, gocp1_0.OBJ_COMPO_CREATOR, gocp1_0.OBJ_COMPO_DCRE, gocp1_0.OBJ_COMPO_DMAJ, gocp1_0.OBJ_COMPO_LIGNE_TAB_NUM_ID, gocp1_0.OBJ_COMPO_MODIFIER, gocp1_0.OBJ_COMPO_NUM_ID_TAB, gocp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gocp1_0.ATT_TEMPLATE_NUM_ID, gocp1_0.OBJ_COMPO_UNIT_NUM_ID, gocp1_0.OBJ_COMPO_VALUE, gocp1_0.OBJ_NUM_ID from GTP_OBJ_COMPOSITION gocp1_0 where gocp1_0.OBJ_NUM_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000);
Date: 2025-11-18 10:08:00 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
11 12ms 10 0ms 4ms 1ms SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 2ms 2ms 08 1 4ms 4ms 09 1 2ms 2ms [ User: azuresu - Total duration: 12ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 12ms - Times executed: 10 ]
-
SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');
Date: 2025-11-18 08:42:11 Duration: 4ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');
Date: 2025-11-18 07:42:07 Duration: 2ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');
Date: 2025-11-18 09:42:16 Duration: 2ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
12 12ms 2 0ms 11ms 6ms select * from information_schema.sequences;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 10 2 12ms 6ms [ User: a3dsupervisor - Total duration: 12ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12ms - Times executed: 2 ]
-
select * from information_schema.sequences;
Date: 2025-11-18 10:02:48 Duration: 11ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select * from information_schema.sequences;
Date: 2025-11-18 10:07:38 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 10ms 10 0ms 5ms 1ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 1ms 1ms 08 1 5ms 5ms 09 1 1ms 1ms [ User: azuresu - Total duration: 2ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 10 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-11-18 08:42:11 Duration: 5ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-11-18 09:42:16 Duration: 1ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-11-18 07:42:07 Duration: 1ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
14 8ms 16 0ms 5ms 0ms select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 10 16 8ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1ms - Times executed: 16 ]
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-11-18 10:02:59 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-11-18 10:07:44 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-11-18 10:03:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
15 7ms 15 0ms 5ms 0ms select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 10 15 7ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 15 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6ms - Times executed: 15 ]
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:03:00 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:07:46 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
16 6ms 2 0ms 6ms 3ms select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 10 2 6ms 3ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;
Date: 2025-11-18 10:03:00 Duration: 6ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
17 6ms 10 0ms 2ms 0ms SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 2ms 2ms 08 1 1ms 1ms 09 1 1ms 1ms [ User: azuresu - Total duration: 1ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1ms - Times executed: 10 ]
-
SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;
Date: 2025-11-18 07:42:07 Duration: 2ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;
Date: 2025-11-18 09:42:16 Duration: 1ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;
Date: 2025-11-18 08:42:11 Duration: 1ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
18 5ms 45 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 #18
Day Hour Count Duration Avg duration 07 3 0ms 0ms 08 8 0ms 0ms 09 24 2ms 0ms 10 10 1ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 45 ]
-
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-11-18 09:11:24 Duration: 0ms Database: pentest User: pentest 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-11-18 07:40:36 Duration: 0ms Database: pentest User: pentest 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-11-18 09:54:35 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
19 5ms 2 0ms 5ms 2ms SELECT VERSION, RELEASE_STATE FROM GTP_A3D_VERSION WHERE DATE_VERSION = ( SELECT MAX(DATE_VERSION) FROM GTP_A3D_VERSION) LIMIT 1;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 10 2 5ms 2ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
SELECT VERSION, RELEASE_STATE FROM GTP_A3D_VERSION WHERE DATE_VERSION = ( SELECT MAX(DATE_VERSION) FROM GTP_A3D_VERSION) LIMIT 1;
Date: 2025-11-18 10:03:03 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
SELECT VERSION, RELEASE_STATE FROM GTP_A3D_VERSION WHERE DATE_VERSION = ( SELECT MAX(DATE_VERSION) FROM GTP_A3D_VERSION) LIMIT 1;
Date: 2025-11-18 10:07:47 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 5ms 2 0ms 4ms 2ms select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 10 2 5ms 2ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;
Date: 2025-11-18 10:03:00 Duration: 4ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 102ms 20 1ms 22ms 5ms SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Nov 18 01 2 4ms 2ms 02 2 4ms 2ms 03 2 4ms 2ms 04 2 4ms 2ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 3ms 1ms 08 2 15ms 7ms 09 2 39ms 19ms 10 2 17ms 8ms [ User: azuresu - Total duration: 101ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 101ms - Times executed: 20 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-18 08:12:09 Duration: 22ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-18 08:42:11 Duration: 17ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-18 07:42:07 Duration: 13ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 74ms 45 0ms 14ms 1ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 07 3 32ms 10ms 08 8 13ms 1ms 09 24 18ms 0ms 10 10 10ms 1ms [ User: a3dsupervisor - Total duration: 403ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 403ms - Times executed: 45 ]
-
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-11-18 07:51:56 Duration: 14ms Database: pentest User: pentest 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-11-18 07:40:36 Duration: 12ms Database: pentest User: pentest 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-11-18 08:42:12 Duration: 8ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 66ms 45 0ms 11ms 1ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 07 3 23ms 7ms 08 8 8ms 1ms 09 24 24ms 1ms 10 10 9ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 23ms - Times executed: 45 ]
-
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-11-18 07:51:56 Duration: 11ms Database: pentest User: pentest 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-11-18 07:40:36 Duration: 10ms Database: pentest User: pentest 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-11-18 08:42:12 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 62ms 2 4ms 57ms 31ms select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 10 2 62ms 31ms [ User: a3dsupervisor - Total duration: 42ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 42ms - Times executed: 2 ]
-
select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;
Date: 2025-11-18 10:03:06 Duration: 57ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;
Date: 2025-11-18 10:07:50 Duration: 4ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
5 56ms 424 0ms 34ms 0ms select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 10 424 56ms 0ms [ User: a3dsupervisor - Total duration: 235ms - Times executed: 424 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 235ms - Times executed: 424 ]
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:03:00 Duration: 34ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:07:45 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
6 47ms 45 0ms 7ms 1ms 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 #6
Day Hour Count Duration Avg duration 07 3 18ms 6ms 08 8 9ms 1ms 09 24 14ms 0ms 10 10 5ms 0ms [ User: a3dsupervisor - Total duration: 15ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 15ms - Times executed: 45 ]
-
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-11-18 07:40:36 Duration: 7ms Database: pentest User: pentest 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-11-18 07:51:56 Duration: 6ms Database: pentest User: pentest 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-11-18 08:42:12 Duration: 4ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 39ms 148 0ms 28ms 0ms select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 10 148 39ms 0ms [ User: a3dsupervisor - Total duration: 50ms - Times executed: 148 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 50ms - Times executed: 148 ]
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:03:00 Duration: 28ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:07:46 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
8 36ms 2 0ms 36ms 18ms select gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_LIST_ORDER, gatevp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatevp1_0.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID, gatevp1_0.ICON_FILE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_IS_DEF, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_PARENT, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_STATUS, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_VALUE, gatevp1_0.EXT_CODE, gatevp1_0.UNIQUE_CODE from GTP_ATT_TEMPLATE_ENUM_VALUE gatevp1_0;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 10 2 36ms 18ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 2 ]
-
select gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_LIST_ORDER, gatevp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatevp1_0.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID, gatevp1_0.ICON_FILE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_IS_DEF, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_PARENT, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_STATUS, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_VALUE, gatevp1_0.EXT_CODE, gatevp1_0.UNIQUE_CODE from GTP_ATT_TEMPLATE_ENUM_VALUE gatevp1_0;
Date: 2025-11-18 10:03:00 Duration: 36ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_LIST_ORDER, gatevp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatevp1_0.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID, gatevp1_0.ICON_FILE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_IS_DEF, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_PARENT, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_STATUS, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_VALUE, gatevp1_0.EXT_CODE, gatevp1_0.UNIQUE_CODE from GTP_ATT_TEMPLATE_ENUM_VALUE gatevp1_0;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
9 36ms 45 0ms 6ms 0ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 07 3 15ms 5ms 08 8 6ms 0ms 09 24 11ms 0ms 10 10 3ms 0ms [ User: a3dsupervisor - Total duration: 625ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 625ms - Times executed: 45 ]
-
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-11-18 07:40:36 Duration: 6ms Database: pentest User: pentest 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-11-18 07:51:56 Duration: 5ms Database: pentest User: pentest 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-11-18 08:42:12 Duration: 3ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
10 36ms 2 0ms 36ms 18ms select gnttp1_0.NODE_TREE_TYPE_NUM_ID, gnttp1_0.VIEW_TEMPLATE_NUM_ID, gnttp1_0.LNK_TEMPLATE_NUM_ID, gnttp1_0.NODE_TREE_TYPE_A3D_NUM_ID, gnttp1_0.NODE_TREE_TYPE_NUM_ID_P, gnttp1_0.NODE_TREE_TYPE_POSITION, gnttp1_0.OBJ_TEMPLATE_NUM_ID, gnttp1_0.REL_SENS, gnttp1_0.REL_TEMPLATE_NUM_ID, gnttp1_0.REQUETE_V2_NUM_ID, gnttp1_0.TYPE_NODE_CODE from GTP_NODE_TREE_TYPE gnttp1_0;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 10 2 36ms 18ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3ms - Times executed: 2 ]
-
select gnttp1_0.NODE_TREE_TYPE_NUM_ID, gnttp1_0.VIEW_TEMPLATE_NUM_ID, gnttp1_0.LNK_TEMPLATE_NUM_ID, gnttp1_0.NODE_TREE_TYPE_A3D_NUM_ID, gnttp1_0.NODE_TREE_TYPE_NUM_ID_P, gnttp1_0.NODE_TREE_TYPE_POSITION, gnttp1_0.OBJ_TEMPLATE_NUM_ID, gnttp1_0.REL_SENS, gnttp1_0.REL_TEMPLATE_NUM_ID, gnttp1_0.REQUETE_V2_NUM_ID, gnttp1_0.TYPE_NODE_CODE from GTP_NODE_TREE_TYPE gnttp1_0;
Date: 2025-11-18 10:03:02 Duration: 36ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gnttp1_0.NODE_TREE_TYPE_NUM_ID, gnttp1_0.VIEW_TEMPLATE_NUM_ID, gnttp1_0.LNK_TEMPLATE_NUM_ID, gnttp1_0.NODE_TREE_TYPE_A3D_NUM_ID, gnttp1_0.NODE_TREE_TYPE_NUM_ID_P, gnttp1_0.NODE_TREE_TYPE_POSITION, gnttp1_0.OBJ_TEMPLATE_NUM_ID, gnttp1_0.REL_SENS, gnttp1_0.REL_TEMPLATE_NUM_ID, gnttp1_0.REQUETE_V2_NUM_ID, gnttp1_0.TYPE_NODE_CODE from GTP_NODE_TREE_TYPE gnttp1_0;
Date: 2025-11-18 10:07:45 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
11 36ms 886 0ms 8ms 0ms select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 10 886 36ms 0ms [ User: a3dsupervisor - Total duration: 44ms - Times executed: 886 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 44ms - Times executed: 886 ]
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);
Date: 2025-11-18 10:03:08 Duration: 8ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);
Date: 2025-11-18 10:07:51 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);
Date: 2025-11-18 10:03:19 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
12 32ms 100 0ms 21ms 0ms select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 10 100 32ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 100 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 100 ]
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-11-18 10:02:59 Duration: 21ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-11-18 10:07:44 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-11-18 10:09:36 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 31ms 2 1ms 29ms 15ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 10 2 31ms 15ms [ User: a3dsupervisor - Total duration: 732ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 732ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-18 10:04:04 Duration: 29ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-18 10:08:48 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
14 30ms 2 1ms 29ms 15ms DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = $1 AND (task.TASK_START_DATE + interval '1 day' * 3) < current_timestamp);Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 10 2 30ms 15ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6ms - Times executed: 2 ]
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = $1 AND (task.TASK_START_DATE + interval '1 day' * 3) < current_timestamp);
Date: 2025-11-18 10:03:04 Duration: 29ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = $1 AND (task.TASK_START_DATE + interval '1 day' * 3) < current_timestamp);
Date: 2025-11-18 10:07:47 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
15 29ms 2 0ms 29ms 14ms delete from GTP_LOG_EHCACHE where LOG_DATE < $1;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 10 2 29ms 14ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE < $1;
Date: 2025-11-18 10:03:04 Duration: 29ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
delete from GTP_LOG_EHCACHE where LOG_DATE < $1;
Date: 2025-11-18 10:07:48 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
16 27ms 2 0ms 26ms 13ms select gnp1_0.NODE_NUM_ID, gnp1_0.PROJECT_NUM_ID, gnp1_0.DATE_CREATION, gnp1_0.NODE_DMAJ, gnp1_0.NODE_MODIFIER, gnp1_0.NODE_NAME, gnp1_0.NODE_NUM_ID_PERE, gnp1_0.NODE_TO_REMOVE, gnp1_0.NODE_POSITION, gnp1_0.PROJECT_NUM_ID_PERE, gnp1_0.TYPE_NODE_CODE, gnp1_0.USER_NUM_ID from GED_NODE gnp1_0 where gnp1_0.NODE_TO_REMOVE = $1 and gnp1_0.TYPE_NODE_CODE = $2;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 10 2 27ms 13ms [ User: a3dsupervisor - Total duration: 64ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 64ms - Times executed: 2 ]
-
select gnp1_0.NODE_NUM_ID, gnp1_0.PROJECT_NUM_ID, gnp1_0.DATE_CREATION, gnp1_0.NODE_DMAJ, gnp1_0.NODE_MODIFIER, gnp1_0.NODE_NAME, gnp1_0.NODE_NUM_ID_PERE, gnp1_0.NODE_TO_REMOVE, gnp1_0.NODE_POSITION, gnp1_0.PROJECT_NUM_ID_PERE, gnp1_0.TYPE_NODE_CODE, gnp1_0.USER_NUM_ID from GED_NODE gnp1_0 where gnp1_0.NODE_TO_REMOVE = $1 and gnp1_0.TYPE_NODE_CODE = $2;
Date: 2025-11-18 10:04:05 Duration: 26ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gnp1_0.NODE_NUM_ID, gnp1_0.PROJECT_NUM_ID, gnp1_0.DATE_CREATION, gnp1_0.NODE_DMAJ, gnp1_0.NODE_MODIFIER, gnp1_0.NODE_NAME, gnp1_0.NODE_NUM_ID_PERE, gnp1_0.NODE_TO_REMOVE, gnp1_0.NODE_POSITION, gnp1_0.PROJECT_NUM_ID_PERE, gnp1_0.TYPE_NODE_CODE, gnp1_0.USER_NUM_ID from GED_NODE gnp1_0 where gnp1_0.NODE_TO_REMOVE = $1 and gnp1_0.TYPE_NODE_CODE = $2;
Date: 2025-11-18 10:08:48 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
17 27ms 1,927 0ms 5ms 0ms COMMIT;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 10 1,927 27ms 0ms [ User: a3dsupervisor - Total duration: 463ms - Times executed: 1927 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 463ms - Times executed: 1927 ]
-
COMMIT;
Date: 2025-11-18 10:03:00 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-11-18 10:03:01 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-11-18 10:07:45 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
18 25ms 2 0ms 24ms 12ms select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 10 2 25ms 12ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;
Date: 2025-11-18 10:03:00 Duration: 24ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;
Date: 2025-11-18 10:07:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
19 24ms 2 1ms 23ms 12ms UPDATE LOG_SESSION SET SESSION_STATUS = $1 WHERE SESSION_STATUS = $2 AND SERVER_ID = $3;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 10 2 24ms 12ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2ms - Times executed: 2 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = $1 WHERE SESSION_STATUS = $2 AND SERVER_ID = $3;
Date: 2025-11-18 10:03:04 Duration: 23ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
UPDATE LOG_SESSION SET SESSION_STATUS = $1 WHERE SESSION_STATUS = $2 AND SERVER_ID = $3;
Date: 2025-11-18 10:07:48 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 24ms 37 0ms 22ms 0ms select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 10 37 24ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 37 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 37 ]
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-11-18 10:04:34 Duration: 22ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-11-18 10:09:17 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-11-18 10:09:33 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 211,970 Log entries
Events distribution
Key values
- 0 PANIC entries
- 6 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 4 Max number of times the same event was reported
- 6 Total events found