SHARE
TWEET

Untitled

a guest Nov 6th, 2019 113 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [root@server ~]# psql template1
  2. psql (10.10)
  3. Type "help" for help.
  4.  
  5. template1=# select * FROM pg_stat_activity WHERE datname = 'template1';
  6.  datid |  datname  |  pid  | usesysid | usename | application_name | client_addr
  7.  | client_hostname | client_port |         backend_start         |          xact
  8. _start           |          query_start          |         state_change
  9.  | wait_event_type | wait_event | state  | backend_xid | backend_xmin |
  10.                    query                            |  backend_type
  11. -------+-----------+-------+----------+---------+------------------+------------
  12. -+-----------------+-------------+-------------------------------+--------------
  13. -----------------+-------------------------------+------------------------------
  14. -+-----------------+------------+--------+-------------+--------------+---------
  15. ----------------------------------------------------+----------------
  16.      1 | template1 | 22339 |    16384 | root    | psql             |
  17.  |                 |          -1 | 2019-11-06 18:39:16.448349-05 | 2019-11-06 18
  18. :39:43.524548-05 | 2019-11-06 18:39:43.524548-05 | 2019-11-06 18:39:43.524551-05
  19.  |                 |            | active |             |         1603 | select *
  20.  FROM pg_stat_activity WHERE datname = 'template1'; | client backend
  21. (1 row)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top