drug_id_query_plan

 Nested Loop  (cost=7266.02..13939862.13 rows=197203686 width=152)
   Output: zcp.pmd_pclaim_id, zcp.pmd_client_id, zcp.pmd_session_id, zcp.pmd_patient_id, zcp.pmd_provider_id, zcp.pmd_pharmacy_id, zcp.date_of_service, zcp.product_service_id_qual, zcp.product_service_id, zcp.product_service_desc, zcp.quantity_dispensed, zcp.days_supply, zcp.drug_strength, zcp.prescriber, zcp.mtm_patient_id, (max(z.id)), zcp.mtm_medication_id, zcp.mtm_pclaim_id, zcp.mtm_provider_id, zcp.mtm_pharmacy_id, zcp.zpclaiminsert, zcp.zpclaimupdate, zcp.mtm_patientprovider_id
   ->  HashAggregate  (cost=7266.02..7758.77 rows=39420 width=15)
         Output: z.ndc, max(z.id)
         ->  Seq Scan on drugs z  (cost=0.00..6702.68 rows=112668 width=15)
               Output: z.id, z.lvl1conceptname, z.lvl2conceptname, z.lvl3conceptname, z.lvl4conceptname, z.lvl5conceptname, z.lvl6conceptname, z.ndc9, z.productnamelong, z.productnameshort, z.routename, z.brand_name, z.brand, z.ingredientname, z.ndc, z.dosage, z.dosageunit, z.eprescribingname, z.desistatusid, z.desistatus, z.deaclassificationid, z.deaclassification, z.brandgenericstatusid, z.brandstatus, z.legendstatusid, z.legendstatusname, z.replacedbyproductid, z.alchemyproductid, z.created_at, z.updated_at, z.form, z."LegacyKey", z.mongo_uuid, z.mongo_export_path
   ->  Index Scan using idx_zpmdlpclaim_productserviceid on zpmdl_pclaim zcp  (cost=0.00..290.88 rows=5003 width=148)
         Output: zcp.pmd_pclaim_id, zcp.pmd_client_id, zcp.pmd_session_id, zcp.pmd_patient_id, zcp.pmd_provider_id, zcp.pmd_pharmacy_id, zcp.date_of_service, zcp.product_service_id_qual, zcp.product_service_id, zcp.product_service_desc, zcp.quantity_dispensed, zcp.days_supply, zcp.drug_strength, zcp.prescriber, zcp.mtm_patient_id, zcp.mtm_medication_id, zcp.mtm_pclaim_id, zcp.mtm_provider_id, zcp.mtm_pharmacy_id, zcp.zpclaiminsert, zcp.zpclaimupdate, zcp.mtm_patientprovider_id, zcp.ctid
         Index Cond: ((zcp.product_service_id)::text = (z.ndc)::text)
(9 rows)