Export and import of statistics data

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: "[PGSQL-ADMIN-LIST]" <pgsql-admin(at)postgresql(dot)org>
Subject: Export and import of statistics data
Date: 2021-02-23 18:53:17
Message-ID: b97f9345-e617-e555-a6e9-7b185f2b17e2@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2021-02-23 19:32:30 Re: Export and import of statistics data
Previous Message Yambu 2021-02-23 08:14:10 hostssl for replica server