Clearing out build history via psql query?

Hi all,

I’ve been trying to set up some jobs for gitlab ci(Omnibus install) and in the process managed to generate ~50 failed/testing job runs. As the builds themselves haven’t been officially used in my team, I’d like to start fresh once I get every repository to play nicely.

From searching, I found that if I connect to the postgresql database via;

sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql -d gitlabhq_production

from here, I found what appears to be the build history.

select * from ci_builds

So, my question is, what happens if I truncate that table? Again, there is no build history I’d like to keep, so a fresh clean ci build history is desired.

Thanks in advance!