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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1noGzh-0001Qe-UM
	for pgsql-general@arkaria.postgresql.org; Tue, 10 May 2022 03:57:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1noGzg-0000O9-ET
	for pgsql-general@arkaria.postgresql.org; Tue, 10 May 2022 03:57:04 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bharath.rupireddyforpostgres@gmail.com>)
	id 1noGzg-0000Nz-2V
	for pgsql-general@lists.postgresql.org; Tue, 10 May 2022 03:57:04 +0000
Received: from mail-pl1-x62f.google.com ([2607:f8b0:4864:20::62f])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <bharath.rupireddyforpostgres@gmail.com>)
	id 1noGzd-0003Qo-HC
	for pgsql-general@lists.postgresql.org; Tue, 10 May 2022 03:57:03 +0000
Received: by mail-pl1-x62f.google.com with SMTP id c9so14969971plh.2
        for <pgsql-general@lists.postgresql.org>;
 Mon, 09 May 2022 20:57:01 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=ERFgqgTPuHhdGZ5EQT7OtlLvjmK/BpD6TLgURP8+ch4=;
        b=oSZOmkgzpw2VOHuYU7JFJxhRUts/uPPrUQBsL145ajtNR7X5hfy8AXkpaOj+i2fmfd
         Yv99ZdxBlZ5iA7wdubatz9Ea+hX+j2kIuWqsNH1T/By7Vh5KSE2eUNqym+PX57Wv8Hjo
         UuKw84fCE+ZKrfNvPZxE9ad5va8WtdP3c6Qv/0wk2IF78xqosdGIPo56V9TscCR8Tw9W
         ZvWEs/FD2Um2SyDhOGsvNo9d8U5RFjzmdt2lFrZQ8Q4Bx4PSGeep4VdrOs39Cox62CjG
         uqAwlwZm+eDiAS3yLjdde7c3GSylY4ASZFxf4s5FM9I+1tNXqVWoBah+m1aS2tQIatkg
         L3vw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=ERFgqgTPuHhdGZ5EQT7OtlLvjmK/BpD6TLgURP8+ch4=;
        b=WzQfy19jxAZVjFj8IjcGC86qFg+t1b0F95SXugK9Eu/f8l5CxE31PQexa+p7DRDDPK
         GEVtzhAYuj+eipzVHPRkq4kZxNQaOS3139bF5opleZlTOls6tgvyMn0fetlFZztxdbJy
         dGz4+eF7I/tbQzusMQT5jHKc1/lidlQhV0sJGYPmGrTtsFopJeHR6oxZ6tBM+kIGj+fC
         O2+S25rrUwHkuPQjwjonLNpPhGoUDJhvnDoPXhAyeMFT1gdUk56M9bIiaXLOkUZOdGtj
         R5LXN9C0mNKs3g2czPfrS9+ePrI3bzWoN88OX91S4FdY8pGPPu1KQowYob+7tOfJLYUx
         JCWQ==
X-Gm-Message-State: AOAM53342GfC8HhVm1y7GWnFTrmtZOrvlb7foT8JjrFMsyBHK/nlGZsu
	hCtjY40MXu7w9UY+REomLo4HWPtMFazRIAY9alQ=
X-Google-Smtp-Source: 
 ABdhPJx4u9c4e7TTltHe2kdmy9ugnqG8GXHpBRJfWO9lyefah6patr3XzRrsmjyozWIp+RrMpFD935BvwpvRsTI+xjo=
X-Received: by 2002:a17:90a:9b0d:b0:1dc:e81d:6c18 with SMTP id
 f13-20020a17090a9b0d00b001dce81d6c18mr17517363pjp.72.1652155019204; Mon, 09
 May 2022 20:56:59 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CA+i5JwYsXzYwBT87y2jtch=Lg1s=d+XgJ0sJS0TV8VQT8g_Xtg@mail.gmail.com>
 <CA+i5Jwbc2B=CT1JxVc7Tke5JFRpBfhyzLA__tdr6t1GckVCwQg@mail.gmail.com>
In-Reply-To: 
 <CA+i5Jwbc2B=CT1JxVc7Tke5JFRpBfhyzLA__tdr6t1GckVCwQg@mail.gmail.com>
From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Date: Tue, 10 May 2022 09:26:47 +0530
Message-ID: 
 <CALj2ACXH+=1T3QKtwhc9S2_CDR+ndVUE8fph8Xo1puRp+vf-vg@mail.gmail.com>
Subject: Re: Set timeout just on a query?
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: 
 <https://www.postgresql.org/message-id/CALj2ACXH%2B%3D1T3QKtwhc9S2_CDR%2BndVUE8fph8Xo1puRp%2Bvf-vg%40mail.gmail.com>
Precedence: bulk

On Tue, May 10, 2022 at 6:29 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
>
>
> Can timeout be set just on a query?
>
> Can we do the following?
>
> Begin
>
> do a query
> set timeout
> Exception
> report a record
>
> End;

Won't the statement_timeout [1] help here?

[1] https://www.postgresql.org/docs/devel/runtime-config-client.html

Regards,
Bharath Rupireddy.