[Bucardo-general] rates table

[Greg Sabino Mullane]

> I want to display the rate of inserts to a table, in a graph. 
> So the graph will show how many inserts have been performed 
> to a specific table each hour of the day.
> 
> Can I use the rates table for this ? The doco is not clear on 
> what info it is storing

Replying more for posterity than anything else, as the next version 
of Bucardo will do things very differently. Yes, you can use the 
bucardo_rate table - but it is only enabled if 'track_rates' is 
on at the sync level. The format of the table is:

CREATE TABLE bucardo.bucardo_rate (
  sync         TEXT        NOT NULL,
  goat         INTEGER     NOT NULL,
  target       TEXT            NULL,
  mastercommit TIMESTAMPTZ NOT NULL,
  slavecommit  TIMESTAMPTZ NOT NULL,
  total        INTEGER     NOT NULL
);

So you can get the total time the sync took by subtracting 
mastercommit from slavecommit. The "total" is the number 
of rows moved around. This table never got much love, so 
it may very well not work well. :)

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110704/5f2e9a60/attachment.bin