> INFO: "repcopy": scanned 3000 of 4652 pages, containing 128964 live rows
> and 0 dead rows; 3000 rows in sample, 199980 estimated total rows
> VACUUM
> controlsmartdb=# select distinct report_status from repcopy ;
According to the vacuum output, there are about 20 rows in the
"repcopy" tab
I am using 8.1, so waiting coln is not there in pg_stat_activity.
I frequently see these in the server logs:
LOG: autovacuum: processing database "controlsmartdb"
Though I can give you the result of vacuum run (but it is not helping):
controlsmartdb=# vacuum full verbose analyze repcopy;
INFO:
In response to Szymon Guz :
> 2010/4/13 Satish Burnwal (sburnwal)
>
> > I have a query which is not giving me the result even after 30 minutes. I
> > want to know how to detect what is going and what’s wrong ?
> >
> >
> >
> > EXPLAIN query - gives me the following:
> >
> > controlsmartdb=# expl
2010/4/13 Satish Burnwal (sburnwal)
> I have a query which is not giving me the result even after 30 minutes. I
> want to know how to detect what is going and what’s wrong ?
>
>
>
> EXPLAIN query - gives me the following:
>
> controlsmartdb=# explain select report_id, dm_ip, dm_mac, dm_user, dm_
