"Unique (cost=529701.37..529701.43 rows=1 width=574) (actual time=2695930.462..2695933.678 rows=3729 loops=1)" " -> Sort (cost=529701.37..529701.37 rows=1 width=574) (actual time=2695930.462..2695931.403 rows=3729 loops=1)" " Sort Key: so_phci_entity_base.phci_entity_type_f, lms_reserve_sec_region_lkup.reserve_sec_region_name, lms_property_rights_base.ownership_category_f, lms_reserve_minor_class_lkup.reserve_minor_class_k, so_country_state_assoc_lkup.description, (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) * (('100'::numeric - (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'W_Moisture'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) / '100'::numeric))), ((CASE WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END = '0'::numeric) THEN 'Insufficient'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END < 1.2) THEN '< 1.2 lbs'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END < 2.5) THEN '> 1.2 to 2.5 lbs.'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END >= 2.5) THEN '> 2.5 lbs'::text ELSE 'Insufficient'::text END)::character varying), lms_reserve_mining_type_lkup_1.mining_type_display, lms_reserve_mining_type_lkup.mining_type_display, lms_reserve_category_lkup.reserve_category_k, ""*SELECT* 1"".statecode, (CASE WHEN (lms_reserve_mining_type_lkup_1.mining_type_display IS NULL) THEN lms_reserve_mining_type_lkup.mining_type_display ELSE lms_reserve_mining_type_lkup_1.mining_type_display END), lms_reserve_stateofmining_lkup.reserve_state_of_mining_code_k, ""*SELECT* 1"".upsid, lms_categorized_reserve_base.coal_acres, lms_categorized_reserve_base.yardage, lms_categorized_reserve_base.avg_thickness, (sum(lms_property_rights_base.numerator)), (sum(lms_property_rights_base.denominator)), (sum(lms_categorized_reserve_base.wash_percentage)), (sum(lms_categorized_reserve_base.recovery_percentage)), lms_categorized_reserve_base.tons_per_acre_foot, ((((""*SELECT* 1"".statecode)::text || lpad((""*SELECT* 1"".countyfip)::text, 3, '0'::text)) || lpad((""*SELECT* 1"".upno)::text, 5, '0'::text))), (sum((((((lms_categorized_reserve_base.tons_per_acre_foot * lms_categorized_reserve_base.avg_thickness) * lms_categorized_reserve_base.coal_acres) * (lms_property_rights_base.numerator / lms_property_rights_base.denominator)) * (lms_categorized_reserve_base.recovery_percentage / '100'::numeric)) * (lms_categorized_reserve_base.wash_percentage / '100'::numeric))))" " Sort Method: quicksort Memory: 1087kB" " -> GroupAggregate (cost=529701.18..529701.36 rows=1 width=574) (actual time=2695914.626..2695926.298 rows=3729 loops=1)" " Group Key: so_phci_entity_base.phci_entity_type_f, lms_reserve_sec_region_lkup.reserve_sec_region_name, lms_property_rights_base.ownership_category_f, lms_reserve_minor_class_lkup.reserve_minor_class_k, so_country_state_assoc_lkup.description, (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) * (('100'::numeric - (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'W_Moisture'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) / '100'::numeric))), ((CASE WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END = '0'::numeric) THEN 'Insufficient'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END < 1.2) THEN '< 1.2 lbs'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END < 2.5) THEN '> 1.2 to 2.5 lbs.'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END >= 2.5) THEN '> 2.5 lbs'::text ELSE 'Insufficient'::text END)::character varying), lms_reserve_mining_type_lkup_1.mining_type_display, lms_reserve_mining_type_lkup.mining_type_display, lms_reserve_category_lkup.reserve_category_k, ""*SELECT* 1"".statecode, lms_reserve_mining_type_lkup.mining_type_display, (CASE WHEN (lms_reserve_mining_type_lkup_1.mining_type_display IS NULL) THEN lms_reserve_mining_type_lkup.mining_type_display ELSE lms_reserve_mining_type_lkup_1.mining_type_display END), lms_reserve_stateofmining_lkup.reserve_state_of_mining_code_k, ""*SELECT* 1"".upsid, lms_categorized_reserve_base.coal_acres, lms_categorized_reserve_base.yardage, lms_categorized_reserve_base.avg_thickness, lms_categorized_reserve_base.tons_per_acre_foot, ((((""*SELECT* 1"".statecode)::text || lpad((""*SELECT* 1"".countyfip)::text, 3, '0'::text)) || lpad((""*SELECT* 1"".upno)::text, 5, '0'::text)))" " -> Sort (cost=529701.18..529701.19 rows=1 width=466) (actual time=2695914.606..2695915.531 rows=3853 loops=1)" " Sort Key: so_phci_entity_base.phci_entity_type_f, lms_reserve_sec_region_lkup.reserve_sec_region_name, lms_property_rights_base.ownership_category_f, lms_reserve_minor_class_lkup.reserve_minor_class_k, so_country_state_assoc_lkup.description, (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) * (('100'::numeric - (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'W_Moisture'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) / '100'::numeric))), ((CASE WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END = '0'::numeric) THEN 'Insufficient'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END < 1.2) THEN '< 1.2 lbs'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END < 2.5) THEN '> 1.2 to 2.5 lbs.'::text WHEN (CASE WHEN ((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) = '0'::numeric) THEN '0'::numeric ELSE (((sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)) / (sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END))) * 19981.2) END >= 2.5) THEN '> 2.5 lbs'::text ELSE 'Insufficient'::text END)::character varying), lms_reserve_mining_type_lkup_1.mining_type_display, lms_reserve_mining_type_lkup.mining_type_display, lms_reserve_category_lkup.reserve_category_k, ""*SELECT* 1"".statecode, (CASE WHEN (lms_reserve_mining_type_lkup_1.mining_type_display IS NULL) THEN lms_reserve_mining_type_lkup.mining_type_display ELSE lms_reserve_mining_type_lkup_1.mining_type_display END), lms_reserve_stateofmining_lkup.reserve_state_of_mining_code_k, ""*SELECT* 1"".upsid, lms_categorized_reserve_base.coal_acres, lms_categorized_reserve_base.yardage, lms_categorized_reserve_base.avg_thickness, lms_categorized_reserve_base.tons_per_acre_foot, ((((""*SELECT* 1"".statecode)::text || lpad((""*SELECT* 1"".countyfip)::text, 3, '0'::text)) || lpad((""*SELECT* 1"".upno)::text, 5, '0'::text)))" " Sort Method: quicksort Memory: 1120kB" " -> Nested Loop (cost=485996.66..529701.17 rows=1 width=466) (actual time=31511.519..2695868.984 rows=3853 loops=1)" " Join Filter: ((lms_reserve_area_extension.reserve_entity_sid_c)::text = (so_phci_entity_base.phci_entity_sid_k)::text)" " Rows Removed by Join Filter: 545261" " -> Nested Loop Left Join (cost=485994.37..529674.17 rows=1 width=492) (actual time=31510.763..2695091.652 rows=3867 loops=1)" " -> Nested Loop Left Join (cost=485994.23..529674.00 rows=1 width=499) (actual time=31510.699..2695050.571 rows=3867 loops=1)" " -> Nested Loop Left Join (cost=485993.95..529673.71 rows=1 width=480) (actual time=31510.638..2694918.429 rows=3867 loops=1)" " Join Filter: ((lms_primary_subarea_base_cycle.primarysubarea_sid_k)::text = (lms_upseamreservearea_assoc.primarysubarea_sid_f)::text)" " Rows Removed by Join Filter: 2919666" " -> Nested Loop Left Join (cost=485927.92..529583.08 rows=1 width=438) (actual time=31506.153..2693555.775 rows=3867 loops=1)" " Join Filter: ((lms_categorized_reserve_base.categorized_reserve_sid_k)::text = (lms_catreserve_parmvalues_base.categorized_reserve_sid_c)::text)" " Rows Removed by Join Filter: 642098758" " -> Nested Loop (cost=11988.92..49173.52 rows=1 width=360) (actual time=16879.183..2287032.073 rows=3867 loops=1)" " -> Nested Loop (cost=11988.78..49173.11 rows=1 width=360) (actual time=16879.167..2286967.728 rows=3897 loops=1)" " -> Nested Loop (cost=11988.65..49172.52 rows=1 width=360) (actual time=2693.833..2286525.992 rows=48363 loops=1)" " -> Nested Loop (cost=11988.51..49170.96 rows=1 width=350) (actual time=2693.808..2285352.656 rows=48363 loops=1)" " Join Filter: ((lms_up_seam_reserve_assoc.up_sid_c)::text = (""*SELECT* 1"".upsid)::text)" " Rows Removed by Join Filter: 2871810009" " -> Nested Loop (cost=6486.52..43331.21 rows=1 width=283) (actual time=2192.032..22015.939 rows=49326 loops=1)" " -> Nested Loop (cost=6486.10..43330.59 rows=1 width=270) (actual time=2191.970..20389.934 rows=51096 loops=1)" " Join Filter: ((entity_base.entity_sid_k)::text = (so_phci_entity_base.phci_entity_sid_k)::text)" " Rows Removed by Join Filter: 184098888" " -> Index Scan using so_phci_entity_base_pkey on so_phci_entity_base (cost=0.28..157.65 rows=3604 width=30) (actual time=0.007..11.241 rows=3604 loops=1)" " -> Materialize (cost=6485.82..43118.88 rows=1 width=240) (actual time=0.043..2.081 rows=51096 loops=3604)" " -> Nested Loop (cost=6485.82..43118.88 rows=1 width=240) (actual time=155.904..1885.756 rows=51096 loops=1)" " -> Nested Loop (cost=6485.53..43118.57 rows=1 width=224) (actual time=155.883..1610.873 rows=51096 loops=1)" " -> Nested Loop (cost=6485.11..43118.11 rows=1 width=172) (actual time=155.611..1211.386 rows=51217 loops=1)" " -> Hash Join (cost=6484.69..43117.63 rows=1 width=198) (actual time=155.508..820.705 rows=52841 loops=1)" " Hash Cond: (((lms_doc_property_rights_assoc.doc_sid_c)::text = (lms_doc_propright_status_assoc.doc_sid_c)::text) AND ((lms_property_rights_base.property_sid_k)::text = (lms_doc_propright_status_assoc.property_sid_c)::text))" " -> Append (cost=5832.77..40901.92 rows=89359 width=614) (actual time=152.309..774.394 rows=182799 loops=1)" " -> Hash Join (cost=5832.77..11802.58 rows=82431 width=125) (actual time=152.308..255.509 rows=145080 loops=1)" " Hash Cond: ((lms_up_seam_reserve_assoc_1.up_sid_c)::text = (lms_prop_up_assoc.up_sid_c)::text)" " -> Seq Scan on lms_up_seam_reserve_assoc lms_up_seam_reserve_assoc_1 (cost=0.00..3486.59 rows=147459 width=29) (actual time=0.011..16.611 rows=147459 loops=1)" " -> Hash (cost=5574.98..5574.98 rows=20623 width=111) (actual time=152.134..152.138 rows=51704 loops=1)" " Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 7333kB" " -> Nested Loop (cost=1463.28..5574.98 rows=20623 width=111) (actual time=20.344..124.179 rows=51704 loops=1)" " Join Filter: ((lms_property_rights_base.property_sid_k)::text = (lms_prop_up_assoc.property_sid_c)::text)" " -> Hash Join (cost=1462.86..2365.25 rows=2542 width=135) (actual time=20.318..31.170 rows=8845 loops=1)" " Hash Cond: ((lms_doc_property_rights_assoc.property_sid_c)::text = (lms_property_rights_base.property_sid_k)::text)" " -> Seq Scan on lms_doc_property_rights_assoc (cost=0.00..750.98 rows=33598 width=36) (actual time=0.005..3.159 rows=33598 loops=1)" " -> Hash (cost=1431.09..1431.09 rows=2542 width=99) (actual time=20.288..20.290 rows=8845 loops=1)" " Buckets: 16384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1185kB" " -> Hash Join (cost=1039.63..1431.09 rows=2542 width=99) (actual time=10.213..15.959 rows=8845 loops=1)" " Hash Cond: ((lms_coal_property_rights_base.property_sid_c)::text = (lms_property_rights_base.property_sid_k)::text)" " -> Seq Scan on lms_coal_property_rights_base (cost=0.00..365.10 rows=10040 width=43) (actual time=0.007..1.867 rows=10040 loops=1)" " Filter: ((how_to_use_seam_assoc_f)::text = 'ALL'::text)" " Rows Removed by Filter: 5488" " -> Hash (cost=933.32..933.32 rows=8505 width=56) (actual time=10.115..10.115 rows=13269 loops=1)" " Buckets: 16384 Batches: 1 Memory Usage: 1280kB" " -> Index Scan using prop_rights_coalyn_idx on lms_property_rights_base (cost=0.29..933.32 rows=8505 width=56) (actual time=0.022..6.392 rows=13269 loops=1)" " Index Cond: ((coal_rights_yn)::text = 'Y'::text)" " Filter: ((ownership_category_f)::text = ANY ('{LEASED,OPTION,OWNED}'::text[]))" " Rows Removed by Filter: 2303" " -> Index Only Scan using lms_prop_up_assoc_pkey on lms_prop_up_assoc (cost=0.42..0.98 rows=23 width=33) (actual time=0.007..0.009 rows=6 loops=8845)" " Index Cond: (property_sid_c = (lms_doc_property_rights_assoc.property_sid_c)::text)" " Heap Fetches: 51704" " -> Nested Loop (cost=245.65..3519.18 rows=450 width=125) (actual time=1.809..236.381 rows=16481 loops=1)" " Join Filter: ((lms_prop_rights_seam_assoc.seam_sid_c)::text = (lms_up_seam_reserve_assoc_2.seam_sid_c)::text)" " Rows Removed by Join Filter: 34719" " -> Nested Loop (cost=245.23..1872.02 rows=2984 width=125) (actual time=1.658..87.853 rows=21346 loops=1)" " Join Filter: ((lms_property_rights_base_1.property_sid_k)::text = (lms_prop_up_assoc_1.property_sid_c)::text)" " -> Nested Loop (cost=244.81..1407.35 rows=368 width=168) (actual time=1.639..54.652 rows=3419 loops=1)" " -> Nested Loop (cost=244.39..1216.67 rows=368 width=132) (actual time=1.623..32.697 rows=3419 loops=1)" " Join Filter: ((lms_coal_property_rights_base_1.property_sid_c)::text = (lms_property_rights_base_1.property_sid_k)::text)" " -> Hash Join (cost=243.98..407.36 rows=1453 width=76) (actual time=1.596..4.584 rows=4262 loops=1)" " Hash Cond: ((lms_prop_rights_seam_assoc.property_sid_c)::text = (lms_coal_property_rights_base_1.property_sid_c)::text)" " -> Seq Scan on lms_prop_rights_seam_assoc (cost=0.00..142.92 rows=7792 width=33) (actual time=0.012..0.664 rows=7792 loops=1)" " -> Hash (cost=207.78..207.78 rows=2896 width=43) (actual time=1.563..1.564 rows=2896 loops=1)" " Buckets: 4096 Batches: 1 Memory Usage: 241kB" " -> Index Scan using coal_prop_rights_howtouse_idx on lms_coal_property_rights_base lms_coal_property_rights_base_1 (cost=0.29..207.78 rows=2896 width=43) (actual time=0.021..0.945 rows=2896 loops=1)" " Index Cond: ((how_to_use_seam_assoc_f)::text = 'ONLYINCLUDING'::text)" " -> Index Scan using lms_property_rights_base_pkey on lms_property_rights_base lms_property_rights_base_1 (cost=0.41..0.54 rows=1 width=56) (actual time=0.006..0.006 rows=1 loops=4262)" " Index Cond: ((property_sid_k)::text = (lms_prop_rights_seam_assoc.property_sid_c)::text)" " Filter: (((coal_rights_yn)::text = 'Y'::text) AND ((ownership_category_f)::text = ANY ('{LEASED,OPTION,OWNED}'::text[])))" " Rows Removed by Filter: 0" " -> Index Scan using proprights_prop_idx on lms_doc_property_rights_assoc lms_doc_property_rights_assoc_1 (cost=0.41..0.51 rows=1 width=36) (actual time=0.006..0.006 rows=1 loops=3419)" " Index Cond: ((property_sid_c)::text = (lms_property_rights_base_1.property_sid_k)::text)" " -> Index Only Scan using lms_prop_up_assoc_pkey on lms_prop_up_assoc lms_prop_up_assoc_1 (cost=0.42..0.98 rows=23 width=33) (actual time=0.007..0.008 rows=6 loops=3419)" " Index Cond: (property_sid_c = (lms_doc_property_rights_assoc_1.property_sid_c)::text)" " Heap Fetches: 21346" " -> Index Only Scan using lms_up_seam_reserve_assoc_up_sid_c_seam_sid_c_key on lms_up_seam_reserve_assoc lms_up_seam_reserve_assoc_2 (cost=0.42..0.50 rows=4 width=29) (actual time=0.006..0.006 rows=2 loops=21346)" " Index Cond: (up_sid_c = (lms_prop_up_assoc_1.up_sid_c)::text)" " Heap Fetches: 51200" " -> Nested Loop (cost=197.34..21462.37 rows=6421 width=125) (actual time=1.946..182.540 rows=12164 loops=1)" " -> Nested Loop (cost=196.92..1856.65 rows=3213 width=130) (actual time=1.816..34.539 rows=6386 loops=1)" " Join Filter: ((lms_property_rights_base_2.property_sid_k)::text = (lms_prop_up_assoc_2.property_sid_c)::text)" " -> Nested Loop (cost=196.50..1356.63 rows=396 width=135) (actual time=1.735..20.439 rows=1405 loops=1)" " -> Hash Join (cost=196.08..1151.44 rows=396 width=99) (actual time=1.713..9.967 rows=1405 loops=1)" " Hash Cond: ((lms_property_rights_base_2.property_sid_k)::text = (lms_coal_property_rights_base_2.property_sid_c)::text)" " -> Index Scan using prop_rights_coalyn_idx on lms_property_rights_base lms_property_rights_base_2 (cost=0.29..933.32 rows=8505 width=56) (actual time=0.026..6.870 rows=13269 loops=1)" " Index Cond: ((coal_rights_yn)::text = 'Y'::text)" " Filter: ((ownership_category_f)::text = ANY ('{LEASED,OPTION,OWNED}'::text[]))" " Rows Removed by Filter: 2303" " -> Hash (cost=176.26..176.26 rows=1563 width=43) (actual time=1.118..1.119 rows=1563 loops=1)" " Buckets: 2048 Batches: 1 Memory Usage: 123kB" " -> Index Scan using coal_prop_rights_howtouse_idx on lms_coal_property_rights_base lms_coal_property_rights_base_2 (cost=0.29..176.26 rows=1563 width=43) (actual time=0.013..0.673 rows=1563 loops=1)" " Index Cond: ((how_to_use_seam_assoc_f)::text = 'ALLEXCEPT'::text)" " -> Index Scan using proprights_prop_idx on lms_doc_property_rights_assoc lms_doc_property_rights_assoc_2 (cost=0.41..0.51 rows=1 width=36) (actual time=0.007..0.007 rows=1 loops=1405)" " Index Cond: ((property_sid_c)::text = (lms_property_rights_base_2.property_sid_k)::text)" " -> Index Only Scan using lms_prop_up_assoc_pkey on lms_prop_up_assoc lms_prop_up_assoc_2 (cost=0.42..0.98 rows=23 width=33) (actual time=0.007..0.009 rows=5 loops=1405)" " Index Cond: (property_sid_c = (lms_doc_property_rights_assoc_2.property_sid_c)::text)" " Heap Fetches: 6386" " -> Index Only Scan using lms_up_seam_reserve_assoc_up_sid_c_seam_sid_c_key on lms_up_seam_reserve_assoc lms_up_seam_reserve_assoc_3 (cost=0.42..6.08 rows=2 width=29) (actual time=0.012..0.023 rows=2 loops=6386)" " Index Cond: (up_sid_c = (lms_prop_up_assoc_2.up_sid_c)::text)" " Filter: (NOT (SubPlan 1))" " Rows Removed by Filter: 1" " Heap Fetches: 19137" " SubPlan 1" " -> Index Only Scan using lms_prop_rights_seam_assoc_pkey on lms_prop_rights_seam_assoc lms_prop_rights_seam_assoc_5 (cost=0.28..2.50 rows=1 width=14) (actual time=0.004..0.005 rows=1 loops=19137)" " Index Cond: (property_sid_c = (lms_prop_up_assoc_2.property_sid_c)::text)" " Heap Fetches: 28011" " -> Hash Join (cost=256.52..745.92 rows=16 width=125) (actual time=1.901..24.634 rows=2413 loops=1)" " Hash Cond: (((lms_property_rights_base_3.state_code_f)::text = (so_seam_base_1.state_f)::text) AND ((lms_up_seam_reserve_assoc_4.seam_sid_c)::text = (so_seam_base_1.seam_sid_k)::text))" " Join Filter: (so_seam_base_1.seam_order < so_seam_base.seam_order)" " Rows Removed by Join Filter: 2890" " -> Nested Loop (cost=139.87..622.95 rows=1203 width=133) (actual time=0.444..21.089 rows=5303 loops=1)" " -> Nested Loop (cost=139.45..459.81 rows=301 width=119) (actual time=0.427..9.631 rows=1164 loops=1)" " Join Filter: ((lms_property_rights_base_3.property_sid_k)::text = (lms_prop_up_assoc_3.property_sid_c)::text)" " -> Nested Loop (cost=139.03..413.09 rows=37 width=162) (actual time=0.383..7.099 rows=205 loops=1)" " -> Nested Loop (cost=138.75..401.79 rows=37 width=168) (actual time=0.369..6.030 rows=205 loops=1)" " -> Nested Loop (cost=138.33..382.62 rows=37 width=132) (actual time=0.356..4.340 rows=205 loops=1)" " Join Filter: ((lms_coal_property_rights_base_3.property_sid_c)::text = (lms_property_rights_base_3.property_sid_k)::text)" " -> Hash Join (cost=137.92..301.30 rows=146 width=76) (actual time=0.313..1.932 rows=291 loops=1)" " Hash Cond: ((lms_prop_rights_seam_assoc_1.property_sid_c)::text = (lms_coal_property_rights_base_3.property_sid_c)::text)" " -> Seq Scan on lms_prop_rights_seam_assoc lms_prop_rights_seam_assoc_1 (cost=0.00..142.92 rows=7792 width=33) (actual time=0.010..0.705 rows=7792 loops=1)" " -> Hash (cost=134.28..134.28 rows=291 width=43) (actual time=0.271..0.271 rows=291 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 28kB" " -> Index Scan using coal_prop_rights_howtouse_idx on lms_coal_property_rights_base lms_coal_property_rights_base_3 (cost=0.29..134.28 rows=291 width=43) (actual time=0.017..0.173 rows=291 loops=1)" " Index Cond: ((how_to_use_seam_assoc_f)::text = 'ALLABOVE'::text)" " -> Index Scan using lms_property_rights_base_pkey on lms_property_rights_base lms_property_rights_base_3 (cost=0.41..0.54 rows=1 width=56) (actual time=0.008..0.008 rows=1 loops=291)" " Index Cond: ((property_sid_k)::text = (lms_prop_rights_seam_assoc_1.property_sid_c)::text)" " Filter: (((coal_rights_yn)::text = 'Y'::text) AND ((ownership_category_f)::text = ANY ('{LEASED,OPTION,OWNED}'::text[])))" " Rows Removed by Filter: 0" " -> Index Scan using proprights_prop_idx on lms_doc_property_rights_assoc lms_doc_property_rights_assoc_3 (cost=0.41..0.51 rows=1 width=36) (actual time=0.007..0.007 rows=1 loops=205)" " Index Cond: ((property_sid_c)::text = (lms_property_rights_base_3.property_sid_k)::text)" " -> Index Scan using so_seam_base_pkey on so_seam_base (cost=0.28..0.31 rows=1 width=22) (actual time=0.004..0.004 rows=1 loops=205)" " Index Cond: ((seam_sid_k)::text = (lms_prop_rights_seam_assoc_1.seam_sid_c)::text)" " -> Index Only Scan using lms_prop_up_assoc_pkey on lms_prop_up_assoc lms_prop_up_assoc_3 (cost=0.42..0.98 rows=23 width=33) (actual time=0.009..0.011 rows=6 loops=205)" " Index Cond: (property_sid_c = (lms_doc_property_rights_assoc_3.property_sid_c)::text)" " Heap Fetches: 1164" " -> Index Only Scan using lms_up_seam_reserve_assoc_up_sid_c_seam_sid_c_key on lms_up_seam_reserve_assoc lms_up_seam_reserve_assoc_4 (cost=0.42..0.50 rows=4 width=29) (actual time=0.007..0.009 rows=5 loops=1164)" " Index Cond: (up_sid_c = (lms_prop_up_assoc_3.up_sid_c)::text)" " Heap Fetches: 5303" " -> Hash (cost=71.86..71.86 rows=2986 width=25) (actual time=1.384..1.384 rows=2986 loops=1)" " Buckets: 4096 Batches: 1 Memory Usage: 201kB" " -> Seq Scan on so_seam_base so_seam_base_1 (cost=0.00..71.86 rows=2986 width=25) (actual time=0.016..0.615 rows=2986 loops=1)" " -> Hash Join (cost=269.87..827.58 rows=19 width=125) (actual time=1.428..24.152 rows=2738 loops=1)" " Hash Cond: (((lms_property_rights_base_4.state_code_f)::text = (so_seam_base_3.state_f)::text) AND ((lms_up_seam_reserve_assoc_5.seam_sid_c)::text = (so_seam_base_3.seam_sid_k)::text))" " Join Filter: (so_seam_base_3.seam_order <= so_seam_base_2.seam_order)" " Rows Removed by Join Filter: 2370" " -> Nested Loop (cost=153.22..703.33 rows=1448 width=133) (actual time=0.401..21.348 rows=5108 loops=1)" " -> Nested Loop (cost=152.80..507.12 rows=362 width=119) (actual time=0.388..9.908 rows=1467 loops=1)" " Join Filter: ((lms_property_rights_base_4.property_sid_k)::text = (lms_prop_up_assoc_4.property_sid_c)::text)" " -> Nested Loop (cost=152.38..450.30 rows=45 width=162) (actual time=0.372..7.193 rows=238 loops=1)" " -> Nested Loop (cost=152.10..436.56 rows=45 width=168) (actual time=0.358..5.970 rows=238 loops=1)" " -> Nested Loop (cost=151.69..413.24 rows=45 width=132) (actual time=0.344..4.224 rows=238 loops=1)" " Join Filter: ((lms_coal_property_rights_base_4.property_sid_c)::text = (lms_property_rights_base_4.property_sid_k)::text)" " -> Hash Join (cost=151.27..314.66 rows=177 width=76) (actual time=0.326..1.659 rows=352 loops=1)" " Hash Cond: ((lms_prop_rights_seam_assoc_2.property_sid_c)::text = (lms_coal_property_rights_base_4.property_sid_c)::text)" " -> Seq Scan on lms_prop_rights_seam_assoc lms_prop_rights_seam_assoc_2 (cost=0.00..142.92 rows=7792 width=33) (actual time=0.005..0.527 rows=7792 loops=1)" " -> Hash (cost=146.87..146.87 rows=352 width=43) (actual time=0.305..0.306 rows=352 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 34kB" " -> Index Scan using coal_prop_rights_howtouse_idx on lms_coal_property_rights_base lms_coal_property_rights_base_4 (cost=0.29..146.87 rows=352 width=43) (actual time=0.023..0.176 rows=352 loops=1)" " Index Cond: ((how_to_use_seam_assoc_f)::text = 'ABOVEINCLUDING'::text)" " -> Index Scan using lms_property_rights_base_pkey on lms_property_rights_base lms_property_rights_base_4 (cost=0.41..0.54 rows=1 width=56) (actual time=0.007..0.007 rows=1 loops=352)" " Index Cond: ((property_sid_k)::text = (lms_prop_rights_seam_assoc_2.property_sid_c)::text)" " Filter: (((coal_rights_yn)::text = 'Y'::text) AND ((ownership_category_f)::text = ANY ('{LEASED,OPTION,OWNED}'::text[])))" " Rows Removed by Filter: 0" " -> Index Scan using proprights_prop_idx on lms_doc_property_rights_assoc lms_doc_property_rights_assoc_4 (cost=0.41..0.51 rows=1 width=36) (actual time=0.006..0.007 rows=1 loops=238)" " Index Cond: ((property_sid_c)::text = (lms_property_rights_base_4.property_sid_k)::text)" " -> Index Scan using so_seam_base_pkey on so_seam_base so_seam_base_2 (cost=0.28..0.31 rows=1 width=22) (actual time=0.004..0.004 rows=1 loops=238)" " Index Cond: ((seam_sid_k)::text = (lms_prop_rights_seam_assoc_2.seam_sid_c)::text)" " -> Index Only Scan using lms_prop_up_assoc_pkey on lms_prop_up_assoc lms_prop_up_assoc_4 (cost=0.42..0.98 rows=23 width=33) (actual time=0.008..0.010 rows=6 loops=238)" " Index Cond: (property_sid_c = (lms_doc_property_rights_assoc_4.property_sid_c)::text)" " Heap Fetches: 1467" " -> Index Only Scan using lms_up_seam_reserve_assoc_up_sid_c_seam_sid_c_key on lms_up_seam_reserve_assoc lms_up_seam_reserve_assoc_5 (cost=0.42..0.50 rows=4 width=29) (actual time=0.006..0.007 rows=3 loops=1467)" " Index Cond: (up_sid_c = (lms_prop_up_assoc_4.up_sid_c)::text)" " Heap Fetches: 5108" " -> Hash (cost=71.86..71.86 rows=2986 width=25) (actual time=0.979..0.979 rows=2986 loops=1)" " Buckets: 4096 Batches: 1 Memory Usage: 201kB" " -> Seq Scan on so_seam_base so_seam_base_3 (cost=0.00..71.86 rows=2986 width=25) (actual time=0.012..0.404 rows=2986 loops=1)" " -> Hash Join (cost=248.22..707.80 rows=14 width=125) (actual time=1.320..22.266 rows=1677 loops=1)" " Hash Cond: (((lms_property_rights_base_5.state_code_f)::text = (so_seam_base_5.state_f)::text) AND ((lms_up_seam_reserve_assoc_6.seam_sid_c)::text = (so_seam_base_5.seam_sid_k)::text))" " Join Filter: (so_seam_base_5.seam_order > so_seam_base_4.seam_order)" " Rows Removed by Join Filter: 3777" " -> Nested Loop (cost=131.57..585.42 rows=1091 width=133) (actual time=0.297..19.411 rows=5454 loops=1)" " -> Nested Loop (cost=131.15..437.46 rows=273 width=119) (actual time=0.284..8.623 rows=1374 loops=1)" " Join Filter: ((lms_property_rights_base_5.property_sid_k)::text = (lms_prop_up_assoc_5.property_sid_c)::text)" " -> Nested Loop (cost=130.73..394.53 rows=34 width=162) (actual time=0.265..6.118 rows=242 loops=1)" " -> Nested Loop (cost=130.45..384.14 rows=34 width=168) (actual time=0.256..4.968 rows=242 loops=1)" " -> Nested Loop (cost=130.03..366.53 rows=34 width=132) (actual time=0.241..3.322 rows=242 loops=1)" " Join Filter: ((lms_coal_property_rights_base_5.property_sid_c)::text = (lms_property_rights_base_5.property_sid_k)::text)" " -> Hash Join (cost=129.62..293.00 rows=132 width=76) (actual time=0.225..1.382 rows=264 loops=1)" " Hash Cond: ((lms_prop_rights_seam_assoc_3.property_sid_c)::text = (lms_coal_property_rights_base_5.property_sid_c)::text)" " -> Seq Scan on lms_prop_rights_seam_assoc lms_prop_rights_seam_assoc_3 (cost=0.00..142.92 rows=7792 width=33) (actual time=0.004..0.398 rows=7792 loops=1)" " -> Hash (cost=126.32..126.32 rows=264 width=43) (actual time=0.209..0.209 rows=264 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 26kB" " -> Index Scan using coal_prop_rights_howtouse_idx on lms_coal_property_rights_base lms_coal_property_rights_base_5 (cost=0.29..126.32 rows=264 width=43) (actual time=0.012..0.120 rows=264 loops=1)" " Index Cond: ((how_to_use_seam_assoc_f)::text = 'ALLBELOW'::text)" " -> Index Scan using lms_property_rights_base_pkey on lms_property_rights_base lms_property_rights_base_5 (cost=0.41..0.54 rows=1 width=56) (actual time=0.007..0.007 rows=1 loops=264)" " Index Cond: ((property_sid_k)::text = (lms_prop_rights_seam_assoc_3.property_sid_c)::text)" " Filter: (((coal_rights_yn)::text = 'Y'::text) AND ((ownership_category_f)::text = ANY ('{LEASED,OPTION,OWNED}'::text[])))" " Rows Removed by Filter: 0" " -> Index Scan using proprights_prop_idx on lms_doc_property_rights_assoc lms_doc_property_rights_assoc_5 (cost=0.41..0.51 rows=1 width=36) (actual time=0.006..0.006 rows=1 loops=242)" " Index Cond: ((property_sid_c)::text = (lms_property_rights_base_5.property_sid_k)::text)" " -> Index Scan using so_seam_base_pkey on so_seam_base so_seam_base_4 (cost=0.28..0.31 rows=1 width=22) (actual time=0.004..0.004 rows=1 loops=242)" " Index Cond: ((seam_sid_k)::text = (lms_prop_rights_seam_assoc_3.seam_sid_c)::text)" " -> Index Only Scan using lms_prop_up_assoc_pkey on lms_prop_up_assoc lms_prop_up_assoc_5 (cost=0.42..0.98 rows=23 width=33) (actual time=0.007..0.009 rows=6 loops=242)" " Index Cond: (property_sid_c = (lms_doc_property_rights_assoc_5.property_sid_c)::text)" " Heap Fetches: 1374" " -> Index Only Scan using lms_up_seam_reserve_assoc_up_sid_c_seam_sid_c_key on lms_up_seam_reserve_assoc lms_up_seam_reserve_assoc_6 (cost=0.42..0.50 rows=4 width=29) (actual time=0.006..0.007 rows=4 loops=1374)" " Index Cond: (up_sid_c = (lms_prop_up_assoc_5.up_sid_c)::text)" " Heap Fetches: 5455" " -> Hash (cost=71.86..71.86 rows=2986 width=25) (actual time=0.946..0.946 rows=2986 loops=1)" " Buckets: 4096 Batches: 1 Memory Usage: 201kB" " -> Seq Scan on so_seam_base so_seam_base_5 (cost=0.00..71.86 rows=2986 width=25) (actual time=0.008..0.422 rows=2986 loops=1)" " -> Hash Join (cost=196.38..496.11 rows=7 width=125) (actual time=1.241..19.966 rows=2246 loops=1)" " Hash Cond: (((lms_property_rights_base_6.state_code_f)::text = (so_seam_base_7.state_f)::text) AND ((lms_up_seam_reserve_assoc_7.seam_sid_c)::text = (so_seam_base_7.seam_sid_k)::text))" " Join Filter: (so_seam_base_7.seam_order >= so_seam_base_6.seam_order)" " Rows Removed by Join Filter: 1363" " -> Nested Loop (cost=79.73..376.81 rows=505 width=133) (actual time=0.228..17.326 rows=3609 loops=1)" " -> Nested Loop (cost=79.31..308.52 rows=126 width=119) (actual time=0.210..6.704 rows=1059 loops=1)" " Join Filter: ((lms_property_rights_base_6.property_sid_k)::text = (lms_prop_up_assoc_6.property_sid_c)::text)" " -> Nested Loop (cost=78.89..288.32 rows=16 width=162) (actual time=0.185..4.899 rows=109 loops=1)" " -> Nested Loop (cost=78.61..283.43 rows=16 width=168) (actual time=0.175..4.001 rows=109 loops=1)" " -> Nested Loop (cost=78.19..275.14 rows=16 width=132) (actual time=0.163..2.886 rows=109 loops=1)" " Join Filter: ((lms_coal_property_rights_base_6.property_sid_c)::text = (lms_property_rights_base_6.property_sid_k)::text)" " -> Hash Join (cost=77.78..241.16 rows=61 width=76) (actual time=0.145..1.573 rows=122 loops=1)" " Hash Cond: ((lms_prop_rights_seam_assoc_4.property_sid_c)::text = (lms_coal_property_rights_base_6.property_sid_c)::text)" " -> Seq Scan on lms_prop_rights_seam_assoc lms_prop_rights_seam_assoc_4 (cost=0.00..142.92 rows=7792 width=33) (actual time=0.006..0.581 rows=7792 loops=1)" " -> Hash (cost=76.25..76.25 rows=122 width=43) (actual time=0.104..0.105 rows=122 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 17kB" " -> Index Scan using coal_prop_rights_howtouse_idx on lms_coal_property_rights_base lms_coal_property_rights_base_6 (cost=0.29..76.25 rows=122 width=43) (actual time=0.013..0.079 rows=122 loops=1)" " Index Cond: ((how_to_use_seam_assoc_f)::text = 'BELOWINCLUDING'::text)" " -> Index Scan using lms_property_rights_base_pkey on lms_property_rights_base lms_property_rights_base_6 (cost=0.41..0.54 rows=1 width=56) (actual time=0.009..0.009 rows=1 loops=122)" " Index Cond: ((property_sid_k)::text = (lms_prop_rights_seam_assoc_4.property_sid_c)::text)" " Filter: (((coal_rights_yn)::text = 'Y'::text) AND ((ownership_category_f)::text = ANY ('{LEASED,OPTION,OWNED}'::text[])))" " Rows Removed by Filter: 0" " -> Index Scan using proprights_prop_idx on lms_doc_property_rights_assoc lms_doc_property_rights_assoc_6 (cost=0.41..0.51 rows=1 width=36) (actual time=0.009..0.009 rows=1 loops=109)" " Index Cond: ((property_sid_c)::text = (lms_property_rights_base_6.property_sid_k)::text)" " -> Index Scan using so_seam_base_pkey on so_seam_base so_seam_base_6 (cost=0.28..0.31 rows=1 width=22) (actual time=0.006..0.006 rows=1 loops=109)" " Index Cond: ((seam_sid_k)::text = (lms_prop_rights_seam_assoc_4.seam_sid_c)::text)" " -> Index Only Scan using lms_prop_up_assoc_pkey on lms_prop_up_assoc lms_prop_up_assoc_6 (cost=0.42..0.98 rows=23 width=33) (actual time=0.010..0.013 rows=10 loops=109)" " Index Cond: (property_sid_c = (lms_doc_property_rights_assoc_6.property_sid_c)::text)" " Heap Fetches: 1059" " -> Index Only Scan using lms_up_seam_reserve_assoc_up_sid_c_seam_sid_c_key on lms_up_seam_reserve_assoc lms_up_seam_reserve_assoc_7 (cost=0.42..0.50 rows=4 width=29) (actual time=0.007..0.009 rows=3 loops=1059)" " Index Cond: (up_sid_c = (lms_prop_up_assoc_6.up_sid_c)::text)" " Heap Fetches: 3609" " -> Hash (cost=71.86..71.86 rows=2986 width=25) (actual time=0.910..0.911 rows=2986 loops=1)" " Buckets: 4096 Batches: 1 Memory Usage: 201kB" " -> Seq Scan on so_seam_base so_seam_base_7 (cost=0.00..71.86 rows=2986 width=25) (actual time=0.009..0.381 rows=2986 loops=1)" " -> Subquery Scan on ""*SELECT* 8"" (cost=0.00..0.00 rows=1 width=301) (actual time=0.001..0.001 rows=0 loops=1)" " -> Result (cost=0.00..0.00 rows=0 width=297) (actual time=0.000..0.001 rows=0 loops=1)" " One-Time Filter: false" " -> Hash (cost=571.61..571.61 rows=5354 width=36) (actual time=3.149..3.150 rows=5355 loops=1)" " Buckets: 8192 Batches: 1 Memory Usage: 431kB" " -> Index Scan using idx_status_f on lms_doc_propright_status_assoc (cost=0.29..571.61 rows=5354 width=36) (actual time=0.020..1.997 rows=5355 loops=1)" " Index Cond: ((status_f)::text = 'ACQUIRED'::text)" " -> Index Scan using lms_up_seam_reserve_assoc_up_sid_c_seam_sid_c_key on lms_up_seam_reserve_assoc (cost=0.42..0.48 rows=1 width=46) (actual time=0.007..0.007 rows=1 loops=52841)" " Index Cond: (((up_sid_c)::text = (lms_prop_up_assoc.up_sid_c)::text) AND ((seam_sid_c)::text = (lms_up_seam_reserve_assoc_1.seam_sid_c)::text))" " Filter: ((lms_up_seam_status_f)::text = 'ACTIVE'::text)" " Rows Removed by Filter: 0" " -> Index Scan using lms_upseamreservearea_assoc_pkey on lms_upseamreservearea_assoc (cost=0.42..0.46 rows=1 width=52) (actual time=0.007..0.007 rows=1 loops=51217)" " Index Cond: ((up_seam_reserve_sid_c)::text = (lms_up_seam_reserve_assoc.up_seam_reserve_sid_k)::text)" " -> Index Only Scan using entity_base_pkey on entity_base (cost=0.29..0.31 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=51096)" " Index Cond: (entity_sid_k = (lms_upseamreservearea_assoc.reserve_entity_sid_f)::text)" " Heap Fetches: 51096" " -> Index Scan using lms_categorized_reserve_base_up_seam_reserve_sid_lf_reserve_key on lms_categorized_reserve_base (cost=0.42..0.60 rows=2 width=64) (actual time=0.024..0.029 rows=1 loops=51096)" " Index Cond: ((up_seam_reserve_sid_lf)::text = (lms_up_seam_reserve_assoc.up_seam_reserve_sid_k)::text)" " Filter: (coal_acres > '0'::numeric)" " Rows Removed by Filter: 2" " -> HashAggregate (cost=5501.99..5605.92 rows=10393 width=1818) (actual time=0.011..42.496 rows=58222 loops=49326)" " Group Key: ""*SELECT* 1"".reservecyclesid, ""*SELECT* 1"".upsid, ""*SELECT* 1"".countrycode, ""*SELECT* 1"".statecode, ""*SELECT* 1"".countyfip, ""*SELECT* 1"".upno, ""*SELECT* 1"".sec, ""*SELECT* 1"".twn, ""*SELECT* 1"".twn_ns, ""*SELECT* 1"".rng, ""*SELECT* 1"".rng_ew, ""*SELECT* 1"".acres, ""*SELECT* 1"".calcacres, ""*SELECT* 1"".srcecode, ""*SELECT* 1"".adddate, ""*SELECT* 1"".addempno, ""*SELECT* 1"".lastmoddate, ""*SELECT* 1"".lastmodempno, ""*SELECT* 1"".activeyn, ""*SELECT* 1"".inactdate, ""*SELECT* 1"".inactempno, ""*SELECT* 1"".lbllocx, ""*SELECT* 1"".lbllocy, ""*SELECT* 1"".lbllocsrce, ""*SELECT* 1"".verempno, ""*SELECT* 1"".verdate, ""*SELECT* 1"".bndverempno, ""*SELECT* 1"".bndverdate, ((""*SELECT* 1"".minx)::double precision), ""*SELECT* 1"".miny, ((""*SELECT* 1"".maxx)::double precision), ""*SELECT* 1"".maxy, ""*SELECT* 1"".modts, ""*SELECT* 1"".locationtext, ""*SELECT* 1"".remarks" " -> Append (cost=0.43..4592.60 rows=10393 width=1818) (actual time=170.661..380.695 rows=58222 loops=1)" " -> Subquery Scan on ""*SELECT* 1"" (cost=0.43..2.05 rows=1 width=291) (actual time=1.219..1.220 rows=0 loops=1)" " -> Index Scan using lms_up_cycle_base_pkey on lms_up_cycle_base (cost=0.43..2.03 rows=1 width=295) (actual time=1.218..1.218 rows=0 loops=1)" " Index Cond: (reserve_cycle_sid_c IS NULL)" " -> Subquery Scan on ""*SELECT* 2"" (cost=3264.27..4538.59 rows=10392 width=570) (actual time=169.441..375.875 rows=58222 loops=1)" " -> Hash Join (cost=3264.27..4226.83 rows=10392 width=360) (actual time=169.435..340.367 rows=58222 loops=1)" " Hash Cond: ((unit_property.up_sid_c)::text = (lms_up_base.up_sid_k)::text)" " -> HashAggregate (cost=833.55..1509.03 rows=10392 width=544) (actual time=114.847..239.655 rows=58224 loops=1)" " Group Key: unit_property.up_sid_c, unit_property.geometry, unit_property.mod_user, unit_property.updated_ts" " -> Nested Loop (cost=2.34..677.67 rows=10392 width=328) (actual time=0.125..43.217 rows=58224 loops=1)" " -> Hash Join (cost=1.92..6.59 rows=207 width=19) (actual time=0.074..0.233 rows=207 loops=1)" " Hash Cond: ((state_county_coordinate_assoc.coordinate_system_c)::text = (lms_valid_coordinate_assoc.coordinate_system_k)::text)" " -> Seq Scan on state_county_coordinate_assoc (cost=0.00..4.07 rows=207 width=20) (actual time=0.014..0.038 rows=207 loops=1)" " -> Hash (cost=1.41..1.41 rows=41 width=17) (actual time=0.041..0.042 rows=41 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 10kB" " -> Seq Scan on lms_valid_coordinate_assoc (cost=0.00..1.41 rows=41 width=17) (actual time=0.008..0.014 rows=41 loops=1)" " -> Index Scan using idx_unit_property_multicolumn on unit_property (cost=0.41..3.21 rows=3 width=331) (actual time=0.014..0.125 rows=281 loops=207)" " Index Cond: (((country_code)::text = (state_county_coordinate_assoc.country_code_c)::text) AND ((county_fip)::text = (state_county_coordinate_assoc.county_fip_c)::text) AND ((state_code)::text = (state_county_coordinate_assoc.state_code_c)::text))" " -> Hash (cost=1673.65..1673.65 rows=60565 width=172) (actual time=54.512..54.513 rows=60565 loops=1)" " Buckets: 65536 Batches: 1 Memory Usage: 8683kB" " -> Seq Scan on lms_up_base (cost=0.00..1673.65 rows=60565 width=172) (actual time=0.017..25.277 rows=60565 loops=1)" " -> Index Scan using so_country_state_assoc_lkup_pkey on so_country_state_assoc_lkup (cost=0.14..1.55 rows=1 width=13) (actual time=0.018..0.019 rows=1 loops=48363)" " Index Cond: ((state_code_k)::text = (""*SELECT* 1"".statecode)::text)" " -> Index Only Scan using lms_reserve_category_lkup_pkey on lms_reserve_category_lkup (cost=0.13..0.44 rows=1 width=2) (actual time=0.003..0.003 rows=0 loops=48363)" " Index Cond: ((reserve_category_k = lms_categorized_reserve_base.reserve_category_lf) AND (reserve_category_k = ANY ('{1,2,3}'::integer[])))" " Heap Fetches: 3897" " -> Index Only Scan using lms_reserve_minor_class_lkup_pkey on lms_reserve_minor_class_lkup (cost=0.13..0.30 rows=1 width=3) (actual time=0.006..0.006 rows=1 loops=3897)" " Index Cond: ((reserve_minor_class_k = (lms_categorized_reserve_base.reserve_minor_class_lf)::text) AND (reserve_minor_class_k = ANY ('{ID,MS}'::text[])))" " Heap Fetches: 3867" " -> HashAggregate (cost=473939.00..475929.94 rows=199094 width=594) (actual time=3.766..94.857 rows=166047 loops=3867)" " Group Key: lms_catreserve_parmvalues_base.categorized_reserve_sid_c, sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'AdAsh'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'AdBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'AdMoisture'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'AdSulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryAsh'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DryBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'DrySulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'EqAsh'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'EqBTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'EqSulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'EquilibriumMoisture'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'Moisture'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'Sodium'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'W_Ash'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'W_BTU'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'W_Moisture'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'W_Sulfur'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END), sum(CASE WHEN ((lms_catreserve_parmvalues_base.parameter_code_c)::text = 'Total_Depth_Feet'::text) THEN (translate((lms_catreserve_parmvalues_base.parameter_value)::text, '1234567890+&<>!@#$%'::text, '1234567890'::text))::numeric ELSE '0'::numeric END)" " -> Finalize GroupAggregate (cost=370240.97..464482.04 rows=199094 width=594) (actual time=10152.183..14085.640 rows=333656 loops=1)" " Group Key: lms_catreserve_parmvalues_base.categorized_reserve_sid_c" " -> Gather Merge (cost=370240.97..416699.48 rows=398188 width=594) (actual time=10152.130..10688.560 rows=474105 loops=1)" " Workers Planned: 2" " Workers Launched: 2" " -> Sort (cost=369240.95..369738.68 rows=199094 width=594) (actual time=9885.123..9901.666 rows=158035 loops=3)" " Sort Key: lms_catreserve_parmvalues_base.categorized_reserve_sid_c" " Sort Method: quicksort Memory: 168383kB" " Worker 0: Sort Method: quicksort Memory: 164541kB" " Worker 1: Sort Method: quicksort Memory: 167022kB" " -> Partial HashAggregate (cost=340767.43..351717.60 rows=199094 width=594) (actual time=6733.792..8283.508 rows=158035 loops=3)" " Group Key: lms_catreserve_parmvalues_base.categorized_reserve_sid_c" " -> Parallel Seq Scan on lms_catreserve_parmvalues_base (cost=0.00..45016.06 rows=1300006 width=35) (actual time=0.333..2148.474 rows=1039995 loops=3)" " -> HashAggregate (cost=66.03..73.60 rows=757 width=912) (actual time=0.003..0.304 rows=756 loops=3867)" " Group Key: lms_primary_subarea_base_cycle.reserve_cycle_sid_c, lms_primary_subarea_base_cycle.primarysubarea_sid_k, lms_primary_subarea_base_cycle.reserve_entity_sid_c, lms_primary_subarea_base_cycle.primary_subarea_name, lms_primary_subarea_base_cycle.primarysubarea_desc, lms_primary_subarea_base_cycle.reserve_mining_type_code_k, lms_primary_subarea_base_cycle.reserve_state_of_mining_code_k, (NULL::character varying), lms_primary_subarea_base_cycle.mod_ts, lms_primary_subarea_base_cycle.last_modified_by, lms_reserve_mining_type_lkup_1.mining_type_display" " -> Append (cost=0.41..45.22 rows=757 width=912) (actual time=1.908..2.733 rows=756 loops=1)" " -> Nested Loop (cost=0.41..3.45 rows=1 width=207) (actual time=1.729..1.729 rows=0 loops=1)" " Join Filter: (lms_primary_subarea_base_cycle.reserve_mining_type_code_k = lms_reserve_mining_type_lkup_1.reserve_mining_type_code_k)" " -> Index Scan using lms_primary_subarea_base_cycle_pkey on lms_primary_subarea_base_cycle (cost=0.41..2.38 rows=1 width=167) (actual time=1.727..1.727 rows=0 loops=1)" " Index Cond: (reserve_cycle_sid_c IS NULL)" " -> Seq Scan on lms_reserve_mining_type_lkup lms_reserve_mining_type_lkup_1 (cost=0.00..1.03 rows=3 width=10) (never executed)" " -> Hash Join (cost=1.07..30.42 rows=756 width=196) (actual time=0.172..0.926 rows=756 loops=1)" " Hash Cond: (lms_primary_subarea_base.reserve_mining_type_code_k = lms_reserve_mining_type_lkup_2.reserve_mining_type_code_k)" " -> Seq Scan on lms_primary_subarea_base (cost=0.00..24.56 rows=756 width=156) (actual time=0.028..0.218 rows=756 loops=1)" " -> Hash (cost=1.03..1.03 rows=3 width=10) (actual time=0.107..0.108 rows=3 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 9kB" " -> Seq Scan on lms_reserve_mining_type_lkup lms_reserve_mining_type_lkup_2 (cost=0.00..1.03 rows=3 width=10) (actual time=0.067..0.070 rows=3 loops=1)" " -> Index Scan using lms_reserve_sec_report_assoc_pkey on lms_reserve_sec_report_assoc (cost=0.27..0.29 rows=1 width=38) (actual time=0.027..0.027 rows=1 loops=3867)" " Index Cond: ((entity_base.entity_sid_k)::text = (reserve_entity_sid_c)::text)" " -> Index Scan using lms_reserve_sec_region_lkup_pkey on lms_reserve_sec_region_lkup (cost=0.14..0.17 rows=1 width=31) (actual time=0.006..0.006 rows=1 loops=3867)" " Index Cond: ((lms_reserve_sec_report_assoc.reserve_sec_region_sid_lf)::text = (reserve_sec_region_sid_k)::text)" " -> Hash Left Join (cost=2.30..25.76 rows=94 width=29) (actual time=0.011..0.163 rows=142 loops=3867)" " Hash Cond: (lms_reserve_area_extension.reserve_mining_type_code_k = lms_reserve_mining_type_lkup.reserve_mining_type_code_k)" " -> Hash Join (cost=1.23..24.10 rows=94 width=23) (actual time=0.009..0.136 rows=142 loops=3867)" " Hash Cond: (lms_reserve_area_extension.reserve_state_of_mining_code_k = lms_reserve_stateofmining_lkup.reserve_state_of_mining_code_k)" " -> Seq Scan on lms_reserve_area_extension (cost=0.00..21.38 rows=438 width=23) (actual time=0.004..0.062 rows=438 loops=3867)" " -> Hash (cost=1.19..1.19 rows=3 width=2) (actual time=0.037..0.038 rows=3 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 9kB" " -> Seq Scan on lms_reserve_stateofmining_lkup (cost=0.00..1.19 rows=3 width=2) (actual time=0.031..0.034 rows=3 loops=1)" " Filter: (reserve_state_of_mining_code_k = ANY ('{1,3,9}'::integer[]))" " Rows Removed by Filter: 11" " -> Hash (cost=1.03..1.03 rows=3 width=10) (actual time=0.012..0.012 rows=3 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 9kB" " -> Seq Scan on lms_reserve_mining_type_lkup (cost=0.00..1.03 rows=3 width=10) (actual time=0.009..0.011 rows=3 loops=1)" "Planning Time: 195.696 ms" "Execution Time: 2696179.159 ms"