pg_flight_recorder ← Project page

Install in two pastes.

Two self-contained SQL bundles ready for the Supabase dashboard SQL editor (or any plain-SQL client). No psql, no CLI, no extension registry.

Latest release: v2.29.2

01 / required

pgfr_record — core recorder

Tables, collection functions, scheduling, the partitioned sample ring, safety mechanisms. Schedules every pg_cron job on install.

Download
Preview SQL
Loading…
02 / optional

pgfr_analyze — reporting & analysis

Anomaly detection, time-travel, incident timelines, capacity planning. Requires pgfr_record to be installed first.

Download
Preview SQL
Loading…

Uninstall

Destructive. Each script drops a schema with CASCADE — every table, view, and function in that schema is removed, along with the data. Cron jobs (pgfr_*) are unscheduled first. If you only want to stop collection without removing data, run SELECT pgfr_record.disable(); instead.

01 / uninstall

pgfr_analyze

Drops the pgfr_analyze schema. Reverses the second install step. Safe to run first; it has no side effects on pgfr_record.

Download
Preview SQL
Loading…
02 / uninstall

pgfr_record

Unschedules every pgfr_* cron job, deletes their run-history rows, then drops the pgfr_record schema. Run this after pgfr_analyze if you've installed both.

Download
Preview SQL
Loading…