Test Status Update - October 2015

[writetoritu]

Please test the following tables:

• [x] Demographic
• [x] Encounter
• [x] Enrollment
• [x] Diagnosis
• [x] Dispensing
• [x] Condition
• [x] Procedure
• [x] Death_Cause
• [x] Death
• [x] Prescribing
• [x] Vital
• [x] Lab_result_CM

successfully tested on

• [x] CHOP
  • with tentative fix to vital query until CHOP's data is fixed https://github.com/PEDSnet/CHOP/issues/149
  • vital pk converted to serial and the logic to populate vitalid removed from ETL query
• [x] Colorado
  • encounter query fix: multiple discharge disposition found (data quality issue) - fixed using min function... also opened an issue https://github.com/PEDSnet/Colorado/issues/35
  • dispensing wont be generated as they dont have relevant records in drug exposure
• [x] Nemours
  • Nemours wont have any death_Cause or dispensing records (no relevant info in PEDSnet CDM)
• [x] Nationwide
  • no records would be generated for death_cause and dispensing
  • lab_Result_Cm being generated but not shown in log file
• [x] Seattle
  • no records would be generated for death_Cause, condition, dispensing
  • no record generated for lab result cm - because of a DQA issue - unexpected values for operator concept id field https://github.com/PEDSnet/Seattle/issues/33
• [ ] St Louis

[lcdavidson]

@writetoritu , I am working on Colorado.

A few of the tables like vitals appear to have no data in them:

I am investigtating

Beginning Execution of copy_mappings.sql
SET
COPY 177
        0.68 real         0.00 user         0.00 sys
Beginning Execution of Demographic_ETL.sql
INSERT 0 624637
       20.34 real         0.00 user         0.00 sys
Beginning Execution of Enrollment_ETL.sql
INSERT 0 624637
       22.22 real         0.00 user         0.00 sys
Beginning Execution of Death_ETL.sql
INSERT 0 1271
        0.57 real         0.00 user         0.00 sys
Beginning Execution of Death_Cause_ETL.sql
INSERT 0 155
        0.46 real         0.00 user         0.00 sys
Beginning Execution of Encounter_ETL.sql
ERROR:  duplicate key value violates unique constraint "xpk_encounter"
DETAIL:  Key (encounterid)=(100857378) already exists.
      249.02 real         0.00 user         0.00 sys
Beginning Execution of Condition_ETL.sql
INSERT 0 1068930
       42.97 real         0.00 user         0.00 sys
Beginning Execution of Diagnosis_ETL.sql
INSERT 0 0
        1.40 real         0.00 user         0.00 sys
Beginning Execution of Procedure_ETL.sql
INSERT 0 0
        0.39 real         0.00 user         0.00 sys
Beginning Execution of Dispensing_ETL.sql
INSERT 0 0
        4.57 real         0.00 user         0.00 sys
Beginning Execution of Prescribing_ETL.sql
INSERT 0 0
        2.36 real         0.00 user         0.00 sys
Beginning Execution of Vital_ETL.sql
ERROR:  insert or update on table "vital" violates foreign key constraint "fk_vital_encounterid"
DETAIL:  Key (encounterid)=(104358646) is not present in table "encounter".
      617.42 real         0.00 user         0.00 sys
Beginning Execution of Lab_Result_CM_ETL.sql
INSERT 0 0
        0.48 real         0.00 user         0.00 sys

[lcdavidson]

Nemours is running...

Beginning Execution of pcornetcdm_ddl.sql
SET
 search_path 
-------------
 pcornet_cdm
(1 row)

