Raleigh-durham, NC Climate in August

Temperature for August

In Raleigh-durham, NC during August the average high temperature is 87.8°F. The hottest day on record was August 19, 1988 when the temperature hit 105.1°F.

Raleigh-durham, NC daily average and extreme temperature range for August

Low Temperature

During August the overnight temperature drops to an average of 67.3°F, with the lowest temperature of 46.0°F being recorded on August 30, 1965. In August it has never frozen overnight.

Precipitation for August

In August the average monthly rainfall in Raleigh-durham, NC is 2.73 inches with rain usually falling on between 12 and 13 days. 1947 was the driest August with only 0.00 inches of rain falling, and 1982 was the wettest August with 12.26 inches of rain. The wettest single day in August was 11 August 1982 when 9.09 inches of rain fell.

There are thunderstorms on between 7 and 8 days in August.
  BENCHMARKS  
Loading Time: Base Classes  0.0075
Controller Execution Time ( Climate / Summary )  0.0919
Total Execution Time  0.0995
  GET DATA  
No GET data exists
  MEMORY USAGE  
2,292,908 bytes
  POST DATA  
No POST data exists
  URI STRING  
climate/summary/united-states/north-carolina/raleigh-durham-intl/august
  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` =  'north-carolina'
AND `urlName` =  'raleigh-durham-intl'
LIMIT 1 
0.0008   SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTempAVG(`meanMaxTemp`) AS meanMaxTemp
FROM 
(`aggMonthly`)
WHERE `monthNo` =  8
AND `locationId` =  '2445'
GROUP BY `monthNo
0.0007   SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTempAVG(`meanMaxTemp`) AS meanMaxTemp
FROM 
(`aggMonthly`)
WHERE `monthNo` =  8
AND `locationId` =  '2445'
GROUP BY `monthNo
0.0021   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` =  '2445'
AND `dimDate`.`monthNo` =  8
ORDER BY 
`maxTempdesc
LIMIT 1 
0.0050   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` =  '2445'
AND `dimDate`.`monthNo` =  8
ORDER BY 
`minTempasc
LIMIT 1 
0.0263   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 2445 and minTemp <= 32  and dd.monthNo 8 group by year) as count_freezing 
0.0266   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 2445 and maxTemp <= 32  and dd.monthNo 8 group by year) as count_freezing 
0.0008   SELECT AVG(`sumRainfall`) AS sumRainfallAVG(`daysRainfall`) AS daysRainfallAVG(`daysSnow`) AS daysSnowAVG(`daysTornado`) AS daysTornadoAVG(`daysThunder`) AS daysThunder, `monthNo`
FROM (`aggMonthly`)
WHERE `monthNo` =  8
AND `locationId` =  '2445'
GROUP BY `monthNo
0.0008   SELECT `sumRainfall`, `daysRainfall`, `year`
FROM (`aggMonthly`)
WHERE `monthNo` =  8
AND `locationId` =  '2445'
ORDER BY `sumRainfallasc
LIMIT 1 
0.0008   SELECT `sumRainfall`, `daysRainfall`, `year`
FROM (`aggMonthly`)
WHERE `monthNo` =  8
AND `locationId` =  '2445'
ORDER BY `sumRainfalldesc
LIMIT 1 
0.0020   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` =  '2445'
AND `dimDate`.`monthNo` =  8
ORDER BY 
`maxRainfalldesc
LIMIT 1 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)