Postgres Pro
Downloads
Home   >   mailing lists

Regarding Sequential Scans count increase each time we press refresh . - Mailing list pgsql-performance

From keshav upadhyaya
Subject Regarding Sequential Scans count increase each time we press refresh .
Date
Msg-id d40c44910909241032k28fde9eet83d872d9a93f981a@mail.gmail.com
Whole thread Raw
Responses Re: Regarding Sequential Scans count increase each time we press refresh .
List pgsql-performance
Tree view
Hi ,

I have one table  my_test table . with on index created on one column .


I have turned off the sequential scans .

Now when ever i do refresh on this table or press F5 , It increase the sequential scans count and
Sequential tuple read count .

Pls help me to understand what exactly is happening ?  Is it scanning the Table sequentially once i press refresh  ?

Thanks,
keshav

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Next
From: Karl Denninger
Date:
Subject: Re: High CPU load on Postgres Server during Peak times!!!!