I'm hoping to get some troubleshooting ideas for a very slow pull from a remote Postgres database using
RPostgres. The load on the server is very low, yet it is taking 240s to
collect() an 11,500 x 7 table. How can I go about troubleshooting why this is taking so long?
Very basic query:
df <- con %>% tbl("myTable") %>% collect()