{% load i18n %}
{% trans "disk usage ยท unused / redundant / unindexed-FK ยท orphan rows ยท dead rows" %}
| {% trans "Table" %} | {% trans "Total" %} | {% trans "Table" %} | {% trans "Indexes" %} |
|---|---|---|---|
| {{ s.qualified }} |
{{ s.total }}
|
{{ s.table }} | {{ s.index }} |
{{ sizes_error }}
{% else %}{% trans "No user tables." %}
{% endif %}| {% trans "Index" %} | {% trans "On table" %} | {% trans "Scans" %} | {% trans "Size" %} | |
|---|---|---|---|---|
| {{ u.name }} | {{ u.schema }}.{{ u.table }} | {{ u.scans }} | {{ u.size|default:"โ" }} |
{% trans "No unused indexes โ every index has been used. ๐" %}
{% endif %}| {% trans "Table" %} | {% trans "Unique on" %} | {% trans "Nullable" %} | {% trans "Slipped through" %} |
|---|---|---|---|
| {{ u.qualified }} | {{ u.columns }} ({{ u.constraint|default:u.index }}) | {{ u.nullable }} | |
{% trans "No composite UNIQUE has a nullable column โ no hole to fit through. ๐" %}
{% endif %}| {% trans "Index" %} | {% trans "On table" %} | {% trans "State" %} | {% trans "Size" %} | |
|---|---|---|---|---|
| {{ ix.name }} | {{ ix.schema }}.{{ ix.table }} | {% if ix.building %} {% trans "building" %} {% elif not ix.live %} {% trans "drop failed" %} {% else %} {% trans "build failed" %} {% endif %} | {{ ix.size|default:"โ" }} |
{% trans "No invalid indexes โ every index is usable. ๐" %}
{% endif %}{% trans "Not applicable to this engine โ InnoDB requires and auto-creates an index on every foreign key's columns, so there's never one missing." %}
{% elif fk_missing %}| {% trans "Table" %} | {% trans "Columns" %} | {% trans "References" %} | {% trans "Constraint" %} | |
|---|---|---|---|---|
| {{ f.qualified }} | {{ f.columns }} | {{ f.references }} | {{ f.constraint }} |
{% trans "Every foreign key has a supporting index. ๐" %}
{% endif %}| {% trans "Table" %} | {% trans "Redundant index" %} | {% trans "Covered by" %} | {% trans "Size" %} | |
|---|---|---|---|---|
| {{ d.qualified }} | {{ d.name }} ({{ d.columns }}) {% if d.identical %}{% trans "identical" %}{% endif %} | {{ d.covered_by }} ({{ d.covered_by_columns }}) | {{ d.size|default:"โ" }} |
{% trans "No redundant indexes โ no index is covered by another. ๐" %}
{% endif %}{% trans "Not applicable to this engine โ InnoDB has no NOT VALID clause, so a declared foreign key is always enforced and can't carry orphan rows." %}
{% elif orphan_candidates %}| {% trans "Table" %} | {% trans "Columns" %} | {% trans "References" %} | {% trans "Kind" %} | {% trans "Orphan rows" %} |
|---|---|---|---|---|
| {{ o.qualified }} | {{ o.columns }} | {{ o.references }} ({{ o.ref_columns }}) | {% if o.inferred %} {% trans "inferred" %} {% else %} {% trans "NOT VALID" %} {% endif %} | |
{% trans "No unvalidated FKs, and every *_id column that names a table is backed by one. ๐" %}
{% endif %}{% trans "Not applicable to this engine โ InnoDB has no vacuum or dead-tuple model, so there's nothing to report here." %}
{% elif vacuum %}| {% trans "Table" %} | {% trans "Live" %} | {% trans "Dead" %} | {% trans "Dead %" %} | {% trans "Last vacuum" %} | {% trans "Last analyze" %} |
|---|---|---|---|---|---|
| {{ v.qualified }} | {{ v.live }} | {{ v.dead }} | {{ v.dead_pct }}% | {% if v.last_vacuum %}{% blocktrans with t=v.last_vacuum|timesince %}{{ t }} ago{% endblocktrans %}{% else %}{% trans "never" %}{% endif %} | {% if v.last_analyze %}{% blocktrans with t=v.last_analyze|timesince %}{{ t }} ago{% endblocktrans %}{% else %}{% trans "never" %}{% endif %} |
{% trans "No table statistics yet." %}
{% endif %}{% trans "Not applicable to this engine โ there's no MySQL/InnoDB equivalent of the pg_stats bloat estimate." %}
{% elif bloat %}| {% trans "Table" %} | {% trans "Size" %} | {% trans "Wasted (est.)" %} | {% trans "Wasted %" %} | {% trans "Bloat ร" %} |
|---|---|---|---|---|
| {{ b.qualified }} | {{ b.table_bytes|filesizeformat }} | {{ b.wasted_bytes|filesizeformat }} | {{ b.wasted_pct }}% | {{ b.bloat_ratio }}ร |
{{ bloat_error }}
{% else %}{% trans "No bloat to estimate (or stats not collected yet)." %}
{% endif %}