[root@server ~]# psql template1
psql (10.10)
Type "help" for help.

template1=# select * FROM pg_stat_activity WHERE datname = 'template1';
 datid |  datname  |  pid  | usesysid | usename | application_name | client_addr
 | client_hostname | client_port |         backend_start         |          xact
_start           |          query_start          |         state_change
 | wait_event_type | wait_event | state  | backend_xid | backend_xmin |
                   query                            |  backend_type
-------+-----------+-------+----------+---------+------------------+------------
-+-----------------+-------------+-------------------------------+--------------
-----------------+-------------------------------+------------------------------
-+-----------------+------------+--------+-------------+--------------+---------
----------------------------------------------------+----------------
     1 | template1 | 22339 |    16384 | root    | psql             |
 |                 |          -1 | 2019-11-06 18:39:16.448349-05 | 2019-11-06 18
:39:43.524548-05 | 2019-11-06 18:39:43.524548-05 | 2019-11-06 18:39:43.524551-05
 |                 |            | active |             |         1603 | select *
 FROM pg_stat_activity WHERE datname = 'template1'; | client backend
(1 row)