Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d1Fj5-0004M4-7W for pgsql-sql@arkaria.postgresql.org; Thu, 20 Apr 2017 17:18:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d1Fj4-0008Lj-QR for pgsql-sql@arkaria.postgresql.org; Thu, 20 Apr 2017 17:18:38 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d1Fj2-0008Ce-DF for pgsql-sql@postgresql.org; Thu, 20 Apr 2017 17:18:36 +0000 Received: from forward4h.cmail.yandex.net ([2a02:6b8:0:f35::111]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d1Fiy-0002cY-II for pgsql-sql@postgresql.org; Thu, 20 Apr 2017 17:18:34 +0000 Received: from mxback5j.mail.yandex.net (mxback5j.mail.yandex.net [IPv6:2a02:6b8:0:1619::10e]) by forward4h.cmail.yandex.net (Yandex) with ESMTP id 3B42F20B53; Thu, 20 Apr 2017 20:18:27 +0300 (MSK) Received: from web22g.yandex.ru (web22g.yandex.ru [95.108.253.231]) by mxback5j.mail.yandex.net (nwsmtp/Yandex) with ESMTP id J5bMy2DCPr-IQTmmAvc; Thu, 20 Apr 2017 20:18:26 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1492708706; bh=XZnMyJePcuMdbJ9b3qrjbYPixRLcbXToRczEsf85r3M=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=amfPNfo+lEtrOFMhjjEcCaYa1Lcx+G1DhplJrIOMtiDqOzSBvLW1jv78i7bLiTooI llHWYhti+wat6W+sts4KX8bz3ijGDaBsKxgUMPLEgK+maIW/64RZ4tugeSci9YwhQu jG+Lqi5+l7Ia8c2eC4XQX4dKRXQj0uupxnM4enE0= Authentication-Results: mxback5j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web22g.yandex.ru with HTTP; Thu, 20 Apr 2017 20:18:26 +0300 From: Samed YILDIRIM To: Muhannad Shubita , "pgsql-sql@postgresql.org" In-Reply-To: References: Subject: Re: Please advice on query optimization MIME-Version: 1.0 Message-Id: <334521492708706@web22g.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Thu, 20 Apr 2017 20:18:26 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org PGRpdj5IaSBNdWhhbm5hZCw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5EaWQgeW91IHRyeSB1c2lu ZyBNSU4gYW5kIE1BWCBmdW5jdGlvbj8gSSBndWVzcyB0aGF0IGZvbGxvd2luZyBxdWVyeSBzb2x2 ZXMgeW91ciBwcm9ibGVtLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjxkaXY+c2VsZWN0IGVtcGxv eWVlX2lkLCBkYXksIHN1bSh0b3RhbF9ob3VycykgYXMgdG90YWxfaG91cnMsIChzZWxlY3QgbmFt ZSBmcm9tIGVtcGxveWVlIHdoZXJlIGlkID0gZW1wbG95ZWVfaWQpIGFzIGVtcF9uYW1lLCA8ZW0+ PHN0cm9uZz5taW4oc2lnbl9pbikgYXMgZmlyc3Rfc2lnbl9pbiwgbWF4KHNpZ25faW4pIGFzIGxh c3Rfc2lnbl9pbjwvc3Ryb25nPjwvZW0+PC9kaXY+PGRpdj5mcm9tIGJpb2VtcGxveWVlIHdoZXJl IHNpZ25faW4gQkVUV0VFTiBYIGFuZCBZIEdST1VQIEJZIGVtcGxveWVlX2lkLCBkYXkgT1JERVIg QlkgZGF5OzwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkJlc3QgcmVnYXJkcy48L2Rpdj48L2Rpdj48 ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj48YnIgLz48L2Rp dj48ZGl2PsSweWkgw6dhbMSxxZ9tYWxhci48L2Rpdj48ZGl2PlNhbWVkIFlJTERJUklNPC9kaXY+ PGRpdj48YnIgLz48L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj4y MC4wNC4yMDE3LCAxOTo1NiwgIk11aGFubmFkIFNodWJpdGEiICZsdDttdWhhbm5hZHNodWJpdGFA Z21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZSB0eXBlPSJjaXRlIj48ZGl2IGRpcj0ibHRy Ij48ZGl2Pkdvb2QgZGF5LDwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj5JIGhhdmUgYSB0YWJs ZSB3aXRoIGJpb21ldHJpYyBpbmZvIGFib3V0IGVtcGxveWVlcyAobGV0J3MgY2FsbCBpdCBiaW9l bXBsb3llZSk6PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PmlkIHNlcmlhbCBub3QgbnVsbCAt LSBwcmltYXJ5IGtleTwvZGl2PjxkaXY+ZW1wbG95ZWVfaWQgwqAtLSBmb3JlaWduIGtleSByZWZl cmVuY2VzIGVtcGxveWVlIHRhYmxlPC9kaXY+PGRpdj5kYXkgY2hhcig4KSAtLSBZWS1NTS1ERDwv ZGl2PjxkaXY+c2lnbl9pbiBUSU1FU1RBTVA8L2Rpdj48ZGl2PnRvdGFsX2hvdXJzIElOVEVHRVI8 L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+SSB3YW50IHRvIGRpc3BsYXkgZGV0YWlscyBncm91 cGVkIGJ5IGRheSAmYW1wOyBlbXBsb3llZSBJZCwgZm9yIGV4YW1wbGU6PC9kaXY+PGRpdj48YnIg Lz48L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+RGF5IDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFj ZTpwcmU7Ij4JPC9zcGFuPkVtcGxveWVlPHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZTsiPgk8 L3NwYW4+VG90YWwtSG91cnM8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlOyI+CTwvc3Bhbj4g Rmlyc3QtU2lnbi1JbiA8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlOyI+CQk8L3NwYW4+TGFz dC1TaWduLUluPC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PjIwLzQ8c3BhbiBzdHlsZT0id2hp dGUtc3BhY2U6cHJlOyI+CTwvc3Bhbj5lbXAxPHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZTsi PgkJPC9zcGFuPjQ8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlOyI+CQkJPC9zcGFuPjg6MjI8 c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlOyI+CQkgICAgICAgICAgICA8L3NwYW4+MzoyNTwv ZGl2PjxkaXY+MjEvNDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7Ij4JPC9zcGFuPmVtcDE8 c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlOyI+CQk8L3NwYW4+NzxzcGFuIHN0eWxlPSJ3aGl0 ZS1zcGFjZTpwcmU7Ij4JCQk8L3NwYW4+OTowMDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7 Ij4JCSAgICAgICAgICAgPC9zcGFuPjQ6MTE8L2Rpdj48ZGl2PjIxLzQ8c3BhbiBzdHlsZT0id2hp dGUtc3BhY2U6cHJlOyI+CTwvc3Bhbj5lbXAyPHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZTsi PgkJPC9zcGFuPjI8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlOyI+CQkJPC9zcGFuPjExOjAw PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZTsiPgkJICAgICAgICAgICA8L3NwYW4+MDE6MTE8 L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj5JIGNyZWF0ZWQgYSBw Z3NxbCBmdW5jdGlvbiB0byBnZXQgdGhlIGRldGFpbHMgdGhyb3VnaCB0aGUgYmVsb3cgcXVlcnk6 PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PnNlbGVjdCBlbXBsb3llZV9pZCwgZGF5LCBzdW0o dG90YWxfaG91cnMpIGFzIHRvdGFsX2hvdXJzLCAoc2VsZWN0IG5hbWUgZnJvbSBlbXBsb3llZSB3 aGVyZSBpZCA9IGVtcGxveWVlX2lkKSBhcyBlbXBfbmFtZTwvZGl2PjxkaXY+ZnJvbSBiaW9lbXBs b3llZSB3aGVyZSBzaWduX2luIEJFVFdFRU4gWCBhbmQgWSBHUk9VUCBCWSBlbXBsb3llZV9pZCwg ZGF5IE9SREVSIEJZIGRheTs8L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+bm93IHRoZSBwcm9i bGVtIGlzIHdpdGggZ2V0dGluZyBGaXJzdC1TaWduLUluIMKgJmFtcDsgwqBMYXN0LVNpZ24tSW4g cGVyIGdyb3VwIChlbXBsb3llZSAmYW1wOyBkYXkpLCBJIGhhdmUgY3VycmVudGx5IGltcGxlbWVu dGVkIGl0IGluIGEgRk9SIGxvb3A6PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PmZvciBSRUNP UkQgaW4gcXVlcnkgTE9PUDwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZTsi Pgk8L3NwYW4+LS1GaXJzdC1TaWduLUluPC9kaXY+PGRpdj48c3BhbiBzdHlsZT0id2hpdGUtc3Bh Y2U6cHJlOyI+CTwvc3Bhbj5zZWxlY3Qgc2lnbl9pbiBmcm9tIGJpb2VtcGxveWVlIHdoZXJlIGVt cGxveWVlX2lkID0gLS0gYW5kIGRheSA9IC0tIGFuZCBzaWduX2luIEJFVFdFRU4gWCBhbmQgWSBP UkRFUiBCWSBzaWduX2luIExJTUlUIDE7PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0id2hpdGUtc3Bh Y2U6cHJlOyI+CTwvc3Bhbj4tLUxhc3QtU2lnbi1JbjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9Indo aXRlLXNwYWNlOnByZTsiPgk8L3NwYW4+c2VsZWN0IHNpZ25faW4gZnJvbSBiaW9lbXBsb3llZSB3 aGVyZSBlbXBsb3llZV9pZCA9IC0tIGFuZCBkYXkgPSAtLSBhbmQgc2lnbl9pbiBCRVRXRUVOIFgg YW5kIFkgT1JERVIgQlkgc2lnbl9pbiBERVNDIExJTUlUIDE7PC9kaXY+PGRpdj48c3BhbiBzdHls ZT0id2hpdGUtc3BhY2U6cHJlOyI+CTwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJ3aGl0 ZS1zcGFjZTpwcmU7Ij4JPC9zcGFuPnJldHVybiBuZXh0IGpzb25fYnVpbGRfb2JqZWN0KGZpcnN0 X3NpZ25faW4sIGxhc3Rfc2lnbl9pbiwgLi5yZXN0IG9mIGRldGFpbHMpOzwvZGl2PjxkaXY+RU5E IExPT1A8L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+YnV0IElmIEkgaGFkIDEwMCBlbXBsb3ll ZXMgb3ZlciBhIHNwYW4gb2YgMzAgZGF5cywgdGhpcyB3b3VsZCBiZSA2MDAwIHF1ZXJpZXMgaW5z aWRlIHRoZSBsb29wISB3aGljaCBJIGFtIHN1cmUgeW91IHdvdWxkIGFncmVlIGlzIGFuIG92ZXJr aWxsPC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+aXMgdGhlcmUg YSBiZXR0ZXIgd2F5IHRvIGRvIHRoaXM/wqA8L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+PGJy IC8+PC9kaXY+PGRpdj5UaGFua3MuPC9kaXY+CjwvZGl2Pgo8L2Jsb2NrcXVvdGU+