NOTICE:  table "version_history" does not exist, skipping
DROP TABLE
CREATE TABLE
INSERT 0 1
NOTICE:  table "condition" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "death" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "death_cause" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "demographic" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "diagnosis" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "dispensing" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "encounter" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "enrollment" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "harvest" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "lab_result_cm" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "pcornet_trial" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "prescribing" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "pro_cm" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "procedures" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "vital" does not exist, skipping
DROP TABLE
CREATE TABLE
INSERT 0 1
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
INSERT 0 1
0.00user 0.00system 0:00.70elapsed 1%CPU (0avgtext+0avgdata 3560maxresident)k
0inputs+0outputs (0major+1015minor)pagefaults 0swaps
Beginning Execution of cz_omop_pcornet_concept_map_ddl.sql
SET
NOTICE:  table "cz_omop_pcornet_concept_map" does not exist, skipping
DROP TABLE
CREATE TABLE
0.00user 0.00system 0:00.04elapsed 10%CPU (0avgtext+0avgdata 3512maxresident)k
0inputs+0outputs (0major+1003minor)pagefaults 0swaps
Beginning Execution of copy_mappings.sql
SET
0.00user 0.00system 0:00.03elapsed 11%CPU (0avgtext+0avgdata 3552maxresident)k
0inputs+0outputs (0major+1014minor)pagefaults 0swaps
Beginning Execution of Demographic_ETL.sql
INSERT 0 808958
0.00user 0.00system 0:39.70elapsed 0%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+8outputs (0major+1010minor)pagefaults 0swaps
Beginning Execution of Enrollment_ETL.sql
INSERT 0 808931
0.00user 0.00system 0:30.42elapsed 0%CPU (0avgtext+0avgdata 3544maxresident)k
0inputs+0outputs (0major+1012minor)pagefaults 0swaps
Beginning Execution of Death_ETL.sql
INSERT 0 1577
0.00user 0.00system 0:00.43elapsed 1%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1006minor)pagefaults 0swaps
Beginning Execution of Death_Cause_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.02elapsed 19%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1006minor)pagefaults 0swaps
Beginning Execution of Encounter_ETL.sql
INSERT 0 25204619
0.00user 0.00system 44:03.31elapsed 0%CPU (0avgtext+0avgdata 3556maxresident)k
0inputs+8outputs (0major+1015minor)pagefaults 0swaps
Beginning Execution of Condition_ETL.sql
INSERT 0 1961095
Beginning Execution of Diagnosis_ETL.sql
INSERT 0 17154842
Beginning Execution of Procedure_ETL.sql
INSERT 0 3996603
Beginning Execution of Dispensing_ETL.sql
INSERT 0 0
Beginning Execution of Prescribing_ETL.sql
INSERT 0 12941885
Beginning Execution of Vital_ETL.sql

[lcdavidson]

@writetoritu , should death_cause have zero inserts for Nemours?

dispensing is also zero for Nemours?

[writetoritu]

yes that's right - Nemours wont have any death_Cause or dispensing records

[lcdavidson]

ok. thanks.

[lcdavidson]

Seattle:

@writetoritu , could you review this output?

Beginning Execution of pcornetcdm_ddl.sql
SET
 search_path 
-------------
 pcornet_cdm
(1 row)

