1select 2 pid, 3 max(c.ts) as last_rss, 4 p.end_ts as process_end 5from counter c 6join process_counter_track t on c.track_id = t.id 7join process p using(upid) 8group by upid