Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dYWB7-00066q-Lv for pgsql-sql@arkaria.postgresql.org; Fri, 21 Jul 2017 11:33:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dYWB7-0000Tm-7D for pgsql-sql@arkaria.postgresql.org; Fri, 21 Jul 2017 11:33:05 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dYWB5-0000RS-Ce for pgsql-sql@postgresql.org; Fri, 21 Jul 2017 11:33:03 +0000 Received: from mail-wm0-x229.google.com ([2a00:1450:400c:c09::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dYWB2-0006o0-Jq for pgsql-sql@postgresql.org; Fri, 21 Jul 2017 11:33:01 +0000 Received: by mail-wm0-x229.google.com with SMTP id e131so11526735wme.0 for ; Fri, 21 Jul 2017 04:33:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=Zxy+2cTB6BwetfBzQR8OJWLW5eTKVx5qL8/7zEOfmn0=; b=oGwJK3X0r6ra1qa/guqJSqNdiIfxGW6lNXOh7cDo7oLmtz6ZYasAZC3/dPIWJOFZjJ cWkvDWFIsvr3CsNkT1svF0maInQnAS30xcUBK8c/B4+/oJ4dLbcHnnUzxwA/sGzFiqcB xzcZVSxa8g3J2AijBFxdMusq87hCeI5d28teUduWr0IiohD0cmCjOPKRj0S7TZXd7M/s V634Q/NzYPLXY1EiYYVi9VLpYtoQwo9TBP4pNGnUHDmsvHZI6gc/aIdjO2PlRw+EOKD5 fg+WcyEmUSXUZZRbq5WWGwWVzkir3F9Z3PV8z2/OlXO821ZUvPot0/b6HYhuCOCos6Z1 jZtQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=Zxy+2cTB6BwetfBzQR8OJWLW5eTKVx5qL8/7zEOfmn0=; b=DEJYQ61FWYQ4zx2aounPJeSeqmd0JN8anaqmlA5docFeH8/a1EHpgY9T+J1SMSd1AR qwBTkbjqxfm5OdSNKk6sTZZEaNrjhjI38ntn8by7KsKj7u9C+sOHTOAqwWbBgJrQidHU VK78kdTN25q/CV315ONa162zOCbzL6XDHBc723C8bt6u3ZIMXdmgS2idw5OfFiGl01+S eU8oqJADdU3q5TJAEa3v2QINtX87p/lZkPgLCKONAGnosyUykl7iOlowkmiKTxu271tt SfcmKrBaiiMKNTRztDr7aU9jKy11nb20IKRkURmdwV0N8HMPb4rgqBHmF6J+j1+Oh2vt 96EA== X-Gm-Message-State: AIVw113/Z8mbxWiZbBLlZPBbiy98mIQzBSdDQtElaJKq7DqLxISWr5Kj Y4tDvbvKppG8+xdy X-Received: by 10.28.5.19 with SMTP id 19mr4553447wmf.20.1500636779025; Fri, 21 Jul 2017 04:32:59 -0700 (PDT) Received: from timbomac.domain_not_set.invalid ([88.202.149.90]) by smtp.googlemail.com with ESMTPSA id q2sm1076474wmg.3.2017.07.21.04.32.58 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 21 Jul 2017 04:32:58 -0700 (PDT) To: pgsql-sql@postgresql.org From: Tim Dudgeon Subject: commit not completing - how to investigate? Message-ID: <5e59f5e0-7168-fb80-d038-7fe9adad4aa9@gmail.com> Date: Fri, 21 Jul 2017 12:32:57 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:52.0) Gecko/20100101 Thunderbird/52.2.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-GB List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org I have a situation where the pg_stat_activity view shows that can have some processes that are idle and not completing. In some cases the statement being executed is COMMIT. How can I investigate WHY these processes are not completing. Presumably they are waiting on something, but I'm not sure how to work out what this is. Thanks Tim -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql