SQL Query to get commit count from DB

[Mahalakshmi Sivasamy]

Can you help me in getting a SQL Query to get the commit count?

[Nic Brough -Adaptavist- · Accepted solution]

From what I can see, the database doesn't record that, the server just asks git what the count is when it needs it.

[Christian Glockner]

Nic is correct here - Bitbucket Server doesn't store commits in the database, so there is no query to retrieve this information from it.

Cheers,

Christian

Premier Support Engineer

Atlassian

[Uladzislava Kastsitsyna _Stiltsoft_]

Hi,

Consider taking a look at Awesome Graphs for Bitbucket. Our app enables you to export commit data on different levels via REST API or directly to a CSV file.

For example, here is how you can get a list of commits on a global level using REST API.

Hope that it helps.

Best regards,
Uladzislava