From: Holger Jakobs <holger@jakobs.com>
To: [PGSQL-ADMIN-LIST] <pgsql-admin@postgresql.org>
Subject: Export and import of statistics data
Date: Tue, 23 Feb 2021 19:53:17 +0100
Message-ID: <b97f9345-e617-e555-a6e9-7b185f2b17e2@jakobs.com> (raw)
Hi everybody,
Is there a way of exporting statistics data from a database cluster
containing a lot of rows and import them into a similar structured, but
small database cluster.
The purpose of this is testing and comparing execution plans on a small
machine. Of course executing the statement wouldn't make much sense, so
I would use only EXPLAIN, not EXPLAIN ANALYZE.
Due to data protection and capacity it's not possible to copy the
production database or even access it.
Thanks and best regards
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com
Subject: Re: Export and import of statistics data
In-Reply-To: <b97f9345-e617-e555-a6e9-7b185f2b17e2@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox