PG 10.5 I loaded 133 million rows to a wide table (more than 100 cols) via COPY. The table has no index at this time. Since I am the only user I don't see any other activity. Now when I run select count(*) on the table where I just loaded data, it runs for ever, more than 10min and still running. Intrigued, I checked locks and saw nothing. Then I noticed something strange. When select count(*) runs, PG is writing to wal_logs, and that too a large amount. Why? I suspect vaccum is getting triggered, but this is a brand new table with no updates. So it should not.
Is there a SQL to peek into what PG is doing to write so much to WAL logs ?