Times Reported Time consuming queries #1

x Hide

[ User: a3dsupervisor - Total duration: 20s889ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 20s889ms - Times executed: 1 ]

x Hide

COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;

Date: 2025-11-14 08:37:46
Duration: 20s889ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: a3dsupervisor - Total duration: 461ms - Times executed: 34 ]

x Hide

[ Application: [unknown] - Total duration: 461ms - Times executed: 34 ]

x Hide

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-11-14 09:54:22
Duration: 17ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.1.6
Application: [unknown]
Bind query: yes

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-11-14 08:32:53
Duration: 17ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-11-14 08:38:32
Duration: 17ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: a3dsupervisor - Total duration: 263ms - Times executed: 34 ]

x Hide

[ Application: [unknown] - Total duration: 263ms - Times executed: 34 ]

x Hide

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-11-14 07:57:19
Duration: 18ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-11-14 08:32:53
Duration: 9ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-11-14 08:38:32
Duration: 8ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: a3dsupervisor - Total duration: 256ms - Times executed: 34 ]

x Hide

[ Application: [unknown] - Total duration: 256ms - Times executed: 34 ]

x Hide

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-11-14 07:57:19
Duration: 19ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-11-14 08:50:33
Duration: 11ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-11-14 08:38:32
Duration: 11ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: a3dsupervisor - Total duration: 212ms - Times executed: 34 ]

x Hide

[ Application: [unknown] - Total duration: 212ms - Times executed: 34 ]

x Hide

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-11-14 10:29:58
Duration: 7ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-11-14 10:28:02
Duration: 7ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-11-14 10:28:23
Duration: 7ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: a3dsupervisor - Total duration: 54ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 54ms - Times executed: 1 ]

x Hide

SELECT t.tableoid, t.oid, i.indrelid, t.relname AS indexname, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indkey, i.indisclustered, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, i.indisreplident, inh.inhparent AS parentidx, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals, i.indnullsnotdistinct FROM unnest('{2800585,2800592,2800595,2800598,2800609,2800615,2800627,2800632,2800638,2800648,2800651,2800657,2800662,2800666,2800669,2800672,2800675,2800678,2800681,2800685,2800689,2800693,2800696,2800699,2800713,2800719,2800725,2800728,2800732,2800739,2800744,2800750,2800754,2800761,2800765,2800768,2800772,2800778,2800781,2800789,2800795,2800801,2800807,2800810,2800815,2800818,2800823,2800830,2800835,2800838,2800843,2800847,2800858,2800868,2800875,2800879,2800884,2800893,2800897,2800901,2800908,2800914,2800924,2800927,2800930,2800933,2800939,2800942,2800950,2800956,2800962,2800968,2800971,2800974,2800978,2800982,2800985,2800988,2800991,2800994,2800997,2801000,2801003,2801006,2801009,2801012,2801018,2801021,2801024,2801030,2801037,2801043,2801049,2801056,2801062,2801068,2801074,2801077,2801083,2801089,2801096,2801099,2801102,2801105,2801109,2801115,2801133,2801139,2801144,2801150,2801157,2801160,2801164,2801168,2801172,2801176,2801179,2801183,2801187,2801193,2801197,2801203,2801209,2801214,2801217,2801224,2801227,2801233,2801239,2801242,2801248,2801257,2801264,2801270,2801273,2801276,2801281,2801284,2801293,2801299,2801303,2801306,2801312,2801315,2801318,2801322,2801327,2801333,2801340,2801347,2801353,2801357,2801360,2801363,2801366,2801371,2801375,2801382,2801389,2801395,2801398,2801404,2801410,2801413,2801417,2801420,2801425,2801428,2801431,2801434,2801439,2801442,2801445,2801448,2801453,2801459,2801466,2801469,2801474,2801481,2801488,2801491,2801494,2801498,2801504,2801507,2801513,2801516,2801523,2801528,2801534,2801540,2801543,2801548,2801553,2801558,2801563,2801568,2801571,2801574,2801577,2801580,2801583,2801589,2801595,2801601,2801607,2801613,2801617,2801621,2801625,2801629,2801633,2801637,2801641,2801645,2801650,2801655,2801660,2801665,2801670,2801675,2801679,2801683,2801689,2801695,2801699,2801704,2801710,2801715,2801720,2801723,2801728,2801732,2801738,2801744,2801747,2801753}'::pg_catalog.oid[]) AS src (tbloid) JOIN pg_catalog.pg_index i ON (src.tbloid = i.indrelid) JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY i.indrelid, indexname;