NOTICE:  table "version_history" does not exist, skipping
DROP TABLE
CREATE TABLE
INSERT 0 1
NOTICE:  table "condition" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "death" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "death_cause" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "demographic" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "diagnosis" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "dispensing" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "encounter" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "enrollment" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "harvest" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "lab_result_cm" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "pcornet_trial" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "prescribing" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "pro_cm" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "procedures" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "vital" does not exist, skipping
DROP TABLE
CREATE TABLE
INSERT 0 1
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
INSERT 0 1
0.00user 0.00system 0:00.53elapsed 2%CPU (0avgtext+0avgdata 3564maxresident)k
0inputs+0outputs (0major+1016minor)pagefaults 0swaps
Beginning Execution of cz_omop_pcornet_concept_map_ddl.sql
SET
NOTICE:  table "cz_omop_pcornet_concept_map" does not exist, skipping
DROP TABLE
CREATE TABLE
0.00user 0.00system 0:00.04elapsed 10%CPU (0avgtext+0avgdata 3512maxresident)k
0inputs+0outputs (0major+1003minor)pagefaults 0swaps
Beginning Execution of copy_mappings.sql
SET
0.00user 0.00system 0:00.03elapsed 9%CPU (0avgtext+0avgdata 3552maxresident)k
0inputs+0outputs (0major+1015minor)pagefaults 0swaps
Beginning Execution of Demographic_ETL.sql
INSERT 0 378198
0.00user 0.00system 0:12.28elapsed 0%CPU (0avgtext+0avgdata 3536maxresident)k
0inputs+0outputs (0major+1009minor)pagefaults 0swaps
Beginning Execution of Enrollment_ETL.sql
INSERT 0 378198
0.00user 0.00system 0:13.49elapsed 0%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+0outputs (0major+1010minor)pagefaults 0swaps
Beginning Execution of Death_ETL.sql
INSERT 0 1085
0.00user 0.00system 0:00.31elapsed 1%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1006minor)pagefaults 0swaps
Beginning Execution of Death_Cause_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.04elapsed 12%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1006minor)pagefaults 0swaps
Beginning Execution of Encounter_ETL.sql
INSERT 0 4562424
0.00user 0.00system 5:01.81elapsed 0%CPU (0avgtext+0avgdata 3556maxresident)k
0inputs+8outputs (0major+1015minor)pagefaults 0swaps
Beginning Execution of Condition_ETL.sql
INSERT 0 0
Beginning Execution of Diagnosis_ETL.sql
INSERT 0 3797814
Beginning Execution of Procedure_ETL.sql
INSERT 0 440412
Beginning Execution of Dispensing_ETL.sql
INSERT 0 0
Beginning Execution of Prescribing_ETL.sql
INSERT 0 1019503
Beginning Execution of Vital_ETL.sql
INSERT 0 4279465
Beginning Execution of Lab_Result_CM_ETL.sql
INSERT 0 0

[writetoritu]

For Seattle - there wouldn't be any records for death_cause, condition and dispensing. I will look into why lab_result_cm wasn't generated.

Any updates on Nationwide?

Thanks!

[lcdavidson]

@writetoritu

Nationwide...

Beginning Execution of pcornetcdm_ddl.sql
SET
 search_path 
-------------
 pcornet_cdm
(1 row)

