/pg-activity-dumper

Dump pg_stat_activity metrics into CSV files

Primary LanguageGo

PostgreSQL Activity Dumper

Gets records from pg_stat_activity view every 10 seconds and dumps the data to CSV file every 5 minutes to /var/log/pg_activity/YYYY-MM-DD/YYYY-MM-DD_HHMM.csv.gz for future analysis.

Build with:

go build

or for particular platform:

GOOS=linux GOARCH=amd64 go build