pgBadger-
Global information
- Generated on Mon Dec 8 05:03:51 2025
- Log file: ssh://root@db2.cetoc.muni.cz//mnt/logpsql/var/log/postgresql/postgresql-12-olap.log
- Parsed 5,845,658 log entries in 3m35s
- Log start from 2025-12-07 03:00:02 to 2025-12-07 23:57:43
-
Overview
Global Stats
- 22,909 Number of unique normalized queries
- 113,509 Number of queries
- 1h19m26s Total query duration
- 2025-12-07 03:00:02 First query
- 2025-12-07 23:48:40 Last query
- 4,729 queries/s at 2025-12-07 03:37:59 Query peak
- 1h19m26s Total query duration
- 553ms Prepare/parse total duration
- 301ms Bind total duration
- 1h19m25s Execute total duration
- 368 Number of events
- 2 Number of unique normalized events
- 346 Max number of times the same event was reported
- 0 Number of cancellation
- 9 Total number of automatic vacuums
- 475 Total number of automatic analyzes
- 103 Number temporary file
- 1.00 GiB Max size of temporary file
- 29.54 MiB Average size of temporary file
- 494 Total number of sessions
- 2 sessions at 2025-12-07 22:12:08 Session peak
- 1h53m22s Total duration of sessions
- 13s770ms Average duration of sessions
- 229 Average queries per session
- 9s648ms Average queries duration per session
- 4s121ms Average idle time per session
- 494 Total number of connections
- 23 connections/s at 2025-12-07 05:19:16 Connection peak
- 11 Total number of databases
SQL Traffic
Key values
- 4,729 queries/s Query Peak
- 2025-12-07 03:37:59 Date
SELECT Traffic
Key values
- 2,661 queries/s Query Peak
- 2025-12-07 04:02:49 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 452 queries/s Query Peak
- 2025-12-07 04:03:01 Date
Queries duration
Key values
- 1h19m26s 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) Dec 07 03 65,464 0ms 1m29s 50ms 1m15s 1m30s 2m1s 04 42,902 0ms 45s399ms 20ms 58s34ms 1m20s 1m24s 05 1,536 0ms 5s449ms 24ms 6s116ms 23s741ms 23s741ms 22 2,269 0ms 18s585ms 89ms 31s91ms 31s119ms 1m9s 23 1,338 0ms 1m9s 221ms 52s981ms 53s832ms 1m9s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 07 03 35,616 14,876 65ms 1m8s 1m13s 1m31s 04 30,950 5,670 24ms 45s399ms 57s157ms 1m24s 05 30 0 1ms 5ms 6ms 7ms 22 63 0 59ms 11ms 119ms 1s959ms 23 336 0 0ms 10ms 14ms 20ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 07 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 16 19ms 0ms 0ms 78ms 05 0 0 0 161 165ms 0ms 97ms 23s593ms 22 0 0 0 368 258ms 0ms 1s437ms 26s373ms 23 37 0 0 71 1s900ms 70ms 5s663ms 52s794ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 07 03 0 0 0.00 0.00% 04 165 158 0.96 0.44% 05 364 355 0.98 24.25% 22 519 507 0.98 23.61% 23 693 679 0.98 61.44% Day Hour Count Average / Second Dec 07 03 6 0.00/s 04 71 0.02/s 05 120 0.03/s 22 176 0.05/s 23 121 0.03/s Day Hour Count Average Duration Average idle time Dec 07 03 5 7m31s 0ms 04 72 50s654ms 38s283ms 05 120 787ms 467ms 22 176 2s669ms 1s509ms 23 121 2s748ms 297ms -
Connections
Established Connections
Key values
- 23 connections Connection Peak
- 2025-12-07 05:19:16 Date
Connections per database
Key values
- dwh_celspac Main Database
- 494 connections Total
Database User Count dwh_bims 85 dwh_bims_admin_user 83 postgres 2 dwh_celspac 216 dwh_celspac_admin_user 214 postgres 2 dwh_celspac_static_data 2 postgres 2 dwh_inqint 177 dwh_inqint_admin_user 175 postgres 2 dwh_ngs 2 postgres 2 dwh_por_static_data 2 postgres 2 dwh_por_v2 2 postgres 2 dwh_survey 2 postgres 2 postgres 4 postgres 4 training 2 postgres 2 Connections per user
Key values
- dwh_celspac_admin_user Main User
- 494 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2025-12-07 22:12:08 Date
Histogram of session times
Key values
- 381 0-500ms duration
Sessions per database
Key values
- dwh_celspac Main Database
- 494 sessions Total
Database Count Total Duration Average Duration dwh_bims 85 21m38s 15s276ms dwh_celspac 216 52m23s 14s550ms dwh_celspac_static_data 2 55s550ms 27s775ms dwh_inqint 177 4m1s 1s362ms dwh_ngs 2 1m1s 30s816ms dwh_por_static_data 2 6m24s 3m12s dwh_por_v2 2 26m55s 13m27s dwh_survey 2 1s325ms 662ms postgres 4 804ms 201ms training 2 589ms 294ms Sessions per user
Key values
- dwh_celspac_admin_user Main User
- 494 sessions Total
Sessions per host
Key values
- 10.16.50.5 Main Host
- 494 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 308,026 buffers Checkpoint Peak
- 2025-12-07 23:42:43 Date
- 269.870 seconds Highest write time
- 0.464 seconds Sync time
Checkpoints Wal files
Key values
- 336 files Wal files usage Peak
- 2025-12-07 23:42:43 Date
Checkpoints distance
Key values
- 6,464.14 Mo Distance Peak
- 2025-12-07 23:42:43 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 07 03 504 50.782s 0.013s 50.843s 04 2,335 234.19s 0.046s 234.421s 05 148,951 645.527s 0.083s 646.214s 22 435,660 1,152.805s 0.47s 1,153.87s 23 647,384 1,551.384s 0.685s 1,553.233s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 07 03 0 0 0 30 0.004s 0.003s 04 0 1 0 312 0.005s 0.009s 05 0 91 0 1,034 0.004s 0.005s 22 0 0 344 1,415 0.370s 0.008s 23 0 38 483 601 0.445s 0.011s Day Hour Count Avg time (sec) Dec 07 03 0 0s 04 0 0s 05 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Dec 07 03 492.33 kB 2,424,467.00 kB 04 2,345.43 kB 1,458,772.29 kB 05 298,222.60 kB 925,200.20 kB 22 1,126,095.00 kB 2,865,659.40 kB 23 1,067,396.38 kB 2,312,517.62 kB -
Temporary Files
Size of temporary files
Key values
- 1.10 GiB Temp Files size Peak
- 2025-12-07 23:36:53 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-12-07 22:12:15 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Dec 07 03 2 16.38 MiB 8.19 MiB 04 6 58.64 MiB 9.77 MiB 05 8 86.78 MiB 10.85 MiB 22 55 996.65 MiB 18.12 MiB 23 32 1.84 GiB 58.90 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 50 1.64 GiB 9.77 MiB 64.45 MiB 33.66 MiB with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != ? and nspname not like ? ), referenced as ( select relation.id as id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in (...) ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;
Date: 2025-12-07 22:09:04 Duration: 1s118ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;
Date: 2025-12-07 23:24:05 Duration: 633ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;
Date: 2025-12-07 23:09:08 Duration: 624ms
2 3 104.02 MiB 31.01 MiB 38.77 MiB 34.67 MiB create index if not exists "d47b351e4303f825a18fc305e3e516b5" on "dwh_bims".src_las."biobank_logaliquot" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_logaliquot"} */ create index if not exists "d47b351e4303f825a18fc305e3e516b5" on "dwh_bims".src_las."biobank_logaliquot" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:28 Duration: 1s523ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_logaliquot"} */ create index if not exists "d47b351e4303f825a18fc305e3e516b5" on "dwh_bims".src_las."biobank_logaliquot" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:28 Duration: 0ms
3 3 5.77 MiB 1.61 MiB 2.27 MiB 1.92 MiB create index if not exists "f445ad19459b202254e28a3a248ddaa1" on "dwh_celspac".src_data_extractor_integra."integra_main" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.integra_main"} */ create index if not exists "f445ad19459b202254e28a3a248ddaa1" on "dwh_celspac".src_data_extractor_integra."integra_main" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:09:09 Duration: 101ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.integra_main"} */ create index if not exists "f445ad19459b202254e28a3a248ddaa1" on "dwh_celspac".src_data_extractor_integra."integra_main" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:09:09 Duration: 0ms
4 3 3.61 MiB 1.06 MiB 1.45 MiB 1.20 MiB create index if not exists "7162d6bfd2e28f488fd6c29f990f9106" on "dwh_celspac".src_data_extractor_sysmex."sysmex_values" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.sysmex_values"} */ create index if not exists "7162d6bfd2e28f488fd6c29f990f9106" on "dwh_celspac".src_data_extractor_sysmex."sysmex_values" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:28:56 Duration: 57ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.sysmex_values"} */ create index if not exists "7162d6bfd2e28f488fd6c29f990f9106" on "dwh_celspac".src_data_extractor_sysmex."sysmex_values" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:28:56 Duration: 0ms
5 3 4.50 MiB 616.00 KiB 2.25 MiB 1.50 MiB create index if not exists "5139d88e09d48318a0bc0322ce811eab" on "dwh_bims".src_las."biobank_logsample" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_logsample"} */ create index if not exists "5139d88e09d48318a0bc0322ce811eab" on "dwh_bims".src_las."biobank_logsample" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:14 Duration: 204ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_logsample"} */ create index if not exists "5139d88e09d48318a0bc0322ce811eab" on "dwh_bims".src_las."biobank_logsample" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:14 Duration: 0ms
6 3 37.91 MiB 12.52 MiB 12.72 MiB 12.64 MiB create index if not exists "adf765dfb7028ff4a29d8b60ee39f3d2" on "dwh_inqint".src_air_sensor."data" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.data"} */ create index if not exists "adf765dfb7028ff4a29d8b60ee39f3d2" on "dwh_inqint".src_air_sensor."data" using btree (_airbyte_emitted_at);
Date: 2025-12-07 05:30:02 Duration: 628ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.data"} */ create index if not exists "adf765dfb7028ff4a29d8b60ee39f3d2" on "dwh_inqint".src_air_sensor."data" using btree (_airbyte_emitted_at);
Date: 2025-12-07 05:30:02 Duration: 0ms
7 3 13.13 MiB 4.01 MiB 4.59 MiB 4.38 MiB create index if not exists "a382fbd58e7840c67e02ea5ef6287541" on "dwh_celspac".src_data_extractor_spiro."fvc_best_attempts" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.fvc_best_attempts"} */ create index if not exists "a382fbd58e7840c67e02ea5ef6287541" on "dwh_celspac".src_data_extractor_spiro."fvc_best_attempts" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:24:09 Duration: 186ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.fvc_best_attempts"} */ create index if not exists "a382fbd58e7840c67e02ea5ef6287541" on "dwh_celspac".src_data_extractor_spiro."fvc_best_attempts" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:24:09 Duration: 0ms
8 3 3.45 MiB 936.00 KiB 1.52 MiB 1.15 MiB create index if not exists "649464dc2b4689ae038982789487578d" on "dwh_bims".src_las."biobank_movedcontainer" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_movedcontainer"} */ create index if not exists "649464dc2b4689ae038982789487578d" on "dwh_bims".src_las."biobank_movedcontainer" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:15 Duration: 193ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_movedcontainer"} */ create index if not exists "649464dc2b4689ae038982789487578d" on "dwh_bims".src_las."biobank_movedcontainer" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:15 Duration: 0ms
9 3 11.02 MiB 3.52 MiB 3.81 MiB 3.67 MiB create index if not exists "7e0d6b670e46530787f2a79f7e737542" on "dwh_celspac".src_bims_las."map_cls_id_barcode_all_aliquots" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.map_cls_id_barcode_all_aliquots"} */ create index if not exists "7e0d6b670e46530787f2a79f7e737542" on "dwh_celspac".src_bims_las."map_cls_id_barcode_all_aliquots" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:21:48 Duration: 226ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.map_cls_id_barcode_all_aliquots"} */ create index if not exists "7e0d6b670e46530787f2a79f7e737542" on "dwh_celspac".src_bims_las."map_cls_id_barcode_all_aliquots" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:21:48 Duration: 0ms
10 3 11.03 MiB 3.06 MiB 4.34 MiB 3.68 MiB create index if not exists "56ec4a5f34f2b69d5552265dd3bdc24e" on "dwh_bims".src_las."biobank_aliquot" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_aliquot"} */ create index if not exists "56ec4a5f34f2b69d5552265dd3bdc24e" on "dwh_bims".src_las."biobank_aliquot" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:12 Duration: 571ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_aliquot"} */ create index if not exists "56ec4a5f34f2b69d5552265dd3bdc24e" on "dwh_bims".src_las."biobank_aliquot" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:12 Duration: 0ms
11 3 7.11 MiB 2.28 MiB 2.53 MiB 2.37 MiB create index if not exists "a2425f9bd0f94d0dd8611e1a4ebb0866" on "dwh_celspac".src_data_extractor_madmax."madmax" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.madmax"} */ create index if not exists "a2425f9bd0f94d0dd8611e1a4ebb0866" on "dwh_celspac".src_data_extractor_madmax."madmax" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:14:08 Duration: 117ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.madmax"} */ create index if not exists "a2425f9bd0f94d0dd8611e1a4ebb0866" on "dwh_celspac".src_data_extractor_madmax."madmax" using btree (_airbyte_emitted_at);
Date: 2025-12-07 23:14:08 Duration: 0ms
12 3 2.18 MiB 400.00 KiB 1.14 MiB 744.00 KiB create index if not exists "a391fc3b0560e48fb1b32d3862ffc6f0" on "dwh_bims".src_las."biobank_sample" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_sample"} */ create index if not exists "a391fc3b0560e48fb1b32d3862ffc6f0" on "dwh_bims".src_las."biobank_sample" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:17 Duration: 97ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_sample"} */ create index if not exists "a391fc3b0560e48fb1b32d3862ffc6f0" on "dwh_bims".src_las."biobank_sample" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:17 Duration: 0ms
13 2 1.10 GiB 103.99 MiB 1.00 GiB 564.00 MiB refresh materialized view src_cladeis_public_seisnsitive.all_cladeis_answers with data;-
REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;
Date: 2025-12-07 23:36:53 Duration: 1m9s
-
REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;
Date: 2025-12-07 23:36:53 Duration: 0ms
14 2 2.55 MiB 880.00 KiB 1.70 MiB 1.28 MiB create index if not exists "ec9b222222171659254536a949322a72" on "dwh_bims".src_las."biobank_sample_sampletubes" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_sample_sampletubes"} */ create index if not exists "ec9b222222171659254536a949322a72" on "dwh_bims".src_las."biobank_sample_sampletubes" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:12 Duration: 188ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_sample_sampletubes"} */ create index if not exists "ec9b222222171659254536a949322a72" on "dwh_bims".src_las."biobank_sample_sampletubes" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:12 Duration: 0ms
15 2 16.38 MiB 8.19 MiB 8.19 MiB 8.19 MiB select classid, objid, refclassid, refobjid, deptype from pg_depend where deptype != ? and deptype != ? union all select ?::regclass as classid, amopfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amop o where deptype not in (...) and classid = ?::regclass and objid = o.oid and not (refclassid = ?::regclass and amopfamily = refobjid) union all select ?::regclass as classid, amprocfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amproc p where deptype not in (...) and classid = ?::regclass and objid = p.oid and not (refclassid = ?::regclass and amprocfamily = refobjid) order by ?, ?;-
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-12-07 03:17:14 Duration: 356ms
-
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-12-07 03:38:09 Duration: 305ms
-
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-12-07 04:01:43 Duration: 109ms
16 2 1.64 MiB 560.00 KiB 1.09 MiB 840.00 KiB create index if not exists "9f7cb7ddf5359015f99d89f6a37d9f69" on "dwh_bims".src_las."biobank_vk" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_vk"} */ create index if not exists "9f7cb7ddf5359015f99d89f6a37d9f69" on "dwh_bims".src_las."biobank_vk" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:14 Duration: 114ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_vk"} */ create index if not exists "9f7cb7ddf5359015f99d89f6a37d9f69" on "dwh_bims".src_las."biobank_vk" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:14 Duration: 0ms
17 2 1.27 MiB 304.00 KiB 1000.00 KiB 652.00 KiB create index if not exists "6116d5f4807700258f342602f1400aa1" on "dwh_bims".src_las."tmp_sjednoceni_komentaru_studie_co_rt" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.tmp_sjednoceni_komentaru_studie_co_rt"} */ create index if not exists "6116d5f4807700258f342602f1400aa1" on "dwh_bims".src_las."tmp_sjednoceni_komentaru_studie_co_rt" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:16 Duration: 62ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.tmp_sjednoceni_komentaru_studie_co_rt"} */ create index if not exists "6116d5f4807700258f342602f1400aa1" on "dwh_bims".src_las."tmp_sjednoceni_komentaru_studie_co_rt" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:16 Duration: 0ms
18 2 1.57 MiB 256.00 KiB 1.32 MiB 804.00 KiB create index if not exists "83b6556898cc08ca37027f069af5e51e" on "dwh_bims".src_las."tmp_celspac_sample_import" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.tmp_celspac_sample_import"} */ create index if not exists "83b6556898cc08ca37027f069af5e51e" on "dwh_bims".src_las."tmp_celspac_sample_import" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:16 Duration: 52ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.tmp_celspac_sample_import"} */ create index if not exists "83b6556898cc08ca37027f069af5e51e" on "dwh_bims".src_las."tmp_celspac_sample_import" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:16 Duration: 0ms
19 2 704.00 KiB 8.00 KiB 696.00 KiB 352.00 KiB create index if not exists "412cfe3ccb4cdd5584b4292df6b6f809" on "dwh_celspac".src_bims_las."map_cls_id_barcode_removed_aliquots" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.map_cls_id_barcode_removed_aliquots"} */ create index if not exists "412cfe3ccb4cdd5584b4292df6b6f809" on "dwh_celspac".src_bims_las."map_cls_id_barcode_removed_aliquots" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:21:44 Duration: 48ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.map_cls_id_barcode_removed_aliquots"} */ create index if not exists "412cfe3ccb4cdd5584b4292df6b6f809" on "dwh_celspac".src_bims_las."map_cls_id_barcode_removed_aliquots" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:21:44 Duration: 0ms
20 2 432.00 KiB 8.00 KiB 424.00 KiB 216.00 KiB create index if not exists "b12d30e2f07e9f11f691cfe2eaf464f3" on "dwh_bims".src_las."django_session" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.django_session"} */ create index if not exists "b12d30e2f07e9f11f691cfe2eaf464f3" on "dwh_bims".src_las."django_session" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:15 Duration: 47ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.django_session"} */ create index if not exists "b12d30e2f07e9f11f691cfe2eaf464f3" on "dwh_bims".src_las."django_session" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:15 Duration: 0ms
21 2 1.46 MiB 8.00 KiB 1.45 MiB 748.00 KiB create index if not exists "8ba266a42ae70a3f409001bec501d5d5" on "dwh_bims".src_las."tmp_celspac_recieved_sample" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.tmp_celspac_recieved_sample"} */ create index if not exists "8ba266a42ae70a3f409001bec501d5d5" on "dwh_bims".src_las."tmp_celspac_recieved_sample" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:15 Duration: 99ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.tmp_celspac_recieved_sample"} */ create index if not exists "8ba266a42ae70a3f409001bec501d5d5" on "dwh_bims".src_las."tmp_celspac_recieved_sample" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:15 Duration: 0ms
22 2 2.55 MiB 1.02 MiB 1.53 MiB 1.28 MiB create index if not exists "cd9a96f5efc07a4cc231ca9e74eaa7f6" on "dwh_bims".src_las."biobank_sampletube" using btree (_airbyte_emitted_at);-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_sampletube"} */ create index if not exists "cd9a96f5efc07a4cc231ca9e74eaa7f6" on "dwh_bims".src_las."biobank_sampletube" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:14 Duration: 393ms
-
/* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_sampletube"} */ create index if not exists "cd9a96f5efc07a4cc231ca9e74eaa7f6" on "dwh_bims".src_las."biobank_sampletube" using btree (_airbyte_emitted_at);
Date: 2025-12-07 22:12:14 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 1.00 GiB REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;[ Date: 2025-12-07 23:36:53 ]
2 103.99 MiB REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;[ Date: 2025-12-07 23:36:53 ]
3 64.45 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:09:04 ]
4 64.45 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:21:43 ]
5 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:33:53 ]
6 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:38:59 ]
7 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:43:52 ]
8 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:53:52 ]
9 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:58:53 ]
10 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 23:03:53 ]
11 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 23:09:08 ]
12 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 23:14:06 ]
13 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 23:18:50 ]
14 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 23:24:05 ]
15 64.44 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 23:28:55 ]
16 38.77 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.biobank_logaliquot"} */ create index if not exists "d47b351e4303f825a18fc305e3e516b5" on "dwh_bims".src_las."biobank_logaliquot" using btree (_airbyte_emitted_at);[ Date: 2025-12-07 22:12:28 ]
17 36.38 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:09:04 ]
18 36.38 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:21:43 ]
19 36.37 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:33:53 ]
20 36.37 MiB /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "master"} */ with relation as ( select pg_rewrite.ev_class as class, pg_rewrite.oid as id from pg_rewrite ), class as ( select oid as id, relname as name, relnamespace as schema, relkind as kind from pg_class ), dependency as ( select pg_depend.objid as id, pg_depend.refobjid as ref from pg_depend ), schema as ( select pg_namespace.oid as id, pg_namespace.nspname as name from pg_namespace where nspname != 'information_schema' and nspname not like 'pg\_%' ), referenced as ( select relation.id AS id, referenced_class.name, referenced_class.schema, referenced_class.kind from relation join class as referenced_class on relation.class = referenced_class.id where referenced_class.kind in ('r', 'v') ), relationships as ( select referenced.name as referenced_name, referenced.schema as referenced_schema_id, dependent_class.name as dependent_name, dependent_class.schema as dependent_schema_id, referenced.kind as kind from referenced join dependency on referenced.id = dependency.id join class as dependent_class on dependency.ref = dependent_class.id where (referenced.name != dependent_class.name or referenced.schema != dependent_class.schema)) select referenced_schema.name as referenced_schema, relationships.referenced_name as referenced_name, dependent_schema.name as dependent_schema, relationships.dependent_name as dependent_name from relationships join schema as dependent_schema on relationships.dependent_schema_id = dependent_schema.id join schema as referenced_schema on relationships.referenced_schema_id = referenced_schema.id group by referenced_schema, referenced_name, dependent_schema, dependent_name order by referenced_schema, referenced_name, dependent_schema, dependent_name;[ Date: 2025-12-07 22:38:59 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.35 sec Highest CPU-cost vacuum
Table pg_toast.pg_toast_2619
Database dwh_bims - 2025-12-07 22:14:34 Date
- 0.09 sec Highest CPU-cost analyze
Table src_air_sensor.data
Database dwh_bims - 2025-12-07 05:31:18 Date
Average Autovacuum Duration
Key values
- 1.35 sec Highest CPU-cost vacuum
Table pg_toast.pg_toast_2619
Database dwh_bims - 2025-12-07 22:14:34 Date
Analyzes per table
Key values
- src_las._airbyte_raw_biobank_logaliquot (2) Main table analyzed (database dwh_bims)
- 475 analyzes Total
Table Number of analyzes dwh_bims.src_las._airbyte_raw_biobank_logaliquot 2 dwh_bims.pg_catalog.pg_class 2 dwh_celspac.src_bims_las._airbyte_raw_map_cls_id_barcode_all_aliquots 2 dwh_inqint.src_air_sensor._airbyte_raw_data 2 dwh_bims.src_las.biobank_logcontainer 1 dwh_bims.src_las.biobank_allowedcontent_sampletype 1 dwh_inqint.src_sampling_record_sheet.products 1 dwh_bims.src_las.biobank_allowedcontent_tubetype 1 dwh_bims.src_las.biobank_sampletube 1 dwh_inqint.src_geospatial.pesticide_bifenthrin 1 dwh_bims.src_las.biobank_robotrunreport 1 dwh_inqint.src_geospatial._airbyte_raw_air_quality 1 dwh_bims.src_las.biobank_vs 1 dwh_inqint.src_geospatial.volcano 1 dwh_celspac.src_bims_las._airbyte_raw_map_cls_id_barcode_removed_aliquots 1 dwh_bims.src_las._airbyte_raw_biobank_allowedcontent_sampletype 1 dwh_inqint.src_geospatial.industry_facility_buffer_50 1 dwh_inqint.src_geospatial.clc_forest_buffer_250 1 dwh_bims.src_las.biobank_mm 1 dwh_inqint.src_air_sensor.data 1 dwh_bims.src_las._airbyte_raw_biobank_timestamptype 1 dwh_bims.src_las._airbyte_raw_biobank_containertypestructure 1 dwh_inqint.src_geospatial._airbyte_raw_pesticide_bifenthrin 1 dwh_inqint.src_geospatial.population 1 dwh_celspac.src_data_extractor_spiro._airbyte_raw_fvc_results 1 dwh_inqint.src_geospatial.aq_station 1 dwh_inqint.src_geospatial.precipitation_year_2019 1 dwh_celspac.src_celspac_admin_core.form 1 dwh_bims.src_las.auth_permission 1 dwh_bims.src_las.biobank_logaliquot 1 dwh_celspac.src_data_extractor_dexa.fracture_risk 1 dwh_inqint.src_geospatial.cd_buffer_1000 1 dwh_bims.src_las.biobank_studydescription 1 dwh_celspac.src_cladeis_public.cls_form_study_phase 1 dwh_bims.src_las._airbyte_raw_biobank_aliquot 1 dwh_celspac.src_data_collector_public._airbyte_raw_project_document_type 1 dwh_inqint.src_geospatial.cd_buffer_50 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_integra 1 dwh_celspac.src_data_collector_public.import_batch_e411 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_old_dexa_table_to_2024_05_16 1 dwh_inqint.src_geospatial._airbyte_raw_crops_area 1 dwh_bims.src_las.biobank_autocompletiondatahelper 1 dwh_inqint.src_sampling_record_sheet._airbyte_raw_svoc_samplers 1 dwh_bims.src_las.biobank_wg_user 1 dwh_inqint.src_geospatial.industry_cd_buffer_1000 1 dwh_celspac.src_cladeis_public.cls_question_validation_condition 1 dwh_celspac.src_data_collector_public.import_batch_dexa 1 dwh_inqint.src_geospatial.cd_buffer_5000 1 dwh_inqint.src_geospatial.clc_forest_buffer_1000 1 dwh_inqint.src_geospatial.pesticide_chlorpyrifos_methyl 1 dwh_bims.src_las._airbyte_raw_auth_permission 1 dwh_bims.src_las._airbyte_raw_monitorovanie_marek_tabulka 1 dwh_bims.src_las.biobank_container 1 dwh_inqint.src_geospatial._airbyte_raw_osm_buffer_500 1 dwh_inqint.src_geospatial._airbyte_raw_osm_buffer_250 1 dwh_bims.src_las._airbyte_raw_biobank_logcontainer 1 dwh_bims.src_las._airbyte_raw_biobank_allowedcontent_aliquotcontent 1 dwh_bims.src_las.biobank_allowedcontent 1 dwh_bims.src_las._airbyte_raw_biobank_autocompletiondatahelper 1 dwh_inqint.src_weekly_logsheet._airbyte_raw_meta 1 dwh_celspac.src_cladeis_public.cls_form_subject 1 dwh_inqint.src_geospatial.clc_forest_buffer_30000 1 dwh_inqint.src_geospatial._airbyte_raw_industry_cd_buffer_1000 1 dwh_celspac.src_data_collector_public.project_document_type 1 dwh_celspac.src_data_extractor_madmax._airbyte_raw_madmax 1 dwh_inqint.src_geospatial._airbyte_raw_clc_all_buffer_500 1 dwh_celspac.src_data_extractor_sysmex.sysmex_main 1 dwh_inqint.src_geospatial._airbyte_raw_industry_facility_buffer_2000 1 dwh_inqint.src_home_questionnaire.outdoor 1 dwh_inqint.src_geospatial.industry_as_buffer_100 1 dwh_bims.src_las._airbyte_raw_biobank_allowedcontent_timestamptype 1 dwh_celspac.src_data_extractor_spiro_blue_cherry.spiro_blue_cherry_dat 1 dwh_celspac.src_data_extractor_hba._airbyte_raw_hba_roche_metadata 1 dwh_bims.src_las._airbyte_raw_biobank_researchsubstudy 1 dwh_inqint.src_geospatial._airbyte_raw_osm_buffer_2000 1 dwh_inqint.src_home_questionnaire._airbyte_raw_dwelling 1 dwh_celspac.src_data_extractor_footarch.statistical_parameter 1 dwh_inqint.src_geospatial._airbyte_raw_crops_percentage 1 dwh_inqint.src_geospatial.as_buffer_50 1 dwh_bims.src_las._airbyte_raw_biobank_ts 1 dwh_celspac.src_cladeis_public.cls_discrete_value 1 dwh_inqint.src_geospatial.precipitation_year_2016 1 dwh_celspac.src_data_extractor_hba.hba_roche_import 1 dwh_inqint.src_weekly_logsheet_cleaning_detail._airbyte_raw_vacuum_cleaner 1 dwh_bims.src_las._airbyte_raw_biobank_sample 1 dwh_celspac.src_data_collector_public._airbyte_raw_project 1 dwh_inqint.src_geospatial._airbyte_raw_as_buffer_500 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_fracture_risk 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2018 1 dwh_inqint.src_inqint_core.import_batch 1 dwh_bims.src_las._airbyte_raw_biobank_sampletube 1 dwh_bims.src_las._airbyte_raw_biobank_ds 1 dwh_celspac.src_data_extractor_dexa.decision_output 1 dwh_celspac.src_cladeis_public_seisnsitive.cls_answer 1 dwh_celspac.src_cladeis_public.trans_dictionary 1 dwh_inqint.src_geospatial.precipitation_year_2021 1 dwh_bims.src_las.auth_user 1 dwh_celspac.src_data_extractor_dexa.summary_report 1 dwh_inqint.src_geospatial._airbyte_raw_industry_as_buffer_500 1 dwh_bims.src_las._airbyte_raw_biobank_vk 1 dwh_bims.src_las._airbyte_raw_biobank_robotrunreport 1 dwh_bims.src_las.django_session 1 dwh_inqint.src_weekly_logsheet._airbyte_raw_weekly_activities_description 1 dwh_bims.src_las._airbyte_raw_auth_user 1 dwh_bims.src_las.biobank_timestamptype 1 dwh_inqint.src_geospatial._airbyte_raw_industry_as_buffer_2000 1 dwh_bims.src_las.biobank_samplesourcetype 1 dwh_inqint.src_sampling_record_sheet._airbyte_raw_products 1 dwh_bims.pg_catalog.pg_attribute 1 dwh_bims.src_las._airbyte_raw_django_session 1 dwh_inqint.src_air_sensor.metatable 1 dwh_bims.src_las.biobank_sampletype 1 dwh_bims.src_las._airbyte_raw_biobank_tubecontent 1 dwh_inqint.src_weekly_logsheet_cleaning_detail._airbyte_raw_weekly_logsheet 1 dwh_inqint.src_geospatial.industry_facility_buffer_500 1 dwh_celspac.src_cladeis_public.cls_remote_data_query 1 dwh_inqint.src_weekly_logsheet_cleaning_detail.weekly_activities_description 1 dwh_bims.src_las._airbyte_raw_tmp_celspac_recieved_sample 1 dwh_inqint.src_geospatial._airbyte_raw_volcano 1 dwh_bims.src_las._airbyte_raw_auth_user_user_permissions 1 dwh_celspac.src_data_extractor_dexa.hl_7 1 dwh_celspac.src_celspac_admin_core.subcohort_inform_consent 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_report_parameters 1 dwh_inqint.src_geospatial.industry_as_buffer_1000 1 dwh_inqint.src_geospatial._airbyte_raw_cd_buffer_250 1 dwh_celspac.src_data_extractor_inbody.inbody 1 dwh_inqint.src_geospatial._airbyte_raw_osm_buffer_5000 1 dwh_bims.src_las.biobank_ds 1 dwh_bims.src_las._airbyte_raw_biobank_containertype_childs 1 dwh_inqint.src_geospatial.industry_as_buffer_500 1 dwh_bims.src_las._airbyte_raw_biobank_messagetype 1 dwh_celspac.src_cladeis_public.cls_question_group 1 dwh_inqint.src_geospatial._airbyte_raw_pesticide_glyphosate 1 dwh_celspac.src_data_extractor_integra.integra_main 1 dwh_inqint.src_geospatial._airbyte_raw_as_buffer_100 1 dwh_celspac.src_data_extractor_public._airbyte_raw_source 1 dwh_celspac.src_cladeis_public_seisnsitive.all_cladeis_answers 1 dwh_bims.src_las._airbyte_raw_biobank_movedcontainer 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_500 1 dwh_celspac.src_data_extractor_dexa.cover_letter 1 dwh_inqint.src_geospatial.precipitation_year_2018 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2016 1 dwh_inqint.src_geospatial._airbyte_raw_wind 1 dwh_celspac.src_data_extractor_e411._airbyte_raw_e411_main 1 dwh_bims.src_las.tmp_celspac_sample_import 1 dwh_celspac.src_data_extractor_dexa.report_parameters 1 dwh_inqint.src_weekly_logsheet_cleaning_detail._airbyte_raw_meta 1 dwh_inqint.src_geospatial._airbyte_raw_industry_cd_buffer_50 1 dwh_inqint.src_geospatial.clc_all_buffer_100 1 dwh_celspac.src_cladeis_public.acl_user 1 dwh_bims.src_las.biobank_bs 1 dwh_inqint.src_weekly_logsheet_cleaning_detail.weekly_logsheet 1 dwh_inqint.src_geospatial.precipitation_year_2020 1 dwh_bims.src_las._airbyte_raw_biobank_mm 1 dwh_inqint.src_sampling_record_sheet.voc_samplers 1 dwh_celspac.src_cladeis_public.cls_question_datatype 1 dwh_bims.src_las._airbyte_raw_biobank_researchstudy 1 dwh_inqint.src_geospatial.as_buffer_1000 1 dwh_bims.src_las._airbyte_raw_biobank_wg_user 1 dwh_celspac.src_data_extractor_public.document_context 1 dwh_inqint.src_sampling_record_sheet._airbyte_raw_urine_samples 1 dwh_inqint.src_sampling_record_sheet.urine_samples 1 dwh_inqint.src_geospatial.cd_buffer_100 1 dwh_celspac.src_data_extractor_hba.hba_roche_metadata 1 dwh_celspac.src_data_extractor_spiro.fvc_results 1 dwh_celspac.src_celspac_admin_core.cohort 1 dwh_celspac.src_celspac_admin_core.subject 1 dwh_inqint.src_geospatial._airbyte_raw_clc_agriculture 1 dwh_bims.src_las._airbyte_raw_biobank_generatedbarcodes 1 dwh_inqint.src_geospatial.industry_as_buffer_250 1 dwh_inqint.src_weekly_logsheet.meta 1 dwh_celspac.src_data_extractor_sysmex.sysmex_values 1 dwh_celspac.src_data_extractor_public._airbyte_raw_document_context 1 dwh_inqint.src_geospatial.pfas 1 dwh_bims.src_las.auth_user_user_permissions 1 dwh_inqint.src_home_questionnaire.dwelling 1 dwh_inqint.src_geospatial._airbyte_raw_aq_station 1 dwh_bims.src_las.biobank_sample 1 dwh_inqint.src_public.document_context 1 dwh_celspac.src_data_extractor_spiro_blue_cherry.spiro_blue_cherry_csv 1 dwh_inqint.src_sampling_record_sheet.svoc_samplers 1 dwh_inqint.src_geospatial.precipitation_year_2017 1 dwh_bims.src_las.biobank_messagetype 1 dwh_celspac.src_celspac_admin_public_sensitive.acl_user 1 dwh_bims.src_las._airbyte_raw_biobank_tubecontent_content 1 dwh_celspac.src_data_extractor_e411._airbyte_raw_e411_values 1 dwh_celspac.src_data_extractor_sysmex._airbyte_raw_sysmex_values 1 dwh_celspac.src_data_extractor_spiro.fvc_best_attempts 1 dwh_inqint.src_home_questionnaire.room 1 dwh_bims.src_las._airbyte_raw_biobank_hospital 1 dwh_inqint.src_geospatial.crops_percentage 1 dwh_inqint.src_weekly_logsheet.weekly_logsheet 1 dwh_inqint.src_geospatial._airbyte_raw_industry_as_buffer_5000 1 dwh_inqint.src_air_sensor._airbyte_raw_metatable 1 dwh_inqint.src_geospatial.clc_all_buffer_500 1 dwh_bims.src_las._airbyte_raw_biobank_aliquotcontent 1 dwh_celspac.src_data_collector_public.document_type 1 dwh_inqint.src_geospatial.clc_agriculture 1 dwh_inqint.src_geospatial._airbyte_raw_industry_as_buffer_100 1 dwh_inqint.src_geospatial._airbyte_raw_as_buffer_2000 1 dwh_bims.src_las._airbyte_raw_biobank_sample_sampletubes 1 dwh_inqint.src_geospatial._airbyte_raw_pesticide_cypermethrin 1 dwh_bims.src_las._airbyte_raw_biobank_sampletype_samplesources 1 dwh_inqint.src_weekly_logsheet.weekly_activities_description 1 dwh_inqint.src_geospatial.osm_buffer_50 1 dwh_inqint.src_geospatial.cd_buffer_250 1 dwh_celspac.src_data_extractor_dexa.adipose_indices 1 dwh_inqint.src_geospatial.industry_cd_buffer_5000 1 dwh_celspac.src_data_collector_public.import_batch_spiro 1 dwh_inqint.src_weekly_logsheet_cleaning_detail._airbyte_raw_weekly_activities_description 1 dwh_inqint.src_geospatial.pesticide_chlorpyrifos 1 dwh_celspac.src_data_collector_public._airbyte_raw_document 1 dwh_bims.src_las.biobank_selectionrule 1 dwh_inqint.src_geospatial.pesticide_tau_fluvalinate 1 dwh_inqint.src_geospatial._airbyte_raw_industry_cd_buffer_500 1 dwh_inqint.src_geospatial._airbyte_raw_industry_cd_buffer_250 1 dwh_inqint.src_geospatial._airbyte_raw_pesticide_chlorpyrifos 1 dwh_bims.src_las.biobank_researchsubstudy 1 dwh_celspac.src_cladeis_public.cls_discrete_value_group 1 dwh_inqint.src_geospatial._airbyte_raw_as_buffer_50 1 dwh_bims.src_las._airbyte_raw_biobank_studydescription 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2022 1 dwh_inqint.src_geospatial._airbyte_raw_pesticide_tau_fluvalinate 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2015 1 dwh_inqint.src_geospatial.industry_facility_buffer_1000 1 dwh_inqint.src_geospatial._airbyte_raw_industry_as_buffer_1000 1 dwh_bims.src_las._airbyte_raw_las_auth_session 1 dwh_celspac.src_bims_las.map_cls_id_barcode_all_aliquots 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_feetarch 1 dwh_inqint.src_geospatial._airbyte_raw_industry_as_buffer_50 1 dwh_celspac.src_data_collector_public.import_batch_covid 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch 1 dwh_bims.src_las._airbyte_raw_tmp_sjednoceni_komentaru_studie_co_rt 1 dwh_celspac.src_data_collector_public.import_batch_feetarch 1 dwh_inqint.src_geospatial.as_buffer_250 1 dwh_inqint.src_geospatial.clc_forest_buffer_5000 1 dwh_inqint.src_geospatial.clc_forest_buffer_50 1 dwh_inqint.src_sampling_record_sheet.dust_home_visit 1 dwh_bims.src_las.biobank_aliquot 1 dwh_inqint.src_home_questionnaire._airbyte_raw_room 1 dwh_celspac.src_celspac_admin_core.subcohort_form_structure_variant 1 dwh_bims.src_las.biobank_allowedcontent_aliquotcontent 1 dwh_bims.src_las._airbyte_raw_biobank_allowedcontent_samplesource 1 dwh_inqint.src_inqint_core.document 1 dwh_inqint.src_geospatial._airbyte_raw_population 1 dwh_bims.src_las._airbyte_raw_biobank_allowedcontent_researchstudy 1 dwh_inqint.src_geospatial._airbyte_raw_as_buffer_250 1 dwh_inqint.src_geospatial._airbyte_raw_industry_facility_buffer_5000 1 dwh_bims.src_las.biobank_pk 1 dwh_bims.src_las._airbyte_raw_biobank_container 1 dwh_bims.src_las.biobank_tubecontent_content 1 dwh_bims.src_las._airbyte_raw_biobank_containertype 1 dwh_inqint.src_geospatial.industry_facility_buffer_2000 1 dwh_celspac.src_data_collector_public.import_batch_integra 1 dwh_bims.src_las._airbyte_raw_biobank_sampletype_timestamptypes 1 dwh_inqint.src_sampling_record_sheet._airbyte_raw_dust_home_visit 1 dwh_celspac.src_cladeis_public.cls_form_structure 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_sysmex 1 dwh_inqint.src_sampling_record_sheet_extra_room._airbyte_raw_weekly_logsheet 1 dwh_inqint.pg_catalog.pg_namespace 1 dwh_bims.src_las.django_migrations 1 dwh_inqint.src_geospatial._airbyte_raw_pfas 1 dwh_inqint.pg_catalog.pg_class 1 dwh_inqint.src_geospatial.crops_area 1 dwh_celspac.src_cladeis_hist2.public_cls_form_study_phase 1 dwh_inqint.src_geospatial.as_buffer_2000 1 dwh_celspac.src_data_extractor_e411.e411_main 1 dwh_inqint.src_geospatial.osm_buffer_250 1 dwh_bims.pg_catalog.pg_index 1 dwh_inqint.src_inqint_core._airbyte_raw_document 1 dwh_inqint.src_weekly_logsheet._airbyte_raw_weekly_logsheet 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_lean_mass_indices 1 dwh_bims.src_las.biobank_logsample 1 dwh_celspac.src_data_extractor_e411.e411_values 1 dwh_inqint.src_public._airbyte_raw_document_context 1 dwh_celspac.src_cladeis_public.cls_question_group_question 1 dwh_inqint.pg_catalog.pg_index 1 dwh_inqint.src_weekly_logsheet_cleaning_detail.vacuum_cleaner 1 dwh_inqint.src_geospatial.industry_cd_buffer_50 1 dwh_inqint.src_geospatial._airbyte_raw_industry_facility_buffer_1000 1 dwh_bims.src_las._airbyte_raw_biobank_allowedcontent 1 dwh_celspac.src_cis_enum_public.mkn10_20140401_cz 1 dwh_inqint.src_geospatial._airbyte_raw_clc_all_buffer_1000 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_cover_letter 1 dwh_bims.src_las._airbyte_raw_biobank_pk 1 dwh_inqint.src_sampling_record_sheet._airbyte_raw_aq_sensor 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_spiro 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2021 1 dwh_inqint.src_geospatial.airport 1 dwh_inqint.src_weekly_logsheet_cleaning_detail.meta 1 dwh_celspac.src_data_extractor_dexa.hsa 1 dwh_celspac.src_celspac_admin_core_sensitive.subject 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_hl_7 1 dwh_inqint.src_geospatial.clc_forest_buffer_500 1 dwh_bims.src_las._airbyte_raw_biobank_logsample 1 dwh_inqint.src_geospatial.precipitation_year_2015 1 dwh_inqint.src_geospatial._airbyte_raw_industry_cd_buffer_5000 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_2000 1 dwh_bims.pg_catalog.pg_depend 1 dwh_bims.src_las._airbyte_raw_tmp_celspac_sample_import 1 dwh_celspac.src_data_extractor_spiro_blue_cherry._airbyte_raw_spiro_blue_cherry_csv 1 dwh_inqint.src_geospatial.clc_forest_buffer_2000 1 dwh_inqint.src_geospatial._airbyte_raw_osm_buffer_1000 1 dwh_inqint.src_geospatial._airbyte_raw_clc_all_buffer_100 1 dwh_celspac.src_data_collector_public._airbyte_raw_document_type 1 dwh_bims.src_las.biobank_containertype 1 dwh_inqint.src_geospatial._airbyte_raw_cd_buffer_50 1 dwh_inqint.src_geospatial.cd_buffer_500 1 dwh_inqint.src_sampling_record_sheet.aq_sensor 1 dwh_celspac.src_celspac_admin_core.form_structure 1 dwh_inqint.src_geospatial.pesticide_deltamethrin 1 dwh_inqint.src_geospatial.hv_index_elevation 1 dwh_inqint.src_geospatial.industry_as_buffer_5000 1 dwh_celspac.src_data_collector_public.project 1 dwh_inqint.src_geospatial._airbyte_raw_airport 1 dwh_bims.src_las.las_auth_session 1 dwh_bims.src_las.monitorovanie_marek_tabulka 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_bca_results 1 dwh_inqint.src_geospatial._airbyte_raw_osm_buffer_100 1 dwh_celspac.src_cladeis_public.cls_question 1 dwh_bims.src_las.biobank_sampletype_timestamptypes 1 dwh_inqint.src_sampling_record_sheet_extra_room.weekly_logsheet 1 dwh_inqint.src_geospatial._airbyte_raw_industry_cd_buffer_2000 1 dwh_inqint.src_geospatial._airbyte_raw_as_buffer_1000 1 dwh_bims.src_las.biobank_sk 1 dwh_bims.src_las._airbyte_raw_biobank_vs 1 dwh_celspac.src_data_extractor_inbody._airbyte_raw_inbody 1 dwh_celspac.src_data_collector_public.import_batch 1 dwh_inqint.src_sampling_record_sheet_extra_room._airbyte_raw_weekly_activities_description 1 dwh_inqint.src_geospatial.clc_all_buffer_1000 1 dwh_inqint.src_geospatial.industry_cd_buffer_2000 1 dwh_inqint.src_geospatial._airbyte_raw_industry_as_buffer_250 1 dwh_inqint.src_geospatial._airbyte_raw_industry_facility_buffer_50 1 dwh_celspac.src_data_extractor_footarch._airbyte_raw_statistical_parameter 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_e411 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2020 1 dwh_inqint.src_inqint_core._airbyte_raw_document_import_batch 1 dwh_bims.src_las._airbyte_raw_biobank_tubetype 1 dwh_inqint.src_geospatial.as_buffer_100 1 dwh_bims.src_las.biobank_removedaliquotsplan_aliquots 1 dwh_inqint.src_geospatial._airbyte_raw_hv_index_elevation 1 dwh_celspac.src_cis_enum_public.mkn10_20201103_cz 1 dwh_inqint.src_geospatial.industry_as_buffer_2000 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_hsa 1 dwh_celspac.src_data_collector_public.import_batch_inbody 1 dwh_bims.src_las.biobank_tubetype 1 dwh_inqint.src_geospatial.wind 1 dwh_celspac.src_data_collector_public.import_batch_sysmex 1 dwh_inqint.src_geospatial.industry_facility_buffer_5000 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_100 1 dwh_celspac.src_celspac_admin_core.subject_inform_consent 1 dwh_bims.src_las._airbyte_raw_biobank_sampletubecomment 1 dwh_inqint.src_geospatial.industry_cd_buffer_500 1 dwh_bims.src_las.biobank_movedcontainer 1 dwh_inqint.src_geospatial._airbyte_raw_cd_buffer_1000 1 dwh_inqint.src_geospatial._airbyte_raw_industry_facility_buffer_250 1 dwh_inqint.src_geospatial.osm_buffer_2000 1 dwh_inqint.src_geospatial.osm_buffer_1000 1 dwh_celspac.src_cladeis_public.cls_answer 1 dwh_inqint.src_geospatial.industry_cd_buffer_250 1 dwh_inqint.src_geospatial.as_buffer_500 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2019 1 dwh_bims.src_las._airbyte_raw_biobank_bs 1 dwh_bims.src_las.biobank_allowedcontent_timestamptype 1 dwh_bims.src_las._airbyte_raw_biobank_removedaliquotsplan 1 dwh_inqint.src_geospatial._airbyte_raw_osm_buffer_50 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_30000 1 dwh_bims.src_las.biobank_generatedbarcodes 1 dwh_inqint.src_geospatial._airbyte_raw_industry_cd_buffer_100 1 dwh_bims.src_las._airbyte_raw_django_migrations 1 dwh_celspac.src_cladeis_public.cls_form 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_inbody 1 dwh_celspac.src_data_extractor_dexa.bca_results 1 dwh_bims.src_las.django_content_type 1 dwh_inqint.src_geospatial.osm_buffer_100 1 dwh_inqint.src_geospatial.clc_all_buffer_200 1 dwh_bims.src_las.biobank_st 1 dwh_inqint.src_geospatial.air_quality 1 dwh_celspac.src_celspac_admin_core.form_structure_version 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_250 1 dwh_bims.src_las._airbyte_raw_biobank_sk 1 dwh_inqint.src_geospatial.industry_facility_buffer_100 1 dwh_bims.pg_catalog.pg_type 1 dwh_bims.src_las.biobank_researchstudy 1 dwh_celspac.src_data_extractor_footarch.patient_info 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_decision_output 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_adipose_indices 1 dwh_celspac.src_data_extractor_dexa.pedi_parameters 1 dwh_bims.src_las._airbyte_raw_biobank_removedaliquotsplan_aliquots 1 dwh_bims.src_las.biobank_containertypestructure 1 dwh_celspac.src_data_extractor_dexa.lean_mass_indices 1 dwh_celspac.src_data_extractor_spiro._airbyte_raw_fvc_best_attempts 1 dwh_inqint.src_geospatial._airbyte_raw_pesticide_deltamethrin 1 dwh_inqint.src_geospatial._airbyte_raw_industry_facility_buffer_100 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_dexa 1 dwh_inqint.pg_catalog.pg_attribute 1 dwh_inqint.src_sampling_record_sheet_extra_room._airbyte_raw_meta 1 dwh_inqint.src_geospatial._airbyte_raw_as_buffer_5000 1 dwh_bims.src_las.biobank_allowedcontent_samplesource 1 dwh_inqint.src_geospatial.industry_facility_buffer_250 1 dwh_inqint.src_geospatial.precipitation_year_2022 1 dwh_inqint.pg_catalog.pg_type 1 dwh_celspac.src_celspac_admin_core.inform_consent 1 dwh_bims.src_las._airbyte_raw_biobank_selectionrule 1 dwh_bims.src_las.biobank_allowedcontent_researchstudy 1 dwh_inqint.src_geospatial._airbyte_raw_clc_all_buffer_200 1 dwh_bims.src_las._airbyte_raw_biobank_sampletype 1 dwh_inqint.src_geospatial._airbyte_raw_cd_buffer_500 1 dwh_bims.src_las.biobank_cs 1 dwh_bims.src_las.biobank_sampletype_samplesources 1 dwh_inqint.src_geospatial.as_buffer_5000 1 dwh_bims.src_las._airbyte_raw_biobank_cs 1 dwh_inqint.src_geospatial.clc_forest_buffer_100 1 dwh_celspac.src_celspac_admin_core.subcohort 1 dwh_inqint.src_geospatial._airbyte_raw_cd_buffer_100 1 dwh_celspac.src_data_extractor_spiro._airbyte_raw_patient_data 1 dwh_celspac.src_data_collector_public._airbyte_raw_import_batch_covid 1 dwh_bims.src_las.biobank_sample_sampletubes 1 dwh_celspac.src_data_extractor_integra._airbyte_raw_integra_main 1 dwh_celspac.src_data_extractor_spiro.patient_data 1 dwh_bims.src_las.tmp_celspac_recieved_sample 1 dwh_bims.src_las.tmp_sjednoceni_komentaru_studie_co_rt 1 dwh_inqint.src_geospatial._airbyte_raw_cd_buffer_2000 1 dwh_bims.src_las.biobank_vk 1 dwh_inqint.src_geospatial.osm_buffer_500 1 dwh_inqint.src_geospatial.pesticide_cypermethrin 1 dwh_inqint.src_geospatial.osm_buffer_5000 1 dwh_inqint.src_inqint_core._airbyte_raw_import_batch 1 dwh_inqint.src_geospatial.pesticide_glyphosate 1 dwh_inqint.src_inqint_core.document_import_batch 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_50 1 dwh_bims.src_las._airbyte_raw_biobank_samplesourcetype 1 dwh_celspac.src_data_extractor_hba._airbyte_raw_hba_roche_import 1 dwh_inqint.src_geospatial.industry_cd_buffer_100 1 dwh_inqint.src_geospatial._airbyte_raw_precipitation_year_2017 1 dwh_celspac.src_cladeis_public.cls_question_skip_logic 1 dwh_inqint.src_geospatial._airbyte_raw_industry_facility_buffer_500 1 dwh_bims.src_las.biobank_tubecontent 1 dwh_celspac.src_celspac_admin_core.pilot 1 dwh_inqint.src_geospatial._airbyte_raw_pesticide_chlorpyrifos_methyl 1 dwh_celspac.src_data_collector_public.document 1 dwh_bims.src_las.biobank_containertype_childs 1 dwh_celspac.src_celspac_admin_core.form_structure_variant 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_summary_report 1 dwh_celspac.src_data_extractor_footarch._airbyte_raw_patient_info 1 dwh_bims.src_las._airbyte_raw_biobank_m 1 dwh_celspac.src_data_extractor_spiro_blue_cherry._airbyte_raw_spiro_blue_cherry_dat 1 dwh_celspac.src_data_extractor_sysmex._airbyte_raw_sysmex_main 1 dwh_bims.src_las.biobank_sampletubecomment 1 dwh_bims.src_las.biobank_aliquotcontent 1 dwh_inqint.src_sampling_record_sheet._airbyte_raw_voc_samplers 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_5000 1 dwh_bims.src_las._airbyte_raw_biobank_st 1 dwh_bims.src_las._airbyte_raw_biobank_sampletubepriority 1 dwh_inqint.src_geospatial.industry_as_buffer_50 1 dwh_celspac.src_cladeis_public.cls_question_group_form_structure 1 dwh_bims.src_las._airbyte_raw_django_content_type 1 dwh_bims.src_las._airbyte_raw_biobank_allowedcontent_tubetype 1 dwh_celspac_static_data.pg_catalog.pg_shdepend 1 dwh_bims.src_las.biobank_m 1 dwh_inqint.src_geospatial._airbyte_raw_cd_buffer_5000 1 dwh_celspac.src_data_extractor_madmax.madmax 1 dwh_inqint.src_home_questionnaire._airbyte_raw_outdoor 1 dwh_celspac.src_bims_las.map_cls_id_barcode_removed_aliquots 1 dwh_celspac.src_data_extractor_dexa.old_dexa_table_to_2024_05_16 1 dwh_bims.src_las.biobank_removedaliquotsplan 1 dwh_inqint.src_geospatial._airbyte_raw_clc_forest_buffer_1000 1 dwh_celspac.src_data_extractor_dexa._airbyte_raw_pedi_parameters 1 dwh_bims.src_las.biobank_sampletubepriority 1 dwh_inqint.src_geospatial.cd_buffer_2000 1 dwh_bims.src_las.biobank_ts 1 Total 475 Vacuums per table
Key values
- pg_catalog.pg_index (1) Main table vacuumed on database dwh_inqint
- 9 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples dwh_inqint.pg_catalog.pg_index 1 1 259 0 14 0 0 0 0 0 0 0 dwh_bims.pg_catalog.pg_class 1 1 746 0 107 0 238 0 0 0 0 0 dwh_bims.pg_catalog.pg_database 1 0 24 0 3 0 0 0 0 0 0 0 dwh_inqint.pg_toast.pg_toast_2619 1 1 1,350 0 156 0 0 0 0 0 0 0 dwh_inqint.pg_catalog.pg_namespace 1 0 27 0 3 0 0 0 0 0 0 0 dwh_bims.pg_catalog.pg_type 1 1 537 0 120 0 0 0 0 0 0 0 dwh_bims.pg_toast.pg_toast_2619 1 1 907 0 153 0 19 0 0 0 0 0 dwh_bims.pg_catalog.pg_depend 1 1 1,131 0 238 0 55 0 0 0 0 0 dwh_inqint.pg_catalog.pg_class 1 1 1,145 0 65 0 0 0 0 0 0 0 Total 9 7 6,126 1,792 859 0 312 0 0 0 0 0 Vacuum throughput per table
Key values
- pg_toast.pg_toast_2619 (1.35) Max CPU elapsed for vacuum on database dwh_bims
- unknown (0 ms) Max I/O read time for vacuum on database dwh_bims
- unknown (0 ms) Max I/O write time for vacuum on database dwh_bims
I/O timing (ms) CPU (s) Table read write elapsed dwh_inqint.pg_catalog.pg_index 0 0 0.1 dwh_bims.pg_catalog.pg_class 0 0 0.68 dwh_bims.pg_catalog.pg_database 0 0 0 dwh_inqint.pg_toast.pg_toast_2619 0 0 0.61 dwh_inqint.pg_catalog.pg_namespace 0 0 0 dwh_bims.pg_catalog.pg_type 0 0 0.54 dwh_bims.pg_toast.pg_toast_2619 0 0 1.35 dwh_bims.pg_catalog.pg_depend 0 0 1.23 dwh_inqint.pg_catalog.pg_class 0 0 0.41 Total 0 0 4.92 Tuples removed per table
Key values
- pg_catalog.pg_depend (4112) Main table with removed tuples on database dwh_bims
- 8531 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain dwh_bims.pg_catalog.pg_depend 1 1 4,112 16,336 0 0 258 dwh_inqint.pg_toast.pg_toast_2619 1 1 1,195 1,872 2 0 667 dwh_bims.pg_catalog.pg_type 1 1 920 3,362 0 0 153 dwh_inqint.pg_catalog.pg_class 1 1 898 10,763 0 0 344 dwh_bims.pg_catalog.pg_class 1 1 684 5,729 0 0 438 dwh_bims.pg_toast.pg_toast_2619 1 1 485 2,509 25 0 678 dwh_inqint.pg_catalog.pg_index 1 1 207 2,394 0 0 65 dwh_inqint.pg_catalog.pg_namespace 1 0 23 85 0 0 2 dwh_bims.pg_catalog.pg_database 1 0 7 13 1 0 1 Total 9 7 8,531 43,063 28 0 2,606 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed dwh_inqint.pg_catalog.pg_index 1 1 207 0 dwh_bims.pg_catalog.pg_class 1 1 684 0 dwh_bims.pg_catalog.pg_database 1 0 7 0 dwh_inqint.pg_toast.pg_toast_2619 1 1 1195 0 dwh_inqint.pg_catalog.pg_namespace 1 0 23 0 dwh_bims.pg_catalog.pg_type 1 1 920 0 dwh_bims.pg_toast.pg_toast_2619 1 1 485 0 dwh_bims.pg_catalog.pg_depend 1 1 4112 0 dwh_inqint.pg_catalog.pg_class 1 1 898 0 Total 9 7 8,531 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Dec 07 03 0 0 04 1 31 05 3 184 22 4 205 23 1 55 - 1.35 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
- 66,995 Total read queries
- 25,430 Total write queries
Queries by database
Key values
- unknown Main database
- 113,141 Requests
- 1h19m24s (unknown)
- Main time consuming database
Database Request type Count Duration dwh_bims Total 81 44ms select 2 38ms tcl 79 6ms dwh_celspac Total 116 147ms select 2 138ms tcl 114 8ms dwh_celspac_static_data Total 2 55ms select 2 55ms dwh_inqint Total 155 79ms select 2 64ms tcl 153 14ms dwh_ngs Total 2 34ms select 2 34ms dwh_por_static_data Total 2 43ms select 2 43ms dwh_por_v2 Total 2 96ms select 2 96ms dwh_survey Total 2 44ms select 2 44ms postgres Total 4 194ms select 4 194ms training Total 2 30ms select 2 30ms unknown Total 113,141 1h19m24s copy from 616 2m20s copy to 20,546 1h8m30s cte 45 10s686ms cursor 18 23ms ddl 2,013 2m8s insert 37 3m6s others 21,084 1m14s select 66,973 1m49s tcl 1,809 3s897ms Queries by user
Key values
- unknown Main user
- 113,141 Requests
User Request type Count Duration dwh_bims_admin_user Total 79 6ms tcl 79 6ms dwh_celspac_admin_user Total 114 8ms tcl 114 8ms dwh_inqint_admin_user Total 153 14ms tcl 153 14ms postgres Total 22 740ms select 22 740ms unknown Total 113,141 1h19m24s copy from 616 2m20s copy to 20,546 1h8m30s cte 45 10s686ms cursor 18 23ms ddl 2,013 2m8s insert 37 3m6s others 21,084 1m14s select 66,973 1m49s tcl 1,809 3s897ms Duration by user
Key values
- 1h19m24s (unknown) Main time consuming user
User Request type Count Duration dwh_bims_admin_user Total 79 6ms tcl 79 6ms dwh_celspac_admin_user Total 114 8ms tcl 114 8ms dwh_inqint_admin_user Total 153 14ms tcl 153 14ms postgres Total 22 740ms select 22 740ms unknown Total 113,141 1h19m24s copy from 616 2m20s copy to 20,546 1h8m30s cte 45 10s686ms cursor 18 23ms ddl 2,013 2m8s insert 37 3m6s others 21,084 1m14s select 66,973 1m49s tcl 1,809 3s897ms Queries by host
Key values
- unknown Main host
- 113,509 Requests
- 1h19m25s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 113,141 Requests
- 1h19m24s (unknown)
- Main time consuming application
Application Request type Count Duration dbt Total 109 8ms tcl 109 8ms dbt SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) Total 237 21ms tcl 237 21ms pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) Total 20 596ms select 20 596ms psql SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) Total 2 144ms select 2 144ms unknown Total 113,141 1h19m24s copy from 616 2m20s copy to 20,546 1h8m30s cte 45 10s686ms cursor 18 23ms ddl 2,013 2m8s insert 37 3m6s others 21,084 1m14s select 66,973 1m49s tcl 1,809 3s897ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-12-07 04:06:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 86,719 0-1ms duration
Slowest individual queries
Rank Duration Query 1 1m29s COPY prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") TO stdout;[ Date: 2025-12-07 03:04:44 ]
2 1m27s COPY prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") TO stdout;[ Date: 2025-12-07 03:13:02 ]
3 1m9s REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;[ Date: 2025-12-07 23:36:53 - Bind query: yes ]
4 53s793ms INSERT INTO src_cladeis_public.cls_answer SELECT all_answers.form_structure_id AS form_structure_id, all_answers.id AS form_id, all_answers.repeat_group_id, all_answers.repeat_group_row_id, all_answers.question_id, CASE WHEN all_answers.question_id IN ( SELECT q_id FROM public.exceptions_table) AND all_answers.value::json ->> 'state'::text = 'done' THEN '{"kod":"Sensitive_question"}' ELSE all_answers.value::json ->> 'value'::text END AS value, all_answers.value::json ->> 'state'::text AS state, all_answers.value AS all_json FROM src_cladeis_public_seisnsitive.all_cladeis_answers all_answers;[ Date: 2025-12-07 23:37:48 - Bind query: yes ]
5 52s94ms INSERT INTO src_cladeis_hist2.public_cls_form_study_phase SELECT * FROM fdw_cladeis_hist2.public_cls_form_study_phase;[ Date: 2025-12-07 23:34:56 - Bind query: yes ]
6 45s399ms COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;[ Date: 2025-12-07 04:27:34 ]
7 44s189ms COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;[ Date: 2025-12-07 04:09:12 ]
8 44s165ms COPY src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;[ Date: 2025-12-07 04:28:18 ]
9 43s981ms INSERT INTO src_cladeis_public_seisnsitive.cls_answer SELECT form_structure_id AS form_structure_id, id AS form_id, repeat_group_id, repeat_group_row_id, question_id, value::json ->> 'value'::text AS value, value::json ->> 'state'::text AS state FROM src_cladeis_public_seisnsitive.all_cladeis_answers;[ Date: 2025-12-07 23:38:32 - Bind query: yes ]
10 42s470ms COPY src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) TO stdout;[ Date: 2025-12-07 03:56:10 ]
11 40s666ms COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;[ Date: 2025-12-07 04:05:47 ]
12 40s559ms COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;[ Date: 2025-12-07 04:13:15 ]
13 39s625ms COPY src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;[ Date: 2025-12-07 04:13:55 ]
14 39s493ms COPY src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) TO stdout;[ Date: 2025-12-07 03:33:39 ]
15 29s898ms COPY jk_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;[ Date: 2025-12-07 03:10:50 ]
16 29s475ms COPY prod1_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;[ Date: 2025-12-07 03:48:57 ]
17 29s241ms COPY jc_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;[ Date: 2025-12-07 03:10:07 ]
18 29s86ms COPY prod_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;[ Date: 2025-12-07 03:14:09 ]
19 28s982ms COPY src_las.biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;[ Date: 2025-12-07 03:16:32 ]
20 28s712ms COPY ps_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;[ Date: 2025-12-07 03:52:02 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2m56s 2 1m27s 1m29s 1m28s copy prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 07 03 2 2m56s 1m28s -
COPY prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") TO stdout;
Date: 2025-12-07 03:04:44 Duration: 1m29s
-
COPY prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") TO stdout;
Date: 2025-12-07 03:13:02 Duration: 1m27s
2 2m50s 4 40s559ms 45s399ms 42s703ms copy src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 07 04 4 2m50s 42s703ms -
COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:27:34 Duration: 45s399ms
-
COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:09:12 Duration: 44s189ms
-
COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:05:47 Duration: 40s666ms
3 1m23s 2 39s625ms 44s165ms 41s895ms copy src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 07 04 2 1m23s 41s895ms -
COPY src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:28:18 Duration: 44s165ms
-
COPY src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:13:55 Duration: 39s625ms
4 1m21s 2 39s493ms 42s470ms 40s982ms copy src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 07 03 2 1m21s 40s982ms -
COPY src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) TO stdout;
Date: 2025-12-07 03:56:10 Duration: 42s470ms
-
COPY src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) TO stdout;
Date: 2025-12-07 03:33:39 Duration: 39s493ms
5 1m9s 1 1m9s 1m9s 1m9s refresh materialized view src_cladeis_public_seisnsitive.all_cladeis_answers with data;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 07 23 1 1m9s 1m9s -
REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;
Date: 2025-12-07 23:36:53 Duration: 1m9s Bind query: yes
-
REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;
Date: 2025-12-07 23:36:53 Duration: 0ms
6 56s980ms 2 27s82ms 29s898ms 28s490ms copy jk_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 07 03 2 56s980ms 28s490ms -
COPY jk_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:10:50 Duration: 29s898ms
-
COPY jk_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:02:33 Duration: 27s82ms
7 56s737ms 4 2s664ms 25s516ms 14s184ms copy tmp.xml_fl (id, xml_fl, code, xml_size) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 07 04 4 56s737ms 14s184ms -
COPY tmp.xml_fl (id, xml_fl, code, xml_size) TO stdout;
Date: 2025-12-07 04:15:15 Duration: 25s516ms
-
COPY tmp.xml_fl (id, xml_fl, code, xml_size) TO stdout;
Date: 2025-12-07 04:29:42 Duration: 25s495ms
-
COPY tmp.xml_fl (id, xml_fl, code, xml_size) TO stdout;
Date: 2025-12-07 04:10:04 Duration: 3s60ms
8 56s321ms 2 27s80ms 29s241ms 28s160ms copy jc_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 07 03 2 56s321ms 28s160ms -
COPY jc_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:10:07 Duration: 29s241ms
-
COPY jc_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:01:53 Duration: 27s80ms
9 56s91ms 2 27s5ms 29s86ms 28s45ms copy prod_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 07 03 2 56s91ms 28s45ms -
COPY prod_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:14:09 Duration: 29s86ms
-
COPY prod_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:05:49 Duration: 27s5ms
10 55s966ms 2 27s254ms 28s712ms 27s983ms copy ps_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 07 03 2 55s966ms 27s983ms -
COPY ps_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:52:02 Duration: 28s712ms
-
COPY ps_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:29:50 Duration: 27s254ms
11 55s306ms 2 27s92ms 28s214ms 27s653ms copy kp_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 07 03 2 55s306ms 27s653ms -
COPY kp_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:45:00 Duration: 28s214ms
-
COPY kp_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:23:33 Duration: 27s92ms
12 55s64ms 2 26s81ms 28s982ms 27s532ms copy src_las.biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 07 03 2 55s64ms 27s532ms -
COPY src_las.biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:16:32 Duration: 28s982ms
-
COPY src_las.biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:08:01 Duration: 26s81ms
13 54s975ms 90 148ms 777ms 610ms copy src_las._airbyte_raw_biobank_logaliquot from stdin delimiter ? csv;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 07 22 90 54s975ms 610ms -
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:09:56 Duration: 777ms
-
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:09:59 Duration: 768ms
-
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:10:03 Duration: 752ms
14 54s733ms 2 25s258ms 29s475ms 27s366ms copy prod1_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 07 03 2 54s733ms 27s366ms -
COPY prod1_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:48:57 Duration: 29s475ms
-
COPY prod1_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:27:02 Duration: 25s258ms
15 54s327ms 2 26s195ms 28s132ms 27s163ms copy prod_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 07 03 2 54s327ms 27s163ms -
COPY prod_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:50:28 Duration: 28s132ms
-
COPY prod_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:28:25 Duration: 26s195ms
16 53s793ms 1 53s793ms 53s793ms 53s793ms insert into src_cladeis_public.cls_answer select all_answers.form_structure_id as form_structure_id, all_answers.id as form_id, all_answers.repeat_group_id, all_answers.repeat_group_row_id, all_answers.question_id, case when all_answers.question_id in ( select q_id from public.exceptions_table) and all_answers.value::json ->> ?::text = ? then ? else all_answers.value::json ->> ?::text end as value, all_answers.value::json ->> ?::text as state, all_answers.value as all_json from src_cladeis_public_seisnsitive.all_cladeis_answers all_answers;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 07 23 1 53s793ms 53s793ms -
INSERT INTO src_cladeis_public.cls_answer SELECT all_answers.form_structure_id AS form_structure_id, all_answers.id AS form_id, all_answers.repeat_group_id, all_answers.repeat_group_row_id, all_answers.question_id, CASE WHEN all_answers.question_id IN ( SELECT q_id FROM public.exceptions_table) AND all_answers.value::json ->> 'state'::text = 'done' THEN '{"kod":"Sensitive_question"}' ELSE all_answers.value::json ->> 'value'::text END AS value, all_answers.value::json ->> 'state'::text AS state, all_answers.value AS all_json FROM src_cladeis_public_seisnsitive.all_cladeis_answers all_answers;
Date: 2025-12-07 23:37:48 Duration: 53s793ms Bind query: yes
17 53s712ms 2 25s997ms 27s715ms 26s856ms copy jk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 07 03 2 53s712ms 26s856ms -
COPY jk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:41:54 Duration: 27s715ms
-
COPY jk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:20:42 Duration: 25s997ms
18 53s662ms 2 25s381ms 28s280ms 26s831ms copy kbl_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 07 03 2 53s662ms 26s831ms -
COPY kbl_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:43:29 Duration: 28s280ms
-
COPY kbl_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:22:07 Duration: 25s381ms
19 53s18ms 2 25s544ms 27s473ms 26s509ms copy jc_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 07 03 2 53s18ms 26s509ms -
COPY jc_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:40:19 Duration: 27s473ms
-
COPY jc_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:19:16 Duration: 25s544ms
20 52s428ms 2 25s319ms 27s109ms 26s214ms copy rk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 07 03 2 52s428ms 26s214ms -
COPY rk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order) TO stdout;
Date: 2025-12-07 03:54:37 Duration: 27s109ms
-
COPY rk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order) TO stdout;
Date: 2025-12-07 03:32:13 Duration: 25s319ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 34,404 16s132ms 0ms 50ms 0ms select a.attnum, a.attname, a.atttypmod, 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, a.attgenerated, case when a.atthasmissing and not a.attisdropped then a.attmissingval else null end as attmissingval, a.attidentity, 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, case when a.attcollation <> t.typcollation then a.attcollation else ? end as attcollation, array_to_string(a.attoptions, ?) as attoptions from pg_catalog.pg_attribute a left join pg_catalog.pg_type t on a.atttypid = t.oid where a.attrelid = ?::pg_catalog.oid and a.attnum > ?::pg_catalog.int2 order by a.attnum;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 07 03 21,226 12s90ms 0ms 04 13,178 4s41ms 0ms -
SELECT a.attnum, a.attname, a.atttypmod, 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, a.attgenerated, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE null END AS attmissingval, a.attidentity, 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, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, array_to_string(a.attoptions, ', ') AS attoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '100239'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-12-07 03:17:05 Duration: 50ms
-
SELECT a.attnum, a.attname, a.atttypmod, 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, a.attgenerated, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE null END AS attmissingval, a.attidentity, 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, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, array_to_string(a.attoptions, ', ') AS attoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '100239'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-12-07 03:38:01 Duration: 49ms
-
SELECT a.attnum, a.attname, a.atttypmod, 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, a.attgenerated, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE null END AS attmissingval, a.attidentity, 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, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, array_to_string(a.attoptions, ', ') AS attoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '100239'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-12-07 04:00:44 Duration: 36ms
2 13,404 25s532ms 0ms 184ms 1ms select pg_catalog.pg_get_viewdef(?::pg_catalog.oid) as viewdef;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 07 03 5,938 23s795ms 4ms 04 7,466 1s737ms 0ms -
SELECT pg_catalog.pg_get_viewdef('342184568'::pg_catalog.oid) AS viewdef;
Date: 2025-12-07 03:17:15 Duration: 184ms
-
SELECT pg_catalog.pg_get_viewdef('342184568'::pg_catalog.oid) AS viewdef;
Date: 2025-12-07 03:38:09 Duration: 181ms
-
SELECT pg_catalog.pg_get_viewdef('347353372'::pg_catalog.oid) AS viewdef;
Date: 2025-12-07 03:17:16 Duration: 180ms
3 12,950 8s163ms 0ms 4ms 0ms select at.attname, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) as init (init_acl) where acl = init_acl)) as foo) as attacl, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rattacl, null as initattacl, null as initrattacl from pg_catalog.pg_attribute at join pg_catalog.pg_class c on (at.attrelid = c.oid) left join pg_catalog.pg_init_privs pip on (at.attrelid = pip.objoid and pip.classoid = ?::pg_catalog.regclass and at.attnum = pip.objsubid) where at.attrelid = ?::pg_catalog.oid and not at.attisdropped and (( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) as init (init_acl) where acl = init_acl)) as foo) is not null or ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) is not null or null is not null or null is not null) order by at.attnum;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 07 03 5,318 3s989ms 0ms 04 7,632 4s173ms 0ms -
SELECT at.attname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS attacl, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rattacl, NULL AS initattacl, NULL AS initrattacl FROM pg_catalog.pg_attribute at JOIN pg_catalog.pg_class c ON (at.attrelid = c.oid) LEFT JOIN pg_catalog.pg_init_privs pip ON (at.attrelid = pip.objoid AND pip.classoid = 'pg_catalog.pg_class'::pg_catalog.regclass AND at.attnum = pip.objsubid) WHERE at.attrelid = '311963397'::pg_catalog.oid AND NOT at.attisdropped AND (( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) IS NOT NULL OR ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL) ORDER BY at.attnum;
Date: 2025-12-07 03:38:16 Duration: 4ms
-
SELECT at.attname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS attacl, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rattacl, NULL AS initattacl, NULL AS initrattacl FROM pg_catalog.pg_attribute at JOIN pg_catalog.pg_class c ON (at.attrelid = c.oid) LEFT JOIN pg_catalog.pg_init_privs pip ON (at.attrelid = pip.objoid AND pip.classoid = 'pg_catalog.pg_class'::pg_catalog.regclass AND at.attnum = pip.objsubid) WHERE at.attrelid = '311963397'::pg_catalog.oid AND NOT at.attisdropped AND (( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) IS NOT NULL OR ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL) ORDER BY at.attnum;
Date: 2025-12-07 03:17:22 Duration: 4ms
-
SELECT at.attname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS attacl, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rattacl, NULL AS initattacl, NULL AS initrattacl FROM pg_catalog.pg_attribute at JOIN pg_catalog.pg_class c ON (at.attrelid = c.oid) LEFT JOIN pg_catalog.pg_init_privs pip ON (at.attrelid = pip.objoid AND pip.classoid = 'pg_catalog.pg_class'::pg_catalog.regclass AND at.attnum = pip.objsubid) WHERE at.attrelid = '239910579'::pg_catalog.oid AND NOT at.attisdropped AND (( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) IS NOT NULL OR ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL) ORDER BY at.attnum;
Date: 2025-12-07 03:38:20 Duration: 4ms
4 2,454 2s884ms 0ms 55ms 1ms select t.tableoid, t.oid, t.relname as indexname, inh.inhparent as parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, i.indnkeyatts as indnkeyatts, i.indnatts as indnatts, i.indkey, i.indisclustered, i.indisreplident, 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, ( select pg_catalog.array_agg(attnum order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatcols, ( select pg_catalog.array_agg(attstattarget order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatvals from pg_catalog.pg_index i 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 (...)) left join pg_catalog.pg_inherits inh on (inh.inhrelid = indexrelid) where i.indrelid = ?::pg_catalog.oid and (i.indisvalid or t2.relkind = ?) and i.indisready order by indexname;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 07 03 1,466 1s922ms 1ms 04 988 962ms 0ms -
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, 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, ( 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 FROM pg_catalog.pg_index i 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.indrelid = '832633'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-12-07 04:11:22 Duration: 55ms
-
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, 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, ( 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 FROM pg_catalog.pg_index i 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.indrelid = '118665'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-12-07 03:17:13 Duration: 46ms
-
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, 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, ( 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 FROM pg_catalog.pg_index i 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.indrelid = '832633'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-12-07 04:25:28 Duration: 38ms
5 1,414 300ms 0ms 19ms 0ms select tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) as adsrc from pg_catalog.pg_attrdef where adrelid = ?::pg_catalog.oid;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 07 03 910 141ms 0ms 04 504 158ms 0ms -
SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '118665'::pg_catalog.oid;
Date: 2025-12-07 03:17:05 Duration: 19ms
-
SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '105483397'::pg_catalog.oid;
Date: 2025-12-07 04:01:40 Duration: 15ms
-
SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '832633'::pg_catalog.oid;
Date: 2025-12-07 04:25:27 Duration: 14ms
6 790 47ms 0ms 2ms 0ms begin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 07 03 4 0ms 0ms 04 120 6ms 0ms 05 235 15ms 0ms 22 345 21ms 0ms 23 86 4ms 0ms [ User: dwh_inqint_admin_user - Total duration: 14ms - Times executed: 153 ]
[ User: dwh_celspac_admin_user - Total duration: 8ms - Times executed: 114 ]
[ User: dwh_bims_admin_user - Total duration: 6ms - Times executed: 79 ]
[ Application: dbt SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) - Total duration: 21ms - Times executed: 237 ]
[ Application: dbt - Total duration: 8ms - Times executed: 109 ]
-
BEGIN;
Date: 2025-12-07 22:12:09 Duration: 2ms
-
BEGIN;
Date: 2025-12-07 05:19:16 Duration: 1ms Database: dwh_inqint User: dwh_inqint_admin_user Application: dbt SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
-
BEGIN;
Date: 2025-12-07 05:19:17 Duration: 0ms Database: dwh_inqint User: dwh_inqint_admin_user Application: dbt SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
7 732 3s865ms 0ms 364ms 5ms commit;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 07 04 79 169ms 2ms 05 215 342ms 1ms 22 279 2s710ms 9ms 23 159 642ms 4ms -
COMMIT;
Date: 2025-12-07 22:12:14 Duration: 364ms
-
COMMIT;
Date: 2025-12-07 22:09:01 Duration: 83ms Bind query: yes
-
COMMIT;
Date: 2025-12-07 22:08:53 Duration: 79ms Bind query: yes
8 483 7ms 0ms 0ms 0ms begin isolation level read committed;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 07 04 42 0ms 0ms 05 110 1ms 0ms 22 125 2ms 0ms 23 206 3ms 0ms -
BEGIN ISOLATION LEVEL READ COMMITTED;
Date: 2025-12-07 04:58:58 Duration: 0ms
-
BEGIN ISOLATION LEVEL READ COMMITTED;
Date: 2025-12-07 22:39:44 Duration: 0ms
-
BEGIN ISOLATION LEVEL READ COMMITTED;
Date: 2025-12-07 22:33:57 Duration: 0ms
9 454 118ms 0ms 12ms 0ms select fs.srvname, 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(ftoptions) order by option_name), e ?) as ftoptions from pg_catalog.pg_foreign_table ft join pg_catalog.pg_foreign_server fs on (fs.oid = ft.ftserver) where ft.ftrelid = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 07 03 360 88ms 0ms 04 94 30ms 0ms -
SELECT fs.srvname, 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(ftoptions) ORDER BY option_name), E', ') AS ftoptions FROM pg_catalog.pg_foreign_table ft JOIN pg_catalog.pg_foreign_server fs ON (fs.oid = ft.ftserver) WHERE ft.ftrelid = '262482593';
Date: 2025-12-07 03:17:14 Duration: 12ms
-
SELECT fs.srvname, 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(ftoptions) ORDER BY option_name), E', ') AS ftoptions FROM pg_catalog.pg_foreign_table ft JOIN pg_catalog.pg_foreign_server fs ON (fs.oid = ft.ftserver) WHERE ft.ftrelid = '262482593';
Date: 2025-12-07 03:38:09 Duration: 12ms
-
SELECT fs.srvname, 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(ftoptions) ORDER BY option_name), E', ') AS ftoptions FROM pg_catalog.pg_foreign_table ft JOIN pg_catalog.pg_foreign_server fs ON (fs.oid = ft.ftserver) WHERE ft.ftrelid = '50007109';
Date: 2025-12-07 04:11:23 Duration: 8ms
10 212 112ms 0ms 19ms 0ms select proretset, prosrc, probin, pg_catalog.pg_get_function_arguments(oid) as funcargs, pg_catalog.pg_get_function_identity_arguments(oid) as funciargs, pg_catalog.pg_get_function_result(oid) as funcresult, array_to_string(protrftypes, ?) as protrftypes, prokind, provolatile, proisstrict, prosecdef, proleakproof, proconfig, procost, prorows, prosupport, proparallel, ( select lanname from pg_catalog.pg_language where oid = prolang) as lanname from pg_catalog.pg_proc where oid = ?::pg_catalog.oid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 07 03 178 63ms 0ms 04 34 49ms 1ms -
SELECT proretset, prosrc, probin, pg_catalog.pg_get_function_arguments(oid) AS funcargs, pg_catalog.pg_get_function_identity_arguments(oid) AS funciargs, pg_catalog.pg_get_function_result(oid) AS funcresult, array_to_string(protrftypes, ' ') AS protrftypes, prokind, provolatile, proisstrict, prosecdef, proleakproof, proconfig, procost, prorows, prosupport, proparallel, ( SELECT lanname FROM pg_catalog.pg_language WHERE oid = prolang) AS lanname FROM pg_catalog.pg_proc WHERE oid = '348090625'::pg_catalog.oid;
Date: 2025-12-07 03:38:09 Duration: 19ms
-
SELECT proretset, prosrc, probin, pg_catalog.pg_get_function_arguments(oid) AS funcargs, pg_catalog.pg_get_function_identity_arguments(oid) AS funciargs, pg_catalog.pg_get_function_result(oid) AS funcresult, array_to_string(protrftypes, ' ') AS protrftypes, prokind, provolatile, proisstrict, prosecdef, proleakproof, proconfig, procost, prorows, prosupport, proparallel, ( SELECT lanname FROM pg_catalog.pg_language WHERE oid = prolang) AS lanname FROM pg_catalog.pg_proc WHERE oid = '348090625'::pg_catalog.oid;
Date: 2025-12-07 03:17:14 Duration: 16ms
-
SELECT proretset, prosrc, probin, pg_catalog.pg_get_function_arguments(oid) AS funcargs, pg_catalog.pg_get_function_identity_arguments(oid) AS funciargs, pg_catalog.pg_get_function_result(oid) AS funcresult, array_to_string(protrftypes, ' ') AS protrftypes, prokind, provolatile, proisstrict, prosecdef, proleakproof, proconfig, procost, prorows, prosupport, proparallel, ( SELECT lanname FROM pg_catalog.pg_language WHERE oid = prolang) AS lanname FROM pg_catalog.pg_proc WHERE oid = '100219'::pg_catalog.oid;
Date: 2025-12-07 04:00:44 Duration: 13ms
11 200 4ms 0ms 0ms 0ms select t.oid, t.typelem as elemtype, t.typtype as kind from pg_catalog.pg_type as t where t.oid = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 07 04 12 0ms 0ms 05 10 0ms 0ms 22 16 0ms 0ms 23 162 3ms 0ms -
SELECT t.oid, t.typelem AS elemtype, t.typtype AS kind FROM pg_catalog.pg_type AS t WHERE t.oid = '3802';
Date: 2025-12-07 23:48:40 Duration: 0ms Bind query: yes
-
SELECT t.oid, t.typelem AS elemtype, t.typtype AS kind FROM pg_catalog.pg_type AS t WHERE t.oid = '3802';
Date: 2025-12-07 23:33:42 Duration: 0ms Bind query: yes
-
SELECT t.oid, t.typelem AS elemtype, t.typtype AS kind FROM pg_catalog.pg_type AS t WHERE t.oid = '114';
Date: 2025-12-07 23:04:13 Duration: 0ms Bind query: yes
12 150 6ms 0ms 0ms 0ms rollback;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 07 04 18 1ms 0ms 05 15 0ms 0ms 22 24 1ms 0ms 23 93 2ms 0ms -
ROLLBACK;
Date: 2025-12-07 04:39:15 Duration: 0ms
-
ROLLBACK;
Date: 2025-12-07 23:09:08 Duration: 0ms
-
ROLLBACK;
Date: 2025-12-07 04:18:58 Duration: 0ms
13 126 2ms 0ms 0ms 0ms show transaction isolation level;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 07 04 12 0ms 0ms 05 10 0ms 0ms 22 17 0ms 0ms 23 87 1ms 0ms -
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2025-12-07 22:08:59 Duration: 0ms Bind query: yes
-
show transaction isolation level;
Date: 2025-12-07 22:39:44 Duration: 0ms Bind query: yes
-
show transaction isolation level;
Date: 2025-12-07 04:19:05 Duration: 0ms Bind query: yes
14 100 0ms 0ms 0ms 0ms show standard_conforming_strings;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 07 04 6 0ms 0ms 05 5 0ms 0ms 22 8 0ms 0ms 23 81 0ms 0ms -
show standard_conforming_strings;
Date: 2025-12-07 23:48:40 Duration: 0ms Bind query: yes
-
show standard_conforming_strings;
Date: 2025-12-07 22:12:41 Duration: 0ms Bind query: yes
-
show standard_conforming_strings;
Date: 2025-12-07 23:37:48 Duration: 0ms Bind query: yes
15 100 0ms 0ms 0ms 0ms select pg_catalog.version();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 07 04 6 0ms 0ms 05 5 0ms 0ms 22 8 0ms 0ms 23 81 0ms 0ms -
select pg_catalog.version();
Date: 2025-12-07 23:33:57 Duration: 0ms Bind query: yes
-
select pg_catalog.version();
Date: 2025-12-07 23:33:44 Duration: 0ms Bind query: yes
-
select pg_catalog.version();
Date: 2025-12-07 22:09:20 Duration: 0ms Bind query: yes
16 100 0ms 0ms 0ms 0ms select current_schema();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 07 04 6 0ms 0ms 05 5 0ms 0ms 22 8 0ms 0ms 23 81 0ms 0ms -
select current_schema();
Date: 2025-12-07 22:09:20 Duration: 0ms Bind query: yes
-
select current_schema();
Date: 2025-12-07 23:37:48 Duration: 0ms Bind query: yes
-
select current_schema();
Date: 2025-12-07 23:36:54 Duration: 0ms Bind query: yes
17 97 16s600ms 90ms 230ms 171ms copy src_bims_las._airbyte_raw_map_cls_id_barcode_all_aliquots from stdin delimiter ? csv;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 07 22 97 16s600ms 171ms -
COPY src_bims_las._airbyte_raw_map_cls_id_barcode_all_aliquots FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:20:48 Duration: 230ms
-
COPY src_bims_las._airbyte_raw_map_cls_id_barcode_all_aliquots FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:21:06 Duration: 207ms
-
COPY src_bims_las._airbyte_raw_map_cls_id_barcode_all_aliquots FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:21:30 Duration: 203ms
18 90 54s975ms 148ms 777ms 610ms copy src_las._airbyte_raw_biobank_logaliquot from stdin delimiter ? csv;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 07 22 90 54s975ms 610ms -
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:09:56 Duration: 777ms
-
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:09:59 Duration: 768ms
-
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:10:03 Duration: 752ms
19 90 66ms 0ms 18ms 0ms select t.tgname, t.tgfoid::pg_catalog.regproc as tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) as tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal from pg_catalog.pg_trigger t left join pg_catalog.pg_depend as d on d.classid = ?::pg_catalog.regclass and d.refclassid = ?::pg_catalog.regclass and d.objid = t.oid left join pg_catalog.pg_trigger as pt on pt.oid = refobjid where t.tgrelid = ?::pg_catalog.oid and (not t.tgisinternal);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 07 04 90 66ms 0ms -
SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_depend AS d ON d.classid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.objid = t.oid LEFT JOIN pg_catalog.pg_trigger AS pt ON pt.oid = refobjid WHERE t.tgrelid = '2558245'::pg_catalog.oid AND (NOT t.tgisinternal);
Date: 2025-12-07 04:11:22 Duration: 18ms
-
SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_depend AS d ON d.classid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.objid = t.oid LEFT JOIN pg_catalog.pg_trigger AS pt ON pt.oid = refobjid WHERE t.tgrelid = '2558245'::pg_catalog.oid AND (NOT t.tgisinternal);
Date: 2025-12-07 04:25:28 Duration: 16ms
-
SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_depend AS d ON d.classid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.objid = t.oid LEFT JOIN pg_catalog.pg_trigger AS pt ON pt.oid = refobjid WHERE t.tgrelid = '44399660'::pg_catalog.oid AND (NOT t.tgisinternal);
Date: 2025-12-07 04:04:56 Duration: 12ms
20 90 13ms 0ms 2ms 0ms select tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) as condef from pg_catalog.pg_constraint where conrelid = ?::pg_catalog.oid and conparentid = ? and contype = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 07 04 90 13ms 0ms -
SELECT tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) AS condef FROM pg_catalog.pg_constraint WHERE conrelid = '2558245'::pg_catalog.oid AND conparentid = 0 AND contype = 'f';
Date: 2025-12-07 04:11:22 Duration: 2ms
-
SELECT tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) AS condef FROM pg_catalog.pg_constraint WHERE conrelid = '2558245'::pg_catalog.oid AND conparentid = 0 AND contype = 'f';
Date: 2025-12-07 04:25:28 Duration: 2ms
-
SELECT tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) AS condef FROM pg_catalog.pg_constraint WHERE conrelid = '251488'::pg_catalog.oid AND conparentid = 0 AND contype = 'f';
Date: 2025-12-07 04:38:17 Duration: 0ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m27s 1m29s 1m28s 2 2m56s copy prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 07 03 2 2m56s 1m28s -
COPY prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") TO stdout;
Date: 2025-12-07 03:04:44 Duration: 1m29s
-
COPY prefect_test_mart_las.map_cls_id_barcode (cls_id, "birthday of participant", "sex of participant", sample_id, sample_type, "other note", barcode, "type of aliquot", "tube type", "date when was sample issued", "date when was sample stored in freezer", "time when was sample stored in freezer", study_name, substudy, amount, status, "time sample was outside of freezer", sample_date, "time period of sampling", "the purpose of issuing the sample", "time of sampling", value, "first morning urine", fasting, "time of the last food", workplace, "notes of sample") TO stdout;
Date: 2025-12-07 03:13:02 Duration: 1m27s
2 1m9s 1m9s 1m9s 1 1m9s refresh materialized view src_cladeis_public_seisnsitive.all_cladeis_answers with data;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 07 23 1 1m9s 1m9s -
REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;
Date: 2025-12-07 23:36:53 Duration: 1m9s Bind query: yes
-
REFRESH MATERIALIZED VIEW src_cladeis_public_seisnsitive.all_cladeis_answers WITH DATA;
Date: 2025-12-07 23:36:53 Duration: 0ms
3 53s793ms 53s793ms 53s793ms 1 53s793ms insert into src_cladeis_public.cls_answer select all_answers.form_structure_id as form_structure_id, all_answers.id as form_id, all_answers.repeat_group_id, all_answers.repeat_group_row_id, all_answers.question_id, case when all_answers.question_id in ( select q_id from public.exceptions_table) and all_answers.value::json ->> ?::text = ? then ? else all_answers.value::json ->> ?::text end as value, all_answers.value::json ->> ?::text as state, all_answers.value as all_json from src_cladeis_public_seisnsitive.all_cladeis_answers all_answers;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 07 23 1 53s793ms 53s793ms -
INSERT INTO src_cladeis_public.cls_answer SELECT all_answers.form_structure_id AS form_structure_id, all_answers.id AS form_id, all_answers.repeat_group_id, all_answers.repeat_group_row_id, all_answers.question_id, CASE WHEN all_answers.question_id IN ( SELECT q_id FROM public.exceptions_table) AND all_answers.value::json ->> 'state'::text = 'done' THEN '{"kod":"Sensitive_question"}' ELSE all_answers.value::json ->> 'value'::text END AS value, all_answers.value::json ->> 'state'::text AS state, all_answers.value AS all_json FROM src_cladeis_public_seisnsitive.all_cladeis_answers all_answers;
Date: 2025-12-07 23:37:48 Duration: 53s793ms Bind query: yes
4 40s559ms 45s399ms 42s703ms 4 2m50s copy src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 07 04 4 2m50s 42s703ms -
COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:27:34 Duration: 45s399ms
-
COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:09:12 Duration: 44s189ms
-
COPY src_hom.homologa_nl_20241029 ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "METH_NAME_2", "CROP_STAG_NAME_2", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "APPLI_DESC_ORIG_NAME1_2", "APPLI_DESC_ORIG_NAME1_LANGUAGE1_2", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:05:47 Duration: 40s666ms
5 39s625ms 44s165ms 41s895ms 2 1m23s copy src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 07 04 2 1m23s 41s895ms -
COPY src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:28:18 Duration: 44s165ms
-
COPY src_hom.homologa_nl_20241029_casted ("USE_ID", "CTRY_NAME", "PTYP_NAME", "A.I. COMBINATION", "ACTI_NAME", "ACTI_GROUP", "CAS_NUM", "MODE_NAME", "FORM_NAME", "TOTAL_CONC", "CONCENTRAT", "ACTI_UNIT_NAME", "CROP_GROUP", "CROP_NAME", "CROP_INFO", "CROP_VARIETY_NAME", "SITE_NAME", "PLACE_NAME", "CROP_PURPOSE_NAME", "CROP_STATUS_NAME", "CROP_TRAIT_NAME", "CROP_ORIG_NAME1", "CROP_ORIG_NAME1_LANGUAGE1", "APPLI_DESC_ORIG_NAME1", "APPLI_DESC_ORIG_NAME1_LANGUAGE1", "CROP_EPPO_CODE", "USE_STATUS", "DATE_REGIS", "METH_NAME", "CROP_STAG_NAME", "TYPE_REGIS_NAME", "EXP_DATE_R", "USE_LAST_USE", "PROF_AMATEUR_NAME", "PROD_DATE_REGIS", "PROD_EXP_DATE_P", "PROD_LAST_COMER", "PROD_LAST_USE", "SALE_TYPE", "PRODUCT_CATEGORY", "TIME_APP_NAME", "STAGE_SCALE_DESCRIPTION", "STAGE_SCALE_TYPE_NAME", "PEST_STAG_NAME", "PEST_COMPLEX_ORIG_NAME_EN", "PEST_COMPLEX_ORIG_NAME1", "PEST_COMPLEX_ORIG_NAME1_LANGUAGE", "PEST_MAIN_GROUP", "PEST_GROUP", "PEST_NAME", "PEST_NAME_LATIN", "PEST_EPPO_CODE", "PEST_ORIG_NAME1", "PEST_ORIG_NAME1_LANGUAGE", "MIN_DOSE_R", "MAX_DOSE_R", "DOSE_UNIT_NAME", "MAX_DOSE_SEASON", "MAX_DOSE_SEASON_UNIT_NAME", "MAX_TREAT_APP", "MAX_TREAT", "MAX_TREAT_UNIT_NAME", "AMOUNT_WATER_MAX", "AMOUNT_WATER_MIN", "WATER_UNIT_ORIG_NAME_EN", "INTER_TREAT_MAX", "INTER_TREAT_MIN", "INTER_TREAT_UNIT_NAME", "PHI", "REI", "GRAZING", "CERTIFICATION") TO stdout;
Date: 2025-12-07 04:13:55 Duration: 39s625ms
6 39s493ms 42s470ms 40s982ms 2 1m21s copy src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 07 03 2 1m21s 40s982ms -
COPY src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) TO stdout;
Date: 2025-12-07 03:56:10 Duration: 42s470ms
-
COPY src_cladeis_hist2.public_cls_form_study_phase (shd_id, id, soft_delete, form_structure_id, subject_id, study_phase_id, resource_name, form_data, usercreated, datecreated, datechanged, userchanged, owner_group_id, validation_state, owner_user_id, shd_action, shd_chng_date) TO stdout;
Date: 2025-12-07 03:33:39 Duration: 39s493ms
7 27s82ms 29s898ms 28s490ms 2 56s980ms copy jk_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 07 03 2 56s980ms 28s490ms -
COPY jk_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:10:50 Duration: 29s898ms
-
COPY jk_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:02:33 Duration: 27s82ms
8 27s80ms 29s241ms 28s160ms 2 56s321ms copy jc_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 07 03 2 56s321ms 28s160ms -
COPY jc_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:10:07 Duration: 29s241ms
-
COPY jc_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:01:53 Duration: 27s80ms
9 27s5ms 29s86ms 28s45ms 2 56s91ms copy prod_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 07 03 2 56s91ms 28s45ms -
COPY prod_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:14:09 Duration: 29s86ms
-
COPY prod_stg_las.stg_las_biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:05:49 Duration: 27s5ms
10 27s254ms 28s712ms 27s983ms 2 55s966ms copy ps_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 07 03 2 55s966ms 27s983ms -
COPY ps_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:52:02 Duration: 28s712ms
-
COPY ps_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:29:50 Duration: 27s254ms
11 27s92ms 28s214ms 27s653ms 2 55s306ms copy kp_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 07 03 2 55s306ms 27s653ms -
COPY kp_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:45:00 Duration: 28s214ms
-
COPY kp_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:23:33 Duration: 27s92ms
12 26s81ms 28s982ms 27s532ms 2 55s64ms copy src_las.biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 07 03 2 55s64ms 27s532ms -
COPY src_las.biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:16:32 Duration: 28s982ms
-
COPY src_las.biobank_logaliquot (date, aliquot_id, createdby_id, messagetype_id, additionaldescription, id, _airbyte_ab_id, _airbyte_emitted_at, _airbyte_normalized_at, _airbyte_biobank_logaliquot_hashid) TO stdout;
Date: 2025-12-07 03:08:01 Duration: 26s81ms
13 25s258ms 29s475ms 27s366ms 2 54s733ms copy prod1_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 07 03 2 54s733ms 27s366ms -
COPY prod1_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:48:57 Duration: 29s475ms
-
COPY prod1_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:27:02 Duration: 25s258ms
14 26s195ms 28s132ms 27s163ms 2 54s327ms copy prod_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 07 03 2 54s327ms 27s163ms -
COPY prod_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:50:28 Duration: 28s132ms
-
COPY prod_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:28:25 Duration: 26s195ms
15 25s997ms 27s715ms 26s856ms 2 53s712ms copy jk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 07 03 2 53s712ms 26s856ms -
COPY jk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:41:54 Duration: 27s715ms
-
COPY jk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:20:42 Duration: 25s997ms
16 25s381ms 28s280ms 26s831ms 2 53s662ms copy kbl_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 07 03 2 53s662ms 26s831ms -
COPY kbl_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:43:29 Duration: 28s280ms
-
COPY kbl_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:22:07 Duration: 25s381ms
17 25s544ms 27s473ms 26s509ms 2 53s18ms copy jc_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 07 03 2 53s18ms 26s509ms -
COPY jc_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:40:19 Duration: 27s473ms
-
COPY jc_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order, fill_quality_question) TO stdout;
Date: 2025-12-07 03:19:16 Duration: 25s544ms
18 25s319ms 27s109ms 26s214ms 2 52s428ms copy rk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 07 03 2 52s428ms 26s214ms -
COPY rk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order) TO stdout;
Date: 2025-12-07 03:54:37 Duration: 27s109ms
-
COPY rk_stg_cladeis_core.stg_cladeis__answer (form_structure_id, form_id, question_id, repeat_group_id, index, value, state, question_datatype_id, form_structure_name, question_code, question_name, question_group_order, question_order) TO stdout;
Date: 2025-12-07 03:32:13 Duration: 25s319ms
19 2s664ms 25s516ms 14s184ms 4 56s737ms copy tmp.xml_fl (id, xml_fl, code, xml_size) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 07 04 4 56s737ms 14s184ms -
COPY tmp.xml_fl (id, xml_fl, code, xml_size) TO stdout;
Date: 2025-12-07 04:15:15 Duration: 25s516ms
-
COPY tmp.xml_fl (id, xml_fl, code, xml_size) TO stdout;
Date: 2025-12-07 04:29:42 Duration: 25s495ms
-
COPY tmp.xml_fl (id, xml_fl, code, xml_size) TO stdout;
Date: 2025-12-07 04:10:04 Duration: 3s60ms
20 148ms 777ms 610ms 90 54s975ms copy src_las._airbyte_raw_biobank_logaliquot from stdin delimiter ? csv;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 07 22 90 54s975ms 610ms -
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:09:56 Duration: 777ms
-
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:09:59 Duration: 768ms
-
COPY src_las._airbyte_raw_biobank_logaliquot FROM stdin DELIMITER ',' CSV;
Date: 2025-12-07 22:10:03 Duration: 752ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 150ms 200 0ms 83ms 0ms SELECT ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Dec 07 04 12 8ms 0ms 05 10 2ms 0ms 22 16 9ms 0ms 23 162 129ms 0ms -
SELECT ;
Date: 2025-12-07 23:48:40 Duration: 83ms Database: postgres
-
SELECT ;
Date: 2025-12-07 22:09:20 Duration: 5ms Database: postgres
-
SELECT ;
Date: 2025-12-07 04:19:05 Duration: 3ms Database: postgres
2 92ms 26 0ms 44ms 3ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 03 6 13ms 2ms 04 5 0ms 0ms 21 9 78ms 8ms 22 6 0ms 0ms -
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2025-12-07 22:08:53 Duration: 44ms Database: postgres
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2025-12-07 22:08:59 Duration: 33ms Database: postgres
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2025-12-07 04:18:50 Duration: 7ms Database: postgres
3 35ms 100 0ms 10ms 0ms select pg_catalog.version();Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 03 6 5ms 0ms 04 5 0ms 0ms 21 8 13ms 1ms 22 81 15ms 0ms -
select pg_catalog.version();
Date: 2025-12-07 22:12:41 Duration: 10ms Database: postgres
-
select pg_catalog.version();
Date: 2025-12-07 23:48:40 Duration: 10ms Database: postgres
-
select pg_catalog.version();
Date: 2025-12-07 22:09:20 Duration: 2ms Database: postgres
4 30ms 1 30ms 30ms 30ms INSERT INTO src_celspac_admin_public_sensitive.acl_user;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 22 1 30ms 30ms -
INSERT INTO src_celspac_admin_public_sensitive.acl_user;
Date: 2025-12-07 23:34:00 Duration: 30ms Database: postgres
5 26ms 100 0ms 7ms 0ms select current_schema();Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 03 6 6ms 1ms 04 5 0ms 0ms 21 8 13ms 1ms 22 81 7ms 0ms -
select current_schema();
Date: 2025-12-07 22:09:20 Duration: 7ms Database: postgres
-
select current_schema();
Date: 2025-12-07 22:12:41 Duration: 6ms Database: postgres
-
select current_schema();
Date: 2025-12-07 04:29:04 Duration: 3ms Database: postgres
6 20ms 1 20ms 20ms 20ms INSERT INTO src_celspac_admin_core_sensitive.subject;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 22 1 20ms 20ms -
INSERT INTO src_celspac_admin_core_sensitive.subject;
Date: 2025-12-07 23:33:55 Duration: 20ms Database: postgres
7 16ms 1 16ms 16ms 16ms SELECT tmp.TABLE_CAT, tmp.TABLE_SCHEM, tmp.TABLE_NAME, tmp.NON_UNIQUE, tmp.INDEX_QUALIFIER, tmp.INDEX_NAME, tmp.TYPE, tmp.ORDINAL_POSITION, trim(both '"' from pg_catalog.pg_get_indexdef(tmp.CI_OID, tmp.ORDINAL_POSITION, false)) AS COLUMN_NAME, CASE tmp.AM_NAME WHEN 'btree' THEN CASE tmp.I_INDOPTION[tmp.ORDINAL_POSITION - 1] & 1::smallint WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, tmp.CARDINALITY, tmp.PAGES, tmp.FILTER_CONDITION FROM ( SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (information_schema._pg_expandarray (i.indkey)).n AS ORDINAL_POSITION, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION, ci.oid AS CI_OID, i.indoption AS I_INDOPTION, am.amname AS AM_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN pg_catalog.pg_index i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE true AND n.nspname = 'prod_mart_las' AND ct.relname = 'map_cls_id_barcode_all_aliquots') AS tmp ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 21 1 16ms 16ms -
SELECT tmp.TABLE_CAT, tmp.TABLE_SCHEM, tmp.TABLE_NAME, tmp.NON_UNIQUE, tmp.INDEX_QUALIFIER, tmp.INDEX_NAME, tmp.TYPE, tmp.ORDINAL_POSITION, trim(both '"' from pg_catalog.pg_get_indexdef(tmp.CI_OID, tmp.ORDINAL_POSITION, false)) AS COLUMN_NAME, CASE tmp.AM_NAME WHEN 'btree' THEN CASE tmp.I_INDOPTION[tmp.ORDINAL_POSITION - 1] & 1::smallint WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, tmp.CARDINALITY, tmp.PAGES, tmp.FILTER_CONDITION FROM ( SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (information_schema._pg_expandarray (i.indkey)).n AS ORDINAL_POSITION, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION, ci.oid AS CI_OID, i.indoption AS I_INDOPTION, am.amname AS AM_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN pg_catalog.pg_index i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE true AND n.nspname = 'prod_mart_las' AND ct.relname = 'map_cls_id_barcode_all_aliquots') AS tmp ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2025-12-07 22:20:46 Duration: 16ms Database: postgres
8 16ms 1 16ms 16ms 16ms INSERT INTO src_cladeis_public.cls_answer;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 22 1 16ms 16ms -
INSERT INTO src_cladeis_public.cls_answer;
Date: 2025-12-07 23:36:54 Duration: 16ms Database: postgres
9 14ms 1 14ms 14ms 14ms INSERT INTO src_celspac_admin_core.subcohort_form_structure_variant;Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 22 1 14ms 14ms -
INSERT INTO src_celspac_admin_core.subcohort_form_structure_variant;
Date: 2025-12-07 23:33:46 Duration: 14ms Database: postgres
10 9ms 1 9ms 9ms 9ms INSERT INTO src_celspac_admin_core.inform_consent SELECT * FROM fdw_celspac_admin_core.inform_consent;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 22 1 9ms 9ms -
INSERT INTO src_celspac_admin_core.inform_consent SELECT * FROM fdw_celspac_admin_core.inform_consent;
Date: 2025-12-07 23:33:49 Duration: 9ms Database: postgres
11 9ms 1 9ms 9ms 9ms INSERT INTO src_cis_enum_public.mkn10_20140401_cz SELECT * FROM fdw_cis_enum_public.mkn10_20140401_cz;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 22 1 9ms 9ms -
INSERT INTO src_cis_enum_public.mkn10_20140401_cz SELECT * FROM fdw_cis_enum_public.mkn10_20140401_cz;
Date: 2025-12-07 23:34:02 Duration: 9ms Database: postgres
12 9ms 1 9ms 9ms 9ms INSERT INTO src_celspac_admin_core.form_structure_variant;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 22 1 9ms 9ms -
INSERT INTO src_celspac_admin_core.form_structure_variant;
Date: 2025-12-07 23:33:59 Duration: 9ms Database: postgres
13 7ms 1 7ms 7ms 7ms select (txid_snapshot_xmin(txid_current_snapshot()) >> 32) AS num_wraparound, ;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 21 1 7ms 7ms -
select (txid_snapshot_xmin(txid_current_snapshot()) >> 32) AS num_wraparound, ;
Date: 2025-12-07 22:20:46 Duration: 7ms Database: postgres
14 7ms 1 7ms 7ms 7ms INSERT INTO src_celspac_admin_core.cohort SELECT * FROM fdw_celspac_admin_core.cohort;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 22 1 7ms 7ms -
INSERT INTO src_celspac_admin_core.cohort SELECT * FROM fdw_celspac_admin_core.cohort;
Date: 2025-12-07 23:33:47 Duration: 7ms Database: postgres
15 7ms 1 7ms 7ms 7ms INSERT INTO src_celspac_admin_core.pilot;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 22 1 7ms 7ms -
INSERT INTO src_celspac_admin_core.pilot;
Date: 2025-12-07 23:33:47 Duration: 7ms Database: postgres
16 7ms 1 7ms 7ms 7ms INSERT INTO src_cladeis_public.trans_dictionary SELECT * FROM fdw_cladeis_public.trans_dictionary;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 22 1 7ms 7ms -
INSERT INTO src_cladeis_public.trans_dictionary SELECT * FROM fdw_cladeis_public.trans_dictionary;
Date: 2025-12-07 23:35:04 Duration: 7ms Database: postgres
17 5ms 292 0ms 0ms 0ms ;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 03 26 0ms 0ms 04 99 1ms 0ms 21 143 2ms 0ms 22 24 0ms 0ms -
;
Date: 2025-12-07 22:09:01 Duration: 0ms Database: postgres
-
;
Date: 2025-12-07 05:18:54 Duration: 0ms Database: postgres
-
;
Date: 2025-12-07 22:33:44 Duration: 0ms Database: postgres
18 5ms 1 5ms 5ms 5ms INSERT INTO src_celspac_admin_core.subject_inform_consent SELECT * FROM fdw_celspac_admin_core.subject_inform_consent;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 22 1 5ms 5ms -
INSERT INTO src_celspac_admin_core.subject_inform_consent SELECT * FROM fdw_celspac_admin_core.subject_inform_consent;
Date: 2025-12-07 23:33:52 Duration: 5ms Database: postgres
19 4ms 1 4ms 4ms 4ms INSERT INTO src_cladeis_public.cls_form_structure SELECT * FROM fdw_cladeis_public.cls_form_structure;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 22 1 4ms 4ms -
INSERT INTO src_cladeis_public.cls_form_structure SELECT * FROM fdw_cladeis_public.cls_form_structure;
Date: 2025-12-07 23:35:04 Duration: 4ms Database: postgres
20 4ms 1 4ms 4ms 4ms INSERT INTO src_celspac_admin_core.form_structure SELECT * FROM fdw_celspac_admin_core.form_structure;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 22 1 4ms 4ms -
INSERT INTO src_celspac_admin_core.form_structure SELECT * FROM fdw_celspac_admin_core.form_structure;
Date: 2025-12-07 23:33:49 Duration: 4ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 117ms 200 0ms 39ms 0ms SELECT t.oid, t.typelem AS elemtype, t.typtype AS kind FROM pg_catalog.pg_type AS t WHERE t.oid = $1;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Dec 07 04 12 13ms 1ms 05 10 2ms 0ms 22 16 19ms 1ms 23 162 81ms 0ms -
SELECT t.oid, t.typelem AS elemtype, t.typtype AS kind FROM pg_catalog.pg_type AS t WHERE t.oid = $1;
Date: 2025-12-07 23:48:40 Duration: 39ms Database: postgres parameters: $1 = '114'
-
SELECT t.oid, t.typelem AS elemtype, t.typtype AS kind FROM pg_catalog.pg_type AS t WHERE t.oid = $1;
Date: 2025-12-07 22:09:20 Duration: 15ms Database: postgres parameters: $1 = '114'
-
SELECT t.oid, t.typelem AS elemtype, t.typtype AS kind FROM pg_catalog.pg_type AS t WHERE t.oid = $1;
Date: 2025-12-07 04:19:05 Duration: 5ms Database: postgres parameters: $1 = '114'
2 44ms 1 44ms 44ms 44ms INSERT INTO src_celspac_admin_core.subcohort_form_structure_variant SELECT * FROM fdw_celspac_admin_core.subcohort_form_structure_variant;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 22 1 44ms 44ms -
INSERT INTO src_celspac_admin_core.subcohort_form_structure_variant SELECT * FROM fdw_celspac_admin_core.subcohort_form_structure_variant;
Date: 2025-12-07 23:33:46 Duration: 44ms Database: postgres
3 29ms 1 29ms 29ms 29ms INSERT INTO src_cladeis_public.cls_answer SELECT all_answers.form_structure_id AS form_structure_id, all_answers.id AS form_id, all_answers.repeat_group_id, all_answers.repeat_group_row_id, all_answers.question_id, CASE WHEN all_answers.question_id IN ( SELECT q_id FROM public.exceptions_table) AND all_answers.value::json ->> 'state'::text = 'done' THEN '{"kod":"Sensitive_question"}' ELSE all_answers.value::json ->> 'value'::text END AS value, all_answers.value::json ->> 'state'::text AS state, all_answers.value AS all_json FROM src_cladeis_public_seisnsitive.all_cladeis_answers all_answers;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 22 1 29ms 29ms -
INSERT INTO src_cladeis_public.cls_answer SELECT all_answers.form_structure_id AS form_structure_id, all_answers.id AS form_id, all_answers.repeat_group_id, all_answers.repeat_group_row_id, all_answers.question_id, CASE WHEN all_answers.question_id IN ( SELECT q_id FROM public.exceptions_table) AND all_answers.value::json ->> 'state'::text = 'done' THEN '{"kod":"Sensitive_question"}' ELSE all_answers.value::json ->> 'value'::text END AS value, all_answers.value::json ->> 'state'::text AS state, all_answers.value AS all_json FROM src_cladeis_public_seisnsitive.all_cladeis_answers all_answers;
Date: 2025-12-07 23:36:54 Duration: 29ms Database: postgres
4 9ms 1 9ms 9ms 9ms SELECT tmp.TABLE_CAT, tmp.TABLE_SCHEM, tmp.TABLE_NAME, tmp.NON_UNIQUE, tmp.INDEX_QUALIFIER, tmp.INDEX_NAME, tmp.TYPE, tmp.ORDINAL_POSITION, trim(both '"' from pg_catalog.pg_get_indexdef(tmp.CI_OID, tmp.ORDINAL_POSITION, false)) AS COLUMN_NAME, CASE tmp.AM_NAME WHEN 'btree' THEN CASE tmp.I_INDOPTION[tmp.ORDINAL_POSITION - 1] & 1::smallint WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, tmp.CARDINALITY, tmp.PAGES, tmp.FILTER_CONDITION FROM ( SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (information_schema._pg_expandarray (i.indkey)).n AS ORDINAL_POSITION, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION, ci.oid AS CI_OID, i.indoption AS I_INDOPTION, am.amname AS AM_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN pg_catalog.pg_index i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE true AND n.nspname = 'prod_mart_las' AND ct.relname = 'map_cls_id_barcode_all_aliquots') AS tmp ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 21 1 9ms 9ms -
SELECT tmp.TABLE_CAT, tmp.TABLE_SCHEM, tmp.TABLE_NAME, tmp.NON_UNIQUE, tmp.INDEX_QUALIFIER, tmp.INDEX_NAME, tmp.TYPE, tmp.ORDINAL_POSITION, trim(both '"' from pg_catalog.pg_get_indexdef(tmp.CI_OID, tmp.ORDINAL_POSITION, false)) AS COLUMN_NAME, CASE tmp.AM_NAME WHEN 'btree' THEN CASE tmp.I_INDOPTION[tmp.ORDINAL_POSITION - 1] & 1::smallint WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, tmp.CARDINALITY, tmp.PAGES, tmp.FILTER_CONDITION FROM ( SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (information_schema._pg_expandarray (i.indkey)).n AS ORDINAL_POSITION, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION, ci.oid AS CI_OID, i.indoption AS I_INDOPTION, am.amname AS AM_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN pg_catalog.pg_index i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE true AND n.nspname = 'prod_mart_las' AND ct.relname = 'map_cls_id_barcode_all_aliquots') AS tmp ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2025-12-07 22:20:46 Duration: 9ms Database: postgres
5 9ms 1 9ms 9ms 9ms INSERT INTO src_celspac_admin_public_sensitive.acl_user SELECT DISTINCT au.id, au."name" FROM fdw_celspac_admin_public.acl_user au LEFT JOIN fdw_celspac_admin_public.acl_user_group_role augr ON au.id = augr.user_id LEFT JOIN fdw_celspac_admin_public.acl_group ag ON augr.group_id = ag.id WHERE au.active AND ag."name" != 'proband';Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 22 1 9ms 9ms -
INSERT INTO src_celspac_admin_public_sensitive.acl_user SELECT DISTINCT au.id, au."name" FROM fdw_celspac_admin_public.acl_user au LEFT JOIN fdw_celspac_admin_public.acl_user_group_role augr ON au.id = augr.user_id LEFT JOIN fdw_celspac_admin_public.acl_group ag ON augr.group_id = ag.id WHERE au.active AND ag."name" != 'proband';
Date: 2025-12-07 23:34:00 Duration: 9ms Database: postgres
6 8ms 1 8ms 8ms 8ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 2615 AS oid, 2 AS attnum UNION ALL SELECT 1259, 2) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 21 1 8ms 8ms -
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 2615 AS oid, 2 AS attnum UNION ALL SELECT 1259, 2) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2025-12-07 22:20:46 Duration: 8ms Database: postgres
7 6ms 1 6ms 6ms 6ms INSERT INTO src_celspac_admin_core_sensitive.subject SELECT subject_state_code, sex_code, family_id, elspac_family_relationship_type_code, is_origin_elspac, family_code, name, surname, titles_before, titles_after, description, rc, tng_id, birthdate, death_by, death_at, date_of_death, cause_of_death, email, phone_number, city, street, street_number, postal_code, country, permanent AS permanent_residence, street_contact, street_number_contact, city_contact, postal_code_contact, country_contact, is_archived, user_id, maiden_name, test_proband, created_by, enrolled_by, created_at, enrolled_at, anonym_by, anonym_at, subject_id, tng_p08__description, tng_p08__description_internal, tng_p08__expectedchildbirth, tng_p08__childbirth, tng_p08__location, tng_p08__hospitalid, tng_p08__childid, tng_p08__childcode, tng_p01__description, tng_p01__description_internal, tng_p01__expectedchildbirth, tng_p01__childbirth, tng_p01__location, tng_p01__hospitalid, tng_p01__childid, tng_p01__childcode, tng_p02__description, tng_p02__description_internal, tng_p02__expectedchildbirth, tng_p02__childbirth, tng_p02__location, tng_p02__hospitalid, tng_p02__childid, tng_p02__childcode, tng_p03__description, tng_p03__description_internal, tng_p03__expectedchildbirth, tng_p03__childbirth, tng_p03__location, tng_p03__hospitalid, tng_p03__childid, tng_p03__childcode, tng_p04__description, tng_p04__description_internal, tng_p04__expectedchildbirth, tng_p04__childbirth, tng_p04__location, tng_p04__hospitalid, tng_p04__childid, tng_p04__childcode, tng_p05__description, tng_p05__description_internal, tng_p05__expectedchildbirth, tng_p05__childbirth, tng_p05__location, tng_p05__hospitalid, tng_p05__childid, tng_p05__childcode, tng_p06__description, tng_p06__description_internal, tng_p06__expectedchildbirth, tng_p06__childbirth, tng_p06__location, tng_p06__hospitalid, tng_p06__childid, tng_p06__childcode, tng_p07__description, tng_p07__description_internal, tng_p07__expectedchildbirth, tng_p07__childbirth, tng_p07__location, tng_p07__hospitalid, tng_p07__childid, tng_p07__childcode, tng_p09__description, tng_p09__description_internal, tng_p09__expectedchildbirth, tng_p09__childbirth, tng_p09__location, tng_p09__hospitalid, tng_p09__childid, tng_p09__childcode, ya_p01__description, ya_p01__description_internal, ya_p01__examin, ya_p01__familyelspac, ya_p02__description, ya_p02__description_internal, ya_p02__examin, ya_p02__familyelspac, tng_p10__description, tng_p10__description_internal, tng_p10__expectedchildbirth, tng_p10__childbirth, tng_p10__location, tng_p10__hospitalid, tng_p10__childid, tng_p10__childcode, hba_p01__description, hba_p01__description_internal, hba_p01__examin, hba_p01__familyelspac, covid_p01__description, covid_p01__description_internal, covid_p01__examin, covid_p01__familyelspac, tng_p11__description, tng_p11__description_internal, tng_p11__expectedchildbirth, tng_p11__childbirth, tng_p11__location, tng_p11__hospitalid, tng_p11__childid, tng_p11__childcode, ya_p03__description, ya_p03__description_internal, ya_p03__examin, ya_p03__familyelspac, tng_p12__description, tng_p12__description_internal, tng_p12__expectedchildbirth, tng_p12__childbirth, tng_p12__location, tng_p12__hospitalid, tng_p12__childid, tng_p12__childcode, celspac_pr_elspac_p01__description, celspac_pr_elspac_p01__description_internal, celspac_pr_elspac_p01__examin, celspac_pr_elspac_p01__familyelspac, celspac_pr_zajemci_p01__description, celspac_pr_zajemci_p01__description_internal, celspac_pr_zajemci_p01__examin, celspac_pr_zajemci_p01__familyelspac, hapiee_p01__description, hapiee_p01__description_internal, hapiee_p01__examin, hapiee_p01__familyelspac, tng_p13__description, tng_p13__description_internal, tng_p13__expectedchildbirth, tng_p13__childbirth, tng_p13__location, tng_p13__hospitalid, tng_p13__childid, tng_p13__childcode, hapiee_p02__description, hapiee_p02__description_internal, hapiee_p02__examin, hapiee_p02__familyelspac, vulde__description, vulde__description_internal, vulde__examin, vulde__familyelspac, tng_4mi_p1__description, tng_4mi_p1__description_internal, tng_4mi_p1__expectedchildbirth, tng_4mi_p1__childbirth, tng_4mi_p1__location, tng_4mi_p1__hospitalid, tng_4mi_p1__childid, tng_4mi_p1__childcode, tng_4mi_p1__examin, parents_p01__description, parents_p01__description_internal, parents_p01__examin, parents_p01__familyelspac, parents_p02__description, parents_p02__description_internal, parents_p02__examin, parents_p02__familyelspac, ya_p04__description, ya_p04__description_internal, ya_p04__examin, ya_p04__familyelspac, tng_4mi_p2__description, tng_4mi_p2__description_internal, tng_4mi_p2__expectedchildbirth, tng_4mi_p2__childbirth, tng_4mi_p2__location, tng_4mi_p2__hospitalid, tng_4mi_p2__childid, tng_4mi_p2__childcode, tng_4mi_p2__examin, tng_children_p1__description, tng_children_p1__description_internal, tng_children_p1__location, tng_children_p1__examin, tng_children_p1__childcode, horpark__description, horpark__description_internal, horpark__patientgroup, horpark__patientpartner, horpark__biobankcode, horpark__locationbloodurine, horpark__locationlikvor FROM fdw_celspac_admin_core.stg_celspac_admin__subject s;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 22 1 6ms 6ms -
INSERT INTO src_celspac_admin_core_sensitive.subject SELECT subject_state_code, sex_code, family_id, elspac_family_relationship_type_code, is_origin_elspac, family_code, name, surname, titles_before, titles_after, description, rc, tng_id, birthdate, death_by, death_at, date_of_death, cause_of_death, email, phone_number, city, street, street_number, postal_code, country, permanent AS permanent_residence, street_contact, street_number_contact, city_contact, postal_code_contact, country_contact, is_archived, user_id, maiden_name, test_proband, created_by, enrolled_by, created_at, enrolled_at, anonym_by, anonym_at, subject_id, tng_p08__description, tng_p08__description_internal, tng_p08__expectedchildbirth, tng_p08__childbirth, tng_p08__location, tng_p08__hospitalid, tng_p08__childid, tng_p08__childcode, tng_p01__description, tng_p01__description_internal, tng_p01__expectedchildbirth, tng_p01__childbirth, tng_p01__location, tng_p01__hospitalid, tng_p01__childid, tng_p01__childcode, tng_p02__description, tng_p02__description_internal, tng_p02__expectedchildbirth, tng_p02__childbirth, tng_p02__location, tng_p02__hospitalid, tng_p02__childid, tng_p02__childcode, tng_p03__description, tng_p03__description_internal, tng_p03__expectedchildbirth, tng_p03__childbirth, tng_p03__location, tng_p03__hospitalid, tng_p03__childid, tng_p03__childcode, tng_p04__description, tng_p04__description_internal, tng_p04__expectedchildbirth, tng_p04__childbirth, tng_p04__location, tng_p04__hospitalid, tng_p04__childid, tng_p04__childcode, tng_p05__description, tng_p05__description_internal, tng_p05__expectedchildbirth, tng_p05__childbirth, tng_p05__location, tng_p05__hospitalid, tng_p05__childid, tng_p05__childcode, tng_p06__description, tng_p06__description_internal, tng_p06__expectedchildbirth, tng_p06__childbirth, tng_p06__location, tng_p06__hospitalid, tng_p06__childid, tng_p06__childcode, tng_p07__description, tng_p07__description_internal, tng_p07__expectedchildbirth, tng_p07__childbirth, tng_p07__location, tng_p07__hospitalid, tng_p07__childid, tng_p07__childcode, tng_p09__description, tng_p09__description_internal, tng_p09__expectedchildbirth, tng_p09__childbirth, tng_p09__location, tng_p09__hospitalid, tng_p09__childid, tng_p09__childcode, ya_p01__description, ya_p01__description_internal, ya_p01__examin, ya_p01__familyelspac, ya_p02__description, ya_p02__description_internal, ya_p02__examin, ya_p02__familyelspac, tng_p10__description, tng_p10__description_internal, tng_p10__expectedchildbirth, tng_p10__childbirth, tng_p10__location, tng_p10__hospitalid, tng_p10__childid, tng_p10__childcode, hba_p01__description, hba_p01__description_internal, hba_p01__examin, hba_p01__familyelspac, covid_p01__description, covid_p01__description_internal, covid_p01__examin, covid_p01__familyelspac, tng_p11__description, tng_p11__description_internal, tng_p11__expectedchildbirth, tng_p11__childbirth, tng_p11__location, tng_p11__hospitalid, tng_p11__childid, tng_p11__childcode, ya_p03__description, ya_p03__description_internal, ya_p03__examin, ya_p03__familyelspac, tng_p12__description, tng_p12__description_internal, tng_p12__expectedchildbirth, tng_p12__childbirth, tng_p12__location, tng_p12__hospitalid, tng_p12__childid, tng_p12__childcode, celspac_pr_elspac_p01__description, celspac_pr_elspac_p01__description_internal, celspac_pr_elspac_p01__examin, celspac_pr_elspac_p01__familyelspac, celspac_pr_zajemci_p01__description, celspac_pr_zajemci_p01__description_internal, celspac_pr_zajemci_p01__examin, celspac_pr_zajemci_p01__familyelspac, hapiee_p01__description, hapiee_p01__description_internal, hapiee_p01__examin, hapiee_p01__familyelspac, tng_p13__description, tng_p13__description_internal, tng_p13__expectedchildbirth, tng_p13__childbirth, tng_p13__location, tng_p13__hospitalid, tng_p13__childid, tng_p13__childcode, hapiee_p02__description, hapiee_p02__description_internal, hapiee_p02__examin, hapiee_p02__familyelspac, vulde__description, vulde__description_internal, vulde__examin, vulde__familyelspac, tng_4mi_p1__description, tng_4mi_p1__description_internal, tng_4mi_p1__expectedchildbirth, tng_4mi_p1__childbirth, tng_4mi_p1__location, tng_4mi_p1__hospitalid, tng_4mi_p1__childid, tng_4mi_p1__childcode, tng_4mi_p1__examin, parents_p01__description, parents_p01__description_internal, parents_p01__examin, parents_p01__familyelspac, parents_p02__description, parents_p02__description_internal, parents_p02__examin, parents_p02__familyelspac, ya_p04__description, ya_p04__description_internal, ya_p04__examin, ya_p04__familyelspac, tng_4mi_p2__description, tng_4mi_p2__description_internal, tng_4mi_p2__expectedchildbirth, tng_4mi_p2__childbirth, tng_4mi_p2__location, tng_4mi_p2__hospitalid, tng_4mi_p2__childid, tng_4mi_p2__childcode, tng_4mi_p2__examin, tng_children_p1__description, tng_children_p1__description_internal, tng_children_p1__location, tng_children_p1__examin, tng_children_p1__childcode, horpark__description, horpark__description_internal, horpark__patientgroup, horpark__patientpartner, horpark__biobankcode, horpark__locationbloodurine, horpark__locationlikvor FROM fdw_celspac_admin_core.stg_celspac_admin__subject s;
Date: 2025-12-07 23:33:55 Duration: 6ms Database: postgres
8 5ms 1 5ms 5ms 5ms SELECT "cls_id", "birthday of participant", "sample type", "tube type", "type of aliquot", "sex of participant", "time period of sampling", "date and time received in lab", "date when the sample was collected", "time when sample was collected", "date and time when sample was entered in LAS", "workplace", "amount", "date when the aliquot was created", "time when the aliquot was created", "barcode", "status", "other note", "date when was sample stored in freezer", "time_when_was_sample_stored_in_freezer", "time sample was outside of freezer [ms]", "time sample was outside of freezer [s]", "study_name", "cohort_abbreviation", "substudy", "fasting", "time of the last food", "notes of the sample", "sample_id", "value", "first morning urine", "specific gravity" FROM "prod_mart_las"."map_cls_id_barcode_all_aliquots";Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 21 1 5ms 5ms -
SELECT "cls_id", "birthday of participant", "sample type", "tube type", "type of aliquot", "sex of participant", "time period of sampling", "date and time received in lab", "date when the sample was collected", "time when sample was collected", "date and time when sample was entered in LAS", "workplace", "amount", "date when the aliquot was created", "time when the aliquot was created", "barcode", "status", "other note", "date when was sample stored in freezer", "time_when_was_sample_stored_in_freezer", "time sample was outside of freezer [ms]", "time sample was outside of freezer [s]", "study_name", "cohort_abbreviation", "substudy", "fasting", "time of the last food", "notes of the sample", "sample_id", "value", "first morning urine", "specific gravity" FROM "prod_mart_las"."map_cls_id_barcode_all_aliquots";
Date: 2025-12-07 22:20:46 Duration: 5ms Database: postgres
9 4ms 1 4ms 4ms 4ms SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, t.typtypmod, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif (a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind in ('r', 'p', 'v', 'f', 'm') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'prod_mart_las') c WHERE true ORDER BY nspname, c.relname, attnum;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 21 1 4ms 4ms -
SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, t.typtypmod, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif (a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind in ('r', 'p', 'v', 'f', 'm') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'prod_mart_las') c WHERE true ORDER BY nspname, c.relname, attnum;
Date: 2025-12-07 22:20:46 Duration: 4ms Database: postgres
10 3ms 1 3ms 3ms 3ms INSERT INTO src_cis_enum_public.mkn10_20140401_cz SELECT * FROM fdw_cis_enum_public.mkn10_20140401_cz;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 22 1 3ms 3ms -
INSERT INTO src_cis_enum_public.mkn10_20140401_cz SELECT * FROM fdw_cis_enum_public.mkn10_20140401_cz;
Date: 2025-12-07 23:34:02 Duration: 3ms Database: postgres
11 2ms 100 0ms 0ms 0ms select current_schema();Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 03 6 0ms 0ms 04 5 0ms 0ms 21 8 0ms 0ms 22 81 2ms 0ms -
select current_schema();
Date: 2025-12-07 23:48:40 Duration: 0ms Database: postgres
-
select current_schema();
Date: 2025-12-07 22:09:20 Duration: 0ms Database: postgres
-
select current_schema();
Date: 2025-12-07 23:37:48 Duration: 0ms Database: postgres
12 2ms 1 2ms 2ms 2ms INSERT INTO src_celspac_admin_core.pilot SELECT * FROM fdw_celspac_admin_core.pilot;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 22 1 2ms 2ms -
INSERT INTO src_celspac_admin_core.pilot SELECT * FROM fdw_celspac_admin_core.pilot;
Date: 2025-12-07 23:33:47 Duration: 2ms Database: postgres
13 2ms 1 2ms 2ms 2ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 347737276 AS oid, 1 AS attnum UNION ALL SELECT 347737276, 2 UNION ALL SELECT 347737276, 3 UNION ALL SELECT 347737276, 4 UNION ALL SELECT 347737276, 5 UNION ALL SELECT 347737276, 6 UNION ALL SELECT 347737276, 7 UNION ALL SELECT 347737276, 8 UNION ALL SELECT 347737276, 9 UNION ALL SELECT 347737276, 10 UNION ALL SELECT 347737276, 11 UNION ALL SELECT 347737276, 12 UNION ALL SELECT 347737276, 13 UNION ALL SELECT 347737276, 14 UNION ALL SELECT 347737276, 15 UNION ALL SELECT 347737276, 16 UNION ALL SELECT 347737276, 17 UNION ALL SELECT 347737276, 18 UNION ALL SELECT 347737276, 19 UNION ALL SELECT 347737276, 20 UNION ALL SELECT 347737276, 21 UNION ALL SELECT 347737276, 22 UNION ALL SELECT 347737276, 23 UNION ALL SELECT 347737276, 24 UNION ALL SELECT 347737276, 25 UNION ALL SELECT 347737276, 26 UNION ALL SELECT 347737276, 27 UNION ALL SELECT 347737276, 28 UNION ALL SELECT 347737276, 29 UNION ALL SELECT 347737276, 30 UNION ALL SELECT 347737276, 31 UNION ALL SELECT 347737276, 32) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 21 1 2ms 2ms -
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 347737276 AS oid, 1 AS attnum UNION ALL SELECT 347737276, 2 UNION ALL SELECT 347737276, 3 UNION ALL SELECT 347737276, 4 UNION ALL SELECT 347737276, 5 UNION ALL SELECT 347737276, 6 UNION ALL SELECT 347737276, 7 UNION ALL SELECT 347737276, 8 UNION ALL SELECT 347737276, 9 UNION ALL SELECT 347737276, 10 UNION ALL SELECT 347737276, 11 UNION ALL SELECT 347737276, 12 UNION ALL SELECT 347737276, 13 UNION ALL SELECT 347737276, 14 UNION ALL SELECT 347737276, 15 UNION ALL SELECT 347737276, 16 UNION ALL SELECT 347737276, 17 UNION ALL SELECT 347737276, 18 UNION ALL SELECT 347737276, 19 UNION ALL SELECT 347737276, 20 UNION ALL SELECT 347737276, 21 UNION ALL SELECT 347737276, 22 UNION ALL SELECT 347737276, 23 UNION ALL SELECT 347737276, 24 UNION ALL SELECT 347737276, 25 UNION ALL SELECT 347737276, 26 UNION ALL SELECT 347737276, 27 UNION ALL SELECT 347737276, 28 UNION ALL SELECT 347737276, 29 UNION ALL SELECT 347737276, 30 UNION ALL SELECT 347737276, 31 UNION ALL SELECT 347737276, 32) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2025-12-07 22:20:46 Duration: 2ms Database: postgres
14 2ms 100 0ms 0ms 0ms select pg_catalog.version();Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 03 6 0ms 0ms 04 5 0ms 0ms 21 8 0ms 0ms 22 81 1ms 0ms -
select pg_catalog.version();
Date: 2025-12-07 23:33:44 Duration: 0ms Database: postgres
-
select pg_catalog.version();
Date: 2025-12-07 04:48:59 Duration: 0ms Database: postgres
-
select pg_catalog.version();
Date: 2025-12-07 23:35:01 Duration: 0ms Database: postgres
15 2ms 1 2ms 2ms 2ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 347737270 AS oid, 1 AS attnum UNION ALL SELECT 347737270, 2 UNION ALL SELECT 347737270, 3 UNION ALL SELECT 347737270, 4 UNION ALL SELECT 347737270, 5 UNION ALL SELECT 347737270, 6 UNION ALL SELECT 347737270, 7 UNION ALL SELECT 347737270, 8 UNION ALL SELECT 347737270, 9 UNION ALL SELECT 347737270, 10 UNION ALL SELECT 347737270, 11 UNION ALL SELECT 347737270, 12 UNION ALL SELECT 347737270, 13 UNION ALL SELECT 347737270, 14 UNION ALL SELECT 347737270, 15 UNION ALL SELECT 347737270, 16 UNION ALL SELECT 347737270, 17 UNION ALL SELECT 347737270, 18 UNION ALL SELECT 347737270, 19 UNION ALL SELECT 347737270, 20 UNION ALL SELECT 347737270, 21 UNION ALL SELECT 347737270, 22 UNION ALL SELECT 347737270, 23 UNION ALL SELECT 347737270, 24 UNION ALL SELECT 347737270, 25 UNION ALL SELECT 347737270, 26 UNION ALL SELECT 347737270, 27 UNION ALL SELECT 347737270, 28 UNION ALL SELECT 347737270, 29 UNION ALL SELECT 347737270, 30) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 21 1 2ms 2ms -
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 347737270 AS oid, 1 AS attnum UNION ALL SELECT 347737270, 2 UNION ALL SELECT 347737270, 3 UNION ALL SELECT 347737270, 4 UNION ALL SELECT 347737270, 5 UNION ALL SELECT 347737270, 6 UNION ALL SELECT 347737270, 7 UNION ALL SELECT 347737270, 8 UNION ALL SELECT 347737270, 9 UNION ALL SELECT 347737270, 10 UNION ALL SELECT 347737270, 11 UNION ALL SELECT 347737270, 12 UNION ALL SELECT 347737270, 13 UNION ALL SELECT 347737270, 14 UNION ALL SELECT 347737270, 15 UNION ALL SELECT 347737270, 16 UNION ALL SELECT 347737270, 17 UNION ALL SELECT 347737270, 18 UNION ALL SELECT 347737270, 19 UNION ALL SELECT 347737270, 20 UNION ALL SELECT 347737270, 21 UNION ALL SELECT 347737270, 22 UNION ALL SELECT 347737270, 23 UNION ALL SELECT 347737270, 24 UNION ALL SELECT 347737270, 25 UNION ALL SELECT 347737270, 26 UNION ALL SELECT 347737270, 27 UNION ALL SELECT 347737270, 28 UNION ALL SELECT 347737270, 29 UNION ALL SELECT 347737270, 30) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2025-12-07 22:21:32 Duration: 2ms Database: postgres
16 2ms 1 2ms 2ms 2ms INSERT INTO src_celspac_admin_core.subject_inform_consent SELECT * FROM fdw_celspac_admin_core.subject_inform_consent;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 22 1 2ms 2ms -
INSERT INTO src_celspac_admin_core.subject_inform_consent SELECT * FROM fdw_celspac_admin_core.subject_inform_consent;
Date: 2025-12-07 23:33:52 Duration: 2ms Database: postgres
17 1ms 1 1ms 1ms 1ms INSERT INTO src_celspac_admin_core.subcohort SELECT * FROM fdw_celspac_admin_core.subcohort;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 22 1 1ms 1ms -
INSERT INTO src_celspac_admin_core.subcohort SELECT * FROM fdw_celspac_admin_core.subcohort;
Date: 2025-12-07 23:33:50 Duration: 1ms Database: postgres
18 1ms 1 1ms 1ms 1ms INSERT INTO src_celspac_admin_core.subject SELECT subject_state_code, sex_code, family_id, elspac_family_relationship_type_code, is_origin_elspac, family_code, NULL AS name, NULL AS surname, NULL AS titles_before, NULL AS titles_after, NULL AS description, NULL AS rc, tng_id, NULL::date birthdate, death_by, death_at, date_of_death, cause_of_death, NULL AS email, NULL AS phone_number, city, NULL AS street, NULL AS street_number, postal_code, country, NULL AS permanent_residence, NULL AS street_contact, NULL AS street_number_contact, city_contact, postal_code_contact, country_contact, is_archived, user_id, NULL AS maiden_name, test_proband, created_by, enrolled_by, created_at, enrolled_at, anonym_by, anonym_at, subject_id, tng_p08__expectedchildbirth, NULL::jsonb AS tng_p08__childbirth, tng_p08__location, tng_p08__hospitalid, tng_p08__childid, tng_p08__childcode, tng_p01__expectedchildbirth, NULL::jsonb AS tng_p01__childbirth, tng_p01__location, tng_p01__hospitalid, tng_p01__childid, tng_p01__childcode, tng_p02__expectedchildbirth, NULL::jsonb AS tng_p02__childbirth, tng_p02__location, tng_p02__hospitalid, tng_p02__childid, tng_p02__childcode, tng_p03__expectedchildbirth, NULL::jsonb AS tng_p03__childbirth, tng_p03__location, tng_p03__hospitalid, tng_p03__childid, tng_p03__childcode, tng_p04__expectedchildbirth, NULL::jsonb AS tng_p04__childbirth, tng_p04__location, tng_p04__hospitalid, tng_p04__childid, tng_p04__childcode, tng_p05__expectedchildbirth, NULL::jsonb AS tng_p05__childbirth, tng_p05__location, tng_p05__hospitalid, tng_p05__childid, tng_p05__childcode, tng_p06__expectedchildbirth, NULL::jsonb AS tng_p06__childbirth, tng_p06__location, tng_p06__hospitalid, tng_p06__childid, tng_p06__childcode, tng_p07__expectedchildbirth, NULL::jsonb AS tng_p07__childbirth, tng_p07__location, tng_p07__hospitalid, tng_p07__childid, tng_p07__childcode, tng_p09__expectedchildbirth, NULL::jsonb AS tng_p09__childbirth, tng_p09__location, tng_p09__hospitalid, tng_p09__childid, tng_p09__childcode, ya_p01__examin, ya_p01__familyelspac, ya_p02__examin, ya_p02__familyelspac, tng_p10__expectedchildbirth, NULL::jsonb AS tng_p10__childbirth, tng_p10__location, tng_p10__hospitalid, tng_p10__childid, tng_p10__childcode, hba_p01__examin, hba_p01__familyelspac, covid_p01__examin, covid_p01__familyelspac, tng_p11__expectedchildbirth, NULL::jsonb AS tng_p11__childbirth, tng_p11__location, tng_p11__hospitalid, tng_p11__childid, tng_p11__childcode, ya_p03__examin, ya_p03__familyelspac, tng_p12__expectedchildbirth, NULL::jsonb AS tng_p12__childbirth, tng_p12__location, tng_p12__hospitalid, tng_p12__childid, tng_p12__childcode, celspac_pr_elspac_p01__examin, celspac_pr_elspac_p01__familyelspac, celspac_pr_zajemci_p01__examin, celspac_pr_zajemci_p01__familyelspac, hapiee_p01__examin, hapiee_p01__familyelspac, tng_p13__expectedchildbirth, NULL::jsonb AS tng_p13__childbirth, tng_p13__location, tng_p13__hospitalid, tng_p13__childid, tng_p13__childcode, hapiee_p02__examin, hapiee_p02__familyelspac, vulde__examin, vulde__familyelspac, tng_4mi_p1__expectedchildbirth, NULL::jsonb AS tng_4mi_p1__childbirth, tng_4mi_p1__location, tng_4mi_p1__hospitalid, tng_4mi_p1__childid, tng_4mi_p1__childcode, tng_4mi_p1__examin, tng_4mi_p1__description, tng_4mi_p1__description_internal, parents_p01__description, parents_p01__description_internal, parents_p01__examin, parents_p01__familyelspac, parents_p02__description, parents_p02__description_internal, parents_p02__examin, parents_p02__familyelspac, tng_p01__description, tng_p02__description, tng_p03__description, tng_p04__description, tng_p05__description, tng_p06__description, tng_p07__description, tng_p08__description, tng_p09__description, tng_p10__description, tng_p11__description, tng_p12__description, tng_p13__description, tng_p01__description_internal, tng_p02__description_internal, tng_p03__description_internal, tng_p04__description_internal, tng_p05__description_internal, tng_p06__description_internal, tng_p07__description_internal, tng_p08__description_internal, tng_p09__description_internal, tng_p10__description_internal, tng_p11__description_internal, tng_p12__description_internal, tng_p13__description_internal, tng_children_p1__description, tng_children_p1__description_internal, tng_children_p1__location, tng_children_p1__examin, tng_children_p1__childcode, tng_4mi_p2__description, tng_4mi_p2__description_internal, tng_4mi_p2__expectedchildbirth, NULL::jsonb AS tng_4mi_p2__childbirth, tng_4mi_p2__location, tng_4mi_p2__hospitalid, tng_4mi_p2__childid, tng_4mi_p2__childcode, tng_4mi_p2__examin, ya_p04__description, ya_p04__description_internal, ya_p04__examin, ya_p04__familyelspac, horpark__description, horpark__description_internal, horpark__patientgroup, horpark__patientpartner, horpark__biobankcode, horpark__locationbloodurine, horpark__locationlikvor FROM fdw_celspac_admin_core.stg_celspac_admin__subject s;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 22 1 1ms 1ms -
INSERT INTO src_celspac_admin_core.subject SELECT subject_state_code, sex_code, family_id, elspac_family_relationship_type_code, is_origin_elspac, family_code, NULL AS name, NULL AS surname, NULL AS titles_before, NULL AS titles_after, NULL AS description, NULL AS rc, tng_id, NULL::date birthdate, death_by, death_at, date_of_death, cause_of_death, NULL AS email, NULL AS phone_number, city, NULL AS street, NULL AS street_number, postal_code, country, NULL AS permanent_residence, NULL AS street_contact, NULL AS street_number_contact, city_contact, postal_code_contact, country_contact, is_archived, user_id, NULL AS maiden_name, test_proband, created_by, enrolled_by, created_at, enrolled_at, anonym_by, anonym_at, subject_id, tng_p08__expectedchildbirth, NULL::jsonb AS tng_p08__childbirth, tng_p08__location, tng_p08__hospitalid, tng_p08__childid, tng_p08__childcode, tng_p01__expectedchildbirth, NULL::jsonb AS tng_p01__childbirth, tng_p01__location, tng_p01__hospitalid, tng_p01__childid, tng_p01__childcode, tng_p02__expectedchildbirth, NULL::jsonb AS tng_p02__childbirth, tng_p02__location, tng_p02__hospitalid, tng_p02__childid, tng_p02__childcode, tng_p03__expectedchildbirth, NULL::jsonb AS tng_p03__childbirth, tng_p03__location, tng_p03__hospitalid, tng_p03__childid, tng_p03__childcode, tng_p04__expectedchildbirth, NULL::jsonb AS tng_p04__childbirth, tng_p04__location, tng_p04__hospitalid, tng_p04__childid, tng_p04__childcode, tng_p05__expectedchildbirth, NULL::jsonb AS tng_p05__childbirth, tng_p05__location, tng_p05__hospitalid, tng_p05__childid, tng_p05__childcode, tng_p06__expectedchildbirth, NULL::jsonb AS tng_p06__childbirth, tng_p06__location, tng_p06__hospitalid, tng_p06__childid, tng_p06__childcode, tng_p07__expectedchildbirth, NULL::jsonb AS tng_p07__childbirth, tng_p07__location, tng_p07__hospitalid, tng_p07__childid, tng_p07__childcode, tng_p09__expectedchildbirth, NULL::jsonb AS tng_p09__childbirth, tng_p09__location, tng_p09__hospitalid, tng_p09__childid, tng_p09__childcode, ya_p01__examin, ya_p01__familyelspac, ya_p02__examin, ya_p02__familyelspac, tng_p10__expectedchildbirth, NULL::jsonb AS tng_p10__childbirth, tng_p10__location, tng_p10__hospitalid, tng_p10__childid, tng_p10__childcode, hba_p01__examin, hba_p01__familyelspac, covid_p01__examin, covid_p01__familyelspac, tng_p11__expectedchildbirth, NULL::jsonb AS tng_p11__childbirth, tng_p11__location, tng_p11__hospitalid, tng_p11__childid, tng_p11__childcode, ya_p03__examin, ya_p03__familyelspac, tng_p12__expectedchildbirth, NULL::jsonb AS tng_p12__childbirth, tng_p12__location, tng_p12__hospitalid, tng_p12__childid, tng_p12__childcode, celspac_pr_elspac_p01__examin, celspac_pr_elspac_p01__familyelspac, celspac_pr_zajemci_p01__examin, celspac_pr_zajemci_p01__familyelspac, hapiee_p01__examin, hapiee_p01__familyelspac, tng_p13__expectedchildbirth, NULL::jsonb AS tng_p13__childbirth, tng_p13__location, tng_p13__hospitalid, tng_p13__childid, tng_p13__childcode, hapiee_p02__examin, hapiee_p02__familyelspac, vulde__examin, vulde__familyelspac, tng_4mi_p1__expectedchildbirth, NULL::jsonb AS tng_4mi_p1__childbirth, tng_4mi_p1__location, tng_4mi_p1__hospitalid, tng_4mi_p1__childid, tng_4mi_p1__childcode, tng_4mi_p1__examin, tng_4mi_p1__description, tng_4mi_p1__description_internal, parents_p01__description, parents_p01__description_internal, parents_p01__examin, parents_p01__familyelspac, parents_p02__description, parents_p02__description_internal, parents_p02__examin, parents_p02__familyelspac, tng_p01__description, tng_p02__description, tng_p03__description, tng_p04__description, tng_p05__description, tng_p06__description, tng_p07__description, tng_p08__description, tng_p09__description, tng_p10__description, tng_p11__description, tng_p12__description, tng_p13__description, tng_p01__description_internal, tng_p02__description_internal, tng_p03__description_internal, tng_p04__description_internal, tng_p05__description_internal, tng_p06__description_internal, tng_p07__description_internal, tng_p08__description_internal, tng_p09__description_internal, tng_p10__description_internal, tng_p11__description_internal, tng_p12__description_internal, tng_p13__description_internal, tng_children_p1__description, tng_children_p1__description_internal, tng_children_p1__location, tng_children_p1__examin, tng_children_p1__childcode, tng_4mi_p2__description, tng_4mi_p2__description_internal, tng_4mi_p2__expectedchildbirth, NULL::jsonb AS tng_4mi_p2__childbirth, tng_4mi_p2__location, tng_4mi_p2__hospitalid, tng_4mi_p2__childid, tng_4mi_p2__childcode, tng_4mi_p2__examin, ya_p04__description, ya_p04__description_internal, ya_p04__examin, ya_p04__familyelspac, horpark__description, horpark__description_internal, horpark__patientgroup, horpark__patientpartner, horpark__biobankcode, horpark__locationbloodurine, horpark__locationlikvor FROM fdw_celspac_admin_core.stg_celspac_admin__subject s;
Date: 2025-12-07 23:33:57 Duration: 1ms Database: postgres
19 1ms 1 1ms 1ms 1ms INSERT INTO src_cladeis_public.cls_question_group SELECT * FROM fdw_cladeis_public.cls_question_group;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 22 1 1ms 1ms -
INSERT INTO src_cladeis_public.cls_question_group SELECT * FROM fdw_cladeis_public.cls_question_group;
Date: 2025-12-07 23:35:06 Duration: 1ms Database: postgres
20 1ms 1 1ms 1ms 1ms INSERT INTO src_celspac_admin_core.form_structure_version SELECT * FROM fdw_celspac_admin_core.form_structure_version;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 22 1 1ms 1ms -
INSERT INTO src_celspac_admin_core.form_structure_version SELECT * FROM fdw_celspac_admin_core.form_structure_version;
Date: 2025-12-07 23:33:59 Duration: 1ms Database: postgres
-
Events
Log levels
Key values
- 2,917,199 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 346 WARNING entries
- 22 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 346 Max number of times the same event was reported
- 368 Total events found
Rank Times reported Error 1 346 WARNING: there is already a transaction in progress
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 07 04 43 05 110 22 159 23 34 2 22 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 07 04 6 05 5 22 5 23 6