How to find large files in all repositories in Gitlab (greater than 100MB)

General
1

Hi,

Is there any way to find all the large files (greater than 100MB) in Gitlab on-prem instance running in docker container?
I need to find large files in all repositories in out gitlab instance. (with or without LFS)

Is there any API that could provide me this result? or is there any other way to access the internal postgres database in PGADMIN4 to query this in the tables?

Please suggest.

2

The repository data is stored on disk, not in the DB. You should find it in /var/opt/gitlab/git-data/repositories/@hashed/ for example. Here you can see how to list files with their sizes in bare repositories.

This page should help you find where the LFS data is stored.