Formatting table with partitions, PostgreSQL

Language: Layout:

--PostgreSQL 9.5
--'\\' is a delimiter

create table events(
  event_id   int       not null,
  ID         text      not null,
  occurrence text      not null,
  datetime   timestamp not null
);

set datestyle to iso, mdy;

insert into events
values (1003603017, 'A', 'owner_from', '12/16/2016 4:44:16' ), 
       (1003603017, 'A', 'owner_to'  , '12/16/2016 4:44:38' ), 
       (1003603017, 'A', 'owner_from', '12/16/2016 4:44:38' ), 
       (1003603017, 'A', 'opened'    , '12/16/2016 4:44:39' ), 
       (1003603017, 'B', 'owner_from', '12/16/2016 7:36:23' ), 
       (1003603017, 'A', 'owner_to'  , '12/16/2016 7:36:23' ), 
       (1003603017, 'B', 'owner_to'  , '12/16/2016 9:00:01' ), 
       (1003603017, 'C', 'owner_from', '12/16/2016 9:00:01' ), 
       (1003603017, 'A', 'closed'    , '12/16/2016 12:00:36'), 
       (1003603017, 'D', 'owner_from', '12/17/2016 4:25:00' ), 
       (1003603017, 'C', 'owner_to'  , '12/17/2016 4:25:00' ), 
       (1003603017, 'D', 'owner_from', '12/17/2016 4:52:02' ), 
       (1003603017, 'D', 'owner_to'  , '12/17/2016 4:52:02' ), 
       (1003603017, 'D', 'opened'    , '12/17/2016 4:52:02' ), 
       (1003603017, 'D', 'owner_to'  , '12/17/2016 8:57:00' ), 
       (1003603017, 'E', 'owner_from', '12/17/2016 8:57:00' ), 
       (1003603017, 'D', 'closed'    , '12/17/2016 12:03:10');

create index idx_events_datetime on events(occurrence, datetime);

select e.*
from   events o
join   events c on c.datetime > o.datetime
join   events e on e.datetime > o.datetime and e.datetime < c.datetime
where  o.occurrence = 'opened'
and    c.occurrence = 'closed'
and    not exists(select 1
                  from   events x
                  where  x.datetime > o.datetime
                  and    x.datetime < c.datetime
                  and    x.occurrence in ('opened', 'closed'));

select (e).*
from   (select e, count(1) filter (where occurrence = 'opened') over (order by datetime rows between unbounded preceding and 1 preceding)
                  - count(1) filter (where occurrence = 'closed') over (order by datetime rows between unbounded preceding and current row) open_close
        from   events e) e
where  open_close = 1;


absolute service time: 0,44 sec