pgBadger-
Global information
- Generated on Mon Oct 20 09:35:10 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=18/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=18/h=23/m=00/PT1H.log
- Parsed 7,312 log entries in 1m
- Log start from 2025-10-13 06:39:02 to 2025-10-17 07:06:51
-
Overview
Global Stats
- 58 Number of unique normalized queries
- 176 Number of queries
- 1h14m4s Total query duration
- 2025-10-13 06:47:24 First query
- 2025-10-17 06:53:23 Last query
- 1 queries/s at 2025-10-17 06:52:51 Query peak
- 1h14m4s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h14m4s Execute total duration
- 85 Number of events
- 4 Number of unique normalized events
- 80 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
- 986 Number temporary file
- 3.11 GiB Max size of temporary file
- 22.06 MiB Average size of temporary file
- 1,933 Total number of sessions
- 80 sessions at 2025-10-18 17:50:23 Session peak
- 4h10m29s Total duration of sessions
- 7s775ms Average duration of sessions
- 0 Average queries per session
- 2s299ms Average queries duration per session
- 5s476ms Average idle time per session
- 1,933 Total number of connections
- 11 connections/s at 2025-10-16 06:47:46 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-17 06:52:51 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-14 06:54:27 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-17 06:52:51 Date
Queries duration
Key values
- 1h14m4s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 12 00 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 13 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 27 0ms 3m20s 18s235ms 57s660ms 3m20s 3m20s 07 10 0ms 7m15s 1m18s 2m33s 7m15s 7m15s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 14 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 35 0ms 34s634ms 10s526ms 48s82ms 1m1s 1m1s 07 8 0ms 8m21s 1m47s 8m21s 8m21s 8m21s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 15 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 26 0ms 1m19s 14s944ms 1m2s 1m19s 1m19s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 16 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 32 0ms 57s746ms 15s245ms 50s877ms 57s746ms 59s247ms 07 11 0ms 5m22s 58s879ms 3m18s 5m22s 5m22s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 17 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 27 0ms 47s339ms 15s394ms 54s796ms 55s120ms 55s120ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 18 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) Oct 12 00 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 13 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 9 38s779ms 1m7s 1m8s 2m33s 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 14 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 2 0 6s33ms 0ms 0ms 12s67ms 07 0 6 19s458ms 28s601ms 1m8s 1m8s 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 15 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 4 7s578ms 0ms 5s907ms 24s408ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 16 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 6 13s505ms 0ms 23s369ms 57s664ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 17 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 4 7s771ms 0ms 5s813ms 25s273ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 18 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) Oct 12 00 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 13 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 15 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 16 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 17 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 18 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 12 00 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 13 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 14 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 15 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 16 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 17 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 18 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 Oct 12 00 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 Oct 13 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 290 0.08/s 07 7 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Oct 14 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 290 0.08/s 07 6 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Oct 15 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 293 0.08/s 07 3 0.00/s 08 8 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Oct 16 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 284 0.08/s 07 12 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 4 0.00/s 13 6 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Oct 17 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 283 0.08/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 4 0.00/s 15 4 0.00/s 16 5 0.00/s 17 6 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Oct 18 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 5 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 5 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Oct 12 00 2 72ms 72ms 02 2 75ms 75ms 03 2 76ms 76ms 04 2 78ms 78ms 05 2 73ms 73ms 06 2 72ms 72ms 07 2 78ms 78ms 08 2 82ms 82ms 09 2 72ms 72ms 10 2 74ms 74ms 11 2 74ms 74ms 12 2 72ms 72ms 13 2 90ms 90ms 14 2 76ms 76ms 15 2 82ms 82ms 16 2 79ms 79ms 17 2 77ms 77ms 18 2 85ms 85ms 19 2 80ms 80ms 20 2 83ms 83ms 21 2 77ms 77ms 22 2 76ms 76ms 23 2 73ms 73ms Oct 13 00 2 75ms 75ms 01 2 74ms 74ms 02 2 80ms 80ms 03 2 74ms 74ms 04 2 74ms 74ms 05 2 75ms 75ms 06 289 3s697ms 1s993ms 07 8 8m28s 6m50s 08 3 90ms 90ms 09 3 74ms 74ms 10 3 80ms 80ms 11 3 80ms 80ms 12 3 71ms 71ms 13 3 109ms 109ms 14 3 81ms 81ms 15 3 75ms 75ms 16 3 75ms 75ms 17 3 76ms 76ms 18 3 95ms 95ms 19 3 524ms 524ms 20 3 100ms 100ms 21 3 74ms 74ms 22 3 146ms 146ms 23 3 73ms 73ms Oct 14 00 3 71ms 71ms 01 3 70ms 70ms 02 3 71ms 71ms 03 3 74ms 74ms 04 3 70ms 70ms 05 3 72ms 72ms 06 289 3s293ms 2s18ms 07 7 4m32s 2m30s 08 3 74ms 74ms 09 3 76ms 76ms 10 3 124ms 124ms 11 3 95ms 95ms 12 3 76ms 76ms 13 3 114ms 114ms 14 3 112ms 112ms 15 3 109ms 109ms 16 3 91ms 91ms 17 3 73ms 73ms 18 3 103ms 103ms 19 3 114ms 114ms 20 3 77ms 77ms 21 3 79ms 79ms 22 3 71ms 71ms 23 3 75ms 75ms Oct 15 00 3 70ms 70ms 01 3 71ms 71ms 02 3 72ms 72ms 03 3 71ms 71ms 04 3 76ms 76ms 05 3 71ms 71ms 06 292 3s354ms 2s24ms 07 4 6m16s 6m16s 08 8 840ms 840ms 09 3 74ms 74ms 10 3 75ms 75ms 11 3 71ms 71ms 12 3 102ms 102ms 13 3 111ms 111ms 14 3 85ms 85ms 15 3 76ms 76ms 16 3 78ms 78ms 17 3 77ms 77ms 18 3 107ms 107ms 19 3 259ms 259ms 20 3 75ms 75ms 21 3 75ms 75ms 22 3 72ms 72ms 23 3 73ms 73ms Oct 16 00 3 70ms 70ms 01 3 70ms 70ms 02 3 70ms 70ms 03 3 71ms 71ms 04 3 72ms 72ms 05 3 74ms 74ms 06 283 3s255ms 1s531ms 07 13 2m26s 1m36s 08 3 90ms 90ms 09 3 72ms 72ms 10 3 84ms 84ms 11 3 79ms 79ms 12 4 204ms 204ms 13 6 208ms 208ms 14 3 84ms 84ms 15 3 108ms 108ms 16 3 76ms 76ms 17 3 90ms 90ms 18 3 119ms 119ms 19 3 136ms 136ms 20 3 92ms 92ms 21 3 72ms 72ms 22 3 73ms 73ms 23 3 70ms 70ms Oct 17 00 3 72ms 72ms 01 3 71ms 71ms 02 3 72ms 72ms 03 3 70ms 70ms 04 3 71ms 71ms 05 3 76ms 76ms 06 282 2s905ms 1s431ms 07 4 3m32s 3m32s 08 3 71ms 71ms 09 3 71ms 71ms 10 3 79ms 79ms 11 3 135ms 135ms 12 3 75ms 75ms 13 3 73ms 73ms 14 4 157ms 157ms 15 4 126ms 126ms 16 5 170ms 170ms 17 6 166ms 166ms 18 3 107ms 107ms 19 3 107ms 107ms 20 3 82ms 82ms 21 3 77ms 77ms 22 3 71ms 71ms 23 3 69ms 69ms Oct 18 00 3 71ms 71ms 01 3 69ms 69ms 02 3 72ms 72ms 03 3 76ms 76ms 04 3 73ms 73ms 05 3 70ms 70ms 06 3 72ms 72ms 07 3 70ms 70ms 08 3 76ms 76ms 09 5 169ms 169ms 10 3 71ms 71ms 11 3 71ms 71ms 12 3 76ms 76ms 13 3 78ms 78ms 14 3 75ms 75ms 15 5 154ms 154ms 16 3 75ms 75ms 17 3 96ms 96ms 18 3 120ms 120ms 19 3 78ms 78ms 20 3 71ms 71ms 21 3 75ms 75ms 22 3 89ms 89ms 23 3 70ms 70ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-10-16 06:47:46 Date
Connections per database
Key values
- autotest Main Database
- 1,933 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,933 connections Total
-
Sessions
Simultaneous sessions
Key values
- 80 sessions Session Peak
- 2025-10-18 17:50:23 Date
Histogram of session times
Key values
- 1,758 0-500ms duration
Sessions per database
Key values
- autotest Main Database
- 1,933 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,933 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,933 sessions Total
Sessions per application
Key values
- psql Main Application
- 1,933 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest' 1 12m13s 12m13s DBeaver 23.2.0 - Metadata 'autotest' 1 12m12s 12m12s DBeaver 23.2.0 - SQLEditor 'Script-3.sql' 1 12m10s 12m10s IntelliJ IDEA 2024.3.5 5 6s486ms 1s297ms [unknown] 485 48s182ms 99ms pg_dump 5 1h41m3s 20m12s psql 1,435 1h51m55s 4s679ms -
Temporary Files
Size of temporary files
Key values
- 387.04 MiB Temp Files size Peak
- 2025-10-14 06:51:12 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-10-15 06:44:35 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 12 00 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 13 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 197 4.27 GiB 22.17 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 14 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 199 4.25 GiB 21.89 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 15 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 198 4.25 GiB 21.99 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 16 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 195 4.23 GiB 22.22 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 17 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 197 4.24 GiB 22.03 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 18 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 Oct 12 00 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 13 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 14 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 16 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 17 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 18 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
- 4 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
- 2 Total read queries
- 164 Total write queries
Queries by database
Key values
- autotest Main database
- 176 Requests
- 1h14m4s (autotest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 176 Requests
User Request type Count Duration a3dsupervisor Total 176 1h14m4s copy to 29 10m8s ddl 135 28m45s others 10 34m58s select 2 12s67ms Duration by user
Key values
- 1h14m4s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 176 1h14m4s copy to 29 10m8s ddl 135 28m45s others 10 34m58s select 2 12s67ms Queries by host
Key values
- 10.3.0.4 Main host
- 176 Requests
- 1h14m4s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 147 Requests
- 1h3m56s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-14 07:41:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 104 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 8m21s VACUUM ANALYZE;[ Date: 2025-10-14 07:03:00 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 7m15s VACUUM ANALYSE;[ Date: 2025-10-13 07:04:31 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 5m22s VACUUM ANALYZE;[ Date: 2025-10-16 07:06:28 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 4m1s VACUUM ANALYSE;[ Date: 2025-10-14 07:07:45 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 3m20s VACUUM ANALYZE;[ Date: 2025-10-13 06:57:08 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 3m18s VACUUM ANALYSE;[ Date: 2025-10-16 07:10:30 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 2m33s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-13 07:09:25 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 1m19s VACUUM ANALYZE;[ Date: 2025-10-15 06:50:40 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 1m7s COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-10-13 07:06:47 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 57s746ms 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-10-16 06:55:42 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 47s339ms VACUUM ANALYZE;[ Date: 2025-10-17 06:51:38 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 45s186ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-16 06:59:27 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 42s357ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2025-10-13 07:10:11 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 40s344ms ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-16 06:53:44 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 39s838ms 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-10-17 06:50:03 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 38s793ms VACUUM ANALYSE;[ Date: 2025-10-17 06:52:24 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 38s247ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-14 07:09:18 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 36s389ms 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-10-15 06:48:35 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 34s634ms 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-10-14 06:51:12 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 32s834ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);[ Date: 2025-10-17 06:45:09 - Database: autotest - 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 19m11s 5 47s339ms 8m21s 3m50s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 08 1 3m20s 3m20s Oct 14 09 1 8m21s 8m21s Oct 15 08 1 1m19s 1m19s Oct 16 09 1 5m22s 5m22s Oct 17 08 1 47s339ms 47s339ms [ User: a3dsupervisor - Total duration: 19m11s - Times executed: 5 ]
[ Application: psql - Total duration: 19m11s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-14 07:03:00 Duration: 8m21s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-16 07:06:28 Duration: 5m22s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-13 06:57:08 Duration: 3m20s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 15m46s 5 32s445ms 7m15s 3m9s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 09 1 7m15s 7m15s Oct 14 09 1 4m1s 4m1s Oct 15 08 1 32s445ms 32s445ms Oct 16 09 1 3m18s 3m18s Oct 17 08 1 38s793ms 38s793ms [ User: a3dsupervisor - Total duration: 15m46s - Times executed: 5 ]
[ Application: psql - Total duration: 15m46s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-13 07:04:31 Duration: 7m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-14 07:07:45 Duration: 4m1s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-16 07:10:30 Duration: 3m18s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4m2s 5 7s971ms 2m33s 48s557ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 09 1 2m33s 2m33s Oct 14 09 1 38s247ms 38s247ms Oct 15 08 1 11s267ms 11s267ms Oct 16 09 1 31s713ms 31s713ms Oct 17 08 1 7s971ms 7s971ms [ User: a3dsupervisor - Total duration: 4m2s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4m2s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-13 07:09:25 Duration: 2m33s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-14 07:09:18 Duration: 38s247ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-16 07:11:35 Duration: 31s713ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 3m18s 5 29s876ms 57s746ms 39s697ms 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 Oct 13 08 1 29s876ms 29s876ms Oct 14 08 1 34s634ms 34s634ms Oct 15 08 1 36s389ms 36s389ms Oct 16 08 1 57s746ms 57s746ms Oct 17 08 1 39s838ms 39s838ms [ User: a3dsupervisor - Total duration: 3m18s - Times executed: 5 ]
[ Application: psql - Total duration: 3m18s - 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-10-16 06:55:42 Duration: 57s746ms Database: autotest 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-10-17 06:50:03 Duration: 39s838ms Database: autotest 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-10-15 06:48:35 Duration: 36s389ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1m47s 5 5s813ms 1m7s 21s417ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 09 1 1m7s 1m7s Oct 14 09 1 19s651ms 19s651ms Oct 15 08 1 5s907ms 5s907ms Oct 16 09 1 8s194ms 8s194ms Oct 17 08 1 5s813ms 5s813ms [ User: a3dsupervisor - Total duration: 1m47s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-13 07:06:47 Duration: 1m7s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-14 07:08:32 Duration: 19s651ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-16 07:11:03 Duration: 8s194ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 1m39s 5 9s370ms 31s925ms 19s987ms 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 #6
Day Hour Count Duration Avg duration Oct 13 08 1 21s936ms 21s936ms Oct 14 08 1 9s370ms 9s370ms Oct 15 08 1 18s294ms 18s294ms Oct 16 08 1 18s408ms 18s408ms Oct 17 08 1 31s925ms 31s925ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: psql - Total duration: 1m39s - 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-10-17 06:44:10 Duration: 31s925ms Database: autotest 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-10-13 06:47:24 Duration: 21s936ms Database: autotest 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-10-16 06:48:28 Duration: 18s408ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1m34s 5 10s224ms 25s910ms 18s924ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 08 1 19s578ms 19s578ms Oct 14 08 1 25s910ms 25s910ms Oct 15 08 1 10s224ms 10s224ms Oct 16 08 1 20s896ms 20s896ms Oct 17 08 1 18s10ms 18s10ms [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 5 ]
[ Application: psql - Total duration: 1m34s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-14 06:49:07 Duration: 25s910ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-16 06:51:29 Duration: 20s896ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-13 06:51:02 Duration: 19s578ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 1m30s 5 6s781ms 42s357ms 18s189ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 09 1 42s357ms 42s357ms Oct 14 09 1 20s4ms 20s4ms Oct 15 08 1 6s781ms 6s781ms Oct 16 09 1 11s617ms 11s617ms Oct 17 08 1 10s185ms 10s185ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-13 07:10:11 Duration: 42s357ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-14 07:09:38 Duration: 20s4ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-16 07:11:48 Duration: 11s617ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1m26s 5 14s802ms 19s780ms 17s223ms 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 #9
Day Hour Count Duration Avg duration Oct 13 08 1 14s802ms 14s802ms Oct 14 08 1 18s519ms 18s519ms Oct 15 08 1 18s3ms 18s3ms Oct 16 08 1 15s10ms 15s10ms Oct 17 08 1 19s780ms 19s780ms [ User: a3dsupervisor - Total duration: 1m26s - Times executed: 5 ]
[ Application: psql - Total duration: 1m26s - 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-10-17 06:49:14 Duration: 19s780ms Database: autotest 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-10-14 06:50:21 Duration: 18s519ms Database: autotest 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-10-15 06:47:48 Duration: 18s3ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m20s 5 6s240ms 32s834ms 16s122ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 08 1 22s979ms 22s979ms Oct 14 08 1 6s769ms 6s769ms Oct 15 08 1 11s788ms 11s788ms Oct 16 08 1 6s240ms 6s240ms Oct 17 08 1 32s834ms 32s834ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 5 ]
[ Application: psql - Total duration: 1m20s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-17 06:45:09 Duration: 32s834ms Database: autotest 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-10-13 06:48:05 Duration: 22s979ms Database: autotest 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-10-15 06:43:49 Duration: 11s788ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1m17s 5 6s359ms 25s535ms 15s461ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 09 1 25s535ms 25s535ms Oct 14 09 1 20s650ms 20s650ms Oct 15 08 1 6s359ms 6s359ms Oct 16 09 1 17s645ms 17s645ms Oct 17 08 1 7s116ms 7s116ms [ User: a3dsupervisor - Total duration: 1m17s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m17s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-13 07:11:04 Duration: 25s535ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-14 07:10:10 Duration: 20s650ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-16 07:12:13 Duration: 17s645ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 1m14s 5 6s523ms 40s344ms 14s964ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 08 1 12s217ms 12s217ms Oct 14 08 1 8s157ms 8s157ms Oct 15 08 1 7s581ms 7s581ms Oct 16 08 1 40s344ms 40s344ms Oct 17 08 1 6s523ms 6s523ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 5 ]
[ Application: psql - Total duration: 1m14s - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-16 06:53:44 Duration: 40s344ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-13 06:51:42 Duration: 12s217ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-14 06:49:43 Duration: 8s157ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1m2s 5 10s214ms 15s450ms 12s599ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 08 1 10s214ms 10s214ms Oct 14 08 1 10s705ms 10s705ms Oct 15 08 1 14s766ms 14s766ms Oct 16 08 1 15s450ms 15s450ms Oct 17 08 1 11s860ms 11s860ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-16 06:54:04 Duration: 15s450ms Database: autotest 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-10-15 06:47:24 Duration: 14s766ms Database: autotest 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-10-17 06:48:48 Duration: 11s860ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 59s74ms 5 9s910ms 17s767ms 11s814ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 08 1 9s910ms 9s910ms Oct 14 08 1 10s339ms 10s339ms Oct 15 08 1 10s688ms 10s688ms Oct 16 08 1 17s767ms 17s767ms Oct 17 08 1 10s369ms 10s369ms [ User: a3dsupervisor - Total duration: 59s74ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s74ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-16 06:51:47 Duration: 17s767ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-15 06:46:37 Duration: 10s688ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-17 06:48:09 Duration: 10s369ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 57s665ms 5 8s306ms 13s608ms 11s533ms 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 #15
Day Hour Count Duration Avg duration Oct 13 08 1 8s306ms 8s306ms Oct 14 08 1 13s317ms 13s317ms Oct 15 08 1 10s66ms 10s66ms Oct 16 08 1 13s608ms 13s608ms Oct 17 08 1 12s366ms 12s366ms [ User: a3dsupervisor - Total duration: 57s665ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s665ms - 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-10-16 06:50:22 Duration: 13s608ms Database: autotest 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-10-14 06:47:52 Duration: 13s317ms Database: autotest 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-10-17 06:46:56 Duration: 12s366ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 56s798ms 5 8s24ms 13s336ms 11s359ms 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 Oct 13 08 1 13s336ms 13s336ms Oct 14 08 1 11s71ms 11s71ms Oct 15 08 1 8s24ms 8s24ms Oct 16 08 1 13s236ms 13s236ms Oct 17 08 1 11s128ms 11s128ms [ User: a3dsupervisor - Total duration: 56s798ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s798ms - 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-10-13 06:50:05 Duration: 13s336ms Database: autotest 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-10-16 06:50:35 Duration: 13s236ms Database: autotest 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-10-17 06:47:07 Duration: 11s128ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 55s815ms 5 10s157ms 13s243ms 11s163ms 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 #17
Day Hour Count Duration Avg duration Oct 13 08 1 10s157ms 10s157ms Oct 14 08 1 10s813ms 10s813ms Oct 15 08 1 13s243ms 13s243ms Oct 16 08 1 10s781ms 10s781ms Oct 17 08 1 10s818ms 10s818ms [ User: a3dsupervisor - Total duration: 55s815ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s815ms - 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-10-15 06:45:09 Duration: 13s243ms Database: autotest 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-10-17 06:46:32 Duration: 10s818ms Database: autotest 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-10-14 06:47:28 Duration: 10s813ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 55s231ms 5 6s931ms 13s593ms 11s46ms 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 #18
Day Hour Count Duration Avg duration Oct 13 08 1 13s503ms 13s503ms Oct 14 08 1 6s931ms 6s931ms Oct 15 08 1 12s796ms 12s796ms Oct 16 08 1 13s593ms 13s593ms Oct 17 08 1 8s407ms 8s407ms [ User: a3dsupervisor - Total duration: 55s231ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s231ms - 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-10-16 06:50:48 Duration: 13s593ms Database: autotest 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-10-13 06:50:18 Duration: 13s503ms Database: autotest 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-10-15 06:45:51 Duration: 12s796ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 54s896ms 5 10s338ms 11s748ms 10s979ms 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 #19
Day Hour Count Duration Avg duration Oct 13 08 1 10s338ms 10s338ms Oct 14 08 1 10s613ms 10s613ms Oct 15 08 1 11s5ms 11s5ms Oct 16 08 1 11s190ms 11s190ms Oct 17 08 1 11s748ms 11s748ms [ User: a3dsupervisor - Total duration: 54s896ms - Times executed: 5 ]
[ Application: psql - Total duration: 54s896ms - 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-10-17 06:46:44 Duration: 11s748ms Database: autotest 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-10-16 06:50:08 Duration: 11s190ms Database: autotest 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-10-15 06:45:20 Duration: 11s5ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 53s562ms 2 8s375ms 45s186ms 26s781ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_objt foreign key (obj_template_num_id) references gtp_obj_template (obj_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 14 08 1 8s375ms 8s375ms Oct 16 08 1 45s186ms 45s186ms [ User: a3dsupervisor - Total duration: 53s562ms - Times executed: 2 ]
[ Application: psql - Total duration: 53s562ms - Times executed: 2 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-16 06:59:27 Duration: 45s186ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-14 06:53:16 Duration: 8s375ms Database: autotest 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 5 19m11s 47s339ms 8m21s 3m50s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 08 1 3m20s 3m20s Oct 14 09 1 8m21s 8m21s Oct 15 08 1 1m19s 1m19s Oct 16 09 1 5m22s 5m22s Oct 17 08 1 47s339ms 47s339ms [ User: a3dsupervisor - Total duration: 19m11s - Times executed: 5 ]
[ Application: psql - Total duration: 19m11s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-14 07:03:00 Duration: 8m21s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-16 07:06:28 Duration: 5m22s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-13 06:57:08 Duration: 3m20s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 5 15m46s 32s445ms 7m15s 3m9s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 09 1 7m15s 7m15s Oct 14 09 1 4m1s 4m1s Oct 15 08 1 32s445ms 32s445ms Oct 16 09 1 3m18s 3m18s Oct 17 08 1 38s793ms 38s793ms [ User: a3dsupervisor - Total duration: 15m46s - Times executed: 5 ]
[ Application: psql - Total duration: 15m46s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-13 07:04:31 Duration: 7m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-14 07:07:45 Duration: 4m1s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-16 07:10:30 Duration: 3m18s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 5 4m2s 7s971ms 2m33s 48s557ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 09 1 2m33s 2m33s Oct 14 09 1 38s247ms 38s247ms Oct 15 08 1 11s267ms 11s267ms Oct 16 09 1 31s713ms 31s713ms Oct 17 08 1 7s971ms 7s971ms [ User: a3dsupervisor - Total duration: 4m2s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4m2s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-13 07:09:25 Duration: 2m33s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-14 07:09:18 Duration: 38s247ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-16 07:11:35 Duration: 31s713ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 5 3m18s 29s876ms 57s746ms 39s697ms 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 Oct 13 08 1 29s876ms 29s876ms Oct 14 08 1 34s634ms 34s634ms Oct 15 08 1 36s389ms 36s389ms Oct 16 08 1 57s746ms 57s746ms Oct 17 08 1 39s838ms 39s838ms [ User: a3dsupervisor - Total duration: 3m18s - Times executed: 5 ]
[ Application: psql - Total duration: 3m18s - 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-10-16 06:55:42 Duration: 57s746ms Database: autotest 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-10-17 06:50:03 Duration: 39s838ms Database: autotest 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-10-15 06:48:35 Duration: 36s389ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 5 1m47s 5s813ms 1m7s 21s417ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 09 1 1m7s 1m7s Oct 14 09 1 19s651ms 19s651ms Oct 15 08 1 5s907ms 5s907ms Oct 16 09 1 8s194ms 8s194ms Oct 17 08 1 5s813ms 5s813ms [ User: a3dsupervisor - Total duration: 1m47s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-13 07:06:47 Duration: 1m7s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-14 07:08:32 Duration: 19s651ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-16 07:11:03 Duration: 8s194ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 5 1m39s 9s370ms 31s925ms 19s987ms 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 #6
Day Hour Count Duration Avg duration Oct 13 08 1 21s936ms 21s936ms Oct 14 08 1 9s370ms 9s370ms Oct 15 08 1 18s294ms 18s294ms Oct 16 08 1 18s408ms 18s408ms Oct 17 08 1 31s925ms 31s925ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: psql - Total duration: 1m39s - 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-10-17 06:44:10 Duration: 31s925ms Database: autotest 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-10-13 06:47:24 Duration: 21s936ms Database: autotest 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-10-16 06:48:28 Duration: 18s408ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 5 1m34s 10s224ms 25s910ms 18s924ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 08 1 19s578ms 19s578ms Oct 14 08 1 25s910ms 25s910ms Oct 15 08 1 10s224ms 10s224ms Oct 16 08 1 20s896ms 20s896ms Oct 17 08 1 18s10ms 18s10ms [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 5 ]
[ Application: psql - Total duration: 1m34s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-14 06:49:07 Duration: 25s910ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-16 06:51:29 Duration: 20s896ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-13 06:51:02 Duration: 19s578ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 5 1m30s 6s781ms 42s357ms 18s189ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 09 1 42s357ms 42s357ms Oct 14 09 1 20s4ms 20s4ms Oct 15 08 1 6s781ms 6s781ms Oct 16 09 1 11s617ms 11s617ms Oct 17 08 1 10s185ms 10s185ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-13 07:10:11 Duration: 42s357ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-14 07:09:38 Duration: 20s4ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-16 07:11:48 Duration: 11s617ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 5 1m26s 14s802ms 19s780ms 17s223ms 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 #9
Day Hour Count Duration Avg duration Oct 13 08 1 14s802ms 14s802ms Oct 14 08 1 18s519ms 18s519ms Oct 15 08 1 18s3ms 18s3ms Oct 16 08 1 15s10ms 15s10ms Oct 17 08 1 19s780ms 19s780ms [ User: a3dsupervisor - Total duration: 1m26s - Times executed: 5 ]
[ Application: psql - Total duration: 1m26s - 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-10-17 06:49:14 Duration: 19s780ms Database: autotest 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-10-14 06:50:21 Duration: 18s519ms Database: autotest 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-10-15 06:47:48 Duration: 18s3ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 5 1m20s 6s240ms 32s834ms 16s122ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 08 1 22s979ms 22s979ms Oct 14 08 1 6s769ms 6s769ms Oct 15 08 1 11s788ms 11s788ms Oct 16 08 1 6s240ms 6s240ms Oct 17 08 1 32s834ms 32s834ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 5 ]
[ Application: psql - Total duration: 1m20s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-17 06:45:09 Duration: 32s834ms Database: autotest 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-10-13 06:48:05 Duration: 22s979ms Database: autotest 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-10-15 06:43:49 Duration: 11s788ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 1m17s 6s359ms 25s535ms 15s461ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 09 1 25s535ms 25s535ms Oct 14 09 1 20s650ms 20s650ms Oct 15 08 1 6s359ms 6s359ms Oct 16 09 1 17s645ms 17s645ms Oct 17 08 1 7s116ms 7s116ms [ User: a3dsupervisor - Total duration: 1m17s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m17s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-13 07:11:04 Duration: 25s535ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-14 07:10:10 Duration: 20s650ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-16 07:12:13 Duration: 17s645ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 5 1m14s 6s523ms 40s344ms 14s964ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 08 1 12s217ms 12s217ms Oct 14 08 1 8s157ms 8s157ms Oct 15 08 1 7s581ms 7s581ms Oct 16 08 1 40s344ms 40s344ms Oct 17 08 1 6s523ms 6s523ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 5 ]
[ Application: psql - Total duration: 1m14s - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-16 06:53:44 Duration: 40s344ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-13 06:51:42 Duration: 12s217ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-14 06:49:43 Duration: 8s157ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 5 1m2s 10s214ms 15s450ms 12s599ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 08 1 10s214ms 10s214ms Oct 14 08 1 10s705ms 10s705ms Oct 15 08 1 14s766ms 14s766ms Oct 16 08 1 15s450ms 15s450ms Oct 17 08 1 11s860ms 11s860ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-16 06:54:04 Duration: 15s450ms Database: autotest 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-10-15 06:47:24 Duration: 14s766ms Database: autotest 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-10-17 06:48:48 Duration: 11s860ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 59s74ms 9s910ms 17s767ms 11s814ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 08 1 9s910ms 9s910ms Oct 14 08 1 10s339ms 10s339ms Oct 15 08 1 10s688ms 10s688ms Oct 16 08 1 17s767ms 17s767ms Oct 17 08 1 10s369ms 10s369ms [ User: a3dsupervisor - Total duration: 59s74ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s74ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-16 06:51:47 Duration: 17s767ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-15 06:46:37 Duration: 10s688ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-17 06:48:09 Duration: 10s369ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5 57s665ms 8s306ms 13s608ms 11s533ms 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 #15
Day Hour Count Duration Avg duration Oct 13 08 1 8s306ms 8s306ms Oct 14 08 1 13s317ms 13s317ms Oct 15 08 1 10s66ms 10s66ms Oct 16 08 1 13s608ms 13s608ms Oct 17 08 1 12s366ms 12s366ms [ User: a3dsupervisor - Total duration: 57s665ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s665ms - 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-10-16 06:50:22 Duration: 13s608ms Database: autotest 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-10-14 06:47:52 Duration: 13s317ms Database: autotest 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-10-17 06:46:56 Duration: 12s366ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 56s798ms 8s24ms 13s336ms 11s359ms 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 Oct 13 08 1 13s336ms 13s336ms Oct 14 08 1 11s71ms 11s71ms Oct 15 08 1 8s24ms 8s24ms Oct 16 08 1 13s236ms 13s236ms Oct 17 08 1 11s128ms 11s128ms [ User: a3dsupervisor - Total duration: 56s798ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s798ms - 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-10-13 06:50:05 Duration: 13s336ms Database: autotest 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-10-16 06:50:35 Duration: 13s236ms Database: autotest 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-10-17 06:47:07 Duration: 11s128ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5 55s815ms 10s157ms 13s243ms 11s163ms 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 #17
Day Hour Count Duration Avg duration Oct 13 08 1 10s157ms 10s157ms Oct 14 08 1 10s813ms 10s813ms Oct 15 08 1 13s243ms 13s243ms Oct 16 08 1 10s781ms 10s781ms Oct 17 08 1 10s818ms 10s818ms [ User: a3dsupervisor - Total duration: 55s815ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s815ms - 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-10-15 06:45:09 Duration: 13s243ms Database: autotest 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-10-17 06:46:32 Duration: 10s818ms Database: autotest 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-10-14 06:47:28 Duration: 10s813ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5 55s231ms 6s931ms 13s593ms 11s46ms 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 #18
Day Hour Count Duration Avg duration Oct 13 08 1 13s503ms 13s503ms Oct 14 08 1 6s931ms 6s931ms Oct 15 08 1 12s796ms 12s796ms Oct 16 08 1 13s593ms 13s593ms Oct 17 08 1 8s407ms 8s407ms [ User: a3dsupervisor - Total duration: 55s231ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s231ms - 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-10-16 06:50:48 Duration: 13s593ms Database: autotest 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-10-13 06:50:18 Duration: 13s503ms Database: autotest 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-10-15 06:45:51 Duration: 12s796ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5 54s896ms 10s338ms 11s748ms 10s979ms 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 #19
Day Hour Count Duration Avg duration Oct 13 08 1 10s338ms 10s338ms Oct 14 08 1 10s613ms 10s613ms Oct 15 08 1 11s5ms 11s5ms Oct 16 08 1 11s190ms 11s190ms Oct 17 08 1 11s748ms 11s748ms [ User: a3dsupervisor - Total duration: 54s896ms - Times executed: 5 ]
[ Application: psql - Total duration: 54s896ms - 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-10-17 06:46:44 Duration: 11s748ms Database: autotest 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-10-16 06:50:08 Duration: 11s190ms Database: autotest 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-10-15 06:45:20 Duration: 11s5ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5 49s695ms 5s896ms 13s402ms 9s939ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 08 1 13s402ms 13s402ms Oct 14 08 1 10s492ms 10s492ms Oct 15 08 1 8s499ms 8s499ms Oct 16 08 1 5s896ms 5s896ms Oct 17 08 1 11s404ms 11s404ms [ User: a3dsupervisor - Total duration: 49s695ms - Times executed: 5 ]
[ Application: psql - Total duration: 49s695ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-13 06:48:18 Duration: 13s402ms Database: autotest 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-10-17 06:45:21 Duration: 11s404ms Database: autotest 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-10-14 06:46:22 Duration: 10s492ms Database: autotest 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 47s339ms 8m21s 3m50s 5 19m11s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 08 1 3m20s 3m20s Oct 14 09 1 8m21s 8m21s Oct 15 08 1 1m19s 1m19s Oct 16 09 1 5m22s 5m22s Oct 17 08 1 47s339ms 47s339ms [ User: a3dsupervisor - Total duration: 19m11s - Times executed: 5 ]
[ Application: psql - Total duration: 19m11s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-14 07:03:00 Duration: 8m21s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-16 07:06:28 Duration: 5m22s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-13 06:57:08 Duration: 3m20s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 32s445ms 7m15s 3m9s 5 15m46s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 09 1 7m15s 7m15s Oct 14 09 1 4m1s 4m1s Oct 15 08 1 32s445ms 32s445ms Oct 16 09 1 3m18s 3m18s Oct 17 08 1 38s793ms 38s793ms [ User: a3dsupervisor - Total duration: 15m46s - Times executed: 5 ]
[ Application: psql - Total duration: 15m46s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-13 07:04:31 Duration: 7m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-14 07:07:45 Duration: 4m1s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-16 07:10:30 Duration: 3m18s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 7s971ms 2m33s 48s557ms 5 4m2s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 09 1 2m33s 2m33s Oct 14 09 1 38s247ms 38s247ms Oct 15 08 1 11s267ms 11s267ms Oct 16 09 1 31s713ms 31s713ms Oct 17 08 1 7s971ms 7s971ms [ User: a3dsupervisor - Total duration: 4m2s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4m2s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-13 07:09:25 Duration: 2m33s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-14 07:09:18 Duration: 38s247ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-16 07:11:35 Duration: 31s713ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 29s876ms 57s746ms 39s697ms 5 3m18s 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 Oct 13 08 1 29s876ms 29s876ms Oct 14 08 1 34s634ms 34s634ms Oct 15 08 1 36s389ms 36s389ms Oct 16 08 1 57s746ms 57s746ms Oct 17 08 1 39s838ms 39s838ms [ User: a3dsupervisor - Total duration: 3m18s - Times executed: 5 ]
[ Application: psql - Total duration: 3m18s - 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-10-16 06:55:42 Duration: 57s746ms Database: autotest 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-10-17 06:50:03 Duration: 39s838ms Database: autotest 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-10-15 06:48:35 Duration: 36s389ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 8s375ms 45s186ms 26s781ms 2 53s562ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_objt foreign key (obj_template_num_id) references gtp_obj_template (obj_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 14 08 1 8s375ms 8s375ms Oct 16 08 1 45s186ms 45s186ms [ User: a3dsupervisor - Total duration: 53s562ms - Times executed: 2 ]
[ Application: psql - Total duration: 53s562ms - Times executed: 2 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-16 06:59:27 Duration: 45s186ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-14 06:53:16 Duration: 8s375ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 5s813ms 1m7s 21s417ms 5 1m47s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 13 09 1 1m7s 1m7s Oct 14 09 1 19s651ms 19s651ms Oct 15 08 1 5s907ms 5s907ms Oct 16 09 1 8s194ms 8s194ms Oct 17 08 1 5s813ms 5s813ms [ User: a3dsupervisor - Total duration: 1m47s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-13 07:06:47 Duration: 1m7s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-14 07:08:32 Duration: 19s651ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-16 07:11:03 Duration: 8s194ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 9s370ms 31s925ms 19s987ms 5 1m39s 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 #7
Day Hour Count Duration Avg duration Oct 13 08 1 21s936ms 21s936ms Oct 14 08 1 9s370ms 9s370ms Oct 15 08 1 18s294ms 18s294ms Oct 16 08 1 18s408ms 18s408ms Oct 17 08 1 31s925ms 31s925ms [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 5 ]
[ Application: psql - Total duration: 1m39s - 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-10-17 06:44:10 Duration: 31s925ms Database: autotest 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-10-13 06:47:24 Duration: 21s936ms Database: autotest 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-10-16 06:48:28 Duration: 18s408ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 10s224ms 25s910ms 18s924ms 5 1m34s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 08 1 19s578ms 19s578ms Oct 14 08 1 25s910ms 25s910ms Oct 15 08 1 10s224ms 10s224ms Oct 16 08 1 20s896ms 20s896ms Oct 17 08 1 18s10ms 18s10ms [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 5 ]
[ Application: psql - Total duration: 1m34s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-14 06:49:07 Duration: 25s910ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-16 06:51:29 Duration: 20s896ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-13 06:51:02 Duration: 19s578ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 6s781ms 42s357ms 18s189ms 5 1m30s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 09 1 42s357ms 42s357ms Oct 14 09 1 20s4ms 20s4ms Oct 15 08 1 6s781ms 6s781ms Oct 16 09 1 11s617ms 11s617ms Oct 17 08 1 10s185ms 10s185ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-13 07:10:11 Duration: 42s357ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-14 07:09:38 Duration: 20s4ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-16 07:11:48 Duration: 11s617ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 14s802ms 19s780ms 17s223ms 5 1m26s 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 #10
Day Hour Count Duration Avg duration Oct 13 08 1 14s802ms 14s802ms Oct 14 08 1 18s519ms 18s519ms Oct 15 08 1 18s3ms 18s3ms Oct 16 08 1 15s10ms 15s10ms Oct 17 08 1 19s780ms 19s780ms [ User: a3dsupervisor - Total duration: 1m26s - Times executed: 5 ]
[ Application: psql - Total duration: 1m26s - 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-10-17 06:49:14 Duration: 19s780ms Database: autotest 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-10-14 06:50:21 Duration: 18s519ms Database: autotest 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-10-15 06:47:48 Duration: 18s3ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 6s240ms 32s834ms 16s122ms 5 1m20s create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 08 1 22s979ms 22s979ms Oct 14 08 1 6s769ms 6s769ms Oct 15 08 1 11s788ms 11s788ms Oct 16 08 1 6s240ms 6s240ms Oct 17 08 1 32s834ms 32s834ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 5 ]
[ Application: psql - Total duration: 1m20s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-17 06:45:09 Duration: 32s834ms Database: autotest 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-10-13 06:48:05 Duration: 22s979ms Database: autotest 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-10-15 06:43:49 Duration: 11s788ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 6s359ms 25s535ms 15s461ms 5 1m17s copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 09 1 25s535ms 25s535ms Oct 14 09 1 20s650ms 20s650ms Oct 15 08 1 6s359ms 6s359ms Oct 16 09 1 17s645ms 17s645ms Oct 17 08 1 7s116ms 7s116ms [ User: a3dsupervisor - Total duration: 1m17s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m17s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-13 07:11:04 Duration: 25s535ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-14 07:10:10 Duration: 20s650ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-16 07:12:13 Duration: 17s645ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 6s523ms 40s344ms 14s964ms 5 1m14s alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 08 1 12s217ms 12s217ms Oct 14 08 1 8s157ms 8s157ms Oct 15 08 1 7s581ms 7s581ms Oct 16 08 1 40s344ms 40s344ms Oct 17 08 1 6s523ms 6s523ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 5 ]
[ Application: psql - Total duration: 1m14s - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-16 06:53:44 Duration: 40s344ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-13 06:51:42 Duration: 12s217ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-14 06:49:43 Duration: 8s157ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 10s214ms 15s450ms 12s599ms 5 1m2s alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 08 1 10s214ms 10s214ms Oct 14 08 1 10s705ms 10s705ms Oct 15 08 1 14s766ms 14s766ms Oct 16 08 1 15s450ms 15s450ms Oct 17 08 1 11s860ms 11s860ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-16 06:54:04 Duration: 15s450ms Database: autotest 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-10-15 06:47:24 Duration: 14s766ms Database: autotest 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-10-17 06:48:48 Duration: 11s860ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 9s910ms 17s767ms 11s814ms 5 59s74ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 08 1 9s910ms 9s910ms Oct 14 08 1 10s339ms 10s339ms Oct 15 08 1 10s688ms 10s688ms Oct 16 08 1 17s767ms 17s767ms Oct 17 08 1 10s369ms 10s369ms [ User: a3dsupervisor - Total duration: 59s74ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s74ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-16 06:51:47 Duration: 17s767ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-15 06:46:37 Duration: 10s688ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-17 06:48:09 Duration: 10s369ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 8s306ms 13s608ms 11s533ms 5 57s665ms 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 #16
Day Hour Count Duration Avg duration Oct 13 08 1 8s306ms 8s306ms Oct 14 08 1 13s317ms 13s317ms Oct 15 08 1 10s66ms 10s66ms Oct 16 08 1 13s608ms 13s608ms Oct 17 08 1 12s366ms 12s366ms [ User: a3dsupervisor - Total duration: 57s665ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s665ms - 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-10-16 06:50:22 Duration: 13s608ms Database: autotest 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-10-14 06:47:52 Duration: 13s317ms Database: autotest 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-10-17 06:46:56 Duration: 12s366ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 8s24ms 13s336ms 11s359ms 5 56s798ms 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 Oct 13 08 1 13s336ms 13s336ms Oct 14 08 1 11s71ms 11s71ms Oct 15 08 1 8s24ms 8s24ms Oct 16 08 1 13s236ms 13s236ms Oct 17 08 1 11s128ms 11s128ms [ User: a3dsupervisor - Total duration: 56s798ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s798ms - 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-10-13 06:50:05 Duration: 13s336ms Database: autotest 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-10-16 06:50:35 Duration: 13s236ms Database: autotest 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-10-17 06:47:07 Duration: 11s128ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 10s157ms 13s243ms 11s163ms 5 55s815ms 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 #18
Day Hour Count Duration Avg duration Oct 13 08 1 10s157ms 10s157ms Oct 14 08 1 10s813ms 10s813ms Oct 15 08 1 13s243ms 13s243ms Oct 16 08 1 10s781ms 10s781ms Oct 17 08 1 10s818ms 10s818ms [ User: a3dsupervisor - Total duration: 55s815ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s815ms - 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-10-15 06:45:09 Duration: 13s243ms Database: autotest 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-10-17 06:46:32 Duration: 10s818ms Database: autotest 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-10-14 06:47:28 Duration: 10s813ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 6s931ms 13s593ms 11s46ms 5 55s231ms 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 Oct 13 08 1 13s503ms 13s503ms Oct 14 08 1 6s931ms 6s931ms Oct 15 08 1 12s796ms 12s796ms Oct 16 08 1 13s593ms 13s593ms Oct 17 08 1 8s407ms 8s407ms [ User: a3dsupervisor - Total duration: 55s231ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s231ms - 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-10-16 06:50:48 Duration: 13s593ms Database: autotest 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-10-13 06:50:18 Duration: 13s503ms Database: autotest 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-10-15 06:45:51 Duration: 12s796ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 10s338ms 11s748ms 10s979ms 5 54s896ms 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 #20
Day Hour Count Duration Avg duration Oct 13 08 1 10s338ms 10s338ms Oct 14 08 1 10s613ms 10s613ms Oct 15 08 1 11s5ms 11s5ms Oct 16 08 1 11s190ms 11s190ms Oct 17 08 1 11s748ms 11s748ms [ User: a3dsupervisor - Total duration: 54s896ms - Times executed: 5 ]
[ Application: psql - Total duration: 54s896ms - 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-10-17 06:46:44 Duration: 11s748ms Database: autotest 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-10-16 06:50:08 Duration: 11s190ms Database: autotest 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-10-15 06:45:20 Duration: 11s5ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 7,051 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 5 ERROR entries
- 80 WARNING entries
Most Frequent Errors/Events
Key values
- 80 Max number of times the same event was reported
- 85 Total events found
Rank Times reported Error 1 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 13 08 16 Oct 14 08 16 Oct 15 08 16 Oct 16 08 16 Oct 17 08 16 2 3 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 #2
Day Hour Count Oct 13 08 1 Oct 15 08 1 Oct 17 08 1 3 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 17 09 1 4 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON gtp_obj_composition (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 13 08 1