Stranger than fiction...

Sorry for the double, but I just stripped down my query on my status
table and saw some interesting results....

          Table "status"
 Attribute |   Type    | Modifier
-----------+-----------+----------
 site_id   | bigint    | not null
 host_id   | bigint    | not null
 product   | varchar() | not null
 class     | varchar() | not null
 subclass  | varchar() | not null
 status    | varchar() | not null
 msg       | varchar() |
 tstamp    | timestamp |
Indices: status_5_column_index,
         status_host_id_key,
         status_site_id_key

This table currently has 224 rows of data in it.

The following queries *ALL* take approx.  .433 seconds to run.

select * from status s where s.site_id = 18 and s.host_id = 49 and
s.product = 'BETA' and s.class = 'APPS' and s.subclass = 'MONITOR' ;
select * from status s where s.site_id = 18 and s.host_id = 49 and
s.product = 'BETA';
select * from status s where s.site_id = 18 and s.host_id = 49;
select * from status s where s.site_id = 18;
select * from status;

Nothing gets triggered on a select off of this table.  This table did
have a view attached, but I dropped the view with the same results.

So, I'm totally baffled as to how a simple select * on a 224-row table
could take almost half a second to execute!  Please help the neophyte.
=)

Thank you,
Fran