Date: 2025-11-14 08:31:49
Duration: 54ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: a3dsupervisor - Total duration: 42ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 42ms - Times executed: 1 ]

x Hide

SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;

Date: 2025-11-14 08:31:48
Duration: 42ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: a3dsupervisor - Total duration: 31ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 31ms - Times executed: 1 ]

x Hide

SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);

Date: 2025-11-14 08:31:49
Duration: 31ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: a3dsupervisor - Total duration: 27ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 27ms - Times executed: 1 ]

x Hide

SELECT oid, lomowner, lomacl, acldefault('L', lomowner) AS acldefault FROM pg_largeobject_metadata ORDER BY lomowner, lomacl::pg_catalog.text, oid;

Date: 2025-11-14 08:31:49
Duration: 27ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #10

x Hide

[ User: a3dsupervisor - Total duration: 26ms - Times executed: 164 ]

x Hide

[ Application: pg_dump - Total duration: 26ms - Times executed: 164 ]

x Hide

SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;

Date: 2025-11-14 08:31:50
Duration: 2ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800531'::oid;

Date: 2025-11-14 08:31:51
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800501'::oid;

Date: 2025-11-14 08:31:50
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #11

x Hide

[ User: a3dsupervisor - Total duration: 25ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 25ms - Times executed: 1 ]

x Hide

SELECT a.attrelid, a.attnum, a.attname, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid, a.atttypmod) AS atttypname, array_to_string(a.attoptions, ', ') AS attoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, pg_catalog.array_to_string(ARRAY ( SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), E', ') AS attfdwoptions, a.attcompression AS attcompression, a.attidentity, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE null END AS attmissingval, a.attgenerated FROM unnest('{2800585,2800592,2800595,2800598,2800609,2800615,2800627,2800632,2800638,2800643,2800648,2800651,2800657,2800662,2800666,2800669,2800672,2800675,2800678,2800681,2800685,2800689,2800693,2800696,2800699,2800713,2800719,2800725,2800728,2800732,2800739,2800744,2800750,2800754,2800761,2800765,2800768,2800772,2800778,2800781,2800789,2800795,2800801,2800807,2800810,2800815,2800818,2800823,2800830,2800835,2800838,2800843,2800847,2800853,2800858,2800868,2800875,2800879,2800884,2800893,2800897,2800901,2800908,2800914,2800921,2800924,2800927,2800930,2800933,2800939,2800942,2800945,2800950,2800956,2800962,2800968,2800971,2800974,2800978,2800982,2800985,2800988,2800991,2800994,2800997,2801000,2801003,2801006,2801009,2801012,2801018,2801021,2801024,2801030,2801037,2801043,2801049,2801056,2801062,2801068,2801074,2801077,2801083,2801089,2801096,2801099,2801102,2801105,2801109,2801115,2801133,2801139,2801144,2801150,2801157,2801160,2801164,2801168,2801172,2801176,2801179,2801183,2801187,2801193,2801197,2801203,2801209,2801214,2801217,2801224,2801227,2801233,2801239,2801242,2801248,2801257,2801264,2801270,2801273,2801276,2801281,2801284,2801293,2801299,2801303,2801306,2801312,2801315,2801318,2801322,2801327,2801333,2801340,2801347,2801353,2801357,2801360,2801363,2801366,2801371,2801375,2801382,2801389,2801395,2801398,2801404,2801410,2801413,2801417,2801420,2801425,2801428,2801431,2801434,2801439,2801442,2801445,2801448,2801453,2801459,2801466,2801469,2801474,2801481,2801488,2801491,2801494,2801498,2801504,2801507,2801513,2801516,2801523,2801528,2801534,2801540,2801543,2801548,2801553,2801558,2801563,2801568,2801571,2801574,2801577,2801580,2801583,2801589,2801595,2801601,2801607,2801613,2801617,2801621,2801625,2801629,2801633,2801637,2801641,2801645,2801650,2801655,2801660,2801665,2801670,2801675,2801679,2801683,2801689,2801695,2801699,2801704,2801710,2801715,2801720,2801723,2801728,2801732,2801738,2801744,2801747,2801753,2801756}'::pg_catalog.oid[]) AS src (tbloid) JOIN pg_catalog.pg_attribute a ON (src.tbloid = a.attrelid) LEFT JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) WHERE a.attnum > 0::pg_catalog.int2 ORDER BY a.attrelid, a.attnum;

