pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Feb 24 09:04:18 2026
Log file: ./2026-02-23_PT1D.log
Parsed 3,561 log entries in 13s
Log start from 2026-02-23 01:00:16 to 2026-02-23 23:29:00

Global Stats

87 Number of unique normalized queries
1,521 Number of queries
3h14m6s Total query duration
2026-02-23 06:25:36 First query
2026-02-23 23:20:36 Last query
5 queries/s at 2026-02-23 06:27:12 Query peak

3h14m6s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
3h14m6s Execute total duration

259 Number of events
7 Number of unique normalized events
111 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
1,521 Average queries per session
3h14m6s 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

5 queries/s Query Peak
2026-02-23 06:27:12 Date

SELECT Traffic

Key values

5 queries/s Query Peak
2026-02-23 06:27:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

2 queries/s Query Peak
2026-02-23 22:05:38 Date

Queries duration

Key values

3h14m6s 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)
Feb 23	01	0	0ms	0ms	0ms	0ms	0ms	0ms
	06	1,393	3s	13s620ms	3s516ms	4m54s	5m23s	5m32s
	07	9	0ms	5m56s	57s20ms	1m2s	5m56s	5m56s
	08	14	3s204ms	26s547ms	9s36ms	43s861ms	43s861ms	43s861ms
	10	1	4s984ms	4s984ms	4s984ms	4s984ms	4s984ms	4s984ms
	21	19	16s320ms	7m51s	1m53s	11m12s	11m12s	11m12s
	22	63	0ms	4m13s	53s430ms	5m15s	7m21s	8m13s
	23	22	0ms	31s946ms	26s701ms	1m1s	1m2s	1m2s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 23	01	0	0ms	0ms	0ms	0ms
	06	1,393	3s516ms	4m30s	4m54s	5m32s
	07	3	2m1s	3s371ms	4s585ms	5m56s
	08	9	8s409ms	21s739ms	26s547ms	26s547ms
	10	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms
	22	13	2m14s	3m54s	4m31s	8m13s
	23	22	26s701ms	1m	1m1s	1m2s

Day	Hour	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 23	01	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	0	0ms	0ms	0ms	0ms
	07	0	5	0	29s57ms	0ms	21s110ms	1m2s
	08	0	2	0	10s895ms	0ms	0ms	21s790ms
	10	1	0	0	4s984ms	4s984ms	4s984ms	4s984ms
	21	0	0	3	4m12s	0ms	4m9s	7m51s
	22	1	0	6	21s23ms	0ms	4s537ms	1m15s
	23	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Feb 23	01	0	0.00	0.00%
	06	1,393	1,393.00	0.00%
	07	9	9.00	0.00%
	08	14	14.00	0.00%
	10	1	1.00	0.00%
	21	0	0.00	0.00%
	22	14	14.00	0.00%
	23	22	22.00	0.00%

Day	Hour	Average / Second
Feb 23	01	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	10	0.00/s
	21	0.00/s
	22	0.00/s
	23	0.00/s

Day	Hour	Average Duration	Average idle time
Feb 23	01	0ms	0ms
	06	0ms	0ms
	07	0ms	0ms
	08	0ms	0ms
	10	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
Feb 23	01	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	10	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
Feb 23	01	0	0
	06	0	0
	07	0	0
	08	0	0
	10	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

1,440 Total read queries
80 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,440	94.67%
INSERT	0	0.00%
UPDATE	2	0.13%
DELETE	7	0.46%
COPY FROM	9	0.59%
COPY TO	0	0.00%
CTE	1	0.07%
DDL	58	3.81%
TCL	3	0.20%
CURSOR	0	0.00%
OTHERS	1	0.07%

Queries by database

Key values

perf_minarm Main database
1,521 Requests
3h14m6s (perf_minarm)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
perf_minarm	Total	1,521	3h14m6s
	copy from	9	14m59s
	cte	1	4s803ms
	ddl	58	45m17s
	delete	7	2m47s
	others	1	2m22s
	select	1,440	2h7m58s
	tcl	3	27s630ms
	update	2	9s521ms

Queries by user

Key values

a3d Main user
1,521 Requests

Queries Chart
Table

User	Request type	Count	Duration
a3d	Total	1,521	3h14m6s
	copy from	9	14m59s
	cte	1	4s803ms
	ddl	58	45m17s
	delete	7	2m47s
	others	1	2m22s
	select	1,440	2h7m58s
	tcl	3	27s630ms
	update	2	9s521ms

Duration by user

Key values

