datid | procpid | usesysid | application_name | current_query | waiting | xact_start | query_start | backend_start | client_addr | client_hostname | client_port |
---|---|---|---|---|---|---|---|---|---|---|---|
11919 | 25581 | 16384 | psql | SELECT * FROM pg_stat_get_activity(NULL::integer); | f | 2013-11-02 00:54:58.413595+01 | 2013-11-02 00:54:58.413595+01 | 2013-11-02 00:36:32.898456+01 | -1 | ||
11919 | 26050 | 16384 | psql | <IDLE> | f | 2013-11-02 00:43:18.00825+01 | 2013-11-02 00:43:17.159333+01 | -1 | |||
11919 | 26068 | 16384 | <IDLE> | f | 2013-11-02 00:43:35.423728+01 | 2013-11-02 00:43:34.305488+01 | -1 | ||||
131765 | 26087 | 131766 | <IDLE> | f | 2013-11-02 00:43:35.391947+01 | 2013-11-02 00:43:35.345341+01 | ::1 | 44298 |
(4 rows)
datname | datdba | encoding | datcollate | datctype | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | dattablespace | datacl |
---|---|---|---|---|---|---|---|---|---|---|---|
template0 | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | t | f | -1 | 11911 | 670 | 1663 | {=c/postgres,postgres=CTc/postgres} |
postgres | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 1663 | |
zlotkadry2013 | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 1663 | |
tmp | 38506 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 1663 | |
test | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 1663 | |
template1 | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | t | t | -1 | 11911 | 670 | 17021 | {=c/postgres,postgres=CTc/postgres} |
test2 | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
hajmondb | 18636 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
hajmon_django | 18638 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
hajmondb_new | 18636 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
lista_kudryckiej | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
efizyka | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
cc2865ec-750f-424b-957b-47d8f5779afa | 123573 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
f143740c-f4f1-4578-8d59-498e532614e6 | 123580 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | {"=T/\"f143740c-f4f1-4578-8d59-498e532614e6\"","\"f143740c-f4f1-4578-8d59-498e532614e6\"=CTc/\"f143740c-f4f1-4578-8d59-498e532614e6\""} |
27962084-95c4-4567-af10-b7546ddcfced | 123623 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | {"=T/\"27962084-95c4-4567-af10-b7546ddcfced\"","\"27962084-95c4-4567-af10-b7546ddcfced\"=CTc/\"27962084-95c4-4567-af10-b7546ddcfced\""} |
9af36345-1d13-4681-a221-5a5099587854 | 123675 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | {"=T/\"9af36345-1d13-4681-a221-5a5099587854\"","\"9af36345-1d13-4681-a221-5a5099587854\"=CTc/\"9af36345-1d13-4681-a221-5a5099587854\""} |
drop-me555dd77d-4db2-4a25-b0ad-e7bd2cf8d2d5 | 123718 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
drop-meb17bdacb-2771-4894-9f99-964a83ca5c9c | 123761 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
drop-medc0303b6-6332-4e01-88d8-a8218f033344 | 123804 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
drop-mea9edb83a-c3f1-454a-b52d-ef181a9db8c2 | 123847 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 | |
drop-me7e2b9b29-12ae-43f9-94c3-1f28cdd0d781 | 131764 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 11911 | 670 | 17021 |
(21 rows)
datid | datname | procpid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | waiting | current_query |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11919 | postgres | 25581 | 16384 | jb | psql | -1 | 2013-11-02 00:36:32.898456+01 | 2013-11-02 00:55:22.892988+01 | 2013-11-02 00:55:22.892988+01 | f | SELECT * FROM pg_stat_activity; | ||
11919 | postgres | 26050 | 16384 | jb | psql | -1 | 2013-11-02 00:43:17.159333+01 | 2013-11-02 00:43:18.00825+01 | f | <IDLE> | |||
11919 | postgres | 26068 | 16384 | jb | -1 | 2013-11-02 00:43:34.305488+01 | 2013-11-02 00:43:35.423728+01 | f | <IDLE> |
(3 rows)