pgBadger :: pgBadger

Global information

Generated on Tue Mar 10 09:06:20 2026
Log file: ./2026-03-09_PT1D.log
Parsed 8,796 log entries in 9s
Log start from 2026-03-09 00:16:38 to 2026-03-09 23:59:59

Global Stats

91 Number of unique normalized queries
365 Number of queries
1h57m47s Total query duration
2026-03-09 06:25:35 First query
2026-03-09 23:24:25 Last query
8 queries/s at 2026-03-09 06:26:49 Query peak

1h57m47s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
1h57m47s Execute total duration

4,033 Number of events
8 Number of unique normalized events
3,905 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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
365 Average queries per session
1h57m47s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

8 queries/s Query Peak
2026-03-09 06:26:49 Date

SELECT Traffic

Key values

8 queries/s Query Peak
2026-03-09 06:26:49 Date

INSERT/UPDATE/DELETE Traffic

Key values

2 queries/s Query Peak
2026-03-09 21:54:37 Date

Queries duration

Key values

1h57m47s 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

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 09	00	0	0ms	0ms	0ms	0ms	0ms	0ms
	04	0	0ms	0ms	0ms	0ms	0ms	0ms
	06	236	3s	9s600ms	3s286ms	52s794ms	52s845ms	1m28s
	07	10	0ms	5m21s	54s716ms	1m51s	5m21s	5m21s
	08	9	3s61ms	35s42ms	10s31ms	35s42ms	35s42ms	35s42ms
	10	1	18s958ms	18s958ms	18s958ms	18s958ms	18s958ms	18s958ms
	15	0	0ms	0ms	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms	0ms	0ms
	21	66	3s3ms	7m9s	48s630ms	7m58s	11m30s	11m30s
	22	21	0ms	9m4s	1m31s	2m42s	4m59s	9m4s
	23	22	0ms	28s743ms	23s246ms	53s237ms	54s45ms	55s271ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 09	00	0	0ms	0ms	0ms	0ms
	04	0	0ms	0ms	0ms	0ms
	06	236	3s286ms	39s933ms	52s794ms	1m28s
	07	5	1m32s	20s22ms	1m51s	5m21s
	08	7	9s812ms	24s266ms	35s42ms	35s42ms
	10	0	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms
	22	13	1m22s	2m8s	2m37s	4m59s
	23	22	23s246ms	26s615ms	53s237ms	54s220ms

Day	Hour	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 09	00	0	0	0	0ms	0ms	0ms	0ms
	04	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	0	0ms	0ms	0ms	0ms
	07	0	3	0	25s524ms	0ms	5s224ms	49s732ms
	08	0	0	0	0ms	0ms	0ms	0ms
	10	1	0	0	18s958ms	18s958ms	18s958ms	18s958ms
	15	0	0	0	0ms	0ms	0ms	0ms
	16	0	0	0	0ms	0ms	0ms	0ms
	21	0	0	10	1m30s	0ms	56s375ms	7m9s
	22	0	0	0	0ms	0ms	0ms	0ms
	23	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Mar 09	00	0	0.00	0.00%
	04	0	0.00	0.00%
	06	236	236.00	0.00%
	07	10	10.00	0.00%
	08	9	9.00	0.00%
	10	1	1.00	0.00%
	15	0	0.00	0.00%
	16	0	0.00	0.00%
	21	0	0.00	0.00%
	22	15	15.00	0.00%
	23	22	22.00	0.00%

Day	Hour	Average / Second
Mar 09	00	0.00/s
	04	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	10	0.00/s
	15	0.00/s
	16	0.00/s
	21	0.00/s
	22	0.00/s
	23	0.00/s

Day	Hour	Average Duration	Average idle time
Mar 09	00	0ms	0ms
	04	0ms	0ms
	06	0ms	0ms
	07	0ms	0ms
	08	0ms	0ms
	10	0ms	0ms
	15	0ms	0ms
	16	0ms	0ms
	21	0ms	0ms
	22	0ms	0ms
	23	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Mar 09	00	0	0	0
	04	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	10	0	0	0
	15	0	0	0
	16	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

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)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

