Re. Select with where condition times out

sivapostgres@yahoo.com <sivapostgres@yahoo.com>

From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>

To: Postgresql General Group <pgsql-general@lists.postgresql.org>

Date: 2024-07-18T09:38:22Z

Lists: pgsql-general

Hello,PG V11
Select count(*) from table1Returns 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