Re: [GENERAL] Index Only Scan and Heap Fetches

2017-07-27 Thread Jeff Janes
On Tue, Jul 18, 2017 at 7:21 AM, Mikhail wrote: > Hi guys, > > I'm running the process, that executes "select * from sr where sr.id=210 > for update;", then some calculations and finally "update sr set usage = > where sr.id = 210;". That operation is done in a loop. > > In parallel session i'm r

[GENERAL] Index Only Scan and Heap Fetches

2017-07-18 Thread Mikhail
Hi guys, I'm running the process, that executes "select * from sr where sr.id=210 for update;", then some calculations and finally "update sr set usage = where sr.id = 210;". That operation is done in a loop. In parallel session i'm running the query: test=# explain (analyze, buffers) select i