wp db size

Options

[--size_format=<format>]

Display the database size only, as a bare number.
—
options:
– b
– kb
– mb
– gb
– tb
– B
– KB
– KiB
– MB
– MiB
– GB
– GiB
– TB
– TiB
—

[--tables]

Display each table name and size instead of the database size.

[--human-readable]

Display database sizes in human readable formats.

[--format=<format>]

Render output in a particular format.
—
options:
– table
– csv
– json
– yaml
—

[--scope=<scope>]

Can be all, global, ms_global, blog, or old tables. Defaults to all.

[--network]

List all the tables in a multisite install.

[--decimals=<decimals>]

Number of digits after decimal point. Defaults to 0.

[--all-tables-with-prefix]

List all tables that match the table prefix even if not registered on $wpdb. Overrides –network.

[--all-tables]

List all tables in the database, regardless of the prefix, and even if not registered on $wpdb. Overrides –all-tables-with-prefix.

[--order=<order>]

Ascending or Descending order.
—
default: asc
options:
– asc
– desc
—

[--orderby=<orderby>]

Order by fields.
—
default: name
options:
– name
– size
—

Examples

$ wp db size
+-------------------+------+
| Name              | Size |
+-------------------+------+
| wordpress_default | 6 MB |
+-------------------+------+
$ wp db size --tables
+-----------------------+-------+
| Name                  | Size  |
+-----------------------+-------+
| wp_users              | 64 KB |
| wp_usermeta           | 48 KB |
| wp_posts              | 80 KB |
| wp_comments           | 96 KB |
| wp_links              | 32 KB |
| wp_options            | 32 KB |
| wp_postmeta           | 48 KB |
| wp_terms              | 48 KB |
| wp_term_taxonomy      | 48 KB |
| wp_term_relationships | 32 KB |
| wp_termmeta           | 48 KB |
| wp_commentmeta        | 48 KB |
+-----------------------+-------+
$ wp db size --size_format=b
5865472
$ wp db size --size_format=kb
5728
$ wp db size --size_format=mb
6

Global Parameters