Timeline for How to verify disk hit by a query
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 8, 2016 at 9:12 | comment | added | Gowtham Kumar | Thanks a lot for your explanation . Although am aware of explain (analyze , verbose , buffers) , your explanation adds more details . Only reasons why 'am going for logs is we can't predict and run explain plan of each and every query so , enabled the parameter in the postgres.conf file to log the details. Once again thanks for your time. | |
| Feb 6, 2016 at 18:53 | comment | added | András Váczi | How do you distinguish between the blocks read from disk or from the OS cache? | |
| Feb 6, 2016 at 11:18 | history | answered | hruske | CC BY-SA 3.0 |