Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSQtd-00052C-Ne for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Nov 2019 19:23:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iSQtc-00019x-E9 for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Nov 2019 19:23:12 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSQtc-00019q-1S for pgsql-hackers@lists.postgresql.org; Wed, 06 Nov 2019 19:23:12 +0000 Received: from mail-wr1-x42e.google.com ([2a00:1450:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSQtX-0007zu-Qt for pgsql-hackers@lists.postgresql.org; Wed, 06 Nov 2019 19:23:11 +0000 Received: by mail-wr1-x42e.google.com with SMTP id r10so641424wrx.3 for ; Wed, 06 Nov 2019 11:23:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=j6oPQRprH3yUpu1W6ZAK74QEnR4Jhhuq9OJDkztMjXY=; b=o0vRKBR+ByHTIerbIHbLbuflUU6qE5BASn1YTSLfZ8p0vBvtlMkwQdQVs+N1uQ3O/5 J9YhHFsFpE+qM7QHWorKMYQwJSAIRjNi/TF/MEkTmFVB6twyfCsHDhc5+5GmUOwdhryq a0ZkqZy+5DDK/AhwVSEeEiGV2aDdxX8LccAD2ZdMNP5eXJrzpQ1mbSpKggGLB93crK0Q JfN3C1okBRvZvRfL4hd40xG9BSmkhq4QD/JWSP080ot2XVj728R2N9KfCHgWPOqD+HKd aUamnfTf5giD2Jwl42jaEHPfQm+w37A2scSMEKK2iJEaQPM7iW5Qcm9Gb9bzUqN6I9KM uiWA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=j6oPQRprH3yUpu1W6ZAK74QEnR4Jhhuq9OJDkztMjXY=; b=XaJM+P1HeWZkq3wSjyPQSy/Vv5U5uZdcJ7DpV2K2WEYgdY5jTlN3Iig/snmzSPfW13 twep/J33z1zUkI+u+ST9torjRRt+3C7go8N4/MTyns6L2H37djtXhf5/SuRul8xyuPOj bhmcijVIchSNTywsFN3tkAM2c0t1AH7+ck/WamLPfk/irwXoFWxK0nDtBPWPijBaNMMD htHDeC6+SbkikiCkQ2V0gmzkzt9jYR86R8XfMnTy/J+B3VFYXMWBIn/MEEam36FDfCHb F6pgT5QbQYvuF8v3Md1HjnNzE2iFVeKQdz438a4FrBMaNA+V3mY13g5NX6h3WuRtzQNT MzKA== X-Gm-Message-State: APjAAAWeOAVA8tnrFF9bdTClY36T3bKxb0qysKq+/tN5a1lzBLdEiAsU yyr6SkH0s6tg+FltZWVIfVgdCA== X-Google-Smtp-Source: APXvYqzSLgIgCF1ek4TrxcL8epA6A4p9rqV8XJTx5LbcqVXe5zC9L7dYTT40vmiYSb4cdMq0/x+n/Q== X-Received: by 2002:adf:9f43:: with SMTP id f3mr4243529wrg.76.1573068186267; Wed, 06 Nov 2019 11:23:06 -0800 (PST) Received: from localhost (ip-86-49-253-183.net.upcbroadband.cz. [86.49.253.183]) by smtp.gmail.com with ESMTPSA id j3sm17436467wrs.70.2019.11.06.11.22.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 06 Nov 2019 11:22:56 -0800 (PST) Date: Wed, 6 Nov 2019 20:22:55 +0100 From: Tomas Vondra To: Adrien Nayrat Cc: Tom Lane , pgsql-hackers@lists.postgresql.org Subject: Re: idea: log_statement_sample_rate - bottom limit for sampling Message-ID: <20191106192255.cbckgh6x5xday3sr@development> References: <20190801100445.yo5v3pdxelijztzm@development> <3f6b75ea-03bb-7c35-1f20-e989f4b7f9ac@anayrat.info> <20190804191037.em6rmlvxjpcsjtqu@development> <25079.1564946172@sss.pgh.pa.us> <20190804195823.qi7vntgybfgitdnn@development> <27954.1564950312@sss.pgh.pa.us> <20190804204848.7f7ypsbijpgxojxx@development> <20190804214154.tbr5pbg5wss2adfu@development> <20191106182106.dwdvxalewyydqbx3@development> <3d67278c-3e8f-6ef4-4950-eb5e7a4411de@anayrat.info> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: <3d67278c-3e8f-6ef4-4950-eb5e7a4411de@anayrat.info> User-Agent: NeoMutt/20180716 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Nov 06, 2019 at 08:00:57PM +0100, Adrien Nayrat wrote: >On 11/6/19 7:21 PM, Tomas Vondra wrote: >> I've pushed the reworked version of log_statement_sample_rate patch [1]. >> If I understand correctly, that makes this patch unnecessary, and we >> should mark it as rejected. Or do we still need it? > >Yes, the goal of this patch was to disable sampling and log all queries whose >duration exceed log_statement_sample_limit. > >For now it is possible just with log_min_duration_statement which log all >queries whose duration exceed it. > OK, I've marked it as rejected. If someone thinks we should still have something like it, please submit a patch implementing it. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services