Skip to content

Add storage and bandwidth usage to instance dashboard

Is your feature request related to a problem? Please describe

The instance dashboard should display some analytics.

Describe the solution you'd like

The instance dashboard should display:

  • Number of uploaded bytes per month as a graph
SELECT sum(file_size), DATE_FORMAT(`updated_at`,'%Y-%m') AS month FROM `cp_media` GROUP BY month ORDER BY month;
  • Number of total uploaded bytes
SELECT sum(file_size) FROM `cp_media`;
  • Number of downloaded bytes per months as a graph
SELECT sum(`bandwidth`), DATE_FORMAT(`updated_at`,'%Y-%m') AS month FROM `cp_analytics_podcasts` GROUP BY month ORDER BY month;