SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 02:32 PM
| ||||
| ||||
 Tracking disk writes? (again) Hi, is there any way that I can track the number of actual disk writes done by a particular database or database cluster? I already sent this question last Friday and, while even I usually frown upon reposts to lists and forums, I really need some kind of answer, even if it's "you can't" in which case a why would also be cool. erik jones <erik@myemma.com> sofware developer 615-296-0838 emma(r)      |
|
04-09-2008, 02:32 PM
| |||
| |||
| Re: Tracking disk writes? (again) Erik, on windows you can use performance monitor to filter down diskrequest. With sysinternals tools you can also go down to disk accesses on process basis. google for sysinternals site:microsoft.com on other platforms I have no information. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
|
04-09-2008, 02:32 PM
| |||
| |||
| Re: Tracking disk writes? (again) On Mar 12, 2007, at 11:22 AM, Harald Armin Massa wrote: > Erik, > > on windows you can use performance monitor to filter down diskrequest. > With sysinternals tools you can also go down to disk accesses on > process basis. > > google for sysinternals site:microsoft.com > > on other platforms I have no information. Ah, good point, I should have specified some system details (although I was hoping I could get at this through postgres as I can when tracking disk reads). We have db servers running on both Ubuntu Linux and Solaris 10. erik jones <erik@myemma.com> sofware developer 615-296-0838 emma(r) |
|
04-09-2008, 02:32 PM
| |||
| |||
| Re: Tracking disk writes? (again) Erik, for solaris I think dtrace can be of help: http://www.opensolaris.org/os/community/dtrace/ PostgreSQL 8.2 introduced dtrace-ability. From what I read it is specifically created to do this kind of measurement. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
|
04-09-2008, 02:32 PM
| |||
| |||
| Re: Tracking disk writes? (again) On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote: > Erik, > > for solaris I think dtrace can be of help: > > http://www.opensolaris.org/os/community/dtrace/ > > PostgreSQL 8.2 introduced dtrace-ability. > > From what I read it is specifically created to do this kind of > measurement. Hmm... That would be a particulary heavy weight solution to what I was hoping for. Basically, I'm looking to poll the db or "something" to get either the total number of block or page writes done by the db either ever or since my last reading. That way I can graph disk writes over time and compare to the graphs I've already got for transactions committed, transactios rolled back, disk blocks read from disk, and disk blocks found in cache. erik jones <erik@myemma.com> sofware developer 615-296-0838 emma(r) |
|
04-09-2008, 02:32 PM
| |||
| |||
| Re: Tracking disk writes? (again) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 03/12/07 12:16, Erik Jones wrote: > > On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote: > >> Erik, >> >> for solaris I think dtrace can be of help: >> >> http://www.opensolaris.org/os/community/dtrace/ >> >> PostgreSQL 8.2 introduced dtrace-ability. >> >> From what I read it is specifically created to do this kind of >> measurement. > > Hmm... That would be a particulary heavy weight solution to what I was > hoping for. Basically, I'm looking to poll the db or "something" to get > either the total number of block or page writes done by the db either > ever or since my last reading. That way I can graph disk writes over > time and compare to the graphs I've already got for transactions > committed, transactios rolled back, disk blocks read from disk, and disk > blocks found in cache. Like a system montitor that tracks reads, writes, transactions, etc? > > erik jones <erik@myemma.com> > sofware developer > 615-296-0838 > emma(r) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFF9ZiyS9HxQb37XmcRAiNKAKCxG7RJUEQTpyU6N6bqll lOcvUJ6wCfZh+8 7s3LprWsR2IEB3n+FwyLy58= =cPIV -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
|
04-09-2008, 02:32 PM
| |||
| |||
| Re: Tracking disk writes? (again) On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote: > Hi, is there any way that I can track the number of actual disk > writes done by a particular database or database cluster? I already > sent this question last Friday and, while even I usually frown upon > reposts to lists and forums, I really need some kind of answer, even > if it's "you can't" in which case a why would also be cool. I'm not sure it's what you mean, but the pg_stats* tables include stuff like blocks read from tables and indexes and the like... You do need to enable it in the config though. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFF9ZxqIB7bNG8LQkwRAoeSAJ0RswmpDSCsXLd96klK2Z wAlaUKhACgiHVp vGJq+4poHURk4HYL+c7xrnc= =/7G8 -----END PGP SIGNATURE----- |
|
04-09-2008, 02:33 PM
| |||
| |||
| Re: Tracking disk writes? (again) Martijn van Oosterhout wrote: > On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote: > > Hi, is there any way that I can track the number of actual disk > > writes done by a particular database or database cluster? I already > > sent this question last Friday and, while even I usually frown upon > > reposts to lists and forums, I really need some kind of answer, even > > if it's "you can't" in which case a why would also be cool. > > I'm not sure it's what you mean, but the pg_stats* tables include stuff > like blocks read from tables and indexes and the like... You do need to > enable it in the config though. But it does not include disk writes, only reads. I think it would make sense to add blocks dirtied and blocks written to the block-level stats. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ |
|
04-09-2008, 02:33 PM
| |||
| |||
| Re: Tracking disk writes? (again) On Mar 12, 2007, at 1:31 PM, Martijn van Oosterhout wrote: > On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote: >> Hi, is there any way that I can track the number of actual disk >> writes done by a particular database or database cluster? I already >> sent this question last Friday and, while even I usually frown upon >> reposts to lists and forums, I really need some kind of answer, even >> if it's "you can't" in which case a why would also be cool. > > I'm not sure it's what you mean, but the pg_stats* tables include > stuff > like blocks read from tables and indexes and the like... You do > need to > enable it in the config though. That is exactly what I mean except that there doesn't seem to be anything in there for tracking writes done by the database. There's the number of reads from disk and reads from the cache, but nothing that I can see wrt writes to disk. erik jones <erik@myemma.com> sofware developer 615-296-0838 emma(r) |
|
04-09-2008, 02:33 PM
| ||||
| ||||
| Re: Tracking disk writes? (again) On Mar 12, 2007, at 1:15 PM, Ron Johnson wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 03/12/07 12:16, Erik Jones wrote: >> >> On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote: >> >>> Erik, >>> >>> for solaris I think dtrace can be of help: >>> >>> http://www.opensolaris.org/os/community/dtrace/ >>> >>> PostgreSQL 8.2 introduced dtrace-ability. >>> >>> From what I read it is specifically created to do this kind of >>> measurement. >> >> Hmm... That would be a particulary heavy weight solution to what I >> was >> hoping for. Basically, I'm looking to poll the db or "something" >> to get >> either the total number of block or page writes done by the db either >> ever or since my last reading. That way I can graph disk writes over >> time and compare to the graphs I've already got for transactions >> committed, transactios rolled back, disk blocks read from disk, >> and disk >> blocks found in cache. > > Like a system montitor that tracks reads, writes, transactions, etc? Well, disk reads, cache hits, transactions commited, transactions rolled back, index size and usage, etc. are all able to be tracked vi the pg catalogue tables and views. But, I haven't seen anything that will give me numbers on actual disk writes done by the database. erik jones <erik@myemma.com> sofware developer 615-296-0838 emma(r) |
Linear Mode
