Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id A11331337B8B for ; Mon, 22 Nov 2010 13:00:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 48327-02 for ; Mon, 22 Nov 2010 17:00:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id DB2991337B8A for ; Mon, 22 Nov 2010 13:00:14 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id oAMH084U028723; Mon, 22 Nov 2010 12:00:08 -0500 (EST) To: Uwe Bartels cc: pgsql-admin@postgresql.org Subject: Re: docs log_executor_stats In-reply-to: References: Comments: In-reply-to Uwe Bartels message dated "Mon, 22 Nov 2010 17:48:10 +0100" Date: Mon, 22 Nov 2010 12:00:08 -0500 Message-ID: <28722.1290445208@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/190 X-Sequence-Number: 36156 Uwe Bartels 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