Uwe Bartels <uwe.bartels@xxxxxxxxx> writes: > i know what a context switch is or a page fault/reclaim, etc. > what i need to know is the context of the numbers: > - numbers without brackets > - number with brackets It looks like the numbers in brackets are the latest raw numbers from getrusage(), whereas the numbers before the brackets are the delta from a getrusage() call made at the start of execution. > - context for those numbers: are all of these numbers one-to-one related to > my function call? Or did those numbers (signals/page reclaims) come up > during the time of execution of that function? It's just the overall getrusage result for the backend process. > what I don't know and never found so far is "Local blocks" and "Direct > blocks". So I'd be interested to know what's this, jst for completeness. Local blocks are (or were ... that code is gone as of 9.0) I/O for temporary tables of the current backend. I think direct blocks was a count of I/Os on temp files (sort data and so on). regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin