Re: SQL Question: Averages of intervals. - Mailing list pgsql-novice

On Sat, January 24, 2009 8:05 pm, Jasen Betts wrote:

> 10 minutes is 600 seconds
>
> SELECT AVG("IOW"),AVG("SYS"),AVG("USR"),MIN("Time"),"MachineName"
>   FROM "LoadTable"
>   WHERE "Date"='today'::date
>   GROUP BY  FLOOR( EXTRACT(EPOCH FROM "Time") / 600 ),"MachineName";

This worked perfectly.  Thank you.

Daniel T. Staal