can any tweaks improve full table scan time in Postgres/Cloud SQL?
Obviously faster storage and more RAM for caching can improve performance of a sequential scan.
Other than that, you can increase max_parallel_workers_per_gather on recent PostgreSQL versions to have more processes work on the query. That reduces the execution time at the expense of more load on the database.