Ssd vector began to slow down?

Question

Solid State Drives

It costs ssd vector 128gb. The utility shows the remaining resource of 85%. Data recorder 20 terobytes. The computer began to blunt unrealistically. In task manager, disk usage is always 100%.
I put the old hdd instead of ssd - everything works fine.
Probably the disk of the khan or can I do something shamanistic?

Answer 1

There is no way to check, I write by eye

SELECT
  id_user,
  datetime((strftime('%s', timestamp) / 3600) * 3600, 'unixepoch') as interval
FROM some_table
GROUP BY interval, id_user
HAVING count(*) > 3;

Answer 2

Didn't check

select
t1.user_id
from 
(
  select
  user_id
  from users
  where timestamp BETWEEN strftime('%m/%d/%Y %H:%M', datetime('now','localtime'), '-1 hours') 
  AND strftime('%m/%d/%Y %H:%M',datetime('now','localtime'));
) t1
group by t1.user_id
having count(*) > 3