{%- extends "_layout.html" %} {%- block content %}

{{ hawat_view_title }}



{{ gettext('Event database') }}

{{ gettext('Estimated number of events:') }} {%- if database_status['row_estimate'] %} {{ babel_format_decimal(database_status['row_estimate']) }} {%- else %} {{ database_status['row_estimate'] }} {%- endif %}
{{ gettext('Index size:') }} {{ database_status['index_bytes_str'] }}
{{ gettext('Table size:') }} {{ database_status['table_bytes_str'] }}
{{ gettext('Tablespace size:') }} {{ database_status['toast_bytes_str'] }}
{{ gettext('Total size:') }} {{ database_status['total_bytes_str'] }}
{{ gettext('Oldest event:') }} {{ babel_format_datetime(database_status['dt_oldest']) }} ({{ gettext('before') }} {{ babel_format_timedelta(current_datetime_utc - database_status['dt_oldest']) }})
{{ gettext('Newest event:') }} {{ babel_format_datetime(database_status['dt_newest']) }} ({{ gettext('before') }} {{ babel_format_timedelta(current_datetime_utc - database_status['dt_newest']) }})
{{ gettext('Oldest event:') }} {{ babel_format_datetime(database_status['dt_oldest']) }} ({{ gettext('before') }} {{ babel_format_timedelta(current_datetime_utc - database_status['dt_oldest']) }})
{{ gettext('Event timespan:') }} {{ babel_format_timedelta(database_status['dt_newest'] - database_status['dt_oldest']) }}

{{ gettext('PostgreSQL') }}

{%- for setting in ['max_connections','shared_buffers','work_mem','maintenance_work_mem','wal_buffers','effective_cache_size']%} {%- endfor %}
{{ gettext('Version:') }} {{ sw_versions['postgresql'] }}
{{ setting }}: {%- if database_status['pg_settings'][setting].vartype == 'integer' %} {{ babel_format_decimal(database_status['pg_settings'][setting].setting) }} {%- else %} {{ database_status['pg_settings'][setting].setting }} {%- endif %} [{{ database_status['pg_settings'][setting].unit | default('None') }}] {{ database_status['pg_settings'][setting].vartype }} {{ database_status['pg_settings'][setting].category }} {{ get_fa_icon('help')}}
{%- if permission_can('developer') %}
STATUS:
{{ database_status | pprint }}
SW VERSIONS:
{{ sw_versions | pprint }}
                    
{%- endif %}
{%- endblock content %}