Skip to main content
The database collector exposes metrics about PostgreSQL databases, including disk space usage and connection limits.

​
Status

Default: Enabled

​
Metrics

​
pg_database_size_bytes

Type: Gauge
Description: Disk space used by the database Labels:
  • datname - Database name
Source Query: 
SELECT pg_database_size($1)

​
pg_database_connection_limit

Type: Gauge
Description: Connection limit set for the database (-1 = unlimited) Labels:
  • datname - Database name

​
SQL Queries

The collector executes two queries:
  1. List databases:
SELECT pg_database.datname, pg_database.datconnlimit 
FROM pg_database;
  1. Get database size (per database):
SELECT pg_database_size($1)

​
Configuration

​
Exclude Databases

You can exclude specific databases from collection using the --exclude-databases flag: 
pgexporter --exclude-databases="postgres,template0,template1"

​
PostgreSQL Versions

Supported: All versions

​
Required Permissions

The monitoring user needs:
  • CONNECT privilege on target databases
  • Access to pg_database system catalog
  • Execute permission on pg_database_size() function

​
Example Output

pg_database_size_bytes{datname="myapp"} 524288000
pg_database_connection_limit{datname="myapp"} 100
pg_database_connection_limit{datname="postgres"} -1

Build docs developers (and LLMs) love

Get started for freeTalk to us