pgBadger-
Global information
- Generated on Mon Oct 27 09:36:06 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=25/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=25/h=23/m=00/PT1H.log
- Parsed 28,525 log entries in 1m7s
- Log start from 2025-10-20 14:53:40 to 2025-10-25 17:01:35
-
Overview
Global Stats
- 92 Number of unique normalized queries
- 318 Number of queries
- 1h52m55s Total query duration
- 2025-10-20 06:14:09 First query
- 2025-10-25 00:00:51 Last query
- 7 queries/s at 2025-10-21 13:26:08 Query peak
- 1h52m55s Total query duration
- 12s350ms Prepare/parse total duration
- 41s283ms Bind total duration
- 1h52m1s Execute total duration
- 6,532 Number of events
- 49 Number of unique normalized events
- 6,120 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
- 1,063 Number temporary file
- 1.06 GiB Max size of temporary file
- 20.52 MiB Average size of temporary file
- 4,568 Total number of sessions
- 89 sessions at 2025-10-19 16:52:10 Session peak
- 24d2h55m41s Total duration of sessions
- 7m36s Average duration of sessions
- 0 Average queries per session
- 1s483ms Average queries duration per session
- 7m34s Average idle time per session
- 4,565 Total number of connections
- 13 connections/s at 2025-10-23 09:09:43 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2025-10-21 13:26:08 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-22 06:56:19 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2025-10-21 13:26:08 Date
Queries duration
Key values
- 1h52m55s 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) Oct 19 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 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 20 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 10 0ms 11s420ms 6s150ms 11s854ms 12s142ms 15s158ms 07 1 0ms 5s266ms 5s266ms 0ms 0ms 5s266ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 1 0ms 14s679ms 14s679ms 0ms 0ms 14s679ms 15 4 0ms 3m39s 1m14s 11s149ms 55s25ms 3m39s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 35 0ms 2m6s 21s7ms 2m6s 2m10s 2m32s 19 1 0ms 5s329ms 5s329ms 0ms 5s329ms 5s329ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 21 00 1 0ms 6s148ms 6s148ms 0ms 0ms 6s148ms 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 5 0ms 8s45ms 7s560ms 0ms 8s45ms 22s399ms 07 1 0ms 6s368ms 6s368ms 0ms 0ms 6s368ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 13 0ms 3m52s 1m25s 15s236ms 1m7s 15m52s 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 5 0ms 3m59s 58s934ms 9s14ms 33s52ms 3m59s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 35 0ms 2m18s 21s490ms 2m6s 2m18s 2m34s 19 4 0ms 5s726ms 5s286ms 5s417ms 15s727ms 15s727ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 22 00 1 0ms 5s344ms 5s344ms 5s344ms 5s344ms 5s344ms 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 22 0ms 22s38ms 9s148ms 28s217ms 40s875ms 1m2s 07 2 0ms 6s659ms 6s136ms 0ms 0ms 12s273ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 8 0ms 3m45s 39s123ms 12s494ms 15s921ms 3m45s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 34 0ms 2m11s 20s719ms 2m11s 2m13s 2m35s 19 4 0ms 6s82ms 5s797ms 0ms 23s191ms 23s191ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 23 00 1 0ms 5s488ms 5s488ms 0ms 5s488ms 5s488ms 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 26 0ms 13s803ms 7s18ms 22s507ms 25s650ms 55s773ms 07 4 0ms 9s244ms 6s912ms 0ms 9s244ms 18s405ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 1 0ms 5s415ms 5s415ms 0ms 0ms 5s415ms 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 36 0ms 2m 19s824ms 2m 2m7s 2m12s 19 4 0ms 5s941ms 5s638ms 5s14ms 17s541ms 17s541ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 24 00 1 0ms 5s686ms 5s686ms 0ms 5s686ms 5s686ms 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 8 0ms 6s679ms 5s937ms 6s679ms 11s253ms 29s570ms 07 6 0ms 20s565ms 11s229ms 5s500ms 20s565ms 35s726ms 08 1 0ms 5s48ms 5s48ms 0ms 0ms 5s48ms 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 1 0ms 6s874ms 6s874ms 0ms 0ms 6s874ms 14 4 0ms 3m43s 1m11s 7s480ms 43s186ms 3m43s 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 36 0ms 2m19s 20s269ms 1m59s 2m19s 2m31s 19 1 0ms 5s325ms 5s325ms 0ms 0ms 5s325ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 25 00 1 0ms 5s576ms 5s576ms 0ms 0ms 5s576ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 19 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 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 20 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 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 13s559ms 0ms 0ms 13s559ms 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 Oct 21 00 1 0 6s148ms 0ms 0ms 6s148ms 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 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 4 0 24s79ms 0ms 6s702ms 1m7s 14 0 0 0ms 0ms 0ms 0ms 15 2 0 6s379ms 0ms 0ms 12s758ms 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 Oct 22 00 1 0 5s344ms 0ms 5s344ms 5s344ms 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 6 0 7s978ms 0ms 6s848ms 16s260ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 5 0 8s358ms 0ms 0ms 15s921ms 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 Oct 23 00 1 0 5s488ms 0ms 0ms 5s488ms 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 5 0 7s729ms 0ms 5s276ms 21s775ms 07 3 0 7s179ms 0ms 0ms 12s293ms 08 0 0 0ms 0ms 0ms 0ms 09 1 0 5s415ms 0ms 0ms 5s415ms 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 Oct 24 00 1 0 5s686ms 0ms 0ms 5s686ms 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 2 0 13s32ms 0ms 0ms 20s565ms 08 1 0 5s48ms 0ms 0ms 5s48ms 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 1 0 6s874ms 0ms 0ms 6s874ms 14 1 0 7s480ms 0ms 0ms 7s480ms 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 Oct 25 00 1 0 5s576ms 0ms 0ms 5s576ms 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 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 19 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 20 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 1 1 0 0 6s71ms 0ms 0ms 5s975ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 1 0 14s679ms 0ms 0ms 0ms 15 0 0 1 0 55s25ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 6 29s751ms 0ms 8s333ms 48s338ms 19 1 0 0 0 5s329ms 0ms 0ms 5s329ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 21 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 1 0 8s45ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 4 2 1 0 1m49s 0ms 0ms 2m53s 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 1 0 33s52ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 6 32s186ms 0ms 0ms 59s499ms 19 2 0 0 0 5s 0ms 0ms 10s 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 22 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 3 1 0 0 7s923ms 0ms 0ms 9s211ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 1 0 34s557ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 6 30s335ms 0ms 15s566ms 50s675ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 23 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 2 1 1 0 7s843ms 0ms 0ms 7s136ms 07 1 0 0 0 6s111ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 6 30s174ms 0ms 14s243ms 1m18s 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 24 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 5s586ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 1 0 43s186ms 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 1 6 32s151ms 0ms 0ms 1m2s 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 19 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 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 20 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 10 10.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 1 1.00 0.00% 15 0 4 4.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 21 00 0 1 1.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 5 5.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 13 13.00 0.00% 14 0 0 0.00 0.00% 15 0 5 5.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 4 4.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 22 00 0 1 1.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 1 22 22.00 4.55% 07 0 2 2.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 8 8.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 4 4.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 23 00 0 1 1.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 1 26 26.00 3.85% 07 0 4 4.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.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 1 1.00 0.00% 19 0 4 4.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 24 00 0 1 1.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 8 8.00 0.00% 07 0 6 6.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.00 0.00% 14 0 4 4.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 1 1.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 25 00 0 1 1.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 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 19 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Oct 20 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 29 0.01/s 06 33 0.01/s 07 39 0.01/s 08 61 0.02/s 09 54 0.01/s 10 54 0.01/s 11 39 0.01/s 12 53 0.01/s 13 48 0.01/s 14 62 0.02/s 15 46 0.01/s 16 55 0.02/s 17 30 0.01/s 18 65 0.02/s 19 16 0.00/s 20 23 0.01/s 21 31 0.01/s 22 32 0.01/s 23 24 0.01/s Oct 21 00 42 0.01/s 01 30 0.01/s 02 27 0.01/s 03 22 0.01/s 04 23 0.01/s 05 26 0.01/s 06 43 0.01/s 07 29 0.01/s 08 26 0.01/s 09 26 0.01/s 10 42 0.01/s 11 22 0.01/s 12 17 0.00/s 13 90 0.03/s 14 67 0.02/s 15 54 0.01/s 16 30 0.01/s 17 36 0.01/s 18 59 0.02/s 19 18 0.01/s 20 17 0.00/s 21 32 0.01/s 22 32 0.01/s 23 21 0.01/s Oct 22 00 15 0.00/s 01 16 0.00/s 02 13 0.00/s 03 17 0.00/s 04 24 0.01/s 05 17 0.00/s 06 34 0.01/s 07 52 0.01/s 08 24 0.01/s 09 35 0.01/s 10 24 0.01/s 11 14 0.00/s 12 45 0.01/s 13 83 0.02/s 14 93 0.03/s 15 63 0.02/s 16 49 0.01/s 17 40 0.01/s 18 62 0.02/s 19 20 0.01/s 20 27 0.01/s 21 27 0.01/s 22 19 0.01/s 23 20 0.01/s Oct 23 00 34 0.01/s 01 14 0.00/s 02 23 0.01/s 03 33 0.01/s 04 30 0.01/s 05 19 0.01/s 06 34 0.01/s 07 55 0.02/s 08 38 0.01/s 09 47 0.01/s 10 34 0.01/s 11 38 0.01/s 12 26 0.01/s 13 26 0.01/s 14 48 0.01/s 15 28 0.01/s 16 14 0.00/s 17 29 0.01/s 18 63 0.02/s 19 17 0.00/s 20 16 0.00/s 21 30 0.01/s 22 24 0.01/s 23 32 0.01/s Oct 24 00 23 0.01/s 01 15 0.00/s 02 23 0.01/s 03 28 0.01/s 04 20 0.01/s 05 42 0.01/s 06 32 0.01/s 07 39 0.01/s 08 38 0.01/s 09 38 0.01/s 10 59 0.02/s 11 34 0.01/s 12 76 0.02/s 13 73 0.02/s 14 37 0.01/s 15 119 0.03/s 16 39 0.01/s 17 33 0.01/s 18 61 0.02/s 19 24 0.01/s 20 28 0.01/s 21 17 0.00/s 22 13 0.00/s 23 19 0.01/s Oct 25 00 32 0.01/s 01 17 0.00/s 02 18 0.01/s 03 23 0.01/s 04 14 0.00/s 05 27 0.01/s 06 20 0.01/s 07 19 0.01/s 08 19 0.01/s 09 16 0.00/s 10 16 0.00/s 11 14 0.00/s 12 19 0.01/s 13 17 0.00/s 14 22 0.01/s 15 12 0.00/s 16 19 0.01/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Oct 19 00 3 74ms 74ms 01 3 76ms 76ms 02 3 71ms 71ms 03 3 72ms 72ms 04 3 71ms 71ms 05 3 77ms 77ms 06 3 76ms 76ms 07 3 74ms 74ms 08 3 87ms 87ms 09 3 79ms 79ms 10 3 81ms 81ms 11 3 74ms 74ms 12 3 77ms 77ms 13 3 76ms 76ms 14 3 74ms 74ms 15 3 82ms 82ms 16 3 75ms 75ms 17 3 72ms 72ms 18 3 92ms 92ms 19 3 75ms 75ms 20 3 73ms 73ms 21 3 76ms 76ms 22 3 74ms 74ms 23 3 70ms 70ms Oct 20 00 3 73ms 73ms 01 3 82ms 82ms 02 3 71ms 71ms 03 3 71ms 71ms 04 3 71ms 71ms 05 26 1m53s 1m53s 06 31 2m59s 2m58s 07 41 3m3s 3m3s 08 59 1m32s 1m32s 09 57 1m45s 1m45s 10 51 1m49s 1m49s 11 41 1m52s 1m52s 12 51 1m48s 1m48s 13 51 1m43s 1m43s 14 58 2m45s 2m45s 15 49 2m58s 2m51s 16 55 1m49s 1m49s 17 31 46m11s 46m11s 18 64 3m7s 2m55s 19 14 6m15s 6m14s 20 25 2m47s 2m47s 21 31 3m12s 3m12s 22 32 3m13s 3m13s 23 22 3m48s 3m48s Oct 21 00 44 2m18s 2m18s 01 30 3m5s 3m5s 02 27 3m13s 3m13s 03 22 3m22s 3m22s 04 23 2m47s 2m47s 05 26 3m4s 3m4s 06 43 3m18s 3m17s 07 29 2m53s 2m53s 08 26 3m39s 3m39s 09 25 2m1s 2m1s 10 40 2m38s 2m38s 11 22 2m37s 2m37s 12 17 6m9s 6m9s 13 90 26m49s 26m37s 14 69 9m36s 9m36s 15 55 8m15s 8m9s 16 30 2m55s 2m55s 17 36 13m56s 13m56s 18 59 3m23s 3m10s 19 18 3m13s 3m12s 20 17 6m37s 6m37s 21 30 3m13s 3m13s 22 33 2m51s 2m51s 23 24 28m35s 28m35s Oct 22 00 13 1m4s 1m4s 01 16 1m9s 1m9s 02 13 1m7s 1m7s 03 15 1m10s 1m10s 04 23 1m13s 1m13s 05 20 1m11s 1m11s 06 30 1m9s 1m2s 07 53 1m33s 1m33s 08 23 1m19s 1m19s 09 36 1m13s 1m13s 10 27 26m20s 26m20s 11 14 1m7s 1m7s 12 38 1m11s 1m11s 13 85 11m53s 11m53s 14 97 6m 6m 15 63 2m41s 2m36s 16 51 2m3s 2m3s 17 39 53m49s 53m49s 18 62 3m36s 3m24s 19 20 4m33s 4m32s 20 25 3m24s 3m24s 21 27 3m9s 3m9s 22 17 3m29s 3m29s 23 24 4m14s 4m14s Oct 23 00 32 3m6s 3m5s 01 16 1m40s 1m40s 02 23 5m32s 5m32s 03 33 3m1s 3m1s 04 30 2m48s 2m48s 05 19 3m6s 3m6s 06 31 3m45s 3m39s 07 50 1m58s 1m58s 08 43 6m6s 6m6s 09 48 3m44s 3m44s 10 30 4m12s 4m12s 11 38 9m37s 9m37s 12 27 6m35s 6m35s 13 25 5m21s 5m21s 14 48 2m 2m 15 35 1h4m2s 1h4m2s 16 14 4m43s 4m43s 17 28 1h37m55s 1h37m55s 18 64 3m7s 2m56s 19 17 5m25s 5m24s 20 16 3m2s 3m2s 21 30 3m30s 3m30s 22 24 2m28s 2m28s 23 32 4m12s 4m12s Oct 24 00 23 2m57s 2m57s 01 15 1m13s 1m13s 02 23 6m36s 6m36s 03 28 2m49s 2m49s 04 20 3m44s 3m44s 05 42 2m36s 2m36s 06 32 2m27s 2m26s 07 38 3m20s 3m18s 08 35 3m14s 3m14s 09 38 2m3s 2m3s 10 57 2m22s 2m22s 11 35 6m58s 6m58s 12 75 2m6s 2m6s 13 76 17m42s 17m42s 14 39 4m28s 4m21s 15 119 29m28s 29m28s 16 42 3m2s 3m2s 17 33 8m31s 8m31s 18 61 3m15s 3m3s 19 24 3m55s 3m55s 20 28 3m15s 3m15s 21 17 2m7s 2m7s 22 13 6m44s 6m44s 23 19 5m5s 5m5s Oct 25 00 29 2m53s 2m53s 01 20 4m2s 4m2s 02 18 5m26s 5m26s 03 21 3m39s 3m39s 04 15 5m5s 5m5s 05 27 3m9s 3m9s 06 19 4m12s 4m12s 07 20 3m39s 3m39s 08 19 4m17s 4m17s 09 17 4m35s 4m35s 10 16 4m11s 4m11s 11 14 5m43s 5m43s 12 19 3m40s 3m40s 13 17 4m29s 4m29s 14 22 2m15s 2m15s 15 12 8m49s 8m49s 16 19 4m36s 4m36s 17 5 8h53m40s 8h53m40s 18 2 83ms 83ms 19 2 78ms 78ms 20 2 95ms 95ms 21 2 79ms 79ms 22 2 72ms 72ms 23 2 77ms 77ms -
Connections
Established Connections
Key values
- 13 connections Connection Peak
- 2025-10-23 09:09:43 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 4,565 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,565 connections Total
-
Sessions
Simultaneous sessions
Key values
- 89 sessions Session Peak
- 2025-10-19 16:52:10 Date
Histogram of session times
Key values
- 3,514 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 4,568 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,568 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,568 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 4,568 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 4 21h51m17s 5h27m49s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 4 21h50m 5h27m30s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 4 17h49m12s 4h27m18s IntelliJ IDEA 2024.3.5 13 1d3h57m26s 2h9m2s PostgreSQL JDBC Driver 4,015 20d6h34m18s 7m16s [unknown] 483 1m 126ms pg_restore 20 2h41m25s 8m4s psql 25 10m58s 26s326ms -
Temporary Files
Size of temporary files
Key values
- 395.63 MiB Temp Files size Peak
- 2025-10-22 18:38:35 Date
Number of temporary files
Key values
- 8 per second Temp Files Peak
- 2025-10-24 18:37:28 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 19 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 1 4.19 MiB 4.19 MiB 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 1 4.19 MiB 4.19 MiB 15 25 106.88 MiB 4.28 MiB 16 0 0 0 17 0 0 0 18 175 3.99 GiB 23.33 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 21 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 26 111.09 MiB 4.27 MiB 14 2 8.38 MiB 4.19 MiB 15 25 106.92 MiB 4.28 MiB 16 0 0 0 17 0 0 0 18 186 4.26 GiB 23.44 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 22 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 1 4.19 MiB 4.19 MiB 13 2 8.38 MiB 4.19 MiB 14 3 12.56 MiB 4.19 MiB 15 27 113.35 MiB 4.20 MiB 16 0 0 0 17 0 0 0 18 181 4.09 GiB 23.14 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 23 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 1 4.19 MiB 4.19 MiB 08 1 4.19 MiB 4.19 MiB 09 1 4.19 MiB 4.19 MiB 10 2 8.38 MiB 4.19 MiB 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 186 4.25 GiB 23.42 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 24 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 1 4.19 MiB 4.19 MiB 11 0 0 0 12 2 8.38 MiB 4.19 MiB 13 4 13.54 MiB 3.39 MiB 14 23 101.69 MiB 4.42 MiB 15 6 25.12 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 181 4.08 GiB 23.06 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 17 155.50 MiB 2.48 MiB 31.12 MiB 9.15 MiB select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021523', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021523', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-10-22 15:23:09 Duration: 8s86ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021408', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021408', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-10-24 14:08:43 Duration: 7s480ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021328', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021328', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-10-21 13:28:25 Duration: 7s80ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 15 537.48 MiB 8.41 MiB 89.75 MiB 35.83 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-10-24 18:37:08 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 15 2.33 GiB 12.14 MiB 529.29 MiB 159.06 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-10-24 18:35:53 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 15 242.62 MiB 3.12 MiB 47.60 MiB 16.17 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-10-24 18:37:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 15 339.46 MiB 3.66 MiB 60.52 MiB 22.63 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2025-10-24 18:37:20 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 15 65.73 MiB 2.45 MiB 5.93 MiB 4.38 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-10-24 18:37:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 15 597.23 MiB 21.94 MiB 171.40 MiB 39.82 MiB 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);-
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-10-24 18:36:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 15 1.79 GiB 17.51 MiB 487.73 MiB 122.28 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-24 18:34:56 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 15 2.39 GiB 35.29 MiB 693.23 MiB 163.40 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-24 18:32:18 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 15 4.22 GiB 109.64 MiB 1.06 GiB 288.18 MiB 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);-
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-10-24 18:33:08 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 15 1.07 GiB 50.94 MiB 256.42 MiB 73.07 MiB 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);-
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-10-24 18:35:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 15 394.09 MiB 17.62 MiB 34.77 MiB 26.27 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-10-24 18:37:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 13 1.30 GiB 29.65 MiB 310.89 MiB 102.08 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-24 18:34:46 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 12 216.16 MiB 3.96 MiB 47.93 MiB 18.01 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-10-24 18:33:55 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 12 99.34 MiB 3.23 MiB 46.03 MiB 8.28 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-10-24 18:37:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 11 139.82 MiB 1.95 MiB 41.16 MiB 12.71 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2025-10-24 18:33:52 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 9 60.74 MiB 1.95 MiB 12.49 MiB 6.75 MiB add constraint pk_pe_consumption_hourly primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_hourly PRIMARY KEY (consumption_num_id);
Date: 2025-10-24 18:37:36 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 7 1.75 GiB 2.02 MiB 1.01 GiB 256.65 MiB add constraint pk_l_notification_user primary key (nous_user_num_id, nous_noti_id);-
ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);
Date: 2025-10-24 18:31:32 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 6 23.57 MiB 2.48 MiB 5.39 MiB 3.93 MiB select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = ? and ceahp1_0.alert_type_a3d_id = ? and ceahp1_1.obj_template_a3d_id = ? and ceahp1_1.obj_num_id = ? order by ceahp1_1.history_date desc;-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = $1 and ceahp1_0.ALERT_TYPE_A3D_ID = $2 and ceahp1_1.OBJ_TEMPLATE_A3D_ID = $3 and ceahp1_1.OBJ_NUM_ID = $4 order by ceahp1_1.HISTORY_DATE desc;
Date: 2025-10-22 15:23:25 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
20 4 1.05 GiB 8.73 MiB 1.01 GiB 268.41 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-10-24 18:37:46 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 2 6.18 MiB 2.56 MiB 3.62 MiB 3.09 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 15:34:59 Duration: 3m59s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 13:26:08 Duration: 3m52s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-22 15:21:13 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
22 1 431.73 MiB 431.73 MiB 431.73 MiB 431.73 MiB add constraint fk_uml_relation_ua_id foreign key (ur_ua_id) references public.uml_attribute (ua_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_uml_relation_ua_id FOREIGN KEY (ur_ua_id) REFERENCES public.uml_attribute (ua_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:37:45 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 1.00 GiB 1.00 GiB 1.00 GiB 1.00 GiB add constraint fk_gtp_relation_content_templ foreign key (content_template_num_id) references public.gtp_obj_template (obj_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_relation_content_templ FOREIGN KEY (content_template_num_id) REFERENCES public.gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-23 18:31:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.06 GiB 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-10-22 18:36:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.01 GiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-10-20 18:31:14 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1.01 GiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-10-24 18:31:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1.00 GiB ADD CONSTRAINT fk_gtp_relation_content_templ FOREIGN KEY (content_template_num_id) REFERENCES public.gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-23 18:31:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 693.23 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-21 18:31:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 670.24 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-10-21 18:32:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 529.29 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-24 18:35:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 528.30 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-23 18:36:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 528.27 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-21 18:36:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 506.62 MiB 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-10-20 18:32:58 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 506.62 MiB 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-10-21 18:33:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 505.59 MiB 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-10-24 18:33:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 487.73 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-23 18:34:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 473.39 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-22 18:40:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 471.40 MiB 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-10-23 18:33:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 431.73 MiB ADD CONSTRAINT fk_uml_relation_ua_id FOREIGN KEY (ur_ua_id) REFERENCES public.uml_attribute (ua_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-22 18:37:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 398.77 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-24 18:34:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 347.54 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-20 18:32:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 346.28 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-21 18:35:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 337.59 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-23 18:32:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
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 Oct 19 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 Oct 20 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 Oct 21 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 Oct 22 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 Oct 23 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 Oct 24 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 Oct 25 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
- ShareLock Main Lock Type
- 20 locks Total
Type Object Count Total Duration Average Duration (s) AccessShareLock 2 5s135ms 2s567ms relation 2 5s135ms 2s567ms ExclusiveLock 4 34s355ms 8s588ms extension 3 3s177ms 1s59ms tuple 1 31s178ms 31s178ms ShareLock 10 11m34s 1m9s relation 5 5s444ms 1s88ms transaction 5 11m28s 2m17s ShareRowExclusiveLock 2 2s269ms 1s134ms relation 2 2s269ms 1s134ms ShareUpdateExclusiveLock 2 2s2ms 1s1ms relation 2 2s2ms 1s1ms Total 20 12m17s 36s898ms 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
- 37 Total read queries
- 266 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 318 Requests
- 1h52m1s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 319 Requests
User Request type Count Duration a3dsupervisor Total 319 1h52m6s copy from 30 16m40s ddl 135 31m30s delete 13 5m20s insert 15 10m23s others 15 30m52s select 38 5m57s tcl 68 8m8s update 5 3m13s Duration by user
Key values
- 1h52m6s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 319 1h52m6s copy from 30 16m40s ddl 135 31m30s delete 13 5m20s insert 15 10m23s others 15 30m52s select 38 5m57s tcl 68 8m8s update 5 3m13s Queries by host
Key values
- 10.3.0.4 Main host
- 319 Requests
- 1h52m6s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 166 Requests
- 52m47s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-20 22:36:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 160 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m59s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-21 15:34:59 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 3m52s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-21 13:26:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 3m45s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-22 15:21:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 3m43s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-24 14:05:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 3m39s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-20 15:17:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 3m34s insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);[ Date: 2025-10-21 13:26:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 2m52s insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);[ Date: 2025-10-21 13:26:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 2m22s update A3D_USER set ANONYMIZED =, USER_CIVILITY =, CREATION_DATE =, USER_NUM_ID_CREATOR =, USER_FIRSTNAME =, LAST_CONNECTION_DATE =, USER_NAME =, MODIFICATION_DATE =, MODIFIER_NUM_ID =, POLICY_VERSION =, OBJ_NUM_ID =, USER_ADDRESS =, USER_AUTHENTICATION =, USER_CITY =, USER_COUNTRY =, USER_DELETED =, USER_FAX =, COMPANY_NUM_ID =, USER_GUID =, USER_LOGIN =, USER_MAIL =, USER_CELULAR =, USER_PASSWORD =, USER_PHONE =, USER_POSTAL_CODE =, USER_BOK = where USER_NUM_ID =;[ Date: 2025-10-21 13:26:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 2m19s VACUUM ANALYSE;[ Date: 2025-10-24 18:49:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 2m18s VACUUM ANALYSE;[ Date: 2025-10-21 18:49:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 2m11s VACUUM ANALYSE;[ Date: 2025-10-22 18:53:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 2m6s VACUUM ANALYSE;[ Date: 2025-10-20 18:48:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 2m VACUUM ANALYSE;[ Date: 2025-10-23 18:48:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 1m40s insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);[ Date: 2025-10-21 13:26:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 1m20s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-10-20 18:31:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 1m19s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-10-24 18:31:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 1m18s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-10-21 18:31:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 1m18s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-10-23 18:31:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 1m15s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-10-22 18:36:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 1m7s SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;[ Date: 2025-10-21 13:18:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 19m1s 5 3m39s 3m59s 3m48s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 20 17 1 3m39s 3m39s Oct 21 15 1 3m52s 3m52s 17 1 3m59s 3m59s Oct 22 17 1 3m45s 3m45s Oct 24 16 1 3m43s 3m43s [ User: a3dsupervisor - Total duration: 19m1s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 19m1s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 15:34:59 Duration: 3m59s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 13:26:08 Duration: 3m52s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-22 15:21:13 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 10m56s 5 2m 2m19s 2m11s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 20 20 1 2m6s 2m6s Oct 21 20 1 2m18s 2m18s Oct 22 20 1 2m11s 2m11s Oct 23 20 1 2m 2m Oct 24 20 1 2m19s 2m19s [ User: a3dsupervisor - Total duration: 10m56s - Times executed: 5 ]
[ Application: psql - Total duration: 10m56s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-24 18:49:12 Duration: 2m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-21 18:49:31 Duration: 2m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-22 18:53:24 Duration: 2m11s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 9m6s 4 58s14ms 3m34s 2m16s insert into batch_scenario_run (creation_date, creator_num_id, end_date, modification_date, modifier_num_id, batch_scenario_num_id, start_date, state, status, batch_scenario_run_id) values (,,,,,,,,,);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 21 15 4 9m6s 2m16s [ User: a3dsupervisor - Total duration: 9m6s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9m6s - Times executed: 4 ]
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-21 13:26:08 Duration: 3m34s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-21 13:26:08 Duration: 2m52s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-21 13:26:08 Duration: 1m40s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 8m8s 68 5s14ms 22s38ms 7s185ms commit;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 20 08 8 49s364ms 6s170ms 09 1 5s266ms 5s266ms Oct 21 08 4 29s757ms 7s439ms 09 1 6s368ms 6s368ms 21 2 11s143ms 5s571ms Oct 22 08 12 2m1s 10s142ms 09 2 12s273ms 6s136ms 21 4 23s191ms 5s797ms Oct 23 08 17 1m52s 6s615ms 21 4 22s555ms 5s638ms Oct 24 08 8 47s503ms 5s937ms 09 3 35s726ms 11s908ms 20 1 5s984ms 5s984ms 21 1 5s325ms 5s325ms [ User: a3dsupervisor - Total duration: 8m8s - Times executed: 68 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m2s - Times executed: 67 ]
[ Application: pg_restore - Total duration: 5s984ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s38ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:41 Duration: 14s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-23 06:59:16 Duration: 13s803ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 6m31s 5 1m15s 1m20s 1m18s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 20 20 1 1m20s 1m20s Oct 21 20 1 1m18s 1m18s Oct 22 20 1 1m15s 1m15s Oct 23 20 1 1m18s 1m18s Oct 24 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 6m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m31s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-20 18:31:34 Duration: 1m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-24 18:31:52 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-21 18:31:53 Duration: 1m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 5m7s 11 12s710ms 55s25ms 27s943ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 20 16 1 14s679ms 14s679ms 17 1 55s25ms 55s25ms 20 1 17s1ms 17s1ms Oct 21 15 1 45s520ms 45s520ms 17 1 33s52ms 33s52ms 20 1 17s282ms 17s282ms Oct 22 17 1 34s557ms 34s557ms 20 1 16s910ms 16s910ms Oct 23 20 1 17s449ms 17s449ms Oct 24 16 1 43s186ms 43s186ms 20 1 12s710ms 12s710ms [ User: a3dsupervisor - Total duration: 5m7s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m7s - Times executed: 11 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-20 15:25:31 Duration: 55s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 13:31:52 Duration: 45s520ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-24 14:12:33 Duration: 43s186ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 2m58s 5 35s231ms 36s80ms 35s645ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 20 20 1 35s231ms 35s231ms Oct 21 20 1 36s80ms 36s80ms Oct 22 20 1 35s932ms 35s932ms Oct 23 20 1 35s397ms 35s397ms Oct 24 20 1 35s583ms 35s583ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-21 18:31:10 Duration: 36s80ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-22 18:35:46 Duration: 35s932ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-24 18:31:08 Duration: 35s583ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 2m53s 2 31s206ms 2m22s 1m26s update a3d_user set anonymized =, user_civility =, creation_date =, user_num_id_creator =, user_firstname =, last_connection_date =, user_name =, modification_date =, modifier_num_id =, policy_version =, obj_num_id =, user_address =, user_authentication =, user_city =, user_country =, user_deleted =, user_fax =, company_num_id =, user_guid =, user_login =, user_mail =, user_celular =, user_password =, user_phone =, user_postal_code =, user_bok = where user_num_id =;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 21 15 2 2m53s 1m26s [ User: a3dsupervisor - Total duration: 2m53s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m53s - Times executed: 2 ]
-
update A3D_USER set ANONYMIZED =, USER_CIVILITY =, CREATION_DATE =, USER_NUM_ID_CREATOR =, USER_FIRSTNAME =, LAST_CONNECTION_DATE =, USER_NAME =, MODIFICATION_DATE =, MODIFIER_NUM_ID =, POLICY_VERSION =, OBJ_NUM_ID =, USER_ADDRESS =, USER_AUTHENTICATION =, USER_CITY =, USER_COUNTRY =, USER_DELETED =, USER_FAX =, COMPANY_NUM_ID =, USER_GUID =, USER_LOGIN =, USER_MAIL =, USER_CELULAR =, USER_PASSWORD =, USER_PHONE =, USER_POSTAL_CODE =, USER_BOK = where USER_NUM_ID =;
Date: 2025-10-21 13:26:08 Duration: 2m22s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
update A3D_USER set ANONYMIZED =, USER_CIVILITY =, CREATION_DATE =, USER_NUM_ID_CREATOR =, USER_FIRSTNAME =, LAST_CONNECTION_DATE =, USER_NAME =, MODIFICATION_DATE =, MODIFIER_NUM_ID =, POLICY_VERSION =, OBJ_NUM_ID =, USER_ADDRESS =, USER_AUTHENTICATION =, USER_CITY =, USER_COUNTRY =, USER_DELETED =, USER_FAX =, COMPANY_NUM_ID =, USER_GUID =, USER_LOGIN =, USER_MAIL =, USER_CELULAR =, USER_PASSWORD =, USER_PHONE =, USER_POSTAL_CODE =, USER_BOK = where USER_NUM_ID =;
Date: 2025-10-21 13:26:08 Duration: 31s206ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 2m44s 5 30s486ms 37s277ms 32s991ms alter table only public.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 #9
Day Hour Count Duration Avg duration Oct 20 20 1 30s888ms 30s888ms Oct 21 20 1 37s277ms 37s277ms Oct 22 20 1 33s579ms 33s579ms Oct 23 20 1 32s726ms 32s726ms Oct 24 20 1 30s486ms 30s486ms [ User: a3dsupervisor - Total duration: 2m44s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m44s - Times executed: 5 ]
-
ALTER TABLE ONLY public.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-10-21 18:34:10 Duration: 37s277ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-22 18:38:35 Duration: 33s579ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-23 18:33:45 Duration: 32s726ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2m38s 5 29s478ms 34s203ms 31s691ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 20 20 1 29s902ms 29s902ms Oct 21 20 1 34s203ms 34s203ms Oct 22 20 1 29s478ms 29s478ms Oct 23 20 1 31s805ms 31s805ms Oct 24 20 1 33s64ms 33s64ms [ User: a3dsupervisor - Total duration: 2m38s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m38s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-21 18:35:14 Duration: 34s203ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-24 18:34:47 Duration: 33s64ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-23 18:34:46 Duration: 31s805ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2m23s 5 24s347ms 35s438ms 28s636ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 20 20 1 31s441ms 31s441ms Oct 21 20 1 24s347ms 24s347ms Oct 22 20 1 26s140ms 26s140ms Oct 23 20 1 35s438ms 35s438ms Oct 24 20 1 25s814ms 25s814ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-23 18:32:17 Duration: 35s438ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-20 18:32:05 Duration: 31s441ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-22 18:36:51 Duration: 26s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 2m20s 5 25s49ms 31s598ms 28s146ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 20 20 1 31s598ms 31s598ms Oct 21 20 1 28s836ms 28s836ms Oct 22 20 1 29s190ms 29s190ms Oct 23 20 1 25s49ms 25s49ms Oct 24 20 1 26s59ms 26s59ms [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-20 18:32:11 Duration: 31s598ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-22 18:37:10 Duration: 29s190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-21 18:32:37 Duration: 28s836ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2m6s 5 23s176ms 27s153ms 25s377ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 20 20 1 24s934ms 24s934ms Oct 21 20 1 26s636ms 26s636ms Oct 22 20 1 24s987ms 24s987ms Oct 23 20 1 27s153ms 27s153ms Oct 24 20 1 23s176ms 23s176ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m6s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-23 18:31:26 Duration: 27s153ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-21 18:31:37 Duration: 26s636ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-22 18:36:11 Duration: 24s987ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1m58s 5 18s435ms 29s812ms 23s726ms 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;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 20 20 1 18s435ms 18s435ms Oct 21 20 1 25s295ms 25s295ms Oct 22 20 1 21s196ms 21s196ms Oct 23 20 1 23s891ms 23s891ms Oct 24 20 1 29s812ms 29s812ms [ User: a3dsupervisor - Total duration: 1m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m58s - Times executed: 5 ]
-
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: 2025-10-24 18:34:40 Duration: 29s812ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-21 18:35:02 Duration: 25s295ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-23 18:34:36 Duration: 23s891ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1m39s 5 14s596ms 24s525ms 19s966ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 20 20 1 16s427ms 16s427ms Oct 21 20 1 23s630ms 23s630ms Oct 22 20 1 24s525ms 24s525ms Oct 23 20 1 20s652ms 20s652ms Oct 24 20 1 14s596ms 14s596ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:37:50 Duration: 24s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-21 18:33:15 Duration: 23s630ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-23 18:32:54 Duration: 20s652ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1m39s 5 12s746ms 25s153ms 19s947ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 20 20 1 25s153ms 25s153ms Oct 21 20 1 21s516ms 21s516ms Oct 22 20 1 18s698ms 18s698ms Oct 23 20 1 12s746ms 12s746ms Oct 24 20 1 21s621ms 21s621ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-20 18:32:59 Duration: 25s153ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-24 18:33:11 Duration: 21s621ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-21 18:33:20 Duration: 21s516ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1m33s 5 14s861ms 21s286ms 18s711ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 20 20 1 19s538ms 19s538ms Oct 21 20 1 21s286ms 21s286ms Oct 22 20 1 16s677ms 16s677ms Oct 23 20 1 21s192ms 21s192ms Oct 24 20 1 14s861ms 14s861ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m33s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-21 18:32:58 Duration: 21s286ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-23 18:32:49 Duration: 21s192ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-20 18:32:34 Duration: 19s538ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1m23s 5 13s918ms 18s208ms 16s782ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 20 20 1 17s322ms 17s322ms Oct 21 20 1 16s985ms 16s985ms Oct 22 20 1 17s475ms 17s475ms Oct 23 20 1 18s208ms 18s208ms Oct 24 20 1 13s918ms 13s918ms [ User: a3dsupervisor - Total duration: 1m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m23s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-23 18:34:03 Duration: 18s208ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:38:54 Duration: 17s475ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-20 18:33:57 Duration: 17s322ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1m22s 5 14s243ms 19s323ms 16s524ms 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;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 20 20 1 19s323ms 19s323ms Oct 21 20 1 17s413ms 17s413ms Oct 22 20 1 15s566ms 15s566ms Oct 23 20 1 14s243ms 14s243ms Oct 24 20 1 16s74ms 16s74ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 5 ]
-
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: 2025-10-20 18:32:31 Duration: 19s323ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-21 18:32:51 Duration: 17s413ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-24 18:32:47 Duration: 16s74ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1m19s 5 11s712ms 24s571ms 15s805ms alter table only public.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 #20
Day Hour Count Duration Avg duration Oct 20 20 1 24s571ms 24s571ms Oct 21 20 1 12s271ms 12s271ms Oct 22 20 1 13s152ms 13s152ms Oct 23 20 1 17s319ms 17s319ms Oct 24 20 1 11s712ms 11s712ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 5 ]
-
ALTER TABLE ONLY public.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-10-20 18:35:45 Duration: 24s571ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-23 18:35:49 Duration: 17s319ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-22 18:40:24 Duration: 13s152ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 68 8m8s 5s14ms 22s38ms 7s185ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 20 08 8 49s364ms 6s170ms 09 1 5s266ms 5s266ms Oct 21 08 4 29s757ms 7s439ms 09 1 6s368ms 6s368ms 21 2 11s143ms 5s571ms Oct 22 08 12 2m1s 10s142ms 09 2 12s273ms 6s136ms 21 4 23s191ms 5s797ms Oct 23 08 17 1m52s 6s615ms 21 4 22s555ms 5s638ms Oct 24 08 8 47s503ms 5s937ms 09 3 35s726ms 11s908ms 20 1 5s984ms 5s984ms 21 1 5s325ms 5s325ms [ User: a3dsupervisor - Total duration: 8m8s - Times executed: 68 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m2s - Times executed: 67 ]
[ Application: pg_restore - Total duration: 5s984ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s38ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:41 Duration: 14s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-23 06:59:16 Duration: 13s803ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 11 5m7s 12s710ms 55s25ms 27s943ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 20 16 1 14s679ms 14s679ms 17 1 55s25ms 55s25ms 20 1 17s1ms 17s1ms Oct 21 15 1 45s520ms 45s520ms 17 1 33s52ms 33s52ms 20 1 17s282ms 17s282ms Oct 22 17 1 34s557ms 34s557ms 20 1 16s910ms 16s910ms Oct 23 20 1 17s449ms 17s449ms Oct 24 16 1 43s186ms 43s186ms 20 1 12s710ms 12s710ms [ User: a3dsupervisor - Total duration: 5m7s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m7s - Times executed: 11 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-20 15:25:31 Duration: 55s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 13:31:52 Duration: 45s520ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-24 14:12:33 Duration: 43s186ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 10 1m11s 5s 13s59ms 7s141ms 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 #3
Day Hour Count Duration Avg duration Oct 20 08 1 6s167ms 6s167ms 21 1 5s329ms 5s329ms Oct 21 21 2 10s 5s Oct 22 08 3 24s846ms 8s282ms Oct 23 08 2 18s957ms 9s478ms 09 1 6s111ms 6s111ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 10 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m11s - Times executed: 10 ]
-
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-10-23 06:59:16 Duration: 13s59ms Database: autotest_feat_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-10-22 06:57:14 Duration: 9s382ms Database: autotest_feat_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-10-22 06:49:03 Duration: 9s211ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 7 50s163ms 5s276ms 12s922ms 7s166ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 22 08 3 20s206ms 6s735ms Oct 23 08 3 23s949ms 7s983ms 09 1 6s6ms 6s6ms [ User: a3dsupervisor - Total duration: 50s163ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 50s163ms - Times executed: 7 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-10-23 06:59:16 Duration: 12s922ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-10-22 06:49:03 Duration: 7s514ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-10-22 06:57:14 Duration: 6s848ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 5 19m1s 3m39s 3m59s 3m48s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 20 17 1 3m39s 3m39s Oct 21 15 1 3m52s 3m52s 17 1 3m59s 3m59s Oct 22 17 1 3m45s 3m45s Oct 24 16 1 3m43s 3m43s [ User: a3dsupervisor - Total duration: 19m1s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 19m1s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 15:34:59 Duration: 3m59s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 13:26:08 Duration: 3m52s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-22 15:21:13 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 5 10m56s 2m 2m19s 2m11s vacuum analyse;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 20 20 1 2m6s 2m6s Oct 21 20 1 2m18s 2m18s Oct 22 20 1 2m11s 2m11s Oct 23 20 1 2m 2m Oct 24 20 1 2m19s 2m19s [ User: a3dsupervisor - Total duration: 10m56s - Times executed: 5 ]
[ Application: psql - Total duration: 10m56s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-24 18:49:12 Duration: 2m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-21 18:49:31 Duration: 2m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-22 18:53:24 Duration: 2m11s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 5 6m31s 1m15s 1m20s 1m18s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 20 20 1 1m20s 1m20s Oct 21 20 1 1m18s 1m18s Oct 22 20 1 1m15s 1m15s Oct 23 20 1 1m18s 1m18s Oct 24 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 6m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m31s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-20 18:31:34 Duration: 1m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-24 18:31:52 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-21 18:31:53 Duration: 1m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5 2m58s 35s231ms 36s80ms 35s645ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 20 20 1 35s231ms 35s231ms Oct 21 20 1 36s80ms 36s80ms Oct 22 20 1 35s932ms 35s932ms Oct 23 20 1 35s397ms 35s397ms Oct 24 20 1 35s583ms 35s583ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-21 18:31:10 Duration: 36s80ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-22 18:35:46 Duration: 35s932ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-24 18:31:08 Duration: 35s583ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5 2m44s 30s486ms 37s277ms 32s991ms alter table only public.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 #9
Day Hour Count Duration Avg duration Oct 20 20 1 30s888ms 30s888ms Oct 21 20 1 37s277ms 37s277ms Oct 22 20 1 33s579ms 33s579ms Oct 23 20 1 32s726ms 32s726ms Oct 24 20 1 30s486ms 30s486ms [ User: a3dsupervisor - Total duration: 2m44s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m44s - Times executed: 5 ]
-
ALTER TABLE ONLY public.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-10-21 18:34:10 Duration: 37s277ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-22 18:38:35 Duration: 33s579ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-23 18:33:45 Duration: 32s726ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5 2m38s 29s478ms 34s203ms 31s691ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 20 20 1 29s902ms 29s902ms Oct 21 20 1 34s203ms 34s203ms Oct 22 20 1 29s478ms 29s478ms Oct 23 20 1 31s805ms 31s805ms Oct 24 20 1 33s64ms 33s64ms [ User: a3dsupervisor - Total duration: 2m38s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m38s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-21 18:35:14 Duration: 34s203ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-24 18:34:47 Duration: 33s64ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-23 18:34:46 Duration: 31s805ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5 2m23s 24s347ms 35s438ms 28s636ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 20 20 1 31s441ms 31s441ms Oct 21 20 1 24s347ms 24s347ms Oct 22 20 1 26s140ms 26s140ms Oct 23 20 1 35s438ms 35s438ms Oct 24 20 1 25s814ms 25s814ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-23 18:32:17 Duration: 35s438ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-20 18:32:05 Duration: 31s441ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-22 18:36:51 Duration: 26s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 2m20s 25s49ms 31s598ms 28s146ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 20 20 1 31s598ms 31s598ms Oct 21 20 1 28s836ms 28s836ms Oct 22 20 1 29s190ms 29s190ms Oct 23 20 1 25s49ms 25s49ms Oct 24 20 1 26s59ms 26s59ms [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-20 18:32:11 Duration: 31s598ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-22 18:37:10 Duration: 29s190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-21 18:32:37 Duration: 28s836ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 2m6s 23s176ms 27s153ms 25s377ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 20 20 1 24s934ms 24s934ms Oct 21 20 1 26s636ms 26s636ms Oct 22 20 1 24s987ms 24s987ms Oct 23 20 1 27s153ms 27s153ms Oct 24 20 1 23s176ms 23s176ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m6s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-23 18:31:26 Duration: 27s153ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-21 18:31:37 Duration: 26s636ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-22 18:36:11 Duration: 24s987ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 1m58s 18s435ms 29s812ms 23s726ms 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;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 20 20 1 18s435ms 18s435ms Oct 21 20 1 25s295ms 25s295ms Oct 22 20 1 21s196ms 21s196ms Oct 23 20 1 23s891ms 23s891ms Oct 24 20 1 29s812ms 29s812ms [ User: a3dsupervisor - Total duration: 1m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m58s - Times executed: 5 ]
-
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: 2025-10-24 18:34:40 Duration: 29s812ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-21 18:35:02 Duration: 25s295ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-23 18:34:36 Duration: 23s891ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 1m39s 14s596ms 24s525ms 19s966ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 20 20 1 16s427ms 16s427ms Oct 21 20 1 23s630ms 23s630ms Oct 22 20 1 24s525ms 24s525ms Oct 23 20 1 20s652ms 20s652ms Oct 24 20 1 14s596ms 14s596ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:37:50 Duration: 24s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-21 18:33:15 Duration: 23s630ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-23 18:32:54 Duration: 20s652ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 1m39s 12s746ms 25s153ms 19s947ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 20 20 1 25s153ms 25s153ms Oct 21 20 1 21s516ms 21s516ms Oct 22 20 1 18s698ms 18s698ms Oct 23 20 1 12s746ms 12s746ms Oct 24 20 1 21s621ms 21s621ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-20 18:32:59 Duration: 25s153ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-24 18:33:11 Duration: 21s621ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-21 18:33:20 Duration: 21s516ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 1m33s 14s861ms 21s286ms 18s711ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 20 20 1 19s538ms 19s538ms Oct 21 20 1 21s286ms 21s286ms Oct 22 20 1 16s677ms 16s677ms Oct 23 20 1 21s192ms 21s192ms Oct 24 20 1 14s861ms 14s861ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m33s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-21 18:32:58 Duration: 21s286ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-23 18:32:49 Duration: 21s192ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-20 18:32:34 Duration: 19s538ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 1m23s 13s918ms 18s208ms 16s782ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 20 20 1 17s322ms 17s322ms Oct 21 20 1 16s985ms 16s985ms Oct 22 20 1 17s475ms 17s475ms Oct 23 20 1 18s208ms 18s208ms Oct 24 20 1 13s918ms 13s918ms [ User: a3dsupervisor - Total duration: 1m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m23s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-23 18:34:03 Duration: 18s208ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:38:54 Duration: 17s475ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-20 18:33:57 Duration: 17s322ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 1m22s 14s243ms 19s323ms 16s524ms 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;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 20 20 1 19s323ms 19s323ms Oct 21 20 1 17s413ms 17s413ms Oct 22 20 1 15s566ms 15s566ms Oct 23 20 1 14s243ms 14s243ms Oct 24 20 1 16s74ms 16s74ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 5 ]
-
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: 2025-10-20 18:32:31 Duration: 19s323ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-21 18:32:51 Duration: 17s413ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-24 18:32:47 Duration: 16s74ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 1m19s 11s712ms 24s571ms 15s805ms alter table only public.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 #20
Day Hour Count Duration Avg duration Oct 20 20 1 24s571ms 24s571ms Oct 21 20 1 12s271ms 12s271ms Oct 22 20 1 13s152ms 13s152ms Oct 23 20 1 17s319ms 17s319ms Oct 24 20 1 11s712ms 11s712ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 5 ]
-
ALTER TABLE ONLY public.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-10-20 18:35:45 Duration: 24s571ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-23 18:35:49 Duration: 17s319ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-22 18:40:24 Duration: 13s152ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m39s 3m59s 3m48s 5 19m1s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 20 17 1 3m39s 3m39s Oct 21 15 1 3m52s 3m52s 17 1 3m59s 3m59s Oct 22 17 1 3m45s 3m45s Oct 24 16 1 3m43s 3m43s [ User: a3dsupervisor - Total duration: 19m1s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 19m1s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 15:34:59 Duration: 3m59s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-21 13:26:08 Duration: 3m52s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-22 15:21:13 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 58s14ms 3m34s 2m16s 4 9m6s insert into batch_scenario_run (creation_date, creator_num_id, end_date, modification_date, modifier_num_id, batch_scenario_num_id, start_date, state, status, batch_scenario_run_id) values (,,,,,,,,,);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 15 4 9m6s 2m16s [ User: a3dsupervisor - Total duration: 9m6s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9m6s - Times executed: 4 ]
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-21 13:26:08 Duration: 3m34s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-21 13:26:08 Duration: 2m52s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-21 13:26:08 Duration: 1m40s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m 2m19s 2m11s 5 10m56s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 20 20 1 2m6s 2m6s Oct 21 20 1 2m18s 2m18s Oct 22 20 1 2m11s 2m11s Oct 23 20 1 2m 2m Oct 24 20 1 2m19s 2m19s [ User: a3dsupervisor - Total duration: 10m56s - Times executed: 5 ]
[ Application: psql - Total duration: 10m56s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-24 18:49:12 Duration: 2m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-21 18:49:31 Duration: 2m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-22 18:53:24 Duration: 2m11s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 31s206ms 2m22s 1m26s 2 2m53s update a3d_user set anonymized =, user_civility =, creation_date =, user_num_id_creator =, user_firstname =, last_connection_date =, user_name =, modification_date =, modifier_num_id =, policy_version =, obj_num_id =, user_address =, user_authentication =, user_city =, user_country =, user_deleted =, user_fax =, company_num_id =, user_guid =, user_login =, user_mail =, user_celular =, user_password =, user_phone =, user_postal_code =, user_bok = where user_num_id =;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 21 15 2 2m53s 1m26s [ User: a3dsupervisor - Total duration: 2m53s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m53s - Times executed: 2 ]
-
update A3D_USER set ANONYMIZED =, USER_CIVILITY =, CREATION_DATE =, USER_NUM_ID_CREATOR =, USER_FIRSTNAME =, LAST_CONNECTION_DATE =, USER_NAME =, MODIFICATION_DATE =, MODIFIER_NUM_ID =, POLICY_VERSION =, OBJ_NUM_ID =, USER_ADDRESS =, USER_AUTHENTICATION =, USER_CITY =, USER_COUNTRY =, USER_DELETED =, USER_FAX =, COMPANY_NUM_ID =, USER_GUID =, USER_LOGIN =, USER_MAIL =, USER_CELULAR =, USER_PASSWORD =, USER_PHONE =, USER_POSTAL_CODE =, USER_BOK = where USER_NUM_ID =;
Date: 2025-10-21 13:26:08 Duration: 2m22s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
update A3D_USER set ANONYMIZED =, USER_CIVILITY =, CREATION_DATE =, USER_NUM_ID_CREATOR =, USER_FIRSTNAME =, LAST_CONNECTION_DATE =, USER_NAME =, MODIFICATION_DATE =, MODIFIER_NUM_ID =, POLICY_VERSION =, OBJ_NUM_ID =, USER_ADDRESS =, USER_AUTHENTICATION =, USER_CITY =, USER_COUNTRY =, USER_DELETED =, USER_FAX =, COMPANY_NUM_ID =, USER_GUID =, USER_LOGIN =, USER_MAIL =, USER_CELULAR =, USER_PASSWORD =, USER_PHONE =, USER_POSTAL_CODE =, USER_BOK = where USER_NUM_ID =;
Date: 2025-10-21 13:26:08 Duration: 31s206ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m15s 1m20s 1m18s 5 6m31s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 20 20 1 1m20s 1m20s Oct 21 20 1 1m18s 1m18s Oct 22 20 1 1m15s 1m15s Oct 23 20 1 1m18s 1m18s Oct 24 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 6m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m31s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-20 18:31:34 Duration: 1m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-24 18:31:52 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-21 18:31:53 Duration: 1m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 35s231ms 36s80ms 35s645ms 5 2m58s copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 20 20 1 35s231ms 35s231ms Oct 21 20 1 36s80ms 36s80ms Oct 22 20 1 35s932ms 35s932ms Oct 23 20 1 35s397ms 35s397ms Oct 24 20 1 35s583ms 35s583ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-21 18:31:10 Duration: 36s80ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-22 18:35:46 Duration: 35s932ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-24 18:31:08 Duration: 35s583ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 30s486ms 37s277ms 32s991ms 5 2m44s alter table only public.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 #7
Day Hour Count Duration Avg duration Oct 20 20 1 30s888ms 30s888ms Oct 21 20 1 37s277ms 37s277ms Oct 22 20 1 33s579ms 33s579ms Oct 23 20 1 32s726ms 32s726ms Oct 24 20 1 30s486ms 30s486ms [ User: a3dsupervisor - Total duration: 2m44s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m44s - Times executed: 5 ]
-
ALTER TABLE ONLY public.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-10-21 18:34:10 Duration: 37s277ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-22 18:38:35 Duration: 33s579ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-23 18:33:45 Duration: 32s726ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 29s478ms 34s203ms 31s691ms 5 2m38s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 20 20 1 29s902ms 29s902ms Oct 21 20 1 34s203ms 34s203ms Oct 22 20 1 29s478ms 29s478ms Oct 23 20 1 31s805ms 31s805ms Oct 24 20 1 33s64ms 33s64ms [ User: a3dsupervisor - Total duration: 2m38s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m38s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-21 18:35:14 Duration: 34s203ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-24 18:34:47 Duration: 33s64ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-23 18:34:46 Duration: 31s805ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 24s347ms 35s438ms 28s636ms 5 2m23s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 20 20 1 31s441ms 31s441ms Oct 21 20 1 24s347ms 24s347ms Oct 22 20 1 26s140ms 26s140ms Oct 23 20 1 35s438ms 35s438ms Oct 24 20 1 25s814ms 25s814ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-23 18:32:17 Duration: 35s438ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-20 18:32:05 Duration: 31s441ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-22 18:36:51 Duration: 26s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 25s49ms 31s598ms 28s146ms 5 2m20s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 20 20 1 31s598ms 31s598ms Oct 21 20 1 28s836ms 28s836ms Oct 22 20 1 29s190ms 29s190ms Oct 23 20 1 25s49ms 25s49ms Oct 24 20 1 26s59ms 26s59ms [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-20 18:32:11 Duration: 31s598ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-22 18:37:10 Duration: 29s190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-21 18:32:37 Duration: 28s836ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 12s710ms 55s25ms 27s943ms 11 5m7s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 20 16 1 14s679ms 14s679ms 17 1 55s25ms 55s25ms 20 1 17s1ms 17s1ms Oct 21 15 1 45s520ms 45s520ms 17 1 33s52ms 33s52ms 20 1 17s282ms 17s282ms Oct 22 17 1 34s557ms 34s557ms 20 1 16s910ms 16s910ms Oct 23 20 1 17s449ms 17s449ms Oct 24 16 1 43s186ms 43s186ms 20 1 12s710ms 12s710ms [ User: a3dsupervisor - Total duration: 5m7s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m7s - Times executed: 11 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-20 15:25:31 Duration: 55s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 13:31:52 Duration: 45s520ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-24 14:12:33 Duration: 43s186ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 23s176ms 27s153ms 25s377ms 5 2m6s create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 20 20 1 24s934ms 24s934ms Oct 21 20 1 26s636ms 26s636ms Oct 22 20 1 24s987ms 24s987ms Oct 23 20 1 27s153ms 27s153ms Oct 24 20 1 23s176ms 23s176ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m6s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-23 18:31:26 Duration: 27s153ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-21 18:31:37 Duration: 26s636ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-22 18:36:11 Duration: 24s987ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 18s435ms 29s812ms 23s726ms 5 1m58s 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;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 20 20 1 18s435ms 18s435ms Oct 21 20 1 25s295ms 25s295ms Oct 22 20 1 21s196ms 21s196ms Oct 23 20 1 23s891ms 23s891ms Oct 24 20 1 29s812ms 29s812ms [ User: a3dsupervisor - Total duration: 1m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m58s - Times executed: 5 ]
-
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: 2025-10-24 18:34:40 Duration: 29s812ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-21 18:35:02 Duration: 25s295ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-23 18:34:36 Duration: 23s891ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 14s596ms 24s525ms 19s966ms 5 1m39s create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 20 20 1 16s427ms 16s427ms Oct 21 20 1 23s630ms 23s630ms Oct 22 20 1 24s525ms 24s525ms Oct 23 20 1 20s652ms 20s652ms Oct 24 20 1 14s596ms 14s596ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:37:50 Duration: 24s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-21 18:33:15 Duration: 23s630ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-23 18:32:54 Duration: 20s652ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 12s746ms 25s153ms 19s947ms 5 1m39s create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 20 20 1 25s153ms 25s153ms Oct 21 20 1 21s516ms 21s516ms Oct 22 20 1 18s698ms 18s698ms Oct 23 20 1 12s746ms 12s746ms Oct 24 20 1 21s621ms 21s621ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-20 18:32:59 Duration: 25s153ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-24 18:33:11 Duration: 21s621ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-21 18:33:20 Duration: 21s516ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 14s861ms 21s286ms 18s711ms 5 1m33s alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 20 20 1 19s538ms 19s538ms Oct 21 20 1 21s286ms 21s286ms Oct 22 20 1 16s677ms 16s677ms Oct 23 20 1 21s192ms 21s192ms Oct 24 20 1 14s861ms 14s861ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m33s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-21 18:32:58 Duration: 21s286ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-23 18:32:49 Duration: 21s192ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-20 18:32:34 Duration: 19s538ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 13s918ms 18s208ms 16s782ms 5 1m23s alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 20 20 1 17s322ms 17s322ms Oct 21 20 1 16s985ms 16s985ms Oct 22 20 1 17s475ms 17s475ms Oct 23 20 1 18s208ms 18s208ms Oct 24 20 1 13s918ms 13s918ms [ User: a3dsupervisor - Total duration: 1m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m23s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-23 18:34:03 Duration: 18s208ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:38:54 Duration: 17s475ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-20 18:33:57 Duration: 17s322ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 14s243ms 19s323ms 16s524ms 5 1m22s 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;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 20 20 1 19s323ms 19s323ms Oct 21 20 1 17s413ms 17s413ms Oct 22 20 1 15s566ms 15s566ms Oct 23 20 1 14s243ms 14s243ms Oct 24 20 1 16s74ms 16s74ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 5 ]
-
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: 2025-10-20 18:32:31 Duration: 19s323ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-21 18:32:51 Duration: 17s413ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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: 2025-10-24 18:32:47 Duration: 16s74ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 11s712ms 24s571ms 15s805ms 5 1m19s alter table only public.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 #19
Day Hour Count Duration Avg duration Oct 20 20 1 24s571ms 24s571ms Oct 21 20 1 12s271ms 12s271ms Oct 22 20 1 13s152ms 13s152ms Oct 23 20 1 17s319ms 17s319ms Oct 24 20 1 11s712ms 11s712ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 5 ]
-
ALTER TABLE ONLY public.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-10-20 18:35:45 Duration: 24s571ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-23 18:35:49 Duration: 17s319ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.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-10-22 18:40:24 Duration: 13s152ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5s14ms 22s38ms 7s185ms 68 8m8s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 20 08 8 49s364ms 6s170ms 09 1 5s266ms 5s266ms Oct 21 08 4 29s757ms 7s439ms 09 1 6s368ms 6s368ms 21 2 11s143ms 5s571ms Oct 22 08 12 2m1s 10s142ms 09 2 12s273ms 6s136ms 21 4 23s191ms 5s797ms Oct 23 08 17 1m52s 6s615ms 21 4 22s555ms 5s638ms Oct 24 08 8 47s503ms 5s937ms 09 3 35s726ms 11s908ms 20 1 5s984ms 5s984ms 21 1 5s325ms 5s325ms [ User: a3dsupervisor - Total duration: 8m8s - Times executed: 68 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m2s - Times executed: 67 ]
[ Application: pg_restore - Total duration: 5s984ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s38ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:41 Duration: 14s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-23 06:59:16 Duration: 13s803ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 7s288ms 1 7s288ms 7s288ms 7s288ms select nextval('S_BACKGROUND_TASK');Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Oct 25 08 1 7s288ms 7s288ms [ User: a3dsupervisor - Total duration: 16s260ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s260ms - Times executed: 1 ]
-
select nextval('S_BACKGROUND_TASK');
Date: 2025-10-22 06:58:35 Duration: 7s288ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 21,675 Log entries
Events distribution
Key values
- 0 PANIC entries
- 19 FATAL entries
- 6443 ERROR entries
- 70 WARNING entries
Most Frequent Errors/Events
Key values
- 6,120 Max number of times the same event was reported
- 6,532 Total events found
Rank Times reported Error 1 6,120 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 20 21 100 22 338 23 92 00 667 01 27 Oct 21 02 3 21 90 22 469 23 728 00 96 01 27 Oct 22 21 96 22 420 23 200 00 238 01 2 Oct 23 21 110 22 386 23 93 00 657 01 28 Oct 24 02 4 03 1 21 99 22 360 23 96 00 661 01 26 Oct 25 02 1 03 2 04 3 2 128 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 20 16 2 19 3 Oct 21 16 20 19 3 Oct 22 12 3 15 5 16 6 18 2 19 3 Oct 23 10 2 11 2 13 3 14 2 17 5 19 3 Oct 24 13 2 14 2 15 24 17 28 18 2 19 3 Oct 25 19 3 3 40 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 20 17 8 Oct 21 15 8 17 8 Oct 22 17 8 Oct 24 16 8 4 30 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 20 17 6 Oct 21 15 6 17 6 Oct 22 17 6 Oct 24 16 6 5 12 ERROR: invalid large-object descriptor: 0
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 24 12 9 14 3 6 10 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 21 01 10 7 10 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 20 17 2 Oct 21 15 2 17 2 Oct 22 17 2 Oct 24 16 2 8 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 21 01 8 9 8 LOG: process ... still waiting for ShareLock on transaction ... after ... msinsert into BATCH_SCENARIO_RUN (...) values (...)
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 21 15 8 10 6 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 #10
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 11 6 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 #11
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 12 6 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 #12
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 13 6 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 #13
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 14 6 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 #14
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 15 6 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #15
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 16 6 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 17 6 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 #17
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 18 6 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 20 20 1 Oct 21 15 1 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 19 5 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #19
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 20 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #20
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 21 5 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #21
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 22 5 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #22
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 23 5 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #23
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 24 5 ERROR: null value in column "..." of relation "..." violates not-null constraintSELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #24
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 25 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #25
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 26 5 LOG: process ... still waiting for ShareLock on transaction ... after ... msselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #26
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 27 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #27
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 28 5 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #28
Day Hour Count Oct 20 20 1 Oct 21 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 29 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #29
Day Hour Count Oct 20 20 1 Oct 21 20 1 Oct 22 20 1 Oct 23 20 1 Oct 24 20 1 30 5 ERROR: canceling statement due to lock timeoutselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #30
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 31 5 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #31
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 32 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #32
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 33 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #33
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 34 5 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #34
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 35 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_TIME_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #35
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 36 5 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #36
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 37 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #37
Day Hour Count Oct 20 17 1 Oct 21 15 1 17 1 Oct 22 17 1 Oct 24 16 1 38 3 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #38
Day Hour Count Oct 21 20 1 Oct 23 20 2 39 2 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #39
Day Hour Count Oct 20 08 2 40 2 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #40
Day Hour Count Oct 22 20 1 Oct 23 20 1 41 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate A3D_USER set ANONYMIZED=,USER_CIVILITY=,CREATION_DATE=,USER_NUM_ID_CREATOR=,USER_FIRSTNAME=,LAST_CONNECTION_DATE=,USER_NAME=,MODIFICATION_DATE=,MODIFIER_NUM_ID=,POLICY_VERSION=,OBJ_NUM_ID=,USER_ADDRESS=,USER_AUTHENTICATION=,USER_CITY=,USER_COUNTRY=,USER_DELETED=,USER_FAX=,COMPANY_NUM_ID=,USER_GUID=,USER_LOGIN=,USER_MAIL=,USER_CELULAR=,USER_PASSWORD=,USER_PHONE=,USER_POSTAL_CODE=,USER_BOK= where USER_NUM_ID=
Times Reported Most Frequent Error / Event #41
Day Hour Count Oct 21 15 2 42 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (...) REFERENCES public.gtp_att_template(...) DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #42
Day Hour Count Oct 20 20 1 43 1 ERROR: Erreur: duplicate key value violates unique constraint "..."--liquibase formatted sql --changeset active3d:${a3d.release}-postgresql-optional-ACTIVE3D_RQM-17843_init_batch_process dbms:postgresql encoding:UTF-8 endDelimiter:/ DO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := 'ACTIVE3D_RQM-17843_init_batch_process'; BEGIN raise debug 'START %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval(...) into l_grpId; select nextval(...) into l_scnId; select nextval(...) into l_processId; select nextval(...) into l_processId_2; select nextval(...) into l_mappingId; select nextval(...) into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "..." (...) VALUES(...); INSERT INTO "..." (...) VALUES(...); INSERT INTO batch_group (...) VALUES(...); INSERT INTO batch_scenario (...) VALUES(...); INSERT INTO batch_process (...) VALUES(...); EXCEPTION WHEN OTHERS THEN RAISE EXCEPTION 'Erreur: %', SQLERRM; ROLLBACK; END; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET validated = true WHERE type = 'postInstallation' AND name = L_SCRIPT_NAME AND RELEASE = '${a3d.release}'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise notice 'END %', L_SCRIPT_NAME; EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #43
Day Hour Count Oct 21 12 1 44 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #44
Day Hour Count Oct 21 12 1 45 1 ERROR: syntax error at or near "..."mapping"..."1.0"..."UTF-8"..."yes"..."true"..."false"..."true"..."false"..."500"..."500"..."xml"..."false"..."false"..."false"..."false"..."1"..."false"..."yyyyMMdd"..."true"..."PORT"..."PORT"..."true"..."A3D_LIBELLE"..."A3D_IDENTITE"..."A3D_LIBELLE"..."mapping"..."1.0"..."UTF-8"..."yes"..."true"..."false"..."true"..."false"..."500"..."500"..."xml"..."false"..."false"..."false"..."false"..."1"..."false"..."yyyyMMdd"..."true"..."PORT"..."PORT"..."true"..."A3D_LIBELLE"..."A3D_IDENTITE"..."A3D_LIBELLE"..."mappingNumId"..."directoryPath"..."aaa"..."fileName"..."Export_XML_02.01_batch01"..."logLevel"..."Info"..."viewTemplateUniqueCode"..."VUE_TYPE_REFERENTIEL_PATRIMOINE"..."encoding"..."UTF-8"..."filter"..."filterAsString"...""..."encodingAsEnum"..."UTF_8"..."mappingNumId"..."directoryPath"..."aaa"..."fileName"..."Export_XML_02.01_batch01"..."logLevel"..."Info"..."viewTemplateUniqueCode"..."VUE_TYPE_REFERENTIEL_PATRIMOINE"..."encoding"..."UTF-8"..."filter"..."filterAsString"...""..."encodingAsEnum"..."UTF_8"..."
Times Reported Most Frequent Error / Event #45
Day Hour Count Oct 22 08 1 46 1 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #46
Day Hour Count Oct 23 16 1 47 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_relation
Times Reported Most Frequent Error / Event #47
Day Hour Count Oct 23 20 1 48 1 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... msupdate A3D_USER set ANONYMIZED=,USER_CIVILITY=,CREATION_DATE=,USER_NUM_ID_CREATOR=,USER_FIRSTNAME=,LAST_CONNECTION_DATE=,USER_NAME=,MODIFICATION_DATE=,MODIFIER_NUM_ID=,POLICY_VERSION=,OBJ_NUM_ID=,USER_ADDRESS=,USER_AUTHENTICATION=,USER_CITY=,USER_COUNTRY=,USER_DELETED=,USER_FAX=,COMPANY_NUM_ID=,USER_GUID=,USER_LOGIN=,USER_MAIL=,USER_CELULAR=,USER_PASSWORD=,USER_PHONE=,USER_POSTAL_CODE=,USER_BOK= where USER_NUM_ID=
Times Reported Most Frequent Error / Event #48
Day Hour Count Oct 21 15 1 49 1 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #49
Day Hour Count Oct 21 17 1