@opentelemetry/plugin-pg

OpenTelemetry Postgres Instrumentation for Node.js

This module provides automatic instrumentation for pg.

For automatic instrumentation see the @opentelemetry/node package.

Installation

npm install --save @opentelemetry/plugin-pg
npm install --save @opentelemetry/plugin-pg-pool

Usage

To load all of the default supported plugins, use the below approach. Each plugin is only loaded when the module that it patches is loaded; in other words, there is no computational overhead for listing plugins for unused modules.

const { NodeTracerProvider } = require('@opentelemetry/node');

const provider = new NodeTracerProvider(); // All default plugins will be used

If instead you would just want to load a specific plugin (pg in this case), specify it in the NodeTracer configuration.

const { NodeTracerProvider } = require('@opentelemetry/node');

const provider = new NodeTracerProvider({
  plugins: {
    pg: {
      enabled: true,
      // You may use a package name or absolute path to the module
      path: '@opentelemetry/plugin-pg',
    }
  }
});

If you are using any of the pg.Pool APIs, you will also need to include the pg-pool plugin.

const { NodeTracerProvider } = require('@opentelemetry/node');

const provider = new NodeTracerProvider({
  plugins: {
    pg: {
      enabled: true,
      // You may use a package name or absolute path to the module
      path: '@opentelemetry/plugin-pg',
    },
    'pg-pool': {
      enabled: true,
      // You may use a package name or absolute path to the module
      path: '@opentelemetry/plugin-pg-pool',
    },
  }
});

See examples/postgres for a short example.

PostgreSQL Plugin Options

PostgreSQL plugin has few options available to choose from. You can set the following:

Options	Type	Description
enhancedDatabaseReporting	boolean	If true, additional information about query parameters and results will be attached (as attributes) to spans representing database operations

Supported Versions

• pg: 7.x
• pg-pool: 2.x (Installed by pg)

Useful links

• For more information on OpenTelemetry, visit: https://opentelemetry.io/
• For more about OpenTelemetry JavaScript: https://github.com/open-telemetry/opentelemetry-js
• For help or feedback on this project, join us in GitHub Discussions

License

Apache 2.0 - See LICENSE for more information.

Changelog

0.15.0

:rocket: Enhancement

• Other
  • #366 Add automated release workflows (@willarmiros)
• auto-instrumentation-web
  • #391 chore: adding meta package for web (@obecny)
• auto-instrumentation-node
  • #379 chore: creating meta package for default auto instrumentations for node (@obecny)
• opentelemetry-instrumentation-hapi
  • #380 Moving Hapi Plugin to Instrumentation (@obecny)
• opentelemetry-instrumentation-koa
  • #327 feat: enable root span to contain route (@DinaYakovlev)
• opentelemetry-instrumentation-mysql
  • #393 feat: mysql instrumentation (@dyladan)
• opentelemetry-instrumentation-net
  • #389 feat: net module instrumentation (@seemk)
• opentelemetry-host-metrics
  • #395 chore: fixing broken links, updating to correct base url, replacing gitter with github discussions (@obecny)

:house: Internal

• opentelemetry-host-metrics, opentelemetry-test-utils
  • #408 chore: bump otel dependencies to latest patch (@dyladan)
• Other
  • #392 chore: fixing broken links (@obecny)

:memo: Documentation

• opentelemetry-host-metrics
  • #373 Update README.md (@z1c0)

Committers: 9

• Bartlomiej Obecny (@obecny)
• Daniel Dyla (@dyladan)
• Dina.Yakovlev (@DinaYakovlev)
• Gerhard Stöbich (@Flarna)
• Jakub Malinowski (@jtmalinowski)
• Siim Kallas (@seemk)
• Valentin Marchaud (@vmarchaud)
• William Armiros (@willarmiros)
• Wolfgang Ziegler (@z1c0)