Vertica Query request times over time by user

Vertica_Query_Times

-- Query request times over time by user
select distinct TheDay, user_name
, (min_dat / 1000) as min_sec, (max_dat / 1000) as max_sec
, (avg_dat / 1000) as avg_sec, (median_dat / 1000) as median_sec
, query_cnt
from (
select DATE(end_timestamp::timestamp) as TheDay, user_name
, min(request_duration_ms) over(partition by DATE(end_timestamp::timestamp), user_name ) min_dat 
, max(request_duration_ms) over(partition by DATE(end_timestamp::timestamp), user_name ) max_dat
, avg(request_duration_ms) over(partition by DATE(end_timestamp::timestamp), user_name ) avg_dat
, median(request_duration_ms) over(partition by DATE(end_timestamp::timestamp), user_name ) median_dat
, count(*) over(partition by DATE(end_timestamp::timestamp), user_name ) as query_cnt from query_requests
where is_executing is false
and request ilike '%table%'
-- and user_name ilike '%Elvis%'
and not (request like 'SELECT * FROM columns%' OR request like '%query_requests%') ) my_alias
order by 1, 2 desc;