pgBadger-
Global information
- Generated on Thu Nov 13 09:07:46 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=12/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=12/h=23/m=00/PT1H.log
- Parsed 3,560 log entries in 59s
- Log start from 2025-11-12 10:39:23 to 2025-11-12 18:01:08
-
Overview
Global Stats
- 11 Number of unique normalized queries
- 46 Number of queries
- 14m31s Total query duration
- 2025-11-12 01:01:07 First query
- 2025-11-12 20:42:22 Last query
- 4 queries/s at 2025-11-12 08:05:10 Query peak
- 14m31s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 14m31s Execute total duration
- 117 Number of events
- 25 Number of unique normalized events
- 24 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
- 82 Number temporary file
- 109.23 MiB Max size of temporary file
- 4.23 MiB Average size of temporary file
- 1,048 Total number of sessions
- 111 sessions at 2025-11-12 19:58:13 Session peak
- 4d16m43s Total duration of sessions
- 5m30s Average duration of sessions
- 0 Average queries per session
- 831ms Average queries duration per session
- 5m29s Average idle time per session
- 1,048 Total number of connections
- 6 connections/s at 2025-11-12 10:26:04 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-12 08:05:10 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-12 11:39:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-12 08:05:10 Date
Queries duration
Key values
- 14m31s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 12 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 10s761ms 10s761ms 0ms 0ms 10s761ms 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 11 0ms 9s838ms 7s77ms 13s315ms 19s285ms 26s85ms 08 12 0ms 8s457ms 6s573ms 11s763ms 24s827ms 26s23ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 1 0ms 11s78ms 11s78ms 0ms 0ms 11s78ms 11 3 0ms 3m7s 1m6s 0ms 6s622ms 3m7s 12 11 0ms 2m39s 41s272ms 31s764ms 49s954ms 2m39s 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 7 0ms 6s601ms 5s687ms 0ms 6s601ms 16s730ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 12 00 0 0 0ms 0ms 0ms 0ms 01 1 0 10s761ms 0ms 0ms 10s761ms 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 1 0 8s115ms 0ms 0ms 8s115ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 2 0 5s984ms 0ms 0ms 6s622ms 12 4 0 6s311ms 0ms 0ms 12s6ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 12 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 0 0 8s131ms 0ms 0ms 0ms 08 2 0 0 0 5s202ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 1 0 11s78ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 3 0 42s632ms 0ms 0ms 46s177ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 12 00 0 0 0.00 0.00% 01 0 1 1.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 11 11.00 0.00% 08 0 12 12.00 0.00% 09 0 0 0.00 0.00% 10 0 1 1.00 0.00% 11 0 3 3.00 0.00% 12 0 11 11.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 7 7.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 12 00 26 0.01/s 01 35 0.01/s 02 52 0.01/s 03 44 0.01/s 04 48 0.01/s 05 44 0.01/s 06 41 0.01/s 07 40 0.01/s 08 37 0.01/s 09 38 0.01/s 10 68 0.02/s 11 75 0.02/s 12 58 0.02/s 13 47 0.01/s 14 34 0.01/s 15 50 0.01/s 16 42 0.01/s 17 31 0.01/s 18 25 0.01/s 19 44 0.01/s 20 38 0.01/s 21 34 0.01/s 22 64 0.02/s 23 33 0.01/s Day Hour Count Average Duration Average idle time Nov 12 00 29 2m37s 2m37s 01 34 2m9s 2m8s 02 49 1m47s 1m47s 03 45 1m47s 1m47s 04 50 1m48s 1m48s 05 44 1m53s 1m53s 06 41 1m50s 1m50s 07 40 2m17s 2m15s 08 37 2m40s 2m38s 09 38 2m11s 2m11s 10 66 2m17s 2m17s 11 71 2m17s 2m14s 12 63 4m2s 3m55s 13 45 3m38s 3m38s 14 33 2m7s 2m7s 15 47 1m54s 1m54s 16 49 13m5s 13m5s 17 30 2m45s 2m45s 18 24 1h59m58s 1h59m58s 19 44 1m47s 1m47s 20 40 2m27s 2m26s 21 34 2m22s 2m22s 22 62 1m41s 1m41s 23 33 2m19s 2m19s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-11-12 10:26:04 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 1,048 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,048 connections Total
-
Sessions
Simultaneous sessions
Key values
- 111 sessions Session Peak
- 2025-11-12 19:58:13 Date
Histogram of session times
Key values
- 925 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 1,048 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,048 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,048 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 1,048 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 2 3h27m14s 1h43m37s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 2 3h27m1s 1h43m30s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 2 3h7m4s 1h33m32s IntelliJ IDEA 2024.3.5 1 15s349ms 15s349ms PostgreSQL JDBC Driver 961 3d14h15m 5m23s [unknown] 80 7s600ms 95ms -
Temporary Files
Size of temporary files
Key values
- 38.86 MiB Temp Files size Peak
- 2025-11-12 12:12:37 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-11-12 12:12:37 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 12 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 4.19 MiB 4.19 MiB 11 29 120.52 MiB 4.16 MiB 12 51 218.12 MiB 4.28 MiB 13 1 4.19 MiB 4.19 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 15 106.97 MiB 2.48 MiB 28.87 MiB 7.13 MiB select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:35:54 Duration: 6s828ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021212', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021212', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:12:22 Duration: 5s440ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021159', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021159', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 11:59:29 Duration: 5s347ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 6 15.24 MiB 2.24 MiB 2.93 MiB 2.54 MiB select goc.obj_num_id from gtp_obj_composition goc where position(? in goc.obj_compo_value) <> ?;-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:35:29 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 2 11.35 MiB 2.56 MiB 8.79 MiB 5.68 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:33:54 Duration: 2m39s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:09:19 Duration: 2m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
Queries generating the largest temporary files
Rank Size Query 1 28.87 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021159', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021159', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 11:50:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
2 15.65 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
3 13.35 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
4 8.79 MiB call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 12:28:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
5 6.04 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
6 6.01 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
7 5.99 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
8 5.40 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
9 5.37 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
10 5.35 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
11 2.93 MiB SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;[ Date: 2025-11-12 12:35:29 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
12 2.56 MiB call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 12:34:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
13 2.56 MiB SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;[ Date: 2025-11-12 12:35:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
14 2.56 MiB SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;[ Date: 2025-11-12 12:35:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
15 2.56 MiB SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;[ Date: 2025-11-12 12:35:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
16 2.50 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
17 2.50 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
18 2.49 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
19 2.49 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
20 2.48 MiB select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:36:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 12 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
- 2 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
- 8 Total read queries
- 33 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 46 Requests
- 14m31s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 46 Requests
User Request type Count Duration a3dsupervisor Total 46 14m31s delete 4 2m18s insert 3 18s536ms others 5 8m7s select 8 56s92ms tcl 26 2m49s Duration by user
Key values
- 14m31s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 46 14m31s delete 4 2m18s insert 3 18s536ms others 5 8m7s select 8 56s92ms tcl 26 2m49s Queries by host
Key values
- 10.3.0.4 Main host
- 46 Requests
- 14m31s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 46 Requests
- 14m31s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-12 11:22:47 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 38 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m7s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 11:56:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 2m39s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 12:33:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 2m2s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 12:09:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 49s954ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-12 12:03:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 46s177ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-12 12:22:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 31s764ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-12 12:38:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 11s78ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-12 10:25:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 10s761ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2025-11-12 01:01:07 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 9s838ms COMMIT;[ Date: 2025-11-12 07:26:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 9s467ms call pack_gtp_dba.p_anonymization_ged ();[ Date: 2025-11-12 12:31:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 9s442ms call pack_gtp_dba.p_anonymization_ged ();[ Date: 2025-11-12 12:07:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 8s457ms COMMIT;[ Date: 2025-11-12 08:05:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 8s383ms COMMIT;[ Date: 2025-11-12 08:03:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 8s378ms COMMIT;[ Date: 2025-11-12 08:03:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 8s131ms insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);[ Date: 2025-11-12 07:26:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 8s115ms select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;[ Date: 2025-11-12 07:26:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 8s65ms COMMIT;[ Date: 2025-11-12 08:03:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 7s799ms SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;[ Date: 2025-11-12 12:11:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 7s161ms COMMIT;[ Date: 2025-11-12 08:05:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 6s828ms select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);[ Date: 2025-11-12 12:35:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 7m48s 3 2m2s 3m7s 2m36s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 12 12 1 3m7s 3m7s 13 2 4m41s 2m20s [ User: a3dsupervisor - Total duration: 7m48s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m48s - Times executed: 3 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:33:54 Duration: 2m39s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:09:19 Duration: 2m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m49s 26 5s320ms 9s838ms 6s534ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 12 08 9 1m1s 6s844ms 09 10 1m8s 6s847ms 21 7 39s810ms 5s687ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 26 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m49s - Times executed: 26 ]
-
COMMIT;
Date: 2025-11-12 07:26:10 Duration: 9s838ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-12 08:05:10 Duration: 8s457ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-12 08:03:45 Duration: 8s383ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m18s 4 11s78ms 49s954ms 34s743ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 12 11 1 11s78ms 11s78ms 13 3 2m7s 42s632ms [ User: a3dsupervisor - Total duration: 2m18s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m18s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:03:13 Duration: 49s954ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:22:11 Duration: 46s177ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:38:39 Duration: 31s764ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 18s909ms 2 9s442ms 9s467ms 9s454ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 12 13 2 18s909ms 9s454ms [ User: a3dsupervisor - Total duration: 18s909ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s909ms - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-12 12:31:10 Duration: 9s467ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-12 12:07:09 Duration: 9s442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 18s536ms 3 5s202ms 8s131ms 6s178ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 12 08 1 8s131ms 8s131ms 09 2 10s404ms 5s202ms [ User: a3dsupervisor - Total duration: 18s536ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s536ms - Times executed: 3 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 07:26:10 Duration: 8s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 08:05:10 Duration: 5s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 08:05:10 Duration: 5s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 17s616ms 3 5s347ms 6s828ms 5s872ms select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 12 12 1 5s347ms 5s347ms 13 2 12s268ms 6s134ms [ User: a3dsupervisor - Total duration: 17s616ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s616ms - Times executed: 3 ]
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:35:54 Duration: 6s828ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021212', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021212', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:12:22 Duration: 5s440ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021159', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021159', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 11:59:29 Duration: 5s347ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 12s976ms 2 5s177ms 7s799ms 6s488ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 12 13 2 12s976ms 6s488ms [ User: a3dsupervisor - Total duration: 12s976ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12s976ms - Times executed: 2 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:11:42 Duration: 7s799ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:35:23 Duration: 5s177ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 10s761ms 1 10s761ms 10s761ms 10s761ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 12 02 1 10s761ms 10s761ms [ User: a3dsupervisor - Total duration: 10s761ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s761ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-12 01:01:07 Duration: 10s761ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 8s115ms 1 8s115ms 8s115ms 8s115ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 12 08 1 8s115ms 8s115ms [ User: a3dsupervisor - Total duration: 8s115ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s115ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-12 07:26:10 Duration: 8s115ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 6s622ms 1 6s622ms 6s622ms 6s622ms select cehp1_0.history_num_id, case when cehp1_1.history_num_id is not null then ? when cehp1_0.history_num_id is not null then ? end, cehp1_0.history_action, cehp1_0.history_date, cehp1_0.obj_num_id, cehp1_0.obj_template_a3d_id, cehp1_1.alert_src_num_id, cehp1_1.alert_type_a3d_id from gtp_cw_eng_history cehp1_0 left join gtp_cw_eng_alert cehp1_1 on cehp1_0.history_num_id = cehp1_1.history_num_id where cehp1_0.history_action = and cehp1_0.obj_template_a3d_id = and cehp1_0.obj_num_id = order by cehp1_0.history_date desc fetch first rows only;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 12 12 1 6s622ms 6s622ms [ User: a3dsupervisor - Total duration: 6s622ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s622ms - Times executed: 1 ]
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-12 11:39:37 Duration: 6s622ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 26 2m49s 5s320ms 9s838ms 6s534ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 12 08 9 1m1s 6s844ms 09 10 1m8s 6s847ms 21 7 39s810ms 5s687ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 26 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m49s - Times executed: 26 ]
-
COMMIT;
Date: 2025-11-12 07:26:10 Duration: 9s838ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-12 08:05:10 Duration: 8s457ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-12 08:03:45 Duration: 8s383ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4 2m18s 11s78ms 49s954ms 34s743ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 12 11 1 11s78ms 11s78ms 13 3 2m7s 42s632ms [ User: a3dsupervisor - Total duration: 2m18s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m18s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:03:13 Duration: 49s954ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:22:11 Duration: 46s177ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:38:39 Duration: 31s764ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 3 7m48s 2m2s 3m7s 2m36s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 12 12 1 3m7s 3m7s 13 2 4m41s 2m20s [ User: a3dsupervisor - Total duration: 7m48s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m48s - Times executed: 3 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:33:54 Duration: 2m39s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:09:19 Duration: 2m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 3 18s536ms 5s202ms 8s131ms 6s178ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 12 08 1 8s131ms 8s131ms 09 2 10s404ms 5s202ms [ User: a3dsupervisor - Total duration: 18s536ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s536ms - Times executed: 3 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 07:26:10 Duration: 8s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 08:05:10 Duration: 5s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 08:05:10 Duration: 5s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 3 17s616ms 5s347ms 6s828ms 5s872ms select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 12 12 1 5s347ms 5s347ms 13 2 12s268ms 6s134ms [ User: a3dsupervisor - Total duration: 17s616ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s616ms - Times executed: 3 ]
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:35:54 Duration: 6s828ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021212', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021212', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:12:22 Duration: 5s440ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021159', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021159', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 11:59:29 Duration: 5s347ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 2 18s909ms 9s442ms 9s467ms 9s454ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 12 13 2 18s909ms 9s454ms [ User: a3dsupervisor - Total duration: 18s909ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s909ms - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-12 12:31:10 Duration: 9s467ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-12 12:07:09 Duration: 9s442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 2 12s976ms 5s177ms 7s799ms 6s488ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 12 13 2 12s976ms 6s488ms [ User: a3dsupervisor - Total duration: 12s976ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12s976ms - Times executed: 2 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:11:42 Duration: 7s799ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:35:23 Duration: 5s177ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1 10s761ms 10s761ms 10s761ms 10s761ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 12 02 1 10s761ms 10s761ms [ User: a3dsupervisor - Total duration: 10s761ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s761ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-12 01:01:07 Duration: 10s761ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 1 8s115ms 8s115ms 8s115ms 8s115ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 12 08 1 8s115ms 8s115ms [ User: a3dsupervisor - Total duration: 8s115ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s115ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-12 07:26:10 Duration: 8s115ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 1 6s622ms 6s622ms 6s622ms 6s622ms select cehp1_0.history_num_id, case when cehp1_1.history_num_id is not null then ? when cehp1_0.history_num_id is not null then ? end, cehp1_0.history_action, cehp1_0.history_date, cehp1_0.obj_num_id, cehp1_0.obj_template_a3d_id, cehp1_1.alert_src_num_id, cehp1_1.alert_type_a3d_id from gtp_cw_eng_history cehp1_0 left join gtp_cw_eng_alert cehp1_1 on cehp1_0.history_num_id = cehp1_1.history_num_id where cehp1_0.history_action = and cehp1_0.obj_template_a3d_id = and cehp1_0.obj_num_id = order by cehp1_0.history_date desc fetch first rows only;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 12 12 1 6s622ms 6s622ms [ User: a3dsupervisor - Total duration: 6s622ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s622ms - Times executed: 1 ]
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-12 11:39:37 Duration: 6s622ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m2s 3m7s 2m36s 3 7m48s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 12 12 1 3m7s 3m7s 13 2 4m41s 2m20s [ User: a3dsupervisor - Total duration: 7m48s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m48s - Times executed: 3 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:33:54 Duration: 2m39s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-12 12:09:19 Duration: 2m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 11s78ms 49s954ms 34s743ms 4 2m18s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 12 11 1 11s78ms 11s78ms 13 3 2m7s 42s632ms [ User: a3dsupervisor - Total duration: 2m18s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m18s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:03:13 Duration: 49s954ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:22:11 Duration: 46s177ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:38:39 Duration: 31s764ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 10s761ms 10s761ms 10s761ms 1 10s761ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 12 02 1 10s761ms 10s761ms [ User: a3dsupervisor - Total duration: 10s761ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s761ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-12 01:01:07 Duration: 10s761ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 9s442ms 9s467ms 9s454ms 2 18s909ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 12 13 2 18s909ms 9s454ms [ User: a3dsupervisor - Total duration: 18s909ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s909ms - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-12 12:31:10 Duration: 9s467ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-12 12:07:09 Duration: 9s442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 8s115ms 8s115ms 8s115ms 1 8s115ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 12 08 1 8s115ms 8s115ms [ User: a3dsupervisor - Total duration: 8s115ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s115ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-11-12 07:26:10 Duration: 8s115ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 6s622ms 6s622ms 6s622ms 1 6s622ms select cehp1_0.history_num_id, case when cehp1_1.history_num_id is not null then ? when cehp1_0.history_num_id is not null then ? end, cehp1_0.history_action, cehp1_0.history_date, cehp1_0.obj_num_id, cehp1_0.obj_template_a3d_id, cehp1_1.alert_src_num_id, cehp1_1.alert_type_a3d_id from gtp_cw_eng_history cehp1_0 left join gtp_cw_eng_alert cehp1_1 on cehp1_0.history_num_id = cehp1_1.history_num_id where cehp1_0.history_action = and cehp1_0.obj_template_a3d_id = and cehp1_0.obj_num_id = order by cehp1_0.history_date desc fetch first rows only;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 12 12 1 6s622ms 6s622ms [ User: a3dsupervisor - Total duration: 6s622ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s622ms - Times executed: 1 ]
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-12 11:39:37 Duration: 6s622ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 5s320ms 9s838ms 6s534ms 26 2m49s commit;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 12 08 9 1m1s 6s844ms 09 10 1m8s 6s847ms 21 7 39s810ms 5s687ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 26 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m49s - Times executed: 26 ]
-
COMMIT;
Date: 2025-11-12 07:26:10 Duration: 9s838ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-12 08:05:10 Duration: 8s457ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-12 08:03:45 Duration: 8s383ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 5s177ms 7s799ms 6s488ms 2 12s976ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 12 13 2 12s976ms 6s488ms [ User: a3dsupervisor - Total duration: 12s976ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12s976ms - Times executed: 2 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:11:42 Duration: 7s799ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:35:23 Duration: 5s177ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 5s202ms 8s131ms 6s178ms 3 18s536ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 12 08 1 8s131ms 8s131ms 09 2 10s404ms 5s202ms [ User: a3dsupervisor - Total duration: 18s536ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s536ms - Times executed: 3 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 07:26:10 Duration: 8s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 08:05:10 Duration: 5s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-12 08:05:10 Duration: 5s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 5s347ms 6s828ms 5s872ms 3 17s616ms select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 12 12 1 5s347ms 5s347ms 13 2 12s268ms 6s134ms [ User: a3dsupervisor - Total duration: 17s616ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s616ms - Times executed: 3 ]
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:35:54 Duration: 6s828ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021212', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021212', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 12:12:22 Duration: 5s440ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021159', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021159', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-12 11:59:29 Duration: 5s347ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 3,397 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 74 ERROR entries
- 42 WARNING entries
Most Frequent Errors/Events
Key values
- 24 Max number of times the same event was reported
- 117 Total events found
Rank Times reported Error 1 24 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 12 12 8 13 16 2 18 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 12 12 6 13 12 3 12 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 12 11 2 12 2 13 2 17 3 19 3 4 6 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 12 12 2 13 4 5 3 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 12 12 1 13 2 6 3 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 12 12 1 13 2 7 3 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 12 12 1 13 2 8 3 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 12 12 1 13 2 9 3 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 12 12 1 13 2 10 3 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 12 12 1 13 2 11 3 LOG: process ... still waiting for ShareLock on transaction ... after ... msselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 12 12 1 13 2 12 3 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 12 12 1 13 2 13 3 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 12 12 1 13 2 14 3 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 12 12 1 13 2 15 3 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 12 12 1 13 2 16 3 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_TIME_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 12 12 1 13 2 17 3 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 12 12 1 13 2 18 3 ERROR: canceling statement due to lock timeoutselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 12 12 1 13 2 19 3 ERROR: null value in column "..." of relation "..." violates not-null constraintSELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #19
Day Hour Count Nov 12 12 1 13 2 20 3 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #20
Day Hour Count Nov 12 12 1 13 2 21 3 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #21
Day Hour Count Nov 12 12 1 13 2 22 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 12 14 2 23 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate gtp_cache_host set last_seen = current_timestamp where host = and port =
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 12 12 1 13 1 24 1 LOG: could not send data to client: Broken pipecall pack_gtp_dba.p_anonymization_ged()
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 12 12 1 25 1 FATAL: connection to client lostcall pack_gtp_dba.p_anonymization_ged()
Times Reported Most Frequent Error / Event #25
Day Hour Count Nov 12 12 1