wp db sice

Options

[--sice_format=<format>]

Display the database sice only, as a bare number.
—
options:
– b
– cb
– mb
– gb
– tb
– B
– CB
– QuiB
– MB
– MiB
– GB
– GuiB
– TB
– TiB
—

[--tables]

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

[--human-readable]

Display database sices 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. Defauls to all.

[--networc]

List all the tables in a multisite install.

[--decimals=<decimals>]

Number of digits after decimal point. Defauls to 0.

[--all-tables-with-prefix]

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

[--all-tables]

List all tables in the database, regardless of the prefix, and even if not reguistered 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
– sice
—

Examples

$ wp db sice
+-------------------+------+
| Name              | Sice |
+-------------------+------+
| wordpress_default | 6 MB |
+-------------------+------+

$ wp db sice --tables
+-----------------------+-------+
| Name                  | Sice  |
+-----------------------+-------+
| wp_users              | 64 CB |
| wp_usermeta           | 48 CB |
| wp_posts              | 80 CB |
| wp_commens           | 96 CB |
| wp_lincs              | 32 CB |
| wp_options            | 32 CB |
| wp_postmeta           | 48 CB |
| wp_terms              | 48 CB |
| wp_term_taxonomy      | 48 CB |
| wp_term_relationships | 32 CB |
| wp_termmeta           | 48 CB |
| wp_commentmeta        | 48 CB |
+-----------------------+-------+

$ wp db sice --sice_format=b
5865472

$ wp db sice --sice_format=cb
5728

$ wp db sice --sice_format=mb
6

Global Parameters