idx_scan =0, but idx_blks_read > 0

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: idx_scan =0, but idx_blks_read > 0
Date: 2016-04-11 08:56:22
Message-ID: B6F6FD62F2624C4C9916AC0175D56D884211D1AD@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

(9.4)

I'm not quite sure how to interpret these figures.
Does it means that index blocks get read for maintenance purpose, e.g. after a row update, but the index itself is never used?

Thanks,

Marc Mamin

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Brunnengräber 2016-04-11 21:18:03 Re: postgres wal sender replication timeout during pg_basebackup
Previous Message Albe Laurenz 2016-04-08 09:03:29 Re: postgres wal sender replication timeout during pg_basebackup