Create a new report that compares the relation size to the number of tuples in the relation, this can be used to help show relation bloat over time. This report(s) should contain indexes as well as tables.
Updated by Darcy Buskermolen almost 17 years ago
Not exactly, I'm not sure if rrd can show diffrent scales onthe same graph, but I was thinking of haveing 3 items ploted on the graph.
A) the number of tuples (reltuples)
B) the size in bytes of the relation (pg_relation_size())
C) the ratio of these 2 (pg_relation_size(oid)/reltuples)
So in effect we would be plotting: SELECT reltubles, pg_relation_size(oid), pg_relation_size(oid)/reltuples FROM pg_class where relkind in ('r','i');
Updated by Darcy Buskermolen almost 16 years ago
I'd like it graphed so that we can see change over time. And an example query is in the ticket, but I'll recap it: SELECT reltuples, pg_relation_size(oid), pg_relation_size(oid)/reltuples FROM pg_class where relkind in ('r','i'); Though I think that without being able to have different scales on the same graph this might be very hard to track in this exact manor. It might require 3 distinct graphs.