[check_postgres] Bloat check skips messages for tables with same name in different databases
Mark Kirkwood
mark.kirkwood at catalyst.net.nz
Fri May 29 03:23:51 UTC 2009
I've been looking at using check_postgres.pl to check bloat - which is
seems to do really well.
By accident I noticed that for a check which includs multiple databases,
each containing the same schema e.g 3 copies of pgbench:
$ check_postgres.pl --port=5432 --dbname=bench,bench1,bench2
--action=bloat --warn='10M' --critical='1G' --timeout=100
I only get 1 warning from database 'bench', when in fact all of 'em have
bloated tables. Is this intended?
After a bit of gazing at the code I make a change that got me all the
warnings back (attached) - hopefully I haven't completely broken the
intent of the 'seeit' check!
Cheers
Mark
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_postgres.pl.diff
Type: text/x-patch
Size: 750 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090529/7002ee0a/attachment.bin
More information about the Check_postgres
mailing list