Fwd: postgresql performance question

I create a table by command as listed as below:

And then use command as listed as below to import data to log2 table

My purpose is to import log information to log2 table to analysis, but I found one situation : for example , I have 166856 records in log2 table, when I use select command to list data , it spent a lot time, can we adjust the situation ? 

Thanks for your kindly assistance.

Additional information: The attachment is log format

Best Regards, Anderson Hsu