Zmiany pomiędzy wersją 10 and wersją 11 dla AdminGuide/DatabaseMonitoring
- Data i czas:
- 05/26/15 21:55:11 (9 years temu)
Legend:
- Bez zmian
- Dodane
- Usunięte
- Zmienione
-
AdminGuide/DatabaseMonitoring
v10 v11 34 34 35 35 == Sprawdzenie aktualnie wykonywanych zapytań == 36 37 {{{38 postgres@edokumenty:~$psql39 40 SELECT (now() - pg_stat_activity.xact_start) AS age,41 pg_stat_activity.datname, pg_stat_activity.procpid,42 pg_stat_activity.usename, pg_stat_activity.waiting,43 pg_stat_activity.query_start, pg_stat_activity.client_addr,44 pg_stat_activity.client_port, pg_stat_activity.current_query45 FROM pg_stat_activity46 WHERE (pg_stat_activity.xact_start IS NOT NULL)47 ORDER BY pg_stat_activity.xact_start;48 49 }}}50 36 51 37 Od wersji postgresql 9.2:
