unable to get data from PSQL local server

I have a psql DB that connect with the Database tool box and show the table. However, the data cannot be exported to tables as the data is too big. I have 16 GB RAM and i7 processor quad core and still not bale to fix this. If I want to limit the data by applying the filters before import. The data still runs the query and never completes.

How to optimize my pull of data to a table. The data is mix of strings and numerical so I think structure should be output.But I am not able to reach the stage of getting the data in any format.