Slow response to my query

Goke Aruna <goksie@gmail.com>

From: Goke Aruna <goksie@gmail.com>
To: pgsql-novice@lists.postgresql.org
Date: 2019-11-28T04:35:44Z
Lists: pgsql-novice
I have a HP DL380 server  g8 with 32GB RAM and 48 *2.5Ghz CPU. Running on
CentOS Linux 7.4.

I have a postgresql 12 database. One of my tables has 42 columns and has
about 500million records.
However, any attempt to select even 1 column from the table take hours at
least 1.5hours to respond.

Kindly help on documentation on how to optimize it to return the response
in milliseconds.

Regards