Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lBr8F-00071I-TQ for pgsql-admin@arkaria.postgresql.org; Tue, 16 Feb 2021 03:34:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lBr8E-0005R7-HY for pgsql-admin@arkaria.postgresql.org; Tue, 16 Feb 2021 03:34:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lBr8E-0005R0-5j for pgsql-admin@lists.postgresql.org; Tue, 16 Feb 2021 03:34:34 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lBr8A-0004hD-91 for pgsql-admin@postgresql.org; Tue, 16 Feb 2021 03:34:33 +0000 Received: by mail-ej1-x62b.google.com with SMTP id f14so14390452ejc.8 for ; Mon, 15 Feb 2021 19:34:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=ESXDNv+X2dIVvHtDhEw2ebV88d3YUEub3mMtlr2YwLo=; b=KmD0eKKyVYXcWH461bAHQrd9lQjrekQob+HrK8LHDbputpCFyzuEC//1GwFNHA8gJ4 tLP7nbZfzUSbNHyCCh3OwTmio5R63R8lDaIXIiI1sZY2hmTghZLDUJ8Wd7KEDHr5SrXr H59BxKUefRRRsjDSVH2oEsmAIU5n0pR0dh8//98+g33rj+c5nlphI5cCPrpHdYia1776 ZZnBPhqhRiSuSUYdpXUXdnoCm6KrwVTDu7zGwxnm0uKYiXTO7sP3LrseDWW7vcyPyjUT cMrkVat97igG/1SyOOmhEdEUya8zVnadzJnIENaH5FgTOK+2GAYjO2Y5ttw74B3VaHCa ojgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=ESXDNv+X2dIVvHtDhEw2ebV88d3YUEub3mMtlr2YwLo=; b=A4OGE3tVNHXlmB3shp0kfV8egA/gW6LCoUIEZZGbwNkf58oO4J7Tm2VVC+E2MagBbh PBY9HRmze/0gQIEsG/+t2IN90WJCbp0f5v2M60yCGOn03f/HZu/NXgoOjdDSKMRMHrkc DUicRrHinHKk1yXbFBn0yXcMRLV/pX9vW5VK5RsElcXmUOZLvtF2c1IH/nHkwxRL1C71 U0gMzYIZBPOWUo56FPdlkqsPbPcYcsdvkrykXlA7fePGO33DhUoe3ywmaGaqEFSMIT+V GrDbkrAJjbZjmoNW0ImIwXLkky1Y8SD7H3DI8lI9REt45Si2ECqSFCFaEj2tqWzTYDBz yfJg== X-Gm-Message-State: AOAM531/hgQ4Kod9bI7/t64ToLpFUw5N+k34eNgVUoc6HvRE69EMGZI+ Oyfa/BjA/M1xo5l4WJZ/K07k3g== X-Google-Smtp-Source: ABdhPJzx0VvYvQBLF0CpOdNWbhCT4aG8mQfxMI8mIYUoVjgeNcPc0eXQtzX+D0/KnpkmKLPHKdKqzg== X-Received: by 2002:a17:906:b042:: with SMTP id bj2mr18333195ejb.261.1613446469394; Mon, 15 Feb 2021 19:34:29 -0800 (PST) Received: from localhost.localdomain (178-190-180-133.adsl.highway.telekom.at. [178.190.180.133]) by smtp.gmail.com with ESMTPSA id b13sm3011578edy.77.2021.02.15.19.34.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 15 Feb 2021 19:34:29 -0800 (PST) Message-ID: Subject: Re: Getting relevant table value as pertains to autovacuum_analyze_scale_factor (and vacuum scale factor)? From: Laurenz Albe To: Wells Oliver , pgsql-admin Date: Tue, 16 Feb 2021 04:34:28 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, 2021-02-15 at 16:05 -0800, Wells Oliver wrote: > Where can I pull this from? I am guessing it's just number of dead tuples / row count, > but Im not exactly sure. Would like to show these factors per relation in an overall view I have. The row count of the table is taken from pg_class.reltuples, and the number of dead tuples is taken from the "pg_stat_get_dead_tuples" function. Note that the autovacuum parameters can be overridden by storage parameters on the table. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com