We use Omnibus GitLab at work, and it’s really very useful. We appreciate it a lot in the development process, as it aides a lot in being precise, organized and methodical.

It has been long time since they added a basic time tracking feature to issues: add estimate and spent time to issues, a useful tool for planning. Sadly, at least in  the Community Edition, it’s not possible to so much with that, beside opening every single issue and see the two values. That’s a shame…

We almost always add estimated time to issues, so we needed a way to summarize this estimate.

A quick way to export all the issues for a project is using PostgreSQL export function.

Enter PostgreSQL shell with:

gitlab-psql -d gitlabhq_production

Then run an SQL statement like this:

Copy (select iid, title, time_estimate from issues where project_id = '129' and state = 'opened') To '/tmp/issues.csv' With CSV DELIMITER ';';

The iid field is the internal id, while the id is the table’s auto increment. The guess here is the project_id, which you can figure out from the projects table.