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 1jlIJ6-0003PJ-0F for pgsql-performance@arkaria.postgresql.org; Tue, 16 Jun 2020 20:35:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jlIJ4-0004tj-CO for pgsql-performance@arkaria.postgresql.org; Tue, 16 Jun 2020 20:35:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jlIJ3-0004tc-SC for pgsql-performance@lists.postgresql.org; Tue, 16 Jun 2020 20:35:42 +0000 Received: from sonic306-21.consmr.mail.ne1.yahoo.com ([66.163.189.83]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jlIJ0-0001mw-3c for pgsql-performance@lists.postgresql.org; Tue, 16 Jun 2020 20:35:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1592339734; bh=srgwUhtZY7GNmq5mD4IYH/qB3Fcz4tp+5d52mVtFvSU=; h=Date:From:To:Subject:References:From:Subject; b=AU7Ccvu1Gagx0WvDd0Cz3Gqc2NUMZWQFSJqZHCSHLv4FVPvjllbd8hwjrMl8wgRddhcY4M6y/n8/SDgBZuLwc2byyLu5gHEB9TPKyx3BetBZX/8HbJExm2jJXME8K2eCy6hl/bWLylX0YZZ00UGPAzNHZseDMvzR/fNvYPgIcHXE8LOj9TtHqC0Lhmvra+uiKR+MxjVZCRz01tliL5Mle+/dhnt+LaLRr0wfHhdhZqv0Pb3gRJ/kdGM5c5dTnAxXxXosPW4hdWlO3bNSkur8q23P6zNsNMWDw5Xc9r94V0rIgBhh08ipuMz/lLELyfk45TlDLXWIorhPdVF0ZeuKjg== X-YMail-OSG: jN0VQ2gVM1kShVJRtZvP23DWkhas5IJ9njac_trCo6hcfhDgFuQdzAeijqrXmC2 S4wseEDY0ufDPQRzZxnpfofMJMhF2Sq7tzD_Qlt_TFVBmHFhHSHKOYo2sMUHjQz98qHz4s1Zlftm 6AauQ.Z7wdfuXC.5WGMJbfNo__ZHXCocihqLpbr6IuQFKtDWPz_zzpqy6fuLTfiAwo6JbDRSKAgk I1YjbP8I0A72gsTe_288jytC0EJ7pEgUM9NY_Ac9KykTZzh4uZqS.k5vxWSltEUfaWkwYp1_N4Z2 _EidIsYDPcEgsX5dIh7n3f3hav4SmJXJoqckzFF5Z_SXcOGA6ZGsmg5Se5LA_z2LAMCvmfwt8lgo 1Cxv9i1f2ieY9F3i81ammDwrpP2pz8JEA0KsiRmxX0xt.5SP6J6N6q.6ZxvlotnIMkbaHFKU5Xmt m1mSU8FVyTmUC.jNrIF5UARsj54ooh2yHXFlb_YLHU.A1CEF4u7A5.dER9StMg2KSbPp7j9yOeK9 dTUp3uJ4SWY2RQMkqvgDcC39NEzklhXMgoieM7317MfUM.iulYJyB2Ew6ILuXbAjnFCAloP4uI2C BhOj0qrZlUA7LM3xr_UNT4Sraqtf54rDnFpDCZuXbj5TKhP4fYEuMz97RMBvIeGMaOmub45uv_Jo sqoMirbm4K8c1iID9RZYHgL5NAwPzfeE2MWY.HjHyXYzBWXhohELYVjE1sTbScz8Rxu4Z3QN4IGe p7kkLHh2quIV2n4.HdK6RSgMf1lFKflmxBniRxtPOYcwRoai03VgRtqVDnZL08Q7cxd.xGhyV5fw 19qy0oRvb544Qgl2mbB8ycZGVuAK4HTtuaS26duH46PoQeOZKX.mBHpR0fqoZgacvuL3_.7hJcAf 1XisXetZiTV9Nq.Y28cBY9fjJkeS4Frsq9JJGYdc93sCvRMAUCb_jRamj6mou64cxcPyUFHaI22W 4iU_wWUMlIyk5_2wb3djQ7ue81tmtMr.I5PDBBbG1HEUZ6E8cxLfh2rXDLSTP0i8su35AcYH4EOV cG3SDYbo8MOm45xFdgSSrGIvtP31kltkObDqMgYapSHPsXxa9OY7U1UjzqeuU16cLPmcctjouqni DyohUCnOMWnKBcr4a29XyRr1Oru4DltzALBTgzPBhbpuOP34cytTKxoQKiHDYyvBZobEH47PVDBM 3HsCWZseYEGMryg0VelrYFgZK_Ey3YnRSpaWn0FNfUYgJKveNejZdbICjWe8wOr9MybOfVS72L2g d1JOVe8LMbWDDYPS5nJ.l3KHgn6O4fonMFj_RyoHktKfmlN4zxxKrNCaRd_XwTOgzb8w- Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.ne1.yahoo.com with HTTP; Tue, 16 Jun 2020 20:35:34 +0000 Date: Tue, 16 Jun 2020 20:35:31 +0000 (UTC) From: Nagaraj Raj To: Pgsql Performance Message-ID: <574079062.1873527.1592339731136@mail.yahoo.com> Subject: simple query running for ever MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit References: <574079062.1873527.1592339731136.ref@mail.yahoo.com> X-Mailer: WebService/1.1.16119 YMailNodin Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36 Content-Length: 963 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I wrote a simple query, and it is taking too long, not sure what is wrong in it, even its not giving EXPLAIN ANALYZE. select T0."physical_address_sid", T0."individual_entity_proxy_id", T2."infrrd_hh_rank_nbr" from "cms_prospects".PROSPECT T0 --inner join "sas_prs_tmp".DEDUPE3583E3F18 T1 on T0."individual_entity_proxy_id" = T1."individual_entity_proxy_id" left join "cms_prospects".INDIVIDUAL_DEMOGRAPHIC T2 on T0."individual_entity_proxy_id" = T2."individual_entity_proxy_id" "Merge Left Join (cost=55.96..18147747.08 rows=213620928 width=20)" " Merge Cond: (t0.individual_entity_proxy_id = t2.individual_entity_proxy_id)" " -> Index Scan using pk_prospect on prospect t0 (cost=0.57..10831606.89 rows=213620928 width=16)" " -> Index Only Scan using indxp_individual_demo_infrrd_hh_rank_nbr on individual_demographic t2 (cost=0.57..5013756.93 rows=260652064 width=12)" Any suggestions or help would be highly appreciated. Best regards, Rj