Re: [PERFORM] stats on cursor and query execution troubleshooting

2004-10-08 Thread "Alban Médici (NetCentrex)"
Thanks for your repply,  but I still don"t understand why the statistic logs   : !   0/0 [0/0] filesystem blocks in/out it told me there is no hard disk access, I'm sure there is,  I heard my HDD,  and see activity using gkrellm (even using my first query ; big select *) ? 2004-10-08 10

Re: [PERFORM] stats on cursor and query execution troubleshooting

2004-10-06 Thread Tom Lane
=?ISO-8859-1?Q?=22Alban_M=E9dici_=28NetCentrex=29=22?= <[EMAIL PROTECTED]> writes: > I'm looking for the statistic of memory, CPU, filesystem access while=20 > executing some regular SQL query, and I want to compare them to > same kind of results while executing a cursor function. I think your