pgBadger-
Global information
- Generated on Tue Nov 4 09:07:29 2025
- Log file: ././A3D-RND-REF/y=2025/m=11/d=03/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=11/d=03/h=23/m=00/PT1H.log
- Parsed 1,038,859 log entries in 5m58s
- Log start from 2025-11-03 00:20:31 to 2025-11-03 23:59:59
-
Overview
Global Stats
- 149 Number of unique normalized queries
- 414,556 Number of queries
- 1m16s Total query duration
- 2025-11-03 00:20:31 First query
- 2025-11-03 23:59:59 Last query
- 571 queries/s at 2025-11-03 18:25:18 Query peak
- 1m16s Total query duration
- 1s96ms Prepare/parse total duration
- 10s876ms Bind total duration
- 1m4s 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
- 168 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
- 109 Total number of sessions
- 3 sessions at 2025-11-03 20:30:33 Session peak
- 1h8m31s Total duration of sessions
- 37s723ms Average duration of sessions
- 3,803 Average queries per session
- 697ms Average queries duration per session
- 37s25ms Average idle time per session
- 111 Total number of connections
- 5 connections/s at 2025-11-03 18:25:05 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 571 queries/s Query Peak
- 2025-11-03 18:25:18 Date
SELECT Traffic
Key values
- 151 queries/s Query Peak
- 2025-11-03 23:00:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 223 queries/s Query Peak
- 2025-11-03 18:25:18 Date
Queries duration
Key values
- 1m16s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 03 00 10 0ms 4ms 0ms 5ms 5ms 5ms 01 10 0ms 4ms 1ms 5ms 5ms 5ms 02 10 0ms 4ms 1ms 6ms 6ms 6ms 03 10 0ms 4ms 1ms 5ms 5ms 5ms 04 10 0ms 5ms 1ms 7ms 7ms 7ms 05 10 0ms 4ms 1ms 5ms 5ms 5ms 06 10 0ms 4ms 1ms 5ms 5ms 5ms 07 10 0ms 6ms 1ms 7ms 7ms 7ms 08 10 0ms 4ms 1ms 6ms 6ms 6ms 09 10 0ms 4ms 1ms 5ms 5ms 5ms 10 42 0ms 66ms 6ms 174ms 174ms 174ms 11 10 0ms 4ms 1ms 6ms 6ms 6ms 12 10 0ms 5ms 1ms 6ms 6ms 6ms 13 66 0ms 17ms 3ms 108ms 108ms 108ms 14 10 0ms 4ms 1ms 6ms 6ms 6ms 15 10 0ms 4ms 1ms 6ms 6ms 6ms 16 34 0ms 13ms 3ms 36ms 36ms 36ms 17 10 0ms 4ms 1ms 5ms 5ms 5ms 18 43,806 0ms 2s417ms 0ms 188ms 4s308ms 8s667ms 19 74,083 0ms 50ms 0ms 182ms 202ms 214ms 20 73,995 0ms 52ms 0ms 202ms 215ms 233ms 21 74,042 0ms 43ms 0ms 204ms 216ms 221ms 22 74,171 0ms 58ms 0ms 198ms 207ms 225ms 23 74,167 0ms 199ms 0ms 213ms 228ms 344ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 03 00 5 0 1ms 5ms 5ms 5ms 01 5 0 1ms 5ms 5ms 5ms 02 5 0 2ms 5ms 5ms 5ms 03 5 0 2ms 5ms 5ms 5ms 04 5 0 2ms 7ms 7ms 7ms 05 5 0 2ms 5ms 5ms 5ms 06 5 0 1ms 5ms 5ms 5ms 07 5 0 2ms 7ms 7ms 7ms 08 5 0 2ms 6ms 6ms 6ms 09 5 0 2ms 5ms 5ms 5ms 10 37 0 7ms 174ms 174ms 174ms 11 5 0 2ms 5ms 5ms 5ms 12 5 0 2ms 6ms 6ms 6ms 13 61 0 4ms 108ms 108ms 108ms 14 5 0 2ms 5ms 5ms 5ms 15 5 0 2ms 5ms 5ms 5ms 16 29 0 4ms 36ms 36ms 36ms 17 5 0 2ms 5ms 5ms 5ms 18 11,047 0 0ms 11ms 16ms 4s272ms 19 18,347 0 0ms 12ms 15ms 16ms 20 18,335 0 0ms 13ms 14ms 15ms 21 18,347 0 0ms 13ms 14ms 16ms 22 18,354 0 0ms 12ms 13ms 15ms 23 18,369 0 0ms 13ms 14ms 18ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 03 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,532 10 835 0 2ms 4ms 48ms 2s2ms 19 2,906 12 1,486 0 0ms 4ms 10ms 60ms 20 2,905 12 1,485 0 0ms 5ms 25ms 62ms 21 2,906 12 1,486 0 0ms 5ms 23ms 66ms 22 2,907 13 1,488 0 0ms 5ms 26ms 58ms 23 2,908 12 1,488 0 0ms 5ms 23ms 60ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 03 00 10 10 1.00 200.00% 01 10 10 1.00 200.00% 02 10 10 1.00 200.00% 03 10 10 1.00 200.00% 04 10 10 1.00 200.00% 05 10 10 1.00 200.00% 06 10 10 1.00 200.00% 07 10 10 1.00 200.00% 08 10 10 1.00 200.00% 09 10 10 1.00 200.00% 10 42 42 1.00 113.51% 11 10 10 1.00 200.00% 12 10 10 1.00 200.00% 13 66 66 1.00 108.20% 14 10 10 1.00 200.00% 15 10 10 1.00 200.00% 16 34 34 1.00 117.24% 17 10 10 1.00 200.00% 18 548 21,805 39.79 1.82% 19 38 36,929 971.82 0.07% 20 23 36,905 1,604.57 0.05% 21 15 36,929 2,461.93 0.03% 22 20 36,947 1,847.35 0.04% 23 14 36,973 2,640.93 0.03% Day Hour Count Average / Second Nov 03 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 6 0.00/s 11 2 0.00/s 12 2 0.00/s 13 9 0.00/s 14 2 0.00/s 15 2 0.00/s 16 5 0.00/s 17 2 0.00/s 18 11 0.00/s 19 12 0.00/s 20 2 0.00/s 21 2 0.00/s 22 26 0.01/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Nov 03 00 2 73ms 68ms 01 2 75ms 70ms 02 2 74ms 69ms 03 2 75ms 69ms 04 2 78ms 72ms 05 2 82ms 76ms 06 2 76ms 70ms 07 2 175ms 167ms 08 2 84ms 78ms 09 2 81ms 75ms 10 6 290ms 246ms 11 2 77ms 72ms 12 2 77ms 71ms 13 9 265ms 235ms 14 2 73ms 67ms 15 2 76ms 70ms 16 5 243ms 219ms 17 2 79ms 74ms 18 9 1m36s 1m34s 19 12 1m1s 1m1s 20 2 76ms 0ms 21 2 74ms 0ms 22 22 1m17s 1m17s 23 12 1m5s 1m5s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2025-11-03 18:25:05 Date
Connections per database
Key values
- pentest Main Database
- 111 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 111 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2025-11-03 20:30:33 Date
Histogram of session times
Key values
- 61 0-500ms duration
Sessions per database
Key values
- pentest Main Database
- 109 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 109 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 109 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 4.20 MiB Temp Files size Peak
- 2025-11-03 18:25:27 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2025-11-03 18:25:27 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 03 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-11-03 18:25:27 Duration: 2s417ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-03 18:25:27 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-11-03 18:25:27 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
Queries generating the largest temporary files
Rank Size Query 1 4.20 MiB select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;[ Date: 2025-11-03 18:25:27 - 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 (166) Main table analyzed (database pentest)
- 168 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 03 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 29 21 0 30 22 0 30 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,001 Total read queries
- 182,535 Total write queries
Queries by database
Key values
- pentest Main database
- 414,556 Requests
- 1m4s (pentest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 414,316 Requests
User Request type Count Duration a3dsupervisor Total 414,316 1m3s delete 8,268 5s265ms insert 16,064 4s208ms others 239 880ms select 102,881 9s680ms tcl 158,132 39s719ms update 71 2s80ms azuresu Total 240 258ms others 120 5ms select 120 252ms Duration by user
Key values
- 1m3s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 414,316 1m3s delete 8,268 5s265ms insert 16,064 4s208ms others 239 880ms select 102,881 9s680ms tcl 158,132 39s719ms update 71 2s80ms azuresu Total 240 258ms others 120 5ms select 120 252ms Queries by host
Key values
- 10.3.6.4 Main host
- 414,204 Requests
- 1m3s (10.3.6.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 414,204 Requests
- 1m3s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-03 23:58:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 397,419 0-1ms duration
Slowest individual queries
Rank Duration Query 1 2s417ms select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;[ Date: 2025-11-03 18:25:27 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 1s938ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');[ Date: 2025-11-03 18:26:22 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 1s549ms delete from GTP_LOG_JVM where LOG_DATE <;[ Date: 2025-11-03 18:25:22 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 1s459ms delete from GTP_LOG_THREAD where LOG_DATE <;[ Date: 2025-11-03 18:25:23 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 951ms delete from GTP_LOG_CONNECTION where LOG_DATE <;[ Date: 2025-11-03 18:25:25 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 798ms call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);[ Date: 2025-11-03 18:26:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 559ms 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-11-03 18:26:23 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 403ms 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-11-03 18:25:24 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 256ms 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-11-03 18:25:22 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 199ms COMMIT;[ Date: 2025-11-03 23:37:00 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 181ms delete from GTP_LOG_SESSION where LOG_DATE <;[ Date: 2025-11-03 18:25:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 162ms COMMIT;[ Date: 2025-11-03 23:34:14 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 136ms COMMIT;[ Date: 2025-11-03 18:26:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 119ms select gscp1_0.SETTING_NUM_ID, gscp1_1.SETTING_CODE, gscp1_1.SETTING_CREATOR, gscp1_1.SETTING_DCRE, gscp1_1.SETTING_DMAJ, gscp1_1.SETTING_MODIFIER, gscp1_1.SETTING_TYPE, gscp1_1.USER_NUM_ID, gscp1_0.SETTING_VALUE from GTP_SETTING_CLOB gscp1_0 join GTP_SETTING gscp1_1 on gscp1_0.SETTING_NUM_ID = gscp1_1.SETTING_NUM_ID;[ Date: 2025-11-03 18:25:23 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 105ms select gdp1_0.DOCUMENT_NUM_ID, gdp1_0.DEL_ACTION_NUM_ID, gdp1_0.DOCUMENT_B_VALID, gdp1_0.DOCUMENT_COMMENT_UPLOAD, gdp1_0.DOCUMENT_COMMENT_VERSION, gdp1_0.DOCUMENT_COMPRESSION, gdp1_0.DOCUMENT_CONTENT_TO_REMOVE, gdp1_0.DOCUMENT_DATE_CREATION, gdp1_0.DOCUMENT_NAME, gdp1_0.DOCUMENT_NUM_ID_VERSION, gdp1_0.DOCUMENT_NUM_VERSION, gdp1_0.DOCUMENT_PARAM, gdp1_0.DOCUMENT_SIZE, gdp1_0.DOCUMENT_STATUT, gdp1_0.DOCUMENT_TITTLE, gdp1_0.EXTENSION_CODE, gdp1_0.FILE_LAST_MODIFICATION_DATE, gdp1_0.NODE_NUM_ID, gdp1_0.PROJECT_NUM_ID, gdp1_0.USER_NUM_ID, gdp1_0.USER_NUM_ID_UPLOADER from GED_DOCUMENT gdp1_0 where gdp1_0.DOCUMENT_CONTENT_TO_REMOVE =;[ Date: 2025-11-03 18:26:22 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 100ms 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-11-03 18:26:20 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 99ms select gcrtp1_0.OBJ_TEMPLATE_NUM_ID, gcrtp1_0.REL_TEMPLATE_NUM_ID, gcrtp1_0.CONTENU_REL_TEMP_A3D_NUM_ID from GTP_CONTENU_REL_TEMPLATE gcrtp1_0;[ Date: 2025-11-03 18:25:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 99ms select gstp1_0.SETTING_NUM_ID, gstp1_1.SETTING_CODE, gstp1_1.SETTING_CREATOR, gstp1_1.SETTING_DCRE, gstp1_1.SETTING_DMAJ, gstp1_1.SETTING_MODIFIER, gstp1_1.SETTING_TYPE, gstp1_1.USER_NUM_ID, gstp1_0.SETTING_VALUE from GTP_SETTING_TEXT gstp1_0 join GTP_SETTING gstp1_1 on gstp1_0.SETTING_NUM_ID = gstp1_1.SETTING_NUM_ID;[ Date: 2025-11-03 18:25:23 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 84ms 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-11-03 18:26:21 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 66ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');[ Date: 2025-11-03 10:11:04 - Database: pentest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: [unknown] - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 35s253ms 79,066 0ms 199ms 0ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 19 8,356 3s814ms 0ms 20 14,139 6s97ms 0ms 21 14,129 6s262ms 0ms 22 14,139 6s220ms 0ms 23 14,146 6s147ms 0ms 00 14,157 6s711ms 0ms [ User: a3dsupervisor - Total duration: 35s253ms - Times executed: 79066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s253ms - Times executed: 79066 ]
-
COMMIT;
Date: 2025-11-03 23:37:00 Duration: 199ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 23:34:14 Duration: 162ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 18:26:20 Duration: 136ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3s650ms 60,830 0ms 4ms 0ms begin read only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 19 6,471 227ms 0ms 20 10,870 561ms 0ms 21 10,862 739ms 0ms 22 10,870 727ms 0ms 23 10,873 686ms 0ms 00 10,884 707ms 0ms [ User: a3dsupervisor - Total duration: 3s650ms - Times executed: 60830 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s650ms - Times executed: 60830 ]
-
BEGIN READ ONLY;
Date: 2025-11-03 21:02:25 Duration: 4ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-03 23:15:33 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-03 19:36:16 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
3 2s598ms 7,854 0ms 15ms 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 Nov 03 19 714 350ms 0ms 20 1,428 412ms 0ms 21 1,428 466ms 0ms 22 1,428 472ms 0ms 23 1,428 461ms 0ms 00 1,428 436ms 0ms [ User: a3dsupervisor - Total duration: 2s598ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s598ms - 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-11-03 18:30:00 Duration: 15ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-03 19:05:00 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-03 19:25:00 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s435ms 50 0ms 2s417ms 48ms 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 #4
Day Hour Count Duration Avg duration Nov 03 19 50 2s435ms 48ms [ User: a3dsupervisor - Total duration: 2s435ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s435ms - 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-11-03 18:25:27 Duration: 2s417ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-03 18:25:27 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-11-03 18:25:27 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s997ms 2 58ms 1s938ms 998ms 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 #5
Day Hour Count Duration Avg duration Nov 03 19 1 1s938ms 1s938ms 23 1 58ms 58ms [ User: a3dsupervisor - Total duration: 1s997ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s997ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 18:26:22 Duration: 1s938ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 22:26:20 Duration: 58ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s549ms 1 1s549ms 1s549ms 1s549ms delete from gtp_log_jvm where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 19 1 1s549ms 1s549ms [ User: a3dsupervisor - Total duration: 1s549ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s549ms - Times executed: 1 ]
-
delete from GTP_LOG_JVM where LOG_DATE <;
Date: 2025-11-03 18:25:22 Duration: 1s549ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s459ms 1 1s459ms 1s459ms 1s459ms delete from gtp_log_thread where log_date <;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 19 1 1s459ms 1s459ms [ User: a3dsupervisor - Total duration: 1s459ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s459ms - Times executed: 1 ]
-
delete from GTP_LOG_THREAD where LOG_DATE <;
Date: 2025-11-03 18:25:23 Duration: 1s459ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s419ms 3,961 0ms 6ms 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 #8
Day Hour Count Duration Avg duration Nov 03 19 395 144ms 0ms 20 713 242ms 0ms 21 713 259ms 0ms 22 713 250ms 0ms 23 713 257ms 0ms 00 714 266ms 0ms [ User: a3dsupervisor - Total duration: 1s419ms - Times executed: 3961 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s419ms - Times executed: 3961 ]
-
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-11-03 18:25:18 Duration: 6ms 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-11-03 22:33:01 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-11-03 23:10:51 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s373ms 7,921 0ms 6ms 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 #9
Day Hour Count Duration Avg duration Nov 03 19 789 94ms 0ms 20 1,426 213ms 0ms 21 1,425 277ms 0ms 22 1,426 271ms 0ms 23 1,427 255ms 0ms 00 1,428 261ms 0ms [ User: a3dsupervisor - Total duration: 1s373ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s373ms - Times executed: 7921 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-03 18:26:20 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-03 23:06:44 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-11-03 19:11:52 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 951ms 1 951ms 951ms 951ms delete from gtp_log_connection where log_date <;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 19 1 951ms 951ms [ User: a3dsupervisor - Total duration: 951ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 951ms - Times executed: 1 ]
-
delete from GTP_LOG_CONNECTION where LOG_DATE <;
Date: 2025-11-03 18:25:25 Duration: 951ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 858ms 6 10ms 798ms 143ms call pack_gtp_trigger.p_delete_gtp_obj_invalid (,);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 19 1 798ms 798ms 20 1 13ms 13ms 21 1 11ms 11ms 22 1 10ms 10ms 23 1 12ms 12ms 00 1 12ms 12ms [ User: a3dsupervisor - Total duration: 858ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 858ms - Times executed: 6 ]
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-11-03 18:26:21 Duration: 798ms 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-11-03 19:26:21 Duration: 13ms 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-11-03 23:26:21 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 815ms 18,236 0ms 2ms 0ms begin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 19 1,885 46ms 0ms 20 3,269 126ms 0ms 21 3,267 164ms 0ms 22 3,269 163ms 0ms 23 3,273 155ms 0ms 00 3,273 158ms 0ms [ User: a3dsupervisor - Total duration: 815ms - Times executed: 18236 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 815ms - Times executed: 18236 ]
-
BEGIN;
Date: 2025-11-03 19:56:34 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-03 22:19:03 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-03 23:26:04 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
13 689ms 15,840 0ms 4ms 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 #13
Day Hour Count Duration Avg duration Nov 03 19 1,578 64ms 0ms 20 2,852 122ms 0ms 21 2,850 131ms 0ms 22 2,852 131ms 0ms 23 2,852 112ms 0ms 00 2,856 126ms 0ms [ User: a3dsupervisor - Total duration: 689ms - Times executed: 15840 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 689ms - Times executed: 15840 ]
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 18:25:20 Duration: 4ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 23:21:21 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 19:48:14 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 601ms 7,921 0ms 2ms 0ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 03 19 789 37ms 0ms 20 1,426 95ms 0ms 21 1,425 122ms 0ms 22 1,426 114ms 0ms 23 1,427 107ms 0ms 00 1,428 124ms 0ms [ User: a3dsupervisor - Total duration: 601ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 601ms - Times executed: 7921 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-11-03 20:01:57 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-11-03 23:11:06 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-11-03 22:54:42 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 567ms 19,801 0ms 2ms 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 #15
Day Hour Count Duration Avg duration Nov 03 19 1,972 52ms 0ms 20 3,565 97ms 0ms 21 3,562 112ms 0ms 22 3,565 107ms 0ms 23 3,567 91ms 0ms 00 3,570 105ms 0ms [ User: a3dsupervisor - Total duration: 567ms - Times executed: 19801 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 567ms - Times executed: 19801 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 23:00:56 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 21:00:18 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 20:11:09 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 559ms 2 0ms 559ms 279ms 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 =;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 19 1 559ms 559ms 23 1 0ms 0ms [ User: a3dsupervisor - Total duration: 559ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 559ms - 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 = and gnp1_0.TYPE_NODE_CODE =;
Date: 2025-11-03 18:26:23 Duration: 559ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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-11-03 22:26:20 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 403ms 1 403ms 403ms 403ms 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 = ? limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 19 1 403ms 403ms [ User: a3dsupervisor - Total duration: 403ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 403ms - Times executed: 1 ]
-
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-11-03 18:25:24 Duration: 403ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 322ms 15,842 0ms 1ms 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 #18
Day Hour Count Duration Avg duration Nov 03 19 1,578 29ms 0ms 20 2,852 55ms 0ms 21 2,850 62ms 0ms 22 2,852 60ms 0ms 23 2,854 57ms 0ms 00 2,856 55ms 0ms [ User: a3dsupervisor - Total duration: 322ms - Times executed: 15842 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 322ms - Times executed: 15842 ]
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 21:47:31 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 19:30:08 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 23:17:34 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 256ms 1 256ms 256ms 256ms 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;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 03 19 1 256ms 256ms [ User: a3dsupervisor - Total duration: 256ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 256ms - Times executed: 1 ]
-
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-11-03 18:25:22 Duration: 256ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 236ms 67 2ms 84ms 3ms 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 #20
Day Hour Count Duration Avg duration Nov 03 19 7 98ms 14ms 20 12 27ms 2ms 21 12 26ms 2ms 22 12 27ms 2ms 23 12 27ms 2ms 00 12 29ms 2ms [ User: a3dsupervisor - Total duration: 236ms - Times executed: 67 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 236ms - 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-11-03 18:26:21 Duration: 84ms 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-11-03 23:46: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-11-03 19:06:20 Duration: 2ms 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,066 35s253ms 0ms 199ms 0ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 19 8,356 3s814ms 0ms 20 14,139 6s97ms 0ms 21 14,129 6s262ms 0ms 22 14,139 6s220ms 0ms 23 14,146 6s147ms 0ms 00 14,157 6s711ms 0ms [ User: a3dsupervisor - Total duration: 35s253ms - Times executed: 79066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s253ms - Times executed: 79066 ]
-
COMMIT;
Date: 2025-11-03 23:37:00 Duration: 199ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 23:34:14 Duration: 162ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 18:26:20 Duration: 136ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 60,830 3s650ms 0ms 4ms 0ms begin read only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 19 6,471 227ms 0ms 20 10,870 561ms 0ms 21 10,862 739ms 0ms 22 10,870 727ms 0ms 23 10,873 686ms 0ms 00 10,884 707ms 0ms [ User: a3dsupervisor - Total duration: 3s650ms - Times executed: 60830 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s650ms - Times executed: 60830 ]
-
BEGIN READ ONLY;
Date: 2025-11-03 21:02:25 Duration: 4ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-03 23:15:33 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-03 19:36:16 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
3 19,801 567ms 0ms 2ms 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 Nov 03 19 1,972 52ms 0ms 20 3,565 97ms 0ms 21 3,562 112ms 0ms 22 3,565 107ms 0ms 23 3,567 91ms 0ms 00 3,570 105ms 0ms [ User: a3dsupervisor - Total duration: 567ms - Times executed: 19801 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 567ms - Times executed: 19801 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 23:00:56 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 21:00:18 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 20:11:09 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 18,236 815ms 0ms 2ms 0ms begin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 19 1,885 46ms 0ms 20 3,269 126ms 0ms 21 3,267 164ms 0ms 22 3,269 163ms 0ms 23 3,273 155ms 0ms 00 3,273 158ms 0ms [ User: a3dsupervisor - Total duration: 815ms - Times executed: 18236 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 815ms - Times executed: 18236 ]
-
BEGIN;
Date: 2025-11-03 19:56:34 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-03 22:19:03 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-03 23:26:04 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
5 15,842 322ms 0ms 1ms 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 #5
Day Hour Count Duration Avg duration Nov 03 19 1,578 29ms 0ms 20 2,852 55ms 0ms 21 2,850 62ms 0ms 22 2,852 60ms 0ms 23 2,854 57ms 0ms 00 2,856 55ms 0ms [ User: a3dsupervisor - Total duration: 322ms - Times executed: 15842 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 322ms - Times executed: 15842 ]
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 21:47:31 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 19:30:08 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-03 23:17:34 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 15,840 689ms 0ms 4ms 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 #6
Day Hour Count Duration Avg duration Nov 03 19 1,578 64ms 0ms 20 2,852 122ms 0ms 21 2,850 131ms 0ms 22 2,852 131ms 0ms 23 2,852 112ms 0ms 00 2,856 126ms 0ms [ User: a3dsupervisor - Total duration: 689ms - Times executed: 15840 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 689ms - Times executed: 15840 ]
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 18:25:20 Duration: 4ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 23:21:21 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 19:48:14 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 8,143 185ms 0ms 41ms 0ms select nextval(?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 19 743 55ms 0ms 20 1,480 21ms 0ms 21 1,480 26ms 0ms 22 1,480 29ms 0ms 23 1,480 28ms 0ms 00 1,480 25ms 0ms [ User: a3dsupervisor - Total duration: 185ms - Times executed: 8143 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 185ms - Times executed: 8143 ]
-
select nextval('S_BACKGROUND_TASK');
Date: 2025-11-03 18:26:20 Duration: 41ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-11-03 22:35:00 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-11-03 22:40:00 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 7,921 1s373ms 0ms 6ms 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 Nov 03 19 789 94ms 0ms 20 1,426 213ms 0ms 21 1,425 277ms 0ms 22 1,426 271ms 0ms 23 1,427 255ms 0ms 00 1,428 261ms 0ms [ User: a3dsupervisor - Total duration: 1s373ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s373ms - Times executed: 7921 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-03 18:26:20 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-03 23:06:44 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-11-03 19:11:52 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 7,921 601ms 0ms 2ms 0ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 19 789 37ms 0ms 20 1,426 95ms 0ms 21 1,425 122ms 0ms 22 1,426 114ms 0ms 23 1,427 107ms 0ms 00 1,428 124ms 0ms [ User: a3dsupervisor - Total duration: 601ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 601ms - Times executed: 7921 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-11-03 20:01:57 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-11-03 23:11:06 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-11-03 22:54:42 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 7,918 49ms 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 ? = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 19 788 4ms 0ms 20 1,426 8ms 0ms 21 1,424 9ms 0ms 22 1,426 9ms 0ms 23 1,426 7ms 0ms 00 1,428 10ms 0ms [ User: a3dsupervisor - Total duration: 49ms - Times executed: 7918 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49ms - 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-11-03 23:20:21 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0 where 1 = 0;
Date: 2025-11-03 23:14:38 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0 where 1 = 0;
Date: 2025-11-03 20:31:22 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 7,854 2s598ms 0ms 15ms 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 Nov 03 19 714 350ms 0ms 20 1,428 412ms 0ms 21 1,428 466ms 0ms 22 1,428 472ms 0ms 23 1,428 461ms 0ms 00 1,428 436ms 0ms [ User: a3dsupervisor - Total duration: 2s598ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s598ms - 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-11-03 18:30:00 Duration: 15ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-03 19:05:00 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-03 19:25:00 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 4,292 84ms 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 Nov 03 19 427 7ms 0ms 20 773 15ms 0ms 21 772 17ms 0ms 22 773 14ms 0ms 23 773 14ms 0ms 00 774 15ms 0ms [ User: a3dsupervisor - Total duration: 84ms - Times executed: 4292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 84ms - Times executed: 4292 ]
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-11-03 20:42:30 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-11-03 22:01:03 Duration: 0ms 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-11-03 19:02:00 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 4,018 162ms 0ms 1ms 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 Nov 03 19 418 18ms 0ms 20 720 31ms 0ms 21 720 29ms 0ms 22 720 28ms 0ms 23 720 27ms 0ms 00 720 26ms 0ms [ User: a3dsupervisor - Total duration: 162ms - Times executed: 4018 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 162ms - 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-11-03 18:25:15 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;
Date: 2025-11-03 21:26:15 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-11-03 21:41:25 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 3,961 1s419ms 0ms 6ms 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 #14
Day Hour Count Duration Avg duration Nov 03 19 395 144ms 0ms 20 713 242ms 0ms 21 713 259ms 0ms 22 713 250ms 0ms 23 713 257ms 0ms 00 714 266ms 0ms [ User: a3dsupervisor - Total duration: 1s419ms - Times executed: 3961 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s419ms - Times executed: 3961 ]
-
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-11-03 18:25:18 Duration: 6ms 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-11-03 22:33:01 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-11-03 23:10:51 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 3,960 135ms 0ms 3ms 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 #15
Day Hour Count Duration Avg duration Nov 03 19 394 16ms 0ms 20 713 24ms 0ms 21 713 24ms 0ms 22 713 22ms 0ms 23 713 22ms 0ms 00 714 24ms 0ms [ User: a3dsupervisor - Total duration: 135ms - Times executed: 3960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 135ms - Times executed: 3960 ]
-
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-11-03 18:26:50 Duration: 3ms 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-11-03 22:18:38 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-11-03 22:01:59 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 3,960 75ms 0ms 7ms 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 #16
Day Hour Count Duration Avg duration Nov 03 19 394 6ms 0ms 20 713 14ms 0ms 21 713 11ms 0ms 22 713 14ms 0ms 23 713 10ms 0ms 00 714 17ms 0ms [ User: a3dsupervisor - Total duration: 75ms - Times executed: 3960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 75ms - Times executed: 3960 ]
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-11-03 23:15:54 Duration: 7ms 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-11-03 21:54:50 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-11-03 21:37:40 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 3,960 28ms 0ms 1ms 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 #17
Day Hour Count Duration Avg duration Nov 03 19 394 3ms 0ms 20 713 4ms 0ms 21 713 6ms 0ms 22 713 4ms 0ms 23 713 5ms 0ms 00 714 4ms 0ms [ User: a3dsupervisor - Total duration: 28ms - Times executed: 3960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 28ms - Times executed: 3960 ]
-
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-11-03 20:37:14 Duration: 1ms 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-11-03 22:03:45 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-11-03 19:29:42 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 3,959 86ms 0ms 0ms 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 Nov 03 19 394 8ms 0ms 20 713 14ms 0ms 21 712 16ms 0ms 22 713 17ms 0ms 23 713 14ms 0ms 00 714 15ms 0ms [ User: a3dsupervisor - Total duration: 86ms - Times executed: 3959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 86ms - Times executed: 3959 ]
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-11-03 23:02:47 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-11-03 22:32:00 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-11-03 18:50:20 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 3,959 24ms 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 Nov 03 19 394 1ms 0ms 20 713 4ms 0ms 21 712 3ms 0ms 22 713 4ms 0ms 23 713 3ms 0ms 00 714 5ms 0ms [ User: a3dsupervisor - Total duration: 24ms - Times executed: 3959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24ms - 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-11-03 19:58:56 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-11-03 23:08:20 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-11-03 23:39:32 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,338 66ms 0ms 0ms 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 Nov 03 19 138 6ms 0ms 20 240 11ms 0ms 21 240 12ms 0ms 22 240 12ms 0ms 23 240 11ms 0ms 00 240 12ms 0ms [ User: a3dsupervisor - Total duration: 66ms - Times executed: 1338 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 66ms - 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-11-03 19:12:46 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-11-03 23:57:22 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-11-03 21:16:19 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 1s549ms 1s549ms 1s549ms 1 1s549ms delete from gtp_log_jvm where log_date <;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 19 1 1s549ms 1s549ms [ User: a3dsupervisor - Total duration: 1s549ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s549ms - Times executed: 1 ]
-
delete from GTP_LOG_JVM where LOG_DATE <;
Date: 2025-11-03 18:25:22 Duration: 1s549ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1s459ms 1s459ms 1s459ms 1 1s459ms delete from gtp_log_thread where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 19 1 1s459ms 1s459ms [ User: a3dsupervisor - Total duration: 1s459ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s459ms - Times executed: 1 ]
-
delete from GTP_LOG_THREAD where LOG_DATE <;
Date: 2025-11-03 18:25:23 Duration: 1s459ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 58ms 1s938ms 998ms 2 1s997ms 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 #3
Day Hour Count Duration Avg duration Nov 03 19 1 1s938ms 1s938ms 23 1 58ms 58ms [ User: a3dsupervisor - Total duration: 1s997ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s997ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 18:26:22 Duration: 1s938ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 22:26:20 Duration: 58ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 951ms 951ms 951ms 1 951ms delete from gtp_log_connection where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 19 1 951ms 951ms [ User: a3dsupervisor - Total duration: 951ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 951ms - Times executed: 1 ]
-
delete from GTP_LOG_CONNECTION where LOG_DATE <;
Date: 2025-11-03 18:25:25 Duration: 951ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 403ms 403ms 403ms 1 403ms 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 = ? limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 19 1 403ms 403ms [ User: a3dsupervisor - Total duration: 403ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 403ms - Times executed: 1 ]
-
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-11-03 18:25:24 Duration: 403ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 559ms 279ms 2 559ms 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 =;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 19 1 559ms 559ms 23 1 0ms 0ms [ User: a3dsupervisor - Total duration: 559ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 559ms - 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 = and gnp1_0.TYPE_NODE_CODE =;
Date: 2025-11-03 18:26:23 Duration: 559ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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-11-03 22:26:20 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 256ms 256ms 256ms 1 256ms 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;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 19 1 256ms 256ms [ User: a3dsupervisor - Total duration: 256ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 256ms - Times executed: 1 ]
-
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-11-03 18:25:22 Duration: 256ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 10ms 798ms 143ms 6 858ms call pack_gtp_trigger.p_delete_gtp_obj_invalid (,);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 19 1 798ms 798ms 20 1 13ms 13ms 21 1 11ms 11ms 22 1 10ms 10ms 23 1 12ms 12ms 00 1 12ms 12ms [ User: a3dsupervisor - Total duration: 858ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 858ms - Times executed: 6 ]
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID (,);
Date: 2025-11-03 18:26:21 Duration: 798ms 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-11-03 19:26:21 Duration: 13ms 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-11-03 23:26:21 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 2s417ms 48ms 50 2s435ms 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 #9
Day Hour Count Duration Avg duration Nov 03 19 50 2s435ms 48ms [ User: a3dsupervisor - Total duration: 2s435ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s435ms - 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-11-03 18:25:27 Duration: 2s417ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;
Date: 2025-11-03 18:25:27 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-11-03 18:25:27 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 2ms 84ms 3ms 67 236ms 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 #10
Day Hour Count Duration Avg duration Nov 03 19 7 98ms 14ms 20 12 27ms 2ms 21 12 26ms 2ms 22 12 27ms 2ms 23 12 27ms 2ms 00 12 29ms 2ms [ User: a3dsupervisor - Total duration: 236ms - Times executed: 67 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 236ms - 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-11-03 18:26:21 Duration: 84ms 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-11-03 23:46: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-11-03 19:06:20 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 199ms 0ms 79,066 35s253ms commit;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 19 8,356 3s814ms 0ms 20 14,139 6s97ms 0ms 21 14,129 6s262ms 0ms 22 14,139 6s220ms 0ms 23 14,146 6s147ms 0ms 00 14,157 6s711ms 0ms [ User: a3dsupervisor - Total duration: 35s253ms - Times executed: 79066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s253ms - Times executed: 79066 ]
-
COMMIT;
Date: 2025-11-03 23:37:00 Duration: 199ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 23:34:14 Duration: 162ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 18:26:20 Duration: 136ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 6ms 0ms 3,961 1s419ms 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 #12
Day Hour Count Duration Avg duration Nov 03 19 395 144ms 0ms 20 713 242ms 0ms 21 713 259ms 0ms 22 713 250ms 0ms 23 713 257ms 0ms 00 714 266ms 0ms [ User: a3dsupervisor - Total duration: 1s419ms - Times executed: 3961 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s419ms - Times executed: 3961 ]
-
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-11-03 18:25:18 Duration: 6ms 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-11-03 22:33:01 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-11-03 23:10:51 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 15ms 0ms 7,854 2s598ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 03 19 714 350ms 0ms 20 1,428 412ms 0ms 21 1,428 466ms 0ms 22 1,428 472ms 0ms 23 1,428 461ms 0ms 00 1,428 436ms 0ms [ User: a3dsupervisor - Total duration: 2s598ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s598ms - 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-11-03 18:30:00 Duration: 15ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-03 19:05:00 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-03 19:25:00 Duration: 12ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 6ms 0ms 7,921 1s373ms 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 #14
Day Hour Count Duration Avg duration Nov 03 19 789 94ms 0ms 20 1,426 213ms 0ms 21 1,425 277ms 0ms 22 1,426 271ms 0ms 23 1,427 255ms 0ms 00 1,428 261ms 0ms [ User: a3dsupervisor - Total duration: 1s373ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s373ms - Times executed: 7921 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-03 18:26:20 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-03 23:06:44 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-11-03 19:11:52 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 2ms 0ms 7,921 601ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 03 19 789 37ms 0ms 20 1,426 95ms 0ms 21 1,425 122ms 0ms 22 1,426 114ms 0ms 23 1,427 107ms 0ms 00 1,428 124ms 0ms [ User: a3dsupervisor - Total duration: 601ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 601ms - Times executed: 7921 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-11-03 20:01:57 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-11-03 23:11:06 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-11-03 22:54:42 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 4ms 0ms 60,830 3s650ms begin read only;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 19 6,471 227ms 0ms 20 10,870 561ms 0ms 21 10,862 739ms 0ms 22 10,870 727ms 0ms 23 10,873 686ms 0ms 00 10,884 707ms 0ms [ User: a3dsupervisor - Total duration: 3s650ms - Times executed: 60830 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s650ms - Times executed: 60830 ]
-
BEGIN READ ONLY;
Date: 2025-11-03 21:02:25 Duration: 4ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-03 23:15:33 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-11-03 19:36:16 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
17 0ms 0ms 0ms 1,338 66ms 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 #17
Day Hour Count Duration Avg duration Nov 03 19 138 6ms 0ms 20 240 11ms 0ms 21 240 12ms 0ms 22 240 12ms 0ms 23 240 11ms 0ms 00 240 12ms 0ms [ User: a3dsupervisor - Total duration: 66ms - Times executed: 1338 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 66ms - 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-11-03 19:12:46 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-11-03 23:57:22 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-11-03 21:16:19 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 2ms 0ms 18,236 815ms begin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 03 19 1,885 46ms 0ms 20 3,269 126ms 0ms 21 3,267 164ms 0ms 22 3,269 163ms 0ms 23 3,273 155ms 0ms 00 3,273 158ms 0ms [ User: a3dsupervisor - Total duration: 815ms - Times executed: 18236 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 815ms - Times executed: 18236 ]
-
BEGIN;
Date: 2025-11-03 19:56:34 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-03 22:19:03 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-11-03 23:26:04 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
19 0ms 4ms 0ms 15,840 689ms 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 #19
Day Hour Count Duration Avg duration Nov 03 19 1,578 64ms 0ms 20 2,852 122ms 0ms 21 2,850 131ms 0ms 22 2,852 131ms 0ms 23 2,852 112ms 0ms 00 2,856 126ms 0ms [ User: a3dsupervisor - Total duration: 689ms - Times executed: 15840 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 689ms - Times executed: 15840 ]
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 18:25:20 Duration: 4ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 23:21:21 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2025-11-03 19:48:14 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 1ms 0ms 4,018 162ms 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 #20
Day Hour Count Duration Avg duration Nov 03 19 418 18ms 0ms 20 720 31ms 0ms 21 720 29ms 0ms 22 720 28ms 0ms 23 720 27ms 0ms 00 720 26ms 0ms [ User: a3dsupervisor - Total duration: 162ms - Times executed: 4018 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 162ms - 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-11-03 18:25:15 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;
Date: 2025-11-03 21:26:15 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-11-03 21:41:25 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 203ms 48 1ms 135ms 4ms SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Nov 03 01 2 2ms 1ms 02 2 2ms 1ms 03 2 2ms 1ms 04 2 3ms 1ms 05 2 3ms 1ms 06 2 2ms 1ms 07 2 2ms 1ms 08 2 136ms 68ms 09 2 2ms 1ms 10 2 2ms 1ms 11 2 2ms 1ms 12 2 2ms 1ms 13 2 2ms 1ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 2ms 1ms 17 2 2ms 1ms 18 2 2ms 1ms 19 2 2ms 1ms 20 2 2ms 1ms 21 2 2ms 1ms 22 2 3ms 1ms 23 2 3ms 1ms 00 2 2ms 1ms [ User: azuresu - Total duration: 221ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 221ms - 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-11-03 07:50:59 Duration: 135ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-03 04:50:47 Duration: 1ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-03 22:21:51 Duration: 1ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 43ms 1 43ms 43ms 43ms delete from GTP_LOG_JVM where LOG_DATE < $1;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 18 1 43ms 43ms [ User: a3dsupervisor - Total duration: 1s549ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s549ms - Times executed: 1 ]
-
delete from GTP_LOG_JVM where LOG_DATE < $1;
Date: 2025-11-03 18:25:20 Duration: 43ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
3 42ms 1 42ms 42ms 42ms select gcrtp1_0.OBJ_TEMPLATE_NUM_ID, gcrtp1_0.REL_TEMPLATE_NUM_ID, gcrtp1_0.CONTENU_REL_TEMP_A3D_NUM_ID from GTP_CONTENU_REL_TEMPLATE gcrtp1_0;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 18 1 42ms 42ms [ User: a3dsupervisor - Total duration: 99ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 99ms - Times executed: 1 ]
-
select gcrtp1_0.OBJ_TEMPLATE_NUM_ID, gcrtp1_0.REL_TEMPLATE_NUM_ID, gcrtp1_0.CONTENU_REL_TEMP_A3D_NUM_ID from GTP_CONTENU_REL_TEMPLATE gcrtp1_0;
Date: 2025-11-03 18:25:21 Duration: 42ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
4 41ms 2 0ms 41ms 20ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 18 1 41ms 41ms 22 1 0ms 0ms [ User: a3dsupervisor - Total duration: 1s997ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s997ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 18:26:20 Duration: 41ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 22:26:20 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
5 39ms 17 0ms 31ms 2ms 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 prepare #5
Day Hour Count Duration Avg duration 18 16 39ms 2ms 19 1 0ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 17 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7ms - Times executed: 17 ]
-
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-11-03 18:26:20 Duration: 31ms 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-11-03 18:26:50 Duration: 5ms 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-11-03 18:27:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
6 38ms 1 38ms 38ms 38ms select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 18 1 38ms 38ms [ User: a3dsupervisor - Total duration: 403ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 403ms - Times executed: 1 ]
-
select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;
Date: 2025-11-03 18:25:24 Duration: 38ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
7 37ms 14 1ms 15ms 2ms 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 #7
Day Hour Count Duration Avg duration 10 4 21ms 5ms 13 7 11ms 1ms 16 3 5ms 1ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 14 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 14 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-11-03 10:11:04 Duration: 15ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-11-03 16:30:39 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-11-03 10:50:53 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 37ms 1 37ms 37ms 37ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 2596845 AS oid, 1 AS attnum) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) where c.oid in (2596845);Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 18 1 37ms 37ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 1 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 2596845 AS oid, 1 AS attnum) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) where c.oid in (2596845);
Date: 2025-11-03 18:25:24 Duration: 37ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
9 36ms 1 36ms 36ms 36ms DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = $1 AND (task.TASK_START_DATE + interval '1 day' * 3) < current_timestamp);Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 18 1 36ms 36ms [ User: a3dsupervisor - Total duration: 63ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 63ms - Times executed: 1 ]
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = $1 AND (task.TASK_START_DATE + interval '1 day' * 3) < current_timestamp);
Date: 2025-11-03 18:25:20 Duration: 36ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
10 36ms 1 36ms 36ms 36ms UPDATE LOG_SESSION SET SESSION_STATUS = $1 WHERE SESSION_STATUS = $2 AND SERVER_ID = $3;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 18 1 36ms 36ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = $1 WHERE SESSION_STATUS = $2 AND SERVER_ID = $3;
Date: 2025-11-03 18:25:20 Duration: 36ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
11 35ms 17 0ms 29ms 2ms 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 #11
Day Hour Count Duration Avg duration 18 15 31ms 2ms 19 1 2ms 2ms 23 1 1ms 1ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 17 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5ms - Times executed: 17 ]
-
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-11-03 18:25:20 Duration: 29ms 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-11-03 19:26:20 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-11-03 23:00:00 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
12 33ms 1 33ms 33ms 33ms select lup1_0.USER_NUM_ID, lup1_0.COMPANY_NUM_ID, lup1_0.ANONYMIZED, lup1_0.USER_CIVILITY, lup1_0.CREATION_DATE, lup1_0.USER_NUM_ID_CREATOR, lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME || ' (' || lup1_0.USER_LOGIN || ')', lup1_0.LAST_CONNECTION_DATE, lup1_0.USER_NAME, lup1_0.MODIFICATION_DATE, lup1_0.MODIFIER_NUM_ID, lup1_0.POLICY_VERSION, lup1_0.OBJ_NUM_ID, lup1_0.USER_ADDRESS, lup1_0.USER_AUTHENTICATION, lup1_0.USER_CITY, lup1_0.USER_COUNTRY, lup1_0.USER_DELETED, lup1_0.USER_FAX, lup1_0.USER_GUID, lup1_0.USER_LOGIN, lup1_0.USER_MAIL, lup1_0.USER_CELULAR, lup1_0.USER_PASSWORD, lup1_0.USER_PHONE, lup1_0.USER_POSTAL_CODE, lup1_0.USER_BOK from A3D_USER lup1_0;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 18 1 33ms 33ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 1 ]
-
select lup1_0.USER_NUM_ID, lup1_0.COMPANY_NUM_ID, lup1_0.ANONYMIZED, lup1_0.USER_CIVILITY, lup1_0.CREATION_DATE, lup1_0.USER_NUM_ID_CREATOR, lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME || ' (' || lup1_0.USER_LOGIN || ')', lup1_0.LAST_CONNECTION_DATE, lup1_0.USER_NAME, lup1_0.MODIFICATION_DATE, lup1_0.MODIFIER_NUM_ID, lup1_0.POLICY_VERSION, lup1_0.OBJ_NUM_ID, lup1_0.USER_ADDRESS, lup1_0.USER_AUTHENTICATION, lup1_0.USER_CITY, lup1_0.USER_COUNTRY, lup1_0.USER_DELETED, lup1_0.USER_FAX, lup1_0.USER_GUID, lup1_0.USER_LOGIN, lup1_0.USER_MAIL, lup1_0.USER_CELULAR, lup1_0.USER_PASSWORD, lup1_0.USER_PHONE, lup1_0.USER_POSTAL_CODE, lup1_0.USER_BOK from A3D_USER lup1_0;
Date: 2025-11-03 18:25:22 Duration: 33ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 30ms 1 30ms 30ms 30ms UPDATE ENG_FILE SET FILE_SRC = NULL, FILE_BIM6D = NULL, FILE_BIM6D_MD5 = null, BIM6D_VERSION = 0 WHERE FILE_SRC_MD5 IN ( SELECT EFI.FILE_SRC_MD5 FROM ENG_FILE EFI INNER JOIN ENG_DATA EDA ON EFI.FILE_SRC_MD5 = EDA.FILE_SRC_MD5 WHERE EFI.FILE_SRC_MD5 NOT IN ( SELECT FILE_SRC_MD5 FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY OBJ_NUM_ID ORDER BY IMPORT_DATE DESC) AS ROWN, FILE_SRC_MD5 FROM ENG_DATA WHERE IMPORT_STATUS = 1) WHERE ROWN <= $1)) AND FILE_BIM6D_MD5 IS NOT NULL;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 18 1 30ms 30ms [ User: a3dsupervisor - Total duration: 64ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 64ms - Times executed: 1 ]
-
UPDATE ENG_FILE SET FILE_SRC = NULL, FILE_BIM6D = NULL, FILE_BIM6D_MD5 = null, BIM6D_VERSION = 0 WHERE FILE_SRC_MD5 IN ( SELECT EFI.FILE_SRC_MD5 FROM ENG_FILE EFI INNER JOIN ENG_DATA EDA ON EFI.FILE_SRC_MD5 = EDA.FILE_SRC_MD5 WHERE EFI.FILE_SRC_MD5 NOT IN ( SELECT FILE_SRC_MD5 FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY OBJ_NUM_ID ORDER BY IMPORT_DATE DESC) AS ROWN, FILE_SRC_MD5 FROM ENG_DATA WHERE IMPORT_STATUS = 1) WHERE ROWN <= $1)) AND FILE_BIM6D_MD5 IS NOT NULL;
Date: 2025-11-03 18:26:33 Duration: 30ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
14 29ms 14 0ms 18ms 2ms 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 #14
Day Hour Count Duration Avg duration 10 4 21ms 5ms 13 7 5ms 0ms 16 3 2ms 0ms [ User: a3dsupervisor - Total duration: 171ms - Times executed: 14 ]
[ Application: [unknown] - Total duration: 171ms - Times executed: 14 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-11-03 10:11:04 Duration: 18ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-11-03 13:43:33 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-11-03 13:25:25 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
15 28ms 1 28ms 28ms 28ms select * from information_schema.sequences;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 18 1 28ms 28ms [ User: a3dsupervisor - Total duration: 24ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24ms - Times executed: 1 ]
-
select * from information_schema.sequences;
Date: 2025-11-03 18:25:07 Duration: 28ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
16 28ms 1 28ms 28ms 28ms delete from GTP_LOG_METRIC where LOG_DATE < $1;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 18 1 28ms 28ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1ms - Times executed: 1 ]
-
delete from GTP_LOG_METRIC where LOG_DATE < $1;
Date: 2025-11-03 18:25:25 Duration: 28ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
17 26ms 1 26ms 26ms 26ms delete from GTP_LOG_SESSION where LOG_DATE < $1;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 18 1 26ms 26ms [ User: a3dsupervisor - Total duration: 181ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 181ms - Times executed: 1 ]
-
delete from GTP_LOG_SESSION where LOG_DATE < $1;
Date: 2025-11-03 18:25:20 Duration: 26ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
18 21ms 2 0ms 20ms 10ms 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 #18
Day Hour Count Duration Avg duration 18 1 20ms 20ms 22 1 0ms 0ms [ User: a3dsupervisor - Total duration: 559ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 559ms - Times executed: 2 ]
-
select gnp1_0.NODE_NUM_ID, gnp1_0.PROJECT_NUM_ID, gnp1_0.DATE_CREATION, gnp1_0.NODE_DMAJ, gnp1_0.NODE_MODIFIER, gnp1_0.NODE_NAME, gnp1_0.NODE_NUM_ID_PERE, gnp1_0.NODE_TO_REMOVE, gnp1_0.NODE_POSITION, gnp1_0.PROJECT_NUM_ID_PERE, gnp1_0.TYPE_NODE_CODE, gnp1_0.USER_NUM_ID from GED_NODE gnp1_0 where gnp1_0.NODE_TO_REMOVE = $1 and gnp1_0.TYPE_NODE_CODE = $2;
Date: 2025-11-03 18:26:23 Duration: 20ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gnp1_0.NODE_NUM_ID, gnp1_0.PROJECT_NUM_ID, gnp1_0.DATE_CREATION, gnp1_0.NODE_DMAJ, gnp1_0.NODE_MODIFIER, gnp1_0.NODE_NAME, gnp1_0.NODE_NUM_ID_PERE, gnp1_0.NODE_TO_REMOVE, gnp1_0.NODE_POSITION, gnp1_0.PROJECT_NUM_ID_PERE, gnp1_0.TYPE_NODE_CODE, gnp1_0.USER_NUM_ID from GED_NODE gnp1_0 where gnp1_0.NODE_TO_REMOVE = $1 and gnp1_0.TYPE_NODE_CODE = $2;
Date: 2025-11-03 22:26:20 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
19 17ms 1 17ms 17ms 17ms delete from tmp_file where TMP_FILE_INSERT_DATE < current_date - $1;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 18 1 17ms 17ms [ User: a3dsupervisor - Total duration: 35ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35ms - Times executed: 1 ]
-
delete from tmp_file where TMP_FILE_INSERT_DATE < current_date - $1;
Date: 2025-11-03 18:26:20 Duration: 17ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 14ms 6 0ms 13ms 2ms call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID ($1, $2);Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 18 1 13ms 13ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: a3dsupervisor - Total duration: 858ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 858ms - Times executed: 6 ]
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID ($1, $2);
Date: 2025-11-03 18:26:20 Duration: 13ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID ($1, $2);
Date: 2025-11-03 19:26:21 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID ($1, $2);
Date: 2025-11-03 23:26:21 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s729ms 15,840 0ms 5ms 0ms select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = $1 order by gsbp1_0.SETTING_NUM_ID desc;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Nov 03 19 1,578 120ms 0ms 20 2,852 272ms 0ms 21 2,850 355ms 0ms 22 2,852 345ms 0ms 23 2,852 298ms 0ms 00 2,856 336ms 0ms [ User: a3dsupervisor - Total duration: 689ms - Times executed: 15840 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 689ms - Times executed: 15840 ]
-
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-11-03 18:25:20 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-11-03 23:31:02 Duration: 4ms 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-11-03 23:00:30 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
2 1s238ms 15,842 0ms 2ms 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,578 69ms 0ms 19 2,852 184ms 0ms 20 2,850 248ms 0ms 21 2,852 246ms 0ms 22 2,854 248ms 0ms 23 2,856 240ms 0ms [ User: a3dsupervisor - Total duration: 322ms - Times executed: 15842 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 322ms - Times executed: 15842 ]
-
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-11-03 21:01:53 Duration: 2ms 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-11-03 20:12:19 Duration: 2ms 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-11-03 22:09:03 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
3 1s167ms 19,801 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 = $1;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 18 1,972 78ms 0ms 19 3,565 181ms 0ms 20 3,562 236ms 0ms 21 3,565 225ms 0ms 22 3,567 222ms 0ms 23 3,570 224ms 0ms [ User: a3dsupervisor - Total duration: 567ms - Times executed: 19801 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 567ms - Times executed: 19801 ]
-
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-11-03 20:18:12 Duration: 3ms 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-11-03 22:32:41 Duration: 3ms 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-11-03 23:13:47 Duration: 3ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
4 543ms 79,066 0ms 0ms 0ms COMMIT;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 18 8,356 61ms 0ms 19 14,139 96ms 0ms 20 14,129 96ms 0ms 21 14,139 97ms 0ms 22 14,146 93ms 0ms 23 14,157 97ms 0ms [ User: a3dsupervisor - Total duration: 35s251ms - Times executed: 79066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s251ms - Times executed: 79066 ]
-
COMMIT;
Date: 2025-11-03 23:02:47 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-11-03 23:56:01 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-11-03 21:11:20 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
5 430ms 7,854 0ms 7ms 0ms select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 18 714 15ms 0ms 19 1,428 58ms 0ms 20 1,428 87ms 0ms 21 1,428 85ms 0ms 22 1,428 83ms 0ms 23 1,428 100ms 0ms [ User: a3dsupervisor - Total duration: 131ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 131ms - Times executed: 7854 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-11-03 23:35:00 Duration: 7ms 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-11-03 23:25:00 Duration: 4ms 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-11-03 20:45:00 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
6 362ms 4,018 0ms 10ms 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 #6
Day Hour Count Duration Avg duration 18 418 38ms 0ms 19 720 60ms 0ms 20 720 68ms 0ms 21 720 71ms 0ms 22 720 63ms 0ms 23 720 59ms 0ms [ User: a3dsupervisor - Total duration: 162ms - Times executed: 4018 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 162ms - 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-11-03 18:25:15 Duration: 10ms 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-11-03 21:08:00 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;
Date: 2025-11-03 20:31:00 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
7 333ms 7,921 0ms 2ms 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 #7
Day Hour Count Duration Avg duration 18 789 35ms 0ms 19 1,426 62ms 0ms 20 1,425 58ms 0ms 21 1,426 58ms 0ms 22 1,427 60ms 0ms 23 1,428 58ms 0ms [ User: a3dsupervisor - Total duration: 1s373ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s373ms - Times executed: 7921 ]
-
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-11-03 19:25:30 Duration: 2ms 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-11-03 19:00:16 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-11-03 23:17:09 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
8 305ms 4,292 0ms 3ms 0ms select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 18 427 19ms 0ms 19 773 46ms 0ms 20 772 67ms 0ms 21 773 59ms 0ms 22 773 52ms 0ms 23 774 60ms 0ms [ User: a3dsupervisor - Total duration: 84ms - Times executed: 4292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 84ms - Times executed: 4292 ]
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-11-03 20:43:10 Duration: 3ms 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-11-03 23:55:26 Duration: 1ms 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-11-03 23:48:22 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
9 274ms 7,918 0ms 4ms 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 788 25ms 0ms 19 1,426 43ms 0ms 20 1,424 55ms 0ms 21 1,426 54ms 0ms 22 1,426 45ms 0ms 23 1,428 50ms 0ms [ User: a3dsupervisor - Total duration: 49ms - Times executed: 7918 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49ms - 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-11-03 18:36:01 Duration: 4ms 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-11-03 19:30:58 Duration: 2ms 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-11-03 23:08:20 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
10 224ms 3,960 0ms 7ms 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 394 22ms 0ms 19 713 32ms 0ms 20 713 41ms 0ms 21 713 41ms 0ms 22 713 45ms 0ms 23 714 41ms 0ms [ User: a3dsupervisor - Total duration: 135ms - Times executed: 3960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 135ms - Times executed: 3960 ]
-
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-11-03 18:26:50 Duration: 7ms 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-11-03 22:00:03 Duration: 4ms 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-11-03 23:58:52 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
11 195ms 7,921 0ms 1ms 0ms delete from APPLICATIVE_LOCK where LOCK_KEY = $1;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 18 789 21ms 0ms 19 1,426 33ms 0ms 20 1,425 33ms 0ms 21 1,426 33ms 0ms 22 1,427 38ms 0ms 23 1,428 34ms 0ms [ User: a3dsupervisor - Total duration: 601ms - Times executed: 7921 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 601ms - Times executed: 7921 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY = $1;
Date: 2025-11-03 21:23:00 Duration: 1ms 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-11-03 22:32:46 Duration: 1ms 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-11-03 22:13:40 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
12 194ms 1,338 0ms 29ms 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 #12
Day Hour Count Duration Avg duration 18 138 45ms 0ms 19 240 24ms 0ms 20 240 31ms 0ms 21 240 32ms 0ms 22 240 29ms 0ms 23 240 30ms 0ms [ User: a3dsupervisor - Total duration: 66ms - Times executed: 1338 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 66ms - 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-11-03 18:25:30 Duration: 29ms 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-11-03 21:56:49 Duration: 3ms 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-11-03 18:26:30 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 159ms 3,961 0ms 2ms 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 #13
Day Hour Count Duration Avg duration 18 395 14ms 0ms 19 713 24ms 0ms 20 713 29ms 0ms 21 713 31ms 0ms 22 713 29ms 0ms 23 714 29ms 0ms [ User: a3dsupervisor - Total duration: 1s419ms - Times executed: 3961 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s419ms - Times executed: 3961 ]
-
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-11-03 18:25:18 Duration: 2ms 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-11-03 23:31:27 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-11-03 22:48:14 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
14 155ms 3,960 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 bind #14
Day Hour Count Duration Avg duration 18 394 12ms 0ms 19 713 25ms 0ms 20 713 31ms 0ms 21 713 29ms 0ms 22 713 27ms 0ms 23 714 28ms 0ms [ User: a3dsupervisor - Total duration: 75ms - Times executed: 3960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 75ms - Times executed: 3960 ]
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-11-03 18:26:50 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-11-03 20:59:03 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-11-03 19:32:49 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
15 151ms 1 151ms 151ms 151ms select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 18 1 151ms 151ms [ User: a3dsupervisor - Total duration: 403ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 403ms - Times executed: 1 ]
-
select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;
Date: 2025-11-03 18:25:24 Duration: 151ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
16 151ms 3,959 0ms 0ms 0ms SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 18 394 11ms 0ms 19 713 24ms 0ms 20 712 30ms 0ms 21 713 28ms 0ms 22 713 27ms 0ms 23 714 28ms 0ms [ User: a3dsupervisor - Total duration: 86ms - Times executed: 3959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 86ms - Times executed: 3959 ]
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-11-03 19:53:27 Duration: 0ms 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-11-03 20:39:58 Duration: 0ms 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-11-03 20:30:22 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
17 150ms 48 1ms 50ms 3ms 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 #17
Day Hour Count Duration Avg duration 00 2 3ms 1ms 01 2 4ms 2ms 02 2 4ms 2ms 03 2 3ms 1ms 04 2 4ms 2ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 53ms 26ms 08 2 4ms 2ms 09 2 4ms 2ms 10 2 4ms 2ms 11 2 4ms 2ms 12 2 4ms 2ms 13 2 4ms 2ms 14 2 4ms 2ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 4ms 2ms 18 2 4ms 2ms 19 2 4ms 2ms 20 2 4ms 2ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms [ User: azuresu - Total duration: 221ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 221ms - 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-11-03 07:50:59 Duration: 50ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-03 17:51:35 Duration: 2ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-11-03 13:51:21 Duration: 2ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
18 146ms 1 146ms 146ms 146ms 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;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 18 1 146ms 146ms [ User: a3dsupervisor - Total duration: 256ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 256ms - Times executed: 1 ]
-
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-11-03 18:25:22 Duration: 146ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
19 145ms 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 #19
Day Hour Count Duration Avg duration 18 714 14ms 0ms 19 1,428 27ms 0ms 20 1,428 27ms 0ms 21 1,428 25ms 0ms 22 1,428 25ms 0ms 23 1,428 25ms 0ms [ User: a3dsupervisor - Total duration: 2s598ms - Times executed: 7854 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s598ms - 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-11-03 19:35: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-11-03 19:50: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-11-03 19:40:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 143ms 2 1ms 141ms 71ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 18 1 141ms 141ms 22 1 1ms 1ms [ User: a3dsupervisor - Total duration: 1s997ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s997ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 18:26:20 Duration: 141ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-03 22:26:20 Duration: 1ms 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