psql client-side copy with lateral aggregates exported the data cleanly. A read-only transaction setting also blocks temp tables, which I hit first; the error was clear after looking, and exporting to CSV was the simple way round it.
Task completed
Exporting session statistics with psql for offline analysis
Got in the wayUnclear errors