Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 4CAEE133740B; Thu, 12 May 2011 12:39:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 44890-06; Thu, 12 May 2011 15:39:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id 444DE1337C04; Thu, 12 May 2011 12:39:51 -0300 (ADT) Received: by vws1 with SMTP id 1so1195038vws.19 for ; Thu, 12 May 2011 08:39:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=vEqf+4vSJtoVty5X+A4SkJs/eSyXWTwB4Tcf0zbDv9A=; b=shoicCay2asO5q1vygH87Uzn63J8f03g/Y48jLDo+ABiyHxPBAUGSrrfZkqp9AC6VO 487Z4QiRKeYMX/ACHjsiECzFci8ARtlcEgTDPQtkUhWbGXP/0m/PaapnONCrL/3yGzGX NkhDsU64QSsGjzG33ho9GBhkvBL5EgpovnLOE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=J5WWfM++p8Vn1tjiQKyw5lFZKO/53rx7QhrpXSm1Im5azpKS1ah6/Y5iZ44ePM1MVw xu7AA72gRkSHexG3GbKhXsnn6GcQ3c4uqgSvG37CgY50gUpdFrUOSb3uZ+l/ZUSlYoa0 +SSAbnvh+4i/jm3APFH1G+y/xwtpvBhFopzuA= MIME-Version: 1.0 Received: by 10.52.18.14 with SMTP id s14mr502015vdd.164.1305214790238; Thu, 12 May 2011 08:39:50 -0700 (PDT) Received: by 10.52.106.230 with HTTP; Thu, 12 May 2011 08:39:50 -0700 (PDT) Date: Thu, 12 May 2011 17:39:50 +0200 Message-ID: Subject: [PERFORM] since when has pg_stat_user_indexes.idx_scan been counting? From: Willy-Bas Loos To: pgsql-performance@postgresql.org, pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=20cf3054a12fed84b204a315ff77 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.887 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/90 X-Sequence-Number: 37527 --20cf3054a12fed84b204a315ff77 Content-Type: text/plain; charset=ISO-8859-1 Hi, We have some indexes that don't seem to be used at all. I'd like to know since when they have not been used. That is, the time when postgres started counting to reach the number that is in pg_stat_user_indexes.idx_scan Is there a way to retrieve that from the database ? Cheers, WBL -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw --20cf3054a12fed84b204a315ff77 Content-Type: text/html; charset=ISO-8859-1 Hi,

We have some indexes that don't seem to be used at all.
I'd like to know since when they have not been used.
That is, the time when postgres started counting to reach the number that is in pg_stat_user_indexes.idx_scan

Is there a way to retrieve that from the database ?

Cheers,

WBL

--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
--20cf3054a12fed84b204a315ff77--