Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] how many times - Mailing list pgsql-sql

From Michael Moore
Subject Re: [SQL] how many times
Date
Msg-id CACpWLjPyXExZvyuWAP35N7ApoYZMy74zskvMQ1NGdnk-vYrMug@mail.gmail.com
Whole thread Raw
In response to [SQL] how many times  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: [SQL] how many times  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-sql
Tree view
something like this.
select
sum (case when buc = 1 then 1 else 0 end) _1_8_sec,
sum (case when buc = 2 then 1 else 0 end) _2_8_sec,
sum (case when buc = 3 then 1 else 0 end) _3_8_sec,
sum (case when buc = 4 then 1 else 0 end) _4_8_sec,
sum (case when buc = 5 then 1 else 0 end) _5_8_sec,
sum (case when buc = 6 then 1 else 0 end) _6_8_sec,
sum (case when buc = 7 then 1 else 0 end) _7_8_sec,
sum (case when buc = 8 then 1 else 0 end) _1_sec,
sum (case when buc = 9 then 1 else 0 end) _8_8_sec,
sum (case when buc = 10 then 1 else 0 end) _10_8_sec,
sum (case when buc = 11 then 1 else 0 end) _11_8_sec,
sum (case when buc = 12 then 1 else 0 end) _12_8_sec,
count(*) cnt
from 
(select width_bucket( temp_time, 0, 1500 , 11) buc  from mikes_debug_log_vals2  where temp_time is not null) x

On Wed, Aug 23, 2017 at 11:03 AM, Campbell, Lance <lance@illinois.edu> wrote:

I am not for sure how to do the below.  I was hoping someone could share their thoughts.

 

Assume I have a table called T1.  It contains a single filed called “viewed” that is of type timestamp.

 

Every time someone views a particular web page we insert the current timestamp into T1.

 

Now I need to ask this business question:

 

On average in any consecutive five minute time frame how many times is the web page viewed?

 

Thanks,

 

Lance


pgsql-sql by date:

Previous
From: Michael Moore
Date:
Subject: Re: [SQL] how many times
Next
From: "Campbell, Lance"
Date:
Subject: Re: [SQL] how many times