pgBadger-
Global information
- Generated on Mon Nov 10 09:40:03 2025
- Log file: ./2025-11-08_PT1D.log
- Parsed 136 log entries in 36s
- Log start from 2025-11-02 21:01:24 to 2025-11-07 21:17:28
-
Overview
Global Stats
- 18 Number of unique normalized queries
- 68 Number of queries
- 3h44m2s Total query duration
- 2025-11-02 21:00:59 First query
- 2025-11-07 21:17:37 Last query
- 1 queries/s at 2025-11-07 21:12:41 Query peak
- 3h44m2s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h44m2s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 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
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 68 Average queries per session
- 3h44m2s Average queries duration per session
- n/a Average idle time per session
- 0 Total number of connections
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-07 21:12:41 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-07 21:12:41 Date
Queries duration
Key values
- 3h44m2s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 21 6 4s148ms 58s577ms 17s359ms 58s577ms 58s577ms 58s577ms 22 1 28m2s 28m2s 28m2s 28m2s 28m2s 28m2s Nov 03 21 10 7s6ms 16m52s 3m20s 19m12s 19m12s 19m12s Nov 04 21 10 5s383ms 13m18s 2m46s 15m9s 15m9s 15m9s Nov 05 09 10 5s162ms 13m11s 2m32s 13m56s 13m56s 13m56s Nov 06 09 11 4s711ms 15m12s 2m39s 15m12s 15m12s 15m12s 21 10 8s479ms 20m 3m55s 20m34s 20m34s 20m34s Nov 07 21 10 8s531ms 19m22s 3m54s 19m22s 19m22s 19m22s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Nov 03 21 0 10 3m20s 8m21s 19m12s 19m12s Nov 04 21 0 10 2m46s 15m9s 15m9s 15m9s Nov 05 09 0 10 2m32s 6m25s 13m56s 13m56s Nov 06 09 0 11 2m39s 7m28s 15m12s 15m12s 21 0 10 3m55s 9m58s 20m34s 20m34s Nov 07 21 0 10 3m54s 10m17s 19m22s 19m22s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms Nov 03 21 0 0 0 0 0ms 0ms 0ms 0ms Nov 04 21 0 0 0 0 0ms 0ms 0ms 0ms Nov 05 09 0 0 0 0 0ms 0ms 0ms 0ms Nov 06 09 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms Nov 07 21 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 02 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Nov 03 21 0 0 0.00 0.00% Nov 04 21 0 0 0.00 0.00% Nov 05 09 0 0 0.00 0.00% Nov 06 09 0 0 0.00 0.00% 21 0 0 0.00 0.00% Nov 07 21 0 0 0.00 0.00% Day Hour Count Average / Second Nov 02 21 0 0.00/s 22 0 0.00/s Nov 03 21 0 0.00/s Nov 04 21 0 0.00/s Nov 05 09 0 0.00/s Nov 06 09 0 0.00/s 21 0 0.00/s Nov 07 21 0 0.00/s Day Hour Count Average Duration Average idle time Nov 02 21 0 0ms 0ms 22 0 0ms 0ms Nov 03 21 0 0ms 0ms Nov 04 21 0 0ms 0ms Nov 05 09 0 0ms 0ms Nov 06 09 0 0ms 0ms 21 0 0ms 0ms Nov 07 21 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 02 21 0 0 0 22 0 0 0 Nov 03 21 0 0 0 Nov 04 21 0 0 0 Nov 05 09 0 0 0 Nov 06 09 0 0 0 21 0 0 0 Nov 07 21 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 02 21 0 0 22 0 0 Nov 03 21 0 0 Nov 04 21 0 0 Nov 05 09 0 0 Nov 06 09 0 0 21 0 0 Nov 07 21 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 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
- 0 Total read queries
- 61 Total write queries
Queries by database
Key values
- refperf_minarm Main database
- 68 Requests
- 3h44m2s (refperf_minarm)
- Main time consuming database
Queries by user
Key values
- a3d Main user
- 71 Requests
User Request type Count Duration a3d Total 71 3h42m1s copy to 71 3h42m1s postgres Total 7 29m46s others 7 29m46s Duration by user
Key values
- 3h42m1s (a3d) Main time consuming user
User Request type Count Duration a3d Total 71 3h42m1s copy to 71 3h42m1s postgres Total 7 29m46s others 7 29m46s Queries by host
Key values
- 10.6.201.196 Main host
- 51 Requests
- 2h43m9s (10.6.201.196)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 61 Requests
- 3h14m16s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-07 21:12:41 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 51 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 28m2s REINDEX (VERBOSE) DATABASE refperf_minarm;[ Date: 2025-11-02 22:28:04 - Database: refperf_minarm - User: postgres - Remote: [local] - Application: reindexdb ]
2 20m COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2025-11-06 21:17:29 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
3 19m22s COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2025-11-07 21:16:53 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
4 16m52s COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2025-11-03 21:14:56 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
5 15m12s COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2025-11-06 09:57:29 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
6 13m18s COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2025-11-04 21:10:43 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
7 13m11s COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2025-11-05 09:27:51 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
8 10m17s 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-11-07 21:07:48 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
9 9m58s 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-11-06 21:07:26 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
10 8m21s 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-11-03 21:06:25 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
11 7m39s 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-11-04 21:05:04 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
12 7m28s 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-11-06 09:49:45 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
13 6m25s 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-11-05 09:21:05 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
14 2m30s 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-11-06 21:12:07 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
15 2m29s 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-11-07 21:12:41 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
16 2m28s COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;[ Date: 2025-11-07 21:15:09 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
17 2m24s COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;[ Date: 2025-11-06 21:14:31 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
18 2m12s 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-11-03 21:10:26 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
19 2m9s COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;[ Date: 2025-11-03 21:12:36 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
20 1m53s 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-11-04 21:08:28 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h37m58s 6 13m11s 20m 16m19s copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 21 1 16m52s 16m52s Nov 04 21 1 13m18s 13m18s Nov 05 09 1 13m11s 13m11s Nov 06 09 1 15m12s 15m12s 21 1 20m 20m Nov 07 21 1 19m22s 19m22s [ User: a3d - Total duration: 1h37m58s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1h37m58s - Times executed: 6 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-06 21:17:29 Duration: 20m Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-07 21:16:53 Duration: 19m22s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-03 21:14:56 Duration: 16m52s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
2 50m10s 6 6m25s 10m17s 8m21s 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 #2
Day Hour Count Duration Avg duration Nov 03 21 1 8m21s 8m21s Nov 04 21 1 7m39s 7m39s Nov 05 09 1 6m25s 6m25s Nov 06 09 1 7m28s 7m28s 21 1 9m58s 9m58s Nov 07 21 1 10m17s 10m17s [ User: a3d - Total duration: 50m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50m10s - Times executed: 6 ]
-
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-11-07 21:07:48 Duration: 10m17s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-06 21:07:26 Duration: 9m58s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-03 21:06:25 Duration: 8m21s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
3 28m2s 1 28m2s 28m2s 28m2s reindex (verbose) database refperf_minarm;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 02 22 1 28m2s 28m2s [ User: postgres - Total duration: 28m2s - Times executed: 1 ]
[ Application: reindexdb - Total duration: 28m2s - Times executed: 1 ]
-
REINDEX (VERBOSE) DATABASE refperf_minarm;
Date: 2025-11-02 22:28:04 Duration: 28m2s Database: refperf_minarm User: postgres Remote: [local] Application: reindexdb
4 12m22s 6 1m33s 2m30s 2m3s 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 #4
Day Hour Count Duration Avg duration Nov 03 21 1 2m12s 2m12s Nov 04 21 1 1m53s 1m53s Nov 05 09 1 1m33s 1m33s Nov 06 09 1 1m44s 1m44s 21 1 2m30s 2m30s Nov 07 21 1 2m29s 2m29s [ User: a3d - Total duration: 12m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12m22s - Times executed: 6 ]
-
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-11-06 21:12:07 Duration: 2m30s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-07 21:12:41 Duration: 2m29s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-03 21:10:26 Duration: 2m12s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
5 12m5s 6 1m32s 2m28s 2m copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 21 1 2m9s 2m9s Nov 04 21 1 1m50s 1m50s Nov 05 09 1 1m32s 1m32s Nov 06 09 1 1m40s 1m40s 21 1 2m24s 2m24s Nov 07 21 1 2m28s 2m28s [ User: a3d - Total duration: 12m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12m5s - Times executed: 6 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-07 21:15:09 Duration: 2m28s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-06 21:14:31 Duration: 2m24s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-03 21:12:36 Duration: 2m9s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
6 8m40s 6 1m6s 1m52s 1m26s copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 21 1 1m32s 1m32s Nov 04 21 1 1m10s 1m10s Nov 05 09 1 1m6s 1m6s Nov 06 09 1 1m14s 1m14s 21 1 1m44s 1m44s Nov 07 21 1 1m52s 1m52s [ User: a3d - Total duration: 8m40s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 8m40s - Times executed: 6 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-07 21:17:02 Duration: 1m52s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-06 21:16:16 Duration: 1m44s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-03 21:14:09 Duration: 1m32s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
7 6m55s 6 52s879ms 1m27s 1m9s copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 21 1 1m14s 1m14s Nov 04 21 1 57s372ms 57s372ms Nov 05 09 1 52s879ms 52s879ms Nov 06 09 1 56s672ms 56s672ms 21 1 1m26s 1m26s Nov 07 21 1 1m27s 1m27s [ User: a3d - Total duration: 6m55s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 6m55s - Times executed: 6 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-07 21:10:12 Duration: 1m27s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-06 21:09:36 Duration: 1m26s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-03 21:08:14 Duration: 1m14s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
8 3m14s 6 24s552ms 40s303ms 32s378ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 21 1 33s371ms 33s371ms Nov 04 21 1 31s868ms 31s868ms Nov 05 09 1 24s552ms 24s552ms Nov 06 09 1 26s134ms 26s134ms 21 1 40s303ms 40s303ms Nov 07 21 1 38s39ms 38s39ms [ User: a3d - Total duration: 3m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 6 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-06 21:16:57 Duration: 40s303ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-07 21:17:31 Duration: 38s39ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-03 21:14:42 Duration: 33s371ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
9 1m19s 6 9s837ms 16s972ms 13s292ms copy public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 21 1 14s197ms 14s197ms Nov 04 21 1 11s523ms 11s523ms Nov 05 09 1 9s837ms 9s837ms Nov 06 09 1 11s146ms 11s146ms 21 1 16s76ms 16s76ms Nov 07 21 1 16s972ms 16s972ms [ User: a3d - Total duration: 1m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 6 ]
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-07 21:17:19 Duration: 16s972ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-06 21:17:13 Duration: 16s76ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-03 21:14:57 Duration: 14s197ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
10 58s577ms 1 58s577ms 58s577ms 58s577ms vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_composition;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 02 21 1 58s577ms 58s577ms [ User: postgres - Total duration: 58s577ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 58s577ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_composition;
Date: 2025-11-02 21:00:59 Duration: 58s577ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
11 43s155ms 6 5s162ms 9s168ms 7s192ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 21 1 7s6ms 7s6ms Nov 04 21 1 6s512ms 6s512ms Nov 05 09 1 5s162ms 5s162ms Nov 06 09 1 6s516ms 6s516ms 21 1 9s168ms 9s168ms Nov 07 21 1 8s789ms 8s789ms [ User: a3d - Total duration: 43s155ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s155ms - Times executed: 6 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-06 21:17:22 Duration: 9s168ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-07 21:17:28 Duration: 8s789ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-03 21:15:03 Duration: 7s6ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
12 41s122ms 6 5s366ms 8s531ms 6s853ms copy public.gtp_history_obj_concerned (action_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 21 1 7s53ms 7s53ms Nov 04 21 1 5s383ms 5s383ms Nov 05 09 1 5s366ms 5s366ms Nov 06 09 1 6s308ms 6s308ms 21 1 8s479ms 8s479ms Nov 07 21 1 8s531ms 8s531ms [ User: a3d - Total duration: 41s122ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s122ms - Times executed: 6 ]
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-07 21:17:37 Duration: 8s531ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-06 21:17:31 Duration: 8s479ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-03 21:15:04 Duration: 7s53ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
13 15s916ms 1 15s916ms 15s916ms 15s916ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_compo;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 02 21 1 15s916ms 15s916ms [ User: postgres - Total duration: 15s916ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 15s916ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_compo;
Date: 2025-11-02 21:01:15 Duration: 15s916ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
14 10s906ms 1 10s906ms 10s906ms 10s906ms vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_rel_vt;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 02 21 1 10s906ms 10s906ms [ User: postgres - Total duration: 10s906ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 10s906ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_rel_vt;
Date: 2025-11-02 21:01:35 Duration: 10s906ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
15 8s807ms 1 8s807ms 8s807ms 8s807ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_action;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 02 21 1 8s807ms 8s807ms [ User: postgres - Total duration: 8s807ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 8s807ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_action;
Date: 2025-11-02 21:01:24 Duration: 8s807ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
16 5s804ms 1 5s804ms 5s804ms 5s804ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_link_unlink;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 02 21 1 5s804ms 5s804ms [ User: postgres - Total duration: 5s804ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 5s804ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_link_unlink;
Date: 2025-11-02 21:01:41 Duration: 5s804ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
17 4s711ms 1 4s711ms 4s711ms 4s711ms copy public.gtp_log (log_date, log_type, log_info, log_release, log_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 06 09 1 4s711ms 4s711ms [ User: a3d - Total duration: 4s711ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s711ms - Times executed: 1 ]
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-11-06 09:56:47 Duration: 4s711ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
18 4s148ms 1 4s148ms 4s148ms 4s148ms vacuum (skip_database_stats, verbose, analyze) public.gtp_relation;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 02 21 1 4s148ms 4s148ms [ User: postgres - Total duration: 4s148ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 4s148ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_relation;
Date: 2025-11-02 21:01:45 Duration: 4s148ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 6 1h37m58s 13m11s 20m 16m19s copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 21 1 16m52s 16m52s Nov 04 21 1 13m18s 13m18s Nov 05 09 1 13m11s 13m11s Nov 06 09 1 15m12s 15m12s 21 1 20m 20m Nov 07 21 1 19m22s 19m22s [ User: a3d - Total duration: 1h37m58s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1h37m58s - Times executed: 6 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-06 21:17:29 Duration: 20m Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-07 21:16:53 Duration: 19m22s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-03 21:14:56 Duration: 16m52s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
2 6 50m10s 6m25s 10m17s 8m21s 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 #2
Day Hour Count Duration Avg duration Nov 03 21 1 8m21s 8m21s Nov 04 21 1 7m39s 7m39s Nov 05 09 1 6m25s 6m25s Nov 06 09 1 7m28s 7m28s 21 1 9m58s 9m58s Nov 07 21 1 10m17s 10m17s [ User: a3d - Total duration: 50m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50m10s - Times executed: 6 ]
-
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-11-07 21:07:48 Duration: 10m17s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-06 21:07:26 Duration: 9m58s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-03 21:06:25 Duration: 8m21s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
3 6 12m22s 1m33s 2m30s 2m3s 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 #3
Day Hour Count Duration Avg duration Nov 03 21 1 2m12s 2m12s Nov 04 21 1 1m53s 1m53s Nov 05 09 1 1m33s 1m33s Nov 06 09 1 1m44s 1m44s 21 1 2m30s 2m30s Nov 07 21 1 2m29s 2m29s [ User: a3d - Total duration: 12m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12m22s - Times executed: 6 ]
-
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-11-06 21:12:07 Duration: 2m30s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-07 21:12:41 Duration: 2m29s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-03 21:10:26 Duration: 2m12s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
4 6 12m5s 1m32s 2m28s 2m copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 21 1 2m9s 2m9s Nov 04 21 1 1m50s 1m50s Nov 05 09 1 1m32s 1m32s Nov 06 09 1 1m40s 1m40s 21 1 2m24s 2m24s Nov 07 21 1 2m28s 2m28s [ User: a3d - Total duration: 12m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12m5s - Times executed: 6 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-07 21:15:09 Duration: 2m28s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-06 21:14:31 Duration: 2m24s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-03 21:12:36 Duration: 2m9s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
5 6 8m40s 1m6s 1m52s 1m26s copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 21 1 1m32s 1m32s Nov 04 21 1 1m10s 1m10s Nov 05 09 1 1m6s 1m6s Nov 06 09 1 1m14s 1m14s 21 1 1m44s 1m44s Nov 07 21 1 1m52s 1m52s [ User: a3d - Total duration: 8m40s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 8m40s - Times executed: 6 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-07 21:17:02 Duration: 1m52s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-06 21:16:16 Duration: 1m44s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-03 21:14:09 Duration: 1m32s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
6 6 6m55s 52s879ms 1m27s 1m9s copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 21 1 1m14s 1m14s Nov 04 21 1 57s372ms 57s372ms Nov 05 09 1 52s879ms 52s879ms Nov 06 09 1 56s672ms 56s672ms 21 1 1m26s 1m26s Nov 07 21 1 1m27s 1m27s [ User: a3d - Total duration: 6m55s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 6m55s - Times executed: 6 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-07 21:10:12 Duration: 1m27s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-06 21:09:36 Duration: 1m26s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-03 21:08:14 Duration: 1m14s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
7 6 3m14s 24s552ms 40s303ms 32s378ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 21 1 33s371ms 33s371ms Nov 04 21 1 31s868ms 31s868ms Nov 05 09 1 24s552ms 24s552ms Nov 06 09 1 26s134ms 26s134ms 21 1 40s303ms 40s303ms Nov 07 21 1 38s39ms 38s39ms [ User: a3d - Total duration: 3m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 6 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-06 21:16:57 Duration: 40s303ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-07 21:17:31 Duration: 38s39ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-03 21:14:42 Duration: 33s371ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
8 6 1m19s 9s837ms 16s972ms 13s292ms copy public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 21 1 14s197ms 14s197ms Nov 04 21 1 11s523ms 11s523ms Nov 05 09 1 9s837ms 9s837ms Nov 06 09 1 11s146ms 11s146ms 21 1 16s76ms 16s76ms Nov 07 21 1 16s972ms 16s972ms [ User: a3d - Total duration: 1m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 6 ]
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-07 21:17:19 Duration: 16s972ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-06 21:17:13 Duration: 16s76ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-03 21:14:57 Duration: 14s197ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
9 6 43s155ms 5s162ms 9s168ms 7s192ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 21 1 7s6ms 7s6ms Nov 04 21 1 6s512ms 6s512ms Nov 05 09 1 5s162ms 5s162ms Nov 06 09 1 6s516ms 6s516ms 21 1 9s168ms 9s168ms Nov 07 21 1 8s789ms 8s789ms [ User: a3d - Total duration: 43s155ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s155ms - Times executed: 6 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-06 21:17:22 Duration: 9s168ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-07 21:17:28 Duration: 8s789ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-03 21:15:03 Duration: 7s6ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
10 6 41s122ms 5s366ms 8s531ms 6s853ms copy public.gtp_history_obj_concerned (action_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 21 1 7s53ms 7s53ms Nov 04 21 1 5s383ms 5s383ms Nov 05 09 1 5s366ms 5s366ms Nov 06 09 1 6s308ms 6s308ms 21 1 8s479ms 8s479ms Nov 07 21 1 8s531ms 8s531ms [ User: a3d - Total duration: 41s122ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s122ms - Times executed: 6 ]
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-07 21:17:37 Duration: 8s531ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-06 21:17:31 Duration: 8s479ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-03 21:15:04 Duration: 7s53ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
11 1 28m2s 28m2s 28m2s 28m2s reindex (verbose) database refperf_minarm;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 02 22 1 28m2s 28m2s [ User: postgres - Total duration: 28m2s - Times executed: 1 ]
[ Application: reindexdb - Total duration: 28m2s - Times executed: 1 ]
-
REINDEX (VERBOSE) DATABASE refperf_minarm;
Date: 2025-11-02 22:28:04 Duration: 28m2s Database: refperf_minarm User: postgres Remote: [local] Application: reindexdb
12 1 58s577ms 58s577ms 58s577ms 58s577ms vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_composition;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 02 21 1 58s577ms 58s577ms [ User: postgres - Total duration: 58s577ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 58s577ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_composition;
Date: 2025-11-02 21:00:59 Duration: 58s577ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
13 1 15s916ms 15s916ms 15s916ms 15s916ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_compo;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 02 21 1 15s916ms 15s916ms [ User: postgres - Total duration: 15s916ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 15s916ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_compo;
Date: 2025-11-02 21:01:15 Duration: 15s916ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
14 1 10s906ms 10s906ms 10s906ms 10s906ms vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_rel_vt;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 02 21 1 10s906ms 10s906ms [ User: postgres - Total duration: 10s906ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 10s906ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_rel_vt;
Date: 2025-11-02 21:01:35 Duration: 10s906ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
15 1 8s807ms 8s807ms 8s807ms 8s807ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_action;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 02 21 1 8s807ms 8s807ms [ User: postgres - Total duration: 8s807ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 8s807ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_action;
Date: 2025-11-02 21:01:24 Duration: 8s807ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
16 1 5s804ms 5s804ms 5s804ms 5s804ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_link_unlink;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 02 21 1 5s804ms 5s804ms [ User: postgres - Total duration: 5s804ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 5s804ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_link_unlink;
Date: 2025-11-02 21:01:41 Duration: 5s804ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
17 1 4s711ms 4s711ms 4s711ms 4s711ms copy public.gtp_log (log_date, log_type, log_info, log_release, log_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 06 09 1 4s711ms 4s711ms [ User: a3d - Total duration: 4s711ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s711ms - Times executed: 1 ]
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-11-06 09:56:47 Duration: 4s711ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
18 1 4s148ms 4s148ms 4s148ms 4s148ms vacuum (skip_database_stats, verbose, analyze) public.gtp_relation;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 02 21 1 4s148ms 4s148ms [ User: postgres - Total duration: 4s148ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 4s148ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_relation;
Date: 2025-11-02 21:01:45 Duration: 4s148ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 28m2s 28m2s 28m2s 1 28m2s reindex (verbose) database refperf_minarm;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 02 22 1 28m2s 28m2s [ User: postgres - Total duration: 28m2s - Times executed: 1 ]
[ Application: reindexdb - Total duration: 28m2s - Times executed: 1 ]
-
REINDEX (VERBOSE) DATABASE refperf_minarm;
Date: 2025-11-02 22:28:04 Duration: 28m2s Database: refperf_minarm User: postgres Remote: [local] Application: reindexdb
2 13m11s 20m 16m19s 6 1h37m58s copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 21 1 16m52s 16m52s Nov 04 21 1 13m18s 13m18s Nov 05 09 1 13m11s 13m11s Nov 06 09 1 15m12s 15m12s 21 1 20m 20m Nov 07 21 1 19m22s 19m22s [ User: a3d - Total duration: 1h37m58s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1h37m58s - Times executed: 6 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-06 21:17:29 Duration: 20m Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-07 21:16:53 Duration: 19m22s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-11-03 21:14:56 Duration: 16m52s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
3 6m25s 10m17s 8m21s 6 50m10s 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 #3
Day Hour Count Duration Avg duration Nov 03 21 1 8m21s 8m21s Nov 04 21 1 7m39s 7m39s Nov 05 09 1 6m25s 6m25s Nov 06 09 1 7m28s 7m28s 21 1 9m58s 9m58s Nov 07 21 1 10m17s 10m17s [ User: a3d - Total duration: 50m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50m10s - Times executed: 6 ]
-
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-11-07 21:07:48 Duration: 10m17s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-06 21:07:26 Duration: 9m58s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-03 21:06:25 Duration: 8m21s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
4 1m33s 2m30s 2m3s 6 12m22s 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 #4
Day Hour Count Duration Avg duration Nov 03 21 1 2m12s 2m12s Nov 04 21 1 1m53s 1m53s Nov 05 09 1 1m33s 1m33s Nov 06 09 1 1m44s 1m44s 21 1 2m30s 2m30s Nov 07 21 1 2m29s 2m29s [ User: a3d - Total duration: 12m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12m22s - Times executed: 6 ]
-
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-11-06 21:12:07 Duration: 2m30s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-07 21:12:41 Duration: 2m29s Database: refperf_minarm User: a3d Remote: 10.6.201.196 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-11-03 21:10:26 Duration: 2m12s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
5 1m32s 2m28s 2m 6 12m5s copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 21 1 2m9s 2m9s Nov 04 21 1 1m50s 1m50s Nov 05 09 1 1m32s 1m32s Nov 06 09 1 1m40s 1m40s 21 1 2m24s 2m24s Nov 07 21 1 2m28s 2m28s [ User: a3d - Total duration: 12m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12m5s - Times executed: 6 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-07 21:15:09 Duration: 2m28s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-06 21:14:31 Duration: 2m24s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-11-03 21:12:36 Duration: 2m9s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
6 1m6s 1m52s 1m26s 6 8m40s copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 21 1 1m32s 1m32s Nov 04 21 1 1m10s 1m10s Nov 05 09 1 1m6s 1m6s Nov 06 09 1 1m14s 1m14s 21 1 1m44s 1m44s Nov 07 21 1 1m52s 1m52s [ User: a3d - Total duration: 8m40s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 8m40s - Times executed: 6 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-07 21:17:02 Duration: 1m52s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-06 21:16:16 Duration: 1m44s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-11-03 21:14:09 Duration: 1m32s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
7 52s879ms 1m27s 1m9s 6 6m55s copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 21 1 1m14s 1m14s Nov 04 21 1 57s372ms 57s372ms Nov 05 09 1 52s879ms 52s879ms Nov 06 09 1 56s672ms 56s672ms 21 1 1m26s 1m26s Nov 07 21 1 1m27s 1m27s [ User: a3d - Total duration: 6m55s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 6m55s - Times executed: 6 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-07 21:10:12 Duration: 1m27s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-06 21:09:36 Duration: 1m26s Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-11-03 21:08:14 Duration: 1m14s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
8 58s577ms 58s577ms 58s577ms 1 58s577ms vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_composition;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 02 21 1 58s577ms 58s577ms [ User: postgres - Total duration: 58s577ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 58s577ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_composition;
Date: 2025-11-02 21:00:59 Duration: 58s577ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
9 24s552ms 40s303ms 32s378ms 6 3m14s copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 21 1 33s371ms 33s371ms Nov 04 21 1 31s868ms 31s868ms Nov 05 09 1 24s552ms 24s552ms Nov 06 09 1 26s134ms 26s134ms 21 1 40s303ms 40s303ms Nov 07 21 1 38s39ms 38s39ms [ User: a3d - Total duration: 3m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 6 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-06 21:16:57 Duration: 40s303ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-07 21:17:31 Duration: 38s39ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-11-03 21:14:42 Duration: 33s371ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
10 15s916ms 15s916ms 15s916ms 1 15s916ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_compo;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 02 21 1 15s916ms 15s916ms [ User: postgres - Total duration: 15s916ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 15s916ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_compo;
Date: 2025-11-02 21:01:15 Duration: 15s916ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
11 9s837ms 16s972ms 13s292ms 6 1m19s copy public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 21 1 14s197ms 14s197ms Nov 04 21 1 11s523ms 11s523ms Nov 05 09 1 9s837ms 9s837ms Nov 06 09 1 11s146ms 11s146ms 21 1 16s76ms 16s76ms Nov 07 21 1 16s972ms 16s972ms [ User: a3d - Total duration: 1m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 6 ]
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-07 21:17:19 Duration: 16s972ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-06 21:17:13 Duration: 16s76ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.register_cost_monthly (cost_num_id, obj_num_id, fiscal_year, version, type, obj_type, tx_currency_num_id, period_1_tx_value, period_2_tx_value, period_3_tx_value, period_4_tx_value, period_5_tx_value, period_6_tx_value, period_7_tx_value, period_8_tx_value, period_9_tx_value, period_10_tx_value, period_11_tx_value, period_12_tx_value, period_1_obj_value, period_2_obj_value, period_3_obj_value, period_4_obj_value, period_5_obj_value, period_6_obj_value, period_7_obj_value, period_8_obj_value, period_9_obj_value, period_10_obj_value, period_11_obj_value, period_12_obj_value, dcre, creator, dmaj, modifier) TO stdout;
Date: 2025-11-03 21:14:57 Duration: 14s197ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
12 10s906ms 10s906ms 10s906ms 1 10s906ms vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_rel_vt;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 02 21 1 10s906ms 10s906ms [ User: postgres - Total duration: 10s906ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 10s906ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_rel_vt;
Date: 2025-11-02 21:01:35 Duration: 10s906ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
13 8s807ms 8s807ms 8s807ms 1 8s807ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_action;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 02 21 1 8s807ms 8s807ms [ User: postgres - Total duration: 8s807ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 8s807ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_action;
Date: 2025-11-02 21:01:24 Duration: 8s807ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
14 5s162ms 9s168ms 7s192ms 6 43s155ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 03 21 1 7s6ms 7s6ms Nov 04 21 1 6s512ms 6s512ms Nov 05 09 1 5s162ms 5s162ms Nov 06 09 1 6s516ms 6s516ms 21 1 9s168ms 9s168ms Nov 07 21 1 8s789ms 8s789ms [ User: a3d - Total duration: 43s155ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s155ms - Times executed: 6 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-06 21:17:22 Duration: 9s168ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-07 21:17:28 Duration: 8s789ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-11-03 21:15:03 Duration: 7s6ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
15 5s366ms 8s531ms 6s853ms 6 41s122ms copy public.gtp_history_obj_concerned (action_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 03 21 1 7s53ms 7s53ms Nov 04 21 1 5s383ms 5s383ms Nov 05 09 1 5s366ms 5s366ms Nov 06 09 1 6s308ms 6s308ms 21 1 8s479ms 8s479ms Nov 07 21 1 8s531ms 8s531ms [ User: a3d - Total duration: 41s122ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s122ms - Times executed: 6 ]
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-07 21:17:37 Duration: 8s531ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-06 21:17:31 Duration: 8s479ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-03 21:15:04 Duration: 7s53ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
16 5s804ms 5s804ms 5s804ms 1 5s804ms vacuum (skip_database_stats, verbose, analyze) public.gtp_history_obj_link_unlink;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 02 21 1 5s804ms 5s804ms [ User: postgres - Total duration: 5s804ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 5s804ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_history_obj_link_unlink;
Date: 2025-11-02 21:01:41 Duration: 5s804ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
17 4s711ms 4s711ms 4s711ms 1 4s711ms copy public.gtp_log (log_date, log_type, log_info, log_release, log_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 06 09 1 4s711ms 4s711ms [ User: a3d - Total duration: 4s711ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s711ms - Times executed: 1 ]
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-11-06 09:56:47 Duration: 4s711ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
18 4s148ms 4s148ms 4s148ms 1 4s148ms vacuum (skip_database_stats, verbose, analyze) public.gtp_relation;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 02 21 1 4s148ms 4s148ms [ User: postgres - Total duration: 4s148ms - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 4s148ms - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_relation;
Date: 2025-11-02 21:01:45 Duration: 4s148ms Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
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
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET