pgBadger-
Global information
- Generated on Wed Nov 19 09:09:10 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=18/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=18/h=23/m=00/PT1H.log
- Parsed 12,752 log entries in 53s
- Log start from 2025-11-18 00:30:02 to 2025-11-18 23:45:02
-
Overview
Global Stats
- 31 Number of unique normalized queries
- 40 Number of queries
- 8m57s Total query duration
- 2025-11-18 07:31:31 First query
- 2025-11-18 20:55:18 Last query
- 2 queries/s at 2025-11-18 08:02:02 Query peak
- 8m57s Total query duration
- 11s646ms Prepare/parse total duration
- 10s797ms Bind total duration
- 8m34s Execute total duration
- 4,923 Number of events
- 15 Number of unique normalized events
- 4,861 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
- 208 Number temporary file
- 3.54 GiB Max size of temporary file
- 23.71 MiB Average size of temporary file
- 872 Total number of sessions
- 34 sessions at 2025-11-18 20:54:11 Session peak
- 2d4h34m40s Total duration of sessions
- 3m37s Average duration of sessions
- 0 Average queries per session
- 615ms Average queries duration per session
- 3m36s Average idle time per session
- 871 Total number of connections
- 11 connections/s at 2025-11-18 20:54:03 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-18 08:02:02 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-18 08:44:43 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-18 08:02:02 Date
Queries duration
Key values
- 8m57s 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 18 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 0 0ms 0ms 0ms 0ms 0ms 0ms 07 2 0ms 6s435ms 6s373ms 0ms 6s311ms 6s435ms 08 11 0ms 8s54ms 6s294ms 10s211ms 12s534ms 14s747ms 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 27 0ms 1m10s 16s21ms 1m 1m6s 1m10s 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 18 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 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 1 0 5s314ms 0ms 0ms 5s314ms 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) Nov 18 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 1 0 0 0 6s435ms 0ms 0ms 6s435ms 08 1 1 0 0 6s354ms 0ms 0ms 5s547ms 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 1 0 24s50ms 0ms 0ms 24s50ms 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 18 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 0 0.00 0.00% 07 1 2 2.00 50.00% 08 1 11 11.00 9.09% 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 1 1.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 18 00 25 0.01/s 01 15 0.00/s 02 9 0.00/s 03 9 0.00/s 04 7 0.00/s 05 16 0.00/s 06 11 0.00/s 07 23 0.01/s 08 47 0.01/s 09 38 0.01/s 10 35 0.01/s 11 7 0.00/s 12 6 0.00/s 13 41 0.01/s 14 42 0.01/s 15 39 0.01/s 16 11 0.00/s 17 17 0.00/s 18 14 0.00/s 19 13 0.00/s 20 360 0.10/s 21 54 0.01/s 22 22 0.01/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Nov 18 00 26 9m27s 9m27s 01 15 1m10s 1m10s 02 9 45s769ms 45s769ms 03 9 49s826ms 49s826ms 04 7 47s586ms 47s586ms 05 16 1m4s 1m4s 06 11 53s298ms 53s298ms 07 22 1m38s 1m37s 08 46 1m18s 1m17s 09 40 17s393ms 17s393ms 10 35 14s884ms 14s884ms 11 5 29s214ms 29s214ms 12 8 45s690ms 45s690ms 13 41 43m43s 43m43s 14 42 25s236ms 25s236ms 15 39 8s400ms 8s400ms 16 11 46s327ms 46s327ms 17 17 1m6s 1m6s 18 14 40m17s 40m17s 19 15 13m46s 13m46s 20 354 5s344ms 4s122ms 21 58 40s853ms 40s853ms 22 22 1m8s 1m8s 23 10 56s701ms 56s701ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-11-18 20:54:03 Date
Connections per database
Key values
- autotest_api_batch Main Database
- 871 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 871 connections Total
-
Sessions
Simultaneous sessions
Key values
- 34 sessions Session Peak
- 2025-11-18 20:54:11 Date
Histogram of session times
Key values
- 523 0-500ms duration
Sessions per database
Key values
- autotest_api_batch Main Database
- 872 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 872 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 872 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 385.41 MiB Temp Files size Peak
- 2025-11-18 20:49:59 Date
Number of temporary files
Key values
- 5 per second Temp Files Peak
- 2025-11-18 20:50:12 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 18 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 203 4.80 GiB 24.23 MiB 21 5 12.81 MiB 2.56 MiB 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 18 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
- 1 Total read queries
- 37 Total write queries
Queries by database
Key values
- autotest_api_batch Main database
- 40 Requests
- 8m34s (autotest_api_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 40 Requests
User Request type Count Duration a3dsupervisor Total 40 8m34s ddl 24 5m2s delete 1 24s50ms insert 2 11s982ms others 2 1m46s select 1 5s314ms tcl 9 57s525ms update 1 7s162ms Duration by user
Key values
- 8m34s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 40 8m34s ddl 24 5m2s delete 1 24s50ms insert 2 11s982ms others 2 1m46s select 1 5s314ms tcl 9 57s525ms update 1 7s162ms Queries by host
Key values
- 10.3.0.4 Main host
- 40 Requests
- 8m34s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 26 Requests
- 6m48s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-18 21:15:12 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 23 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m10s VACUUM ANALYZE;[ Date: 2025-11-18 20:51:57 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 35s779ms VACUUM ANALYSE;[ Date: 2025-11-18 20:52:40 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 35s217ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-18 20:49:59 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 30s538ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-11-18 20:47:33 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 24s50ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-18 20:55:18 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 19s394ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-18 20:49:07 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 17s622ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-18 20:48:41 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 17s54ms CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);[ Date: 2025-11-18 20:48:03 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 14s529ms CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2025-11-18 20:45:54 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 13s231ms CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);[ Date: 2025-11-18 20:46:07 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 12s887ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-11-18 20:43:52 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 12s588ms CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-18 20:46:19 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 12s483ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2025-11-18 20:47:45 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 12s39ms CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);[ Date: 2025-11-18 20:44:33 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 12s10ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);[ Date: 2025-11-18 20:44:21 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 11s887ms ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-11-18 20:49:23 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 10s940ms CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);[ Date: 2025-11-18 20:46:55 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 9s703ms CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);[ Date: 2025-11-18 20:46:43 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 9s110ms CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON gtp_obj_composition (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-11-18 20:44:01 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 8s54ms COMMIT;[ Date: 2025-11-18 08:45:27 - Database: autotest_api_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 1m10s 1 1m10s 1m10s 1m10s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 18 21 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 1m10s - Times executed: 1 ]
[ Application: psql - Total duration: 1m10s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-11-18 20:51:57 Duration: 1m10s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 57s525ms 9 5s93ms 8s54ms 6s391ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 18 08 1 6s311ms 6s311ms 09 8 51s213ms 6s401ms [ User: a3dsupervisor - Total duration: 57s525ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 57s525ms - Times executed: 9 ]
-
COMMIT;
Date: 2025-11-18 08:45:27 Duration: 8s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 08:46:09 Duration: 7s701ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 08:45:26 Duration: 6s693ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 35s779ms 1 35s779ms 35s779ms 35s779ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 18 21 1 35s779ms 35s779ms [ User: a3dsupervisor - Total duration: 35s779ms - Times executed: 1 ]
[ Application: psql - Total duration: 35s779ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-18 20:52:40 Duration: 35s779ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 35s217ms 1 35s217ms 35s217ms 35s217ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 18 21 1 35s217ms 35s217ms [ User: a3dsupervisor - Total duration: 35s217ms - Times executed: 1 ]
[ Application: psql - Total duration: 35s217ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-18 20:49:59 Duration: 35s217ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 30s538ms 1 30s538ms 30s538ms 30s538ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 18 21 1 30s538ms 30s538ms [ User: a3dsupervisor - Total duration: 30s538ms - Times executed: 1 ]
[ Application: psql - Total duration: 30s538ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-18 20:47:33 Duration: 30s538ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 24s50ms 1 24s50ms 24s50ms 24s50ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 21 1 24s50ms 24s50ms [ User: a3dsupervisor - Total duration: 24s50ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24s50ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-18 20:55:18 Duration: 24s50ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 19s394ms 1 19s394ms 19s394ms 19s394ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 18 21 1 19s394ms 19s394ms [ User: a3dsupervisor - Total duration: 19s394ms - Times executed: 1 ]
[ Application: psql - Total duration: 19s394ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-18 20:49:07 Duration: 19s394ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 17s622ms 1 17s622ms 17s622ms 17s622ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 21 1 17s622ms 17s622ms [ User: a3dsupervisor - Total duration: 17s622ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s622ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-18 20:48:41 Duration: 17s622ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 17s54ms 1 17s54ms 17s54ms 17s54ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 18 21 1 17s54ms 17s54ms [ User: a3dsupervisor - Total duration: 17s54ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s54ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-18 20:48:03 Duration: 17s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 14s529ms 1 14s529ms 14s529ms 14s529ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 21 1 14s529ms 14s529ms [ User: a3dsupervisor - Total duration: 14s529ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s529ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-18 20:45:54 Duration: 14s529ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 13s231ms 1 13s231ms 13s231ms 13s231ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 21 1 13s231ms 13s231ms [ User: a3dsupervisor - Total duration: 13s231ms - Times executed: 1 ]
[ Application: psql - Total duration: 13s231ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-18 20:46:07 Duration: 13s231ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 12s887ms 1 12s887ms 12s887ms 12s887ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 21 1 12s887ms 12s887ms [ User: a3dsupervisor - Total duration: 12s887ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s887ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-18 20:43:52 Duration: 12s887ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 12s588ms 1 12s588ms 12s588ms 12s588ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 21 1 12s588ms 12s588ms [ User: a3dsupervisor - Total duration: 12s588ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s588ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-18 20:46:19 Duration: 12s588ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 12s483ms 1 12s483ms 12s483ms 12s483ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 21 1 12s483ms 12s483ms [ User: a3dsupervisor - Total duration: 12s483ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s483ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-18 20:47:45 Duration: 12s483ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 12s39ms 1 12s39ms 12s39ms 12s39ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 21 1 12s39ms 12s39ms [ User: a3dsupervisor - Total duration: 12s39ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s39ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-18 20:44:33 Duration: 12s39ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 12s10ms 1 12s10ms 12s10ms 12s10ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 21 1 12s10ms 12s10ms [ User: a3dsupervisor - Total duration: 12s10ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s10ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-18 20:44:21 Duration: 12s10ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 11s982ms 2 5s547ms 6s435ms 5s991ms 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 #17
Day Hour Count Duration Avg duration Nov 18 08 1 6s435ms 6s435ms 09 1 5s547ms 5s547ms [ User: a3dsupervisor - Total duration: 11s982ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s982ms - Times executed: 2 ]
-
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-18 07:56:14 Duration: 6s435ms Database: autotest_api_batch 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: 2025-11-18 08:44:43 Duration: 5s547ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 11s887ms 1 11s887ms 11s887ms 11s887ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 21 1 11s887ms 11s887ms [ User: a3dsupervisor - Total duration: 11s887ms - Times executed: 1 ]
[ Application: psql - Total duration: 11s887ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-18 20:49:23 Duration: 11s887ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 10s940ms 1 10s940ms 10s940ms 10s940ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 21 1 10s940ms 10s940ms [ User: a3dsupervisor - Total duration: 10s940ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s940ms - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-18 20:46:55 Duration: 10s940ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 9s703ms 1 9s703ms 9s703ms 9s703ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 18 21 1 9s703ms 9s703ms [ User: a3dsupervisor - Total duration: 9s703ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s703ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-18 20:46:43 Duration: 9s703ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 9 57s525ms 5s93ms 8s54ms 6s391ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 18 08 1 6s311ms 6s311ms 09 8 51s213ms 6s401ms [ User: a3dsupervisor - Total duration: 57s525ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 57s525ms - Times executed: 9 ]
-
COMMIT;
Date: 2025-11-18 08:45:27 Duration: 8s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 08:46:09 Duration: 7s701ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 08:45:26 Duration: 6s693ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2 11s982ms 5s547ms 6s435ms 5s991ms 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 #2
Day Hour Count Duration Avg duration Nov 18 08 1 6s435ms 6s435ms 09 1 5s547ms 5s547ms [ User: a3dsupervisor - Total duration: 11s982ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s982ms - Times executed: 2 ]
-
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-18 07:56:14 Duration: 6s435ms Database: autotest_api_batch 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: 2025-11-18 08:44:43 Duration: 5s547ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1 1m10s 1m10s 1m10s 1m10s vacuum analyze;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 18 21 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 1m10s - Times executed: 1 ]
[ Application: psql - Total duration: 1m10s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-11-18 20:51:57 Duration: 1m10s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1 35s779ms 35s779ms 35s779ms 35s779ms vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 18 21 1 35s779ms 35s779ms [ User: a3dsupervisor - Total duration: 35s779ms - Times executed: 1 ]
[ Application: psql - Total duration: 35s779ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-18 20:52:40 Duration: 35s779ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 35s217ms 35s217ms 35s217ms 35s217ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 18 21 1 35s217ms 35s217ms [ User: a3dsupervisor - Total duration: 35s217ms - Times executed: 1 ]
[ Application: psql - Total duration: 35s217ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-18 20:49:59 Duration: 35s217ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1 30s538ms 30s538ms 30s538ms 30s538ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 21 1 30s538ms 30s538ms [ User: a3dsupervisor - Total duration: 30s538ms - Times executed: 1 ]
[ Application: psql - Total duration: 30s538ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-18 20:47:33 Duration: 30s538ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1 24s50ms 24s50ms 24s50ms 24s50ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 18 21 1 24s50ms 24s50ms [ User: a3dsupervisor - Total duration: 24s50ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24s50ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-18 20:55:18 Duration: 24s50ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1 19s394ms 19s394ms 19s394ms 19s394ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 21 1 19s394ms 19s394ms [ User: a3dsupervisor - Total duration: 19s394ms - Times executed: 1 ]
[ Application: psql - Total duration: 19s394ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-18 20:49:07 Duration: 19s394ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1 17s622ms 17s622ms 17s622ms 17s622ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 18 21 1 17s622ms 17s622ms [ User: a3dsupervisor - Total duration: 17s622ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s622ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-18 20:48:41 Duration: 17s622ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1 17s54ms 17s54ms 17s54ms 17s54ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 21 1 17s54ms 17s54ms [ User: a3dsupervisor - Total duration: 17s54ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s54ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-18 20:48:03 Duration: 17s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1 14s529ms 14s529ms 14s529ms 14s529ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 21 1 14s529ms 14s529ms [ User: a3dsupervisor - Total duration: 14s529ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s529ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-18 20:45:54 Duration: 14s529ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1 13s231ms 13s231ms 13s231ms 13s231ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 21 1 13s231ms 13s231ms [ User: a3dsupervisor - Total duration: 13s231ms - Times executed: 1 ]
[ Application: psql - Total duration: 13s231ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-18 20:46:07 Duration: 13s231ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1 12s887ms 12s887ms 12s887ms 12s887ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 21 1 12s887ms 12s887ms [ User: a3dsupervisor - Total duration: 12s887ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s887ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-18 20:43:52 Duration: 12s887ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1 12s588ms 12s588ms 12s588ms 12s588ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 21 1 12s588ms 12s588ms [ User: a3dsupervisor - Total duration: 12s588ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s588ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-18 20:46:19 Duration: 12s588ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1 12s483ms 12s483ms 12s483ms 12s483ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 21 1 12s483ms 12s483ms [ User: a3dsupervisor - Total duration: 12s483ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s483ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-18 20:47:45 Duration: 12s483ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 1 12s39ms 12s39ms 12s39ms 12s39ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 21 1 12s39ms 12s39ms [ User: a3dsupervisor - Total duration: 12s39ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s39ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-18 20:44:33 Duration: 12s39ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 1 12s10ms 12s10ms 12s10ms 12s10ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 18 21 1 12s10ms 12s10ms [ User: a3dsupervisor - Total duration: 12s10ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s10ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-18 20:44:21 Duration: 12s10ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 1 11s887ms 11s887ms 11s887ms 11s887ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 21 1 11s887ms 11s887ms [ User: a3dsupervisor - Total duration: 11s887ms - Times executed: 1 ]
[ Application: psql - Total duration: 11s887ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-18 20:49:23 Duration: 11s887ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 1 10s940ms 10s940ms 10s940ms 10s940ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 21 1 10s940ms 10s940ms [ User: a3dsupervisor - Total duration: 10s940ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s940ms - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-18 20:46:55 Duration: 10s940ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 1 9s703ms 9s703ms 9s703ms 9s703ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 18 21 1 9s703ms 9s703ms [ User: a3dsupervisor - Total duration: 9s703ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s703ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-18 20:46:43 Duration: 9s703ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m10s 1m10s 1m10s 1 1m10s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 18 21 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 1m10s - Times executed: 1 ]
[ Application: psql - Total duration: 1m10s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-11-18 20:51:57 Duration: 1m10s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 35s779ms 35s779ms 35s779ms 1 35s779ms vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 18 21 1 35s779ms 35s779ms [ User: a3dsupervisor - Total duration: 35s779ms - Times executed: 1 ]
[ Application: psql - Total duration: 35s779ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-18 20:52:40 Duration: 35s779ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 35s217ms 35s217ms 35s217ms 1 35s217ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 18 21 1 35s217ms 35s217ms [ User: a3dsupervisor - Total duration: 35s217ms - Times executed: 1 ]
[ Application: psql - Total duration: 35s217ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-18 20:49:59 Duration: 35s217ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 30s538ms 30s538ms 30s538ms 1 30s538ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 18 21 1 30s538ms 30s538ms [ User: a3dsupervisor - Total duration: 30s538ms - Times executed: 1 ]
[ Application: psql - Total duration: 30s538ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-18 20:47:33 Duration: 30s538ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 24s50ms 24s50ms 24s50ms 1 24s50ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 18 21 1 24s50ms 24s50ms [ User: a3dsupervisor - Total duration: 24s50ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24s50ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-18 20:55:18 Duration: 24s50ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 19s394ms 19s394ms 19s394ms 1 19s394ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 21 1 19s394ms 19s394ms [ User: a3dsupervisor - Total duration: 19s394ms - Times executed: 1 ]
[ Application: psql - Total duration: 19s394ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-18 20:49:07 Duration: 19s394ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 17s622ms 17s622ms 17s622ms 1 17s622ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 18 21 1 17s622ms 17s622ms [ User: a3dsupervisor - Total duration: 17s622ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s622ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-18 20:48:41 Duration: 17s622ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 17s54ms 17s54ms 17s54ms 1 17s54ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 21 1 17s54ms 17s54ms [ User: a3dsupervisor - Total duration: 17s54ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s54ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-18 20:48:03 Duration: 17s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 14s529ms 14s529ms 14s529ms 1 14s529ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 18 21 1 14s529ms 14s529ms [ User: a3dsupervisor - Total duration: 14s529ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s529ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-18 20:45:54 Duration: 14s529ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 13s231ms 13s231ms 13s231ms 1 13s231ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 21 1 13s231ms 13s231ms [ User: a3dsupervisor - Total duration: 13s231ms - Times executed: 1 ]
[ Application: psql - Total duration: 13s231ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-18 20:46:07 Duration: 13s231ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 12s887ms 12s887ms 12s887ms 1 12s887ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 21 1 12s887ms 12s887ms [ User: a3dsupervisor - Total duration: 12s887ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s887ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-18 20:43:52 Duration: 12s887ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 12s588ms 12s588ms 12s588ms 1 12s588ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 21 1 12s588ms 12s588ms [ User: a3dsupervisor - Total duration: 12s588ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s588ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-18 20:46:19 Duration: 12s588ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 12s483ms 12s483ms 12s483ms 1 12s483ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 21 1 12s483ms 12s483ms [ User: a3dsupervisor - Total duration: 12s483ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s483ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-18 20:47:45 Duration: 12s483ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 12s39ms 12s39ms 12s39ms 1 12s39ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 21 1 12s39ms 12s39ms [ User: a3dsupervisor - Total duration: 12s39ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s39ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-18 20:44:33 Duration: 12s39ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 12s10ms 12s10ms 12s10ms 1 12s10ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 21 1 12s10ms 12s10ms [ User: a3dsupervisor - Total duration: 12s10ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s10ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-18 20:44:21 Duration: 12s10ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 11s887ms 11s887ms 11s887ms 1 11s887ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 21 1 11s887ms 11s887ms [ User: a3dsupervisor - Total duration: 11s887ms - Times executed: 1 ]
[ Application: psql - Total duration: 11s887ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-18 20:49:23 Duration: 11s887ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 10s940ms 10s940ms 10s940ms 1 10s940ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 18 21 1 10s940ms 10s940ms [ User: a3dsupervisor - Total duration: 10s940ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s940ms - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-18 20:46:55 Duration: 10s940ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 9s703ms 9s703ms 9s703ms 1 9s703ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 21 1 9s703ms 9s703ms [ User: a3dsupervisor - Total duration: 9s703ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s703ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-18 20:46:43 Duration: 9s703ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5s93ms 8s54ms 6s391ms 9 57s525ms commit;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 08 1 6s311ms 6s311ms 09 8 51s213ms 6s401ms [ User: a3dsupervisor - Total duration: 57s525ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 57s525ms - Times executed: 9 ]
-
COMMIT;
Date: 2025-11-18 08:45:27 Duration: 8s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 08:46:09 Duration: 7s701ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 08:45:26 Duration: 6s693ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s547ms 6s435ms 5s991ms 2 11s982ms 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 #20
Day Hour Count Duration Avg duration Nov 18 08 1 6s435ms 6s435ms 09 1 5s547ms 5s547ms [ User: a3dsupervisor - Total duration: 11s982ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s982ms - Times executed: 2 ]
-
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-18 07:56:14 Duration: 6s435ms Database: autotest_api_batch 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: 2025-11-18 08:44:43 Duration: 5s547ms Database: autotest_api_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
Log levels
Key values
- 7,789 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 4907 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 4,861 Max number of times the same event was reported
- 4,923 Total events found
Rank Times reported Error 1 4,861 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 18 01 955 02 581 03 190 04 437 05 429 06 287 07 1 22 778 23 871 00 332 2 20 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 18 14 2 19 2 21 7 22 9 3 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 18 21 16 4 11 ERROR: operator does not exist: integer = character varying
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 18 21 7 22 4 5 5 ERROR: function convert(...) does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 18 22 5 6 1 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 18 21 1 7 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 18 21 1 8 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 18 21 1 9 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 18 21 1 10 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 18 21 1 11 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 18 21 1 12 1 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 18 21 1 13 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 18 21 1 14 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 18 21 1 15 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 18 21 1