{% if messages %} {% for message in messages: %}
{% endfor %} {% endif %}
{% if page == 'stats-summary' %}

DB overview {% if dbname %}for "{{dbname}}"{% endif %} (based on metrics stored in {{datastore}})

{% if data %}
{% for key, values in data %} {% endfor %}
Attribute Last 7d avg Last 24h avg Last 1h avg
{{key}} {{values[0]}} {{values[1]}} {{values[2]}}
{% endif %} {% elif page == 'statements' %}

pg_stat_statements Top 50 by {{sort_column}} {% if dbname %}for "{{dbname}}"{% endif %} (based on metrics stored in {{datastore}})

From: To: 1h | 3h | 6h | 12h | 1d | 1w | 1m
{% if data %}
{% for d in data %} {% endfor %}
queryid query total_time mean_time calls shared_blks_hit shared_blks_read shared_blks_written temp_blks_read temp_blks_written blk_read_time blk_write_time
{{d['queryid']}} {{d['query']}} {{d['total_time']}} {{d['mean_time']}} {{d['calls']}} {{d['shared_blks_hit']}} {{d['shared_blks_read']}} {{d['shared_blks_written']}} {{d['temp_blks_read']}} {{d['temp_blks_written']}} {{d['blk_read_time']}} {{d['blk_write_time']}}
{% endif %} {% endif %}