Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bfO1O-0003Ha-U0 for pgsql-performance@arkaria.postgresql.org; Thu, 01 Sep 2016 09:10:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bfO1O-0004dd-GM for pgsql-performance@arkaria.postgresql.org; Thu, 01 Sep 2016 09:10:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bfNzg-0000tS-P9 for pgsql-performance@postgresql.org; Thu, 01 Sep 2016 09:09:09 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([2404:130:4080::4]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bfNzc-00031Z-S6 for pgsql-performance@postgresql.org; Thu, 01 Sep 2016 09:09:08 +0000 Received: from localhost (localhost [127.0.0.1]) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTP id A422980478 for ; Thu, 1 Sep 2016 21:08:55 +1200 (NZST) X-Virus-Scanned: Debian amavisd-new at cat-porwal-prod-mail1.servers.catalyst.net.nz Received: from cat-porwal-prod-mail1.catalyst.net.nz ([127.0.0.1]) by localhost (cat-porwal-prod-mail1.servers.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id hr6BSannZMKg for ; Thu, 1 Sep 2016 21:08:55 +1200 (NZST) Received: from [192.168.1.64] (222-153-9-108.jetstream.xtra.co.nz [222.153.9.108]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 18AC88058C for ; Thu, 1 Sep 2016 21:08:55 +1200 (NZST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=catalyst.net.nz; s=catalyst; t=1472720935; bh=QPmVdY3pEirlQ0942OxE44IN2dPVDVZ82dJLfz9B/Bc=; h=Subject:To:References:From:Date:In-Reply-To; b=cnIdV8xTfIhxrEMtQcSTZcxx3PbUDacrk37AcV2KlU+QTkjUlhC/vpcVxYkGT7SZg sGoxS/idq0j+2gxZivCKHaz+aSE06fS1GuV/SnsiPwZ5PfYqt0wT99UUVrCPsqD/df trYVeUG9+clLVcTWZw38pzW8lOgCWQ4CpvYVach0= Subject: Re: Possible to find disk IOs for a Query? To: pgsql-performance@postgresql.org References: From: Mark Kirkwood Message-ID: <6f2e5bde-7951-35ee-3bc0-e1821ed68344@catalyst.net.nz> Date: Thu, 1 Sep 2016 21:08:54 +1200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -3.5 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 01/09/16 17:56, Mark Kirkwood wrote: > the other way to attack this is to trace your backend postgres > process (err perfmon...no idea how to do this on windows...) No idea why I thought you were on windows (maybe was reading another message just before yours) - sorry! -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance