Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT usename,pid,client_addr,waiting,query_start,query FROM pg_stat_activity where datname = 'db_nazwa_bazy_ks';

...

No Format
 usename |  pid  | client_addr  | waiting |          query_start          |                                             query                                             
---------+-------+--------------+---------+-------------------------------+----------------------------------------------------------------------------------------------
 sowa    | 30163 | 192.168.1.61 | f       | 2018-03-09 08:59:45.926053+01 | set client_encoding to win1250;                                                              
 sowa    |  4556 | 192.168.1.61 | f       | 2018-03-09 10:22:28.544199+01 | END;
 sowa    |  4558 | 192.168.1.61 | f       | 2018-03-09 10:22:28.264697+01 | SELECT fld_ipub_id FROM tbl_linkage WHERE fld_rec_type = 'U' AND fld_rec_id = '56049' LIMIT 1
 sowa    | 30168 | 192.168.1.61 | f       | 2018-03-09 08:59:47.897656+01 | set client_encoding to win1250;                                                              
 sowa    | 30169 | 192.168.1.61 | f       | 2018-03-09 08:59:47.837634+01 | set client_encoding to win1250;                                                              
 sowa    | 30186 | 192.168.1.61 | f       | 2018-03-09 08:59:55.337295+01 | LISTEN oai_pmh_change
(6 wierszy)

...

Code Block
languagesql
select pg_cancelterminate_backend(4558);