Postgres Pro
Downloads
Home   >   mailing lists

idx_scan =0, but idx_blks_read > 0 - Mailing list pgsql-admin

From Marc Mamin
Subject idx_scan =0, but idx_blks_read > 0
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D884211D1AD@jenmbs01.ad.intershop.net
Whole thread Raw
List pgsql-admin
Tree view
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
 

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: postgres wal sender replication timeout during pg_basebackup
Next
From: Peter Brunnengräber
Date:
Subject: Re: postgres wal sender replication timeout during pg_basebackup