Probably your statistics collector is not running. http://www.postgresql.org/docs/8.2/static/monitoring-stats.html
Bob Gobeille On Mar 15, 2010, at 1:14 PM, Furosh One wrote: > Sorry about re-posting this but I'm not sure what or if I can do > anything about this. > > So we've been going on this new server for a few weeks now and its > crunching tons of source-code. > However, I expected this Fossology DB size on the main page > http://localhost/repo/ -> Admin -> Dashboard to start displaying some > amount of size close to the fossology-database size but for some > reason it's still showing up as Zero 0. > > Our fossology DB and actual disk space used is currently at: > > [r...@san-psip ~]# du -sh /var/lib/pgsql/data/ > > 8.0G /var/lib/pgsql/data/ > > which is similar to the database size of fossology: > > > postgres=# SELECT pg_size_pretty(pg_database_size('fossology')); > pg_size_pretty > ---------------- > 7907 MB > (1 row) > > > But when using your query to display Fossology DB size on Dashboard, > its still showing zero, or nothing unlike the last time I used this > query: > > postgres=# SELECT SUM(relpages) AS val FROM pg_class INNER JOIN > > pg_stat_all_tables ON pg_stat_all_tables.relname = pg_class.relname > WHERE schemaname='public'; > val > ----- > > > (1 row) > > Last time I ran this it displayed: val = 0. > > So in theory the query and displayed size is correct, but this seems > more like an issue or something not being right, (possibly a bug?). I > don't know but I would like to attempt to correct this somehow. > > I would hope to see something close to the DB size when going to the > Dashboard page. Others engineers have asked me about this and I really > don't know what to tell them. > > Is this expected results? > Is this some sort of bug/issue? > Can I correct this to show DB size in Dashboard page? > > Any suggestions, recommendations? > > -Gibran > _______________________________________________ > fossology mailing list > fossology@fossology.org > http://fossology.org/mailman/listinfo/fossology _______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
