Supabase
Inspect Commands
Database diagnostics
8 commands
Commands
Show table and index bloat
$ supabase inspect db bloat --linked
Show table and index bloat estimation
Show blocking queries
$ supabase inspect db blocking --local
Show queries holding locks and blocking others
List queries by frequency
$ supabase inspect db calls --linked
List queries ordered by call frequency
Show index stats
$ supabase inspect db index-stats --linked
Show index performance and usage stats
Show exclusive locks
$ supabase inspect db locks --local
Show queries with exclusive locks
List long-running queries
$ supabase inspect db long-running-queries --linked
List queries running longer than 5 minutes
Show query outliers
$ supabase inspect db outliers --local
Show statements by total execution time
Show vacuum stats
$ supabase inspect db vacuum-stats --local
Show vacuum activity and dead row counts