Postgresql receiver query plan not populating #45190
Description
Component(s)
receiver/postgresql
What happened?
Query plan for postgressql db are not showing up. Postgresql by default does not have query plans stored.However, the receiver explicilty executes EXPLAIN command in the code
Despite this the plans are not showing up.
Steps to Reproduce
Install otel-contrib on host server and fetch postgresql query data with a user having right permissions.
Collector version
0.142.0
Environment information
OS: Ubuntu 22.04.1 LTS
OpenTelemetry Collector configuration
affinity: {}
config:
exporters:
debug:
sampling_initial: 100
sampling_thereafter: 1
verbosity: detailed
nop: {}
extensions:
health_check:
endpoint: ${env:MY_POD_IP}:13133
processors:
batch:
send_batch_max_size: 2
send_batch_size: 1
timeout: 10s
k8sattributes:
extract:
metadata:
- k8s.namespace.name
- k8s.node.name
- k8s.pod.name
- k8s.pod.uid
filter:
node_from_env_var: K8S_NODE_NAME
passthrough: false
pod_association:
- sources:
- from: resource_attribute
name: k8s.pod.ip
- sources:
- from: resource_attribute
name: k8s.pod.uid
- sources:
- from: connection
memory_limiter:
check_interval: 2s
limit_mib: 500
limit_percentage: 80
spike_limit_percentage: 30
resource:
attributes:
- action: insert
key: metric_source
value: kubernetes
- action: upsert
key: k8s.cluster.name
value: bitsingle
resource/add_agent_k8s:
attributes:
- action: insert
key: k8s.pod.name
value: ${K8S_POD_NAME}
- action: insert
key: k8s.pod.uid
value: ${K8S_POD_UID}
- action: insert
key: k8s.namespace.name
value: ${K8S_NAMESPACE}
resourcedetection:
detectors:
- env
- eks
- ec2
- system
override: true
timeout: 15s
receivers:
postgresql:
username: oteluser
# password: "!i#C3r1[N8#YUoY$>RrFzAK(WG[("
password: "otelp"
endpoint: db-postgres:5432
databases: [test]
events:
db.server.query_sample:
enabled: true
service:
extensions:
- health_check
pipelines:
logs:
exporters:
- otlphttp
processors:
- memory_limiter
- batch
receivers:
- postgresql/rds
metrics/sqlserver:
exporters:
-
processors:
- resourcedetection
- resource/pg_host_name
- memory_limiter
- batch
receivers:
- postgresql/rds
extraEnvs:
- name: NODE_NAME
valueFrom:
fieldRef:
fieldPath: spec.nodeName
- name: OTEL_FEATURE_GATE
value: receiver.kubeletstats.enableCPUUsageMetrics
image:
repository: otel-contribcol
tag: 0.142.0
mode: deployment
resources:
limits:
cpu: 500m
memory: 1000Mi
requests:
cpu: 250m
memory: 128Mi