Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mYIAc-0000rZ-Gn for pgsql-performance@arkaria.postgresql.org; Thu, 07 Oct 2021 01:26:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mYIAb-0002uU-FR for pgsql-performance@arkaria.postgresql.org; Thu, 07 Oct 2021 01:26:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mYIAb-0002uM-3l for pgsql-performance@lists.postgresql.org; Thu, 07 Oct 2021 01:26:01 +0000 Received: from mail-qv1-xf32.google.com ([2607:f8b0:4864:20::f32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mYIAY-0003Ce-Sq for pgsql-performance@lists.postgresql.org; Thu, 07 Oct 2021 01:26:00 +0000 Received: by mail-qv1-xf32.google.com with SMTP id a9so3223086qvf.0 for ; Wed, 06 Oct 2021 18:25:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :references:from:in-reply-to; bh=OYkaW4vQQxOllZM7r8pq0cyab3Oudw5QFucW81DYKsA=; b=AmWjq91JWrmvYq+gVIGC0CTTimPX1T+L0uslH7XSCGpZ5Lai71qusyQKUeR80lpkua u8vY9VqQOF/T3HoUQ2Y8PeadX+TJrNUOP7jKYS7gEzYU3ZqzMd8fIIRhNRxBXLvicyCm XdhD/OfbHe3XC1PjLuZXsan8w1+qhOvyNom0MsGvq73LpJppz5YZyt2ANIjXIqLgHfe4 skwkGbnOpH1dXP4NSolCeB5UqdnweBXKvTUpJEetIhygvQwns53/QAa5quAolOsOR/Mj SFeSeCtxO1zjCFsuFkvdKQ/2h7D4d5opz/5VxgFRy9x768mBHjGptDc3tBodk6Su8J7i njrw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to; bh=OYkaW4vQQxOllZM7r8pq0cyab3Oudw5QFucW81DYKsA=; b=kt2pGMIZgSjcXab/Fcg6nFs64dwwqL8gvFkCoG9NxSaukmCBGsVp4G1cB/kRB8PWQv ku/CdUimZTremcRWQ5uMOQVp9O/SS6lm/hHFyaY0ZJ++Mp9Y7unrt+mM+TPWlLfztiK7 L+0Xstr9IoCz77tdZYkha1qkp3gTrW9cfxbSirlM/+5e/H3HR987XtSr5naLI/0DHplG q4f5YAVrxIKh9OXf171hfwVc/SxLj9U7nx88NwgBkmlhXxvPz4oJ8v3anbRcgCtaOAwJ MV/yjCZtqm8r6XduyIR/QFDLAJ/15KQPO/MXe2STtQs7gfGZ0Od4AcB4fJ/rdC3PIBFq 2u2g== X-Gm-Message-State: AOAM533nvJgxIm3ZafXPoHMS6XkAaNcW+bq9fZ2HsAbmhdZ8c7laEfiX Q3aw6S4yku10ksCHpUPjEhA= X-Google-Smtp-Source: ABdhPJy6HhVUokTxb6gtOLinWYqksRgX0JAhP9jPRCJt6jY7zU5Qpktvs1D0OJzly7aGtJrNyOqLvw== X-Received: by 2002:ad4:5608:: with SMTP id ca8mr1393169qvb.0.1633569956905; Wed, 06 Oct 2021 18:25:56 -0700 (PDT) Received: from [192.168.2.100] (pool-72-79-19-93.nwrknj.east.verizon.net. [72.79.19.93]) by smtp.gmail.com with ESMTPSA id p9sm12547593qkm.23.2021.10.06.18.25.56 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 06 Oct 2021 18:25:56 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------QWXIjEm5OhrFkOAuBnoXKgJI" Message-ID: <5e905f34-0294-0ee1-9701-929ec2fad0c5@gmail.com> Date: Wed, 6 Oct 2021 21:25:55 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.1.0 Subject: Re: [EXT] Re: Troubleshooting a long running delete statement Content-Language: en-US To: "Dirschel, Steve" , "pgsql-performance@lists.postgresql.org" References: <5c336778-df1a-f440-8feb-31c5ffbc9188@gmail.com> From: Mladen Gogala In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------QWXIjEm5OhrFkOAuBnoXKgJI Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 10/6/21 16:26, Dirschel, Steve wrote: > Thanks for the reply and I hope I’m replying to this e-mail correctly > at the bottom of the chain. Hey, it's not me, it's rules and regulations. And that's incredibly important on this group, or so I was lead to believe :) > We are running on AWS aurora postgres.  I assume strace -e isn’t an > option given we don’t have access to the server or are you aware of a > method I could still do that without server access? > Regards > Steve No, access to the OS is not an option with RDS. However, RDS comes with support. You will have to contact support. They may use strace for you. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com --------------QWXIjEm5OhrFkOAuBnoXKgJI Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 10/6/21 16:26, Dirschel, Steve wrote:
 
Thanks for the reply and I hope I’m replying to this e-mail correctly at the bottom of the chain. 


Hey, it's not me, it's rules and regulations. And that's incredibly important on this group, or so I was lead to believe :)

We are running on AWS aurora postgres.  I assume strace -e isn’t an option given we don’t have access to the server or are you aware of a method I could still do that without server access?
 
Regards
Steve
No, access to the OS is not an option with RDS. However, RDS comes with support. You will have to contact support. They may use strace for you.
-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
--------------QWXIjEm5OhrFkOAuBnoXKgJI--