Summarizing groups after left join, PostgreSQL

Language: Layout:

CREATE TABLE visits (loc_id varchar(4), user_id varchar (3), site_visit_date date, site_visit_count integer);
INSERT INTO visits (loc_id, user_id, site_visit_date, site_visit_count) VALUES
('1234','003','06/05/2016',1)
,('1234','003','06/06/2016',1)
,('1234','003','06/09/2016',1)
,('1234','003','06/14/2016',1)
,('1234','003','06/28/2016',1)
,('1234','003','07/01/2016',1)
,('1234','802','05/18/2016',1)
,('1234','818','02/19/2016',1)
,('1234','818','02/21/2016',1)
,('1234','818','03/20/2016',1)
,('1234','868','01/29/2016',1)
,('1234','868','02/02/2016',1)
,('1234','868','02/03/2016',1)
,('1234','868','02/29/2016',1)
,('1234','868','03/15/2016',1)
,('1234','868','03/17/2016',2)
,('1234','871','09/08/2016',1)
,('1234','876','03/09/2016',1)
,('1234','876','03/11/2016',1)
,('1234','876','03/16/2016',1)
,('1234','877','02/07/2016',1)
,('1234','877','02/08/2016',1)
,('1234','877','02/09/2016',1)
,('1234','877','03/25/2016',1)
,('1234','877','03/26/2016',1)
,('1234','877','03/27/2016',1)
;

CREATE TABLE actions (loc_id varchar(4), user_id varchar (3), action_date date, action_category varchar (10), action_count integer);
INSERT INTO actions (loc_id, user_id, action_date, action_category, action_count) VALUES
('1234','003','06/05/2016','action123',2)
,('1234','003','06/14/2016','action123',4)
,('1234','003','07/01/2016','action123',1)
,('1234','868','02/29/2016','action123',13)
,('1234','868','03/17/2016','action123',9)
,('1234','877','02/08/2016','action123',5)
,('1234','877','03/25/2016','action123',4)
;

with tbl as (
select
    v.loc_id
    ,v.user_id
    ,TO_CHAR(v.site_visit_date,'YYYY-MM-DD')
    ,v.site_visit_count
    ,TO_CHAR(a.action_date,'YYYY-MM-DD')
    ,a.action_category
    ,a.action_count
    ,case when a.action_count >=1 then 'ever' else 'never' end ever_never
from
    visits v
    left join actions a on v.user_id = a.user_id and v.site_visit_date = a.action_date
order by 1,2,5
)
select
    user_id
    ,ever_never
    ,sum(action_count)
from
    tbl
group by
    user_id
    ,ever_never
order by 1,2


absolute service time: 0,42 sec