can we have the Postgres collector yml file example

[saranggm]

[burningalchemist]

Hi @saranggm, I guess you can have a look at the example here:

sql_exporter/helm/ci/postgresql-values.yaml

Lines 12 to 38 in 25c6746

	config:
	target:
	data_source_name: 'postgresql://postgres:[email protected]:5432?sslmode=disable'
	collectors: [active_connections]
	collectors:
	- collector_name: active_connections
	metrics:
	- metric_name: active_connections
	type: gauge
	help: 'Active connections'
	key_labels:
	- "datname"
	- "usename"
	- "state"
	values:
	- "count"
	query_ref: active_connections
	queries:
	- query_name: active_connections
	query: |
	SELECT
	datname::text,
	usename::text,
	state::text,
	COUNT(state)::float AS count
	FROM pg_stat_activity
	GROUP BY datname, usename, state;

There's no defaults as sql_exporter is a database-agnostic exporter, so it's up to the user to define what they want to query, be it system or user tables.