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 1kUsxu-00028g-Qz for pgsql-performance@arkaria.postgresql.org; Tue, 20 Oct 2020 14:50:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kUsxs-0006nl-CV for pgsql-performance@arkaria.postgresql.org; Tue, 20 Oct 2020 14:50:16 +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 1kUsxs-0006nN-0Q for pgsql-performance@lists.postgresql.org; Tue, 20 Oct 2020 14:50:16 +0000 Received: from mail-lj1-x241.google.com ([2a00:1450:4864:20::241]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kUsxo-0001pE-PA for pgsql-performance@postgresql.org; Tue, 20 Oct 2020 14:50:14 +0000 Received: by mail-lj1-x241.google.com with SMTP id d24so2304317ljg.10 for ; Tue, 20 Oct 2020 07:50:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=duneanalytics-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language; bh=QBj+msE0eE2xD0ZOwyreDbPyDAEiDLFGCeWER7uTa8o=; b=julbBDsy9wrD7rOOOOhYI6/9c4MWIiGotL8DCbf5hZyDonxvV+gvaS/5yYExWnxNWH vDcP92JE0/so6sfi8fzyV/Te+j/D/3J0H9TnHRqmdvmyN+4MwqhRHyPUd6vv4Evb/AI0 9wNg5qQqi+4ufpNCo1hwC58VpmdMqJ9BnxejaaRUG/dGNxkBKoLaEz8CA/i+pzf0eFzW BxrXL91co8cBSiIPpuRzUd1newLqhbvKmeLtWYwgP/zkuFWfilBjTiA8abEZeEZT5+o+ 0w8Kk5uf/X88gG3ul3t7RC3OYSKvoBo/3dNL+X4g3A28SQCI5usvzmojFFCn6SxlxWWM Mvfw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=QBj+msE0eE2xD0ZOwyreDbPyDAEiDLFGCeWER7uTa8o=; b=UoGje0VdJ96QP4kg7loGXoAZMAPIlnItBDNFhIX6bC3vDulvnUrG77nQuoYx7LuqBa tokuKREOPXBw831yCNUOHB0j5r5G3NcWiUqw/TTBYmgOybpFCEqL+oYGFJFDv0ce6xPu 5cypj1v1gSUem94p54CFmSViBFpisQdX2EWBPWGZAi1ahFWYvkbkG6p231ENlHaY2z8p WprcWDPAqYEg9GDVk0qWi/p1FX987AtoduM2uCogEEohqAmHlcAuceNdZBOp6tV2LZ19 +R6NiTco/kl0Jrb8h7Q/ythtHNK7kRBWbqpDMocXxiaTKq5hjcaug7Prz+umXrAYe74Z BqRA== X-Gm-Message-State: AOAM5318TWBywGjNgq5FFLnqw2zIVlCpTBW9W8shvEgeMK2jvlP3d/Sa e1IghEPqtPCEBTCF6aV+DVD3uTwd4XD6wlbV X-Google-Smtp-Source: ABdhPJxXOzjQm/n62LhlSBZIsZnKYxkDu+CS+l4B3G6xWooY1metuBsWbAQxO1wOFdBCfVb5KBpeNg== X-Received: by 2002:a05:651c:1194:: with SMTP id w20mr1278616ljo.174.1603205409838; Tue, 20 Oct 2020 07:50:09 -0700 (PDT) Received: from [192.168.1.181] (host-37-191-238-241.lynet.no. [37.191.238.241]) by smtp.gmail.com with ESMTPSA id a11sm334537lfi.187.2020.10.20.07.50.08 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 20 Oct 2020 07:50:08 -0700 (PDT) Subject: Re: Query Performance / Planner estimate off To: Victor Yegorov Cc: pgsql-performance@postgresql.org References: From: Mats Olsen Message-ID: <225f4817-ca74-a595-8ff4-58c6a591578b@duneanalytics.com> Date: Tue, 20 Oct 2020 16:50:02 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.3.2 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------F12A373A72BECD39C595A9E7" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------F12A373A72BECD39C595A9E7 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 10/20/20 3:04 PM, Victor Yegorov wrote: > вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen >: > > I'm looking for some help to manage queries against two large tables. > > > Can you tell the version you're running currently and the output of > this query, please? > >     select name,setting,source from pg_settings where source not in > ('default','override'); > Running "PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.2.1-9ubuntu2) 9.2.1 20191008, 64-bit" Updated the gist to include the results forom pg_settings. Here's the direct link https://gist.githubusercontent.com/mewwts/9f11ae5e6a5951593b8999559f5418cf/raw/e5deebbbb48680e04570bec4e9a816fa009da34f/pg_settings --------------F12A373A72BECD39C595A9E7 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit


On 10/20/20 3:04 PM, Victor Yegorov wrote:
вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats@duneanalytics.com>:
I'm looking for some help to manage queries against two large tables.

Can you tell the version you're running currently and the output of this query, please?

    select name,setting,source from pg_settings where source not in ('default','override'); 

Running "PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.2.1-9ubuntu2) 9.2.1 20191008, 64-bit"

Updated the gist to include the results forom pg_settings. Here's the direct link https://gist.githubusercontent.com/mewwts/9f11ae5e6a5951593b8999559f5418cf/raw/e5deebbbb48680e04570bec4e9a816fa009da34f/pg_settings

--------------F12A373A72BECD39C595A9E7--