On 3/9/2011 5:36 PM, ganiuszka wrote:
> 2011/3/9 Mike Eggleston<mikeegg1 AT mac DOT com>:
>> Afternoon,
>>
>> I just noticed one of my clients had a huge incremental (level 2)
>> backup. I want to see what file caused the huge increase. I tried 'list
>> files jobid=20097' and though I'm shown the files, I'm not shown the
>> size of each file. Is there a command or query that shows me the size
>> of the file?
>>
>> Mike
> Hi,
> Here you have SQL function for PostgreSQL (I took it from bweb):
>
> CREATE PROCEDURAL LANGUAGE plpgsql;
> BEGIN;
>
> CREATE OR REPLACE FUNCTION base64_decode_lstat(int4, varchar) RETURNS int8 AS
> $$
> DECLARE
> val int8;
> b64 varchar(64);
> size varchar(64);
> i int;
> BEGIN
> size := split_part($2, ' ', $1);
> b64 := 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
> val := 0;
> FOR i IN 1..length(size) LOOP
> val := val + (strpos(b64, substr(size, i, 1))-1) * (64^(length(size)-i));
> END LOOP;
> RETURN val;
> END;
> $$ language 'plpgsql';
>
> COMMIT;
>
> and this is a query which lists file path, filename and size in Bytes
> (in this example for jobid=8):
>
> SELECT Path.Path, Filename.Name, base64_decode_lstat(8,File.LStat) AS
> size FROM Filename, File, Path WHERE File.JobId=8 AND
> File.PathId=Path.PathId AND Filename.FilenameId=File.FilenameId ORDER
> BY size ASC;
>
> I tested it. It works.
For the record:
In this query, I see base64_decode_lstat(8,File.LStat)
What is 8? It is not jobid. It is a field id. This lstat value:
BZ FNmi IGw B BQ Bb U6Wq E7 EAA E BNeOq1 BNeOq1 BNeOrS A A C
The eight field, as defined by ' ', is E7.
--
Dan Langille - http://langille.org/
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
