pgBadger-
Global information
- Generated on Mon Mar 9 09:01:07 2026
- Log file: ././A3D-RND-PIC/y=2026/m=03/d=06/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2026/m=03/d=06/h=23/m=00/PT1H.log
- Parsed 9,464 log entries in 52s
- Log start from 2026-03-06 00:00:02 to 2026-03-06 07:23:39
-
Overview
Global Stats
- 5 Number of unique normalized queries
- 9 Number of queries
- 42s60ms Total query duration
- 2026-03-06 06:37:53 First query
- 2026-03-06 06:44:15 Last query
- 3 queries/s at 2026-03-06 06:38:26 Query peak
- 42s60ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 42s60ms Execute total duration
- 4,194 Number of events
- 4 Number of unique normalized events
- 4,175 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
- 354 Total number of sessions
- 15 sessions at 2026-03-06 06:43:53 Session peak
- 1d11h4m11s Total duration of sessions
- 5m56s Average duration of sessions
- 0 Average queries per session
- 118ms Average queries duration per session
- 5m56s Average idle time per session
- 351 Total number of connections
- 7 connections/s at 2026-03-06 07:18:37 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-03-06 06:38:26 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-06 06:38:26 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-06 06:37:53 Date
Queries duration
Key values
- 42s60ms 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) Mar 06 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 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 9 0ms 5s808ms 4s673ms 5s93ms 16s702ms 17s51ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 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) Mar 06 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 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 2 0 4s320ms 0ms 0ms 8s640ms 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 0 0 0ms 0ms 0ms 0ms 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) Mar 06 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 3 0 1 0 5s93ms 0ms 0ms 10s893ms 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 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 Mar 06 00 0 0 0.00 0.00% 01 0 0 0.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 9 9.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.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 0 0.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 Mar 06 00 30 0.01/s 01 14 0.00/s 02 36 0.01/s 03 45 0.01/s 04 64 0.02/s 05 42 0.01/s 06 23 0.01/s 07 51 0.01/s 08 5 0.00/s 09 2 0.00/s 10 4 0.00/s 11 6 0.00/s 12 2 0.00/s 13 6 0.00/s 14 4 0.00/s 15 2 0.00/s 16 2 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 1 0.00/s Day Hour Count Average Duration Average idle time Mar 06 00 30 2m38s 2m38s 01 14 1m29s 1m29s 02 37 3m58s 3m58s 03 41 2m12s 2m12s 04 65 1m41s 1m41s 05 44 1m53s 1m53s 06 26 1h14s 1h13s 07 51 3s340ms 3s340ms 08 5 100ms 100ms 09 2 56ms 56ms 10 4 56s89ms 56s89ms 11 6 84ms 84ms 12 2 54ms 54ms 13 6 87ms 87ms 14 4 14s989ms 14s989ms 15 2 52ms 52ms 16 2 52ms 52ms 17 2 52ms 52ms 18 2 50ms 50ms 19 2 57ms 57ms 20 2 60ms 60ms 21 2 49ms 49ms 22 2 56ms 56ms 23 1 61ms 61ms -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-03-06 07:18:37 Date
Connections per database
Key values
- reftk Main Database
- 351 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 351 connections Total
-
Sessions
Simultaneous sessions
Key values
- 15 sessions Session Peak
- 2026-03-06 06:43:53 Date
Histogram of session times
Key values
- 237 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 354 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 354 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 354 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 354 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 Mar 06 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 Mar 06 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
- AccessShareLock Main Lock Type
- 2 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
- 2 Total read queries
- 7 Total write queries
Queries by database
Key values
- reftk Main database
- 9 Requests
- 42s60ms (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 9 Requests
User Request type Count Duration a3dsupervisor Total 9 42s60ms delete 1 5s93ms insert 3 15s282ms select 2 8s640ms tcl 3 13s44ms Duration by user
Key values
- 42s60ms (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 9 42s60ms delete 1 5s93ms insert 3 15s282ms select 2 8s640ms tcl 3 13s44ms Queries by host
Key values
- 10.3.0.4 Main host
- 9 Requests
- 42s60ms (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 9 Requests
- 42s60ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-06 01:40:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 9 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 5s808ms COMMIT;[ Date: 2026-03-06 06:37:54 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 5s447ms 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: 2026-03-06 06:37:53 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 5s445ms 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: 2026-03-06 06:37:53 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 5s93ms delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));[ Date: 2026-03-06 06:44:15 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 4s394ms select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;[ Date: 2026-03-06 06:38:26 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 4s388ms 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: 2026-03-06 06:38:26 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 4s246ms 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: 2026-03-06 06:38:26 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 4s22ms COMMIT;[ Date: 2026-03-06 06:38:59 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 3s213ms COMMIT;[ Date: 2026-03-06 06:39:30 - Database: reftk - 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 15s282ms 3 4s388ms 5s447ms 5s94ms 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 #1
Day Hour Count Duration Avg duration Mar 06 07 3 15s282ms 5s94ms [ User: a3dsupervisor - Total duration: 15s282ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s282ms - Times executed: 3 ]
-
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: 2026-03-06 06:37:53 Duration: 5s447ms Database: reftk User: a3dsupervisor Remote: 10.3.0.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: 2026-03-06 06:37:53 Duration: 5s445ms Database: reftk User: a3dsupervisor Remote: 10.3.0.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: 2026-03-06 06:38:26 Duration: 4s388ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 13s44ms 3 3s213ms 5s808ms 4s348ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 07 3 13s44ms 4s348ms [ User: a3dsupervisor - Total duration: 13s44ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s44ms - Times executed: 3 ]
-
COMMIT;
Date: 2026-03-06 06:37:54 Duration: 5s808ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:38:59 Duration: 4s22ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:39:30 Duration: 3s213ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5s93ms 1 5s93ms 5s93ms 5s93ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 06 07 1 5s93ms 5s93ms [ User: a3dsupervisor - Total duration: 5s93ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s93ms - Times executed: 1 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-06 06:44:15 Duration: 5s93ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 4s394ms 1 4s394ms 4s394ms 4s394ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 06 07 1 4s394ms 4s394ms [ User: a3dsupervisor - Total duration: 4s394ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s394ms - Times executed: 1 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-06 06:38:26 Duration: 4s394ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 4s246ms 1 4s246ms 4s246ms 4s246ms 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 Mar 06 07 1 4s246ms 4s246ms [ User: a3dsupervisor - Total duration: 4s246ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s246ms - 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: 2026-03-06 06:38:26 Duration: 4s246ms Database: reftk 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 3 15s282ms 4s388ms 5s447ms 5s94ms 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 #1
Day Hour Count Duration Avg duration Mar 06 07 3 15s282ms 5s94ms [ User: a3dsupervisor - Total duration: 15s282ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s282ms - Times executed: 3 ]
-
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: 2026-03-06 06:37:53 Duration: 5s447ms Database: reftk User: a3dsupervisor Remote: 10.3.0.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: 2026-03-06 06:37:53 Duration: 5s445ms Database: reftk User: a3dsupervisor Remote: 10.3.0.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: 2026-03-06 06:38:26 Duration: 4s388ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3 13s44ms 3s213ms 5s808ms 4s348ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 07 3 13s44ms 4s348ms [ User: a3dsupervisor - Total duration: 13s44ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s44ms - Times executed: 3 ]
-
COMMIT;
Date: 2026-03-06 06:37:54 Duration: 5s808ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:38:59 Duration: 4s22ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:39:30 Duration: 3s213ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1 5s93ms 5s93ms 5s93ms 5s93ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 06 07 1 5s93ms 5s93ms [ User: a3dsupervisor - Total duration: 5s93ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s93ms - Times executed: 1 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-06 06:44:15 Duration: 5s93ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 4s394ms 4s394ms 4s394ms 4s394ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 06 07 1 4s394ms 4s394ms [ User: a3dsupervisor - Total duration: 4s394ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s394ms - Times executed: 1 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-06 06:38:26 Duration: 4s394ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1 4s246ms 4s246ms 4s246ms 4s246ms 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 Mar 06 07 1 4s246ms 4s246ms [ User: a3dsupervisor - Total duration: 4s246ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s246ms - 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: 2026-03-06 06:38:26 Duration: 4s246ms Database: reftk 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 4s388ms 5s447ms 5s94ms 3 15s282ms 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 #1
Day Hour Count Duration Avg duration Mar 06 07 3 15s282ms 5s94ms [ User: a3dsupervisor - Total duration: 15s282ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s282ms - Times executed: 3 ]
-
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: 2026-03-06 06:37:53 Duration: 5s447ms Database: reftk User: a3dsupervisor Remote: 10.3.0.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: 2026-03-06 06:37:53 Duration: 5s445ms Database: reftk User: a3dsupervisor Remote: 10.3.0.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: 2026-03-06 06:38:26 Duration: 4s388ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5s93ms 5s93ms 5s93ms 1 5s93ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 07 1 5s93ms 5s93ms [ User: a3dsupervisor - Total duration: 5s93ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s93ms - Times executed: 1 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-06 06:44:15 Duration: 5s93ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s394ms 4s394ms 4s394ms 1 4s394ms 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 Mar 06 07 1 4s394ms 4s394ms [ User: a3dsupervisor - Total duration: 4s394ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s394ms - Times executed: 1 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-06 06:38:26 Duration: 4s394ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s213ms 5s808ms 4s348ms 3 13s44ms commit;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 06 07 3 13s44ms 4s348ms [ User: a3dsupervisor - Total duration: 13s44ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s44ms - Times executed: 3 ]
-
COMMIT;
Date: 2026-03-06 06:37:54 Duration: 5s808ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:38:59 Duration: 4s22ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:39:30 Duration: 3s213ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 4s246ms 4s246ms 4s246ms 1 4s246ms 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 Mar 06 07 1 4s246ms 4s246ms [ User: a3dsupervisor - Total duration: 4s246ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s246ms - 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: 2026-03-06 06:38:26 Duration: 4s246ms Database: reftk 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
Log levels
Key values
- 5,261 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 4178 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 4,175 Max number of times the same event was reported
- 4,194 Total events found
Rank Times reported Error 1 4,175 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 06 01 641 02 3,532 03 2 2 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 06 08 16 3 2 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect 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 Most Frequent Error / Event #3
Day Hour Count Mar 06 07 2 4 1 ERROR: schema "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 06 08 1