use materialised dashboard table

diff --git a/cgi-bin/show_status.pl b/cgi-bin/show_status.pl
index 975d52aa87c7739ee728e443792acff85ff29416..1c363372a74cf3f2689e98e307ff66a2f91b0cf8 100755 (executable)
--- a/cgi-bin/show_status.pl
+++ b/cgi-bin/show_status.pl
@@ -39,8 +39,8 @@ my $db = DBI->connect($dsn,$dbuser,$dbpass) or die("$dsn,$dbuser,$dbpass,$!");
 my $statement =<<EOS;
 
 
 my $statement =<<EOS;
 
 

-  select *
-  from dashboard
+  select timezone('GMT'::text, now())::timestamp(0) without time zone - b.snapshot AS when_ago, b.*
+  from dashboard_mat b

   order by branch = 'HEAD' desc,
         branch desc, $sort_clause 
         snapshot desc
   order by branch = 'HEAD' desc,
         branch desc, $sort_clause 
         snapshot desc