p4 dbstat

Synopsis

Display size or simple statistics for a database table.

Syntax


p4 [g-opts] dbstat [-h] {-a | dbtable …}
p4 [g-opts] dbstat -s

Description

The p4 dbstat command displays statistics on the internal state of the Perforce database. The dbtable corresponds to the db.* files in your server's root directory. This command is typically used in conjunction with Perforce technical support for purposes of estimating disk seeks due to sequential database scans.

To obtain size information, use p4 dbstat -s.

Options

-a

Display statistics for all tables.

-h

Display a histogram showing distances between leaf pages.

-s

Report file sizes of database tables.

dbtable

Display statistics for only the specified tables (for instance, db.have, db.user, and so on.)

g-opts

See “Global Options”.

Usage Notes

Can File Arguments Use Revision Specifier?

Can File Arguments Use Revision Range?

Minimal Access Level Required

N/A

N/A

super

  • Because p4 dbstat locks out write access to the database while it scans the tables, use this command with care. You will most often use this command when working with Perforce technical support.