Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7lmf-005fzX-02 for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 02:58:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7lmd-00ERi4-0c for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 02:58:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7lmc-00ERhv-2v for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 02:58:19 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7lma-00000002HZX-0mL3 for pgsql-hackers@postgresql.org; Wed, 01 Apr 2026 02:58:18 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-66c4c7e2bb7so1811850a12.0 for ; Tue, 31 Mar 2026 19:58:16 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775012295; cv=none; d=google.com; s=arc-20240605; b=LA7FBYhY2/RKKHNmQABahG7QKbCg1gd0bcnz5bHbLW5yvli0bPbLyVMV295i4fW72E 3bdq4ShUEL0lA9sJWfqGMnn+LU3anQ6Ofu2lt90ayQK9eSFnGwxgR9NzLfjJQXVpVXWH 4QOpVWLziOu8yjnpqauBtDy2UskXhwlL6oa/FdvijO9AWaLvRpaE0SUePDQzlNjM/vhu DPxNaEcby42ZG6ytZQcmR6yYObyqlsPEVN2rei0ZhX2s6QWlcsL4pbsVj4QvXsGCVzHM dGFoScfP3QvzzKbHh8bzYWGNVE0kxG/3hQTrYnaGAY6JDXpDzh9WAIA47KII+oGPP3s5 Wo8g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=+N6BZE0iSMhORqFjHTeCgTCuInxaKDmu/AQjbCXuTEA=; fh=ScvsIRBmUuNca92/w3NqXWBHFHm0MrOi2rMD/ubbXV8=; b=IDY2sN6j18zb6sQg5/aT5ZHUqRCDK9wPN0v6oiVBmGoE4WhBYvf26TmJR52vURB3VO pADmwH3zNa3EMuBv01FL0CXD8h8B7F6xAzbgKCvzh0kcJnJyOWjpq8HS3bdaoOwi6T+L HmvliPofGO6nAJA8UvY9zXc4e93tetD36z6DuDcDBzFseIbZ5Ua3N/A8i/2ycSH49mD+ VjkBO2DxvGV2b8d7M0qyOjGzzq2MvSlYhm5d9NTz8GPcjUZJ/9+Uxkw5twqvolcTdyYd CMe2VMgcMwMPVj7df2moOi15itwSt9MI2CoW0psTavazfjvCt7+y+SmJvcD/qicTAyeI M5Mw==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775012295; x=1775617095; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=+N6BZE0iSMhORqFjHTeCgTCuInxaKDmu/AQjbCXuTEA=; b=EelF4HRg+hahkEEOxQsFoeuGtsuGr6crRj6daF+oVl+h2hdPzhfYLxFJ3haSPS8QS5 csh9r0yyVlKlxJCRx0VRxEqivUn1MLRc62Bq/seGDT5oQtsTUpMtoEQ4jA+2Rt/hO1rh qkgMwZpsXBSSYUqaIYJz5QWxXw7S8eg59eHirC063reRBX6A8kSso1tvMAdDWQlSUGsX UMZnTxhh/f9pUXiPGU/gvqBdU/IXdm6DM051UuVMvbTydmQF/VrAwcI9OaZodXaBI3SU CDl7+xnPs0QTHaMliVAvmzdcmf7R1jigjrSoYQqeVObhI/w68uqnvFspR4W9zTVBmN9y lZLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775012295; x=1775617095; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=+N6BZE0iSMhORqFjHTeCgTCuInxaKDmu/AQjbCXuTEA=; b=jhPmXH+sxp5UhOiQjTD2RQo3S59Bch+C6kUh21nPmRi9MSrqNzolQ6nhnsbHIjeFtb kOndmBAy09dEfBLh95IE2hghxE3M6HNmZsbpgSdn3ljcmqUgUx1/W/q2VvCIDvSpQNdQ jQ/S7yAx7SF98B0zp3TJ56uZa94jiEvG0TRugifamS0l4uZsvkRAJCSzvOOwYq6nVy6E S6Z9QejsDKK+Hl/w3LTSk257QlbqhzDsPDftXuveoBPjBS3BK6dz6yELGiFuZusNsq+P sZcKSIdV/HaKI34B2T6mcf8hjkSpBBz1xH5pbnMflwSgwgvm3A3fGtiW4KdEzMdYzjWz UNUg== X-Gm-Message-State: AOJu0YyKDAcRsrBbFrDxwnFfI9uXt9gRiiZe3EHkC8NNhsWt3pvj4LQW qSFDxuUgIE7KHJET6HvgEPH7kNz6tuPVNVD2Z3c5HaAkBxWIWuOue1NetZ1j8RjYdR2fFzS+saT 9udYHxrEXu3SdXD+UrLet3D7vS2VENlA= X-Gm-Gg: ATEYQzzpnS9DVm7CE7ZJ9K5Bo8Rekn1lSzKwyGPKMFVSXK0vcqmWKkNM1x3U7biPTyn JjiAOJEGN1zGsfOHMk7QJb9vEhsXG9a3/0FiUG4zrsRI937qRW/Xz2NZyXqixKxaHK4DPdBHudD LHQD3uYoVsttn14FOPL3Re8pkb584oMfrPqCDiv8/v0qvBri/gtVPi00waBT8qvOT84Uv3VZEHR QCmYiBTPosITIRqmP5Bmo+WC2fkWypKf4e+RuKwfwNJb6Er4+TbyR/Ud3h11Xx21vKgKC7mwdEr g4XT4Q== X-Received: by 2002:a05:6402:530c:b0:66c:ecdd:9cc0 with SMTP id 4fb4d7f45d1cf-66db09e1548mr986409a12.15.1775012295357; Tue, 31 Mar 2026 19:58:15 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sami Imseih Date: Tue, 31 Mar 2026 21:58:03 -0500 X-Gm-Features: AQROBzB-nsiMCQ4IKLBl4_MAnF-vMd3Yp-P6LObN-rSrNLUBg_BVfrRg4Ghvgsc Message-ID: Subject: Re: Proposal: Track last-used timestamp for index usage To: Raghav Mittal Cc: pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, > I=E2=80=99ve been exploring index usage statistics in PostgreSQL and noti= ced that > pg_stat_user_indexes only provides cumulative counters (idx_scan), but no= t > recency information. pg_stat_user_indexes.last_idx_scan and pg_stat_all_tableslast_seq_scan have= been around since v16. See [1] Is that what you are looking for? [1] [https://www.postgresql.org/docs/devel/monitoring-stats.html#MONITORING= -PG-STAT-ALL-INDEXES-VIEW] -- Sami Imseih Amazon Web Services (AWS)