How to view connection and SQL execution information in postgresql

Question

235 views17/04/2023PostgreSQL

0

Amen1.09K 14/04/2023 0 Comments

How to view connection and SQL execution information in postgresql? SQL scripts to query connection and SQL execution information in postgresql?

Ezana Answered question 17/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-17T15:25:43+00:00

To query the connected users and their clients:

SELECT datname,usename,client_addr,client_port FROM pg_stat_activity

And to Query the SQL execution information:

SELECT datname,usename,query FROM pg_stat_activity ;