FBSTAT(1)

πŸ¦‹ FBSTAT(1) β€” the Firebird database analyzer, bestie edition πŸ¦‹

okay so before we even get into it: this is a Firebird documentation page, and we're talking about fbstat. Pull up a chair, grab a strawberry πŸ“, and let's get into it.


✨ NAME ✨

fbstat β€” analyze firebird database πŸ’…


🌸 SYNOPSIS 🌸

fbstat [command] [option...] [server:]database
fbstat -h server:db
fbstat -all server:db
fbstat -data server:db

πŸ’– DESCRIPTION πŸ’–

(Note: Due to file-level conflict, the Debian package has changed the name of gstat to fbstat.)

So fbstat analyzes Firebird databases and produces different kinds of reports, no cap. πŸŽ€ These reports are literally the moment when you're sitting there like "where did all this huge disk space go 😭" or when you're estimating/evaluating index efficiency. It's giving detective energy. It's giving receipts. πŸ‘‘


πŸ‘‘ OPTIONS πŸ‘‘

  • -all β€” Analyze data and index pages. everything, go off. πŸ”₯
  • -data β€” Analyze data pages. just the data pages, bestie.
  • -system β€” Analyze system tables. peeking behind the curtain 🫣
  • -header β€” Display information from the database header, and skip analyzing any tables. header only, we're not doing the whole thing.
  • -index β€” Analyze leaf index pages. πŸƒ
  • -record β€” Analyze average record and version length. math girlies rise πŸ™ˆ
  • -table table β€” Analyze data pages used by the given table. one table, main character energy.
  • -nocreation β€” Suppress creation date. no birthday for you πŸŽ‚πŸš«
  • -user name / -password secret / -fetch_password file β€” Authentication parameters. your lil login vibe check πŸ’œ
  • -z, -? β€” Displays version number.

Copyright (C) 2010, Damyan Ivanov.

This manpage was written by Damyan Ivanov for the Debian project but may be used by others. Permission is granted to use this document, with or without modifications, provided that this notice is retained. If we meet some day, and you think this stuff is worth it, you can buy me a beer in return. 🍻 (genuinely iconic offer, honestly)


okay that's the whole page, you ate it πŸ’…βœ¨ this was Firebird 4.0, dated 2026-06-28 β€” mwah, go analyze something πŸ¦‹πŸ’–

πŸ“¦ where this page comes from