unknown (0) Main table analyzed (database )
0 analyzes Total

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

unknown (0) Main table vacuumed on database
0 vacuums Total

Chart
Table

Vacuums per tables

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
NO DATASET

Tuples removed per table

Key values

unknown (0) Main table with removed tuples on database
0 tuples Total removed

Chart
Table

Tuples removed per tables

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
NO DATASET

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
NO DATASET

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Mar 09	00	0	0
	04	0	0
	06	0	0
	07	0	0
	08	0	0
	10	0	0
	15	0	0
	16	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

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 by type

Key values

283 Total read queries
80 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	283	77.53%
INSERT	0	0.00%
UPDATE	1	0.27%
DELETE	3	0.82%
COPY FROM	10	2.74%
COPY TO	0	0.00%
CTE	1	0.27%
DDL	61	16.71%
TCL	4	1.10%
CURSOR	0	0.00%
OTHERS	2	0.55%

Queries by database

Key values

perf_minarm Main database
365 Requests
1h57m47s (perf_minarm)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
perf_minarm	Total	365	1h57m47s
	copy from	10	15m5s
	cte	1	4s504ms
	ddl	61	41m12s
	delete	3	1m16s
	others	2	10m52s
	select	283	48m2s
	tcl	4	55s188ms
	update	1	18s958ms

Queries by user

Key values

a3d Main user
730 Requests

Queries Chart
Table

User	Request type	Count	Duration
a3d	Total	730	3h55m35s
	copy from	20	30m11s
	cte	2	9s8ms
	ddl	122	1h22m25s
	delete	6	2m33s
	others	4	21m44s
	select	566	1h36m4s
	tcl	8	1m50s
	update	2	37s916ms

Duration by user

Key values

3h55m35s (a3d) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
a3d	Total	730	3h55m35s
	copy from	20	30m11s
	cte	2	9s8ms
	ddl	122	1h22m25s
	delete	6	2m33s
	others	4	21m44s
	select	566	1h36m4s
	tcl	8	1m50s
	update	2	37s916ms

Queries by host

Key values

10.7.173.69 Main host
338 Requests
1h56m11s (10.6.201.196)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.6.201.196	Total	144	1h56m11s
	copy from	20	30m11s
	ddl	122	1h22m25s
	others	2	3m34s
10.7.173.67	Total	248	15m54s
	select	238	13m25s
	tcl	8	1m50s
	update	2	37s916ms
10.7.173.69	Total	338	1h43m30s
	cte	2	9s8ms
	delete	6	2m33s
	others	2	18m9s
	select	328	1h22m38s

Queries by application

Key values

PostgreSQL JDBC Driver Main application
293 Requests
59m42s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	293	59m42s
	cte	1	4s504ms
	delete	3	1m16s
	others	1	9m4s
	select	283	48m2s
	tcl	4	55s188ms
	update	1	18s958ms
pg_restore	Total	71	56m18s
	copy from	10	15m5s
	ddl	61	41m12s
psql	Total	1	1m47s
	others	1	1m47s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-03-09 06:34:29 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

271 1000-10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	271	74.25%
> 10000ms	94	25.75%

Slowest individual queries


[ Date: 2026-03-09 22:14:12 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 21:39:30 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 21:49:23 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 07:09:15 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 21:49:00 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 21:36:36 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 22:40:54 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 22:41:58 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 22:43:31 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 22:39:41 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 22:41:59 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 22:44:07 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 21:54:21 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 21:52:20 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 07:15:39 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 22:04:10 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: psql ]
[ Date: 2026-03-09 21:57:12 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 22:46:51 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-03-09 21:44:18 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-03-09 21:57:29 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]

