The annual Mental Health Inpatient Census has led to criticism that too many patients are stuck in hospital long after they are ready to go home.