{%- extends "_layout.html" %} {%- block content %}
{{ _('List of available tables:') }}
{{ _('Estimated number of records:') }} | {%- if table_data['row_estimate'] %} {{ babel_format_decimal(table_data['row_estimate']) }} {%- else %} {{ table_data['row_estimate'] }} {%- endif %} |
---|---|
{{ _('Table size:') }} | {{ table_data['table_bytes_str'] }} ({{ babel_format_percent(table_data['table_bytes'] / table_data['total_bytes']) }}) |
{{ _('Index size:') }} | {{ table_data['index_bytes_str'] }} ({{ babel_format_percent(table_data['index_bytes'] / table_data['total_bytes']) }}) |
{{ _('Tablespace size:') }} | {{ table_data['toast_bytes_str'] }} ({{ babel_format_percent(table_data['toast_bytes'] / table_data['total_bytes']) }}) |
{{ _('Total size:') }} | {{ table_data['total_bytes_str'] }} ({{ babel_format_percent(table_data['total_bytes'] / table_data['total_bytes']) }}) |
{{ _('Oldest record:') }} | {%- if 'dt_oldest' in table_data and table_data['dt_oldest'] %} {{ babel_format_datetime(table_data['dt_oldest']) }} ({{ gettext('%(delta)s ago', delta = babel_format_timedelta(current_datetime_utc - table_data['dt_oldest'])) }}) {%- else %} {{ _('unknown') }} {%- endif %} |
{{ _('Newest record:') }} | {%- if 'dt_newest' in table_data and table_data['dt_newest'] %} {{ babel_format_datetime(table_data['dt_newest']) }} ({{ gettext('%(delta)s ago', delta = babel_format_timedelta(current_datetime_utc - table_data['dt_newest'])) }}) {%- else %} {{ _('unknown') }} {%- endif %} |
{{ _('Record timespan:') }} | {%- if 'dt_oldest' in table_data and table_data['dt_oldest'] and 'dt_newest' in table_data and table_data['dt_newest']%} {{ babel_format_timedelta(table_data['dt_newest'] - table_data['dt_oldest']) }} {%- else %} {{ _('unknown') }} {%- endif %} |
{{ _('Name') }} | {{ _('Type') }} | {{ _('Value [unit]') }} | {{ _('Boot / Reset') }} | {{ _('Description') }} |
---|---|---|---|---|
{{ _('version:') }} | string | {{ sw_versions['postgresql'] }} | ||
{{ setting }}: | {{ database_status_events['pg_settings'][setting].vartype }} {%- if database_status_events['pg_settings'][setting].vartype in ['integer', 'real'] %} {{ get_icon('help')}} {%- elif database_status_events['pg_settings'][setting].vartype in ['enum'] %} {{ get_icon('help')}} {%- endif %} | {% if database_status_events['pg_settings'][setting].setting != database_status_events['pg_settings'][setting].boot_val %} {%- endif %} {%- if database_status_events['pg_settings'][setting].vartype in ['integer', 'real'] %} {{ babel_format_decimal(database_status_events['pg_settings'][setting].setting) }} {%- else %} {{ database_status_events['pg_settings'][setting].setting }} {%- endif %} {% if database_status_events['pg_settings'][setting].setting != database_status_events['pg_settings'][setting].boot_val %} {%- endif %} [{{ database_status_events['pg_settings'][setting].unit | default('none') }}] {{ get_icon('help')}} | {%- if database_status_events['pg_settings'][setting].vartype in ['integer', 'real'] %} {{ babel_format_decimal(database_status_events['pg_settings'][setting].boot_val) }} / {{ babel_format_decimal(database_status_events['pg_settings'][setting].reset_val) }} {%- else %} {{ database_status_events['pg_settings'][setting].boot_val }} / {{ database_status_events['pg_settings'][setting].reset_val }} {%- endif %} | {{ database_status_events['pg_settings'][setting].category }} {{ get_icon('help')}} |