go-agent: github.com/newrelic/go-agent/v3/integrations/nrpq Index | Files | Directories

package nrpq

import "github.com/newrelic/go-agent/v3/integrations/nrpq"

Package nrpq instruments https://github.com/lib/pq.

Use this package to instrument your PostgreSQL calls without having to manually create DatastoreSegments. This is done in a two step process:

1. Use this package's driver in place of the postgres driver.

If your code is using sql.Open like this:

import (
	_ "github.com/lib/pq"

func main() {
	db, err := sql.Open("postgres", "user=pqgotest dbname=pqgotest sslmode=verify-full")

Then change the side-effect import to this package, and open "nrpostgres" instead:

import (
	_ "github.com/newrelic/go-agent/v3/integrations/nrpq"

func main() {
	db, err := sql.Open("nrpostgres", "user=pqgotest dbname=pqgotest sslmode=verify-full")

If your code is using pq.NewConnector, simply use nrpq.NewConnector instead.

2. Provide a context containing a newrelic.Transaction to all exec and query methods on sql.DB, sql.Conn, and sql.Tx. This requires using the context methods ExecContext, QueryContext, and QueryRowContext in place of Exec, Query, and QueryRow respectively. For example, instead of the following:

row := db.QueryRow("SELECT count(*) FROM pg_catalog.pg_tables")

Do this:

ctx := newrelic.NewContext(context.Background(), txn)
row := db.QueryRowContext(ctx, "SELECT count(*) FROM pg_catalog.pg_tables")

Unfortunately, sql.Stmt exec and query calls are not supported since pq.stmt does not have ExecContext and QueryContext methods (as of June 2019, see https://github.com/lib/pq/pull/768).

A working example is shown here: https://github.com/newrelic/go-agent/tree/master/v3/integrations/nrpq/example/main.go


Package Files


func NewConnector Uses

func NewConnector(dsn string) (driver.Connector, error)

NewConnector can be used in place of pq.NewConnector to get an instrumented PostgreSQL connector.


example/sqlxAn application that illustrates how to instrument jmoiron/sqlx with DatastoreSegments

Package nrpq imports 10 packages (graph) and is imported by 2 packages. Updated 2020-07-02. Refresh now. Tools for package owners.