PostgreSQL Metrics

Introduction

Trace0 provides detailed metrics for PostgreSQL, a powerful, object-relational database system. Metrics are based on the OpenTelemetry semantic conventions for PostgreSQL client operations. To view metrics for PostgreSQL for a service, click into the Metrics section, click the View more link for your service, then click the PostgreSQL toggle.

PostgreSQL Connection Pool Metrics Light

Displayed Metrics

We currently display the following PostgreSQL metrics, broken into Requests and Connection Pools sections. The metrics are displayed either as a single value or as a chart.

Requests
Connection Pools

Single Value

Metric	Unit
Request Count	Number
Requests per Second	Number
Request Latency P99	Time (ms, s)
Error Rate	Percentage

Chart

Metric	Description	Chart Type
Request Count by Table	Number of database requests grouped by table	Horizontal Bar chart
P99 Latency by Table	P99 request latency grouped by table	Horizontal Bar chart
Request Count by Operation	Number of database requests grouped by operation	Horizontal Bar chart
P99 Latency by Operation	P99 request latency grouped by operation	Horizontal Bar chart
Request Count Over Time	Number of database requests over time	Vertical Bar chart
Latency Over Time	P50, P75, P90, P95, and P99 request latency over time	Line chart

SQL commands containing multiple statements are not attributed to a specific table or operation and are therefore excluded from request count and latency metrics for individual tables and operations.

Metric	Description	Chart Type
Connection Count	Number of used and idle connections over time for each connection pool	Line chart

Examples

See our example apps for working services that uses PostgreSQL with Trace0 installed:

Example	Environment
Java Docker PostgreSQL example app	Docker (local)

Introduction

Getting Started

Platform

Agents

Setup Guides

Pricing

Security

FAQ

PostgreSQL Metrics

Introduction

Displayed Metrics

Examples

​Introduction

​Displayed Metrics

​Examples

Introduction

Displayed Metrics

Examples