pgBadger-
Global information
- Generated on Mon Nov 17 09:38:47 2025
- Log file: ./2025-11-15_PT1D.log
- Parsed 270 log entries in 33s
- Log start from 2025-11-09 21:01:27 to 2025-11-14 21:17:35
-
Overview
Global Stats
- 83 Number of unique normalized queries
- 123 Number of queries
- 4h2m3s Total query duration
- 2025-11-09 21:01:08 First query
- 2025-11-14 21:18:01 Last query
- 1 queries/s at 2025-11-10 21:14:39 Query peak
- 4h2m3s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h2m3s Execute total duration
- 12 Number of events
- 2 Number of unique normalized events
- 11 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
- 123 Average queries per session
- 4h2m3s 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-10 21:14:39 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-10 21:14:39 Date
Queries duration
Key values
- 4h2m3s 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 09 21 6 3s543ms 1m6s 19s689ms 1m54s 1m54s 1m54s 22 1 27m33s 27m33s 27m33s 27m33s 27m33s 27m33s Nov 10 21 10 6s976ms 16m37s 3m20s 19m10s 19m10s 19m10s Nov 11 21 10 4s724ms 12m10s 2m31s 14m 14m 14m Nov 12 21 10 5s153ms 12m23s 2m42s 12m23s 12m23s 12m23s Nov 13 21 10 8s88ms 20m40s 4m4s 21m36s 21m36s 21m36s Nov 14 14 35 0ms 5m59s 53s818ms 4m12s 5m19s 5m59s 15 31 3s46ms 4m18s 28s803ms 2m12s 4m45s 4m45s 21 10 8s237ms 19m56s 3m58s 21m2s 21m2s 21m2s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 09 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Nov 10 21 0 10 3m20s 19m10s 19m10s 19m10s Nov 11 21 0 10 2m31s 14m 14m 14m Nov 12 21 0 10 2m42s 12m23s 12m23s 12m23s Nov 13 21 0 10 4m4s 10m36s 21m36s 21m36s Nov 14 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 21 0 10 3m58s 10m30s 21m2s 21m2s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 09 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms Nov 10 21 0 0 0 0 0ms 0ms 0ms 0ms Nov 11 21 0 0 0 0 0ms 0ms 0ms 0ms Nov 12 21 0 0 0 0 0ms 0ms 0ms 0ms Nov 13 21 0 0 0 0 0ms 0ms 0ms 0ms Nov 14 14 0 0 0 9 1m20s 0ms 7s932ms 5m59s 15 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 09 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Nov 10 21 0 0 0.00 0.00% Nov 11 21 0 0 0.00 0.00% Nov 12 21 0 0 0.00 0.00% Nov 13 21 0 0 0.00 0.00% Nov 14 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 21 0 0 0.00 0.00% Day Hour Count Average / Second Nov 09 21 0 0.00/s 22 0 0.00/s Nov 10 21 0 0.00/s Nov 11 21 0 0.00/s Nov 12 21 0 0.00/s Nov 13 21 0 0.00/s Nov 14 14 0 0.00/s 15 0 0.00/s 21 0 0.00/s Day Hour Count Average Duration Average idle time Nov 09 21 0 0ms 0ms 22 0 0ms 0ms Nov 10 21 0 0ms 0ms Nov 11 21 0 0ms 0ms Nov 12 21 0 0ms 0ms Nov 13 21 0 0ms 0ms Nov 14 14 0 0ms 0ms 15 0 0ms 0ms 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 09 21 0 0 0 22 0 0 0 Nov 10 21 0 0 0 Nov 11 21 0 0 0 Nov 12 21 0 0 0 Nov 13 21 0 0 0 Nov 14 14 0 0 0 15 0 0 0 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 09 21 0 0 22 0 0 Nov 10 21 0 0 Nov 11 21 0 0 Nov 12 21 0 0 Nov 13 21 0 0 Nov 14 14 0 0 15 0 0 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
- 115 Total write queries
Queries by database
Key values
- refperf_minarm Main database
- 123 Requests
- 4h2m3s (refperf_minarm)
- Main time consuming database
Queries by user
Key values
- a3d Main user
- 298 Requests
User Request type Count Duration a3d Total 298 7h57m32s copy from 27 36m8s copy to 100 5h38m43s ddl 168 1h40m1s others 3 2m40s postgres Total 7 29m31s others 7 29m31s Duration by user
Key values
- 7h57m32s (a3d) Main time consuming user
User Request type Count Duration a3d Total 298 7h57m32s copy from 27 36m8s copy to 100 5h38m43s ddl 168 1h40m1s others 3 2m40s postgres Total 7 29m31s others 7 29m31s Queries by host
Key values
- 10.6.107.196 Main host
- 248 Requests
- 4h36m48s (10.6.107.196)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 65 Requests
- 2h46m15s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-10 21:14:39 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 86 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 27m33s REINDEX (VERBOSE) DATABASE refperf_minarm;[ Date: 2025-11-09 22:27:35 - Database: refperf_minarm - User: postgres - Remote: [local] - Application: reindexdb ]
2 20m40s 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-13 21:18:58 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
3 19m56s 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-14 21:17:47 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
4 16m37s 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-10 21:14:26 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
5 12m23s 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-12 21:10:09 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
6 12m10s 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-11 21:10:00 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
7 10m36s 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-13 21:08:54 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
8 10m30s 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-14 21:08:20 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
9 8m47s 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-10 21:06:36 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
10 8m24s 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-12 21:06:09 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
11 6m32s 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-11 21:04:22 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
12 5m59s 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) FROM stdin;[ Date: 2025-11-14 14:37:58 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_restore ]
13 5m19s CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));[ Date: 2025-11-14 14:59:09 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_restore ]
14 4m18s CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2025-11-14 15:03:27 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_restore ]
15 3m28s COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;[ Date: 2025-11-14 14:31:11 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_restore ]
16 2m33s 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-13 21:13:39 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
17 2m28s 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-14 21:12:44 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
18 2m25s 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-13 21:16:05 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
19 2m22s 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-14 21:15:06 - Database: refperf_minarm - User: a3d - Remote: 10.6.201.196 - Application: pg_dump ]
20 2m10s 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-10 21:10:46 - Database: refperf_minarm - User: a3d - Remote: 10.6.107.196 - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h21m48s 5 12m10s 20m40s 16m21s 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 10 21 1 16m37s 16m37s Nov 11 21 1 12m10s 12m10s Nov 12 21 1 12m23s 12m23s Nov 13 21 1 20m40s 20m40s Nov 14 21 1 19m56s 19m56s [ User: a3d - Total duration: 1h21m48s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1h21m48s - Times executed: 5 ]
-
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-13 21:18:58 Duration: 20m40s 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-14 21:17:47 Duration: 19m56s 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-10 21:14:26 Duration: 16m37s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
2 44m50s 5 6m32s 10m36s 8m58s 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 10 21 1 8m47s 8m47s Nov 11 21 1 6m32s 6m32s Nov 12 21 1 8m24s 8m24s Nov 13 21 1 10m36s 10m36s Nov 14 21 1 10m30s 10m30s [ User: a3d - Total duration: 44m50s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 44m50s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-11-13 21:08:54 Duration: 10m36s 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-14 21:08:20 Duration: 10m30s 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-10 21:06:36 Duration: 8m47s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
3 27m33s 1 27m33s 27m33s 27m33s reindex (verbose) database refperf_minarm;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 09 22 1 27m33s 27m33s [ User: postgres - Total duration: 27m33s - Times executed: 1 ]
[ Application: reindexdb - Total duration: 27m33s - Times executed: 1 ]
-
REINDEX (VERBOSE) DATABASE refperf_minarm;
Date: 2025-11-09 22:27:35 Duration: 27m33s Database: refperf_minarm User: postgres Remote: [local] Application: reindexdb
4 10m29s 5 1m36s 2m33s 2m5s 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 10 21 1 2m10s 2m10s Nov 11 21 1 1m40s 1m40s Nov 12 21 1 1m36s 1m36s Nov 13 21 1 2m33s 2m33s Nov 14 21 1 2m28s 2m28s [ User: a3d - Total duration: 10m29s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 10m29s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-11-13 21:13:39 Duration: 2m33s 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-14 21:12:44 Duration: 2m28s 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-10 21:10:46 Duration: 2m10s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
5 10m7s 5 1m36s 2m25s 2m1s 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 10 21 1 2m5s 2m5s Nov 11 21 1 1m36s 1m36s Nov 12 21 1 1m38s 1m38s Nov 13 21 1 2m25s 2m25s Nov 14 21 1 2m22s 2m22s [ User: a3d - Total duration: 10m7s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 10m7s - Times executed: 5 ]
-
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-13 21:16:05 Duration: 2m25s 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-14 21:15:06 Duration: 2m22s 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-10 21:12:52 Duration: 2m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
6 7m20s 5 1m3s 1m51s 1m28s 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 10 21 1 1m32s 1m32s Nov 11 21 1 1m5s 1m5s Nov 12 21 1 1m3s 1m3s Nov 13 21 1 1m51s 1m51s Nov 14 21 1 1m48s 1m48s [ User: a3d - Total duration: 7m20s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 7m20s - Times executed: 5 ]
-
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-13 21:17:57 Duration: 1m51s 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-14 21:16:55 Duration: 1m48s 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-10 21:14:24 Duration: 1m32s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
7 6m25s 5 57s37ms 1m30s 1m17s 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 10 21 1 1m16s 1m16s Nov 11 21 1 1m19s 1m19s Nov 12 21 1 57s37ms 57s37ms Nov 13 21 1 1m30s 1m30s Nov 14 21 1 1m21s 1m21s [ User: a3d - Total duration: 6m25s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 6m25s - Times executed: 5 ]
-
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-13 21:11:06 Duration: 1m30s 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-14 21:10:15 Duration: 1m21s 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-11 21:06:07 Duration: 1m19s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
8 5m59s 1 5m59s 5m59s 5m59s 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) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 14 14 1 5m59s 5m59s [ User: a3d - Total duration: 5m59s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 5m59s - Times executed: 1 ]
-
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) FROM stdin;
Date: 2025-11-14 14:37:58 Duration: 5m59s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
9 5m19s 1 5m19s 5m19s 5m19s create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 14 14 1 5m19s 5m19s [ User: a3d - Total duration: 5m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 5m19s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-11-14 14:59:09 Duration: 5m19s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
10 4m18s 1 4m18s 4m18s 4m18s create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 14 15 1 4m18s 4m18s [ User: a3d - Total duration: 4m18s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m18s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-14 15:03:27 Duration: 4m18s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
11 3m28s 1 3m28s 3m28s 3m28s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 14 14 1 3m28s 3m28s [ User: a3d - Total duration: 3m28s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 3m28s - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-14 14:31:11 Duration: 3m28s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
12 2m57s 5 24s97ms 40s533ms 35s504ms 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 #12
Day Hour Count Duration Avg duration Nov 10 21 1 33s338ms 33s338ms Nov 11 21 1 24s97ms 24s97ms Nov 12 21 1 40s533ms 40s533ms Nov 13 21 1 39s503ms 39s503ms Nov 14 21 1 40s48ms 40s48ms [ User: a3d - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 5 ]
-
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-12 21:11:49 Duration: 40s533ms Database: refperf_minarm User: a3d Remote: 10.6.107.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-14 21:17:35 Duration: 40s48ms 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-13 21:18:37 Duration: 39s503ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
13 1m43s 1 1m43s 1m43s 1m43s alter table only public.gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 14 14 1 1m43s 1m43s [ User: a3d - Total duration: 1m43s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m43s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-14 14:43:52 Duration: 1m43s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
14 1m41s 1 1m41s 1m41s 1m41s alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_tab foreign key (obj_compo_num_id_tab) references public.gtp_obj_composition (obj_compo_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 14 15 1 1m41s 1m41s [ User: a3d - Total duration: 1m41s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m41s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_tab FOREIGN KEY (obj_compo_num_id_tab) REFERENCES public.gtp_obj_composition (obj_compo_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-14 15:11:20 Duration: 1m41s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
15 1m11s 1 1m11s 1m11s 1m11s create index i_gtp_obj_compo_template on public.gtp_obj_composition using btree (att_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 14 14 1 1m11s 1m11s [ User: a3d - Total duration: 1m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m11s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_template ON public.gtp_obj_composition USING btree (att_template_num_id);
Date: 2025-11-14 14:53:50 Duration: 1m11s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
16 1m6s 1 1m6s 1m6s 1m6s vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_composition;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 09 21 1 1m6s 1m6s [ User: postgres - Total duration: 1m6s - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 1m6s - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_composition;
Date: 2025-11-09 21:01:08 Duration: 1m6s Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
17 1m6s 5 9s958ms 17s195ms 13s297ms 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 #17
Day Hour Count Duration Avg duration Nov 10 21 1 13s32ms 13s32ms Nov 11 21 1 9s958ms 9s958ms Nov 12 21 1 10s158ms 10s158ms Nov 13 21 1 16s140ms 16s140ms Nov 14 21 1 17s195ms 17s195ms [ User: a3d - Total duration: 1m6s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 5 ]
-
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-14 21:17:53 Duration: 17s195ms 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-13 21:18:53 Duration: 16s140ms 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-10 21:14:39 Duration: 13s32ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
18 1m5s 1 1m5s 1m5s 1m5s alter table only public.gtp_obj_composition add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 14 14 1 1m5s 1m5s [ User: a3d - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-11-14 14:40:43 Duration: 1m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
19 1m5s 1 1m5s 1m5s 1m5s alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 14 15 1 1m5s 1m5s [ User: a3d - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-14 15:09:38 Duration: 1m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
20 1m1s 1 1m1s 1m1s 1m1s create index i_gtp_obj_compo_category on public.gtp_obj_composition using btree (att_template_category_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 14 14 1 1m1s 1m1s [ User: a3d - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_category ON public.gtp_obj_composition USING btree (att_template_category_num_id);
Date: 2025-11-14 14:50:58 Duration: 1m1s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 5 1h21m48s 12m10s 20m40s 16m21s 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 10 21 1 16m37s 16m37s Nov 11 21 1 12m10s 12m10s Nov 12 21 1 12m23s 12m23s Nov 13 21 1 20m40s 20m40s Nov 14 21 1 19m56s 19m56s [ User: a3d - Total duration: 1h21m48s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1h21m48s - Times executed: 5 ]
-
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-13 21:18:58 Duration: 20m40s 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-14 21:17:47 Duration: 19m56s 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-10 21:14:26 Duration: 16m37s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
2 5 44m50s 6m32s 10m36s 8m58s 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 10 21 1 8m47s 8m47s Nov 11 21 1 6m32s 6m32s Nov 12 21 1 8m24s 8m24s Nov 13 21 1 10m36s 10m36s Nov 14 21 1 10m30s 10m30s [ User: a3d - Total duration: 44m50s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 44m50s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-11-13 21:08:54 Duration: 10m36s 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-14 21:08:20 Duration: 10m30s 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-10 21:06:36 Duration: 8m47s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
3 5 10m29s 1m36s 2m33s 2m5s 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 10 21 1 2m10s 2m10s Nov 11 21 1 1m40s 1m40s Nov 12 21 1 1m36s 1m36s Nov 13 21 1 2m33s 2m33s Nov 14 21 1 2m28s 2m28s [ User: a3d - Total duration: 10m29s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 10m29s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-11-13 21:13:39 Duration: 2m33s 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-14 21:12:44 Duration: 2m28s 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-10 21:10:46 Duration: 2m10s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
4 5 10m7s 1m36s 2m25s 2m1s 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 10 21 1 2m5s 2m5s Nov 11 21 1 1m36s 1m36s Nov 12 21 1 1m38s 1m38s Nov 13 21 1 2m25s 2m25s Nov 14 21 1 2m22s 2m22s [ User: a3d - Total duration: 10m7s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 10m7s - Times executed: 5 ]
-
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-13 21:16:05 Duration: 2m25s 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-14 21:15:06 Duration: 2m22s 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-10 21:12:52 Duration: 2m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
5 5 7m20s 1m3s 1m51s 1m28s 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 10 21 1 1m32s 1m32s Nov 11 21 1 1m5s 1m5s Nov 12 21 1 1m3s 1m3s Nov 13 21 1 1m51s 1m51s Nov 14 21 1 1m48s 1m48s [ User: a3d - Total duration: 7m20s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 7m20s - Times executed: 5 ]
-
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-13 21:17:57 Duration: 1m51s 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-14 21:16:55 Duration: 1m48s 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-10 21:14:24 Duration: 1m32s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
6 5 6m25s 57s37ms 1m30s 1m17s 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 10 21 1 1m16s 1m16s Nov 11 21 1 1m19s 1m19s Nov 12 21 1 57s37ms 57s37ms Nov 13 21 1 1m30s 1m30s Nov 14 21 1 1m21s 1m21s [ User: a3d - Total duration: 6m25s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 6m25s - Times executed: 5 ]
-
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-13 21:11:06 Duration: 1m30s 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-14 21:10:15 Duration: 1m21s 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-11 21:06:07 Duration: 1m19s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
7 5 2m57s 24s97ms 40s533ms 35s504ms 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 10 21 1 33s338ms 33s338ms Nov 11 21 1 24s97ms 24s97ms Nov 12 21 1 40s533ms 40s533ms Nov 13 21 1 39s503ms 39s503ms Nov 14 21 1 40s48ms 40s48ms [ User: a3d - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 5 ]
-
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-12 21:11:49 Duration: 40s533ms Database: refperf_minarm User: a3d Remote: 10.6.107.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-14 21:17:35 Duration: 40s48ms 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-13 21:18:37 Duration: 39s503ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
8 5 1m6s 9s958ms 17s195ms 13s297ms 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 10 21 1 13s32ms 13s32ms Nov 11 21 1 9s958ms 9s958ms Nov 12 21 1 10s158ms 10s158ms Nov 13 21 1 16s140ms 16s140ms Nov 14 21 1 17s195ms 17s195ms [ User: a3d - Total duration: 1m6s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 5 ]
-
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-14 21:17:53 Duration: 17s195ms 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-13 21:18:53 Duration: 16s140ms 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-10 21:14:39 Duration: 13s32ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
9 5 34s600ms 4s724ms 8s624ms 6s920ms 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 10 21 1 7s169ms 7s169ms Nov 11 21 1 4s724ms 4s724ms Nov 12 21 1 5s581ms 5s581ms Nov 13 21 1 8s500ms 8s500ms Nov 14 21 1 8s624ms 8s624ms [ User: a3d - Total duration: 34s600ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 34s600ms - Times executed: 5 ]
-
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-14 21:17:55 Duration: 8s624ms 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-13 21:19:02 Duration: 8s500ms 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-10 21:14:46 Duration: 7s169ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
10 5 33s761ms 5s153ms 8s237ms 6s752ms 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 10 21 1 6s976ms 6s976ms Nov 11 21 1 5s305ms 5s305ms Nov 12 21 1 5s153ms 5s153ms Nov 13 21 1 8s88ms 8s88ms Nov 14 21 1 8s237ms 8s237ms [ User: a3d - Total duration: 33s761ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 33s761ms - Times executed: 5 ]
-
COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;
Date: 2025-11-14 21:18:01 Duration: 8s237ms 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-13 21:19:07 Duration: 8s88ms 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-10 21:14:54 Duration: 6s976ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
11 1 27m33s 27m33s 27m33s 27m33s reindex (verbose) database refperf_minarm;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 09 22 1 27m33s 27m33s [ User: postgres - Total duration: 27m33s - Times executed: 1 ]
[ Application: reindexdb - Total duration: 27m33s - Times executed: 1 ]
-
REINDEX (VERBOSE) DATABASE refperf_minarm;
Date: 2025-11-09 22:27:35 Duration: 27m33s Database: refperf_minarm User: postgres Remote: [local] Application: reindexdb
12 1 5m59s 5m59s 5m59s 5m59s 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) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 14 14 1 5m59s 5m59s [ User: a3d - Total duration: 5m59s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 5m59s - Times executed: 1 ]
-
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) FROM stdin;
Date: 2025-11-14 14:37:58 Duration: 5m59s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
13 1 5m19s 5m19s 5m19s 5m19s create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 14 14 1 5m19s 5m19s [ User: a3d - Total duration: 5m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 5m19s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-11-14 14:59:09 Duration: 5m19s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
14 1 4m18s 4m18s 4m18s 4m18s create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 14 15 1 4m18s 4m18s [ User: a3d - Total duration: 4m18s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m18s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-14 15:03:27 Duration: 4m18s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
15 1 3m28s 3m28s 3m28s 3m28s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 14 14 1 3m28s 3m28s [ User: a3d - Total duration: 3m28s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 3m28s - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-14 14:31:11 Duration: 3m28s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
16 1 1m43s 1m43s 1m43s 1m43s alter table only public.gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 14 14 1 1m43s 1m43s [ User: a3d - Total duration: 1m43s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m43s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-14 14:43:52 Duration: 1m43s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
17 1 1m41s 1m41s 1m41s 1m41s alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_tab foreign key (obj_compo_num_id_tab) references public.gtp_obj_composition (obj_compo_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 14 15 1 1m41s 1m41s [ User: a3d - Total duration: 1m41s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m41s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_tab FOREIGN KEY (obj_compo_num_id_tab) REFERENCES public.gtp_obj_composition (obj_compo_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-14 15:11:20 Duration: 1m41s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
18 1 1m11s 1m11s 1m11s 1m11s create index i_gtp_obj_compo_template on public.gtp_obj_composition using btree (att_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 14 14 1 1m11s 1m11s [ User: a3d - Total duration: 1m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m11s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_template ON public.gtp_obj_composition USING btree (att_template_num_id);
Date: 2025-11-14 14:53:50 Duration: 1m11s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
19 1 1m6s 1m6s 1m6s 1m6s vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_composition;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 09 21 1 1m6s 1m6s [ User: postgres - Total duration: 1m6s - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 1m6s - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_composition;
Date: 2025-11-09 21:01:08 Duration: 1m6s Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
20 1 1m5s 1m5s 1m5s 1m5s alter table only public.gtp_obj_composition add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 14 14 1 1m5s 1m5s [ User: a3d - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-11-14 14:40:43 Duration: 1m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 27m33s 27m33s 27m33s 1 27m33s reindex (verbose) database refperf_minarm;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 09 22 1 27m33s 27m33s [ User: postgres - Total duration: 27m33s - Times executed: 1 ]
[ Application: reindexdb - Total duration: 27m33s - Times executed: 1 ]
-
REINDEX (VERBOSE) DATABASE refperf_minarm;
Date: 2025-11-09 22:27:35 Duration: 27m33s Database: refperf_minarm User: postgres Remote: [local] Application: reindexdb
2 12m10s 20m40s 16m21s 5 1h21m48s 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 10 21 1 16m37s 16m37s Nov 11 21 1 12m10s 12m10s Nov 12 21 1 12m23s 12m23s Nov 13 21 1 20m40s 20m40s Nov 14 21 1 19m56s 19m56s [ User: a3d - Total duration: 1h21m48s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1h21m48s - Times executed: 5 ]
-
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-13 21:18:58 Duration: 20m40s 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-14 21:17:47 Duration: 19m56s 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-10 21:14:26 Duration: 16m37s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
3 6m32s 10m36s 8m58s 5 44m50s 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 10 21 1 8m47s 8m47s Nov 11 21 1 6m32s 6m32s Nov 12 21 1 8m24s 8m24s Nov 13 21 1 10m36s 10m36s Nov 14 21 1 10m30s 10m30s [ User: a3d - Total duration: 44m50s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 44m50s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-11-13 21:08:54 Duration: 10m36s 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-14 21:08:20 Duration: 10m30s 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-10 21:06:36 Duration: 8m47s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
4 5m59s 5m59s 5m59s 1 5m59s 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) from stdin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 14 14 1 5m59s 5m59s [ User: a3d - Total duration: 5m59s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 5m59s - Times executed: 1 ]
-
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) FROM stdin;
Date: 2025-11-14 14:37:58 Duration: 5m59s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
5 5m19s 5m19s 5m19s 1 5m19s create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 14 14 1 5m19s 5m19s [ User: a3d - Total duration: 5m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 5m19s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-11-14 14:59:09 Duration: 5m19s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
6 4m18s 4m18s 4m18s 1 4m18s create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 14 15 1 4m18s 4m18s [ User: a3d - Total duration: 4m18s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m18s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-14 15:03:27 Duration: 4m18s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
7 3m28s 3m28s 3m28s 1 3m28s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 14 14 1 3m28s 3m28s [ User: a3d - Total duration: 3m28s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 3m28s - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-14 14:31:11 Duration: 3m28s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
8 1m36s 2m33s 2m5s 5 10m29s 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 #8
Day Hour Count Duration Avg duration Nov 10 21 1 2m10s 2m10s Nov 11 21 1 1m40s 1m40s Nov 12 21 1 1m36s 1m36s Nov 13 21 1 2m33s 2m33s Nov 14 21 1 2m28s 2m28s [ User: a3d - Total duration: 10m29s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 10m29s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-11-13 21:13:39 Duration: 2m33s 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-14 21:12:44 Duration: 2m28s 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-10 21:10:46 Duration: 2m10s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
9 1m36s 2m25s 2m1s 5 10m7s 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 #9
Day Hour Count Duration Avg duration Nov 10 21 1 2m5s 2m5s Nov 11 21 1 1m36s 1m36s Nov 12 21 1 1m38s 1m38s Nov 13 21 1 2m25s 2m25s Nov 14 21 1 2m22s 2m22s [ User: a3d - Total duration: 10m7s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 10m7s - Times executed: 5 ]
-
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-13 21:16:05 Duration: 2m25s 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-14 21:15:06 Duration: 2m22s 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-10 21:12:52 Duration: 2m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
10 1m43s 1m43s 1m43s 1 1m43s alter table only public.gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 14 14 1 1m43s 1m43s [ User: a3d - Total duration: 1m43s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m43s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-14 14:43:52 Duration: 1m43s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
11 1m41s 1m41s 1m41s 1 1m41s alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_tab foreign key (obj_compo_num_id_tab) references public.gtp_obj_composition (obj_compo_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 14 15 1 1m41s 1m41s [ User: a3d - Total duration: 1m41s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m41s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_tab FOREIGN KEY (obj_compo_num_id_tab) REFERENCES public.gtp_obj_composition (obj_compo_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-14 15:11:20 Duration: 1m41s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
12 1m3s 1m51s 1m28s 5 7m20s 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 #12
Day Hour Count Duration Avg duration Nov 10 21 1 1m32s 1m32s Nov 11 21 1 1m5s 1m5s Nov 12 21 1 1m3s 1m3s Nov 13 21 1 1m51s 1m51s Nov 14 21 1 1m48s 1m48s [ User: a3d - Total duration: 7m20s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 7m20s - Times executed: 5 ]
-
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-13 21:17:57 Duration: 1m51s 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-14 21:16:55 Duration: 1m48s 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-10 21:14:24 Duration: 1m32s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
13 57s37ms 1m30s 1m17s 5 6m25s 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 #13
Day Hour Count Duration Avg duration Nov 10 21 1 1m16s 1m16s Nov 11 21 1 1m19s 1m19s Nov 12 21 1 57s37ms 57s37ms Nov 13 21 1 1m30s 1m30s Nov 14 21 1 1m21s 1m21s [ User: a3d - Total duration: 6m25s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 6m25s - Times executed: 5 ]
-
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-13 21:11:06 Duration: 1m30s 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-14 21:10:15 Duration: 1m21s 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-11 21:06:07 Duration: 1m19s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
14 1m11s 1m11s 1m11s 1 1m11s create index i_gtp_obj_compo_template on public.gtp_obj_composition using btree (att_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 14 14 1 1m11s 1m11s [ User: a3d - Total duration: 1m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m11s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_template ON public.gtp_obj_composition USING btree (att_template_num_id);
Date: 2025-11-14 14:53:50 Duration: 1m11s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
15 1m6s 1m6s 1m6s 1 1m6s vacuum (skip_database_stats, verbose, analyze) public.gtp_obj_composition;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 09 21 1 1m6s 1m6s [ User: postgres - Total duration: 1m6s - Times executed: 1 ]
[ Application: vacuumdb - Total duration: 1m6s - Times executed: 1 ]
-
VACUUM (SKIP_DATABASE_STATS, VERBOSE, ANALYZE) public.gtp_obj_composition;
Date: 2025-11-09 21:01:08 Duration: 1m6s Database: refperf_minarm User: postgres Remote: [local] Application: vacuumdb
16 1m5s 1m5s 1m5s 1 1m5s alter table only public.gtp_obj_composition add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 14 14 1 1m5s 1m5s [ User: a3d - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-11-14 14:40:43 Duration: 1m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
17 1m5s 1m5s 1m5s 1 1m5s alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 14 15 1 1m5s 1m5s [ User: a3d - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-14 15:09:38 Duration: 1m5s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
18 1m1s 1m1s 1m1s 1 1m1s create index i_gtp_obj_compo_category on public.gtp_obj_composition using btree (att_template_category_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 14 14 1 1m1s 1m1s [ User: a3d - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_category ON public.gtp_obj_composition USING btree (att_template_category_num_id);
Date: 2025-11-14 14:50:58 Duration: 1m1s Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_restore
19 24s97ms 40s533ms 35s504ms 5 2m57s 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 #19
Day Hour Count Duration Avg duration Nov 10 21 1 33s338ms 33s338ms Nov 11 21 1 24s97ms 24s97ms Nov 12 21 1 40s533ms 40s533ms Nov 13 21 1 39s503ms 39s503ms Nov 14 21 1 40s48ms 40s48ms [ User: a3d - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 5 ]
-
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-12 21:11:49 Duration: 40s533ms Database: refperf_minarm User: a3d Remote: 10.6.107.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-14 21:17:35 Duration: 40s48ms 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-13 21:18:37 Duration: 39s503ms Database: refperf_minarm User: a3d Remote: 10.6.201.196 Application: pg_dump
20 9s958ms 17s195ms 13s297ms 5 1m6s 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 #20
Day Hour Count Duration Avg duration Nov 10 21 1 13s32ms 13s32ms Nov 11 21 1 9s958ms 9s958ms Nov 12 21 1 10s158ms 10s158ms Nov 13 21 1 16s140ms 16s140ms Nov 14 21 1 17s195ms 17s195ms [ User: a3d - Total duration: 1m6s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 5 ]
-
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-14 21:17:53 Duration: 17s195ms 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-13 21:18:53 Duration: 16s140ms 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-10 21:14:39 Duration: 13s32ms Database: refperf_minarm User: a3d Remote: 10.6.107.196 Application: pg_dump
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
- 136 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 11 WARNING entries
Most Frequent Errors/Events
Key values
- 11 Max number of times the same event was reported
- 12 Total events found
Rank Times reported Error 1 11 WARNING: permission denied to vacuum "...", skipping it
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 14 15 11 2 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 14 14 1 - ERROR: relation "gtp_a3d_version" does not exist at character 44
Statement: SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY
Date: 2025-11-14 14:24:02 Database: refperf_minarm Application: [unknown] User: a3d Remote: 10.6.201.196