-- Так тормозит
  with report as (
    
    select t1.minutes
           t1.hours
           t1.total 
           t1.view
      from table1 t1
     where t1.start >= to_date(concat(:start, ' 00:00:00'), 'dd.mm.yyyy hh24:mi:ss') 
      and t1.finish <= to_date(concat(:finish, ' 23:59:59'), 'dd.mm.yyyy hh24:mi:ss')
  )

  select 0 as sort 
        ,sum(r.minutes) as minutes
        ,sum(r.hours) as hours
        ,sum(r.total) as total
        ,r.view 
    from report r
    group by r.view 

  union all 

   select 1 as sort 
          ,sum(r.minutes) as minutes
          ,sum(r.hours) as hours
          ,sum(r.total) as total
          ,'Итог'
    from report r
   

  union all 

   select 2 as sort 
          ,sum(r.minutes) as minutes
          ,sum(r.hours) as hours
          ,sum(r.total) as total
          ,'Вид 1'
    from report r where r.view = 1;

-- Так нет
  with report as (
    
    select t1.minutes
           t1.hours
           t1.total 
           t1.view
      from table1 t1
     where t1.start >= to_date(concat(:start, ' 00:00:00'), 'dd.mm.yyyy hh24:mi:ss') 
      and t1.finish <= to_date(concat(:finish, ' 23:59:59'), 'dd.mm.yyyy hh24:mi:ss')
  )

  select 0 as sort 
        ,sum(r.minutes) as minutes
        ,sum(r.hours) as hours
        ,sum(r.total) as total
        ,r.view 
    from report r
    group by r.view