Re: Query is stuck

In response to "Satish Burnwal (sburnwal)" <sburnwal(at)cisco(dot)com>:

> controlsmartdb=# \d repcopy;
> Table "public.repcopy"
> Column | Type | Modifiers
> -----------------+--------------------------------+-----------
> report_id | integer | not null
> dm_ip | character varying(64) |
> dm_mac | character varying(64) |
> dm_user | character varying(255) |
> dm_os | character varying(64) |
> report_time | timestamp(0) without time zone |
> sys_name | character varying(255) |
> sys_user | character varying(255) |
> sys_user_domain | character varying(255) |
> ss_key | character varying(128) |
> login_time | character varying(64) |
> role_id | smallint |
> new_vlan_id | character varying(64) |
> report_status | smallint |
> Indexes:
> "repcopy_pk" PRIMARY KEY, btree (report_id)

Unless you truncated this output, you _really_ need to add some indexes
to this table. Read back through earlier messages in the thread for
suggestions.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/