NOTICE:  table "version_history" does not exist, skipping
DROP TABLE
CREATE TABLE
INSERT 0 1
NOTICE:  table "condition" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "death" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "death_cause" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "demographic" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "diagnosis" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "dispensing" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "encounter" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "enrollment" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "harvest" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "lab_result_cm" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "pcornet_trial" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "prescribing" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "pro_cm" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "procedures" does not exist, skipping
DROP TABLE
CREATE TABLE
NOTICE:  table "vital" does not exist, skipping
DROP TABLE
CREATE TABLE
INSERT 0 1
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
INSERT 0 1
0.00user 0.01system 0:00.11elapsed 11%CPU (0avgtext+0avgdata 3560maxresident)k
0inputs+8outputs (0major+1013minor)pagefaults 0swaps
Beginning Execution of cz_omop_pcornet_concept_map_ddl.sql
SET
NOTICE:  table "cz_omop_pcornet_concept_map" does not exist, skipping
DROP TABLE
CREATE TABLE
0.00user 0.00system 0:00.07elapsed 6%CPU (0avgtext+0avgdata 3512maxresident)k
0inputs+0outputs (0major+1002minor)pagefaults 0swaps
Beginning Execution of copy_mappings.sql
SET
0.00user 0.00system 0:00.04elapsed 12%CPU (0avgtext+0avgdata 3552maxresident)k
0inputs+0outputs (0major+1012minor)pagefaults 0swaps
Beginning Execution of Demographic_ETL.sql
INSERT 0 573900
0.00user 0.00system 0:18.05elapsed 0%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+8outputs (0major+1009minor)pagefaults 0swaps
Beginning Execution of Enrollment_ETL.sql
INSERT 0 573900
0.00user 0.00system 0:20.77elapsed 0%CPU (0avgtext+0avgdata 3536maxresident)k
0inputs+0outputs (0major+1007minor)pagefaults 0swaps
Beginning Execution of Death_ETL.sql
INSERT 0 1057
0.00user 0.00system 0:00.09elapsed 5%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1004minor)pagefaults 0swaps
Beginning Execution of Death_Cause_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.03elapsed 12%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1004minor)pagefaults 0swaps
Beginning Execution of Encounter_ETL.sql
INSERT 0 8036817
0.00user 0.00system 11:54.38elapsed 0%CPU (0avgtext+0avgdata 3556maxresident)k
0inputs+8outputs (0major+1012minor)pagefaults 0swaps
Beginning Execution of Condition_ETL.sql
INSERT 0 1237196
0.00user 0.00system 1:24.62elapsed 0%CPU (0avgtext+0avgdata 3536maxresident)k
0inputs+8outputs (0major+1007minor)pagefaults 0swaps
Beginning Execution of Diagnosis_ETL.sql
INSERT 0 10767685
0.00user 0.00system 19:47.17elapsed 0%CPU (0avgtext+0avgdata 3544maxresident)k
0inputs+8outputs (0major+1009minor)pagefaults 0swaps
Beginning Execution of Procedure_ETL.sql
INSERT 0 8060399
0.00user 0.00system 8:05.92elapsed 0%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+8outputs (0major+1008minor)pagefaults 0swaps
Beginning Execution of Dispensing_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.05elapsed 14%CPU (0avgtext+0avgdata 3544maxresident)k
0inputs+0outputs (0major+1009minor)pagefaults 0swaps
Beginning Execution of Prescribing_ETL.sql
INSERT 0 1267
0.00user 0.00system 0:00.17elapsed 2%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+0outputs (0major+1008minor)pagefaults 0swaps
Beginning Execution of Vital_ETL.sql
INSERT 0 11989079
0.00user 0.00system 18:37.79elapsed 0%CPU (0avgtext+0avgdata 3552maxresident)k
8inputs+8outputs (0major+1011minor)pagefaults 0swaps
Beginning Execution of Lab_Result_CM_ETL.sql

[writetoritu]

thanks Lemar! Nationwide looks good except that I dont see a complete message for Lab_Result_CM_ETL?

[lcdavidson]

@writetoritu , yes, that Lab_Result_CM_ETL query seems to run with out end for nationwide for some reason... I am looking into it.

[lcdavidson]

@writetoritu and @murphyke , here is the output from the St. Louis transformation log which I just ran:

Beginning Execution of pcornetcdm_ddl.sql
SET
 search_path 
-------------
 pcornet_cdm
(1 row)

