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 1lEcoJ-0006sK-AJ for pgsql-admin@arkaria.postgresql.org; Tue, 23 Feb 2021 18:53:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lEcoH-0004AH-Ax for pgsql-admin@arkaria.postgresql.org; Tue, 23 Feb 2021 18:53:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lEcoH-0004AA-1h for pgsql-admin@lists.postgresql.org; Tue, 23 Feb 2021 18:53:25 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lEcoD-0006qC-MS for pgsql-admin@postgresql.org; Tue, 23 Feb 2021 18:53:22 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 2F0B03804AD; Tue, 23 Feb 2021 19:53:18 +0100 (CET) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id N4TsINb9SbID; Tue, 23 Feb 2021 19:53:18 +0100 (CET) Received: from [192.168.178.86] (p5b2450c6.dip0.t-ipconnect.de [91.36.80.198]) by rs.plausibolo.de (Postfix) with ESMTPSA id F075B3800C0; Tue, 23 Feb 2021 19:53:17 +0100 (CET) To: "[PGSQL-ADMIN-LIST]" From: Holger Jakobs Subject: Export and import of statistics data Message-ID: Date: Tue, 23 Feb 2021 19:53:17 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.7.1 MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="QrotXIpXeWRBmpdOaOeo337iSsbagtCyL" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --QrotXIpXeWRBmpdOaOeo337iSsbagtCyL Content-Type: multipart/mixed; boundary="U2R6ANFB9F8BoTpqH3EFNLdGMDYDjVLpt"; protected-headers="v1" From: Holger Jakobs To: "[PGSQL-ADMIN-LIST]" Message-ID: Subject: Export and import of statistics data --U2R6ANFB9F8BoTpqH3EFNLdGMDYDjVLpt Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable Content-Language: de-DE Hi everybody, Is there a way of exporting statistics data from a database cluster=20 containing a lot of rows and import them into a similar structured, but=20 small database cluster. The purpose of this is testing and comparing execution plans on a small=20 machine. Of course executing the statement wouldn't make much sense, so=20 I would use only EXPLAIN, not EXPLAIN ANALYZE. Due to data protection and capacity it's not possible to copy the=20 production database or even access it. Thanks and best regards Holger --=20 Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 --U2R6ANFB9F8BoTpqH3EFNLdGMDYDjVLpt-- --QrotXIpXeWRBmpdOaOeo337iSsbagtCyL Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYDVPHQUDAAAAAAAKCRCKV5yTsxlhuiDc AKDLM1K+Xd9L9sx+wO+4A5jLwxYX5wCgv5rmt7sXj3lqOAqzc9/6XUSzD1E= =iAwW -----END PGP SIGNATURE----- --QrotXIpXeWRBmpdOaOeo337iSsbagtCyL--