Zmiany pomiędzy wersją 6 and wersją 7 dla AdminGuide/DatabaseMonitoring
- Data i czas:
- 04/22/14 20:20:08 (10 years temu)
Legend:
- Bez zmian
- Dodane
- Usunięte
- Zmienione
-
AdminGuide/DatabaseMonitoring
v6 v7 48 48 49 49 }}} 50 51 Od wersji postgresql 9.2: 52 {{{ 53 postgres@edokumenty:~$psql 54 55 SELECT (now() - pg_stat_activity.xact_start) AS age, 56 pg_stat_activity.datname, pg_stat_activity.procpid, 57 pg_stat_activity.usename, pg_stat_activity.waiting, 58 pg_stat_activity.query_start, pg_stat_activity.client_addr, 59 pg_stat_activity.client_port, pg_stat_activity.current_query 60 FROM pg_stat_activity 61 WHERE (pg_stat_activity.xact_start IS NOT NULL) 62 ORDER BY pg_stat_activity.xact_start; 63 64 }}}