3h14m6s (a3d) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
a3d	Total	1,521	3h14m6s
	copy from	9	14m59s
	cte	1	4s803ms
	ddl	58	45m17s
	delete	7	2m47s
	others	1	2m22s
	select	1,440	2h7m58s
	tcl	3	27s630ms
	update	2	9s521ms

Queries by host

Key values

10.7.173.69 Main host
763 Requests
1h29m40s (10.7.173.69)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.6.107.196	Total	1	2m22s
	others	1	2m22s
10.6.201.196	Total	67	1h17s
	copy from	9	14m59s
	ddl	58	45m17s
10.7.173.67	Total	690	41m47s
	cte	1	4s803ms
	delete	3	31s423ms
	select	681	40m33s
	tcl	3	27s630ms
	update	2	9s521ms
10.7.173.69	Total	763	1h29m40s
	delete	4	2m15s
	select	759	1h27m24s

Queries by application

Key values

PostgreSQL JDBC Driver Main application
1,453 Requests
2h11m27s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	1,453	2h11m27s
	cte	1	4s803ms
	delete	7	2m47s
	select	1,440	2h7m58s
	tcl	3	27s630ms
	update	2	9s521ms
pg_restore	Total	67	1h17s
	copy from	9	14m59s
	ddl	58	45m17s
psql	Total	1	2m22s
	others	1	2m22s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-02-23 06:50:45 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

1,425 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	1,425	93.69%
> 10000ms	96	6.31%

Slowest individual queries


