Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qb2oN-00B0GU-HY for pgsql-performance@arkaria.postgresql.org; Tue, 29 Aug 2023 17:47:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qb2oL-009Tm0-FY for pgsql-performance@arkaria.postgresql.org; Tue, 29 Aug 2023 17:47:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qb2oK-009TlI-RY for pgsql-performance@lists.postgresql.org; Tue, 29 Aug 2023 17:47:28 +0000 Received: from forward102c.mail.yandex.net ([2a02:6b8:c03:500:1:45:d181:d102]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qb2oF-001dkL-RV for pgsql-performance@lists.postgresql.org; Tue, 29 Aug 2023 17:47:27 +0000 Received: from mail-nwsmtp-mxback-production-main-55.iva.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-55.iva.yp-c.yandex.net [IPv6:2a02:6b8:c0c:1b88:0:640:8929:0]) by forward102c.mail.yandex.net (Yandex) with ESMTP id A8C58600B5 for ; Tue, 29 Aug 2023 20:47:19 +0300 (MSK) Received: from mail.yandex.ru (2a02:6b8:c0c:9514:0:640:c85a:0 [2a02:6b8:c0c:9514:0:640:c85a:0]) by mail-nwsmtp-mxback-production-main-55.iva.yp-c.yandex.net (mxback/Yandex) with HTTP id 9lUH0Y1W5W20-e7KjBd0I; Tue, 29 Aug 2023 20:47:19 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1693331239; bh=Gwwu07qAFbZQ2AfQK0SUf83RnolN+4UpWG8YcQwGOZM=; h=Message-Id:Date:Subject:To:From; b=i5QgiBcnH89vvZmAQSiowfO0oXnNru5HzTm+NjlxmhvCRCCXWviSGCcYqdbSL0EOf wbTY+YpsShDGmZQvK9ZaKHK76pAmcSpE/BxD4/dsiSZoG+AIbBKKgEyAQMA/gLNxeJ mgVEGml+NB2fUBN4RWsowRMUbbLoRDszdpj7CC1I= Authentication-Results: mail-nwsmtp-mxback-production-main-55.iva.yp-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by 2nmvwtstv3l3allg.iva.yp-c.yandex.net with HTTP; Tue, 29 Aug 2023 20:47:19 +0300 From: Rondat Flyag To: "pgsql-performance@lists.postgresql.org" Subject: Queries containing ORDER BY and LIMIT started to work slowly MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Tue, 29 Aug 2023 20:47:19 +0300 Message-Id: <32431693330715@mail.yandex.ru> Content-Type: multipart/mixed; boundary="----==--bound.1394.2nmvwtstv3l3allg.iva.yp-c.yandex.net" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------==--bound.1394.2nmvwtstv3l3allg.iva.yp-c.yandex.net Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 PGRpdj5JIGhhdmUgYSBsZWdhY3kgc3lzdGVtIHRoYXQgdXNlcyBgUG9zZ3Jlc3FsIDkuNmAgYW5k IGBVYnVudHUgMTYuMDRgLiBFdmVyeXRoaW5nIHdhcyBmaW5lIHNldmVyYWwgZGF5cyBhZ28gZXZl biB3aXRoIHN0YW5kYXJkIFBvc3RncmVzcWwgc2V0dGluZ3MuIEkgZHVtcGVkIGEgZGF0YWJhc2Ug d2l0aCB0aGUgY29tcHJlc3Npb24gb3B0aW9uIChtYXhpbXVtIGNvbXByZXNzaW9uIGxldmVsIC1a IDkpIGluIG9yZGVyIHRvIGhhdmUgYSBzbWFsbGVyIHNpemUgKGBwZ19kdW1wIC0tY29tcHJlc3M9 OSBkYXRhYmFzZV9uYW1lICZndDsgZGF0YWJhc2VfbmFtZS5zcWxgKS4gQWZ0ZXIgdGhhdCBJIGdv dCBhIGxvdCBvZiBwcm9ibGVtcy4gU29tZSBxdWVyaWVzIGZvciBjZXJ0YWluIHRhYmxlcyBzdGFy dGVkIHRvIGJlIGV4ZWN1dGVkIHZlcnkgc2xvdy4gUXVlcmllcyBmb3Igb3RoZXIgdGFibGVzIHdv cmsgZmluZS48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5IZXJlIGFyZSB0aGUgdGFibGVzIHRoYXQg SSBoYXZlIGlzc3VlcyB3aXRoLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7C oCDCoCBhc2luczo8L2Rpdj48ZGl2PsKgIMKgIGlkIChpbnRlZ2VyKTwvZGl2PjxkaXY+wqAgwqAg dmFsdWUgKHN0cmluZyksIGluZGV4IGItdHJlZTwvZGl2PjxkaXY+wqAgwqAgdHlwZSAoc3RyaW5n KTwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgwqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoCDC oCBib29rczo8L2Rpdj48ZGl2PsKgIMKgIGlkIChpbnRlZ2VyKTwvZGl2PjxkaXY+wqAgwqAgYXNp biAoc3RyaW5nKSwgaW5kZXggYi10cmVlPC9kaXY+PGRpdj7CoCDCoCAuLi48L2Rpdj48ZGl2PsKg IMKgICh0b3RhbCAzMiBjb2x1bW5zKTwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRp dj7CoDwvZGl2PjxkaXY+wqAgwqAgYXNpbnNfc3RhdGlzdGljczo8L2Rpdj48ZGl2PsKgIMKgIGlk IChpbnRlZ2VyKTwvZGl2PjxkaXY+wqAgwqAgYXZlcmFnZV9wcmljZSAoZmxvYXQpPC9kaXY+PGRp dj7CoCDCoCBhdmVyYWdlX3JhdGluZyAoaW50ZWdlcik8L2Rpdj48ZGl2PsKgIMKgIGFzaW5faWQg KGZvcmVpZ24ga2V5KTwvZGl2PjxkaXY+wqAgwqAgLi4uPC9kaXY+PGRpdj7CoCDCoCAodG90YWwg MTcgY29sdW1ucyk8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5UaGVzZSB0YWJsZXMgY29udGFpbiAx IDQwMCAwMDAgcm93cyBlYWNoLiBEZXRhaWxlZCBpbmZvIGluIGF0dGFjaG1lbnRzLjwvZGl2Pjxk aXY+wqA8L2Rpdj48ZGl2PkJhc2ljYWxseSBJIHVzZWQgdGhlIGZvbGxvd2luZyBxdWVyeSBhbmQg aXQgd29ya2VkIHdlbGw6PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgIMKg ICgxKSBTRUxFQ1QgKiBGUk9NIElTQk5TIEpPSU4gQk9PS1MgT04gQk9PS1MuSVNCTiA9IElTQk4u VkFMVUUgSk9JTiBJU0JOU19TVEFUSVNUSUNTIE9OIElTQk5TX1NUQVRJU1RJQ1MuSVNCTl9JRCA9 IElTQk5TLklEIE9SREVSIEJZIElTQk5TLlZBTFVFIExJTUlUIDEwMDs8L2Rpdj48ZGl2PsKgPC9k aXY+PGRpdj7CoDwvZGl2PjxkaXY+QnV0IGFmdGVyIEkgbWFkZSB0aGUgZHVtcCBpdCBzdGFydGVk IHRvIGJlIGV4ZWN1dGVkIGV4dHJlbWVseSBzbG93LiBJJ20gbm90IHN1cmUgd2hldGhlciBpdCdz IGJlY2F1c2Ugb2YgdGhlIGR1bXAsIGJ1dCBiZWZvcmUgdGhlIGR1bXAgZXZlcnl0aGluZyB3b3Jr ZWQgd2VsbC4gVGhpcyBxdWVyeSBhbHNvIHdvcmtzIHdlbGw6PC9kaXY+PGRpdj7CoDwvZGl2Pjxk aXY+wqA8L2Rpdj48ZGl2PsKgIMKgIFNFTEVDVCAqIEZST00gSVNCTlMgSk9JTiBCT09LUyBPTiBC T09LUy5JU0JOID0gSVNCTi5WQUxVRSBKT0lOIElTQk5TX1NUQVRJU1RJQ1MgT04gSVNCTlNfU1RB VElTVElDUy5JU0JOX0lEID0gSVNCTlMuSUQgTElNSVQgMTAwOzwvZGl2PjxkaXY+wqA8L2Rpdj48 ZGl2PlRoaXMgcXVlcnkgaXMgZXhlY3V0ZWQgcXVpY2tseSB0b286PC9kaXY+PGRpdj7CoDwvZGl2 PjxkaXY+wqAgwqAgU0VMRUNUICogRlJPTSBJU0JOUyBKT0lOIEJPT0tTIE9OIEJPT0tTLklTQk4g PSBJU0JOLlZBTFVFIE9SREVSIEJZIElTQk5TLlZBTFVFIExJTUlUIDEwMDs8L2Rpdj48ZGl2PsKg PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SSBjaGFuZ2VkIHBlcmZvcm1hbmNlIHNldHRpbmdzIChm b3IgaW5zdGFuY2UsIGluY3JlYXNlZCBgc2hhcmVkX2J1ZmZlcmApLCBidXQgaXQgZGlkbid0IGlu Y3JlYXNlIHNwZWVkIHRvbyBtdWNoLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkkndmUgcmVhZCB0 aGF0IHF1ZXJpZXMgY29udGFpbmluZyBMSU1JVCBhbmQgT1JERVIgQlkgd29yayB2ZXJ5IHNsb3cs IGJ1dCBpZiBJIG1ha2Ugc3VjaCBxdWVyaWVzIHRvIG90aGVyIHRhYmxlcyBpdCB3b3JrcyBmaW5l LjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlRoZSBxdWVyeSBwbGFuIGZvciBxdWVyeSAoMSkgaXMg aW4gYXR0YWNobWVudC48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5TbywgdGhlIHF1ZXN0aW9ucyBh cmU6PC9kaXY+PGRpdj4xLiBXaHkgZXZlcnl0aGluZyB3b3JrZWQgd2VsbCBhbmQgc3RhcnRlZCB0 byB3b3JrIHNsb3dseT88L2Rpdj48ZGl2PjIuIFdoeSBzaW1pbGFyIHF1ZXJpZXMgdG8gb3RoZXIg dGFibGVzIGFyZSBzdGlsbCBleGVjdXRlZCBxdWlja2x5PzwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2 PlRoYW5rIHlvdSBpbiBhZHZhbmNlLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkNoZWVycyw8L2Rp dj48ZGl2PlNlcmc8L2Rpdj48ZGl2PsKgPC9kaXY+ ------==--bound.1394.2nmvwtstv3l3allg.iva.yp-c.yandex.net Content-Disposition: attachment; filename="asins_statistics_schema.txt" Content-Transfer-Encoding: base64 Content-Type: text/plain; name="asins_statistics_schema.txt" ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMu YXNpbnNfc3RhdGlzdGljcyINCiAgICAgICAgQ29sdW1uICAgICAgICAgfCAgICAgICAgICAgIFR5 cGUgICAgICAgICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAgICAgIE1vZGlmaWVycyAgICAg ICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogaWQgICAgICAgICAgICAgICAgICAgIHwgaW50 ZWdlciAgICAgICAgICAgICAgICAgICAgIHwgbm90IG51bGwgZGVmYXVsdCBuZXh0dmFsKCdhc2lu c19zdGF0aXN0aWNzX2lkX3NlcSc6OnJlZ2NsYXNzKQ0KIGF2ZXJhZ2VfY29zdF9hbWF6b24gICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIGF2ZXJhZ2VfcHJpY2VfbmV3ICAgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIHF1YW50aXR5X3NvbGRfbmV3ICAgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIHF1YW50aXR5X2luX3RyYW5zaXQgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIHF1YW50aXR5X3ByZXNlbnRfbmV3ICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIHJhbmtzX3RoaXJ0eSAgICAgICAgICB8 IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8IA0KIHJhbmtzX25pbmV0eSAgICAgICAgICB8 IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8IA0KIGF2ZXJhZ2VfcHJvZml0X25ldyAgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIGF2ZXJhZ2Vfcm9pX25ldyAgICAgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIGF2ZXJhZ2Vfc2VsbGluZ190aW1lICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIGFzaW5faWQgICAgICAgICAgICAgICB8 IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8IA0KIGF2ZXJhZ2VfY29zdF9hb2IgICAgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIGxhc3Rfc29sZCAgICAgICAgICAgICB8 IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8IA0KIGF2ZXJhZ2VfcHJpY2VfdXNlZCAgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KIHF1YW50aXR5X3NvbGRfdXNlZCAgICB8 IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8IA0KIHF1YW50aXR5X3ByZXNlbnRfdXNlZCB8 IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8IA0KIGF2ZXJhZ2VfcHJvZml0X3VzZWQgICB8 IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IA0KSW5kZXhlczoNCiAgICAiYXNpbnNfc3Rh dGlzdGljc19wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlkKQ0KRm9yZWlnbi1rZXkgY29uc3Ry YWludHM6DQogICAgImFzaW5zX3N0YXRpc3RpY3NfYXNpbl9pZF9ma2V5IiBGT1JFSUdOIEtFWSAo YXNpbl9pZCkgUkVGRVJFTkNFUyBhc2lucyhpZCkgT04gREVMRVRFIENBU0NBREUNCg0K ------==--bound.1394.2nmvwtstv3l3allg.iva.yp-c.yandex.net Content-Disposition: attachment; filename="books_schema.txt" Content-Transfer-Encoding: base64 Content-Type: text/plain; name="books_schema.txt" ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJs ZSAicHVibGljLmJvb2tzIg0KICAgICAgICAgICAgICAgICAgIENvbHVtbiAgICAgICAgICAgICAg ICAgICB8ICAgICAgICAgICAgVHlwZSAgICAgICAgICAgICB8ICAgICAgICAgICAgICAgICAgICAg TW9kaWZpZXJzICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIGlkICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IGludGVnZXIgICAgICAgICAgICAg ICAgICAgICB8IG5vdCBudWxsIGRlZmF1bHQgbmV4dHZhbCgnYm9va3NfaWRfc2VxJzo6cmVnY2xh c3MpDQogbGluayAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgY2hhcmFj dGVyIHZhcnlpbmcoMzAwKSAgICAgIHwgDQogYXNpbiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcoNjApICAgICAgIHwgDQogdGl0bGUgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcoNDAw KSAgICAgIHwgDQogaXNibiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwg Y2hhcmFjdGVyIHZhcnlpbmcoNTApICAgICAgIHwgDQogbmV3ZXJfZWRpdGlvbl9hdmFpbGFibGUg ICAgICAgICAgICAgICAgICAgIHwgYm9vbGVhbiAgICAgICAgICAgICAgICAgICAgIHwgDQogbmV3 ZXJfZWRpdGlvbl9saW5rICAgICAgICAgICAgICAgICAgICAgICAgIHwgY2hhcmFjdGVyIHZhcnlp bmcoMTUwKSAgICAgIHwgDQogY292ZXJfdHlwZSAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcoMTAwKSAgICAgIHwgDQogYmxvY2tfdW50aWwgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIHwgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6b25lIHwg DQogbGF0ZXN0X3RyYWRlX2luX2F2YWlsYWJsZSAgICAgICAgICAgICAgICAgIHwgYm9vbGVhbiAg ICAgICAgICAgICAgICAgICAgIHwgDQogbGF0ZXN0X3RyYWRlX2luX3ByaWNlICAgICAgICAgICAg ICAgICAgICAgIHwgZG91YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgDQogbGF0ZXN0X3Jhbmsg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgYmlnaW50ICAgICAgICAgICAgICAgICAg ICAgIHwgDQogbGF0ZXN0X3Byb2ZpdF9saWtlX25ldyAgICAgICAgICAgICAgICAgICAgIHwgZG91 YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgDQogbGF0ZXN0X3Byb2ZpdF92ZXJ5X2dvb2QgICAg ICAgICAgICAgICAgICAgIHwgZG91YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgDQogbGF0ZXN0 X3Byb2ZpdF9yYXRpbyAgICAgICAgICAgICAgICAgICAgICAgIHwgZG91YmxlIHByZWNpc2lvbiAg ICAgICAgICAgIHwgDQogbGF0ZXN0X3Byb2ZpdF90cmFkZV9pbiAgICAgICAgICAgICAgICAgICAg IHwgZG91YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgDQogY2F0ZWdvcnlfaWQgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIHwgaW50ZWdlciAgICAgICAgICAgICAgICAgICAgIHwgDQog YW9iX3VzZXJuYW1lICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgY2hhcmFjdGVyIHZh cnlpbmcoMjUwKSAgICAgIHwgDQogbGF0ZXN0X21pbmltdW1fcHJpY2UgICAgICAgICAgICAgICAg ICAgICAgIHwgZG91YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgDQogbGF0ZXN0X21pbmltdW1f c2hpcHBpbmcgICAgICAgICAgICAgICAgICAgIHwgZG91YmxlIHByZWNpc2lvbiAgICAgICAgICAg IHwgDQogYnNyICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgaW50ZWdl ciAgICAgICAgICAgICAgICAgICAgIHwgZGVmYXVsdCAxMDAwDQogcXVhbnRpdHlfaW5fdHJhbnNp dCAgICAgICAgICAgICAgICAgICAgICAgIHwgaW50ZWdlciAgICAgICAgICAgICAgICAgICAgIHwg ZGVmYXVsdCAwDQogbGF0ZXN0X21pbmltdW1fcHJpY2VfbGlrZV9uZXcgICAgICAgICAgICAgIHwg ZG91YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgZGVmYXVsdCAnMTAwMDAwMCc6OmRvdWJsZSBw cmVjaXNpb24NCiBsYXRlc3RfbWluaW11bV9wcmljZV92ZXJ5X2dvb2QgICAgICAgICAgICAgfCBk b3VibGUgcHJlY2lzaW9uICAgICAgICAgICAgfCBkZWZhdWx0ICcxMDAwMDAwJzo6ZG91YmxlIHBy ZWNpc2lvbg0KIGxhdGVzdF9taW5pbXVtX3NoaXBwaW5nX2xpa2VfbmV3ICAgICAgICAgICB8IGRv dWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8IGRlZmF1bHQgJzEwMDAwMDAnOjpkb3VibGUgcHJl Y2lzaW9uDQogbGF0ZXN0X21pbmltdW1fc2hpcHBpbmdfdmVyeV9nb29kICAgICAgICAgIHwgZG91 YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgZGVmYXVsdCAnMTAwMDAwMCc6OmRvdWJsZSBwcmVj aXNpb24NCiB0b3RhbF9taW5pbXVtX3ByaWNlX2FuZF9zaGlwcGluZyAgICAgICAgICAgfCBkb3Vi bGUgcHJlY2lzaW9uICAgICAgICAgICAgfCANCiByZWNlbnRfbWluaW11bV9wcmljZV9hbmRfc2hp cHBpbmcgICAgICAgICAgfCBkb3VibGUgcHJlY2lzaW9uICAgICAgICAgICAgfCANCiBzZXZlbnR5 X2ZpdmVfcGVyY2VudGlsZV9wcmljZV9hbmRfc2hpcHBpbmcgfCBkb3VibGUgcHJlY2lzaW9uICAg ICAgICAgICAgfCANCiBic3Jfc3RyICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg fCBjaGFyYWN0ZXIgdmFyeWluZyg1MCkgICAgICAgfCANCiBic3JfaWQgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgfCBpbnRlZ2VyICAgICAgICAgICAgICAgICAgICAgfCANCiBs YXRlc3RfcHJvZml0X3JhdGlvX2xpa2VfbmV3ICAgICAgICAgICAgICAgfCBkb3VibGUgcHJlY2lz aW9uICAgICAgICAgICAgfCANCiBsYXRlc3RfcHJvZml0X3JhdGlvX3ZlcnlfZ29vZCAgICAgICAg ICAgICAgfCBkb3VibGUgcHJlY2lzaW9uICAgICAgICAgICAgfCANCkluZGV4ZXM6DQogICAgImJv b2tzX3BrZXkiIFBSSU1BUlkgS0VZLCBidHJlZSAoaWQpDQogICAgImJvb2tzX2FzaW5fa2V5IiBV TklRVUUgQ09OU1RSQUlOVCwgYnRyZWUgKGFzaW4pDQogICAgImJvb2tzX2lzYm5fa2V5IiBVTklR VUUgQ09OU1RSQUlOVCwgYnRyZWUgKGlzYm4pDQogICAgImJvb2tzX2xpbmtfa2V5IiBVTklRVUUg Q09OU1RSQUlOVCwgYnRyZWUgKGxpbmspDQogICAgImluZGV4X2FzaW5fYm9va3MiIGJ0cmVlIChh c2luKQ0KICAgICJpbmRleF9pc2JuX2Jvb2tzIiBidHJlZSAoaXNibikNCiAgICAiaW5kZXhfbGF0 ZXN0X3JhbmtfYm9va3MiIGJ0cmVlIChsYXRlc3RfcmFuaykNCiAgICAiaW5kZXhfdGl0bGVfYm9v a3MiIGJ0cmVlICh0aXRsZSkNCg0K ------==--bound.1394.2nmvwtstv3l3allg.iva.yp-c.yandex.net Content-Disposition: attachment; filename="asins_schema.txt" Content-Transfer-Encoding: base64 Content-Type: text/plain; name="asins_schema.txt" ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMuYXNpbnMi CiAgICAgIENvbHVtbiAgICAgIHwgICAgICAgICBUeXBlICAgICAgICAgIHwgICAgICAgICAgICAg ICAgICAgICBNb2RpZmllcnMgICAgICAgICAgICAgICAgICAgICAgCi0tLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tCiBpZCAgICAgICAgICAgICAgIHwgaW50ZWdlciAgICAgICAg ICAgICAgIHwgbm90IG51bGwgZGVmYXVsdCBuZXh0dmFsKCdpc2Juc19pZF9zZXEnOjpyZWdjbGFz cykKIHZhbHVlICAgICAgICAgICAgfCBjaGFyYWN0ZXIgdmFyeWluZyg1MCkgfCAKIHJhbmtfdHlw ZSAgICAgICAgfCBwb3B1bGFyaXR5dHlwZWVudW0gICAgfCAKIHNlbGxfY29uc3RyYWludHMgfCBj aGFyYWN0ZXIgdmFyeWluZyg1MCkgfCAKIGlzYm5fdGhpcnRlZW4gICAgfCBjaGFyYWN0ZXIgdmFy eWluZygyMCkgfCAKSW5kZXhlczoKICAgICJpc2Juc19wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUg KGlkKQogICAgImlzYm5zX3ZhbHVlX2tleSIgVU5JUVVFIENPTlNUUkFJTlQsIGJ0cmVlICh2YWx1 ZSkKICAgICJpbmRleF92YWx1ZV9hc2lucyIgYnRyZWUgKHZhbHVlKQpSZWZlcmVuY2VkIGJ5Ogog ICAgVEFCTEUgImFzaW5zX3N0YXRpc3RpY3MiIENPTlNUUkFJTlQgImFzaW5zX3N0YXRpc3RpY3Nf YXNpbl9pZF9ma2V5IiBGT1JFSUdOIEtFWSAoYXNpbl9pZCkgUkVGRVJFTkNFUyBhc2lucyhpZCkg T04gREVMRVRFIENBU0NBREUKICAgIFRBQkxFICJib29rc190b19yZXBsZW5pc2giIENPTlNUUkFJ TlQgImJvb2tzX3RvX3JlcGxlbmlzaF9hc2luX2lkX2ZrZXkiIEZPUkVJR04gS0VZIChhc2luX2lk KSBSRUZFUkVOQ0VTIGFzaW5zKGlkKSBPTiBERUxFVEUgQ0FTQ0FERQogICAgVEFCTEUgImludmVu dG9yeV9pdGVtIiBDT05TVFJBSU5UICJpbnZlbnRvcnlfaXRlbV9hc2luX2lkX2ZrZXkiIEZPUkVJ R04gS0VZIChhc2luX2lkKSBSRUZFUkVOQ0VTIGFzaW5zKGlkKSBPTiBERUxFVEUgQ0FTQ0FERQog ICAgVEFCTEUgImludmVudG9yeV9pdGVtcyIgQ09OU1RSQUlOVCAiaW52ZW50b3J5X2l0ZW1zX2Fz aW5faWRfZmtleSIgRk9SRUlHTiBLRVkgKGFzaW5faWQpIFJFRkVSRU5DRVMgYXNpbnMoaWQpIE9O IERFTEVURSBDQVNDQURFCiAgICBUQUJMRSAib3JkZXJzX29uX2FtYXpvbiIgQ09OU1RSQUlOVCAi b3JkZXJzX29uX2FtYXpvbl9hc2luX2lkX2ZrZXkiIEZPUkVJR04gS0VZIChhc2luX2lkKSBSRUZF UkVOQ0VTIGFzaW5zKGlkKSBPTiBERUxFVEUgQ0FTQ0FERQogICAgVEFCTEUgIm9yZGVyc19vbl9h bWF6b25fc29sZCIgQ09OU1RSQUlOVCAib3JkZXJzX29uX2FtYXpvbl9zb2xkX2FzaW5faWRfZmtl eSIgRk9SRUlHTiBLRVkgKGFzaW5faWQpIFJFRkVSRU5DRVMgYXNpbnMoaWQpIE9OIERFTEVURSBD QVNDQURFCgo= ------==--bound.1394.2nmvwtstv3l3allg.iva.yp-c.yandex.net Content-Disposition: attachment; filename="query_plan.txt" Content-Transfer-Encoding: base64 Content-Type: text/plain; name="query_plan.txt" ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgIC0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KICAgICBMaW1pdCAgKGNvc3Q9 MTA0ODM3OS4zNy4uMTA0ODQyOC4zMyByb3dzPTEwMCB3aWR0aD00OTgpIChhY3R1YWwgdGltZT01 MjY0LjE5My4uNTI2NC40NDQgcm93cz0xMDAgbG9vcHM9MSkKICAgICAgIEJ1ZmZlcnM6IHNoYXJl ZCBoaXQ9NDAyNTAgcmVhZD0zMzI0NzIsIHRlbXAgcmVhZD0xNjY5OSB3cml0dGVuPTI4MzkyCiAg ICAgICAtPiAgTWVyZ2UgSm9pbiAgKGNvc3Q9MTA0ODM3OS4zNy4uMjI5MTU1Ny41MSByb3dzPTI1 MzkzNjAgd2lkdGg9NDk4KSAoYWN0dWFsIHRpbWU9NTI2NC4xOTEuLjUyNjQuNDM2IHJvd3M9MTAw IGxvb3BzPTEpCiAgICAgICAgICAgICBNZXJnZSBDb25kOiAoKGJvb2tzLmlzYm4pOjp0ZXh0ID0g KGlzYm5zLnZhbHVlKTo6dGV4dCkKICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NDAy NTAgcmVhZD0zMzI0NzIsIHRlbXAgcmVhZD0xNjY5OSB3cml0dGVuPTI4MzkyCiAgICAgICAgICAg ICAtPiAgSW5kZXggU2NhbiB1c2luZyBib29rc19pc2JuX2tleSBvbiBib29rcyAgKGNvc3Q9MC40 My4uMTIwNTQ5NC44OCByb3dzPTEzODYxMTQgd2lkdGg9MzMzKSAoYWN0dWFsIHRpbWU9MC4wMjAu LjAuMTUwIHJvd3M9MTAwIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFy ZWQgaGl0PTEwMwogICAgICAgICAgICAgLT4gIE1hdGVyaWFsaXplICAoY29zdD0xMDQyMzMzLjc3 Li4xMDU1MTk5Ljc1IHJvd3M9MjU3MzE5NyB3aWR0aD0xNTUpIChhY3R1YWwgdGltZT01MjYzLjkw MS4uNTI2My45NjAgcm93cz0xMDAgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6 IHNoYXJlZCBoaXQ9NDAxNDcgcmVhZD0zMzI0NzIsIHRlbXAgcmVhZD0xNjY5OSB3cml0dGVuPTI4 MzkyCiAgICAgICAgICAgICAgICAgICAtPiAgU29ydCAgKGNvc3Q9MTA0MjMzMy43Ny4uMTA0ODc2 Ni43NiByb3dzPTI1NzMxOTcgd2lkdGg9MTU1KSAoYWN0dWFsIHRpbWU9NTI2My44OTUuLjUyNjMu OTQ5IHJvd3M9MTAwIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICBTb3J0IEtleTog aXNibnMudmFsdWUKICAgICAgICAgICAgICAgICAgICAgICAgIFNvcnQgTWV0aG9kOiBleHRlcm5h bCBtZXJnZSAgRGlzazogMTM2ODY0a0IKICAgICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6 IHNoYXJlZCBoaXQ9NDAxNDcgcmVhZD0zMzI0NzIsIHRlbXAgcmVhZD0xNjY5OSB3cml0dGVuPTI4 MzkyCiAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD01NTczNC4x NC4uNTY2MDYxLjQ0IHJvd3M9MjU3MzE5NyB3aWR0aD0xNTUpIChhY3R1YWwgdGltZT00MDMuOTYy Li4xOTk0Ljg4NCByb3dzPTE0MDQ1ODIgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIEhhc2ggQ29uZDogKGlzYm5zX3N0YXRpc3RpY3MuaXNibl9pZCA9IGlzYm5zLmlkKQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD00MDE0NyBy ZWFkPTMzMjQ3MiwgdGVtcCByZWFkPTExMjgxIHdyaXR0ZW49MTEyNzkKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBpc2Juc19zdGF0aXN0aWNzICAoY29zdD0w LjAwLi4zODUxOTMuOTcgcm93cz0yNTczMTk3IHdpZHRoPTEyMCkgKGFjdHVhbCB0aW1lPTAuMDI0 Li43NzkuNzE3IHJvd3M9MTQwNDU4MiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD0yNjk5MCByZWFkPTMzMjQ3MgogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggIChjb3N0PTI3MjAyLjg0Li4yNzIwMi44 NCByb3dzPTE0MDQ1ODQgd2lkdGg9MzUpIChhY3R1YWwgdGltZT00MDIuNDMxLi40MDIuNDMxIHJv d3M9MTQwNDU4NCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg QnVja2V0czogMTA0ODU3NiAgQmF0Y2hlczogMiAgTWVtb3J5IFVzYWdlOiA1MTM5M2tCCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTEzMTU3 LCB0ZW1wIHdyaXR0ZW49NDM2MwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg LT4gIFNlcSBTY2FuIG9uIGlzYm5zICAoY29zdD0wLjAwLi4yNzIwMi44NCByb3dzPTE0MDQ1ODQg d2lkdGg9MzUpIChhY3R1YWwgdGltZT0wLjAyNy4uMTUyLjU2OCByb3dzPTE0MDQ1ODQgbG9vcHM9 MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNo YXJlZCBoaXQ9MTMxNTcKICAgICBQbGFubmluZyB0aW1lOiAxLjE2MCBtcwogICAgIEV4ZWN1dGlv biB0aW1lOiA1Mjc5Ljk4MyBtcwogICAgKDI1IHJvd3MpCgo= ------==--bound.1394.2nmvwtstv3l3allg.iva.yp-c.yandex.net--