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 1jf2LA-0003rL-UC for pgsql-performance@arkaria.postgresql.org; Sat, 30 May 2020 14:20:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jf2L8-00021H-ON for pgsql-performance@arkaria.postgresql.org; Sat, 30 May 2020 14:19:58 +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 1jf2L8-00021A-EH for pgsql-performance@lists.postgresql.org; Sat, 30 May 2020 14:19:58 +0000 Received: from mail-io1-xd34.google.com ([2607:f8b0:4864:20::d34]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jf2L5-0004Pr-C0 for pgsql-performance@lists.postgresql.org; Sat, 30 May 2020 14:19:57 +0000 Received: by mail-io1-xd34.google.com with SMTP id p20so2345512iop.11 for ; Sat, 30 May 2020 07:19:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=Yb3pDgR5TiqEK6N9d70sUfiYctCefEiY/WJtDtfJSxE=; b=WMvNBVKLy8zx2aSKDEc/kdzSWLqlyHYZDXFyXsio7TlTHynZzMD1wTaoAQL+4UxOIr 5rKoqa7MW/1JWQO0cPzxSz9DmLZq/nQuInuC7UWfrFF9QxMbwMObQfRuT+TNT08gqYXd 8GTLIThu3nAFkm2+VOqSeUI0Bf79A1EzSC+SA/bMw4nZvVcXSoQODoe0qSDcXuDilX+1 PT9pEnVCJRtG+TCOZxjRzscIolLLvMmK+LPwR6l1/uiD7S7p9ysvKtwGW724qkdS1Rsi 6Ks2ItIDKsTFKv3WASj+l9qs7Ewb/idrxi24X72c9FICyzVL1U8vBQpIxNwo4vlRnRH5 fmvQ== 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:content-transfer-encoding :in-reply-to:user-agent; bh=Yb3pDgR5TiqEK6N9d70sUfiYctCefEiY/WJtDtfJSxE=; b=FFV3xnosr2cqXGe14DDtpliTGrB3ONqYHBUS64L0naAqAfbbjaIMviQYrQw0SPQ/49 FN6ZN494QAfAWk4rwEL+dZIwlN0/3R3fAAdY6SGoaF5vKKvjqUtm98Mf6vJYCLauy3lV me73k9zBtaNVxg5JyMaGJM77KIJDVOkKA8BFCl0Hhgr73PeudLJ4xIPXpAUN5Rch26Kh tDgZUAudZV1XRxrYevYgAuBiK/ei7S9kpSwRUs6whCQf9ylHLWdqbLynMCrCn7W6iTnp XLOuCpDnCo5f5F3gGMQS2EUE/VR9oKE7Y4zsJ6qpqdFXts3DKZ9dwlaNp/xKXBUbWAPj eZPg== X-Gm-Message-State: AOAM531F90bSSnuj1b51I3YHQtLnAhcsH5RB5ZAGMDIXvIqDgU2LAPYB 2ESAYCamaRTuN2krMFpQzy9cUg== X-Google-Smtp-Source: ABdhPJxv9lTg8BrKO6WPVh10vthbLEkIN6rptU5Tb56seoAe0qg3SVMcuV63npwDT122bQBi5ZvQfw== X-Received: by 2002:a05:6602:1616:: with SMTP id x22mr11490739iow.70.1590848394192; Sat, 30 May 2020 07:19:54 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id p2sm317004ioh.1.2020.05.30.07.19.53 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 30 May 2020 07:19:53 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 0E2AD8001A3; Sat, 30 May 2020 09:19:51 -0500 (CDT) Date: Sat, 30 May 2020 09:19:51 -0500 From: Justin Pryzby To: Pavel Stehule Cc: sugnathi hai , pgsql-performance@lists.postgresql.org Subject: Re: Performance tunning Message-ID: <20200530141951.GY17850@telsasoft.com> References: <975278223.51863.1590824209351.ref@mail.yahoo.com> <975278223.51863.1590824209351@mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sat, May 30, 2020 at 09:43:43AM +0200, Pavel Stehule wrote: > so 30. 5. 2020 v 9:37 odesílatel sugnathi hai napsal: > > Can you help to tune the below plan Could you also send it so line breaks aren't lost, as seen here: https://www.postgresql.org/message-id/975278223.51863.1590824209351%40mail.yahoo.com Probably best to send a link to the plan at https://explain.depesz.com/ https://wiki.postgresql.org/wiki/Slow_Query_Questions https://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Justin