Re: Running update in chunks?

On 01/21/2013 05:02 PM, Tim Uckun wrote:
> I already posted the schema earlier. It's a handful of integer fields
> with one hstore field.

Oh well. I can't find it but maybe it got lost in shipping or eaten by a
spam filter.

>
>
> On Tue, Jan 22, 2013 at 1:23 PM, Steve Crawford
> <scrawford@pinpointresearch.com> wrote:
>> select * from pg_stat_user_tables where relname='yourtable';
>
>
> Messy output
Don't know if you are in psql but if so, expanded display works for
this. I.e.:
steve@[local] => \x
Expanded display is on.
steve@[local] => select * from pg_stat_user_tables where relname='footest';
-[ RECORD 1 ]-----+------------------------------
relid             | 781691
schemaname        | public
relname           | footest
seq_scan          | 3
seq_tup_read      | 609
idx_scan          |
idx_tup_fetch     |
n_tup_ins         | 609
n_tup_upd         | 0
n_tup_del         | 0
n_tup_hot_upd     | 0
n_live_tup        | 301
n_dead_tup        | 0
last_vacuum       |
last_autovacuum   |
last_analyze      |
last_autoanalyze  | 2012-12-19 08:42:23.347368-08
vacuum_count      | 0
autovacuum_count  | 0
analyze_count     | 0
autoanalyze_count | 2


>
>
"relid","schemaname","relname","seq_scan","seq_tup_read","idx_scan","idx_tup_fetch","n_tup_ins","n_tup_upd","n_tup_del","n_tup_hot_upd","n_live_tup","n_dead_tup","last_vacuum","last_autovacuum","last_analyze","last_autoanalyze","vacuum_count","autovacuum_count","analyze_count","autoanalyze_count"
> 26710,"chrysler","imports",274,25280539,4,2749,98926,5757462,92,327542,98834,0,"2013-01-22
> 12:28:29.01505+13","2013-01-22 12:32:29.249588+13","2013-01-22
> 12:28:29.173772+13","2013-01-22 12:32:44.123493+13",3,30,3,24
>
>
So at least autovacuum is running (and some manual vacuum and analyze as
well).

Cheers,
Steve