DROP TABLE
CREATE TABLE
INSERT 0 1
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
NOTICE:  drop cascades to 10 other objects
DETAIL:  drop cascades to constraint fk_diagnosis_patid on table diagnosis
drop cascades to constraint fk_dispensing_patid on table dispensing
drop cascades to constraint fk_encounter_patid on table encounter
drop cascades to constraint fk_enrollment_patid on table enrollment
drop cascades to constraint fk_lab_result_cm_patid on table lab_result_cm
drop cascades to constraint fk_pcornet_trial_patid on table pcornet_trial
drop cascades to constraint fk_prescribing_patid on table prescribing
drop cascades to constraint fk_pro_cm_patid on table pro_cm
drop cascades to constraint fk_procedures_patid on table procedures
drop cascades to constraint fk_vital_patid on table vital
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
NOTICE:  drop cascades to 5 other objects
DETAIL:  drop cascades to constraint fk_lab_result_cm_encounterid on table lab_result_cm
drop cascades to constraint fk_prescribing_encounterid on table prescribing
drop cascades to constraint fk_pro_cm_encounterid on table pro_cm
drop cascades to constraint fk_procedures_encounterid on table procedures
drop cascades to constraint fk_vital_encounterid on table vital
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
INSERT 0 1
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
INSERT 0 1
0.00user 0.00system 0:00.82elapsed 1%CPU (0avgtext+0avgdata 3560maxresident)k
0inputs+16outputs (0major+1015minor)pagefaults 0swaps
Beginning Execution of cz_omop_pcornet_concept_map_ddl.sql
SET
DROP TABLE
CREATE TABLE
0.00user 0.00system 0:00.11elapsed 3%CPU (0avgtext+0avgdata 3516maxresident)k
0inputs+0outputs (0major+1004minor)pagefaults 0swaps
Beginning Execution of copy_mappings.sql
SET
0.00user 0.00system 0:00.04elapsed 12%CPU (0avgtext+0avgdata 3552maxresident)k
0inputs+0outputs (0major+1014minor)pagefaults 0swaps
Beginning Execution of Demographic_ETL.sql
INSERT 0 185385
0.00user 0.00system 0:06.14elapsed 0%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+8outputs (0major+1010minor)pagefaults 0swaps
Beginning Execution of Enrollment_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.03elapsed 15%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+0outputs (0major+1010minor)pagefaults 0swaps
Beginning Execution of Death_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.02elapsed 15%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1007minor)pagefaults 0swaps
Beginning Execution of Death_Cause_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.02elapsed 15%CPU (0avgtext+0avgdata 3524maxresident)k
0inputs+0outputs (0major+1006minor)pagefaults 0swaps
Beginning Execution of Encounter_ETL.sql
INSERT 0 654104
0.00user 0.00system 0:45.63elapsed 0%CPU (0avgtext+0avgdata 3556maxresident)k
0inputs+8outputs (0major+1014minor)pagefaults 0swaps
Beginning Execution of Condition_ETL.sql
INSERT 0 359532
0.00user 0.00system 0:23.16elapsed 0%CPU (0avgtext+0avgdata 3536maxresident)k
0inputs+0outputs (0major+1009minor)pagefaults 0swaps
Beginning Execution of Diagnosis_ETL.sql
INSERT 0 1024906
0.00user 0.00system 1:45.56elapsed 0%CPU (0avgtext+0avgdata 3544maxresident)k
0inputs+8outputs (0major+1012minor)pagefaults 0swaps
Beginning Execution of Procedure_ETL.sql
INSERT 0 5071
0.00user 0.00system 0:00.81elapsed 0%CPU (0avgtext+0avgdata 3540maxresident)k
0inputs+0outputs (0major+1010minor)pagefaults 0swaps
Beginning Execution of Dispensing_ETL.sql
INSERT 0 0
0.00user 0.00system 0:00.09elapsed 4%CPU (0avgtext+0avgdata 3544maxresident)k
0inputs+0outputs (0major+1012minor)pagefaults 0swaps
Beginning Execution of Prescribing_ETL.sql
INSERT 0 123340
0.00user 0.00system 0:08.92elapsed 0%CPU (0avgtext+0avgdata 3544maxresident)k
0inputs+0outputs (0major+1011minor)pagefaults 0swaps
Beginning Execution of Vital_ETL.sql
INSERT 0 292113
0.00user 0.00system 0:21.63elapsed 0%CPU (0avgtext+0avgdata 3560maxresident)k
0inputs+0outputs (0major+1015minor)pagefaults 0swaps
Beginning Execution of Lab_Result_CM_ETL.sql
INSERT 0 1193559
0.00user 0.00system 1:18.23elapsed 0%CPU (0avgtext+0avgdata 3532maxresident)k
0inputs+8outputs (0major+1008minor)pagefaults 0swaps