stats reset during pg_restore?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This did not have any takers in pgsql-general. Maybe
performance-oriented folks can shed light? The basic question is if
there is a way to preserve stats during pg_restore?


-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of George Pavlov
Sent: Monday, August 21, 2006 3:15 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: [GENERAL] stats reset during pg_restore?

I would like to analyze server stats offline, so I attempt to pg_dump my
production database and then pg_restore it into another database. In the
process all stats seem to be reset (they are not completely zeroed). So
in production I have a table with the following stats (from
pg_stat_all_tables as an example):

relid         | 25519576
relname       | property_contact
seq_scan      | 5612
seq_tup_read  | 569971320
idx_scan      | 4486454
idx_tup_fetch | 180100369
n_tup_ins     | 39114
n_tup_upd     | 17553
n_tup_del     | 21877

After I restore the stats for the same table look like this:

relid         | 104017313
relname       | property_contact
seq_scan      | 9
seq_tup_read  | 992493
idx_scan      | 0
idx_tup_fetch | 0
n_tup_ins     | 110277
n_tup_upd     | 0
n_tup_del     | 0

These look like stats for table accesses during the restore itself:
11027 is indeed the number of rows in the table, and 992493 / 110277 =
9, which happens to be the number of indexes and FK constraints on the
table.

I do have stats_reset_on_server_start = off on both servers.

Can someone share what exatly happens with stats upon restore? Also is
there anything one can do to keep them intact during a dump/restore? 

Apologies if already discussed--I failed to find any references.

TIA,

George


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux