From: Larry Rosenman <ler@lerctr.org>
To: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: trying to summarize into a new table by time...
Date: Sat, 2 Jun 2001 08:50:12 -0500
Message-ID: <20010602085012.A28751@lerami.lerctr.org> (raw)
In-Reply-To: <20010602051258.A18140@lerami.lerctr.org>
* Larry Rosenman <ler@lerctr.org> [010602 05:17]:
> Where we group into six hour groupings.
>
> I came up with the following:
>
> insert into traffic_summary
> select asn,protocol,
> cast(sum(pkts_src) as float) as pkts_src,
> cast(sum(pkts_dst) as float) as pkts_dst,
> cast(sum(bytes_src) as float) as bytes_src,
> cast(sum(bytes_dst) as float) as bytes_dst,
> cast(sum(secs_src) as float) as secs_src,
> cast(sum(secs_dst) as float) as secs_dst,
> min(early) as early,
> max(late) as late
> from traffic
> where early >= '2001-01-01 00:00:00' and
> early <= '2001-01-02 05:59:59'
> GROUP BY asn,protocol;
>
I *THINK* I can change the GROUP BY to add date_trunc('hour',early)
and get what I want to the hour.
How can I get 6 hours?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ler@lerctr.org
Subject: Re: trying to summarize into a new table by time...
In-Reply-To: <20010602085012.A28751@lerami.lerctr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox