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