Struct PostgresMetrics 

pub struct PostgresMetrics {
    pub image: String,
    pub enabled: bool,
    pub queries: Option<QueryConfig>,
}

PostgresExporter is the configuration for the postgres-exporter to expose custom metrics from the database.

Example: This example exposes specific metrics from a query to a pgmq queue enabled database.

apiVersion: coredb.io/v1alpha1
kind: CoreDB
metadata:
  name: test-db
spec:
metrics:
  enabled: true
  image: quay.io/prometheuscommunity/postgres-exporter:v0.12.0
  queries:
    pgmq:
      query: select queue_name, queue_length, oldest_msg_age_sec, newest_msg_age_sec, total_messages from public.pgmq_metrics_all()
      master: true
      metrics:
        - queue_name:
            description: Name of the queue
            usage: LABEL
        - queue_length:
            description: Number of messages in the queue
            usage: GAUGE
        - oldest_msg_age_sec:
            description: Age of the oldest message in the queue, in seconds.
            usage: GAUGE
        - newest_msg_age_sec:
            description: Age of the newest message in the queue, in seconds.
            usage: GAUGE
        - total_messages:
            description: Total number of messages that have passed into the queue.
            usage: GAUGE

Fields

image: String

The image to use for the postgres-exporter container.

Default: quay.io/prometheuscommunity/postgres-exporter:v0.12.0

enabled: bool

To enable or disable the metric.

Default: true

queries: Option<QueryConfig>

The SQL query to run.

Example: select queue_name, queue_length, oldest_msg_age_sec, newest_msg_age_sec, total_messages from public.pgmq_metrics_all()

Default: None

Trait Implementations

impl Clone for PostgresMetrics

fn clone(&self) -> PostgresMetrics

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for PostgresMetrics

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for PostgresMetrics

fn default() -> PostgresMetrics

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for PostgresMetrics

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl JsonSchema for PostgresMetrics

fn schema_name() -> String

The name of the generated JSON Schema.

fn schema_id() -> Cow<'static, str>

Returns a string that uniquely identifies the schema produced by this type.

fn json_schema(generator: &mut SchemaGenerator) -> Schema

Generates a JSON Schema for this type.

fn is_referenceable() -> bool

Whether JSON Schemas generated for this type should be re-used where possible using the $ref keyword.

impl Serialize for PostgresMetrics

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.