Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bn3I0-000826-V8 for pgsql-performance@arkaria.postgresql.org; Thu, 22 Sep 2016 12:39:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bn3I0-0004vX-ID for pgsql-performance@arkaria.postgresql.org; Thu, 22 Sep 2016 12:39:44 +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 1bn3I0-0004vR-3b for pgsql-performance@postgresql.org; Thu, 22 Sep 2016 12:39:44 +0000 Received: from mail.treubuch-colonia.de ([195.243.249.203] helo=ns.ddd-do.de) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bn3Hs-0001Md-Cw for pgsql-performance@postgresql.org; Thu, 22 Sep 2016 12:39:42 +0000 From: "Knels, Udo" To: "pgsql-performance@postgresql.org" Subject: Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Thread-Topic: [PERFORM] Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Thread-Index: AdH5O1H79waUwOJ+T8+JxfQvcAsxrQbBdU2AACL1roA= Date: Thu, 22 Sep 2016 12:39:30 +0000 Message-ID: References: <1d6ce510f1cf4dfcad73b15ff8ff98a4@EXCH-1.ddd-do.de> <283046e4-a37f-d8cb-85dc-52d1286e8ffb@BlueTreble.com> In-Reply-To: <283046e4-a37f-d8cb-85dc-52d1286e8ffb@BlueTreble.com> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [172.16.1.180] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Hi, I tried the following on the upgraded database: analyze schema_test.table_a; But the result is the same.=20 https://explain.depesz.com/s/hsx5 "Sort (cost=3D5.94..6.01 rows=3D26 width=3D6) (actual time=3D0.199..0.200 = rows=3D3 loops=3D1)" " Sort Key: table_a.col0002" " Sort Method: quicksort Memory: 25kB" " Buffers: shared hit=3D1" " -> HashAggregate (cost=3D5.07..5.33 rows=3D26 width=3D6) (actual time= =3D0.161..0.163 rows=3D3 loops=3D1)" " Group Key: table_a.col0002" " Buffers: shared hit=3D1" " -> Hash Semi Join (cost=3D2.76..4.95 rows=3D50 width=3D6) (actua= l time=3D0.070..0.133 rows=3D26 loops=3D1)" " Hash Cond: ((table_a.col0001)::text =3D (unnest('{5010010000= }'::text[])))" " Buffers: shared hit=3D1" " -> Seq Scan on table_a (cost=3D0.00..1.50 rows=3D50 width= =3D17) (actual time=3D0.015..0.034 rows=3D50 loops=3D1)" " Buffers: shared hit=3D1" " -> Hash (cost=3D1.51..1.51 rows=3D100 width=3D32) (actual = time=3D0.028..0.028 rows=3D1 loops=3D1)" " Buckets: 1024 Batches: 1 Memory Usage: 9kB" " -> Result (cost=3D0.00..0.51 rows=3D100 width=3D0) (= actual time=3D0.015..0.017 rows=3D1 loops=3D1)" "Planning time: 0.653 ms" "Execution time: 0.326 ms" Greetings Udo Knels treubuch IT GmbH --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance