pgBadger-
Global information
- Generated on Tue Oct 28 09:07:48 2025
- Log file: ././A3D-RND-REF/y=2025/m=10/d=27/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=10/d=27/h=23/m=00/PT1H.log
- Parsed 1,040,929 log entries in 6m7s
- Log start from 2025-10-27 00:10:25 to 2025-10-27 23:59:59
-
Overview
Global Stats
- 224 Number of unique normalized queries
- 415,248 Number of queries
- 1m3s Total query duration
- 2025-10-27 00:10:25 First query
- 2025-10-27 23:59:59 Last query
- 680 queries/s at 2025-10-27 18:25:18 Query peak
- 1m3s Total query duration
- 649ms Prepare/parse total duration
- 8s835ms Bind total duration
- 53s851ms Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 171 Total number of automatic analyzes
- 1 Number temporary file
- 4.20 MiB Max size of temporary file
- 4.20 MiB Average size of temporary file
- 80 Total number of sessions
- 3 sessions at 2025-10-27 21:28:15 Session peak
- 1h13m49s Total duration of sessions
- 55s372ms Average duration of sessions
- 5,190 Average queries per session
- 791ms Average queries duration per session
- 54s580ms Average idle time per session
- 82 Total number of connections
- 5 connections/s at 2025-10-27 18:25:05 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 680 queries/s Query Peak
- 2025-10-27 18:25:18 Date
SELECT Traffic
Key values
- 165 queries/s Query Peak
- 2025-10-27 21:05:24 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 259 queries/s Query Peak
- 2025-10-27 18:25:18 Date
Queries duration
Key values
- 1m3s 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) Oct 27 00 10 0ms 4ms 0ms 5ms 5ms 5ms 01 10 0ms 4ms 1ms 5ms 5ms 5ms 02 10 0ms 4ms 1ms 5ms 5ms 5ms 03 10 0ms 4ms 1ms 6ms 6ms 6ms 04 10 0ms 4ms 1ms 5ms 5ms 5ms 05 10 0ms 4ms 1ms 7ms 7ms 7ms 06 18 0ms 21ms 3ms 57ms 57ms 57ms 07 10 0ms 7ms 1ms 7ms 7ms 7ms 08 10 0ms 6ms 1ms 8ms 8ms 8ms 09 42 0ms 22ms 4ms 85ms 85ms 85ms 10 10 0ms 4ms 0ms 5ms 5ms 5ms 11 10 0ms 4ms 1ms 6ms 6ms 6ms 12 10 0ms 4ms 1ms 5ms 5ms 5ms 13 42 0ms 13ms 3ms 68ms 68ms 68ms 14 10 0ms 4ms 1ms 6ms 6ms 6ms 15 10 0ms 4ms 1ms 6ms 6ms 6ms 16 10 0ms 4ms 1ms 5ms 5ms 5ms 17 10 0ms 4ms 1ms 6ms 6ms 6ms 18 43,829 0ms 654ms 0ms 175ms 1s129ms 2s59ms 19 74,188 0ms 37ms 0ms 164ms 184ms 242ms 20 74,060 0ms 13ms 0ms 175ms 195ms 214ms 21 74,604 0ms 164ms 0ms 194ms 207ms 1s372ms 22 74,252 0ms 59ms 0ms 197ms 230ms 238ms 23 74,063 0ms 447ms 0ms 203ms 213ms 597ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 00 5 0 1ms 5ms 5ms 5ms 01 5 0 2ms 5ms 5ms 5ms 02 5 0 2ms 5ms 5ms 5ms 03 5 0 2ms 5ms 5ms 5ms 04 5 0 1ms 5ms 5ms 5ms 05 5 0 2ms 7ms 7ms 7ms 06 13 0 5ms 57ms 57ms 57ms 07 5 0 2ms 7ms 7ms 7ms 08 5 0 2ms 8ms 8ms 8ms 09 37 0 4ms 85ms 85ms 85ms 10 5 0 1ms 5ms 5ms 5ms 11 5 0 2ms 6ms 6ms 6ms 12 5 0 1ms 5ms 5ms 5ms 13 37 0 4ms 68ms 68ms 68ms 14 5 0 2ms 6ms 6ms 6ms 15 5 0 2ms 6ms 6ms 6ms 16 5 0 1ms 5ms 5ms 5ms 17 5 0 1ms 5ms 5ms 5ms 18 11,051 0 0ms 11ms 14ms 1s74ms 19 18,369 0 0ms 11ms 12ms 14ms 20 18,347 0 0ms 11ms 12ms 15ms 21 18,734 0 0ms 13ms 14ms 16ms 22 18,388 0 0ms 13ms 14ms 16ms 23 18,349 0 0ms 13ms 14ms 16ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 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 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 1,534 10 837 0 1ms 4ms 11ms 665ms 19 2,908 12 1,488 0 0ms 3ms 9ms 37ms 20 2,906 12 1,486 0 0ms 4ms 9ms 60ms 21 2,910 15 1,486 0 0ms 5ms 28ms 59ms 22 2,912 17 1,489 0 0ms 5ms 29ms 59ms 23 2,906 12 1,485 0 0ms 5ms 26ms 53ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 27 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 18 18 1.00 138.46% 07 10 10 1.00 200.00% 08 10 10 1.00 200.00% 09 42 42 1.00 113.51% 10 10 10 1.00 200.00% 11 10 10 1.00 200.00% 12 10 10 1.00 200.00% 13 42 42 1.00 113.51% 14 10 10 1.00 200.00% 15 10 10 1.00 200.00% 16 10 10 1.00 200.00% 17 10 10 1.00 200.00% 18 567 21,816 38.48 1.88% 19 129 36,973 286.61 0.25% 20 12 36,929 3,077.42 0.02% 21 233 37,355 160.32 0.45% 22 47 37,024 787.74 0.09% 23 23 36,933 1,605.78 0.05% Day Hour Count Average / Second Oct 27 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 3 0.00/s 07 2 0.00/s 08 2 0.00/s 09 6 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 6 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 10 0.00/s 19 14 0.00/s 20 6 0.00/s 21 2 0.00/s 22 2 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Oct 27 00 2 71ms 66ms 01 2 78ms 72ms 02 2 73ms 67ms 03 2 74ms 69ms 04 2 73ms 67ms 05 2 81ms 74ms 06 3 180ms 157ms 07 2 121ms 114ms 08 2 113ms 106ms 09 6 255ms 226ms 10 2 78ms 73ms 11 2 88ms 82ms 12 2 75ms 70ms 13 6 242ms 216ms 14 2 86ms 80ms 15 2 81ms 75ms 16 2 82ms 76ms 17 2 76ms 71ms 18 8 5m11s 5m10s 19 14 1m53s 1m53s 20 6 42s90ms 40s689ms 21 2 72ms 0ms 22 2 76ms 0ms 23 3 29s413ms 26s283ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2025-10-27 18:25:05 Date
Connections per database
Key values
- pentest Main Database
- 82 connections Total
Connections per user
Key values
- azuresu Main User
- 82 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2025-10-27 21:28:15 Date
Histogram of session times
Key values
- 57 0-500ms duration
Sessions per database
Key values
- pentest Main Database
- 80 sessions Total
Sessions per user
Key values
- azuresu Main User
- 80 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 80 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 4.20 MiB Temp Files size Peak
- 2025-10-27 18:25:23 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2025-10-27 18:25:23 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 1 4.20 MiB 4.20 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1 4.20 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-10-27 18:25:23 Duration: 322ms 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-10-27 18:25:23 Duration: 1ms 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-10-27 18:25:23 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-10-27 18:25:23 - 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 (167) Main table analyzed (database pentest)
- 171 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 Oct 27 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 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 17 19 0 31 20 0 30 21 0 31 22 0 31 23 0 31 - 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
- 103,400 Total read queries
- 182,719 Total write queries
Queries by database
Key values
- pentest Main database
- 415,248 Requests
- 53s851ms (pentest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 415,008 Requests
User Request type Count Duration a3dsupervisor Total 415,008 53s598ms delete 8,271 1s737ms insert 16,076 4s285ms others 215 221ms select 103,280 6s127ms tcl 158,294 38s213ms update 78 998ms azuresu Total 240 252ms others 120 4ms select 120 248ms Duration by user
Key values
- 53s598ms (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 415,008 53s598ms delete 8,271 1s737ms insert 16,076 4s285ms others 215 221ms select 103,280 6s127ms tcl 158,294 38s213ms update 78 998ms azuresu Total 240 252ms others 120 4ms select 120 248ms Queries by host
Key values
- 10.3.6.4 Main host
- 414,936 Requests
- 53s235ms (10.3.6.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 414,936 Requests
- 53s235ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-27 19:49:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 398,079 0-1ms duration
Slowest individual queries
Rank Duration Query 1 654ms 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-10-27 18:26:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 517ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-27 18:25:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 447ms COMMIT;[ Date: 2025-10-27 23:36:31 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 322ms select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;[ Date: 2025-10-27 18:25:23 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 164ms update GTP_OBJ_COMPOSITION set OBJ_COMPO_VALUE =, OBJ_COMPO_UNIT_NUM_ID =, OBJ_COMPO_DMAJ = current_timestamp, OBJ_COMPO_MODIFIER =, OBJ_COMPO_LIGNE_TAB_NUM_ID = where obj_compo_num_id =;[ Date: 2025-10-27 21:05:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 147ms call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);[ Date: 2025-10-27 18:26:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 145ms 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 = and gnp1_0.TYPE_NODE_CODE =;[ Date: 2025-10-27 18:26:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 105ms delete from GTP_LOG_JVM where LOG_DATE <;[ Date: 2025-10-27 18:25:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 99ms select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in (,,,,,,,,,) and gob.obj_status = 1 LIMIT 50000;[ Date: 2025-10-27 18:25:22 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 97ms select grvp1_0.REQUETE_V2_NUM_ID, grvp1_0.USER_NUM_ID, grvp1_0.USER_NUM_ID_MODIFIER, grvp1_0.REQUETE_V2_DATE_CREATION, grvp1_0.OBJ_TEMPLATE_NUM_ID, grvp1_0.REQUETE_V2_A3D_NUM_ID, grvp1_0.REQUETE_V2_COMMENT, grvp1_0.REQUETE_V2_GROUP_NUM_ID, grvp1_0.REQUETE_V2_HAVE_USER_CONDITION, grvp1_0.REQUETE_V2_NOM, grvp1_0.REQUETE_V2_VALUE, grvp1_0.UNIQUE_CODE, grvp1_0.REQUETE_V2_LAST_MODIF, grvp1_0.WORKSPACE_NUM_ID from GTP_REQUETE_V2 grvp1_0;[ Date: 2025-10-27 18:25:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 92ms delete from GTP_LOG_THREAD where LOG_DATE <;[ Date: 2025-10-27 18:25:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 91ms delete from GTP_LOG_SESSION where LOG_DATE <;[ Date: 2025-10-27 18:25:19 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 88ms insert into GTP_HISTORY_OBJ_COMPO (HISTORY_COMPO_ID, ACTION_NUM_ID, OBJ_NUM_ID, ATT_TEMPLATE_CATEGORY_NUM_ID, ATT_TEMPLATE_NUM_ID, CELL_COLUMN, CELL_LINE, ATT_NEW_VALUE, OBJ_COMPO_NEW_UNIT_NUM_ID, DISPLAYABLE_VALUE, ACTION_TYPE) values (nextval('S_HISTORY_OBJ_COMPO'),,,,,,,,,,);[ Date: 2025-10-27 21:05:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 88ms SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/741' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;[ Date: 2025-10-27 21:05:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 88ms delete from GTP_LOG_CONNECTION where LOG_DATE <;[ Date: 2025-10-27 18:25:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 84ms SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/424' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;[ Date: 2025-10-27 21:05:24 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 71ms select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in ();[ Date: 2025-10-27 21:05:24 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 59ms 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-10-27 22:26:19 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 48ms update GTP_OBJ set OBJ_NAME_FR =, OBJ_DMAJ = current_timestamp, OBJ_MODIFIER =, OBJ_B_VALID = 1 where obj_num_id =;[ Date: 2025-10-27 21:05:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 42ms COMMIT;[ Date: 2025-10-27 21:10:39 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 34s253ms 79,147 0ms 447ms 0ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 27 19 8,359 3s358ms 0ms 20 14,157 6s38ms 0ms 21 14,139 5s996ms 0ms 22 14,171 6s214ms 0ms 23 14,179 6s105ms 0ms 00 14,142 6s539ms 0ms [ User: a3dsupervisor - Total duration: 34s253ms - Times executed: 79147 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 34s253ms - Times executed: 79147 ]
-
COMMIT;
Date: 2025-10-27 23:36:31 Duration: 447ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 21:10:39 Duration: 42ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 23:37:01 Duration: 39ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3s232ms 60,892 0ms 3ms 0ms begin read only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 27 19 6,470 215ms 0ms 20 10,884 344ms 0ms 21 10,870 535ms 0ms 22 10,895 718ms 0ms 23 10,899 716ms 0ms 00 10,874 700ms 0ms [ User: a3dsupervisor - Total duration: 3s232ms - Times executed: 60892 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s232ms - Times executed: 60892 ]
-
BEGIN READ ONLY;
Date: 2025-10-27 19:32:04 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-27 22:15:27 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-27 23:14:33 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
3 2s619ms 7,854 0ms 39ms 0ms 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 #3
Day Hour Count Duration Avg duration Oct 27 19 714 644ms 0ms 20 1,428 272ms 0ms 21 1,428 361ms 0ms 22 1,428 424ms 0ms 23 1,428 471ms 0ms 00 1,428 445ms 0ms [ User: a3dsupervisor - Total duration: 2s619ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s619ms - Times executed: 7854 ]
-
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-10-27 18:30:00 Duration: 39ms 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-10-27 19:15:01 Duration: 18ms 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-10-27 18:30:00 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1s405ms 3,962 0ms 5ms 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 27 19 396 141ms 0ms 20 714 241ms 0ms 21 713 250ms 0ms 22 713 256ms 0ms 23 713 254ms 0ms 00 713 261ms 0ms [ User: a3dsupervisor - Total duration: 1s405ms - Times executed: 3962 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s405ms - Times executed: 3962 ]
-
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;
Date: 2025-10-27 18:25:18 Duration: 5ms 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;
Date: 2025-10-27 23:14:33 Duration: 4ms 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;
Date: 2025-10-27 23:42:19 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s232ms 7,922 0ms 4ms 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 #5
Day Hour Count Duration Avg duration Oct 27 19 791 89ms 0ms 20 1,428 146ms 0ms 21 1,426 212ms 0ms 22 1,425 260ms 0ms 23 1,427 266ms 0ms 00 1,425 257ms 0ms [ User: a3dsupervisor - Total duration: 1s232ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s232ms - Times executed: 7922 ]
-
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-10-27 18:26:19 Duration: 4ms 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-10-27 19:35:46 Duration: 3ms 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-10-27 20:12:20 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 727ms 18,255 0ms 5ms 0ms begin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 27 19 1,889 46ms 0ms 20 3,273 74ms 0ms 21 3,269 126ms 0ms 22 3,276 161ms 0ms 23 3,280 159ms 0ms 00 3,268 158ms 0ms [ User: a3dsupervisor - Total duration: 727ms - Times executed: 18255 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 727ms - Times executed: 18255 ]
-
BEGIN;
Date: 2025-10-27 20:25:11 Duration: 5ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-27 21:34:53 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-27 21:34:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
7 713ms 2 59ms 654ms 356ms 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 #7
Day Hour Count Duration Avg duration Oct 27 19 1 654ms 654ms 23 1 59ms 59ms [ User: a3dsupervisor - Total duration: 713ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 713ms - 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-10-27 18:26:20 Duration: 654ms 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-10-27 22:26:19 Duration: 59ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 659ms 15,854 0ms 7ms 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 Oct 27 19 1,582 64ms 0ms 20 2,856 105ms 0ms 21 2,852 103ms 0ms 22 2,861 127ms 0ms 23 2,853 133ms 0ms 00 2,850 124ms 0ms [ User: a3dsupervisor - Total duration: 659ms - Times executed: 15854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 659ms - Times executed: 15854 ]
-
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-10-27 18:25:19 Duration: 7ms 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-10-27 23:07:43 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-10-27 22:40:51 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 549ms 7,922 0ms 2ms 0ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 27 19 791 36ms 0ms 20 1,428 59ms 0ms 21 1,426 93ms 0ms 22 1,425 123ms 0ms 23 1,427 121ms 0ms 00 1,425 114ms 0ms [ User: a3dsupervisor - Total duration: 549ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 549ms - Times executed: 7922 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-10-27 21:28:29 Duration: 2ms 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-10-27 19:15:01 Duration: 2ms 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-10-27 21:13:41 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 532ms 19,805 0ms 3ms 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 #10
Day Hour Count Duration Avg duration Oct 27 19 1,977 52ms 0ms 20 3,570 84ms 0ms 21 3,565 91ms 0ms 22 3,563 104ms 0ms 23 3,568 103ms 0ms 00 3,562 96ms 0ms [ User: a3dsupervisor - Total duration: 532ms - Times executed: 19805 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 532ms - Times executed: 19805 ]
-
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-10-27 21:09:18 Duration: 3ms 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-10-27 18:36:20 Duration: 1ms 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-10-27 21:01:33 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 517ms 1 517ms 517ms 517ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 27 19 1 517ms 517ms [ User: a3dsupervisor - Total duration: 517ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 517ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-27 18:25:20 Duration: 517ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 341ms 50 0ms 322ms 6ms 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 #12
Day Hour Count Duration Avg duration Oct 27 19 50 341ms 6ms [ User: a3dsupervisor - Total duration: 341ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 341ms - Times executed: 50 ]
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-10-27 18:25:23 Duration: 322ms 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-10-27 18:25:23 Duration: 1ms 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-10-27 18:25:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 313ms 15,844 0ms 3ms 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 #13
Day Hour Count Duration Avg duration Oct 27 19 1,582 31ms 0ms 20 2,856 49ms 0ms 21 2,852 53ms 0ms 22 2,850 57ms 0ms 23 2,854 59ms 0ms 00 2,850 62ms 0ms [ User: a3dsupervisor - Total duration: 313ms - Times executed: 15844 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 313ms - Times executed: 15844 ]
-
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-10-27 23:31:12 Duration: 3ms 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-10-27 22:32:06 Duration: 2ms 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-10-27 19:57:32 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 249ms 26 0ms 88ms 9ms select ? as idpath, gor_0_0.content_num_id as obj_0, ? as rel_0, gor_0_0.container_num_id as obj_1, ? as rel_1, gor_0_1.content_num_id as obj_2 from gtp_relation gor_0_0 inner join gtp_obj gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.content_template_num_id = and gor_0_1.rel_template_num_id = and gor_0_1.container_num_id = gor_0_0.container_num_id) inner join gtp_obj gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id where gor_0_0.rel_template_num_id = and gor_0_0.content_num_id in (...) and gob_0_0.obj_status = ? and gob_0_1.obj_status = ? and gob_0_1.obj_state is null;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 27 22 26 249ms 9ms [ User: a3dsupervisor - Total duration: 249ms - Times executed: 26 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 249ms - Times executed: 26 ]
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/741' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:21 Duration: 88ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/424' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:24 Duration: 84ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/772' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:24 Duration: 21ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 216ms 48 4ms 7ms 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 ? else ? end)::bigint as tables_vacuumed, sum( case when last_autovacuum is not null then ? else ? end)::bigint as tables_autovacuumed, sum( case when last_analyze is not null then ? else ? end)::bigint as tables_analyzed, sum( case when last_autoanalyze is not null then ? else ? end)::bigint as tables_autoanalyzed from pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 27 01 2 8ms 4ms 02 2 8ms 4ms 03 2 8ms 4ms 04 2 8ms 4ms 05 2 8ms 4ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 11ms 5ms 09 2 10ms 5ms 10 2 8ms 4ms 11 2 8ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 9ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 8ms 4ms 18 2 8ms 4ms 19 2 8ms 4ms 20 2 8ms 4ms 21 2 8ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms [ User: azuresu - Total duration: 216ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 216ms - Times executed: 48 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 07:40:52 Duration: 7ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 08:10:55 Duration: 6ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 21:41:43 Duration: 4ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
16 209ms 9 4ms 71ms 23ms select bcep1_0.element_num_id, bcep1_0.right_num_id, bcep1_0.right_mode, bcep1_0.update_date, bcep1_0.update_user_num_id from bdc_concerned_element bcep1_0 where bcep1_0.right_num_id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 27 22 9 209ms 23ms [ User: a3dsupervisor - Total duration: 209ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 209ms - Times executed: 9 ]
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in ();
Date: 2025-10-27 21:05:24 Duration: 71ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in (,);
Date: 2025-10-27 21:05:25 Duration: 36ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in (,);
Date: 2025-10-27 21:05:25 Duration: 34ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 208ms 6 10ms 147ms 34ms call pack_gtp_trigger.p_delete_gtp_obj_invalid (,);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 27 19 1 147ms 147ms 20 1 16ms 16ms 21 1 13ms 13ms 22 1 10ms 10ms 23 1 10ms 10ms 00 1 10ms 10ms [ User: a3dsupervisor - Total duration: 208ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 208ms - Times executed: 6 ]
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-10-27 18:26:20 Duration: 147ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-10-27 19:26:20 Duration: 16ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-10-27 20:26:20 Duration: 13ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 167ms 2 2ms 164ms 83ms update gtp_obj_composition set obj_compo_value =, obj_compo_unit_num_id =, obj_compo_dmaj = current_timestamp, obj_compo_modifier =, obj_compo_ligne_tab_num_id = where obj_compo_num_id =;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 27 22 1 164ms 164ms 23 1 2ms 2ms [ User: a3dsupervisor - Total duration: 167ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 167ms - Times executed: 2 ]
-
update GTP_OBJ_COMPOSITION set OBJ_COMPO_VALUE =, OBJ_COMPO_UNIT_NUM_ID =, OBJ_COMPO_DMAJ = current_timestamp, OBJ_COMPO_MODIFIER =, OBJ_COMPO_LIGNE_TAB_NUM_ID = where obj_compo_num_id =;
Date: 2025-10-27 21:05:21 Duration: 164ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
update GTP_OBJ_COMPOSITION set OBJ_COMPO_VALUE =, OBJ_COMPO_UNIT_NUM_ID =, OBJ_COMPO_DMAJ = current_timestamp, OBJ_COMPO_MODIFIER =, OBJ_COMPO_LIGNE_TAB_NUM_ID = where obj_compo_num_id =;
Date: 2025-10-27 22:25:24 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 166ms 67 2ms 11ms 2ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 27 19 7 25ms 3ms 20 12 28ms 2ms 21 12 28ms 2ms 22 12 28ms 2ms 23 12 28ms 2ms 00 12 27ms 2ms [ User: a3dsupervisor - Total duration: 166ms - Times executed: 67 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 166ms - Times executed: 67 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 18:26:20 Duration: 11ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 21:51:20 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 19:16:20 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 152ms 8,146 0ms 8ms 0ms select nextval(?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 27 19 743 35ms 0ms 20 1,480 11ms 0ms 21 1,480 18ms 0ms 22 1,481 32ms 0ms 23 1,481 25ms 0ms 00 1,481 28ms 0ms [ User: a3dsupervisor - Total duration: 152ms - Times executed: 8146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 152ms - Times executed: 8146 ]
-
select nextval('S_LOG_SESSION_ID');
Date: 2025-10-27 21:05:20 Duration: 8ms 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-10-27 18:30:00 Duration: 7ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-10-27 18:30:00 Duration: 7ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 79,147 34s253ms 0ms 447ms 0ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 27 19 8,359 3s358ms 0ms 20 14,157 6s38ms 0ms 21 14,139 5s996ms 0ms 22 14,171 6s214ms 0ms 23 14,179 6s105ms 0ms 00 14,142 6s539ms 0ms [ User: a3dsupervisor - Total duration: 34s253ms - Times executed: 79147 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 34s253ms - Times executed: 79147 ]
-
COMMIT;
Date: 2025-10-27 23:36:31 Duration: 447ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 21:10:39 Duration: 42ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 23:37:01 Duration: 39ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 60,892 3s232ms 0ms 3ms 0ms begin read only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 27 19 6,470 215ms 0ms 20 10,884 344ms 0ms 21 10,870 535ms 0ms 22 10,895 718ms 0ms 23 10,899 716ms 0ms 00 10,874 700ms 0ms [ User: a3dsupervisor - Total duration: 3s232ms - Times executed: 60892 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s232ms - Times executed: 60892 ]
-
BEGIN READ ONLY;
Date: 2025-10-27 19:32:04 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-27 22:15:27 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-27 23:14:33 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
3 19,805 532ms 0ms 3ms 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 #3
Day Hour Count Duration Avg duration Oct 27 19 1,977 52ms 0ms 20 3,570 84ms 0ms 21 3,565 91ms 0ms 22 3,563 104ms 0ms 23 3,568 103ms 0ms 00 3,562 96ms 0ms [ User: a3dsupervisor - Total duration: 532ms - Times executed: 19805 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 532ms - Times executed: 19805 ]
-
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-10-27 21:09:18 Duration: 3ms 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-10-27 18:36:20 Duration: 1ms 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-10-27 21:01:33 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 18,255 727ms 0ms 5ms 0ms begin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 27 19 1,889 46ms 0ms 20 3,273 74ms 0ms 21 3,269 126ms 0ms 22 3,276 161ms 0ms 23 3,280 159ms 0ms 00 3,268 158ms 0ms [ User: a3dsupervisor - Total duration: 727ms - Times executed: 18255 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 727ms - Times executed: 18255 ]
-
BEGIN;
Date: 2025-10-27 20:25:11 Duration: 5ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-27 21:34:53 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-27 21:34:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
5 15,854 659ms 0ms 7ms 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 #5
Day Hour Count Duration Avg duration Oct 27 19 1,582 64ms 0ms 20 2,856 105ms 0ms 21 2,852 103ms 0ms 22 2,861 127ms 0ms 23 2,853 133ms 0ms 00 2,850 124ms 0ms [ User: a3dsupervisor - Total duration: 659ms - Times executed: 15854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 659ms - Times executed: 15854 ]
-
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-10-27 18:25:19 Duration: 7ms 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-10-27 23:07:43 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-10-27 22:40:51 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 15,844 313ms 0ms 3ms 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 #6
Day Hour Count Duration Avg duration Oct 27 19 1,582 31ms 0ms 20 2,856 49ms 0ms 21 2,852 53ms 0ms 22 2,850 57ms 0ms 23 2,854 59ms 0ms 00 2,850 62ms 0ms [ User: a3dsupervisor - Total duration: 313ms - Times executed: 15844 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 313ms - Times executed: 15844 ]
-
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-10-27 23:31:12 Duration: 3ms 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-10-27 22:32:06 Duration: 2ms 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-10-27 19:57:32 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 8,146 152ms 0ms 8ms 0ms select nextval(?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 27 19 743 35ms 0ms 20 1,480 11ms 0ms 21 1,480 18ms 0ms 22 1,481 32ms 0ms 23 1,481 25ms 0ms 00 1,481 28ms 0ms [ User: a3dsupervisor - Total duration: 152ms - Times executed: 8146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 152ms - Times executed: 8146 ]
-
select nextval('S_LOG_SESSION_ID');
Date: 2025-10-27 21:05:20 Duration: 8ms 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-10-27 18:30:00 Duration: 7ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-10-27 18:30:00 Duration: 7ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 7,922 1s232ms 0ms 4ms 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 #8
Day Hour Count Duration Avg duration Oct 27 19 791 89ms 0ms 20 1,428 146ms 0ms 21 1,426 212ms 0ms 22 1,425 260ms 0ms 23 1,427 266ms 0ms 00 1,425 257ms 0ms [ User: a3dsupervisor - Total duration: 1s232ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s232ms - Times executed: 7922 ]
-
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-10-27 18:26:19 Duration: 4ms 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-10-27 19:35:46 Duration: 3ms 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-10-27 20:12:20 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 7,922 549ms 0ms 2ms 0ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 27 19 791 36ms 0ms 20 1,428 59ms 0ms 21 1,426 93ms 0ms 22 1,425 123ms 0ms 23 1,427 121ms 0ms 00 1,425 114ms 0ms [ User: a3dsupervisor - Total duration: 549ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 549ms - Times executed: 7922 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-10-27 21:28:29 Duration: 2ms 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-10-27 19:15:01 Duration: 2ms 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-10-27 21:13:41 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 7,918 54ms 0ms 5ms 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 #10
Day Hour Count Duration Avg duration Oct 27 19 790 10ms 0ms 20 1,428 6ms 0ms 21 1,426 9ms 0ms 22 1,424 10ms 0ms 23 1,426 9ms 0ms 00 1,424 8ms 0ms [ User: a3dsupervisor - Total duration: 54ms - Times executed: 7918 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 54ms - Times executed: 7918 ]
-
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-10-27 18:26:54 Duration: 5ms 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-10-27 23:44:11 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-10-27 22:50:58 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 7,854 2s619ms 0ms 39ms 0ms 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 #11
Day Hour Count Duration Avg duration Oct 27 19 714 644ms 0ms 20 1,428 272ms 0ms 21 1,428 361ms 0ms 22 1,428 424ms 0ms 23 1,428 471ms 0ms 00 1,428 445ms 0ms [ User: a3dsupervisor - Total duration: 2s619ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s619ms - Times executed: 7854 ]
-
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-10-27 18:30:00 Duration: 39ms 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-10-27 19:15:01 Duration: 18ms 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-10-27 18:30:00 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 4,292 85ms 0ms 1ms 0ms select count(gotcratcp1_0.id) from gtp_obj_template_calcul_rule_att_to_compute gotcratcp1_0;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 27 19 428 8ms 0ms 20 774 14ms 0ms 21 773 13ms 0ms 22 772 17ms 0ms 23 773 16ms 0ms 00 772 15ms 0ms [ User: a3dsupervisor - Total duration: 85ms - Times executed: 4292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 85ms - Times executed: 4292 ]
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-10-27 22:58:32 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-10-27 19:18:37 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-10-27 21:24:18 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 4,018 140ms 0ms 6ms 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 #13
Day Hour Count Duration Avg duration Oct 27 19 418 20ms 0ms 20 720 23ms 0ms 21 720 23ms 0ms 22 720 25ms 0ms 23 720 23ms 0ms 00 720 23ms 0ms [ User: a3dsupervisor - Total duration: 140ms - Times executed: 4018 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 140ms - Times executed: 4018 ]
-
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-10-27 18:25:15 Duration: 6ms 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-10-27 19:57:10 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-10-27 20:26:10 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 3,963 78ms 0ms 1ms 0ms select goacrp1_0.action_num_id from gtp_obj_action_calcul_rule goacrp1_0 order by goacrp1_0.action_num_id fetch first rows only;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 27 19 395 8ms 0ms 20 714 13ms 0ms 21 713 12ms 0ms 22 714 15ms 0ms 23 714 13ms 0ms 00 713 14ms 0ms [ User: a3dsupervisor - Total duration: 78ms - Times executed: 3963 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 78ms - Times executed: 3963 ]
-
select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first rows only;
Date: 2025-10-27 21:49:02 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first rows only;
Date: 2025-10-27 19:40:18 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first rows only;
Date: 2025-10-27 19:26:57 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 3,963 29ms 0ms 0ms 0ms select ghodp1_0.action_num_id, ghodp1_0.obj_num_id, ghodp1_0.obj_name, ghodp1_0.obj_template_num_id, ghodp1_0.workspace_num_id from gtp_history_obj_deleted ghodp1_0 where ? = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 27 19 395 3ms 0ms 20 714 3ms 0ms 21 713 5ms 0ms 22 714 5ms 0ms 23 714 5ms 0ms 00 713 6ms 0ms [ User: a3dsupervisor - Total duration: 29ms - Times executed: 3963 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29ms - Times executed: 3963 ]
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-10-27 21:08:12 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-10-27 18:26:54 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-10-27 20:15:56 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 3,962 1s405ms 0ms 5ms 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;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 27 19 396 141ms 0ms 20 714 241ms 0ms 21 713 250ms 0ms 22 713 256ms 0ms 23 713 254ms 0ms 00 713 261ms 0ms [ User: a3dsupervisor - Total duration: 1s405ms - Times executed: 3962 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s405ms - Times executed: 3962 ]
-
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;
Date: 2025-10-27 18:25:18 Duration: 5ms 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;
Date: 2025-10-27 23:14:33 Duration: 4ms 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;
Date: 2025-10-27 23:42:19 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 3,961 99ms 0ms 2ms 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 queries #17
Day Hour Count Duration Avg duration Oct 27 19 395 9ms 0ms 20 714 16ms 0ms 21 713 16ms 0ms 22 713 19ms 0ms 23 713 17ms 0ms 00 713 21ms 0ms [ User: a3dsupervisor - Total duration: 99ms - Times executed: 3961 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 99ms - Times executed: 3961 ]
-
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-10-27 19:36:57 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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-10-27 23:20:21 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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-10-27 23:26:55 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 3,959 61ms 0ms 1ms 0ms select * from gtp_obj_template_calcul_rule_att_to_compute gccc order by ? limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 27 19 395 5ms 0ms 20 714 10ms 0ms 21 713 11ms 0ms 22 712 11ms 0ms 23 713 11ms 0ms 00 712 11ms 0ms [ User: a3dsupervisor - Total duration: 61ms - Times executed: 3959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 61ms - Times executed: 3959 ]
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-10-27 20:33:56 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-10-27 21:28:46 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-10-27 23:22:27 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 3,959 23ms 0ms 0ms 0ms select gotcrop1_0.att_template_category_num_id, gotcrop1_0.att_template_num_id, gotcrop1_0.obj_template_num_id, gotcrop1_0.auto_load, gotcrop1_0.automatic, gotcrop1_0.exec_on_creation, gotcrop1_0.manual_modification_allowed, gotcrop1_0.recalculation from gtp_obj_template_calculation_rule_options gotcrop1_0 where ? = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 27 19 395 2ms 0ms 20 714 4ms 0ms 21 713 3ms 0ms 22 712 3ms 0ms 23 713 4ms 0ms 00 712 4ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 3959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23ms - Times executed: 3959 ]
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-10-27 19:19:13 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-10-27 18:40:43 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-10-27 18:52:14 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,338 68ms 0ms 1ms 0ms select gbtp1_0.task_num_id, gbtp1_0.canceling_user_num_id, gbtp1_0.export_file_name, gbtp1_0.server_id, gbtp1_0.source_file_name, gbtp1_0.source_obj_num_id, gbtp1_0.task_active_status, gbtp1_0.task_create_date, gbtp1_0.task_current_progress, gbtp1_0.task_current_step, gbtp1_0.task_end_date, gbtp1_0.task_error_message, gbtp1_0.task_last_update, gbtp1_0.task_log, gbtp1_0.task_max_progress, gbtp1_0.task_max_step, gbtp1_0.task_origin, gbtp1_0.task_parameters, gbtp1_0.task_report, gbtp1_0.task_service_name, gbtp1_0.task_start_date, gbtp1_0.task_state, gbtp1_0.task_status, gbtp1_0.task_sub_type, gbtp1_0.user_num_id from gtp_background_task gbtp1_0 where gbtp1_0.task_status = and gbtp1_0.canceling_user_num_id is not null order by gbtp1_0.task_num_id desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 27 19 138 7ms 0ms 20 240 12ms 0ms 21 240 12ms 0ms 22 240 12ms 0ms 23 240 10ms 0ms 00 240 12ms 0ms [ User: a3dsupervisor - Total duration: 68ms - Times executed: 1338 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 68ms - Times executed: 1338 ]
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 21:13:18 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 23:51:51 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 20:21:01 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 517ms 517ms 517ms 1 517ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 27 19 1 517ms 517ms [ User: a3dsupervisor - Total duration: 517ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 517ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-27 18:25:20 Duration: 517ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 59ms 654ms 356ms 2 713ms 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 #2
Day Hour Count Duration Avg duration Oct 27 19 1 654ms 654ms 23 1 59ms 59ms [ User: a3dsupervisor - Total duration: 713ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 713ms - 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-10-27 18:26:20 Duration: 654ms 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-10-27 22:26:19 Duration: 59ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2ms 164ms 83ms 2 167ms update gtp_obj_composition set obj_compo_value =, obj_compo_unit_num_id =, obj_compo_dmaj = current_timestamp, obj_compo_modifier =, obj_compo_ligne_tab_num_id = where obj_compo_num_id =;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 27 22 1 164ms 164ms 23 1 2ms 2ms [ User: a3dsupervisor - Total duration: 167ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 167ms - Times executed: 2 ]
-
update GTP_OBJ_COMPOSITION set OBJ_COMPO_VALUE =, OBJ_COMPO_UNIT_NUM_ID =, OBJ_COMPO_DMAJ = current_timestamp, OBJ_COMPO_MODIFIER =, OBJ_COMPO_LIGNE_TAB_NUM_ID = where obj_compo_num_id =;
Date: 2025-10-27 21:05:21 Duration: 164ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
update GTP_OBJ_COMPOSITION set OBJ_COMPO_VALUE =, OBJ_COMPO_UNIT_NUM_ID =, OBJ_COMPO_DMAJ = current_timestamp, OBJ_COMPO_MODIFIER =, OBJ_COMPO_LIGNE_TAB_NUM_ID = where obj_compo_num_id =;
Date: 2025-10-27 22:25:24 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 10ms 147ms 34ms 6 208ms call pack_gtp_trigger.p_delete_gtp_obj_invalid (,);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 27 19 1 147ms 147ms 20 1 16ms 16ms 21 1 13ms 13ms 22 1 10ms 10ms 23 1 10ms 10ms 00 1 10ms 10ms [ User: a3dsupervisor - Total duration: 208ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 208ms - Times executed: 6 ]
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-10-27 18:26:20 Duration: 147ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-10-27 19:26:20 Duration: 16ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-10-27 20:26:20 Duration: 13ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 4ms 71ms 23ms 9 209ms select bcep1_0.element_num_id, bcep1_0.right_num_id, bcep1_0.right_mode, bcep1_0.update_date, bcep1_0.update_user_num_id from bdc_concerned_element bcep1_0 where bcep1_0.right_num_id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 27 22 9 209ms 23ms [ User: a3dsupervisor - Total duration: 209ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 209ms - Times executed: 9 ]
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in ();
Date: 2025-10-27 21:05:24 Duration: 71ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in (,);
Date: 2025-10-27 21:05:25 Duration: 36ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in (,);
Date: 2025-10-27 21:05:25 Duration: 34ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 88ms 9ms 26 249ms select ? as idpath, gor_0_0.content_num_id as obj_0, ? as rel_0, gor_0_0.container_num_id as obj_1, ? as rel_1, gor_0_1.content_num_id as obj_2 from gtp_relation gor_0_0 inner join gtp_obj gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.content_template_num_id = and gor_0_1.rel_template_num_id = and gor_0_1.container_num_id = gor_0_0.container_num_id) inner join gtp_obj gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id where gor_0_0.rel_template_num_id = and gor_0_0.content_num_id in (...) and gob_0_0.obj_status = ? and gob_0_1.obj_status = ? and gob_0_1.obj_state is null;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 27 22 26 249ms 9ms [ User: a3dsupervisor - Total duration: 249ms - Times executed: 26 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 249ms - Times executed: 26 ]
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/741' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:21 Duration: 88ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/424' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:24 Duration: 84ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/772' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = AND gor_0_1.rel_template_num_id = AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:24 Duration: 21ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 322ms 6ms 50 341ms 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 #7
Day Hour Count Duration Avg duration Oct 27 19 50 341ms 6ms [ User: a3dsupervisor - Total duration: 341ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 341ms - Times executed: 50 ]
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-10-27 18:25:23 Duration: 322ms 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-10-27 18:25:23 Duration: 1ms 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-10-27 18:25:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 4ms 7ms 4ms 48 216ms 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 ? else ? end)::bigint as tables_vacuumed, sum( case when last_autovacuum is not null then ? else ? end)::bigint as tables_autovacuumed, sum( case when last_analyze is not null then ? else ? end)::bigint as tables_analyzed, sum( case when last_autoanalyze is not null then ? else ? end)::bigint as tables_autoanalyzed from pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 27 01 2 8ms 4ms 02 2 8ms 4ms 03 2 8ms 4ms 04 2 8ms 4ms 05 2 8ms 4ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 11ms 5ms 09 2 10ms 5ms 10 2 8ms 4ms 11 2 8ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 9ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 8ms 4ms 18 2 8ms 4ms 19 2 8ms 4ms 20 2 8ms 4ms 21 2 8ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms [ User: azuresu - Total duration: 216ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 216ms - Times executed: 48 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 07:40:52 Duration: 7ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 08:10:55 Duration: 6ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 21:41:43 Duration: 4ms Database: pentest User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
9 2ms 11ms 2ms 67 166ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 27 19 7 25ms 3ms 20 12 28ms 2ms 21 12 28ms 2ms 22 12 28ms 2ms 23 12 28ms 2ms 00 12 27ms 2ms [ User: a3dsupervisor - Total duration: 166ms - Times executed: 67 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 166ms - Times executed: 67 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 18:26:20 Duration: 11ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 21:51:20 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 19:16:20 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 447ms 0ms 79,147 34s253ms commit;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 27 19 8,359 3s358ms 0ms 20 14,157 6s38ms 0ms 21 14,139 5s996ms 0ms 22 14,171 6s214ms 0ms 23 14,179 6s105ms 0ms 00 14,142 6s539ms 0ms [ User: a3dsupervisor - Total duration: 34s253ms - Times executed: 79147 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 34s253ms - Times executed: 79147 ]
-
COMMIT;
Date: 2025-10-27 23:36:31 Duration: 447ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 21:10:39 Duration: 42ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 23:37:01 Duration: 39ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 5ms 0ms 3,962 1s405ms 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;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 27 19 396 141ms 0ms 20 714 241ms 0ms 21 713 250ms 0ms 22 713 256ms 0ms 23 713 254ms 0ms 00 713 261ms 0ms [ User: a3dsupervisor - Total duration: 1s405ms - Times executed: 3962 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s405ms - Times executed: 3962 ]
-
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;
Date: 2025-10-27 18:25:18 Duration: 5ms 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;
Date: 2025-10-27 23:14:33 Duration: 4ms 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;
Date: 2025-10-27 23:42:19 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 39ms 0ms 7,854 2s619ms 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 #12
Day Hour Count Duration Avg duration Oct 27 19 714 644ms 0ms 20 1,428 272ms 0ms 21 1,428 361ms 0ms 22 1,428 424ms 0ms 23 1,428 471ms 0ms 00 1,428 445ms 0ms [ User: a3dsupervisor - Total duration: 2s619ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s619ms - Times executed: 7854 ]
-
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-10-27 18:30:00 Duration: 39ms 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-10-27 19:15:01 Duration: 18ms 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-10-27 18:30:00 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 4ms 0ms 7,922 1s232ms 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 #13
Day Hour Count Duration Avg duration Oct 27 19 791 89ms 0ms 20 1,428 146ms 0ms 21 1,426 212ms 0ms 22 1,425 260ms 0ms 23 1,427 266ms 0ms 00 1,425 257ms 0ms [ User: a3dsupervisor - Total duration: 1s232ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s232ms - Times executed: 7922 ]
-
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-10-27 18:26:19 Duration: 4ms 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-10-27 19:35:46 Duration: 3ms 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-10-27 20:12:20 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 2ms 0ms 7,922 549ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 27 19 791 36ms 0ms 20 1,428 59ms 0ms 21 1,426 93ms 0ms 22 1,425 123ms 0ms 23 1,427 121ms 0ms 00 1,425 114ms 0ms [ User: a3dsupervisor - Total duration: 549ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 549ms - Times executed: 7922 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-10-27 21:28:29 Duration: 2ms 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-10-27 19:15:01 Duration: 2ms 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-10-27 21:13:41 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 3ms 0ms 60,892 3s232ms begin read only;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 27 19 6,470 215ms 0ms 20 10,884 344ms 0ms 21 10,870 535ms 0ms 22 10,895 718ms 0ms 23 10,899 716ms 0ms 00 10,874 700ms 0ms [ User: a3dsupervisor - Total duration: 3s232ms - Times executed: 60892 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s232ms - Times executed: 60892 ]
-
BEGIN READ ONLY;
Date: 2025-10-27 19:32:04 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-27 22:15:27 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-27 23:14:33 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
16 0ms 1ms 0ms 1,338 68ms select gbtp1_0.task_num_id, gbtp1_0.canceling_user_num_id, gbtp1_0.export_file_name, gbtp1_0.server_id, gbtp1_0.source_file_name, gbtp1_0.source_obj_num_id, gbtp1_0.task_active_status, gbtp1_0.task_create_date, gbtp1_0.task_current_progress, gbtp1_0.task_current_step, gbtp1_0.task_end_date, gbtp1_0.task_error_message, gbtp1_0.task_last_update, gbtp1_0.task_log, gbtp1_0.task_max_progress, gbtp1_0.task_max_step, gbtp1_0.task_origin, gbtp1_0.task_parameters, gbtp1_0.task_report, gbtp1_0.task_service_name, gbtp1_0.task_start_date, gbtp1_0.task_state, gbtp1_0.task_status, gbtp1_0.task_sub_type, gbtp1_0.user_num_id from gtp_background_task gbtp1_0 where gbtp1_0.task_status = and gbtp1_0.canceling_user_num_id is not null order by gbtp1_0.task_num_id desc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 27 19 138 7ms 0ms 20 240 12ms 0ms 21 240 12ms 0ms 22 240 12ms 0ms 23 240 10ms 0ms 00 240 12ms 0ms [ User: a3dsupervisor - Total duration: 68ms - Times executed: 1338 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 68ms - Times executed: 1338 ]
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 21:13:18 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 23:51:51 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 20:21:01 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 7ms 0ms 15,854 659ms 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 #17
Day Hour Count Duration Avg duration Oct 27 19 1,582 64ms 0ms 20 2,856 105ms 0ms 21 2,852 103ms 0ms 22 2,861 127ms 0ms 23 2,853 133ms 0ms 00 2,850 124ms 0ms [ User: a3dsupervisor - Total duration: 659ms - Times executed: 15854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 659ms - Times executed: 15854 ]
-
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-10-27 18:25:19 Duration: 7ms 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-10-27 23:07:43 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-10-27 22:40:51 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 5ms 0ms 18,255 727ms begin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 27 19 1,889 46ms 0ms 20 3,273 74ms 0ms 21 3,269 126ms 0ms 22 3,276 161ms 0ms 23 3,280 159ms 0ms 00 3,268 158ms 0ms [ User: a3dsupervisor - Total duration: 727ms - Times executed: 18255 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 727ms - Times executed: 18255 ]
-
BEGIN;
Date: 2025-10-27 20:25:11 Duration: 5ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-27 21:34:53 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-27 21:34:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
19 0ms 6ms 0ms 4,018 140ms 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 #19
Day Hour Count Duration Avg duration Oct 27 19 418 20ms 0ms 20 720 23ms 0ms 21 720 23ms 0ms 22 720 25ms 0ms 23 720 23ms 0ms 00 720 23ms 0ms [ User: a3dsupervisor - Total duration: 140ms - Times executed: 4018 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 140ms - Times executed: 4018 ]
-
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-10-27 18:25:15 Duration: 6ms 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-10-27 19:57:10 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-10-27 20:26:10 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 3ms 0ms 19,805 532ms 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 #20
Day Hour Count Duration Avg duration Oct 27 19 1,977 52ms 0ms 20 3,570 84ms 0ms 21 3,565 91ms 0ms 22 3,563 104ms 0ms 23 3,568 103ms 0ms 00 3,562 96ms 0ms [ User: a3dsupervisor - Total duration: 532ms - Times executed: 19805 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 532ms - Times executed: 19805 ]
-
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-10-27 21:09:18 Duration: 3ms 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-10-27 18:36:20 Duration: 1ms 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-10-27 21:01:33 Duration: 1ms 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 128ms 48 1ms 36ms 2ms 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 #1
Day Hour Count Duration Avg duration Oct 27 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 2ms 1ms 08 2 37ms 18ms 09 2 26ms 13ms 10 2 2ms 1ms 11 2 2ms 1ms 12 2 3ms 1ms 13 2 2ms 1ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 5ms 2ms 17 2 2ms 1ms 18 2 2ms 1ms 19 2 2ms 1ms 20 2 2ms 1ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms [ User: azuresu - Total duration: 216ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 216ms - Times executed: 48 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 07:40:52 Duration: 36ms 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-10-27 08:10:55 Duration: 24ms 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-10-27 15:11:20 Duration: 3ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 34ms 9 0ms 16ms 3ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 06 1 16ms 16ms 09 4 14ms 3ms 13 4 3ms 0ms [ User: a3dsupervisor - Total duration: 94ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 94ms - Times executed: 9 ]
-
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-10-27 06:44:32 Duration: 16ms 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-10-27 09:07:42 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-10-27 09:45:59 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 29ms 9 1ms 10ms 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 #3
Day Hour Count Duration Avg duration 06 1 10ms 10ms 09 4 12ms 3ms 13 4 6ms 1ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 9 ]
-
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-10-27 06:44:32 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-10-27 09:07:42 Duration: 8ms 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-10-27 13:08:51 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 22ms 1 22ms 22ms 22ms select * from information_schema.sequences;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 18 1 22ms 22ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23ms - Times executed: 1 ]
-
select * from information_schema.sequences;
Date: 2025-10-27 18:25:06 Duration: 22ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
5 19ms 9 0ms 8ms 2ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 06 1 8ms 8ms 09 4 8ms 2ms 13 4 2ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 9 ]
-
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-10-27 06:44:32 Duration: 8ms 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-10-27 09:07:42 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-10-27 13:15:46 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 19ms 11 0ms 16ms 1ms 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 #6
Day Hour Count Duration Avg duration 18 6 18ms 3ms 21 5 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 11 ]
-
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-10-27 18:25:15 Duration: 16ms 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-10-27 18:25:16 Duration: 0ms 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-10-27 21:05:20 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
7 14ms 24 0ms 7ms 0ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming prepare #7
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 0ms 0ms 08 1 7ms 7ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: azuresu - Total duration: 2ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 24 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-10-27 08:10:55 Duration: 7ms 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-10-27 16:11:24 Duration: 0ms 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-10-27 01:10:29 Duration: 0ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
8 13ms 1 13ms 13ms 13ms 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 #8
Day Hour Count Duration Avg duration 18 1 13ms 13ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3ms - Times executed: 1 ]
-
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-10-27 18:25:16 Duration: 13ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
9 12ms 24 0ms 4ms 0ms 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 #9
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 0ms 0ms 08 1 4ms 4ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: azuresu - Total duration: 27ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 27ms - Times executed: 24 ]
-
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-10-27 08:10:55 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-10-27 15:11:20 Duration: 0ms 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-10-27 13:11:13 Duration: 0ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
10 10ms 9 0ms 3ms 1ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 06 1 3ms 3ms 09 4 4ms 1ms 13 4 2ms 0ms [ User: a3dsupervisor - Total duration: 58ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 58ms - Times executed: 9 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-27 06:44:32 Duration: 3ms 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-10-27 09:07:42 Duration: 2ms 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-10-27 09:45:59 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
11 10ms 9 0ms 4ms 1ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 06 1 4ms 4ms 09 4 4ms 1ms 13 4 1ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 9 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-27 06:44:32 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-10-27 09:07:42 Duration: 3ms 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-10-27 13:07:39 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 10ms 29 0ms 2ms 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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 18 20 4ms 0ms 19 9 5ms 0ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 29 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 29 ]
-
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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-10-27 19:05:01 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-10-27 19:15:01 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-10-27 19:03:45 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 9ms 2 0ms 9ms 4ms SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/741' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = $1 AND gor_0_1.rel_template_num_id = $2 AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = $3 AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 21 2 9ms 4ms [ User: a3dsupervisor - Total duration: 88ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 88ms - Times executed: 2 ]
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/741' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = $1 AND gor_0_1.rel_template_num_id = $2 AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = $3 AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:21 Duration: 9ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
SELECT /*+CURSOR_SHARING_EXACT*/ '/null-39/70-1173/741' as idPath, gor_0_0.content_num_id as obj_0, 39 as rel_0, gor_0_0.container_num_id as obj_1, 1173 as rel_1, gor_0_1.content_num_id as obj_2 FROM gtp_relation gor_0_0 INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_0.container_num_id inner join gtp_relation gor_0_1 on (gor_0_1.CONTENT_TEMPLATE_NUM_ID = $1 AND gor_0_1.rel_template_num_id = $2 AND gor_0_1.container_num_id = gor_0_0.container_num_id) INNER JOIN GTP_OBJ gob_0_1 on gob_0_1.obj_num_id = gor_0_1.content_num_id WHERE gor_0_0.rel_template_num_id = $3 AND gor_0_0.content_num_id in (511047) AND gob_0_0.obj_status = 1 AND gob_0_1.obj_status = 1 AND gob_0_1.OBJ_STATE IS NULL;
Date: 2025-10-27 21:05:27 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
14 9ms 2 0ms 9ms 4ms 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 prepare #14
Day Hour Count Duration Avg duration 18 1 9ms 9ms 22 1 0ms 0ms [ User: a3dsupervisor - Total duration: 145ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 145ms - 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-10-27 18:26:20 Duration: 9ms 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-10-27 22:26:19 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
15 9ms 1 9ms 9ms 9ms delete from tmp_file where TMP_FILE_INSERT_DATE < current_date - $1;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 18 1 9ms 9ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 1 ]
-
delete from tmp_file where TMP_FILE_INSERT_DATE < current_date - $1;
Date: 2025-10-27 18:26:19 Duration: 9ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
16 8ms 2 0ms 8ms 4ms select gwp1_0.WORKSPACE_NUM_ID, gwp1_0.USER_NUM_ID, gwp1_0.WORKSPACE_B_VALID, gwp1_0.WORKSPACE_DCRE, gwp1_0.WORKSPACE_NAME_FR, gwp1_0.WORKSPACE_SHORTNAME from GTP_WORKSPACE gwp1_0;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 18 2 8ms 4ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8ms - Times executed: 2 ]
-
select gwp1_0.WORKSPACE_NUM_ID, gwp1_0.USER_NUM_ID, gwp1_0.WORKSPACE_B_VALID, gwp1_0.WORKSPACE_DCRE, gwp1_0.WORKSPACE_NAME_FR, gwp1_0.WORKSPACE_SHORTNAME from GTP_WORKSPACE gwp1_0;
Date: 2025-10-27 18:25:16 Duration: 8ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gwp1_0.WORKSPACE_NUM_ID, gwp1_0.USER_NUM_ID, gwp1_0.WORKSPACE_B_VALID, gwp1_0.WORKSPACE_DCRE, gwp1_0.WORKSPACE_NAME_FR, gwp1_0.WORKSPACE_SHORTNAME from GTP_WORKSPACE gwp1_0;
Date: 2025-10-27 18:25:16 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
17 8ms 9 0ms 3ms 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 #17
Day Hour Count Duration Avg duration 06 1 3ms 3ms 09 4 3ms 0ms 13 4 1ms 0ms [ User: a3dsupervisor - Total duration: 139ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 139ms - Times executed: 9 ]
-
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-10-27 06:44:32 Duration: 3ms 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-10-27 09:07:42 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-10-27 09:45:45 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
18 7ms 6 0ms 7ms 1ms 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 #18
Day Hour Count Duration Avg duration 18 6 7ms 1ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 6 ]
-
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-10-27 18:25:16 Duration: 7ms 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-10-27 18:25:18 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-10-27 18:25:17 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
19 7ms 5 1ms 1ms 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 #19
Day Hour Count Duration Avg duration 18 5 7ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 5 ]
-
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-10-27 18:25: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-10-27 18:25:23 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-10-27 18:25:53 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 7ms 1 7ms 7ms 7ms SELECT ef.FILE_SRC_MD5, ef.FILE_SRC, ef.FILE_BIM6D FROM ENG_FILE ef WHERE FILE_SRC IS NOT NULL AND FILE_BIM6D IS NOT NULL AND FILE_SRC_MD5 NOT IN ( SELECT FILE_SRC_MD5 FROM ENG_DATA ed WHERE ef.FILE_SRC_MD5 = ed.FILE_SRC_MD5) ORDER BY ef.CONSULT_DATE DESC;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 18 1 7ms 7ms [ User: a3dsupervisor - Total duration: 13ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13ms - Times executed: 1 ]
-
SELECT ef.FILE_SRC_MD5, ef.FILE_SRC, ef.FILE_BIM6D FROM ENG_FILE ef WHERE FILE_SRC IS NOT NULL AND FILE_BIM6D IS NOT NULL AND FILE_SRC_MD5 NOT IN ( SELECT FILE_SRC_MD5 FROM ENG_DATA ed WHERE ef.FILE_SRC_MD5 = ed.FILE_SRC_MD5) ORDER BY ef.CONSULT_DATE DESC;
Date: 2025-10-27 18:26:19 Duration: 7ms 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 1s546ms 15,854 0ms 6ms 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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 27 19 1,582 122ms 0ms 20 2,856 184ms 0ms 21 2,852 250ms 0ms 22 2,861 331ms 0ms 23 2,853 340ms 0ms 00 2,850 316ms 0ms [ User: a3dsupervisor - Total duration: 659ms - Times executed: 15854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 659ms - Times executed: 15854 ]
-
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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-10-27 18:25:19 Duration: 6ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-10-27 22:25:01 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-10-27 19:05:01 Duration: 3ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
2 1s93ms 15,844 0ms 3ms 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 = $1;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 18 1,582 69ms 0ms 19 2,856 118ms 0ms 20 2,852 184ms 0ms 21 2,850 238ms 0ms 22 2,854 240ms 0ms 23 2,850 242ms 0ms [ User: a3dsupervisor - Total duration: 313ms - Times executed: 15844 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 313ms - Times executed: 15844 ]
-
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 = $1;
Date: 2025-10-27 19:49:33 Duration: 3ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1;
Date: 2025-10-27 20:45:53 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1;
Date: 2025-10-27 23:42:19 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
3 1s53ms 19,805 0ms 5ms 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 = $1;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 18 1,977 78ms 0ms 19 3,570 129ms 0ms 20 3,565 179ms 0ms 21 3,563 217ms 0ms 22 3,568 232ms 0ms 23 3,562 215ms 0ms [ User: a3dsupervisor - Total duration: 532ms - Times executed: 19805 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 532ms - Times executed: 19805 ]
-
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 = $1;
Date: 2025-10-27 19:18:58 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1;
Date: 2025-10-27 22:46:30 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 = $1;
Date: 2025-10-27 23:31:02 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
4 508ms 79,147 0ms 6ms 0ms COMMIT;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 18 8,359 55ms 0ms 19 14,157 94ms 0ms 20 14,139 87ms 0ms 21 14,171 90ms 0ms 22 14,179 90ms 0ms 23 14,142 91ms 0ms [ User: a3dsupervisor - Total duration: 34s253ms - Times executed: 79147 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 34s253ms - Times executed: 79147 ]
-
COMMIT;
Date: 2025-10-27 19:40:59 Duration: 6ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-10-27 23:27:10 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-10-27 20:03:45 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
5 331ms 7,854 0ms 0ms 0ms select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 18 714 13ms 0ms 19 1,428 25ms 0ms 20 1,428 52ms 0ms 21 1,428 80ms 0ms 22 1,428 79ms 0ms 23 1,428 79ms 0ms [ User: a3dsupervisor - Total duration: 115ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 115ms - Times executed: 7854 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-10-27 20:55:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-10-27 23:25:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-10-27 20:40:01 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
6 320ms 7,922 0ms 1ms 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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11);Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 18 791 34ms 0ms 19 1,428 59ms 0ms 20 1,426 56ms 0ms 21 1,425 57ms 0ms 22 1,427 56ms 0ms 23 1,425 55ms 0ms [ User: a3dsupervisor - Total duration: 1s232ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s232ms - Times executed: 7922 ]
-
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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11);
Date: 2025-10-27 21:06:11 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11);
Date: 2025-10-27 19:46:06 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11);
Date: 2025-10-27 19:43:25 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
7 289ms 4,292 0ms 7ms 0ms select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 18 428 33ms 0ms 19 774 33ms 0ms 20 773 46ms 0ms 21 772 61ms 0ms 22 773 58ms 0ms 23 772 56ms 0ms [ User: a3dsupervisor - Total duration: 85ms - Times executed: 4292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 85ms - Times executed: 4292 ]
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-10-27 18:26:49 Duration: 7ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-10-27 18:29:21 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-10-27 18:46:31 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
8 280ms 4,018 0ms 9ms 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 bind #8
Day Hour Count Duration Avg duration 18 418 35ms 0ms 19 720 40ms 0ms 20 720 46ms 0ms 21 720 54ms 0ms 22 720 53ms 0ms 23 720 50ms 0ms [ User: a3dsupervisor - Total duration: 140ms - Times executed: 4018 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 140ms - Times executed: 4018 ]
-
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-10-27 18:25:15 Duration: 9ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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-10-27 22:13:15 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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-10-27 21:32:15 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
9 230ms 7,918 0ms 1ms 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 1 = 0;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 18 790 16ms 0ms 19 1,428 27ms 0ms 20 1,426 37ms 0ms 21 1,424 50ms 0ms 22 1,426 51ms 0ms 23 1,424 46ms 0ms [ User: a3dsupervisor - Total duration: 54ms - Times executed: 7918 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 54ms - Times executed: 7918 ]
-
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-10-27 20:33:41 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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-10-27 21:09:08 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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-10-27 21:55:53 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
10 208ms 3,963 0ms 8ms 0ms select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first $1 rows only;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 18 395 23ms 0ms 19 714 20ms 0ms 20 713 31ms 0ms 21 714 44ms 0ms 22 714 44ms 0ms 23 713 43ms 0ms [ User: a3dsupervisor - Total duration: 78ms - Times executed: 3963 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 78ms - Times executed: 3963 ]
-
select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first $1 rows only;
Date: 2025-10-27 18:26:49 Duration: 8ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first $1 rows only;
Date: 2025-10-27 21:38:45 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first $1 rows only;
Date: 2025-10-27 22:03:05 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
11 183ms 7,922 0ms 0ms 0ms delete from APPLICATIVE_LOCK where LOCK_KEY = $1;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 18 791 21ms 0ms 19 1,428 33ms 0ms 20 1,426 32ms 0ms 21 1,425 31ms 0ms 22 1,427 31ms 0ms 23 1,425 33ms 0ms [ User: a3dsupervisor - Total duration: 549ms - Times executed: 7922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 549ms - Times executed: 7922 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY = $1;
Date: 2025-10-27 23:21:47 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
delete from APPLICATIVE_LOCK where LOCK_KEY = $1;
Date: 2025-10-27 18:39:52 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
delete from APPLICATIVE_LOCK where LOCK_KEY = $1;
Date: 2025-10-27 20:33:11 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
12 175ms 3,961 0ms 11ms 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 #12
Day Hour Count Duration Avg duration 18 395 26ms 0ms 19 714 21ms 0ms 20 713 31ms 0ms 21 713 32ms 0ms 22 713 32ms 0ms 23 713 31ms 0ms [ User: a3dsupervisor - Total duration: 99ms - Times executed: 3961 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 99ms - Times executed: 3961 ]
-
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-10-27 18:26:49 Duration: 11ms 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-10-27 20:30:24 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-10-27 20:40:25 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 155ms 1,338 0ms 1ms 0ms select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 18 138 17ms 0ms 19 240 25ms 0ms 20 240 23ms 0ms 21 240 29ms 0ms 22 240 28ms 0ms 23 240 30ms 0ms [ User: a3dsupervisor - Total duration: 68ms - Times executed: 1338 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 68ms - Times executed: 1338 ]
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 18:26:14 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 18:25:29 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-27 18:25:59 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
14 149ms 3,962 0ms 13ms 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;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 18 396 24ms 0ms 19 714 17ms 0ms 20 713 22ms 0ms 21 713 27ms 0ms 22 713 28ms 0ms 23 713 28ms 0ms [ User: a3dsupervisor - Total duration: 1s405ms - Times executed: 3962 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s405ms - Times executed: 3962 ]
-
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;
Date: 2025-10-27 18:25:18 Duration: 13ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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;
Date: 2025-10-27 23:27:55 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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;
Date: 2025-10-27 19:03:45 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
15 145ms 3,959 0ms 1ms 0ms SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 18 395 11ms 0ms 19 714 18ms 0ms 20 713 23ms 0ms 21 712 31ms 0ms 22 713 31ms 0ms 23 712 28ms 0ms [ User: a3dsupervisor - Total duration: 61ms - Times executed: 3959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 61ms - Times executed: 3959 ]
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-10-27 21:04:05 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-10-27 21:25:08 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-10-27 20:31:45 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
16 143ms 48 1ms 25ms 2ms 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 #16
Day Hour Count Duration Avg duration 00 2 3ms 1ms 01 2 4ms 2ms 02 2 4ms 2ms 03 2 3ms 1ms 04 2 3ms 1ms 05 2 3ms 1ms 06 2 4ms 2ms 07 2 27ms 13ms 08 2 25ms 12ms 09 2 3ms 1ms 10 2 3ms 1ms 11 2 4ms 2ms 12 2 3ms 1ms 13 2 5ms 2ms 14 2 4ms 2ms 15 2 3ms 1ms 16 2 4ms 2ms 17 2 3ms 1ms 18 2 3ms 1ms 19 2 3ms 1ms 20 2 4ms 2ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms [ User: azuresu - Total duration: 216ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 216ms - Times executed: 48 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-10-27 07:40:52 Duration: 25ms 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-10-27 08:10:55 Duration: 23ms 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-10-27 13:11:13 Duration: 3ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
17 133ms 7,854 0ms 0ms 0ms 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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 18 714 13ms 0ms 19 1,428 23ms 0ms 20 1,428 23ms 0ms 21 1,428 24ms 0ms 22 1,428 24ms 0ms 23 1,428 24ms 0ms [ User: a3dsupervisor - Total duration: 2s619ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s619ms - Times executed: 7854 ]
-
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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);
Date: 2025-10-27 18:35:01 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);
Date: 2025-10-27 23:10:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);
Date: 2025-10-27 22:35:01 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
18 125ms 3,963 0ms 8ms 0ms select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 18 395 18ms 0ms 19 714 16ms 0ms 20 713 20ms 0ms 21 714 22ms 0ms 22 714 24ms 0ms 23 713 22ms 0ms [ User: a3dsupervisor - Total duration: 29ms - Times executed: 3963 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29ms - Times executed: 3963 ]
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-10-27 18:26:49 Duration: 8ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-10-27 19:33:05 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-10-27 18:51:08 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
19 122ms 3,959 0ms 7ms 0ms select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 18 395 15ms 0ms 19 714 14ms 0ms 20 713 17ms 0ms 21 712 25ms 0ms 22 713 22ms 0ms 23 712 27ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 3959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23ms - Times executed: 3959 ]
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-10-27 18:26:49 Duration: 7ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-10-27 23:12:31 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-10-27 23:18:20 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 43ms 1 43ms 43ms 43ms select * from information_schema.sequences;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 18 1 43ms 43ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23ms - Times executed: 1 ]
-
select * from information_schema.sequences;
Date: 2025-10-27 18:25:07 Duration: 43ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
Events
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET