pgBadger-
Global information
- Generated on Mon Oct 6 09:36:26 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=04/h=23/m=00/PT1H.log
- Parsed 29,358 log entries in 1m7s
- Log start from 2025-09-29 07:36:35 to 2025-10-04 17:00:56
-
Overview
Global Stats
- 114 Number of unique normalized queries
- 363 Number of queries
- 3h25m17s Total query duration
- 2025-09-29 06:11:34 First query
- 2025-10-04 00:00:55 Last query
- 6 queries/s at 2025-09-29 07:45:04 Query peak
- 3h25m17s Total query duration
- 25s367ms Prepare/parse total duration
- 25s743ms Bind total duration
- 3h24m26s Execute total duration
- 7,109 Number of events
- 57 Number of unique normalized events
- 4,781 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,142 Number temporary file
- 1.37 GiB Max size of temporary file
- 19.29 MiB Average size of temporary file
- 4,372 Total number of sessions
- 34 sessions at 2025-10-03 07:51:10 Session peak
- 27d2h32m1s Total duration of sessions
- 8m55s Average duration of sessions
- 0 Average queries per session
- 2s817ms Average queries duration per session
- 8m52s Average idle time per session
- 4,373 Total number of connections
- 10 connections/s at 2025-10-03 18:48:08 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2025-09-29 07:45:04 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-02 06:12:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2025-09-29 07:45:04 Date
Queries duration
Key values
- 3h25m17s 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) Sep 28 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 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 29 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 13 0ms 7s20ms 5s785ms 5s981ms 15s418ms 19s548ms 07 32 0ms 8m50s 1m17s 50s31ms 56s668ms 31m11s 08 8 0ms 4m1s 1m8s 8s960ms 1m12s 5m56s 09 5 0ms 4m6s 1m4s 0ms 19s300ms 4m6s 10 6 0ms 4m7s 1m 10s649ms 59s434ms 4m7s 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 6 0ms 4m14s 58s783ms 0ms 29s72ms 4m14s 16 9 0ms 8m48s 1m40s 45s600ms 4m11s 8m48s 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 32 0ms 2m15s 22s294ms 2m15s 2m27s 2m27s 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 Sep 30 00 1 0ms 5s398ms 5s398ms 0ms 5s398ms 5s398ms 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 4 0ms 11s590ms 6s998ms 5s409ms 5s989ms 11s590ms 07 9 0ms 4m24s 1m4s 14s367ms 27s614ms 8m2s 08 6 0ms 8m56s 2m12s 11s897ms 1m3s 11m27s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 8 0ms 4m14s 1m10s 9s122ms 56s884ms 7m50s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 8 0ms 4m1s 47s80ms 9s234ms 1m14s 4m20s 13 6 0ms 4m4s 59s191ms 9s200ms 1m5s 4m25s 14 8 0ms 4m43s 51s194ms 20s495ms 53s581ms 4m43s 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 38 0ms 2m23s 20s129ms 1m37s 2m23s 2m35s 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 01 00 1 0ms 7s53ms 7s53ms 0ms 7s53ms 7s53ms 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 3 0ms 6s710ms 6s609ms 0ms 0ms 19s829ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 1 0ms 6s993ms 6s993ms 0ms 6s993ms 6s993ms 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 34 0ms 1m34s 21s369ms 1m53s 2m16s 2m30s 19 4 0ms 6s769ms 6s142ms 0ms 0ms 24s570ms 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 02 00 1 0ms 6s307ms 6s307ms 0ms 6s307ms 6s307ms 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 11 0ms 25s67ms 7s565ms 7s389ms 23s256ms 25s67ms 07 18 0ms 8s59ms 5s691ms 10s55ms 21s703ms 32s641ms 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 41 0ms 1m31s 19s506ms 2m15s 2m18s 2m34s 19 1 0ms 5s35ms 5s35ms 0ms 0ms 5s35ms 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 03 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 4 0ms 7s255ms 6s202ms 0ms 10s551ms 14s256ms 07 5 0ms 20s116ms 8s753ms 0ms 20s116ms 23s652ms 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 38 0ms 2m7s 20s185ms 1m58s 2m7s 2m45s 19 1 0ms 5s919ms 5s919ms 0ms 5s919ms 5s919ms 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 04 00 1 0ms 5s452ms 5s452ms 0ms 5s452ms 5s452ms 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) Sep 28 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 23 0 0 0ms 0ms 0ms 0ms Sep 29 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 3 0 6s36ms 0ms 0ms 11s90ms 07 16 0 30s344ms 6s475ms 35s507ms 3m41s 08 3 0 12s273ms 0ms 0ms 8s960ms 09 2 0 9s650ms 0ms 0ms 19s300ms 10 3 0 16s185ms 0ms 0ms 37s906ms 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 3 0 9s690ms 0ms 0ms 29s72ms 16 2 0 8s813ms 0ms 0ms 11s84ms 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 Sep 30 00 1 0 5s398ms 0ms 0ms 5s398ms 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 3 0 15s128ms 0ms 0ms 22s87ms 08 2 0 5s948ms 0ms 0ms 11s897ms 09 0 0 0ms 0ms 0ms 0ms 10 4 0 14s974ms 0ms 7s533ms 32s879ms 11 0 0 0ms 0ms 0ms 0ms 12 5 0 10s184ms 0ms 0ms 26s471ms 13 3 0 12s6ms 0ms 6s969ms 21s331ms 14 5 0 12s562ms 0ms 14s378ms 20s495ms 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 01 00 1 0 7s53ms 0ms 0ms 7s53ms 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 02 00 1 0 6s307ms 0ms 0ms 6s307ms 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 3 0 5s727ms 0ms 0ms 17s181ms 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 03 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 04 00 1 0 5s452ms 0ms 0ms 5s452ms 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) Sep 28 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 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 29 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 0 0 0 5s360ms 0ms 0ms 5s66ms 07 0 2 3 0 1m29s 0ms 0ms 33s436ms 08 0 1 0 0 1m54s 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 5 0 2m5s 0ms 0ms 51s880ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 6 32s611ms 0ms 13s524ms 1m49s 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 Sep 30 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 1 0 0 11s590ms 0ms 0ms 0ms 07 0 1 1 0 18s85ms 0ms 0ms 8s555ms 08 0 0 3 0 3m30s 0ms 0ms 1m3s 09 0 0 0 0 0ms 0ms 0ms 0ms 10 1 0 1 0 1m59s 0ms 0ms 56s884ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 1 0 1m14s 0ms 0ms 0ms 13 0 0 1 0 1m5s 0ms 0ms 0ms 14 0 0 1 0 53s581ms 0ms 0ms 53s581ms 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 6 32s973ms 0ms 0ms 58s410ms 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 01 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 1 0 6s993ms 0ms 0ms 6s993ms 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 6 32s905ms 0ms 0ms 55s942ms 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 02 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 2 1 0 10s999ms 0ms 0ms 7s389ms 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 1 7 25s26ms 0ms 6s287ms 42s476ms 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 03 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 1 0 0 7s255ms 0ms 0ms 0ms 07 0 0 1 0 20s116ms 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 28s1ms 0ms 9s123ms 1m13s 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 04 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 Sep 28 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% 23 0 0 0.00 0.00% Sep 29 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 2 13 6.50 15.38% 07 0 32 32.00 0.00% 08 0 8 8.00 0.00% 09 0 5 5.00 0.00% 10 0 6 6.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 6 6.00 0.00% 16 0 9 9.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% Sep 30 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 4 4.00 33.33% 07 0 9 9.00 0.00% 08 0 6 6.00 0.00% 09 0 0 0.00 0.00% 10 0 8 8.00 0.00% 11 0 0 0.00 0.00% 12 0 8 8.00 0.00% 13 0 6 6.00 0.00% 14 0 8 8.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 01 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 1 3 3.00 33.33% 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 0 0.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 02 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 11 11.00 0.00% 07 0 18 18.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 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 03 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 4 4.00 0.00% 07 0 5 5.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 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 04 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 Sep 28 00 1 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 23 2 0.00/s Sep 29 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 25 0.01/s 06 48 0.01/s 07 68 0.02/s 08 105 0.03/s 09 64 0.02/s 10 51 0.01/s 11 56 0.02/s 12 51 0.01/s 13 49 0.01/s 14 40 0.01/s 15 61 0.02/s 16 52 0.01/s 17 21 0.01/s 18 46 0.01/s 19 32 0.01/s 20 18 0.01/s 21 13 0.00/s 22 15 0.00/s 23 22 0.01/s Sep 30 00 25 0.01/s 01 18 0.01/s 02 15 0.00/s 03 22 0.01/s 04 12 0.00/s 05 23 0.01/s 06 30 0.01/s 07 68 0.02/s 08 43 0.01/s 09 84 0.02/s 10 46 0.01/s 11 21 0.01/s 12 69 0.02/s 13 52 0.01/s 14 36 0.01/s 15 15 0.00/s 16 22 0.01/s 17 32 0.01/s 18 63 0.02/s 19 22 0.01/s 20 27 0.01/s 21 18 0.01/s 22 41 0.01/s 23 23 0.01/s Oct 01 00 15 0.00/s 01 10 0.00/s 02 13 0.00/s 03 16 0.00/s 04 30 0.01/s 05 15 0.00/s 06 25 0.01/s 07 41 0.01/s 08 32 0.01/s 09 37 0.01/s 10 27 0.01/s 11 17 0.00/s 12 38 0.01/s 13 47 0.01/s 14 17 0.00/s 15 22 0.01/s 16 71 0.02/s 17 28 0.01/s 18 64 0.02/s 19 34 0.01/s 20 22 0.01/s 21 17 0.00/s 22 28 0.01/s 23 15 0.00/s Oct 02 00 18 0.01/s 01 17 0.00/s 02 13 0.00/s 03 15 0.00/s 04 22 0.01/s 05 14 0.00/s 06 59 0.02/s 07 61 0.02/s 08 28 0.01/s 09 52 0.01/s 10 34 0.01/s 11 20 0.01/s 12 69 0.02/s 13 50 0.01/s 14 41 0.01/s 15 20 0.01/s 16 25 0.01/s 17 34 0.01/s 18 63 0.02/s 19 28 0.01/s 20 26 0.01/s 21 17 0.00/s 22 19 0.01/s 23 23 0.01/s Oct 03 00 12 0.00/s 01 17 0.00/s 02 25 0.01/s 03 32 0.01/s 04 26 0.01/s 05 43 0.01/s 06 41 0.01/s 07 43 0.01/s 08 27 0.01/s 09 24 0.01/s 10 26 0.01/s 11 31 0.01/s 12 72 0.02/s 13 38 0.01/s 14 58 0.02/s 15 64 0.02/s 16 39 0.01/s 17 39 0.01/s 18 52 0.01/s 19 20 0.01/s 20 37 0.01/s 21 36 0.01/s 22 34 0.01/s 23 25 0.01/s Oct 04 00 14 0.00/s 01 10 0.00/s 02 19 0.01/s 03 14 0.00/s 04 26 0.01/s 05 19 0.01/s 06 26 0.01/s 07 23 0.01/s 08 17 0.00/s 09 24 0.01/s 10 16 0.00/s 11 26 0.01/s 12 23 0.01/s 13 12 0.00/s 14 20 0.01/s 15 16 0.00/s 16 25 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 Sep 28 00 1 76ms 76ms 01 2 77ms 77ms 02 2 75ms 75ms 03 2 73ms 73ms 04 2 71ms 71ms 05 2 73ms 73ms 06 2 80ms 80ms 07 2 71ms 71ms 08 2 71ms 71ms 09 2 72ms 72ms 10 2 75ms 75ms 11 2 73ms 73ms 12 2 74ms 74ms 13 2 71ms 71ms 14 2 71ms 71ms 15 2 73ms 73ms 16 2 75ms 75ms 17 2 76ms 76ms 18 2 80ms 80ms 19 2 70ms 70ms 20 2 85ms 85ms 21 2 74ms 74ms 23 2 71ms 71ms Sep 29 00 2 72ms 72ms 01 2 75ms 75ms 02 2 74ms 74ms 03 2 74ms 74ms 04 2 69ms 69ms 05 22 2m19s 2m19s 06 47 2m1s 1m59s 07 65 4m22s 3m44s 08 104 3m37s 3m32s 09 67 4m58s 4m53s 10 44 6m5s 5m56s 11 62 2m21s 2m21s 12 47 1m42s 1m42s 13 49 2m1s 2m1s 14 42 1m51s 1m51s 15 61 9m5s 8m59s 16 54 4m34s 4m17s 17 24 1h51m4s 1h51m4s 18 46 5m29s 5m13s 19 32 3m2s 3m2s 20 18 4m22s 4m22s 21 13 4m47s 4m47s 22 15 4m23s 4m23s 23 20 5m36s 5m36s Sep 30 00 27 2m47s 2m47s 01 18 2m50s 2m50s 02 15 6m55s 6m55s 03 22 4m7s 4m7s 04 12 5m41s 5m41s 05 23 3m7s 3m7s 06 29 3m5s 3m4s 07 61 1m28s 1m19s 08 45 10m47s 10m29s 09 84 3m2s 3m2s 10 47 7m29s 7m17s 11 18 15m5s 15m5s 12 72 2m56s 2m51s 13 51 3m45s 3m38s 14 33 8m24s 8m11s 15 24 1h13m39s 1h13m39s 16 22 5m24s 5m24s 17 30 1h30m33s 1h30m33s 18 65 3m16s 3m5s 19 22 4m4s 4m4s 20 25 3m38s 3m38s 21 20 3m43s 3m43s 22 39 4m6s 4m6s 23 25 3m9s 3m9s Oct 01 00 15 4m56s 4m56s 01 10 3m58s 3m58s 02 13 6m5s 6m5s 03 16 5m10s 5m10s 04 30 3m56s 3m56s 05 15 4m18s 4m18s 06 22 3m40s 3m40s 07 38 4m7s 4m6s 08 30 2m54s 2m54s 09 39 2m40s 2m40s 10 27 3m13s 3m13s 11 17 3m58s 3m58s 12 38 11m21s 11m21s 13 47 5m2s 5m2s 14 17 4m7s 4m7s 15 22 3m37s 3m37s 16 65 34m15s 34m15s 17 40 1h8m26s 1h8m26s 18 62 3m29s 3m17s 19 35 2m59s 2m59s 20 22 1m52s 1m52s 21 17 4m46s 4m46s 22 28 4m48s 4m48s 23 15 2m54s 2m54s Oct 02 00 18 3m28s 3m28s 01 17 6m49s 6m49s 02 13 4m51s 4m51s 03 15 5m30s 5m30s 04 22 3m51s 3m51s 05 14 5m12s 5m12s 06 56 2m37s 2m36s 07 62 3m6s 3m4s 08 28 7m45s 7m45s 09 41 6m47s 6m47s 10 45 7m59s 7m59s 11 22 12m13s 12m13s 12 67 3m12s 3m12s 13 50 3m33s 3m33s 14 41 6m37s 6m37s 15 22 8m28s 8m28s 16 25 2m43s 2m43s 17 35 1h18m9s 1h18m9s 18 59 3m32s 3m18s 19 31 3m1s 3m1s 20 25 1m19s 1m19s 21 18 8m24s 8m24s 22 17 1m12s 1m12s 23 25 5m44s 5m44s Oct 03 00 12 5m16s 5m16s 01 16 1m16s 1m16s 02 26 6m15s 6m15s 03 29 3m21s 3m21s 04 27 3m21s 3m21s 05 42 2m26s 2m26s 06 42 1m37s 1m37s 07 43 3m14s 3m13s 08 23 8m21s 8m21s 09 22 2m44s 2m44s 10 26 4m19s 4m19s 11 34 43m45s 43m45s 12 75 3m30s 3m30s 13 36 2m44s 2m44s 14 53 6m32s 6m32s 15 70 41m52s 41m52s 16 42 3m45s 3m45s 17 37 7m45s 7m45s 18 54 3m42s 3m28s 19 20 4m19s 4m19s 20 35 2m53s 2m53s 21 38 2m9s 2m9s 22 34 3m5s 3m5s 23 25 1m9s 1m9s Oct 04 00 14 8m56s 8m56s 01 10 1m3s 1m3s 02 19 7m 7m 03 14 1m3s 1m3s 04 26 6m35s 6m35s 05 19 3m12s 3m12s 06 26 3m45s 3m45s 07 20 4m57s 4m57s 08 20 3m18s 3m18s 09 24 3m33s 3m33s 10 16 4m55s 4m55s 11 26 2m49s 2m49s 12 23 2m48s 2m48s 13 12 7m7s 7m7s 14 20 5m25s 5m25s 15 16 4m42s 4m42s 16 25 3m18s 3m18s 17 5 8h53m16s 8h53m16s 18 2 96ms 96ms 19 2 84ms 84ms 20 2 79ms 79ms 21 2 83ms 83ms 22 2 73ms 73ms 23 2 74ms 74ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-10-03 18:48:08 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 4,373 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,373 connections Total
-
Sessions
Simultaneous sessions
Key values
- 34 sessions Session Peak
- 2025-10-03 07:51:10 Date
Histogram of session times
Key values
- 3,378 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 4,372 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,372 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,372 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 4,372 sessions Total
Application Count Total Duration Average Duration DBeaver 24.2.1 - Main 'autotest_feat_batch' 4 1d1h15m3s 6h18m45s DBeaver 24.2.1 - Metadata 'autotest_feat_batch' 4 1d1h15m2s 6h18m45s DBeaver 24.2.1 - SQLEditor 'Script-420.sql' 5 1d1h16m8s 5h3m13s DBeaver 24.2.1 - View Lock item 8 2s309ms 288ms DBeaver 24.2.1 - View Locks 1 296ms 296ms DBeaver 24.2.1 - View sessions 1 275ms 275ms IntelliJ IDEA 2024.3.5 9 10h38m22s 1h10m55s PostgreSQL JDBC Driver 3,939 23d9h9m30s 8m32s [unknown] 356 37s863ms 106ms pg_restore 20 2h47m18s 8m21s psql 25 9m53s 23s755ms -
Temporary Files
Size of temporary files
Key values
- 393.31 MiB Temp Files size Peak
- 2025-09-29 18:39:07 Date
Number of temporary files
Key values
- 8 per second Temp Files Peak
- 2025-09-29 18:42:36 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 28 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 23 0 0 0 Sep 29 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 27 117.20 MiB 4.34 MiB 08 27 115.35 MiB 4.27 MiB 09 24 104.56 MiB 4.36 MiB 10 24 104.64 MiB 4.36 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 25 108.76 MiB 4.35 MiB 16 25 106.90 MiB 4.28 MiB 17 0 0 0 18 180 4.12 GiB 23.44 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 30 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 10 28.40 MiB 2.84 MiB 08 18 89.14 MiB 4.95 MiB 09 3 12.56 MiB 4.19 MiB 10 25 106.89 MiB 4.28 MiB 11 1 4.19 MiB 4.19 MiB 12 25 106.96 MiB 4.28 MiB 13 25 106.89 MiB 4.28 MiB 14 25 106.92 MiB 4.28 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 169 4.11 GiB 24.93 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 01 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 1 4.19 MiB 4.19 MiB 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 0 0 0 15 0 0 0 16 4 16.75 MiB 4.19 MiB 17 0 0 0 18 167 4.02 GiB 24.67 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 02 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 1 4.19 MiB 4.19 MiB 07 1 4.19 MiB 4.19 MiB 08 0 0 0 09 2 8.38 MiB 4.19 MiB 10 1 4.19 MiB 4.19 MiB 11 0 0 0 12 3 12.56 MiB 4.19 MiB 13 1 4.19 MiB 4.19 MiB 14 1 4.19 MiB 4.19 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 159 3.96 GiB 25.50 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 03 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 2 8.38 MiB 4.19 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 4 16.75 MiB 4.19 MiB 13 0 0 0 14 1 4.19 MiB 4.19 MiB 15 2 8.38 MiB 4.19 MiB 16 2 8.38 MiB 4.19 MiB 17 0 0 0 18 153 3.98 GiB 26.67 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 04 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 69 434.08 MiB 2.32 MiB 28.94 MiB 6.29 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('202001020755', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101020755', '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-09-29 07:56:05 Duration: 38s126ms 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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-29 10:35:27 Duration: 10s649ms 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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-30 10:35:20 Duration: 10s361ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 31 100.98 MiB 2.24 MiB 13.59 MiB 3.26 MiB select goc.obj_num_id from gtp_obj_composition goc where position(? in goc.obj_compo_value) <> ?;-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;
Date: 2025-09-30 14:35:50 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 15 1.98 GiB 18.71 MiB 507.41 MiB 135.01 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-03 18:33:07 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 15 460.22 MiB 21.59 MiB 39.94 MiB 30.68 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-03 18:34:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 15 164.40 MiB 3.00 MiB 41.48 MiB 10.96 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-03 18:31:28 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 15 2.39 GiB 36.00 MiB 701.45 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-03 18:29:57 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 15 1.93 GiB 11.05 MiB 486.97 MiB 131.88 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-03 18:33:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 15 479.66 MiB 8.80 MiB 89.55 MiB 31.98 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-03 18:34:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 15 191.47 MiB 3.33 MiB 46.84 MiB 12.76 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-03 18:34:56 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 15 394.08 MiB 17.80 MiB 41.02 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-03 18:34:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 13 358.29 MiB 3.28 MiB 76.34 MiB 27.56 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-03 18:34:42 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 13 63.34 MiB 2.67 MiB 10.76 MiB 4.87 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-03 18:35:02 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 13 890.49 MiB 50.91 MiB 178.09 MiB 68.50 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-03 18:33:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 13 1021.27 MiB 27.48 MiB 278.52 MiB 78.56 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-03 18:32:32 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 13 883.56 MiB 3.85 MiB 431.72 MiB 67.97 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-03 18:30:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 13 5.56 GiB 117.45 MiB 1.37 GiB 437.91 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-03 18:29:03 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 8 168.41 MiB 2.02 MiB 72.77 MiB 21.05 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-03 18:34:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 6 1.00 GiB 2.76 MiB 670.66 MiB 171.06 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-03 18:33:12 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 56.56 MiB 9.66 MiB 12.87 MiB 11.31 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-03 18:35:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 4 307.56 MiB 8.27 MiB 201.49 MiB 76.89 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-10-03 18:31:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 4 22.70 MiB 2.56 MiB 8.79 MiB 5.68 MiB select count(*) from gtp_obj_rel_vt;-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 10:32:57 Duration: 32s879ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 13:35:59 Duration: 21s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 14:34:02 Duration: 20s495ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
22 2 11.35 MiB 2.56 MiB 8.79 MiB 5.68 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-29 07:45:04 Duration: 8m50s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-30 14:33:34 Duration: 4m43s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-30 07:58:00 Duration: 4m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
23 1 369.88 MiB 369.88 MiB 369.88 MiB 369.88 MiB add constraint fk_gtp_obj_compo_category foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_category FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-02 18:38:50 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
24 1 21.65 MiB 21.65 MiB 21.65 MiB 21.65 MiB with recursive nodes as ( select distinct obj.obj_num_id as id1, objsecond.obj_num_id as id2, gntt1.node_tree_type_num_id_p as nodeid1p from gtp_obj obj inner join gtp_node_tree_type gntt1 on obj.obj_template_num_id = gntt1.obj_template_num_id and gntt1.view_template_num_id = ? inner join gtp_node_tree_type gntt2 on gntt1.node_tree_type_num_id = gntt2.node_tree_type_num_id_p and gntt1.view_template_num_id = gntt2.view_template_num_id inner join gtp_node_tree_type gntt3 on gntt2.node_tree_type_num_id = gntt3.node_tree_type_num_id_p and gntt3.view_template_num_id = gntt2.view_template_num_id inner join gtp_relation gr on obj.obj_num_id = case gntt2.rel_sens when ? then gr.container_num_id else gr.content_num_id end inner join gtp_obj objsecond on objsecond.obj_num_id = case gntt2.rel_sens when ? then gr.content_num_id else gr.container_num_id end where obj.obj_b_valid = ? and objsecond.obj_b_valid = ? and ((gntt2.rel_sens = ? and gntt2.rel_template_num_id = gr.rel_template_num_id and ((gntt3.obj_template_num_id = objsecond.obj_template_num_id) or (exists ( select ? from gtp_node_tree_type gntt4 where gntt3.lnk_template_num_id = gntt4.node_tree_type_num_id and gntt4.view_template_num_id = gntt3.view_template_num_id and objsecond.obj_template_num_id = gntt4.obj_template_num_id)))) or (gntt2.rel_sens = ? and ((gntt3.obj_template_num_id = objsecond.obj_template_num_id) or (exists ( select ? from gtp_node_tree_type gntt4 where gntt3.lnk_template_num_id = gntt4.node_tree_type_num_id and gntt4.view_template_num_id = gntt3.view_template_num_id and objsecond.obj_template_num_id = gntt4.obj_template_num_id))))) ), nodes2 as ( select nodes.* from nodes where nodes.id2 in ( select perimeter.obj_num_id from gtp_obj gob inner join gtp_relation gr on gr.container_num_id = gob.obj_num_id inner join gtp_rel_template grt on (grt.rel_template_num_id = gr.rel_template_num_id and grt.rel_group_template_num_id = ?) inner join gtp_obj perimeter on perimeter.obj_num_id = gr.content_num_id where gob.obj_template_num_id in (...)) union all select nodes.* from nodes inner join nodes2 on nodes2.id1 = nodes.id2 ) select distinct nodes2.id1, nodes2.id2 from nodes2;-
WITH RECURSIVE nodes AS ( SELECT /*+ MATERIALIZE */ DISTINCT obj.obj_num_id as id1, objSecond.obj_num_id as id2, gntt1.node_tree_type_num_id_p as nodeId1p FROM gtp_obj obj INNER JOIN gtp_node_tree_type gntt1 ON obj.obj_template_num_id = gntt1.obj_template_num_id AND gntt1.view_template_num_id = $1 INNER JOIN gtp_node_tree_type gntt2 ON gntt1.node_tree_type_num_id = gntt2.node_tree_type_num_id_p AND gntt1.view_template_num_id = gntt2.view_template_num_id INNER JOIN gtp_node_tree_type gntt3 ON gntt2.node_tree_type_num_id = gntt3.node_tree_type_num_id_p AND gntt3.view_template_num_id = gntt2.view_template_num_id INNER JOIN gtp_relation gr ON obj.obj_num_id = case gntt2.rel_sens when 1 then gr.container_num_id else gr.content_num_id end INNER JOIN gtp_obj objSecond ON objSecond.obj_num_id = case gntt2.rel_sens when 1 then gr.content_num_id else gr.container_num_id end WHERE obj.obj_b_valid = 1 AND objSecond.obj_b_valid = 1 AND (( /*Fils Rel+Lnk*/ gntt2.rel_sens = 1 AND gntt2.rel_template_num_id = gr.rel_template_num_id AND (( /*Rel*/ gntt3.obj_template_num_id = objSecond.obj_template_num_id) OR ( /*Lnk*/ EXISTS ( SELECT 1 FROM gtp_node_tree_type gntt4 WHERE gntt3.lnk_template_num_id = gntt4.node_tree_type_num_id AND gntt4.view_template_num_id = gntt3.view_template_num_id AND objSecond.obj_template_num_id = gntt4.obj_template_num_id)))) OR ( /*Pere Rel+Lnk*/ gntt2.rel_sens = 0 AND (( /*Rel*/ gntt3.obj_template_num_id = objSecond.obj_template_num_id) OR ( /*Lnk*/ EXISTS ( SELECT 1 FROM gtp_node_tree_type gntt4 WHERE gntt3.lnk_template_num_id = gntt4.node_tree_type_num_id AND gntt4.view_template_num_id = gntt3.view_template_num_id AND objSecond.obj_template_num_id = gntt4.obj_template_num_id))))) ), nodes2 AS ( select nodes.* from nodes WHERE nodes.id2 IN ( SELECT perimeter.OBJ_NUM_ID FROM gtp_obj gob INNER JOIN gtp_relation gr ON gr.CONTAINER_NUM_ID = gob.obj_num_id INNER JOIN GTP_REL_TEMPLATE grt ON (grt.REL_TEMPLATE_NUM_ID = gr.REL_TEMPLATE_NUM_ID and grt.REL_GROUP_TEMPLATE_NUM_ID = 18) INNER JOIN gtp_obj perimeter ON perimeter.OBJ_NUM_ID = gr.CONTENT_NUM_ID WHERE gob.obj_template_num_id IN (26, 108, 184)) UNION ALL select nodes.* from nodes INNER JOIN nodes2 ON nodes2.id1 = nodes.id2 ) Select distinct nodes2.id1, nodes2.id2 from nodes2;
Date: 2025-09-29 07:31:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
25 1 1.00 GiB 1.00 GiB 1.00 GiB 1.00 GiB add constraint fk_gtp_obj_compo_modifier foreign key (obj_compo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_modifier FOREIGN KEY (obj_compo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-29 18:36:31 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.37 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-01 18:37:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.12 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-03 18:29:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1.11 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-02 18:36:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1.00 GiB ADD CONSTRAINT fk_gtp_obj_compo_modifier FOREIGN KEY (obj_compo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-09-29 18:36:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 701.45 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-30 18:36:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 670.66 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-09-30 18:37:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 507.41 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-02 18:40:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 491.98 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-09-30 18:37:59 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 486.97 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-30 18:40:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 468.77 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-30 18:39:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 468.04 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-09-29 18:38:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 431.72 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-01 18:39:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 375.98 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-03 18:30:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 371.60 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-29 18:41:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 369.88 MiB ADD CONSTRAINT fk_gtp_obj_compo_category FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-02 18:38:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 339.05 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-03 18:29:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 337.69 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-02 18:37:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 336.15 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-01 18:38:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 333.94 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-29 18:37:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 323.44 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-01 18:40:51 - 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 Sep 28 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 23 0 0 Sep 29 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 Sep 30 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 01 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 02 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 03 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 04 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
- 36 locks Total
Type Object Count Total Duration Average Duration (s) AccessShareLock 3 4s379ms 1s459ms relation 3 4s379ms 1s459ms ExclusiveLock 10 10s826ms 1s82ms extension 10 10s826ms 1s82ms ShareLock 16 33m13s 2m4s relation 6 8s278ms 1s379ms transaction 10 33m4s 3m18s ShareRowExclusiveLock 5 5s24ms 1s4ms relation 5 5s24ms 1s4ms ShareUpdateExclusiveLock 2 2s39ms 1s19ms relation 2 2s39ms 1s19ms Total 36 33m35s 55s981ms 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
- 61 Total read queries
- 265 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 363 Requests
- 3h24m26s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 364 Requests
User Request type Count Duration a3dsupervisor Total 364 3h24m32s copy from 31 16m16s cte 2 23s761ms ddl 143 36m21s delete 21 27m34s insert 4 3m19s others 37 1h12m27s select 62 16m8s tcl 56 22m54s update 8 9m5s Duration by user
Key values
- 3h24m32s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 364 3h24m32s copy from 31 16m16s cte 2 23s761ms ddl 143 36m21s delete 21 27m34s insert 4 3m19s others 37 1h12m27s select 62 16m8s tcl 56 22m54s update 8 9m5s Queries by host
Key values
- 10.3.0.4 Main host
- 364 Requests
- 3h24m32s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 181 Requests
- 2h18m7s (PostgreSQL JDBC Driver)
- Main time consuming application
Application Request type Count Duration DBeaver 24.2.1 - SQLEditor 'Script-420.sql' Total 1 3m37s others 1 3m37s PostgreSQL JDBC Driver Total 181 2h18m7s cte 2 23s761ms delete 21 27m34s insert 4 3m19s others 31 58m57s select 61 16m3s tcl 54 22m43s update 8 9m5s pg_restore Total 176 52m48s copy from 31 16m16s ddl 143 36m21s tcl 2 11s45ms psql Total 5 9m52s others 5 9m52s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-02 22:15:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 188 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 8m56s delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;[ Date: 2025-09-30 08:17:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 8m50s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-29 07:45:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 8m48s delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;[ Date: 2025-09-29 16:36:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 6m24s UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;[ Date: 2025-09-29 07:45:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 6m23s COMMIT;[ Date: 2025-09-29 07:45:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 4m43s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 14:33:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 4m34s COMMIT;[ Date: 2025-09-29 07:45:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 4m24s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 07:58:00 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 4m14s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-29 15:33:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 4m14s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 10:32:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 4m11s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-29 16:16:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 4m7s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-29 10:32:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 4m6s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-29 09:49:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 4m4s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 13:35:28 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 4m1s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-29 08:42:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 4m1s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 12:48:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 3m41s select distinct (SERVER_ID) from GTP_LOG_EHCACHE;[ Date: 2025-09-29 07:53:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 3m37s --liquibase formatted sql--changeset active3d:7.22.0.0-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 (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [START]', '7.22.0.0'); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval('s_batch_group_num_id') into l_grpId; select nextval('s_batch_scenario_num_id') into l_scnId; select nextval('s_batch_process_num_id') into l_processId; select nextval('s_batch_process_num_id') into l_processId_2; select nextval('s_mapping_num_id') into l_mappingId; select nextval('s_mapping_num_id') into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId, '02.01_batch01', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch01'); INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId2, '02.01_batch02', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch02'); INSERT INTO batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_grpId, '02_group', '02_group', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_scnId, l_grpId, '02_scenario_01', '02_scenario_01', '', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId, l_scnId, '02.01_batch01', '02.01_batch01', 8, 1, '', '{"mappingNumId":'||l_mappingId||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId_2, l_scnId, '02.01_batch02', '02.01_batch02', 8, 2, '', '{"mappingNumId":'||l_mappingId2||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); 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 = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [SUCCESS]', '7.22.0.0'); raise notice 'END %', L_SCRIPT_NAME;EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [ERROR]', '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.22.0.0'); RAISE;END $body$;[ Date: 2025-09-30 07:58:00 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' - Bind query: yes ]
19 3m2s insert into BATCH_PROCESS (BATCH_PROCESS_COMMENT, CREATION_DATE, CREATOR_NUM_ID, BATCH_PROCESS_EXECUTION_ORDER, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_PROCESS_NAME, BATCH_SCENARIO_NUM_ID, BATCH_PROCESS_SETTINGS, BATCH_PROCESS_TYPE_CODE, BATCH_PROCESS_UNIQUE_CODE, BATCH_PROCESS_NUM_ID) values (,,,,,,,,,,,);[ Date: 2025-09-30 10:32:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 2m49s COMMIT;[ Date: 2025-09-29 07:45:04 - 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 51m4s 11 4m1s 8m50s 4m38s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 09 1 8m50s 8m50s 10 1 4m1s 4m1s 11 1 4m6s 4m6s 12 1 4m7s 4m7s 17 1 4m14s 4m14s 18 1 4m11s 4m11s Sep 30 09 1 4m24s 4m24s 12 1 4m14s 4m14s 14 1 4m1s 4m1s 15 1 4m4s 4m4s 16 1 4m43s 4m43s [ User: a3dsupervisor - Total duration: 51m4s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51m4s - Times executed: 11 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-29 07:45:04 Duration: 8m50s 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-09-30 14:33:34 Duration: 4m43s 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-09-30 07:58:00 Duration: 4m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 22m54s 56 5s4ms 6m23s 24s544ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 08 8 46s376ms 5s797ms 09 6 15m44s 2m37s Sep 30 08 2 10s994ms 5s497ms 09 1 5s112ms 5s112ms 10 1 2m30s 2m30s 20 1 6s3ms 6s3ms Oct 01 09 3 19s829ms 6s609ms 21 4 24s570ms 6s142ms Oct 02 08 4 22s40ms 5s510ms 09 17 1m34s 5s551ms 21 1 5s35ms 5s35ms Oct 03 08 2 10s551ms 5s275ms 09 4 23s652ms 5s913ms 20 1 5s42ms 5s42ms 21 1 5s919ms 5s919ms [ User: a3dsupervisor - Total duration: 22m54s - Times executed: 56 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22m43s - Times executed: 54 ]
[ Application: pg_restore - Total duration: 11s45ms - Times executed: 2 ]
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 6m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 4m34s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 2m49s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 17m45s 2 8m48s 8m56s 8m52s delete from gtp_workspace where workspace_num_id =;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 18 1 8m48s 8m48s Sep 30 10 1 8m56s 8m56s [ User: a3dsupervisor - Total duration: 17m45s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17m45s - Times executed: 2 ]
-
delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;
Date: 2025-09-30 08:17:13 Duration: 8m56s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;
Date: 2025-09-29 16:36:09 Duration: 8m48s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 9m52s 5 1m31s 2m23s 1m58s vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 20 1 2m15s 2m15s Sep 30 20 1 2m23s 2m23s Oct 01 20 1 1m34s 1m34s Oct 02 20 1 1m31s 1m31s Oct 03 20 1 2m7s 2m7s [ User: a3dsupervisor - Total duration: 9m52s - Times executed: 5 ]
[ Application: psql - Total duration: 9m52s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-09-30 18:54:25 Duration: 2m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-29 18:54:03 Duration: 2m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-03 18:46:55 Duration: 2m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 8m 13 5s71ms 1m14s 36s970ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 09 1 24s148ms 24s148ms 18 1 51s880ms 51s880ms Sep 30 09 1 27s614ms 27s614ms 10 1 1m3s 1m3s 12 1 56s884ms 56s884ms 14 1 1m14s 1m14s 15 1 1m5s 1m5s 16 1 53s581ms 53s581ms Oct 01 11 1 6s993ms 6s993ms Oct 02 08 1 25s67ms 25s67ms 20 1 5s71ms 5s71ms Oct 03 09 1 20s116ms 20s116ms 20 1 5s500ms 5s500ms [ User: a3dsupervisor - Total duration: 8m - Times executed: 13 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m - Times executed: 13 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-30 12:54:14 Duration: 1m14s 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-09-30 13:41:12 Duration: 1m5s 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-09-30 08:03:34 Duration: 1m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 6m24s 1 6m24s 6m24s 6m24s update log_session set session_status = where session_status = and server_id =;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 09 1 6m24s 6m24s [ User: a3dsupervisor - Total duration: 6m24s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m24s - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;
Date: 2025-09-29 07:45:04 Duration: 6m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 6m15s 5 1m13s 1m16s 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;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 29 20 1 1m15s 1m15s Sep 30 20 1 1m16s 1m16s Oct 01 20 1 1m15s 1m15s Oct 02 20 1 1m15s 1m15s Oct 03 20 1 1m13s 1m13s [ User: a3dsupervisor - Total duration: 6m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m15s - 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-09-30 18:36:31 Duration: 1m16s 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-01 18:37:20 Duration: 1m15s 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-02 18:37:08 Duration: 1m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5m11s 5 47s68ms 1m13s 1m2s call pack_gtp_trigger.p_trigger_del_line_att_tab (,);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 10 2 2m25s 1m12s 11 1 47s68ms 47s68ms 12 1 59s434ms 59s434ms 17 1 59s453ms 59s453ms [ User: a3dsupervisor - Total duration: 5m11s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m11s - Times executed: 5 ]
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 08:03:38 Duration: 1m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 08:48:23 Duration: 1m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 15:38:36 Duration: 59s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 5m 6 7s419ms 3m41s 50s60ms select distinct (server_id) from gtp_log_ehcache;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 09 1 3m41s 3m41s 10 1 21s727ms 21s727ms 12 1 29s984ms 29s984ms 17 1 12s39ms 12s39ms Sep 30 14 1 7s867ms 7s867ms 16 1 7s419ms 7s419ms [ User: a3dsupervisor - Total duration: 5m - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m - Times executed: 6 ]
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 07:53:21 Duration: 3m41s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 10:34:42 Duration: 29s984ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 08:44:27 Duration: 21s727ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 3m37s 1 3m37s 3m37s 3m37s --liquibase formatted sql--changeset active3d:?.?.?.?-postgresql-optional-active3d_rqm-17843_init_batch_process dbms:postgresql encoding:utf-8 enddelimiter:/do $body$declare l_script_name constant text := ?;begin raise debug ?, l_script_name; -- ne pas supprimer cette ligne : initialisation de la validation du passage du script de post-installation insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); 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 = ?; insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid2, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_grpid, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_scnid, l_grpid, ?, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid||?, current_timestamp, ?, null, null); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid_2, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid2||?, current_timestamp, ?, null, null); exception when others then raise exception ?, 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 = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); raise notice ?, l_script_name;exception when others then call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); call pack_gtp_utils.p_trace_error(? || l_script_name, sqlerrm, ?); raise;end $body$;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 30 09 1 3m37s 3m37s [ User: a3dsupervisor - Total duration: 3m37s - Times executed: 1 ]
[ Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' - Total duration: 3m37s - Times executed: 1 ]
-
--liquibase formatted sql--changeset active3d:7.22.0.0-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 (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [START]', '7.22.0.0'); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval('s_batch_group_num_id') into l_grpId; select nextval('s_batch_scenario_num_id') into l_scnId; select nextval('s_batch_process_num_id') into l_processId; select nextval('s_batch_process_num_id') into l_processId_2; select nextval('s_mapping_num_id') into l_mappingId; select nextval('s_mapping_num_id') into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId, '02.01_batch01', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch01'); INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId2, '02.01_batch02', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch02'); INSERT INTO batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_grpId, '02_group', '02_group', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_scnId, l_grpId, '02_scenario_01', '02_scenario_01', '', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId, l_scnId, '02.01_batch01', '02.01_batch01', 8, 1, '', '{"mappingNumId":'||l_mappingId||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId_2, l_scnId, '02.01_batch02', '02.01_batch02', 8, 2, '', '{"mappingNumId":'||l_mappingId2||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); 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 = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [SUCCESS]', '7.22.0.0'); raise notice 'END %', L_SCRIPT_NAME;EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [ERROR]', '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.22.0.0'); RAISE;END $body$;
Date: 2025-09-30 07:58:00 Duration: 3m37s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' Bind query: yes
11 3m11s 5 27s358ms 48s778ms 38s331ms 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 Sep 29 20 1 27s358ms 27s358ms Sep 30 20 1 30s227ms 30s227ms Oct 01 20 1 48s778ms 48s778ms Oct 02 20 1 45s202ms 45s202ms Oct 03 20 1 40s88ms 40s88ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-01 18:38:09 Duration: 48s778ms 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-02 18:37:53 Duration: 45s202ms 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-03 18:29:57 Duration: 40s88ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3m7s 5 33s937ms 40s107ms 37s513ms 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 #12
Day Hour Count Duration Avg duration Sep 29 20 1 38s802ms 38s802ms Sep 30 20 1 38s659ms 38s659ms Oct 01 20 1 36s60ms 36s60ms Oct 02 20 1 33s937ms 33s937ms Oct 03 20 1 40s107ms 40s107ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m7s - 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-03 18:31:58 Duration: 40s107ms 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-09-29 18:39:07 Duration: 38s802ms 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-09-30 18:38:51 Duration: 38s659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3m2s 1 3m2s 3m2s 3m2s insert into batch_process (batch_process_comment, creation_date, creator_num_id, batch_process_execution_order, modification_date, modifier_num_id, batch_process_name, batch_scenario_num_id, batch_process_settings, batch_process_type_code, batch_process_unique_code, batch_process_num_id) values (,,,,,,,,,,,);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 30 12 1 3m2s 3m2s [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m2s - Times executed: 1 ]
-
insert into BATCH_PROCESS (BATCH_PROCESS_COMMENT, CREATION_DATE, CREATOR_NUM_ID, BATCH_PROCESS_EXECUTION_ORDER, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_PROCESS_NAME, BATCH_SCENARIO_NUM_ID, BATCH_PROCESS_SETTINGS, BATCH_PROCESS_TYPE_CODE, BATCH_PROCESS_UNIQUE_CODE, BATCH_PROCESS_NUM_ID) values (,,,,,,,,,,,);
Date: 2025-09-30 10:32:17 Duration: 3m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 2m56s 5 34s372ms 35s968ms 35s381ms 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 #14
Day Hour Count Duration Avg duration Sep 29 20 1 34s372ms 34s372ms Sep 30 20 1 35s641ms 35s641ms Oct 01 20 1 35s968ms 35s968ms Oct 02 20 1 35s727ms 35s727ms Oct 03 20 1 35s198ms 35s198ms [ User: a3dsupervisor - Total duration: 2m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m56s - 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-01 18:36:40 Duration: 35s968ms 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-02 18:36:28 Duration: 35s727ms 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-09-30 18:35:51 Duration: 35s641ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2m52s 5 31s196ms 37s942ms 34s502ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 20 1 31s196ms 31s196ms Sep 30 20 1 35s105ms 35s105ms Oct 01 20 1 35s164ms 35s164ms Oct 02 20 1 33s105ms 33s105ms Oct 03 20 1 37s942ms 37s942ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m52s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-03 18:30:09 Duration: 37s942ms 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-01 18:38:17 Duration: 35s164ms 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-09-30 18:37:22 Duration: 35s105ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2m41s 5 26s49ms 35s693ms 32s350ms 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 #16
Day Hour Count Duration Avg duration Sep 29 20 1 33s835ms 33s835ms Sep 30 20 1 33s862ms 33s862ms Oct 01 20 1 32s310ms 32s310ms Oct 02 20 1 26s49ms 26s49ms Oct 03 20 1 35s693ms 35s693ms [ User: a3dsupervisor - Total duration: 2m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m41s - 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-03 18:32:41 Duration: 35s693ms 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-09-30 18:39:48 Duration: 33s862ms 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-09-29 18:39:56 Duration: 33s835ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2m18s 11 6s130ms 45s377ms 12s571ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 09 1 45s377ms 45s377ms 10 1 6s130ms 6s130ms 11 1 10s513ms 10s513ms 12 1 7s921ms 7s921ms 17 1 8s665ms 8s665ms 18 1 11s84ms 11s84ms Sep 30 09 1 8s930ms 8s930ms 12 1 9s122ms 9s122ms 14 1 10s937ms 10s937ms 15 1 7s717ms 7s717ms 16 1 11s888ms 11s888ms [ User: a3dsupervisor - Total duration: 2m18s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m18s - Times executed: 11 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-29 07:54:06 Duration: 45s377ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-30 14:35:44 Duration: 11s888ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-29 16:17:45 Duration: 11s84ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 2m16s 11 9s30ms 42s891ms 12s448ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 09 1 42s891ms 42s891ms 10 1 9s30ms 9s30ms 11 1 9s160ms 9s160ms 12 1 9s381ms 9s381ms 17 1 9s182ms 9s182ms 18 1 9s117ms 9s117ms Sep 30 09 1 11s488ms 11s488ms 12 1 9s81ms 9s81ms 14 1 9s234ms 9s234ms 15 1 9s200ms 9s200ms 16 1 9s168ms 9s168ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m16s - Times executed: 11 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-29 07:35:52 Duration: 42s891ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-30 07:53:22 Duration: 11s488ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-29 10:28:32 Duration: 9s381ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 2m10s 5 24s195ms 30s479ms 26s43ms 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 #19
Day Hour Count Duration Avg duration Sep 29 20 1 24s380ms 24s380ms Sep 30 20 1 25s130ms 25s130ms Oct 01 20 1 30s479ms 30s479ms Oct 02 20 1 26s34ms 26s34ms Oct 03 20 1 24s195ms 24s195ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m10s - 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-01 18:37:11 Duration: 30s479ms 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-02 18:36:55 Duration: 26s34ms 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-09-30 18:36:16 Duration: 25s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2m1s 11 6s224ms 38s126ms 11s26ms 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 (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 09 1 38s126ms 38s126ms 10 1 8s960ms 8s960ms 11 1 8s786ms 8s786ms 12 1 10s649ms 10s649ms 17 1 8s368ms 8s368ms 18 1 6s542ms 6s542ms Sep 30 10 1 6s224ms 6s224ms 12 1 10s361ms 10s361ms 14 1 7s667ms 7s667ms 15 1 6s969ms 6s969ms 16 1 8s633ms 8s633ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m1s - Times executed: 11 ]
-
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('202001020755', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101020755', '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-09-29 07:56:05 Duration: 38s126ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-29 10:35:27 Duration: 10s649ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-30 10:35:20 Duration: 10s361ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 56 22m54s 5s4ms 6m23s 24s544ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 08 8 46s376ms 5s797ms 09 6 15m44s 2m37s Sep 30 08 2 10s994ms 5s497ms 09 1 5s112ms 5s112ms 10 1 2m30s 2m30s 20 1 6s3ms 6s3ms Oct 01 09 3 19s829ms 6s609ms 21 4 24s570ms 6s142ms Oct 02 08 4 22s40ms 5s510ms 09 17 1m34s 5s551ms 21 1 5s35ms 5s35ms Oct 03 08 2 10s551ms 5s275ms 09 4 23s652ms 5s913ms 20 1 5s42ms 5s42ms 21 1 5s919ms 5s919ms [ User: a3dsupervisor - Total duration: 22m54s - Times executed: 56 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22m43s - Times executed: 54 ]
[ Application: pg_restore - Total duration: 11s45ms - Times executed: 2 ]
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 6m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 4m34s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 2m49s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 13 8m 5s71ms 1m14s 36s970ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 09 1 24s148ms 24s148ms 18 1 51s880ms 51s880ms Sep 30 09 1 27s614ms 27s614ms 10 1 1m3s 1m3s 12 1 56s884ms 56s884ms 14 1 1m14s 1m14s 15 1 1m5s 1m5s 16 1 53s581ms 53s581ms Oct 01 11 1 6s993ms 6s993ms Oct 02 08 1 25s67ms 25s67ms 20 1 5s71ms 5s71ms Oct 03 09 1 20s116ms 20s116ms 20 1 5s500ms 5s500ms [ User: a3dsupervisor - Total duration: 8m - Times executed: 13 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m - Times executed: 13 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-30 12:54:14 Duration: 1m14s 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-09-30 13:41:12 Duration: 1m5s 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-09-30 08:03:34 Duration: 1m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 11 51m4s 4m1s 8m50s 4m38s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 09 1 8m50s 8m50s 10 1 4m1s 4m1s 11 1 4m6s 4m6s 12 1 4m7s 4m7s 17 1 4m14s 4m14s 18 1 4m11s 4m11s Sep 30 09 1 4m24s 4m24s 12 1 4m14s 4m14s 14 1 4m1s 4m1s 15 1 4m4s 4m4s 16 1 4m43s 4m43s [ User: a3dsupervisor - Total duration: 51m4s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51m4s - Times executed: 11 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-29 07:45:04 Duration: 8m50s 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-09-30 14:33:34 Duration: 4m43s 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-09-30 07:58:00 Duration: 4m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 11 2m18s 6s130ms 45s377ms 12s571ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 09 1 45s377ms 45s377ms 10 1 6s130ms 6s130ms 11 1 10s513ms 10s513ms 12 1 7s921ms 7s921ms 17 1 8s665ms 8s665ms 18 1 11s84ms 11s84ms Sep 30 09 1 8s930ms 8s930ms 12 1 9s122ms 9s122ms 14 1 10s937ms 10s937ms 15 1 7s717ms 7s717ms 16 1 11s888ms 11s888ms [ User: a3dsupervisor - Total duration: 2m18s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m18s - Times executed: 11 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-29 07:54:06 Duration: 45s377ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-30 14:35:44 Duration: 11s888ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-29 16:17:45 Duration: 11s84ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 11 2m16s 9s30ms 42s891ms 12s448ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 09 1 42s891ms 42s891ms 10 1 9s30ms 9s30ms 11 1 9s160ms 9s160ms 12 1 9s381ms 9s381ms 17 1 9s182ms 9s182ms 18 1 9s117ms 9s117ms Sep 30 09 1 11s488ms 11s488ms 12 1 9s81ms 9s81ms 14 1 9s234ms 9s234ms 15 1 9s200ms 9s200ms 16 1 9s168ms 9s168ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m16s - Times executed: 11 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-29 07:35:52 Duration: 42s891ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-30 07:53:22 Duration: 11s488ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-29 10:28:32 Duration: 9s381ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 11 2m1s 6s224ms 38s126ms 11s26ms 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 (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 09 1 38s126ms 38s126ms 10 1 8s960ms 8s960ms 11 1 8s786ms 8s786ms 12 1 10s649ms 10s649ms 17 1 8s368ms 8s368ms 18 1 6s542ms 6s542ms Sep 30 10 1 6s224ms 6s224ms 12 1 10s361ms 10s361ms 14 1 7s667ms 7s667ms 15 1 6s969ms 6s969ms 16 1 8s633ms 8s633ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m1s - Times executed: 11 ]
-
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('202001020755', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101020755', '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-09-29 07:56:05 Duration: 38s126ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-29 10:35:27 Duration: 10s649ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-30 10:35:20 Duration: 10s361ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 6 5m 7s419ms 3m41s 50s60ms select distinct (server_id) from gtp_log_ehcache;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 29 09 1 3m41s 3m41s 10 1 21s727ms 21s727ms 12 1 29s984ms 29s984ms 17 1 12s39ms 12s39ms Sep 30 14 1 7s867ms 7s867ms 16 1 7s419ms 7s419ms [ User: a3dsupervisor - Total duration: 5m - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m - Times executed: 6 ]
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 07:53:21 Duration: 3m41s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 10:34:42 Duration: 29s984ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 08:44:27 Duration: 21s727ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 6 1m53s 7s533ms 32s879ms 18s854ms select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 09 1 11s787ms 11s787ms Sep 30 12 2 40s412ms 20s206ms 14 1 19s103ms 19s103ms 15 1 21s331ms 21s331ms 16 1 20s495ms 20s495ms [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m53s - Times executed: 6 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 10:32:57 Duration: 32s879ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 13:35:59 Duration: 21s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 14:34:02 Duration: 20s495ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 6 46s363ms 5s465ms 11s590ms 7s727ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 09 1 6s108ms 6s108ms Sep 30 08 1 11s590ms 11s590ms 09 1 8s555ms 8s555ms Oct 02 08 2 12s854ms 6s427ms Oct 03 08 1 7s255ms 7s255ms [ User: a3dsupervisor - Total duration: 46s363ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 46s363ms - Times executed: 6 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-30 06:57:02 Duration: 11s590ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-30 07:04:41 Duration: 8s555ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-10-02 06:55:01 Duration: 7s389ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 5 9m52s 1m31s 2m23s 1m58s vacuum analyse;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 20 1 2m15s 2m15s Sep 30 20 1 2m23s 2m23s Oct 01 20 1 1m34s 1m34s Oct 02 20 1 1m31s 1m31s Oct 03 20 1 2m7s 2m7s [ User: a3dsupervisor - Total duration: 9m52s - Times executed: 5 ]
[ Application: psql - Total duration: 9m52s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-09-30 18:54:25 Duration: 2m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-29 18:54:03 Duration: 2m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-03 18:46:55 Duration: 2m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 6m15s 1m13s 1m16s 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;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 29 20 1 1m15s 1m15s Sep 30 20 1 1m16s 1m16s Oct 01 20 1 1m15s 1m15s Oct 02 20 1 1m15s 1m15s Oct 03 20 1 1m13s 1m13s [ User: a3dsupervisor - Total duration: 6m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m15s - 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-09-30 18:36:31 Duration: 1m16s 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-01 18:37:20 Duration: 1m15s 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-02 18:37:08 Duration: 1m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 5m11s 47s68ms 1m13s 1m2s call pack_gtp_trigger.p_trigger_del_line_att_tab (,);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 10 2 2m25s 1m12s 11 1 47s68ms 47s68ms 12 1 59s434ms 59s434ms 17 1 59s453ms 59s453ms [ User: a3dsupervisor - Total duration: 5m11s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m11s - Times executed: 5 ]
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 08:03:38 Duration: 1m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 08:48:23 Duration: 1m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 15:38:36 Duration: 59s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 5 3m11s 27s358ms 48s778ms 38s331ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 20 1 27s358ms 27s358ms Sep 30 20 1 30s227ms 30s227ms Oct 01 20 1 48s778ms 48s778ms Oct 02 20 1 45s202ms 45s202ms Oct 03 20 1 40s88ms 40s88ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-01 18:38:09 Duration: 48s778ms 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-02 18:37:53 Duration: 45s202ms 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-03 18:29:57 Duration: 40s88ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 3m7s 33s937ms 40s107ms 37s513ms 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 #14
Day Hour Count Duration Avg duration Sep 29 20 1 38s802ms 38s802ms Sep 30 20 1 38s659ms 38s659ms Oct 01 20 1 36s60ms 36s60ms Oct 02 20 1 33s937ms 33s937ms Oct 03 20 1 40s107ms 40s107ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m7s - 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-03 18:31:58 Duration: 40s107ms 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-09-29 18:39:07 Duration: 38s802ms 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-09-30 18:38:51 Duration: 38s659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 2m56s 34s372ms 35s968ms 35s381ms 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 #15
Day Hour Count Duration Avg duration Sep 29 20 1 34s372ms 34s372ms Sep 30 20 1 35s641ms 35s641ms Oct 01 20 1 35s968ms 35s968ms Oct 02 20 1 35s727ms 35s727ms Oct 03 20 1 35s198ms 35s198ms [ User: a3dsupervisor - Total duration: 2m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m56s - 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-01 18:36:40 Duration: 35s968ms 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-02 18:36:28 Duration: 35s727ms 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-09-30 18:35:51 Duration: 35s641ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 2m52s 31s196ms 37s942ms 34s502ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 20 1 31s196ms 31s196ms Sep 30 20 1 35s105ms 35s105ms Oct 01 20 1 35s164ms 35s164ms Oct 02 20 1 33s105ms 33s105ms Oct 03 20 1 37s942ms 37s942ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m52s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-03 18:30:09 Duration: 37s942ms 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-01 18:38:17 Duration: 35s164ms 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-09-30 18:37:22 Duration: 35s105ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 2m41s 26s49ms 35s693ms 32s350ms 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 #17
Day Hour Count Duration Avg duration Sep 29 20 1 33s835ms 33s835ms Sep 30 20 1 33s862ms 33s862ms Oct 01 20 1 32s310ms 32s310ms Oct 02 20 1 26s49ms 26s49ms Oct 03 20 1 35s693ms 35s693ms [ User: a3dsupervisor - Total duration: 2m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m41s - 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-03 18:32:41 Duration: 35s693ms 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-09-30 18:39:48 Duration: 33s862ms 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-09-29 18:39:56 Duration: 33s835ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 2m10s 24s195ms 30s479ms 26s43ms 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 #18
Day Hour Count Duration Avg duration Sep 29 20 1 24s380ms 24s380ms Sep 30 20 1 25s130ms 25s130ms Oct 01 20 1 30s479ms 30s479ms Oct 02 20 1 26s34ms 26s34ms Oct 03 20 1 24s195ms 24s195ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m10s - 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-01 18:37:11 Duration: 30s479ms 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-02 18:36:55 Duration: 26s34ms 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-09-30 18:36:16 Duration: 25s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 2m 13s540ms 33s884ms 24s69ms create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 20 1 13s581ms 13s581ms Sep 30 20 1 13s540ms 13s540ms Oct 01 20 1 31s1ms 31s1ms Oct 02 20 1 33s884ms 33s884ms Oct 03 20 1 28s337ms 28s337ms [ User: a3dsupervisor - Total duration: 2m - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-02 18:37:28 Duration: 33s884ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-01 18:37:42 Duration: 31s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-03 18:29:31 Duration: 28s337ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 1m51s 16s426ms 24s547ms 22s299ms 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 #20
Day Hour Count Duration Avg duration Sep 29 20 1 23s144ms 23s144ms Sep 30 20 1 24s547ms 24s547ms Oct 01 20 1 23s632ms 23s632ms Oct 02 20 1 16s426ms 16s426ms Oct 03 20 1 23s745ms 23s745ms [ User: a3dsupervisor - Total duration: 1m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m51s - 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-09-30 18:39:36 Duration: 24s547ms 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-03 18:32:23 Duration: 23s745ms 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-01 18:40:23 Duration: 23s632ms 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 8m48s 8m56s 8m52s 2 17m45s delete from gtp_workspace where workspace_num_id =;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 18 1 8m48s 8m48s Sep 30 10 1 8m56s 8m56s [ User: a3dsupervisor - Total duration: 17m45s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17m45s - Times executed: 2 ]
-
delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;
Date: 2025-09-30 08:17:13 Duration: 8m56s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;
Date: 2025-09-29 16:36:09 Duration: 8m48s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 6m24s 6m24s 6m24s 1 6m24s update log_session set session_status = where session_status = and server_id =;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 09 1 6m24s 6m24s [ User: a3dsupervisor - Total duration: 6m24s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m24s - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;
Date: 2025-09-29 07:45:04 Duration: 6m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 4m1s 8m50s 4m38s 11 51m4s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 09 1 8m50s 8m50s 10 1 4m1s 4m1s 11 1 4m6s 4m6s 12 1 4m7s 4m7s 17 1 4m14s 4m14s 18 1 4m11s 4m11s Sep 30 09 1 4m24s 4m24s 12 1 4m14s 4m14s 14 1 4m1s 4m1s 15 1 4m4s 4m4s 16 1 4m43s 4m43s [ User: a3dsupervisor - Total duration: 51m4s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51m4s - Times executed: 11 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-29 07:45:04 Duration: 8m50s 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-09-30 14:33:34 Duration: 4m43s 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-09-30 07:58:00 Duration: 4m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 3m37s 3m37s 3m37s 1 3m37s --liquibase formatted sql--changeset active3d:?.?.?.?-postgresql-optional-active3d_rqm-17843_init_batch_process dbms:postgresql encoding:utf-8 enddelimiter:/do $body$declare l_script_name constant text := ?;begin raise debug ?, l_script_name; -- ne pas supprimer cette ligne : initialisation de la validation du passage du script de post-installation insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); 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 = ?; insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid2, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_grpid, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_scnid, l_grpid, ?, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid||?, current_timestamp, ?, null, null); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid_2, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid2||?, current_timestamp, ?, null, null); exception when others then raise exception ?, 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 = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); raise notice ?, l_script_name;exception when others then call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); call pack_gtp_utils.p_trace_error(? || l_script_name, sqlerrm, ?); raise;end $body$;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 30 09 1 3m37s 3m37s [ User: a3dsupervisor - Total duration: 3m37s - Times executed: 1 ]
[ Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' - Total duration: 3m37s - Times executed: 1 ]
-
--liquibase formatted sql--changeset active3d:7.22.0.0-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 (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [START]', '7.22.0.0'); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval('s_batch_group_num_id') into l_grpId; select nextval('s_batch_scenario_num_id') into l_scnId; select nextval('s_batch_process_num_id') into l_processId; select nextval('s_batch_process_num_id') into l_processId_2; select nextval('s_mapping_num_id') into l_mappingId; select nextval('s_mapping_num_id') into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId, '02.01_batch01', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch01'); INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId2, '02.01_batch02', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch02'); INSERT INTO batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_grpId, '02_group', '02_group', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_scnId, l_grpId, '02_scenario_01', '02_scenario_01', '', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId, l_scnId, '02.01_batch01', '02.01_batch01', 8, 1, '', '{"mappingNumId":'||l_mappingId||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId_2, l_scnId, '02.01_batch02', '02.01_batch02', 8, 2, '', '{"mappingNumId":'||l_mappingId2||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); 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 = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [SUCCESS]', '7.22.0.0'); raise notice 'END %', L_SCRIPT_NAME;EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [ERROR]', '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.22.0.0'); RAISE;END $body$;
Date: 2025-09-30 07:58:00 Duration: 3m37s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' Bind query: yes
5 3m2s 3m2s 3m2s 1 3m2s insert into batch_process (batch_process_comment, creation_date, creator_num_id, batch_process_execution_order, modification_date, modifier_num_id, batch_process_name, batch_scenario_num_id, batch_process_settings, batch_process_type_code, batch_process_unique_code, batch_process_num_id) values (,,,,,,,,,,,);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 30 12 1 3m2s 3m2s [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m2s - Times executed: 1 ]
-
insert into BATCH_PROCESS (BATCH_PROCESS_COMMENT, CREATION_DATE, CREATOR_NUM_ID, BATCH_PROCESS_EXECUTION_ORDER, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_PROCESS_NAME, BATCH_SCENARIO_NUM_ID, BATCH_PROCESS_SETTINGS, BATCH_PROCESS_TYPE_CODE, BATCH_PROCESS_UNIQUE_CODE, BATCH_PROCESS_NUM_ID) values (,,,,,,,,,,,);
Date: 2025-09-30 10:32:17 Duration: 3m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1m31s 2m23s 1m58s 5 9m52s vacuum analyse;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 20 1 2m15s 2m15s Sep 30 20 1 2m23s 2m23s Oct 01 20 1 1m34s 1m34s Oct 02 20 1 1m31s 1m31s Oct 03 20 1 2m7s 2m7s [ User: a3dsupervisor - Total duration: 9m52s - Times executed: 5 ]
[ Application: psql - Total duration: 9m52s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-09-30 18:54:25 Duration: 2m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-29 18:54:03 Duration: 2m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-03 18:46:55 Duration: 2m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1m13s 1m16s 1m15s 5 6m15s 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 Sep 29 20 1 1m15s 1m15s Sep 30 20 1 1m16s 1m16s Oct 01 20 1 1m15s 1m15s Oct 02 20 1 1m15s 1m15s Oct 03 20 1 1m13s 1m13s [ User: a3dsupervisor - Total duration: 6m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m15s - 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-09-30 18:36:31 Duration: 1m16s 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-01 18:37:20 Duration: 1m15s 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-02 18:37:08 Duration: 1m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 47s68ms 1m13s 1m2s 5 5m11s call pack_gtp_trigger.p_trigger_del_line_att_tab (,);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 10 2 2m25s 1m12s 11 1 47s68ms 47s68ms 12 1 59s434ms 59s434ms 17 1 59s453ms 59s453ms [ User: a3dsupervisor - Total duration: 5m11s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m11s - Times executed: 5 ]
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 08:03:38 Duration: 1m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 08:48:23 Duration: 1m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-29 15:38:36 Duration: 59s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 7s419ms 3m41s 50s60ms 6 5m select distinct (server_id) from gtp_log_ehcache;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 09 1 3m41s 3m41s 10 1 21s727ms 21s727ms 12 1 29s984ms 29s984ms 17 1 12s39ms 12s39ms Sep 30 14 1 7s867ms 7s867ms 16 1 7s419ms 7s419ms [ User: a3dsupervisor - Total duration: 5m - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m - Times executed: 6 ]
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 07:53:21 Duration: 3m41s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 10:34:42 Duration: 29s984ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-29 08:44:27 Duration: 21s727ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 27s358ms 48s778ms 38s331ms 5 3m11s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 20 1 27s358ms 27s358ms Sep 30 20 1 30s227ms 30s227ms Oct 01 20 1 48s778ms 48s778ms Oct 02 20 1 45s202ms 45s202ms Oct 03 20 1 40s88ms 40s88ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-01 18:38:09 Duration: 48s778ms 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-02 18:37:53 Duration: 45s202ms 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-03 18:29:57 Duration: 40s88ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 33s937ms 40s107ms 37s513ms 5 3m7s 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 #11
Day Hour Count Duration Avg duration Sep 29 20 1 38s802ms 38s802ms Sep 30 20 1 38s659ms 38s659ms Oct 01 20 1 36s60ms 36s60ms Oct 02 20 1 33s937ms 33s937ms Oct 03 20 1 40s107ms 40s107ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m7s - 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-03 18:31:58 Duration: 40s107ms 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-09-29 18:39:07 Duration: 38s802ms 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-09-30 18:38:51 Duration: 38s659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5s71ms 1m14s 36s970ms 13 8m delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 09 1 24s148ms 24s148ms 18 1 51s880ms 51s880ms Sep 30 09 1 27s614ms 27s614ms 10 1 1m3s 1m3s 12 1 56s884ms 56s884ms 14 1 1m14s 1m14s 15 1 1m5s 1m5s 16 1 53s581ms 53s581ms Oct 01 11 1 6s993ms 6s993ms Oct 02 08 1 25s67ms 25s67ms 20 1 5s71ms 5s71ms Oct 03 09 1 20s116ms 20s116ms 20 1 5s500ms 5s500ms [ User: a3dsupervisor - Total duration: 8m - Times executed: 13 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m - Times executed: 13 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-30 12:54:14 Duration: 1m14s 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-09-30 13:41:12 Duration: 1m5s 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-09-30 08:03:34 Duration: 1m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 34s372ms 35s968ms 35s381ms 5 2m56s 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 #13
Day Hour Count Duration Avg duration Sep 29 20 1 34s372ms 34s372ms Sep 30 20 1 35s641ms 35s641ms Oct 01 20 1 35s968ms 35s968ms Oct 02 20 1 35s727ms 35s727ms Oct 03 20 1 35s198ms 35s198ms [ User: a3dsupervisor - Total duration: 2m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m56s - 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-01 18:36:40 Duration: 35s968ms 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-02 18:36:28 Duration: 35s727ms 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-09-30 18:35:51 Duration: 35s641ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 31s196ms 37s942ms 34s502ms 5 2m52s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 29 20 1 31s196ms 31s196ms Sep 30 20 1 35s105ms 35s105ms Oct 01 20 1 35s164ms 35s164ms Oct 02 20 1 33s105ms 33s105ms Oct 03 20 1 37s942ms 37s942ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m52s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-03 18:30:09 Duration: 37s942ms 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-01 18:38:17 Duration: 35s164ms 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-09-30 18:37:22 Duration: 35s105ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 26s49ms 35s693ms 32s350ms 5 2m41s 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 #15
Day Hour Count Duration Avg duration Sep 29 20 1 33s835ms 33s835ms Sep 30 20 1 33s862ms 33s862ms Oct 01 20 1 32s310ms 32s310ms Oct 02 20 1 26s49ms 26s49ms Oct 03 20 1 35s693ms 35s693ms [ User: a3dsupervisor - Total duration: 2m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m41s - 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-03 18:32:41 Duration: 35s693ms 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-09-30 18:39:48 Duration: 33s862ms 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-09-29 18:39:56 Duration: 33s835ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 24s195ms 30s479ms 26s43ms 5 2m10s 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 #16
Day Hour Count Duration Avg duration Sep 29 20 1 24s380ms 24s380ms Sep 30 20 1 25s130ms 25s130ms Oct 01 20 1 30s479ms 30s479ms Oct 02 20 1 26s34ms 26s34ms Oct 03 20 1 24s195ms 24s195ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m10s - 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-01 18:37:11 Duration: 30s479ms 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-02 18:36:55 Duration: 26s34ms 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-09-30 18:36:16 Duration: 25s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5s4ms 6m23s 24s544ms 56 22m54s commit;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 08 8 46s376ms 5s797ms 09 6 15m44s 2m37s Sep 30 08 2 10s994ms 5s497ms 09 1 5s112ms 5s112ms 10 1 2m30s 2m30s 20 1 6s3ms 6s3ms Oct 01 09 3 19s829ms 6s609ms 21 4 24s570ms 6s142ms Oct 02 08 4 22s40ms 5s510ms 09 17 1m34s 5s551ms 21 1 5s35ms 5s35ms Oct 03 08 2 10s551ms 5s275ms 09 4 23s652ms 5s913ms 20 1 5s42ms 5s42ms 21 1 5s919ms 5s919ms [ User: a3dsupervisor - Total duration: 22m54s - Times executed: 56 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22m43s - Times executed: 54 ]
[ Application: pg_restore - Total duration: 11s45ms - Times executed: 2 ]
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 6m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 4m34s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 07:45:04 Duration: 2m49s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 13s540ms 33s884ms 24s69ms 5 2m create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 20 1 13s581ms 13s581ms Sep 30 20 1 13s540ms 13s540ms Oct 01 20 1 31s1ms 31s1ms Oct 02 20 1 33s884ms 33s884ms Oct 03 20 1 28s337ms 28s337ms [ User: a3dsupervisor - Total duration: 2m - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-02 18:37:28 Duration: 33s884ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-01 18:37:42 Duration: 31s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-03 18:29:31 Duration: 28s337ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 16s426ms 24s547ms 22s299ms 5 1m51s 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 #19
Day Hour Count Duration Avg duration Sep 29 20 1 23s144ms 23s144ms Sep 30 20 1 24s547ms 24s547ms Oct 01 20 1 23s632ms 23s632ms Oct 02 20 1 16s426ms 16s426ms Oct 03 20 1 23s745ms 23s745ms [ User: a3dsupervisor - Total duration: 1m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m51s - 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-09-30 18:39:36 Duration: 24s547ms 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-03 18:32:23 Duration: 23s745ms 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-01 18:40:23 Duration: 23s632ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 7s533ms 32s879ms 18s854ms 6 1m53s select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 09 1 11s787ms 11s787ms Sep 30 12 2 40s412ms 20s206ms 14 1 19s103ms 19s103ms 15 1 21s331ms 21s331ms 16 1 20s495ms 20s495ms [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m53s - Times executed: 6 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 10:32:57 Duration: 32s879ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 13:35:59 Duration: 21s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 14:34:02 Duration: 20s495ms 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 NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s501ms 1 5s501ms 5s501ms 5s501ms select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 04 09 1 5s501ms 5s501ms [ User: a3dsupervisor - Total duration: 5s41ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s41ms - Times executed: 1 ]
-
select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);
Date: 2025-10-02 07:02:42 Duration: 5s501ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 21,886 Log entries
Events distribution
Key values
- 0 PANIC entries
- 3 FATAL entries
- 6952 ERROR entries
- 154 WARNING entries
Most Frequent Errors/Events
Key values
- 4,781 Max number of times the same event was reported
- 7,109 Total events found
Rank Times reported Error 1 4,781 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 29 21 92 22 376 23 95 00 416 01 1 Sep 30 21 95 22 370 23 91 00 310 Oct 01 21 100 22 516 23 42 00 286 01 30 Oct 02 02 1 03 1 21 94 22 489 23 104 00 208 01 157 Oct 03 02 2 03 1 21 97 22 368 23 98 00 314 01 23 Oct 04 02 3 04 1 2 850 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 13 838 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 Oct 02 09 1 3 838 ERROR: canceling statement due to lock timeoutselect LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 29 13 838 4 172 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 29 09 4 10 8 11 3 12 2 13 3 17 4 18 3 19 7 Sep 30 10 3 11 6 13 2 17 2 19 3 Oct 01 14 3 15 5 18 15 19 8 Oct 02 09 2 11 8 12 6 13 2 14 6 15 2 16 2 17 2 19 3 Oct 03 09 2 13 7 14 8 16 2 17 19 18 14 19 3 Oct 04 19 3 5 88 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 29 09 8 10 8 11 8 12 8 17 8 18 8 Sep 30 09 8 12 8 14 8 15 8 16 8 6 66 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 29 09 6 10 6 11 6 12 6 17 6 18 6 Sep 30 09 6 12 6 14 6 15 6 16 6 7 22 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 29 09 2 10 2 11 2 12 2 17 2 18 2 Sep 30 09 2 12 2 14 2 15 2 16 2 8 13 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 29 09 4 10 4 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 9 11 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 #9
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 10 11 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 #10
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 11 11 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 12 11 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 13 11 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 14 11 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 15 11 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 #15
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 16 11 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 #16
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 17 11 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 #17
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 18 11 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #18
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 19 11 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #19
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 20 11 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 #20
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 21 11 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #21
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 22 11 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #22
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 23 11 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #23
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 24 11 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #24
Day Hour Count Sep 29 09 1 10 1 11 1 12 1 17 1 18 1 Sep 30 09 1 12 1 14 1 15 1 16 1 25 10 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #25
Day Hour Count Sep 29 20 3 Sep 30 20 2 Oct 01 20 2 Oct 02 20 1 Oct 03 20 2 26 10 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 #26
Day Hour Count Sep 30 12 1 14 2 15 3 16 4 27 6 LOG: process ... still waiting for ShareLock on transaction ... after ... msCOMMIT
Times Reported Most Frequent Error / Event #27
Day Hour Count Sep 29 09 5 Sep 30 10 1 28 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #28
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 29 5 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 #29
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 30 5 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 #30
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 31 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #31
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 32 5 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 #32
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 33 5 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 #33
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 34 5 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 #34
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 35 5 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 #35
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 36 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #36
Day Hour Count Sep 29 20 1 Sep 30 20 1 Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 37 3 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #37
Day Hour Count Oct 01 20 1 Oct 02 20 1 Oct 03 20 1 38 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition
Times Reported Most Frequent Error / Event #38
Day Hour Count Sep 29 20 1 Oct 02 20 1 39 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms--liquibase formatted sql --changeset active3d:7.22.0.0-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 = '7.22.0.0'; 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 #39
Day Hour Count Sep 30 09 2 40 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 #40
Day Hour Count Oct 01 08 2 41 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (...) REFERENCES public.gtp_rel_template(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #41
Day Hour Count Oct 01 20 1 Oct 03 20 1 42 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msinsert into BATCH_PROCESS (...) values (...)
Times Reported Most Frequent Error / Event #42
Day Hour Count Sep 30 12 2 43 2 FATAL: connection to client lostdelete from GTP_WORKSPACE where WORKSPACE_NUM_ID=
Times Reported Most Frequent Error / Event #43
Day Hour Count Sep 29 18 1 Sep 30 10 1 44 2 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 #44
Day Hour Count Sep 29 20 1 Sep 30 20 1 45 2 LOG: could not send data to client: Connection reset by peerdelete from GTP_WORKSPACE where WORKSPACE_NUM_ID=
Times Reported Most Frequent Error / Event #45
Day Hour Count Sep 29 18 1 Sep 30 10 1 46 2 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #46
Day Hour Count Sep 29 20 1 Oct 01 20 1 47 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msUPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =
Times Reported Most Frequent Error / Event #47
Day Hour Count Sep 29 09 1 48 1 ERROR: canceling statement due to lock timeoutSELECT BATCH_PROCESS_NUM_ID FROM BATCH_PROCESS WHERE BATCH_PROCESS_NUM_ID IN (...) FOR UPDATE
Times Reported Most Frequent Error / Event #48
Day Hour Count Oct 02 09 1 49 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #49
Day Hour Count Sep 29 20 1 50 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate gtp_cache_host set last_seen = current_timestamp where host = and port =
Times Reported Most Frequent Error / Event #50
Day Hour Count Sep 29 10 1 51 1 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
Times Reported Most Frequent Error / Event #51
Day Hour Count Oct 02 21 1 52 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #52
Day Hour Count Oct 03 10 1 53 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_obj FOREIGN KEY (...) REFERENCES public.gtp_obj(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #53
Day Hour Count Oct 01 20 1 54 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #54
Day Hour Count Sep 29 12 1 55 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #55
Day Hour Count Sep 29 10 1 56 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate BATCH_PROCESS set BATCH_PROCESS_COMMENT=,CREATION_DATE=,CREATOR_NUM_ID=,BATCH_PROCESS_EXECUTION_ORDER=,MODIFICATION_DATE=,MODIFIER_NUM_ID=,BATCH_PROCESS_NAME=,BATCH_SCENARIO_NUM_ID=,BATCH_PROCESS_SETTINGS=,BATCH_PROCESS_TYPE_CODE=,BATCH_PROCESS_UNIQUE_CODE= where BATCH_PROCESS_NUM_ID=
Times Reported Most Frequent Error / Event #56
Day Hour Count Sep 29 10 1 57 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msSELECT BATCH_PROCESS_NUM_ID FROM BATCH_PROCESS WHERE BATCH_PROCESS_NUM_ID IN (...) FOR UPDATE
Times Reported Most Frequent Error / Event #57
Day Hour Count Oct 02 09 1