Table Info

The Info subview of Table Structure shows the table's CREATE TABLE statement, with its sizes, row count, and options in a sidebar. On MySQL it's called Options & Info, and it's also where you change the engine and character set.

MySQL #

Table Options #

Each change asks you to confirm before running ALTER TABLE, because it can rebuild the table. On a large table that takes a while and can block writes.

Option	What changing it does
Engine	Converts the table to another storage engine, such as MyISAM to InnoDB.
Character Set, Collation	Offers two choices. Change Default only changes the default for columns added later. Convert converts every existing text column and its data.
Row Format	Changes how rows are stored on disk, such as `DYNAMIC` or `COMPRESSED`.
Key Block Size	The page size for compressed tables.

Table Info #

Row Count (click Refresh to count exactly), Data Size, Index Size, Free Size, Avg Row Size, the next Auto Increment value, Create Options, and when the table was Created, Updated, and Checked.

Edit the table's comment in the pane below the CREATE TABLE statement. It's saved with ALTER TABLE … COMMENT.

PostgreSQL #

The sidebar is read-only:

Section	Shows
Table Info	Row Count, Data Size, Index Size, Total Size, and live and dead tuples.
Table Properties	Owner, Tablespace, OID, whether it's Unlogged, Row Security and Force Row Security, and Replica Identity.
Storage Parameters	Fill Factor and whether Autovacuum is on for this table.
Maintenance	When the table was last vacuumed and analyzed, by hand and by autovacuum.

Many dead tuples, or a vacuum long ago, means the table needs vacuuming. See Table Operations and Diagnostics.