Re: Query is stuck - Mailing list pgsql-general

In response to "Satish Burnwal (sburnwal)" <sburnwal@cisco.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/