ANALYZE schemaname | tablename | rowcount ------------+---------------------------------+----------- 19362 | ACTIVITY | 55809080 19362 | ACTIVITY_CONDUCTING_ORG | 20284828 19362 | ACTIVITY_CONDUCTING_ORG_COPY | 20368280 19362 | ACTIVITY_GROUP | 547975 19362 | ACTIVITY_GROUP_DETAIL | 5832337 19362 | ACTIVITY_GROUP_TYPE | 6 19362 | ACTIVITY_MEDIA | 8 19362 | ACTIVITY_MEDIA_COPY | 8 19362 | ACTIVITY_MEDIA_SUBDIVISION | 71 19362 | ACTIVITY_MEDIA_SUBDIVISION_COPY | 71 19362 | ACTIVITY_METRIC | 4100130 19362 | ACTIVITY_METRIC_COPY | 4100130 19362 | ACTIVITY_METRIC_INDEX | 627852 19362 | ACTIVITY_OLD | 34966 19362 | ACTIVITY_PROJECT | 72808616 19362 | ACTIVITY_PROJECT_COPY | 73181800 19362 | ACTIVITY_TYPE | 108 19362 | ACTIVITY_TYPE_COPY | 108 19362 | ACTIVITY_UPD | 34966 19362 | ACTMLOCUID | 34966 19362 | ACTMLOC_UID | 34966 19362 | ADDRESS_TYPE | 3 19362 | ADDRESS_TYPE_COPY | 3 19362 | ALIAS_TYPE | 19 19362 | ANALYTICAL_METHOD | 17505 19362 | ANALYTICAL_METHOD_CONTEXT | 1603 19362 | ANALYTICAL_METHOD_CONTEXT_COPY | 1603 19362 | ANALYTICAL_METHOD_COPY | 17505 19362 | AQUIFER | 14758 19362 | AQUIFER_CONTEXT | 1545 19362 | AQUIFER_TYPE | 3 19362 | ASSEMBLAGE | 15 19362 | ASSEMBLAGE_COPY | 15 19362 | ATTACHED_OBJECT | 70954 19362 | ATTACHED_OBJECT_DELTA | 2663 19362 | ATTACHED_OBJECT_FOLDER | 6 19362 | AUDIT_TYPE | 3 19362 | BIOLOGICAL_HABITAT_INDEX | 676357 19362 | BIOLOGICAL_HABITAT_INDEX_COPY | 676357 19362 | BIOLOGICAL_INTENT | 8 19362 | BIOLOGICAL_INTENT_COPY | 8 19362 | CELL_FORM | 9 19362 | CELL_FORM_COPY | 9 19362 | CELL_SHAPE | 10 19362 | CELL_SHAPE_COPY | 10 19362 | CHARACTERISTIC | 23347 19362 | CHARACTERISTIC_ALIAS | 144950 19362 | CHARACTERISTIC_COPY | 23347 19362 | CHARACTERISTIC_GROUP | 37 19362 | CHARACTERISTIC_GROUP_COPY | 37 19362 | CHARACTERISTIC_PICK_LIST_VALUE | 3890 19362 | CHAR_ANALYTICAL_METHOD | 1 19362 | CHAR_DETECT_QUANT_LIMIT_TYPE | 1 19362 | CHAR_MEASUREMENT_UNIT | 1 19362 | CHAR_METH_SPECIATION | 1 19362 | CHAR_SAMPLE_FRACTION | 1 19362 | CITATION | 430 19362 | CITATION_COPY | 430 19362 | CONFIG | 18 19362 | CONTAINER_COLOR | 7 19362 | CONTAINER_COLOR_COPY | 7 19362 | CONTAINER_TYPE | 35 19362 | COUNTRY | 294 19362 | COUNTY | 3298 19362 | DETECTION_QUANT_LIMIT_TYPE | 41 19362 | DETECTION_QUANT_LIMIT_TYPE_COPY | 41 19362 | DOMAIN_VALUE_STATUS | 3 19362 | ELECTRONIC_ADDRESS_TYPE | 3 19362 | ELEMENT_VALUE_STATUS | 8 19362 | EPA_REGION | 10 19362 | ETL_EXECUTION_STATUS | 65 19362 | ETL_MANUAL_LOAD | 1 19362 | ETL_PRJ_TRIP_STG | 184251 19362 | FREQUENCY_CLASS_DESCRIPTOR | 81 19362 | FREQUENCY_CLASS_TYPE | 6 19362 | GEAR_PROCEDURE_UNIT | 6 19362 | HABIT | 11 19362 | HABITAT_SELECTION_METHOD | 6 19362 | HORIZONTAL_COLLECTION_METHOD | 40 19362 | HORIZONTAL_REFERENCE_DATUM | 17 19362 | HYDROLOGIC_CONDITION | 8 19362 | HYDROLOGIC_EVENT | 21 19362 | INDEX_TYPE | 1957 19362 | INDEX_TYPE_COPY | 1957 19362 | LAB_SAMPLE_PREPARATION_METHOD | 2638 19362 | LOOKUP_TABLE_AUDIT | 906379 19362 | LOOKUP_TABLE_AUDIT_UPD_DETAIL | 97949 19362 | MEASUREMENT_UNIT | 516 19362 | MEASUREMENT_UNIT_COPY | 516 19362 | MEASURE_QUALIFIER | 421 19362 | MEASURE_QUALIFIER_COPY | 421 19362 | MEASURE_QUALIFIER_LEGACY | 320 19362 | METHOD_SPECIATION | 117 19362 | METRIC_TYPE | 5459 19362 | METRIC_TYPE_CONTEXT | 1223 19362 | MONITORING_LOCATION | 1040045 19362 | MONITORING_LOCATION_ALTERNATE | 353978 19362 | MONITORING_LOCATION_COPY | 802837 19362 | MONITORING_LOCATION_TYPE | 111 19362 | MONITORING_LOCATION_TYPE_COPY | 106 19362 | MONITORING_LOCATION_WEIGHT | 10622 19362 | NARS_ACIVITY | 47719 19362 | NARS_ACTIVITY_GROUP | 13 19362 | NARS_ACTIVITY_PROJECT | 48555 19362 | NARS_MONITORING_LOCATION | 2281 19362 | NARS_RESULT | 38230 19362 | NARS_RESULT_DETECT_QUANT_LIMIT | 0 19362 | NATIONAL_AQUIFER | 69 19362 | NET_TYPE | 3 19362 | OLD_ETL_EXECUTION_STATUS | 43 19362 | ORGANIZATION | 1481 19362 | ORGANIZATION_COPY | 1451 19362 | ORGANIZATION_TYPE | 10 19362 | ORGANIZATION_TYPE_COPY | 10 19362 | ORG_ADDRESS | 580 19362 | ORG_ELECTRONIC_ADDRESS | 801 19362 | ORG_PHONE | 526 19362 | OW_APPLICATION_STATUS | 5 19362 | PHONE_TYPE | 5 19362 | PROJECT | 57947 19362 | PROJECT_COPY | 54190 19362 | QAQC_CHARACTERISTIC_VALIDATION | 71801 19362 | QAQC_LATLONG_VALIDATION | 2136790 19362 | QAQC_TAXON_VALIDATION | 83886 19362 | REFERENCE_LOCATION_TYPE | 4 19362 | RELATIVE_DEPTH | 35 19362 | RESULT | 295240448 19362 | RESULT_DETECTION_CONDITION | 23 19362 | RESULT_DETECT_QUANT_LIMIT | 107314608 19362 | RESULT_FREQUENCY_CLASS | 1541532 19362 | RESULT_LAB_COMMENT | 39 19362 | RESULT_LAB_SAMPLE_PREP | 46660472 19362 | RESULT_MEASURE_QUALIFIER | 13843177 19362 | RESULT_SAMPLING_POINT_TYPE | 4 19362 | RESULT_STATISTICAL_BASE | 66 19362 | RESULT_STATUS | 10 19362 | RESULT_TARGET_COUNT | 10 19362 | RESULT_TAXON_DETAIL | 490023 19362 | RESULT_TAXON_FEEDING_GROUP | 351056 19362 | RESULT_TAXON_HABIT | 171972 19362 | RESULT_TEMPERATURE_BASIS | 40 19362 | RESULT_TIME_BASIS | 152 19362 | RESULT_VALUE_TYPE | 5 19362 | RESULT_WEIGHT_BASIS | 20 19362 | SAMPLE_COLLECTION_EQUIP | 253 19362 | SAMPLE_COLLECTION_EQUIP_TYPE | 14 19362 | SAMPLE_COLLECTION_METHOD | 29149 19362 | SAMPLE_COLLECT_METHOD_CONTEXT | 1313 19362 | SAMPLE_FRACTION | 47 19362 | SAMPLE_PREPARATION_METHOD | 444 19362 | SAMPLE_TISSUE_ANATOMY | 110 19362 | SAMPLING_DESIGN_TYPE | 3 19362 | STATE | 116 19362 | TABLE_LIST | 96 19362 | TABLE_TYPE | 3 19362 | TAXON | 51634 19362 | TAXON_ALIAS | 464776 19362 | TAXON_COPY | 51283 19362 | TAXON_GROUP | 17 19362 | TAXON_PARENT | 50758 19362 | TAXON_PARENT_COPY | 50758 19362 | TAXON_RANK | 46 19362 | THERMAL_PRESERVATIVE | 12 19362 | TIME_ZONE | 26 19362 | TMP_TAXON_ALIAS | 1 19362 | TMP_TRIBE | 2336 19362 | TOXICITY_TEST_TYPE | 2 19362 | TRANSACTION_HEADER | 155214 19362 | TRANSACTION_LOG | 191310 19362 | TRANSACTION_LOG_AUDIT | 2962604 19362 | TRANSACTION_LOG_AUDIT_SUMMARY | 1009559 19362 | TRANSACTION_LOG_DETAIL | 25175 19362 | TRANSACTION_LOG_DETAIL_TYPE | 5 19362 | TRANSACTION_STATUS | 3 19362 | TRANSACTION_TYPE | 3 19362 | TRIBE | 610 19362 | USER_ACCESS | 19369 19362 | USER_ACCESS_DOMAIN | 4 19362 | USER_ACCESS_TYPE | 7 19362 | USER_ACCESS_TYPE_BY_DOMAIN | 9 19362 | USER_LIST | 2897 19362 | VERTICAL_COLLECTION_METHOD | 17 19362 | VERTICAL_REFERENCE_DATUM | 6 19362 | VOLTINISM | 6 19362 | WELL | 75241 19362 | WELL_FORMATION_TYPE | 18 19362 | WELL_TYPE | 28 19362 | characteristic_validation | 241816 19362 | csv_gen_validatestate | 224532 19362 | result_apistats | 1 19362 | station_apistats | 1 19362 | validateresult | 9868 19362 | validateresult_generated | 1 19362 | validatestation | 1645776 19362 | validatestation_registernew | 1047264 (195 rows)