Skip to content

Instantly share code, notes, and snippets.

@pmdgithub
Created November 12, 2010 14:07
Show Gist options
  • Save pmdgithub/674123 to your computer and use it in GitHub Desktop.
Save pmdgithub/674123 to your computer and use it in GitHub Desktop.
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment