X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D7F5E5E46D2 for ; Thu, 26 Aug 2004 11:51:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81354-10 for ; Thu, 26 Aug 2004 14:51:17 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 878C45E46DC for ; Thu, 26 Aug 2004 11:51:14 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7QEpL8Q017569; Thu, 26 Aug 2004 10:51:21 -0400 (EDT) To: Steve Lane Cc: pgsql-admin@postgresql.org, Jamie Thomas Subject: Re: Odd double queries continues In-reply-to: References: Comments: In-reply-to Steve Lane message dated "Thu, 26 Aug 2004 07:17:02 -0500" Date: Thu, 26 Aug 2004 10:51:21 -0400 Message-ID: <17568.1093531881@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/262 X-Sequence-Number: 14657 Steve Lane writes: > I realize no one may have any insight in the whole problem, but can anyone > at least tell me the significance of each of these numbers from the stats: > 261/10 [691/281] page faults/reclaims, 0 [0] swaps It's just repeating what getrusage() told it. See the docs for your operating system. It looks like the numbers inside the square brackets are totals since process start, while the ones before are the delta since query start. regards, tom lane