Contents

• PG Metricus
  • • INFO
    • INSTALLATION
    • FORMAT
    • EXAMPLE

PG Metricus

INFO

pg_metricus is an extension written in C for sending metrics in the socket (Brubeck aggregator, Graphite, etc.) from pl/pgsql code.

If a sending is executed inside a transaction, the metrics will delivered even if the transaction is aborted.

INSTALLATION

In the directory where you downloaded pg_metricus, run

make install

You need set control variables in postgresql.conf. These can be added/changed at anytime with a simple reload. See the documentation for more details.:

pg_metricus.host = '10.9.5.164'
pg_metricus.port = 8124

Log into PostgreSQL and run the following commands. Schema is optional (but recommended) and can be whatever you wish, but it cannot be changed after installation.

create schema metricus;
create extension pg_metricus schema metricus;

FORMAT

For Brubeck aggregator: plpgsql select metricus.send_metric(format(E'%s.%s:%s|%s\n', metric_path, metric_name, metric_value, metric_type ));

For Graphite: plpgsql select metricus.send_metric(format(E'%s.%s %s %s \n', metric_path, metric_name, metric_value, extract(epoch from now())::integer ));

EXAMPLE

do language plpgsql $$
declare
    x1 timestamp;
    x2 timestamp;
    v_val_hstore text;
begin

    x1 = clock_timestamp();

    v_val_hstore = get_val_hstore();

    x2 = clock_timestamp();

    perform metricus.send_metric(format(E'%s.%s:%s|%s\n', 
        'db.sql.metric', 
        'get_val_hstore_duration', 
        extract(millisecond from (x2 - x1))::bigint::text, 
        'ms'
    ));

end
$$;