[OT] Re: enabling autovacuum

[Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>]

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?