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 1gXo1q-0006CS-Ch for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Dec 2018 14:01:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gXo1m-0004Wd-OA for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Dec 2018 14:01:18 +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 1gXo1m-0004WW-Ak for pgsql-hackers@lists.postgresql.org; Fri, 14 Dec 2018 14:01:18 +0000 Received: from mail-wr1-x432.google.com ([2a00:1450:4864:20::432]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gXo1j-0002VD-8S for pgsql-hackers@postgresql.org; Fri, 14 Dec 2018 14:01:17 +0000 Received: by mail-wr1-x432.google.com with SMTP id s12so5103172wrt.4 for ; Fri, 14 Dec 2018 06:01:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=NAfBgQUjVRdgizFn4L2/1zXUNPFgI7vtgMp3CRT/EQI=; b=P5hbkgnk3+4rL1YomnK0z7nEDyLi7HunxtiTTSoQ9cjLBiGD8wFUakdvIn3/PHCGGe YqhbaYlqXhMbsN4IHJ36fqC/4Te68+tiFQesrq4OdBQxMv691jm4gy0Cyl00i+kZq5VR bOT6E2/a/a5x13GQWJaAV+IdZqI8gCcPgGipZgLNp9gHLW0ENpTXMjFK9vlg6yXQgtoo FTy0Rgo8G/nZ8OrVewvCr2M5ij8SLOCO0OB4P7T338vZsxmE0Fu0AaHV5ryzvj+aT3Rd P7LA+sm3TL4R08aTyBia5Tebs5F7S/T1kCGxI3lEpsSQk+oJqxJngNQC4PoGbxCjW27K wSIg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=NAfBgQUjVRdgizFn4L2/1zXUNPFgI7vtgMp3CRT/EQI=; b=CDcDfxArq4B7nBpfF/fOpi+cEJmW6FBnDgRI9kU+6AhGOekXhQgkbMHNNJsdj1RsyP PXcREW6j9vAFmBjralQHpM9rsqJSL7VF0/JN84byDYC4jGpG4k564PStyNBPpmUeSLwg QugGVn1gdu0FPKr4p6ODyazM4VABUSkANIuV0pW+oucXgRmttJfelgdOqYQNQi6qN8ly TNw3wE6/P3hzQdFSConf4CAqfev2ibmppKxvQVMh364+LxWuGeVCHTK+Rzx29GcQJN8f BjtQF96H0IzgH/2pGujEaagaanSHCIS5aTk1LqEuaxkK+qIdJpeyPaiZpNnoMU6kESZt DCqg== X-Gm-Message-State: AA+aEWYvxag5dKbErrtLPLSEwjCW1lMNFcfBeaK4t+6+0teMwqg/Hcx/ Bqrz8HPSf6i3jLAK1YrFX34XyBhrTXbgOAz6flKtUDiRLw4HEFh+k/C01adwsRqzZdZqom+cNwf slF0mcXTvzxBmoiS19B6+HSQzEiZU6YNVdSe2AQBeyRiWZxfPMb1xMOhbr64G661BXN93dJ/R2c M4jBo/P8GBk8v1s6wW X-Google-Smtp-Source: AFSGD/X7uca4ZnvTBTuQEqeh0nL8AOvkGvO8JltTjBC36QoqohEM8Pfn2/hb6bGsg6nrK53kldfhtQ== X-Received: by 2002:adf:b592:: with SMTP id c18mr2678348wre.89.1544796072529; Fri, 14 Dec 2018 06:01:12 -0800 (PST) Received: from [10.137.2.21] (static-84-42-175-93.net.upcbroadband.cz. [84.42.175.93]) by smtp.gmail.com with ESMTPSA id g16sm5921017wru.41.2018.12.14.06.01.11 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 14 Dec 2018 06:01:11 -0800 (PST) Subject: Re: explain plans with information about (modified) gucs To: Jim Finnerty , pgsql-hackers@postgresql.org References: <1544792718021-0.post@n3.nabble.com> From: Tomas Vondra Message-ID: <847526e0-2e15-29da-9488-ab387b9762c8@2ndquadrant.com> Date: Fri, 14 Dec 2018 15:01:09 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.1 MIME-Version: 1.0 In-Reply-To: <1544792718021-0.post@n3.nabble.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/14/18 2:05 PM, Jim Finnerty wrote: > You might want to only include the GUCs that are query tuning parameters, > i.e., those returned by: > > SELECT name, setting, category > FROM pg_settings > WHERE category LIKE 'Query Tuning%' > ORDER BY category, name; > Good idea! Thanks. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services