Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1iB5MU-0003H3-9Q
	for pgsql-performance@arkaria.postgresql.org; Thu, 19 Sep 2019 22:57:18 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1iB5MS-00078J-VI
	for pgsql-performance@arkaria.postgresql.org; Thu, 19 Sep 2019 22:57:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1iB5MS-000785-MF
	for pgsql-performance@lists.postgresql.org; Thu, 19 Sep 2019 22:57:16 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1iB5MQ-0006GZ-HS
	for pgsql-performance@lists.postgresql.org; Thu, 19 Sep 2019 22:57:16 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x8JMvBeG018658;
	Thu, 19 Sep 2019 18:57:11 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?Q?Lu=c3=ads_Roberto_Weck?= <luisroberto@siscobra.com.br>
cc: Michael Lewis <mlewis@entrata.com>, pgsql-performance@lists.postgresql.org
Subject: Re: Slow query on a one-tuple table
In-reply-to: <f1468794-1681-3f1e-2f9c-b491cb87ed5d@siscobra.com.br>
References: 
 <CA+t6e1kacbVHq69aihEVeBzH_nMY5eK7bZ-UXL_FuUquEgF_gg@mail.gmail.com>
 <24571.1568910502@sss.pgh.pa.us>
 <774d6080-d6d7-e9e7-7351-9a412c7d5956@siscobra.com.br>
 <CAHOFxGqMpUxn54jMLoU4-HcUata2yfLgjEbRHdJG3k0BBDPbog@mail.gmail.com>
 <ab6ea98e-6266-7665-40b7-151c5736c08d@siscobra.com.br>
 <BN6PR1701MB1890E31E15D486A85FEC8510DA890@BN6PR1701MB1890.namprd17.prod.outlook.com>
 <bf03aedc-9201-f7c9-ef25-e795d4e1626a@siscobra.com.br>
 <BN6PR1701MB1890A207FBF02BBC5E3C9F01DA890@BN6PR1701MB1890.namprd17.prod.outlook.com>
 <18ae8108-acaf-e9cc-96a9-ab20f4147f5a@siscobra.com.br>
 <35df2bd8-4c7c-7ace-6bdc-d6d97a101a14@siscobra.com.br>
 <1980a708-ed4a-6fc6-2792-33c07b07d704@siscobra.com.br>
 <CAHOFxGosug4xfpieTqFdcFqwF-mK3hn8Tr9boN=jLFDU3y-JNQ@mail.gmail.com>
 <f1468794-1681-3f1e-2f9c-b491cb87ed5d@siscobra.com.br>
Comments: In-reply-to =?UTF-8?Q?Lu=c3=ads_Roberto_Weck?=
 <luisroberto@siscobra.com.br>
	message dated "Thu, 19 Sep 2019 19:46:46 -0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <18656.1568933831.1@sss.pgh.pa.us>
Date: Thu, 19 Sep 2019 18:57:11 -0400
Message-ID: <18657.1568933831@sss.pgh.pa.us>
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

=?UTF-8?Q?Lu=c3=ads_Roberto_Weck?= <luisroberto@siscobra.com.br> writes:
> As fas as autovacuum options, this is what I'm using:

> autovacuum_vacuum_scale_factor=0,

Ugh ... maybe I'm misremembering, but I *think* that has the effect
of disabling autovac completely.  You don't want zero.

Check in pg_stat_all_tables.last_autovacuum to see if anything
is happening.  If the dates seem reasonably current, then I'm wrong.

			regards, tom lane