pg_netstat
Data
database monitoring extension
SHOW HN2022
How HN took it
1 positive, 4 neutral or asking, 0 mixed, 3 critical, out of 8 comments about the project. Thread score -0.26.
Idea: 1 for, 2 againstPerformance: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful approach for getting network data into Postgres.
From 1 comment
I've written a tool to do this not once but twice now! The first was for ingesting netflow data, the second from ingesting AWS VPC flow logs. In both cases this was storing…
adamcharnock on HN
Objections
Requiring packet capture permission for the Postgres binary is a security concern.
From 1 comment
> Before install this extension, you need to give network packet capture permission to Postgres binary. At that point you have root and can use any of the dozen estabilished ways…
xani_ on HN
Postgres is a poor time series database compared with dedicated TSDBs.
From 1 comment
Nearly all usecases for this seem to be recreating a time series database... Postgres isn't a great TSDB - the indexes don't understand columns that will only have updates at one…
londons_explore on HN
Requests
Feature requests and bug reports welcomed.
From 1 comment
Hey HN, I have spent some time to search for a tool that can ingest realtime network traffic data to Postgres but have no luck, so I developed this extension and used it…
burmecia on HN
Questions
How are the stats used for monitoring?
From 1 comment
I'm curious as to how you're using these stats for monitoring. What kind of insights are you gaining with this, and in what context is it used?
Dowwie on HN
Alternatives named
nftables counters with jq and Zabbix.
From 1 comment
could achieve something similar a bit different way - by using Linux nftables ( new iptables ) netfilter interface. I have setup like this for measuring used traffic by certain…
merpkz on HN
TimescaleDB.
From 1 comment
Or just use TimescaleDB which is competitive on most axes but already PG.
jpgvm on HN
ClickHouse.
From 1 comment
or clickhouse!
mritchie712 on HN
InfluxDB.
From 1 comment
Nearly all usecases for this seem to be recreating a time series database... Postgres isn't a great TSDB - the indexes don't understand columns that will only have updates at one…
londons_explore on HN
VictoriaMetrics.
From 1 comment
I recommend to use VictoriaMetrics instead of using InfluxDB for many reasons. PostgreSQL is good SQL database for different purposes but as TSDB on a big installations it works…
dengolius on HN
file_fdw reading /proc files.
From 1 comment
For another alternative: I added some monitoring, by using file_fdw. This is a standard pg extension that presents files or program stdout as tables. So I file_fdw'd some files…
hyperman1 on HN
tcpdump.
From 1 comment
Yes, you need root to grant capture permission to Postgres, but Postgres doesn't need to run as root. The main purpose is to easily ingest network traffic data into Postgres for…
burmecia on HN