Saving the user activity in the database(sql)

Question

I am creating a chart to analyze the access of posts by age group by time on my site. But the site does not yet have this ability to capture the activity of the user and need to do it.

My task and change the database to make this possible, currently I have the following tables:

table user{
    id_user (Chave Primaria);
    date_of_birth (date);
    name (char(255))
}

table post{
    id_post (Chave Primaria);
    title (char(255))
}

When a user 'Tobias' access the posts 'How to bake an egg' on '23 May 2018' at '13:31' for '30 seconds', I will need to have this information in the database.

First I thought about creating a table in the most intuitive way possible:

table acesso{
    id_acesso(Chave primaria);
    id_user (Chave estrangeira);
    id_post(Chave estrangeira);
    date (timestamp);
    duration (inteiro, segundos);
}

But I don’t know what is the most efficient way to do this table or if there is a better form or if I’m doing the right thing. Because I’m planning this bank to have thousands of users and posts, and efficiency is something desired.