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.  (Rodrigo E. De León Plicet <rdeleonp@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Swierczek
Дата:
Сообщение: Re: Newbie question PostgreSQL / Postgres Plus / Tuning
Следующее
От: "Nico Callewaert"
Дата:
Сообщение: Function call