Date: 2025-11-14 08:31:49
Duration: 25ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #12

x Hide

[ User: a3dsupervisor - Total duration: 20ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 20ms - Times executed: 1 ]

x Hide

SELECT a.tableoid, a.oid, adrelid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM unnest('{2800585,2800598,2800609,2800615,2800632,2800651,2800662,2800681,2800685,2800689,2800699,2800713,2800719,2800728,2800732,2800744,2800750,2800754,2800761,2800768,2800772,2800781,2800789,2800795,2800801,2800810,2800818,2800823,2800830,2800838,2800843,2800847,2800858,2800868,2800875,2800879,2800884,2800893,2800897,2800901,2800908,2800914,2800933,2800950,2800956,2800962,2800974,2800978,2801012,2801024,2801030,2801037,2801043,2801049,2801056,2801062,2801068,2801077,2801083,2801089,2801105,2801109,2801115,2801133,2801144,2801150,2801160,2801164,2801168,2801172,2801179,2801183,2801187,2801193,2801197,2801203,2801209,2801217,2801227,2801233,2801242,2801248,2801257,2801264,2801284,2801293,2801299,2801306,2801318,2801327,2801333,2801340,2801347,2801353,2801371,2801375,2801382,2801389,2801398,2801404,2801413,2801453,2801459,2801474,2801481,2801494,2801498,2801507,2801516,2801528,2801534,2801543,2801548,2801553,2801558,2801563,2801583,2801589,2801595,2801601,2801607,2801613,2801617,2801621,2801625,2801629,2801633,2801637,2801641,2801675,2801679,2801683,2801689,2801695,2801704,2801728,2801732,2801738,2801747}'::pg_catalog.oid[]) AS src (tbloid) JOIN pg_catalog.pg_attrdef a ON (src.tbloid = a.adrelid) ORDER BY a.adrelid, a.adnum;

Date: 2025-11-14 08:31:49
Duration: 20ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #13

x Hide

[ User: a3dsupervisor - Total duration: 19ms - Times executed: 109 ]

x Hide

[ Application: pg_dump - Total duration: 19ms - Times executed: 109 ]

x Hide

EXECUTE dumpFunc ('2818867');

Date: 2025-11-14 08:31:49
Duration: 1ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

EXECUTE dumpFunc ('2818849');

Date: 2025-11-14 08:31:49
Duration: 1ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

EXECUTE dumpFunc ('2818852');

Date: 2025-11-14 08:31:49
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #14

x Hide

[ User: a3dsupervisor - Total duration: 17ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 17ms - Times executed: 1 ]

x Hide

SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;

Date: 2025-11-14 08:31:49
Duration: 17ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #15

x Hide

[ User: a3dsupervisor - Total duration: 17ms - Times executed: 34 ]

x Hide

[ Application: [unknown] - Total duration: 17ms - Times executed: 34 ]

x Hide

SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();

Date: 2025-11-14 13:23:23
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();

Date: 2025-11-14 10:28:53
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();

Date: 2025-11-14 10:25:24
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #16

x Hide

[ User: a3dsupervisor - Total duration: 12ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 12ms - Times executed: 1 ]

x Hide

SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;

Date: 2025-11-14 08:31:49
Duration: 12ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #17

x Hide

[ User: a3dsupervisor - Total duration: 10ms - Times executed: 34 ]

x Hide

[ Application: [unknown] - Total duration: 10ms - Times executed: 34 ]

x Hide

SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';

Date: 2025-11-14 07:57:19
Duration: 1ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';

Date: 2025-11-14 13:23:23
Duration: 1ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';

Date: 2025-11-14 08:38:32
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #18

x Hide

[ User: a3dsupervisor - Total duration: 8ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 8ms - Times executed: 1 ]

x Hide

SELECT tableoid, oid, typname, typnamespace, typacl, acldefault('T', typowner) AS acldefault, typowner, typelem, typrelid, CASE WHEN typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = typrelid) END AS typrelkind, typtype, typisdefined, typname[0] = '_' AND typelem != 0 AND ( SELECT typarray FROM pg_type te WHERE oid = pg_type.typelem) = oid AS isarray FROM pg_type;

Date: 2025-11-14 08:31:49
Duration: 8ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #19

x Hide

