wp db size

Displays the database name and size

Options

NameDescription
--size_format <format>Display the database size only, as a bare number
--tablesDisplay each table name and size instead of the database size
--human-readableDisplay database sizes in human readable formats
--format <options>Render output in a particular format
--scope <scope>Can be all, global, ms_global, blog, or old tables. Defaults to all
--networkList all the tables in a multisite install
--all-tables-with-prefixList all tables that match the table prefix even if not registered on $wpdb. Overrides –network
--all-tablesList all tables in the database, regardless of the prefix, and even if not registered on $wpdb. Overrides –all-tables-with-prefix