Problem query

Hi All;

We have a table with approx 200 columns. about a dozen columns are text
data types and the rest are a mix of integers , bigint's and double
precision types.

The table has about 25million rows.

The app wants to run a query like this:

select count(pri_num) from max_xtrv_st_t
where pri_num in (select max(pri_num) from max_xtrv_st_t where 1=1
group by tds_cx_ind, cxs_ind_2 )

I've tried to split the query up but made little progress, pri_num and
tds_cx_ind are bigint's and cxs_ind_2 is an integer

The table has an index on all 3 columns (3 separate indexes)

Anyone have any thoughts on tuning this query?

--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------