Rank	Duration	Query
1	9m4s	DO $body$ DECLARE L_SCRIPT_NAME CONSTANT text := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID, ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (ga.att_template_num_id = gat.att_template_num_id) INNER JOIN GED_DOCUMENT ge ON (ga.OBJ_COMPO_VALUE::varchar = ge.document_num_id::varchar) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (tab.OBJ_COMPO_NUM_ID = ga.obj_compo_num_id_tab) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId varchar(100); cNewGedId bigint; BEGIN INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME \|\| ' [START]', '7.23.0.0'); raise debug 'START %', L_SCRIPT_NAME; OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; EXIT WHEN NOT FOUND; SELECT gd.document_num_id INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (gei.node_num_id = gd.node_num_id) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id::varchar = cOldGedId; UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId::varchar WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; raise notice 'END %', L_SCRIPT_NAME; UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = true WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME \|\| ' [SUCCESS]', '7.23.0.0'); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME \|\| ' [ERROR]', '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR ('POST_INSTALL ' \|\| L_SCRIPT_NAME, SQLERRM, '7.23.0.0'); RAISE; END $body$; [ Date: 2026-03-09 22:14:12 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	7m9s	COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin; [ Date: 2026-03-09 21:39:30 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
3	6m	CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text)); [ Date: 2026-03-09 21:49:23 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
4	5m21s	SELECT /+ FIRST_ROWS(1) / btuSrc.UNIQUE_ID FROM GTP_BACKGROUND_TASK_UNIQUEID btuSrc WHERE btuSrc.UNIQUE_ID IN ( SELECT btuDest.UNIQUE_ID FROM GTP_BACKGROUND_TASK_UNIQUEID btuDest INNER JOIN GTP_BACKGROUND_TASK bt ON btuDest.TASK_NUM_ID = bt.TASK_NUM_ID WHERE btuDest.TASK_NUM_ID <> '1631629' AND bt.TASK_STATUS <> '1') AND btuSrc.TASK_NUM_ID = '1631629'; [ Date: 2026-03-09 07:09:15 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	4m41s	CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id); [ Date: 2026-03-09 21:49:00 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
6	4m15s	COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin; [ Date: 2026-03-09 21:36:36 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
7	2m42s	SELECT * FROM ( SELECT /+CURSOR_SHARING_EXACT LEADING(gor_0_0)/ '/753-36/547-24/615-1720/919-1633/918' as idPath, gor_0_0.container_num_id as obj_0, 36 as rel_0, gor_0_0.content_num_id as obj_1, 24 as rel_1, gor_0_1.container_num_id as obj_2, 1720 as rel_2, gor_0_2.container_num_id as obj_3, 1633 as rel_3, gor_0_3.content_num_id as obj_4 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.rel_template_num_id = '24' AND gor_0_1.content_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.rel_template_num_id = '1720' AND gor_0_2.content_num_id = gor_0_1.container_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.CONTENT_TEMPLATE_NUM_ID = '918' AND gor_0_3.rel_template_num_id = '1633' AND gor_0_3.container_num_id = gor_0_2.container_num_id) LEFT OUTER JOIN GTP_OBJ_COMPOSITION gor_0_3_goc_0 ON (gor_0_3.content_num_id = gor_0_3_goc_0.obj_num_id AND gor_0_3_goc_0.att_template_category_num_id = '28' AND gor_0_3_goc_0.att_template_num_id = '150') INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_3.content_num_id WHERE gor_0_0.rel_template_num_id = '36' AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = '547' AND gor_0_3_goc_0.obj_compo_value LIKE '%WEBSERVICES%' AND gob_0_0.OBJ_STATE IS NULL) path ORDER BY 10 desc; [ Date: 2026-03-09 22:40:54 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	2m41s	SELECT * FROM ( SELECT /+CURSOR_SHARING_EXACT LEADING(gor_0_0)/ '/753-36/547-24/615-1720/919-1633/918' as idPath, gor_0_0.container_num_id as obj_0, 36 as rel_0, gor_0_0.content_num_id as obj_1, 24 as rel_1, gor_0_1.container_num_id as obj_2, 1720 as rel_2, gor_0_2.container_num_id as obj_3, 1633 as rel_3, gor_0_3.content_num_id as obj_4 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.rel_template_num_id = '24' AND gor_0_1.content_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.rel_template_num_id = '1720' AND gor_0_2.content_num_id = gor_0_1.container_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.CONTENT_TEMPLATE_NUM_ID = '918' AND gor_0_3.rel_template_num_id = '1633' AND gor_0_3.container_num_id = gor_0_2.container_num_id) LEFT OUTER JOIN GTP_OBJ_COMPOSITION gor_0_3_goc_0 ON (gor_0_3.content_num_id = gor_0_3_goc_0.obj_num_id AND gor_0_3_goc_0.att_template_category_num_id = '28' AND gor_0_3_goc_0.att_template_num_id = '150') INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_3.content_num_id WHERE gor_0_0.rel_template_num_id = '36' AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = '547' AND gor_0_3_goc_0.obj_compo_value LIKE '%WEBSERVICE%' AND gob_0_0.OBJ_STATE IS NULL) path ORDER BY 10 desc; [ Date: 2026-03-09 22:41:58 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	2m37s	SELECT * FROM ( SELECT /+CURSOR_SHARING_EXACT LEADING(gor_0_0)/ '/753-36/547-24/615-24/364-1720/919-1633/918' as idPath, gor_0_0.container_num_id as obj_0, 36 as rel_0, gor_0_0.content_num_id as obj_1, 24 as rel_1, gor_0_1.container_num_id as obj_2, 24 as rel_2, gor_0_2.content_num_id as obj_3, 1720 as rel_3, gor_0_3.container_num_id as obj_4, 1633 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.rel_template_num_id = '24' AND gor_0_1.content_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = '364' AND gor_0_2.rel_template_num_id = '24' AND gor_0_2.container_num_id = gor_0_1.container_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.rel_template_num_id = '1720' AND gor_0_3.content_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = '918' AND gor_0_4.rel_template_num_id = '1633' AND gor_0_4.container_num_id = gor_0_3.container_num_id) LEFT OUTER JOIN GTP_OBJ_COMPOSITION gor_0_4_goc_0 ON (gor_0_4.content_num_id = gor_0_4_goc_0.obj_num_id AND gor_0_4_goc_0.att_template_category_num_id = '28' AND gor_0_4_goc_0.att_template_num_id = '150') INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = '36' AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = '547' AND gor_0_4_goc_0.obj_compo_value LIKE '%WEBSERVICES%' AND gob_0_0.OBJ_STATE IS NULL) path ORDER BY 12 desc; [ Date: 2026-03-09 22:43:31 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	2m35s	SELECT * FROM ( SELECT /+CURSOR_SHARING_EXACT LEADING(gor_0_0)/ '/753-36/547-24/615-1720/919-1633/918' as idPath, gor_0_0.container_num_id as obj_0, 36 as rel_0, gor_0_0.content_num_id as obj_1, 24 as rel_1, gor_0_1.container_num_id as obj_2, 1720 as rel_2, gor_0_2.container_num_id as obj_3, 1633 as rel_3, gor_0_3.content_num_id as obj_4 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.rel_template_num_id = '24' AND gor_0_1.content_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.rel_template_num_id = '1720' AND gor_0_2.content_num_id = gor_0_1.container_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.CONTENT_TEMPLATE_NUM_ID = '918' AND gor_0_3.rel_template_num_id = '1633' AND gor_0_3.container_num_id = gor_0_2.container_num_id) LEFT OUTER JOIN GTP_OBJ_COMPOSITION gor_0_3_goc_0 ON (gor_0_3.content_num_id = gor_0_3_goc_0.obj_num_id AND gor_0_3_goc_0.att_template_category_num_id = '28' AND gor_0_3_goc_0.att_template_num_id = '150') INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_3.content_num_id WHERE gor_0_0.rel_template_num_id = '36' AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = '547' AND gor_0_3_goc_0.obj_compo_value LIKE '%OI_WEBSERVICE%' AND gob_0_0.OBJ_STATE IS NULL) path ORDER BY 10 desc; [ Date: 2026-03-09 22:39:41 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	2m17s	SELECT * FROM ( SELECT /+CURSOR_SHARING_EXACT LEADING(gor_0_0)/ '/753-36/547-24/615-24/364-1720/919-1633/918' as idPath, gor_0_0.container_num_id as obj_0, 36 as rel_0, gor_0_0.content_num_id as obj_1, 24 as rel_1, gor_0_1.container_num_id as obj_2, 24 as rel_2, gor_0_2.content_num_id as obj_3, 1720 as rel_3, gor_0_3.container_num_id as obj_4, 1633 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.rel_template_num_id = '24' AND gor_0_1.content_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = '364' AND gor_0_2.rel_template_num_id = '24' AND gor_0_2.container_num_id = gor_0_1.container_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.rel_template_num_id = '1720' AND gor_0_3.content_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = '918' AND gor_0_4.rel_template_num_id = '1633' AND gor_0_4.container_num_id = gor_0_3.container_num_id) LEFT OUTER JOIN GTP_OBJ_COMPOSITION gor_0_4_goc_0 ON (gor_0_4.content_num_id = gor_0_4_goc_0.obj_num_id AND gor_0_4_goc_0.att_template_category_num_id = '28' AND gor_0_4_goc_0.att_template_num_id = '150') INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = '36' AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = '547' AND gor_0_4_goc_0.obj_compo_value LIKE '%OI_WEBSERVICE%' AND gob_0_0.OBJ_STATE IS NULL) path ORDER BY 12 desc; [ Date: 2026-03-09 22:41:59 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	2m8s	SELECT * FROM ( SELECT /+CURSOR_SHARING_EXACT LEADING(gor_0_0)/ '/753-36/547-24/615-24/364-1720/919-1633/918' as idPath, gor_0_0.container_num_id as obj_0, 36 as rel_0, gor_0_0.content_num_id as obj_1, 24 as rel_1, gor_0_1.container_num_id as obj_2, 24 as rel_2, gor_0_2.content_num_id as obj_3, 1720 as rel_3, gor_0_3.container_num_id as obj_4, 1633 as rel_4, gor_0_4.content_num_id as obj_5 FROM gtp_relation gor_0_0 inner join gtp_relation gor_0_1 on (gor_0_1.rel_template_num_id = '24' AND gor_0_1.content_num_id = gor_0_0.content_num_id) inner join gtp_relation gor_0_2 on (gor_0_2.CONTENT_TEMPLATE_NUM_ID = '364' AND gor_0_2.rel_template_num_id = '24' AND gor_0_2.container_num_id = gor_0_1.container_num_id) inner join gtp_relation gor_0_3 on (gor_0_3.rel_template_num_id = '1720' AND gor_0_3.content_num_id = gor_0_2.content_num_id) inner join gtp_relation gor_0_4 on (gor_0_4.CONTENT_TEMPLATE_NUM_ID = '918' AND gor_0_4.rel_template_num_id = '1633' AND gor_0_4.container_num_id = gor_0_3.container_num_id) LEFT OUTER JOIN GTP_OBJ_COMPOSITION gor_0_4_goc_0 ON (gor_0_4.content_num_id = gor_0_4_goc_0.obj_num_id AND gor_0_4_goc_0.att_template_category_num_id = '28' AND gor_0_4_goc_0.att_template_num_id = '150') INNER JOIN GTP_OBJ gob_0_0 on gob_0_0.obj_num_id = gor_0_4.content_num_id WHERE gor_0_0.rel_template_num_id = '36' AND gor_0_0.CONTENT_TEMPLATE_NUM_ID = '547' AND gor_0_4_goc_0.obj_compo_value LIKE '%WEBSERVICE%' AND gob_0_0.OBJ_STATE IS NULL) path ORDER BY 12 desc; [ Date: 2026-03-09 22:44:07 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	2m1s	ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_tab FOREIGN KEY (obj_compo_num_id_tab) REFERENCES public.gtp_obj_composition (obj_compo_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; [ Date: 2026-03-09 21:54:21 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
14	1m52s	ALTER TABLE ONLY public.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: 2026-03-09 21:52:20 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
15	1m51s	SELECT /+ FIRST_ROWS(1) / btuSrc.UNIQUE_ID FROM GTP_BACKGROUND_TASK_UNIQUEID btuSrc WHERE btuSrc.UNIQUE_ID IN ( SELECT btuDest.UNIQUE_ID FROM GTP_BACKGROUND_TASK_UNIQUEID btuDest INNER JOIN GTP_BACKGROUND_TASK bt ON btuDest.TASK_NUM_ID = bt.TASK_NUM_ID WHERE btuDest.TASK_NUM_ID <> '1631631' AND bt.TASK_STATUS <> '1') AND btuSrc.TASK_NUM_ID = '1631631'; [ Date: 2026-03-09 07:15:39 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	1m47s	VACUUM ANALYSE; [ Date: 2026-03-09 22:04:10 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: psql ]
17	1m28s	ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; [ Date: 2026-03-09 21:57:12 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
18	1m27s	SELECT /+cursor_sharing_exact/ gob.obj_num_id FROM gtp_obj gob LEFT OUTER JOIN GTP_OBJ_COMPOSITION gob_goc_0 ON (gob.obj_num_id = gob_goc_0.obj_num_id AND gob_goc_0.att_template_category_num_id = '28' AND gob_goc_0.att_template_num_id = '150') WHERE gob_goc_0.obj_compo_value LIKE '%DI - WEBSERVICE%' AND gob.OBJ_B_VALID = 1 AND gob.OBJ_STATE IS NULL AND gob.obj_status = 1 AND gob.obj_template_num_id = '676' AND gob.obj_template_num_id in ( select gntt.obj_template_num_id from gtp_node_tree_type gntt where gntt.type_node_code = 'OBJ' AND gntt.view_template_num_id = '74') ORDER BY gob.obj_num_id desc; [ Date: 2026-03-09 22:46:51 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	1m20s	CREATE INDEX i_gtp_obj_compo_template ON public.gtp_obj_composition USING btree (att_template_num_id); [ Date: 2026-03-09 21:44:18 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
20	1m16s	ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; [ Date: 2026-03-09 21:57:29 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]

Time consuming queries (N)


[ User: a3d - Total duration: 13m4s - Times executed: 239 ]
[ User: a3d - Total duration: 9m4s - Times executed: 1 ]
[ User: a3d - Total duration: 8m6s - Times executed: 18 ]
[ User: a3d - Total duration: 8m - Times executed: 3 ]
[ User: a3d - Total duration: 7m40s - Times executed: 5 ]
[ User: a3d - Total duration: 7m9s - Times executed: 1 ]
[ User: a3d - Total duration: 7m3s - Times executed: 3 ]
[ User: a3d - Total duration: 6m - Times executed: 1 ]
[ User: a3d - Total duration: 4m41s - Times executed: 1 ]
[ User: a3d - Total duration: 4m15s - Times executed: 1 ]
[ User: a3d - Total duration: 2m4s - Times executed: 3 ]
[ User: a3d - Total duration: 2m1s - Times executed: 1 ]
[ User: a3d - Total duration: 1m52s - Times executed: 1 ]
[ User: a3d - Total duration: 1m47s - Times executed: 1 ]
[ User: a3d - Total duration: 1m28s - Times executed: 1 ]
[ User: a3d - Total duration: 1m20s - Times executed: 1 ]
[ User: a3d - Total duration: 1m16s - Times executed: 1 ]
[ User: a3d - Total duration: 1m16s - Times executed: 3 ]
[ User: a3d - Total duration: 1m5s - Times executed: 1 ]
[ User: a3d - Total duration: 1m4s - Times executed: 1 ]

Most frequent queries (N)


[ User: a3d - Total duration: 13m4s - Times executed: 239 ]
[ User: a3d - Total duration: 8m6s - Times executed: 18 ]
[ User: a3d - Total duration: 7m40s - Times executed: 5 ]
[ User: a3d - Total duration: 55s188ms - Times executed: 4 ]
[ User: a3d - Total duration: 8m - Times executed: 3 ]
[ User: a3d - Total duration: 7m3s - Times executed: 3 ]
[ User: a3d - Total duration: 2m4s - Times executed: 3 ]
[ User: a3d - Total duration: 1m16s - Times executed: 3 ]
[ User: a3d - Total duration: 24s266ms - Times executed: 3 ]
[ User: a3d - Total duration: 26s540ms - Times executed: 2 ]
[ User: a3d - Total duration: 11s228ms - Times executed: 2 ]
[ User: a3d - Total duration: 9m4s - Times executed: 1 ]
[ User: a3d - Total duration: 7m9s - Times executed: 1 ]
[ User: a3d - Total duration: 6m - Times executed: 1 ]
[ User: a3d - Total duration: 4m41s - Times executed: 1 ]
[ User: a3d - Total duration: 4m15s - Times executed: 1 ]
[ User: a3d - Total duration: 2m1s - Times executed: 1 ]
[ User: a3d - Total duration: 1m52s - Times executed: 1 ]
[ User: a3d - Total duration: 1m47s - Times executed: 1 ]
[ User: a3d - Total duration: 1m28s - Times executed: 1 ]

Normalized slowest queries (N)


[ User: a3d - Total duration: 9m4s - Times executed: 1 ]
[ User: a3d - Total duration: 7m9s - Times executed: 1 ]
[ User: a3d - Total duration: 6m - Times executed: 1 ]
[ User: a3d - Total duration: 4m41s - Times executed: 1 ]
[ User: a3d - Total duration: 4m15s - Times executed: 1 ]
[ User: a3d - Total duration: 8m - Times executed: 3 ]
[ User: a3d - Total duration: 7m3s - Times executed: 3 ]
[ User: a3d - Total duration: 2m1s - Times executed: 1 ]
[ User: a3d - Total duration: 1m52s - Times executed: 1 ]
[ User: a3d - Total duration: 1m47s - Times executed: 1 ]
[ User: a3d - Total duration: 7m40s - Times executed: 5 ]
[ User: a3d - Total duration: 1m28s - Times executed: 1 ]
[ User: a3d - Total duration: 1m20s - Times executed: 1 ]
[ User: a3d - Total duration: 1m16s - Times executed: 1 ]
[ User: a3d - Total duration: 1m5s - Times executed: 1 ]
[ User: a3d - Total duration: 1m4s - Times executed: 1 ]
[ User: a3d - Total duration: 2m4s - Times executed: 3 ]
[ User: a3d - Total duration: 8m6s - Times executed: 18 ]
[ User: a3d - Total duration: 1m16s - Times executed: 3 ]
[ User: a3d - Total duration: 55s188ms - Times executed: 4 ]

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

Log levels

Key values

12,659 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	48	0.38%
DETAIL	4,189	33.09%
ERROR	4,022	31.77%
HINT	2	0.02%
LOG	365	2.88%
STATEMENT	4,022	31.77%
WARNING	11	0.09%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
4022 ERROR entries
11 WARNING entries

Most Frequent Errors/Events

Key values

3,905 Max number of times the same event was reported
4,033 Total events found

Rank

Times reported

Error

1

3,905

Details

ERROR: duplicate key value violates unique constraint "..."

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Mar 09	00	1
	04	1
	16	1
	22	519
	23	3,383

ERROR: duplicate key value violates unique constraint "pk_applicative_lock"
ERROR: duplicate key value violates unique constraint "pk_gtp_log_metric"

2

48

Details

ERROR: canceling statement due to lock timeout

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Mar 09	07	45
	15	3

ERROR: canceling statement due to lock timeout

3

48

Details

ERROR: current transaction is aborted, commands ignored until end of transaction block

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Mar 09	07	45
	15	3

ERROR: current transaction is aborted, commands ignored until end of transaction block

4

18

Details

ERROR: relation "..." already exists

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Mar 09	22	18

ERROR: relation "batch_job_instance" already exists
ERROR: relation "batch_job_execution" already exists
ERROR: relation "batch_job_execution_params" already exists

5

11

Details

WARNING: permission denied to vacuum "...", skipping it

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Mar 09	22	11

6

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Mar 09	22	1

ERROR: relation "public.databasechangeloglock" does not exist at character 22

7

1

Details

ERROR: function listagg(...) does not exist

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Mar 09	23	1

ERROR: function listagg(character varying, unknown, character varying) does not exist at character 254

8

1

Details

ERROR: function trunc(...) does not exist

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Mar 09	23	1

ERROR: function trunc(timestamp without time zone) does not exist at character 307

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values