2023-09-15 08:55:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:55:49 [Main thread] INFO Achilles achilles CDM Version 5.4 found in cdm_source table. 2023-09-15 08:55:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:55:49 [Main thread] INFO Achilles achilles Beginning single-threaded execution 2023-09-15 08:55:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:55:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0397 secs 2023-09-15 08:55:49 [Main thread] INFO DatabaseConnector insertTable.default Inserting data took 0.0425 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Executing multiple queries. This could take a while 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 0 (Source name) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0272 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 0 (0.031079 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 1 (Number of persons) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0173 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1 (0.020870 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 2 (Number of persons by gender) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0215 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2 (0.025120 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 3 (Number of persons by year of birth) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0179 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 3 (0.021528 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 4 (Number of persons by race) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0263 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 4 (0.030360 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 5 (Number of persons by ethnicity) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0178 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 5 (0.021306 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 10 (Number of all persons by year of birth by gender) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0272 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 10 (0.031651 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 11 (Number of non-deceased persons by year of birth by gender) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0208 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 11 (0.024671 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 12 (Number of persons by race and ethnicity) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0159 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 12 (0.019552 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 101 (Number of persons by age, with age at first observation period) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0206 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 101 (0.024336 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 102 (Number of persons by gender by age, with age at first observation period) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.026 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 102 (0.029705 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 103 (Distribution of age at first observation period) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0336 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 103 (0.037546 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 104 (Distribution of age at first observation period by gender) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0515 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 104 (0.055394 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 105 (Length of observation (days) of first observation period) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.111 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 105 (0.116594 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 106 (Length of observation (days) of first observation period by gender) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0934 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 106 (0.098576 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 107 (Length of observation (days) of first observation period by age decile) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.082 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 107 (0.085860 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 108 (Number of persons by length of observation period, in 30d increments) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0264 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 108 (0.030644 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 109 (Number of persons with continuous observation in each year) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0354 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 109 (0.039013 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 110 (Number of persons with continuous observation in each month) -- START 2023-09-15 08:55:55 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0277 secs 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 110 (0.031481 secs) 2023-09-15 08:55:55 [Main thread] INFO Achilles achilles Analysis 111 (Number of persons by observation period start month) -- START 2023-09-15 08:55:56 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0169 secs 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 111 (0.020649 secs) 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles Analysis 112 (Number of persons by observation period end month) -- START 2023-09-15 08:55:56 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0245 secs 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 112 (0.032192 secs) 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles Analysis 113 (Number of persons by number of observation periods) -- START 2023-09-15 08:55:56 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0223 secs 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 113 (0.026179 secs) 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles Analysis 116 (Number of persons with at least one day of observation in each year by gender and age decile) -- START 2023-09-15 08:55:56 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0579 secs 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 116 (0.061594 secs) 2023-09-15 08:55:56 [Main thread] INFO Achilles achilles Analysis 117 (Number of persons with at least one day of observation in each month) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 4.35 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 117 (4.349949 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 119 (Number of observation period records by period_type_concept_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0183 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 119 (0.021911 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 200 (Number of persons with at least one visit occurrence, by visit_concept_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.028 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 200 (0.031618 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 201 (Number of visit occurrence records, by visit_concept_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.024 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 201 (0.027890 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 202 (Number of persons by visit occurrence start month, by visit_concept_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0266 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 202 (0.030497 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 203 (Number of distinct visit occurrence concepts per person) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.058 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 203 (0.061716 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 204 (Number of persons with at least one visit occurrence, by visit_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0639 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 204 (0.067871 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 206 (Distribution of age by visit_concept_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0659 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 206 (0.076159 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 207 (Number of visit records with invalid person_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0229 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 207 (0.026659 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 209 (Number of visit records with invalid care_site_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0201 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 209 (0.023881 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 210 (Number of visit_occurrence records outside a valid observation period) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0168 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 210 (0.020864 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 212 (Number of persons with at least one visit occurrence, by calendar year by gender by age decile) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0301 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 212 (0.033818 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 213 (Distribution of length of stay by visit_concept_id) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0438 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 213 (0.047400 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 220 (Number of visit occurrence records by visit occurrence start month) -- START 2023-09-15 08:56:00 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0237 secs 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 220 (0.027518 secs) 2023-09-15 08:56:00 [Main thread] INFO Achilles achilles Analysis 221 (Number of persons by visit start year) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0232 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 221 (0.027056 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 225 (Number of visit_occurrence records by visit_source_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0287 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 225 (0.032802 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 226 (Number of records by domain by visit_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.25 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 226 (0.253673 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 300 (Number of providers) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0141 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 300 (0.018244 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 301 (Number of providers by specialty concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0161 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 301 (0.021528 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 303 (Number of providers records by specialty_concept_id and visit_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0154 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 303 (0.019455 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 325 (Number of provider records by specialty_source_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0111 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 325 (0.015868 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 400 (Number of persons with at least one condition occurrence, by condition_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0107 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 400 (0.014522 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 401 (Number of condition occurrence records, by condition_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0164 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 401 (0.019960 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 402 (Number of persons by condition occurrence start month, by condition_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0159 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 402 (0.019518 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 403 (Number of distinct condition occurrence concepts per person) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0282 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 403 (0.032155 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 404 (Number of persons with at least one condition occurrence, by condition_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0151 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 404 (0.019843 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 405 (Number of condition occurrence records, by condition_concept_id by condition_type_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0148 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 405 (0.018612 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 406 (Distribution of age by condition_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.05 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 406 (0.053742 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 414 (Number of condition occurrence records, by condition_status_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0259 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 414 (0.031509 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 415 (Number of condition occurrence records, by condition_type_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0131 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 415 (0.017094 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 416 (Number of condition occurrence records, by condition_status_concept_id, condition_type_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0144 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 416 (0.018849 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 420 (Number of condition occurrence records by condition occurrence start month) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0163 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 420 (0.019892 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 425 (Number of condition_occurrence records by condition_source_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0132 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 425 (0.023608 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 500 (Number of persons with death, by cause_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0222 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 500 (0.027941 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 501 (Number of records of death, by cause_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0147 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 501 (0.018158 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 502 (Number of persons by death month) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0244 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 502 (0.028001 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 504 (Number of persons with a death, by calendar year by gender by age decile) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0189 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 504 (0.022403 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 505 (Number of death records, by death_type_concept_id) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0208 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 505 (0.024438 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 506 (Distribution of age at death by gender) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0332 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 506 (0.042297 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 511 (Distribution of time from death to last condition) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0275 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 511 (0.031153 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 512 (Distribution of time from death to last drug) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0299 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 512 (0.033808 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 513 (Distribution of time from death to last visit) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0298 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 513 (0.033618 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 514 (Distribution of time from death to last procedure) -- START 2023-09-15 08:56:01 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0274 secs 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 514 (0.030906 secs) 2023-09-15 08:56:01 [Main thread] INFO Achilles achilles Analysis 515 (Distribution of time from death to last observation) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0364 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 515 (0.039901 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 525 (Number of death records by cause_source_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.012 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 525 (0.017589 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 600 (Number of persons with at least one procedure occurrence, by procedure_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.012 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 600 (0.015490 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 601 (Number of procedure occurrence records, by procedure_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0108 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 601 (0.014647 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 602 (Number of persons by procedure occurrence start month, by procedure_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0119 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 602 (0.015618 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 603 (Number of distinct procedure occurrence concepts per person) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0325 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 603 (0.039951 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 604 (Number of persons with at least one procedure occurrence, by procedure_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0152 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 604 (0.022336 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 605 (Number of procedure occurrence records, by procedure_concept_id by procedure_type_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0229 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 605 (0.026584 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 606 (Distribution of age by procedure_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0673 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 606 (0.070951 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 620 (Number of procedure occurrence records by procedure occurrence start month) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.011 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 620 (0.014898 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 625 (Number of procedure_occurrence records by procedure_source_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0136 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 625 (0.017055 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 630 (Number of procedure_occurrence records inside a valid observation period) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0204 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 630 (0.023946 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 691 (Percentage of total persons that have at least x procedures) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0123 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 691 (0.016029 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 700 (Number of persons with at least one drug exposure, by drug_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0117 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 700 (0.015266 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 701 (Number of drug exposure records, by drug_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0251 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 701 (0.029207 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 702 (Number of persons by drug exposure start month, by drug_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.012 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 702 (0.015597 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 703 (Number of distinct drug exposure concepts per person) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0302 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 703 (0.034390 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 704 (Number of persons with at least one drug exposure, by drug_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.012 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 704 (0.015778 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 705 (Number of drug exposure records, by drug_concept_id by drug_type_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0162 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 705 (0.021631 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 706 (Distribution of age by drug_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0575 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 706 (0.061748 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 715 (Distribution of days_supply by drug_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0371 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 715 (0.040735 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 716 (Distribution of refills by drug_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0451 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 716 (0.048909 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 717 (Distribution of quantity by drug_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0348 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 717 (0.038618 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 720 (Number of drug exposure records by drug exposure start month) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0157 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 720 (0.036271 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 725 (Number of drug_exposure records by drug_source_concept_id) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0112 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 725 (0.014761 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 791 (Percentage of total persons that have at least x drug exposures) -- START 2023-09-15 08:56:02 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0207 secs 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 791 (0.024380 secs) 2023-09-15 08:56:02 [Main thread] INFO Achilles achilles Analysis 800 (Number of persons with at least one observation occurrence, by observation_concept_id) -- START 2023-09-15 08:56:03 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.345 secs 2023-09-15 08:56:03 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 800 (0.348980 secs) 2023-09-15 08:56:03 [Main thread] INFO Achilles achilles Analysis 801 (Number of observation occurrence records, by observation_concept_id) -- START 2023-09-15 08:56:03 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.16 secs 2023-09-15 08:56:03 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 801 (0.164284 secs) 2023-09-15 08:56:03 [Main thread] INFO Achilles achilles Analysis 802 (Number of persons by observation occurrence start month, by observation_concept_id) -- START 2023-09-15 08:56:03 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.544 secs 2023-09-15 08:56:03 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 802 (0.548011 secs) 2023-09-15 08:56:03 [Main thread] INFO Achilles achilles Analysis 803 (Number of distinct observation occurrence concepts per person) -- START 2023-09-15 08:56:04 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.412 secs 2023-09-15 08:56:04 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 803 (0.415821 secs) 2023-09-15 08:56:04 [Main thread] INFO Achilles achilles Analysis 804 (Number of persons with at least one observation occurrence, by observation_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:04 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.654 secs 2023-09-15 08:56:04 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 804 (0.658834 secs) 2023-09-15 08:56:04 [Main thread] INFO Achilles achilles Analysis 805 (Number of observation occurrence records, by observation_concept_id by observation_type_concept_id) -- START 2023-09-15 08:56:05 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.178 secs 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 805 (0.181381 secs) 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles Analysis 806 (Distribution of age by observation_concept_id) -- START 2023-09-15 08:56:05 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.681 secs 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 806 (0.684355 secs) 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles Analysis 807 (Number of observation occurrence records, by observation_concept_id and unit_concept_id) -- START 2023-09-15 08:56:05 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.182 secs 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 807 (0.185861 secs) 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles Analysis 814 (Number of observation records with no value (numeric, string, or concept)) -- START 2023-09-15 08:56:05 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0499 secs 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 814 (0.054137 secs) 2023-09-15 08:56:05 [Main thread] INFO Achilles achilles Analysis 815 (Distribution of numeric values, by observation_concept_id and unit_concept_id) -- START 2023-09-15 08:56:07 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 1.03 secs 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 815 (1.037083 secs) 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles Analysis 820 (Number of observation records by observation start month) -- START 2023-09-15 08:56:07 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.25 secs 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 820 (0.253950 secs) 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles Analysis 822 (Number of observation records, by observation_concept_id and value_as_concept_id) -- START 2023-09-15 08:56:07 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.173 secs 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 822 (0.176810 secs) 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles Analysis 823 (Number of observation records, by observation_concept_id and qualifier_concept_id) -- START 2023-09-15 08:56:07 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.183 secs 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 823 (0.186936 secs) 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles Analysis 825 (Number of observation records by observation_source_concept_id) -- START 2023-09-15 08:56:07 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.154 secs 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 825 (0.157883 secs) 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles Analysis 826 (Number of observation records by value_as_concept_id) -- START 2023-09-15 08:56:07 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.167 secs 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 826 (0.170882 secs) 2023-09-15 08:56:07 [Main thread] INFO Achilles achilles Analysis 827 (Number of observation records by unit_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.143 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 827 (0.146689 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 891 (Percentage of total persons that have at least x observations) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.282 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 891 (0.285832 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 900 (Number of persons with at least one drug era, by drug_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0166 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 900 (0.020545 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 901 (Number of drug era records, by drug_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0145 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 901 (0.018120 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 902 (Number of persons by drug era start month, by drug_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0125 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 902 (0.016204 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 903 (Number of distinct drug era concepts per person) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0347 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 903 (0.038244 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 904 (Number of persons with at least one drug era, by drug_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0117 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 904 (0.015384 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 906 (Distribution of age by drug_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0559 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 906 (0.059721 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 907 (Distribution of drug era length, by drug_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0303 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 907 (0.034567 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 920 (Number of drug era records by drug era start month) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0129 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 920 (0.017066 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1000 (Number of persons with at least one condition era, by condition_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0125 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1000 (0.016211 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1001 (Number of condition era records, by condition_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0113 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1001 (0.015486 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1002 (Number of persons by condition era start month, by condition_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0137 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1002 (0.017865 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1003 (Number of distinct condition era concepts per person) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0373 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1003 (0.041754 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1004 (Number of persons with at least one condition era, by condition_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0255 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1004 (0.029487 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1006 (Distribution of age by condition_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0424 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1006 (0.046013 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1007 (Distribution of condition era length, by condition_concept_id) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0297 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1007 (0.035340 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1020 (Number of condition era records by condition era start month) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0116 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1020 (0.015390 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1100 (Number of persons by location 3-digit zip) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0129 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1100 (0.016431 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1101 (Number of persons by location state) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0123 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1101 (0.015811 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1102 (Number of care sites by location 3-digit zip) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0125 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1102 (0.016487 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1103 (Number of care sites by location state) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0114 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1103 (0.015015 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1200 (Number of persons by place of service) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0113 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1200 (0.014915 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1201 (Number of visits by place of service) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0128 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1201 (0.016646 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1202 (Number of care sites by place of service) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0133 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1202 (0.016885 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1203 (Number of visits by place of service discharge type) -- START 2023-09-15 08:56:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0127 secs 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1203 (0.016155 secs) 2023-09-15 08:56:08 [Main thread] INFO Achilles achilles Analysis 1300 (Number of persons with at least one visit detail, by visit_detail_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0176 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1300 (0.021280 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1301 (Number of visit detail records, by visit_detail_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0235 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1301 (0.027506 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1302 (Number of persons by visit detail start month, by visit_detail_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0118 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1302 (0.015429 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1303 (Number of distinct visit detail concepts per person) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0372 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1303 (0.051083 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1304 (Number of persons with at least one visit detail, by visit_detail_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0122 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1304 (0.015656 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1306 (Distribution of age by visit_detail_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0344 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1306 (0.038096 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1312 (Number of persons with at least one visit detail, by calendar year by gender by age decile) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.011 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1312 (0.015220 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1313 (Distribution of length of stay by visit_detail_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0317 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1313 (0.035420 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1320 (Number of visit detail records by visit detail start month) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0134 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1320 (0.017043 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1321 (Number of persons by visit start year) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0109 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1321 (0.014492 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1325 (Number of visit_detail records by visit_detail_source_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.011 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1325 (0.014513 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1326 (Number of records by domain by visit_detail_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.182 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1326 (0.185337 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1406 (Length of payer plan (days) of first payer plan period by gender) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0266 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1406 (0.030746 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1407 (Length of payer plan (days) of first payer plan period by age decile) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0348 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1407 (0.039017 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1408 (Number of persons by length of payer plan period, in 30d increments) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0119 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1408 (0.015494 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1409 (Number of persons with continuous payer plan in each year) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0255 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1409 (0.029078 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1410 (Number of persons with continuous payer plan in each month) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0362 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1410 (0.039846 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1411 (Number of persons by payer plan period start month) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0163 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1411 (0.019790 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1412 (Number of persons by payer plan period end month) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0106 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1412 (0.014347 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1413 (Number of persons by number of payer plan periods) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0113 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1413 (0.014833 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1425 (Number of payer_plan_period records by payer_source_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0155 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1425 (0.019306 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1800 (Number of persons with at least one measurement occurrence, by measurement_concept_id) -- START 2023-09-15 08:56:09 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.236 secs 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1800 (0.239610 secs) 2023-09-15 08:56:09 [Main thread] INFO Achilles achilles Analysis 1801 (Number of measurement occurrence records, by measurement_concept_id) -- START 2023-09-15 08:56:10 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0991 secs 2023-09-15 08:56:10 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1801 (0.103747 secs) 2023-09-15 08:56:10 [Main thread] INFO Achilles achilles Analysis 1802 (Number of persons by measurement occurrence start month, by measurement_concept_id) -- START 2023-09-15 08:56:10 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.355 secs 2023-09-15 08:56:10 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1802 (0.358633 secs) 2023-09-15 08:56:10 [Main thread] INFO Achilles achilles Analysis 1803 (Number of distinct mesurement occurrence concepts per person) -- START 2023-09-15 08:56:10 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.261 secs 2023-09-15 08:56:10 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1803 (0.265077 secs) 2023-09-15 08:56:10 [Main thread] INFO Achilles achilles Analysis 1804 (Number of persons with at least one mesurement occurrence, by measurement_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:56:11 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.413 secs 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1804 (0.416586 secs) 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles Analysis 1805 (Number of measurement occurrence records, by measurement_concept_id by measurement_type_concept_id) -- START 2023-09-15 08:56:11 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.119 secs 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1805 (0.123074 secs) 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles Analysis 1806 (Distribution of age by measurement_concept_id) -- START 2023-09-15 08:56:11 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.505 secs 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1806 (0.509061 secs) 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles Analysis 1807 (Number of measurement occurrence records, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 08:56:11 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.118 secs 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1807 (0.121846 secs) 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles Analysis 1811 (Number of measurement records with a valid value (with a mapped, non-null value_as_number)) -- START 2023-09-15 08:56:11 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0886 secs 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1811 (0.093859 secs) 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles Analysis 1814 (Number of measurement records with no value (numeric, string, or concept)) -- START 2023-09-15 08:56:11 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.037 secs 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1814 (0.040652 secs) 2023-09-15 08:56:11 [Main thread] INFO Achilles achilles Analysis 1815 (Distribution of numeric values, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 08:58:34 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 2.37 mins 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1815 (2.374278 mins) 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles Analysis 1816 (Distribution of low range, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 08:58:34 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.118 secs 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1816 (0.121597 secs) 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles Analysis 1817 (Distribution of high range, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 08:58:34 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.117 secs 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1817 (0.120629 secs) 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles Analysis 1818 (Number of measurement records below/within/above normal range, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 08:58:34 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.058 secs 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1818 (0.061524 secs) 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles Analysis 1819 (Number of measurement records, by measurement_concept_id, with a valid value (with a mapped, non-null value_as_number)) -- START 2023-09-15 08:58:34 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.111 secs 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1819 (0.115585 secs) 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles Analysis 1820 (Number of measurement records by measurement start month) -- START 2023-09-15 08:58:34 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.16 secs 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1820 (0.163900 secs) 2023-09-15 08:58:34 [Main thread] INFO Achilles achilles Analysis 1821 (Number of measurement records with no numeric value) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0357 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1821 (0.039686 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 1822 (Number of measurement records, by measurement_concept_id and value_as_concept_id) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.111 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1822 (0.115348 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 1823 (Number of measurement records, by measurement_concept_id and operator_concept_id) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.112 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1823 (0.115712 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 1825 (Number of measurement records by measurement_source_concept_id) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0949 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1825 (0.098639 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 1826 (Number of measurement records by value_as_concept_id) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0949 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1826 (0.098886 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 1827 (Number of measurement records by unit_concept_id) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.104 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1827 (0.108125 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 1891 (Percentage of total persons that have at least x measurements) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.165 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1891 (0.168348 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 1900 (Source values mapped to concept_id 0 by table, by column, by source_value) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.163 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1900 (0.166826 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 2000 (Number of patients with at least 1 Dx and 1 Rx) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.015 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2000 (0.018528 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 2001 (Number of patients with at least 1 Dx and 1 Proc) -- START 2023-09-15 08:58:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0156 secs 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2001 (0.019169 secs) 2023-09-15 08:58:35 [Main thread] INFO Achilles achilles Analysis 2002 (Number of patients with at least 1 Meas, 1 Dx and 1 Rx) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0941 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2002 (0.097926 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2003 (Number of patients with at least 1 Visit) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0205 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2003 (0.024380 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2004 (Number of distinct patients that overlap between specific domains) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.517 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2004 (0.520983 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2100 (Number of persons with at least one device exposure, by device_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0136 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2100 (0.017256 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2101 (Number of device exposure records, by device_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0114 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2101 (0.014887 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2102 (Number of persons by device records start month, by device_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.012 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2102 (0.015515 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2104 (Number of persons with at least one device exposure, by device_concept_id by calendar year by gender by age decile) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0115 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2104 (0.015217 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2105 (Number of device exposure records, by device_concept_id by device_type_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0119 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2105 (0.015433 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2106 (Distribution of age by device_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0494 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2106 (0.053042 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2120 (Number of device_exposure records by device_exposure start month) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0184 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2120 (0.022140 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2125 (Number of device_exposure records by device_source_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0117 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2125 (0.016182 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2191 (Percentage of total persons that have at least x device exposures) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0144 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2191 (0.035511 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2200 (Number of persons with at least one note by note_type_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0117 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2200 (0.015273 secs) 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles Analysis 2201 (Number of note records, by note_type_concept_id) -- START 2023-09-15 08:58:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0115 secs 2023-09-15 08:58:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2201 (0.015236 secs) 2023-09-15 08:58:41 [Main thread] INFO Achilles achilles Merging scratch Achilles tables 2023-09-15 08:58:41 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.124 secs 2023-09-15 08:58:42 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0602 secs 2023-09-15 08:58:42 [Main thread] INFO Achilles achilles Done. Achilles results can now be found in schema results 2023-09-15 08:58:42 [Main thread] INFO Achilles achilles Dropping scratch Achilles tables from schema # 2023-09-15 08:58:46 [Main thread] TRACE Achilles dropAllScratchTables Initiating cluster consisting only of main thread 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00658 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00714 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00802 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00682 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00675 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00708 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00603 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00717 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0133 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00781 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00616 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00599 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00679 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00632 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00747 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00609 secs 2023-09-15 08:58:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00632 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00703 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00675 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00729 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00743 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00702 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0351 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00775 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00716 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00762 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00689 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00658 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00682 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00621 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0084 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00667 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00677 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00622 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00967 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00631 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0076 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00677 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00605 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00627 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00754 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0101 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00665 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00966 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.014 secs 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00663 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00841 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00722 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00657 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00785 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00677 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00784 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00684 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00621 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00826 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00598 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00601 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00679 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0073 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00642 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00695 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00594 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00887 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00725 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00593 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00637 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0209 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00815 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00637 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0176 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00712 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00627 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0067 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00812 secs 2023-09-15 08:58:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00775 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00664 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00651 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00626 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00699 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00909 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0108 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00621 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0063 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00679 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00693 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00572 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00605 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00615 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00635 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00695 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0142 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00648 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00712 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00907 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00663 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.007 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00888 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00649 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00698 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00603 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00772 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00732 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0059 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00666 secs 2023-09-15 08:58:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00588 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00701 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0125 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00664 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0063 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00582 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00595 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00965 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00618 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0103 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00591 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00615 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00602 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00764 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00876 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00757 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00633 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00644 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00904 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00596 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00662 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00574 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00613 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00774 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00633 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00581 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00611 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00584 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00616 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0067 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00892 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00611 secs 2023-09-15 08:58:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00669 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00639 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00726 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0133 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0121 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00644 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00644 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00957 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0064 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0132 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00623 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0112 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00928 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00617 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00669 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00799 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00989 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00669 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00597 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00608 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0133 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00583 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0254 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0307 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00748 secs 2023-09-15 08:58:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0114 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00743 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0257 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00628 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00728 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00962 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00669 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00681 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00648 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0063 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00999 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00648 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.007 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0103 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0103 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0068 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0064 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0158 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00642 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00666 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00569 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00672 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00613 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00865 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00687 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00744 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00956 secs 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00628 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00661 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00691 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00664 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00692 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00733 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0064 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00664 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00688 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0073 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00693 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0069 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00811 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00581 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.025 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00597 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00645 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00579 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00625 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00653 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00584 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00678 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0187 secs 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:53 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00646 secs 2023-09-15 08:58:53 [Main thread] INFO Achilles achilles Temporary Achilles tables removed from schema # 2023-09-15 08:58:54 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 08:58:54 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.739 secs 2023-09-15 08:58:54 [Main thread] INFO Achilles achilles [Total Runtime] 3.095583 mins 2023-09-15 16:21:06 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:21:08 [Main thread] INFO Achilles achilles CDM Version 5.4 found in cdm_source table. 2023-09-15 16:21:08 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:21:08 [Main thread] INFO Achilles achilles Beginning single-threaded execution 2023-09-15 16:21:08 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:21:08 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.087 secs 2023-09-15 16:21:08 [Main thread] INFO DatabaseConnector insertTable.default Inserting data took 0.0506 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Executing multiple queries. This could take a while 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 0 (Source name) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0587 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 0 (0.061746 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 1 (Number of persons) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0134 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1 (0.016352 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 2 (Number of persons by gender) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.014 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2 (0.016867 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 3 (Number of persons by year of birth) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0135 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 3 (0.016325 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 4 (Number of persons by race) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0135 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 4 (0.016537 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 5 (Number of persons by ethnicity) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0141 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 5 (0.016964 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 10 (Number of all persons by year of birth by gender) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0263 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 10 (0.029433 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 11 (Number of non-deceased persons by year of birth by gender) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0232 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 11 (0.026161 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 12 (Number of persons by race and ethnicity) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0218 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 12 (0.024891 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 101 (Number of persons by age, with age at first observation period) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0545 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 101 (0.057638 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 102 (Number of persons by gender by age, with age at first observation period) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0161 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 102 (0.019074 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 103 (Distribution of age at first observation period) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0269 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 103 (0.037827 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 104 (Distribution of age at first observation period by gender) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0389 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 104 (0.041746 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 105 (Length of observation (days) of first observation period) -- START 2023-09-15 16:21:13 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0745 secs 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 105 (0.077389 secs) 2023-09-15 16:21:13 [Main thread] INFO Achilles achilles Analysis 106 (Length of observation (days) of first observation period by gender) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0575 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 106 (0.060687 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 107 (Length of observation (days) of first observation period by age decile) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0367 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 107 (0.039655 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 108 (Number of persons by length of observation period, in 30d increments) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0193 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 108 (0.022246 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 109 (Number of persons with continuous observation in each year) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0219 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 109 (0.025074 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 110 (Number of persons with continuous observation in each month) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.024 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 110 (0.026929 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 111 (Number of persons by observation period start month) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0277 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 111 (0.030624 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 112 (Number of persons by observation period end month) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0164 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 112 (0.019343 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 113 (Number of persons by number of observation periods) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0148 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 113 (0.017823 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 116 (Number of persons with at least one day of observation in each year by gender and age decile) -- START 2023-09-15 16:21:14 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0336 secs 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 116 (0.036467 secs) 2023-09-15 16:21:14 [Main thread] INFO Achilles achilles Analysis 117 (Number of persons with at least one day of observation in each month) -- START 2023-09-15 16:21:17 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 3.59 secs 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 117 (3.589368 secs) 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles Analysis 119 (Number of observation period records by period_type_concept_id) -- START 2023-09-15 16:21:17 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0175 secs 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 119 (0.020727 secs) 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles Analysis 200 (Number of persons with at least one visit occurrence, by visit_concept_id) -- START 2023-09-15 16:21:17 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0376 secs 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 200 (0.040786 secs) 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles Analysis 201 (Number of visit occurrence records, by visit_concept_id) -- START 2023-09-15 16:21:17 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0218 secs 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 201 (0.024726 secs) 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles Analysis 202 (Number of persons by visit occurrence start month, by visit_concept_id) -- START 2023-09-15 16:21:17 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0225 secs 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 202 (0.025352 secs) 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles Analysis 203 (Number of distinct visit occurrence concepts per person) -- START 2023-09-15 16:21:17 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0419 secs 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 203 (0.044936 secs) 2023-09-15 16:21:17 [Main thread] INFO Achilles achilles Analysis 204 (Number of persons with at least one visit occurrence, by visit_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0272 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 204 (0.030092 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 206 (Distribution of age by visit_concept_id) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0448 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 206 (0.047740 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 207 (Number of visit records with invalid person_id) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0143 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 207 (0.017629 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 209 (Number of visit records with invalid care_site_id) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0239 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 209 (0.026889 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 210 (Number of visit_occurrence records outside a valid observation period) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0176 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 210 (0.020417 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 212 (Number of persons with at least one visit occurrence, by calendar year by gender by age decile) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0216 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 212 (0.024515 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 213 (Distribution of length of stay by visit_concept_id) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0389 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 213 (0.041871 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 220 (Number of visit occurrence records by visit occurrence start month) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0206 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 220 (0.023634 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 221 (Number of persons by visit start year) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0283 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 221 (0.031117 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 225 (Number of visit_occurrence records by visit_source_concept_id) -- START 2023-09-15 16:21:18 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0156 secs 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 225 (0.018373 secs) 2023-09-15 16:21:18 [Main thread] INFO Achilles achilles Analysis 226 (Number of records by domain by visit_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.863 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 226 (0.865679 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 300 (Number of providers) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.012 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 300 (0.014802 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 301 (Number of providers by specialty concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0132 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 301 (0.015995 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 303 (Number of providers records by specialty_concept_id and visit_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00981 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 303 (0.012560 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 325 (Number of provider records by specialty_source_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0098 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 325 (0.012713 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 400 (Number of persons with at least one condition occurrence, by condition_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0145 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 400 (0.017350 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 401 (Number of condition occurrence records, by condition_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00977 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 401 (0.012561 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 402 (Number of persons by condition occurrence start month, by condition_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00919 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 402 (0.011940 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 403 (Number of distinct condition occurrence concepts per person) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0241 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 403 (0.026959 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 404 (Number of persons with at least one condition occurrence, by condition_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00973 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 404 (0.012638 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 405 (Number of condition occurrence records, by condition_concept_id by condition_type_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00912 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 405 (0.011867 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 406 (Distribution of age by condition_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0366 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 406 (0.039453 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 414 (Number of condition occurrence records, by condition_status_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0172 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 414 (0.020272 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 415 (Number of condition occurrence records, by condition_type_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0123 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 415 (0.015097 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 416 (Number of condition occurrence records, by condition_status_concept_id, condition_type_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0131 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 416 (0.022197 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 420 (Number of condition occurrence records by condition occurrence start month) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0103 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 420 (0.013210 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 425 (Number of condition_occurrence records by condition_source_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0109 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 425 (0.013608 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 500 (Number of persons with death, by cause_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.013 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 500 (0.015876 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 501 (Number of records of death, by cause_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00883 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 501 (0.011554 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 502 (Number of persons by death month) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00945 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 502 (0.012235 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 504 (Number of persons with a death, by calendar year by gender by age decile) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00976 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 504 (0.012577 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 505 (Number of death records, by death_type_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0103 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 505 (0.013250 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 506 (Distribution of age at death by gender) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0268 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 506 (0.029670 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 511 (Distribution of time from death to last condition) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0159 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 511 (0.018811 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 512 (Distribution of time from death to last drug) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0324 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 512 (0.036003 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 513 (Distribution of time from death to last visit) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0672 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 513 (0.070334 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 514 (Distribution of time from death to last procedure) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0417 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 514 (0.046519 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 515 (Distribution of time from death to last observation) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0253 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 515 (0.028293 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 525 (Number of death records by cause_source_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00857 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 525 (0.011396 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 600 (Number of persons with at least one procedure occurrence, by procedure_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00944 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 600 (0.012173 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 601 (Number of procedure occurrence records, by procedure_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00892 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 601 (0.011641 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 602 (Number of persons by procedure occurrence start month, by procedure_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0192 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 602 (0.022218 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 603 (Number of distinct procedure occurrence concepts per person) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0226 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 603 (0.025509 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 604 (Number of persons with at least one procedure occurrence, by procedure_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0104 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 604 (0.014553 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 605 (Number of procedure occurrence records, by procedure_concept_id by procedure_type_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0111 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 605 (0.014101 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 606 (Distribution of age by procedure_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0452 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 606 (0.048367 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 620 (Number of procedure occurrence records by procedure occurrence start month) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00925 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 620 (0.012065 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 625 (Number of procedure_occurrence records by procedure_source_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00885 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 625 (0.011630 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 630 (Number of procedure_occurrence records inside a valid observation period) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0108 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 630 (0.013931 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 691 (Percentage of total persons that have at least x procedures) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00958 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 691 (0.012529 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 700 (Number of persons with at least one drug exposure, by drug_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0115 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 700 (0.014535 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 701 (Number of drug exposure records, by drug_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0123 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 701 (0.015244 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 702 (Number of persons by drug exposure start month, by drug_concept_id) -- START 2023-09-15 16:21:19 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00968 secs 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 702 (0.012583 secs) 2023-09-15 16:21:19 [Main thread] INFO Achilles achilles Analysis 703 (Number of distinct drug exposure concepts per person) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0232 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 703 (0.026219 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 704 (Number of persons with at least one drug exposure, by drug_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00928 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 704 (0.012163 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 705 (Number of drug exposure records, by drug_concept_id by drug_type_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0105 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 705 (0.013443 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 706 (Distribution of age by drug_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0617 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 706 (0.064682 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 715 (Distribution of days_supply by drug_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0341 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 715 (0.037095 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 716 (Distribution of refills by drug_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0233 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 716 (0.026261 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 717 (Distribution of quantity by drug_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0225 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 717 (0.025423 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 720 (Number of drug exposure records by drug exposure start month) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00914 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 720 (0.011934 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 725 (Number of drug_exposure records by drug_source_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00871 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 725 (0.018836 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 791 (Percentage of total persons that have at least x drug exposures) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0101 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 791 (0.013142 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 800 (Number of persons with at least one observation occurrence, by observation_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.275 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 800 (0.278283 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 801 (Number of observation occurrence records, by observation_concept_id) -- START 2023-09-15 16:21:20 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.134 secs 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 801 (0.137320 secs) 2023-09-15 16:21:20 [Main thread] INFO Achilles achilles Analysis 802 (Number of persons by observation occurrence start month, by observation_concept_id) -- START 2023-09-15 16:21:21 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.443 secs 2023-09-15 16:21:21 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 802 (0.445916 secs) 2023-09-15 16:21:21 [Main thread] INFO Achilles achilles Analysis 803 (Number of distinct observation occurrence concepts per person) -- START 2023-09-15 16:21:21 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.33 secs 2023-09-15 16:21:21 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 803 (0.333203 secs) 2023-09-15 16:21:21 [Main thread] INFO Achilles achilles Analysis 804 (Number of persons with at least one observation occurrence, by observation_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:21 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.543 secs 2023-09-15 16:21:21 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 804 (0.545587 secs) 2023-09-15 16:21:21 [Main thread] INFO Achilles achilles Analysis 805 (Number of observation occurrence records, by observation_concept_id by observation_type_concept_id) -- START 2023-09-15 16:21:22 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.151 secs 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 805 (0.154181 secs) 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles Analysis 806 (Distribution of age by observation_concept_id) -- START 2023-09-15 16:21:22 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.573 secs 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 806 (0.575837 secs) 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles Analysis 807 (Number of observation occurrence records, by observation_concept_id and unit_concept_id) -- START 2023-09-15 16:21:22 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.153 secs 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 807 (0.155987 secs) 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles Analysis 814 (Number of observation records with no value (numeric, string, or concept)) -- START 2023-09-15 16:21:22 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0484 secs 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 814 (0.051401 secs) 2023-09-15 16:21:22 [Main thread] INFO Achilles achilles Analysis 815 (Distribution of numeric values, by observation_concept_id and unit_concept_id) -- START 2023-09-15 16:21:23 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.915 secs 2023-09-15 16:21:23 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 815 (0.918043 secs) 2023-09-15 16:21:23 [Main thread] INFO Achilles achilles Analysis 820 (Number of observation records by observation start month) -- START 2023-09-15 16:21:24 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.202 secs 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 820 (0.204697 secs) 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles Analysis 822 (Number of observation records, by observation_concept_id and value_as_concept_id) -- START 2023-09-15 16:21:24 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.149 secs 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 822 (0.152055 secs) 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles Analysis 823 (Number of observation records, by observation_concept_id and qualifier_concept_id) -- START 2023-09-15 16:21:24 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.153 secs 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 823 (0.155757 secs) 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles Analysis 825 (Number of observation records by observation_source_concept_id) -- START 2023-09-15 16:21:24 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.122 secs 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 825 (0.124464 secs) 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles Analysis 826 (Number of observation records by value_as_concept_id) -- START 2023-09-15 16:21:24 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.134 secs 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 826 (0.136456 secs) 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles Analysis 827 (Number of observation records by unit_concept_id) -- START 2023-09-15 16:21:24 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.133 secs 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 827 (0.135637 secs) 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles Analysis 891 (Percentage of total persons that have at least x observations) -- START 2023-09-15 16:21:24 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.233 secs 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 891 (0.236042 secs) 2023-09-15 16:21:24 [Main thread] INFO Achilles achilles Analysis 900 (Number of persons with at least one drug era, by drug_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0155 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 900 (0.018447 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 901 (Number of drug era records, by drug_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00905 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 901 (0.011812 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 902 (Number of persons by drug era start month, by drug_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00966 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 902 (0.012387 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 903 (Number of distinct drug era concepts per person) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0221 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 903 (0.025086 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 904 (Number of persons with at least one drug era, by drug_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0112 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 904 (0.014021 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 906 (Distribution of age by drug_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0337 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 906 (0.036844 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 907 (Distribution of drug era length, by drug_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0342 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 907 (0.037259 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 920 (Number of drug era records by drug era start month) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0121 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 920 (0.015029 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1000 (Number of persons with at least one condition era, by condition_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00933 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1000 (0.020869 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1001 (Number of condition era records, by condition_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00935 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1001 (0.012266 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1002 (Number of persons by condition era start month, by condition_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0091 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1002 (0.011827 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1003 (Number of distinct condition era concepts per person) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0284 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1003 (0.031336 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1004 (Number of persons with at least one condition era, by condition_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00913 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1004 (0.011888 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1006 (Distribution of age by condition_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0335 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1006 (0.036304 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1007 (Distribution of condition era length, by condition_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0228 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1007 (0.025674 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1020 (Number of condition era records by condition era start month) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00918 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1020 (0.012031 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1100 (Number of persons by location 3-digit zip) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0136 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1100 (0.016323 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1101 (Number of persons by location state) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00946 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1101 (0.012251 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1102 (Number of care sites by location 3-digit zip) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0132 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1102 (0.015989 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1103 (Number of care sites by location state) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00944 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1103 (0.012170 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1200 (Number of persons by place of service) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0106 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1200 (0.013417 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1201 (Number of visits by place of service) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0109 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1201 (0.022596 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1202 (Number of care sites by place of service) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00875 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1202 (0.011556 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1203 (Number of visits by place of service discharge type) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00982 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1203 (0.012551 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1300 (Number of persons with at least one visit detail, by visit_detail_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0102 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1300 (0.012956 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1301 (Number of visit detail records, by visit_detail_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0136 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1301 (0.016611 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1302 (Number of persons by visit detail start month, by visit_detail_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00871 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1302 (0.011407 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1303 (Number of distinct visit detail concepts per person) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0271 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1303 (0.029950 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1304 (Number of persons with at least one visit detail, by visit_detail_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0125 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1304 (0.015211 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1306 (Distribution of age by visit_detail_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0333 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1306 (0.036168 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1312 (Number of persons with at least one visit detail, by calendar year by gender by age decile) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00923 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1312 (0.012057 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1313 (Distribution of length of stay by visit_detail_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0302 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1313 (0.033135 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1320 (Number of visit detail records by visit detail start month) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00923 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1320 (0.011895 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1321 (Number of persons by visit start year) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00992 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1321 (0.012635 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1325 (Number of visit_detail records by visit_detail_source_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00951 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1325 (0.012165 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1326 (Number of records by domain by visit_detail_concept_id) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.154 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1326 (0.157489 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1406 (Length of payer plan (days) of first payer plan period by gender) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0361 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1406 (0.039145 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1407 (Length of payer plan (days) of first payer plan period by age decile) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0242 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1407 (0.027254 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1408 (Number of persons by length of payer plan period, in 30d increments) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00914 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1408 (0.011862 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1409 (Number of persons with continuous payer plan in each year) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0214 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1409 (0.024187 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1410 (Number of persons with continuous payer plan in each month) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0203 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1410 (0.023143 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1411 (Number of persons by payer plan period start month) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00874 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1411 (0.011412 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1412 (Number of persons by payer plan period end month) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00917 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1412 (0.011896 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1413 (Number of persons by number of payer plan periods) -- START 2023-09-15 16:21:25 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00973 secs 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1413 (0.012648 secs) 2023-09-15 16:21:25 [Main thread] INFO Achilles achilles Analysis 1425 (Number of payer_plan_period records by payer_source_concept_id) -- START 2023-09-15 16:21:26 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0151 secs 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1425 (0.017891 secs) 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles Analysis 1800 (Number of persons with at least one measurement occurrence, by measurement_concept_id) -- START 2023-09-15 16:21:26 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.175 secs 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1800 (0.177817 secs) 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles Analysis 1801 (Number of measurement occurrence records, by measurement_concept_id) -- START 2023-09-15 16:21:26 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.085 secs 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1801 (0.088004 secs) 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles Analysis 1802 (Number of persons by measurement occurrence start month, by measurement_concept_id) -- START 2023-09-15 16:21:26 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.278 secs 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1802 (0.281203 secs) 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles Analysis 1803 (Number of distinct mesurement occurrence concepts per person) -- START 2023-09-15 16:21:26 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.204 secs 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1803 (0.207351 secs) 2023-09-15 16:21:26 [Main thread] INFO Achilles achilles Analysis 1804 (Number of persons with at least one mesurement occurrence, by measurement_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:21:27 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.337 secs 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1804 (0.339691 secs) 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles Analysis 1805 (Number of measurement occurrence records, by measurement_concept_id by measurement_type_concept_id) -- START 2023-09-15 16:21:27 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0948 secs 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1805 (0.098509 secs) 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles Analysis 1806 (Distribution of age by measurement_concept_id) -- START 2023-09-15 16:21:27 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.443 secs 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1806 (0.446587 secs) 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles Analysis 1807 (Number of measurement occurrence records, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 16:21:27 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0982 secs 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1807 (0.101131 secs) 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles Analysis 1811 (Number of measurement records with a valid value (with a mapped, non-null value_as_number)) -- START 2023-09-15 16:21:27 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0723 secs 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1811 (0.075419 secs) 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles Analysis 1814 (Number of measurement records with no value (numeric, string, or concept)) -- START 2023-09-15 16:21:27 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0316 secs 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1814 (0.034582 secs) 2023-09-15 16:21:27 [Main thread] INFO Achilles achilles Analysis 1815 (Distribution of numeric values, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 16:23:34 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 2.12 mins 2023-09-15 16:23:34 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1815 (2.116004 mins) 2023-09-15 16:23:34 [Main thread] INFO Achilles achilles Analysis 1816 (Distribution of low range, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 16:23:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.569 secs 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1816 (0.571511 secs) 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles Analysis 1817 (Distribution of high range, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 16:23:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0995 secs 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1817 (0.102509 secs) 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles Analysis 1818 (Number of measurement records below/within/above normal range, by measurement_concept_id and unit_concept_id) -- START 2023-09-15 16:23:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0494 secs 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1818 (0.055524 secs) 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles Analysis 1819 (Number of measurement records, by measurement_concept_id, with a valid value (with a mapped, non-null value_as_number)) -- START 2023-09-15 16:23:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.09 secs 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1819 (0.092950 secs) 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles Analysis 1820 (Number of measurement records by measurement start month) -- START 2023-09-15 16:23:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.129 secs 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1820 (0.132793 secs) 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles Analysis 1821 (Number of measurement records with no numeric value) -- START 2023-09-15 16:23:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0417 secs 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1821 (0.044804 secs) 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles Analysis 1822 (Number of measurement records, by measurement_concept_id and value_as_concept_id) -- START 2023-09-15 16:23:35 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0931 secs 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1822 (0.096279 secs) 2023-09-15 16:23:35 [Main thread] INFO Achilles achilles Analysis 1823 (Number of measurement records, by measurement_concept_id and operator_concept_id) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.09 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1823 (0.093192 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 1825 (Number of measurement records by measurement_source_concept_id) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0825 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1825 (0.085512 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 1826 (Number of measurement records by value_as_concept_id) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0786 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1826 (0.081656 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 1827 (Number of measurement records by unit_concept_id) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0904 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1827 (0.093296 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 1891 (Percentage of total persons that have at least x measurements) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.137 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1891 (0.139512 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 1900 (Source values mapped to concept_id 0 by table, by column, by source_value) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.155 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 1900 (0.158311 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 2000 (Number of patients with at least 1 Dx and 1 Rx) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.093 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2000 (0.096087 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 2001 (Number of patients with at least 1 Dx and 1 Proc) -- START 2023-09-15 16:23:36 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0556 secs 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2001 (0.058812 secs) 2023-09-15 16:23:36 [Main thread] INFO Achilles achilles Analysis 2002 (Number of patients with at least 1 Meas, 1 Dx and 1 Rx) -- START 2023-09-15 16:23:37 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.303 secs 2023-09-15 16:23:37 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2002 (0.306019 secs) 2023-09-15 16:23:37 [Main thread] INFO Achilles achilles Analysis 2003 (Number of patients with at least 1 Visit) -- START 2023-09-15 16:23:37 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.102 secs 2023-09-15 16:23:37 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2003 (0.105397 secs) 2023-09-15 16:23:37 [Main thread] INFO Achilles achilles Analysis 2004 (Number of distinct patients that overlap between specific domains) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.946 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2004 (0.950209 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2100 (Number of persons with at least one device exposure, by device_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0448 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2100 (0.047935 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2101 (Number of device exposure records, by device_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0431 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2101 (0.046268 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2102 (Number of persons by device records start month, by device_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0401 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2102 (0.044490 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2104 (Number of persons with at least one device exposure, by device_concept_id by calendar year by gender by age decile) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0463 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2104 (0.049245 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2105 (Number of device exposure records, by device_concept_id by device_type_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0597 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2105 (0.062674 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2106 (Distribution of age by device_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.166 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2106 (0.169165 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2120 (Number of device_exposure records by device_exposure start month) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00948 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2120 (0.012450 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2125 (Number of device_exposure records by device_source_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00907 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2125 (0.011853 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2191 (Percentage of total persons that have at least x device exposures) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0103 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2191 (0.012977 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2200 (Number of persons with at least one note by note_type_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0096 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2200 (0.012477 secs) 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles Analysis 2201 (Number of note records, by note_type_concept_id) -- START 2023-09-15 16:23:38 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00853 secs 2023-09-15 16:23:38 [Main thread] INFO Achilles achilles [Main Analysis] [COMPLETE] 2201 (0.011347 secs) 2023-09-15 16:23:42 [Main thread] INFO Achilles achilles Merging scratch Achilles tables 2023-09-15 16:23:42 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.103 secs 2023-09-15 16:23:42 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0507 secs 2023-09-15 16:23:42 [Main thread] INFO Achilles achilles Done. Achilles results can now be found in schema results 2023-09-15 16:23:42 [Main thread] INFO Achilles achilles Dropping scratch Achilles tables from schema # 2023-09-15 16:23:45 [Main thread] TRACE Achilles dropAllScratchTables Initiating cluster consisting only of main thread 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0178 secs 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00467 secs 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00458 secs 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00944 secs 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00768 secs 2023-09-15 16:23:45 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00457 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00459 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00481 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00452 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00451 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00864 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00458 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00473 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00455 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0186 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0066 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00484 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0049 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00487 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00511 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00485 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0047 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00487 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00472 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00472 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00526 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00497 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00534 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00507 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0134 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00448 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00507 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0047 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00617 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00747 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00459 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00692 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00481 secs 2023-09-15 16:23:46 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00479 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00738 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00455 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00516 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00481 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00463 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00518 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00448 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00475 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0051 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00449 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00452 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00438 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00476 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00437 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00444 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0076 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00455 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00481 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0044 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00428 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00442 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00424 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00434 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00451 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00417 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00461 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00466 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00502 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00467 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00445 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00466 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00463 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0044 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00491 secs 2023-09-15 16:23:47 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0046 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00456 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00469 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00453 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00455 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00461 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0199 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00442 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00445 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00445 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00436 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00461 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00485 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00445 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0047 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00456 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00517 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00457 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00442 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00593 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00447 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00462 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00441 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00426 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0054 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.018 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00451 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00435 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0041 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00433 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00494 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00443 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0045 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00439 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00443 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00463 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00445 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00461 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00431 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00471 secs 2023-09-15 16:23:48 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00462 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00461 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00474 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00468 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0145 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00553 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00442 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0054 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00453 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00504 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00433 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00462 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00435 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00505 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00575 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0046 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00583 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00453 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00449 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00493 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0047 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00479 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0147 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00664 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0045 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0043 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00457 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00459 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00453 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00423 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00422 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00415 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0042 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0118 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00433 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00434 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00424 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00433 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00441 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00443 secs 2023-09-15 16:23:49 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0118 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00462 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00602 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0043 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00514 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00454 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00432 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00439 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00421 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00449 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00435 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00498 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00443 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00417 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0045 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0122 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00434 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00441 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00436 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00427 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00474 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00429 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00457 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00842 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00441 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.016 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00473 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00803 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0044 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00452 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00438 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00441 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00425 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0049 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00434 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00445 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00425 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0113 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0045 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0042 secs 2023-09-15 16:23:50 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00427 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00424 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0043 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00436 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00419 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0114 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00443 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00442 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00452 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00444 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00445 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00442 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00433 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.0044 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00476 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00441 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00456 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00497 secs 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.00438 secs 2023-09-15 16:23:51 [Main thread] INFO Achilles achilles Temporary Achilles tables removed from schema # 2023-09-15 16:23:51 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:52 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 0.624 secs 2023-09-15 16:23:52 [Main thread] INFO DatabaseConnector connectPostgreSql Connecting using PostgreSQL driver 2023-09-15 16:23:52 [Main thread] INFO Achilles optimizeAtlasCache Optimizing atlas cache 2023-09-15 16:26:12 [Main thread] INFO DatabaseConnector executeSql Executing SQL took 2.33 mins 2023-09-15 16:26:12 [Main thread] INFO Achilles optimizeAtlasCache Atlas cache was optimized 2023-09-15 16:26:12 [Main thread] INFO Achilles achilles [Total Runtime] 5.095136 mins