How to Output Slow Query Logs for Aurora (PostgreSQL)

aurorapostdb=> select version();
                                   version
-----------------------------------------------------------------------------
 PostgreSQL 10.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit
(1 row)

log_statement=all # Controls which SQL statements are logged
log_min_duration_statement=0 # Setting to 0 outputs execution time for all statements
log_destination=csvlog # When csvlog is included in log_destination, log entries are output in "comma-separated values" (CSV) format for easier program loading
log_duration=1
log_error_verbosity=verbose # Controls the amount of detail written to the server log for each logged message

show log_statement;
show log_min_duration_statement;
show log_destination;
show log_duration;
show log_error_verbosity;

select count(*) from pg_tables a, pg_stats b, pg_index c, pg_locks d;