> The cost is "13.88" to fetch 1 row by scanning an Primary KeyI don't know, how many index pages will need to be randomly accessed
> indexed column.
>
> Isn't the cost for fetching 1 row is too high ?
in addition to the random heap access? How many dead versions of
the row will need to be visited besides the row which is actually
visible? How many of these pages are in shared_buffers? How many
of these pages are in OS cache?
Total Index pages are 140310. Yes. I suspect most of the times the required page is found in either OS cache or disk (shared_buffers is .9 GB) as we have 200+ GB of highly active database and the Index is on a 10GB table.
