Re: Running update in chunks? - Mailing list pgsql-general

From Tim Uckun
Subject Re: Running update in chunks?
Date
Msg-id CAGuHJrNKFjrEuq7LXbLSj8tJ+Ur-tQ-=ARjgQtW=3-0K1hGtMA@mail.gmail.com
Whole thread Raw
In response to Re: Running update in chunks?  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: Running update in chunks?  (Jeff Janes <jeff.janes@gmail.com>)
Re: Running update in chunks?  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
I already posted the schema earlier. It's a handful of integer fields
with one hstore field.


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


"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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Yet Another Timestamp Question: Time Defaults
Next
From: "Kevin Grittner"
Date:
Subject: Re: Yet Another Timestamp Question: Time Defaults