feat: PostgreSQL Tracing Support

[kamilogorek]

PostgreSQL and CockroachDB tracing support.

Usage:

const Sentry = require("@sentry/node");
const Tracing = require("@sentry/tracing");
const pg = require("pg");

Sentry.init({
  dsn: "__PUBLIC_DSN__",
  integrations: [
    new Tracing.Integrations.Postgres(),
  ],
  tracesSampleRate: 1.0,
});

const client = new pg.Client({
  user: "postgres",
  password: "docker",
});

client.connect();

// the rest of the code, for raw-node code we need manual instrumentation, eg.

const transaction = Sentry.startTransaction({
  op: "transaction",
  name: "My Transaction",
});

Sentry.configureScope((scope) => {
  scope.setSpan(transaction);
});

client.query("SELECT $1::text as message", ["Hello world!"], (err, res) => {
  console.log(err ? err.stack : res.rows[0].message); // Hello World!
  if (transaction) transaction.finish();
  client.end();
});

Works nicely with Express too:

const Sentry = require("@sentry/node");
const Tracing = require("@sentry/tracing");
const pg = require("pg");
const express = require("express");

Sentry.init({
  dsn: "__PUBLIC_DSN__",
  integrations: [
    new Sentry.Integrations.Http({ tracing: true }),
    new Tracing.Integrations.Express({
      app: express.Router,
      methods: ["get"],
    }),
    new Tracing.Integrations.Postgres(),
  ],
});

const app = express();
const client = new pg.Client({
  user: "postgres",
  password: "docker",
});

client.connect();

app.use(Sentry.Handlers.requestHandler());
app.use(Sentry.Handlers.tracingHandler());
app.use(express.json());

app.get("/hi", function sayHi(req, res) {
  client.query("SELECT $1::text as name", ["picklerick"], (err, rows) => {
    res.send(rows[0]);
  });
});

app.use(Sentry.Handlers.errorHandler());

app.listen(3000);

[github-actions]

size-limit report

Path	Size
@sentry/browser - CDN Bundle (gzipped)	19.73 KB (+0.01% 🔺)
@sentry/browser - Webpack	20.6 KB (0%)
@sentry/react - Webpack	20.6 KB (0%)
@sentry/browser + @sentry/tracing - CDN Bundle (gzipped)	26.88 KB (+0.01% 🔺)

[kamilogorek]

Thanks @lobsterkatie, will make appropriate changes once I finish Mongo work.

[ghost]

Is there a timeline for when this will be merged and released? The Express fix in here would be really nice to have given it is causing a lot of duplicates in our issues page.

[kamilogorek]

@dlaudate-embark I'll extract it from the PR today so we can ship it tomorrow/monday

[kamilogorek]

@dlaudate-embark ref: #3078

[lobsterkatie]

Looks good! Maybe some tests, though?