On Mar 30, 2011, at 10:20 PM, Dan Langille wrote: > On Mar 30, 2011, at 4:46 PM, Rodrigo Renie Braga wrote: > >> Hello list. >> >> Can someone send me the SQL Query to get the size that all my Full, Diff and >> Inc backups are currently consuming? In my config, I have 5 Pools that store >> Full Backup tapes, the same happens for Diff and Inc Backups. But if you >> send me a SQL Query. >> >> I'm going to use this to know when should I get more tapes for my Storage... > > The OP contacted me on IRC and I suggested they post here. They were asking > me about this page: > > https://services.unixathome.org/bacula/ > > SELECT P.Name as name, > pg_size_pretty( sum( coalesce( m.volbytes, 0 ) )::bigint) as size, > count(M.mediaid) as tape_count > FROM pool P, media M > WHERE P.PoolId = m.poolid > AND P.name IN ('Incrementals', 'Differentials', 'Fulls') > GROUP BY 1 > ORDER BY P.name
I believe the OP contacted me because of this webpage: https://services.unixathome.org/bacula/ This webpage now has the ability to display the SQL associated with each output. ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
