OBJECTIVES: Demonstrate that patients with inadequate treatment post-surgical to pay may end up having a longer period of hospitalization. METHODS: A retrospective administrative claims database containing over 18 millions lives from Brazilian private hospitals (ORIZON database), was assessed (from January through June 2014), of patients who underwent a surgical intervention by appendectomy  (n= 1,618) or who had an episode of renal colic and nefretic syndrome (n=6,555) identified by International Codes Disease (N20, N21, N22, N23) and who received one of the nonsteroidal anti-inflammatory drugs (NSAIDs) available in the market (parecoxib, tenoxicam, and ketoprofen, ketorolac) for pain treatment. After patient identification, the average period of hospital permanence was assessed by drug group. . Median time differences between groups were assessed thru Kruskal-Wallis method. A significance level of 5% was adopted. All statistical analysis were performe in R, version 3.1.1. RESULTS: The average period of hospital permanence for the appendectomy procedure was 2.20 days (medical calculations from private hospitals round it to 3 days) group of (tenoxicam, ketoprofen, ketorolac)  versus 1.95 (p=0.006) in the parecoxib, respectively. In the episodes of renal colic, we had 33 hours versus 25 hours (p < 0.001) in the group of (tenoxicam, ketoprofen, ketorolac) versus (parecoxib), respectively. CONCLUSIONS: Pain is the one of the critical signs in clinical evolution, quality care and outcome disease. The period of hospital permanence after surgery or during renal colic or nefretic syndrome treatment is the utmost importance and  implies in hospital costs.  The longer patients stay in hospital higher is the probability of clinical complication, delaying treatment and some cases to increase mortality. The adequate treatment may reduce hospital stay and improve assistance as well as financial results