I have a table with 12 million records. There are indexes on columns col_1 and col_2. I use postgresql 9.3.
I need two types of queries on it. First, some queries with just one condition in where clause, such as:
select count(*)
from table_1
where
col_1 >= 123456;
**explain analyze:**
Aggregate (cost=164523.60 ..164523.61 rows=1 width=0)...