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 1kaVUK-000681-Ln for pgsql-performance@arkaria.postgresql.org; Thu, 05 Nov 2020 02:59:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kaVUJ-00009m-ID for pgsql-performance@arkaria.postgresql.org; Thu, 05 Nov 2020 02:58:59 +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 1kaVUJ-00009U-8L for pgsql-performance@lists.postgresql.org; Thu, 05 Nov 2020 02:58:59 +0000 Received: from mail-qv1-xf32.google.com ([2607:f8b0:4864:20::f32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kaVUC-0005pf-Uo for pgsql-performance@postgresql.org; Thu, 05 Nov 2020 02:58:58 +0000 Received: by mail-qv1-xf32.google.com with SMTP id dj6so80585qvb.3 for ; Wed, 04 Nov 2020 18:58:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:message-id:date :to; bh=Lya4b/cs7qYle5/j78xjnrVIjORPVPfUaGOBSytkkww=; b=YPRL2YfdcpMrjzErrEkjFu4gEBU0UhP6LPxVrC9iC9vDDlDfOpmMKszuCzDPYHuZ7q 0P5EQwRcu8fZrReGW+eeqWebcWLIpwBXMHAcpgs5eapSqMYT0RGkGAUNpfw4VapLameY ZfKJMCbCZTgwn5tVlyNH4LprpAJjd8mUcns4vqvauXlnhEC8sp+J6MFmNOgsxszLamrv 79MhabwGULAbcFj0/iBzVG9r3E6xMy/8SeJwXvgnBFXR5zzLkKFMdVAyRfU6hfF6Irmh fV8Ep+F/9kNk76Xn9KR5ghZ3+LjhsSZ3Y/0zn1AzMYVpkgpQPAwEAyOx4pkhMI8xai4h Qvew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:message-id:date:to; bh=Lya4b/cs7qYle5/j78xjnrVIjORPVPfUaGOBSytkkww=; b=cqD+/jvptRSceN8d9OOS+/Pv5DmVDuLi3y/Ln3ov2j3f/DQ3crsBMOEzhlUc8/qFfP 4M5ztFzeFHY5DgZDftwy7BwLIE6svItiaGXIUyt4C0pDquGKQLr9jRvNgWEfg4pUAY7I vHSoyJS8AJK+Zo2TlwuxJVzohFxp6FOgLeFnO6VHHZglLX7XDJHd7zlmhEhG8H7DzouD rPmayeNraxGYb7B8pc5Gehi8niAfXiAV8ZEL44GY5ttzFTOmYYn/1nRQ5lrZ2e89mFzJ NM57TfH8PxnmZWjmRJ7EUCnI0FnRpLB3t3/UUefTiRnWsqPCRrj3emCCj0375kzuFv8Y 7aFg== X-Gm-Message-State: AOAM533uRktJrc76D/bSam4c5cdcAOlJmGPfvEkIQKCQub6RlCtvrOuq NAaLLPYjiqTOU9gg8wt7LL8dj7dvXeX2/g== X-Google-Smtp-Source: ABdhPJw32q3NYAUyHhUfKxpXnxcptlB9fkIAtX6UJOjOZrMRrGdoNeDhxP8qduPoE2FKfFDj4olTuQ== X-Received: by 2002:ad4:45d2:: with SMTP id v18mr464863qvt.45.1604545131720; Wed, 04 Nov 2020 18:58:51 -0800 (PST) Received: from [192.168.1.232] (ip24-255-76-212.rn.hr.cox.net. [24.255.76.212]) by smtp.gmail.com with ESMTPSA id n63sm218773qka.45.2020.11.04.18.58.51 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 04 Nov 2020 18:58:51 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-05C7C999-BC96-4412-BEAD-935486010A89 Content-Transfer-Encoding: 7bit From: Koteswara Rao Daliparthi Mime-Version: 1.0 (1.0) Subject: Low cost query - running longer Message-Id: Date: Wed, 4 Nov 2020 21:58:50 -0500 To: pgsql-performance@postgresql.org X-Mailer: iPhone Mail (18A8395) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-05C7C999-BC96-4412-BEAD-935486010A89 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable =EF=BB=BFHi Guys, Sorry for the bold below. I just feel it helps others iden= tify my question easily. A description of what you are trying to achieve and what results you expect.= : A very low cost query running long (clustered and vacuumed and analyzed on j= oin columns), a very generic query..What can be done without admin privs?? PostgreSQL version number you are running: 11.5 How you installed PostgreSQL: admin installed it Changes made to the settings in the postgresql.conf file: see Server Config= uration for a quick way to list them all. no changes to postgresql.conf Operating system and version: What program you're using to connect to PostgreSQL: pgadmin 4v4 =20 Is there anything relevant or unusual in the PostgreSQL server logs?: no =20 For questions about any kind of error: no errors What you were doing when the error happened / how to cause the error: no err= or The EXACT TEXT of the error message you're getting, if there is one: (Copy a= nd paste the message to the email, do not send a screenshot) no error. --=20 Thanks & Regards Koteswara Daliparthi= --Apple-Mail-05C7C999-BC96-4412-BEAD-935486010A89 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
=EF=BB=BFHi Guys, Sorry for the bold below. I just fee= l it helps others identify my question easily.

A description of what you are trying to achieve and wh= at results you expect.:

A very low cost query running long (cluste= red and vacuumed and analyzed on join columns), a very generic query..What c= an be done without admin privs??

PostgreSQL version number you ar= e running: 11.5

How you installed PostgreSQL: adm= in installed it

Changes made to the settings in the postgresql.co= nf file:  see Server Configuration for a quick way to list them all.&nb= sp;no changes to postgresql.conf

Operating system and version:=

What program you're using to connect to PostgreSQL: pgadmin 4= v4
 
Is there anything relevant or unusual in the PostgreSQL s= erver logs?: no
 
For questions about any kind of err= or: no errors

What you were doing when the error happened= / how to cause the error: no error

The EXACT TEXT of the= error message you're getting, if there is one: (Copy and paste the message t= o the email, do not send a screenshot) no error.

-- =
Thanks & Regards
Koteswara Daliparthi
<= /div>= --Apple-Mail-05C7C999-BC96-4412-BEAD-935486010A89--