[GENERAL] pg query exec time, reports

[Johnny Edge]

Hello folks,
 
I wish to log query execution time on all queries. 
 
Could you please advise re the same? 
 
Could you also suggest report generation tools? I.e. what queries take longest 
time to exec, duration of session, etc.
 
Thanks,
 
-JE