[ Date: 2026-02-23 21:49:55 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 07:10:33 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 21:59:56 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 21:59:21 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 22:33:48 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 21:46:13 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 22:37:55 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 22:37:54 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 22:35:44 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 22:39:39 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 22:09:58 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 22:33:48 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 22:41:05 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 22:16:49 - Database: perf_minarm - User: a3d - Remote: 10.6.107.196 - Application: psql ]
[ Date: 2026-02-23 22:03:20 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 22:05:20 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 22:05:38 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 22:41:05 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2026-02-23 21:54:41 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
[ Date: 2026-02-23 22:09:06 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]

Rank	Duration	Query
1	7m51s	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-02-23 21:49:55 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
2	5m56s	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 <> '1588750' AND bt.TASK_STATUS <> '1') AND btuSrc.TASK_NUM_ID = '1588750'; [ Date: 2026-02-23 07:10:33 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	5m54s	CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text)); [ Date: 2026-02-23 21:59:56 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
4	4m39s	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-02-23 21:59:21 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
5	4m13s	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-02-23 22:33:48 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	4m9s	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-02-23 21:46:13 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
7	4m7s	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-02-23 22:37:55 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	4m5s	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-02-23 22:37:54 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	3m58s	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-02-23 22:35:44 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	3m54s	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-02-23 22:39:39 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	3m8s	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-02-23 22:09:58 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
12	3m7s	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-02-23 22:33:48 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	2m35s	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-02-23 22:41:05 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	2m22s	VACUUM ANALYSE; [ Date: 2026-02-23 22:16:49 - Database: perf_minarm - User: a3d - Remote: 10.6.107.196 - Application: psql ]
15	2m13s	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-02-23 22:03:20 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
16	1m59s	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-02-23 22:05:20 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
17	1m38s	CREATE INDEX i_container_content ON public.gtp_relation USING btree (container_num_id, rel_template_num_id, content_template_num_id, content_num_id); [ Date: 2026-02-23 22:05:38 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]
18	1m30s	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 - WEBSERVICES%' 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-02-23 22:41:05 - Database: perf_minarm - User: a3d - Remote: 10.7.173.69 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	1m18s	CREATE INDEX i_gtp_obj_compo_template ON public.gtp_obj_composition USING btree (att_template_num_id); [ Date: 2026-02-23 21:54:41 - 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-02-23 22:09:06 - Database: perf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_restore ]

Time consuming queries (N)


[ User: a3d - Total duration: 1h21m19s - Times executed: 1393 ]
[ User: a3d - Total duration: 12m7s - Times executed: 3 ]
[ User: a3d - Total duration: 11m19s - Times executed: 3 ]
[ User: a3d - Total duration: 9m15s - Times executed: 18 ]
[ User: a3d - Total duration: 7m51s - Times executed: 1 ]
[ User: a3d - Total duration: 6m21s - Times executed: 5 ]
[ User: a3d - Total duration: 5m54s - Times executed: 1 ]
[ User: a3d - Total duration: 4m54s - Times executed: 4 ]
[ User: a3d - Total duration: 4m39s - Times executed: 1 ]
[ User: a3d - Total duration: 4m9s - Times executed: 1 ]
[ User: a3d - Total duration: 3m8s - Times executed: 1 ]
[ User: a3d - Total duration: 2m47s - Times executed: 7 ]
[ User: a3d - Total duration: 2m22s - Times executed: 1 ]
[ User: a3d - Total duration: 2m13s - Times executed: 1 ]
[ User: a3d - Total duration: 1m59s - Times executed: 1 ]
[ User: a3d - Total duration: 1m38s - Times executed: 1 ]
[ User: a3d - Total duration: 1m18s - Times executed: 1 ]
[ User: a3d - Total duration: 1m16s - Times executed: 1 ]
[ User: a3d - Total duration: 1m11s - Times executed: 1 ]
[ User: a3d - Total duration: 1m10s - Times executed: 1 ]

Most frequent queries (N)


[ User: a3d - Total duration: 1h21m19s - Times executed: 1393 ]
[ User: a3d - Total duration: 9m15s - Times executed: 18 ]
[ User: a3d - Total duration: 2m47s - Times executed: 7 ]
[ User: a3d - Total duration: 6m21s - Times executed: 5 ]
[ User: a3d - Total duration: 4m54s - Times executed: 4 ]
[ User: a3d - Total duration: 12m7s - Times executed: 3 ]
[ User: a3d - Total duration: 11m19s - Times executed: 3 ]
[ User: a3d - Total duration: 27s630ms - Times executed: 3 ]
[ User: a3d - Total duration: 25s339ms - Times executed: 3 ]
[ User: a3d - Total duration: 41s384ms - Times executed: 2 ]
[ User: a3d - Total duration: 16s481ms - Times executed: 2 ]
[ User: a3d - Total duration: 16s63ms - Times executed: 2 ]
[ User: a3d - Total duration: 9s521ms - Times executed: 2 ]
[ User: a3d - Total duration: 7m51s - Times executed: 1 ]
[ User: a3d - Total duration: 5m54s - Times executed: 1 ]
[ User: a3d - Total duration: 4m39s - Times executed: 1 ]
[ User: a3d - Total duration: 4m9s - Times executed: 1 ]
[ User: a3d - Total duration: 3m8s - Times executed: 1 ]
[ User: a3d - Total duration: 2m22s - Times executed: 1 ]
[ User: a3d - Total duration: 2m13s - Times executed: 1 ]

Normalized slowest queries (N)


[ User: a3d - Total duration: 7m51s - Times executed: 1 ]
[ User: a3d - Total duration: 5m54s - Times executed: 1 ]
[ User: a3d - Total duration: 4m39s - Times executed: 1 ]
[ User: a3d - Total duration: 4m9s - Times executed: 1 ]
[ User: a3d - Total duration: 12m7s - Times executed: 3 ]
[ User: a3d - Total duration: 11m19s - Times executed: 3 ]
[ User: a3d - Total duration: 3m8s - Times executed: 1 ]
[ User: a3d - Total duration: 2m22s - Times executed: 1 ]
[ User: a3d - Total duration: 2m13s - Times executed: 1 ]
[ User: a3d - Total duration: 1m59s - Times executed: 1 ]
[ User: a3d - Total duration: 1m38s - Times executed: 1 ]
[ User: a3d - Total duration: 1m18s - Times executed: 1 ]
[ User: a3d - Total duration: 6m21s - Times executed: 5 ]
[ User: a3d - Total duration: 1m16s - Times executed: 1 ]
[ User: a3d - Total duration: 4m54s - Times executed: 4 ]
[ User: a3d - Total duration: 1m11s - Times executed: 1 ]
[ User: a3d - Total duration: 1m10s - Times executed: 1 ]
[ User: a3d - Total duration: 9m15s - Times executed: 18 ]
[ User: a3d - Total duration: 2m47s - Times executed: 7 ]
[ User: a3d - Total duration: 41s384ms - Times executed: 2 ]

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

3,587 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	111	3.09%
DETAIL	1,445	40.28%
ERROR	248	6.91%
HINT	2	0.06%
LOG	1,522	42.43%
STATEMENT	248	6.91%
WARNING	11	0.31%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
248 ERROR entries
11 WARNING entries

Most Frequent Errors/Events

Key values

111 Max number of times the same event was reported
259 Total events found

Rank

Times reported

Error

1

111

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 23	07	100
	08	11

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

2

111

Details

ERROR: canceling statement due to lock timeout

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 23	07	100
	08	11

ERROR: canceling statement due to lock timeout

3

18

Details

ERROR: relation "..." already exists

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 23	22	18

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

4

11

Details

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

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 23	22	11

5

6

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 23	01	2
	07	4

ERROR: duplicate key value violates unique constraint "pk_applicative_lock"

6

1

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 23	23	1

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

7

1

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 23	23	1

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

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