Carlsbad, NM Climate in April

Temperature for April

In Carlsbad, NM during April the average high temperature is 81.9°F. The hottest day on record was April 25, 2012 when the temperature hit 100.9°F.

Carlsbad, NM daily average and extreme temperature range for April

Low Temperature

During April the overnight temperature drops to an average of 48.4°F, with the lowest temperature of 19.9°F being recorded on April 8, 1983. Overnight temperatures drop below freezing between 1 and 7 times in April.

Precipitation for April

In April the average monthly rainfall in Carlsbad, NM is 0.43 inches with rain usually falling on between 3 and 4 days. 1944 was the driest April with only 0.00 inches of rain falling, and 2004 was the wettest April with 4.01 inches of rain. The wettest single day in April was 4 April 2004 when 2.62 inches of rain fell.

In April it usually snows on between 0 and 1 days. There are thunderstorms on between 1 and 2 days in April.

  BENCHMARKS  
Loading Time: Base Classes  0.0070
Controller Execution Time ( Climate / Summary )  0.0845
Total Execution Time  0.0916
  GET DATA  
No GET data exists
  MEMORY USAGE  
2,293,292 bytes
  POST DATA  
No POST data exists
  URI STRING  
climate/summary/united-states/new-mexico/cavern-city-air-terminal/april
  CLASS/METHOD  
climate/summary
  DATABASE:  xrssweather0-climatespy   QUERIES: 11  (Hide)
0.0007   SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay
FROM 
(`dimLocation`)
JOIN `dimDatedd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId`
JOIN `dimDatedd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId`
WHERE `urlState` =  'new-mexico'
AND `urlName` =  'cavern-city-air-terminal'
LIMIT 1 
0.0007   SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTempAVG(`meanMaxTemp`) AS meanMaxTemp
FROM 
(`aggMonthly`)
WHERE `monthNo` =  4
AND `locationId` =  '2217'
GROUP BY `monthNo
0.0007   SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTempAVG(`meanMaxTemp`) AS meanMaxTemp
FROM 
(`aggMonthly`)
WHERE `monthNo` =  4
AND `locationId` =  '2217'
GROUP BY `monthNo
0.0025   SELECT `maxTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName`
FROM (`aggMonthly`)
JOIN `dimLocationON `dimLocation`.`locationId` = `aggMonthly`.`locationId`
JOIN `dimDateON `dimDate`.`dateId` = `aggMonthly`.`maxTempDate`
WHERE `aggMonthly`.`locationId` =  '2217'
AND `dimDate`.`monthNo` =  4
ORDER BY 
`maxTempdesc
LIMIT 1 
0.0023   SELECT `minTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName`
FROM (`aggMonthly`)
JOIN `dimLocationON `dimLocation`.`locationId` = `aggMonthly`.`locationId`
JOIN `dimDateON `dimDate`.`dateId` = `aggMonthly`.`minTempDate`
WHERE `aggMonthly`.`locationId` =  '2217'
AND `dimDate`.`monthNo` =  4
ORDER BY 
`minTempasc
LIMIT 1 
0.0238   select min(count_days) as min_daysavg(count_days) as average_daysmax(count_days) as max_days  from (select yearcount(*) as count_days from factDaily fd  join dimDate dd on (dd.dateId fd.DateId) where fd.locationId 2217 and minTemp <= 32  and dd.monthNo 4 group by year) as count_freezing 
0.0239   select min(count_days) as min_daysavg(count_days) as average_daysmax(count_days) as max_days  from (select yearcount(*) as count_days from factDaily fd  join dimDate dd on (dd.dateId fd.DateId) where fd.locationId 2217 and maxTemp <= 32  and dd.monthNo 4 group by year) as count_freezing 
0.0007   SELECT AVG(`sumRainfall`) AS sumRainfallAVG(`daysRainfall`) AS daysRainfallAVG(`daysSnow`) AS daysSnowAVG(`daysTornado`) AS daysTornadoAVG(`daysThunder`) AS daysThunder, `monthNo`
FROM (`aggMonthly`)
WHERE `monthNo` =  4
AND `locationId` =  '2217'
GROUP BY `monthNo
0.0007   SELECT `sumRainfall`, `daysRainfall`, `year`
FROM (`aggMonthly`)
WHERE `monthNo` =  4
AND `locationId` =  '2217'
ORDER BY `sumRainfallasc
LIMIT 1 
0.0007   SELECT `sumRainfall`, `daysRainfall`, `year`
FROM (`aggMonthly`)
WHERE `monthNo` =  4
AND `locationId` =  '2217'
ORDER BY `sumRainfalldesc
LIMIT 1 
0.0018   SELECT `maxRainfall`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName`
FROM (`aggMonthly`)
JOIN `dimLocationON `dimLocation`.`locationId` = `aggMonthly`.`locationId`
JOIN `dimDateON `dimDate`.`dateId` = `aggMonthly`.`maxRainfallDate`
WHERE `aggMonthly`.`locationId` =  '2217'
AND `dimDate`.`monthNo` =  4
ORDER BY 
`maxRainfalldesc
LIMIT 1 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)