On Mon, 2008-01-28 at 22:17 +0000, Jeremy Harris wrote:
> We have one problematic table, which has a steady stream of entries
> and a weekly mass-delete of ancient history. The "bloat" query from
> Greg Sabino Mullane (thanks to Greg Smith for pointing it out) returns:
>
> schemaname | tablename | reltuples | relpages | otta | tbloat | wastedpages | wastedbytes | wastedsize |
iname | ituples | ipages | iotta | ibloat | wastedipages | wastedibytes | wastedisize
>
------------+------------+-----------+----------+------+--------+-------------+-------------+------------+-----------------------------+---------+--------+-------+--------+--------------+--------------+-------------
> public | rcpt_audit | 1300300 | 152149 | 6365 | 23.9 | 145784 | 1194262528 | 1139 MB |
rcpt_audit_msg_audit_id_idx| 1300300 | 6798 | 3819 | 1.8 | 2979 | 24403968 | 23 MB
> public | rcpt_audit | 1300300 | 152149 | 6365 | 23.9 | 145784 | 1194262528 | 1139 MB |
rcpt_audit_id_idx | 1300300 | 4727 | 3819 | 1.2 | 908 | 7438336 | 7264 kB
>
Can you let me know what is the sql used to generate such a nice summary
of the tables?