SELECT     "generic_names".* FROM       "generic_names"  WHERE     (status=$1 and healthcare_institution_id=$2) ORDER BY  lower(name)

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
generic_names	3825	id PRIMARY healthcare_institution_id is_external is_internal is_rt name name gist_trgm_ops GIST purchase_type status store_category_id, name