Error running query on database \"<database_host:port>\": pg_stat_statements pq: syntax error at or near \"e\"

[pankdhnd]

What did you do? We deployed postgres exporter version 0.11.1 using official helm chart, and we are noticing below error in the exporter pod logs:

ts=2023-02-06T14:06:40.385Z caller=namespace.go:236 level=info err="Error running query on database \"<database_host:port>\": pg_stat_statements pq: syntax error at or near \"e\""

ts=2023-02-06T14:06:40.385Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_stat_database_conflicts

ts=2023-02-06T14:06:40.392Z caller=namespace.go:193 level=debug msg="Querying namespa

What did you expect to see? We expect to see regular metrices for pg_stat_statements

What did you see instead? Under which circumstances? We keep seeing the error listed above in the pod logs

Environment

• Kubernetes cluster v1.24+
• postgres_exporter version: 0.11.1
• postgres_exporter flags: None
• PostgreSQL version: 13.7

• Logs:

“ts=2023-02-06T14:06:40.385Z caller=namespace.go:236 level=info err="Error running query on database \"<database_host:port>\": pg_stat_statements pq: syntax error at or near \"e\""
ts=2023-02-06T14:06:40.385Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_stat_database_conflicts
ts=2023-02-06T14:06:40.392Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_replication
ts=2023-02-06T14:06:40.393Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_stat_user_tables
ts=2023-02-06T14:06:40.448Z caller=collector.go:200 level=debug msg="collector succeeded" name=database duration_seconds=0.09150201
ts=2023-02-06T14:06:40.663Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_statio_user_tables
ts=2023-02-06T14:06:40.664Z caller=namespace.go:236 level=info err="Error running query on database \"<database_host:port>\": pg_statio_user_tables pq: column \"toast_blks_re\" does not exist"
ts=2023-02-06T14:06:40.664Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_database”