How can I find out the last query completion time in PostgressSQL?

Question

PostgreSQL

I have logging configured, can I use SELECT or some other way to find out the completion time of the last request and write it to a variable?

Answer 1

We use: SELECT * FROM pg_stat_activity
This table has a query_start column - it stores the time when a certain request was made