pg_flight_recorder: Continuously sample PostgreSQL system state via pg_cron
github.comThis sounds promising, but the examples don't show what a report actually looks like? What information does this actually show?
They don't have an example but they have the schema the functions return
https://github.com/dventimisupabase/pg_flight_recorder/blob/...
This looks like metrics. No otel sink?
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).