SQL Question: Averages of intervals.
От | Daniel Staal |
---|---|
Тема | SQL Question: Averages of intervals. |
Дата | |
Msg-id | 14759.152.121.16.49.1232743182.squirrel@www.magehandbook.com обсуждение исходный текст |
Ответы |
Re: SQL Question: Averages of intervals.
|
Список | pgsql-novice |
I have the following table: LoadTable: MachineName - String Date - Date Time - Time IOW - Real SYS - Real USR - Real ... - Real I am trying to get information out for using in a graph. Unfortunately, we are logging several times a minute, so the amounts of data for any reasonable timeframe (say, one day) are just too large for any one graph to handle well. So, what I'd like to do is average the IOW (or whichever I'm graphing at the moment) over a timeframe. (Where I would probably scale the timeframe depending on the total length of time I'm pulling.) So, the result would contain one row per interval, with the IOW/whatever being the average value over the interval. Is there any way to do this in straight SQL? (Let's use one day (Date = '$date') and 10 minutes as examples: I'll probably be creating an interface to generate these ad-hock, over random timeframes.) Daniel T. Staal
В списке pgsql-novice по дате отправления: