pg_flight_recorder: Continuously sample PostgreSQL system state via pg_cron

ttanelpoder 2 days ago 4 commentsRead Article on github.com

⚡ Community Insights

Discussion Sentiment

50% Positive

Analyzed from 98 words in the discussion.

Discussion (4 Comments)Read Original on HackerNews

Valodim•about 7 hours ago

This sounds promising, but the examples don't show what a report actually looks like? What information does this actually show?

nijave•about 5 hours ago

They don't have an example but they have the schema the functions return

https://github.com/dventimisupabase/pg_flight_recorder/blob/...

esafak•about 6 hours ago

This looks like metrics. No otel sink?

nijave•about 5 hours ago

After reading docs don't think that makes much sense. This is sampling a bunch of stats from pg, wait sampling, and stat statements and storing somewhere in pg. If you want otel, you can do that yourself with pg exporter and store in your otel store.

Seems like it basically automates capturing metrics and storing them in PG but doesn't actually handle the instrumentation (it reads from various other things).