[ User: a3dsupervisor - Total duration: 8ms - Times executed: 3 ]

x Hide

[ Application: pg_dump - Total duration: 8ms - Times executed: 3 ]

x Hide

SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';

Date: 2025-11-14 08:31:48
Duration: 4ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';

Date: 2025-11-14 08:31:52
Duration: 2ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';

Date: 2025-11-14 08:31:52
Duration: 1ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #20

x Hide

[ User: a3dsupervisor - Total duration: 6ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 6ms - Times executed: 1 ]

x Hide

SELECT t.tgrelid, t.tgname, pg_catalog.pg_get_triggerdef(t.oid, false) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgparentid <> 0 AS tgispartition FROM unnest('{2800585,2800592,2800595,2800598,2800609,2800615,2800627,2800632,2800638,2800643,2800648,2800651,2800657,2800662,2800666,2800669,2800672,2800675,2800678,2800681,2800685,2800689,2800693,2800696,2800699,2800725,2800728,2800732,2800739,2800744,2800750,2800754,2800761,2800768,2800772,2800778,2800781,2800789,2800795,2800801,2800810,2800815,2800843,2800847,2800858,2800868,2800875,2800879,2800884,2800893,2800897,2800901,2800908,2800914,2800924,2800927,2800930,2800933,2800939,2800956,2800962,2800968,2800971,2800974,2800978,2800982,2800985,2800988,2800991,2800994,2800997,2801000,2801003,2801006,2801009,2801018,2801021,2801024,2801030,2801037,2801043,2801049,2801056,2801062,2801068,2801074,2801077,2801083,2801089,2801096,2801099,2801102,2801105,2801109,2801115,2801133,2801139,2801144,2801150,2801187,2801193,2801197,2801203,2801209,2801214,2801217,2801227,2801233,2801239,2801242,2801248,2801257,2801264,2801270,2801273,2801276,2801281,2801284,2801293,2801299,2801303,2801312,2801315,2801318,2801322,2801327,2801333,2801340,2801347,2801353,2801357,2801360,2801363,2801371,2801375,2801382,2801389,2801395,2801398,2801404,2801413,2801417,2801420,2801425,2801428,2801431,2801434,2801439,2801445,2801453,2801459,2801466,2801469,2801474,2801481,2801488,2801491,2801494,2801498,2801504,2801507,2801513,2801516,2801523,2801528,2801540,2801543,2801548,2801553,2801558,2801563,2801568,2801571,2801574,2801577,2801580,2801583,2801589,2801595,2801601,2801607,2801613,2801621,2801625,2801629,2801633,2801637,2801641,2801645,2801650,2801655,2801660,2801665,2801670,2801675,2801679,2801689,2801699,2801704,2801710,2801715,2801720,2801723,2801728,2801732,2801738,2801744,2801747,2801753}'::pg_catalog.oid[]) AS src (tbloid) JOIN pg_catalog.pg_trigger t ON (src.tbloid = t.tgrelid) LEFT JOIN pg_catalog.pg_trigger u ON (u.oid = t.tgparentid) WHERE ((NOT t.tgisinternal AND t.tgparentid = 0) OR t.tgenabled != u.tgenabled) ORDER BY t.tgrelid, t.tgname;

Date: 2025-11-14 08:31:49
Duration: 6ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: a3dsupervisor - Total duration: 26ms - Times executed: 164 ]

x Hide

[ Application: pg_dump - Total duration: 26ms - Times executed: 164 ]

x Hide

SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;

Date: 2025-11-14 08:31:50
Duration: 2ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800531'::oid;

Date: 2025-11-14 08:31:51
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800501'::oid;

Date: 2025-11-14 08:31:50
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: a3dsupervisor - Total duration: 19ms - Times executed: 109 ]

x Hide

[ Application: pg_dump - Total duration: 19ms - Times executed: 109 ]

x Hide

EXECUTE dumpFunc ('2818867');

Date: 2025-11-14 08:31:49
Duration: 1ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

EXECUTE dumpFunc ('2818849');

Date: 2025-11-14 08:31:49
Duration: 1ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

EXECUTE dumpFunc ('2818852');

Date: 2025-11-14 08:31:49
Duration: 0ms
Database: autotest_feat_batch
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: a3dsupervisor - Total duration: 461ms - Times executed: 34 ]

x Hide

[ Application: [unknown] - Total duration: 461ms - Times executed: 34 ]