pgBadger-
Global information
- Generated on Mon Nov 10 09:35:55 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=08/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=08/h=23/m=00/PT1H.log
- Parsed 51,757 log entries in 1m1s
- Log start from 2025-11-03 18:01:49 to 2025-11-08 18:01:12
-
Overview
Global Stats
- 41 Number of unique normalized queries
- 196 Number of queries
- 43m15s Total query duration
- 2025-11-03 07:15:41 First query
- 2025-11-07 20:56:25 Last query
- 3 queries/s at 2025-11-07 07:56:25 Query peak
- 43m15s Total query duration
- 11s271ms Prepare/parse total duration
- 6s757ms Bind total duration
- 42m57s Execute total duration
- 19,503 Number of events
- 18 Number of unique normalized events
- 19,193 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,038 Number temporary file
- 3.51 GiB Max size of temporary file
- 23.52 MiB Average size of temporary file
- 3,773 Total number of sessions
- 150 sessions at 2025-11-02 17:49:05 Session peak
- 11d22h11m37s Total duration of sessions
- 4m33s Average duration of sessions
- 0 Average queries per session
- 687ms Average queries duration per session
- 4m32s Average idle time per session
- 3,771 Total number of connections
- 12 connections/s at 2025-11-04 20:29:47 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-07 07:56:25 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-07 07:56:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-04 08:00:19 Date
Queries duration
Key values
- 43m15s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 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 0 0ms 0ms 0ms 0ms 0ms 0ms 07 13 0ms 12s326ms 7s701ms 24s629ms 25s917ms 28s871ms 08 4 0ms 13s181ms 8s148ms 0ms 10s932ms 21s661ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 27 0ms 49s830ms 15s62ms 49s830ms 53s968ms 55s47ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 04 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 6 0ms 7s94ms 5s932ms 10s473ms 12s535ms 12s583ms 08 7 0ms 12s454ms 7s737ms 10s137ms 11s228ms 32s794ms 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 2 0ms 6s388ms 6s387ms 0ms 12s774ms 12s774ms 20 27 0ms 54s669ms 14s730ms 48s403ms 54s669ms 1m 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 05 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 1 0ms 6s380ms 6s380ms 0ms 0ms 6s380ms 08 1 0ms 13s964ms 13s964ms 0ms 13s964ms 13s964ms 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 25 0ms 1m11s 16s695ms 55s278ms 1m2s 1m11s 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 06 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 7 0ms 9s407ms 7s64ms 0ms 10s764ms 38s688ms 08 7 0ms 14s253ms 6s737ms 5s235ms 14s253ms 22s585ms 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 2 0ms 9s522ms 9s520ms 0ms 19s40ms 19s40ms 20 24 0ms 1m10s 16s498ms 49s585ms 1m7s 1m10s 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 07 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 9 0ms 8s475ms 7s550ms 14s539ms 16s896ms 23s106ms 08 6 0ms 6s393ms 6s111ms 0ms 11s383ms 25s282ms 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 1 0ms 5s321ms 5s321ms 0ms 5s321ms 5s321ms 20 27 0ms 1m19s 17s715ms 59s220ms 1m5s 1m19s 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 08 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 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 Nov 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 Nov 04 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 Nov 05 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 Nov 06 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 2 0 8s989ms 0ms 0ms 17s978ms 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 Nov 07 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 2 0 7s498ms 0ms 0ms 14s996ms 08 1 0 6s248ms 0ms 0ms 6s248ms 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 Nov 08 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 Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 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 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 Nov 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 0 0 0 0ms 0ms 0ms 0ms 07 1 0 0 0 5s702ms 0ms 0ms 5s702ms 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 1 0 20s172ms 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 Nov 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 1 0 5s441ms 0ms 0ms 5s441ms 08 1 0 0 0 5s12ms 0ms 0ms 5s12ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 1 0 18s360ms 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 Nov 05 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 1 0 0 13s964ms 0ms 0ms 13s964ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 1 0 22s140ms 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 Nov 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 0 0 9s407ms 0ms 0ms 9s407ms 08 0 1 0 0 14s253ms 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 1 0 19s636ms 0ms 0ms 19s636ms 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 Nov 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 0 0 8s109ms 0ms 0ms 0ms 08 0 0 1 0 6s253ms 0ms 0ms 6s253ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 1 0 33s555ms 0ms 0ms 33s555ms 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 Nov 08 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 Nov 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 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 0 0.00 0.00% 07 0 13 13.00 0.00% 08 0 4 4.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 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 04 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 6 6.00 0.00% 08 0 7 7.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 2 2.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 05 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 1 1.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 06 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 7 7.00 0.00% 08 1 7 7.00 14.29% 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 2 2.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 07 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 1 9 9.00 12.50% 08 0 6 6.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 1 1.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 08 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 02 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 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 22 2 0.00/s 23 2 0.00/s Nov 03 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 2 0.00/s 06 15 0.00/s 07 18 0.01/s 08 22 0.01/s 09 6 0.00/s 10 10 0.00/s 11 10 0.00/s 12 6 0.00/s 13 19 0.01/s 14 12 0.00/s 15 12 0.00/s 16 13 0.00/s 17 6 0.00/s 18 5 0.00/s 19 9 0.00/s 20 365 0.10/s 21 64 0.02/s 22 25 0.01/s 23 6 0.00/s Nov 04 00 13 0.00/s 01 11 0.00/s 02 13 0.00/s 03 17 0.00/s 04 11 0.00/s 05 8 0.00/s 06 9 0.00/s 07 25 0.01/s 08 21 0.01/s 09 14 0.00/s 10 7 0.00/s 11 5 0.00/s 12 12 0.00/s 13 14 0.00/s 14 23 0.01/s 15 16 0.00/s 16 5 0.00/s 17 6 0.00/s 18 7 0.00/s 19 24 0.01/s 20 391 0.11/s 21 8 0.00/s 22 12 0.00/s 23 14 0.00/s Nov 05 00 14 0.00/s 01 15 0.00/s 02 17 0.00/s 03 14 0.00/s 04 17 0.00/s 05 16 0.00/s 06 12 0.00/s 07 23 0.01/s 08 22 0.01/s 09 9 0.00/s 10 15 0.00/s 11 11 0.00/s 12 18 0.01/s 13 11 0.00/s 14 11 0.00/s 15 13 0.00/s 16 9 0.00/s 17 14 0.00/s 18 9 0.00/s 19 24 0.01/s 20 370 0.10/s 21 33 0.01/s 22 12 0.00/s 23 10 0.00/s Nov 06 00 17 0.00/s 01 11 0.00/s 02 4 0.00/s 03 15 0.00/s 04 6 0.00/s 05 12 0.00/s 06 12 0.00/s 07 21 0.01/s 08 24 0.01/s 09 13 0.00/s 10 9 0.00/s 11 16 0.00/s 12 17 0.00/s 13 22 0.01/s 14 15 0.00/s 15 4 0.00/s 16 10 0.00/s 17 10 0.00/s 18 5 0.00/s 19 22 0.01/s 20 353 0.10/s 21 52 0.01/s 22 19 0.01/s 23 14 0.00/s Nov 07 00 20 0.01/s 01 15 0.00/s 02 12 0.00/s 03 7 0.00/s 04 11 0.00/s 05 11 0.00/s 06 9 0.00/s 07 27 0.01/s 08 27 0.01/s 09 8 0.00/s 10 13 0.00/s 11 11 0.00/s 12 15 0.00/s 13 16 0.00/s 14 38 0.01/s 15 8 0.00/s 16 15 0.00/s 17 6 0.00/s 18 10 0.00/s 19 12 0.00/s 20 333 0.09/s 21 84 0.02/s 22 11 0.00/s 23 20 0.01/s Nov 08 00 26 0.01/s 01 12 0.00/s 02 15 0.00/s 03 13 0.00/s 04 16 0.00/s 05 17 0.00/s 06 8 0.00/s 07 10 0.00/s 08 10 0.00/s 09 14 0.00/s 10 9 0.00/s 11 10 0.00/s 12 8 0.00/s 13 10 0.00/s 14 14 0.00/s 15 11 0.00/s 16 9 0.00/s 17 8 0.00/s 18 6 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Nov 02 00 2 73ms 73ms 01 2 78ms 78ms 02 2 77ms 77ms 03 2 73ms 73ms 04 2 75ms 75ms 05 2 78ms 78ms 06 2 73ms 73ms 07 2 74ms 74ms 08 2 85ms 85ms 09 2 77ms 77ms 10 2 76ms 76ms 11 2 80ms 80ms 12 2 73ms 73ms 13 2 136ms 136ms 14 2 74ms 74ms 15 2 86ms 86ms 16 2 81ms 81ms 17 2 74ms 74ms 18 2 81ms 81ms 19 2 105ms 105ms 20 2 76ms 76ms 21 2 71ms 71ms 22 2 73ms 73ms 23 2 76ms 76ms Nov 03 00 2 73ms 73ms 01 2 79ms 79ms 02 2 78ms 78ms 03 2 72ms 72ms 04 2 74ms 74ms 05 2 74ms 74ms 06 13 1m19s 1m19s 07 18 1m23s 1m18s 08 23 5m38s 5m36s 09 6 56s991ms 56s991ms 10 10 19s569ms 19s569ms 11 10 50s888ms 50s888ms 12 6 57s694ms 57s694ms 13 19 17s391ms 17s391ms 14 12 47s532ms 47s532ms 15 12 54s904ms 54s904ms 16 13 57s968ms 57s968ms 17 6 57s734ms 57s734ms 18 5 4h15m52s 4h15m52s 19 11 19m27s 19m27s 20 363 6s634ms 5s513ms 21 62 1m5s 1m5s 22 27 1m23s 1m23s 23 6 1m6s 1m6s Nov 04 00 13 58s804ms 58s804ms 01 11 1m11s 1m11s 02 13 1m11s 1m11s 03 16 1m5s 1m5s 04 12 54s426ms 54s426ms 05 8 51s947ms 51s947ms 06 9 50s651ms 50s651ms 07 24 1m36s 1m35s 08 22 1m56s 1m54s 09 11 58s869ms 58s869ms 10 10 55s621ms 55s621ms 11 5 51s561ms 51s561ms 12 12 1m9s 1m9s 13 14 1h10m44s 1h10m44s 14 23 37s174ms 37s174ms 15 12 1h46m58s 1h46m58s 16 9 1m4s 1m4s 17 6 23m21s 23m21s 18 7 21m44s 21m44s 19 26 9m9s 9m8s 20 389 7s790ms 6s768ms 21 8 1m18s 1m18s 22 12 57s481ms 57s481ms 23 14 1m12s 1m12s Nov 05 00 14 1m2s 1m2s 01 15 1m5s 1m5s 02 17 1m14s 1m14s 03 14 1m2s 1m2s 04 17 1m4s 1m4s 05 14 1m4s 1m4s 06 14 1m7s 1m7s 07 22 1m34s 1m33s 08 23 1m37s 1m36s 09 9 52s755ms 52s755ms 10 15 1m2s 1m2s 11 11 54s577ms 54s577ms 12 18 1m2s 1m2s 13 11 28s565ms 28s565ms 14 11 1m3s 1m3s 15 13 29s915ms 29s915ms 16 9 2h15m5s 2h15m5s 17 14 55s283ms 55s283ms 18 9 2h33m59s 2h33m59s 19 26 7m50s 7m50s 20 367 6s121ms 4s984ms 21 34 48s181ms 48s181ms 22 12 1m3s 1m3s 23 10 1m16s 1m16s Nov 06 00 17 1m5s 1m5s 01 11 1m8s 1m8s 02 4 40s501ms 40s501ms 03 15 1m10s 1m10s 04 6 37s971ms 37s971ms 05 12 45m53s 45m53s 06 12 2m41s 2m41s 07 21 1m45s 1m43s 08 25 1m49s 1m47s 09 13 56s827ms 56s827ms 10 9 35s267ms 35s267ms 11 16 1m4s 1m4s 12 17 53s803ms 53s803ms 13 22 41s335ms 41s335ms 14 15 16s183ms 16s183ms 15 4 17s768ms 17s768ms 16 10 50s596ms 50s596ms 17 10 1h10m20s 1h10m20s 18 5 4h19m11s 4h19m11s 19 24 9m10s 9m9s 20 348 5s730ms 4s592ms 21 55 34s375ms 34s375ms 22 19 1m10s 1m10s 23 14 1m5s 1m5s Nov 07 00 20 1m7s 1m7s 01 15 1m3s 1m3s 02 12 30m41s 30m41s 03 7 45s916ms 45s916ms 04 11 57s168ms 57s168ms 05 11 1m1s 1m1s 06 9 51s114ms 51s114ms 07 26 1m41s 1m39s 08 28 1m41s 1m39s 09 8 29s554ms 29s554ms 10 13 32s545ms 32s545ms 11 11 1m6s 1m6s 12 15 48s232ms 48s232ms 13 15 55s728ms 55s728ms 14 39 45m7s 45m7s 15 8 27s382ms 27s382ms 16 15 12m57s 12m57s 17 6 36s814ms 36s814ms 18 10 23m1s 23m1s 19 14 14m54s 14m54s 20 331 5s938ms 4s493ms 21 84 38s419ms 38s419ms 22 11 1m11s 1m11s 23 20 1m13s 1m13s Nov 08 00 26 1m24s 1m24s 01 12 1m22s 1m22s 02 15 1m4s 1m4s 03 13 1m22s 1m22s 04 16 55s680ms 55s680ms 05 17 1m3s 1m3s 06 8 55s639ms 55s639ms 07 10 51s898ms 51s898ms 08 10 54s766ms 54s766ms 09 14 58s826ms 58s826ms 10 9 59s528ms 59s528ms 11 10 52s273ms 52s273ms 12 8 53s117ms 53s117ms 13 10 53s209ms 53s209ms 14 14 57s995ms 57s995ms 15 7 50s 50s 16 13 55s235ms 55s235ms 17 8 52s571ms 52s571ms 18 8 5h16m49s 5h16m49s 19 3 73ms 73ms 20 3 166ms 166ms 21 3 70ms 70ms 22 3 72ms 72ms 23 3 69ms 69ms -
Connections
Established Connections
Key values
- 12 connections Connection Peak
- 2025-11-04 20:29:47 Date
Connections per database
Key values
- autotest_api_batch Main Database
- 3,771 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 3,771 connections Total
-
Sessions
Simultaneous sessions
Key values
- 150 sessions Session Peak
- 2025-11-02 17:49:05 Date
Histogram of session times
Key values
- 2,020 0-500ms duration
Sessions per database
Key values
- autotest_api_batch Main Database
- 3,773 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 3,773 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 3,773 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 385.42 MiB Temp Files size Peak
- 2025-11-04 20:36:13 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-11-03 20:41:32 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 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 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 Nov 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 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 201 4.75 GiB 24.18 MiB 21 5 12.81 MiB 2.56 MiB 22 0 0 0 23 0 0 0 Nov 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 208 4.77 GiB 23.46 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Nov 05 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 204 4.76 GiB 23.87 MiB 21 5 12.81 MiB 2.56 MiB 22 0 0 0 23 0 0 0 Nov 06 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 204 4.76 GiB 23.90 MiB 21 5 12.81 MiB 2.56 MiB 22 0 0 0 23 0 0 0 Nov 07 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 201 4.76 GiB 24.25 MiB 21 5 12.81 MiB 2.56 MiB 22 0 0 0 23 0 0 0 Nov 08 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 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 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 Nov 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 Nov 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 Nov 05 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 Nov 06 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 Nov 07 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 Nov 08 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
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 5 Total read queries
- 180 Total write queries
Queries by database
Key values
- autotest_api_batch Main database
- 196 Requests
- 42m57s (autotest_api_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 196 Requests
User Request type Count Duration a3dsupervisor Total 196 42m57s ddl 115 24m12s delete 7 2m5s insert 4 28s232ms others 11 8m58s select 5 39s223ms tcl 52 6m5s update 2 28s218ms Duration by user
Key values
- 42m57s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 196 42m57s ddl 115 24m12s delete 7 2m5s insert 4 28s232ms others 11 8m58s select 5 39s223ms tcl 52 6m5s update 2 28s218ms Queries by host
Key values
- 10.3.0.4 Main host
- 196 Requests
- 42m57s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 125 Requests
- 33m2s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-04 01:16:44 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 113 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m19s VACUUM ANALYZE;[ Date: 2025-11-07 20:52:32 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m11s VACUUM ANALYZE;[ Date: 2025-11-05 20:44:15 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m10s VACUUM ANALYZE;[ Date: 2025-11-06 20:52:56 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 57s680ms VACUUM ANALYSE;[ Date: 2025-11-07 20:53:38 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 54s669ms VACUUM ANALYZE;[ Date: 2025-11-04 20:37:59 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 49s830ms VACUUM ANALYZE;[ Date: 2025-11-03 20:49:46 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 44s225ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-06 20:51:00 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 42s993ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-03 20:47:52 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 40s192ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-07 20:50:28 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 38s678ms VACUUM ANALYSE;[ Date: 2025-11-06 20:53:42 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 37s378ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-04 20:36:13 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 37s3ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-05 20:42:09 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 36s410ms VACUUM ANALYSE;[ Date: 2025-11-05 20:45:00 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 36s355ms VACUUM ANALYSE;[ Date: 2025-11-03 20:50:29 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 35s146ms VACUUM ANALYSE;[ Date: 2025-11-04 20:38:43 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 33s555ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-07 20:56:25 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 33s502ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-11-06 20:48:39 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 32s117ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-11-04 20:34:00 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 26s681ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-11-07 20:48:02 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 26s671ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-11-05 20:39:47 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6m5s 52 5s85ms 13s181ms 7s29ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 08 12 1m34s 7s867ms 09 4 32s593ms 8s148ms Nov 04 08 5 30s150ms 6s30ms 09 6 49s147ms 8s191ms 20 2 12s774ms 6s387ms Nov 05 08 1 6s380ms 6s380ms Nov 06 08 4 22s66ms 5s516ms 09 6 32s906ms 5s484ms 20 2 19s40ms 9s520ms Nov 07 08 5 36s549ms 7s309ms 09 4 24s164ms 6s41ms 20 1 5s321ms 5s321ms [ User: a3dsupervisor - Total duration: 6m5s - Times executed: 52 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m5s - Times executed: 52 ]
-
COMMIT;
Date: 2025-11-03 08:03:16 Duration: 13s181ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 12s454ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s326ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5m25s 5 49s830ms 1m19s 1m5s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 21 1 49s830ms 49s830ms Nov 04 21 1 54s669ms 54s669ms Nov 05 21 1 1m11s 1m11s Nov 06 21 1 1m10s 1m10s Nov 07 21 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 5m25s - Times executed: 5 ]
[ Application: psql - Total duration: 5m25s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-07 20:52:32 Duration: 1m19s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-05 20:44:15 Duration: 1m11s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-06 20:52:56 Duration: 1m10s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 3m24s 5 35s146ms 57s680ms 40s854ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 21 1 36s355ms 36s355ms Nov 04 21 1 35s146ms 35s146ms Nov 05 21 1 36s410ms 36s410ms Nov 06 21 1 38s678ms 38s678ms Nov 07 21 1 57s680ms 57s680ms [ User: a3dsupervisor - Total duration: 3m24s - Times executed: 5 ]
[ Application: psql - Total duration: 3m24s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-07 20:53:38 Duration: 57s680ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 20:53:42 Duration: 38s678ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-05 20:45:00 Duration: 36s410ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 3m21s 5 37s3ms 44s225ms 40s358ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 21 1 42s993ms 42s993ms Nov 04 21 1 37s378ms 37s378ms Nov 05 21 1 37s3ms 37s3ms Nov 06 21 1 44s225ms 44s225ms Nov 07 21 1 40s192ms 40s192ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 5 ]
[ Application: psql - Total duration: 3m21s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 20:51:00 Duration: 44s225ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-03 20:47:52 Duration: 42s993ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 20:50:28 Duration: 40s192ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 2m22s 5 23s92ms 33s502ms 28s413ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 21 1 23s92ms 23s92ms Nov 04 21 1 32s117ms 32s117ms Nov 05 21 1 26s671ms 26s671ms Nov 06 21 1 33s502ms 33s502ms Nov 07 21 1 26s681ms 26s681ms [ User: a3dsupervisor - Total duration: 2m22s - Times executed: 5 ]
[ Application: psql - Total duration: 2m22s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-06 20:48:39 Duration: 33s502ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-04 20:34:00 Duration: 32s117ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-07 20:48:02 Duration: 26s681ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1m53s 5 18s360ms 33s555ms 22s773ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 21 1 20s172ms 20s172ms Nov 04 21 1 18s360ms 18s360ms Nov 05 21 1 22s140ms 22s140ms Nov 06 21 1 19s636ms 19s636ms Nov 07 21 1 33s555ms 33s555ms [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m53s - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 20:56:25 Duration: 33s555ms Database: autotest_api_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-11-05 20:47:13 Duration: 22s140ms Database: autotest_api_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-11-03 20:52:19 Duration: 20s172ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 1m24s 5 12s127ms 18s454ms 16s995ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 21 1 18s109ms 18s109ms Nov 04 21 1 17s854ms 17s854ms Nov 05 21 1 18s454ms 18s454ms Nov 06 21 1 12s127ms 12s127ms Nov 07 21 1 18s430ms 18s430ms [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 5 ]
[ Application: psql - Total duration: 1m24s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-05 20:40:55 Duration: 18s454ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-07 20:49:12 Duration: 18s430ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-03 20:46:35 Duration: 18s109ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 1m24s 5 12s598ms 19s210ms 16s836ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 21 1 16s555ms 16s555ms Nov 04 21 1 16s842ms 16s842ms Nov 05 21 1 19s210ms 19s210ms Nov 06 21 1 12s598ms 12s598ms Nov 07 21 1 18s976ms 18s976ms [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 5 ]
[ Application: psql - Total duration: 1m24s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 20:41:22 Duration: 19s210ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-07 20:49:39 Duration: 18s976ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-04 20:35:26 Duration: 16s842ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1m17s 5 13s385ms 19s52ms 15s513ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 21 1 17s530ms 17s530ms Nov 04 21 1 13s385ms 13s385ms Nov 05 21 1 19s52ms 19s52ms Nov 06 21 1 13s801ms 13s801ms Nov 07 21 1 13s796ms 13s796ms [ User: a3dsupervisor - Total duration: 1m17s - Times executed: 5 ]
[ Application: psql - Total duration: 1m17s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-05 20:40:06 Duration: 19s52ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-03 20:45:43 Duration: 17s530ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-06 20:48:53 Duration: 13s801ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m9s 5 11s357ms 16s363ms 13s892ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 21 1 11s357ms 11s357ms Nov 04 21 1 14s509ms 14s509ms Nov 05 21 1 15s7ms 15s7ms Nov 06 21 1 12s223ms 12s223ms Nov 07 21 1 16s363ms 16s363ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: psql - Total duration: 1m9s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-07 20:46:24 Duration: 16s363ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 20:38:09 Duration: 15s7ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-04 20:32:22 Duration: 14s509ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1m8s 5 10s164ms 17s422ms 13s656ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 21 1 17s422ms 17s422ms Nov 04 21 1 14s255ms 14s255ms Nov 05 21 1 14s517ms 14s517ms Nov 06 21 1 10s164ms 10s164ms Nov 07 21 1 11s921ms 11s921ms [ User: a3dsupervisor - Total duration: 1m8s - Times executed: 5 ]
[ Application: psql - Total duration: 1m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-03 20:41:51 Duration: 17s422ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-05 20:36:19 Duration: 14s517ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-04 20:30:27 Duration: 14s255ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1m3s 5 9s18ms 16s997ms 12s690ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 21 1 13s344ms 13s344ms Nov 04 21 1 9s18ms 9s18ms Nov 05 21 1 9s638ms 9s638ms Nov 06 21 1 14s451ms 14s451ms Nov 07 21 1 16s997ms 16s997ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-07 20:48:33 Duration: 16s997ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-06 20:49:07 Duration: 14s451ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-03 20:45:56 Duration: 13s344ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 59s196ms 5 8s468ms 16s158ms 11s839ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 03 21 1 16s158ms 16s158ms Nov 04 21 1 12s992ms 12s992ms Nov 05 21 1 11s25ms 11s25ms Nov 06 21 1 8s468ms 8s468ms Nov 07 21 1 10s551ms 10s551ms [ User: a3dsupervisor - Total duration: 59s196ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s196ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-03 20:44:15 Duration: 16s158ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 20:32:46 Duration: 12s992ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 20:38:32 Duration: 11s25ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 57s458ms 5 9s929ms 13s123ms 11s491ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 03 21 1 13s123ms 13s123ms Nov 04 21 1 10s342ms 10s342ms Nov 05 21 1 11s766ms 11s766ms Nov 06 21 1 12s296ms 12s296ms Nov 07 21 1 9s929ms 9s929ms [ User: a3dsupervisor - Total duration: 57s458ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s458ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-03 20:43:59 Duration: 13s123ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-06 20:47:15 Duration: 12s296ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-05 20:38:21 Duration: 11s766ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 54s952ms 5 9s708ms 12s596ms 10s990ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 03 21 1 10s594ms 10s594ms Nov 04 21 1 12s335ms 12s335ms Nov 05 21 1 9s717ms 9s717ms Nov 06 21 1 12s596ms 12s596ms Nov 07 21 1 9s708ms 9s708ms [ User: a3dsupervisor - Total duration: 54s952ms - Times executed: 5 ]
[ Application: psql - Total duration: 54s952ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-06 20:45:51 Duration: 12s596ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-04 20:31:04 Duration: 12s335ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-03 20:42:29 Duration: 10s594ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 50s825ms 5 6s705ms 14s436ms 10s165ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 21 1 8s868ms 8s868ms Nov 04 21 1 14s436ms 14s436ms Nov 05 21 1 6s705ms 6s705ms Nov 06 21 1 12s545ms 12s545ms Nov 07 21 1 8s268ms 8s268ms [ User: a3dsupervisor - Total duration: 50s825ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s825ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-04 20:30:52 Duration: 14s436ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-06 20:45:39 Duration: 12s545ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-03 20:42:18 Duration: 8s868ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 50s628ms 5 7s107ms 11s435ms 10s125ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 21 1 11s158ms 11s158ms Nov 04 21 1 7s107ms 7s107ms Nov 05 21 1 11s435ms 11s435ms Nov 06 21 1 10s49ms 10s49ms Nov 07 21 1 10s878ms 10s878ms [ User: a3dsupervisor - Total duration: 50s628ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s628ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-05 20:38:44 Duration: 11s435ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-03 20:44:26 Duration: 11s158ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-07 20:46:55 Duration: 10s878ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 48s865ms 5 7s313ms 11s861ms 9s773ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 03 21 1 9s289ms 9s289ms Nov 04 21 1 10s823ms 10s823ms Nov 05 21 1 7s313ms 7s313ms Nov 06 21 1 9s577ms 9s577ms Nov 07 21 1 11s861ms 11s861ms [ User: a3dsupervisor - Total duration: 48s865ms - Times executed: 5 ]
[ Application: psql - Total duration: 48s865ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-07 20:47:15 Duration: 11s861ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-04 20:33:11 Duration: 10s823ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-06 20:47:52 Duration: 9s577ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 45s972ms 5 6s568ms 12s635ms 9s194ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 03 21 1 9s172ms 9s172ms Nov 04 21 1 8s855ms 8s855ms Nov 05 21 1 8s741ms 8s741ms Nov 06 21 1 6s568ms 6s568ms Nov 07 21 1 12s635ms 12s635ms [ User: a3dsupervisor - Total duration: 45s972ms - Times executed: 5 ]
[ Application: psql - Total duration: 45s972ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-07 20:47:28 Duration: 12s635ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-03 20:44:54 Duration: 9s172ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-04 20:33:21 Duration: 8s855ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 45s297ms 5 6s963ms 13s6ms 9s59ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 03 21 1 9s269ms 9s269ms Nov 04 21 1 6s963ms 6s963ms Nov 05 21 1 13s6ms 13s6ms Nov 06 21 1 8s305ms 8s305ms Nov 07 21 1 7s752ms 7s752ms [ User: a3dsupervisor - Total duration: 45s297ms - Times executed: 5 ]
[ Application: psql - Total duration: 45s297ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-05 20:38:57 Duration: 13s6ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-03 20:44:35 Duration: 9s269ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-06 20:47:42 Duration: 8s305ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 52 6m5s 5s85ms 13s181ms 7s29ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 08 12 1m34s 7s867ms 09 4 32s593ms 8s148ms Nov 04 08 5 30s150ms 6s30ms 09 6 49s147ms 8s191ms 20 2 12s774ms 6s387ms Nov 05 08 1 6s380ms 6s380ms Nov 06 08 4 22s66ms 5s516ms 09 6 32s906ms 5s484ms 20 2 19s40ms 9s520ms Nov 07 08 5 36s549ms 7s309ms 09 4 24s164ms 6s41ms 20 1 5s321ms 5s321ms [ User: a3dsupervisor - Total duration: 6m5s - Times executed: 52 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m5s - Times executed: 52 ]
-
COMMIT;
Date: 2025-11-03 08:03:16 Duration: 13s181ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 12s454ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s326ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5 5m25s 49s830ms 1m19s 1m5s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 21 1 49s830ms 49s830ms Nov 04 21 1 54s669ms 54s669ms Nov 05 21 1 1m11s 1m11s Nov 06 21 1 1m10s 1m10s Nov 07 21 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 5m25s - Times executed: 5 ]
[ Application: psql - Total duration: 5m25s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-07 20:52:32 Duration: 1m19s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-05 20:44:15 Duration: 1m11s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-06 20:52:56 Duration: 1m10s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 5 3m24s 35s146ms 57s680ms 40s854ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 21 1 36s355ms 36s355ms Nov 04 21 1 35s146ms 35s146ms Nov 05 21 1 36s410ms 36s410ms Nov 06 21 1 38s678ms 38s678ms Nov 07 21 1 57s680ms 57s680ms [ User: a3dsupervisor - Total duration: 3m24s - Times executed: 5 ]
[ Application: psql - Total duration: 3m24s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-07 20:53:38 Duration: 57s680ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 20:53:42 Duration: 38s678ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-05 20:45:00 Duration: 36s410ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 3m21s 37s3ms 44s225ms 40s358ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 21 1 42s993ms 42s993ms Nov 04 21 1 37s378ms 37s378ms Nov 05 21 1 37s3ms 37s3ms Nov 06 21 1 44s225ms 44s225ms Nov 07 21 1 40s192ms 40s192ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 5 ]
[ Application: psql - Total duration: 3m21s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 20:51:00 Duration: 44s225ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-03 20:47:52 Duration: 42s993ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 20:50:28 Duration: 40s192ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 5 2m22s 23s92ms 33s502ms 28s413ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 21 1 23s92ms 23s92ms Nov 04 21 1 32s117ms 32s117ms Nov 05 21 1 26s671ms 26s671ms Nov 06 21 1 33s502ms 33s502ms Nov 07 21 1 26s681ms 26s681ms [ User: a3dsupervisor - Total duration: 2m22s - Times executed: 5 ]
[ Application: psql - Total duration: 2m22s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-06 20:48:39 Duration: 33s502ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-04 20:34:00 Duration: 32s117ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-07 20:48:02 Duration: 26s681ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 5 1m53s 18s360ms 33s555ms 22s773ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 21 1 20s172ms 20s172ms Nov 04 21 1 18s360ms 18s360ms Nov 05 21 1 22s140ms 22s140ms Nov 06 21 1 19s636ms 19s636ms Nov 07 21 1 33s555ms 33s555ms [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m53s - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 20:56:25 Duration: 33s555ms Database: autotest_api_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-11-05 20:47:13 Duration: 22s140ms Database: autotest_api_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-11-03 20:52:19 Duration: 20s172ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 5 1m24s 12s127ms 18s454ms 16s995ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 21 1 18s109ms 18s109ms Nov 04 21 1 17s854ms 17s854ms Nov 05 21 1 18s454ms 18s454ms Nov 06 21 1 12s127ms 12s127ms Nov 07 21 1 18s430ms 18s430ms [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 5 ]
[ Application: psql - Total duration: 1m24s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-05 20:40:55 Duration: 18s454ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-07 20:49:12 Duration: 18s430ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-03 20:46:35 Duration: 18s109ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 5 1m24s 12s598ms 19s210ms 16s836ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 21 1 16s555ms 16s555ms Nov 04 21 1 16s842ms 16s842ms Nov 05 21 1 19s210ms 19s210ms Nov 06 21 1 12s598ms 12s598ms Nov 07 21 1 18s976ms 18s976ms [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 5 ]
[ Application: psql - Total duration: 1m24s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 20:41:22 Duration: 19s210ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-07 20:49:39 Duration: 18s976ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-04 20:35:26 Duration: 16s842ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 5 1m17s 13s385ms 19s52ms 15s513ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 21 1 17s530ms 17s530ms Nov 04 21 1 13s385ms 13s385ms Nov 05 21 1 19s52ms 19s52ms Nov 06 21 1 13s801ms 13s801ms Nov 07 21 1 13s796ms 13s796ms [ User: a3dsupervisor - Total duration: 1m17s - Times executed: 5 ]
[ Application: psql - Total duration: 1m17s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-05 20:40:06 Duration: 19s52ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-03 20:45:43 Duration: 17s530ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-06 20:48:53 Duration: 13s801ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 5 1m9s 11s357ms 16s363ms 13s892ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 21 1 11s357ms 11s357ms Nov 04 21 1 14s509ms 14s509ms Nov 05 21 1 15s7ms 15s7ms Nov 06 21 1 12s223ms 12s223ms Nov 07 21 1 16s363ms 16s363ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: psql - Total duration: 1m9s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-07 20:46:24 Duration: 16s363ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 20:38:09 Duration: 15s7ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-04 20:32:22 Duration: 14s509ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 1m8s 10s164ms 17s422ms 13s656ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 21 1 17s422ms 17s422ms Nov 04 21 1 14s255ms 14s255ms Nov 05 21 1 14s517ms 14s517ms Nov 06 21 1 10s164ms 10s164ms Nov 07 21 1 11s921ms 11s921ms [ User: a3dsupervisor - Total duration: 1m8s - Times executed: 5 ]
[ Application: psql - Total duration: 1m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-03 20:41:51 Duration: 17s422ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-05 20:36:19 Duration: 14s517ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-04 20:30:27 Duration: 14s255ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5 1m3s 9s18ms 16s997ms 12s690ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 21 1 13s344ms 13s344ms Nov 04 21 1 9s18ms 9s18ms Nov 05 21 1 9s638ms 9s638ms Nov 06 21 1 14s451ms 14s451ms Nov 07 21 1 16s997ms 16s997ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-07 20:48:33 Duration: 16s997ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-06 20:49:07 Duration: 14s451ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-03 20:45:56 Duration: 13s344ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 5 59s196ms 8s468ms 16s158ms 11s839ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 03 21 1 16s158ms 16s158ms Nov 04 21 1 12s992ms 12s992ms Nov 05 21 1 11s25ms 11s25ms Nov 06 21 1 8s468ms 8s468ms Nov 07 21 1 10s551ms 10s551ms [ User: a3dsupervisor - Total duration: 59s196ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s196ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-03 20:44:15 Duration: 16s158ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 20:32:46 Duration: 12s992ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 20:38:32 Duration: 11s25ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 57s458ms 9s929ms 13s123ms 11s491ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 03 21 1 13s123ms 13s123ms Nov 04 21 1 10s342ms 10s342ms Nov 05 21 1 11s766ms 11s766ms Nov 06 21 1 12s296ms 12s296ms Nov 07 21 1 9s929ms 9s929ms [ User: a3dsupervisor - Total duration: 57s458ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s458ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-03 20:43:59 Duration: 13s123ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-06 20:47:15 Duration: 12s296ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-05 20:38:21 Duration: 11s766ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5 54s952ms 9s708ms 12s596ms 10s990ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 03 21 1 10s594ms 10s594ms Nov 04 21 1 12s335ms 12s335ms Nov 05 21 1 9s717ms 9s717ms Nov 06 21 1 12s596ms 12s596ms Nov 07 21 1 9s708ms 9s708ms [ User: a3dsupervisor - Total duration: 54s952ms - Times executed: 5 ]
[ Application: psql - Total duration: 54s952ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-06 20:45:51 Duration: 12s596ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-04 20:31:04 Duration: 12s335ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-03 20:42:29 Duration: 10s594ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 50s825ms 6s705ms 14s436ms 10s165ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 21 1 8s868ms 8s868ms Nov 04 21 1 14s436ms 14s436ms Nov 05 21 1 6s705ms 6s705ms Nov 06 21 1 12s545ms 12s545ms Nov 07 21 1 8s268ms 8s268ms [ User: a3dsupervisor - Total duration: 50s825ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s825ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-04 20:30:52 Duration: 14s436ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-06 20:45:39 Duration: 12s545ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-03 20:42:18 Duration: 8s868ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5 50s628ms 7s107ms 11s435ms 10s125ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 21 1 11s158ms 11s158ms Nov 04 21 1 7s107ms 7s107ms Nov 05 21 1 11s435ms 11s435ms Nov 06 21 1 10s49ms 10s49ms Nov 07 21 1 10s878ms 10s878ms [ User: a3dsupervisor - Total duration: 50s628ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s628ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-05 20:38:44 Duration: 11s435ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-03 20:44:26 Duration: 11s158ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-07 20:46:55 Duration: 10s878ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5 48s865ms 7s313ms 11s861ms 9s773ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 03 21 1 9s289ms 9s289ms Nov 04 21 1 10s823ms 10s823ms Nov 05 21 1 7s313ms 7s313ms Nov 06 21 1 9s577ms 9s577ms Nov 07 21 1 11s861ms 11s861ms [ User: a3dsupervisor - Total duration: 48s865ms - Times executed: 5 ]
[ Application: psql - Total duration: 48s865ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-07 20:47:15 Duration: 11s861ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-04 20:33:11 Duration: 10s823ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-06 20:47:52 Duration: 9s577ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5 45s972ms 6s568ms 12s635ms 9s194ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 03 21 1 9s172ms 9s172ms Nov 04 21 1 8s855ms 8s855ms Nov 05 21 1 8s741ms 8s741ms Nov 06 21 1 6s568ms 6s568ms Nov 07 21 1 12s635ms 12s635ms [ User: a3dsupervisor - Total duration: 45s972ms - Times executed: 5 ]
[ Application: psql - Total duration: 45s972ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-07 20:47:28 Duration: 12s635ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-03 20:44:54 Duration: 9s172ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-04 20:33:21 Duration: 8s855ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5 45s297ms 6s963ms 13s6ms 9s59ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 03 21 1 9s269ms 9s269ms Nov 04 21 1 6s963ms 6s963ms Nov 05 21 1 13s6ms 13s6ms Nov 06 21 1 8s305ms 8s305ms Nov 07 21 1 7s752ms 7s752ms [ User: a3dsupervisor - Total duration: 45s297ms - Times executed: 5 ]
[ Application: psql - Total duration: 45s297ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-05 20:38:57 Duration: 13s6ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-03 20:44:35 Duration: 9s269ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-06 20:47:42 Duration: 8s305ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 49s830ms 1m19s 1m5s 5 5m25s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 21 1 49s830ms 49s830ms Nov 04 21 1 54s669ms 54s669ms Nov 05 21 1 1m11s 1m11s Nov 06 21 1 1m10s 1m10s Nov 07 21 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 5m25s - Times executed: 5 ]
[ Application: psql - Total duration: 5m25s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-07 20:52:32 Duration: 1m19s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-05 20:44:15 Duration: 1m11s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-06 20:52:56 Duration: 1m10s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 35s146ms 57s680ms 40s854ms 5 3m24s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 21 1 36s355ms 36s355ms Nov 04 21 1 35s146ms 35s146ms Nov 05 21 1 36s410ms 36s410ms Nov 06 21 1 38s678ms 38s678ms Nov 07 21 1 57s680ms 57s680ms [ User: a3dsupervisor - Total duration: 3m24s - Times executed: 5 ]
[ Application: psql - Total duration: 3m24s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-07 20:53:38 Duration: 57s680ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 20:53:42 Duration: 38s678ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-05 20:45:00 Duration: 36s410ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 37s3ms 44s225ms 40s358ms 5 3m21s alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 21 1 42s993ms 42s993ms Nov 04 21 1 37s378ms 37s378ms Nov 05 21 1 37s3ms 37s3ms Nov 06 21 1 44s225ms 44s225ms Nov 07 21 1 40s192ms 40s192ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 5 ]
[ Application: psql - Total duration: 3m21s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 20:51:00 Duration: 44s225ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-03 20:47:52 Duration: 42s993ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 20:50:28 Duration: 40s192ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 23s92ms 33s502ms 28s413ms 5 2m22s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 21 1 23s92ms 23s92ms Nov 04 21 1 32s117ms 32s117ms Nov 05 21 1 26s671ms 26s671ms Nov 06 21 1 33s502ms 33s502ms Nov 07 21 1 26s681ms 26s681ms [ User: a3dsupervisor - Total duration: 2m22s - Times executed: 5 ]
[ Application: psql - Total duration: 2m22s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-06 20:48:39 Duration: 33s502ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-04 20:34:00 Duration: 32s117ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-07 20:48:02 Duration: 26s681ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 18s360ms 33s555ms 22s773ms 5 1m53s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 21 1 20s172ms 20s172ms Nov 04 21 1 18s360ms 18s360ms Nov 05 21 1 22s140ms 22s140ms Nov 06 21 1 19s636ms 19s636ms Nov 07 21 1 33s555ms 33s555ms [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m53s - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 20:56:25 Duration: 33s555ms Database: autotest_api_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-11-05 20:47:13 Duration: 22s140ms Database: autotest_api_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-11-03 20:52:19 Duration: 20s172ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 12s127ms 18s454ms 16s995ms 5 1m24s alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 21 1 18s109ms 18s109ms Nov 04 21 1 17s854ms 17s854ms Nov 05 21 1 18s454ms 18s454ms Nov 06 21 1 12s127ms 12s127ms Nov 07 21 1 18s430ms 18s430ms [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 5 ]
[ Application: psql - Total duration: 1m24s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-05 20:40:55 Duration: 18s454ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-07 20:49:12 Duration: 18s430ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-03 20:46:35 Duration: 18s109ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 12s598ms 19s210ms 16s836ms 5 1m24s alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 21 1 16s555ms 16s555ms Nov 04 21 1 16s842ms 16s842ms Nov 05 21 1 19s210ms 19s210ms Nov 06 21 1 12s598ms 12s598ms Nov 07 21 1 18s976ms 18s976ms [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 5 ]
[ Application: psql - Total duration: 1m24s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 20:41:22 Duration: 19s210ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-07 20:49:39 Duration: 18s976ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-04 20:35:26 Duration: 16s842ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 13s385ms 19s52ms 15s513ms 5 1m17s create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 21 1 17s530ms 17s530ms Nov 04 21 1 13s385ms 13s385ms Nov 05 21 1 19s52ms 19s52ms Nov 06 21 1 13s801ms 13s801ms Nov 07 21 1 13s796ms 13s796ms [ User: a3dsupervisor - Total duration: 1m17s - Times executed: 5 ]
[ Application: psql - Total duration: 1m17s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-05 20:40:06 Duration: 19s52ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-03 20:45:43 Duration: 17s530ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-06 20:48:53 Duration: 13s801ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 11s357ms 16s363ms 13s892ms 5 1m9s create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 21 1 11s357ms 11s357ms Nov 04 21 1 14s509ms 14s509ms Nov 05 21 1 15s7ms 15s7ms Nov 06 21 1 12s223ms 12s223ms Nov 07 21 1 16s363ms 16s363ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: psql - Total duration: 1m9s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-07 20:46:24 Duration: 16s363ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 20:38:09 Duration: 15s7ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-04 20:32:22 Duration: 14s509ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 10s164ms 17s422ms 13s656ms 5 1m8s create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 21 1 17s422ms 17s422ms Nov 04 21 1 14s255ms 14s255ms Nov 05 21 1 14s517ms 14s517ms Nov 06 21 1 10s164ms 10s164ms Nov 07 21 1 11s921ms 11s921ms [ User: a3dsupervisor - Total duration: 1m8s - Times executed: 5 ]
[ Application: psql - Total duration: 1m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-03 20:41:51 Duration: 17s422ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-05 20:36:19 Duration: 14s517ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-04 20:30:27 Duration: 14s255ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 9s18ms 16s997ms 12s690ms 5 1m3s create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 21 1 13s344ms 13s344ms Nov 04 21 1 9s18ms 9s18ms Nov 05 21 1 9s638ms 9s638ms Nov 06 21 1 14s451ms 14s451ms Nov 07 21 1 16s997ms 16s997ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-07 20:48:33 Duration: 16s997ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-06 20:49:07 Duration: 14s451ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-03 20:45:56 Duration: 13s344ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 8s468ms 16s158ms 11s839ms 5 59s196ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 21 1 16s158ms 16s158ms Nov 04 21 1 12s992ms 12s992ms Nov 05 21 1 11s25ms 11s25ms Nov 06 21 1 8s468ms 8s468ms Nov 07 21 1 10s551ms 10s551ms [ User: a3dsupervisor - Total duration: 59s196ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s196ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-03 20:44:15 Duration: 16s158ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 20:32:46 Duration: 12s992ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 20:38:32 Duration: 11s25ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 9s929ms 13s123ms 11s491ms 5 57s458ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 03 21 1 13s123ms 13s123ms Nov 04 21 1 10s342ms 10s342ms Nov 05 21 1 11s766ms 11s766ms Nov 06 21 1 12s296ms 12s296ms Nov 07 21 1 9s929ms 9s929ms [ User: a3dsupervisor - Total duration: 57s458ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s458ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-03 20:43:59 Duration: 13s123ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-06 20:47:15 Duration: 12s296ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-05 20:38:21 Duration: 11s766ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 9s708ms 12s596ms 10s990ms 5 54s952ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 03 21 1 10s594ms 10s594ms Nov 04 21 1 12s335ms 12s335ms Nov 05 21 1 9s717ms 9s717ms Nov 06 21 1 12s596ms 12s596ms Nov 07 21 1 9s708ms 9s708ms [ User: a3dsupervisor - Total duration: 54s952ms - Times executed: 5 ]
[ Application: psql - Total duration: 54s952ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-06 20:45:51 Duration: 12s596ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-04 20:31:04 Duration: 12s335ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-03 20:42:29 Duration: 10s594ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 6s705ms 14s436ms 10s165ms 5 50s825ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 03 21 1 8s868ms 8s868ms Nov 04 21 1 14s436ms 14s436ms Nov 05 21 1 6s705ms 6s705ms Nov 06 21 1 12s545ms 12s545ms Nov 07 21 1 8s268ms 8s268ms [ User: a3dsupervisor - Total duration: 50s825ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s825ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-04 20:30:52 Duration: 14s436ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-06 20:45:39 Duration: 12s545ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-03 20:42:18 Duration: 8s868ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 7s107ms 11s435ms 10s125ms 5 50s628ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 21 1 11s158ms 11s158ms Nov 04 21 1 7s107ms 7s107ms Nov 05 21 1 11s435ms 11s435ms Nov 06 21 1 10s49ms 10s49ms Nov 07 21 1 10s878ms 10s878ms [ User: a3dsupervisor - Total duration: 50s628ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s628ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-05 20:38:44 Duration: 11s435ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-03 20:44:26 Duration: 11s158ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-11-07 20:46:55 Duration: 10s878ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 7s313ms 11s861ms 9s773ms 5 48s865ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 21 1 9s289ms 9s289ms Nov 04 21 1 10s823ms 10s823ms Nov 05 21 1 7s313ms 7s313ms Nov 06 21 1 9s577ms 9s577ms Nov 07 21 1 11s861ms 11s861ms [ User: a3dsupervisor - Total duration: 48s865ms - Times executed: 5 ]
[ Application: psql - Total duration: 48s865ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-07 20:47:15 Duration: 11s861ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-04 20:33:11 Duration: 10s823ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-11-06 20:47:52 Duration: 9s577ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 6s568ms 12s635ms 9s194ms 5 45s972ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 03 21 1 9s172ms 9s172ms Nov 04 21 1 8s855ms 8s855ms Nov 05 21 1 8s741ms 8s741ms Nov 06 21 1 6s568ms 6s568ms Nov 07 21 1 12s635ms 12s635ms [ User: a3dsupervisor - Total duration: 45s972ms - Times executed: 5 ]
[ Application: psql - Total duration: 45s972ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-07 20:47:28 Duration: 12s635ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-03 20:44:54 Duration: 9s172ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-04 20:33:21 Duration: 8s855ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 6s963ms 13s6ms 9s59ms 5 45s297ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 03 21 1 9s269ms 9s269ms Nov 04 21 1 6s963ms 6s963ms Nov 05 21 1 13s6ms 13s6ms Nov 06 21 1 8s305ms 8s305ms Nov 07 21 1 7s752ms 7s752ms [ User: a3dsupervisor - Total duration: 45s297ms - Times executed: 5 ]
[ Application: psql - Total duration: 45s297ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-05 20:38:57 Duration: 13s6ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-03 20:44:35 Duration: 9s269ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-11-06 20:47:42 Duration: 8s305ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5s85ms 13s181ms 7s29ms 52 6m5s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 03 08 12 1m34s 7s867ms 09 4 32s593ms 8s148ms Nov 04 08 5 30s150ms 6s30ms 09 6 49s147ms 8s191ms 20 2 12s774ms 6s387ms Nov 05 08 1 6s380ms 6s380ms Nov 06 08 4 22s66ms 5s516ms 09 6 32s906ms 5s484ms 20 2 19s40ms 9s520ms Nov 07 08 5 36s549ms 7s309ms 09 4 24s164ms 6s41ms 20 1 5s321ms 5s321ms [ User: a3dsupervisor - Total duration: 6m5s - Times executed: 52 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m5s - Times executed: 52 ]
-
COMMIT;
Date: 2025-11-03 08:03:16 Duration: 13s181ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 12s454ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s326ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s335ms 1 5s335ms 5s335ms 5s335ms select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Nov 08 08 1 5s335ms 5s335ms [ User: a3dsupervisor - Total duration: 8s301ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s301ms - Times executed: 1 ]
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-11-07 07:56:25 Duration: 5s335ms Database: autotest_api_batch User: autotest_api_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 32,058 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 19423 ERROR entries
- 80 WARNING entries
Most Frequent Errors/Events
Key values
- 19,193 Max number of times the same event was reported
- 19,503 Total events found
Rank Times reported Error 1 19,193 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 03 22 782 23 850 00 335 Nov 04 01 1,012 02 330 03 242 04 309 21 163 22 800 23 674 00 583 Nov 05 01 756 02 575 03 238 04 344 22 786 23 362 00 1,090 Nov 06 01 191 02 289 03 374 04 380 05 2 22 815 23 707 00 579 Nov 07 01 749 02 575 03 238 04 433 05 1 22 761 23 293 00 555 Nov 08 01 766 02 534 03 241 04 428 05 51 2 97 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 03 19 2 21 11 22 5 Nov 04 16 2 19 2 21 16 Nov 05 19 2 21 11 22 5 Nov 06 19 2 21 1 22 15 Nov 07 15 1 17 2 19 2 22 16 Nov 08 19 2 3 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 03 21 16 Nov 04 21 16 Nov 05 21 16 Nov 06 21 16 Nov 07 21 16 4 55 ERROR: operator does not exist: integer = character varying
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 03 21 11 Nov 04 21 11 Nov 05 21 11 Nov 06 21 1 22 10 Nov 07 22 11 5 25 ERROR: function convert(...) does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 03 22 5 Nov 04 21 5 Nov 05 22 5 Nov 06 22 5 Nov 07 22 5 6 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 #6
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 7 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 8 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 9 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 10 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 #10
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 11 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 #11
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 12 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 #12
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 13 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 #13
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 14 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 15 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 #15
Day Hour Count Nov 03 21 1 Nov 04 21 1 Nov 05 21 1 Nov 06 21 1 Nov 07 21 1 16 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_pe_consumption_10min_cp ON pe_consumption_10min (...)
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 07 21 1 17 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (...)
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 07 21 1 18 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (...)
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 04 21 1