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 ) id 1gT3OH-0006lJ-Tz for pgsql-general@arkaria.postgresql.org; Sat, 01 Dec 2018 11:24:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gT3OG-0001Sv-6B for pgsql-general@arkaria.postgresql.org; Sat, 01 Dec 2018 11:24:52 +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 ) id 1gT3OF-0001Sn-SF for pgsql-general@lists.postgresql.org; Sat, 01 Dec 2018 11:24:51 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gT3OD-00034k-Px for pgsql-general@lists.postgresql.org; Sat, 01 Dec 2018 11:24:51 +0000 Received: by mail-ot1-x32c.google.com with SMTP id a11so7522015otr.10 for ; Sat, 01 Dec 2018 03:24:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=yqJzUNUqGN8NQ6wWvS+PUdbMDiyl+hfA40/cWFZ4qOk=; b=n1z08vuj3f8USa3yby3Vlj+8JmjrocHczBbvyiI4wU7Lb+CGEGsvEy5rCi2IBMyS6N yWgMZBPWmuxT8lJEu28A7uJjgw3iO2tri+jzx/nbXNDOmFLBUSE6mSdo0hx1XJsKB0DA VyYhXfH9VrHbxzvqmVqZ0Q/OmvP6pZ/PgPIilhk5oY0iuRwSYFHFw2T8niVq9rFx9SwA 4AJHbJC7/C2Lpl8YFhc6D249jZfN3zVvnDmdMU4shLPBJUtritJwrQtICgUvd4JMLSYm Hleo+euihGCen3sQiDKu0mSboBQYlZvrc1HtSXOyzYMuteeVnpPmgqqBAR3YHOM3AUao olRQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=yqJzUNUqGN8NQ6wWvS+PUdbMDiyl+hfA40/cWFZ4qOk=; b=kFVEbpZ67uQGJwpkOVwjzmPhRHN7DIJf4/QgmFWdxglJwmKZNW+f6V06h76BwAP3Zt 6JKVjI6BHuKlPRmNigaTi5kXY+bhGzowR7GUqf/38kiFgVYCC4qVZpMyKfWMyM1+URjz Nvmy3n9bFGrVPmcbmRfzkku0X7q+3PYGIhB08Ugh4pepmCGDdaV2AyiVZtxyvw9mDqGi o3c8F4LI3pRiVUadP9Ejoy7po9K0/ZddTUJtaXhVigI8KiaTgZTkXKsbwAWXdj4lgDM+ vPWQFsrYix+qYA6W2S8T0/yLsw6Xsmrc3j5pJvXPOea9qxB6pwS3v3YtijCoOXZJniiP qWvw== X-Gm-Message-State: AA+aEWaW4hJ5mG2CCRkEkkMAMYTB4KqtQ0EWnPqrSZMvfhYu/LMc6gWZ EtK7e85yhWTWIwmJC1panCOMIZWW X-Google-Smtp-Source: AFSGD/UAMZJeokBfCC4zWY8huEHCFTrU2NCccYXFZtC/gr6qzGG97h7S6pqZGXlQ4q+WnWjBvGCHSA== X-Received: by 2002:a9d:63cd:: with SMTP id e13mr6097447otl.319.1543663487200; Sat, 01 Dec 2018 03:24:47 -0800 (PST) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id l108sm3157528otc.23.2018.12.01.03.24.45 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 01 Dec 2018 03:24:46 -0800 (PST) To: pgsql-general@lists.postgresql.org From: Ron Subject: Unused indexes Message-ID: Date: Sat, 1 Dec 2018 05:24:45 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk For indexes that existed before the cluster was last started, and for which REINDEX hasn't been run on them since the cluster was last started... is it valid to say that an index has not been used since the cluster was started if these three pg_stat_all_indexes fields all have a value of 0? idx_scan idx_tup_read idx_tup_fetch If it matters, the version is 9.6.6. Thanks -- Angular momentum makes the world go 'round.