How are Nexus 3 blob store and repository metrics stored in a PostgreSQL database?

Overview

The blob store and repository administration pages show statistics for blob counts and aggregate sizes. This article will describe where those respective values are stored in a PostgreSQL database.

Blob store metrics

1. In your PostgreSQL DB query tool of choice (e.g. pgAdmin 4), connect to your DB and run the following query:

SELECT blob_store_name, blob_count, total_size
FROM public.blob_store_metrics
ORDER BY blob_store_name

The result set will provide the values analogous to the Blob Stores page.

Repository metrics

1. Connect to your DB and run the following query:

SELECT repository_name, repository_format, total_size 
FROM public.repository_metrics
ORDER BY repository_name

The result set will provide the values analogous to the Repositories page.