Re. Select with where condition times out

["sivapostgres@xxxxxxxxx" <sivapostgres@xxxxxxxxx>]

Hello,

PG V11

Select count(*) from table1

Returns 10456432

Select field1, field2 from table1 where field3> '2024-07-18 12:00:00' 

Times out

The above query was working fine for the past 2 years.  

Backup was taken a day back.  Need to recover complete data as far as possible.

Any possible way(s) to do this?

BKR Sivaprakash 

Yahoo Mail: Search, organise, conquer