New Relic plugin for monitoring PostgreSQL.

• Component/tuple/table/table_name/percent/active - relation of live tuples to total table size
• Component/tuple/table/table_name/percent/dead - relation of dead tuples to total table size
• Component/tuple/table/table_name/percent/free - relation of free space to total table size
• Component/tuple/summary/percent/active - live tuples to total table size; average over all tables in database
• Component/tuple/summary/percent/dead - dead tuples to total table size; average over all tables in database
• Component/tuple/summary/percent/free - free space to total table size; average over all tables in database

• Component/disksize/table/table_name/table - disk space used by table; expressed in Bytes
• Component/disksize/table/table_name/index - disk space used by table indexes; expressed in Bytes
• Component/disksize/summary/table/table_name - disk space used by table; expressed in Bytes
• Component/disksize/summary/index/table_name - disk space used by table indexes; expressed in Bytes

Requires golang toolchain.

sudo apt-get install golang

go get github.com/lib/pq
go get github.com/yvasiyarov/newrelic_platform_go
go get github.com/maciejmrowiec/pgmonitor
go build

Usage of pgmonitor:

• -database="": Database name (required)
• -host="localhost:5432": Database host
• -interval=1: Sampling interval [min]
• -key="": Newrelic license key (required)
• -user="postgres": Database user name
• -verbose=false: Verbose mode

To deamonize in backgrund you can use:

nohup ./pgmonitor -database=<mydatabase> -key=<my_newrelic_key> >/dev/null 2>&1 &

Note: PGMonitor requires pgstattuple extension to work correctly.

To enable execute in postgres shell:

CREATE EXTENSION pgstattuple;