Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 675E62E3294 for ; Mon, 14 Jan 2008 12:13:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16503-06 for ; Mon, 14 Jan 2008 12:13:06 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.180]) by postgresql.org (Postfix) with ESMTP id C17102E2F07 for ; Mon, 14 Jan 2008 12:13:05 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so4031543waf.5 for ; Mon, 14 Jan 2008 08:13:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=aWujqLBRkqosUZxvTg4WDhiCEuRKmkA7eKgRsNATqnc=; b=hIAjudG711Zwmo97br8ZLICxsGwCzGC2F1jtk3oGCmH02Mom3vMmNnP7hsajaPr7+A+jWHkCEnL7dNKsZY1jm4meJrXq4VDjOLf+JkIjsFEXCvA9My1l8YEprdMaCjNC2mjcXIyy8FJxTXEPUHw5iqct9qF5gxx93KpD2mb2Be0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=husmgjnhwwUwRorbPB3OMdHczq/88AxmrI5ygSH9/Dgjhbl/LVTPvewCj6SUw89lGmAo0XulNtl3kOHa/DVk81Irg7r8b67/LvRoFw3ZVG1ZSt2skXPFuZMNbwDFSnpoELwPOVMBkGvZB2IXNMwF+y/i9mvYXFZVdGmoualgzy4= Received: by 10.114.146.1 with SMTP id t1mr3830276wad.20.1200327183671; Mon, 14 Jan 2008 08:13:03 -0800 (PST) Received: by 10.114.199.20 with HTTP; Mon, 14 Jan 2008 08:13:03 -0800 (PST) Message-ID: <4544e0330801140813o18b52999h3e874ae344f1548d@mail.gmail.com> Date: Mon, 14 Jan 2008 10:13:03 -0600 From: "Peter Koczan" To: pgsql-admin@postgresql.org Subject: monitoring free space map usage without VACUUM MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/145 X-Sequence-Number: 27919 Hi all, I'm looking into adding things to the way I monitor pgsql installations. One of them was free space map stuff. Is there a way to get free space information (especially used free space) without having to screen-scrape the output of VACUUM VERBOSE? I know you can get the allocated fsm pages from "show max_fsm_pages", but I'd like something along the lines of "show needed_fsm_pages". Is there anything that can do this? i don't care if the data is a little stale, I'd just like to have a rough picture of free space map settings and usage. Peter