Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d1Hm8-00016W-PU for pgsql-sql@arkaria.postgresql.org; Thu, 20 Apr 2017 19:29:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d1Hm7-0006sA-K7 for pgsql-sql@arkaria.postgresql.org; Thu, 20 Apr 2017 19:29:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d1Hm5-0006oa-HZ for pgsql-sql@postgresql.org; Thu, 20 Apr 2017 19:29:53 +0000 Received: from forward1h.cmail.yandex.net ([87.250.230.16]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d1Hm2-0008L5-SJ for pgsql-sql@postgresql.org; Thu, 20 Apr 2017 19:29:53 +0000 Received: from mxback18j.mail.yandex.net (mxback18j.mail.yandex.net [IPv6:2a02:6b8:0:1619::94]) by forward1h.cmail.yandex.net (Yandex) with ESMTP id CADE321248; Thu, 20 Apr 2017 22:29:48 +0300 (MSK) Received: from web5m.yandex.ru (web5m.yandex.ru [37.140.138.96]) by mxback18j.mail.yandex.net (nwsmtp/Yandex) with ESMTP id 0Lzm7MBkD8-Tlfq3YXG; Thu, 20 Apr 2017 22:29:47 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1492716587; bh=yP0d0K9jp7jxzPf4XblCqHBBnzZ1WGpKSTnVoB9BYfs=; h=From:To:Cc:In-Reply-To:References:Subject:Message-Id:Date; b=LD8dV+Y7BzgdD7egV/QjHX8/leWE1C1ceuIpow4rCOLOKWVIGnKXRTOHw2lKSfPKx l4v5j5SY6r1oaHoQxH8We3/6xEHPKjzh1OoVN6iaofzeNf7h/9aHT/kojtRsljLxeV DIxubQkIJdijZ3+tUW/X095SHiSn1jAkf30XV74I= Authentication-Results: mxback18j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web5m.yandex.ru with HTTP; Thu, 20 Apr 2017 22:29:47 +0300 From: Samed YILDIRIM To: Muhannad Shubita Cc: "pgsql-sql@postgresql.org" In-Reply-To: References: <334521492708706@web22g.yandex.ru> Subject: Re: Please advice on query optimization MIME-Version: 1.0 Message-Id: <485421492716587@web5m.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Thu, 20 Apr 2017 22:29:47 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 X-Pg-Spam-Score: -1.0 (-) 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+PGRpdj5maXJzdF92YWx1ZSBhbmQg bGFzdF92YWx1ZSBmdW5jdGlvbnMgY2FuIGJlIHVzZWQgZm9yIHRoZXNlIHB1cnBvc2UuIEJ1dCBx dWVyeSBzaG91bGQgYmUgcmV3cml0ZWQgYXMgYmVsb3cuIEFsc28gZm9yIHRoaXMgY2FzZSBJJ20g bm90IHN1cmUgd2hpY2ggb25lIGlzIGJldHRlciwgc3ViIHF1ZXJ5IG9yIHdpbmRvdyBmdW5jdGlv bnMuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+U0VMRUNUIERJU1RJTkNUIGVtcGxveWVlX2lkLCBk YXksIHN1bSh0b3RhbF9ob3Vycykgb3ZlciB3MSwgbWluKHNpZ25faW4pIE9WRVIgdzEgYXMgZmly c3Rfc2lnbl9pbiwgbWF4KHNpZ25faW4pIE9WRVIgdzEgYXMgbGFzdF9zaWduX2luLCBmaXJzdF92 YWx1ZShkZXZpY2VfaWQpIE9WRVIgdzIgYXMgZmlyc3Rfc2lnbl9pbl9kZXZpY2UsIGZpcnN0X3Zh bHVlKGRldmljZV9pZCkgT1ZFUiB3MyBhcyBsYXN0X3NpZ25faW5fZGV2aWNlPC9kaXY+PGRpdj48 ZGl2PkZST00gPHNwYW4+YmlvZW1wbG95ZWUgPC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4+V0hFUkUg c2lnbl9pbiBCRVRXRUVOIFggYW5kIFk8L3NwYW4+PC9kaXY+PGRpdj5XSU5ET1cgdzEgYXMgKFBB UlRJVElPTiBCWSBlbXBsb3llZV9pZCxkYXkpLHcyIGFzIChQQVJUSVRJT04gQlkgZW1wbG95ZWVf aWQsZGF5IE9SREVSIEJZIHNpZ25faW4gQVNDKSx3MyBhcyAoUEFSVElUSU9OIEJZIGVtcGxveWVl X2lkLGRheSBPUkRFUiBCWSBzaWduX2luIERFU0MpPC9kaXY+PGRpdj5PUkRFUiBCWSBkYXk7PC9k aXY+PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+QmVzdCByZWdhcmRzLjwvZGl2PjxkaXY+wqA8L2Rp dj48ZGl2PsSweWkgw6dhbMSxxZ9tYWxhci48L2Rpdj48ZGl2PlNhbWVkIFlJTERJUklNPC9kaXY+ PGRpdj7CoDwvZGl2PjxkaXY+MjAuMDQuMjAxNywgMjA6MzUsICJNdWhhbm5hZCBTaHViaXRhIiAm bHQ7bXVoYW5uYWRzaHViaXRhQGdtYWlsLmNvbSZndDs6PC9kaXY+PGJsb2NrcXVvdGUgdHlwZT0i Y2l0ZSI+PGRpdj5UaGFua3MgU2FtZWQsPGRpdj7CoDwvZGl2PjxkaXY+b25lIG1vcmUgcXVlc3Rp b24sIHdoYXQgaWYgSSBoYWQgb3RoZXIgY29sdW1ucyB0aGF0IGNhbm5vdCBiZSB1c2VkIHdpdGgg YW4gYWdncmVnYXRlIGZ1bmN0aW9uIChURVhULWJhc2VkIGZvciBleGFtcGxlKSBidXQgc3RpbGwg bmVlZGVkIHRvIGJlIHBhaXJlZCB3aXRoIHRoZSBmaXJzdCAmYW1wOyBsYXN0IHNpZ24gaW4/IGZv ciBpbnN0YW5jZSwgYSByYW5kb21seSBnZW5lcmF0ZWQgbWQ1LWVkIElEIGJ5IHRoZSBzaWduIGlu IGRldmljZSB0aGF0IG5lZWRzIHRvIGJlIGRpc3BsYXllZCBhcyBhIHJlZmVyZW5jZTo8L2Rpdj48 ZGl2PsKgPC9kaXY+PGRpdj48ZGl2IHN0eWxlPSJmb250LXNpemU6MTIuOHB4OyI+RGF5wqA8c3Bh biBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXA7Ij4gPC9zcGFuPkVtcGxveWVlPHNwYW4gc3R5 bGU9IndoaXRlLXNwYWNlOnByZS13cmFwOyI+IDwvc3Bhbj5Ub3RhbC1Ib3VyczxzcGFuIHN0eWxl PSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+wqBGaXJzdC1TaWduLUluIDxzcGFuIHN0 eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPsKgIGRldmljZS1pZC1vZi1maXJzdC1zaWduLWlu IDwvc3Bhbj5MYXN0LVNpZ24tSW4gwqAgwqBkZXZpY2UtaWQtb2YtbGFzdC1zaWduLWluPC9kaXY+ PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweDsiPsKgPC9kaXY+PGRpdiBzdHlsZT0iZm9udC1z aXplOjEyLjhweDsiPjIwLzQ8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXA7Ij4gPC9z cGFuPmVtcDE8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXA7Ij4gPC9zcGFuPjQ8c3Bh biBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXA7Ij4gPC9zcGFuPjg6MjI8c3BhbiBzdHlsZT0i d2hpdGUtc3BhY2U6cHJlLXdyYXA7Ij4gMjAyY2I5NjJhYzUuLiA8L3NwYW4+MzoyNSDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAxNTJkMjM0YjcwLi48L2Rpdj48L2Rpdj48ZGl2IHN0eWxl PSJmb250LXNpemU6MTIuOHB4OyI+wqA8L2Rpdj48ZGl2PsKgPGRpdj5PbiBUaHUsIEFwciAyMCwg MjAxNyBhdCA5OjE4IFBNLCBTYW1lZCBZSUxESVJJTSA8c3Bhbj4mbHQ7PGEgdGFyZ2V0PSJfYmxh bmsiIGhyZWY9Im1haWx0bzpzYW1lZEByZWRkb2MubmV0Ij5zYW1lZEByZWRkb2MubmV0PC9hPiZn dDs8L3NwYW4+IHdyb3RlOjxibG9ja3F1b3RlIHN0eWxlPSJtYXJnaW46MCAwIDAgMC44ZXg7Ym9y ZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleDsiPjxkaXY+SGkgTXVoYW5u YWQsPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+RGlkIHlvdSB0cnkgdXNpbmcgTUlOIGFuZCBNQVgg ZnVuY3Rpb24/IEkgZ3Vlc3MgdGhhdCBmb2xsb3dpbmcgcXVlcnkgc29sdmVzIHlvdXIgcHJvYmxl bS48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj48ZGl2PnNlbGVjdCBlbXBsb3llZV9pZCwgZGF5LCBz dW0odG90YWxfaG91cnMpIGFzIHRvdGFsX2hvdXJzLCAoc2VsZWN0IG5hbWUgZnJvbSBlbXBsb3ll ZSB3aGVyZSBpZCA9IGVtcGxveWVlX2lkKSBhcyBlbXBfbmFtZSwgPGVtPjxzdHJvbmc+bWluKHNp Z25faW4pIGFzIGZpcnN0X3NpZ25faW4sIG1heChzaWduX2luKSBhcyBsYXN0X3NpZ25faW48L3N0 cm9uZz48L2VtPjwvZGl2PjxkaXY+PHNwYW4+ZnJvbSBiaW9lbXBsb3llZSB3aGVyZSBzaWduX2lu IEJFVFdFRU4gWCBhbmQgWSBHUk9VUCBCWSBlbXBsb3llZV9pZCwgZGF5IE9SREVSIEJZIGRheTs8 L3NwYW4+PC9kaXY+PGRpdj48c3Bhbj7CoDwvc3Bhbj48L2Rpdj48ZGl2PkJlc3QgcmVnYXJkcy48 L2Rpdj48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKg PC9kaXY+PGRpdj7EsHlpIMOnYWzEscWfbWFsYXIuPC9kaXY+PGRpdj5TYW1lZCBZSUxESVJJTTwv ZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MjAuMDQuMjAx NywgMTk6NTYsICJNdWhhbm5hZCBTaHViaXRhIiAmbHQ7PGEgdGFyZ2V0PSJfYmxhbmsiIGhyZWY9 Im1haWx0bzptdWhhbm5hZHNodWJpdGFAZ21haWwuY29tIj5tdWhhbm5hZHNodWJpdGFAZ21haWwu Y29tPC9hPiZndDs6PC9kaXY+PGRpdj48ZGl2PjxibG9ja3F1b3RlIHR5cGU9ImNpdGUiPjxkaXY+ PGRpdj5Hb29kIGRheSw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5JIGhhdmUgYSB0YWJsZSB3aXRo IGJpb21ldHJpYyBpbmZvIGFib3V0IGVtcGxveWVlcyAobGV0J3MgY2FsbCBpdCBiaW9lbXBsb3ll ZSk6PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+aWQgc2VyaWFsIG5vdCBudWxsIC0tIHByaW1hcnkg a2V5PC9kaXY+PGRpdj5lbXBsb3llZV9pZCDCoC0tIGZvcmVpZ24ga2V5IHJlZmVyZW5jZXMgZW1w bG95ZWUgdGFibGU8L2Rpdj48ZGl2PmRheSBjaGFyKDgpIC0tIFlZLU1NLUREPC9kaXY+PGRpdj5z aWduX2luIFRJTUVTVEFNUDwvZGl2PjxkaXY+dG90YWxfaG91cnMgSU5URUdFUjwvZGl2PjxkaXY+ wqA8L2Rpdj48ZGl2Pkkgd2FudCB0byBkaXNwbGF5IGRldGFpbHMgZ3JvdXBlZCBieSBkYXkgJmFt cDsgZW1wbG95ZWUgSWQsIGZvciBleGFtcGxlOjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9k aXY+PGRpdj5EYXkgPHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZS13cmFwOyI+IDwvc3Bhbj5F bXBsb3llZTxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+VG90YWwt SG91cnM8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXA7Ij4gPC9zcGFuPiBGaXJzdC1T aWduLUluIDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+TGFzdC1T aWduLUluPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MjAvNDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFj ZTpwcmUtd3JhcDsiPiA8L3NwYW4+ZW1wMTxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3Jh cDsiPiA8L3NwYW4+NDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+ ODoyMjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+MzoyNTwvZGl2 PjxkaXY+MjEvNDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+ZW1w MTxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+NzxzcGFuIHN0eWxl PSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+OTowMDxzcGFuIHN0eWxlPSJ3aGl0ZS1z cGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+NDoxMTwvZGl2PjxkaXY+MjEvNDxzcGFuIHN0eWxlPSJ3 aGl0ZS1zcGFjZTpwcmUtd3JhcDsiPiA8L3NwYW4+ZW1wMjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFj ZTpwcmUtd3JhcDsiPiA8L3NwYW4+MjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcDsi PiA8L3NwYW4+MTE6MDA8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXA7Ij4gPC9zcGFu PjAxOjExPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkkgY3JlYXRlZCBhIHBn c3FsIGZ1bmN0aW9uIHRvIGdldCB0aGUgZGV0YWlscyB0aHJvdWdoIHRoZSBiZWxvdyBxdWVyeTo8 L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5zZWxlY3QgZW1wbG95ZWVfaWQsIGRheSwgc3VtKHRvdGFs X2hvdXJzKSBhcyB0b3RhbF9ob3VycywgKHNlbGVjdCBuYW1lIGZyb20gZW1wbG95ZWUgd2hlcmUg aWQgPSBlbXBsb3llZV9pZCkgYXMgZW1wX25hbWU8L2Rpdj48ZGl2PmZyb20gYmlvZW1wbG95ZWUg d2hlcmUgc2lnbl9pbiBCRVRXRUVOIFggYW5kIFkgR1JPVVAgQlkgZW1wbG95ZWVfaWQsIGRheSBP UkRFUiBCWSBkYXk7PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+bm93IHRoZSBwcm9ibGVtIGlzIHdp dGggZ2V0dGluZyBGaXJzdC1TaWduLUluIMKgJmFtcDsgwqBMYXN0LVNpZ24tSW4gcGVyIGdyb3Vw IChlbXBsb3llZSAmYW1wOyBkYXkpLCBJIGhhdmUgY3VycmVudGx5IGltcGxlbWVudGVkIGl0IGlu IGEgRk9SIGxvb3A6PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+Zm9yIFJFQ09SRCBpbiBxdWVyeSBM T09QPC9kaXY+PGRpdj4tLUZpcnN0LVNpZ24tSW48L2Rpdj48ZGl2PnNlbGVjdCBzaWduX2luIGZy b20gYmlvZW1wbG95ZWUgd2hlcmUgZW1wbG95ZWVfaWQgPSAtLSBhbmQgZGF5ID0gLS0gYW5kIHNp Z25faW4gQkVUV0VFTiBYIGFuZCBZIE9SREVSIEJZIHNpZ25faW4gTElNSVQgMTs8L2Rpdj48ZGl2 Pi0tTGFzdC1TaWduLUluPC9kaXY+PGRpdj5zZWxlY3Qgc2lnbl9pbiBmcm9tIGJpb2VtcGxveWVl IHdoZXJlIGVtcGxveWVlX2lkID0gLS0gYW5kIGRheSA9IC0tIGFuZCBzaWduX2luIEJFVFdFRU4g WCBhbmQgWSBPUkRFUiBCWSBzaWduX2luIERFU0MgTElNSVQgMTs8L2Rpdj48ZGl2PsKgPC9kaXY+ PGRpdj5yZXR1cm4gbmV4dCBqc29uX2J1aWxkX29iamVjdChmaXJzdF9zaWduX2luLCBsYXN0X3Np Z25faW4sIC4ucmVzdCBvZiBkZXRhaWxzKTs8L2Rpdj48ZGl2PkVORCBMT09QPC9kaXY+PGRpdj7C oDwvZGl2PjxkaXY+YnV0IElmIEkgaGFkIDEwMCBlbXBsb3llZXMgb3ZlciBhIHNwYW4gb2YgMzAg ZGF5cywgdGhpcyB3b3VsZCBiZSA2MDAwIHF1ZXJpZXMgaW5zaWRlIHRoZSBsb29wISB3aGljaCBJ IGFtIHN1cmUgeW91IHdvdWxkIGFncmVlIGlzIGFuIG92ZXJraWxsPC9kaXY+PGRpdj7CoDwvZGl2 PjxkaXY+wqA8L2Rpdj48ZGl2PmlzIHRoZXJlIGEgYmV0dGVyIHdheSB0byBkbyB0aGlzP8KgPC9k aXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlRoYW5rcy48L2Rpdj48L2Rpdj48L2Js b2NrcXVvdGU+PC9kaXY+PC9kaXY+PC9ibG9ja3F1b3RlPjwvZGl2PsKgPGRpdj7CoDwvZGl2Pi0t PGRpdj48ZGl2Pjxmb250IGZhY2U9Im1vbm9zcGFjZSwgbW9ub3NwYWNlIj5SZWdhcmRzLDwvZm9u dD48ZGl2Pjxmb250IGZhY2U9Im1vbm9zcGFjZSwgbW9ub3NwYWNlIj5NdWhhbm5hZDwvZm9udD48 L2Rpdj48L2Rpdj48L2Rpdj48L2Rpdj48L2Rpdj48L2Jsb2NrcXVvdGU+