Slow response to my query

--0000000000007a8a46059860a6a2
Content-Type: text/plain; charset="UTF-8"

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

--0000000000007a8a46059860a6a2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">I have a HP DL380 server=C2=A0 g8 with 32GB RAM and 48 *2=
.5Ghz CPU. Running on CentOS Linux 7.4.<div dir=3D"auto"><br></div><div dir=
=3D"auto">I have a postgresql 12 database. One of my tables has 42 columns =
and has about 500million records.</div><div dir=3D"auto">However, any attem=
pt to select even 1 column from the table take hours at least 1.5hours to r=
espond.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Kindly help on d=
ocumentation on how to optimize it to return the response in milliseconds.<=
/div><div dir=3D"auto"><br></div><div dir=3D"auto">Regards</div><div dir=3D=
"auto"><br></div><div dir=3D"auto"><br></div></div>

--0000000000007a8a46059860a6a2--