Catching a postgresql query?

Question

PostgreSQL

There is a software which yuzat a database. There is pgadmin. How to catch a request to the database from the software in order to understand which table is being accessed?

Answer 1

in postgres settings log_statement = 'all'. After that, all requests will be written to the standard log.

Answer 2

Via pgaudit

Answer 3

pgtop

Answer 4

SELECT * FROM pg_stat_activity;