pgBadger-
Global information
- Generated on Wed Nov 12 09:05:38 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=11/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=11/h=23/m=00/PT1H.log
- Parsed 3,048 log entries in 52s
- Log start from 2025-11-11 18:01:22 to 2025-11-11 18:01:22
-
Overview
Global Stats
- 5 Number of unique normalized queries
- 28 Number of queries
- 3m25s Total query duration
- 2025-11-11 01:01:26 First query
- 2025-11-11 20:43:17 Last query
- 3 queries/s at 2025-11-11 07:59:20 Query peak
- 3m25s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3m25s Execute total duration
- 3 Number of events
- 1 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 994 Total number of sessions
- 123 sessions at 2025-11-11 18:54:43 Session peak
- 3d9h18m54s Total duration of sessions
- 4m54s Average duration of sessions
- 0 Average queries per session
- 207ms Average queries duration per session
- 4m54s Average idle time per session
- 996 Total number of connections
- 5 connections/s at 2025-11-11 01:49:29 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-11 07:59:20 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-11 20:42:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-11 07:59:20 Date
Queries duration
Key values
- 3m25s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 11 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 10s427ms 10s427ms 0ms 0ms 10s427ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 13 0ms 8s960ms 6s913ms 12s576ms 15s814ms 49s69ms 08 6 0ms 9s906ms 9s152ms 0ms 25s480ms 29s433ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 8 0ms 7s364ms 6s331ms 7s159ms 15s248ms 20s882ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 11 00 0 0 0ms 0ms 0ms 0ms 01 1 0 10s427ms 0ms 0ms 10s427ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 2 0 6s961ms 0ms 0ms 13s923ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 11 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 1 0 0 0 6s959ms 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 Nov 11 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 13 13.00 0.00% 08 0 6 6.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 8 8.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 11 00 46 0.01/s 01 35 0.01/s 02 49 0.01/s 03 46 0.01/s 04 45 0.01/s 05 38 0.01/s 06 19 0.01/s 07 30 0.01/s 08 25 0.01/s 09 57 0.02/s 10 46 0.01/s 11 46 0.01/s 12 56 0.02/s 13 40 0.01/s 14 43 0.01/s 15 60 0.02/s 16 40 0.01/s 17 33 0.01/s 18 36 0.01/s 19 53 0.01/s 20 36 0.01/s 21 37 0.01/s 22 53 0.01/s 23 27 0.01/s Day Hour Count Average Duration Average idle time Nov 11 00 46 1m56s 1m56s 01 35 2m5s 2m5s 02 49 1m51s 1m51s 03 45 1m59s 1m59s 04 46 1m57s 1m57s 05 37 2m7s 2m7s 06 20 2m37s 2m37s 07 29 3m11s 3m8s 08 26 4m6s 4m4s 09 57 1m41s 1m41s 10 47 1m43s 1m43s 11 45 1m44s 1m44s 12 53 1m52s 1m52s 13 43 1m57s 1m57s 14 40 1m48s 1m48s 15 60 1m34s 1m34s 16 43 1m55s 1m55s 17 34 2m22s 2m22s 18 36 1h20m38s 1h20m38s 19 51 1m47s 1m47s 20 35 2m38s 2m37s 21 39 2m2s 2m2s 22 53 1m54s 1m54s 23 25 3m2s 3m2s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2025-11-11 01:49:29 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 996 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 996 connections Total
-
Sessions
Simultaneous sessions
Key values
- 123 sessions Session Peak
- 2025-11-11 18:54:43 Date
Histogram of session times
Key values
- 901 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 994 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 994 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 994 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 11 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 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
- 3 Total read queries
- 25 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 28 Requests
- 3m25s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 28 Requests
User Request type Count Duration a3dsupervisor Total 28 3m25s insert 1 6s959ms select 3 24s351ms tcl 24 2m54s Duration by user
Key values
- 3m25s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 28 3m25s insert 1 6s959ms select 3 24s351ms tcl 24 2m54s Queries by host
Key values
- 10.3.0.4 Main host
- 28 Requests
- 3m25s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 28 Requests
- 3m25s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-11 04:08:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 27 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10s427ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2025-11-11 01:01:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 9s906ms COMMIT;[ Date: 2025-11-11 08:01:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 9s773ms COMMIT;[ Date: 2025-11-11 08:01:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 9s752ms COMMIT;[ Date: 2025-11-11 08:01:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 8s960ms COMMIT;[ Date: 2025-11-11 07:59:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 8s836ms COMMIT;[ Date: 2025-11-11 07:59:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 8s811ms COMMIT;[ Date: 2025-11-11 07:59:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 8s557ms COMMIT;[ Date: 2025-11-11 08:41:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 8s509ms COMMIT;[ Date: 2025-11-11 08:41:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 8s413ms COMMIT;[ Date: 2025-11-11 08:41:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 7s492ms COMMIT;[ Date: 2025-11-11 07:59:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 7s485ms COMMIT;[ Date: 2025-11-11 07:59:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 7s483ms COMMIT;[ Date: 2025-11-11 07:59:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 7s364ms COMMIT;[ Date: 2025-11-11 20:41:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 7s223ms COMMIT;[ Date: 2025-11-11 07:21:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 7s159ms COMMIT;[ Date: 2025-11-11 20:43:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 6s965ms select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;[ Date: 2025-11-11 20:42:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 6s959ms insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);[ Date: 2025-11-11 20:42:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 6s958ms select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;[ Date: 2025-11-11 20:42:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 6s291ms COMMIT;[ Date: 2025-11-11 07:55:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.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 2m54s 24 5s36ms 9s906ms 7s273ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 11 08 13 1m29s 6s913ms 09 6 54s913ms 9s152ms 21 5 29s772ms 5s954ms [ User: a3dsupervisor - Total duration: 2m54s - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m54s - Times executed: 24 ]
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s906ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s773ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s752ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 10s427ms 1 10s427ms 10s427ms 10s427ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 11 02 1 10s427ms 10s427ms [ User: a3dsupervisor - Total duration: 10s427ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s427ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-11 01:01:26 Duration: 10s427ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 6s965ms 1 6s965ms 6s965ms 6s965ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 21 1 6s965ms 6s965ms [ User: a3dsupervisor - Total duration: 6s965ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s965ms - Times executed: 1 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-11 20:42:33 Duration: 6s965ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 6s959ms 1 6s959ms 6s959ms 6s959ms 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 Nov 11 21 1 6s959ms 6s959ms [ User: a3dsupervisor - Total duration: 6s959ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s959ms - Times executed: 1 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-11 20:42:33 Duration: 6s959ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 6s958ms 1 6s958ms 6s958ms 6s958ms 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 #5
Day Hour Count Duration Avg duration Nov 11 21 1 6s958ms 6s958ms [ User: a3dsupervisor - Total duration: 6s958ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s958ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-11 20:42:33 Duration: 6s958ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.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 24 2m54s 5s36ms 9s906ms 7s273ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 11 08 13 1m29s 6s913ms 09 6 54s913ms 9s152ms 21 5 29s772ms 5s954ms [ User: a3dsupervisor - Total duration: 2m54s - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m54s - Times executed: 24 ]
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s906ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s773ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s752ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1 10s427ms 10s427ms 10s427ms 10s427ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 11 02 1 10s427ms 10s427ms [ User: a3dsupervisor - Total duration: 10s427ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s427ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-11 01:01:26 Duration: 10s427ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1 6s965ms 6s965ms 6s965ms 6s965ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 21 1 6s965ms 6s965ms [ User: a3dsupervisor - Total duration: 6s965ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s965ms - Times executed: 1 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-11 20:42:33 Duration: 6s965ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 6s959ms 6s959ms 6s959ms 6s959ms 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 Nov 11 21 1 6s959ms 6s959ms [ User: a3dsupervisor - Total duration: 6s959ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s959ms - Times executed: 1 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-11 20:42:33 Duration: 6s959ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1 6s958ms 6s958ms 6s958ms 6s958ms 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 #5
Day Hour Count Duration Avg duration Nov 11 21 1 6s958ms 6s958ms [ User: a3dsupervisor - Total duration: 6s958ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s958ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-11 20:42:33 Duration: 6s958ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.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 10s427ms 10s427ms 10s427ms 1 10s427ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 11 02 1 10s427ms 10s427ms [ User: a3dsupervisor - Total duration: 10s427ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s427ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-11 01:01:26 Duration: 10s427ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5s36ms 9s906ms 7s273ms 24 2m54s commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 11 08 13 1m29s 6s913ms 09 6 54s913ms 9s152ms 21 5 29s772ms 5s954ms [ User: a3dsupervisor - Total duration: 2m54s - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m54s - Times executed: 24 ]
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s906ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s773ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-11 08:01:24 Duration: 9s752ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 6s965ms 6s965ms 6s965ms 1 6s965ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 21 1 6s965ms 6s965ms [ User: a3dsupervisor - Total duration: 6s965ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s965ms - Times executed: 1 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-11 20:42:33 Duration: 6s965ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 6s959ms 6s959ms 6s959ms 1 6s959ms 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 Nov 11 21 1 6s959ms 6s959ms [ User: a3dsupervisor - Total duration: 6s959ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s959ms - Times executed: 1 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-11 20:42:33 Duration: 6s959ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 6s958ms 6s958ms 6s958ms 1 6s958ms 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 #5
Day Hour Count Duration Avg duration Nov 11 21 1 6s958ms 6s958ms [ User: a3dsupervisor - Total duration: 6s958ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s958ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-11 20:42:33 Duration: 6s958ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 3 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 3 Total events found
Rank Times reported Error 1 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 11 19 3