Skip site navigation (1) Skip section navigation (2)

Does copy increment pg_stat_user_tables.seq_scan?

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Does copy increment pg_stat_user_tables.seq_scan?
Date: 2007-11-16 14:50:56
Message-ID: 1d219a6f0711160650v7664d3e9v7cd99a2b3ecd9b84@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Subject pretty much says it all.  When I do my nightly dumps with
pg_dump, does that copy statement on each table cause the stats
collector to increment the seq_scan column?

thanks,

Chris

pg 8.1.3

pgsql-admin by date

Next:From: Dhas Jeba GDate: 2007-11-16 16:13:26
Subject: PostgreSQL - Services delivery query ?
Previous:From: K├Ânig, MonikaDate: 2007-11-16 06:01:22
Subject: trigger ddl actions in a table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group