Top
Best
New

Posted by tanelpoder 2 days ago

pg_flight_recorder: Continuously sample PostgreSQL system state via pg_cron(github.com)
14 points | 4 comments
Valodim 21 hours ago|
This sounds promising, but the examples don't show what a report actually looks like? What information does this actually show?
nijave 20 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 21 hours ago|
This looks like metrics. No otel sink?
nijave 20 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).