pgBadger-
Global information
- Generated on Mon Sep 22 15:55:35 2025
- Log file: ././A3D-RND-REF/y=2025/m=09/d=19/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=09/d=19/h=23/m=00/PT1H.log
- Parsed 1,188,240 log entries in 7m9s
- Log start from 2025-09-19 00:02:20 to 2025-09-19 23:35:31
-
Overview
Global Stats
- 151 Number of unique normalized queries
- 473,554 Number of queries
- 3m13s Total query duration
- 2025-09-19 00:02:20 First query
- 2025-09-19 23:35:31 Last query
- 626 queries/s at 2025-09-19 07:37:19 Query peak
- 3m13s Total query duration
- 5s642ms Prepare/parse total duration
- 15s700ms Bind total duration
- 2m51s Execute total duration
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 217 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
- 232 Total number of sessions
- 9 sessions at 2025-09-19 10:46:14 Session peak
- 18h23m55s Total duration of sessions
- 4m45s Average duration of sessions
- 2,041 Average queries per session
- 832ms Average queries duration per session
- 4m44s Average idle time per session
- 228 Total number of connections
- 4 connections/s at 2025-09-19 07:52:04 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 626 queries/s Query Peak
- 2025-09-19 07:37:19 Date
SELECT Traffic
Key values
- 133 queries/s Query Peak
- 2025-09-19 07:37:19 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 248 queries/s Query Peak
- 2025-09-19 07:37:19 Date
Queries duration
Key values
- 3m13s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 03 6 0ms 5ms 1ms 5ms 5ms 5ms 04 6 0ms 6ms 1ms 6ms 6ms 6ms 05 6 0ms 4ms 1ms 4ms 4ms 4ms 06 6 0ms 10ms 2ms 11ms 11ms 11ms 07 28,974 0ms 803ms 0ms 714ms 1s346ms 1s704ms 08 73,534 0ms 22ms 0ms 174ms 195ms 210ms 09 73,848 0ms 50ms 0ms 223ms 239ms 297ms 10 50,687 0ms 10s367ms 1ms 6s29ms 6s373ms 19s867ms 11 40,570 0ms 3s369ms 0ms 874ms 2s432ms 11s907ms 12 40,765 0ms 16ms 0ms 112ms 130ms 153ms 13 40,778 0ms 17ms 0ms 138ms 148ms 220ms 14 41,293 0ms 13ms 0ms 125ms 138ms 170ms 15 40,733 0ms 209ms 0ms 131ms 206ms 396ms 16 40,763 0ms 57ms 0ms 134ms 139ms 141ms 17 1,531 0ms 5ms 0ms 116ms 116ms 116ms 18 6 0ms 6ms 1ms 6ms 6ms 6ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 5ms 1ms 5ms 5ms 5ms 21 6 0ms 4ms 1ms 5ms 5ms 5ms 22 6 0ms 4ms 1ms 5ms 5ms 5ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 3 0 2ms 4ms 4ms 4ms 01 3 0 3ms 4ms 4ms 4ms 02 3 0 2ms 4ms 4ms 4ms 03 3 0 3ms 5ms 5ms 5ms 04 3 0 3ms 6ms 6ms 6ms 05 3 0 2ms 4ms 4ms 4ms 06 3 0 5ms 11ms 11ms 11ms 07 7,452 0 0ms 36ms 92ms 1s28ms 08 18,282 0 0ms 13ms 15ms 46ms 09 18,420 0 0ms 15ms 47ms 83ms 10 12,852 0 0ms 51ms 84ms 356ms 11 10,128 0 0ms 11ms 14ms 54ms 12 10,203 0 0ms 11ms 13ms 46ms 13 10,225 0 0ms 11ms 12ms 87ms 14 10,303 0 0ms 12ms 13ms 15ms 15 10,168 0 0ms 10ms 13ms 19ms 16 10,184 0 0ms 11ms 13ms 19ms 17 413 0 0ms 10ms 10ms 10ms 18 3 0 3ms 6ms 6ms 6ms 19 3 0 3ms 4ms 4ms 4ms 20 3 0 3ms 5ms 5ms 5ms 21 3 0 3ms 4ms 4ms 4ms 22 3 0 3ms 4ms 4ms 4ms 23 3 0 2ms 4ms 4ms 4ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 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 996 3 521 0 1ms 3ms 10ms 616ms 08 2,894 0 1,438 0 0ms 3ms 10ms 45ms 09 2,898 0 1,442 0 0ms 4ms 24ms 56ms 10 2,348 0 958 0 5ms 18ms 203ms 1s509ms 11 2,177 1 710 0 1ms 1ms 24ms 346ms 12 2,181 0 713 0 0ms 2ms 10ms 44ms 13 2,181 0 713 0 0ms 2ms 21ms 46ms 14 2,191 0 723 0 0ms 2ms 22ms 48ms 15 2,181 1 714 0 0ms 2ms 23ms 52ms 16 2,181 0 713 0 0ms 2ms 22ms 47ms 17 143 0 20 0 0ms 1ms 35ms 35ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 19 00 6 6 1.00 200.00% 01 6 6 1.00 200.00% 02 6 6 1.00 200.00% 03 6 6 1.00 200.00% 04 6 6 1.00 200.00% 05 6 6 1.00 200.00% 06 6 6 1.00 200.00% 07 462 14,463 31.31 2.32% 08 62 36,627 590.76 0.12% 09 125 36,807 294.46 0.25% 10 353 25,604 72.53 1.01% 11 76 20,315 267.30 0.28% 12 53 20,429 385.45 0.19% 13 77 20,449 265.57 0.28% 14 30 20,653 688.43 0.11% 15 26 20,395 784.42 0.09% 16 16 20,415 1,275.94 0.06% 17 11 831 75.55 1.02% 18 6 6 1.00 200.00% 19 6 6 1.00 200.00% 20 6 6 1.00 200.00% 21 6 6 1.00 200.00% 22 6 6 1.00 200.00% 23 6 6 1.00 200.00% Day Hour Count Average / Second Sep 19 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 29 0.01/s 08 32 0.01/s 09 53 0.01/s 10 51 0.01/s 11 5 0.00/s 12 6 0.00/s 13 13 0.00/s 14 5 0.00/s 15 3 0.00/s 16 3 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Sep 19 00 2 72ms 67ms 01 2 73ms 68ms 02 2 72ms 67ms 03 2 72ms 67ms 04 2 74ms 68ms 05 2 71ms 66ms 06 2 119ms 110ms 07 27 58s400ms 58s155ms 08 32 1m4s 1m4s 09 53 56s36ms 55s858ms 10 55 4m15s 4m13s 11 5 52s831ms 46s782ms 12 6 259ms 0ms 13 13 23s256ms 22s853ms 14 5 35s668ms 34s637ms 15 3 29s696ms 27s791ms 16 3 173ms 0ms 17 4 3h6m28s 3h6m28s 18 2 100ms 94ms 19 2 75ms 70ms 20 2 74ms 69ms 21 2 72ms 67ms 22 2 70ms 65ms 23 2 69ms 65ms -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2025-09-19 07:52:04 Date
Connections per database
Key values
- pentest Main Database
- 228 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 228 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2025-09-19 10:46:14 Date
Histogram of session times
Key values
- 126 60000-600000ms duration
Sessions per database
Key values
- pentest Main Database
- 232 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 232 sessions Total
Sessions per host
Key values
- 10.3.6.4 Main Host
- 232 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 4.20 MiB Temp Files size Peak
- 2025-09-19 07:37:23 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2025-09-19 07:37:23 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 19 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 1 4.20 MiB 4.20 MiB 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 0 0 0 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-09-19 07:37:23 Duration: 324ms 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-09-19 07:37:23 Duration: 0ms 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-09-19 07:37:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
Queries generating the largest temporary files
Rank Size Query 1 4.20 MiB select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49803;[ Date: 2025-09-19 07:37:23 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- public.applicative_lock (209) Main table analyzed (database pentest)
- 217 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 Sep 19 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 15 08 0 30 09 0 30 10 0 20 11 0 20 12 0 20 13 0 21 14 0 19 15 0 20 16 0 21 17 0 1 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 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
- 118,669 Total read queries
- 205,403 Total write queries
Queries by database
Key values
- pentest Main database
- 473,554 Requests
- 2m51s (pentest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 473,410 Requests
User Request type Count Duration a3dsupervisor Total 473,410 2m51s delete 8,665 11s835ms insert 22,371 18s83ms others 226 3s167ms select 118,597 10s902ms tcl 174,362 1m56s update 5 1s209ms azuresu Total 144 249ms others 72 3ms select 72 245ms Duration by user
Key values
- 2m51s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 473,410 2m51s delete 8,665 11s835ms insert 22,371 18s83ms others 226 3s167ms select 118,597 10s902ms tcl 174,362 1m56s update 5 1s209ms azuresu Total 144 249ms others 72 3ms select 72 245ms Queries by host
Key values
- 10.3.6.4 Main host
- 472,974 Requests
- 2m49s (10.3.6.4)
- Main time consuming host
Host Request type Count Duration 10.3.0.4 Total 433 1s991ms others 5 0ms select 422 1s990ms tcl 6 0ms 10.3.1.6 Total 3 0ms select 3 0ms 10.3.6.4 Total 472,974 2m49s delete 8,665 11s835ms insert 22,371 18s83ms others 221 3s166ms select 118,172 8s911ms tcl 174,356 1m56s update 5 1s209ms 169.254.128.1 Total 144 249ms others 72 3ms select 72 245ms Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 472,999 Requests
- 2m49s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-19 09:30:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 454,508 0-1ms duration
Slowest individual queries
Rank Duration Query 1 10s367ms delete from APPLICATIVE_LOCK where LOCK_KEY =;[ Date: 2025-09-19 10:35:07 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 3s369ms COMMIT;[ Date: 2025-09-19 11:04:25 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 3s211ms COMMIT;[ Date: 2025-09-19 11:04:47 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 2s522ms COMMIT;[ Date: 2025-09-19 11:04:43 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 2s194ms COMMIT;[ Date: 2025-09-19 10:59:57 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 2s9ms COMMIT;[ Date: 2025-09-19 10:54:02 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 1s952ms COMMIT;[ Date: 2025-09-19 10:39:38 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 1s773ms COMMIT;[ Date: 2025-09-19 11:04:22 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 1s650ms COMMIT;[ Date: 2025-09-19 11:03:03 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 1s436ms COMMIT;[ Date: 2025-09-19 10:47:18 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 1s393ms COMMIT;[ Date: 2025-09-19 11:02:25 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 1s339ms COMMIT;[ Date: 2025-09-19 10:58:11 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 1s311ms COMMIT;[ Date: 2025-09-19 10:52:47 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 1s310ms SET application_name = 'PostgreSQL JDBC Driver';[ Date: 2025-09-19 10:45:59 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver ]
15 1s309ms SET application_name = 'PostgreSQL JDBC Driver';[ Date: 2025-09-19 10:45:59 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver ]
16 1s262ms BEGIN READ ONLY;[ Date: 2025-09-19 10:35:07 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver ]
17 1s231ms COMMIT;[ Date: 2025-09-19 10:38:58 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 1s213ms COMMIT;[ Date: 2025-09-19 10:34:51 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 1s101ms BEGIN;[ Date: 2025-09-19 10:35:07 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver ]
20 1s87ms COMMIT;[ Date: 2025-09-19 10:34:50 - Database: pentest - User: a3dsupervisor - Remote: 10.3.6.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1m48s 87,184 0ms 3s369ms 1ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 19 09 5,478 2s137ms 0ms 10 14,000 6s35ms 0ms 11 14,034 6s296ms 0ms 12 9,435 55s154ms 5ms 13 7,286 23s466ms 3ms 14 7,319 3s62ms 0ms 15 7,317 3s43ms 0ms 16 7,423 3s161ms 0ms 17 7,318 3s432ms 0ms 18 7,324 3s95ms 0ms 19 250 90ms 0ms [ User: a3dsupervisor - Total duration: 1m48s - Times executed: 87184 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m48s - Times executed: 87184 ]
-
COMMIT;
Date: 2025-09-19 11:04:25 Duration: 3s369ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-19 11:04:47 Duration: 3s211ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-19 11:04:43 Duration: 2s522ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 11s125ms 8,616 0ms 10s367ms 1ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 19 09 505 23ms 0ms 10 1,426 76ms 0ms 11 1,430 92ms 0ms 12 951 10s553ms 11ms 13 709 48ms 0ms 14 713 51ms 0ms 15 713 66ms 0ms 16 723 68ms 0ms 17 713 72ms 0ms 18 713 69ms 0ms 19 20 2ms 0ms [ User: a3dsupervisor - Total duration: 11s125ms - Times executed: 8616 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s125ms - Times executed: 8616 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-09-19 10:35:07 Duration: 10s367ms 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-09-19 10:46:16 Duration: 83ms 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-09-19 10:36:00 Duration: 27ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 10s984ms 13,380 0ms 697ms 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 Sep 19 09 476 596ms 1ms 10 1,428 340ms 0ms 11 1,428 516ms 0ms 12 1,361 3s303ms 2ms 13 1,428 4s373ms 3ms 14 1,428 274ms 0ms 15 1,428 392ms 0ms 16 1,428 381ms 0ms 17 1,428 395ms 0ms 18 1,428 378ms 0ms 19 119 30ms 0ms [ User: a3dsupervisor - Total duration: 10s984ms - Times executed: 13380 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s984ms - Times executed: 13380 ]
-
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-09-19 10:35:08 Duration: 697ms 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-09-19 11:00:02 Duration: 430ms 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-09-19 11:00:03 Duration: 307ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 6s234ms 8,615 0ms 770ms 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 #4
Day Hour Count Duration Avg duration Sep 19 09 505 56ms 0ms 10 1,426 165ms 0ms 11 1,430 211ms 0ms 12 950 4s342ms 4ms 13 709 774ms 1ms 14 713 108ms 0ms 15 713 140ms 0ms 16 723 147ms 0ms 17 713 144ms 0ms 18 713 139ms 0ms 19 20 3ms 0ms [ User: a3dsupervisor - Total duration: 6s234ms - Times executed: 8615 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s234ms - Times executed: 8615 ]
-
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-09-19 10:34:49 Duration: 770ms 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-09-19 10:34:49 Duration: 769ms 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-09-19 10:34:56 Duration: 638ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 4s818ms 63,328 0ms 1s262ms 0ms begin read only;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 19 09 4,278 141ms 0ms 10 10,827 414ms 0ms 11 10,852 548ms 0ms 12 7,163 1s808ms 0ms 13 4,970 190ms 0ms 14 4,997 264ms 0ms 15 4,996 358ms 0ms 16 5,069 360ms 0ms 17 4,994 356ms 0ms 18 5,000 361ms 0ms 19 182 11ms 0ms [ User: a3dsupervisor - Total duration: 4s818ms - Times executed: 63328 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s818ms - Times executed: 63328 ]
-
BEGIN READ ONLY;
Date: 2025-09-19 10:35:07 Duration: 1s262ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-09-19 10:36:05 Duration: 142ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-09-19 10:37:01 Duration: 32ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
6 3s143ms 23,848 0ms 1s101ms 0ms begin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 09 1,202 28ms 0ms 10 3,173 92ms 0ms 11 3,182 121ms 0ms 12 2,262 2s273ms 1ms 13 2,316 59ms 0ms 14 2,322 84ms 0ms 15 2,321 120ms 0ms 16 2,354 118ms 0ms 17 2,324 120ms 0ms 18 2,324 120ms 0ms 19 68 3ms 0ms [ User: a3dsupervisor - Total duration: 3s143ms - Times executed: 23848 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s143ms - Times executed: 23848 ]
-
BEGIN;
Date: 2025-09-19 10:35:07 Duration: 1s101ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-09-19 10:46:14 Duration: 503ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-09-19 10:46:14 Duration: 503ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
7 2s854ms 128 0ms 1s310ms 22ms set application_name = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 09 19 9ms 0ms 10 28 9ms 0ms 11 37 17ms 0ms 12 34 2s804ms 82ms 13 3 0ms 0ms 15 4 3ms 0ms 16 2 1ms 0ms 17 1 8ms 8ms [ User: a3dsupervisor - Total duration: 2s854ms - Times executed: 128 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s854ms - Times executed: 128 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-09-19 10:45:59 Duration: 1s310ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-09-19 10:45:59 Duration: 1s309ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-09-19 10:35:16 Duration: 134ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
8 2s502ms 6,519 0ms 97ms 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 Sep 19 09 253 94ms 0ms 10 713 257ms 0ms 11 715 256ms 0ms 12 536 317ms 0ms 13 708 258ms 0ms 14 713 259ms 0ms 15 713 258ms 0ms 16 723 267ms 0ms 17 712 258ms 0ms 18 713 267ms 0ms 19 20 6ms 0ms [ User: a3dsupervisor - Total duration: 2s502ms - Times executed: 6519 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s502ms - Times executed: 6519 ]
-
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-09-19 10:46:16 Duration: 97ms 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-09-19 10:59:13 Duration: 7ms 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-09-19 07:37:19 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s198ms 3 185ms 803ms 399ms 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 #9
Day Hour Count Duration Avg duration Sep 19 09 1 803ms 803ms 13 1 185ms 185ms 17 1 209ms 209ms [ User: a3dsupervisor - Total duration: 1s198ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s198ms - Times executed: 3 ]
-
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-09-19 07:38:21 Duration: 803ms 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-09-19 15:38:21 Duration: 209ms 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-09-19 11:38:21 Duration: 185ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s180ms 13,787 0ms 650ms 0ms select nextval(?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 19 09 491 31ms 0ms 10 1,468 19ms 0ms 11 1,468 26ms 0ms 12 1,429 942ms 0ms 13 1,468 27ms 0ms 14 1,468 18ms 0ms 15 1,468 25ms 0ms 16 1,468 30ms 0ms 17 1,468 24ms 0ms 18 1,468 31ms 0ms 19 123 2ms 0ms [ User: a3dsupervisor - Total duration: 1s180ms - Times executed: 13787 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 13787 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-09-19 10:35:19 Duration: 650ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-09-19 10:46:15 Duration: 86ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_THREAD_NUM_ID_SEQ');
Date: 2025-09-19 10:46:16 Duration: 54ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s160ms 23,054 0ms 347ms 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 #11
Day Hour Count Duration Avg duration Sep 19 09 1,262 33ms 0ms 10 3,565 97ms 0ms 11 3,575 104ms 0ms 12 2,424 425ms 0ms 13 2,017 81ms 0ms 14 2,025 80ms 0ms 15 2,024 83ms 0ms 16 2,055 83ms 0ms 17 2,025 80ms 0ms 18 2,026 86ms 0ms 19 56 2ms 0ms [ User: a3dsupervisor - Total duration: 1s160ms - Times executed: 23054 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s160ms - Times executed: 23054 ]
-
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-09-19 10:36:56 Duration: 347ms 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-09-19 09:47:31 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-09-19 07:44:09 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s47ms 20,953 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 #12
Day Hour Count Duration Avg duration Sep 19 09 1,010 41ms 0ms 10 2,852 122ms 0ms 11 2,860 112ms 0ms 12 2,007 98ms 0ms 13 2,015 121ms 0ms 14 2,025 110ms 0ms 15 2,024 110ms 0ms 16 2,055 109ms 0ms 17 2,023 105ms 0ms 18 2,026 111ms 0ms 19 56 2ms 0ms [ User: a3dsupervisor - Total duration: 1s47ms - Times executed: 20953 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s47ms - Times executed: 20953 ]
-
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-09-19 07:37: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-09-19 08:46:09 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-09-19 08:46:09 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 708ms 51 12ms 19ms 13ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 19 09 5 70ms 14ms 10 2 26ms 13ms 11 14 193ms 13ms 12 17 231ms 13ms 14 4 55ms 13ms 15 7 100ms 14ms 16 1 13ms 13ms 18 1 17ms 17ms [ User: a3dsupervisor - Total duration: 708ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 708ms - Times executed: 51 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:56:42 Duration: 19ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 16:41:15 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 13:20:38 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
14 541ms 17,232 0ms 153ms 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 #14
Day Hour Count Duration Avg duration Sep 19 09 1,010 19ms 0ms 10 2,852 54ms 0ms 11 2,860 57ms 0ms 12 1,902 198ms 0ms 13 1,418 39ms 0ms 14 1,426 31ms 0ms 15 1,426 32ms 0ms 16 1,446 33ms 0ms 17 1,426 35ms 0ms 18 1,426 38ms 0ms 19 40 0ms 0ms [ User: a3dsupervisor - Total duration: 541ms - Times executed: 17232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 541ms - Times executed: 17232 ]
-
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-09-19 10:35:19 Duration: 153ms 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-09-19 11:33:04 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-19 10:46:41 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 462ms 51 7ms 18ms 9ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 09 5 52ms 10ms 10 2 26ms 13ms 11 14 119ms 8ms 12 17 144ms 8ms 14 4 40ms 10ms 15 7 56ms 8ms 16 1 7ms 7ms 18 1 16ms 16ms [ User: a3dsupervisor - Total duration: 462ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 462ms - Times executed: 51 ]
-
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-09-19 08:31:19 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
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-09-19 07:17:20 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
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-09-19 12:00:07 Duration: 16ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
16 404ms 3 64ms 271ms 134ms 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 Sep 19 09 1 271ms 271ms 13 1 68ms 68ms 17 1 64ms 64ms [ User: a3dsupervisor - Total duration: 404ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 404ms - Times executed: 3 ]
-
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-09-19 07:38:22 Duration: 271ms 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-09-19 11:38:21 Duration: 68ms 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-09-19 15:38:21 Duration: 64ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 384ms 51 6ms 16ms 7ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 09 5 50ms 10ms 10 2 15ms 7ms 11 14 103ms 7ms 12 17 123ms 7ms 14 4 27ms 6ms 15 7 50ms 7ms 16 1 6ms 6ms 18 1 6ms 6ms [ User: a3dsupervisor - Total duration: 384ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 384ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:41:30 Duration: 16ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:20 Duration: 13ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 10:28:15 Duration: 9ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
18 357ms 51 6ms 17ms 7ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 09 5 44ms 8ms 10 2 15ms 7ms 11 14 93ms 6ms 12 17 115ms 6ms 14 4 26ms 6ms 15 7 46ms 6ms 16 1 9ms 9ms 18 1 6ms 6ms [ User: a3dsupervisor - Total duration: 357ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 357ms - Times executed: 51 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 07:41:30 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 10:03:17 Duration: 9ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 14:45:43 Duration: 9ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
19 340ms 50 0ms 324ms 6ms select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 09 50 340ms 6ms [ User: a3dsupervisor - Total duration: 340ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 340ms - 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-09-19 07:37:23 Duration: 324ms 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-09-19 07:37:23 Duration: 0ms 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-09-19 07:37:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 335ms 112 0ms 139ms 2ms insert into gtp_log_jvm (log_date, max_memory, server_id, total_memory_average, total_memory_max, total_memory_min, used_memory_average, used_memory_max, used_memory_min, log_jvm_num_id) values (,,,,,,,,,);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 09 4 1ms 0ms 10 12 6ms 0ms 11 12 6ms 0ms 12 11 229ms 20ms 13 12 50ms 4ms 14 12 7ms 0ms 15 12 6ms 0ms 16 12 7ms 0ms 17 12 10ms 0ms 18 12 7ms 0ms 19 1 0ms 0ms [ User: a3dsupervisor - Total duration: 335ms - Times executed: 112 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 335ms - Times executed: 112 ]
-
insert into GTP_LOG_JVM (LOG_DATE, MAX_MEMORY, SERVER_ID, TOTAL_MEMORY_AVERAGE, TOTAL_MEMORY_MAX, TOTAL_MEMORY_MIN, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_JVM_NUM_ID) values (,,,,,,,,,);
Date: 2025-09-19 10:37:04 Duration: 139ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_JVM (LOG_DATE, MAX_MEMORY, SERVER_ID, TOTAL_MEMORY_AVERAGE, TOTAL_MEMORY_MAX, TOTAL_MEMORY_MIN, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_JVM_NUM_ID) values (,,,,,,,,,);
Date: 2025-09-19 10:46:16 Duration: 76ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_JVM (LOG_DATE, MAX_MEMORY, SERVER_ID, TOTAL_MEMORY_AVERAGE, TOTAL_MEMORY_MAX, TOTAL_MEMORY_MIN, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_JVM_NUM_ID) values (,,,,,,,,,);
Date: 2025-09-19 11:05:02 Duration: 23ms 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 87,184 1m48s 0ms 3s369ms 1ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 19 09 5,478 2s137ms 0ms 10 14,000 6s35ms 0ms 11 14,034 6s296ms 0ms 12 9,435 55s154ms 5ms 13 7,286 23s466ms 3ms 14 7,319 3s62ms 0ms 15 7,317 3s43ms 0ms 16 7,423 3s161ms 0ms 17 7,318 3s432ms 0ms 18 7,324 3s95ms 0ms 19 250 90ms 0ms [ User: a3dsupervisor - Total duration: 1m48s - Times executed: 87184 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m48s - Times executed: 87184 ]
-
COMMIT;
Date: 2025-09-19 11:04:25 Duration: 3s369ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-19 11:04:47 Duration: 3s211ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-19 11:04:43 Duration: 2s522ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 63,328 4s818ms 0ms 1s262ms 0ms begin read only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 19 09 4,278 141ms 0ms 10 10,827 414ms 0ms 11 10,852 548ms 0ms 12 7,163 1s808ms 0ms 13 4,970 190ms 0ms 14 4,997 264ms 0ms 15 4,996 358ms 0ms 16 5,069 360ms 0ms 17 4,994 356ms 0ms 18 5,000 361ms 0ms 19 182 11ms 0ms [ User: a3dsupervisor - Total duration: 4s818ms - Times executed: 63328 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s818ms - Times executed: 63328 ]
-
BEGIN READ ONLY;
Date: 2025-09-19 10:35:07 Duration: 1s262ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-09-19 10:36:05 Duration: 142ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-09-19 10:37:01 Duration: 32ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
3 23,848 3s143ms 0ms 1s101ms 0ms begin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 19 09 1,202 28ms 0ms 10 3,173 92ms 0ms 11 3,182 121ms 0ms 12 2,262 2s273ms 1ms 13 2,316 59ms 0ms 14 2,322 84ms 0ms 15 2,321 120ms 0ms 16 2,354 118ms 0ms 17 2,324 120ms 0ms 18 2,324 120ms 0ms 19 68 3ms 0ms [ User: a3dsupervisor - Total duration: 3s143ms - Times executed: 23848 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s143ms - Times executed: 23848 ]
-
BEGIN;
Date: 2025-09-19 10:35:07 Duration: 1s101ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-09-19 10:46:14 Duration: 503ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-09-19 10:46:14 Duration: 503ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
4 23,054 1s160ms 0ms 347ms 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 #4
Day Hour Count Duration Avg duration Sep 19 09 1,262 33ms 0ms 10 3,565 97ms 0ms 11 3,575 104ms 0ms 12 2,424 425ms 0ms 13 2,017 81ms 0ms 14 2,025 80ms 0ms 15 2,024 83ms 0ms 16 2,055 83ms 0ms 17 2,025 80ms 0ms 18 2,026 86ms 0ms 19 56 2ms 0ms [ User: a3dsupervisor - Total duration: 1s160ms - Times executed: 23054 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s160ms - Times executed: 23054 ]
-
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-09-19 10:36:56 Duration: 347ms 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-09-19 09:47:31 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-09-19 07:44:09 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 20,953 1s47ms 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 #5
Day Hour Count Duration Avg duration Sep 19 09 1,010 41ms 0ms 10 2,852 122ms 0ms 11 2,860 112ms 0ms 12 2,007 98ms 0ms 13 2,015 121ms 0ms 14 2,025 110ms 0ms 15 2,024 110ms 0ms 16 2,055 109ms 0ms 17 2,023 105ms 0ms 18 2,026 111ms 0ms 19 56 2ms 0ms [ User: a3dsupervisor - Total duration: 1s47ms - Times executed: 20953 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s47ms - Times executed: 20953 ]
-
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-09-19 07:37: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-09-19 08:46:09 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-09-19 08:46:09 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 17,232 541ms 0ms 153ms 0ms select null, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 09 1,010 19ms 0ms 10 2,852 54ms 0ms 11 2,860 57ms 0ms 12 1,902 198ms 0ms 13 1,418 39ms 0ms 14 1,426 31ms 0ms 15 1,426 32ms 0ms 16 1,446 33ms 0ms 17 1,426 35ms 0ms 18 1,426 38ms 0ms 19 40 0ms 0ms [ User: a3dsupervisor - Total duration: 541ms - Times executed: 17232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 541ms - Times executed: 17232 ]
-
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-09-19 10:35:19 Duration: 153ms 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-09-19 11:33:04 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-19 10:46:41 Duration: 3ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 13,787 1s180ms 0ms 650ms 0ms select nextval(?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 09 491 31ms 0ms 10 1,468 19ms 0ms 11 1,468 26ms 0ms 12 1,429 942ms 0ms 13 1,468 27ms 0ms 14 1,468 18ms 0ms 15 1,468 25ms 0ms 16 1,468 30ms 0ms 17 1,468 24ms 0ms 18 1,468 31ms 0ms 19 123 2ms 0ms [ User: a3dsupervisor - Total duration: 1s180ms - Times executed: 13787 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 13787 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-09-19 10:35:19 Duration: 650ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-09-19 10:46:15 Duration: 86ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_THREAD_NUM_ID_SEQ');
Date: 2025-09-19 10:46:16 Duration: 54ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 13,380 10s984ms 0ms 697ms 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 #8
Day Hour Count Duration Avg duration Sep 19 09 476 596ms 1ms 10 1,428 340ms 0ms 11 1,428 516ms 0ms 12 1,361 3s303ms 2ms 13 1,428 4s373ms 3ms 14 1,428 274ms 0ms 15 1,428 392ms 0ms 16 1,428 381ms 0ms 17 1,428 395ms 0ms 18 1,428 378ms 0ms 19 119 30ms 0ms [ User: a3dsupervisor - Total duration: 10s984ms - Times executed: 13380 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s984ms - Times executed: 13380 ]
-
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-09-19 10:35:08 Duration: 697ms 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-09-19 11:00:02 Duration: 430ms 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-09-19 11:00:03 Duration: 307ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 8,616 11s125ms 0ms 10s367ms 1ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 19 09 505 23ms 0ms 10 1,426 76ms 0ms 11 1,430 92ms 0ms 12 951 10s553ms 11ms 13 709 48ms 0ms 14 713 51ms 0ms 15 713 66ms 0ms 16 723 68ms 0ms 17 713 72ms 0ms 18 713 69ms 0ms 19 20 2ms 0ms [ User: a3dsupervisor - Total duration: 11s125ms - Times executed: 8616 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s125ms - Times executed: 8616 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-09-19 10:35:07 Duration: 10s367ms 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-09-19 10:46:16 Duration: 83ms 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-09-19 10:36:00 Duration: 27ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 8,615 6s234ms 0ms 770ms 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 #10
Day Hour Count Duration Avg duration Sep 19 09 505 56ms 0ms 10 1,426 165ms 0ms 11 1,430 211ms 0ms 12 950 4s342ms 4ms 13 709 774ms 1ms 14 713 108ms 0ms 15 713 140ms 0ms 16 723 147ms 0ms 17 713 144ms 0ms 18 713 139ms 0ms 19 20 3ms 0ms [ User: a3dsupervisor - Total duration: 6s234ms - Times executed: 8615 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s234ms - Times executed: 8615 ]
-
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-09-19 10:34:49 Duration: 770ms 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-09-19 10:34:49 Duration: 769ms 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-09-19 10:34:56 Duration: 638ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 6,519 2s502ms 0ms 97ms 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 #11
Day Hour Count Duration Avg duration Sep 19 09 253 94ms 0ms 10 713 257ms 0ms 11 715 256ms 0ms 12 536 317ms 0ms 13 708 258ms 0ms 14 713 259ms 0ms 15 713 258ms 0ms 16 723 267ms 0ms 17 712 258ms 0ms 18 713 267ms 0ms 19 20 6ms 0ms [ User: a3dsupervisor - Total duration: 2s502ms - Times executed: 6519 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s502ms - Times executed: 6519 ]
-
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-09-19 10:46:16 Duration: 97ms 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-09-19 10:59:13 Duration: 7ms 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-09-19 07:37:19 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 6,518 151ms 0ms 4ms 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 #12
Day Hour Count Duration Avg duration Sep 19 09 252 5ms 0ms 10 713 12ms 0ms 11 715 13ms 0ms 12 536 13ms 0ms 13 708 16ms 0ms 14 713 18ms 0ms 15 713 15ms 0ms 16 723 18ms 0ms 17 712 21ms 0ms 18 713 16ms 0ms 19 20 0ms 0ms [ User: a3dsupervisor - Total duration: 151ms - Times executed: 6518 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 151ms - Times executed: 6518 ]
-
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-09-19 15:21:47 Duration: 4ms 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-09-19 12:48:53 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-09-19 15:33:04 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 6,517 192ms 0ms 2ms 0ms select gotcratcp1_0.id, gotcratcp1_0.att_template_category_num_id, gotcratcp1_0.att_template_num_id, gotcratcp1_0.insert_date, gotcratcp1_0.obj_num_id, gotcratcp1_0.obj_template_num_id from gtp_obj_template_calcul_rule_att_to_compute gotcratcp1_0 where gotcratcp1_0.obj_num_id is null;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 19 09 252 5ms 0ms 10 713 15ms 0ms 11 715 15ms 0ms 12 535 17ms 0ms 13 708 22ms 0ms 14 713 20ms 0ms 15 713 21ms 0ms 16 723 24ms 0ms 17 712 23ms 0ms 18 713 23ms 0ms 19 20 0ms 0ms [ User: a3dsupervisor - Total duration: 192ms - Times executed: 6517 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 192ms - Times executed: 6517 ]
-
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-09-19 10:52:02 Duration: 2ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotcratcp1_0.ID, gotcratcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcratcp1_0.ATT_TEMPLATE_NUM_ID, gotcratcp1_0.INSERT_DATE, gotcratcp1_0.OBJ_NUM_ID, gotcratcp1_0.OBJ_TEMPLATE_NUM_ID from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0 where gotcratcp1_0.OBJ_NUM_ID is null;
Date: 2025-09-19 14:39:51 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-09-19 14:38:00 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 6,516 52ms 0ms 3ms 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 #14
Day Hour Count Duration Avg duration Sep 19 09 252 1ms 0ms 10 713 2ms 0ms 11 715 3ms 0ms 12 534 6ms 0ms 13 708 5ms 0ms 14 713 5ms 0ms 15 713 6ms 0ms 16 723 9ms 0ms 17 712 5ms 0ms 18 713 5ms 0ms 19 20 0ms 0ms [ User: a3dsupervisor - Total duration: 52ms - Times executed: 6516 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52ms - Times executed: 6516 ]
-
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-09-19 14:56:16 Duration: 3ms 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-09-19 10:59:18 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-09-19 10:53:29 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 4,192 23ms 0ms 0ms 0ms select gotcrp1_0.rule_id, gotcrp1_0.att_template_category_num_id, gotcrp1_0.att_template_num_id, gotcrp1_0.else_condition, gotcrp1_0.formula, gotcrp1_0.label, gotcrp1_0.obj_template_num_id, gotcrp1_0.parent_rule_id, gotcrp1_0.rule_order from gtp_obj_template_calculation_rule gotcrp1_0 where ? = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 09 504 3ms 0ms 10 1,426 7ms 0ms 11 1,430 8ms 0ms 12 832 4ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 4192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23ms - Times executed: 4192 ]
-
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-09-19 09:44:39 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-09-19 08:58:52 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-09-19 10:00:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 2,650 64ms 0ms 1ms 0ms select count(gotcratcp1_0.id) from gtp_obj_template_calcul_rule_att_to_compute gotcratcp1_0;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 09 273 6ms 0ms 10 773 17ms 0ms 11 775 18ms 0ms 12 465 9ms 0ms 13 60 1ms 0ms 14 60 1ms 0ms 15 60 2ms 0ms 16 61 1ms 0ms 17 60 3ms 0ms 18 61 1ms 0ms 19 2 0ms 0ms [ User: a3dsupervisor - Total duration: 64ms - Times executed: 2650 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 64ms - Times executed: 2650 ]
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-09-19 08:07:33 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-09-19 09:30:31 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-09-19 07:55:01 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 2,208 167ms 0ms 44ms 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 #17
Day Hour Count Duration Avg duration Sep 19 09 90 3ms 0ms 10 240 12ms 0ms 11 241 15ms 0ms 12 188 56ms 0ms 13 240 14ms 0ms 14 240 14ms 0ms 15 240 12ms 0ms 16 242 13ms 0ms 17 240 11ms 0ms 18 241 12ms 0ms 19 6 0ms 0ms [ User: a3dsupervisor - Total duration: 167ms - Times executed: 2208 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 167ms - Times executed: 2208 ]
-
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-09-19 10:35:57 Duration: 44ms 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-09-19 10:37:01 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-09-19 09:23:47 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 2,141 187ms 0ms 109ms 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 #18
Day Hour Count Duration Avg duration Sep 19 09 275 10ms 0ms 10 720 26ms 0ms 11 722 24ms 0ms 12 424 126ms 0ms [ User: a3dsupervisor - Total duration: 187ms - Times executed: 2141 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 187ms - Times executed: 2141 ]
-
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-09-19 10:35:07 Duration: 109ms 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-09-19 07:46:04 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-09-19 08:52:14 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 2,096 34ms 0ms 3ms 0ms select * from gtp_obj_template_calcul_rule_att_to_compute gccc order by ? limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 09 252 3ms 0ms 10 713 13ms 0ms 11 715 11ms 0ms 12 416 6ms 0ms [ User: a3dsupervisor - Total duration: 34ms - Times executed: 2096 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 34ms - Times executed: 2096 ]
-
SELECT * FROM GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gccc order by 1 LIMIT 3999;
Date: 2025-09-19 08:36:29 Duration: 3ms 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-09-19 09:39:51 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-09-19 09:17:28 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,096 10ms 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 #20
Day Hour Count Duration Avg duration Sep 19 09 252 1ms 0ms 10 713 3ms 0ms 11 715 3ms 0ms 12 416 2ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 2096 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10ms - Times executed: 2096 ]
-
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-09-19 08:28:35 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-09-19 08:37:29 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-09-19 10:13:00 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 185ms 803ms 399ms 3 1s198ms 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 #1
Day Hour Count Duration Avg duration Sep 19 09 1 803ms 803ms 13 1 185ms 185ms 17 1 209ms 209ms [ User: a3dsupervisor - Total duration: 1s198ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s198ms - Times executed: 3 ]
-
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-09-19 07:38:21 Duration: 803ms 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-09-19 15:38:21 Duration: 209ms 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-09-19 11:38:21 Duration: 185ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 64ms 271ms 134ms 3 404ms 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 #2
Day Hour Count Duration Avg duration Sep 19 09 1 271ms 271ms 13 1 68ms 68ms 17 1 64ms 64ms [ User: a3dsupervisor - Total duration: 404ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 404ms - Times executed: 3 ]
-
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-09-19 07:38:22 Duration: 271ms 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-09-19 11:38:21 Duration: 68ms 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-09-19 15:38:21 Duration: 64ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 1s310ms 22ms 128 2s854ms set application_name = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 19 09 19 9ms 0ms 10 28 9ms 0ms 11 37 17ms 0ms 12 34 2s804ms 82ms 13 3 0ms 0ms 15 4 3ms 0ms 16 2 1ms 0ms 17 1 8ms 8ms [ User: a3dsupervisor - Total duration: 2s854ms - Times executed: 128 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s854ms - Times executed: 128 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-09-19 10:45:59 Duration: 1s310ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-09-19 10:45:59 Duration: 1s309ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-09-19 10:35:16 Duration: 134ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
4 12ms 19ms 13ms 51 708ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 19 09 5 70ms 14ms 10 2 26ms 13ms 11 14 193ms 13ms 12 17 231ms 13ms 14 4 55ms 13ms 15 7 100ms 14ms 16 1 13ms 13ms 18 1 17ms 17ms [ User: a3dsupervisor - Total duration: 708ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 708ms - Times executed: 51 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:56:42 Duration: 19ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 16:41:15 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 13:20:38 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
5 7ms 18ms 9ms 51 462ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 19 09 5 52ms 10ms 10 2 26ms 13ms 11 14 119ms 8ms 12 17 144ms 8ms 14 4 40ms 10ms 15 7 56ms 8ms 16 1 7ms 7ms 18 1 16ms 16ms [ User: a3dsupervisor - Total duration: 462ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 462ms - Times executed: 51 ]
-
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-09-19 08:31:19 Duration: 18ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
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-09-19 07:17:20 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
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-09-19 12:00:07 Duration: 16ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
6 6ms 16ms 7ms 51 384ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 09 5 50ms 10ms 10 2 15ms 7ms 11 14 103ms 7ms 12 17 123ms 7ms 14 4 27ms 6ms 15 7 50ms 7ms 16 1 6ms 6ms 18 1 6ms 6ms [ User: a3dsupervisor - Total duration: 384ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 384ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:41:30 Duration: 16ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:20 Duration: 13ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 10:28:15 Duration: 9ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
7 6ms 17ms 7ms 51 357ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 09 5 44ms 8ms 10 2 15ms 7ms 11 14 93ms 6ms 12 17 115ms 6ms 14 4 26ms 6ms 15 7 46ms 6ms 16 1 9ms 9ms 18 1 6ms 6ms [ User: a3dsupervisor - Total duration: 357ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 357ms - Times executed: 51 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 07:41:30 Duration: 17ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 10:03:17 Duration: 9ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 14:45:43 Duration: 9ms Database: pentest User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
8 0ms 324ms 6ms 50 340ms 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 #8
Day Hour Count Duration Avg duration Sep 19 09 50 340ms 6ms [ User: a3dsupervisor - Total duration: 340ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 340ms - 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-09-19 07:37:23 Duration: 324ms 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-09-19 07:37:23 Duration: 0ms 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-09-19 07:37:23 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 139ms 2ms 112 335ms insert into gtp_log_jvm (log_date, max_memory, server_id, total_memory_average, total_memory_max, total_memory_min, used_memory_average, used_memory_max, used_memory_min, log_jvm_num_id) values (,,,,,,,,,);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 19 09 4 1ms 0ms 10 12 6ms 0ms 11 12 6ms 0ms 12 11 229ms 20ms 13 12 50ms 4ms 14 12 7ms 0ms 15 12 6ms 0ms 16 12 7ms 0ms 17 12 10ms 0ms 18 12 7ms 0ms 19 1 0ms 0ms [ User: a3dsupervisor - Total duration: 335ms - Times executed: 112 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 335ms - Times executed: 112 ]
-
insert into GTP_LOG_JVM (LOG_DATE, MAX_MEMORY, SERVER_ID, TOTAL_MEMORY_AVERAGE, TOTAL_MEMORY_MAX, TOTAL_MEMORY_MIN, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_JVM_NUM_ID) values (,,,,,,,,,);
Date: 2025-09-19 10:37:04 Duration: 139ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_JVM (LOG_DATE, MAX_MEMORY, SERVER_ID, TOTAL_MEMORY_AVERAGE, TOTAL_MEMORY_MAX, TOTAL_MEMORY_MIN, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_JVM_NUM_ID) values (,,,,,,,,,);
Date: 2025-09-19 10:46:16 Duration: 76ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_JVM (LOG_DATE, MAX_MEMORY, SERVER_ID, TOTAL_MEMORY_AVERAGE, TOTAL_MEMORY_MAX, TOTAL_MEMORY_MIN, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_JVM_NUM_ID) values (,,,,,,,,,);
Date: 2025-09-19 11:05:02 Duration: 23ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 10s367ms 1ms 8,616 11s125ms delete from applicative_lock where lock_key =;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 19 09 505 23ms 0ms 10 1,426 76ms 0ms 11 1,430 92ms 0ms 12 951 10s553ms 11ms 13 709 48ms 0ms 14 713 51ms 0ms 15 713 66ms 0ms 16 723 68ms 0ms 17 713 72ms 0ms 18 713 69ms 0ms 19 20 2ms 0ms [ User: a3dsupervisor - Total duration: 11s125ms - Times executed: 8616 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s125ms - Times executed: 8616 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY =;
Date: 2025-09-19 10:35:07 Duration: 10s367ms 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-09-19 10:46:16 Duration: 83ms 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-09-19 10:36:00 Duration: 27ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 3s369ms 1ms 87,184 1m48s commit;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 19 09 5,478 2s137ms 0ms 10 14,000 6s35ms 0ms 11 14,034 6s296ms 0ms 12 9,435 55s154ms 5ms 13 7,286 23s466ms 3ms 14 7,319 3s62ms 0ms 15 7,317 3s43ms 0ms 16 7,423 3s161ms 0ms 17 7,318 3s432ms 0ms 18 7,324 3s95ms 0ms 19 250 90ms 0ms [ User: a3dsupervisor - Total duration: 1m48s - Times executed: 87184 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m48s - Times executed: 87184 ]
-
COMMIT;
Date: 2025-09-19 11:04:25 Duration: 3s369ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-19 11:04:47 Duration: 3s211ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-19 11:04:43 Duration: 2s522ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 697ms 0ms 13,380 10s984ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 19 09 476 596ms 1ms 10 1,428 340ms 0ms 11 1,428 516ms 0ms 12 1,361 3s303ms 2ms 13 1,428 4s373ms 3ms 14 1,428 274ms 0ms 15 1,428 392ms 0ms 16 1,428 381ms 0ms 17 1,428 395ms 0ms 18 1,428 378ms 0ms 19 119 30ms 0ms [ User: a3dsupervisor - Total duration: 10s984ms - Times executed: 13380 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s984ms - Times executed: 13380 ]
-
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-09-19 10:35:08 Duration: 697ms 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-09-19 11:00:02 Duration: 430ms 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-09-19 11:00:03 Duration: 307ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 770ms 0ms 8,615 6s234ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 19 09 505 56ms 0ms 10 1,426 165ms 0ms 11 1,430 211ms 0ms 12 950 4s342ms 4ms 13 709 774ms 1ms 14 713 108ms 0ms 15 713 140ms 0ms 16 723 147ms 0ms 17 713 144ms 0ms 18 713 139ms 0ms 19 20 3ms 0ms [ User: a3dsupervisor - Total duration: 6s234ms - Times executed: 8615 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s234ms - Times executed: 8615 ]
-
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-09-19 10:34:49 Duration: 770ms 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-09-19 10:34:49 Duration: 769ms 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-09-19 10:34:56 Duration: 638ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 97ms 0ms 6,519 2s502ms 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 Sep 19 09 253 94ms 0ms 10 713 257ms 0ms 11 715 256ms 0ms 12 536 317ms 0ms 13 708 258ms 0ms 14 713 259ms 0ms 15 713 258ms 0ms 16 723 267ms 0ms 17 712 258ms 0ms 18 713 267ms 0ms 19 20 6ms 0ms [ User: a3dsupervisor - Total duration: 2s502ms - Times executed: 6519 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s502ms - Times executed: 6519 ]
-
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-09-19 10:46:16 Duration: 97ms 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-09-19 10:59:13 Duration: 7ms 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-09-19 07:37:19 Duration: 6ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1s101ms 0ms 23,848 3s143ms begin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 09 1,202 28ms 0ms 10 3,173 92ms 0ms 11 3,182 121ms 0ms 12 2,262 2s273ms 1ms 13 2,316 59ms 0ms 14 2,322 84ms 0ms 15 2,321 120ms 0ms 16 2,354 118ms 0ms 17 2,324 120ms 0ms 18 2,324 120ms 0ms 19 68 3ms 0ms [ User: a3dsupervisor - Total duration: 3s143ms - Times executed: 23848 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s143ms - Times executed: 23848 ]
-
BEGIN;
Date: 2025-09-19 10:35:07 Duration: 1s101ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-09-19 10:46:14 Duration: 503ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-09-19 10:46:14 Duration: 503ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
16 0ms 109ms 0ms 2,141 187ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 09 275 10ms 0ms 10 720 26ms 0ms 11 722 24ms 0ms 12 424 126ms 0ms [ User: a3dsupervisor - Total duration: 187ms - Times executed: 2141 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 187ms - Times executed: 2141 ]
-
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-09-19 10:35:07 Duration: 109ms 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-09-19 07:46:04 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-09-19 08:52:14 Duration: 0ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 650ms 0ms 13,787 1s180ms select nextval(?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 09 491 31ms 0ms 10 1,468 19ms 0ms 11 1,468 26ms 0ms 12 1,429 942ms 0ms 13 1,468 27ms 0ms 14 1,468 18ms 0ms 15 1,468 25ms 0ms 16 1,468 30ms 0ms 17 1,468 24ms 0ms 18 1,468 31ms 0ms 19 123 2ms 0ms [ User: a3dsupervisor - Total duration: 1s180ms - Times executed: 13787 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 13787 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-09-19 10:35:19 Duration: 650ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-09-19 10:46:15 Duration: 86ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_THREAD_NUM_ID_SEQ');
Date: 2025-09-19 10:46:16 Duration: 54ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1s262ms 0ms 63,328 4s818ms begin read only;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 09 4,278 141ms 0ms 10 10,827 414ms 0ms 11 10,852 548ms 0ms 12 7,163 1s808ms 0ms 13 4,970 190ms 0ms 14 4,997 264ms 0ms 15 4,996 358ms 0ms 16 5,069 360ms 0ms 17 4,994 356ms 0ms 18 5,000 361ms 0ms 19 182 11ms 0ms [ User: a3dsupervisor - Total duration: 4s818ms - Times executed: 63328 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s818ms - Times executed: 63328 ]
-
BEGIN READ ONLY;
Date: 2025-09-19 10:35:07 Duration: 1s262ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-09-19 10:36:05 Duration: 142ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-09-19 10:37:01 Duration: 32ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver
19 0ms 44ms 0ms 2,208 167ms 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 #19
Day Hour Count Duration Avg duration Sep 19 09 90 3ms 0ms 10 240 12ms 0ms 11 241 15ms 0ms 12 188 56ms 0ms 13 240 14ms 0ms 14 240 14ms 0ms 15 240 12ms 0ms 16 242 13ms 0ms 17 240 11ms 0ms 18 241 12ms 0ms 19 6 0ms 0ms [ User: a3dsupervisor - Total duration: 167ms - Times executed: 2208 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 167ms - Times executed: 2208 ]
-
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-09-19 10:35:57 Duration: 44ms 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-09-19 10:37:01 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-09-19 09:23:47 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 347ms 0ms 23,054 1s160ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 09 1,262 33ms 0ms 10 3,565 97ms 0ms 11 3,575 104ms 0ms 12 2,424 425ms 0ms 13 2,017 81ms 0ms 14 2,025 80ms 0ms 15 2,024 83ms 0ms 16 2,055 83ms 0ms 17 2,025 80ms 0ms 18 2,026 86ms 0ms 19 56 2ms 0ms [ User: a3dsupervisor - Total duration: 1s160ms - Times executed: 23054 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s160ms - Times executed: 23054 ]
-
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-09-19 10:36:56 Duration: 347ms 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-09-19 09:47:31 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-09-19 07:44:09 Duration: 1ms Database: pentest User: a3dsupervisor Remote: 10.3.6.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s9ms 21 0ms 1s6ms 48ms select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 19 09 10 0ms 0ms 12 7 1s7ms 143ms 13 4 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 21 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 21 ]
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-09-19 10:54:01 Duration: 1s6ms 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-09-19 10:46:16 Duration: 0ms 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-09-19 07:38:50 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
2 878ms 26 0ms 546ms 33ms 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 prepare #2
Day Hour Count Duration Avg duration 07 10 2ms 0ms 10 14 875ms 62ms 11 2 0ms 0ms [ User: a3dsupervisor - Total duration: 45ms - Times executed: 26 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 45ms - Times executed: 26 ]
-
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-09-19 10:35:23 Duration: 546ms 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-09-19 10:46:14 Duration: 326ms 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-09-19 10:34:49 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
3 876ms 28 0ms 357ms 31ms 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 #3
Day Hour Count Duration Avg duration 07 13 3ms 0ms 10 12 492ms 41ms 11 1 357ms 357ms 15 2 23ms 11ms [ User: a3dsupervisor - Total duration: 13ms - Times executed: 28 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13ms - Times executed: 28 ]
-
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-09-19 11:00:02 Duration: 357ms 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-09-19 10:35:07 Duration: 298ms 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-09-19 10:46:14 Duration: 131ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
4 512ms 30 0ms 508ms 17ms select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 07 5 0ms 0ms 10 20 509ms 25ms 11 5 3ms 0ms [ User: a3dsupervisor - Total duration: 38ms - Times executed: 30 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38ms - Times executed: 30 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-09-19 10:35:07 Duration: 508ms 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-09-19 11:35:00 Duration: 2ms 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-09-19 10:46:15 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
5 326ms 14 0ms 325ms 23ms select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 07 1 0ms 0ms 08 4 0ms 0ms 10 2 325ms 162ms 11 4 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms [ User: a3dsupervisor - Total duration: 92ms - Times executed: 14 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 92ms - Times executed: 14 ]
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-09-19 10:46:14 Duration: 325ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-09-19 08:15:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select nextval('GTP_LOG_SESSION_NUM_ID_SEQ');
Date: 2025-09-19 12:30:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
6 269ms 30 0ms 244ms 8ms 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 prepare #6
Day Hour Count Duration Avg duration 07 5 0ms 0ms 10 20 263ms 13ms 11 5 4ms 0ms [ User: a3dsupervisor - Total duration: 914ms - Times executed: 30 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 914ms - Times executed: 30 ]
-
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-09-19 10:35:09 Duration: 244ms 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-09-19 10:46:15 Duration: 16ms 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-09-19 11:35:00 Duration: 4ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
7 210ms 48 1ms 32ms 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 #7
Day Hour Count Duration Avg duration 00 2 2ms 1ms 01 2 2ms 1ms 02 2 2ms 1ms 03 2 2ms 1ms 04 2 3ms 1ms 05 2 2ms 1ms 06 2 31ms 15ms 07 2 33ms 16ms 08 2 3ms 1ms 09 2 3ms 1ms 10 2 2ms 1ms 11 2 37ms 18ms 12 2 3ms 1ms 13 2 3ms 1ms 14 2 2ms 1ms 15 2 16ms 8ms 16 2 3ms 1ms 17 2 2ms 1ms 18 2 33ms 16ms 19 2 4ms 2ms 20 2 2ms 1ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms [ User: azuresu - Total duration: 239ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 239ms - 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-09-19 18:05:12 Duration: 32ms 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-09-19 07:02:45 Duration: 31ms 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-09-19 06:32:43 Duration: 29ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
8 165ms 25 0ms 155ms 6ms 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 prepare #8
Day Hour Count Duration Avg duration 07 13 1ms 0ms 10 10 164ms 16ms 15 2 0ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 25 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1ms - Times executed: 25 ]
-
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-09-19 10:36:58 Duration: 155ms 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-09-19 10:37:39 Duration: 8ms 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-09-19 10:52:02 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
9 162ms 15 0ms 157ms 10ms 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 prepare #9
Day Hour Count Duration Avg duration 07 11 1ms 0ms 10 4 160ms 40ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 15 ]
-
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-09-19 10:35:21 Duration: 157ms 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-09-19 10:01:54 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-09-19 10:34:49 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
10 156ms 20 0ms 67ms 7ms select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 07 10 2ms 0ms 10 9 150ms 16ms 15 1 2ms 2ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 20 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 20 ]
-
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-09-19 10:46:16 Duration: 67ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-09-19 10:35:59 Duration: 45ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-09-19 10:52:02 Duration: 37ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
11 109ms 51 1ms 9ms 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 #11
Day Hour Count Duration Avg duration 07 5 16ms 3ms 08 2 3ms 1ms 09 14 23ms 1ms 10 17 32ms 1ms 12 4 10ms 2ms 13 7 12ms 1ms 14 1 1ms 1ms 16 1 9ms 9ms [ User: a3dsupervisor - Total duration: 30ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 30ms - Times executed: 51 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-19 16:41:15 Duration: 9ms 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-09-19 07:17:20 Duration: 8ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-19 12:00:07 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 96ms 26 0ms 89ms 3ms 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 prepare #12
Day Hour Count Duration Avg duration 07 14 3ms 0ms 10 10 92ms 9ms 15 2 0ms 0ms [ User: a3dsupervisor - Total duration: 348ms - Times executed: 26 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 348ms - Times executed: 26 ]
-
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-09-19 10:36:10 Duration: 89ms 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-09-19 07:40:01 Duration: 2ms 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-09-19 10:46:18 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 71ms 51 0ms 13ms 1ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 07 5 17ms 3ms 08 2 1ms 0ms 09 14 13ms 0ms 10 17 15ms 0ms 12 4 9ms 2ms 13 7 6ms 0ms 14 1 0ms 0ms 16 1 5ms 5ms [ User: a3dsupervisor - Total duration: 462ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 462ms - Times executed: 51 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-19 07:17:20 Duration: 13ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-19 12:00:07 Duration: 5ms 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-09-19 16:41:15 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
14 69ms 22 0ms 43ms 3ms 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 prepare #14
Day Hour Count Duration Avg duration 07 10 4ms 0ms 10 11 58ms 5ms 15 1 6ms 6ms [ User: a3dsupervisor - Total duration: 110ms - Times executed: 22 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 110ms - Times executed: 22 ]
-
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-09-19 10:46:15 Duration: 43ms 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-09-19 10:52:02 Duration: 13ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0;
Date: 2025-09-19 15:35:01 Duration: 6ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
15 56ms 22 0ms 45ms 2ms 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 prepare #15
Day Hour Count Duration Avg duration 07 11 1ms 0ms 10 10 53ms 5ms 15 1 2ms 2ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 22 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 22 ]
-
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-09-19 10:52:02 Duration: 45ms 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-09-19 10:37:03 Duration: 6ms 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-09-19 15:35:01 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
16 48ms 14 0ms 46ms 3ms insert into GTP_LOG_SESSION (LOG_DATE, SERVER_ID, SESSION_COUNT, TABLE_CACHE_ROW_COUNT, LOG_SESSION_NUM_ID) values ($1, $2, $3, $4, $5);Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 07 1 0ms 0ms 08 4 0ms 0ms 10 2 46ms 23ms 11 4 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms [ User: a3dsupervisor - Total duration: 173ms - Times executed: 14 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 173ms - Times executed: 14 ]
-
insert into GTP_LOG_SESSION (LOG_DATE, SERVER_ID, SESSION_COUNT, TABLE_CACHE_ROW_COUNT, LOG_SESSION_NUM_ID) values ($1, $2, $3, $4, $5);
Date: 2025-09-19 10:46:15 Duration: 46ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
insert into GTP_LOG_SESSION (LOG_DATE, SERVER_ID, SESSION_COUNT, TABLE_CACHE_ROW_COUNT, LOG_SESSION_NUM_ID) values ($1, $2, $3, $4, $5);
Date: 2025-09-19 12:30:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
insert into GTP_LOG_SESSION (LOG_DATE, SERVER_ID, SESSION_COUNT, TABLE_CACHE_ROW_COUNT, LOG_SESSION_NUM_ID) values ($1, $2, $3, $4, $5);
Date: 2025-09-19 08:45:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
17 45ms 51 0ms 2ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 07 5 5ms 1ms 08 2 1ms 0ms 09 14 9ms 0ms 10 17 13ms 0ms 12 4 5ms 1ms 13 7 6ms 0ms 14 1 1ms 1ms 16 1 2ms 2ms [ User: a3dsupervisor - Total duration: 384ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 384ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 16:41:15 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 07:17:20 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 12:00:07 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
18 43ms 14 0ms 41ms 3ms select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 07 2 0ms 0ms 08 3 0ms 0ms 10 2 41ms 20ms 11 3 0ms 0ms 12 2 1ms 0ms 13 2 0ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 14 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3ms - Times executed: 14 ]
-
select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);
Date: 2025-09-19 10:46:16 Duration: 41ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);
Date: 2025-09-19 12:30:01 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);
Date: 2025-09-19 07:45:01 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
19 43ms 22 0ms 39ms 1ms 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 prepare #19
Day Hour Count Duration Avg duration 07 11 1ms 0ms 10 10 40ms 4ms 15 1 1ms 1ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 22 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2ms - Times executed: 22 ]
-
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-09-19 10:52:02 Duration: 39ms 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-09-19 15:35:01 Duration: 1ms 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-09-19 07:38:50 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 41ms 51 0ms 7ms 0ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 07 5 10ms 2ms 08 2 1ms 0ms 09 14 8ms 0ms 10 17 10ms 0ms 12 4 3ms 0ms 13 7 4ms 0ms 14 1 0ms 0ms 16 1 2ms 2ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 51 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 07:17:20 Duration: 7ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 16:41:15 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 12:00:07 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3s943ms 20,953 0ms 1s201ms 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 Sep 19 09 1,010 76ms 0ms 10 2,852 206ms 0ms 11 2,860 256ms 0ms 12 2,007 752ms 0ms 13 2,015 1s379ms 0ms 14 2,025 211ms 0ms 15 2,024 257ms 0ms 16 2,055 261ms 0ms 17 2,023 270ms 0ms 18 2,026 263ms 0ms 19 56 6ms 0ms [ User: a3dsupervisor - Total duration: 1s47ms - Times executed: 20953 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s47ms - Times executed: 20953 ]
-
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-09-19 11:00:03 Duration: 1s201ms 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-09-19 10:35:08 Duration: 411ms 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-09-19 10:35:59 Duration: 44ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
2 1s539ms 23,054 0ms 54ms 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 #2
Day Hour Count Duration Avg duration 07 1,262 51ms 0ms 08 3,565 145ms 0ms 09 3,575 172ms 0ms 10 2,424 281ms 0ms 11 2,017 106ms 0ms 12 2,025 127ms 0ms 13 2,024 158ms 0ms 14 2,055 167ms 0ms 15 2,025 158ms 0ms 16 2,026 165ms 0ms 17 56 4ms 0ms [ User: a3dsupervisor - Total duration: 1s160ms - Times executed: 23054 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s160ms - Times executed: 23054 ]
-
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-09-19 10:36:10 Duration: 54ms 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-09-19 10:35:19 Duration: 48ms 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-09-19 10:52:02 Duration: 34ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
3 1s406ms 2,208 0ms 688ms 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 #3
Day Hour Count Duration Avg duration 07 90 10ms 0ms 08 240 22ms 0ms 09 241 28ms 0ms 10 188 1s172ms 6ms 11 240 21ms 0ms 12 240 26ms 0ms 13 240 29ms 0ms 14 242 32ms 0ms 15 240 32ms 0ms 16 241 28ms 0ms 17 6 0ms 0ms [ User: a3dsupervisor - Total duration: 167ms - Times executed: 2208 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 167ms - Times executed: 2208 ]
-
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-09-19 10:35:24 Duration: 688ms 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-09-19 10:46:15 Duration: 458ms 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-09-19 10:37:01 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
4 1s165ms 17,232 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 = $1;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 07 1,010 41ms 0ms 08 2,852 142ms 0ms 09 2,860 187ms 0ms 10 1,902 124ms 0ms 11 1,418 65ms 0ms 12 1,426 90ms 0ms 13 1,426 126ms 0ms 14 1,446 130ms 0ms 15 1,426 125ms 0ms 16 1,426 127ms 0ms 17 40 3ms 0ms [ User: a3dsupervisor - Total duration: 541ms - Times executed: 17232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 541ms - Times executed: 17232 ]
-
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-09-19 10:36:58 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY = $1;
Date: 2025-09-19 08:47:40 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select null, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY = $1;
Date: 2025-09-19 09:44:14 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
5 752ms 2,141 0ms 396ms 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 #5
Day Hour Count Duration Avg duration 07 275 27ms 0ms 08 720 47ms 0ms 09 722 57ms 0ms 10 424 619ms 1ms [ User: a3dsupervisor - Total duration: 187ms - Times executed: 2141 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 187ms - Times executed: 2141 ]
-
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-09-19 10:35:07 Duration: 396ms 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-09-19 10:35:21 Duration: 188ms 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-09-19 07:37:15 Duration: 9ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
6 743ms 13,411 0ms 46ms 0ms select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 07 476 11ms 0ms 08 1,428 49ms 0ms 09 1,428 88ms 0ms 10 1,392 154ms 0ms 11 1,428 31ms 0ms 12 1,428 57ms 0ms 13 1,428 85ms 0ms 14 1,428 83ms 0ms 15 1,428 87ms 0ms 16 1,428 86ms 0ms 17 119 6ms 0ms [ User: a3dsupervisor - Total duration: 1s2ms - Times executed: 13411 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s2ms - Times executed: 13411 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-09-19 10:35:07 Duration: 46ms 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-09-19 10:35:22 Duration: 40ms 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-09-19 10:05:00 Duration: 2ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
7 709ms 13,379 0ms 201ms 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 #7
Day Hour Count Duration Avg duration 07 476 10ms 0ms 08 1,428 28ms 0ms 09 1,428 28ms 0ms 10 1,360 470ms 0ms 11 1,428 29ms 0ms 12 1,428 27ms 0ms 13 1,428 28ms 0ms 14 1,428 29ms 0ms 15 1,428 27ms 0ms 16 1,428 27ms 0ms 17 119 2ms 0ms [ User: a3dsupervisor - Total duration: 10s965ms - Times executed: 13379 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s965ms - Times executed: 13379 ]
-
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-09-19 10:36:57 Duration: 201ms 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-09-19 10:35:07 Duration: 191ms 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-09-19 10:35:57 Duration: 42ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
8 695ms 87,179 0ms 0ms 0ms COMMIT;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 07 5,478 39ms 0ms 08 14,000 93ms 0ms 09 14,034 91ms 0ms 10 9,430 65ms 0ms 11 7,286 67ms 0ms 12 7,319 66ms 0ms 13 7,317 67ms 0ms 14 7,423 67ms 0ms 15 7,318 65ms 0ms 16 7,324 67ms 0ms 17 250 2ms 0ms [ User: a3dsupervisor - Total duration: 1m46s - Times executed: 87179 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m46s - Times executed: 87179 ]
-
COMMIT;
Date: 2025-09-19 10:06:57 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-09-19 10:59:44 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-09-19 13:59:17 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
9 622ms 8,615 0ms 152ms 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 #9
Day Hour Count Duration Avg duration 07 505 23ms 0ms 08 1,426 66ms 0ms 09 1,430 64ms 0ms 10 950 261ms 0ms 11 709 33ms 0ms 12 713 36ms 0ms 13 713 33ms 0ms 14 723 33ms 0ms 15 713 33ms 0ms 16 713 34ms 0ms 17 20 0ms 0ms [ User: a3dsupervisor - Total duration: 6s234ms - Times executed: 8615 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s234ms - Times executed: 8615 ]
-
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-09-19 10:35:09 Duration: 152ms 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-09-19 10:35:21 Duration: 61ms 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-09-19 12:22:33 Duration: 3ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
10 465ms 6,518 0ms 106ms 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 07 252 16ms 0ms 08 713 25ms 0ms 09 715 35ms 0ms 10 536 136ms 0ms 11 708 27ms 0ms 12 713 33ms 0ms 13 713 45ms 0ms 14 723 46ms 0ms 15 712 48ms 0ms 16 713 48ms 0ms 17 20 1ms 0ms [ User: a3dsupervisor - Total duration: 151ms - Times executed: 6518 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 151ms - Times executed: 6518 ]
-
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-09-19 10:52:02 Duration: 106ms 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-09-19 07:38:50 Duration: 8ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select goacrp1_0.ACTION_NUM_ID from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0 order by goacrp1_0.ACTION_NUM_ID fetch first $1 rows only;
Date: 2025-09-19 09:00:23 Duration: 3ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
11 446ms 6,517 0ms 79ms 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 #11
Day Hour Count Duration Avg duration 07 252 24ms 0ms 08 713 26ms 0ms 09 715 26ms 0ms 10 535 147ms 0ms 11 708 29ms 0ms 12 713 29ms 0ms 13 713 38ms 0ms 14 723 39ms 0ms 15 712 42ms 0ms 16 713 40ms 0ms 17 20 1ms 0ms [ User: a3dsupervisor - Total duration: 192ms - Times executed: 6517 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 192ms - Times executed: 6517 ]
-
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-09-19 10:37:03 Duration: 79ms 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-09-19 10:52:02 Duration: 41ms 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-09-19 07:38:50 Duration: 9ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
12 430ms 6,519 0ms 109ms 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 #12
Day Hour Count Duration Avg duration 07 253 21ms 0ms 08 713 20ms 0ms 09 715 23ms 0ms 10 536 178ms 0ms 11 708 22ms 0ms 12 713 26ms 0ms 13 713 30ms 0ms 14 723 34ms 0ms 15 712 39ms 0ms 16 713 32ms 0ms 17 20 0ms 0ms [ User: a3dsupervisor - Total duration: 2s502ms - Times executed: 6519 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s502ms - Times executed: 6519 ]
-
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-09-19 10:46:15 Duration: 109ms 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-09-19 10:52:02 Duration: 46ms 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-09-19 07:37:19 Duration: 14ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
13 288ms 6,516 0ms 48ms 0ms select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 07 252 13ms 0ms 08 713 16ms 0ms 09 715 19ms 0ms 10 534 77ms 0ms 11 708 19ms 0ms 12 713 21ms 0ms 13 713 30ms 0ms 14 723 26ms 0ms 15 712 34ms 0ms 16 713 28ms 0ms 17 20 0ms 0ms [ User: a3dsupervisor - Total duration: 52ms - Times executed: 6516 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52ms - Times executed: 6516 ]
-
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-09-19 10:52:02 Duration: 48ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-09-19 07:38:50 Duration: 7ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2025-09-19 10:46:16 Duration: 5ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
14 256ms 8,616 0ms 3ms 0ms delete from APPLICATIVE_LOCK where LOCK_KEY = $1;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 07 505 14ms 0ms 08 1,426 38ms 0ms 09 1,430 40ms 0ms 10 951 27ms 0ms 11 709 20ms 0ms 12 713 21ms 0ms 13 713 22ms 0ms 14 723 22ms 0ms 15 713 24ms 0ms 16 713 24ms 0ms 17 20 0ms 0ms [ User: a3dsupervisor - Total duration: 11s125ms - Times executed: 8616 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s125ms - Times executed: 8616 ]
-
delete from APPLICATIVE_LOCK where LOCK_KEY = $1;
Date: 2025-09-19 09:22:01 Duration: 3ms 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-09-19 16:27:04 Duration: 2ms 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-09-19 15:54:13 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
15 217ms 48 1ms 28ms 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 bind #15
Day Hour Count Duration Avg duration 00 2 4ms 2ms 01 2 4ms 2ms 02 2 4ms 2ms 03 2 4ms 2ms 04 2 4ms 2ms 05 2 3ms 1ms 06 2 27ms 13ms 07 2 25ms 12ms 08 2 6ms 3ms 09 2 4ms 2ms 10 2 3ms 1ms 11 2 40ms 20ms 12 2 4ms 2ms 13 2 5ms 2ms 14 2 4ms 2ms 15 2 14ms 7ms 16 2 4ms 2ms 17 2 3ms 1ms 18 2 24ms 12ms 19 2 4ms 2ms 20 2 5ms 2ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms [ User: azuresu - Total duration: 239ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 239ms - 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-09-19 11:04:48 Duration: 28ms 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-09-19 06:32:43 Duration: 24ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 07:02:45 Duration: 23ms Database: pentest User: pentest Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
16 210ms 2,650 0ms 47ms 0ms select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 07 273 17ms 0ms 08 773 33ms 0ms 09 775 43ms 0ms 10 465 74ms 0ms 11 60 6ms 0ms 12 60 5ms 0ms 13 60 6ms 0ms 14 61 8ms 0ms 15 60 6ms 0ms 16 61 7ms 0ms 17 2 0ms 0ms [ User: a3dsupervisor - Total duration: 64ms - Times executed: 2650 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 64ms - Times executed: 2650 ]
-
select count(gotcratcp1_0.ID) from GTP_OBJ_TEMPLATE_CALCUL_RULE_ATT_TO_COMPUTE gotcratcp1_0;
Date: 2025-09-19 10:54:02 Duration: 47ms 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-09-19 07:38:50 Duration: 6ms 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-09-19 11:31:00 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
17 109ms 4,192 0ms 5ms 0ms select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0 where 1 = 0;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 07 504 10ms 0ms 08 1,426 33ms 0ms 09 1,430 42ms 0ms 10 832 23ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 4192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23ms - Times executed: 4192 ]
-
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-09-19 09:05:01 Duration: 5ms 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-09-19 08:15:48 Duration: 0ms 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-09-19 09:55:40 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
18 75ms 76 0ms 61ms 0ms select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 07 2 0ms 0ms 08 8 1ms 0ms 09 8 0ms 0ms 10 8 62ms 7ms 11 8 1ms 0ms 12 8 5ms 0ms 13 8 0ms 0ms 14 8 0ms 0ms 15 8 0ms 0ms 16 8 0ms 0ms 17 2 0ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 76 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6ms - Times executed: 76 ]
-
select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);
Date: 2025-09-19 10:46:16 Duration: 61ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);
Date: 2025-09-19 12:30:01 Duration: 4ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);
Date: 2025-09-19 11:00:04 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
19 69ms 555 0ms 31ms 0ms select count(goacrp1_0.ACTION_NUM_ID) from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 07 21 1ms 0ms 08 60 3ms 0ms 09 60 4ms 0ms 10 50 34ms 0ms 11 60 2ms 0ms 12 60 3ms 0ms 13 60 6ms 0ms 14 61 5ms 0ms 15 60 4ms 0ms 16 61 4ms 0ms 17 2 0ms 0ms [ User: a3dsupervisor - Total duration: 21ms - Times executed: 555 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21ms - Times executed: 555 ]
-
select count(goacrp1_0.ACTION_NUM_ID) from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0;
Date: 2025-09-19 10:46:16 Duration: 31ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select count(goacrp1_0.ACTION_NUM_ID) from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0;
Date: 2025-09-19 13:20:01 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select count(goacrp1_0.ACTION_NUM_ID) from GTP_OBJ_ACTION_CALCUL_RULE goacrp1_0;
Date: 2025-09-19 13:56:00 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
20 64ms 2,096 0ms 13ms 0ms select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 07 252 19ms 0ms 08 713 15ms 0ms 09 715 19ms 0ms 10 416 10ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 2096 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10ms - Times executed: 2096 ]
-
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-09-19 07:38:50 Duration: 13ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-09-19 09:05:01 Duration: 1ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
select gotcrop1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrop1_0.ATT_TEMPLATE_NUM_ID, gotcrop1_0.OBJ_TEMPLATE_NUM_ID, gotcrop1_0.AUTO_LOAD, gotcrop1_0.AUTOMATIC, gotcrop1_0.EXEC_ON_CREATION, gotcrop1_0.MANUAL_MODIFICATION_ALLOWED, gotcrop1_0.RECALCULATION from GTP_OBJ_TEMPLATE_CALCULATION_RULE_OPTIONS gotcrop1_0 where 1 = 0;
Date: 2025-09-19 09:03:40 Duration: 0ms Database: pentest User: pentest Remote: a3dsupervisor Application: 10.3.6.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 714,274 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 19 12 1