PostgreSQL π
Note
You can replace this monitor with the OTel native component postgresql
receiver. See PostgreSQL receiver for more information.
The
Splunk Distribution of OpenTelemetry Collector
uses the Smart Agent receiver with the
postgresql
monitor type to pull metrics from all PostgreSQL
databases from a specific Postgres server instance using SQL queries.
Configuration settings π
The following table shows the configuration options for the
postgresql
integration:
Option |
Required |
Type |
Description |
---|---|---|---|
|
no |
|
|
|
no |
|
(default: |
|
no |
|
|
|
no |
|
See Connection String Parameters |
|
no |
|
|
|
no |
|
|
|
no |
|
|
|
no |
|
|
|
no |
|
|
Metrics π
The following metrics are available for this integration:
Notes π
To learn more about the available in Observability Cloud see Metric types
In host-based subscription plans, default metrics are those metrics included in host-based subscriptions in Observability Cloud, such as host, container, or bundled metrics. Custom metrics are not provided by default and might be subject to charges. See Metric categories for more information.
In MTS-based subscription plans, all metrics are custom.
To add additional metrics, see how to configure
extraMetrics
in Add additional metrics
Metrics about replication π
Replication metrics arenβt available on some PostgreSQL servers. For
now, this monitor automatically deactivates the replication
metrics
group if the monitor detects Aurora. This helps avoid following the
error:
Function pg_last_xlog_receive_location() is currently not supported for Aurora
The metric postgres_replication_state
will be reported only for
master
and for postgres_replication_lag
for the standby
role
(replica).
Troubleshooting π
If you are a Splunk Observability Cloud customer and are not able to see your data in Splunk Observability Cloud, you can get help in the following ways.
Available to Splunk Observability Cloud customers
Submit a case in the Splunk Support Portal .
Call Splunk Customer Support .
Available to prospective customers and free trial users
Ask a question and get answers through community support at Splunk Answers .
Join the Splunk #observability user group Slack channel to communicate with customers, partners, and Splunk employees worldwide. To join, see Chat groups in the Get Started with Splunk Community manual.
To learn about even more support options, see Splunk Customer Success .